IM_ItemCustomerHistoryByPeriod IM Item Customer History By PeriRel: 4.40 Bld: 398 8/28/2009 Bus Obj: IM_ItemCustomerHistoryByPeriod_bus,SO_SalesJournal_upd,CI_CostRecalc_upd SQL Def: Y SysDB: N "MAS_"+%C$+"/IM"+%C$+"/IM_ItemCustomerHistoryByPeriod.M4T"
KPRIMARY: ARDivisionNo+CustomerNo+ShipToCode+ItemCode+FiscalCalYear+FiscalCalPeriod KITEMCUSTOMER: ItemCode+ARDivisionNo+CustomerNo+ShipToCode+FiscalCalYear+FiscalCalPeriod(**) **=Case S ensitive KITEMYEAR: ItemCode+FiscalCalYear+FiscalCalPeriod+ARDivisionNo+CustomerNo+ShipToCode KCUSTOMERSHIPTO: ARDivisionNo+CustomerNo+ShipToCode+FiscalCalYear+FiscalCalPeriod+ItemCode KCUSTOMERYEAR: ARDivisionNo+CustomerNo+FiscalCalYear+FiscalCalPeriod+ShipToCode+ItemCode KCUSTOMERITEM: ARDivisionNo+CustomerNo+ItemCode+FiscalCalYear+FiscalCalPeriod+ShipToCode KITEMBROWSE: ItemCode+FiscalCalYear+ARDivisionNo+CustomerNo+ShipToCode+FiscalCalPeriod KCUSTOMERBROWSE: ARDivisionNo+CustomerNo+FiscalCalYear+ItemCode+ShipToCode+FiscalCalPeriod
Fld Column Name M/L TUR Description/Notes Class
1 ARDivisionNo. . . . . . . . . 2 SNY AR Division Number. . . . . . .ARDIVISION Mask:00 Notes: {IM_13$(1,2)} 2 CustomerNo. . . . . . . . . . 20 SNY Customer Number . . . . . . . .CUSTOMERNO ChngTag:Replace1/ARDivisionNo $ Notes: {IM_13$(3,7)} 3 ShipToCode. . . . . . . . . . 4 SYN Ship To Code. . . . . . . . . .SHIPTO Notes: {IM_13$(10,4)} 4 ItemCode. . . . . . . . . . . 30 SYY Item Code . . . . . . . . . . .ITEMCODE ChngTag:Replace0 Notes: {IM_13$(14,15)} 5 FiscalCalYear . . . . . . . . 4 SNY Fiscal Calendar Year. . . . . .YEAR Mask:0000 Notes: {IM_13$(29, 4)} 6 FiscalCalPeriod . . . . . . . 2 SNY Fiscal Calendar Period. . . . .FISCALPERIOD Mask:00 7 QuantitySold. . . . . . . . . 16.6 NNN Quantity Sold . . . . . . . . .QUANTITY Read Only:Y Mask:##,###, ###.000000- ChngTag:Sum Notes: {IM_13[0]} 8 DollarsSold . . . . . . . . . 15.2 NNN Dollars Sold. . . . . . . . . . Read Only:Y Mask:##,###,###, ###.00- ChngTag:Sum Notes: {IM_13[13]} 9 CostOfGoodsSold . . . . . . . 15.2 NNN Cost Of Goods Sold. . . . . . . Read Only:Y Mask:##,###,###, ###.00- ChngTag:Sum Notes: {IM_13[26]} 10 QuantityReturned. . . . . . . 16.6 NNN Quantity Returned . . . . . . .QUANTITY Read Only:Y Mask:##,###, ###.000000- ChngTag:Sum Notes: {IM_13[39]} 11 DateUpdated . . . . . . . . . 8 SNY Last Update Date. . . . . . . .DATE Read Only:Y Notes: YYYYMMDD 12 TimeUpdated . . . . . . . . . 8 SNY Last Update Time. . . . . . . . Read Only:Y 13 UserUpdatedKey. . . . . . . . 10 SYY Last Update User ID . . . . . .USER Read Only:Y Mask:0000000000 FmtType:ZEROFILL