77 lines
2.2 KiB
SQL
77 lines
2.2 KiB
SQL
create table ct_et_templates.w_ODS_TMS_ECBINSTRUMENTBONDCASHFLOW (
|
|
a_key number(38, 0),
|
|
a_workflow_history_key number(38, 0),
|
|
id varchar2(255 char),
|
|
type_id varchar2(255 char),
|
|
domain_id varchar2(255 char),
|
|
flags number(12, 0),
|
|
name varchar2(255 char),
|
|
layout_id varchar2(255 char),
|
|
active_since date,
|
|
active_until date,
|
|
buy_label varchar2(255 char),
|
|
sell_label varchar2(255 char),
|
|
path_id number(12, 0),
|
|
result_type_id varchar2(255 char),
|
|
template_id varchar2(255 char),
|
|
instrument_group varchar2(255 char),
|
|
umi_id varchar2(255 char),
|
|
currency_id varchar2(255 char),
|
|
issuer_id varchar2(255 char),
|
|
settlement_flags number(12, 0),
|
|
amount_rounding binary_double,
|
|
accrued_interest varchar2(255 char),
|
|
minimum_price_denom number(12, 0),
|
|
default_price_denom number(12, 0),
|
|
sign_id number(12, 0),
|
|
coupon_rate binary_double,
|
|
issuer_unit_id varchar2(255 char),
|
|
key_id number(12, 0),
|
|
cashflow_type_id number(12, 0),
|
|
subtype_id number(12, 0),
|
|
category_id number(12, 0),
|
|
value_date date,
|
|
date_basis varchar2(255 char),
|
|
fixing_price binary_double,
|
|
kinds number(12, 0),
|
|
cf_flags number(12, 0),
|
|
cf_flags_2 number(12, 0),
|
|
cf_keep_flags number(12, 0),
|
|
reference_id number(12, 0),
|
|
referee_id number(12, 0),
|
|
amount binary_double,
|
|
actual_currency_id varchar2(255 char),
|
|
actual_fx_rate binary_double,
|
|
actual_amount binary_double,
|
|
subcategory_id number(12, 0),
|
|
sign number(12, 0),
|
|
since_when date,
|
|
until_when date,
|
|
payment_date date,
|
|
realize_date date,
|
|
origin_id number(12, 0),
|
|
origin_value binary_double,
|
|
ex_date date,
|
|
reference_date date,
|
|
spread binary_double,
|
|
cashflow_group number(12, 0),
|
|
accrual_date_basis varchar2(255 char),
|
|
fixing_rate_id varchar2(255 char),
|
|
fixing_period_id varchar2(255 char),
|
|
fixing_period_2_id varchar2(255 char),
|
|
fixing_param binary_double,
|
|
fixing_subscenario_id varchar2(255 char),
|
|
fixing_date date,
|
|
fixing_from date,
|
|
fixing_to date,
|
|
fixing_price_2 binary_double,
|
|
fixing_quote binary_double,
|
|
fixing_type varchar2(255 char),
|
|
fixing_divider binary_double,
|
|
fixing_cap binary_double,
|
|
fixing_floor binary_double,
|
|
expression varchar2(255 char),
|
|
freeze_date date,
|
|
effective_fixing_date date
|
|
)
|