[Home] [Help] [Dependency Information]
Object Name: | DDR_B_MKT_ITEM_SLS_DAY# |
---|---|
Object Type: | VIEW |
Owner: | DDR |
Subobject Name: | |
Status: | VALID |
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
MFG_ORG_CD | VARCHAR2 | (30) | Yes | |
RTL_ORG_CD | VARCHAR2 | (30) | Yes | |
GLBL_ITEM_ID | VARCHAR2 | (30) | Yes | |
MKT_AREA_ID | NUMBER | Yes | ||
MKT_AREA_CD | VARCHAR2 | (30) | Yes | |
DAY_CD | VARCHAR2 | (30) | Yes | |
BSNS_UNIT_CD | VARCHAR2 | (30) | ||
GLBL_ITEM_ID_TYP | VARCHAR2 | (30) | ||
MKT_ITEM_ID | NUMBER | |||
UOM_CD | VARCHAR2 | (30) | ||
UOM_CD_PRMRY | VARCHAR2 | (30) | ||
UOM_CD_ALT | VARCHAR2 | (30) | ||
CRNCY_CD | VARCHAR2 | (30) | ||
REC_CURR_DT | DATE | |||
AVG_MMACV_SLS_RATE | NUMBER | |||
AVG_STORE_SELL_ITEM_QTY | NUMBER | |||
AVG_STORE_SELL_ITEM_QTY_PRMRY | NUMBER | |||
AVG_STORE_SELL_ITEM_QTY_ALT | NUMBER | |||
AVG_ACV_WGT_DSTRBTN_PCT | NUMBER | |||
AVG_WGT_PRICE_RDCTN_PCT | NUMBER | |||
SLS_QTY | NUMBER | |||
SLS_QTY_PRMRY | NUMBER | |||
SLS_QTY_ALT | NUMBER | |||
SLS_AMT | NUMBER | |||
SLS_AMT_LCL | NUMBER | |||
SLS_AMT_RPT | NUMBER | |||
NRML_QTY | NUMBER | |||
NRML_QTY_PRMRY | NUMBER | |||
NRML_QTY_ALT | NUMBER | |||
NRML_AMT | NUMBER | |||
NRML_AMT_LCL | NUMBER | |||
NRML_AMT_RPT | NUMBER | |||
SLS_PRICE_CUT_QTY | NUMBER | |||
SLS_PRICE_CUT_QTY_PRMRY | NUMBER | |||
SLS_PRICE_CUT_QTY_ALT | NUMBER | |||
SLS_PRICE_CUT_AMT | NUMBER | |||
SLS_PRICE_CUT_AMT_LCL | NUMBER | |||
SLS_PRICE_CUT_AMT_RPT | NUMBER | |||
MAIN_AD_QTY | NUMBER | |||
MAIN_AD_QTY_PRMRY | NUMBER | |||
MAIN_AD_QTY_ALT | NUMBER | |||
MAIN_AD_AMT | NUMBER | |||
MAIN_AD_AMT_LCL | NUMBER | |||
MAIN_AD_AMT_RPT | NUMBER | |||
SRC_SYS_IDNT | VARCHAR2 | (40) | Yes | |
SRC_SYS_DT | DATE | Yes | ||
CRTD_BY_DSR | VARCHAR2 | (30) | Yes | |
LAST_UPDT_BY_DSR | VARCHAR2 | (30) | Yes | |
CREATED_BY | NUMBER | (15) | Yes | |
CREATION_DATE | DATE | Yes | ||
LAST_UPDATED_BY | NUMBER | (15) | Yes | |
LAST_UPDATE_DATE | DATE | Yes | ||
LAST_UPDATE_LOGIN | NUMBER | (15) | Yes |
Cut, paste (and edit) the following text to query this object:
SELECT MFG_ORG_CD
, RTL_ORG_CD
, GLBL_ITEM_ID
, MKT_AREA_ID
, MKT_AREA_CD
, DAY_CD
, BSNS_UNIT_CD
, GLBL_ITEM_ID_TYP
, MKT_ITEM_ID
, UOM_CD
, UOM_CD_PRMRY
, UOM_CD_ALT
, CRNCY_CD
, REC_CURR_DT
, AVG_MMACV_SLS_RATE
, AVG_STORE_SELL_ITEM_QTY
, AVG_STORE_SELL_ITEM_QTY_PRMRY
, AVG_STORE_SELL_ITEM_QTY_ALT
, AVG_ACV_WGT_DSTRBTN_PCT
, AVG_WGT_PRICE_RDCTN_PCT
, SLS_QTY
, SLS_QTY_PRMRY
, SLS_QTY_ALT
, SLS_AMT
, SLS_AMT_LCL
, SLS_AMT_RPT
, NRML_QTY
, NRML_QTY_PRMRY
, NRML_QTY_ALT
, NRML_AMT
, NRML_AMT_LCL
, NRML_AMT_RPT
, SLS_PRICE_CUT_QTY
, SLS_PRICE_CUT_QTY_PRMRY
, SLS_PRICE_CUT_QTY_ALT
, SLS_PRICE_CUT_AMT
, SLS_PRICE_CUT_AMT_LCL
, SLS_PRICE_CUT_AMT_RPT
, MAIN_AD_QTY
, MAIN_AD_QTY_PRMRY
, MAIN_AD_QTY_ALT
, MAIN_AD_AMT
, MAIN_AD_AMT_LCL
, MAIN_AD_AMT_RPT
, SRC_SYS_IDNT
, SRC_SYS_DT
, CRTD_BY_DSR
, LAST_UPDT_BY_DSR
, CREATED_BY
, CREATION_DATE
, LAST_UPDATED_BY
, LAST_UPDATE_DATE
, LAST_UPDATE_LOGIN
FROM DDR.DDR_B_MKT_ITEM_SLS_DAY#;
|
|
|