/*
================================================================================
档案代号:fcm_file
档案名称:固定资产投资抵减享用年度档
档案目的:
上游档案:
下游档案:
============.========================.==========================================
*/
create table fcm_file
(
fcm01       varchar2(16) NOT NULL,   /*申请编号                               */
fcm02       number(5) NOT NULL,      /*项次                                   */
fcm03       varchar2(1),             /*处份否                                 */
fcm04       number(20,6),            /*抵减金额                               */
fcm05       number(5) NOT NULL,      /*享用年度                               */
fcmconf     varchar2(1)              /*确认码                                 */
);

create unique index fcm_pk on fcm_file (fcm01,fcm02,fcm05);
alter table fcm_file add  constraint fcm_pk primary key  (fcm01,fcm02,fcm05) enable validate;
grant select on fcm_file to public;
grant index on fcm_file to public;
grant update on fcm_file to public;
grant delete on fcm_file to public;
grant insert on fcm_file to public;