/*
================================================================================
档案代号:npr_file
档案名称:子系统各期统计开帐
档案目的:
上游档案:
下游档案:
============.========================.==========================================
*/
create table npr_file
(
npr00       varchar2(24) NOT NULL,   /*科目编号                               */
npr01       varchar2(10) NOT NULL,   /*对象                                   */
npr02       varchar2(40) NOT NULL,   /*对象简称                               */
npr03       varchar2(10) NOT NULL,   /*部门                                   */
npr04       number(5) NOT NULL,      /*年度                                   */
npr05       number(5) NOT NULL,      /*期别                                   */
npr06f      number(20,6),            /*原币金额                               */
npr06       number(20,6),            /*本币金额                               */
npr07f      number(20,6),            /*原币金额                               */
npr07       number(20,6),            /*本币金额                               */
npr08       varchar2(10) NOT NULL,   /*营运中心编号                           */
npr09       varchar2(5) NOT NULL,    /*帐别                                   */
npr10       varchar2(1) NOT NULL,    /*来源                                   */
npr11       varchar2(4) NOT NULL     /*币别                                   */
);

create        index npr_02 on npr_file (npr01,npr02);
create unique index npr_pk on npr_file (npr08,npr09,npr00,npr10,npr01,npr02,npr03,npr11,npr04,npr05);
alter table npr_file add  constraint npr_pk primary key  
(npr08,npr09,npr00,npr10,npr01,npr02,npr03,npr11,npr04,npr05) enable validate;
grant select on npr_file to public;
grant index on npr_file to public;
grant update on npr_file to public;
grant delete on npr_file to public;
grant insert on npr_file to public;