NC 查询数据已被哪里引用的逻辑，即根据表名和组织类型查询引用关系
NC 查询数据已被哪里引用的逻辑，即根据表名和组织类型查询引用关系
得到类似的值：
[orgtype=null
referencingtablename=resa_docfree1
crefid=1001A11000000001YTXL
referencingkeycolumn=null
referencedtablename=bd_supplier
referencingtablecolumn=F1
referencedtablekey=pk_supplier
, orgtype=null
referencingtablename=fbm_register
crefid=fbmsZ6plierref000003
referencingkeycolumn=null
referencedtablename=bd_supplier
referencingtablecolumn=hidereceiveunit
referencedtablekey=pk_supplier
, orgtype=null
referencingtablename=fbm_register
crefid=fbmsZ6plierref000006
referencingkeycolumn=null
referencedtablename=bd_supplier
referencingtablecolumn=hidepayunit
referencedtablekey=pk_supplier
, orgtype=null
referencingtablename=fbm_impawn
crefid=fbmsZ6plierref000007
referencingkeycolumn=null
referencedtablename=bd_supplier
referencingtablecolumn=impawnunit
referencedtablekey=pk_supplier
, orgtype=null
referencingtablename=fbm_impawn
crefid=fbmsZ6plierref000010
referencingkeycolumn=null
referencedtablename=bd_supplier
referencingtablecolumn=debitunit
referencedtablekey=pk_supplier
, orgtype=null
referencingtablename=fbm_register
crefid=fbmsZ6plierref000016
referencingkeycolumn=null
referencedtablename=bd_supplier
referencingtablecolumn=keepunit
referencedtablekey=pk_supplier
, orgtype=null
referencingtablename=fbm_register
crefid=fbmsZ6plierref000019
referencingkeycolumn=null
referencedtablename=bd_supplier
referencingtablecolumn=invoiceunit
referencedtablekey=pk_supplier
, orgtype=null
referencingtablename=fbm_accept
crefid=fbmsZ6plierref000022
referencingkeycolumn=null
referencedtablename=bd_supplier
referencingtablecolumn=holdunit
referencedtablekey=pk_supplier
, orgtype=null
referencingtablename=fbm_buyerdiscount
crefid=fbmsZ6plierref000025
referencingkeycolumn=null
referencedtablename=bd_supplier
referencingtablecolumn=holdunit
referencedtablekey=pk_supplier
, orgtype=null
referencingtablename=fbm_impawn
crefid=fbmsZ6plierref000040
referencingkeycolumn=null
referencedtablename=bd_supplier
referencingtablecolumn=impawnbackunit
referencedtablekey=pk_supplier
, orgtype=null
referencingtablename=fbm_storage
crefid=fbmsZ6plierref000046
referencingkeycolumn=null
referencedtablename=bd_supplier
referencingtablecolumn=inputunit
referencedtablekey=pk_supplier
, orgtype=null
referencingtablename=fbm_storage
crefid=fbmsZ6plierref000049
referencingkeycolumn=null
referencedtablename=bd_supplier
referencingtablecolumn=outputunit
referencedtablekey=pk_supplier
, orgtype=null
referencingtablename=fbm_paybill
crefid=fbmsZ6plierref000052
referencingkeycolumn=null
referencedtablename=bd_supplier
referencingtablecolumn=receiveunit
referencedtablekey=pk_supplier
, orgtype=null
referencingtablename=fts_gatheringfinance
crefid=ftssZ6plierrefgat058
referencingkeycolumn=null
referencedtablename=bd_supplier
referencingtablecolumn=pk_company_p
referencedtablekey=pk_supplier
, orgtype=null
referencingtablename=fts_paymentfinance
crefid=ftssZ6plierrefpay058
referencingkeycolumn=null
referencedtablename=bd_supplier
referencingtablecolumn=pk_company_r
referencedtablekey=pk_supplier
, orgtype=null
referencingtablename=ic_month_hand
crefid=IC01Z810000000000001
referencingkeycolumn=null
referencedtablename=bd_supplier
referencingtablecolumn=cvendorid
referencedtablekey=pk_supplier
, orgtype=null
referencingtablename=ic_month_hand
crefid=IC01Z810000000000002
referencingkeycolumn=null
referencedtablename=bd_supplier
referencingtablecolumn=cvmivenderid
referencedtablekey=pk_supplier
, orgtype=null
referencingtablename=ic_month_handsign
crefid=IC01Z810000000000003
referencingkeycolumn=null
referencedtablename=bd_supplier
referencingtablecolumn=cvendorid
referencedtablekey=pk_supplier
, orgtype=null
referencingtablename=ic_month_handsign
crefid=IC01Z810000000000004
referencingkeycolumn=null
referencedtablename=bd_supplier
referencingtablecolumn=cvmivenderid
referencedtablekey=pk_supplier
, orgtype=null
referencingtablename=ic_month_record
crefid=IC01Z810000000000005
referencingkeycolumn=null
referencedtablename=bd_supplier
referencingtablecolumn=cvendorid
referencedtablekey=pk_supplier
, orgtype=null
referencingtablename=ic_month_record
crefid=IC01Z810000000000006
referencingkeycolumn=null
referencedtablename=bd_supplier
referencingtablecolumn=cvmivenderid
referencedtablekey=pk_supplier
, orgtype=null
referencingtablename=ic_month_recordsign
crefid=IC01Z810000000000007
referencingkeycolumn=null
referencedtablename=bd_supplier
referencingtablecolumn=cvendorid
referencedtablekey=pk_supplier
, orgtype=null
referencingtablename=ic_month_recordsign
crefid=IC01Z810000000000008
referencingkeycolumn=null
referencedtablename=bd_supplier
referencingtablecolumn=cvmivenderid
referencedtablekey=pk_supplier
, orgtype=null
referencingtablename=sm_user
crefid=REFRZ0ATIONSUPDOC001
referencingkeycolumn=null
referencedtablename=bd_supplier
referencingtablecolumn=pk_base_doc
referencedtablekey=pk_supplier
, orgtype=null
referencingtablename=sm_user
crefid=REFRZ0ATIONSUPDOC002
referencingkeycolumn=null
referencedtablename=bd_supplier
referencingtablecolumn=pk_supplier
referencedtablekey=pk_supplier
, orgtype=null
referencingtablename=bd_custmaterial
crefid=REFRZ0ATIONSUPDOC011
referencingkeycolumn=null
referencedtablename=bd_supplier
referencingtablecolumn=vfree3
referencedtablekey=pk_supplier
, orgtype=null
referencingtablename=sf_allocateagree_b
crefid=sfsuZ6lierrefagree58
referencingkeycolumn=null
referencedtablename=bd_supplier
referencingtablecolumn=pk_company_r
referencedtablekey=pk_supplier
, orgtype=null
referencingtablename=sf_allocateapply_b
crefid=sfsuZ6lierrefapply58
referencingkeycolumn=null
referencedtablename=bd_supplier
referencingtablecolumn=pk_company_r
referencedtablekey=pk_supplier
, orgtype=null
referencingtablename=tb_docconn
crefid=TBPTZ400000000000003
referencingkeycolumn=null
referencedtablename=bd_supplier
referencingtablecolumn=pk_doc
referencedtablekey=pk_supplier
, orgtype=null
referencingtablename=bd_supstock
crefid=null
referencingkeycolumn=pk_supstock
referencedtablename=bd_supplier
referencingtablecolumn=issuesup
referencedtablekey=pk_supplier
, orgtype=null
referencingtablename=cm_stuff_b
crefid=null
referencingkeycolumn=cstuff_bid
referencedtablename=bd_supplier
referencingtablecolumn=cvendorid
referencedtablekey=pk_supplier
, orgtype=null
referencingtablename=mapub_acquirepricelog
crefid=null
referencingkeycolumn=pk_log
referencedtablename=bd_supplier
referencingtablecolumn=cbvendorid
referencedtablekey=pk_supplier
, orgtype=null
referencingtablename=bcbd_abstractmaterial
crefid=null
referencingkeycolumn=pk_mo
referencedtablename=bd_supplier
referencingtablecolumn=csupplier
referencedtablekey=pk_supplier
, orgtype=null
referencingtablename=ic_sapply_b
crefid=null
referencingkeycolumn=cgeneralbid
referencedtablename=bd_supplier
referencingtablecolumn=cprodvendorid
referencedtablekey=pk_supplier
, orgtype=null
referencingtablename=ic_subcontin_h
crefid=null
referencingkeycolumn=cgeneralhid
referencedtablename=bd_supplier
referencingtablecolumn=cvendorid
referencedtablekey=pk_supplier
, orgtype=null
select * from fbm_counterbook_b
crefid=null
referencingkeycolumn=pk_action
referencedtablename=bd_supplier
referencingtablecolumn=endorsee
referencedtablekey=pk_supplier
, orgtype=null
referencingtablename=po_order
crefid=null
referencingkeycolumn=pk_order
referencedtablename=bd_supplier
referencingtablecolumn=pk_supplier
referencedtablekey=pk_supplier
, orgtype=null
referencingtablename=bd_supabilityset
crefid=null
referencingkeycolumn=pk_supabilityset
referencedtablename=bd_supplier
referencingtablecolumn=pk_supplyname
referencedtablekey=pk_supplier
, orgtype=null
referencingtablename=er_accrued_detail
crefid=null
referencingkeycolumn=pk_accrued_detail
referencedtablename=bd_supplier
referencingtablecolumn=pk_supplier
referencedtablekey=pk_supplier
, orgtype=null
referencingtablename=vrm_vendormater
crefid=null
referencingkeycolumn=pk_vendorstock
referencedtablename=bd_supplier
referencingtablecolumn=pk_supplier
referencedtablekey=pk_supplier
, orgtype=null
referencingtablename=cm_ctrevertratio
crefid=null
referencingkeycolumn=cctrevertratioid
referencedtablename=bd_supplier
referencingtablecolumn=cvendorid
referencedtablekey=pk_supplier
, orgtype=null
referencingtablename=sca_bomref_martactv
crefid=null
referencingkeycolumn=pkmartacvt
referencedtablename=bd_supplier
referencingtablecolumn=cvendorid
referencedtablekey=pk_supplier
, orgtype=null
referencingtablename=po_purchaseinfi_b
crefid=null
referencingkeycolumn=pk_stockps_b
referencedtablename=bd_supplier
referencingtablecolumn=pk_vmisupplier
referencedtablekey=pk_supplier
, orgtype=null
referencingtablename=arap_recstatementitem
crefid=null
referencingkeycolumn=pk_recstatementitem
referencedtablename=bd_supplier
referencingtablecolumn=pk_supplier
referencedtablekey=pk_supplier
, orgtype=null
referencingtablename=ia_i9bill
crefid=null
referencingkeycolumn=cbillid
referencedtablename=bd_supplier
referencingtablecolumn=cvendorid
referencedtablekey=pk_supplier
, orgtype=null
referencingtablename=cmp_recbilldetail
crefid=null
referencingkeycolumn=pk_recbill_detail
referencedtablename=bd_supplier
referencingtablecolumn=pk_supplier
referencedtablekey=pk_supplier
, orgtype=null
referencingtablename=sca_stdcost
crefid=null
referencingkeycolumn=cstdcostid
referencedtablename=bd_supplier
referencingtablecolumn=cvendorid
referencedtablekey=pk_supplier
, orgtype=null
select * from ap_estipayableitem a left join bd_supplier s on a.supplier = pk_supplier where name = ‘广州市广报产业园投资有限公司’
crefid=null
referencingkeycolumn=pk_estipayableitem
referencedtablename=bd_supplier
referencingtablecolumn=ordercubasdoc
referencedtablekey=pk_supplier
, orgtype=null
referencingtablename=ic_openbal_h
crefid=null
referencingkeycolumn=cgeneralhid
referencedtablename=bd_supplier
referencingtablecolumn=cvendorid
referencedtablekey=pk_supplier
, orgtype=null
referencingtablename=ia_idbill_b
crefid=null
referencingkeycolumn=cbill_bid
referencedtablename=bd_supplier
referencingtablecolumn=ccostvendorid
referencedtablekey=pk_supplier
, orgtype=null
referencingtablename=er_cshare_detail
crefid=null
referencingkeycolumn=pk_cshare_detail
referencedtablename=bd_supplier
referencingtablecolumn=hbbm
referencedtablekey=pk_supplier
, orgtype=null
referencingtablename=cm_revertbg_b
crefid=null
referencingkeycolumn=crevertbg_bid
referencedtablename=bd_supplier
referencingtablecolumn=cbvendorid
referencedtablekey=pk_supplier
, orgtype=null
referencingtablename=ic_transform_b
crefid=null
referencingkeycolumn=cspecialbid
referencedtablename=bd_supplier
referencingtablecolumn=cvendorid
referencedtablekey=pk_supplier
, orgtype=null
referencingtablename=pm_feebalance
crefid=null
referencingkeycolumn=pk_feebalance
referencedtablename=bd_supplier
referencingtablecolumn=pk_supplier
referencedtablekey=pk_supplier
, orgtype=null
referencingtablename=lcm_apply
crefid=null
referencingkeycolumn=pk_apply
referencedtablename=bd_supplier
referencingtablecolumn=beneficiary
referencedtablekey=pk_supplier
, orgtype=null
referencingtablename=arap_tally
crefid=null
referencingkeycolumn=pk_tally
referencedtablename=bd_supplier
referencingtablecolumn=supplier
referencedtablekey=pk_supplier
, orgtype=null
referencingtablename=ic_purchasein_h
crefid=null
referencingkeycolumn=cgeneralhid
referencedtablename=bd_supplier
referencingtablecolumn=cvendorid
referencedtablekey=pk_supplier
, orgtype=null
referencingtablename=sca_stdcost_b
crefid=null
referencingkeycolumn=cstdcost_bid
referencedtablename=bd_supplier
referencingtablecolumn=cvendorid
referencedtablekey=pk_supplier
, orgtype=null
referencingtablename=ia_i7bill_b
crefid=null
referencingkeycolumn=cbill_bid
referencedtablename=bd_supplier
referencingtablecolumn=cvendorid
referencedtablekey=pk_supplier
, orgtype=null
referencingtablename=po_initialest
crefid=null
referencingkeycolumn=pk_initialest
referencedtablename=bd_supplier
referencingtablecolumn=pk_supplier
referencedtablekey=pk_supplier
, orgtype=null
referencingtablename=po_storereq_b
crefid=null
referencingkeycolumn=pk_storereq_b
referencedtablename=bd_supplier
referencingtablecolumn=cvendorid
referencedtablekey=pk_supplier
, orgtype=null
referencingtablename=pm_proaccept_dut
crefid=null
referencingkeycolumn=pk_problemduty
referencedtablename=bd_supplier
referencingtablecolumn=pk_supplier
referencedtablekey=pk_supplier
, orgtype=null
referencingtablename=ia_i4bill_b
crefid=null
referencingkeycolumn=cbill_bid
referencedtablename=bd_supplier
referencingtablecolumn=cvendorid
referencedtablekey=pk_supplier
, orgtype=null
referencingtablename=ia_i6bill_b
crefid=null
referencingkeycolumn=cbill_bid
referencedtablename=bd_supplier
referencingtablecolumn=ccostvendorid
referencedtablekey=pk_supplier
, orgtype=null
referencingtablename=pca_costtmpdetail
crefid=null
referencingkeycolumn=pk_detail
referencedtablename=bd_supplier
referencingtablecolumn=pk_supplier
referencedtablekey=pk_supplier
, orgtype=null
referencingtablename=cmp_paybilldetail
crefid=null
referencingkeycolumn=pk_paybill_detail
referencedtablename=bd_supplier
referencingtablecolumn=pk_supplier
referencedtablekey=pk_supplier
, orgtype=null
referencingtablename=er_mtapp_detail
crefid=null
referencingkeycolumn=pk_mtapp_detail
referencedtablename=bd_supplier
referencingtablecolumn=pk_supplier
referencedtablekey=pk_supplier
, orgtype=null
referencingtablename=ic_atp
crefid=null
referencingkeycolumn=catpid
referencedtablename=bd_supplier
referencingtablecolumn=cvendorid
referencedtablekey=pk_supplier
, orgtype=null
referencingtablename=ct_price
crefid=null
referencingkeycolumn=pk_ct_price
referencedtablename=bd_supplier
referencingtablecolumn=cvendorid
referencedtablekey=pk_supplier
, orgtype=null
referencingtablename=pca_costdetail
crefid=null
referencingkeycolumn=pk_detail
referencedtablename=bd_supplier
referencingtablecolumn=pk_supplier
referencedtablekey=pk_supplier
, orgtype=null
referencingtablename=arap_baddebts_occu
crefid=null
referencingkeycolumn=pk_baddebts_occu
referencedtablename=bd_supplier
referencingtablecolumn=supplier
referencedtablekey=pk_supplier
, orgtype=null
referencingtablename=er_bxzb
crefid=null
referencingkeycolumn=pk_jkbx
referencedtablename=bd_supplier
referencingtablecolumn=hbbm
referencedtablekey=pk_supplier
, orgtype=null
referencingtablename=cmp_paybilldetail_commonuse
crefid=null
referencingkeycolumn=pk_paybill_detail
referencedtablename=bd_supplier
referencingtablecolumn=pk_supplier
referencedtablekey=pk_supplier
, orgtype=null
referencingtablename=ct_pu
crefid=null
referencingkeycolumn=pk_ct_pu
referencedtablename=bd_supplier
referencingtablecolumn=cvendorid
referencedtablekey=pk_supplier
, orgtype=null
referencingtablename=ia_idbill
crefid=null
referencingkeycolumn=cbillid
referencedtablename=bd_supplier
referencingtablecolumn=cvendorid
referencedtablekey=pk_supplier
, orgtype=null
referencingtablename=ic_openscrap_b
crefid=null
referencingkeycolumn=cgeneralbid
referencedtablename=bd_supplier
referencingtablecolumn=cvendorid
referencedtablekey=pk_supplier
, orgtype=null
referencingtablename=ic_supply
crefid=null
referencingkeycolumn=pk_supply
referencedtablename=bd_supplier
referencingtablecolumn=cvendorid
referencedtablekey=pk_supplier
, orgtype=null
referencingtablename=cm_inprostuff_b
crefid=null
referencingkeycolumn=cinprostuff_bid
referencedtablename=bd_supplier
referencingtablecolumn=cvendorid
referencedtablekey=pk_supplier
, orgtype=null
referencingtablename=bd_materialpu
crefid=null
referencingkeycolumn=pk_materialpu
referencedtablename=bd_supplier
referencingtablecolumn=pk_cumandoc
referencedtablekey=pk_supplier
, orgtype=null
referencingtablename=pd_rt
crefid=null
referencingkeycolumn=crtid
referencedtablename=bd_supplier
referencingtablecolumn=cvendorid
referencedtablekey=pk_supplier
, orgtype=null
referencingtablename=pm_projectbidresult_b
crefid=null
referencingkeycolumn=pk_probidresult_b
referencedtablename=bd_supplier
referencingtablecolumn=pk_supplier
referencedtablekey=pk_supplier
, orgtype=null
referencingtablename=er_expenseaccount
crefid=null
referencingkeycolumn=pk_expenseaccount
referencedtablename=bd_supplier
referencingtablecolumn=pk_supplier
referencedtablekey=pk_supplier
, orgtype=null
referencingtablename=sca_bom_extra
crefid=null
referencingkeycolumn=cbomextraid
referencedtablename=bd_supplier
referencingtablecolumn=cvendorid
referencedtablekey=pk_supplier
, orgtype=null
referencingtablename=po_arriveorder
crefid=null
referencingkeycolumn=pk_arriveorder
referencedtablename=bd_supplier
referencingtablecolumn=pk_supplier
referencedtablekey=pk_supplier
, orgtype=null
referencingtablename=ic_returnout_b
crefid=null
referencingkeycolumn=cgeneralbid
referencedtablename=bd_supplier
referencingtablecolumn=cvendorid
referencedtablekey=pk_supplier
, orgtype=null
referencingtablename=cmp_recbilldetail_commonuse
crefid=null
referencingkeycolumn=pk_recbill_detail
referencedtablename=bd_supplier
referencingtablecolumn=pk_supplier
referencedtablekey=pk_supplier
, orgtype=null
referencingtablename=arap_verifydetail
crefid=null
referencingkeycolumn=pk_verifydetail
referencedtablename=bd_supplier
referencingtablecolumn=supplier
referencedtablekey=pk_supplier
, orgtype=null
referencingtablename=pca_pcdetail
crefid=null
referencingkeycolumn=pk_pcaccount
referencedtablename=bd_supplier
referencingtablecolumn=pk_supplier
referencedtablekey=pk_supplier
, orgtype=null
referencingtablename=pm_feasiblity
crefid=null
referencingkeycolumn=pk_feasiblity
referencedtablename=bd_supplier
referencingtablecolumn=pk_supplier
referencedtablekey=pk_supplier
, orgtype=null
referencingtablename=sscct_paycontract
crefid=null
referencingkeycolumn=pk_paycontract
referencedtablename=bd_supplier
referencingtablecolumn=yifang_supplier
referencedtablekey=pk_supplier
, orgtype=null
referencingtablename=ic_finprodin_b
crefid=null
referencingkeycolumn=cgeneralbid
referencedtablename=bd_supplier
referencingtablecolumn=cprodvendorid
referencedtablekey=pk_supplier
, orgtype=null
referencingtablename=cm_ctrevertratio_b
crefid=null
referencingkeycolumn=cctrevertratiobid
referencedtablename=bd_supplier
referencingtablecolumn=cbvendorid
referencedtablekey=pk_supplier
, orgtype=null
referencingtablename=ic_wastage_b
crefid=null
referencingkeycolumn=cwastagebid
referencedtablename=bd_supplier
referencingtablecolumn=cvendorid
referencedtablekey=pk_supplier
, orgtype=null
referencingtablename=pm_securitypatrol
crefid=null
referencingkeycolumn=pk_securitypatrol
referencedtablename=bd_supplier
referencingtablecolumn=pk_supplier
referencedtablekey=pk_supplier
, orgtype=null
referencingtablename=purp_discount_h
crefid=null
referencingkeycolumn=pk_discount_h
referencedtablename=bd_supplier
referencingtablecolumn=pk_supplier
referencedtablekey=pk_supplier
, orgtype=null
referencingtablename=cm_allocfac_b
crefid=null
referencingkeycolumn=callocfac_bid
referencedtablename=bd_supplier
referencingtablecolumn=cvendorid
referencedtablekey=pk_supplier
, orgtype=null
referencingtablename=bd_supaddress
crefid=null
referencingkeycolumn=pk_address
referencedtablename=bd_supplier
referencingtablecolumn=pk_supplier
referencedtablekey=pk_supplier
, orgtype=null
referencingtablename=lcm_openregversion
crefid=null
referencingkeycolumn=pk_openmodify
referencedtablename=bd_supplier
referencingtablecolumn=pk_supplier
referencedtablekey=pk_supplier
, orgtype=null
referencingtablename=ic_atp_lock
crefid=null
referencingkeycolumn=catplockid
referencedtablename=bd_supplier
referencingtablecolumn=cvendorid
referencedtablekey=pk_supplier
, orgtype=null
referencingtablename=pm_qualissue
crefid=null
referencingkeycolumn=pk_qualissue
referencedtablename=bd_supplier
referencingtablecolumn=pk_supplier
referencedtablekey=pk_supplier
, orgtype=null
referencingtablename=po_invoice
crefid=null
referencingkeycolumn=pk_invoice
referencedtablename=bd_supplier
referencingtablecolumn=pk_paytosupplier
referencedtablekey=pk_supplier
, orgtype=null
referencingtablename=er_costshare
crefid=null
referencingkeycolumn=pk_costshare
referencedtablename=bd_supplier
referencingtablecolumn=hbbm
referencedtablekey=pk_supplier
, orgtype=null
referencingtablename=ia_calcrange
crefid=null
referencingkeycolumn=ccalcrangeid
referencedtablename=bd_supplier
referencingtablecolumn=cvendorid
referencedtablekey=pk_supplier
, orgtype=null
referencingtablename=pm_contr
crefid=null
referencingkeycolumn=pk_contr
referencedtablename=bd_supplier
referencingtablecolumn=pk_supplier
referencedtablekey=pk_supplier
, orgtype=null
referencingtablename=ia_hisdetailledger
crefid=null
referencingkeycolumn=cdetailledgerid
referencedtablename=bd_supplier
referencingtablecolumn=cvendorid
referencedtablekey=pk_supplier
, orgtype=null
referencingtablename=ic_pickbill_b
crefid=null
referencingkeycolumn=cgeneralbid
referencedtablename=bd_supplier
referencingtablecolumn=cvmivenderid
referencedtablekey=pk_supplier
, orgtype=null
referencingtablename=pm_materialacc
crefid=null
referencingkeycolumn=pk_materialacc
referencedtablename=bd_supplier
referencingtablecolumn=pk_supplier
referencedtablekey=pk_supplier
, orgtype=null
referencingtablename=ap_payableitem
crefid=null
referencingkeycolumn=pk_payableitem
referencedtablename=bd_supplier
referencingtablecolumn=ordercubasdoc
referencedtablekey=pk_supplier
, orgtype=null
referencingtablename=er_sruledata
crefid=null
referencingkeycolumn=pk_cshare_detail
referencedtablename=bd_supplier
referencingtablecolumn=hbbm
referencedtablekey=pk_supplier
, orgtype=null
referencingtablename=ic_atp_f
crefid=null
referencingkeycolumn=catpid
referencedtablename=bd_supplier
referencingtablecolumn=cvendorid
referencedtablekey=pk_supplier
, orgtype=null
referencingtablename=cm_alcrecord
crefid=null
referencingkeycolumn=calcrecordid
referencedtablename=bd_supplier
referencingtablecolumn=cvendorid
referencedtablekey=pk_supplier
, orgtype=null
referencingtablename=ic_material_h
crefid=null
referencingkeycolumn=cgeneralhid
referencedtablename=bd_supplier
referencingtablecolumn=cconstructvendorid
referencedtablekey=pk_supplier
, orgtype=null
referencingtablename=cm_ctrevert
crefid=null
referencingkeycolumn=pk_ctrevert
referencedtablename=bd_supplier
referencingtablecolumn=cvendorid
referencedtablekey=pk_supplier
, orgtype=null
referencingtablename=ic_teardown_b
crefid=null
referencingkeycolumn=cspecialbid
referencedtablename=bd_supplier
referencingtablecolumn=cvendorid
referencedtablekey=pk_supplier
, orgtype=null
referencingtablename=lcm_payment
crefid=null
referencingkeycolumn=pk_payment
referencedtablename=bd_supplier
referencingtablecolumn=pk_supplier
referencedtablekey=pk_supplier
, orgtype=null
referencingtablename=ia_iibill
crefid=null
referencingkeycolumn=cbillid
referencedtablename=bd_supplier
referencingtablecolumn=cvendorid
referencedtablekey=pk_supplier
, orgtype=null
referencingtablename=iv_invoice
crefid=null
referencingkeycolumn=pk_invoice
referencedtablename=bd_supplier
referencingtablecolumn=supplierid
referencedtablekey=pk_supplier
, orgtype=null
referencingtablename=ic_openbal_b
crefid=null
referencingkeycolumn=cgeneralbid
referencedtablename=bd_supplier
referencingtablecolumn=cvendorid
referencedtablekey=pk_supplier
, orgtype=null
referencingtablename=ic_purchasein_b
crefid=null
referencingkeycolumn=cgeneralbid
referencedtablename=bd_supplier
referencingtablecolumn=cvendorid
referencedtablekey=pk_supplier
, orgtype=null
referencingtablename=cm_subitemcost
crefid=null
referencingkeycolumn=csubitemcostid
referencedtablename=bd_supplier
referencingtablecolumn=cvendorid
referencedtablekey=pk_supplier
, orgtype=null
referencingtablename=ia_iabill_b
crefid=null
referencingkeycolumn=cbill_bid
referencedtablename=bd_supplier
referencingtablecolumn=cvendorid
referencedtablekey=pk_supplier
, orgtype=null
referencingtablename=pm_discontr
crefid=null
referencingkeycolumn=pk_discontr
referencedtablename=bd_supplier
referencingtablecolumn=pk_supplier
referencedtablekey=pk_supplier
, orgtype=null
referencingtablename=ic_finprodin_b
crefid=null
referencingkeycolumn=cgeneralbid
referencedtablename=bd_supplier
referencingtablecolumn=cvmivenderid
referencedtablekey=pk_supplier
, orgtype=null
referencingtablename=bd_supstock
crefid=null
referencingkeycolumn=pk_supstock
referencedtablename=bd_supplier
referencingtablecolumn=pk_gathering
referencedtablekey=pk_supplier
, orgtype=null
referencingtablename=ia_igbill
crefid=null
referencingkeycolumn=cbillid
referencedtablename=bd_supplier
referencingtablecolumn=cvendorid
referencedtablekey=pk_supplier
, orgtype=null
referencingtablename=cm_actcost_b
crefid=null
referencingkeycolumn=cactcost_bid
referencedtablename=bd_supplier
referencingtablecolumn=cvendorid
referencedtablekey=pk_supplier
, orgtype=null
referencingtablename=lcm_openregister
crefid=null
referencingkeycolumn=pk_register
referencedtablename=bd_supplier
referencingtablecolumn=pk_supplier
referencedtablekey=pk_supplier
, orgtype=null
referencingtablename=bd_supplier
crefid=null
referencingkeycolumn=pk_supplier
referencedtablename=bd_supplier
referencingtablecolumn=pk_supplier_main
referencedtablekey=pk_supplier
, orgtype=null
referencingtablename=ic_whstrans_b
crefid=null
referencingkeycolumn=cspecialbid
referencedtablename=bd_supplier
referencingtablecolumn=cvmivenderid
referencedtablekey=pk_supplier
, orgtype=null
referencingtablename=cm_ctrevert_b
crefid=null
referencingkeycolumn=pk_ctrevert_b
referencedtablename=bd_supplier
referencingtablecolumn=cvendorid
referencedtablekey=pk_supplier
, orgtype=null
referencingtablename=po_invoice_b
crefid=null
referencingkeycolumn=pk_invoice_b
referencedtablename=bd_supplier
referencingtablecolumn=pk_supplier
referencedtablekey=pk_supplier
, orgtype=null
referencingtablename=pca_balance
crefid=null
referencingkeycolumn=pk_balance
referencedtablename=bd_supplier
referencingtablecolumn=pk_supplier
referencedtablekey=pk_supplier
, orgtype=null
referencingtablename=ic_purchasein_b
crefid=null
referencingkeycolumn=cgeneralbid
referencedtablename=bd_supplier
referencingtablecolumn=cvmivenderid
referencedtablekey=pk_supplier
, orgtype=null
referencingtablename=ic_sapply_h
crefid=null
referencingkeycolumn=cgeneralhid
referencedtablename=bd_supplier
referencingtablecolumn=cconstructvendorid
referencedtablekey=pk_supplier
, orgtype=null
referencingtablename=ic_borrowout_b
crefid=null
referencingkeycolumn=cgeneralbid
referencedtablename=bd_supplier
referencingtablecolumn=cvmivenderid
referencedtablekey=pk_supplier
, orgtype=null
referencingtablename=ic_assetout_b
crefid=null
referencingkeycolumn=cgeneralbid
referencedtablename=bd_supplier
referencingtablecolumn=cvendorid
referencedtablekey=pk_supplier
, orgtype=null
referencingtablename=bd_ffile
crefid=null
referencingkeycolumn=cffileid
referencedtablename=bd_supplier
referencingtablecolumn=cvendorid
referencedtablekey=pk_supplier
, orgtype=null
referencingtablename=cm_scraprecl_b
crefid=null
referencingkeycolumn=cscraprecl_bid
referencedtablename=bd_supplier
referencingtablecolumn=cvendorid
referencedtablekey=pk_supplier
, orgtype=null
referencingtablename=fa_transasset_b
crefid=null
referencingkeycolumn=pk_transasset_b
referencedtablename=bd_supplier
referencingtablecolumn=pk_supplier
referencedtablekey=pk_supplier
, orgtype=null
referencingtablename=pm_materialtr
crefid=null
referencingkeycolumn=pk_materialtr
referencedtablename=bd_supplier
referencingtablecolumn=pk_supplier
referencedtablekey=pk_supplier
, orgtype=null
referencingtablename=pm_problem
crefid=null
referencingkeycolumn=pk_problem
referencedtablename=bd_supplier
referencingtablecolumn=pk_supplier
referencedtablekey=pk_supplier
, orgtype=null
referencingtablename=ic_transin_b
crefid=null
referencingkeycolumn=cgeneralbid
referencedtablename=bd_supplier
referencingtablecolumn=cvendorid
referencedtablekey=pk_supplier
, orgtype=null
referencingtablename=pm_qcrecord
crefid=null
referencingkeycolumn=pk_qcrecord
referencedtablename=bd_supplier
referencingtablecolumn=pk_supplier
referencedtablekey=pk_supplier
, orgtype=null
referencingtablename=pm_compevaluate
crefid=null
referencingkeycolumn=pk_compevaluate
referencedtablename=bd_supplier
referencingtablecolumn=pk_supplier
referencedtablekey=pk_supplier
, orgtype=null
referencingtablename=arap_busidata
crefid=null
referencingkeycolumn=pk_busidata
referencedtablename=bd_supplier
referencingtablecolumn=supplier
referencedtablekey=pk_supplier
, orgtype=null
referencingtablename=fct_ar_b
crefid=null
referencingkeycolumn=pk_fct_ar_b
referencedtablename=bd_supplier
referencingtablecolumn=cvendorid
referencedtablekey=pk_supplier
, orgtype=null
referencingtablename=bd_bom_outputs
crefid=null
referencingkeycolumn=cbom_outputsid
referencedtablename=bd_supplier
referencingtablecolumn=cvendorid
referencedtablekey=pk_supplier
, orgtype=null
referencingtablename=po_order_b
crefid=null
referencingkeycolumn=pk_order_b
referencedtablename=bd_supplier
referencingtablecolumn=pk_supplier
referencedtablekey=pk_supplier
, orgtype=null
referencingtablename=po_praypriceinfo
crefid=null
referencingkeycolumn=pk_priceinfo
referencedtablename=bd_supplier
referencingtablecolumn=pk_supplier1
referencedtablekey=pk_supplier
, orgtype=null
referencingtablename=cm_alcrecord_b
crefid=null
referencingkeycolumn=calcrecord_bid
referencedtablename=bd_supplier
referencingtablecolumn=cvendorid
referencedtablekey=pk_supplier
, orgtype=null
referencingtablename=ia_ijbill_b
crefid=null
referencingkeycolumn=cbill_bid
referencedtablename=bd_supplier
referencingtablecolumn=cvendorid
referencedtablekey=pk_supplier
, orgtype=null
referencingtablename=po_subcontinfi_b
crefid=null
referencingkeycolumn=pk_stockps_b
referencedtablename=bd_supplier
referencingtablecolumn=pk_supplier
referencedtablekey=pk_supplier
, orgtype=null
referencingtablename=ic_sapply_b
crefid=null
referencingkeycolumn=cgeneralbid
referencedtablename=bd_supplier
referencingtablecolumn=cvendorid
referencedtablekey=pk_supplier
, orgtype=null
referencingtablename=ar_gatheritem
crefid=null
referencingkeycolumn=pk_gatheritem
referencedtablename=bd_supplier
referencingtablecolumn=supplier
referencedtablekey=pk_supplier
, orgtype=null
referencingtablename=pm_mater_stock
crefid=null
referencingkeycolumn=pk_mater_stock
referencedtablename=bd_supplier
referencingtablecolumn=pk_supplier
referencedtablekey=pk_supplier
, orgtype=null
referencingtablename=ia_iebill_b
crefid=null
referencingkeycolumn=cbill_bid
referencedtablename=bd_supplier
referencingtablecolumn=cvendorid
referencedtablekey=pk_supplier
, orgtype=null
referencingtablename=ap_estipayableitem
crefid=null
referencingkeycolumn=pk_estipayableitem
referencedtablename=bd_supplier
referencingtablecolumn=supplier
referencedtablekey=pk_supplier
, orgtype=null
referencingtablename=po_praybill_b
crefid=null
referencingkeycolumn=pk_praybill_b
referencedtablename=bd_supplier
referencingtablecolumn=pk_suggestsupplier
referencedtablekey=pk_supplier
, orgtype=null
referencingtablename=sca_costrevert
crefid=null
referencingkeycolumn=pk_costrevert
referencedtablename=bd_supplier
referencingtablecolumn=cvendorid
referencedtablekey=pk_supplier
, orgtype=null
referencingtablename=batm_detail_counter
crefid=null
referencingkeycolumn=pk_counter
referencedtablename=bd_supplier
referencingtablecolumn=endorser
referencedtablekey=pk_supplier
, orgtype=null
referencingtablename=po_order_price
crefid=null
referencingkeycolumn=pk_order_price
referencedtablename=bd_supplier
referencingtablecolumn=pk_supplier
referencedtablekey=pk_supplier
, orgtype=null
referencingtablename=ic_generalin_b
crefid=null
referencingkeycolumn=cgeneralbid
referencedtablename=bd_supplier
referencingtablecolumn=cvendorid
referencedtablekey=pk_supplier
, orgtype=null
referencingtablename=ic_returnin_b
crefid=null
referencingkeycolumn=cgeneralbid
referencedtablename=bd_supplier
referencingtablecolumn=cvmivenderid
referencedtablekey=pk_supplier
, orgtype=null
referencingtablename=po_purchaseinfi_b
crefid=null
referencingkeycolumn=pk_stockps_b
referencedtablename=bd_supplier
referencingtablecolumn=pk_supplier
referencedtablekey=pk_supplier
, orgtype=null
referencingtablename=ic_returnout_b
crefid=null
referencingkeycolumn=cgeneralbid
referencedtablename=bd_supplier
referencingtablecolumn=cvmivenderid
referencedtablekey=pk_supplier
, orgtype=null
referencingtablename=ic_transout_b
crefid=null
referencingkeycolumn=cgeneralbid
referencedtablename=bd_supplier
referencingtablecolumn=cvmivenderid
referencedtablekey=pk_supplier
, orgtype=null
referencingtablename=fa_card
crefid=null
referencingkeycolumn=pk_card
referencedtablename=bd_supplier
referencingtablecolumn=provider
referencedtablekey=pk_supplier
, orgtype=null
referencingtablename=mapub_acquirepricelog
crefid=null
referencingkeycolumn=pk_log
referencedtablename=bd_supplier
referencingtablecolumn=cvendorid
referencedtablekey=pk_supplier
, orgtype=null
referencingtablename=po_order
crefid=null
referencingkeycolumn=pk_order
referencedtablename=bd_supplier
referencingtablecolumn=pk_invcsupllier
referencedtablekey=pk_supplier
, orgtype=null
referencingtablename=ic_material_b
crefid=null
referencingkeycolumn=cgeneralbid
referencedtablename=bd_supplier
referencingtablecolumn=cvmivenderid
referencedtablekey=pk_supplier
, orgtype=null
referencingtablename=bd_bom_repl
crefid=null
referencingkeycolumn=cbom_replaceid
referencedtablename=bd_supplier
referencingtablecolumn=cvendorid
referencedtablekey=pk_supplier
, orgtype=null
referencingtablename=dm_carrier
crefid=null
referencingkeycolumn=ccarrierid
referencedtablename=bd_supplier
referencingtablecolumn=csupplierid
referencedtablekey=pk_supplier
, orgtype=null
referencingtablename=cmp_changebilldetail_cu
crefid=null
referencingkeycolumn=pk_changebill_detail
referencedtablename=bd_supplier
referencingtablecolumn=pk_supplier
referencedtablekey=pk_supplier
, orgtype=null
referencingtablename=ic_material_b
crefid=null
referencingkeycolumn=cgeneralbid
referencedtablename=bd_supplier
referencingtablecolumn=cprodvendorid
referencedtablekey=pk_supplier
, orgtype=null
referencingtablename=ic_pickbill_b
crefid=null
referencingkeycolumn=cgeneralbid
referencedtablename=bd_supplier
referencingtablecolumn=cvendorid
referencedtablekey=pk_supplier
, orgtype=null
referencingtablename=ic_returnin_b
crefid=null
referencingkeycolumn=cgeneralbid
referencedtablename=bd_supplier
referencingtablecolumn=cvendorid
referencedtablekey=pk_supplier
, orgtype=null
referencingtablename=ic_vmi_sum
crefid=null
referencingkeycolumn=cvmihid
referencedtablename=bd_supplier
referencingtablecolumn=cvendorid
referencedtablekey=pk_supplier
, orgtype=null
referencingtablename=pca_summary
crefid=null
referencingkeycolumn=pk_pcsummary
referencedtablename=bd_supplier
referencingtablecolumn=pk_supplier
referencedtablekey=pk_supplier
, orgtype=null
referencingtablename=qc_checkitem
crefid=null
referencingkeycolumn=pk_checkitem
referencedtablename=bd_supplier
referencingtablecolumn=pk_outsupplier
referencedtablekey=pk_supplier
, orgtype=null
referencingtablename=ia_i2bill
crefid=null
referencingkeycolumn=cbillid
referencedtablename=bd_supplier
referencingtablecolumn=cvendorid
referencedtablekey=pk_supplier
, orgtype=null
referencingtablename=ic_invcount_b
crefid=null
referencingkeycolumn=cspecialbid
referencedtablename=bd_supplier
referencingtablecolumn=cvendorid
referencedtablekey=pk_supplier
, orgtype=null
referencingtablename=pm_projectproduct
crefid=null
referencingkeycolumn=pk_projectproduct
referencedtablename=bd_supplier
referencingtablecolumn=pk_supplier
referencedtablekey=pk_supplier
, orgtype=null
referencingtablename=ic_generalout_b
crefid=null
referencingkeycolumn=cgeneralbid
referencedtablename=bd_supplier
referencingtablecolumn=cvendorid
referencedtablekey=pk_supplier
, orgtype=null
referencingtablename=pm_qualitypatrol
crefid=null
referencingkeycolumn=pk_qualitypatrol
referencedtablename=bd_supplier
referencingtablecolumn=respunit
referencedtablekey=pk_supplier
, orgtype=null
referencingtablename=pca_initdetail
crefid=null
referencingkeycolumn=pk_detail
referencedtablename=bd_supplier
referencingtablecolumn=pk_supplier
referencedtablekey=pk_supplier
, orgtype=null
referencingtablename=ap_payitem
crefid=null
referencingkeycolumn=pk_payitem
referencedtablename=bd_supplier
referencingtablecolumn=supplier
referencedtablekey=pk_supplier
, orgtype=null
referencingtablename=ic_assetin_b
crefid=null
referencingkeycolumn=cgeneralbid
referencedtablename=bd_supplier
referencingtablecolumn=cvmivenderid
referencedtablekey=pk_supplier
, orgtype=null
referencingtablename=ic_wasterprocess_b
crefid=null
referencingkeycolumn=cgeneralbid
referencedtablename=bd_supplier
referencingtablecolumn=cvendorid
referencedtablekey=pk_supplier
, orgtype=null
referencingtablename=bd_supstock
crefid=null
referencingkeycolumn=pk_supstock
referencedtablename=bd_supplier
referencingtablecolumn=billingsup
referencedtablekey=pk_supplier
, orgtype=null
referencingtablename=er_bxzb
crefid=null
referencingkeycolumn=pk_jkbx
referencedtablename=bd_supplier
referencingtablecolumn=hbbm
referencedtablekey=pk_supplier
, orgtype=null
referencingtablename=pd_meastool
crefid=null
referencingkeycolumn=cmeastoolid
referencedtablename=bd_supplier
referencingtablecolumn=cvendorid
referencedtablekey=pk_supplier
, orgtype=null
referencingtablename=cmp_changebilldetail
crefid=null
referencingkeycolumn=pk_changebill_detail
referencedtablename=bd_supplier
referencingtablecolumn=pk_supplier
referencedtablekey=pk_supplier
, orgtype=null
referencingtablename=ic_generalin_b
crefid=null
referencingkeycolumn=cgeneralbid
referencedtablename=bd_supplier
referencingtablecolumn=cvmivenderid
referencedtablekey=pk_supplier
, orgtype=null
referencingtablename=lcm_apply
crefid=null
referencingkeycolumn=pk_apply
referencedtablename=bd_supplier
referencingtablecolumn=pk_supplier
referencedtablekey=pk_supplier
, orgtype=null
referencingtablename=ic_onhanddim
crefid=null
referencingkeycolumn=pk_onhanddim
referencedtablename=bd_supplier
referencingtablecolumn=cvmivenderid
referencedtablekey=pk_supplier
, orgtype=null
referencingtablename=ic_openbal_b
crefid=null
referencingkeycolumn=cgeneralbid
referencedtablename=bd_supplier
referencingtablecolumn=cvmivenderid
referencedtablekey=pk_supplier
, orgtype=null
referencingtablename=fa_card
crefid=null
referencingkeycolumn=pk_card
referencedtablename=bd_supplier
referencingtablecolumn=provider
referencedtablekey=pk_supplier
, orgtype=null
referencingtablename=pm_budgetbegining_b
crefid=null
referencingkeycolumn=pk_budgetbegin_b
referencedtablename=bd_supplier
referencingtablecolumn=pk_supplier
referencedtablekey=pk_supplier
, orgtype=null
referencingtablename=sca_stdcost
crefid=null
referencingkeycolumn=cstdcostid
referencedtablename=bd_supplier
referencingtablecolumn=cmainvendorid
referencedtablekey=pk_supplier
, orgtype=null
referencingtablename=cm_prodcost_b
crefid=null
referencingkeycolumn=cprodcost_bid
referencedtablename=bd_supplier
referencingtablecolumn=cvendorid
referencedtablekey=pk_supplier
, orgtype=null
referencingtablename=ic_locadjust_b
crefid=null
referencingkeycolumn=cgeneralbid
referencedtablename=bd_supplier
referencingtablecolumn=cvmivenderid
referencedtablekey=pk_supplier
, orgtype=null
referencingtablename=ia_iabill_b
crefid=null
referencingkeycolumn=cbill_bid
referencedtablename=bd_supplier
referencingtablecolumn=ccostvendorid
referencedtablekey=pk_supplier
, orgtype=null
referencingtablename=ap_payableitem
crefid=null
referencingkeycolumn=pk_payableitem
referencedtablename=bd_supplier
referencingtablecolumn=supplier
referencedtablekey=pk_supplier
, orgtype=null
referencingtablename=ic_material_b
crefid=null
referencingkeycolumn=cgeneralbid
referencedtablename=bd_supplier
referencingtablecolumn=cvendorid
referencedtablekey=pk_supplier
, orgtype=null
referencingtablename=ia_i6bill_b
crefid=null
referencingkeycolumn=cbill_bid
referencedtablename=bd_supplier
referencingtablecolumn=cvendorid
referencedtablekey=pk_supplier
, orgtype=null
referencingtablename=pm_alter
crefid=null
referencingkeycolumn=pk_alter
referencedtablename=bd_supplier
referencingtablecolumn=supplier
referencedtablekey=pk_supplier
, orgtype=null
referencingtablename=arap_baddebts_rece
crefid=null
referencingkeycolumn=pk_baddebts_rece
referencedtablename=bd_supplier
referencingtablecolumn=supplier
referencedtablekey=pk_supplier
, orgtype=null
referencingtablename=ic_saleout_b
crefid=null
referencingkeycolumn=cgeneralbid
referencedtablename=bd_supplier
referencingtablecolumn=cvmivenderid
referencedtablekey=pk_supplier
, orgtype=null
referencingtablename=ic_flowaccount_his
crefid=null
referencingkeycolumn=pk_flow
referencedtablename=bd_supplier
referencingtablecolumn=cvendorid
referencedtablekey=pk_supplier
, orgtype=null
referencingtablename=pd_rt_b
crefid=null
referencingkeycolumn=crt_bid
referencedtablename=bd_supplier
referencingtablecolumn=cboutvendorid
referencedtablekey=pk_supplier
, orgtype=null
referencingtablename=bd_stordoc
crefid=null
referencingkeycolumn=pk_stordoc
referencedtablename=bd_supplier
referencingtablecolumn=operatesupplier
referencedtablekey=pk_supplier
, orgtype=null
referencingtablename=ic_discardin_b
crefid=null
referencingkeycolumn=cgeneralbid
referencedtablename=bd_supplier
referencingtablecolumn=cvendorid
referencedtablekey=pk_supplier
, orgtype=null
referencingtablename=pm_sp_issue
crefid=null
referencingkeycolumn=pk_sp_issue
referencedtablename=bd_supplier
referencingtablecolumn=pk_supplier
referencedtablekey=pk_supplier
, orgtype=null
referencingtablename=po_purchaseinfi_fee
crefid=null
referencingkeycolumn=pk_stockps_fee
referencedtablename=bd_supplier
referencingtablecolumn=pk_supplier
referencedtablekey=pk_supplier
, orgtype=null
referencingtablename=po_settlebill_b
crefid=null
referencingkeycolumn=pk_settlebill_b
referencedtablename=bd_supplier
referencingtablecolumn=pk_supplier
referencedtablekey=pk_supplier
, orgtype=null
referencingtablename=sscct_paycontract
crefid=null
referencingkeycolumn=pk_paycontract
referencedtablename=bd_supplier
referencingtablecolumn=bingfang_supplier
referencedtablekey=pk_supplier
, orgtype=null
referencingtablename=ic_adjusterr_h
crefid=null
referencingkeycolumn=cgeneralhid
referencedtablename=bd_supplier
referencingtablecolumn=cvendorid
referencedtablekey=pk_supplier
, orgtype=null
referencingtablename=pca_transdetail
crefid=null
referencingkeycolumn=pk_detail
referencedtablename=bd_supplier
referencingtablecolumn=pk_supplier
referencedtablekey=pk_supplier
, orgtype=null
referencingtablename=fiweb_verifylist
crefid=null
referencingkeycolumn=pk_verify
referencedtablename=bd_supplier
referencingtablecolumn=supplier
referencedtablekey=pk_supplier
, orgtype=null
referencingtablename=batm_detail_counter
crefid=null
referencingkeycolumn=pk_counter
referencedtablename=bd_supplier
referencingtablecolumn=endorsee
referencedtablekey=pk_supplier
, orgtype=null
referencingtablename=pm_mateplanadd_b
crefid=null
referencingkeycolumn=pk_matplanadd_b
referencedtablename=bd_supplier
referencingtablecolumn=pk_supplier
referencedtablekey=pk_supplier
, orgtype=null
referencingtablename=pm_mater_plan_b
crefid=null
referencingkeycolumn=pk_mater_plan_b
referencedtablename=bd_supplier
referencingtablecolumn=pk_supplier
referencedtablekey=pk_supplier
, orgtype=null
referencingtablename=ic_flowaccount_his
crefid=null
referencingkeycolumn=pk_flow
referencedtablename=bd_supplier
referencingtablecolumn=cvmivenderid
referencedtablekey=pk_supplier
, orgtype=null
referencingtablename=pd_pb
crefid=null
referencingkeycolumn=pk_batchcode
referencedtablename=bd_supplier
referencingtablecolumn=cvendorid
referencedtablekey=pk_supplier
, orgtype=null
referencingtablename=er_jkzb
crefid=null
referencingkeycolumn=pk_jkbx
referencedtablename=bd_supplier
referencingtablecolumn=hbbm
referencedtablekey=pk_supplier
, orgtype=null
referencingtablename=ic_discardin_b
crefid=null
referencingkeycolumn=cgeneralbid
referencedtablename=bd_supplier
referencingtablecolumn=cprodvendorid
referencedtablekey=pk_supplier
, orgtype=null
referencingtablename=ic_subcontin_b
crefid=null
referencingkeycolumn=cgeneralbid
referencedtablename=bd_supplier
referencingtablecolumn=cmainvendorid
referencedtablekey=pk_supplier
, orgtype=null
referencingtablename=pm_check_issue
crefid=null
referencingkeycolumn=pk_leave_issue
referencedtablename=bd_supplier
referencingtablecolumn=pk_supplier
referencedtablekey=pk_supplier
, orgtype=null
referencingtablename=po_vmifi_fee
crefid=null
referencingkeycolumn=pk_stockps_fee
referencedtablename=bd_supplier
referencingtablecolumn=pk_supplier
referencedtablekey=pk_supplier
, orgtype=null
referencingtablename=ic_subcontin_b
crefid=null
referencingkeycolumn=cgeneralbid
referencedtablename=bd_supplier
referencingtablecolumn=cvendorid
referencedtablekey=pk_supplier
, orgtype=null
referencingtablename=sca_bom
crefid=null
referencingkeycolumn=ccmbomid
referencedtablename=bd_supplier
referencingtablecolumn=cvendorid
referencedtablekey=pk_supplier
, orgtype=null
referencingtablename=ic_assetout_b
crefid=null
referencingkeycolumn=cgeneralbid
referencedtablename=bd_supplier
referencingtablecolumn=cvmivenderid
referencedtablekey=pk_supplier
, orgtype=null
referencingtablename=mapub_materialpricebase_b
crefid=null
referencingkeycolumn=cmaterialprice_bid
referencedtablename=bd_supplier
referencingtablecolumn=cvendorid
referencedtablekey=pk_supplier
, orgtype=null
referencingtablename=fct_ap
crefid=null
referencingkeycolumn=pk_fct_ap
referencedtablename=bd_supplier
referencingtablecolumn=cvendorid
referencedtablekey=pk_supplier
, orgtype=null
referencingtablename=bd_fprice
crefid=null
referencingkeycolumn=cfpriceid
referencedtablename=bd_supplier
referencingtablecolumn=cvendorid
referencedtablekey=pk_supplier
, orgtype=null
referencingtablename=cm_lastadjust_b
crefid=null
referencingkeycolumn=clastadjust_bid
referencedtablename=bd_supplier
referencingtablecolumn=cvendorid
referencedtablekey=pk_supplier
, orgtype=null
referencingtablename=pm_qualityevaluate
crefid=null
referencingkeycolumn=pk_qualityeval
referencedtablename=bd_supplier
referencingtablecolumn=pk_supplier
referencedtablekey=pk_supplier
, orgtype=null
referencingtablename=ic_assetin_b
crefid=null
referencingkeycolumn=cgeneralbid
referencedtablename=bd_supplier
referencingtablecolumn=cvendorid
referencedtablekey=pk_supplier
, orgtype=null
referencingtablename=po_pricesettle
crefid=null
referencingkeycolumn=pk_pricesettle
referencedtablename=bd_supplier
referencingtablecolumn=pk_supplier
referencedtablekey=pk_supplier
, orgtype=null
referencingtablename=cm_costobject
crefid=null
referencingkeycolumn=ccostobjectid
referencedtablename=bd_supplier
referencingtablecolumn=cvendorid
referencedtablekey=pk_supplier
, orgtype=null
referencingtablename=ia_i3bill_b
crefid=null
referencingkeycolumn=cbill_bid
referencedtablename=bd_supplier
referencingtablecolumn=cvendorid
referencedtablekey=pk_supplier
, orgtype=null
referencingtablename=ic_flow
crefid=null
referencingkeycolumn=pk_flow
referencedtablename=bd_supplier
referencingtablecolumn=cvmivenderid
referencedtablekey=pk_supplier
, orgtype=null
referencingtablename=gl_docfree1
crefid=null
referencingkeycolumn=assid
referencedtablename=bd_supplier
referencingtablecolumn=f14
referencedtablekey=pk_supplier
, orgtype=null
referencingtablename=ic_reserve
crefid=null
referencingkeycolumn=pk_reserve
referencedtablename=bd_supplier
referencingtablecolumn=cvendorid
referencedtablekey=pk_supplier
, orgtype=null
referencingtablename=ic_assembly_b
crefid=null
referencingkeycolumn=cspecialbid
referencedtablename=bd_supplier
referencingtablecolumn=cvendorid
referencedtablekey=pk_supplier
, orgtype=null
referencingtablename=er_mtapp_bill
crefid=null
referencingkeycolumn=pk_mtapp_bill
referencedtablename=bd_supplier
referencingtablecolumn=pk_supplier
referencedtablekey=pk_supplier
, orgtype=null
referencingtablename=cm_inprocost_b
crefid=null
referencingkeycolumn=cinprocost_bid
referencedtablename=bd_supplier
referencingtablecolumn=cvendorid
referencedtablekey=pk_supplier
, orgtype=null
referencingtablename=lcm_arrival
crefid=null
referencingkeycolumn=pk_arrival
referencedtablename=bd_supplier
referencingtablecolumn=pk_supplier
referencedtablekey=pk_supplier
, orgtype=null
referencingtablename=bd_bom_b
crefid=null
referencingkeycolumn=cbom_bid
referencedtablename=bd_supplier
referencingtablecolumn=cvendorid
referencedtablekey=pk_supplier
, orgtype=null
referencingtablename=cm_iastuff_b
crefid=null
referencingkeycolumn=ciastuff_bid
referencedtablename=bd_supplier
referencingtablecolumn=cvendorid
referencedtablekey=pk_supplier
, orgtype=null
referencingtablename=ia_hisdetailledger
crefid=null
referencingkeycolumn=cdetailledgerid
referencedtablename=bd_supplier
referencingtablecolumn=ccostvendorid
referencedtablekey=pk_supplier
, orgtype=null
referencingtablename=er_busitem
crefid=null
referencingkeycolumn=pk_busitem
referencedtablename=bd_supplier
referencingtablecolumn=hbbm
referencedtablekey=pk_supplier
, orgtype=null
referencingtablename=pm_deduct
crefid=null
referencingkeycolumn=pk_deduct
referencedtablename=bd_supplier
referencingtablecolumn=pk_supplier
referencedtablekey=pk_supplier
, orgtype=null
referencingtablename=dm_prepaidinvoice
crefid=null
referencingkeycolumn=cinvoice_hid
referencedtablename=bd_supplier
referencingtablecolumn=capcustid
referencedtablekey=pk_supplier
, orgtype=null
referencingtablename=sca_costrevert_b
crefid=null
referencingkeycolumn=pk_costrevert_b
referencedtablename=bd_supplier
referencingtablecolumn=cvendorid
referencedtablekey=pk_supplier
, orgtype=null
referencingtablename=ia_detailledger
crefid=null
referencingkeycolumn=cdetailledgerid
referencedtablename=bd_supplier
referencingtablecolumn=cvendorid
referencedtablekey=pk_supplier
, orgtype=null
referencingtablename=po_order_bb_vo
crefid=null
referencingkeycolumn=pk_order_bb
referencedtablename=bd_supplier
referencingtablecolumn=ccarrier
referencedtablekey=pk_supplier
, orgtype=null
referencingtablename=ic_onhanddim
crefid=null
referencingkeycolumn=pk_onhanddim
referencedtablename=bd_supplier
referencingtablecolumn=cvendorid
referencedtablekey=pk_supplier
, orgtype=null
referencingtablename=ia_i3bill_b
crefid=null
referencingkeycolumn=cbill_bid
referencedtablename=bd_supplier
referencingtablecolumn=ccostvendorid
referencedtablekey=pk_supplier
, orgtype=null
referencingtablename=ic_finprodin_b
crefid=null
referencingkeycolumn=cgeneralbid
referencedtablename=bd_supplier
referencingtablecolumn=cvendorid
referencedtablekey=pk_supplier
, orgtype=null
referencingtablename=lcm_openmodify
crefid=null
referencingkeycolumn=pk_openmodify
referencedtablename=bd_supplier
referencingtablecolumn=pk_supplier
referencedtablekey=pk_supplier
, orgtype=null
referencingtablename=ic_locadjust_b
crefid=null
referencingkeycolumn=cgeneralbid
referencedtablename=bd_supplier
referencingtablecolumn=cvendorid
referencedtablekey=pk_supplier
, orgtype=null
referencingtablename=ia_i0bill_b
crefid=null
referencingkeycolumn=cbill_bid
referencedtablename=bd_supplier
referencingtablecolumn=cvendorid
referencedtablekey=pk_supplier
, orgtype=null
referencingtablename=sca_bom_errmsg
crefid=null
referencingkeycolumn=pkmartacvt
referencedtablename=bd_supplier
referencingtablecolumn=cvendorid
referencedtablekey=pk_supplier
, orgtype=null
referencingtablename=ic_generalout_b
crefid=null
referencingkeycolumn=cgeneralbid
referencedtablename=bd_supplier
referencingtablecolumn=cvmivenderid
referencedtablekey=pk_supplier
, orgtype=null
referencingtablename=ic_saleout_b
crefid=null
referencingkeycolumn=cgeneralbid
referencedtablename=bd_supplier
referencingtablecolumn=cvendorid
referencedtablekey=pk_supplier
, orgtype=null
referencingtablename=ic_discardout_b
crefid=null
referencingkeycolumn=cgeneralbid
referencedtablename=bd_supplier
referencingtablecolumn=cvmivenderid
referencedtablekey=pk_supplier
, orgtype=null
referencingtablename=ic_adjustbal_h
crefid=null
referencingkeycolumn=cgeneralhid
referencedtablename=bd_supplier
referencingtablecolumn=cvendorid
referencedtablekey=pk_supplier
, orgtype=null
referencingtablename=po_order_bb
crefid=null
referencingkeycolumn=pk_order_bb
referencedtablename=bd_supplier
referencingtablecolumn=ccarrier
referencedtablekey=pk_supplier
, orgtype=null
referencingtablename=po_vmifi
crefid=null
referencingkeycolumn=pk_stockps_b
referencedtablename=bd_supplier
referencingtablecolumn=pk_supplier
referencedtablekey=pk_supplier
, orgtype=null
referencingtablename=bd_supaddressref
crefid=null
referencingkeycolumn=pk_address
referencedtablename=bd_supplier
referencingtablecolumn=pk_supplier
referencedtablekey=pk_supplier
, orgtype=null
referencingtablename=pm_budget_exe
crefid=null
referencingkeycolumn=pk_budget_exe_b
referencedtablename=bd_supplier
referencingtablecolumn=pk_supplier
referencedtablekey=pk_supplier
, orgtype=null
referencingtablename=cm_subitemcost_b
crefid=null
referencingkeycolumn=csubitemcost_bid
referencedtablename=bd_supplier
referencingtablecolumn=cbvendorid
referencedtablekey=pk_supplier
, orgtype=null
referencingtablename=ic_borrowin_b
crefid=null
referencingkeycolumn=cgeneralbid
referencedtablename=bd_supplier
referencingtablecolumn=cvendorid
referencedtablekey=pk_supplier
, orgtype=null
referencingtablename=sca_bom_stuff
crefid=null
referencingkeycolumn=cbomstuffid
referencedtablename=bd_supplier
referencingtablecolumn=cvendorid
referencedtablekey=pk_supplier
, orgtype=null
referencingtablename=fa_transasset
crefid=null
referencingkeycolumn=pk_transasset
referencedtablename=bd_supplier
referencingtablecolumn=pk_construct_unit
referencedtablekey=pk_supplier
, orgtype=null
referencingtablename=pd_rt_opac
crefid=null
referencingkeycolumn=crt_opacid
referencedtablename=bd_supplier
referencingtablecolumn=cvendorid
referencedtablekey=pk_supplier
, orgtype=null
referencingtablename=ap_payitem
crefid=null
referencingkeycolumn=pk_payitem
referencedtablename=bd_supplier
referencingtablecolumn=ordercubasdoc
referencedtablekey=pk_supplier
, orgtype=null
referencingtablename=pca_valuedetail
crefid=null
referencingkeycolumn=pk_bizvaluedetail
referencedtablename=bd_supplier
referencingtablecolumn=pk_supplier
referencedtablekey=pk_supplier
, orgtype=null
referencingtablename=ia_i8bill_b
crefid=null
referencingkeycolumn=cbill_bid
referencedtablename=bd_supplier
referencingtablecolumn=cvendorid
referencedtablekey=pk_supplier
, orgtype=null
referencingtablename=ic_packbill_b
crefid=null
referencingkeycolumn=cpackbillid
referencedtablename=bd_supplier
referencingtablecolumn=cvendorid
referencedtablekey=pk_supplier
, orgtype=null
referencingtablename=ic_teardown_b
crefid=null
referencingkeycolumn=cspecialbid
referencedtablename=bd_supplier
referencingtablecolumn=cvmivenderid
referencedtablekey=pk_supplier
, orgtype=null
referencingtablename=er_expamtdetail
crefid=null
referencingkeycolumn=pk_expamtdetail
referencedtablename=bd_supplier
referencingtablecolumn=hbbm
referencedtablekey=pk_supplier
, orgtype=null
referencingtablename=ic_transin_b
crefid=null
referencingkeycolumn=cgeneralbid
referencedtablename=bd_supplier
referencingtablecolumn=cvmivenderid
referencedtablekey=pk_supplier
, orgtype=null
referencingtablename=ia_adjcalcrange_b
crefid=null
referencingkeycolumn=cbill_bid
referencedtablename=bd_supplier
referencingtablecolumn=cvendorid
referencedtablekey=pk_supplier
, orgtype=null
referencingtablename=er_cshare_detail
crefid=null
referencingkeycolumn=pk_cshare_detail
referencedtablename=bd_supplier
referencingtablecolumn=hbbm
referencedtablekey=pk_supplier
, orgtype=null
referencingtablename=ia_i5bill_b
crefid=null
referencingkeycolumn=cbill_bid
referencedtablename=bd_supplier
referencingtablecolumn=cvendorid
referencedtablekey=pk_supplier
, orgtype=null
referencingtablename=ic_borrowout_b
crefid=null
referencingkeycolumn=cgeneralbid
referencedtablename=bd_supplier
referencingtablecolumn=cvendorid
referencedtablekey=pk_supplier
, orgtype=null
referencingtablename=purp_priceaudit_b
crefid=null
referencingkeycolumn=pk_priceaudit_b
referencedtablename=bd_supplier
referencingtablecolumn=pk_supplier
referencedtablekey=pk_supplier
, orgtype=null
referencingtablename=po_invoice
crefid=null
referencingkeycolumn=pk_invoice
referencedtablename=bd_supplier
referencingtablecolumn=pk_supplier
referencedtablekey=pk_supplier
, orgtype=null
referencingtablename=bd_bmrt
crefid=null
referencingkeycolumn=cbmrtid
referencedtablename=bd_supplier
referencingtablecolumn=cvendorid
referencedtablekey=pk_supplier
, orgtype=null
referencingtablename=ia_detailledger
crefid=null
referencingkeycolumn=cdetailledgerid
referencedtablename=bd_supplier
referencingtablecolumn=ccostvendorid
referencedtablekey=pk_supplier
, orgtype=null
referencingtablename=ic_transout_b
crefid=null
referencingkeycolumn=cgeneralbid
referencedtablename=bd_supplier
referencingtablecolumn=cvendorid
referencedtablekey=pk_supplier
, orgtype=null
referencingtablename=ic_flow
crefid=null
referencingkeycolumn=pk_flow
referencedtablename=bd_supplier
referencingtablecolumn=cvendorid
referencedtablekey=pk_supplier
, orgtype=null
referencingtablename=fbm_counterbook_b
crefid=null
referencingkeycolumn=pk_action
referencedtablename=bd_supplier
referencingtablecolumn=endorser
referencedtablekey=pk_supplier
, orgtype=null
referencingtablename=po_praypriceinfo
crefid=null
referencingkeycolumn=pk_priceinfo
referencedtablename=bd_supplier
referencingtablecolumn=pk_supplier2
referencedtablekey=pk_supplier
, orgtype=null
referencingtablename=sscct_paycontract_v
crefid=null
referencingkeycolumn=pk_paycontract_v
referencedtablename=bd_supplier
referencingtablecolumn=bingfang_supplier
referencedtablekey=pk_supplier
, orgtype=null
referencingtablename=po_praypriceinfo
crefid=null
referencingkeycolumn=pk_priceinfo
referencedtablename=bd_supplier
referencingtablecolumn=pk_supplier3
referencedtablekey=pk_supplier
, orgtype=null
referencingtablename=cm_revertbg
crefid=null
referencingkeycolumn=crevertbgid
referencedtablename=bd_supplier
referencingtablecolumn=cvendorid
referencedtablekey=pk_supplier
, orgtype=null
referencingtablename=sscct_paycontract_v
crefid=null
referencingkeycolumn=pk_paycontract_v
referencedtablename=bd_supplier
referencingtablecolumn=yifang_supplier
referencedtablekey=pk_supplier
, orgtype=null
referencingtablename=ic_whstrans_b
crefid=null
referencingkeycolumn=cspecialbid
referencedtablename=bd_supplier
referencingtablecolumn=cvendorid
referencedtablekey=pk_supplier
, orgtype=null
referencingtablename=cm_iastuff
crefid=null
referencingkeycolumn=ciastuffid
referencedtablename=bd_supplier
referencingtablecolumn=cvendorid
referencedtablekey=pk_supplier
, orgtype=null
referencingtablename=ic_discardout_b
crefid=null
referencingkeycolumn=cgeneralbid
referencedtablename=bd_supplier
referencingtablecolumn=cvendorid
referencedtablekey=pk_supplier
, orgtype=null
referencingtablename=fbm_endore
crefid=null
referencingkeycolumn=pk_endore
referencedtablename=bd_supplier
referencingtablecolumn=endorsee
referencedtablekey=pk_supplier
, orgtype=null
referencingtablename=ic_invcount_b
crefid=null
referencingkeycolumn=cspecialbid
referencedtablename=bd_supplier
referencingtablecolumn=cvmivenderid
referencedtablekey=pk_supplier
]
就可以一个个排查引用关系了
比如供应商被付款结算单引用了：
select a.* from cmp_paybilldetail a left join bd_supplier s on a.pk_supplier = s.pk_supplier where s.name = ‘广州市**投资有限公司’
被报表引用了：
select a.* from mapub_materialpricebase_b a left join bd_supplier s on a.cvendorid = s.pk_supplier where s.name = ‘广州市**投资有限公司’
原文地址：https://blog.csdn.net/u010741112/article/details/140386382
免责声明：本站文章内容转载自网络资源，如本站内容侵犯了原著者的合法权益，可联系本站删除。更多内容请关注自学内容网（zxcms.com）！