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