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-