127 lines
4.2 KiB
SQL
127 lines
4.2 KiB
SQL
create table ct_et_templates.w_ODS_TMS_SETTLEMENTLOG (
|
|
a_key number(38, 0),
|
|
a_workflow_history_key number(38, 0),
|
|
accepted_by varchar2(255 char),
|
|
action varchar2(255 char),
|
|
action_date date,
|
|
advice_type varchar2(255 char),
|
|
amount number(19,4),
|
|
cashflow_subtype_id number(12, 0),
|
|
cashflow_type_id number(12, 0),
|
|
code varchar2(255 char),
|
|
comment_ varchar2(255 char),
|
|
comment_1 varchar2(255 char),
|
|
comment_2 varchar2(255 char),
|
|
comment_3 varchar2(255 char),
|
|
comment_4 varchar2(255 char),
|
|
cp_client_id varchar2(255 char),
|
|
cp_client_unit_id varchar2(255 char),
|
|
currency_id varchar2(255 char),
|
|
date_time date,
|
|
delivery_units binary_double,
|
|
description varchar2(255 char),
|
|
error varchar2(255 char),
|
|
face_amount number(19,4),
|
|
flags number(12, 0),
|
|
group_id number(12, 0),
|
|
id number(12, 0),
|
|
instrument_id varchar2(255 char),
|
|
instrument_path_id number(12, 0),
|
|
last_user_id varchar2(255 char),
|
|
local_account_1_id varchar2(255 char),
|
|
local_account_2_id varchar2(255 char),
|
|
local_account_3_id varchar2(255 char),
|
|
local_account_4_id varchar2(255 char),
|
|
local_bank_1_id varchar2(255 char),
|
|
local_bank_2_id varchar2(255 char),
|
|
local_bank_1_swift_code varchar2(255 char),
|
|
local_bank_1_unit_id varchar2(255 char),
|
|
local_bank_2_swift_code varchar2(255 char),
|
|
local_bank_3_id varchar2(255 char),
|
|
local_bank_3_swift_code varchar2(255 char),
|
|
local_bank_4_id varchar2(255 char),
|
|
local_bank_4_swift_code varchar2(255 char),
|
|
local_client_id varchar2(255 char),
|
|
local_client_swift_code varchar2(255 char),
|
|
local_client_unit_id varchar2(255 char),
|
|
log_action varchar2(255 char),
|
|
log_caller varchar2(255 char),
|
|
log_date date,
|
|
log_event varchar2(255 char),
|
|
log_type varchar2(255 char),
|
|
log_user varchar2(255 char),
|
|
message_id varchar2(255 char),
|
|
message_type varchar2(255 char),
|
|
netting_criteria_id varchar2(255 char),
|
|
netting_cutoff_time date,
|
|
netting_flags number(12, 0),
|
|
netting_group_id varchar2(255 char),
|
|
netting_rule_id varchar2(255 char),
|
|
number_ number(12, 0),
|
|
on_behalf_account_id varchar2(255 char),
|
|
on_behalf_id varchar2(255 char),
|
|
on_behalf_swift_code varchar2(255 char),
|
|
orig_amount number(19,4),
|
|
orig_currency_id varchar2(255 char),
|
|
other_account_1_id varchar2(255 char),
|
|
other_account_2_id varchar2(255 char),
|
|
other_account_3_id varchar2(255 char),
|
|
other_account_4_id varchar2(255 char),
|
|
other_bank_1_id varchar2(255 char),
|
|
other_bank_1_swift_code varchar2(255 char),
|
|
other_bank_1_unit_id varchar2(255 char),
|
|
other_bank_2_id varchar2(255 char),
|
|
other_bank_2_swift_code varchar2(255 char),
|
|
other_bank_3_id varchar2(255 char),
|
|
other_bank_3_swift_code varchar2(255 char),
|
|
other_bank_4_id varchar2(255 char),
|
|
other_bank_4_swift_code varchar2(255 char),
|
|
other_client_id varchar2(255 char),
|
|
other_client_swift_code varchar2(255 char),
|
|
other_client_unit_id varchar2(255 char),
|
|
owner_id varchar2(255 char),
|
|
owner_unit_id varchar2(255 char),
|
|
param_0 varchar2(255 char),
|
|
param_1 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),
|
|
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),
|
|
payment_date date,
|
|
portfolio_id varchar2(255 char),
|
|
receiver varchar2(255 char),
|
|
related_funct_type varchar2(255 char),
|
|
related_message_type varchar2(255 char),
|
|
related_trmswift_id varchar2(255 char),
|
|
release_cutoff_time date,
|
|
sender varchar2(255 char),
|
|
settlement_client_id varchar2(255 char),
|
|
settlement_client_swift_code varchar2(255 char),
|
|
settlement_type_id varchar2(255 char),
|
|
sign number(12, 0),
|
|
source_type_id varchar2(255 char),
|
|
split_source_id number(12, 0),
|
|
state_id varchar2(255 char),
|
|
status_id varchar2(255 char),
|
|
trading_unit binary_double,
|
|
transfer_type varchar2(255 char),
|
|
trmswift_message varchar2(255 char),
|
|
trmswift_timestamp date,
|
|
uetr varchar2(255 char),
|
|
unique_id varchar2(255 char)
|
|
)
|