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