CSH_TRANSACTION.SQL 775 Bytes
Newer Older
1 2 3 4 5 6 7 8 9 10 11 12 13 14 15

alter table CSH_TRANSACTION add (transfer_amount  number);
comment on column CSH_TRANSACTION.transfer_amount is '已划转金额(hlcm保证金)';

alter table CSH_TRANSACTION add (offset_amount  number);
comment on column CSH_TRANSACTION.offset_amount is '已冲抵金额(hlcm保证金)';

alter table CSH_TRANSACTION add (return_amount  number);
comment on column CSH_TRANSACTION.return_amount is '已退款金额(hlcm保证金)';

alter table CSH_TRANSACTION add (deposit_balance  number);
comment on column CSH_TRANSACTION.deposit_balance is '保证金余额(hlcm保证金)';

alter table CSH_TRANSACTION add (deposit_source_tran_id  number);
comment on column CSH_TRANSACTION.deposit_source_tran_id is '保证金上级现金事务id(hlcm保证金)';