SO_SalesOrderHistoryHeader SO Sales Order History Header Rel: 4.40 Bld: 398 8/28/2009
Bus Obj: SO_SalesOrderHistoryInquiry_bus
SQL Def: N SysDB: N "MAS_"+%C$+"/SO"+%C$+"/SO_SalesOrderHistoryHeader.M4T"
KPRIMARY: SalesOrderNo
KCUSTOMER: ARDivisionNo+CustomerNo+SalesOrderNo
KBILLTO: BillToName+SalesOrderNo
KCUSTOMERPO: CustomerPONo+SalesOrderNo
Fld Column Name M/L TUR Description/Notes Class
1 SalesOrderNo. . . . . . . . . 7 SYY Sales Order Number. . . . . . .SALESORDERNO
FmtType:CHARNUM Notes:
{SO_03$(1,7)}
2 OrderDate . . . . . . . . . . 8 SNN Order Date. . . . . . . . . . .DATE
Notes: {SO_03$(8,6)}
3 OrderStatus . . . . . . . . . 1 SYN Order Status. . . . . . . . . .
Valid:A,C,X,Q,Z Notes:
A=Active Order, C=Completed
Order, X=Deleted Order,
Q=Quote, Z=Deleted Quote
{SO_03$(14,1)}
4 MasterRepeatingOrderNo. . . . 7 SYN Master Repeating Order Number .SALESORDERNO
FmtType:CHARNUM Notes:
{SO_03$(15,7)}
5 ARDivisionNo. . . . . . . . . 2 SNN AR Division Number. . . . . . .ARDIVISION
Mask:00 FmtType:ZEROFILL
Notes: {SO_03$(22,2)}
6 CustomerNo. . . . . . . . . . 20 SYN Customer Number . . . . . . . .
FmtType:MASTERNUMC Notes:
{SO_03$(24,7)}
7 BillToName. . . . . . . . . . 30 SNN Bill-To Name. . . . . . . . . .NAME
Notes: {SO_03$(31,30)}
8 BillToAddress1. . . . . . . . 30 SNN Bill-To Address 1 . . . . . . .ADDRESSLINE
Notes: {SO_03$(61,30)}
9 BillToAddress2. . . . . . . . 30 SNN Bill-To Address 2 . . . . . . .ADDRESSLINE
Notes: {SO_03$(91,30)}
10 BillToAddress3. . . . . . . . 30 SNN Bill-To Address 3 . . . . . . .ADDRESSLINE
Notes: {SO_03$(531,30)}
11 BillToCity. . . . . . . . . . 20 SNN Bill-To City. . . . . . . . . .CITY
Notes: {SO_03$(121,20)}
12 BillToState . . . . . . . . . 2 SYN Bill-To State . . . . . . . . .STATE
Notes: {SO_03$(141,2)}
13 BillToZipCode . . . . . . . . 10 SYN Bill-To Zip Code. . . . . . . .ZIPCODE
Notes: {SO_03$(143,10)}
14 BillToCountryCode . . . . . . 3 SYN Bill-To Country Code. . . . . .COUNTRY
Notes: {SO_03$(561,3)}
15 ShipToCode. . . . . . . . . . 4 SYN Ship-To Code. . . . . . . . . .SHIPTO
Notes: {SO_03$(153,4)}
16 ShipToName. . . . . . . . . . 30 SNN Ship-To Name. . . . . . . . . .NAME
Notes: {SO_03$(157,30)}
17 ShipToAddress1. . . . . . . . 30 SNN Ship-To Address 1 . . . . . . .ADDRESSLINE
Notes: {SO_03$(187,30)}
18 ShipToAddress2. . . . . . . . 30 SNN Ship-To Address 2 . . . . . . .ADDRESSLINE
Notes: {SO_03$(217,30)}
19 ShipToAddress3. . . . . . . . 30 SNN Ship-To Address 3 . . . . . . .ADDRESSLINE
Notes: {SO_03$(581,30)}
20 ShipToCity. . . . . . . . . . 20 SNN Ship-To City. . . . . . . . . .CITY
Notes: {SO_03$(247,20)}
21 ShipToState . . . . . . . . . 2 SYN Ship-To State . . . . . . . . .STATE
Notes: {SO_03$(267,2)}
22 ShipToZipCode . . . . . . . . 10 SYN Ship-To Zip Code. . . . . . . .ZIPCODE
Notes: {SO_03$(269,10)}
23 ShipToCountryCode . . . . . . 3 SYN Ship-To Country Code. . . . . .COUNTRY
Notes: {SO_03$(611,3)}
24 ShipVia . . . . . . . . . . . 15 SYN Ship Via. . . . . . . . . . . .SHIPCODE
Notes: {SO_03$(301,15)}
25 ShipZone. . . . . . . . . . . 5 SYN Ship Zone . . . . . . . . . . .SHIPZONE
Notes: (Maintained)
{SO_03$(444,5)}
26 ShipZoneActual. . . . . . . . 5 SYN Ship Zone Actual. . . . . . . .SHIPZONE
Notes: (Inverse If Ship As)
{SO_03$(454,5)}
27 ShipWeight. . . . . . . . . . 5 SYN Ship Weight . . . . . . . . . .
Mask:00000 FmtType:ZEROFILL
Notes: {SO_03$(449,5)}
28 CustomerPONo. . . . . . . . . 15 SNN Customer PO Number. . . . . . .CUSTOMERPONO
Notes: {SO_03$(286,15)}
29 EmailAddress. . . . . . . . . 250 SNN Email Address . . . . . . . . .EMAILADDRESS
30 ResidentialAddress. . . . . . 1 SYN Residential Address . . . . . .YESNO
DfltVal:N Valid:Y,N
31 CancelReasonCode. . . . . . . 5 SYN Cancellation Reason Code. . . .CANCELREASONCODE
FmtType:CHARNUM Notes:
{SO_03$(279,5)}
32 FreightCalculationMethod. . . 1 SYN Freight Calculation Method. . .
Valid:A,P,W Notes: A=Amount,
P=Product Line, W=Weight
{SO_03$(284,1)}
33 FOB . . . . . . . . . . . . . 15 SNN F.O.B.. . . . . . . . . . . . .
Notes: {SO_03$(316,15)}
34 WarehouseCode . . . . . . . . 3 SYN Warehouse Code. . . . . . . . .WAREHOUSE
FmtType:CHARNUM Notes:
{SO_03$(331,3)}
35 ConfirmTo . . . . . . . . . . 30 SNN Confirm To. . . . . . . . . . .
Notes: {SO_03$(334,30)}
36 Comment . . . . . . . . . . . 30 SNN Comment . . . . . . . . . . . .COMMENT30
Notes: {SO_03$(364,30)}
37 TaxSchedule . . . . . . . . . 9 SYN Tax Schedule. . . . . . . . . .TAXSCHEDULE
FmtType:CHARNUM Notes:
{SO_03$(394,9)}
38 TermsCode . . . . . . . . . . 2 SNN Terms Code. . . . . . . . . . .ARTERMS
Mask:00 FmtType:ZEROFILL
Notes: {SO_03$(403,2)}
39 TaxExemptNo . . . . . . . . . 15 SNN Tax Exempt Number . . . . . . .
Notes: {SO_03$(409,15)}
40 RMANo . . . . . . . . . . . . 7 SYN RMA Number. . . . . . . . . . .RMANO
FmtType:CHARNUM Notes:
{SO_03$(424,7)}
41 JobNo . . . . . . . . . . . . 7 SYN Job Number. . . . . . . . . . .JOBNO
FmtType:CHARNUM
42 LastInvoiceDate . . . . . . . 8 SNN Last Invoice Date . . . . . . .DATE
Notes: {SO_03$(431,6)}
43 LastInvoiceNo . . . . . . . . 7 SYN Last Invoice Number . . . . . .INVOICE
FmtType:MASTERNUM Notes:
{SO_03$(437,7)}
44 CheckNoForDeposit . . . . . . 10 SNN Check Number For Deposit. . . .CHECKNO
FmtType:ZEROFILL Notes:
{SO_03$(466,6)}
45 LotSerialLinesExist . . . . . 1 SYN Lot/Serial Lines Exist. . . . .YESNO
DfltVal:N Valid:Y,N Notes:
{SO_03$(477,1)}
46 SalespersonDivisionNo . . . . 2 SNN Salesperson Division Number . .ARDIVISION
Mask:00 FmtType:ZEROFILL
47 SalespersonNo . . . . . . . . 4 SYN Salesperson Number. . . . . . .SALESPERSONNO
FmtType:CHARNUM Notes:
{SO_03$(405,4)}
48 SplitCommissions. . . . . . . 1 SYN Split Commissions . . . . . . .
Valid:Y,N,O Notes: Y=Yes,
N=No, O=Override {SO_03$(478,
1)}
49 SalespersonDivisionNo2. . . . 2 SNN Saleperson Division Number 2. .ARDIVISION
Mask:00 FmtType:ZEROFILL
Notes: {SO_03$(479,2)}
50 SalespersonNo2. . . . . . . . 4 SYN Salesperson Number 2. . . . . .SALESPERSONNO
FmtType:CHARNUM Notes:
{SO_03$(481,4)}
51 SalespersonDivisionNo3. . . . 2 SNN Saleperson Division Number 3. .ARDIVISION
Mask:00 FmtType:ZEROFILL
Notes: {SO_03$(492,2)}
52 SalespersonNo3. . . . . . . . 4 SYN Salesperson Number 3. . . . . .SALESPERSONNO
FmtType:CHARNUM Notes:
{SO_03$(494,4)}
53 SalespersonDivisionNo4. . . . 2 SNN Saleperson Division Number 4. .ARDIVISION
Mask:00 FmtType:ZEROFILL
Notes: {SO_03$(505,2)}
54 SalespersonNo4. . . . . . . . 4 SYN Salesperson Number 4. . . . . .SALESPERSONNO
FmtType:CHARNUM Notes:
{SO_03$(507,4)}
55 SalespersonDivisionNo5. . . . 2 SNN Saleperson Division Number 5. .ARDIVISION
Mask:00 FmtType:ZEROFILL
Notes: {SO_03$(518,2)}
56 SalespersonNo5. . . . . . . . 4 SYN Saleperson Code 5 . . . . . . .SALESPERSONNO
FmtType:CHARNUM Notes:
{SO_03$(520,4)}
57 EBMUserType . . . . . . . . . 1 SYN e-Business Manager User Type. .
Valid:1,2 Notes: 1=business,
2=consumer {SO_03$(285,1)}
58 EBMSubmissionType . . . . . . 1 SYN e-Business Manager Submission T
Valid:M,A Notes: M=Manual,
A=Auto {SO_03$(564,1)}
59 EBMUserIDSubmittingThisOrder. 15 SYN e-Business Manager User ID Subm
Notes: {SO_03$(565,15)}
60 PaymentType . . . . . . . . . 5 SYN Payment Type. . . . . . . . . .PAYMENTTYPE
Notes: {SO_03$(631,5)}
61 OtherPaymentTypeRefNo . . . . 24 SNN Other Payment Type Reference Nu
Notes: {SO_03$(636,24)}
62 CorporateCustIDPurchOrder . . 25 SNN Corporate Customer ID / Purchas
63 CorporateTaxOverrd. . . . . . 1 SYY Corporate Tax Overridden. . . .YESNO
DfltVal:N Valid:Y,N
64 DepositCorporateTaxOverrd . . 1 SYY Deposit Corporate Tax OverriddeYESNO
DfltVal:N Valid:Y,N
65 CardholderName. . . . . . . . 30 SNN Cardholder Name . . . . . . . .NAME
Notes: {SO_03$(660,30)}
66 ExpirationDateYear. . . . . . 4 SNN Expiration Date Year. . . . . .YEAR2
Notes: {SO_03$(690,2)}
67 ExpirationDateMonth . . . . . 2 SNN Expiration Date Month . . . . .MONTH
Mask:00 FmtType:ZEROFILL
Notes: {SO_03$(692,2)}
68 EncryptedCreditCardNo . . . . 24 SNN Encrypted Credit Card Number. .ENCRYPTEDCREDITCARDNO
Notes: {SO_03$(712,24)}
69 Last4UnencryptedCreditCardNos 4 SNN Last 4 Unencrypted Credit Card
Notes: {SO_03$(740,4)}
70 CreditCardAuthorizationNo . . 16 SNN Credit Card Authorization Numbe
Notes: {SO_03$(744,16)}
71 CreditCardTransactionID . . . 10 SNN Credit Card Transaction ID. . .
Notes: {SO_03$(760,10)}
72 AuthorizationDate . . . . . . 8 SNN Authorization Date. . . . . . .DATE
Notes: {SO_03$(770,6)}
73 AuthorizationTime . . . . . . 6 SNN Authorization Time. . . . . . .
Notes: {SO_03$(776,6)}
74 AuthorizationCodeForDeposit . 16 SNN Authorization Code For Deposit.
Notes: {SO_03$(782,16)}
75 CreditCardTransactionIDForDep 10 SNN Credit Card Transaction ID For
Notes: {SO_03$(798,10)}
76 PaymentTypeCategory . . . . . 1 SYN Payment Type Category . . . . .
Valid:P,D Notes: D=Deposit,
P=Payment {SO_03$(808,1)}
77 PayBalanceByCreditCard. . . . 1 SYN Pay Balance By Credit Card. . .YESNO
DfltVal:N Valid:Y,N Notes:
{SO_03$(809,1)}
78 FaxNo . . . . . . . . . . . . 17 SNN Fax Number. . . . . . . . . . .TELEPHONENO
79 CRMUserID . . . . . . . . . . 11 SNN CRM User ID . . . . . . . . . .
80 CRMCompanyID. . . . . . . . . 11 SNN CRM Company ID. . . . . . . . .
81 CRMPersonID . . . . . . . . . 11 SNN CRM Person ID . . . . . . . . .
82 CRMOpportunityID. . . . . . . 11 SNN CRM Opportunity ID. . . . . . .
83 TaxableSubjectToDiscount. . . 13.2 NNN Taxable Subject To Discount . .AMOUNT
Mask:###,###,###.00 Notes:
{SO_03[1]}
84 NonTaxableSubjectToDiscount . 13.2 NNN Non-Taxable Subject To DiscountAMOUNT
Mask:###,###,###.00 Notes:
{SO_03[2]}
85 TaxSubjToDiscPrcntTotSubjTo . 9.3 NNN Tax-Subj-To-Disc% Of Total Subj
Mask:###0.000- Notes:
{SO_03[3]}
86 DiscountRate. . . . . . . . . 9.3 NNN Discount Rate . . . . . . . . .
Mask:###0.000 Notes:
{SO_03[4]}
87 DiscountAmt . . . . . . . . . 12.2 NNN Discount Amount . . . . . . . .MISCAMOUNT
Mask:##,###,###.00- Notes:
{SO_03[5]}
88 TaxableAmt. . . . . . . . . . 13.2 NNN Taxable Amount. . . . . . . . .AMOUNT
Mask:###,###,###.00 Notes:
{SO_03[6]}
89 NonTaxableAmt . . . . . . . . 13.2 NNN Non-Taxable Amount. . . . . . .AMOUNT
Mask:###,###,###.00 Notes:
{SO_03[7]}
90 SalesTaxAmt . . . . . . . . . 12.2 NNN Sales Tax Amount. . . . . . . .MISCAMOUNT
Mask:##,###,###.00- Notes:
{SO_03[8]}
91 CreditCardPreAuthorizationAmt 13.2 NNN Credit Card Pre-Authorization AAMOUNT
Mask:###,###,###.00 Notes:
{SO_03[9]}
92 CommissionRate. . . . . . . . 9.3 NNN Commission Rate . . . . . . . .COMMISSIONRATE
Mask:###0.000 Notes:
{SO_03[10]}
93 SplitCommRate2. . . . . . . . 9.3 NNN Split Commission Rate 2 . . . .COMMISSIONRATE
Mask:###0.000 Notes:
{SO_03$(485,7)}
94 SplitCommRate3. . . . . . . . 9.3 NNN Split Commission Rate 3 . . . .COMMISSIONRATE
Mask:###0.000 Notes:
{SO_03$(498,7)}
95 SplitCommRate4. . . . . . . . 9.3 NNN Split Commission Rate 4 . . . .COMMISSIONRATE
Mask:###0.000 Notes:
{SO_03$(511,7)}
96 SplitCommRate5. . . . . . . . 9.3 NNN Split Commission Rate 5 . . . .COMMISSIONRATE
Mask:###0.000 Notes:
{SO_03$(524,7)}
97 Weight. . . . . . . . . . . . 12.2 NNN Weight. . . . . . . . . . . . .MISCAMOUNT
Mask:##,###,###.00- Notes:
{SO_03[11]}
98 FreightAmt. . . . . . . . . . 12.2 NNN Freight Amount. . . . . . . . .MISCAMOUNT
Mask:##,###,###.00- Notes:
{SO_03[12]}
99 DepositAmt. . . . . . . . . . 13.2 NNN Deposit Amount. . . . . . . . .AMOUNT
Mask:###,###,###.00 Notes:
{SO_03[13]}
100 CreditCardPaymentBalanceAmt . 13.2 NNN Credit Card Payment / Balance AAMOUNT
Mask:###,###,###.00 Notes:
{SO_03[14]}
101 DepositCorporateSalesTax. . . 12.2 NNN Deposit Corporate Sales Tax . .MISCAMOUNT
Mask:##,###,###.00-
102 CorporateSalesTax . . . . . . 12.2 NNN Corporate Sales Tax . . . . . .MISCAMOUNT
Mask:##,###,###.00-
103 DateCreated . . . . . . . . . 8 SNY Date Created. . . . . . . . . .DATE
Read Only:Y Notes: YYYYMMDD
104 TimeCreated . . . . . . . . . 8 SNY Time Created. . . . . . . . . .
Read Only:Y
105 UserCreatedKey. . . . . . . . 10 SYY User Created Key. . . . . . . .USER
Read Only:Y Mask:0000000000
106 DateUpdated . . . . . . . . . 8 SNN Last Update Date. . . . . . . .DATE
Read Only:Y Notes: YYYYMMDD
107 TimeUpdated . . . . . . . . . 8 SNN Last Update Time. . . . . . . .
Read Only:Y
108 UserUpdatedKey. . . . . . . . 10 SYN Last Update User ID . . . . . .USER
Read Only:Y Mask:0000000000
FmtType:ZEROFILL