SO_CODLabelsWrk SO COD Labels Work Rel: 4.40 Bld: 398 8/28/2009 Bus Obj: SO_CODLabels_rpt SQL Def: Y SysDB: N "MAS_"+%C$+"/SO"+%C$+"/SO_CODLabelsWrk"+%S$+".M4T"
KPRIMARY: SortField
Fld Column Name M/L TUR Description/Notes Class
1 SortField . . . . . . . . . . 127 SNN Sort Field. . . . . . . . . . . 2 InvoiceNo . . . . . . . . . . 7 SNN Invoice Number. . . . . . . . . 3 ShipDate. . . . . . . . . . . 8 SNN Ship Date . . . . . . . . . . .DATE 4 ShipToName. . . . . . . . . . 30 SNN ShipToName. . . . . . . . . . . 5 ShipToAddress1. . . . . . . . 30 SNN Ship To Address 1 . . . . . . . 6 ShipToAddress2. . . . . . . . 30 SNN Ship To Address 2 . . . . . . . 7 ShipToAddress3. . . . . . . . 30 SNN Ship To Address 3 . . . . . . . 8 ShipToCity. . . . . . . . . . 20 SNN Ship To City. . . . . . . . . . 9 ShipToState . . . . . . . . . 2 SNN Ship To State . . . . . . . . . 10 ShipToZipCode . . . . . . . . 10 SNN Ship To Zip Code. . . . . . . . 11 ShipToCountryCode . . . . . . 3 SNN Ship To Country Code. . . . . . 12 ShipToCountryName . . . . . . 30 SNN Ship To Country Name. . . . . . 13 ConfirmTo . . . . . . . . . . 30 SNN Confirm To. . . . . . . . . . . 14 ARDivisionNo. . . . . . . . . 2 SNN AR Division Number. . . . . . . 15 CustomerNo. . . . . . . . . . 20 SNN Customer Number . . . . . . . . 16 CustomerPONo. . . . . . . . . 15 SNN Customer PO Number. . . . . . . 17 AcceptCashOnly. . . . . . . . 1 SNN Accept Cash Only. . . . . . . . 18 LabelNumber . . . . . . . . . 2 SNN Label Number. . . . . . . . . . 19 CRMUserID . . . . . . . . . . 11 SNN CRM User ID . . . . . . . . . . 20 CRMUserLastName . . . . . . . 30 SNN CRM User Last Name. . . . . . . 21 CRMUserFirstName. . . . . . . 30 SNN CRM User First Name . . . . . . 22 CRMCompanyID. . . . . . . . . 11 SNN CRM Company ID. . . . . . . . . 23 CRMCompanyName. . . . . . . . 120 SNN CRM Company Name. . . . . . . . 24 CRMPersonID . . . . . . . . . 11 SNN CRM Person ID . . . . . . . . . 25 CRMPersonFirstName. . . . . . 60 SNN CRM Person First Name . . . . . 26 CRMPersonLastName . . . . . . 80 SNN CRM Person Last Name. . . . . . 27 CRMOpportunityID. . . . . . . 11 SNN CRM Opportunity ID. . . . . . . 28 CRMOpportunityDesc. . . . . . 80 SNN CRM Opportunity Description . . 29 CODAmt. . . . . . . . . . . . 14.2 NNN COD Amount. . . . . . . . . . .