140 lines
4.2 KiB
SQL
140 lines
4.2 KiB
SQL
create table ct_et_templates.w_ODS_TMS_TRANSACTION (
|
|
a_key number(38, 0),
|
|
a_workflow_history_key number(38, 0),
|
|
last_log_id binary_double,
|
|
last_log_date date,
|
|
opening_date date,
|
|
date_ date,
|
|
value_date date,
|
|
maturity_date date,
|
|
maturity_code varchar2(255 char),
|
|
issuer_id varchar2(255 char),
|
|
amount binary_double,
|
|
book_value binary_double,
|
|
currency_id varchar2(255 char),
|
|
currency_2_id varchar2(255 char),
|
|
instrument_group varchar2(255 char),
|
|
instrument_id varchar2(255 char),
|
|
security_identifier varchar2(255 char),
|
|
portfolio_id varchar2(255 char),
|
|
number_ number(12, 0),
|
|
cp_client_id varchar2(255 char),
|
|
deal_price2 varchar2(255 char),
|
|
deal_rate binary_double,
|
|
type_id varchar2(255 char),
|
|
sign_id varchar2(255 char),
|
|
fx_rate varchar2(255 char),
|
|
fx_fwd_points varchar2(255 char),
|
|
state_id varchar2(255 char),
|
|
param_0 varchar2(255 char),
|
|
isin_code varchar2(255 char),
|
|
param_13 varchar2(255 char),
|
|
accrued_interest number(19,4),
|
|
agreed_amount binary_double,
|
|
amount_2 number(19,4),
|
|
audit_number number(12, 0),
|
|
batch_id number(12, 0),
|
|
cap binary_double,
|
|
closing_date date,
|
|
collateral_number number(12, 0),
|
|
comment_ varchar2(255 char),
|
|
comment_2 varchar2(255 char),
|
|
comment_3 varchar2(255 char),
|
|
comment_4 varchar2(255 char),
|
|
contexts varchar2(255 char),
|
|
cp_portfolio_id varchar2(255 char),
|
|
cp_trader_id varchar2(255 char),
|
|
cp_client_unit_id varchar2(255 char),
|
|
creator_tag varchar2(255 char),
|
|
date_basis varchar2(255 char),
|
|
date_basis_2 varchar2(255 char),
|
|
deal_price varchar2(255 char),
|
|
param_1 varchar2(255 char),
|
|
expiry_date date,
|
|
fx_finance_rate binary_double,
|
|
mattr_4 number(19,4),
|
|
face_amount number(19,4),
|
|
sattr_1 varchar2(255 char),
|
|
fixing_calendar varchar2(255 char),
|
|
fixing_calendar_2 varchar2(255 char),
|
|
fixing_offset number(12, 0),
|
|
fixing_offset_2 number(12, 0),
|
|
fixing_period varchar2(255 char),
|
|
fixing_period_2 varchar2(255 char),
|
|
fixing_rate varchar2(255 char),
|
|
fixing_rate_2 varchar2(255 char),
|
|
flags number(12, 0),
|
|
flags_2 number(12, 0),
|
|
flags_3 number(12, 0),
|
|
floor binary_double,
|
|
frequency number(12, 0),
|
|
frequency_2 number(12, 0),
|
|
idx binary_double,
|
|
index_ratio binary_double,
|
|
issue_index binary_double,
|
|
issuer_unit_id varchar2(255 char),
|
|
kind_id varchar2(255 char),
|
|
leg_1_id varchar2(255 char),
|
|
leg_2_id varchar2(255 char),
|
|
sattr_4 varchar2(255 char),
|
|
logical_number number(12, 0),
|
|
sattr_3 varchar2(255 char),
|
|
margin1 binary_double,
|
|
margin2 binary_double,
|
|
param_11 varchar2(255 char),
|
|
method_value varchar2(255 char),
|
|
method_value_2 varchar2(255 char),
|
|
param_9 varchar2(255 char),
|
|
nominal_rate binary_double,
|
|
nominal_rate_2 binary_double,
|
|
opening_time date,
|
|
iattr_6 varchar2(255 char),
|
|
param_10 varchar2(255 char),
|
|
param_4 varchar2(255 char),
|
|
owner_id varchar2(255 char),
|
|
owner_unit_id varchar2(255 char),
|
|
package_id number(12, 0),
|
|
package_main_type_id varchar2(255 char),
|
|
package_type_id varchar2(255 char),
|
|
param_18 varchar2(255 char),
|
|
param_3 varchar2(255 char),
|
|
param_5 varchar2(255 char),
|
|
param_6 varchar2(255 char),
|
|
param_7 varchar2(255 char),
|
|
param_8 varchar2(255 char),
|
|
param_19 varchar2(255 char),
|
|
parent_number number(12, 0),
|
|
sattr_13 varchar2(255 char),
|
|
pool_factor varchar2(255 char),
|
|
premium_amount number(19,4),
|
|
premium_currency_id varchar2(255 char),
|
|
premium_date date,
|
|
premium_price binary_double,
|
|
premium_type varchar2(255 char),
|
|
quote_currency_yield binary_double,
|
|
rate_type varchar2(255 char),
|
|
rate_type_2 varchar2(255 char),
|
|
reference_number number(12, 0),
|
|
param_2 varchar2(255 char),
|
|
secondary_instrument_id varchar2(255 char),
|
|
security_identifier_type varchar2(255 char),
|
|
param_16 varchar2(255 char),
|
|
settlement_date date,
|
|
signature_date date,
|
|
spread binary_double,
|
|
spread_2 binary_double,
|
|
state_id_sort_order number(12, 0),
|
|
status varchar2(255 char),
|
|
broker_id varchar2(255 char),
|
|
top_portfolio_id varchar2(255 char),
|
|
trader_id varchar2(255 char),
|
|
trading_unit binary_double,
|
|
sattr_2 varchar2(255 char),
|
|
param_12 varchar2(255 char),
|
|
param_14 varchar2(255 char),
|
|
param_15 varchar2(255 char),
|
|
param_17 varchar2(255 char),
|
|
transaction_tag varchar2(255 char),
|
|
units binary_double
|
|
)
|