/*
================================================================================
档案代号:axj_file
档案名称:调整与销除分录底稿单身档
档案目的:
上游档案:
下游档案:
============.========================.==========================================
*/
create table axj_file
(
axj00       varchar2(5) NOT NULL,    /*帐别                                   */
axj01       varchar2(16) NOT NULL,   /*传票编号                               */
axj02       number(5) NOT NULL,      /*项次                                   */
axj03       varchar2(24),            /*科目编号                               */
axj04       varchar2(80),            /*摘要                                   */
axj05       varchar2(15),            /*关系人/客户,厂商名称                   */
axj06       varchar2(1),             /*借贷别                                 */
                                     /*借贷别(1.借/2.贷)                      */
axj07       number(20,6) NOT NULL,   /*异动金额                               */
axj08       varchar2(1),             /*No Use                                 */
axj09       varchar2(1),             /*No Use                                 */
axj10       varchar2(1),             /*No Use                                 */
axj11       varchar2(1),             /*No Use                                 */
axj12       varchar2(1)              /*No Use                                 */
);

create        index axj_02 on axj_file (axj03);
create        index axj_03 on axj_file (axj00,axj01,axj03,axj06);
create unique index axj_pk on axj_file (axj01,axj02,axj00);
alter table axj_file add  constraint axj_pk primary key  (axj01,axj02,axj00) enable validate;
grant select on axj_file to public;
grant index on axj_file to public;
grant update on axj_file to public;
grant delete on axj_file to public;
grant insert on axj_file to public;