IM_ItemTransactionRecalc IM Item Transaction Recalculation Rel: 4.40 Bld: 398 8/28/2009 Bus Obj: IM_ItemTransactionRecalc_bus SQL Def: Y SysDB: N "MAS_"+%C$+"/IM"+%C$+"/IM_ItemTransactionRecalc.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 2 WarehouseCode . . . . . . . . 3 SYY Warehouse Code. . . . . . . . .WAREHOUSE 3 TransactionDate . . . . . . . 8 SNY Transaction Date. . . . . . . .DATE 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 5 EntryNo . . . . . . . . . . . 10 SYY Entry Number. . . . . . . . . . FmtType:ZEROFILL 6 SequenceNo. . . . . . . . . . 6 SNY Sequence Number . . . . . . . . FmtType:ZEROFILL 7 IMTransactionEntryComment . . 30 SNN IM Transaction Entry Comment. .COMMENT30 8 APDivisionNo. . . . . . . . . 2 SNN AP Division Number. . . . . . .APDIVISION Mask:00 9 VendorNo. . . . . . . . . . . 7 SNN Vendor Number . . . . . . . . .VENDORNO 10 ARDivisionNo. . . . . . . . . 2 SNN AR Division Number. . . . . . .ARDIVISION Mask:00 11 CustomerNo. . . . . . . . . . 20 SNN Customer Number . . . . . . . .CUSTOMERNO 12 ReferenceDate . . . . . . . . 8 SNN Reference Date. . . . . . . . .DATE 13 FiscalCalYear . . . . . . . . 4 SNN Fiscal Calendar Year. . . . . .YEAR Mask:0000 14 FiscalCalPeriod . . . . . . . 2 SNN Fiscal Calendar Period. . . . .FISCALPERIOD Mask:00 15 ShipToCode. . . . . . . . . . 4 SNN Ship To Code. . . . . . . . . .SHIPTO 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- 18 UnitCost. . . . . . . . . . . 16.6 NNN Unit Cost . . . . . . . . . . .COST Read Only:Y Mask:##,###, ###.000000- 19 AllocatedCost . . . . . . . . 15.2 NNN Allocated Cost. . . . . . . . .IMCOST Read Only:Y 20 UnitPrice . . . . . . . . . . 16.6 NNN Unit Price. . . . . . . . . . .PRICE Read Only:Y Mask:##,###, ###.000000- 21 ExtendedPrice . . . . . . . . 15.2 NNN Extended Price. . . . . . . . . Read Only:Y 22 ExtendedCost. . . . . . . . . 15.2 NNN Extended Cost . . . . . . . . .IMCOST Read Only:Y 23 ExtendedStandardCost. . . . . 15.2 NNN Extended Standard Cost. . . . .IMCOST Read Only:Y 24 DateUpdated . . . . . . . . . 8 SNY Last Update Date. . . . . . . .DATE Read Only:Y 25 TimeUpdated . . . . . . . . . 8 SNY Last Update Time. . . . . . . . Read Only:Y 26 UserUpdatedKey. . . . . . . . 10 SYY Last Update User ID . . . . . .USER Read Only:Y Mask:0000000000