     AR_InvoiceHistoryHeader                AR Invoice History Header      Rel: 4.40  Bld: 398  8/28/2009
     Bus Obj: AR_InvoiceHistoryInquiry_bus,SO_SalesJournal_upd,AR_SalesJournal_upd
     SQL Def: N  SysDB: N                               "MAS_"+%C$+"/AR"+%C$+"/AR_InvoiceHistoryHeader.M4T"

     KPRIMARY: InvoiceNo+HeaderSeqNo
     KCUSTOMER: ARDivisionNo+CustomerNo+InvoiceNo+HeaderSeqNo
     KAPPSONO: ModuleCode+SalesOrderNo+InvoiceNo+HeaderSeqNo
     KBILLTONAME: ModuleCode+BillToName+InvoiceNo+HeaderSeqNo
     KAPPFROM: ModuleCode+InvoiceNo+HeaderSeqNo
     KCUSTPO: CustomerPONo+InvoiceNo+HeaderSeqNo
     KSHIPPING: ShippingInvoice+InvoiceNo+HeaderSeqNo
     KSALESORDER: SalesOrderNo+InvoiceNo+HeaderSeqNo
     KBILLTO: BillToName+InvoiceNo+HeaderSeqNo
     KINVOICEDATE: InvoiceDate(d)+InvoiceNo+HeaderSeqNo

     Fld  Column Name                     M/L TUR  Description/Notes              Class

       1  InvoiceNo . . . . . . . . . .     7 SYY  Invoice Number. . . . . . . . .INVOICE
                                                    FmtType:MASTERNUM Notes:
                                                    {ARN$(1,7)}
       2  HeaderSeqNo . . . . . . . . .     6 SNY  Header Sequence Number. . . . .
                                                    Mask:000000 FmtType:ZEROFILL
                                                    Notes: {ARN$(8,3)}
       3  ModuleCode. . . . . . . . . .     3 SYY  Module Code . . . . . . . . . .MODULECODE
                                                    Notes: AR, JC, SO {ARN$(11,
                                                    2)}
       4  InvoiceType . . . . . . . . .     2 SYY  Invoice Type. . . . . . . . . .
                                                    Valid:CM,DM,IN,AD,FC,CA,XD
                                                    Notes: CM=Credit Memo,
                                                    DM=Debit Memo, IN=INvoice,
                                                    AD=ADjustment., FC=Finance
                                                    Charge, CA=CAsh, XD=Deleted
                                                    {ARN$(13,1)}
       5  InvoiceDate . . . . . . . . .     8 SNY  Invoice Date. . . . . . . . . .DATE
                                                    Notes: {ARN$(14,6)}
       6  TransactionDate . . . . . . .     8 SNN  Transaction Date. . . . . . . .DATE
                                                    Notes: {ARN$(170,6)}
       7  ARDivisionNo. . . . . . . . .     2 SNY  AR Division Number. . . . . . .ARDIVISION
                                                    Mask:00 FmtType:ZEROFILL
                                                    Notes: {ARN$(20,2)}
       8  CustomerNo. . . . . . . . . .    20 SYY  Customer Number . . . . . . . .CUSTOMERNO
                                                    FmtType:MASTERNUMC Notes:
                                                    {ARN$(22,7)}
       9  TermsCode . . . . . . . . . .     2 SNN  Terms Code. . . . . . . . . . .ARTERMS
                                                    Mask:00 FmtType:ZEROFILL
                                                    Notes: {ARN$(59,2)}
      10  TaxSchedule . . . . . . . . .     9 SYN  Tax Schedule. . . . . . . . . .TAXSCHEDULE
                                                    FmtType:CHARNUM Notes:
                                                    {ARN$(61,9)}
      11  TaxExemptNo . . . . . . . . .    15 SNN  Tax Exempt Number . . . . . . .
                                                    Notes: {ARN$(410,15)}
      12  SalespersonDivisionNo . . . .     2 SNN  Salesperson Division Number . .ARDIVISION
                                                    Mask:00 FmtType:ZEROFILL
      13  SalespersonNo . . . . . . . .     4 SYN  Salesperson Number. . . . . . .SALESPERSONNO
                                                    FmtType:CHARNUM Notes:
                                                    {ARN$(70,4)}
      14  CustomerPONo. . . . . . . . .    15 SNN  Customer PO Number. . . . . . .CUSTOMERPONO
                                                    Notes: {ARN$(89,15)}
      15  ApplyToInvoiceNo. . . . . . .     7 SYN  Apply To Invoice Number . . . .
                                                    FmtType:CHARNUM Notes: (CM &
                                                    DM) {ARN$(104,7)}
      16  Comment . . . . . . . . . . .    30 SNN  Comment . . . . . . . . . . . .COMMENT30
                                                    Notes: {ARN$(111,30)}
      17  RepetitiveInvoiceRefNo. . . .     4 SYN  Repetitive Invoice Reference Nu
                                                    FmtType:CHARNUM Notes:
                                                    {ARN$(141,4)}
      18  JobNo . . . . . . . . . . . .     7 SYN  Job Number. . . . . . . . . . .JOBNO
                                                    FmtType:CHARNUM Notes:
                                                    {ARN$(145,7)}
      19  InvoiceDueDate. . . . . . . .     8 SNN  Invoice Due Date. . . . . . . .DATE
                                                    Notes: {ARN$(152,6)}
      20  DiscountDueDate . . . . . . .     8 SNN  Discount Due Date . . . . . . .DATE
                                                    Notes: {ARN$(158,6)}
      21  SourceJournal . . . . . . . .     2 SNN  Source Journal. . . . . . . . .SOURCEJOURNAL
                                                    Notes: {ARN$(164,2)}
      22  JournalNoGLBatchNo. . . . . .     6 SNN  Journal Number/GL Batch Number.
                                                    Mask:000000 FmtType:ZEROFILL
                                                    Notes: {ARN$(166,4)}
      23  BatchFax. . . . . . . . . . .     1 SYY  Batch Fax . . . . . . . . . . .YESNO
                                                    DfltVal:N Valid:Y,N Notes:
                                                    {ARN$(713,1)}
      24  FaxNo . . . . . . . . . . . .    17 SNN  Fax Number. . . . . . . . . . .TELEPHONENO
                                                    Notes: {ARN$(603,17)}
      25  ShippingInvoice . . . . . . .     1 SYY  Shipping Invoice. . . . . . . .YESNO
                                                    DfltVal:N Valid:Y,N Notes:
                                                    Placeholder only in AR
                                                    Record {ARN$(683,1)}
      26  SalesOrderNo. . . . . . . . .     7 SYN  Sales Order Number. . . . . . .SALESORDERNO
                                                    FmtType:CHARNUM Notes:
                                                    {ARN$(844,7)}
      27  OrderType . . . . . . . . . .     1 SYN  Order Type. . . . . . . . . . .
                                                    Valid:B,S,1 Notes: B=Backorde
                                                    r, S=Standard, 1=One Step
                                                    Invoice {ARN$(425,1)}
      28  OrderDate . . . . . . . . . .     8 SNN  Order Date. . . . . . . . . . .DATE
                                                    Notes: {ARN$(426,6)}
      29  BillToName. . . . . . . . . .    30 SNN  Bill To Name. . . . . . . . . .NAME
                                                    Notes: {ARN$(36,30)}
      30  BillToAddress1. . . . . . . .    30 SNN  Bill To Address 1 . . . . . . .ADDRESSLINE
                                                    Notes: {ARN$(66,30)}
      31  BillToAddress2. . . . . . . .    30 SNN  Bill To Address 2 . . . . . . .ADDRESSLINE
                                                    Notes: {ARN$(96,30)}
      32  BillToAddress3. . . . . . . .    30 SNN  Bill To Address 3 . . . . . . .ADDRESSLINE
                                                    Notes: {ARN$(520,30)}
      33  BillToCity. . . . . . . . . .    20 SNN  Bill To City. . . . . . . . . .CITY
                                                    Notes: {ARN$(126,20)}
      34  BillToState . . . . . . . . .     2 SYN  Bill To State . . . . . . . . .STATE
                                                    Notes: {ARN$(146,2)}
      35  BillToZipCode . . . . . . . .    10 SYN  Bill To Zip Code. . . . . . . .ZIPCODE
                                                    Notes: {ARN$(148,10)}
      36  BillToCountryCode . . . . . .     3 SYN  Bill To Country Code. . . . . .COUNTRY
                                                    Notes: {ARN$(550,3)}
      37  ShipToCode. . . . . . . . . .     4 SYN  Ship-To Code. . . . . . . . . .SHIPTO
                                                    Notes: {ARN$(158,4)}
      38  ShipToName. . . . . . . . . .    30 SNN  Ship To Name. . . . . . . . . .NAME
                                                    Notes: {ARN$(162,30)}
      39  ShipToAddress1. . . . . . . .    30 SNN  Ship To Address 1 . . . . . . .ADDRESSLINE
                                                    Notes: {ARN$(192,30)}
      40  ShipToAddress2. . . . . . . .    30 SNN  Ship To Address 2 . . . . . . .ADDRESSLINE
                                                    Notes: {ARN$(222,30)}
      41  ShipToAddress3. . . . . . . .    30 SNN  Ship To Address 3 . . . . . . .ADDRESSLINE
                                                    Notes: {ARN$(570,30)}
      42  ShipToCity. . . . . . . . . .    20 SNN  Ship To City. . . . . . . . . .CITY
                                                    Notes: {ARN$(252,20)}
      43  ShipToState . . . . . . . . .     2 SYN  Ship To State . . . . . . . . .STATE
                                                    Notes: {ARN$(272,2)}
      44  ShipToZipCode . . . . . . . .    10 SYN  Ship To Zip Code. . . . . . . .ZIPCODE
                                                    Notes: {ARN$(274,10)}
      45  ShipToCountryCode . . . . . .     3 SYN  Ship To Country Code. . . . . .COUNTRY
                                                    Notes: {ARN$(600,3)}
      46  ShipDate. . . . . . . . . . .     8 SNN  Ship To Date. . . . . . . . . .DATE
                                                    Notes: {ARN$(284,6)}
      47  ShipVia . . . . . . . . . . .    15 SYN  Ship Via. . . . . . . . . . . .SHIPCODE
                                                    Notes: {ARN$(74,15)}
      48  ShipZone. . . . . . . . . . .     5 SYN  Ship Zone . . . . . . . . . . .SHIPZONE
                                                    Notes: Maintained {ARN$(432,
                                                    5)}
      49  FOB . . . . . . . . . . . . .    15 SNN  F.O.B.. . . . . . . . . . . . .
                                                    Notes: {ARN$(320,15)}
      50  ConfirmTo . . . . . . . . . .    30 SNN  Confirm To. . . . . . . . . . .NAME
                                                    Notes: {ARN$(335,30)}
      51  CheckNoForDeposit . . . . . .     7 SNN  Check Number For Deposit. . . .CHECKNO
                                                    Mask:0000000 FmtType:ZEROFILL
                                                     Notes: {ARN$(442,6)}
      52  SplitCommissions. . . . . . .     1 SYY  Split Commissions . . . . . . .
                                                    DfltVal:N Valid:Y,N,O Notes:
                                                    Y=Yes, N=No, O=Override
                                                    {ARN$(467,1)}
      53  SalespersonDivisionNo2. . . .     2 SNN  Salesperson Division Number 2 .ARDIVISION
                                                    Mask:00 FmtType:ZEROFILL
                                                    Notes: {ARN$(468,2)}
      54  SalespersonNo2. . . . . . . .     4 SYN  Salesperson Number 2. . . . . .SALESPERSONNO
                                                    FmtType:CHARNUM Notes:
                                                    {ARN$(470,4)}
      55  SalespersonDivisionNo3. . . .     2 SNN  Salesperson Division Number 3 .ARDIVISION
                                                    Mask:00 FmtType:ZEROFILL
                                                    Notes: {ARN$(481,2)}
      56  SalespersonNo3. . . . . . . .     4 SYN  Salesperson Number 3. . . . . .SALESPERSONNO
                                                    FmtType:CHARNUM Notes:
                                                    {ARN$(483,4)}
      57  SalespersonDivisionNo4. . . .     2 SNN  Salesperson Division Number 4 .ARDIVISION
                                                    Mask:00 FmtType:ZEROFILL
                                                    Notes: {ARN$(494,2)}
      58  SalespersonNo4. . . . . . . .     4 SYN  Salesperson Number 4. . . . . .SALESPERSONNO
                                                    FmtType:CHARNUM Notes:
                                                    {ARN$(496,4)}
      59  SalespersonDivisionNo5. . . .     2 SNN  Salesperson Division Number 5 .ARDIVISION
                                                    Mask:00 FmtType:ZEROFILL
                                                    Notes: {ARN$(507,2)}
      60  SalespersonNo5. . . . . . . .     4 SYN  Salesperson Number 5. . . . . .SALESPERSONNO
                                                    FmtType:CHARNUM Notes:
                                                    {ARN$(509,4)}
      61  PaymentType . . . . . . . . .     5 SYN  Payment Type. . . . . . . . . .PAYMENTTYPE
                                                    Notes: {ARN$(620,5)}
      62  PaymentTypeCategory . . . . .     1 SYN  Payment Type Category . . . . .
                                                    Notes: {ARN$(798,1)}
      63  OtherPaymentTypeRefNo . . . .    24 SNN  Other Payment Type Reference Nu
                                                    Notes: {ARN$(625,24)}
      64  CorporateCustIDPurchOrder . .    25 SNN  Corporate Customer ID / Purchas
      65  CorporateTaxOverrd. . . . . .     1 SYY  Corporate Tax Overridden. . . .YESNO
                                                    DfltVal:N Valid:Y,N
      66  DepositCorporateTaxOverrd . .     1 SYY  Deposit Corporate Tax OverriddeYESNO
                                                    DfltVal:N Valid:Y,N
      67  CardholderName. . . . . . . .    30 SNN  Cardholder Name . . . . . . . .NAME
                                                    Notes: {ARN$(649,30)}
      68  ExpirationDateYear. . . . . .     4 SNN  Expiration Date Year. . . . . .YEAR2
                                                    Notes: {ARN$(679,2)}
      69  ExpirationDateMonth . . . . .     2 SNN  Expiration Date Month . . . . .MONTH
                                                    Mask:00 FmtType:ZEROFILL
                                                    Notes: {ARN$(681,2)}
      70  EncryptedCreditCardNo . . . .    24 SNN  Encrypted Credit Card Number. .ENCRYPTEDCREDITCARDNO
                                                    Notes: {ARN$(714,24)}
      71  Last4UnencryptedCreditCardNos     4 SNN  Last 4 Unencrypted Credit Card
                                                    Notes: {ARN$(742,4)}
      72  AuthorizationCode . . . . . .    16 SNN  Authorization Code. . . . . . .
                                                    Notes: {ARN$(746,16)}
      73  AuthorizationCodeForDeposit .    16 SNN  Authorization Code for Deposit.
                                                    Notes: {ARN$(772,16)}
      74  CreditCardTransactionID . . .    10 SNN  Credit Card Transaction ID. . .
                                                    Notes: {ARN$(762,10)}
      75  CreditCardTransactionIDForDep    10 SNN  Credit Card Transaction ID for
                                                    Notes: {ARN$(788,10)}
      76  RMANo . . . . . . . . . . . .     7 SYN  RMA Number. . . . . . . . . . .RMANO
                                                    FmtType:CHARNUM Notes:
                                                    {ARN$(684,7)}
      77  EBMSubmissionType . . . . . .     1 SYN  EBM Submission Type . . . . . .
                                                    Valid:M.A Notes: M=Manual,
                                                    A=Auto {ARN$(553,1)}
      78  EBMUserIDSubmittingThisOrder.    15 SYN  EBM User ID Submitting This Ord
                                                    Notes: {ARN$(554,15)}
      79  EBMUserType . . . . . . . . .     1 SYN  EBM User Type . . . . . . . . .
                                                    Valid:1,2 Notes: 1=Business,
                                                    2=Consumer {ARN$(569,1)}
      80  ShipperID . . . . . . . . . .     3 SYN  ShipperID . . . . . . . . . . .
                                                    Notes: {ARN$(851,3)}
      81  UserKey . . . . . . . . . . .    10 SNN  User Key. . . . . . . . . . . .USER
                                                    Mask:0000000000 Notes:
                                                    {ARN$(710,3)}
      82  WarehouseCode . . . . . . . .     3 SYN  Warehouse Code. . . . . . . . .WAREHOUSE
                                                    FmtType:CHARNUM Notes:
                                                    {ARN$(858,3)}
      83  ShipWeight. . . . . . . . . .     5 SYN  Ship Weight . . . . . . . . . .
                                                    Mask:00000 FmtType:CHARNUM
                                                    Notes: {ARN$(437,5)}
      84  ResidentialAddress. . . . . .     1 SYY  Residential Address . . . . . .YESNO
                                                    DfltVal:N Valid:Y,N
      85  EmailAddress. . . . . . . . .   250 SNN  Email Address . . . . . . . . .EMAILADDRESS
      86  CRMUserID . . . . . . . . . .    11 SNN  CRM User ID . . . . . . . . . .
      87  CRMCompanyID. . . . . . . . .    11 SNN  CRM Company ID. . . . . . . . .
      88  CRMPersonID . . . . . . . . .    11 SNN  CRM Person ID . . . . . . . . .
      89  CRMOpportunityID. . . . . . .    11 SNN  CRM Opportunity ID. . . . . . .
      90  TaxableSalesAmt . . . . . . . 13.2  NNN  Taxable Sales Amount. . . . . .AMOUNT
                                                    Mask:###,###,###.00 Notes:
                                                    {ARN[1]}
      91  NonTaxableSalesAmt. . . . . . 13.2  NNN  Non-Taxable Sales Amount. . . .AMOUNT
                                                    Mask:###,###,###.00 Notes:
                                                    {ARN[2]}
      92  FreightAmt. . . . . . . . . . 12.2  NNN  Freight Amount. . . . . . . . .MISCAMOUNT
                                                    Mask:##,###,###.00- Notes:
                                                    {ARN[3]}
      93  SalesTaxAmt . . . . . . . . . 12.2  NNN  Sales Tax Amount. . . . . . . .MISCAMOUNT
                                                    Mask:##,###,###.00- Notes:
                                                    {ARN[4]}
      94  CostOfSalesAmt. . . . . . . . 13.2  NNN  Cost Of Sales Amount. . . . . .AMOUNT
                                                    Mask:###,###,###.00 Notes:
                                                    {ARN[5]}
      95  AmountSubjectToDiscount . . . 13.2  NNN  Amount Subject to Discount. . .AMOUNT
                                                    Mask:###,###,###.00 Notes:
                                                    {ARN[0]}
      96  DiscountRate. . . . . . . . .  9.3  NNN  Discount Rate . . . . . . . . .
                                                    Mask:###0.000 Notes: {ARN[2]}
      97  DiscountAmt . . . . . . . . . 12.2  NNN  Discount Amount . . . . . . . .MISCAMOUNT
                                                    Mask:##,###,###.00- Notes:
                                                    {ARN[3]}
      98  SalesSubjectToComm. . . . . . 13.2  NNN  Sales Subject To Commission . .AMOUNT
                                                    Mask:###,###,###.00 Notes:
                                                    {ARN[6]}
      99  CostSubjectToComm . . . . . . 13.2  NNN  Cost Subject To Commission. . .AMOUNT
                                                    Mask:###,###,###.00 Notes:
                                                    {ARN[7]}
     100  CommissionRate. . . . . . . .  9.3  NNN  Commission Rate . . . . . . . .COMMISSIONRATE
                                                    Mask:###0.000 Notes: {ARN[0]}
     101  CommissionAmt . . . . . . . . 13.2  NNN  Commission Amount . . . . . . .AMOUNT
                                                    Mask:###,###,###.00 Notes:
                                                    {ARN[8]}
     102  SplitCommRate2. . . . . . . .  9.3  NNN  Split Commission Rate 2 . . . .COMMISSIONRATE
                                                    Mask:###0.000 Notes:
                                                    {ARN$(474,7)}
     103  SplitCommRate3. . . . . . . .  9.3  NNN  Split Commission Rate 3 . . . .COMMISSIONRATE
                                                    Mask:###0.000 Notes:
                                                    {ARN$(487,7)}
     104  SplitCommRate4. . . . . . . .  9.3  NNN  Split Commission Rate 4 . . . .COMMISSIONRATE
                                                    Mask:###0.000 Notes:
                                                    {ARN$(500,7)}
     105  SplitCommRate5. . . . . . . .  9.3  NNN  Split Commission Rate 5 . . . .COMMISSIONRATE
                                                    Mask:###0.000 Notes:
                                                    {ARN$(513,7)}
     106  DepositAmt. . . . . . . . . . 13.2  NNN  Deposit Amount. . . . . . . . .AMOUNT
                                                    Mask:###,###,###.00 Notes:
                                                    {ARN[12]}
     107  CreditCardPaymentBalanceAmt . 13.2  NNN  Credit Card Payment / Balance AAMOUNT
                                                    Mask:###,###,###.00 Notes:
                                                    {ARN[14]}
     108  Weight. . . . . . . . . . . . 12.2  NNN  Weight. . . . . . . . . . . . .AMOUNT
                                                    Mask:##,###,###.00 Notes:
                                                    {ARN[13]}
     109  RetentionAmt. . . . . . . . . 13.2  NNN  Retention Amount. . . . . . . .AMOUNT
                                                    Mask:###,###,###.00 Notes:
                                                    {ARN[9]}
     110  NumberOfPackages. . . . . . .  5.0  NNN  Number of Packages. . . . . . .
                                                    Mask:###0 Notes: {ARN$(854,
                                                    4)}
     111  DepositCorporateSalesTax. . . 12.2  NNN  Deposit Corporate Sales Tax . .MISCAMOUNT
                                                    Mask:##,###,###.00-
     112  CorporateSalesTax . . . . . . 12.2  NNN  Corporate Sales Tax . . . . . .MISCAMOUNT
                                                    Mask:##,###,###.00-
     113  DateUpdated . . . . . . . . .     8 SNN  Last Update Date. . . . . . . .DATE
                                                    Read Only:Y Notes: YYYYMMDD
     114  TimeUpdated . . . . . . . . .     8 SNN  Last Update Time. . . . . . . .
                                                    Read Only:Y
     115  UserUpdatedKey. . . . . . . .    10 SYN  Last Update User ID . . . . . .USER
                                                    Read Only:Y Mask:0000000000
                                                    FmtType:ZEROFILL