/*
================================================================================
档案代号:npg_file
档案名称:银行存款期初开帐档
档案目的:
上游档案:
下游档案:
============.========================.==========================================
*/
create table npg_file
(
npg01       varchar2(11) NOT NULL,   /*银行编号                               */
npg02       number(5) NOT NULL,      /*年度                                   */
npg03       number(5) NOT NULL,      /*月份                                   */
npg06       number(20,6) NOT NULL,   /*出纳月底结存                           */
                                     /*出纳月底结存(原币)                     */
npg09       number(20,6) NOT NULL,   /*出纳月底结存                           */
                                     /*出纳月底结存(本币)                     */
npg16       number(20,6) NOT NULL,   /*总帐月底结存                           */
                                     /*总帐月底结存(原币)                     */
npg19       number(20,6) NOT NULL    /*总帐月底结存                           */
                                     /*总帐月底结存(本币)                     */
);

create unique index npg_pk on npg_file (npg01,npg02,npg03);
alter table npg_file add  constraint npg_pk primary key  (npg01,npg02,npg03) enable validate;
grant select on npg_file to public;
grant index on npg_file to public;
grant update on npg_file to public;
grant delete on npg_file to public;
grant insert on npg_file to public;