     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