IM_ItemWhseHistoryByPeriod IM Item Warehouse History By PeriodRel: 4.40 Bld: 398 8/28/2009 Bus Obj: IM_ItemWhseHistoryByPeriod_bus,IM_TransactionRegister_upd,PO_ReceiptRegister_upd,PO_ReturnRegi SQL Def: Y SysDB: N "MAS_"+%C$+"/IM"+%C$+"/IM_ItemWhseHistoryByPeriod.M4T"
KPRIMARY: ItemCode+WarehouseCode+FiscalCalYear+FiscalCalPeriod KYEAR: FiscalCalYear+FiscalCalPeriod+ItemCode+WarehouseCode KITEMYEAR: ItemCode+FiscalCalYear+FiscalCalPeriod+WarehouseCode
Fld Column Name M/L TUR Description/Notes Class
1 ItemCode. . . . . . . . . . . 30 SYY Item Code . . . . . . . . . . .ITEMCODE ChngTag:Replace0 Notes: {IM9$(1,15)} 2 WarehouseCode . . . . . . . . 3 SNY Warehouse Code. . . . . . . . .WAREHOUSE FmtType:CHARNUM 3 FiscalCalYear . . . . . . . . 4 SNY Fiscal Calendar Year. . . . . .YEAR Mask:0000 Notes: {IM9$(19,4)} 4 FiscalCalPeriod . . . . . . . 2 SNY Fiscal Calendar Period. . . . .FISCALPERIOD Mask:00 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 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-12] } 10 CostOfGoodsReceived . . . . . 15.2 NNN Cost of Goods Received. . . . .IMCOST Read Only:Y ChngTag:Sum Notes: {IM_14 (13-25] } 11 QuantityProduced. . . . . . . 16.6 NNN Quantity Produced . . . . . . .QUANTITY Read Only:Y Mask:##,###, ###.000000- ChngTag:Sum Notes: {IM_14 (26-38] } 12 QuantityReturnedVendor. . . . 16.6 NNN Quantity Returned Vendor. . . .QUANTITY Read Only:Y Mask:##,###, ###.000000- ChngTag:Sum Notes: {IM_14 (39-51] } 13 QuantityIssued. . . . . . . . 16.6 NNN Quantity Issued . . . . . . . .QUANTITY Read Only:Y Mask:##,###, ###.000000- ChngTag:Sum Notes: {IMM (0-12] } 14 IssuesCost. . . . . . . . . . 15.2 NNN Issues Cost . . . . . . . . . .IMCOST Read Only:Y ChngTag:Sum Notes: {IMM (65-77] } 15 QuantityTransferred . . . . . 16.6 NNN Quantity Transferred. . . . . .QUANTITY Read Only:Y Mask:##,###, ###.000000- ChngTag:Sum Notes: {IMM (13-25] } Net Qty Transferred 16 QuantityTransferredOut. . . . 16.6 NNN Quantity Transferred Out. . . .QUANTITY Read Only:Y Mask:##,###, ###.000000- ChngTag:Sum 17 TransfersCost . . . . . . . . 15.2 NNN Transfers Cost. . . . . . . . .IMCOST Read Only:Y ChngTag:Sum Notes: {IMM [78-90] } 18 QuantityAdjusted. . . . . . . 16.6 NNN Quantity Adjusted . . . . . . .QUANTITY Read Only:Y Mask:##,###, ###.000000- ChngTag:Sum Notes: {IMM [26-38] } 19 AdjustmentsCost . . . . . . . 15.2 NNN Adjustments Cost. . . . . . . .IMCOST Read Only:Y ChngTag:Sum Notes: {IMM [91-103] } 20 QuantitySoldAsKits. . . . . . 16.6 NNN Quantity Sold As Kits . . . . .QUANTITY Read Only:Y Mask:##,###, ###.000000- ChngTag:Sum 21 DateUpdated . . . . . . . . . 8 SNY Last Update Date. . . . . . . .DATE Read Only:Y Notes: YYYYMMDD 22 TimeUpdated . . . . . . . . . 8 SNY Last Update Time. . . . . . . . Read Only:Y 23 UserUpdatedKey. . . . . . . . 10 SYY Last Update User ID . . . . . .USER Read Only:Y Mask:0000000000 FmtType:ZEROFILL