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