vat_account_tmp.sql 1.31 KB
Newer Older
1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50 51
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