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