/*
================================================================================
档案代号:abi_file
档案名称:传票项次立冲帐余额档
档案目的:
上游档案:
下游档案:
============.========================.==========================================
*/
create table abi_file
(
abi00       varchar2(5) NOT NULL,    /*帐别                                   */
abi01       varchar2(16) NOT NULL,   /*传票编号                               */
                                     /*传票编号(立帐)                         */
abi02       number(5) NOT NULL,      /*项次                                   */
abi03       number(5) NOT NULL,      /*会计年度                               */
abi04       number(5) NOT NULL,      /*期别                                   */
abi05       varchar2(24),            /*会计科目                               */
abi06       date,                    /*传票日期                               */
abi07       varchar2(10),            /*部门                                   */
abi08       number(20,6),            /*立帐金额                               */
                                     /*立帐金额(当期期初金额)                 */
abi09       number(20,6),            /*已冲金额                               */
                                     /*已冲金额(当期已冲金额)                 */
abi10       varchar2(80),            /*摘要                                   */
abi11       varchar2(30),            /*异动码-1                               */
abi12       varchar2(30),            /*异动码-2                               */
abi13       varchar2(30),            /*异动码-3                               */
abi14       varchar2(30),            /*异动码-4                               */
abi15       varchar2(1),             /*No Use                                 */
abi16       varchar2(1),             /*No Use                                 */
abi31       varchar2(30),            /*异动码-5                               */
                                     /*#FUN-5C0015                            */
abi32       varchar2(30),            /*异动码-6                               */
                                     /*#FUN-5C0015                            */
abi33       varchar2(30),            /*异动码-7                               */
                                     /*#FUN-5C0015                            */
abi34       varchar2(30),            /*异动码-8                               */
                                     /*#FUN-5C0015                            */
abi35       varchar2(30),            /*异动码-9                               */
                                     /*#FUN-5C0015                            */
abi36       varchar2(30),            /*异动码-10                              */
                                     /*#FUN-5C0015                            */
abi37       varchar2(30)             /*No Use                                 */
);

create        index abi_02 on abi_file (abi05);
create unique index abi_pk on abi_file (abi01,abi02,abi00,abi03,abi04);
alter table abi_file add  constraint abi_pk primary key  (abi01,abi02,abi00,abi03,abi04) enable validate;
grant select on abi_file to public;
grant index on abi_file to public;
grant update on abi_file to public;
grant delete on abi_file to public;
grant insert on abi_file to public;