     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