/*
================================================================================
档案代号:apx_file
档案名称:还款记录明细档
档案目的: 储存还款记录档
上游档案:
下游档案:
============.========================.==========================================
*/
create table apx_file
(
apx01       varchar2(16) NOT NULL,   /*帐款编号                               */
apx02       number(5) NOT NULL,      /*项次                                   */
apx03       varchar2(16),            /*借款待抵                               */
apx04f      number(20,6) NOT NULL,   /*原币还款金额                           */
apx04       number(20,6) NOT NULL    /*本币还款金额                           */
);

create        index apx_02 on apx_file (apx03);
create unique index apx_pk on apx_file (apx01,apx02);
alter table apx_file add  constraint apx_pk primary key  (apx01,apx02) enable validate;
grant select on apx_file to public;
grant index on apx_file to public;
grant update on apx_file to public;
grant delete on apx_file to public;
grant insert on apx_file to public;