     AP_InvoiceDetail                       AP Invoice Detail              Rel: 4.40  Bld: 398  8/28/2009
     Bus Obj: AP_InvoiceDetail_bus
     SQL Def: Y  SysDB: N                                      "MAS_"+%C$+"/AP"+%C$+"/AP_InvoiceDetail.M4T"

     KPRIMARY: APDivisionNo+VendorNo+InvoiceNo+LineKey
     KDISPLAY: APDivisionNo+VendorNo+InvoiceNo+LineSeqNo+LineKey

     Fld  Column Name                     M/L TUR  Description/Notes              Class

       1  APDivisionNo. . . . . . . . .     2 SNY  AP Division Number. . . . . . .APDIVISION
                                                    Read Only:Y Mask:00
                                                    FmtType:ZEROFILL
       2  VendorNo. . . . . . . . . . .     7 SYY  Vendor Number . . . . . . . . .VENDORNO
                                                    Read Only:Y FmtType:MASTERNUM
       3  InvoiceNo . . . . . . . . . .    10 SNY  Invoice Number. . . . . . . . .APINVOICE
                                                    Read Only:Y
       4  LineKey . . . . . . . . . . .     6 SNY  Line Key. . . . . . . . . . . .
                                                    Read Only:Y Mask:000000
                                                    FmtType:ZEROFILL
       5  LineSeqNo . . . . . . . . . .    14 SNY  Line Sequence Number. . . . . .
                                                    Read Only:Y Mask:000000000000
                                                    00 FmtType:ZEROFILL
       6  AccountKey. . . . . . . . . .     9 SYN  Account Key . . . . . . . . . .ACCOUNT
                                                    DepVal:REQUIRED
       7  JobNo . . . . . . . . . . . .     7 SYN  Job Number. . . . . . . . . . .JOBNO
                                                    FmtType:CHARNUM DepVal:REQUIR
                                                    ED ValGroup:JCIntegrated
       8  CostCode. . . . . . . . . . .     9 SYN  Cost Code . . . . . . . . . . .COSTCODE
                                                    DepVal:REQUIRED ValGroup:JCIn
                                                    tegrated,JobNo
       9  CostType. . . . . . . . . . .     1 SYN  Cost Type . . . . . . . . . . .COSTTYPE
                                                    DepVal:REQUIRED ValGroup:JCIn
                                                    tegrated,JobNo
      10  UnitOfMeasure . . . . . . . .     4 SYN  Unit Of Measure . . . . . . . .UNITOFMEASURE
                                                    DepVal:REQUIRED ValGroup:JCIn
                                                    tegrated,JobNo
      11  CommentText . . . . . . . . .  2048 SNN  Comment Text. . . . . . . . . .COMMENT
      12  TransferAPDivisionNo. . . . .     2 SNN  Transfer AP Division Number . .APDIVISION
                                                    Mask:00 ValGroup:NotJobNo
      13  TransferVendorNo. . . . . . .     7 SYN  Transfer Vendor Number. . . . .VENDORNO
                                                    DepVal:REQUIRED ValGroup:NotJ
                                                    obNo
      14  TransferInvoiceNo . . . . . .    10 SNN  Transfer Invoice Number . . . .APINVOICE
                                                    DepVal:REQUIRED ValGroup:NotJ
                                                    obNo
      15  TransferForm1099. . . . . . .     1 SNN  Transfer 1099 Form. . . . . . .FORM1099
      16  TransferBox1099 . . . . . . .     3 SNN  Transfer 1099 Box . . . . . . .BOX1099
      17  AssetTemplate . . . . . . . .    25 SNN  Asset Template. . . . . . . . .ASSETTEMPLATE
                                                    DepVal:REQUIRED ValGroup:FAIn
                                                    tegration
      18  QuantityDistributed . . . . . 16.6  NNN  Quantity Distributed. . . . . .QUANTITY
                                                    Mask:##,###,###.000000-
                                                    DepVal:REQUIRED ValGroup:JCIn
                                                    tegrated,JobNo
      19  DistributionAmt . . . . . . . 13.2  NNN  Distribution Amount . . . . . .
                                                    Mask:##,###,###.00-
      20  RetentionRate . . . . . . . .  8.2  NNN  Retention Rate. . . . . . . . .RATE
                                                    Mask:###.00-% DepVal:REQUIRED
                                                     ValGroup:JCIntegrated,JobNo
      21  UnitCost. . . . . . . . . . . 16.6  NNN  Unit Cost . . . . . . . . . . .COST
                                                    Mask:##,###,###.000000-
                                                    DepVal:REQUIRED ValGroup:JCIn
                                                    tegrated,JobNo
      22  RetentionAmt. . . . . . . . . 13.2  NNN  Retention Amount. . . . . . . .AMOUNT
                                                    Mask:###,###,###.00-
                                                    DepVal:REQUIRED ValGroup:JCIn
                                                    tegrated,JobNo
      23  TransferDiscount. . . . . . . 13.2  NNN  Transfer Discount . . . . . . .AMOUNT
                                                    Mask:###,###,###.00-