SO_ShippingHistoryWrk SO Shipping History Work Rel: 4.40 Bld: 398 8/28/2009 Bus Obj: SO_ShippingHistoryReport_rpt SQL Def: Y SysDB: N "MAS_"+%C$+"/SO"+%C$+"/SO_ShippingHistoryWrk"+%S$+".M4T"
KPRIMARY: SortField
Fld Column Name M/L TUR Description/Notes Class
1 SortField . . . . . . . . . . 127 SNN Sort Field. . . . . . . . . . . 2 GroupField. . . . . . . . . . 30 SNN Group Field . . . . . . . . . . 3 GroupFieldDesc. . . . . . . . 30 SNN Group Field Description . . . .DESCRIPTION 4 InvoiceNo . . . . . . . . . . 7 SNN Invoice Number. . . . . . . . .INVOICE 5 HeaderSeqNo . . . . . . . . . 6 SNN Header Sequence Number. . . . . 6 DetailSeqNo . . . . . . . . . 6 SNN Detail Sequence Number. . . . . 7 InvoiceType . . . . . . . . . 2 SNN Invoice Type. . . . . . . . . . 8 SalesOrderNo. . . . . . . . . 7 SNN Sales Order Number. . . . . . .SALESORDERNO 9 ShipperID . . . . . . . . . . 3 SNN Shipper ID. . . . . . . . . . .SHIPPERID 10 ARDivisionNo. . . . . . . . . 2 SNN AR Division Number. . . . . . .ARDIVISION Mask:00 11 CustomerNo. . . . . . . . . . 20 SNN Customer Number . . . . . . . .CUSTOMERNO 12 CustomerName. . . . . . . . . 30 SNN Customer Name . . . . . . . . .NAME 13 BillToName. . . . . . . . . . 30 SNN Bill To Name. . . . . . . . . . 14 TermsCode . . . . . . . . . . 2 SNN Terms Code. . . . . . . . . . . 15 ShipVia . . . . . . . . . . . 15 SNN Ship Via. . . . . . . . . . . . 16 ShipDate. . . . . . . . . . . 8 SNN Ship Date . . . . . . . . . . .DATE 17 ShipToName. . . . . . . . . . 30 SNN Ship To Name. . . . . . . . . . 18 ShipToAddress1. . . . . . . . 30 SNN Ship To Address 1 . . . . . . . 19 ShipToAddress2. . . . . . . . 30 SNN Ship To Address 2 . . . . . . . 20 ShipToAddress3. . . . . . . . 30 SNN Ship To Address 3 . . . . . . . 21 ShipToCity. . . . . . . . . . 20 SNN Ship To City. . . . . . . . . . 22 ShipToState . . . . . . . . . 2 SNN Ship To State . . . . . . . . . 23 ShipToZipCode . . . . . . . . 10 SNN Ship To Zip Code. . . . . . . . 24 ShipToCountryCode . . . . . . 3 SNN Ship To Country Code. . . . . . 25 ShipToCountryName . . . . . . 30 SNN Ship To Country Name. . . . . .NAME 26 CustomerPONo. . . . . . . . . 15 SNN Customer PO Number. . . . . . .CUSTOMERPONO 27 ConfirmTo . . . . . . . . . . 30 SNN Confirm To. . . . . . . . . . . 28 Comment . . . . . . . . . . . 30 SNN Comment . . . . . . . . . . . . 29 WarehouseCode . . . . . . . . 3 SNN Warehouse Code. . . . . . . . .WAREHOUSE 30 FOB . . . . . . . . . . . . . 30 SNN FOB . . . . . . . . . . . . . . 31 ShipZone. . . . . . . . . . . 5 SNN Ship Zone . . . . . . . . . . .SHIPZONE 32 ItemCode. . . . . . . . . . . 30 SNN Item Code . . . . . . . . . . . 33 ItemCodeDesc. . . . . . . . . 30 SNN Item Code Description . . . . . 34 ItemType. . . . . . . . . . . 1 SNN Item Type . . . . . . . . . . . 35 LineWarehouseCode . . . . . . 3 SNN Line Warehouse Code . . . . . .WAREHOUSE 36 UnitOfMeasure . . . . . . . . 4 SNN Unit Of Measure . . . . . . . .UNITOFMEASURE 37 TierType. . . . . . . . . . . 1 SNN Tier Type . . . . . . . . . . . 38 LotSerialNo . . . . . . . . . 15 SNN Lot Serial Number . . . . . . . 39 PackageNo . . . . . . . . . . 4 SNN Package Number. . . . . . . . . 40 TrackingID. . . . . . . . . . 30 SNN Tracking ID . . . . . . . . . . 41 Discount. . . . . . . . . . . 1 SNN Discount. . . . . . . . . . . . 42 PriceLevel. . . . . . . . . . 1 SNN Price Level . . . . . . . . . . 43 Commissionable. . . . . . . . 1 SNN Commissionable. . . . . . . . . 44 TaxClass. . . . . . . . . . . 2 SNN Tax Class . . . . . . . . . . .TAXCLASS 45 DropShip. . . . . . . . . . . 1 SNN Drop Ship . . . . . . . . . . . 46 ProductLine . . . . . . . . . 4 SNN Product Line. . . . . . . . . . 47 ProductLineDesc . . . . . . . 25 SNN Product Line Description. . . .DESCRIPTION25 48 CommentText . . . . . . . . . 2048 SNN Comment Text. . . . . . . . . .COMMENT 49 CRMUserID . . . . . . . . . . 11 SNN CRMUserID . . . . . . . . . . . 50 CRMUserName . . . . . . . . . 40 SNN CRM User Name . . . . . . . . . 51 CRMCompanyID. . . . . . . . . 11 SNN CRM Company ID. . . . . . . . . 52 CRMCompanyName. . . . . . . . 40 SNN CRM Company Name. . . . . . . . 53 CRMPersonID . . . . . . . . . 11 SNN CRM Person ID . . . . . . . . . 54 CRMPersonName . . . . . . . . 40 SNN CRM Person Name . . . . . . . . 55 CRMOpportunityID. . . . . . . 11 SNN CRM Opportunity ID. . . . . . . 56 CRMOpportunityName. . . . . . 40 SNN CRMOpportunityName. . . . . . . 57 Weight. . . . . . . . . . . . 12.2 NNN Weight. . . . . . . . . . . . . 58 NumberOfPackages. . . . . . . 5.0 NNN Number of Packages. . . . . . . 59 LineDiscountPercent . . . . . 9.3 NNN Line Discount Percentage. . . . 60 QuantityOrdered . . . . . . . 16.6 NNN Quantity Ordered. . . . . . . . 61 QuantityShipped . . . . . . . 16.6 NNN Quantity Shipped. . . . . . . . 62 QuantityBackordered . . . . . 16.6 NNN Quantity Backordered. . . . . . 63 FreightAmt. . . . . . . . . . 12.2 NNN Freight Amount. . . . . . . . . 64 InvoiceAmt. . . . . . . . . . 12.2 NNN Invoice Amount. . . . . . . . .