/*
================================================================================
档案代号:tas_file
档案名称:会计科目币别每日余额档
档案目的:
上游档案:
下游档案:
============.========================.==========================================
*/
create table tas_file
(
tas00       varchar2(5) NOT NULL,    /*帐别编号                               */
tas01       varchar2(24) NOT NULL,   /*科目编号                               */
tas02       date NOT NULL,           /*日期                                   */
tas04       number(20,6),            /*借方金额                               */
tas05       number(20,6),            /*贷方金额                               */
tas06       number(10),              /*借方笔数                               */
tas07       number(10),              /*贷方笔数                               */
tas08       varchar2(4) NOT NULL,    /*币别                                   */
                                     /*币别                           02/02/26*/
tas09       number(20,6),            /*原币借方金额                           */
                                     /*原币借方金额                   02/02/26*/
tas10       number(20,6)             /*原币贷方金额                           */
                                     /*原币贷方金额                   02/02/26*/
);

create unique index tas_pk on tas_file (tas01,tas02,tas08,tas00);
alter table tas_file add  constraint tas_pk primary key  (tas01,tas02,tas08,tas00) enable validate;
grant select on tas_file to public;
grant index on tas_file to public;
grant update on tas_file to public;
grant delete on tas_file to public;
grant insert on tas_file to public;