CSH_PAYMENT_REQ_LN.sql 1.34 KB
Newer Older
1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17
WHENEVER SQLERROR EXIT FAILURE ROLLBACK;
WHENEVER OSERROR  EXIT FAILURE ROLLBACK;

spool CON_CONTRACT.log

PROMPT
PROMPT CREATING TABLE TRAIN_CONFIG
PROMPT ============================
PROMPT
WHENEVER SQLERROR CONTINUE
 DROP TABLE CON_CONTRACT;
WHENEVER SQLERROR EXIT FAILURE ROLLBACK
BEGIN

alter table csh_payment_req_ln add (amount_vender number);
alter table csh_payment_req_ln add (amount_agent  number);
alter table csh_payment_req_ln add (down_payment_rushoff  number);
18 19 20 21 22 23 24 25
ALTER TABLE csh_payment_req_ln ADD bp_bank_full_name VARCHAR2(2000);
COMMENT ON COLUMN csh_payment_req_ln.bp_bank_full_name IS '应付我司开户行';
ALTER TABLE csh_payment_req_ln ADD vender_bank_full_name VARCHAR2(2000);
COMMENT ON COLUMN csh_payment_req_ln.vender_bank_full_name IS '厂商开户行';
ALTER TABLE csh_payment_req_ln ADD vender_bank_account_name VARCHAR2(2000);
COMMENT ON COLUMN csh_payment_req_ln.vender_bank_account_name IS '厂商账户名';
ALTER TABLE csh_payment_req_ln ADD vender_bank_account_number VARCHAR2(2000);
COMMENT ON COLUMN csh_payment_req_ln.vender_bank_account_number IS '厂商账户号';
26 27 28 29 30 31 32 33 34 35 36

comment on column csh_payment_req_ln.amount_vender is  '应付厂商金额';
comment on column csh_payment_req_ln.amount_agent is  '应付代理店金额';
comment on column csh_payment_req_ln.down_payment_rushoff is  '首付款抵冲金额';


end;

SPOOL OFF

EXIT