/* ================================================================================ 档案代号:aas_file 档案名称:会计科目每日余额档 档案目的: 上游档案: 下游档案: ============.========================.========================================== */ create table aas_file ( aas00 varchar2(5) NOT NULL, /*帐别编号 */ aas01 varchar2(24) NOT NULL, /*科目编号 */ aas02 date NOT NULL, /*日期 */ aas04 number(20,6), /*借方金额 */ aas05 number(20,6), /*贷方金额 */ aas06 number(10), /*借方笔数 */ aas07 number(10) /*贷方笔数 */ ); create unique index aas_pk on aas_file (aas01,aas02,aas00); alter table aas_file add constraint aas_pk primary key (aas01,aas02,aas00) enable validate; grant select on aas_file to public; grant index on aas_file to public; grant update on aas_file to public; grant delete on aas_file to public; grant insert on aas_file to public; |