/* ================================================================================ 档案代号:caa_file 档案名称:成本分摊方式资料档 档案目的: 上游档案: 下游档案: ============.========================.========================================== */ create table caa_file ( caa01 varchar2(10) NOT NULL, /*成本中心 */ caa02 varchar2(10) NOT NULL, /*成本项目 */ caa04 varchar2(1) NOT NULL, /*成本分类 */ /*1.人工成本 */ /*2.制造费用 */ caa05 varchar2(24) NOT NULL, /*会计科目 */ caa06 varchar2(1) /*分摊方式 */ /*1.实际工时 */ /*2.标准工时 */ /*3.产出数量x分摊权数 */ ); create unique index caa_pk on caa_file (caa01,caa02,caa04,caa05); alter table caa_file add constraint caa_pk primary key (caa01,caa02,caa04,caa05) enable validate; grant select on caa_file to public; grant index on caa_file to public; grant update on caa_file to public; grant delete on caa_file to public; grant insert on caa_file to public; |