/* ================================================================================ 档案代号:axh_file 档案名称:合并后会计科目各期余额档 档案目的: 上游档案: 下游档案: ============.========================.========================================== */ create table axh_file ( axh00 varchar2(5) NOT NULL, /*帐别编号 */ axh01 varchar2(10) NOT NULL, /*族群编号 */ axh02 varchar2(10) NOT NULL, /*上层公司编号 */ axh03 varchar2(5) NOT NULL, /*上层帐别 */ axh04 varchar2(10) NOT NULL, /*下层公司编号 */ axh041 varchar2(5) NOT NULL, /*下层帐别 */ axh05 varchar2(24) NOT NULL, /*科目编号 */ axh06 number(5) NOT NULL, /*会计年度 */ axh07 number(5) NOT NULL, /*期别 */ axh08 number(20,6) NOT NULL, /*借方金额 */ axh09 number(20,6) NOT NULL, /*贷方金额 */ axh10 number(10), /*借方笔数 */ axh11 number(10), /*贷方笔数 */ axh12 varchar2(4) NOT NULL, /*币别 */ axh13 varchar2(10) NOT NULL /*版本 */ ); create unique index axh_pk on axh_file (axh01,axh02,axh03,axh04,axh041,axh05,axh06,axh07,axh00,axh12,axh13); alter table axh_file add constraint axh_pk primary key (axh01,axh02,axh03,axh04,axh041,axh05,axh06,axh07,axh00,axh12,axh13) enable validate; grant select on axh_file to public; grant index on axh_file to public; grant update on axh_file to public; grant delete on axh_file to public; grant insert on axh_file to public; |