CSH_TRANSACTION.sql 1.7 KB
Newer Older
1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18
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));
19 20 21 22 23 24 25 26 27
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 '会计确认人 ';
28
comment on column CSH_TRANSACTION.PAID_BYOTHER_FLAG is '代付';
stone's avatar
stone committed
29 30 31 32 33 34
--将营业确认人改为债权确认人
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 '债权确认人';
35 36 37 38 39 40 41 42 43 44 45 46
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