/*
================================================================================
档案代号:ims_file
档案名称:营运中心调拨拨出单档
档案目的:
上游档案:
下游档案:
============.========================.==========================================
*/
create table ims_file
(
ims01       varchar2(16) NOT NULL,   /*拨出单号                               */
ims02       number(5) NOT NULL,      /*拨出项次                               */
ims03       varchar2(16),            /*调拨单号                               */
ims04       number(5),               /*调拨项次                               */
ims05       varchar2(40),            /*料件编号                               */
ims06       number(15,3),            /*实拨数量                               */
ims07       number(15,3),            /*已拨入数量                             */
ims08       varchar2(10),            /*拨出营运中心                           */
ims09       varchar2(10),            /*拨入营运中心                           */
ims10       date,                    /*确认日期                               */
ims11       varchar2(10),            /*确认人                                 */
ims12       varchar2(1),             /*No Use                                 */
ims13       varchar2(1),             /*No Use                                 */
ims14       number(15,3),            /*实拨单位一数量                         */
ims15       number(15,3)             /*实拨单位二数量                         */
);

create        index ims_02 on ims_file (ims03);
create unique index ims_pk on ims_file (ims01,ims02);
alter table ims_file add  constraint ims_pk primary key  (ims01,ims02) enable validate;
grant select on ims_file to public;
grant index on ims_file to public;
grant update on ims_file to public;
grant delete on ims_file to public;
grant insert on ims_file to public;