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