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