create table ct_et_templates.w_ODS_TMS_ACMENTRYSTATELEDGERGROUP ( a_key number(38, 0), a_workflow_history_key number(38, 0), acmaccount1_id_user varchar2(255 char), acmplcategory_id_user varchar2(255 char), acmaccount1_name varchar2(255 char), acmentry_account_id number(12, 0), accountingtreatment_name varchar2(255 char), acmmappingaction_id_user varchar2(255 char), acmentry_adj_discharge_date date, acmentry_aggregation_id number(12, 0), acmgroupingrule1_id_user varchar2(255 char), acmgroupingrule1_id number(12, 0), acmsign1_name varchar2(255 char), acmentry_bank_id varchar2(255 char), acmentry_bank_account varchar2(255 char), acmentry_bank_account_ccy_id varchar2(255 char), acmentry_account_holder_id varchar2(255 char), acmentry_acc_holder_code varchar2(255 char), acmentry_acc_holder_group_id varchar2(255 char), acmentry_batch_id number(12, 0), acmentry_book_value number(19,4), acmentry_booking_amount number(19,4), acmentry_booking_currency_id varchar2(255 char), acmentry_booking_date date, acmbookkeepingtype_id_user varchar2(255 char), acmentry_param_0 varchar2(255 char), acmentry_cmmse_id number(12, 0), acmentry_cmm_group_id number(12, 0), acmentry_cmm_payment_method_id varchar2(255 char), acmentry_cmm_reconciliation_id number(12, 0), acmcmmstate_id_user varchar2(255 char), ctb_category varchar2(255 char), acmentry_ctb_previous_date date, acmentry_ctb_sequence_id number(12, 0), acmctbtyperule_id_user varchar2(255 char), acmrevcancelstate2_id_user varchar2(255 char), acmentry_c_payment_date date, acmentry_figure_id varchar2(255 char), acmledger_chart_id number(12, 0), acmentry_classification_id varchar2(255 char), client_unit_relation_id varchar2(255 char), acmentry_continuation_number number(12, 0), acmcostcenter_id_user varchar2(255 char), acmhedgecostcat_id_user varchar2(255 char), acmentry_counterparty_id varchar2(255 char), acmentry_counterparty_code varchar2(255 char), acmentry_counterparty_group_id varchar2(255 char), acmcptyrelation_id_user varchar2(255 char), acmentry_counterparty_unit_id varchar2(255 char), acmentry_ccy_amount number(19,4), acmentry_ccy_booking_amount number(19,4), acmentry_ccy_group_id number(12, 0), acmentry_ccy_result number(19,4), ccy_grouping_rule varchar2(255 char), acmentry_ccy_grouping_rule_id number(12, 0), ccy_position varchar2(255 char), ccy_state varchar2(255 char), acmdrcr_id_user varchar2(255 char), acmentry_date_basis varchar2(255 char), acmentry_deal_price binary_double, acmentry_deal_rate binary_double, acmentry_description varchar2(255 char), acmentry_amount number(19,4), acmentry_currency_id varchar2(255 char), acmaccount1_erp_account varchar2(255 char), acmentry_param_1 varchar2(255 char), acmentry_id number(12, 0), acmentrytype_id_user varchar2(255 char), acmvouchertype2_id_user varchar2(255 char), acmentry_event_date date, acmentry_event_id number(12, 0), acmeventtype_id_user varchar2(255 char), acmentry_export_id number(12, 0), acmentry_facility_id varchar2(255 char), acmentry_fac_rep_group varchar2(255 char), acmentry_figure_amount number(19,4), acmentry_figure_booking_amount number(19,4), acmentry_flags varchar2(255 char), acmentry_flags_2 varchar2(255 char), acmentry_fx_rate binary_double, acmsign2_name varchar2(255 char), acmgroupingrule2_id_user varchar2(255 char), acmgroupingrule2_id number(12, 0), acmentry_hedge_book_eff_bal number(19,4), acmentry_hedge_book_ineff_bal number(19,4), hedgededesignationtype_name varchar2(255 char), acmentry_hedge_design_percent number(19,4), acmentry_hedge_doc_eff_bal number(19,4), acmentry_hedge_doc_ineff_bal number(19,4), acmhedgeeffcat_id_user varchar2(255 char), acmentry_hedge_eff_percent binary_double, acmhedgequalifcat_id_user varchar2(255 char), acmhedgelegcat_id_user varchar2(255 char), acmentry_hedge_risk varchar2(255 char), acmentry_hedge_strategy_code varchar2(255 char), acmentry_hedge_id number(12, 0), acmentry_hedge_test_method varchar2(255 char), acmentry_hedge_type varchar2(255 char), acmentry_instrument_id varchar2(255 char), umpathnode_upath varchar2(255 char), umpathnode_id varchar2(255 char), acmentry_issuer_id varchar2(255 char), acmentry_issuer_group_id varchar2(255 char), acmentry_issuer_unit_id varchar2(255 char), acmledger_id_user varchar2(255 char), acmentry_ledger_id number(12, 0), acmentry_leg_id varchar2(255 char), acmentry_leg_group number(12, 0), acmentry_load_id number(12, 0), acmentry_logical_reference_id varchar2(255 char), acmentry_mapping_description varchar2(255 char), acmmappingrule_id_user varchar2(255 char), acmmappingrule_id number(12, 0), acmentry_match_id number(12, 0), acmentry_modification_time date, acmentry_n_option_date date, acmentry_nominal_amount number(19,4), acmentry_one_time_cpty_id varchar2(255 char), option_sign varchar2(255 char), acmentryorigin_id_user varchar2(255 char), acmentryoriginentity_id_user varchar2(255 char), acmentryorigingroup_id_user varchar2(255 char), acmentry_original_amount number(19,4), acmentry_orig_booking_amount number(19,4), original_time_band varchar2(255 char), acmentrystate2_id_user varchar2(255 char), acmentry_owner_unit_id varchar2(255 char), acmentry_package_map_id number(12, 0), acmentry_package_type_id varchar2(255 char), acmentry_param_10 varchar2(255 char), acmentry_param_11 varchar2(255 char), acmentry_param_12 varchar2(255 char), acmentry_param_13 varchar2(255 char), acmentry_param_14 varchar2(255 char), acmentry_param_15 varchar2(255 char), acmentry_param_17 varchar2(255 char), acmentry_param_18 varchar2(255 char), acmentry_param_19 varchar2(255 char), acmentry_param_5 varchar2(255 char), acmentry_param_6 varchar2(255 char), acmentry_param_7 varchar2(255 char), acmentry_param_8 varchar2(255 char), acmentry_param_9 varchar2(255 char), acmentry_parent_id number(12, 0), acmentry_pase_id number(12, 0), acmperiod_id_user varchar2(255 char), acmentry_portfolio_id varchar2(255 char), acmentry_pre_voucher_id number(12, 0), acmentry_param_16 varchar2(255 char), acmproject_id_user varchar2(255 char), acmentry_reference_date date, acmentry_number number(12, 0), repccy varchar2(255 char), reportccyamount number(19,4), report_owner_unit_group_id varchar2(255 char), acmvoucher_req_booking_date date, acmvoucher_reversal_bundle_id number(12, 0), acmentry_reverse_event_id number(12, 0), acmrevcancelstate1_id_user varchar2(255 char), acmvoucher_rev_voucher_id number(12, 0), acmaccount2_id_user varchar2(255 char), acmentry_secondary_account_id number(12, 0), acmentry_source_reference varchar2(255 char), acmspecialtreatment_id_user varchar2(255 char), acmrebookingtype_id_user varchar2(255 char), acmentrystate1_id_user varchar2(255 char), acmentry_status number(12, 0), acmentry_tag varchar2(255 char), acmentry_t_currency_id varchar2(255 char), acmentry_t_currency_2_id varchar2(255 char), transactionkind_name varchar2(255 char), acmentry_t_maturity_date date, acmentry_t_opening_date date, acmentry_param_3 varchar2(255 char), acmentry_param_4 varchar2(255 char), acmtransactionsign_name varchar2(255 char), transactiontype_name varchar2(255 char), acmentry_t_value_date date, acmvoucher_bundle_id number(12, 0), valuationhierarchy_name varchar2(255 char), acmcmmviewtype_id_user varchar2(255 char), acmvoucher_booking_date date, acmvoucher_flags varchar2(255 char), acmvoucher_modification_time date, acmvoucher_voucher_number varchar2(255 char), acmvoucher_posting_date date, acmrevcancelstate3_id_user varchar2(255 char), acmvoucherstate_id_user varchar2(255 char), acmentry_voucher_id number(12, 0), acmvouchertype_id_user varchar2(255 char), acmentry_param_2 varchar2(255 char) )