/*
================================================================================
档案代号:axf_file
档案名称:会计科目对冲关系档
档案目的:
上游档案:
下游档案:
============.========================.==========================================
*/
create table axf_file
(
axf01       varchar2(24) NOT NULL,   /*来源会计科目编号                       */
axf02       varchar2(24),            /*对冲会计科目编号                       */
axf03       varchar2(1),             /*比率否                                 */
                                     /*比率否(Y/N)                            */
                                     /*Y:表依股权比率冲销                     */
                                     /*N:表全数冲销                           */
axf04       varchar2(24),            /*差额对应科目编号                       */
axf05       varchar2(1),             /*No Use                                 */
axf06       varchar2(1),             /*No Use                                 */
axf07       varchar2(1),             /*No Use                                 */
axf08       varchar2(1),             /*No Use                                 */
axfacti     varchar2(1),             /*资料有效码                             */
axfuser     varchar2(10),            /*资料所有者                             */
axfgrup     varchar2(10),            /*资料所有部门                           */
axfmodu     varchar2(10),            /*资料修改者                             */
axfdate     date,                    /*最近修改日                             */
axf09       varchar2(10) NOT NULL,   /*来源公司代码                           */
axf10       varchar2(10) NOT NULL,   /*对冲公司代码                           */
axf00       varchar2(5) NOT NULL,    /*来源帐别                               */
axf12       varchar2(5) NOT NULL     /*对冲帐别                               */
);

create unique index axf_pk on axf_file (axf00,axf01,axf09,axf10,axf12);
alter table axf_file add  constraint axf_pk primary key  (axf00,axf01,axf09,axf10,axf12) enable validate;
grant select on axf_file to public;
grant index on axf_file to public;
grant update on axf_file to public;
grant delete on axf_file to public;
grant insert on axf_file to public;