/* ================================================================================ 档案代号:abk_file 档案名称:费用分摊明细档 档案目的: 上游档案: 下游档案: ============.========================.========================================== */ create table abk_file ( abk00 varchar2(1) NOT NULL, /*性质 */ abk01 varchar2(10) NOT NULL, /*费用编号 */ abk02 number(5) NOT NULL, /*项次 */ abk03 number(5) NOT NULL, /*年度 */ abk04 number(5) NOT NULL, /*月份 */ abk05 number(20,6), /*金额 */ abk06 varchar2(16), /*传票编号 */ abk07 date, /*传票日期 */ abk08 varchar2(16), /*分录底稿单号 */ abk09 varchar2(10), /*处理人员 */ abk10 varchar2(24) /*科目编号 */ ); create unique index abk_pk on abk_file (abk00,abk01,abk02,abk03,abk04); alter table abk_file add constraint abk_pk primary key (abk00,abk01,abk02,abk03,abk04) enable validate; grant select on abk_file to public; grant index on abk_file to public; grant update on abk_file to public; grant delete on abk_file to public; grant insert on abk_file to public; |