/*
================================================================================
档案代号:apn_file
档案名称:AAP-帐款统计档
档案目的:
上游档案:
下游档案:
============.========================.==========================================
*/
create table apn_file
(
apn00       varchar2(24) NOT NULL,   /*科目编号                               */
apn01       varchar2(10) NOT NULL,   /*付款厂商                               */
apn02       varchar2(40) NOT NULL,   /*厂商简称                               */
                                     /*厂商简称(一般应付帐款)                 */
                                     /*预购单号(预付购料款)                   */
apn03       varchar2(10),            /*部门                                   */
apn04       number(5) NOT NULL,      /*年度                                   */
apn05       number(5) NOT NULL,      /*期别                                   */
                                     /*系统年结时会产生一笔 '0' 期资料        */
                                     /*程式的期初皆以sum(借-贷)               */
apn06       number(20,6),            /*借方金额                               */
apn07       number(20,6),            /*贷方金额                               */
apn08       varchar2(10) NOT NULL,   /*营运中心编号                           */
apn09       varchar2(5) NOT NULL,    /*帐别                                   */
apn10       varchar2(16) NOT NULL,   /*立冲编号                               */
                                     /*2002.1.4 将以下Report所列栏位直接记录  */
apn11       date,                    /*帐款日                                 */
apn12       varchar2(16),            /*抛转传票编号                           */
                                     /*抛转传票编号 npp01(npq01)              */
apn13       varchar2(255),           /*备注                                   */
apn14       varchar2(4),             /*币别                                   */
                                     /*币别          azi01                    */
apn15       number(20,10),           /*汇率                                   */
                                     /*汇率    No.7952                        */
apn16       varchar2(40),            /*付款厂商简称                           */
apn17       varchar2(30),            /*No Use                                 */
apn18       varchar2(30)             /*No Use                                 */
);

create        index apn_02 on apn_file (apn01,apn02);
create unique index apn_pk on apn_file (apn08,apn09,apn00,apn01,apn02,apn04,apn05,apn10);
alter table apn_file add  constraint apn_pk primary key  (apn08,apn09,apn00,apn01,apn02,apn04,apn05,apn10) 
enable validate;
grant select on apn_file to public;
grant index on apn_file to public;
grant update on apn_file to public;
grant delete on apn_file to public;
grant insert on apn_file to public;