WHENEVER SQLERROR EXIT FAILURE ROLLBACK; WHENEVER OSERROR EXIT FAILURE ROLLBACK; spool vat_account_tmp.log PROMPT PROMPT CREATING TABLE TRAIN_CONFIG PROMPT ============================ PROMPT --增值税台账临时表 CREATE TABLE vat_account_tmp( vct_id NUMBER, session_id NUMBER, invoice_hd_id NUMBER, invoice_line_id NUMBER, contract_id NUMBER, cashflow_id NUMBER, invoice_kind VARCHAR2(100), tax_apply_month VARCHAR2(10), invoice_date DATE, invoice_number VARCHAR2(100), invoice_tax_amount NUMBER, apply_flag VARCHAR2(10), tenant_name VARCHAR2(1000), contract_number VARCHAR2(100), acr_tax_amount NUMBER, journal_tax_amount NUMBER, journal_month VARCHAR2(10), journal_date DATE, journal_num VARCHAR2(100), times VARCHAR2(100), due_date DATE, due_amount NUMBER, principal NUMBER, interest NUMBER, tax_amount NUMBER, created_by NUMBER default -1 not null, creation_date DATE default sysdate not null, last_updated_by NUMBER default -1 not null, last_update_date DATE default sysdate not NULL ); ALTER TABLE vat_account_tmp ADD DESCRIPTION VARCHAR2(1000); ALTER TABLE vat_account_tmp ADD cf_item NUMBER; CREATE SEQUENCE vat_account_tmp_s; SPOOL OFF EXIT