AR_CashReceiptsDetail AR Cash Receipts Detail Rel: 4.40 Bld: 398 8/28/2009
Bus Obj: AR_CashReceiptsDetail_bus,BC_CommonImport
SQL Def: N SysDB: N "MAS_"+%C$+"/AR"+%C$+"/AR_CashReceiptsDetail.M4T"
KPRIMARY: DepositNo+ARDivisionNo+CustomerNo+EncryptedCreditCardNo+CheckNo+LineKey
KDISPLAY: DepositNo+ARDivisionNo+CustomerNo+EncryptedCreditCardNo+CheckNo+LineSeqNo+LineKey
Fld Column Name M/L TUR Description/Notes Class
1 DepositNo . . . . . . . . . . 5 SYY Deposit Number. . . . . . . . .DEPOSITNO
Read Only:Y FmtType:CHARNUM
2 ARDivisionNo. . . . . . . . . 2 SNY AR Division Number. . . . . . .ARDIVISION
Read Only:Y Mask:00
FmtType:ZEROFILL
3 CustomerNo. . . . . . . . . . 20 SYY Customer Number . . . . . . . .CUSTOMERNO
Read Only:Y FmtType:MASTERNUM
C ChngTag:Replace1/ARDivision
No$
4 EncryptedCreditCardNo . . . . 24 SNN Encrypted Credit Card Number. .ENCRYPTEDCREDITCARDNO
Read Only:Y
5 CheckNo . . . . . . . . . . . 10 SYN Check Number. . . . . . . . . .CHECKNO
Read Only:Y
6 LineKey . . . . . . . . . . . 6 SNY Line Key. . . . . . . . . . . .
Read Only:Y Mask:000000
FmtType:ZEROFILL
7 LineSeqNo . . . . . . . . . . 14 SNN Line Sequence Number. . . . . .
Read Only:Y Mask:000000000000
00 FmtType:ZEROFILL
8 LineType. . . . . . . . . . . 1 SYN Line Type . . . . . . . . . . .
DfltVal:I Valid:I,G Notes:
I=Invoice, G=G/L distribution
9 InvoiceNo . . . . . . . . . . 7 SYN Invoice Number. . . . . . . . .INVOICE
FmtType:MASTERNUM DepVal:REQU
IRED
10 InvoiceType . . . . . . . . . 2 SYN Invoice Type. . . . . . . . . .
Valid:CM,DM,IN,AD,FC,CA,XD,
PP Notes: CM=Credit Memo,
DM=Debit Memo, IN=INvoice,
AD=ADjustment., FC=Finance
Charge, CA=CAsh, XD=Deleted,
PP=PrePayment
11 NewPrepayment . . . . . . . . 1 SYN New Prepayment. . . . . . . . .YESNO
DfltVal:N Valid:Y,N
12 Comment . . . . . . . . . . . 2048 SNN Comment . . . . . . . . . . . .COMMENT
13 AccountKey. . . . . . . . . . 9 SYN Account Key . . . . . . . . . .ACCOUNT
DepVal:REQUIRED
14 DiscountAmt . . . . . . . . . 13.2 NNN Discount Amount . . . . . . . .
Mask:###,###,###.00-
15 AmountPosted. . . . . . . . . 13.2 NNN Amount Posted . . . . . . . . .
Mask:###,###,###.00-
16 InvoiceBalance. . . . . . . . 13.2 NNN Invoice Balance . . . . . . . .
Mask:###,###,###.00- Notes:
(After Posting)