     AP_InvoiceHistoryDetail                AP Invoice History Detail      Rel: 4.40  Bld: 398  8/28/2009
     Bus Obj: AP_InvoiceHistoryDetail_bus,AP_InvoiceRegister_upd,AP_ManualCheckRegister_upd,AP_ARClearingReg
     SQL Def: Y  SysDB: N                               "MAS_"+%C$+"/AP"+%C$+"/AP_InvoiceHistoryDetail.M4T"

     KPRIMARY: InvoiceNo+HeaderSeqNo+DetailSeqNo
     KEXTENDEDDESC: ExtendedDescriptionKey+InvoiceNo+HeaderSeqNo+DetailSeqNo
     KTRANSFER: InvoiceNo+HeaderSeqNo+TransferAPDivisionNo+TransferVendorNo

     Fld  Column Name                     M/L TUR  Description/Notes              Class

       1  InvoiceNo . . . . . . . . . .    10 SNY  AP Invoice Number . . . . . . .APINVOICE
                                                    Notes: {AP_13$(1,10)}
       2  HeaderSeqNo . . . . . . . . .     6 SNY  Header Sequence Number. . . . .
                                                    Mask:000000 FmtType:ZEROFILL
                                                    Notes: {AP_13$(11,3)}
       3  DetailSeqNo . . . . . . . . .     6 SNY  Detail Sequence Number. . . . .
                                                    Mask:000000 FmtType:ZEROFILL
                                                    Notes: {AP_13$(14,5)}
       4  AccountKey. . . . . . . . . .     9 SNN  Account Key . . . . . . . . . .ACCOUNT
                                                    Notes: {AP_13$(20,9)}
       5  JobNo . . . . . . . . . . . .     7 SYN  Job Number. . . . . . . . . . .JOBNO
                                                    FmtType:CHARNUM Notes:
                                                    {AP_13$(29,7)}
       6  CostCode. . . . . . . . . . .     9 SYN  Cost Code . . . . . . . . . . .COSTCODE
                                                    Notes: {AP_13$(36,9)}
       7  CostType. . . . . . . . . . .     1 SYN  Cost Type . . . . . . . . . . .COSTTYPE
                                                    Notes: {AP_13$(45,1)}
       8  CommentText . . . . . . . . .  2048 SNN  Comment Text. . . . . . . . . .COMMENT
                                                    Notes: {AP_13$(50,20)}
       9  TransferAPDivisionNo. . . . .     2 SNN  Transfer AP Division Number . .APDIVISION
                                                    Mask:00 FmtType:ZEROFILL
                                                    Notes: {AP_13$(113,2)}
      10  TransferVendorNo. . . . . . .     7 SYN  Transfer Vendor Number. . . . .VENDORNO
                                                    FmtType:MASTERNUM ChngTag:Rep
                                                    lace1/TransferAPDivisionNo$
                                                    Notes: {AP_13$(115,7)}
      11  TransferInvoiceNo . . . . . .    10 SNN  Transfer AP Invoice Number. . .APINVOICE
                                                    Notes: {AP_13$(122,10)}
      12  TransferForm1099. . . . . . .     1 SNN  Transfer 1099 Form. . . . . . .
                                                    Notes: {AP_13$(132,1)}
      13  TransferBox1099 . . . . . . .     3 SNN  Transfer 1099 Box . . . . . . .
                                                    Notes: {AP_13$(133,2)}
      14  ItemCode. . . . . . . . . . .    30 SYN  Item Code . . . . . . . . . . .ITEMCODE
                                                    ChngTag:Replace0 Notes:
                                                    {AP_13$(20,15)}
      15  ItemCodeDesc. . . . . . . . .    30 SNN  Item Code Description . . . . .DESCRIPTION
                                                    Notes: {AP_13$(129,30)}
      16  ItemType. . . . . . . . . . .     1 SYN  Item Type . . . . . . . . . . .
                                                    Valid:1,2,3,4,5 Notes:
                                                    1=Inventory Item, 2=Special
                                                    Item, 3=Charge Item,
                                                    4=Comment Item, 5=Miscellaneo
                                                    us Item
      17  ExtendedDescriptionKey. . . .    10 SNN  Extended Description Key. . . .EXTDESCKEY
                                                    Read Only:Y
      18  UseTax. . . . . . . . . . . .     1 SYN  Use Tax . . . . . . . . . . . .YESNO
                                                    DfltVal:N Valid:Y,N Notes:
                                                    {AP_13$(40,1)}
      19  RequiredDate. . . . . . . . .     8 SNN  Required Date . . . . . . . . .DATE
                                                    Notes: {AP_13$(41,6)}
      20  VendorPriceCode . . . . . . .     4 SYN  Vendor Price Code . . . . . . .
                                                    Notes: {AP_13$(67,4)}
      21  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)}
      22  UnitOfMeasure . . . . . . . .     4 SYN  Unit Of Measure . . . . . . . .UNITOFMEASURE
                                                    Notes: {AP_13$(46,4)}
      23  WarehouseCode . . . . . . . .     3 SYN  Warehouse Code. . . . . . . . .WAREHOUSE
                                                    FmtType:CHARNUM Notes:
                                                    {AP_13$(85,3)}
      24  POWarehouseCode . . . . . . .     3 SNN  PO Warehouse Code . . . . . . .WAREHOUSE
                                                    FmtType:CHARNUM Notes:
                                                    {AP_13$(88,3)}
      25  ProductLine . . . . . . . . .     4 SYN  Product Line. . . . . . . . . .PRODUCTLINE
                                                    Notes: {AP_13$(91,4)}
      26  WorkOrderNo . . . . . . . . .     7 SNN  Work Order No . . . . . . . . .WORKORDERNO
                                                    Notes: {AP_13$(112,7)}
      27  WorkOrderStepNo . . . . . . .     4 SNN  Work Order Step Number. . . . .
                                                    Notes: {AP_13$(119,4)}
      28  WorkOrderSubStepPfx . . . . .     1 SNN  Work Order Sub-Step Prefix. . .
                                                    Notes: {AP_13$(123,1)}
      29  WorkOrderSubStepSfx . . . . .     4 SNN  Work Order Sub-Step Suffix. . .
                                                    Notes: {AP_13$(124,4)}
      30  WorkOrderTransactionType. . .     1 SNN  Work Order Transaction Type . .
      31  VendorAliasItemNo . . . . . .    30 SNN  Vendor Alias Item Number. . . .
                                                    Notes: {AP_13$(159,30)}
      32  TaxClass. . . . . . . . . . .     2 SYN  Tax Class . . . . . . . . . . .TAXCLASS
                                                    Notes: {AP_13$(189,2)}
      33  AssetTemplate . . . . . . . .    25 SNN  Asset Template. . . . . . . . .ASSETTEMPLATE
      34  RetentionRate . . . . . . . .  7.2  NNN  Retention Rate. . . . . . . . .AMOUNT
                                                    Mask:###.00- Notes:
                                                    {AP_13[2]}
      35  RetentionAmt. . . . . . . . . 13.2  NNN  Retention Amount. . . . . . . .AMOUNT
                                                    Mask:###,###,###.00- Notes:
                                                    {AP_13[4]}
      36  TransferDiscount. . . . . . . 13.2  NNN  Transfer Discount . . . . . . .AMOUNT
                                                    Mask:###,###,###.00- Notes:
                                                    {AP_13[5]}
      37  QuantityOrdered . . . . . . . 16.6  NNN  Quantity Ordered. . . . . . . .QUANTITY
                                                    Mask:##,###,###.000000-
                                                    Notes: {AP_13[0]}
      38  QuantityReceived. . . . . . . 16.6  NNN  Quantity Received . . . . . . .QUANTITY
                                                    Mask:##,###,###.000000-
                                                    Notes: {AP_13[1]}
      39  QuantityInvoiced. . . . . . . 16.6  NNN  Quantity Invoiced . . . . . . .QUANTITY
                                                    Mask:##,###,###.000000-
                                                    Notes: {AP_13[2]}
      40  UnitCost. . . . . . . . . . . 16.6  NNN  Unit Cost . . . . . . . . . . .COST
                                                    Mask:##,###,###.000000-
                                                    Notes: {AP_13[3]}
      41  OriginalUnitCost. . . . . . . 16.6  NNN  Original Unit Cost. . . . . . .COST
                                                    Mask:##,###,###.000000-
      42  ExtensionAmt. . . . . . . . . 13.2  NNN  Extension Amount. . . . . . . .AMOUNT
                                                    Mask:###,###,###.00 Notes:
                                                    {AP_13[4]}
      43  QuantityOrderedOriginal . . . 16.6  NNN  Quantity Ordered Original . . .QUANTITY
                                                    Mask:##,###,###.000000-
                                                    Notes: {AP_13[5]}
      44  UnitOfMeasureConvFactor . . . 12.4  NNN  Unit Of Measure Conversion FactUMCONVFACTOR
                                                    Mask:#####0.0000 Notes:
                                                    {AP_13[6]}