IM_ItemVendorHistoryByPeriod IM Item Vendor History By PeriodRel: 4.40 Bld: 398 8/28/2009
Bus Obj: IM_ItemVendorHistoryByPeriod_bus,PO_ReceiptRegister_upd,PO_ReturnRegister_upd,CI_CostRecalc_up
SQL Def: Y SysDB: N "MAS_"+%C$+"/IM"+%C$+"/IM_ItemVendorHistoryByPeriod.M4T"
KPRIMARY: APDivisionNo+VendorNo+ItemCode+FiscalCalYear+FiscalCalPeriod
KITEMVENDOR: ItemCode+APDivisionNo+VendorNo+FiscalCalYear+FiscalCalPeriod
KITEMYEAR: ItemCode+FiscalCalYear+FiscalCalPeriod+APDivisionNo+VendorNo
KVENDOR: APDivisionNo+VendorNo+FiscalCalYear+FiscalCalPeriod+ItemCode
KITEMBROWSE: ItemCode+FiscalCalYear+APDivisionNo+VendorNo+FiscalCalPeriod
KVENDORBROWSE: APDivisionNo+VendorNo+FiscalCalYear+ItemCode+FiscalCalPeriod
Fld Column Name M/L TUR Description/Notes Class
1 APDivisionNo. . . . . . . . . 2 SNY AP Division Number. . . . . . .APDIVISION
Mask:00 Notes: {IM_15$(1,2)}
2 VendorNo. . . . . . . . . . . 7 SYY Vendor Number . . . . . . . . .VENDORNO
ChngTag:Replace1/APDivisionNo
$ Notes: {IM_15$(3,7)}
3 ItemCode. . . . . . . . . . . 30 SYY Item Code . . . . . . . . . . .ITEMCODE
ChngTag:Replace0 Notes:
{IM_15$(10,15)}
4 FiscalCalYear . . . . . . . . 4 SNY Fiscal Calendar Year. . . . . .YEAR
Mask:0000 Notes: {IM_15$(25,
4)}
5 FiscalCalPeriod . . . . . . . 2 SNY Fiscal Calendar Period. . . . .FISCALPERIOD
Mask:00
6 QuantityReceived. . . . . . . 16.6 NNN Quantity Received . . . . . . .QUANTITY
Read Only:Y Mask:##,###,
###.000000- Notes: {IM_15[0]}
7 CostOfGoodsReceived . . . . . 15.2 NNN Cost Of Goods Received. . . . .
Read Only:Y Mask:##,###,###,
###.00- Notes: {IM_15[13]}
8 QuantityReturned. . . . . . . 16.6 NNN Quantity Returned . . . . . . .QUANTITY
Read Only:Y Mask:##,###,
###.000000- Notes: {IM_15[39]
}
9 DateUpdated . . . . . . . . . 8 SNY Last Update Date. . . . . . . .DATE
Read Only:Y Notes: YYYYMMDD
10 TimeUpdated . . . . . . . . . 8 SNY Last Update Time. . . . . . . .
Read Only:Y
11 UserUpdatedKey. . . . . . . . 10 SYY Last Update User ID . . . . . .USER
Read Only:Y Mask:0000000000
FmtType:ZEROFILL