/* ================================================================================ 档案代号: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; |