167 lines
5.5 KiB
SQL
167 lines
5.5 KiB
SQL
create table ct_et_templates.w_ODS_TMS_RULES (
|
|
a_key number(38, 0),
|
|
a_workflow_history_key number(38, 0),
|
|
sdm_object_id number(12, 0),
|
|
sdm_key_id number(12, 0),
|
|
sdm_create_date date,
|
|
sdm_access_level number(12, 0),
|
|
sdm_active number(12, 0),
|
|
id varchar2(255 char),
|
|
number_ number(12, 0),
|
|
priority number(12, 0),
|
|
portfolio_id varchar2(255 char),
|
|
instrument_path_id varchar2(255 char),
|
|
status varchar2(255 char),
|
|
not_status varchar2(255 char),
|
|
cf_leg_path_id varchar2(255 char),
|
|
cf_flags varchar2(255 char),
|
|
cf_not_flags varchar2(255 char),
|
|
flags number(12, 0),
|
|
name varchar2(255 char),
|
|
client_id varchar2(255 char),
|
|
client_main_group_id varchar2(255 char),
|
|
client_group_id varchar2(255 char),
|
|
user_id varchar2(255 char),
|
|
currency_id varchar2(255 char),
|
|
currency_2_id varchar2(255 char),
|
|
instrument_id varchar2(255 char),
|
|
secondary_instrument_id varchar2(255 char),
|
|
package_main_type_id varchar2(255 char),
|
|
package_type_id varchar2(255 char),
|
|
issuer_id varchar2(255 char),
|
|
issuer_main_group_id varchar2(255 char),
|
|
issuer_group_id varchar2(255 char),
|
|
cp_client_id varchar2(255 char),
|
|
cp_client_main_group_id varchar2(255 char),
|
|
cp_client_group_id varchar2(255 char),
|
|
cp_portfolio_id varchar2(255 char),
|
|
broker_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),
|
|
param_0 varchar2(255 char),
|
|
param_1 varchar2(255 char),
|
|
param_2 varchar2(255 char),
|
|
param_3 varchar2(255 char),
|
|
param_4 varchar2(255 char),
|
|
param_5 varchar2(255 char),
|
|
param_6 varchar2(255 char),
|
|
param_7 varchar2(255 char),
|
|
param_8 varchar2(255 char),
|
|
param_9 varchar2(255 char),
|
|
param_10 varchar2(255 char),
|
|
param_11 varchar2(255 char),
|
|
param_12 varchar2(255 char),
|
|
param_13 varchar2(255 char),
|
|
param_14 varchar2(255 char),
|
|
param_15 varchar2(255 char),
|
|
param_16 varchar2(255 char),
|
|
param_17 varchar2(255 char),
|
|
param_18 varchar2(255 char),
|
|
param_19 varchar2(255 char),
|
|
contexts number(12, 0),
|
|
not_contexts number(12, 0),
|
|
transaction_flags number(12, 0),
|
|
transaction_not_flags number(12, 0),
|
|
sign_id varchar2(255 char),
|
|
type_id varchar2(255 char),
|
|
kind_id varchar2(255 char),
|
|
state_id varchar2(255 char),
|
|
cf_status number(12, 0),
|
|
cf_not_status number(12, 0),
|
|
cf_currency_id varchar2(255 char),
|
|
cf_payment_currency_id varchar2(255 char),
|
|
cf_sign varchar2(255 char),
|
|
cf_type_id number(12, 0),
|
|
cf_subtype_id number(12, 0),
|
|
cf_category_id varchar2(255 char),
|
|
cf_subcategory_id varchar2(255 char),
|
|
cf_leg_group number(12, 0),
|
|
cf_leg_id varchar2(255 char),
|
|
cf_branch0_id varchar2(255 char),
|
|
cf_branch1_id varchar2(255 char),
|
|
cf_branch2_id varchar2(255 char),
|
|
cf_branch3_id varchar2(255 char),
|
|
cf_branch4_id varchar2(255 char),
|
|
cf_flags_2 varchar2(255 char),
|
|
cf_not_flags_2 varchar2(255 char),
|
|
cf_kinds varchar2(255 char),
|
|
cf_not_kinds 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),
|
|
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),
|
|
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),
|
|
cf_branch10_id varchar2(255 char),
|
|
cf_branch11_id varchar2(255 char),
|
|
cf_branch12_id varchar2(255 char),
|
|
cf_branch13_id varchar2(255 char),
|
|
cf_branch14_id varchar2(255 char),
|
|
cf_branch15_id varchar2(255 char),
|
|
cf_branch16_id varchar2(255 char),
|
|
cf_branch17_id varchar2(255 char),
|
|
cf_branch18_id varchar2(255 char),
|
|
cf_branch19_id varchar2(255 char),
|
|
cf_branch20_id varchar2(255 char),
|
|
cf_branch21_id varchar2(255 char),
|
|
cf_branch22_id varchar2(255 char),
|
|
cf_branch23_id varchar2(255 char),
|
|
cf_branch24_id varchar2(255 char),
|
|
cf_branch25_id varchar2(255 char),
|
|
cf_branch26_id varchar2(255 char),
|
|
cf_branch27_id varchar2(255 char),
|
|
cf_branch28_id varchar2(255 char),
|
|
cf_branch29_id varchar2(255 char),
|
|
cf_branch30_id varchar2(255 char),
|
|
cf_branch31_id varchar2(255 char),
|
|
cf_branch32_id varchar2(255 char),
|
|
cf_branch33_id varchar2(255 char),
|
|
cf_branch34_id varchar2(255 char),
|
|
cf_branch35_id varchar2(255 char),
|
|
cf_branch36_id varchar2(255 char),
|
|
cf_branch37_id varchar2(255 char),
|
|
cf_branch38_id varchar2(255 char),
|
|
cf_branch39_id varchar2(255 char),
|
|
cf_branch5_id varchar2(255 char),
|
|
cf_branch6_id varchar2(255 char),
|
|
cf_branch7_id varchar2(255 char),
|
|
cf_branch8_id varchar2(255 char),
|
|
cf_branch9_id varchar2(255 char),
|
|
client_unit_id varchar2(255 char),
|
|
cp_client_unit_id varchar2(255 char),
|
|
issuer_unit_id varchar2(255 char),
|
|
cf_type_name varchar2(255 char)
|
|
)
|