AR_CashReceiptsHistory                 AR Cash Receipts History       Rel: 4.40  Bld: 398  8/28/2009
 Bus Obj: AR_CashReceiptsJournal_upd,AR_CashReceiptsHistory_bus,AP_ARClearingRegister_upd
 SQL Def: N  SysDB: N                                "MAS_"+%C$+"/AR"+%C$+"/AR_CashReceiptsHistory.M4T"

 KPRIMARY: BankCode+DepositDate+DepositNo+DepositType+ARDivisionNo+CustomerNo+CheckNo+SequenceNo
 KCUSTOMER: ARDivisionNo+CustomerNo
 KDEPOSITDATE: DepositDate(d)+BankCode+DepositNo+DepositType+ARDivisionNo+CustomerNo+CheckNo+SequenceNo
 KUNENCRYPTED: Last4UnencryptedCreditCardNos+BankCode+DepositDate+DepositNo+DepositType+ARDivisionNo+Cus
               tomerNo+CheckNo+SequenceNo
 KDATE: DepositDate+BankCode+DepositNo+DepositType+ARDivisionNo+CustomerNo+CheckNo+SequenceNo
 KCHECK: CheckNo+DepositDate+BankCode+DepositNo+DepositType+ARDivisionNo+CustomerNo+SequenceNo

 Fld  Column Name                     M/L TUR  Description/Notes              Class

   1  BankCode. . . . . . . . . . .     1 SYY  Bank Code . . . . . . . . . . .BANKCODE
                                                Notes: {AR3$(1,1)}
   2  DepositDate . . . . . . . . .     8 SNY  Deposit Date. . . . . . . . . .DATE
                                                Notes: {AR3$(2,6)}
   3  DepositNo . . . . . . . . . .     5 SNY  Deposit Number. . . . . . . . .DEPOSITNO
                                                FmtType:ZEROFILL Notes:
                                                {AR3$(8,5)}
   4  DepositType . . . . . . . . .     1 SYY  Deposit Type. . . . . . . . . .
                                                Valid:C,R Notes: C=Cash,
                                                R=cRedit
   5  ARDivisionNo. . . . . . . . .     2 SNY  AR Division Number. . . . . . .ARDIVISION
                                                Mask:00 FmtType:ZEROFILL
                                                Notes: {AR3$(13,2)}
   6  CustomerNo. . . . . . . . . .    20 SYY  Customer Number . . . . . . . .CUSTOMERNO
                                                FmtType:MASTERNUMC ChngTag:Re
                                                place1/ARDivisionNo$ Notes:
                                                {AR3$(15,7)}
   7  CheckNo . . . . . . . . . . .    10 SNY  Check Number. . . . . . . . . .CHECKNO
                                                Notes: {AR3$(22,10)}
   8  CreditCardNo. . . . . . . . .    24 SNN  Credit Card Number. . . . . . .
   9  SequenceNo. . . . . . . . . .     6 SNY  Sequence Number . . . . . . . .
                                                Mask:000000 FmtType:ZEROFILL
                                                ChngTag:KeySeq Notes:
                                                {AR3$(32,3)}
  10  PostingDate . . . . . . . . .     8 SNN  Posting Date. . . . . . . . . .DATE
  11  CustomerName. . . . . . . . .    30 SNN  Customer Name . . . . . . . . .NAME
                                                Notes: {AR3$(35,30)}
  12  OpenItemCustomer. . . . . . .     1 SYN  Open Item Customer. . . . . . .YESNO
                                                DfltVal:N Valid:Y,N Notes:
                                                {AR3$(65,1)}
  13  TransactionType . . . . . . .     2 SYN  Transaction Type. . . . . . . .
                                                Valid:IN,GL Notes: IN=Invoice
                                                 Type, GL=GL Only {AR3$(66,
                                                2)}
  14  InvoiceNo . . . . . . . . . .     7 SYN  Invoice Number. . . . . . . . .INVOICE
                                                FmtType:MASTERNUM Notes:
                                                {AR3$(68,7)}
  15  InvoiceType . . . . . . . . .     2 SYN  Invoice Type. . . . . . . . . .
                                                Valid:CM,DM,IN,FC,PP Notes:
                                                CM=Credit Memo, DM=Debit
                                                Memo, IN=Invoice, FC=Finance
                                                Charge, PP=PrePayment
                                                {AR3$(75,2)}
  16  AccountKey. . . . . . . . . .     9 SYN  Account Key . . . . . . . . . .ACCOUNT
                                                Notes: {AR3_2$(68,9)}
  17  DepositDesc . . . . . . . . .    30 SNN  Deposit Description . . . . . .DESCRIPTION
  18  BatchNo . . . . . . . . . . .     5 SYN  Batch Number. . . . . . . . . .BATCHNO
                                                FmtType:ALPHANUM
  19  Last4UnencryptedCreditCardNos     4 SNN  Last 4 Unencrypted Credit Card
  20  ExpirationDateYear. . . . . .     4 SNN  Expiration Date Year. . . . . .YEAR2
  21  ExpirationDateMonth . . . . .     2 SNN  Expiration Date Month . . . . .MONTH
                                                Mask:00
  22  CorporateCustIDPurchOrder . .    25 SNN  Corporate Customer ID / Purchas
  23  CorporateTaxOverrd. . . . . .     1 SYY  Corporate Tax Overridden. . . .YESNO
                                                DfltVal:N Valid:Y,N
  24  CardholderName. . . . . . . .    30 SNN  Cardholder Name . . . . . . . .NAME
  25  CreditCardTransactionID . . .    10 SNN  Credit Card Transaction ID. . .
  26  CreditCardAuthorizationNo . .    16 SNN  Credit Card Authorization Numbe
  27  AuthorizationDate . . . . . .     8 SNN  Authorization Date. . . . . . .DATE
  28  AuthorizationTime . . . . . .     8 SNN  Authorization Time. . . . . . .
  29  AVSAddress. . . . . . . . . .    30 SNN  AVS Address . . . . . . . . . .ADDRESSLINE
  30  AVSCity . . . . . . . . . . .    20 SNN  AVS City. . . . . . . . . . . .CITY
  31  AVSState. . . . . . . . . . .     2 SNN  AVS State . . . . . . . . . . .STATE
  32  AVSZipCode. . . . . . . . . .    10 SNN  AVS Zip Code. . . . . . . . . .ZIPCODE
  33  CreditCardComment . . . . . .    30 SNN  Credit Card Comment . . . . . .COMMENT30
  34  Comment . . . . . . . . . . .  2048 SNN  Comment . . . . . . . . . . . .COMMENT
  35  CashAmountApplied . . . . . . 13.2  NNN  Cash Amount Applied . . . . . .AMOUNT
                                                Mask:###,###,###.00 Notes:
                                                {AR3[0]}
  36  DiscountAmountApplied . . . . 13.2  NNN  Discount Amount Applied . . . .AMOUNT
                                                Mask:###,###,###.00 Notes:
                                                {AR3[1]}
  37  InvoiceBalance. . . . . . . . 14.2  NNN  Invoice Balance . . . . . . . .
                                                Mask:#,###,###,###.00-
                                                Notes: {AR3[2]}
  38  CorporateSalesTax . . . . . . 12.2  NNN  Corporate Sales Tax . . . . . .MISCAMOUNT
                                                Mask:##,###,###.00-
  39  DateUpdated . . . . . . . . .     8 SNN  Last Update Date. . . . . . . .DATE
                                                Read Only:Y Notes: YYYYMMDD
  40  TimeUpdated . . . . . . . . .     8 SNN  Last Update Time. . . . . . . .
                                                Read Only:Y
  41  UserUpdatedKey. . . . . . . .    10 SYN  Last Update User ID . . . . . .USER
                                                Read Only:Y Mask:0000000000
                                                FmtType:ZEROFILL