/*
================================================================================
档案代号:azd_file
档案名称:签核过程档
档案目的:
上游档案:
下游档案:
============.========================.==========================================
*/
create table azd_file
(
azd01       varchar2(16) NOT NULL,   /*单据编号                               */
azd02       number(5) NOT NULL,      /*单据类别                               */
                                     /*单据类别 (与 aze09 同)                 */
                                     /*1.报价单 2.请购单 3.采购单 4.传票      */
                                     /*5.销货单 6.传票底稿                    */
                                     /*7.常用传票(固定金额)8.常用传票(固定比率)*/
                                     /*9.调拨 10.设计变更单 11.应付帐款       */
                                     /*12.付款单   13.销单(内销)出货单        */
                                     /*14.销单(外销)出货单 15.销货折让单      */
                                     /*16.销退单  17.预收货款单 18.复运出口出货*/
                                     /*19.收款冲帐 20.开状单 21.赎单          */
                                     /*22:借项单 23:贷项单  24:呆帐单         */
                                     /*25.订单   26.订单变更                  */
azd03       varchar2(10) NOT NULL,   /*签核人员代号                           */
azd04       date                     /*签核日期                               */
);

create unique index azd_pk on azd_file (azd01,azd02,azd03);
alter table azd_file add  constraint azd_pk primary key  (azd01,azd02,azd03) enable validate;
grant select on azd_file to public;
grant index on azd_file to public;
grant update on azd_file to public;
grant delete on azd_file to public;
grant insert on azd_file to public;