CI_ItemHistoryByPeriod CI Item History By Period Rel: 4.40 Bld: 398 8/28/2009 Bus Obj: CI_ItemCodeHistory_bus,SO_SalesJournal_upd,AR_SalesJournal_upd,PO_ReceiptRegister_upd,PO_Retur SQL Def: Y SysDB: N "MAS_"+%C$+"/CI"+%C$+"/CI_ItemHistoryByPeriod.M4T"
KPRIMARY: ItemCode+FiscalCalYear+FiscalCalPeriod KALTERNATE: FiscalCalYear+FiscalCalPeriod+ItemCode
Fld Column Name M/L TUR Description/Notes Class
1 ItemCode. . . . . . . . . . . 30 SYY Item Code . . . . . . . . . . .ITEMCODE ChngTag:Replace0 Notes: {IM_14$(1,15) } IMM and IM9 contain duplicate data for (1,15) 2 FiscalCalYear . . . . . . . . 4 SNY Fiscal Calendar Year. . . . . .YEAR Mask:0000 Notes: Notes: { IM_14$ (16,3) } IMM and IM9 contain duplicate data for (16,3) 3 FiscalCalPeriod . . . . . . . 2 SNN Fiscal Calendar Period. . . . .FISCALPERIOD Mask:00 4 ItemType. . . . . . . . . . . 1 SYY Item Type . . . . . . . . . . . Valid:3,5 Notes: Note: 3=Charge Item, 5=Miscellaneou s Item 5 QuantitySold. . . . . . . . . 16.6 NNN Quantity Sold . . . . . . . . .QUANTITY Read Only:Y Mask:##,###, ###.000000- ChngTag:Sum Notes: {IM9[0-12] } 6 DollarsSold . . . . . . . . . 15.2 NNN Dollars Sold. . . . . . . . . .IMCOST Read Only:Y ChngTag:Sum Notes: {IM9[13-25] } 7 CostOfGoodsSold . . . . . . . 15.2 NNN Cost Of Goods Sold. . . . . . .IMCOST Read Only:Y Mask:##,###,###, ###.00- ChngTag:Sum Notes: {IM9 [26-38] } 8 QuantityReturnedCustomer. . . 16.6 NNN Quantity Returned Customer. . .QUANTITY Read Only:Y Mask:##,###, ###.000000- ChngTag:Sum Notes: {IM9 [39-51] } 9 QuantityReceived. . . . . . . 16.6 NNN Quantity Received . . . . . . .QUANTITY Read Only:Y Mask:##,###, ###.000000- ChngTag:Sum Notes: {IM_14[0-13] } 10 ReceivedCost. . . . . . . . . 15.2 NNN Received Cost . . . . . . . . .IMCOST Read Only:Y ChngTag:Sum Notes: {IM_14[13-25] } 11 QuantityReturnedVendor. . . . 16.6 NNN Quantity Returned Vendor. . . .QUANTITY Read Only:Y Mask:##,###, ###.000000- ChngTag:Sum Notes: {IM_14[39-51]} 12 QuantityIssued. . . . . . . . 16.6 NNN Quantity Issued . . . . . . . .QUANTITY Read Only:Y Mask:##,###, ###.000000- 13 IssuesCost. . . . . . . . . . 15.2 NNN Issues Cost . . . . . . . . . .IMCOST Read Only:Y 14 DateUpdated . . . . . . . . . 8 SNY Date Updated. . . . . . . . . .DATE Read Only:Y Notes: YYYYMMDD 15 TimeUpdated . . . . . . . . . 8 SNY Time Updated. . . . . . . . . . Read Only:Y 16 UserUpdatedKey. . . . . . . . 10 SYY Last Updated User ID. . . . . .USER Read Only:Y Mask:0000000000 FmtType:ZEROFILL