/*
================================================================================
档案代号:npy_file
档案名称:票据格式设定单身档
档案目的:
上游档案:
下游档案:
============.========================.==========================================
*/
create table npy_file
(
npy01       varchar2(10) NOT NULL,   /*格式代号                               */
npy02       number(5) NOT NULL,      /*单据项次                               */
npy03       varchar2(10),            /*列印项目                               */
npy04       number(5),               /*空几列                                 */
npy05       number(5),               /*空几行                                 */
npy06       varchar2(30),            /*本列结束否                             */
npy07       varchar2(30)             /*No Use                                 */
);

create unique index npy_pk on npy_file (npy01,npy02);
alter table npy_file add  constraint npy_pk primary key  (npy01,npy02) enable validate;
grant select on npy_file to public;
grant index on npy_file to public;
grant update on npy_file to public;
grant delete on npy_file to public;
grant insert on npy_file to public;