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