ACR_INVOICE_HD.sql

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';