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