CribMaster 9NrdSGJa0t1gW6XM6UklP9FuaYhFWbvF6UnogE184nuNWvfJRkoxmXFWzdxjAOu71HD7SMYY88hqT4SAS0DrXtFU2SvGW6vNakdxTHqE5+vsVsHjzkxCgXJrzdxjbGWP3WqBiWJLAcVrTb34YQSk CribMaster TRANS TRANSNUMBER,System.Int32 STATION,System.String BIN,System.String ITEM,System.String OLDITEM,System.String EMPLOYEE,System.String USER1,System.String USER3,System.String USER2,System.String USER4,System.String COST,System.Decimal QUANTITY,System.Int32 TRANSDATE,System.DateTime TRANSTIME,System.String TYPE,System.String TYPEDESCRIPTION,System.String BINQTY,System.Int32 USER5,System.String SERIALID,System.String USER6,System.String RELATEDKEY,System.String STATUS,System.Int16 CRIBBIN,System.String BATCHID,System.Int32 ISSUEDTO,System.String CONSIGNMENT,System.Int32 OTHERCRIBBIN,System.String WONO,System.Int32 TRANSUSAGE,System.Int32 REPAIRCALCYCLE,System.Int16 CRIB,System.Int16 LOTNO,System.Int32 USAGETYPE,System.Byte USAGECRIBBIN,System.String USAGEITEMNUMBER,System.String RESERVATIONNO,System.Int32 SUBTYPE,System.Int32 OTHERSITENO,System.Int32 CYCLECOUNTCLASSNO,System.Int32 EXPECTEDACCURACY,System.Int32 TRANSRFIDNO,System.Int32 LOCALTRANSDATE,System.DateTime UDFSITEID,System.String 30 TRANS CribMaster select * from TRANS TRANSDETAIL TRANSDETAILNO,System.Int32 TRANSNO,System.Int32 TRANSCOMMENT,System.String TRANSDETAILDATE,System.DateTime TRANSDETAILEMPLOYEEID,System.String TRANSREASONCODE,System.String CONFIRMATIONNUMBER,System.String 30 TRANSDETAIL CribMaster select * from TRANSDETAIL CRIB CRIB,System.Int16 NAME,System.String CRIBTYPE,System.Int16 COMMENTS,System.String USER1,System.Int32 USER2,System.Int32 LABELPRINTERNAME,System.String CRIBAREA,System.String SITEID,System.String RETURNTOCRIB,System.Int16 ALERTEMAILADDRESS,System.String CRIBORDERTYPE,System.Byte CRIBSTOCKFROMCRIB,System.Int16 CRIBTELEPHONE,System.String TRANSFERINPACKAGESIZE,System.Boolean REQUIREWOFORISSUE,System.Boolean ENABLESITETRANSFERS,System.Boolean CRIBCHECKOUTTIMELIMIT,System.Int16 ORDERREVIEWOPTION,System.Byte TRACKSPACEOPTION,System.Byte PRIMARYCRIB,System.Int32 ITEMCENTRICOPTION,System.Byte BINTYPEOPTION,System.Byte AUTODELETEOPTION,System.Byte CRIBVENDORNUMBER,System.String CRIBVENDOROPTION,System.Byte CRIB_ADDDATE,System.DateTime CRIB_ADDUID,System.String CRIB_UPDATEDATE,System.DateTime CRIB_UPDATEUID,System.String CRIBFODOPTION,System.Byte NEXTSEQBIN,System.String DEVICECOMPUTERNAME,System.String UDFSHIPTOID,System.String CRIBUSEROVERRIDENO,System.Int32 CRIBSETTINGSTEMPLATENO,System.Int32 DEVICECRIB,System.Int32 CRIBBILLINGOPTION,System.Byte ATRALERTEMAILADDRESS,System.String 30 CRIB CribMaster select * from CRIB SITEPROFILE SITEID,System.String SITEDESCRIPTION,System.String SITEBUYERID,System.String SITEPOCOMMENT,System.String SITESHIPPING,System.String SITEBILLTO1,System.String SITEBILLTO2,System.String SITEBILLTO3,System.String SITEBILLTO4,System.String SITESHIPTO1,System.String SITESHIPTO2,System.String SITESHIPTO3,System.String SITESHIPTO4,System.String SITEPHONE,System.String SITEFAXPHONE,System.String SITECOMPANYNAME,System.String SITENAME,System.String RECOVERYVENDORNUMBER,System.String NEXTRECOVERYBILLNUMBER,System.String SITEOVRAUTOPURCHASEDAYS,System.Int32 SITEPOAPPROVALOPTION,System.Byte SITEPOAPPROVERID,System.String SITEPOEMAILADDRESS,System.String SITEWEBLICENSECOUNT,System.Int32 SITEPREFIX,System.String SITEGROUPID,System.String SITEINACTIVE,System.Boolean SITEDEFAULTLOCALE,System.String SITETIMEZONEID,System.String SITECRIBACCESSOPTION,System.Byte UDFCONSIGNEDCONTRACT,System.String UDFNONCONSIGNEDCONTRACT,System.String UDFLOCATIONID,System.String UDFCUSTOMERID,System.String PARENTSITEID,System.String SITEOVRBROADCASTMSG,System.String SITEUSEROVERRIDENO,System.Int32 SITESETTINGSTEMPLATENO,System.Int32 SITESALESTAXPERCENT,System.Decimal BARCODEMAPPINGOPTION,System.Byte DEFAULTTHEME,System.String UDFTPNAME,System.String UDFSHIPTOID,System.String UDFSITEID,System.String 30 SITEPROFILE CribMaster select * from SITEPROFILE INVENTRY ITEMNUMBER,System.String DESCRIPTION1,System.String DESCRIPTION2,System.String PRICE,System.Decimal MONTHTODATE,System.Decimal YEARTODATE,System.Decimal WEEKTODATE,System.Decimal MONTHLYREDFLAG,System.Decimal YEARLYREDFLAG,System.Decimal WEEKLYREDFLAG,System.Decimal LASTYEAR,System.Decimal SHORTDESC,System.String ACCESSCODE,System.String VENDORNUMBER,System.String ITEMTYPE,System.Int16 ITEMCLASS,System.String REWORKEDITEMNUMBER,System.String UPCCODE,System.String COMMENTS,System.String SERIALIZED,System.Int32 PRICETYPE,System.Int16 MANUFACTURER,System.String MFRNUMBER,System.String DEFAULTQTY,System.Int32 USEINPLANTQUANTITY,System.Int32 INCLUDEREWORKED,System.Int32 SPECIAL,System.String RESTRICTED,System.Int16 RECEIVENEWASREWORK,System.Int32 ALLOWMAINTENANCE,System.Byte TRACKUSAGE,System.Boolean ITEMSTATUSCODE,System.String CHECKOUTTIMELIMIT,System.Int16 ALLOWOVRTIMELIMIT,System.Byte TRACKLOTNUMBER,System.Boolean CINO,System.Int32 CLASSNO,System.Int32 CIREVISION,System.Int32 CINUMBER,System.String LINKCINUMBER,System.Boolean LINKCIDESCRIPTION1,System.Boolean LINKCIDESCRIPTION2,System.Boolean NOINTERSITETRANSFERS,System.Boolean ITEMSTOCKFROMCRIB,System.Int16 USECHECKLIST,System.Boolean BUYERGROUPID,System.String INVENTRY_ADDDATE,System.DateTime INVENTRY_ADDUID,System.String INVENTRY_UPDATEDATE,System.DateTime INVENTRY_UPDATEUID,System.String ITEMFODCONTROL,System.Byte ALTVENDORNO,System.Int32 REQUIRESINSPECTION,System.Byte CERTIFIEDSYSTEM,System.Int16 CRITICALITEMOPTION,System.Byte LOCKED,System.Int16 INACTIVEITEM,System.Boolean CYCLECOUNTCLASSNO,System.Int32 ISSUEUNITOFMEASURE,System.String AUTOSCRAPOPTION,System.Byte UDFPROSTOCKSLOTSIZE,System.String UDFTOOLBOXCOILDEPTH,System.String UDFTOOLBOXCOILTYPE,System.String UDFWEIGHSTATIONITEMWEIGHT,System.String UDFPROLOCKCOUNT,System.String 30 INVENTRY CribMaster select * from INVENTRY STATION CRIBBIN,System.String CRIB,System.Int16 BIN,System.String ITEM,System.String BINQUANTITY,System.Int32 QUANTITY,System.Int32 ONORDER,System.Int32 COMMENTS,System.String STOPORDERING,System.Boolean ORDERNOWQUANTITY,System.Int32 FORCEORDER,System.Int32 ORDERPOINT,System.Int32 OVERRIDEORDERPOINT,System.Int32 MAXIMUM,System.Int32 ORDERQUANTITY,System.Int32 OVERRIDEORDERQUANTITY,System.Int32 AVGLEADTIME,System.Int32 OVERRIDEAVGLEADTIME,System.Int32 MAXLEADTIME,System.Int32 OVERRIDEMAXLEADTIME,System.Int32 MONTHLYUSAGE,System.Int32 OVERRIDEMONTHLYUSAGE,System.Int32 SAFETYSTOCK,System.Int32 OVERRIDESAFETYSTOCK,System.Int32 USAGETHISMONTH,System.Int32 BINCAPACITY,System.Int32 MINORDER,System.Int32 STOCKFROMCRIBBIN,System.String DATELASTCOUNT,System.DateTime DATELASTISSUE,System.DateTime DATELASTRECEIPT,System.DateTime COUNTTYPE,System.Int32 PENDINGREWORK,System.Int32 OVERRIDEDEFAULTQTY,System.Int32 CONSIGNMENT,System.Int32 OVERRIDEISSUEPRICE,System.Decimal PRICETYPE,System.Int16 TOTALVALUE,System.Decimal TOTALPRICE,System.Decimal STATIONAUTOPURCHASE,System.Boolean CRITICALPOINT,System.Int32 ISSURPLUS,System.Boolean EXCESSFLOOR,System.Int32 OVERRIDEEXCESSFLOOR,System.Int32 EXCESSQUANTITY,System.Int32 BINTYPE,System.Byte STATIONCHECKOUTTIMELIMIT,System.Int16 STATION_ADDDATE,System.DateTime STATION_ADDUID,System.String STATION_UPDATEDATE,System.DateTime STATION_UPDATEUID,System.String STORAGESPACE,System.Int16 CRIBSPACEID,System.Int32 PRIMARYCRIBBIN,System.String AUTODELETE,System.Boolean FIFOTRACKINGOPTION,System.Byte OVRALTVENDORNO,System.Int32 TRANSFERSIN,System.Int32 TRANSFERSOUT,System.Int32 RESERVATIONADDQTY,System.Int32 RESERVATIONMINQTY,System.Int32 STOPISSUE,System.Boolean OVRCYCLECOUNTCLASSNO,System.Int32 DATELASTRECALCULATED,System.DateTime STATIONLOTNO,System.Int32 UNITWEIGHT,System.Decimal CONSIGNEDQUANTITY,System.Int32 CONSIGNEDPRICE,System.Decimal BURNQUANTITY,System.Int32 CONSIGNMENTOPTION,System.Byte UNITWEIGHTQUANTITY,System.Int16 SCALECAPACITY,System.Int16 STATIONBILLINGOPTION,System.Byte AVGBINQUANTITY,System.Decimal 30 STATION CribMaster select * from STATION EMPLOYEE ID,System.String LASTNAME,System.String FIRSTNAME,System.String NAME,System.String EMPLOYEEPASSWORD,System.String CATEGORY,System.String USER1,System.String USER3,System.String USER4,System.String USER2,System.String ACCESSCODE,System.String RIGHTS,System.String BEGINTIME,System.Int16 ENDTIME,System.Int16 COSTLIMIT,System.Decimal COSTPERISSUE,System.Decimal MONTHTODATE,System.Decimal YEARTODATE,System.Decimal WEEKTODATE,System.Decimal MONTHLYREDFLAG,System.Decimal YEARLYREDFLAG,System.Decimal WEEKLYREDFLAG,System.Decimal LASTYEAR,System.Decimal SUPPLIERLOGIN,System.Int16 USER5,System.String USER6,System.String EMPLOYEELABORRATE,System.Decimal BADGENUMBER,System.String EMPLOYEEINACTIVE,System.Byte PRINTCODE,System.Int32 FAXNUMBER,System.String EMPLOYEEEMAILADDRESS,System.String SUPERVISOR,System.String EMPLOYEE_ADDDATE,System.DateTime EMPLOYEE_ADDUID,System.String EMPLOYEE_UPDATEDATE,System.DateTime EMPLOYEE_UPDATEUID,System.String EMPLOYEEFODCONTROL,System.Byte PASSWORDEXPIRATION,System.DateTime POAPPROVALLIMIT,System.Decimal LOGINDISABLED,System.Boolean LASTLOGINACTIVITYDATE,System.DateTime GROUPACCOUNT,System.Boolean LASTREPORTEMAILADDRESS,System.String WINDOWSUSERNAME,System.String EMPLOYEESITEID,System.String EMPLOYEELOCALID,System.String DEFAULTLOCALE,System.String UDFCREW,System.String VENDORNUMBER,System.String EMPLOYEEACCESSLEVEL,System.Byte 30 EMPLOYEE CribMaster select * from EMPLOYEE Test Data 0 Order,System.String Line,System.String Item,System.String Qty,System.String UOM,System.String Blank,System.String Blank1,System.String Site,System.String Site1,System.String Test Data C:\Users\jlabrecq\Desktop\Test Data.csv C:\Users\jlabrecq\Desktop\Test Data.csv Cribs CRIB Cribs Cribs CRIB Items ITEM Items Items ITEMNUMBER TransDetails TRANSNUMBER TransDetails TransDetails TRANSNO Employees EMPLOYEE Employees Employees ID IssuedToEmployees ISSUEDTO IssuedToEmployees IssuedToEmployees ID Bins CRIBBIN Bins Bins CRIBBIN Sites SITEID Sites Sites SITEID Internal,ReportName,ReportName,System.String,Test_x0020_Data_x0020_GroupLine,False,False Internal,ReportSectionID,ReportSectionID,System.Int32,_x0031_2,False,False CribMaster_x0020_Formulas,CMHeader,CMHeader,System.String,,False,False CribMaster_x0020_Formulas,CMFooter,CMFooter,System.String,,False,False CribMaster_x0020_Formulas,Address1,Address1,System.String,,False,False CribMaster_x0020_Formulas,Address2,Address2,System.String,,False,False CribMaster_x0020_Formulas,Address3,Address3,System.String,,False,False CribMaster_x0020_Formulas,Phone,Phone,System.String,,False,False CribMaster_x0020_Formulas,Fax,Fax,System.String,,False,False CribMaster_x0020_Formulas,DatabaseToday,DatabaseToday,System.String,,False,False CribMaster_x0020_Formulas,DatabaseTime,DatabaseTime,System.String,,False,False CribMaster_x0020_Formulas,DatabaseNow,DatabaseNow,System.String,,False,False CribMaster_x0020_Formulas,CountryCode,CountryCode,System.String,,False,False CribMaster_x0020_Formulas,ItemDescription,ItemDescription,System.String,,False,False CribMaster_x0020_Formulas,CompanyName,CompanyName,System.String,,False,False CribMaster_x0020_Formulas,PhoneNumber,PhoneNumber,System.String,,False,False CribMaster_x0020_Formulas,FaxNumber,FaxNumber,System.String,,False,False CribMaster_x0020_Formulas,Title,Title,System.String,,False,False CribMaster_x0020_Formulas,SalesTaxRate,SalesTaxRate,System.String,,False,False CribMaster_x0020_Formulas,BarCodeCode,BarCodeCode,System.String,,False,False CribMaster_x0020_Formulas,RangeLabel,RangeLabel,System.String,,False,False CribMaster_x0020_Formulas,GroupTitle,GroupTitle,System.String,,False,False CribMaster_x0020_Formulas,GroupTitle2,GroupTitle2,System.String,,False,False CribMaster_x0020_Formulas,GroupTitle3,GroupTitle3,System.String,,False,False CribMaster_x0020_Formulas,GroupTitle4,GroupTitle4,System.String,,False,False EngineV2 None;Black;2;Solid;False;4;Black Transparent Transparent 0,0.2,7.72,0.4 Transparent 0,0.1,7.7,0.3 Arial,14,Bold Center 0,0,0,0 ReportTitleLabel Test Data GroupLine Black Center PageHeaderBand Transparent 0,9.92,7.72,0.3 FooterBand Transparent 0,1,7.72,0.2 Bottom;[216:216:216];1;Solid;False;4;Black Transparent 0,0,0.6,0.2 Times New Roman,10 0,0,0,0 Text4 Order Black Bottom;[216:216:216];1;Solid;False;4;Black Transparent 0,0,1,0 Times New Roman,10 Center 0,0,0,0 Text2 Order Black Bottom;[216:216:216];1;Solid;False;4;Black Transparent 0.6,0,0.6,0.2 Times New Roman,10 0,0,0,0 Text6 Line Black Bottom;[216:216:216];1;Solid;False;4;Black Transparent 1.2,0,2.1,0.2 Times New Roman,10 0,0,0,0 Text8 Item Black Bottom;[216:216:216];1;Solid;False;4;Black Transparent 3.3,0,0.5,0.2 Times New Roman,10 0,0,0,0 Text10 Qty Black Bottom;[216:216:216];1;Solid;False;4;Black Transparent 3.8,0,0.6,0.2 Times New Roman,10 0,0,0,0 Text12 UOM Black Bottom;[216:216:216];1;Solid;False;4;Black Transparent 4.4,0,0.9,0.2 Times New Roman,10 0,0,0,0 Text14 Blank Black Bottom;[216:216:216];1;Solid;False;4;Black Transparent 5.2,0,0.9,0.2 Times New Roman,10 0,0,0,0 Text16 Blank1 Black Bottom;[216:216:216];1;Solid;False;4;Black Transparent 6.1,0,0.8,0.2 Times New Roman,10 0,0,0,0 Text18 Site Black Bottom;[216:216:216];1;Solid;False;4;Black Transparent 6.9,0,0.8,0.2 Times New Roman,10 0,0,0,0 Text20 Site1 Black HeaderBand Transparent 0,1.6,7.72,0 {Test_Data.Site} GroupHeaderBand2 Transparent 0,2,7.72,0 {Test_Data.Item} GroupHeaderBand3 Transparent 0,2.4,7.72,0.2 Bottom;[216:216:216];1;Solid;False;4;Black Transparent 0,0,0.6,0.2 Times New Roman,10 0,0,0,0 Text3 {Test_Data.Order} Black Bottom;[216:216:216];1;Solid;False;4;Black Transparent 0.6,0,0.6,0.2 Times New Roman,10 0,0,0,0 Text5 {Test_Data.Line} Black Bottom;[216:216:216];1;Solid;False;4;Black Transparent 1.2,0,2.1,0.2 Times New Roman,10 0,0,0,0 Text7 {Test_Data.Item} Black Bottom;[216:216:216];1;Solid;False;4;Black Transparent 3.3,0,0.5,0.2 Times New Roman,10 Right 0,0,0,0 Text9 {Test_Data.Qty} Black Bottom;[216:216:216];1;Solid;False;4;Black Transparent 3.8,0,0.6,0.2 Times New Roman,10 0,0,0,0 Text11 {Test_Data.UOM} Black Bottom;[216:216:216];1;Solid;False;4;Black Transparent 4.3,0,0.9,0.2 Times New Roman,10 28de1f4f57954f12a3fb2a8d2e88a592 0,0,0,0 Text13 Black Expression Bottom;[216:216:216];1;Solid;False;4;Black Transparent 5.2,0,0.9,0.2 Times New Roman,10 0,0,0,0 Text15 Black Expression Bottom;[216:216:216];1;Solid;False;4;Black Transparent 6.1,0,0.8,0.2 Times New Roman,10 0,0,0,0 Text17 {Test_Data.Site} Black Bottom;[216:216:216];1;Solid;False;4;Black Transparent 6.9,0,0.8,0.2 Times New Roman,10 0,0,0,0 Text19 {Test_Data.Site1} Black {Test_Data.Order} GroupHeaderBand1 Transparent 0,3,7.72,0 Bottom;[216:216:216];1;Solid;False;4;Black Transparent 0,-0.2,1,0 Times New Roman,10 0,0,0,0 Text1 {Test_Data.Order} Black DataColumn TRANS DataBand2 7ec0da3ba9a24dcdb2292d11d1e628b2 0.39,0.39,0.39,0.39 Page1 11 8.5 Letter Arial,100 [50:0:0:0] System.Dll System.Drawing.Dll System.Windows.Forms.Dll System.Data.Dll System.Xml.Dll Stimulsoft.Controls.Dll Stimulsoft.Base.Dll Stimulsoft.Report.Dll Report 2/12/2019 8:22:29 AM 2/12/2019 8:18:37 AM 148a64601b314617a2f76edbdd5e3ca4 Report Inches 2014.1.1900 CSharp