IM_ItemTransactionHistory IM Item Transaction History Rel: 4.40 Bld: 398 8/28/2009 Bus Obj: IM_ItemTransactionHistory_bus,IM_TransactionRegister_upd,PO_Mirror: IM_ItemTransactionRecalc SQL Def: Y SysDB: N "MAS_"+%C$+"/IM"+%C$+"/IM_ItemTransactionHistory.M4T"
KPRIMARY: ItemCode+WarehouseCode+TransactionDate+TransactionCode+EntryNo+SequenceNo KITEMYEARPER: ItemCode+FiscalCalYear+FiscalCalPeriod+WarehouseCode+TransactionDate+TransactionCode+Entr yNo+SequenceNo KTRANDATE: TransactionDate+ItemCode+WarehouseCode+TransactionCode+EntryNo+SequenceNo KVENDOR: APDivisionNo+VendorNo+ItemCode+FiscalCalYear+FiscalCalPeriod+ShipToCode+WarehouseCode+Transact ionDate+TransactionCode+EntryNo+SequenceNo KCUSTOMER: ARDivisionNo+CustomerNo+ItemCode+FiscalCalYear+FiscalCalPeriod+ShipToCode+WarehouseCode+Tran sactionDate+TransactionCode+EntryNo+SequenceNo
Fld Column Name M/L TUR Description/Notes Class
1 ItemCode. . . . . . . . . . . 30 SYY Item Code . . . . . . . . . . .ITEMCODE ChngTag:Replace0 Notes: (IM5$(1,15)} 2 WarehouseCode . . . . . . . . 3 SYY Warehouse Code. . . . . . . . .WAREHOUSE FmtType:CHARNUM Notes: (IM5$(16,3)} 3 TransactionDate . . . . . . . 8 SNY Transaction Date. . . . . . . .DATE Notes: (IM5$(19,6)} 4 TransactionCode . . . . . . . 2 SYY Transaction Code. . . . . . . . Valid:IC,BC,WC,BI,BR,BZ,IA, II,IN,IP,IR,IS,IT,IX,IZ,PM, PO,SI,SO,SK,WI,WR,PS,SP,SR, SS,PA,PZ,SZ,WZ Notes: (IM5$(25,2)} 5 EntryNo . . . . . . . . . . . 10 SYY Entry Number. . . . . . . . . . Notes: (IM5$(27,10)} 6 SequenceNo. . . . . . . . . . 6 SNY Sequence Number . . . . . . . . FmtType:ZEROFILL Notes: (IM5$(37,3)} 7 IMTransactionEntryComment . . 30 SNN IM Transaction Entry Comment. .COMMENT30 8 APDivisionNo. . . . . . . . . 2 SNN AP Division Number. . . . . . .APDIVISION Mask:00 Notes: (IM5$(55,2)} 9 VendorNo. . . . . . . . . . . 7 SNN Vendor Number . . . . . . . . .VENDORNO ChngTag:Replace1/APDivisionNo $ Notes: (IM5$(57,2)} 10 ARDivisionNo. . . . . . . . . 2 SNN AR Division Number. . . . . . .ARDIVISION Mask:00 Notes: (IM5$(55,2)} 11 CustomerNo. . . . . . . . . . 20 SNN Customer Number . . . . . . . .CUSTOMERNO ChngTag:Replace1/ARDivisionNo $ Notes: (IM5$(57,7)} 12 ReferenceDate . . . . . . . . 8 SNN Reference Date. . . . . . . . .DATE Notes: (IM5$(64,6)} 13 FiscalCalYear . . . . . . . . 4 SNN Fiscal Calendar Year. . . . . .YEAR Mask:0000 Notes: (IM5$(70,4)} 14 FiscalCalPeriod . . . . . . . 2 SNN Fiscal Calendar Period. . . . .FISCALPERIOD Mask:00 Notes: (IM5$(74,2)} 15 ShipToCode. . . . . . . . . . 4 SNN Ship To Code. . . . . . . . . .SHIPTO Notes: (IM5$(76,4)} 16 InvoiceType . . . . . . . . . 2 SNN Invoice Type. . . . . . . . . . Valid:CM,DM,IN,CA,AD 17 TransactionQty. . . . . . . . 16.6 NNN Transaction Quantity. . . . . .QUANTITY Read Only:Y Mask:##,###, ###.000000- ChngTag:Sum Notes: {IM5[0]} 18 UnitCost. . . . . . . . . . . 16.6 NNN Unit Cost . . . . . . . . . . .COST Read Only:Y Mask:##,###, ###.000000- Notes: {IM5[1]} 19 AllocatedCost . . . . . . . . 16.6 NNN Allocated Cost. . . . . . . . .IMCOST Read Only:Y Notes: {IM5[2]} 20 UnitPrice . . . . . . . . . . 16.6 NNN Unit Price. . . . . . . . . . .PRICE Read Only:Y Mask:##,###, ###.000000- Notes: {IM5[3]} 21 ExtendedPrice . . . . . . . . 15.2 NNN Extended Price. . . . . . . . . Read Only:Y Mask:##,###, ###.000000- ChngTag:Sum 22 ExtendedCost. . . . . . . . . 15.2 NNN Extended Cost . . . . . . . . .IMCOST Read Only:Y ChngTag:Sum 23 ExtendedStandardCost. . . . . 15.2 NNN Extended Standard Cost. . . . .IMCOST Read Only:Y ChngTag:Sum 24 DateUpdated . . . . . . . . . 8 SNY Last Update Date. . . . . . . .DATE 25 TimeUpdated . . . . . . . . . 8 SNY Last Update Time. . . . . . . . 26 UserUpdatedKey. . . . . . . . 10 SYY Last Update User ID . . . . . .USER Mask:0000000000