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. . . . . . . . .