SO_ShippingLabelsWrk SO Shipping Labels Work Rel: 4.40 Bld: 398 8/28/2009 Bus Obj: SO_ShippingLabels_rpt,SO_ShippingEntryLabels_rpt SQL Def: Y SysDB: N "MAS_"+%C$+"/SO"+%C$+"/SO_ShippingLabelsWrk"+%S$+".M4T"
KPRIMARY: SortField
Fld Column Name M/L TUR Description/Notes Class
1 SortField . . . . . . . . . . 127 SNN Sort Field. . . . . . . . . . . 2 SalesOrderNo. . . . . . . . . 7 SNN Sales Order Number. . . . . . . 3 OrderDate . . . . . . . . . . 8 SNN Order Date. . . . . . . . . . .DATE 4 OrderType . . . . . . . . . . 1 SNN Order Type. . . . . . . . . . . 5 ShipToName. . . . . . . . . . 30 SNN ShipToName. . . . . . . . . . . 6 ShipToAddress1. . . . . . . . 30 SNN Ship To Address 1 . . . . . . . 7 ShipToAddress2. . . . . . . . 30 SNN Ship To Address 2 . . . . . . . 8 ShipToAddress3. . . . . . . . 30 SNN Ship To Address 3 . . . . . . . 9 ShipToCity. . . . . . . . . . 20 SNN Ship To City. . . . . . . . . . 10 ShipToState . . . . . . . . . 2 SNN Ship To State . . . . . . . . . 11 ShipToZipCode . . . . . . . . 10 SNN Ship To Zip Code. . . . . . . . 12 ShipToCountryCode . . . . . . 3 SNN Ship To Country Code. . . . . . 13 ShipToCountryName . . . . . . 30 SNN Ship To Country Name. . . . . . 14 ConfirmTo . . . . . . . . . . 30 SNN Confirm To. . . . . . . . . . . 15 ARDivisionNo. . . . . . . . . 2 SNN AR Division Number. . . . . . . 16 CustomerNo. . . . . . . . . . 20 SNN Customer Number . . . . . . . . 17 SalespersonDivisionNo . . . . 2 SNN Salesperson Division Number . . 18 SalespersonNo . . . . . . . . 4 SNN Salesperson Number. . . . . . . 19 SalespersonName . . . . . . . 30 SNN Salesperson Name. . . . . . . . 20 Comment . . . . . . . . . . . 30 SNN Comment . . . . . . . . . . . . 21 TaxSchedule . . . . . . . . . 9 SNN Tax Schedule. . . . . . . . . . 22 CustomerPONo. . . . . . . . . 15 SNN Customer PO Number. . . . . . . 23 ShipVia . . . . . . . . . . . 15 SNN Ship Via. . . . . . . . . . . . 24 ShipZone. . . . . . . . . . . 5 SNN Ship Zone . . . . . . . . . . . 25 FOB . . . . . . . . . . . . . 15 SNN FOB . . . . . . . . . . . . . . 26 TermsCode . . . . . . . . . . 2 SNN Terms Code. . . . . . . . . . . 27 TermsCodeDesc . . . . . . . . 30 SNN Terms Code Description. . . . . 28 InvoiceNo . . . . . . . . . . 7 SNN Invoice Number. . . . . . . . . 29 InvoiceDate . . . . . . . . . 8 SNN Invoice Date. . . . . . . . . .DATE 30 LabelNumber . . . . . . . . . 4 SNN Label Number. . . . . . . . . . 31 CRMUserID . . . . . . . . . . 11 SNN CRM User ID . . . . . . . . . . 32 CRMUserLastName . . . . . . . 30 SNN CRM User Last Name. . . . . . . 33 CRMUserFirstName. . . . . . . 30 SNN CRM User First Name . . . . . . 34 CRMCompanyID. . . . . . . . . 11 SNN CRM Company ID. . . . . . . . . 35 CRMCompanyName. . . . . . . . 120 SNN CRM Company Name. . . . . . . . 36 CRMProspectID . . . . . . . . 11 SNN CRM Prospect ID . . . . . . . . 37 CRMPersonID . . . . . . . . . 11 SNN CRM Person ID . . . . . . . . . 38 CRMPersonFirstName. . . . . . 60 SNN CRM Person First Name . . . . . 39 CRMPersonLastName . . . . . . 80 SNN CRM Person Last Name. . . . . . 40 CRMOpportunityID. . . . . . . 11 SNN CRM Opportunity ID. . . . . . . 41 CRMOpportunityDesc. . . . . . 80 SNN CRM Opportunity Description . . 42 Weight. . . . . . . . . . . . 12.2 NNN Weight. . . . . . . . . . . . .