/*
================================================================================
档案代号:axs_file
档案名称:来源科目misc明细科目档
档案目的:
上游档案:
下游档案:
============.========================.==========================================
*/
create table axs_file
(
axs00       varchar2(5) NOT NULL,    /*来源帐别                               */
axs01       varchar2(24) NOT NULL,   /*来源会计科目编号                       */
axs03       varchar2(24) NOT NULL,   /*来源科目misc明细科目                   */
axs09       varchar2(10) NOT NULL,   /*来源公司代码                           */
axs10       varchar2(10) NOT NULL,   /*对冲公司代码                           */
axs12       varchar2(5) NOT NULL     /*对冲帐别                               */
);

create unique index axs_pk on axs_file (axs00,axs01,axs03,axs09,axs10,axs12);
alter table axs_file add  constraint axs_pk primary key  (axs00,axs01,axs03,axs09,axs10,axs12) enable 
validate;
grant select on axs_file to public;
grant index on axs_file to public;
grant update on axs_file to public;
grant delete on axs_file to public;
grant insert on axs_file to public;