/*
================================================================================
档案代号:ads_file
档案名称:
档案目的:
上游档案:
下游档案:
============.========================.==========================================
*/
create table ads_file
(
ads01       varchar2(16) NOT NULL,   /*库存调整档                             */
ads02       date,                    /*异动日期                               */
ads03       varchar2(10),            /*客户编号                               */
ads04       varchar2(10),            /*员工编号                               */
ads05       varchar2(10),            /*部门编号                               */
ads06       varchar2(255),           /*备注                                   */
ads07       varchar2(1),             /*状况码                                 */
adsmksg     varchar2(1),             /*是否签核                               */
adssign     varchar2(4),             /*签核等级                               */
adsdays     number(5),               /*签核完成天数                           */
adsprit     number(5),               /*签核有先等级                           */
adssseq     number(5),               /*已签核顺序                             */
adssmax     number(5),               /*应签核顺序                             */
adsconf     varchar2(1),             /*确认                                   */
adspost     varchar2(1),             /*过帐否                                 */
adsprsw     number(5),               /*列印次数                               */
adsacti     varchar2(1),             /*有效否                                 */
adsuser     varchar2(10),            /*建档人员                               */
adsgrup     varchar2(10),            /*建档部门                               */
adsmodu     varchar2(10),            /*最后修改人员                           */
adsdate     date                     /*最后修改日期                           */
);

create unique index ads_pk on ads_file (ads01);
alter table ads_file add  constraint ads_pk primary key  (ads01) enable validate;
grant select on ads_file to public;
grant index on ads_file to public;
grant update on ads_file to public;
grant delete on ads_file to public;
grant insert on ads_file to public;