/*
================================================================================
档案代号:bxe_file
档案名称:保税群组代码档
档案目的:
上游档案:
下游档案:
============.========================.==========================================
*/
create table bxe_file
(
bxe01       varchar2(40) NOT NULL,   /*群组代码                               */
bxe02       varchar2(120),           /*群组品名                               */
bxe03       varchar2(120),           /*群组规格                               */
bxe04       varchar2(4),             /*群组单位                               */
bxe05       varchar2(20),            /*群组帐卡编号                           */
bxe06       varchar2(80),            /*工业局英文名称                         */
bxe07       varchar2(20),            /*ccc code                               */
                                     /*Chinese Commercial Codealso            */
                                     /*商品分类号列                           */
bxeacti     varchar2(1)              /*资料有效码                             */
);

create unique index bxe_pk on bxe_file (bxe01);
alter table bxe_file add  constraint bxe_pk primary key  (bxe01) enable validate;
grant select on bxe_file to public;
grant index on bxe_file to public;
grant update on bxe_file to public;
grant delete on bxe_file to public;
grant insert on bxe_file to public;