/*
================================================================================
档案代号:sfai_file
档案名称:备料档(行业别档)
档案目的:
上游档案:
下游档案:
============.========================.==========================================
*/
create table sfai_file
(
sfai01      varchar2(16) DEFAULT '' NOT NULL, /*工单编号*/
sfai03      varchar2(40) DEFAULT '' NOT NULL, /*料件编号*/
sfai08      varchar2(10) DEFAULT '' NOT NULL, /*作业编号*/
sfai12      varchar2(4) DEFAULT '' NOT NULL, /*发料单位*/
sfaiicd01   number(15,3),            /*应发数量                               */
                                     /*参考单位                               */
sfaiicd02   varchar2(4),             /*应发数量单位                           */
                                     /*参考单位                               */
sfaiicd03   varchar2(24),            /*发料批号                               */
sfaiicd04   number(15,3),            /*已发参考数量                           */
sfaiicd05   number(15,3),            /*超发参考数量                           */
sfaislk01   number(15,3)             /*码克用量                               */
);

create unique index sfai_pk on sfai_file (sfai01,sfai03,sfai08,sfai12);
alter table sfai_file add  constraint sfai_pk primary key  (sfai01,sfai03,sfai08,sfai12) enable validate;
grant select on sfai_file to public;
grant index on sfai_file to public;
grant update on sfai_file to public;
grant delete on sfai_file to public;
grant insert on sfai_file to public;