/*
================================================================================
档案代号:axh_file
档案名称:合并后会计科目各期余额档
档案目的:
上游档案:
下游档案:
============.========================.==========================================
*/
create table axh_file
(
axh00       varchar2(5) NOT NULL,    /*帐别编号                               */
axh01       varchar2(10) NOT NULL,   /*族群编号                               */
axh02       varchar2(10) NOT NULL,   /*上层公司编号                           */
axh03       varchar2(5) NOT NULL,    /*上层帐别                               */
axh04       varchar2(10) NOT NULL,   /*下层公司编号                           */
axh041      varchar2(5) NOT NULL,    /*下层帐别                               */
axh05       varchar2(24) NOT NULL,   /*科目编号                               */
axh06       number(5) NOT NULL,      /*会计年度                               */
axh07       number(5) NOT NULL,      /*期别                                   */
axh08       number(20,6) NOT NULL,   /*借方金额                               */
axh09       number(20,6) NOT NULL,   /*贷方金额                               */
axh10       number(10),              /*借方笔数                               */
axh11       number(10),              /*贷方笔数                               */
axh12       varchar2(4) NOT NULL,    /*币别                                   */
axh13       varchar2(10) NOT NULL    /*版本                                   */
);

create unique index axh_pk on axh_file (axh01,axh02,axh03,axh04,axh041,axh05,axh06,axh07,axh00,axh12,axh13);
alter table axh_file add  constraint axh_pk primary key  
(axh01,axh02,axh03,axh04,axh041,axh05,axh06,axh07,axh00,axh12,axh13) enable validate;
grant select on axh_file to public;
grant index on axh_file to public;
grant update on axh_file to public;
grant delete on axh_file to public;
grant insert on axh_file to public;