32 lines
890 B
SQL
32 lines
890 B
SQL
create table ct_et_templates.w_ODS_TMS_MOPDBPRICES (
|
|
a_key number(38, 0),
|
|
a_workflow_history_key number(38, 0),
|
|
target_date date,
|
|
type_id varchar2(255 char),
|
|
name_id varchar2(255 char),
|
|
id number(12, 0),
|
|
scenario_id varchar2(255 char),
|
|
subscenario_id varchar2(255 char),
|
|
source_id varchar2(255 char),
|
|
item varchar2(255 char),
|
|
mi_group varchar2(255 char),
|
|
currency_id varchar2(255 char),
|
|
period_from date,
|
|
period_to date,
|
|
period_id varchar2(255 char),
|
|
period_1_id varchar2(255 char),
|
|
period_2_id varchar2(255 char),
|
|
price_type varchar2(255 char),
|
|
date_basis varchar2(255 char),
|
|
date_ date,
|
|
date_time date,
|
|
price_1 binary_double,
|
|
price_2 binary_double,
|
|
bid binary_double,
|
|
ask binary_double,
|
|
maturity_date date,
|
|
security_identifier varchar2(255 char),
|
|
security_identifier_type varchar2(255 char),
|
|
instrument_group varchar2(255 char)
|
|
)
|