/*
================================================================================
档案代号:imc_file
档案名称:品名规格额外说明资料
档案目的:
上游档案:
下游档案:
============.========================.==========================================
*/
create table imc_file
(
imc01       varchar2(40) NOT NULL,   /*料件编号                               */
                                     /*料件编号ima01                          */
imc02       varchar2(20) NOT NULL,   /*品名规格额外说明类别                   */
                                     /*美律报表固定一类别 'IMA'               */
                                     /*品名规格额外说明类别的分类, 如中文说明,*/
                                     /*                              英文说明,*/
                                     /*                              采购说明,*/
                                     /*                              ......等 */
                                     /*分类说明可记录在码别说明档内           */
imc03       number(5) NOT NULL,      /*行序                                   */
imc04       varchar2(255)            /*品名规格额外说明                       */
);

create unique index imc_pk on imc_file (imc01,imc02,imc03);
alter table imc_file add  constraint imc_pk primary key  (imc01,imc02,imc03) enable validate;
grant select on imc_file to public;
grant index on imc_file to public;
grant update on imc_file to public;
grant delete on imc_file to public;
grant insert on imc_file to public;