/*
================================================================================
档案代号:jce_file
档案名称:不纳入计算成本库维护作业
档案目的:
上游档案:
下游档案:
============.========================.==========================================
*/
create table jce_file
(
jce01       varchar2(10) NOT NULL,   /*成本库别                               */
jce02       varchar2(10) NOT NULL,   /*仓库编号                               */
jce03       varchar2(1),             /*NO USE                                 */
jce04       varchar2(1),             /*No Use                                 */
jce05       varchar2(1),             /*No Use                                 */
jceacti     varchar2(1),             /*资料有效码                             */
jceuser     varchar2(10),            /*资料所有者                             */
jcegrup     varchar2(10),            /*资料所有部门                           */
jcemodu     varchar2(10),            /*资料修改者                             */
jcedate     date                     /*最近修改日                             */
);

create unique index jce_pk on jce_file (jce01,jce02);
alter table jce_file add  constraint jce_pk primary key  (jce01,jce02) enable validate;
grant select on jce_file to public;
grant index on jce_file to public;
grant update on jce_file to public;
grant delete on jce_file to public;
grant insert on jce_file to public;