[Home] [Help] [Dependency Information]
Object Name: | T_SRC_SALES_TMPL# |
---|---|
Object Type: | VIEW |
Owner: | MSD |
Subobject Name: | |
Status: | VALID |
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
T_EP_P1 | VARCHAR2 | (100) | ||
T_EP_LR1 | VARCHAR2 | (100) | ||
T_EP_LS1 | VARCHAR2 | (100) | ||
ACTUAL_QTY | NUMBER | (20) | ||
BASE_EVT_DOL_RTL | NUMBER | (20) | ||
INCR_EVT_DOL_RTL | NUMBER | (20) | ||
ITEM_PRICE | NUMBER | (20) | ||
SALES_DATE | DATE | |||
SDATA10 | NUMBER | (20) | ||
SDATA11 | NUMBER | (20) | ||
SDATA12 | NUMBER | (20) | ||
SDATA13 | NUMBER | (20) | ||
SDATA14 | NUMBER | (20) | ||
SDATA4 | NUMBER | (20) | ||
SDATA5 | NUMBER | (20) | ||
SDATA6 | NUMBER | (20) | ||
SDATA7 | NUMBER | (20) | ||
SDATA8 | NUMBER | (20) | ||
SDATA9 | NUMBER | (20) | ||
SHELF_PRICE_SD | NUMBER | (20) | ||
T_EP_M1 | VARCHAR2 | (100) | ||
T_EP_M2 | VARCHAR2 | (100) | ||
SDATA15 | NUMBER | (20) | ||
DM_ITEM_CODE | VARCHAR2 | (240) | ||
DM_ORG_CODE | VARCHAR2 | (240) | ||
DM_SITE_CODE | VARCHAR2 | (240) | ||
E1_ITEM_BRANCH_CATEGORY_1 | VARCHAR2 | (100) | ||
E1_ITEM_BRANCH_CATEGORY_2 | VARCHAR2 | (100) | ||
E1_ITEM_BRANCH_CATEGORY_3 | VARCHAR2 | (100) | ||
E1_ITEM_BRANCH_CATEGORY_4 | VARCHAR2 | (100) | ||
E1_ITEM_BRANCH_CATEGORY_5 | VARCHAR2 | (100) | ||
E1_ITEM_BRANCH_CATEGORY_6 | VARCHAR2 | (100) | ||
E1_ITEM_BRANCH_CATEGORY_7 | VARCHAR2 | (100) | ||
E1_ITEM_BRANCH_CATEGORY_8 | VARCHAR2 | (100) | ||
E1_ITEM_BRANCH_CATEGORY_9 | VARCHAR2 | (100) | ||
E1_ITEM_BRANCH_CATEGORY_10 | VARCHAR2 | (100) | ||
E1_ITEM_BRANCH_CATEGORY_11 | VARCHAR2 | (100) | ||
E1_ITEM_BRANCH_CATEGORY_12 | VARCHAR2 | (100) | ||
E1_ITEM_BRANCH_CATEGORY_13 | VARCHAR2 | (100) | ||
E1_ITEM_BRANCH_CATEGORY_14 | VARCHAR2 | (100) | ||
E1_ITEM_BRANCH_CATEGORY_15 | VARCHAR2 | (100) | ||
E1_ITEM_BRANCH_CATEGORY_16 | VARCHAR2 | (100) | ||
E1_ITEM_BRANCH_CATEGORY_17 | VARCHAR2 | (100) | ||
E1_ITEM_BRANCH_CATEGORY_18 | VARCHAR2 | (100) | ||
E1_ITEM_BRANCH_CATEGORY_19 | VARCHAR2 | (100) | ||
E1_ITEM_BRANCH_CATEGORY_20 | VARCHAR2 | (100) | ||
E1_ITEM_BRANCH_CATEGORY_21 | VARCHAR2 | (100) | ||
E1_ITEM_BRANCH_CATEGORY_22 | VARCHAR2 | (100) | ||
E1_ITEM_BRANCH_CATEGORY_23 | VARCHAR2 | (100) | ||
EBS_DEMAND_CLASS_CODE | VARCHAR2 | (240) | ||
EBS_SALES_CHANNEL_CODE | VARCHAR2 | (240) | ||
EBS_BOOK_HIST_BOOK_QTY_BD | NUMBER | (20) | ||
EBS_BOOK_HIST_REQ_QTY_BD | NUMBER | (20) | ||
EBS_BOOK_HIST_BOOK_QTY_RD | NUMBER | (20) | ||
EBS_BOOK_HIST_REQ_QTY_RD | NUMBER | (20) | ||
EBS_SHIP_HIST_SHIP_QTY_SD | NUMBER | (20) | ||
EBS_SHIP_HIST_SHIP_QTY_RD | NUMBER | (20) | ||
EBS_SHIP_HIST_REQ_QTY_RD | NUMBER | (20) | ||
EBS_ITEM_SR_PK | NUMBER | |||
EBS_ORG_SR_PK | NUMBER | |||
EBS_SITE_SR_PK | NUMBER | |||
EBS_DEMAND_CLASS_SR_PK | VARCHAR2 | (100) | ||
EBS_SALES_CHANNEL_SR_PK | VARCHAR2 | (100) | ||
DM_PARENT_ITEM_CODE | VARCHAR2 | (240) | ||
CTO_PLN_PCT | NUMBER | (20) | ||
EBS_PARENT_ITEM_SR_PK | NUMBER | |||
EBS_BASE_MODEL_SR_PK | NUMBER | |||
EBS_PARENT_ITEM_CODE | VARCHAR2 | (240) | ||
EBS_BASE_MODEL_CODE | VARCHAR2 | (240) | ||
COMPONENT_CODE | VARCHAR2 | (2000) | ||
COMPONENT_CODE_LEGACY | VARCHAR2 | (4000) |
Cut, paste (and edit) the following text to query this object:
SELECT T_EP_P1
, T_EP_LR1
, T_EP_LS1
, ACTUAL_QTY
, BASE_EVT_DOL_RTL
, INCR_EVT_DOL_RTL
, ITEM_PRICE
, SALES_DATE
, SDATA10
, SDATA11
, SDATA12
, SDATA13
, SDATA14
, SDATA4
, SDATA5
, SDATA6
, SDATA7
, SDATA8
, SDATA9
, SHELF_PRICE_SD
, T_EP_M1
, T_EP_M2
, SDATA15
, DM_ITEM_CODE
, DM_ORG_CODE
, DM_SITE_CODE
, E1_ITEM_BRANCH_CATEGORY_1
, E1_ITEM_BRANCH_CATEGORY_2
, E1_ITEM_BRANCH_CATEGORY_3
, E1_ITEM_BRANCH_CATEGORY_4
, E1_ITEM_BRANCH_CATEGORY_5
, E1_ITEM_BRANCH_CATEGORY_6
, E1_ITEM_BRANCH_CATEGORY_7
, E1_ITEM_BRANCH_CATEGORY_8
, E1_ITEM_BRANCH_CATEGORY_9
, E1_ITEM_BRANCH_CATEGORY_10
, E1_ITEM_BRANCH_CATEGORY_11
, E1_ITEM_BRANCH_CATEGORY_12
, E1_ITEM_BRANCH_CATEGORY_13
, E1_ITEM_BRANCH_CATEGORY_14
, E1_ITEM_BRANCH_CATEGORY_15
, E1_ITEM_BRANCH_CATEGORY_16
, E1_ITEM_BRANCH_CATEGORY_17
, E1_ITEM_BRANCH_CATEGORY_18
, E1_ITEM_BRANCH_CATEGORY_19
, E1_ITEM_BRANCH_CATEGORY_20
, E1_ITEM_BRANCH_CATEGORY_21
, E1_ITEM_BRANCH_CATEGORY_22
, E1_ITEM_BRANCH_CATEGORY_23
, EBS_DEMAND_CLASS_CODE
, EBS_SALES_CHANNEL_CODE
, EBS_BOOK_HIST_BOOK_QTY_BD
, EBS_BOOK_HIST_REQ_QTY_BD
, EBS_BOOK_HIST_BOOK_QTY_RD
, EBS_BOOK_HIST_REQ_QTY_RD
, EBS_SHIP_HIST_SHIP_QTY_SD
, EBS_SHIP_HIST_SHIP_QTY_RD
, EBS_SHIP_HIST_REQ_QTY_RD
, EBS_ITEM_SR_PK
, EBS_ORG_SR_PK
, EBS_SITE_SR_PK
, EBS_DEMAND_CLASS_SR_PK
, EBS_SALES_CHANNEL_SR_PK
, DM_PARENT_ITEM_CODE
, CTO_PLN_PCT
, EBS_PARENT_ITEM_SR_PK
, EBS_BASE_MODEL_SR_PK
, EBS_PARENT_ITEM_CODE
, EBS_BASE_MODEL_CODE
, COMPONENT_CODE
, COMPONENT_CODE_LEGACY
FROM MSD.T_SRC_SALES_TMPL#;
|
|
|