alter table acr_invoice_hd add claim_status varchar2(30);
comment on column acr_invoice_hd.claim_status
is '认领状态';
alter table acr_invoice_hd add (invoice_code varchar2(200));
comment on column acr_invoice_hd.invoice_code is '发票代码';
ALTER TABLE acr_invoice_hd ADD merge_flag VARCHAR2(30) default 'N';
ALTER TABLE acr_invoice_hd ADD status VARCHAR2(20);
ALTER TABLE acr_invoice_hd ADD batch_id NUMBER ;
ALTER TABLE acr_invoice_hd ADD ref_merge_flag VARCHAR2(30);
comment on column ACR_INVOICE_HD.merge_flag
is '是否进行行合并';
comment on column ACR_INVOICE_HD.status
is '审批状态';
comment on column ACR_INVOICE_HD.batch_id
is '审批批次ID';
-
stone authoredd333231c