/*
================================================================================
档案代号:oba_file
档案名称:产品分类档
档案目的:
上游档案:
下游档案:
============.========================.==========================================
*/
create table oba_file
(
oba01       varchar2(10) NOT NULL,   /*产品分类码                             */
oba02       varchar2(80),            /*分类名称                               */
oba03       varchar2(1),             /*No Use                                 */
oba04       varchar2(1),             /*No Use                                 */
oba05       varchar2(1),             /*No Use                                 */
oba06       varchar2(1),             /*No Use                                 */
oba07       number(9,3),             /*转拨计价加计百分比                     */
                                     /*转拨计价加计百分比 add in 00/04/18     */
oba08       varchar2(1),             /*计划期别格式                           */
oba09       number(5),
oba10       varchar2(10),            /*成本中心                               */
oba11       varchar2(24)             /*销货收入科目                           */
);

create unique index oba_pk on oba_file (oba01);
alter table oba_file add  constraint oba_pk primary key  (oba01) enable validate;
grant select on oba_file to public;
grant index on oba_file to public;
grant update on oba_file to public;
grant delete on oba_file to public;
grant insert on oba_file to public;