/*
================================================================================
档案代号:oox_file
档案名称:月底重评价异动记录档
档案目的:
上游档案:
下游档案:
============.========================.==========================================
*/
create table oox_file
(
oox00       varchar2(2) NOT NULL,    /*类型                                   */
                                     /*类型  AR.应收帐款  AP.应付帐款         */
                                     /*      NM.银行存款                      */
                                     /*      NR.应收票据  NP.应付票据  NO.A058*/
oox01       number(5) NOT NULL,      /*年度                                   */
oox02       number(5) NOT NULL,      /*期别                                   */
oox03v      varchar2(2),             /*类别                                   */
                                     /*类别                            NO.A048*/
                                     /*AR/AP 时, 1*.立帐  2*.待抵             */
                                     /*NM    时, 1 .银行存款  2.汇款入帐      */
                                     /*NR    时, 1 .收票  2.质押       NO.A058*/
                                     /*NP    时, 1 .开票               NO.A058*/
oox03       varchar2(16) NOT NULL,   /*异动单号                               */
oox04       number(5) NOT NULL,      /*项次                                   */
oox05       varchar2(4),             /*币别                                   */
oox06       number(20,10),           /*上月重估汇率                           */
oox07       number(20,10),           /*本月重估汇率                           */
oox08       number(20,6),            /*本币未冲金额                           */
oox09       number(20,6),            /*本币重估金额                           */
oox10       number(20,6),            /*汇兑损益                               */
oox041      number(5) DEFAULT '0' NOT NULL /*项次*/
);

create unique index oox_pk on oox_file (oox00,oox01,oox02,oox03,oox04,oox041);
alter table oox_file add  constraint oox_pk primary key  (oox00,oox01,oox02,oox03,oox04,oox041) enable 
validate;
grant select on oox_file to public;
grant index on oox_file to public;
grant update on oox_file to public;
grant delete on oox_file to public;
grant insert on oox_file to public;