/*
================================================================================
档案代号:tao_file
档案名称:部门科目币别余额档
档案目的:
上游档案:
下游档案:
============.========================.==========================================
*/
create table tao_file
(
tao00       varchar2(5) NOT NULL,    /*帐别                                   */
tao01       varchar2(24) NOT NULL,   /*科目编号                               */
                                     /*科目编号  Course No                    */
tao02       varchar2(10) NOT NULL,   /*部门                                   */
                                     /*部门  Cost Center                      */
tao03       number(5) NOT NULL,      /*会计年度                               */
tao04       number(5) NOT NULL,      /*期别                                   */
tao05       number(20,6),            /*借方余额                               */
tao06       number(20,6),            /*贷方余额                               */
tao07       number(15,3),            /*借方笔数                               */
tao08       number(15,3),            /*贷方笔数                               */
tao09       varchar2(4) NOT NULL,    /*币别                                   */
                                     /*币别                          02/02/26 */
tao10       number(20,6),            /*原币借方金额                           */
                                     /*原币借方金额                  02/02/26 */
tao11       number(20,6)             /*原币贷方金额                           */
                                     /*原币贷方金额                  02/02/26 */
);

create unique index tao_pk on tao_file (tao01,tao02,tao03,tao04,tao09,tao00);
alter table tao_file add  constraint tao_pk primary key  (tao01,tao02,tao03,tao04,tao09,tao00) enable 
validate;
grant select on tao_file to public;
grant index on tao_file to public;
grant update on tao_file to public;
grant delete on tao_file to public;
grant insert on tao_file to public;