/*
================================================================================
档案代号:axx_file
档案名称:合并报表关系人递延项摊销明细档
档案目的:
上游档案:
下游档案:
============.========================.==========================================
*/
create table axx_file
(
axx01       varchar2(5),             /*年度                                   */
axx02       varchar2(5),             /*期别                                   */
axx03       varchar2(10),            /*族群代号                               */
axx04       varchar2(5),             /*项次                                   */
axx05       number(5),               /*摊销年度                               */
axx06       number(5),               /*摊销期别                               */
axx07       number(20,6),            /*本期摊销金额                           */
axx08       number(20,6),            /*本期摊销合并币别金额                   */
axx031      varchar2(10)             /*上层公司                               */
);

create unique index axx_pk on axx_file (axx01,axx02,axx03,axx031,axx04,axx05,axx06);
grant select on axx_file to public;
grant index on axx_file to public;
grant update on axx_file to public;
grant delete on axx_file to public;
grant insert on axx_file to public;