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