SO_AdditionalPackingListWrk SO Additional Packing List Work Rel: 4.40 Bld: 398 8/28/2009 Bus Obj: SO_AddlPackingListPrinting_rpt SQL Def: Y SysDB: N "MAS_"+%C$+"/SO"+%C$+"/SO_AdditionalPackingListWrk"+%S$+".M4T"
KPRIMARY: SortField
Fld Column Name M/L TUR Description/Notes Class
1 SortField . . . . . . . . . . 127 SNN Sort Field. . . . . . . . . . . 2 GroupField. . . . . . . . . . 17 SNN Group Field . . . . . . . . . . 3 InvoiceNo . . . . . . . . . . 7 SNN InvoiceNo . . . . . . . . . . . 4 HeaderSeqNo . . . . . . . . . 6 SNN Header Sequence Number. . . . . 5 InvoiceType . . . . . . . . . 2 SNN Invoice Type. . . . . . . . . . 6 InvoiceDate . . . . . . . . . 8 SNN Invoice Date. . . . . . . . . .DATE 7 PackageNo . . . . . . . . . . 4 SNN Package Number. . . . . . . . . 8 SalesOrderNo. . . . . . . . . 7 SNN Sales Order Number. . . . . . . 9 OrderDate . . . . . . . . . . 8 SNN Order Date. . . . . . . . . . .DATE 10 ARDivisionNo. . . . . . . . . 2 SNN AR Division Number. . . . . . . 11 CustomerNo. . . . . . . . . . 20 SNN Customer Number . . . . . . . . 12 TelephoneNo . . . . . . . . . 17 SNN Telephone Number. . . . . . . . 13 FaxNo . . . . . . . . . . . . 17 SNN Fax Number. . . . . . . . . . . 14 EmailAddress. . . . . . . . . 250 SNN Email Address . . . . . . . . . 15 CustomerPONo. . . . . . . . . 15 SNN Customer PO Number. . . . . . . 16 ConfirmTo . . . . . . . . . . 30 SNN Confirm To. . . . . . . . . . . 17 Comment . . . . . . . . . . . 30 SNN Comment . . . . . . . . . . . . 18 ShipVia . . . . . . . . . . . 15 SNN Ship VIA. . . . . . . . . . . . 19 ShipZone. . . . . . . . . . . 5 SNN Ship Zone . . . . . . . . . . . 20 ShipDate. . . . . . . . . . . 8 SNN Ship Expire Date. . . . . . . .DATE 21 FOB . . . . . . . . . . . . . 15 SNN F. O. B.. . . . . . . . . . . . 22 TermsCode . . . . . . . . . . 2 SNN Terms Code. . . . . . . . . . . 23 TermsCodeDesc . . . . . . . . 30 SNN Terms Code Description. . . . . 24 PaymentType . . . . . . . . . 5 SNN Payment Type. . . . . . . . . . 25 OtherPaymentTypeRefNo . . . . 24 SNN Other Payment Type Reference Nu 26 CheckNoForDeposit . . . . . . 6 SNN Check Number for Deposit. . . . 27 SalespersonDivisionNo . . . . 2 SNN Salesperson Division Number . . 28 SalespersonNo . . . . . . . . 4 SNN Salesperson Code. . . . . . . . 29 SalespersonName . . . . . . . 30 SNN Salesperson Name. . . . . . . . 30 BillToName. . . . . . . . . . 30 SNN Bill To Name. . . . . . . . . . 31 BillToAddress1. . . . . . . . 30 SNN Bill To Address 1 . . . . . . . 32 BillToAddress2. . . . . . . . 30 SNN Bill To Address 2 . . . . . . . 33 BillToAddress3. . . . . . . . 30 SNN Bill To Address 3 . . . . . . . 34 BillToCity. . . . . . . . . . 20 SNN Bill To City. . . . . . . . . . 35 BillToState . . . . . . . . . 2 SNN Bill To State . . . . . . . . . 36 BillToZipCode . . . . . . . . 10 SNN Bill To ZIP Code. . . . . . . . 37 BillToCountryCode . . . . . . 3 SNN Bill To Country Code. . . . . . 38 BillToCountryName . . . . . . 30 SNN Bill To Country Name. . . . . . 39 ShipToCode. . . . . . . . . . 4 SNN Ship To Code. . . . . . . . . . 40 ShipToName. . . . . . . . . . 30 SNN Ship To Name. . . . . . . . . . 41 ShipToAddress1. . . . . . . . 30 SNN Ship To Address 1 . . . . . . . 42 ShipToAddress2. . . . . . . . 30 SNN Ship To Address 2 . . . . . . . 43 ShipToAddress3. . . . . . . . 30 SNN Ship To Address 3 . . . . . . . 44 ShipToCity. . . . . . . . . . 20 SNN Ship To City. . . . . . . . . . 45 ShipToState . . . . . . . . . 2 SNN Ship To State . . . . . . . . . 46 ShipToZipCode . . . . . . . . 10 SNN Ship To ZIP Code. . . . . . . . 47 ShipToCountryCode . . . . . . 3 SNN Ship To Country Code. . . . . . 48 ShipToCountryName . . . . . . 30 SNN Ship To Country Name. . . . . . 49 TaxSchedule . . . . . . . . . 9 SNN Tax Schedule. . . . . . . . . . 50 WarehouseCode . . . . . . . . 3 SNN Warehouse Code. . . . . . . . . 51 WarehouseDesc . . . . . . . . 30 SNN Warehouse Description . . . . . 52 WarehouseName . . . . . . . . 30 SNN Warehouse Name. . . . . . . . . 53 WarehouseAddress1 . . . . . . 30 SNN Warehouse Address 1 . . . . . . 54 WarehouseAddress2 . . . . . . 30 SNN Warehouse Address 2 . . . . . . 55 WarehouseAddress3 . . . . . . 30 SNN Warehouse Address 3 . . . . . . 56 WarehouseCity . . . . . . . . 20 SNN Warehouse City. . . . . . . . . 57 WarehouseState. . . . . . . . 2 SNN Warehouse State . . . . . . . . 58 WarehouseZipCode. . . . . . . 10 SNN Warehouse Zip Code. . . . . . . 59 WarehouseCountryCode. . . . . 3 SNN Warehouse Country Code. . . . . 60 EBMSubmissionType . . . . . . 1 SNN EBM Submission Type . . . . . . 61 EBMUserIDSubmittingThisOrder. 15 SNN EBM User ID Submitting This Ord 62 TrackingID. . . . . . . . . . 132 SNN Tracking ID . . . . . . . . . . 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 . . . . . . . . . . . 67 ItemCodeDesc. . . . . . . . . 30 SNN Item Code Description . . . . . 68 Category1 . . . . . . . . . . 15 SNN Category 1. . . . . . . . . . . 69 Category2 . . . . . . . . . . 15 SNN Category 2. . . . . . . . . . . 70 Category3 . . . . . . . . . . 15 SNN Category 3. . . . . . . . . . . 71 Category4 . . . . . . . . . . 15 SNN Category 4. . . . . . . . . . . 72 MessageLine1. . . . . . . . . 50 SNN Message Line 1. . . . . . . . . 73 MessageLine2. . . . . . . . . 50 SNN Message Line 2. . . . . . . . . 74 CRMUserID . . . . . . . . . . 11 SNN CRM User ID . . . . . . . . . . 75 CRMUserName . . . . . . . . . 40 SNN CRM User Name . . . . . . . . . 76 CRMCompanyID. . . . . . . . . 11 SNN CRM Company ID. . . . . . . . . 77 CRMCompanyName. . . . . . . . 40 SNN CRM Company Name. . . . . . . . 78 CRMPersonID . . . . . . . . . 11 SNN CRM Person ID . . . . . . . . . 79 CRMPersonName . . . . . . . . 40 SNN CRM Person Name . . . . . . . . 80 CRMOpportunityID. . . . . . . 11 SNN CRM Opportunity ID. . . . . . . 81 CRMOpportunityName. . . . . . 40 SNN CRM Opportunity Name. . . . . . 82 Quantity. . . . . . . . . . . 16.6 NNN Quantity. . . . . . . . . . . . 83 Weight. . . . . . . . . . . . 12.2 NNN Weight. . . . . . . . . . . . .