SO_ShipToAddressListingWrk SO Ship To Address Listing Work Rel: 4.40 Bld: 398 8/28/2009 Bus Obj: SO_ShipToAddressListing_rpt SQL Def: Y SysDB: N "MAS_"+%C$+"/SO"+%C$+"/SO_ShipToAddressListingWrk"+%S$+".M4T"
KPRIMARY: SortField
Fld Column Name M/L TUR Description/Notes Class
1 SortField . . . . . . . . . . 127 SNN Sort Field. . . . . . . . . . . 2 ARDivisionNo. . . . . . . . . 2 SNN AR Division Number. . . . . . . 3 CustomerNo. . . . . . . . . . 20 SNN Customer Number . . . . . . . . 4 CustomerName. . . . . . . . . 30 SNN Customer Name . . . . . . . . . 5 ShipToCode. . . . . . . . . . 10 SNN Ship-To Code. . . . . . . . . . 6 ShipToName. . . . . . . . . . 30 SNN Ship To Name. . . . . . . . . . 7 ShipToAddress1. . . . . . . . 30 SNN Ship To Address Line 1. . . . . 8 ShipToAddress2. . . . . . . . 30 SNN Ship To Address Line 2. . . . . 9 ShipToAddress3. . . . . . . . 30 SNN Ship To Address Line 3. . . . . 10 ShipToCity. . . . . . . . . . 30 SNN Ship To City. . . . . . . . . . 11 ShipToState . . . . . . . . . 2 SNN Ship To State . . . . . . . . . 12 ShipToZipCode . . . . . . . . 10 SNN Ship To Zip Code. . . . . . . . 13 ShipToCountryCode . . . . . . 3 SNN Ship To Country Code. . . . . . 14 ShipToCountryName . . . . . . 30 SNN Ship To Country Name. . . . . . 15 TelephoneNo . . . . . . . . . 17 SNN Telephone Number. . . . . . . . 16 TelephoneExt. . . . . . . . . 5 SNN Ship To Telephone Extension . . 17 FaxNo . . . . . . . . . . . . 17 SNN Fax Number. . . . . . . . . . . 18 BatchFax. . . . . . . . . . . 1 SNN Batch Fax . . . . . . . . . . . 19 BatchEmail. . . . . . . . . . 1 SNN Batch E-mail. . . . . . . . . . 20 EmailAddress. . . . . . . . . 50 SNN Ship To E-mail Address. . . . . 21 ContactCode . . . . . . . . . 10 SNN Contact Code. . . . . . . . . . 22 ContactName . . . . . . . . . 30 SNN Contact Name. . . . . . . . . . 23 SalespersonDivisionNo . . . . 2 SNN Salesperson Division Number . . 24 SalespersonNo . . . . . . . . 4 SNN Salesperson Number. . . . . . . 25 SalespersonName . . . . . . . 30 SNN Salesperson Name. . . . . . . . 26 WarehouseCode . . . . . . . . 3 SNN Warehouse Code. . . . . . . . . 27 WarehouseDesc . . . . . . . . 30 SNN Warehouse Description . . . . . 28 TaxSchedule . . . . . . . . . 9 SNN Tax Schedule. . . . . . . . . . 29 TaxScheduleDesc . . . . . . . 30 SNN Tax Schedule Description. . . . 30 ResidentialAddress. . . . . . 1 SNN Residential Address . . . . . . 31 CRMAddressID. . . . . . . . . 11 SNN CRM Address ID. . . . . . . . . 32 CRMAddress1 . . . . . . . . . 80 SNN CRM Address 1 . . . . . . . . . 33 PrimaryShipTo . . . . . . . . 1 SNN Primary Ship To Code. . . . . .