003 item price read data flow
DESCRIPTION
003 Item Price Read Data FlowTRANSCRIPT
-
SPM
SPD
SP_Item_?_Get where ? = BySegment, bydivision, )
SP.VW_ITEM SP.ITEM
JOB SP_SYS_POPULATE_DATA(SP.SP_SYS_POPULATE_ITEMS
IDS.ITEMIDS.Item_CategoryIDS.Catalog_Type
ITEM
ATT10Explosion
O.ItemO.CatogoryO.Catalog
Linked ServerIDS_ORA_RO
SP_Item_Price_Get(for one item at the time)
PRICE
O.NLSPO.DQP
SP_SYS_OraQueryLinked Server
ORA_RO
Item_Conversion
Item_Price
Local StorageReduce data amountCalc price on the fly
DM.Item_Convesion
FULL SYNCSP.SP_...
SP.ITEM_Price
FULL SYNCSP.SP_...
DM.UOM, UOM_Class,
Convesion,
DM.Item_Price
O.XXMCS_ICR_DETAILSJOB DM_ORA_DATA_GET
DM.SP_SYS_POPULATEDATA
JOB DM_ORA_DAiLY_GETSP.SP_Item_Price_PopulateFrom JOB DM_ORA_DAILY_GET
O.Units_Of_MeasureO.UOM_Class_Conversions
O.UOM_ConversionsO.apps.xxmcs_dqp
003_Item_Price_Read_Data_Flow.vsdxPage-1