AP_ARClearingDetail AP From AR Clearing Detail Rel: 4.40 Bld: 398 8/28/2009
Bus Obj: AP_ARClearingDetail_bus
SQL Def: Y SysDB: N "MAS_"+%C$+"/AP"+%C$+"/AP_ARClearingDetail.M4T"
KPRIMARY: RecordType+Clear+ARDivisionNo+CustomerNo+CheckNo+LineKey
KDISPLAY: RecordType+Clear+ARDivisionNo+CustomerNo+CheckNo+LineSeqNo+LineKey
Fld Column Name M/L TUR Description/Notes Class
1 RecordType. . . . . . . . . . 1 SYY Record Type . . . . . . . . . .
Read Only:Y
2 Clear . . . . . . . . . . . . 5 SNY Clear . . . . . . . . . . . . .
Read Only:Y
3 ARDivisionNo. . . . . . . . . 2 SNY AR Division Number. . . . . . .ARDIVISION
Read Only:Y Mask:00
FmtType:ZEROFILL
4 CustomerNo. . . . . . . . . . 20 SYY Customer Number . . . . . . . .CUSTOMERNO
Read Only:Y FmtType:MASTERNUM
C
5 CheckNo . . . . . . . . . . . 10 SNY Check Number. . . . . . . . . .CHECKNO
Read Only:Y
6 LineKey . . . . . . . . . . . 6 SNY LineKey . . . . . . . . . . . .
Read Only:Y Mask:000000
FmtType:ZEROFILL
7 LineSeqNo . . . . . . . . . . 14 SNN Line Sequence Number. . . . . .
Read Only:Y Mask:000000000000
00 FmtType:ZEROFILL
8 FieldType . . . . . . . . . . 2 SNN Field Type. . . . . . . . . . .
Notes: Blank=Invoice, GL=
General Ledger
9 InvoiceType . . . . . . . . . 2 SYN Invoice Type. . . . . . . . . .
Valid:CM,DM,IN,AD,FC,CA,XD,
PP Notes: Will be blank when
InvoiceNo is Balance.
CM=Credit Memo, DM=Debit
Memo, IN=INvoice, AD=ADjustme
nt., FC=Finance Charge,
CA=CAsh, XD=Deleted,
PP=PrePayment
10 InvoiceNo . . . . . . . . . . 7 SYY Invoice Number. . . . . . . . .INVOICE
FmtType:MASTERNUM Notes: Can
also be "BALANCE "
11 DiscountAmt . . . . . . . . . 13.2 NNN Discount Amount . . . . . . . .AMOUNT
Mask:###,###,###.00-
ValGroup:InvoiceNoRequired
12 AmountPosted. . . . . . . . . 13.2 NNN Amount Posted . . . . . . . . .AMOUNT
Mask:###,###,###.00-
ValGroup:InvoiceNoRequired
13 InvoiceBalance. . . . . . . . 13.2 NNN Invoice Balance . . . . . . . .AMOUNT
Mask:###,###,###.00-
ValGroup:InvoiceNoRequired