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)