/*
================================================================================
档案代号:str_file
档案名称:部门名称资料(成会系统使用)
档案目的:
上游档案:
下游档案:
============.========================.==========================================
*/
create table str_file
(
str01       varchar2(10) NOT NULL,   /*部门编号                               */
str02       varchar2(10),            /*部门名称                               */
str03       varchar2(80),            /*部门全称                               */
str04       varchar2(24),            /*会计科目                               */
str05       varchar2(1),             /*部门性质                               */
                                     /*部门性质 1:制造部门 2:服务部门 3:虚拟部*/
str06       varchar2(1),             /*层级                                   */
str07       varchar2(1)              /*最终分摊部门                           */
                                     /*最终分摊部门(Y/N)                      */
);

create unique index str_pk on str_file (str01);
alter table str_file add  constraint str_pk primary key  (str01) enable validate;
grant select on str_file to public;
grant index on str_file to public;
grant update on str_file to public;
grant delete on str_file to public;
grant insert on str_file to public;