/*
================================================================================
档案代号:abb_file
档案名称:会计传票单身档
档案目的:
上游档案:
下游档案:
============.========================.==========================================
*/
create table abb_file
(
abb00       varchar2(5) NOT NULL,    /*帐别                                   */
abb01       varchar2(16) NOT NULL,   /*传票编号                               */
abb02       number(5) NOT NULL,      /*项次                                   */
abb03       varchar2(24),            /*科目编号                               */
abb04       varchar2(80),            /*摘要                                   */
abb05       varchar2(10),            /*部门                                   */
abb06       varchar2(1),             /*借贷别                                 */
                                     /*借贷别(1.借/2.贷)                      */
abb07f      number(20,6),            /*原币金额                               */
                                     /*原币金额         add in 01/09/24       */
abb07       number(20,6) NOT NULL,   /*异动金额                               */
abb08       varchar2(10),            /*专案编号                               */
abb11       varchar2(30),            /*异动码-1                               */
                                     /*异动码-1        (96/05/07)             */
abb12       varchar2(30),            /*异动码-2                               */
                                     /*异动码-2        (96/05/07)             */
abb13       varchar2(30),            /*异动码-3                               */
                                     /*异动码-3        (96/05/07)             */
abb14       varchar2(30),            /*异动码-4                               */
abb15       varchar2(10),            /*预算编号                               */
abb24       varchar2(4),             /*原币币别                               */
                                     /*原币币别         add in 01/09/24       */
abb25       number(20,10),           /*汇率                                   */
                                     /*汇率             add in 01/09/24       */
abb31       varchar2(30),            /*异动码-5                               */
                                     /*#FUN-5C0015                            */
abb32       varchar2(30),            /*异动码-6                               */
                                     /*#FUN-5C0015                            */
abb33       varchar2(30),            /*异动码-7                               */
                                     /*#FUN-5C0015                            */
abb34       varchar2(30),            /*异动码-8                               */
                                     /*#FUN-5C0015                            */
abb35       varchar2(30),            /*异动码-9                               */
                                     /*#FUN-5C0015                            */
abb36       varchar2(30),            /*异动码-10                              */
                                     /*#FUN-5C0015                            */
abb37       varchar2(30),            /*异动码-关系人                          */
                                     /*#FUN-5C0015                            */
abb41       number(15,3),            /*数量                                   */
abb42       number(20,6),            /*单价                                   */
abb930      varchar2(6),             /*No Use                                 */
abbud01     varchar2(255),           /*自订栏位-Textedit                      */
abbud02     varchar2(40),            /*自订栏位-文字                          */
abbud03     varchar2(40),            /*自订栏位-文字                          */
abbud04     varchar2(40),            /*自订栏位-文字                          */
abbud05     varchar2(40),            /*自订栏位-文字                          */
abbud06     varchar2(40),            /*自订栏位-文字                          */
abbud07     number(15,3),            /*自订栏位-数值                          */
abbud08     number(15,3),            /*自订栏位-数值                          */
abbud09     number(15,3),            /*自订栏位-数值                          */
abbud10     number(10),              /*自订栏位-整数                          */
abbud11     number(10),              /*自订栏位-整数                          */
abbud12     number(10),              /*自订栏位-整数                          */
abbud13     date,                    /*自订栏位-日期                          */
abbud14     date,                    /*自订栏位-日期                          */
abbud15     date                     /*自订栏位-日期                          */
);

create        index abb_02 on abb_file (abb03);
create        index abb_03 on abb_file (abb00,abb01,abb03,abb06);
create unique index abb_pk on abb_file (abb01,abb02,abb00);
alter table abb_file add  constraint abb_pk primary key  (abb01,abb02,abb00) enable validate;
grant select on abb_file to public;
grant index on abb_file to public;
grant update on abb_file to public;
grant delete on abb_file to public;
grant insert on abb_file to public;