     AR_InvoiceHistoryDetail                AR Invoice History Detail      Rel: 4.40  Bld: 398  8/28/2009
     Bus Obj: AR_InvoiceHistoryInquiryDetail_bus,SO_SalesJournal_upd,AR_SalesJournal_upd
     SQL Def: N  SysDB: N                               "MAS_"+%C$+"/AR"+%C$+"/AR_InvoiceHistoryDetail.M4T"

     KPRIMARY: InvoiceNo+HeaderSeqNo+DetailSeqNo
     KEXTENDEDDESC: ExtendedDescriptionKey+InvoiceNo+HeaderSeqNo+DetailSeqNo

     Fld  Column Name                     M/L TUR  Description/Notes              Class

       1  InvoiceNo . . . . . . . . . .     7 SYY  Invoice Number. . . . . . . . .INVOICE
                                                    FmtType:MASTERNUM Notes:
                                                    {ARO$(1,7)}
       2  HeaderSeqNo . . . . . . . . .     6 SNY  Header Sequence Number. . . . .
                                                    Mask:000000 FmtType:ZEROFILL
                                                    Notes: {ARO$(8,3)}
       3  DetailSeqNo . . . . . . . . .     6 SNY  Detail Sequence Number. . . . .
                                                    Mask:000000 FmtType:ZEROFILL
                                                    Notes: {ARO$(11,5)}
       4  ItemCode. . . . . . . . . . .    30 SYY  Item Code . . . . . . . . . . .ITEMCODE
                                                    ChngTag:Replace0 Notes:
                                                    {ARO$(20,6)}
       5  ItemType. . . . . . . . . . .     1 SYY  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 {ARO$(19,1)}
       6  ItemCodeDesc. . . . . . . . .    30 SNN  Item Code Description . . . . .DESCRIPTION
                                                    Notes: {ARO$(26,30)}
       7  ExtendedDescriptionKey. . . .    10 SYN  Extended Description Key. . . .EXTDESCKEY
                                                    Read Only:Y Notes: {ARO$(135,
                                                    1)}
       8  SalesAcctKey. . . . . . . . .     9 SYN  Sales Account Key . . . . . . .ACCOUNT
                                                    Notes: {ARO$(56,9)}
       9  CostOfGoodsSoldAcctKey. . . .     9 SYN  Cost of Goods Sold Account Key.ACCOUNT
                                                    Notes: {ARO$(65,9)}
      10  InventoryAcctKey. . . . . . .     9 SYN  Inventory Account Key . . . . .ACCOUNT
                                                    Notes: {ARO$(74,9)}
      11  UnitOfMeasure . . . . . . . .     4 SYN  Unit Of Measure . . . . . . . .UNITOFMEASURE
                                                    Notes: {ARO$(83,4)}
      12  SubjectToExemption. . . . . .     1 SYN  Subject To Exemption. . . . . .YESNO
                                                    DfltVal:N Valid:Y,N Notes:
                                                    {ARO$(87,1)}
      13  Commissionable. . . . . . . .     1 SYN  Commissionable. . . . . . . . .YESNO
                                                    DfltVal:N Valid:Y,N Notes:
                                                    {ARO$(88,1)}
      14  TaxClass. . . . . . . . . . .     2 SYN  Tax Class . . . . . . . . . . .TAXCLASS
                                                    Notes: {ARO$(89,2)}
      15  Discount. . . . . . . . . . .     1 SYY  Discount. . . . . . . . . . . .YESNO
                                                    DfltVal:N Valid:Y,N Notes:
                                                    {ARO$(40,1)}
      16  DropShip. . . . . . . . . . .     1 SYY  Drop Ship . . . . . . . . . . .YESNO
                                                    DfltVal:N Valid:Y,N Notes:
                                                    {ARO$(84,1)}
      17  WarehouseCode . . . . . . . .     3 SYN  Warehouse Code. . . . . . . . .WAREHOUSE
                                                    FmtType:CHARNUM Notes:
                                                    {ARO$(103,3)}
      18  PriceLevel. . . . . . . . . .     1 SYN  Price Level . . . . . . . . . .
                                                    Notes: {ARO$(106,1)}
      19  ProductLine . . . . . . . . .     4 SYN  Product Line. . . . . . . . . .PRODUCTLINE
                                                    FmtType:CHARNUM Notes:
                                                    {ARO$(108,4)}
      20  Valuation . . . . . . . . . .     1 SNN  Valuation . . . . . . . . . . .
                                                    Valid:1,2,3,4,5,6 Notes:
                                                    1=Standard, 2=Average,
                                                    3=Fifo, 4=Lifo, 5=Lot,
                                                    6=Serial
      21  PriceOverridden . . . . . . .     1 SYN  Price Overridden. . . . . . . .YESNO
                                                    DfltVal:N Valid:Y,N Notes:
                                                    {ARO$(112,1)}
      22  OrderWarehouse. . . . . . . .     3 SYN  Order Warehouse . . . . . . . .WAREHOUSE
                                                    FmtType:CHARNUM Notes:
                                                    {ARO$(113,3)}
      23  Revision. . . . . . . . . . .     3 SNN  Bill Revision Code. . . . . . .
      24  BillOption1 . . . . . . . . .     2 SYN  Bill Option 1 . . . . . . . . .BILLOPTION
                                                    FmtType:CHARNUM Notes:
                                                    {ARO$(117,2)}
      25  BillOption2 . . . . . . . . .     2 SYN  Bill Option 2 . . . . . . . . .BILLOPTION
                                                    FmtType:CHARNUM Notes:
                                                    {ARO$(119,2)}
      26  BillOption3 . . . . . . . . .     2 SYN  Bill Option 3 . . . . . . . . .BILLOPTION
                                                    FmtType:CHARNUM Notes:
                                                    {ARO$(121,2)}
      27  BillOption4 . . . . . . . . .     2 SYN  Bill Option 4 . . . . . . . . .BILLOPTION
                                                    FmtType:CHARNUM Notes:
                                                    {ARO$(123,2)}
      28  BillOption5 . . . . . . . . .     2 SYN  Bill Option 5 . . . . . . . . .BILLOPTION
                                                    FmtType:CHARNUM Notes:
                                                    {ARO$(125,2)}
      29  BillOption6 . . . . . . . . .     2 SYN  Bill Option 6 . . . . . . . . .BILLOPTION
                                                    FmtType:CHARNUM Notes:
                                                    {ARO$(127,2)}
      30  BillOption7 . . . . . . . . .     2 SYN  Bill Option 7 . . . . . . . . .BILLOPTION
                                                    FmtType:CHARNUM Notes:
                                                    {ARO$(129,2)}
      31  BillOption8 . . . . . . . . .     2 SYN  Bill Option 8 . . . . . . . . .BILLOPTION
                                                    FmtType:CHARNUM Notes:
                                                    {ARO$(131,2)}
      32  BillOption9 . . . . . . . . .     2 SYN  Bill Option 9 . . . . . . . . .BILLOPTION
                                                    FmtType:CHARNUM Notes:
                                                    {ARO$(133,2)}
      33  KitItem . . . . . . . . . . .     1 SYY  Kit Item. . . . . . . . . . . .YESNO
                                                    DfltVal:N Valid:Y,N Notes:
                                                    {ARO$(116,1)}
      34  ExplodedKitItem . . . . . . .     1 SYN  Exploded Kit Item . . . . . . .
                                                    DfltVal:N Valid:Y,N,C Notes:
                                                    Y=Yes, N=No, C=Component
                                                    {ARO$(145,1)}
      35  SkipPrintCompLine . . . . . .     1 SYY  Skip Print Of Component Lines .YESNO
                                                    DfltVal:N Valid:Y,N Notes:
                                                    {ARO$(147,1)}
      36  StandardKitBill . . . . . . .     1 SYY  Standard Kit Bill . . . . . . .YESNO
                                                    DfltVal:N Valid:Y,N Notes:
                                                    {ARO$(146,1)}
      37  AliasItemNo . . . . . . . . .    30 SYN  Alias Item Number . . . . . . .
                                                    Notes: {ARO$(158,30)}
      38  CustomerAction. . . . . . . .     1 SYN  Customer Action . . . . . . . .
                                                    DfltVal:N Valid:C,P,R,N
                                                    Notes: C=Credit, P=rePlacemen
                                                    t, R=Repair, N=None
                                                    {ARO$(188,1)}
      39  ItemAction. . . . . . . . . .     1 SYN  Item Action . . . . . . . . . .
                                                    DfltVal:N Valid:S,P,R,N
                                                    Notes: S=Stock, P=scraP,
                                                    R=Repair, N=None
      40  WarrantyCode. . . . . . . . .    10 SYN  Warranty Code . . . . . . . . .WARRANTYCODE
                                                    Notes: {ARO$(189,10)}
      41  ExpirationDate. . . . . . . .     8 SNN  Expiration Date . . . . . . . .DATE
                                                    Notes: {ARO$(199,6)}
      42  ExpirationOverridden. . . . .     1 SYY  Expiration Overridden . . . . .YESNO
                                                    DfltVal:N Valid:Y,N Notes:
                                                    {ARO$(205,1)}
      43  CostCode. . . . . . . . . . .     9 SYN  Cost Code . . . . . . . . . . .COSTCODE
                                                    FmtType:CHARNUM
      44  CostType. . . . . . . . . . .     1 SYN  Cost Type . . . . . . . . . . .COSTTYPE
                                                    Notes: {ARO$(107,1)}
      45  CommentText . . . . . . . . .  2048 SNN  Comment Text. . . . . . . . . .COMMENT
                                                    Notes: {ARO$(40,100)}
      46  PromiseDate . . . . . . . . .     8 SNN  Promise Date. . . . . . . . . .DATE
      47  QuantityShipped . . . . . . . 16.6  NNN  Quantity Shipped. . . . . . . .QUANTITY
                                                    Mask:##,###,###.000000-
                                                    Notes: {ARO[1]}
      48  QuantityOrdered . . . . . . . 16.6  NNN  Quantity Ordered. . . . . . . .QUANTITY
                                                    Mask:##,###,###.000000-
                                                    Notes: {ARO[0]}
      49  QuantityBackordered . . . . . 16.6  NNN  Quantity Backordered. . . . . .QUANTITY
                                                    Mask:##,###,###.000000-
                                                    Notes: {ARO[2]}
      50  UnitPrice . . . . . . . . . . 16.6  NNN  Unit Price. . . . . . . . . . .PRICE
                                                    Mask:##,###,###.000000-
                                                    Notes: {ARO[1]}
      51  UnitCost. . . . . . . . . . . 16.6  NNN  Unit Cost . . . . . . . . . . .COST
                                                    Mask:##,###,###.000000-
                                                    Notes: {ARO[2]}
      52  UnitOfMeasureConvFactor . . . 12.4  NNN  Unit Of Measure Conversion FactUMCONVFACTOR
                                                    Mask:#####0.0000 Notes:
                                                    {ARO[6]}
      53  CommissionAmt . . . . . . . . 13.2  NNN  Commission Amount . . . . . . .AMOUNT
                                                    Mask:###,###,###.00 Notes:
                                                    {ARO[7]}
      54  LineDiscountPercent . . . . .  9.3  NNN  Line Discount Percent . . . . .
                                                    Mask:###0.000 Notes:
                                                    {ARO$(73,7)}
      55  QuantityPerBill . . . . . . . 16.6  NNN  Quantity Per Bill . . . . . . .QUANTITY
                                                    Mask:##,###,###.000000-
                                                    Notes: {ARO$(148,10)}
      56  ExtensionAmt. . . . . . . . . 12.2  NNN  Extension Amount. . . . . . . .
                                                    Mask:##,###,###.00 Notes:
                                                    {ARO[3]}