/*
================================================================================
档案代号:oca_file
档案名称:客户分类档
档案目的:
上游档案:
下游档案:
============.========================.==========================================
*/
create table oca_file
(
oca01       varchar2(10) NOT NULL,   /*客户分类码                             */
oca02       varchar2(80),            /*客户分类名称                           */
oca03       varchar2(24),            /*应收帐款科目编号                       */
oca04       varchar2(24)             /*应收帐款科目二                         */
);

create unique index oca_pk on oca_file (oca01);
alter table oca_file add  constraint oca_pk primary key  (oca01) enable validate;
grant select on oca_file to public;
grant index on oca_file to public;
grant update on oca_file to public;
grant delete on oca_file to public;
grant insert on oca_file to public;