ER图-sourcing

tt_quotation_ext 报价单扩展表

idquotation_idlc_manage_rateckd_manage_rate a_priceb_pricea_price_no_mouldb_price_no_mouldtoolingtooling_sharetooling_share_quantitytooling_has_sharedevelopment_cost 

id=cbd_id1:1

id=rfq_id1:n

tt_quotation 报价单

idrfq_idroundpart_numpart_prj_codesupplier_idsupplier_plant_id 

tt_purchasing_project_part采购项目(零件)

idfsnr_gsnr_nummodel_name_zhcartype_project_zhcartype_categorypart_project_typepart_project_source 

tt_nomi_record 定点记录

idnominate_app_idpart_proj_idrfq_idfsnr_gsnr_numpart_proj_typepart_type 

tt_rfq_rounds_supplier rfq轮次供应商

idrfq_idrfq_roundssap_numsupplier_idsupplier_namebdl_typeselected_cbd 

tt_mould_cbd 模具费

idmould_idmould_cdb_idquotation_idmould_hdr_idfixed_assets_name 

tt_cbd 

idlevelquotation_id 

quotation=idn:1

quotation_id=id1:1

id = nominate_id1:n

tt_cbd_level_one

idcbd_idmould_cbd_idcbd_hdr_idcbd_plant_cap_idcbd_block_idmaterial_summaryproduction_summaryscrap_summarymanage_summaryother_summaryprofit_summarykent_summarytotal_price 

id=nominate_record_id1:n

rfq_id = idn:1

tt_nomi_record_detail 定点记录详情

idnominate_app_idnominate_record_idsvw_numtemp_numrfq_id 

quotation_id=idn:1

tt_rfq_bdl询价供应商(BDL)

idsupplier_idrfq_idmemosap_numis_mbdlis_check_cbd 

tt_cbd_level_two

cbd_id=id1:1

tt_rfq_bdl_rate供应商评分

idrfq_idpush_daterateexterna_feeadd_feeconfirm_cyclememo 

tt_rfq_part_rating零件评分

tt_cbd_level_three

tt_nomi_exclusive_supplie 单一供应商

single_sourcing_idpart_numts_supplier_idnominate_app_idrfq_idfsnr_gsnr_numsuppliers_namesap_numpart_name_ch 

id=nominate_id1:n

tt_rfq_roundRFQ轮次记录

idrfq_idroundround_statusrounds_typecurrent_rounds_start_timecurrent_rounds_end_time 

tt_cbd_kent 开发费

idrfq_idquotation_iditemitem_descriptionunit_pricequantity 

tt_nomi_application 定点申请关系

idnominate_process_typeapplication_statusmeeting_present_idmeeting_typenominate_nameis_nomination_letter_sendnomination_letter_send_datesoll_date 

nominate_id = idn:1

tt_rfq RFQ表

idrfq_namerfq_descrfq_typecurrent_status 

tt_nomi_suggestion

idnominate_idrfq_idpart_numpart_name_zhpart_name_defsnr_gsnr_num

nominate_id= idn:1

id=quotation_id1:n

tr_nomi_rfq RFQ和定点申请关系表

idnominate_idrfq_id 

tt_nomi_supplier 供应商

idnominate_app_idrfq_supplier_idfsnr_gsnr_numpart_name_chpart_name_ger