     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