/*
================================================================================
档案代号:shj_file
档案名称:生产日报表工单转出维护档
档案目的:
上游档案:
下游档案:
============.========================.==========================================
*/
create table shj_file
(
shj01       varchar2(16) NOT NULL,   /*移转单号                               */
shj02       varchar2(16),            /*退料单号                               */
shj03       varchar2(16),            /*发料单号                               */
shj04       varchar2(10),            /*一般仓库                               */
shj05       varchar2(10),            /*储位                                   */
shj06       varchar2(24),            /*批号                                   */
shj07       varchar2(10),            /*wip仓库                                */
shj08       varchar2(10),            /*储位                                   */
shj09       varchar2(24),            /*批号                                   */
shj10       number(5) NOT NULL,      /*项次                                   */
shj11       varchar2(16),            /*转入工单                               */
shj12       number(15,3),            /*转入数量                               */
shj13       date,                    /*单据日期                               */
shjconf     varchar2(1)              /*确认码                                 */
);

create unique index shj_pk on shj_file (shj01,shj10);
alter table shj_file add  constraint shj_pk primary key  (shj01,shj10) enable validate;
grant select on shj_file to public;
grant index on shj_file to public;
grant update on shj_file to public;
grant delete on shj_file to public;
grant insert on shj_file to public;