/*
================================================================================
档案代号:axr_file
档案名称:合并报表历史汇率档
档案目的:
上游档案:
下游档案:
============.========================.==========================================
*/
create table axr_file
(
axr01       varchar2(10) NOT NULL,   /*族群代码                               */
axr02       varchar2(10) NOT NULL,   /*公司编号                               */
axr03       varchar2(24) NOT NULL,   /*科目编号                               */
axr04       varchar2(4),             /*记帐币别                               */
axr05       number(20,6),            /*记帐币别金额                           */
axr06       date,                    /*No Use                                 */
axr07       varchar2(24) NOT NULL,   /*来源科目                               */
axr08       number(5) NOT NULL,      /*历史年度                               */
axr09       number(5) NOT NULL,      /*历史期别                               */
axr10       number(5) NOT NULL,      /*异动年度                               */
axr11       number(5) NOT NULL       /*异动期别                               */
);

create unique index axr_pk on axr_file (axr01,axr02,axr03,axr07,axr08,axr09,axr10,axr11);
alter table axr_file add  constraint axr_pk primary key  (axr01,axr02,axr03,axr07,axr08,axr09,axr10,axr11) 
enable validate;
grant select on axr_file to public;
grant index on axr_file to public;
grant update on axr_file to public;
grant delete on axr_file to public;
grant insert on axr_file to public;