/*
================================================================================
档案代号:adt_file
档案名称:
档案目的:
上游档案:
下游档案:
============.========================.==========================================
*/
create table adt_file
(
adt01       varchar2(16) NOT NULL,   /*库存调整单                             */
adt02       number(5) NOT NULL,      /*项次                                   */
adt03       varchar2(40),            /*商品编号                               */
adt04       varchar2(24),            /*批号                                   */
adt05       varchar2(4),             /*单位                                   */
adt06       number(15,3),            /*数量                                   */
adt07       varchar2(255)            /*备注                                   */
);

create unique index adt_pk on adt_file (adt01,adt02);
alter table adt_file add  constraint adt_pk primary key  (adt01,adt02) enable validate;
grant select on adt_file to public;
grant index on adt_file to public;
grant update on adt_file to public;
grant delete on adt_file to public;
grant insert on adt_file to public;