/* ================================================================================ 档案代号:bhe_file 档案名称:会计科目维护作业 档案目的: 上游档案: 下游档案: ============.========================.========================================== */ create table bhe_file ( bhe00 varchar2(1) NOT NULL, /*性质 */ /*性质 1产品别 2.客户 3.厂商 */ bhe01 varchar2(40) NOT NULL, /*产品别/客户/厂商 */ bhe02 varchar2(24), /*销货收入科目 */ bhe03 varchar2(24), /*销货成本科目 */ bhe04 varchar2(24), /*存货科目科目 */ bhe05 varchar2(24), /*No Use */ bhe06 varchar2(24) /*应付/应收帐款科目 */ ); create unique index bhe_pk on bhe_file (bhe00,bhe01); alter table bhe_file add constraint bhe_pk primary key (bhe00,bhe01) enable validate; grant select on bhe_file to public; grant index on bhe_file to public; grant update on bhe_file to public; grant delete on bhe_file to public; grant insert on bhe_file to public; |