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