HLS_BP_MASTER_CONTACT_INFO.sql 576 Bytes
Newer Older
1 2 3 4 5 6 7 8 9 10 11
alter table HLS_BP_MASTER_CONTACT_INFO add (CONTACT_TYPE  varchar2(30));
comment on column HLS_BP_MASTER_CONTACT_INFO.CONTACT_TYPE is '联系人类型';

alter table HLS_BP_MASTER_CONTACT_INFO add (PAYMENT_OWNER  varchar2(100));
comment on column HLS_BP_MASTER_CONTACT_INFO.PAYMENT_OWNER is '支付负责人';

alter table HLS_BP_MASTER_CONTACT_INFO add (ZIPCODE  number);
comment on column HLS_BP_MASTER_CONTACT_INFO.ZIPCODE is '邮政编码';

alter table HLS_BP_MASTER add (LEGAL_PERSON  varchar2(100));
comment on column HLS_BP_MASTER.LEGAL_PERSON is '法人代表姓名';