/*
================================================================================
档案代号:cxi_file
档案名称:杂项进出理由码会计科目设定明细档
档案目的:
上游档案:
下游档案:
============.========================.==========================================
*/
create table cxi_file
(
cxi01       varchar2(10) NOT NULL,   /*部门代号                               */
cxi02       varchar2(4) NOT NULL,    /*理由码                                 */
cxi03       varchar2(1) NOT NULL,    /*单据分类                               */
cxi04       varchar2(24),            /*科目代号                               */
cxi05       varchar2(10),            /*成本归属部门                           */
cxi041      varchar2(24)             /*科目编号二                             */
);

create unique index cxi_pk on cxi_file (cxi01,cxi02,cxi03);
alter table cxi_file add  constraint cxi_pk primary key  (cxi01,cxi02,cxi03) enable validate;
grant select on cxi_file to public;
grant index on cxi_file to public;
grant update on cxi_file to public;
grant delete on cxi_file to public;
grant insert on cxi_file to public;