/*
================================================================================
档案代号:adz_file
档案名称:流通配销系统单据性质档
档案目的:
上游档案:
下游档案:
============.========================.==========================================
*/
create table adz_file
(
adzslip     varchar2(5) NOT NULL,    /*单别                                   */
adzdesc     varchar2(80),            /*单据名称                               */
adzauno     varchar2(1),             /*自动编号否                             */
adzconf     varchar2(1),             /*自动确认                               */
adzprnt     varchar2(1),             /*立即列印否                             */
adzdmy6     varchar2(1),             /*1.依流水号                             */
adztype     varchar2(2),             /*单据性质                               */
adz11       varchar2(1),             /*是否影响呆滞日期                       */
adzapr      varchar2(1),             /*是否签核                               */
adzsign     varchar2(4)              /*签核等级                               */
);

create unique index adz_pk on adz_file (adzslip);
alter table adz_file add  constraint adz_pk primary key  (adzslip) enable validate;
grant select on adz_file to public;
grant index on adz_file to public;
grant update on adz_file to public;
grant delete on adz_file to public;
grant insert on adz_file to public;