/*
================================================================================
档案代号:oap_file
档案名称:单据出货地址档
档案目的:
上游档案:
下游档案:
============.========================.==========================================
*/
create table oap_file
(
oap01       varchar2(16) NOT NULL,   /*单据单号                               */
oap02       varchar2(1),             /*No Use                                 */
oap03       varchar2(80),            /*全名                                   */
                                     /*全名 (no use)                          */
oap041      varchar2(255),           /*地址                                   */
oap042      varchar2(255),           /*地址                                   */
oap043      varchar2(255),           /*地址                                   */
oap044      varchar2(255),           /*地址-4                                 */
oap045      varchar2(255)            /*地址-5                                 */
);

create unique index oap_pk on oap_file (oap01);
alter table oap_file add  constraint oap_pk primary key  (oap01) enable validate;
grant select on oap_file to public;
grant index on oap_file to public;
grant update on oap_file to public;
grant delete on oap_file to public;
grant insert on oap_file to public;