Here are some sample SQL*Loader scripts for the ce_statement_headers_int_all and ce_statement_lines_interface tables:
LOAD DATA REPLACE INTO TABLE ce.ce_statement_headers_int_all FIELDS TERMINATED BY ',' OPTIONALLY ENCLOSED BY '"' TRAILING NULLCOLS ( statement_number CHAR, bank_account_num CHAR, statement_date CHAR, bank_name CONSTANT 'Bank Name', bank_branch_name CONSTANT '', creation_date SYSDATE, last_update_date SYSDATE, control_begin_balance DECIMAL EXTERNAL, control_total_dr DECIMAL EXTERNAL, control_total_cr DECIMAL EXTERNAL, control_end_balance DECIMAL EXTERNAL, control_dr_line_count INTEGER EXTERNAL, control_cr_line_count INTEGER EXTERNAL, control_line_count INTEGER EXTERNAL, currency_code CONSTANT 'TTD', int_calc_balance DECIMAL EXTERNAL ) LOAD DATA REPLACE INTO TABLE ce.ce_statement_lines_interface FIELDS TERMINATED BY ',' OPTIONALLY ENCLOSED BY '"' TRAILING NULLCOLS ( bank_account_num CHAR, trx_date DATE, attribute1 CHAR, trx_code CHAR, bank_trx_number CHAR, amount DECIMAL EXTERNAL, attribute2 CHAR, trx_text CHAR, statement_number CHAR, line_number INTEGER EXTERNAL, original_amount DECIMAL EXTERNAL, currency_code CHAR, creation_date SYSDATE, last_update_date SYSDATE, charges_amount CONSTANT 0.00 )
0 Comments.