/*
================================================================================
档案代号:apm_file
档案名称:AAP-帐款统计档
档案目的:
上游档案:
下游档案:
============.========================.==========================================
*/
create table apm_file
(
apm00       varchar2(24) NOT NULL,   /*科目编号                               */
apm01       varchar2(10) NOT NULL,   /*付款厂商                               */
apm02       varchar2(40) NOT NULL,   /*厂商简称                               */
                                     /*厂商简称(一般应付帐款)                 */
                                     /*预购单号(预付购料款)                   */
apm03       varchar2(10) NOT NULL,   /*部门                                   */
apm04       number(5) NOT NULL,      /*年度                                   */
apm05       number(5) NOT NULL,      /*期别                                   */
                                     /*系统年结时会产生一笔 '0' 期资料        */
                                     /*程式的期初皆以sum(借-贷)               */
apm06f      number(20,6),            /*原币借方金额                           */
                                     /*原币借方金额                    NO.A074*/
apm06       number(20,6),            /*本币借方金额                           */
                                     /*本币借方金额                    NO.A074*/
apm07f      number(20,6),            /*原币贷方金额                           */
                                     /*原币贷方金额                    NO.A074*/
apm07       number(20,6),            /*本币贷方金额                           */
                                     /*本币贷方金额                    NO.A074*/
apm08       varchar2(10) NOT NULL,   /*营运中心编号                           */
apm09       varchar2(5) NOT NULL,    /*帐别                                   */
apm10       varchar2(1) NOT NULL,    /*来源                                   */
                                     /*来源 0:表开帐 1:表月结产生 #No.B372 0104*/
apm11       varchar2(4) NOT NULL     /*币别                                   */
                                     /*币别                            NO.A074*/
);

create        index apm_02 on apm_file (apm01,apm02);
create unique index apm_pk on apm_file (apm08,apm09,apm00,apm10,apm01,apm02,apm03,apm11,apm04,apm05);
alter table apm_file add  constraint apm_pk primary key  
(apm08,apm09,apm00,apm10,apm01,apm02,apm03,apm11,apm04,apm05) enable validate;
grant select on apm_file to public;
grant index on apm_file to public;
grant update on apm_file to public;
grant delete on apm_file to public;
grant insert on apm_file to public;