/*
================================================================================
档案代号:npm_file
档案名称:应付票据异动记录单身档
档案目的:
上游档案:
下游档案:
============.========================.==========================================
*/
create table npm_file
(
npm01       varchar2(16) NOT NULL,   /*单据编号                               */
npm02       number(5) NOT NULL,      /*单据项次                               */
npm03       varchar2(16),            /*开票单号                               */
npm04       number(20,6),            /*票面金额                               */
npm05       number(20,6),            /*本币开{票金额                          */
npm06       number(20,6),            /*本币异动金额                           */
npm07       varchar2(1),             /*原票况                                 */
npm08       date,                    /*原异动日期                             */
npmud01     varchar2(255),           /*自订栏位-Textedit                      */
npmud02     varchar2(40),            /*自订栏位-文字                          */
npmud03     varchar2(40),            /*自订栏位-文字                          */
npmud04     varchar2(40),            /*自订栏位-文字                          */
npmud05     varchar2(40),            /*自订栏位-文字                          */
npmud06     varchar2(40),            /*自订栏位-文字                          */
npmud07     number(15,3),            /*自订栏位-数值                          */
npmud08     number(15,3),            /*自订栏位-数值                          */
npmud09     number(15,3),            /*自订栏位-数值                          */
npmud10     number(10),              /*自订栏位-整数                          */
npmud11     number(10),              /*自订栏位-整数                          */
npmud12     number(10),              /*自订栏位-整数                          */
npmud13     date,                    /*自订栏位-日期                          */
npmud14     date,                    /*自订栏位-日期                          */
npmud15     date                     /*自订栏位-日期                          */
);

create        index npm_04 on npm_file (npm03);
create unique index npm_pk on npm_file (npm01,npm02);
alter table npm_file add  constraint npm_pk primary key  (npm01,npm02) enable validate;
grant select on npm_file to public;
grant index on npm_file to public;
grant update on npm_file to public;
grant delete on npm_file to public;
grant insert on npm_file to public;