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