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