SO_PickingSheetWrk SO Picking Sheet Work Rel: 4.40 Bld: 398 8/28/2009 Bus Obj: SO_PickingSheetPrinting_rpt SQL Def: Y SysDB: N "MAS_"+%C$+"/SO"+%C$+"/SO_PickingSheetWrk"+%S$+".M4T"
KPRIMARY: SortField
Fld Column Name M/L TUR Description/Notes Class
1 SortField . . . . . . . . . . 127 SNN Sort Field. . . . . . . . . . . 2 GroupField. . . . . . . . . . 15 SNN Group Field . . . . . . . . . . 3 WarehouseCode . . . . . . . . 3 SNN Warehouse Code. . . . . . . . . 4 WarehouseDesc . . . . . . . . 30 SNN Warehouse Description . . . . . 5 SalesOrderNo. . . . . . . . . 7 SNN Sales Order Number. . . . . . . 6 OrderDate . . . . . . . . . . 8 SNN Order Date. . . . . . . . . . .DATE 7 OrderType . . . . . . . . . . 1 SYN Order Type. . . . . . . . . . . 8 ShipExpireDate. . . . . . . . 8 SNN Ship Expire Date. . . . . . . .DATE 9 ARDivisionNo. . . . . . . . . 2 SNN AR Division Number. . . . . . . 10 CustomerNo. . . . . . . . . . 20 SNN Customer Number . . . . . . . . 11 TelephoneNo . . . . . . . . . 17 SNN Telephone Number. . . . . . . . 12 FaxNo . . . . . . . . . . . . 17 SNN Fax Number. . . . . . . . . . . 13 EmailAddress. . . . . . . . . 250 SNN Email Address . . . . . . . . . 14 CustomerPONo. . . . . . . . . 15 SNN Customer PO Number. . . . . . . 15 ConfirmTo . . . . . . . . . . 30 SNN Confirm To. . . . . . . . . . . 16 Comment . . . . . . . . . . . 30 SNN Comment . . . . . . . . . . . . 17 ShipVia . . . . . . . . . . . 15 SNN Ship Via. . . . . . . . . . . . 18 ShipZone. . . . . . . . . . . 5 SNN Ship Zone . . . . . . . . . . . 19 FOB . . . . . . . . . . . . . 15 SNN F. O. B.. . . . . . . . . . . . 20 TermsCode . . . . . . . . . . 2 SNN Terms Code. . . . . . . . . . . 21 TermsCodeDesc . . . . . . . . 30 SNN Terms Code Description. . . . . 22 AuthorizationDate . . . . . . 8 SNN Authorization Date. . . . . . .DATE 23 SalespersonDivisionNo . . . . 2 SNN Salesperson Division Number . . 24 SalespersonNo . . . . . . . . 4 SNN Salesperson Code. . . . . . . . 25 SalespersonName . . . . . . . 30 SNN Salesperson Name. . . . . . . . 26 BillToName. . . . . . . . . . 30 SNN Bill To Name. . . . . . . . . . 27 BillToAddress1. . . . . . . . 30 SNN Bill To Address 1 . . . . . . . 28 BillToAddress2. . . . . . . . 30 SNN Bill To Address 2 . . . . . . . 29 BillToAddress3. . . . . . . . 30 SNN Bill To Address 3 . . . . . . . 30 BillToCity. . . . . . . . . . 20 SNN Bill To City. . . . . . . . . . 31 BillToState . . . . . . . . . 2 SNN Bill To State . . . . . . . . . 32 BillToZipCode . . . . . . . . 10 SNN Bill To Zip Code. . . . . . . . 33 BillToCountryCode . . . . . . 3 SNN Bill To Country Code. . . . . . 34 BillToCountryName . . . . . . 30 SNN Bill To Country Name. . . . . . 35 ShipToName. . . . . . . . . . 30 SNN Ship To Name. . . . . . . . . . 36 ShipToAddress1. . . . . . . . 30 SNN Ship To Address 1 . . . . . . . 37 ShipToAddress2. . . . . . . . 30 SNN Ship To Address 2 . . . . . . . 38 ShipToAddress3. . . . . . . . 30 SNN Ship To Address 3 . . . . . . . 39 ShipToCity. . . . . . . . . . 20 SNN Ship To City. . . . . . . . . . 40 ShipToState . . . . . . . . . 2 SNN Ship To State . . . . . . . . . 41 ShipToZipCode . . . . . . . . 10 SNN Ship To Zip Code. . . . . . . . 42 ShipToCountryCode . . . . . . 3 SNN Ship To Country Code. . . . . . 43 ShipToCountryName . . . . . . 30 SNN Ship To Country Name. . . . . . 44 LineSeqNo . . . . . . . . . . 14 SNN Line Sequence Number. . . . . . 45 LotSerialSeqNo. . . . . . . . 14 SNN Lot Serial Sequence Number. . . 46 LineNo. . . . . . . . . . . . 14 SNN Line Number . . . . . . . . . . 47 ItemCode. . . . . . . . . . . 30 SNN Item Code . . . . . . . . . . . 48 AliasItemNo . . . . . . . . . 30 SNN Alias Item Number . . . . . . . 49 ItemType. . . . . . . . . . . 1 SNN Item Type . . . . . . . . . . . 50 ItemCodeDesc. . . . . . . . . 30 SNN Item Code Description . . . . . 51 ExtendedDescriptionKey. . . . 10 SNN Extended Description Key. . . . 52 ExtendedDescriptionText . . . 4096 SNN Extended Description. . . . . . 53 Category1 . . . . . . . . . . 15 SNN Category 1. . . . . . . . . . . 54 Category2 . . . . . . . . . . 15 SNN Category 2. . . . . . . . . . . 55 Category3 . . . . . . . . . . 15 SNN Category 3. . . . . . . . . . . 56 Category4 . . . . . . . . . . 15 SNN Category 4. . . . . . . . . . . 57 BinLocation . . . . . . . . . 10 SNN Bin Location. . . . . . . . . . 58 ProductLine . . . . . . . . . 4 SNN ProductLine . . . . . . . . . . 59 DropShip. . . . . . . . . . . 1 SNN Drop Ship . . . . . . . . . . . 60 UnitOfMeasure . . . . . . . . 4 SNN Unit of Measure . . . . . . . . 61 Valuation . . . . . . . . . . 1 SNN Valuation . . . . . . . . . . . 62 CostOfGoodsSoldAcctKey. . . . 9 SNN Cost of Goods Sold Account Key. 63 CostOfGoodsSoldAccount. . . . 41 SNN Fully Formatted Cost of Goods S 64 SalesAcctKey. . . . . . . . . 9 SNN Sales Account Key . . . . . . . 65 SalesAccount. . . . . . . . . 41 SNN Fully Formatted Sales Account . 66 PromiseDate . . . . . . . . . 8 SNN Promise Date. . . . . . . . . .DATE 67 TaxClass. . . . . . . . . . . 2 SNN Tax Class . . . . . . . . . . . 68 CommentText . . . . . . . . . 2048 SNN Comment Text. . . . . . . . . . 69 ExplodedKitItem . . . . . . . 1 SNN Exploded Kit Item . . . . . . . 70 StandardKitBill . . . . . . . 1 SNN Standard Kit Bill . . . . . . . 71 Revision. . . . . . . . . . . 3 SNN Bill Revision Code. . . . . . . 72 BillOption1 . . . . . . . . . 2 SNN Bill Option 1 . . . . . . . . . 73 Option1Desc . . . . . . . . . 30 SNN Option 1 Description. . . . . . 74 BillOption2 . . . . . . . . . 2 SNN Bill Option 2 . . . . . . . . . 75 Option2Desc . . . . . . . . . 30 SNN Option 2 Description. . . . . . 76 BillOption3 . . . . . . . . . 2 SNN Bill Option 3 . . . . . . . . . 77 Option3Desc . . . . . . . . . 30 SNN Option 3 Description. . . . . . 78 BillOption4 . . . . . . . . . 2 SNN Bill Option 4 . . . . . . . . . 79 Option4Desc . . . . . . . . . 30 SNN Option 4 Description. . . . . . 80 BillOption5 . . . . . . . . . 2 SNN Bill Option 5 . . . . . . . . . 81 Option5Desc . . . . . . . . . 30 SNN Option 5 Description. . . . . . 82 BillOption6 . . . . . . . . . 2 SNN Bill Option 6 . . . . . . . . . 83 Option6Desc . . . . . . . . . 30 SNN Option 6 Description. . . . . . 84 BillOption7 . . . . . . . . . 2 SNN Bill Option 7 . . . . . . . . . 85 Option7Desc . . . . . . . . . 30 SNN Option 7 Description. . . . . . 86 BillOption8 . . . . . . . . . 2 SNN Bill Option 8 . . . . . . . . . 87 Option8Desc . . . . . . . . . 30 SNN Option 8 Description. . . . . . 88 BillOption9 . . . . . . . . . 2 SNN Bill Option 9 . . . . . . . . . 89 Option9Desc . . . . . . . . . 30 SNN Option 9 Description. . . . . . 90 SkipPrintCompLine . . . . . . 1 SNN Skip Printing Component Line. . 91 RMANo . . . . . . . . . . . . 7 SNN RMA Number. . . . . . . . . . . 92 CustomerAction. . . . . . . . 1 SNN Customer Action . . . . . . . . 93 JobNo . . . . . . . . . . . . 7 SNN Job Number. . . . . . . . . . . 94 CostCode. . . . . . . . . . . 9 SNN Cost Code . . . . . . . . . . . 95 CostCodeFormatted . . . . . . 11 SNN Cost Code Formatted . . . . . . 96 CostType. . . . . . . . . . . 1 SNN Cost Type . . . . . . . . . . . 97 MessageLine1. . . . . . . . . 50 SNN Message Line 1. . . . . . . . . 98 MessageLine2. . . . . . . . . 50 SNN Message Line 2. . . . . . . . . 99 FaxSendToCompany. . . . . . . 30 SNN Fax Send To Company . . . . . . 100 FaxSendToName . . . . . . . . 30 SNN Fax Send To Name. . . . . . . . 101 BatchFax. . . . . . . . . . . 1 SYN BatchFax. . . . . . . . . . . .YESNO DfltVal:N Valid:Y,N 102 CRMUserID . . . . . . . . . . 11 SNN CRM User ID . . . . . . . . . . 103 CRMUserLastName . . . . . . . 30 SNN CRM User Last Name. . . . . . . 104 CRMUserFirstName. . . . . . . 30 SNN CRM User First Name . . . . . . 105 CRMCompanyID. . . . . . . . . 11 SNN CRM Company ID. . . . . . . . . 106 CRMCompanyName. . . . . . . . 120 SNN CRM Company Name. . . . . . . . 107 CRMProspectID . . . . . . . . 11 SNN CRM Prospect ID . . . . . . . . 108 CRMPersonID . . . . . . . . . 11 SNN CRM Person ID . . . . . . . . . 109 CRMPersonFirstName. . . . . . 60 SNN CRM Person First Name . . . . . 110 CRMPersonLastName . . . . . . 80 SNN CRM Person Last Name. . . . . . 111 CRMOpportunityID. . . . . . . 11 SNN CRM Opportunity ID. . . . . . . 112 CRMOpportunityDesc. . . . . . 80 SNN CRM Opportunity Desc. . . . . . 113 QuantityOrdered . . . . . . . 16.6 NNN Quantity Ordered. . . . . . . . 114 QuantityShipped . . . . . . . 16.6 NNN Quantity Shipped. . . . . . . . 115 QuantityBackOrdered . . . . . 16.6 NNN Quantity Back Ordered . . . . . 116 MasterOriginalQty . . . . . . 16.6 NNN Master Original Quantity. . . . 117 MasterQtyBalance. . . . . . . 16.6 NNN Master Quantity Balance . . . . 118 MasterQtyOrderedToDate. . . . 16.6 NNN Master Quantity Ordered To Date 119 RepeatingQtyShippedToDate . . 16.6 NNN Repeating Quantity Shipped To D 120 ItemWeight. . . . . . . . . . 16.6 NNN Item Weight . . . . . . . . . . 121 UnitPrice . . . . . . . . . . 16.6 NNN Unit Price. . . . . . . . . . . 122 ExtensionAmt. . . . . . . . . 12.2 NNN Extension Amount. . . . . . . .