SO_PackingListWrk SO Packing List Work Rel: 4.40 Bld: 398 8/28/2009
Bus Obj: SO_PackingListPrinting_rpt
SQL Def: Y SysDB: N "MAS_"+%C$+"/SO"+%C$+"/SO_PackingListWrk"+%S$+".M4T"
KPRIMARY: SortField
Fld Column Name M/L TUR Description/Notes Class
1 SortField . . . . . . . . . . 127 SNN Sort Field. . . . . . . . . . .
2 InvoiceNo . . . . . . . . . . 7 SNN InvoiceNo . . . . . . . . . . .
3 InvoiceType . . . . . . . . . 2 SNN Invoice Type. . . . . . . . . .
4 InvoiceDate . . . . . . . . . 8 SNN Invoice Date. . . . . . . . . .DATE
5 SalesOrderNo. . . . . . . . . 7 SNN Sales Order Number. . . . . . .
6 OrderDate . . . . . . . . . . 8 SNN Order Date. . . . . . . . . . .DATE
7 HeaderSeqNo . . . . . . . . . 6 SNN Header Sequence Number. . . . .
8 ARDivisionNo. . . . . . . . . 2 SNN AR Division Number. . . . . . .
9 CustomerNo. . . . . . . . . . 20 SNN Customer Number . . . . . . . .
10 TelephoneNo . . . . . . . . . 17 SNN Telephone Number. . . . . . . .
11 FaxNo . . . . . . . . . . . . 17 SNN Fax Number. . . . . . . . . . .
12 EmailAddress. . . . . . . . . 250 SNN Email Address . . . . . . . . .
13 CustomerPONo. . . . . . . . . 15 SNN Customer PO Number. . . . . . .
14 ConfirmTo . . . . . . . . . . 30 SNN Confirm To. . . . . . . . . . .
15 Comment . . . . . . . . . . . 30 SNN Comment . . . . . . . . . . . .
16 ShipVia . . . . . . . . . . . 15 SNN Ship VIA. . . . . . . . . . . .
17 ShipZone. . . . . . . . . . . 5 SNN Ship Zone . . . . . . . . . . .
18 ShipDate. . . . . . . . . . . 8 SNN Ship Expire Date. . . . . . . .DATE
19 FOB . . . . . . . . . . . . . 15 SNN F. O. B.. . . . . . . . . . . .
20 TrackingNumbers . . . . . . . 132 SNN Tracking Numbers. . . . . . . .
21 TermsCode . . . . . . . . . . 2 SNN Terms Code. . . . . . . . . . .
22 TermsCodeDesc . . . . . . . . 30 SNN Terms Code Description. . . . .
23 PaymentType . . . . . . . . . 5 SNN Payment Type. . . . . . . . . .
24 OtherPaymentTypeRefNo . . . . 24 SNN Other Payment Type Reference Nu
25 CheckNoForDeposit . . . . . . 6 SNN Check Number for Deposit. . . .
26 SalespersonDivisionNo . . . . 2 SNN Salesperson Division Number . .
27 SalespersonNo . . . . . . . . 4 SNN Salesperson Code. . . . . . . .
28 SalespersonName . . . . . . . 30 SNN Salesperson Name. . . . . . . .
29 BillToName. . . . . . . . . . 30 SNN Bill To Name. . . . . . . . . .
30 BillToAddress1. . . . . . . . 30 SNN Bill To Address 1 . . . . . . .
31 BillToAddress2. . . . . . . . 30 SNN Bill To Address 2 . . . . . . .
32 BillToAddress3. . . . . . . . 30 SNN Bill To Address 3 . . . . . . .
33 BillToCity. . . . . . . . . . 20 SNN Bill To City. . . . . . . . . .
34 BillToState . . . . . . . . . 2 SNN Bill To State . . . . . . . . .
35 BillToZipCode . . . . . . . . 10 SNN Bill To ZIP Code. . . . . . . .
36 BillToCountryCode . . . . . . 3 SNN Bill To Country Code. . . . . .
37 BillToCountryName . . . . . . 30 SNN Bill To Country Name. . . . . .
38 ShipToCode. . . . . . . . . . 4 SNN Ship To Code. . . . . . . . . .
39 ShipToName. . . . . . . . . . 30 SNN Ship To Name. . . . . . . . . .
40 ShipToAddress1. . . . . . . . 30 SNN Ship To Address 1 . . . . . . .
41 ShipToAddress2. . . . . . . . 30 SNN Ship To Address 2 . . . . . . .
42 ShipToAddress3. . . . . . . . 30 SNN Ship To Address 3 . . . . . . .
43 ShipToCity. . . . . . . . . . 20 SNN Ship To City. . . . . . . . . .
44 ShipToState . . . . . . . . . 2 SNN Ship To State . . . . . . . . .
45 ShipToZipCode . . . . . . . . 10 SNN Ship To ZIP Code. . . . . . . .
46 ShipToCountryCode . . . . . . 3 SNN Ship To Country Code. . . . . .
47 ShipToCountryName . . . . . . 30 SNN Ship To Country Name. . . . . .
48 TaxSchedule . . . . . . . . . 9 SNN Tax Schedule. . . . . . . . . .
49 WarehouseCode . . . . . . . . 3 SNN Warehouse Code. . . . . . . . .
50 WarehouseDesc . . . . . . . . 30 SNN Warehouse Description . . . . .
51 WarehouseName . . . . . . . . 30 SNN Warehouse Name. . . . . . . . .
52 WarehouseAddress1 . . . . . . 30 SNN Warehouse Address 1 . . . . . .
53 WarehouseAddress2 . . . . . . 30 SNN Warehouse Address 2 . . . . . .
54 WarehouseAddress3 . . . . . . 30 SNN Warehouse Address 3 . . . . . .
55 WarehouseCity . . . . . . . . 20 SNN Warehouse City. . . . . . . . .
56 WarehouseState. . . . . . . . 2 SNN Warehouse State . . . . . . . .
57 WarehouseZipCode. . . . . . . 10 SNN Warehouse Zip Code. . . . . . .
58 WarehouseCountryCode. . . . . 3 SNN Warehouse Country Code. . . . .
59 EBMSubmissionType . . . . . . 1 SNN EBM Submission Type . . . . . .
60 EBMUserIDSubmittingThisOrder. 15 SNN EBM User ID Submitting This Ord
61 ShipperID . . . . . . . . . . 3 SNN Shipper ID. . . . . . . . . . .
62 LineSeqNo . . . . . . . . . . 14 SNN Line Sequence Number. . . . . .
63 LineNumber. . . . . . . . . . 14 SNN Line Number . . . . . . . . . .
64 ItemCode. . . . . . . . . . . 30 SNN Item Code . . . . . . . . . . .
65 AliasItemNo . . . . . . . . . 30 SNN Alias Item Number . . . . . . .
66 ItemType. . . . . . . . . . . 1 SNN Item Type . . . . . . . . . . .
DfltVal:1
67 ItemCodeDesc. . . . . . . . . 30 SNN Item Code Description . . . . .
68 ExtendedDescriptionKey. . . . 10 SNN Extended Description Key. . . .
69 ExtendedDescriptionText . . . 4096 SNN Extended Description. . . . . .
70 LotSerialNo . . . . . . . . . 15 SNN Lot or Serial Number. . . . . .
71 TierType. . . . . . . . . . . 1 SNN Tier Type . . . . . . . . . . .
DfltVal:4
72 Category1 . . . . . . . . . . 15 SNN Category 1. . . . . . . . . . .
73 Category2 . . . . . . . . . . 15 SNN Category 2. . . . . . . . . . .
74 Category3 . . . . . . . . . . 15 SNN Category 3. . . . . . . . . . .
75 Category4 . . . . . . . . . . 15 SNN Category 4. . . . . . . . . . .
76 BinLocation . . . . . . . . . 10 SNN Bin Location. . . . . . . . . .
77 LineWarehouseCode . . . . . . 3 SNN Line Warehouse Code . . . . . .
78 ProductLine . . . . . . . . . 4 SNN ProductLine . . . . . . . . . .
79 UnitOfMeasure . . . . . . . . 4 SNN Unit of Measure . . . . . . . .
80 CostOfGoodsSoldAcctKey. . . . 9 SNN Cost of Goods Sold Account Key.
81 CostOfGoodsSoldAccount. . . . 41 SNN Fully Formatted Cost of Goods S
82 SalesAcctKey. . . . . . . . . 9 SNN Sales Account Key . . . . . . .
83 SalesAccount. . . . . . . . . 41 SNN Fully Formatted Sales Account .
84 CommentText . . . . . . . . . 2048 SNN Comment Text. . . . . . . . . .
85 Revision. . . . . . . . . . . 3 SNN Bill Revision Code. . . . . . .
86 BillOption1 . . . . . . . . . 2 SNN Bill Option 1 . . . . . . . . .
87 Option1Desc . . . . . . . . . 30 SNN Option 1 Description. . . . . .
88 BillOption2 . . . . . . . . . 2 SNN Bill Option 2 . . . . . . . . .
89 Option2Desc . . . . . . . . . 30 SNN Option 2 Description. . . . . .
90 BillOption3 . . . . . . . . . 2 SNN Bill Option 3 . . . . . . . . .
91 Option3Desc . . . . . . . . . 30 SNN Option 3 Description. . . . . .
92 BillOption4 . . . . . . . . . 2 SNN Bill Option 4 . . . . . . . . .
93 Option4Desc . . . . . . . . . 30 SNN Option 4 Description. . . . . .
94 BillOption5 . . . . . . . . . 2 SNN Bill Option 5 . . . . . . . . .
95 Option5Desc . . . . . . . . . 30 SNN Option 5 Description. . . . . .
96 BillOption6 . . . . . . . . . 2 SNN Bill Option 6 . . . . . . . . .
97 Option6Desc . . . . . . . . . 30 SNN Option 6 Description. . . . . .
98 BillOption7 . . . . . . . . . 2 SNN Bill Option 7 . . . . . . . . .
99 Option7Desc . . . . . . . . . 30 SNN Option 7 Description. . . . . .
100 BillOption8 . . . . . . . . . 2 SNN Bill Option 8 . . . . . . . . .
101 Option8Desc . . . . . . . . . 30 SNN Option 8 Description. . . . . .
102 BillOption9 . . . . . . . . . 2 SNN Bill Option 9 . . . . . . . . .
103 Option9Desc . . . . . . . . . 30 SNN Option 9 Description. . . . . .
104 SkipPrintCompLine . . . . . . 1 SNN Skip Printing Component Line. .
105 RMANo . . . . . . . . . . . . 7 SNN RMA Number. . . . . . . . . . .
106 CustomerAction. . . . . . . . 1 SNN Customer Action . . . . . . . .
107 WarrantyCode. . . . . . . . . 10 SNN Warranty Code . . . . . . . . .
108 WarrantyCodeDesc. . . . . . . 30 SNN Warranty Code Description . . .
109 ExpirationDate. . . . . . . . 8 SNN Expiration Date . . . . . . . .DATE
110 MessageLine1. . . . . . . . . 50 SNN Message Line 1. . . . . . . . .
111 MessageLine2. . . . . . . . . 50 SNN Message Line 2. . . . . . . . .
112 QuantityOrdered . . . . . . . 16.6 NNN Quantity Ordered. . . . . . . .
113 QuantityShipped . . . . . . . 16.6 NNN Quantity Shipped. . . . . . . .
114 QuantityBackordered . . . . . 16.6 NNN Quantity Backordered. . . . . .
115 LotSerialQuantityShipped. . . 16.6 NNN Lot or Serial Quantity Shipped.
116 ItemWeight. . . . . . . . . . 16.6 NNN Item Weight . . . . . . . . . .
117 Weight. . . . . . . . . . . . 12.2 NNN Weight. . . . . . . . . . . . .
118 NumberofPackages. . . . . . . 5.0 NNN Number of Packages. . . . . . .