/*
================================================================================
档案代号:imj_file
档案名称:ABC计算记录档
档案目的:
上游档案:
下游档案:
============.========================.==========================================
*/
create table imj_file
(
imj01       date NOT NULL,           /*日期                                   */
imj02       varchar2(8) NOT NULL,    /*时间                                   */
imj03       varchar2(10),            /*人员                                   */
imj04       varchar2(1),             /*ABC计算方式                            */
imj05       number(5),               /*ABC计算年度                            */
imj06       number(5),               /*ABC计算期间                            */
imj07       varchar2(1),             /*排定标准                               */
imj08       varchar2(20),            /*分群码范围                             */
imj09       number(5),               /*计算期间数                             */
imj10       number(5),               /*A 类百分比                             */
imj11       number(5)                /*B 类百分比                             */
);

create unique index imj_pk on imj_file (imj01,imj02);
alter table imj_file add  constraint imj_pk primary key  (imj01,imj02) enable validate;
grant select on imj_file to public;
grant index on imj_file to public;
grant update on imj_file to public;
grant delete on imj_file to public;
grant insert on imj_file to public;