112 lines
3.7 KiB
SQL
112 lines
3.7 KiB
SQL
create table ct_et_templates.w_ODS_TMS_RAR_LIMITLOG (
|
|
a_key number(38, 0),
|
|
a_workflow_history_key number(38, 0),
|
|
id varchar2(255 char),
|
|
date_ date,
|
|
time_utc date,
|
|
sublimit_id varchar2(255 char),
|
|
amount number(19,4),
|
|
old_amount number(19,4),
|
|
violation_type number(12, 0),
|
|
violation_p number(12, 0),
|
|
minimum_amount number(19,4),
|
|
maximum_amount number(19,4),
|
|
item_id number(12, 0),
|
|
number_ number(12, 0),
|
|
portfolio_id varchar2(255 char),
|
|
package_type_id varchar2(255 char),
|
|
package_id number(12, 0),
|
|
market_id varchar2(255 char),
|
|
instrument_id varchar2(255 char),
|
|
currency_id varchar2(255 char),
|
|
currency_class_id varchar2(255 char),
|
|
cp_client_id varchar2(255 char),
|
|
credit_client_id varchar2(255 char),
|
|
issuer_id varchar2(255 char),
|
|
underlying_issuer_id varchar2(255 char),
|
|
leg_id varchar2(255 char),
|
|
payment_date date,
|
|
bank_id varchar2(255 char),
|
|
account_id varchar2(255 char),
|
|
branch0_id varchar2(255 char),
|
|
branch1_id varchar2(255 char),
|
|
branch2_id varchar2(255 char),
|
|
branch3_id varchar2(255 char),
|
|
branch4_id varchar2(255 char),
|
|
branch5_id varchar2(255 char),
|
|
branch6_id varchar2(255 char),
|
|
branch7_id varchar2(255 char),
|
|
branch8_id varchar2(255 char),
|
|
branch9_id varchar2(255 char),
|
|
branch10_id varchar2(255 char),
|
|
branch11_id varchar2(255 char),
|
|
branch12_id varchar2(255 char),
|
|
branch13_id varchar2(255 char),
|
|
branch14_id varchar2(255 char),
|
|
branch15_id varchar2(255 char),
|
|
branch16_id varchar2(255 char),
|
|
branch17_id varchar2(255 char),
|
|
branch18_id varchar2(255 char),
|
|
branch19_id varchar2(255 char),
|
|
causing_number number(12, 0),
|
|
server_id varchar2(255 char),
|
|
delivery_gap_id varchar2(255 char),
|
|
maturity_gap_id varchar2(255 char),
|
|
risk_gap_id varchar2(255 char),
|
|
instrument_path varchar2(255 char),
|
|
affect_date date,
|
|
affect_gap_id varchar2(255 char),
|
|
branch20_id varchar2(255 char),
|
|
branch21_id varchar2(255 char),
|
|
branch22_id varchar2(255 char),
|
|
branch23_id varchar2(255 char),
|
|
branch24_id varchar2(255 char),
|
|
branch25_id varchar2(255 char),
|
|
branch26_id varchar2(255 char),
|
|
branch27_id varchar2(255 char),
|
|
branch28_id varchar2(255 char),
|
|
branch29_id varchar2(255 char),
|
|
branch30_id varchar2(255 char),
|
|
branch31_id varchar2(255 char),
|
|
branch32_id varchar2(255 char),
|
|
branch33_id varchar2(255 char),
|
|
branch34_id varchar2(255 char),
|
|
branch35_id varchar2(255 char),
|
|
branch36_id varchar2(255 char),
|
|
branch37_id varchar2(255 char),
|
|
branch38_id varchar2(255 char),
|
|
branch39_id varchar2(255 char),
|
|
client_group_id varchar2(255 char),
|
|
client_id varchar2(255 char),
|
|
client_main_group_id varchar2(255 char),
|
|
client_rating_code_id varchar2(255 char),
|
|
client_rating_id varchar2(255 char),
|
|
delivery_date date,
|
|
guarantee_level number(12, 0),
|
|
guarantee_param_0 varchar2(255 char),
|
|
guarantee_param_1 varchar2(255 char),
|
|
guarantee_param_2 varchar2(255 char),
|
|
guarantee_param_3 varchar2(255 char),
|
|
guarantee_param_4 varchar2(255 char),
|
|
guarantee_param_5 varchar2(255 char),
|
|
guarantee_param_6 varchar2(255 char),
|
|
guarantee_param_7 varchar2(255 char),
|
|
guarantee_param_8 varchar2(255 char),
|
|
guarantee_param_9 varchar2(255 char),
|
|
guarantee_type_id varchar2(255 char),
|
|
limit_currency_id varchar2(255 char),
|
|
log_id number(12, 0),
|
|
owner_id varchar2(255 char),
|
|
package_main_type_id varchar2(255 char),
|
|
parent_id varchar2(255 char),
|
|
risk_country_id varchar2(255 char),
|
|
umi_rating_code_id varchar2(255 char),
|
|
umi_rating_id varchar2(255 char),
|
|
underlying_instrument_id varchar2(255 char),
|
|
underlying_maturity_gap_id varchar2(255 char),
|
|
adjusted_risk_gap_id varchar2(255 char),
|
|
leg_group number(12, 0),
|
|
leg_path_id varchar2(255 char),
|
|
position_type varchar2(255 char)
|
|
)
|