SO_SalesOrderHeader SO Sales Order Header Rel: 4.40 Bld: 398 8/28/2009
Bus Obj: SO_SalesOrder_bus,SO_SalesJournal_upd,IT_ShoppingCart_upd,RMirror: SO_SalesOrderHistoryHeader
SQL Def: N SysDB: N "MAS_"+%C$+"/SO"+%C$+"/SO_SalesOrderHeader.M4T"
KPRIMARY: SalesOrderNo
KCUSTOMER: ARDivisionNo+CustomerNo+SalesOrderNo
KBILLTO: BillToName+SalesOrderNo
KCUSTOMERPO: CustomerPONo+SalesOrderNo
KAUTHORIZ: AuthorizationRequiredFlag+SalesOrderNo
KDUPLICATEPO: ARDivisionNo+CustomerNo+CustomerPONo+SalesOrderNo
KCOMPANYID: CRMCompanyID+SalesOrderNo
KPERSONID: CRMPersonID+SalesOrderNo
KPROSPECTID: CRMProspectID+SalesOrderNo
Fld Column Name M/L TUR Description/Notes Class
1 SalesOrderNo. . . . . . . . . 7 SYY Sales Order Number. . . . . . .SALESORDERNO
FmtType:CHARNUM Next:SalesOrd
erNo$ Notes: {SO1$(1,7)}
2 OrderDate . . . . . . . . . . 8 SNN Order Date. . . . . . . . . . .DATE
DepVal:REQUIRED Notes:
{SO1$(8,6)}
3 OrderType . . . . . . . . . . 1 SYN Order Type. . . . . . . . . . .
Valid:S,B,M,R,Q,P Notes:
S=Standard, B=Backorder,
Q=Quote, M=Master order,
R=Repeating order, P=Prospect
Quote {SO1$(14,1)}
4 OrderStatus . . . . . . . . . 1 SYN Order Status. . . . . . . . . .
DfltVal:N Valid:N,O,C,H
Notes: N=New, O=Open,
C=Closed, H=Hold {SO1$(279,
1)}
5 MasterRepeatingOrderNo. . . . 7 SYN Master Repeating Order Number .SALESORDERNO
FmtType:CHARNUM ValGroup:Stan
dardOrder Notes: {SO1$(15,7)}
6 ShipExpireDate. . . . . . . . 8 SNN Ship Expire Date. . . . . . . .DATE
Notes: {SO1$(280,6)}
7 ARDivisionNo. . . . . . . . . 2 SNY AR Division Number. . . . . . .ARDIVISION
Mask:00 FmtType:ZEROFILL
Notes: {SO1$(22,2)}
8 CustomerNo. . . . . . . . . . 20 SYY Customer Number . . . . . . . .CUSTOMERNO
FmtType:MASTERNUMC Notes:
{SO1$(24,7)}
9 BillToName. . . . . . . . . . 30 SNN Bill To Name. . . . . . . . . .NAME
ValGroup:CustomerRequired
Notes: {SO1$(31,30)}
10 BillToAddress1. . . . . . . . 30 SNN Bill To Address Line 1. . . . .ADDRESSLINE
ValGroup:CustomerRequired
Notes: {SO1$(61,30)}
11 BillToAddress2. . . . . . . . 30 SNN Bill To Address Line 2. . . . .ADDRESSLINE
ValGroup:CustomerRequired
Notes: {SO1$(91,30)}
12 BillToAddress3. . . . . . . . 30 SNN Bill To Address Line 3. . . . .ADDRESSLINE
ValGroup:CustomerRequired
Notes: {SO1$(531,30)}
13 BillToCity. . . . . . . . . . 20 SNN Bill To City. . . . . . . . . .CITY
ValGroup:CustomerRequired
Notes: {SO1$(121,20)}
14 BillToState . . . . . . . . . 2 SYN Bill To State . . . . . . . . .STATE
ValGroup:CustomerRequired
Notes: {SO1$(141,2)}
15 BillToZipCode . . . . . . . . 10 SNN Bill To Zip Code. . . . . . . .ZIPCODE
ValGroup:CustomerRequired
Notes: {SO1$(143,10)}
16 BillToCountryCode . . . . . . 3 SYN Bill To Country Code. . . . . .COUNTRY
ValGroup:CustomerRequired
Notes: {SO1$(561,3)}
17 ShipToCode. . . . . . . . . . 4 SYN Ship-To Code. . . . . . . . . .SHIPTO
ValGroup:CustomerRequired
Notes: {SO1$(153,4)}
18 ShipToName. . . . . . . . . . 30 SNN Ship To Name. . . . . . . . . .NAME
ValGroup:CustomerRequired
Notes: {SO1$(157,30)}
19 ShipToAddress1. . . . . . . . 30 SNN Ship To Address Line 1. . . . .ADDRESSLINE
ValGroup:CustomerRequired
Notes: {SO1$(187,30)}
20 ShipToAddress2. . . . . . . . 30 SNN Ship To Address Line 2. . . . .ADDRESSLINE
ValGroup:CustomerRequired
Notes: {SO1$(217,30)}
21 ShipToAddress3. . . . . . . . 30 SNN Ship To Address Line 3. . . . .ADDRESSLINE
ValGroup:CustomerRequired
Notes: {SO1$(581,30)}
22 ShipToCity. . . . . . . . . . 20 SNN Ship To City. . . . . . . . . .CITY
ValGroup:CustomerRequired
Notes: {SO1$(247,20)}
23 ShipToState . . . . . . . . . 2 SYN Ship To State . . . . . . . . .STATE
ValGroup:CustomerRequired
Notes: {SO1$(267,2)}
24 ShipToZipCode . . . . . . . . 10 SNN Ship To Zip Code. . . . . . . .ZIPCODE
ValGroup:CustomerRequired
Notes: {SO1$(269,10)}
25 ShipToCountryCode . . . . . . 3 SYN Ship To Country Code. . . . . .COUNTRY
ValGroup:CustomerRequired
Notes: {SO1$(611,3)}
26 ShipVia . . . . . . . . . . . 15 SYN Ship Via. . . . . . . . . . . .SHIPCODE
Notes: {SO1$(301,15)}
27 ShipZone. . . . . . . . . . . 5 SYN Ship Zone . . . . . . . . . . .SHIPZONE
Notes: (Maintained)
{SO1$(444,5)}
28 ShipZoneActual. . . . . . . . 5 SYN Ship Zone Actual. . . . . . . .SHIPZONE
Notes: (Inverse If Shp As
Zip) {SO1$(454,5)}
29 ShipWeight. . . . . . . . . . 5 SYN Ship Weight . . . . . . . . . .SHIPWEIGHT
Mask:00000 FmtType:ZEROFILL
Notes: {SO1$(449,5)}
30 CustomerPONo. . . . . . . . . 15 SNN Customer PO Number. . . . . . .CUSTOMERPONO
ValGroup:CustomerRequired
Notes: {SO1$(286,15)}
31 FOB . . . . . . . . . . . . . 15 SNN F.O.B.. . . . . . . . . . . . .
Notes: {SO1$(316,15)}
32 WarehouseCode . . . . . . . . 3 SYN Warehouse Code. . . . . . . . .WAREHOUSE
FmtType:CHARNUM DepVal:REQUIR
ED ValGroup:MultiWarehouse
Notes: {SO1$(331,3)}
33 ConfirmTo . . . . . . . . . . 30 SNN Confirm To. . . . . . . . . . .
DepVal:REQUIRED Notes:
{SO1$(334,30)}
34 Comment . . . . . . . . . . . 30 SNN Comment . . . . . . . . . . . .COMMENT30
Notes: {SO1$(364,30)}
35 TermsCode . . . . . . . . . . 2 SNN Terms Code. . . . . . . . . . .ARTERMS
Mask:00 FmtType:ZEROFILL
DepVal:REQUIRED Notes:
{SO1$(403,2)}
36 TaxSchedule . . . . . . . . . 9 SYN Tax Schedule. . . . . . . . . .TAXSCHEDULE
FmtType:CHARNUM DepVal:REQUIR
ED ValGroup:ARSalesTax
Notes: {SO1$(394,9)}
37 TaxExemptNo . . . . . . . . . 15 SNN Tax Exempt Number . . . . . . .
Notes: (Only If Sales Tax
Reporting = Yes) {SO1$(409,
15)}
38 InvalidTaxCalc. . . . . . . . 1 SYN Invalid Tax Calculation . . . .YESNO
DfltVal:N Valid:Y,N
ValGroup:ARSalesTax Notes:
{SO1$(430,1)}
39 PrintSalesOrders. . . . . . . 1 SYN Print Sales Orders. . . . . . .YESNO
DfltVal:N Valid:Y,N Notes:
{SO1$(424,1)}
40 PrintPickingSheets. . . . . . 1 SYN Print Picking Sheets. . . . . .YESNO
DfltVal:N Valid:Y,N Notes:
{SO1$(425,1)}
41 LastInvoiceOrderDate. . . . . 8 SNN Last Invoice Order Date . . . .DATE
Notes: {SO1$(431,6)}
42 LastInvoiceOrderNo. . . . . . 7 SYN Last Invoice Order Number . . .INVOICE
FmtType:MASTERNUM Notes:
{SO1$(437,7)}
43 CurrentInvoiceNo. . . . . . . 7 SYN Current Invoice Number. . . . .INVOICE
FmtType:MASTERNUM Notes:
{SO1$(459,7)}
44 CheckNoForDeposit . . . . . . 10 SNN Check Number For Deposit. . . .CHECKNO
FmtType:CHARNUM DepVal:REQUIR
ED Notes: {SO1$(466,6)}
45 CycleCode . . . . . . . . . . 2 SYN Cycle Code. . . . . . . . . . .
FmtType:CHARNUM ValGroup:Mast
erRepeating Notes: {SO1$(472,
2)}
46 FaxNo . . . . . . . . . . . . 17 SNN Fax Number. . . . . . . . . . .TELEPHONENO
DepVal:REQUIRED Notes:
{SO1$(614,17)}
47 BatchFax. . . . . . . . . . . 1 SYN Batch Fax . . . . . . . . . . .YESNO
DfltVal:N Valid:Y,N Notes:
{SO1$(474,1)}
48 BatchEmail. . . . . . . . . . 1 SYN Batch Email . . . . . . . . . .YESNO
DfltVal:N Valid:Y,N
49 EmailAddress. . . . . . . . . 250 SNN Email Address . . . . . . . . .EMAILADDRESS
50 FreightCalculationMethod. . . 1 SYN Freight Calculation Method. . .
Valid:A,P,W Notes: A=Amount,
P=Product line, W=Weight
{SO1$(475,1)}
51 LotSerialLinesExist . . . . . 1 SYN Lot/Serial Lines Exist. . . . .YESNO
DfltVal:N Valid:Y,N Notes:
{SO1$(477,1)}
52 SalespersonDivisionNo . . . . 2 SNN Salesperson Division Number . .ARDIVISION
FmtType:ZEROFILL ValGroup:Cus
tomerRequired,SalespersonRepo
rting
53 SalespersonNo . . . . . . . . 4 SYN Salesperson Number. . . . . . .SALESPERSONNO
FmtType:CHARNUM ValGroup:Cust
omerRequired,SalespersonRepor
ting Notes: {SO1$(405,4)}
54 SplitCommissions. . . . . . . 1 SYN Split Commissions . . . . . . .
DfltVal:N Valid:Y,N,O
ValGroup:CustomerRequired,
SplitCommission,SalespersonRe
quired Notes: Y=Yes, N=No,
O=Override {SO1$(478,1)}
55 SalespersonDivisionNo2. . . . 2 SNN Salesperson Division Number 2 .ARDIVISION
Mask:00 FmtType:ZEROFILL
ValGroup:CustomerRequired,
SplitCommission,SalespersonRe
quired Notes: {SO1$(479,2)}
56 SalespersonNo2. . . . . . . . 4 SYN Salesperson Number 2. . . . . .SALESPERSONNO
FmtType:CHARNUM DepVal:REQUIR
ED ValGroup:CustomerRequired,
SplitCommission,SalespersonRe
quired Notes: {SO1$(481,4)}
57 SalespersonDivisionNo3. . . . 2 SNN Salesperson Division Number 3 .ARDIVISION
Mask:00 FmtType:ZEROFILL
ValGroup:CustomerRequired,
SplitCommission,SalespersonRe
quired Notes: {SO1$(492,2)}
58 SalespersonNo3. . . . . . . . 4 SYN Salesperson Number 3. . . . . .SALESPERSONNO
FmtType:CHARNUM DepVal:REQUIR
ED ValGroup:CustomerRequired,
SplitCommission,SalespersonRe
quired Notes: {SO1$(494,4)}
59 SalespersonDivisionNo4. . . . 2 SNN Salesperson Division Number 4 .ARDIVISION
Mask:00 FmtType:ZEROFILL
ValGroup:CustomerRequired,
SplitCommission,SalespersonRe
quired Notes: {SO1$(505,2)}
60 SalespersonNo4. . . . . . . . 4 SYN Salesperson Number 4. . . . . .SALESPERSONNO
FmtType:CHARNUM DepVal:REQUIR
ED ValGroup:CustomerRequired,
SplitCommission,SalespersonRe
quired Notes: {SO1$(507,4)}
61 SalespersonDivisionNo5. . . . 2 SNN Salesperson Division Number 5 .ARDIVISION
Mask:00 FmtType:ZEROFILL
ValGroup:CustomerRequired,
SplitCommission,SalespersonRe
quired Notes: {SO1$(518,2)}
62 SalespersonNo5. . . . . . . . 4 SYN Salesperson Number 5. . . . . .SALESPERSONNO
FmtType:CHARNUM DepVal:REQUIR
ED ValGroup:CustomerRequired,
SplitCommission,SalespersonRe
quired Notes: {SO1$(520,4)}
63 EBMUserType . . . . . . . . . 1 SNN EBM Internet User Type. . . . .
Valid:1,2 Notes: (1=bus.
2=consumer) {SO1$(476,1)}
64 EBMSubmissionType . . . . . . 1 SYN EBM Internet Submission Type. .
Read Only:Y Notes: {SO1$(564,
1)}
65 EBMUserIDSubmittingThisOrder. 15 SYN EBM Internet User ID Submitttin
Read Only:Y Notes: {SO1$(565,
15)}
66 PaymentType . . . . . . . . . 5 SYN Payment Type. . . . . . . . . .PAYMENTTYPE
DepVal:REQUIRED Notes:
{SO1$(631,5)}
67 OtherPaymentTypeRefNo . . . . 24 SNN Other Payment Type Reference Nu
DepVal:REQUIRED Notes:
{SO1$(636,24)}
68 CorporateCustIDPurchOrder . . 25 SNN Corporate Customer ID / Purchas
69 CorporateTaxOverrd. . . . . . 1 SYY Corporate Tax Overridden. . . .YESNO
DfltVal:N Valid:Y,N
70 DepositCorporateTaxOverrd . . 1 SYY Deposit Corporate Tax OverriddeYESNO
DfltVal:N
71 CardholderName. . . . . . . . 30 SNN Cardholder Name . . . . . . . .NAME
Notes: {SO1$(660,30)}
72 ExpirationDateYear. . . . . . 4 SNN Expiration Date Year. . . . . .YEAR
Mask:0000 Notes: {SO1$(690,
2)}
73 ExpirationDateMonth . . . . . 2 SNN Expiration Date Month . . . . .MONTH
Mask:00 Notes: {SO1$(692,2)}
74 EncryptedCreditCardNo . . . . 24 SNN Encrypted Credit Card Number. .ENCRYPTEDCREDITCARDNO
Notes: {SO1$(717,24)}
75 CancelReasonCode. . . . . . . 5 SYN Cancellation Reason Code. . . .CANCELREASONCODE
FmtType:CHARNUM Notes:
{SO1$(712,5)}
76 CreditCardCVV2No. . . . . . . 5 SNN Credit Card CVV2 Number . . . .
Notes: {SO1$(741,4)}
77 Last4UnencryptedCreditCardNos 4 SNN Last 4 Unencrypted Credit Card
Notes: {SO1$(745,4)}
78 CreditCardAuthorizationNo . . 16 SNN Credit Card Authorization Numbe
Notes: {SO1$(749,16)}
79 CreditCardTransactionID . . . 10 SNN Credit Card Transaction ID. . .
Notes: {SO1$(765,10)}
80 AuthorizationDate . . . . . . 8 SNN Authorization Date. . . . . . .DATE
Notes: {SO1$(775,6)}
81 AuthorizationTime . . . . . . 6 SNN Authorization Time. . . . . . .
Notes: {SO1$(781,6)}
82 AuthorizationCodeForDeposit . 16 SNN Authorization Code For Deposit.
ValSeqNo:9999 Notes:
{SO1$(787,16)}
83 CreditCardTransactionIDForDep 10 SNN Credit Card Transaction ID for
Notes: {SO1$(803,10)}
84 PaymentTypeCategory . . . . . 1 SYN Payment Type Category . . . . .
DfltVal:D Valid:P,D Notes:
P=Payment, D=Deposit
{SO1$(813,1)}
85 PayBalanceByCreditCard. . . . 1 SYN Pay Balance By Credit Card. . .YESNO
DfltVal:N Valid:Y,N Notes:
{SO1$(814,1)}
86 AVSAddress. . . . . . . . . . 30 SNN AVS Address Line. . . . . . . .ADDRESSLINE
Notes: {SO1$(815,30)}
87 AVSCity . . . . . . . . . . . 20 SNN AVS City. . . . . . . . . . . .CITY
Notes: {SO1$(845,20)}
88 AVSState. . . . . . . . . . . 2 SYN AVS State . . . . . . . . . . .STATE
Notes: {SO1$(865,2)}
89 AVSZipCode. . . . . . . . . . 10 SNN AVS Zip Code. . . . . . . . . .ZIPCODE
Notes: {SO1$(867,10)}
90 CreditCardComment . . . . . . 30 SNN Credit Card Comment . . . . . .COMMENT30
Notes: {SO1$(877,30)}
91 AuthorizationRequiredFlag . . 1 SYN Authorization Required Flag . .
DfltVal:O Valid:N,Y,O Notes:
N=CC not authorized, Y=CC
Authorized, O=Other payment
or no deposit {SO1$(907,1)}
92 RMANo . . . . . . . . . . . . 7 SYN RMA Number. . . . . . . . . . .RMANO
FmtType:CHARNUM Notes:
{SO1$(694,7)}
93 JobNo . . . . . . . . . . . . 7 SYN Job Number. . . . . . . . . . .JOBNO
FmtType:CHARNUM DepVal:REQUIR
ED ValGroup:JCIntegrated,
CustomerRequired
94 ResidentialAddress. . . . . . 1 SYN Residential Address . . . . . .YESNO
DfltVal:N Valid:Y,N
95 CRMUserID . . . . . . . . . . 11 SNN CRM User ID . . . . . . . . . .
ValGroup:CU_Integrated,
CU_CheckOrderType,CU_CheckCom
pany
96 CRMPersonID . . . . . . . . . 11 SNN CRM Person ID . . . . . . . . .
ValGroup:CU_Integrated,
CU_CheckOrderType,CU_CheckCom
pany
97 CRMOpportunityID. . . . . . . 11 SNN CRM Opportunity ID. . . . . . .
ValGroup:CU_Integrated,
CU_CheckOrderType,CU_CheckCom
pany
98 CRMCompanyID. . . . . . . . . 11 SNN CRM Company ID. . . . . . . . .
ValGroup:CU_Integrated,
CU_CheckOrderType,CU_CheckCom
pany
99 CRMProspectID . . . . . . . . 11 SNN CRM Prospect ID . . . . . . . .
ValGroup:CU_Integrated
100 TaxableSubjectToDiscount. . . 13.2 NNN Taxable Subject To Discount . .AMOUNT
Read Only:Y Mask:###,###,
###.00 Notes: {SO1[1]}
101 NonTaxableSubjectToDiscount . 13.2 NNN Non-Taxable Subject To DiscountAMOUNT
Read Only:Y Mask:###,###,
###.00 Notes: {SO1[2]}
102 TaxSubjToDiscPrcntOfTotSubjTo 7.2 NNN Tax-Subj-To-Disc % Of Total-Sub
Read Only:Y Mask:##0.00
Notes: {SO1[3]}
103 DiscountRate. . . . . . . . . 8.3 NNN Discount Rate . . . . . . . . .
Mask:##0.000 Notes: {SO1[4]}
104 DiscountAmt . . . . . . . . . 12.2 NNN Discount Amount . . . . . . . .MISCAMOUNT
Mask:##,###,###.00-
ValSeqNo:9999 Notes: {SO1[5]}
105 TaxableAmt. . . . . . . . . . 13.2 NNN Taxable Amount. . . . . . . . .AMOUNT
Read Only:Y Mask:###,###,
###.00 Notes: {SO1[6]}
106 NonTaxableAmt . . . . . . . . 13.2 NNN Non-Taxable Amount. . . . . . .AMOUNT
Read Only:Y Mask:###,###,
###.00 Notes: {SO1[7]}
107 SalesTaxAmt . . . . . . . . . 12.2 NNN Sales Tax Amount. . . . . . . .MISCAMOUNT
Mask:##,###,###.00-
ValGroup:ARSalesTax
ValSeqNo:9999 Notes: {SO1[8]}
108 CreditCardPreAuthorizationAmt 13.2 NNN Credit Card Pre-Authorization AAMOUNT
Mask:###,###,###.00 Notes:
{SO1[9]}
109 Weight. . . . . . . . . . . . 12.2 NNN Weight. . . . . . . . . . . . .MISCAMOUNT
Mask:##,###,###.00- Notes:
{SO1[11]}
110 FreightAmt. . . . . . . . . . 12.2 NNN Freight Amount. . . . . . . . .MISCAMOUNT
Mask:##,###,###.00-
ValSeqNo:9999 Notes:
{SO1[12]}
111 DepositAmt. . . . . . . . . . 13.2 NNN Deposit Amount. . . . . . . . .AMOUNT
Mask:###,###,###.00
ValSeqNo:9999 Notes:
{SO1[13]}
112 CreditCardPaymentBalanceAmt . 13.2 NNN Credit Card Payment / Balance AAMOUNT
Mask:###,###,###.00 Notes:
{SO1[14]}
113 CommissionRate. . . . . . . . 9.3 NNN Commission Rate . . . . . . . .COMMISSIONRATE
Mask:###0.000 ValGroup:Salesp
ersonReporting,SalespersonReq
uired Notes: {SO1[10]}
114 SplitCommRate2. . . . . . . . 9.3 NNN Split Commission Rate 2 . . . .COMMISSIONRATE
Mask:###0.000 ValGroup:SplitC
ommission,SalespersonRequired
Notes: {SO1$(485,7)}
115 SplitCommRate3. . . . . . . . 9.3 NNN Split Commission Rate 3 . . . .COMMISSIONRATE
Mask:###0.000 ValGroup:SplitC
ommission,SalespersonRequired
Notes: {SO1$(498,7)}
116 SplitCommRate4. . . . . . . . 9.3 NNN Split Commission Rate 4 . . . .COMMISSIONRATE
Mask:###0.000 ValGroup:SplitC
ommission,SalespersonRequired
Notes: {SO1$(511,7)}
117 SplitCommRate5. . . . . . . . 9.3 NNN Split Commission Rate 5 . . . .COMMISSIONRATE
Mask:###0.000 ValGroup:SplitC
ommission,SalespersonRequired
Notes: {SO1$(524,7)}
118 NumberOfShippingLabels. . . . 2.0 NNN Number Of Shipping Labels . . .
Mask:00 Notes: {SO1$(426,2)}
119 LastNoOfShippingLabels. . . . 2.0 NNN Last Number Of Shipping Labels.
Mask:00 Notes: {SO1$(428,2)}
120 DepositCorporateSalesTax. . . 12.2 NNN Deposit Corporate Sales Tax . .MISCAMOUNT
Mask:##,###,###.00-
121 CorporateSalesTax . . . . . . 12.2 NNN Corporate Sales Tax . . . . . .MISCAMOUNT
Mask:##,###,###.00-
122 DateCreated . . . . . . . . . 8 SNY Creation Date . . . . . . . . .DATE
Read Only:Y Notes: YYYYMMDD
123 TimeCreated . . . . . . . . . 8 SNY Creation Time . . . . . . . . .
Read Only:Y
124 UserCreatedKey. . . . . . . . 10 SYY Creation User ID. . . . . . . .USER
Read Only:Y Mask:0000000000
FmtType:ZEROFILL
125 DateUpdated . . . . . . . . . 8 SNN Last Update Date. . . . . . . .DATE
Read Only:Y Notes: YYYYMMDD
126 TimeUpdated . . . . . . . . . 8 SNN Last Update Time. . . . . . . .
Read Only:Y
127 UserUpdatedKey. . . . . . . . 10 SYN Last Update User ID . . . . . .USER
Read Only:Y Mask:0000000000
FmtType:ZEROFILL