/* ================================================================================ 档案代号:axj_file 档案名称:调整与销除分录底稿单身档 档案目的: 上游档案: 下游档案: ============.========================.========================================== */ create table axj_file ( axj00 varchar2(5) NOT NULL, /*帐别 */ axj01 varchar2(16) NOT NULL, /*传票编号 */ axj02 number(5) NOT NULL, /*项次 */ axj03 varchar2(24), /*科目编号 */ axj04 varchar2(80), /*摘要 */ axj05 varchar2(15), /*关系人/客户,厂商名称 */ axj06 varchar2(1), /*借贷别 */ /*借贷别(1.借/2.贷) */ axj07 number(20,6) NOT NULL, /*异动金额 */ axj08 varchar2(1), /*No Use */ axj09 varchar2(1), /*No Use */ axj10 varchar2(1), /*No Use */ axj11 varchar2(1), /*No Use */ axj12 varchar2(1) /*No Use */ ); create index axj_02 on axj_file (axj03); create index axj_03 on axj_file (axj00,axj01,axj03,axj06); create unique index axj_pk on axj_file (axj01,axj02,axj00); alter table axj_file add constraint axj_pk primary key (axj01,axj02,axj00) enable validate; grant select on axj_file to public; grant index on axj_file to public; grant update on axj_file to public; grant delete on axj_file to public; grant insert on axj_file to public; |