/* ================================================================================ 档案代号:try_file 档案名称:订单物返未达成记录档 档案目的: 上游档案: 下游档案: ============.========================.========================================== */ create table try_file ( try01 varchar2(16) DEFAULT '' NOT NULL, /*订单单号 物返未达成的来源订*/ try02 number(5) DEFAULT '0' NOT NULL, /*订单项次 物返未达成的来源订*/ try03 varchar2(40), /*搭赠料号 */ try04 number(15,3), /*需补返数量 */ try05 varchar2(4), /*销售单位 */ try06 varchar2(1), /*结案,y/n */ try07 varchar2(16), /*物返来源合同号码 */ try08 number(5), /*物返来源合同项次 */ try09 varchar2(10), /*理由码 */ try10 number(15,3) /*已补返数量 */ ); create unique index try_pk on try_file (try01,try02); alter table try_file add constraint try_pk primary key (try01,try02) enable validate; grant select on try_file to public; grant index on try_file to public; grant update on try_file to public; grant delete on try_file to public; grant insert on try_file to public; |