SO_SalesOrderWrk SO Sales Order Work Rel: 4.40 Bld: 398 8/28/2009
Bus Obj: SO_SalesOrderPrinting_rpt
SQL Def: Y SysDB: N "MAS_"+%C$+"/SO"+%C$+"/SO_SalesOrderWrk"+%S$+".M4T"
KPRIMARY: SortField
Fld Column Name M/L TUR Description/Notes Class
1 SortField . . . . . . . . . . 127 SNN Sort Field. . . . . . . . . . .
2 GroupField. . . . . . . . . . 10 SNN Group Field . . . . . . . . . .
3 SalesOrderNo. . . . . . . . . 7 SNN Sales Order Number. . . . . . .
4 OrderDate . . . . . . . . . . 8 SNN Sales Order Date. . . . . . . .DATE
5 OrderType . . . . . . . . . . 1 SNN Sales Order Type. . . . . . . .
DfltVal:S
6 MasterRepeatingOrderNo. . . . 7 SNN Master Repeating Order Number .
7 ShipExpireDate. . . . . . . . 8 SNN Ship Expire Date. . . . . . . .DATE
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 CycleCode . . . . . . . . . . 2 SNN Cycle Code. . . . . . . . . . .
14 CustomerPONo. . . . . . . . . 15 SNN Customer PO Number. . . . . . .
15 ConfirmTo . . . . . . . . . . 30 SNN Confirm To. . . . . . . . . . .
16 Comment . . . . . . . . . . . 30 SNN Comment . . . . . . . . . . . .
17 WarehouseCode . . . . . . . . 3 SNN Warehouse Code. . . . . . . . .
18 ShipVia . . . . . . . . . . . 15 SNN Ship Via. . . . . . . . . . . .
19 ShipZone. . . . . . . . . . . 5 SNN Ship Zone . . . . . . . . . . .
20 FOB . . . . . . . . . . . . . 15 SNN F. O. B.. . . . . . . . . . . .
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 Last4UnencryptedCreditCardNos 4 SNN Last4 Unencrypted Credit Card N
27 AuthorizationDate . . . . . . 8 SNN Authorization Date. . . . . . .DATE
28 AuthorizationTime . . . . . . 6 SNN Authorization Time. . . . . . .
29 SalespersonDivisionNo . . . . 2 SNN Salesperson Division Number . .
30 SalespersonNo . . . . . . . . 4 SNN Salesperson Code. . . . . . . .
31 SalespersonName . . . . . . . 30 SNN Salesperson Name. . . . . . . .
32 BillToName. . . . . . . . . . 30 SNN Bill To Name. . . . . . . . . .
33 BillToAddress1. . . . . . . . 30 SNN Bill To Address 1 . . . . . . .
34 BillToAddress2. . . . . . . . 30 SNN Bill To Address 2 . . . . . . .
35 BillToAddress3. . . . . . . . 30 SNN Bill To Address 3 . . . . . . .
36 BillToCity. . . . . . . . . . 20 SNN Bill To City. . . . . . . . . .
37 BillToState . . . . . . . . . 2 SNN Bill To State . . . . . . . . .
38 BillToZIPCode . . . . . . . . 10 SNN Bill To ZIP Code. . . . . . . .
39 BillToCountryCode . . . . . . 3 SNN Bill To Country Code. . . . . .
40 BillToCountryName . . . . . . 30 SNN Bill To Country Name. . . . . .
41 ShipToCode. . . . . . . . . . 4 SNN Ship To Code. . . . . . . . . .
42 ShipToName. . . . . . . . . . 30 SNN Ship To Name. . . . . . . . . .
43 ShipToAddress1. . . . . . . . 30 SNN Ship To Address 1 . . . . . . .
44 ShipToAddress2. . . . . . . . 30 SNN Ship To Address 2 . . . . . . .
45 ShipToAddress3. . . . . . . . 30 SNN Ship To Address 3 . . . . . . .
46 ShipToCity. . . . . . . . . . 20 SNN Ship To City. . . . . . . . . .
47 ShipToState . . . . . . . . . 2 SNN Ship To State . . . . . . . . .
48 ShipToZIPCode . . . . . . . . 10 SNN Ship To ZIP Code. . . . . . . .
49 ShipToCountryCode . . . . . . 3 SNN Ship To Country Code. . . . . .
50 ShipToCountryName . . . . . . 30 SNN Ship To Country Name. . . . . .
51 TaxSchedule . . . . . . . . . 9 SNN Tax Schedule. . . . . . . . . .
52 InvalidTaxCalc. . . . . . . . 1 SNN Invalid Tax Calculation . . . .
53 TaxCode1. . . . . . . . . . . 15 SNN Tax Code 1. . . . . . . . . . .
54 TaxCode2. . . . . . . . . . . 15 SNN Tax Code 2. . . . . . . . . . .
55 TaxCode3. . . . . . . . . . . 15 SNN Tax Code 3. . . . . . . . . . .
56 TaxCode4. . . . . . . . . . . 15 SNN Tax Code 4. . . . . . . . . . .
57 TaxCode1Desc. . . . . . . . . 30 SNN Tax Code 1 Description. . . . .
58 TaxCode2Desc. . . . . . . . . 30 SNN Tax Code 2 Description. . . . .
59 TaxCode3Desc. . . . . . . . . 30 SNN Tax Code 3 Description. . . . .
60 TaxCode4Desc. . . . . . . . . 30 SNN Tax Code 4 Description. . . . .
61 ExemptionNo1. . . . . . . . . 20 SNN Exemption Number 1. . . . . . .
62 ExemptionNo2. . . . . . . . . 20 SNN Exemption Number 2. . . . . . .
63 ExemptionNo3. . . . . . . . . 20 SNN Exemption Number 3. . . . . . .
64 ExemptionNo4. . . . . . . . . 20 SNN Exemption Number 4. . . . . . .
65 RegistrationNo1 . . . . . . . 20 SNN Registration Number 1 . . . . .
66 RegistrationNo2 . . . . . . . 20 SNN Registration Number 2 . . . . .
67 RegistrationNo3 . . . . . . . 20 SNN Registration Number 3 . . . . .
68 RegistrationNo4 . . . . . . . 20 SNN Registration Number 4 . . . . .
69 EBMSubmissionType . . . . . . 1 SNN EBM Submission Type . . . . . .
70 EBMUserIDSubmittingThisOrder. 15 SNN EBM User ID Submitting This Ord
71 CancelReasonCode. . . . . . . 5 SNN Cancel Reason Code. . . . . . .
72 LineSeqNo . . . . . . . . . . 14 SNN Line Sequence Number. . . . . .
73 ItemCode. . . . . . . . . . . 30 SNN Item Code . . . . . . . . . . .
74 AliasItemNo . . . . . . . . . 30 SNN Alias Item Number . . . . . . .
75 ItemType. . . . . . . . . . . 1 SNN Item Type . . . . . . . . . . .
DfltVal:1
76 ItemCodeDesc. . . . . . . . . 30 SNN Item Code Description . . . . .
77 ExtendedDescriptionKey. . . . 10 SNN Extended Description Key. . . .
78 ExtendedDescriptionText . . . 4096 SNN Extended Description. . . . . .
79 Category1 . . . . . . . . . . 15 SNN Category 1. . . . . . . . . . .
80 Category2 . . . . . . . . . . 15 SNN Category 2. . . . . . . . . . .
81 Category3 . . . . . . . . . . 15 SNN Category 3. . . . . . . . . . .
82 Category4 . . . . . . . . . . 15 SNN Category 4. . . . . . . . . . .
83 BinLocation . . . . . . . . . 10 SNN Bin Location. . . . . . . . . .
84 LineWarehouseCode . . . . . . 3 SNN Line Warehouse Code . . . . . .
85 ProductLine . . . . . . . . . 4 SNN ProductLine . . . . . . . . . .
86 Discount. . . . . . . . . . . 1 SNN Discount. . . . . . . . . . . .
87 Commissionable. . . . . . . . 1 SNN Commissionable. . . . . . . . .
88 SubjectToExemption. . . . . . 1 SNN Subject To Exemption. . . . . .
89 DropShip. . . . . . . . . . . 1 SNN Drop Ship . . . . . . . . . . .
90 UnitOfMeasure . . . . . . . . 4 SNN Unit of Measure . . . . . . . .
91 CostOfGoodsSoldAcctKey. . . . 9 SNN Cost of Goods Sold Account Key.
92 CostOfGoodsSoldAccount. . . . 41 SNN Fully Formatted Cost of Goods S
93 SalesAcctKey. . . . . . . . . 9 SNN Sales Account Key . . . . . . .
94 SalesAccount. . . . . . . . . 41 SNN Fully Formatted Sales Account .
95 PromiseDate . . . . . . . . . 8 SNN Promise Date. . . . . . . . . .DATE
96 TaxClass. . . . . . . . . . . 2 SNN Tax Class . . . . . . . . . . .
97 CommentText . . . . . . . . . 2048 SNN Comment Text. . . . . . . . . .
98 ExplodedKitItem . . . . . . . 1 SNN Exploded Kit Item . . . . . . .
99 StandardKitBill . . . . . . . 1 SNN Standard Kit Bill . . . . . . .
100 Revision. . . . . . . . . . . 3 SNN Bill Revision Code. . . . . . .
101 BillOption1 . . . . . . . . . 2 SNN Bill Option 1 . . . . . . . . .
102 Option1Desc . . . . . . . . . 30 SNN Option 1 Description. . . . . .
103 BillOption2 . . . . . . . . . 2 SNN Bill Option 2 . . . . . . . . .
104 Option2Desc . . . . . . . . . 30 SNN Option 2 Description. . . . . .
105 BillOption3 . . . . . . . . . 2 SNN Bill Option 3 . . . . . . . . .
106 Option3Desc . . . . . . . . . 30 SNN Option 3 Description. . . . . .
107 BillOption4 . . . . . . . . . 2 SNN Bill Option 4 . . . . . . . . .
108 Option4Desc . . . . . . . . . 30 SNN Option 4 Description. . . . . .
109 BillOption5 . . . . . . . . . 2 SNN Bill Option 5 . . . . . . . . .
110 Option5Desc . . . . . . . . . 30 SNN Option 5 Description. . . . . .
111 BillOption6 . . . . . . . . . 2 SNN Bill Option 6 . . . . . . . . .
112 Option6Desc . . . . . . . . . 30 SNN Option 6 Description. . . . . .
113 BillOption7 . . . . . . . . . 2 SNN Bill Option 7 . . . . . . . . .
114 Option7Desc . . . . . . . . . 30 SNN Option 7 Description. . . . . .
115 BillOption8 . . . . . . . . . 2 SNN Bill Option 8 . . . . . . . . .
116 Option8Desc . . . . . . . . . 30 SNN Option 8 Description. . . . . .
117 BillOption9 . . . . . . . . . 2 SNN Bill Option 9 . . . . . . . . .
118 Option9Desc . . . . . . . . . 30 SNN Option 9 Description. . . . . .
119 SalesKitLineKey . . . . . . . 6 SNN Sales Kit Line Key. . . . . . .
120 RMANo . . . . . . . . . . . . 7 SNN RMA Number. . . . . . . . . . .
121 CustomerAction. . . . . . . . 1 SNN Customer Action . . . . . . . .
122 WarrantyCode. . . . . . . . . 10 SNN Warranty Code . . . . . . . . .
123 WarrantyCodeDesc. . . . . . . 30 SNN Warranty Code Description . . .
124 ExpirationDate. . . . . . . . 8 SNN Expiration Date . . . . . . . .DATE
125 JobNo . . . . . . . . . . . . 7 SNN Job Number. . . . . . . . . . .
126 CostCode. . . . . . . . . . . 9 SNN Cost Code . . . . . . . . . . .
127 CostCodeFormatted . . . . . . 11 SNN Cost Code Formatted . . . . . .
128 CostType. . . . . . . . . . . 1 SNN Cost Type . . . . . . . . . . .
129 MessageLine1. . . . . . . . . 50 SNN Message Line 1. . . . . . . . .
130 MessageLine2. . . . . . . . . 50 SNN Message Line 2. . . . . . . . .
131 FaxSendToCompany. . . . . . . 30 SNN Fax Send To Company . . . . . .
132 FaxSendToName . . . . . . . . 30 SNN Fax Send To Name. . . . . . . .
133 BatchFax. . . . . . . . . . . 1 SYN BatchFax. . . . . . . . . . . .YESNO
DfltVal:N Valid:Y,N
134 CRMUserID . . . . . . . . . . 11 SNN CRM User ID . . . . . . . . . .
135 CRMUserLastName . . . . . . . 30 SNN CRM User Last Name. . . . . . .
136 CRMUserFirstName. . . . . . . 30 SNN CRM User First Name . . . . . .
137 CRMCompanyID. . . . . . . . . 11 SNN CRM Company ID. . . . . . . . .
138 CRMCompanyName. . . . . . . . 120 SNN CRM Company Name. . . . . . . .
139 CRMProspectID . . . . . . . . 11 SNN CRM Prospect ID . . . . . . . .
140 CRMPersonID . . . . . . . . . 11 SNN CRM Person ID . . . . . . . . .
141 CRMPersonFirstName. . . . . . 60 SNN CRM Person First Name . . . . .
142 CRMPersonLastName . . . . . . 80 SNN CRM Person Last Name. . . . . .
143 CRMOpportunityID. . . . . . . 11 SNN CRM Opportunity ID. . . . . . .
144 CRMOpportunityDesc. . . . . . 80 SNN CRM Opportunity Description . .
145 UserCreatedKey. . . . . . . . 10 SNN Creation User ID. . . . . . . .
146 UserCreatedLogon. . . . . . . 60 SNN Creation User Logon . . . . . .
147 UserUpdatedKey. . . . . . . . 10 SNN Last Update User ID . . . . . .
148 UserUpdatedLogon. . . . . . . 60 SNN Last Update User Logon. . . . .
149 PLPrint . . . . . . . . . . . 1 SYN Paperless Office Print CustomerYESNO
DfltVal:N Valid:Y,N
150 PLEmail . . . . . . . . . . . 1 SYN Paperless Office E-Mail CustomeYESNO
DfltVal:N Valid:Y,N
151 PLFax . . . . . . . . . . . . 1 SYN Paperless Office Fax Customer .YESNO
DfltVal:N Valid:Y,N
152 PLPDF . . . . . . . . . . . . 1 SYN Paperless Office Create PDF . .YESNO
DfltVal:N Valid:Y,N
153 QuantityOrdered . . . . . . . 16.6 NNN Quantity Ordered. . . . . . . .
154 QuantityShipped . . . . . . . 16.6 NNN Quantity Shipped. . . . . . . .
155 QuantityBackOrdered . . . . . 16.6 NNN Quantity Back Ordered . . . . .
156 MasterOriginalQty . . . . . . 16.6 NNN Master Original Quantity. . . .
157 MasterQtyBalance. . . . . . . 16.6 NNN Master Quantity Balance . . . .
158 MasterQtyOrderedToDate. . . . 16.6 NNN Master Quantity Ordered To Date
159 RepeatingQtyShippedToDate . . 16.6 NNN Repeating Quantity Shipped To D
160 ItemWeight. . . . . . . . . . 16.6 NNN Item Weight . . . . . . . . . .
161 SuggestedRetailPrice. . . . . 16.6 NNN Suggested Retail Price. . . . .
162 UnitPrice . . . . . . . . . . 16.6 NNN Unit Price. . . . . . . . . . .
163 ExtensionAmt. . . . . . . . . 12.2 NNN Extension Amount. . . . . . . .
164 LineDiscountPercent . . . . . 9.3 NNN Line Discount Percentage. . . .
165 TaxableSubjectToDiscount. . . 13.2 NNN Taxable Subject To Discount . .
166 NonTaxableSubjectToDiscount . 13.2 NNN Non-Taxable Subject To Discount
167 TaxSubjToDiscPrcntOfTotSubjTo 7.2 NNN Tax-Subj-To-Disc % Of Total-Su
168 TaxableAmt. . . . . . . . . . 15.2 NNN Taxable Amount. . . . . . . . .
169 NonTaxableAmt . . . . . . . . 15.2 NNN Non-Taxable Amount. . . . . . .
170 DiscountRate. . . . . . . . . 8.3 NNN Discount Rate . . . . . . . . .
171 DiscountAmt . . . . . . . . . 13.2 NNN Discount Amount . . . . . . . .
172 FreightAmt. . . . . . . . . . 13.2 NNN Freight Amount. . . . . . . . .
173 SalesTaxAmt . . . . . . . . . 12.2 NNN Sales Tax Amount. . . . . . . .
174 SalesTaxAmt1. . . . . . . . . 12.2 NNN Sales Tax Amount 1. . . . . . .
175 SalesTaxAmt2. . . . . . . . . 12.2 NNN Sales Tax Amount 2. . . . . . .
176 SalesTaxAmt3. . . . . . . . . 12.2 NNN Sales Tax Amount 3. . . . . . .
177 SalesTaxAmt4. . . . . . . . . 12.2 NNN Sales Tax Amount 4. . . . . . .
178 DepositAmt. . . . . . . . . . 12.2 NNN Deposit Amount. . . . . . . . .
179 CreditCardPreAuthorizationAmt 13.2 NNN Credit Card Pre-Authorization A
180 CreditCardPaymentBalanceAmt . 13.2 NNN Credit Card Payment/Balance Amo
181 Weight. . . . . . . . . . . . 12.2 NNN Weight. . . . . . . . . . . . .