/*
================================================================================
档案代号:apl_file
档案名称:杂项厂商全名地址档
档案目的:
上游档案:
下游档案:
============.========================.==========================================
*/
create table apl_file
(
apl01       varchar2(20) NOT NULL,   /*杂项厂商 (MISC) 营利事业统一           */
                                     /*         (apl01 = apa21)               */
apl02       varchar2(80),            /*帐款对象全名一                         */
                                     /*帐款对象全名一  char(40)-> char(36)    */
apl021      varchar2(80),            /*帐款对象全名二                         */
                                     /*帐款对象全名二  add  01/12/27          */
apl03       varchar2(255)            /*帐款对象地址                           */
);

create unique index apl_pk on apl_file (apl01);
alter table apl_file add  constraint apl_pk primary key  (apl01) enable validate;
grant select on apl_file to public;
grant index on apl_file to public;
grant update on apl_file to public;
grant delete on apl_file to public;
grant insert on apl_file to public;