CSH_TRANSACTION.sql 1.7 KB
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


ALTER TABLE CSH_TRANSACTION ADD (CONFIRMED_FLAG VARCHAR2(100));
ALTER TABLE CSH_TRANSACTION ADD (CONFIRMED_DATE DATE);
ALTER TABLE CSH_TRANSACTION ADD (CONFIRMED_BY NUMBER);
alter table CSH_TRANSACTION add (PAID_BYOTHER_FLAG varchar2(10));
alter table csh_transaction add (MKT_CONFIRMED_DATE  date);
alter table csh_transaction add (ACC_CONFIRMED_DATE   date);
alter table csh_transaction add (MKT_CONFIRMED_BY   varchar2(100));
alter table csh_transaction add (ACC_CONFIRMED_BY    varchar2(100));

comment on  column csh_transaction.MKT_CONFIRMED_DATE is '营业确认时间';
comment on  column csh_transaction.ACC_CONFIRMED_DATE is '会计确认时间';
comment on  column csh_transaction.MKT_CONFIRMED_BY is '营业确认人';
comment on  column csh_transaction.ACC_CONFIRMED_BY is '会计确认人 ';
comment on column CSH_TRANSACTION.PAID_BYOTHER_FLAG is '代付';
--将营业确认人改为债权确认人
ALTER TABLE csh_transaction RENAME COLUMN MKT_CONFIRMED_DATE TO DEBT_CONFIRMED_DATE;
ALTER TABLE csh_transaction RENAME COLUMN MKT_CONFIRMED_BY TO DEBT_CONFIRMED_BY;

comment on column csh_transaction.DEBT_CONFIRMED_DATE is '债权确认时间';
comment on column csh_transaction.DEBT_CONFIRMED_BY is '债权确认人';
COMMENT ON column CSH_TRANSACTION.CONFIRMED_DATE
  IS '确认时间';
COMMENT ON column CSH_TRANSACTION.CONFIRMED_FLAG
  IS '单据状态';
COMMENT ON column CSH_TRANSACTION.CONFIRMED_BY
  IS '确认人';



SPOOL OFF

EXIT