/*
================================================================================
档案代号:axk_file
档案名称:合并前科目异动码冲帐余额档
档案目的:
上游档案:
下游档案:
============.========================.==========================================
*/
create table axk_file
(
axk00       varchar2(5) NOT NULL,    /*帐别                                   */
axk01       varchar2(10) NOT NULL,   /*族群编号                               */
axk02       varchar2(10) NOT NULL,   /*上层公司编号                           */
axk03       varchar2(5) NOT NULL,    /*上层帐别                               */
axk04       varchar2(10) NOT NULL,   /*下层公司编号                           */
axk041      varchar2(5) NOT NULL,    /*下层帐别                               */
axk05       varchar2(24) NOT NULL,   /*科目编号                               */
axk06       varchar2(2) NOT NULL,    /*异动码顺序                             */
axk07       varchar2(30) NOT NULL,   /*异动码值                               */
axk08       number(5) NOT NULL,      /*会计年度                               */
axk09       number(5) NOT NULL,      /*期别                                   */
axk10       number(20,6),            /*借方总金额                             */
axk11       number(20,6),            /*贷方总金额                             */
axk12       number(5),               /*借方总笔数                             */
axk13       number(5),               /*贷方总笔数                             */
axk14       varchar2(4) NOT NULL,    /*币别                                   */
axk15       varchar2(10) NOT NULL    /*版本                                   */
);

create unique index axk_pk on axk_file 
(axk01,axk02,axk03,axk04,axk041,axk05,axk07,axk08,axk09,axk00,axk06,axk14,axk15);
alter table axk_file add  constraint axk_pk primary key  
(axk01,axk02,axk03,axk04,axk041,axk05,axk07,axk08,axk09,axk00,axk06,axk14,axk15) enable validate;
grant select on axk_file to public;
grant index on axk_file to public;
grant update on axk_file to public;
grant delete on axk_file to public;
grant insert on axk_file to public;