/*
================================================================================
档案代号:pjs_file
档案名称:专案费用明细档
档案目的:
上游档案:
下游档案:
============.========================.==========================================
*/
create table pjs_file
(
pjs01       number(5) NOT NULL,      /*年度                                   */
pjs02       number(5) NOT NULL,      /*期别                                   */
pjs03       varchar2(10) NOT NULL,   /*专案编号                               */
pjs04       varchar2(30) NOT NULL,   /*wbs编号                                */
pjs05       varchar2(10) NOT NULL,   /*费用代号                               */
pjs10       number(20,6),            /*本期发生金额                           */
pjs11       number(20,6),            /*本期预提金额                           */
pjs12       number(20,6),            /*本期结转金额                           */
pjsdate     date,                    /*最近计算日期                           */
pjstime     varchar2(5),             /*最近计算时间                           */
pjsuser     varchar2(10)             /*最近计算人员                           */
);

create unique index pjs_pk on pjs_file (pjs01,pjs02,pjs03,pjs04,pjs05);
alter table pjs_file add  constraint pjs_pk primary key  (pjs01,pjs02,pjs03,pjs04,pjs05) enable validate;
grant select on pjs_file to public;
grant index on pjs_file to public;
grant update on pjs_file to public;
grant delete on pjs_file to public;
grant insert on pjs_file to public;