     IM_TransactionDetail                IM Transaction Entry Detail       Rel: 4.40  Bld: 398  8/28/2009
     Bus Obj: IM_Transaction_bus,BC_CommonImport
     SQL Def: Y  SysDB: N                                  "MAS_"+%C$+"/IM"+%C$+"/IM_TransactionDetail.M4T"

     KPRIMARY: TransactionType+EntryNo+LineKey
     KDISPLAY: TransactionType+EntryNo+LineSeqNo+LineKey
     KITEM: ItemCode+TransactionType+EntryNo+LineKey

     Fld  Column Name                     M/L TUR  Description/Notes              Class

       1  TransactionType . . . . . . .     1 SNY  Transaction Type. . . . . . . .
                                                    Read Only:Y Valid:1,2,4,6,8
                                                    Notes: {IMH$(1,1)} 1=Sales,
                                                    2=Issue, 4=Transfer,
                                                    6=Adjustment, 8=Receipt
       2  EntryNo . . . . . . . . . . .     8 SYY  Entry Number. . . . . . . . . .
                                                    Read Only:Y Notes: {IMH$(2,
                                                    10)}
       3  LineKey . . . . . . . . . . .     6 SNY  Line Key. . . . . . . . . . . .
                                                    Read Only:Y
       4  LineSeqNo . . . . . . . . . .    14 SYY  Line Sequence Number. . . . . .
                                                    Read Only:Y
       5  ItemCode. . . . . . . . . . .    30 SYY  Item Code . . . . . . . . . . .ITEMCODE
                                                    Notes: {IMH$(13,15)}
       6  ProductLine . . . . . . . . .     4 SYN  Product Line. . . . . . . . . .PRODUCTLINE
                                                    Read Only:Y Notes: {IMH$(31,
                                                    4)}
       7  ProductType . . . . . . . . .     1 SNN  Product Type. . . . . . . . . .
                                                    Read Only:Y Valid:F,R,D,K
                                                    Notes: {IMH$(35,1)} (Finish,
                                                    Raw, Discount, Kit)
       8  Valuation . . . . . . . . . .     1 SNN  Valuation . . . . . . . . . . .
                                                    Read Only:Y Valid:1,2,3,4,5,
                                                    6 Notes: {IMH$(36,1)}
                                                    1=Standard, 2=average cost,
                                                    3=fifo, 4=lifo, 5=lot,
                                                    6=serial
       9  UnitOfMeasure . . . . . . . .     4 SYY  Unit Of Measure . . . . . . . .UNITOFMEASURE
                                                    ValGroup:ItemRequired Notes:
                                                    {IMH$(37,4)}
      10  AccountKey. . . . . . . . . .     9 SNN  Account Key . . . . . . . . . .ACCOUNT
                                                    DepVal:REQUIRED Notes:
                                                    {IMH$(41,9)}
      11  JobNo . . . . . . . . . . . .     7 SYN  Job Number. . . . . . . . . . .JOBNO
                                                    FmtType:CHARNUM DepVal:REQUIR
                                                    ED ValGroup:JCIntegrated,
                                                    ItemRequired Notes: {IMH$(52,
                                                    7)}
      12  CostCode. . . . . . . . . . .     9 SYN  Cost Code . . . . . . . . . . .COSTCODE
                                                    DepVal:REQUIRED ValGroup:JCIn
                                                    tegrated,ItemRequired
      13  CostType. . . . . . . . . . .     1 SYN  Cost Type . . . . . . . . . . .COSTTYPE
                                                    DepVal:REQUIRED ValGroup:JCIn
                                                    tegrated,ItemRequired Notes:
                                                    {IMH$(68,1)}
      14  WarehouseCode . . . . . . . .     3 SYY  Warehouse Code. . . . . . . . .WAREHOUSE
                                                    FmtType:CHARNUM ValGroup:Item
                                                    Required Notes: {IMH$(69,3)}
      15  AliasItemNo . . . . . . . . .    30 SYN  Alias Item Number . . . . . . .
                                                    Read Only:Y
      16  LotSerialFullyDistributed . .     1 SNN  Lot/Serial Fully Distributed. .YESNO
                                                    DfltVal:Y Valid:Y,N
      17  UnitPrice . . . . . . . . . . 16.6  NNN  Unit Price. . . . . . . . . . .PRICE
                                                    Mask:##,###,###.000000-
                                                    ValGroup:ItemRequired Notes:
                                                    {IMH[1]}
      18  TransactionQty. . . . . . . . 16.6  NNN  Transaction Quantity. . . . . .QUANTITY
                                                    Mask:##,###,###.000000-
                                                    ValGroup:ItemRequired Notes:
                                                    {IMH[2]}
      19  UnitCost. . . . . . . . . . . 16.6  NNN  Unit Cost . . . . . . . . . . .COST
                                                    Mask:##,###,###.000000-
                                                    Notes: {IMH[3]}
      20  ExtendedSalesAmt. . . . . . . 12.2  NNN  Extended Sales Amount . . . . .MISCAMOUNT
                                                    Mask:##,###,###.00- Notes:
                                                    {IMH[4]}
      21  ExtendedCost. . . . . . . . . 12.2  NNN  Extended Cost . . . . . . . . .COST
                                                    Mask:##,###,###.00-
      22  ExtendedNegQtyAdj . . . . . . 12.2  NNN  Extended Negative Quantity Adju
      23  UnitOfMeasureConvFactor . . . 12.4  NNN  Unit Of Measure Conversion FactUMCONVFACTOR
                                                    Read Only:Y Mask:#####0.0000