     AR_DepositHistory                      AR Deposit History             Rel: 4.40  Bld: 398  8/28/2009
     Bus Obj: AR_CashReceiptsJournal_upd,AR_DepositHistory_bus
     SQL Def: N  SysDB: N                                     "MAS_"+%C$+"/AR"+%C$+"/AR_DepositHistory.M4T"

     KPRIMARY: PaymentType+InvoiceNo+SequenceNo
     KCUSTOMER: ARDivisionNo+CustomerNo
     KTRANSDATE: TransactionDate(d)+PaymentType+InvoiceNo+SequenceNo

     Fld  Column Name                     M/L TUR  Description/Notes              Class

       1  PaymentType . . . . . . . . .     5 SYY  Payment Type. . . . . . . . . .PAYMENTTYPE
                                                    Notes: {AR_14$(1,5)}
       2  InvoiceNo . . . . . . . . . .     7 SYY  Invoice Number. . . . . . . . .INVOICE
                                                    FmtType:MASTERNUM Notes:
                                                    {AR_14$(6,7)}
       3  SequenceNo. . . . . . . . . .     6 SNY  Sequence Number . . . . . . . .
                                                    Mask:000000 FmtType:ZEROFILL
                                                    Notes: {AR_14$(13,3)}
       4  ARDivisionNo. . . . . . . . .     2 SNN  AR Division Number. . . . . . .ARDIVISION
                                                    Mask:00 FmtType:ZEROFILL
                                                    Notes: {AR_14$(16,2)}
       5  CustomerNo. . . . . . . . . .    20 SYN  Customer No . . . . . . . . . .CUSTOMERNO
                                                    FmtType:MASTERNUMC ChngTag:Re
                                                    place1/ARDivisionNo$ Notes:
                                                    {AR_14$(18,7)}
       6  TransactionDate . . . . . . .     8 SNN  Transaction Date. . . . . . . .DATE
                                                    Notes: {AR_14$(25,6)}
       7  InvoiceDate . . . . . . . . .     8 SNN  Invoice Date. . . . . . . . . .DATE
                                                    Notes: {AR_14$(31,6)}
       8  InvoiceType . . . . . . . . .     2 SNN  Invoice Type. . . . . . . . . .
                                                    Valid:DM,IN Notes: DM=Debit
                                                    Memo, IN=INvoice {AR_14$(87,
                                                    2)}
       9  SalesOrderNo. . . . . . . . .     7 SYN  Sales Order Number. . . . . . .SALESORDERNO
                                                    FmtType:CHARNUM Notes:
                                                    {AR_14$(37,7)}
      10  ReferenceNo . . . . . . . . .    24 SNN  Reference Number. . . . . . . .
                                                    Notes: {AR_14$(44,24)}
      11  CheckNo . . . . . . . . . . .    10 SYN  Check Number. . . . . . . . . .CHECKNO
                                                    FmtType:ALPHANUM Notes:
                                                    {AR_14$(44,24)}
      12  EncryptedCreditCardNo . . . .    24 SNN  Encrypted Credit Card Number. .ENCRYPTEDCREDITCARDNO
                                                    Notes: {AR_14$(89,24)}
      13  Last4UnencryptedCreditCardNos     4 SNN  Last 4 Unencrypted Credit Card
                                                    Notes: {AR_14$(117,4)}
      14  ExpirationDateYear. . . . . .     4 SNN  Expiration Date Year. . . . . .YEAR2
                                                    Notes: {AR_14$(68,2)}
      15  ExpirationDateMonth . . . . .     2 SNN  Expiration Date Month . . . . .MONTH
                                                    Mask:00 FmtType:ZEROFILL
                                                    Notes: {AR_14$(70,2)}
      16  CreditCardAuthorizationNo . .    16 SNN  Credit Card Authorization Numbe
                                                    Notes: {AR_14$(121,16)}
      17  CreditCardTransactionID . . .    10 SNN  Credit Card Transaction ID. . .
                                                    Notes: {AR_14$(137,10)}
      18  TransactionAmt. . . . . . . . 13.2  NNN  Transaction Amount. . . . . . .AMOUNT
                                                    Mask:###,###,###.00 Notes:
                                                    {AR_14[0]}
      19  DateUpdated . . . . . . . . .     8 SNN  Last Update Date. . . . . . . .DATE
                                                    Read Only:Y Notes: YYYYMMDD
      20  TimeUpdated . . . . . . . . .     8 SNN  Last Update Time. . . . . . . .
                                                    Read Only:Y
      21  UserUpdatedKey. . . . . . . .    10 SYN  Last Update User ID . . . . . .USER
                                                    Read Only:Y Mask:0000000000
                                                    FmtType:ZEROFILL