常用表

# 根据表查看数据库
SELECT table_schema,table_name,concat('select * from ',table_schema,'.',table_name,' where id =''','2806584575414528',''';') FROM information_schema.TABLES WHERE table_name like '%pay%';

# 自定义档案定义
select * from iuap_apdoc_basedoc.bd_cust_doc_def bcdd where bcdd.code = 'MLS-031_yql';
# 自定义档案维护
select bcd.objid,bcd.code,bcd.name from iuap_apdoc_basedoc.bd_cust_doc bcd where bcd.custdocdefid = '1612502581762326536';
0

# 关系表
select * from iuap_uuas_usercenter.pub_tenant_user_relation;
# 组织
select org.id,org.code,org.name,org.* from iuap_apdoc_basedoc.org_orgs org where org.code = '112';
# 采购组织
select * from pub_dop.cpu_supplydoc;
select * from cpu_base_doc.cpu_supplydoc;
select * from cpu_base_doc.check_erpdata_supply;
# 员工
select t.user_id,t.* from iuap_apdoc_basedoc.bd_staff t where t.code = '4988';
# 用户
select user.* from iuap_uuas_usercenter.pub_tenant_user user where user.user_code = '4988';
# NCC用户主键与BIP用户主键的映射关系
select * from iuap_uuas_usercenter.pub_yht_nc_user
# 部门
select dept.orgid,dept.* from iuap_apdoc_basedoc.org_admin dept where dept.code = 'A00665_112' and dept.tenantid = 'pyicmtg4';
# 租户
select * from iuap_uuas_usercenter.pub_tenant pt where pt.tenant_name = '嘉宝莉集团0523';

# 供应商档案
select a.id,a.cRelationTenantId 供应商的租户id,name 供应商租户的名字,a.* from iuap_apdoc_coredoc.aa_vendor a where a.code in('1440700669','1340700005');
# 供应商档案 供应商联系方式
select avc.iVendorId 供应商id,avc.cContactName 供应商联系人,avc.id 供应商联系人id,avc.* from iuap_apdoc_coredoc.aa_vendorcontacts avc where avc.iVendorId in ('2809524709953792','2809513886617856');
# 合同表
select * from cpu_cooperation.cpu_ct;
# 合同付款协议
select * from cpu_cooperation.cpu_ct_payterm ccp where ccp.contract_id in ('301387','301388');
# 合同组织范围
select * from cpu_cooperation.cpu_ct_org_scope;
# 合同物料子表
select * from cpu_cooperation.cpu_ct_material;
# 物料表
select * from iuap_apdoc_coredoc.product pd;
# 物料分类
select * from iuap_apdoc_coredoc.product_management_class pmc;
# 单位
select * from iuap_apdoc_coredoc.unit unit;
# 税率
select * from iuap_apdoc_basedoc.bd_taxrate bt;
# 币种
select * from iuap_apdoc_basedoc.bd_currency_tenant bct;
# 交易类型
select * from iuap_apdoc_basedoc.bd_transtype bt ;
# 预付款
select * from iuap_apdoc_basedoc.bd_payagreement bp;
# 结算方式
select * from iuap_apdoc_coredoc.settle_method sm;
# 付款起点
select * from iuap_apdoc_basedoc.bd_paystartbase bp;