/*
================================================================================
档案代号:tib_file
档案名称:期间现金活动分类明细档
档案目的:
上游档案:
下游档案:
============.========================.==========================================
*/
create table tib_file
(
tib01       number(5) NOT NULL,      /*起始年度                               */
tib02       number(5) NOT NULL,      /*起始期别                               */
tib03       varchar2(5) NOT NULL,    /*帐别                                   */
tib04       varchar2(24) NOT NULL,   /*科目编号                               */
tib05       varchar2(1) NOT NULL,    /*借贷别                                 */
tib06       varchar2(16) NOT NULL,   /*传票编号                               */
tib07       number(5) NOT NULL,      /*传票项次                               */
tib08       number(20,6),            /*金额                                   */
tib09       varchar2(6)              /*现金代码                               */
);

create unique index tib_pk on tib_file (tib01,tib02,tib03,tib04,tib05,tib06,tib07);
alter table tib_file add  constraint tib_pk primary key  (tib01,tib02,tib03,tib04,tib05,tib06,tib07) enable 
validate;
grant select on tib_file to public;
grant index on tib_file to public;
grant update on tib_file to public;
grant delete on tib_file to public;
grant insert on tib_file to public;