CI_ItemTransactionHistory CI Item Transaction History Rel: 4.40 Bld: 398 8/28/2009 Bus Obj: CI_ItemTransactionHistory_bus,PO_ReturnRegister_upd,PO_ReceiptRegister_upd,BM_ProductionRegist SQL Def: Y SysDB: N "MAS_"+%C$+"/CI"+%C$+"/CI_ItemTransactionHistory.M4T"
kPRIMARY: ItemCode+TransactionDate+TransactionCode+EntryNo+SequenceNo kITEMYEARPER: ItemCode+FiscalCalYear+FiscalCalPeriod+TransactionDate+TransactionCode+EntryNo+SequenceNo kTRANDATE: TransactionDate+ItemCode+TransactionCode+EntryNo+SequenceNo kVENDOR: APDivisionNo+VendorNo+ItemCode+FiscalCalYear+FiscalCalPeriod+ShipToCode+TransactionDate+Transa ctionCode+EntryNo+SequenceNo kCUSTOMER: ARDivisionNo+CustomerNo+ItemCode+FiscalCalYear+FiscalCalPeriod+ShipToCode+TransactionDate+Tr ansactionCode+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 TransactionDate . . . . . . . 8 SNY Transaction Date. . . . . . . .DATE Notes: {IM5$(19,6)} 3 TransactionCode . . . . . . . 2 SYY Transaction Code. . . . . . . . Valid:AR,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)} 4 EntryNo . . . . . . . . . . . 10 SYY Entry Number. . . . . . . . . . FmtType:ZEROFILL Notes: {IM5$(27,10)} 5 SequenceNo. . . . . . . . . . 6 SNY Sequence Number . . . . . . . . Mask:000000 FmtType:ZEROFILL Notes: {IM5$(37,3)} 6 ItemType. . . . . . . . . . . 1 SNY Item Type . . . . . . . . . . . Read Only:Y Valid:2,3,5 Notes: 2=Special Item, 3=Charge Item, 5=Miscellaneou s Item 7 APDivisionNo. . . . . . . . . 2 SNN AP Division Number. . . . . . .APDIVISION Mask:00 Notes: {IM5$(55,2)} 8 VendorNo. . . . . . . . . . . 7 SNN Vendor Number . . . . . . . . .VENDORNO ChngTag:Replace1/APDivisionNo $ Notes: {IM5$(57,7)} 9 ARDivisionNo. . . . . . . . . 2 SNN AR Division Number. . . . . . .ARDIVISION Mask:00 Notes: {IM5$(55,2)} 10 CustomerNo. . . . . . . . . . 20 SNN Customer Number . . . . . . . .CUSTOMERNO ChngTag:Replace1/ARDivisionNo $ Notes: {IM5$(57,7)} 11 ReferenceDate . . . . . . . . 8 SNN Reference Date. . . . . . . . .DATE Notes: {IM5$(64,6)} 12 FiscalCalYear . . . . . . . . 4 SNN Fiscal Calendar Year. . . . . .YEAR Mask:0000 Notes: {IM5$(70,4)} 13 FiscalCalPeriod . . . . . . . 2 SNN Fiscal Calendar Period. . . . .FISCALPERIOD Mask:00 Notes: {IM5$(74,2)} 14 ShipToCode. . . . . . . . . . 4 SNN Ship To Code. . . . . . . . . .SHIPTO Notes: {IM5$(76,4)} 15 InvoiceType . . . . . . . . . 2 SNN Invoice Type. . . . . . . . . . Valid:CM,DM,IN,CA,AD 16 TransactionQty. . . . . . . . 16.6 NNN Transaction Quantity. . . . . .QUANTITY Read Only:Y Mask:##,###, ###.000000- ChngTag:Sum Notes: {IM5[0]} 17 UnitCost. . . . . . . . . . . 16.6 NNN Unit Cost . . . . . . . . . . .COST Read Only:Y Mask:##,###, ###.000000- Notes: {IM5[1]} 18 AllocatedCost . . . . . . . . 16.6 NNN Allocated Cost. . . . . . . . .COST Read Only:Y Mask:##,###, ###.000000- Notes: {IM5[2]} 19 UnitPrice . . . . . . . . . . 16.6 NNN Unit Price. . . . . . . . . . .PRICE Read Only:Y Mask:##,###, ###.000000- Notes: {IM5[3]} 20 ExtendedPrice . . . . . . . . 15.2 NNN Extended Price. . . . . . . . . Read Only:Y Mask:##,###,###, ###.00- ChngTag:Sum 21 ExtendedCost. . . . . . . . . 15.2 NNN Extended Cost . . . . . . . . .IMCOST Read Only:Y ChngTag:Sum 22 DateUpdated . . . . . . . . . 8 SNY Last Update Date. . . . . . . .DATE Read Only:Y Notes: YYYYMMDD 23 TimeUpdated . . . . . . . . . 8 SNY Last Update Time. . . . . . . . Read Only:Y 24 UserUpdatedKey. . . . . . . . 10 SYY Last Update User ID . . . . . .USER Read Only:Y Mask:0000000000 FmtType:ZEROFILL