/* ================================================================================ 档案代号: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; |