     AP_InvoiceDetailPosting                AP Invoice Detail Posting      Rel: 4.40  Bld: 398  8/28/2009
     Bus Obj: AP_InvoiceRegister_upd,AP_ManualCheckRegister_upd,PO_ReceiptRegister_upd,PO_ReturnRegister_upd
     SQL Def: Y  SysDB: N                               "MAS_"+%C$+"/AP"+%C$+"/AP_InvoiceDetailPosting.M4T"

     KPRIMARY: InvoiceNo

     Fld  Column Name                     M/L TUR  Description/Notes              Class

       1  InvoiceNo . . . . . . . . . .    10 SNN  AP Invoice Number . . . . . . .
       2  APDivisionNo. . . . . . . . .     2 SNY  AP Division Number. . . . . . .APDIVISION
                                                    Mask:00
       3  VendorNo. . . . . . . . . . .     7 SYY  Vendor Number . . . . . . . . .VENDORNO
       4  InvoiceHistoryHeaderSeqNo . .     6 SNN  Invoice History Header Sequence
       5  AccountKey. . . . . . . . . .     9 SNN  Account KEY . . . . . . . . . .
       6  JobNo . . . . . . . . . . . .     7 SNN  Job Number. . . . . . . . . . .
                                                    FmtType:CHARNUM
       7  CostCode. . . . . . . . . . .     9 SNN  Cost Code . . . . . . . . . . .
       8  CostType. . . . . . . . . . .     1 SNN  Cost Type . . . . . . . . . . .
       9  CommentText . . . . . . . . .  2048 SNN  Comment TEXT. . . . . . . . . .
      10  TransferAPDivisionNo. . . . .     2 SNN  Transfer AP Division Number . .
      11  TransferVendorNo. . . . . . .     7 SNN  Transfer Vendor Number. . . . .
      12  TransferInvoiceNo . . . . . .    10 SNN  Transfer AP Invoice Number. . .
      13  TransferForm1099. . . . . . .     1 SNN  Transfer 1099 Form. . . . . . .
      14  TransferBox1099 . . . . . . .     3 SNN  Transfer 1099 BOX . . . . . . .
      15  AssetTemplate . . . . . . . .    25 SNN  Asset Template. . . . . . . . .ASSETTEMPLATE
      16  ItemCode. . . . . . . . . . .    30 SYN  Item Code . . . . . . . . . . .ITEMCODE
      17  ItemCodeDesc. . . . . . . . .    30 SNN  Item Code Description . . . . .DESCRIPTION
      18  ExtendedDescriptionKey. . . .    10 SNN  Extended Description Key. . . .EXTDESCKEY
                                                    Read Only:Y ValGroup:NootComm
                                                    ent,ItemRequired
      19  ItemType. . . . . . . . . . .     1 SNN  Item Type . . . . . . . . . . .
      20  UseTax. . . . . . . . . . . .     1 SYN  Use Tax . . . . . . . . . . . .YESNO
                                                    DfltVal:N Valid:Y,N
      21  RequiredDate. . . . . . . . .     8 SNN  Required Date . . . . . . . . .DATE
      22  VendorPriceCode . . . . . . .     4 SNN  Vendor Price Code . . . . . . .
      23  Valuation . . . . . . . . . .     1 SNN  Valuation . . . . . . . . . . .
                                                    Valid:1,2,3,4,5,6 Notes:
                                                    1=Standard, 2=Average,
                                                    3=Fifo, 4=Lifo, 5=Lot,
                                                    6=Serial {AP_13$(80,1)}
      24  UnitOfMeasure . . . . . . . .     4 SNN  Unit Of Measure . . . . . . . .
      25  WarehouseCode . . . . . . . .     3 SYN  Warehouse Code. . . . . . . . .WAREHOUSE
                                                    FmtType:CHARNUM
      26  POWarehouseCode . . . . . . .     3 SNN  PO Warehouse Code . . . . . . .WAREHOUSE
                                                    FmtType:CHARNUM
      27  ProductLine . . . . . . . . .     4 SYN  Product Line. . . . . . . . . .PRODUCTLINE
      28  WorkOrderNo . . . . . . . . .     7 SNN  Work Order Number . . . . . . .
      29  WorkOrderStepNo . . . . . . .     4 SNN  Work Order Step Number. . . . .
      30  WorkOrderSubStepPfx . . . . .     1 SNN  Work Order Sub-Step Prefix. . .
      31  WorkOrderSubStepSfx . . . . .     4 SNN  Work Order Sub-Step Suffix. . .
      32  WorkOrderTransactionType. . .     1 SNN  Work Order Transaction Type . .
      33  VendorAliasItemNo . . . . . .    30 SNN  Vendor Alias Item Number. . . .
      34  TaxClass. . . . . . . . . . .     2 SYN  Tax Class . . . . . . . . . . .TAXCLASS
      35  ReceiptType . . . . . . . . .     1 SYY  Receipt Type. . . . . . . . . .
      36  ReceiptNo . . . . . . . . . .     6 SNN  Receipt Number. . . . . . . . .RECEIPTNO
                                                    Mask:000000
      37  LineKey . . . . . . . . . . .     6 SNY  Line Key. . . . . . . . . . . .
      38  RetentionRate . . . . . . . .  7.2  NNN  Retention Rate. . . . . . . . .
      39  UnitCost. . . . . . . . . . . 16.6  NNN  Unit Cost . . . . . . . . . . .
      40  OriginalUnitCost. . . . . . . 16.6  NNN  Original Unit Cost. . . . . . .COST
                                                    Mask:##,###,###.000000-
      41  RetentionAmt. . . . . . . . . 13.2  NNN  Retention Amount. . . . . . . .
      42  TransferDiscount. . . . . . . 13.2  NNN  Transfer Discount . . . . . . .
      43  QuantityOrdered . . . . . . . 16.6  NNN  Quantity Ordered. . . . . . . .QUANTITY
                                                    Mask:##,###,###.000000-
      44  QuantityReceived. . . . . . . 16.6  NNN  Quantity Received . . . . . . .QUANTITY
                                                    Mask:##,###,###.000000-
      45  QuantityInvoiced. . . . . . . 16.6  NNN  Quantity Invoiced . . . . . . .QUANTITY
                                                    Mask:##,###,###.000000-
      46  QuantityOrderedOriginal . . . 16.6  NNN  Quantity Ordered Original . . .QUANTITY
                                                    Mask:##,###,###.000000-
      47  UnitOfMeasureConvFactor . . . 12.4  NNN  Unit Of Measure Conversion FactUMCONVFACTOR
                                                    Mask:#####0.0000
      48  ExtensionAmt. . . . . . . . . 13.2  NNN  Extension Amount. . . . . . . .AMOUNT
                                                    Mask:###,###,###.00
      49  AllocatedFreight. . . . . . . 13.2  NNN  Allocated Freight . . . . . . .AMOUNT
                                                    Mask:###,###,###.00
      50  AllocatedTaxAmt . . . . . . . 12.2  NNN  Allocated Tax Amount. . . . . .MISCAMOUNT
                                                    Mask:##,###,###.00-