/*
================================================================================
档案代号:qcy_file
档案名称:DATE CODE 维护作业
档案目的:
上游档案:
下游档案:
============.========================.==========================================
*/
create table qcy_file
(
qcy01       varchar2(16) NOT NULL,   /*收货单号                               */
qcy02       number(5) NOT NULL,      /*收货项次                               */
qcy03       number(5) NOT NULL,      /*行序                                   */
qcy04       varchar2(8),             /*No Use                                 */
qcy05       number(15,3)             /*数量                                   */
);

create unique index qcy_pk on qcy_file (qcy01,qcy02,qcy03);
alter table qcy_file add  constraint qcy_pk primary key  (qcy01,qcy02,qcy03) enable validate;
grant select on qcy_file to public;
grant index on qcy_file to public;
grant update on qcy_file to public;
grant delete on qcy_file to public;
grant insert on qcy_file to public;