HLS_BP_MASTER.sql 1.37 KB
Newer Older
1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32
alter table HLS_BP_MASTER add (OTHER_MATTERS  varchar2(2000));
comment on column HLS_BP_MASTER.OTHER_MATTERS is '其他事项说明';

alter table HLS_BP_MASTER add (id_card_no_lp  number);
comment on column HLS_BP_MASTER.id_card_no_lp is '法人代表身份证号';

alter table HLS_BP_MASTER add (Fixed_assets  varchar2(2000));
comment on column HLS_BP_MASTER.Fixed_assets is '固定资产';

alter table HLS_BP_MASTER add (Capital  number);
comment on column HLS_BP_MASTER.Capital is '资本金';

alter table HLS_BP_MASTER add (Capital_in_place  number);
comment on column HLS_BP_MASTER.Capital_in_place is '资本金到位额';

alter table HLS_BP_MASTER add (agency  varchar2(2000));
comment on column HLS_BP_MASTER.agency is '代理店';

alter table HLS_BP_MASTER add (business_manager  varchar2(100));
comment on column HLS_BP_MASTER.business_manager is '业务经理';

alter table HLS_BP_MASTER add (contact_type  varchar2(100));
comment on column HLS_BP_MASTER.contact_type is '联系人类型';

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

  alter table HLS_BP_MASTER add (INOVICE_BP_ADDRESS  varchar2(100));
comment on column HLS_BP_MASTER.INOVICE_BP_ADDRESS is '地址';

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