/* ================================================================================ 档案代号:aed_file 档案名称:科目异动码冲帐余额档 档案目的: 上游档案: 下游档案: ============.========================.========================================== */ create table aed_file ( aed00 varchar2(5) NOT NULL, /*帐别 */ aed01 varchar2(24) NOT NULL, /*科目编号 */ /*科目编号 (明细或独立科目) */ aed011 varchar2(2) NOT NULL, /*异动码顺序 */ aed02 varchar2(30) NOT NULL, /*异动码值 */ aed03 number(5) NOT NULL, /*会计年度 */ aed04 number(5) NOT NULL, /*期别 */ aed05 number(20,6), /*借方总金额 */ aed06 number(20,6), /*贷方总金额 */ aed07 number(5), /*借方总笔数 */ aed08 number(5), /*贷方总笔数 */ aed012 varchar2(10) /*异动码类型代号 */ /*#FUN-5C0015 */ ); create unique index aed_pk on aed_file (aed01,aed02,aed03,aed04,aed00,aed011); alter table aed_file add constraint aed_pk primary key (aed01,aed02,aed03,aed04,aed00,aed011) enable validate; grant select on aed_file to public; grant index on aed_file to public; grant update on aed_file to public; grant delete on aed_file to public; grant insert on aed_file to public; |