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