金蝶cloud读取供应商基础信息

这是我从数据库后台抓到的，金蝶读取供应商基本信息的sql语句

exec sp_executesql N' SET FMTONLY OFF; SET NO_BROWSETABLE ON;

SELECT t_BD_Supplier.FSupplierId, t_BD_Supplier.FMasterId, t_BD_Supplier.FDOCUMENTSTATUS, t_BD_Supplier.FFORBIDSTATUS, t_BD_Supplier.FNUMBER, t_BD_Supplier.FCREATEORGID, t_BD_Supplier.FUSEORGID, t_BD_Supplier.FCREATORID, t_BD_Supplier.FMODIFIERID, t_BD_Supplier.FCREATEDATE, t_BD_Supplier.FMODIFYDATE, t_BD_Supplier.FFORBIDERID, t_BD_Supplier.FFORBIDDATE, t_BD_Supplier.FAUDITDATE, t_BD_Supplier.FAUDITORID, t_BD_Supplier.FPRIMARYGROUP, t_BD_Supplier.FCORRESPONDORGID, t_BD_Supplier.FSYNCGYOWNERSTATUS, t_BD_Supplier.FREGNUMBER FROM t_BD_Supplier WHERE t_BD_Supplier.FSupplierId = @PKValue;

SELECT t_BD_Supplier_L.FPkId, t_BD_Supplier_L.FLocaleId, t_BD_Supplier_L.FNAME, t_BD_Supplier_L.FDESCRIPTION, t_BD_Supplier_L.FSHORTNAME, t_BD_Supplier_L.FSupplierId FROM t_BD_Supplier_L INNER JOIN t_BD_Supplier ON t_BD_Supplier_L.FSupplierId = t_BD_Supplier.FSupplierId WHERE t_BD_Supplier.FSupplierId = @PKValue;

SELECT t_BD_SupplierBase.FEntryId, t_BD_SupplierBase.FCOUNTRY, t_BD_SupplierBase.FPROVINCIAL, t_BD_SupplierBase.FZIP, t_BD_SupplierBase.FLANGUAGE, t_BD_SupplierBase.FADDRESS, t_BD_SupplierBase.FWEBSITE, t_BD_SupplierBase.FREGISTERADDRESS, t_BD_SupplierBase.FTRADE, t_BD_SupplierBase.FCOMPANYNATURE, t_BD_SupplierBase.FFOUNDDATE, t_BD_SupplierBase.FLEGALPERSON, t_BD_SupplierBase.FREGISTERFUND, t_BD_SupplierBase.FREGISTERCODE, t_BD_SupplierBase.FTENDPERMIT, t_BD_SupplierBase.FDEPTID, t_BD_SupplierBase.FSTAFFID, t_BD_SupplierBase.FSUPPLIERCLASSIFY, t_BD_SupplierBase.FCOMPANYCLASSIFY, t_BD_SupplierBase.FSUPPLIERGRADE, t_BD_SupplierBase.FSTARTDATE, t_BD_SupplierBase.FENDDATE, t_BD_SupplierBase.FCOMPANYSCALE, t_BD_SupplierBase.FSUPPLYCLASSIFY, t_BD_SupplierBase.FSOCIALCRECODE, t_BD_SupplierBase.FSupplierId FROM t_BD_SupplierBase INNER JOIN t_BD_Supplier ON t_BD_SupplierBase.FSupplierId = t_BD_Supplier.FSupplierId WHERE t_BD_Supplier.FSupplierId = @PKValue;

SELECT t_BD_SupplierBusiness.FEntryId, t_BD_SupplierBusiness.FPURCHASEGROUPID, t_BD_SupplierBusiness.FMINPOVALUE, t_BD_SupplierBusiness.FNEEDCONFIRM, t_BD_SupplierBusiness.FPARENTSUPPLIERID, t_BD_SupplierBusiness.FBUSINESSSTATUS, t_BD_SupplierBusiness.FFREEZELIMIT, t_BD_SupplierBusiness.FSETTLETYPEID, t_BD_SupplierBusiness.FPRICELISTID, t_BD_SupplierBusiness.FWIPSTOCKPLACEID, t_BD_SupplierBusiness.FWIPSTOCKID, t_BD_SupplierBusiness.FDISCOUNTLISTID, t_BD_SupplierBusiness.FPROVIDERID, t_BD_SupplierBusiness.FFREEZEOPERATOR, t_BD_SupplierBusiness.FFREEZEDATE, t_BD_SupplierBusiness.FVMISTOCKID, t_BD_SupplierBusiness.FVMIBUSINESS, t_BD_SupplierBusiness.FENABLESL, t_BD_SupplierBusiness.FDEPOSITRATIO, t_BD_SupplierBusiness.FSupplierId FROM t_BD_SupplierBusiness INNER JOIN t_BD_Supplier ON t_BD_SupplierBusiness.FSupplierId = t_BD_Supplier.FSupplierId WHERE t_BD_Supplier.FSupplierId = @PKValue;

SELECT t_BD_SupplierFinance.FEntryId, t_BD_SupplierFinance.FPAYCURRENCYID, t_BD_SupplierFinance.FCUSTOMERID, t_BD_SupplierFinance.FPAYADVANCEAMOUNT, t_BD_SupplierFinance.FTAXREGISTERCODE, t_BD_SupplierFinance.FTENDTYPE, t_BD_SupplierFinance.FTAXTYPE, t_BD_SupplierFinance.FDESCRIPTION, t_BD_SupplierFinance.FPAYCONDITION, t_BD_SupplierFinance.FINVOICETYPE, t_BD_SupplierFinance.FSETTLEID, t_BD_SupplierFinance.FCHARGEID, t_BD_SupplierFinance.FTAXRATEID, t_BD_SupplierFinance.FSupplierId FROM t_BD_SupplierFinance INNER JOIN t_BD_Supplier ON t_BD_SupplierFinance.FSupplierId = t_BD_Supplier.FSupplierId WHERE t_BD_Supplier.FSupplierId = @PKValue;

SELECT t_BD_SupplierBank.FBankId, t_BD_SupplierBank.FCOUNTRY, t_BD_SupplierBank.FBANKCODE, t_BD_SupplierBank.FBANKHOLDER, t_BD_SupplierBank.FISDEFAULT, t_BD_SupplierBank.FDESCRIPTION, t_BD_SupplierBank.FCURRENCYID, t_BD_SupplierBank.FBANKTYPEREC, t_BD_SupplierBank.FOPENADDRESSREC, t_BD_SupplierBank.FCNAPS, t_BD_SupplierBank.FSWIFTCODE, t_BD_SupplierBank.FTEXTBANKDETAIL, t_BD_SupplierBank.FBANKDETAIL, t_BD_SupplierBank.FSupplierId FROM t_BD_SupplierBank INNER JOIN t_BD_Supplier ON t_BD_SupplierBank.FSupplierId = t_BD_Supplier.FSupplierId WHERE t_BD_Supplier.FSupplierId = @PKValue;

SELECT t_BD_SupplierBank_L.FPkId, t_BD_SupplierBank_L.FLocaleId, t_BD_SupplierBank_L.FOPENBANKNAME, t_BD_SupplierBank_L.FBankId FROM t_BD_SupplierBank_L INNER JOIN t_BD_SupplierBank ON t_BD_SupplierBank_L.FBankId = t_BD_SupplierBank.FBankId INNER JOIN t_BD_Supplier ON t_BD_SupplierBank.FSupplierId = t_BD_Supplier.FSupplierId WHERE t_BD_Supplier.FSupplierId = @PKValue;
SELECT t_BD_SupplierLocation.FLocationId, t_BD_SupplierLocation.FTRANSPORTDAYS, t_BD_SupplierLocation.FPLANDELIVERYPERIOD, t_BD_SupplierLocation.FDESCRIPTION, t_BD_SupplierLocation.FNUMBER, t_BD_SupplierLocation.FNAME, t_BD_SupplierLocation.FADDRESS, t_BD_SupplierLocation.FISUSED, t_BD_SupplierLocation.FTEL, t_BD_SupplierLocation.FMOBILE, t_BD_SupplierLocation.FFAX, t_BD_SupplierLocation.FEMAIL, t_BD_SupplierLocation.FISDEFAULTSUPPLY, t_BD_SupplierLocation.FISDEFAULTSETTLE, t_BD_SupplierLocation.FISDEFAULTPAYEE, t_BD_SupplierLocation.FCONTACTID, t_BD_SupplierLocation.FNEWCONTACTID, t_BD_SupplierLocation.FSupplierId FROM t_BD_SupplierLocation INNER JOIN t_BD_Supplier ON t_BD_SupplierLocation.FSupplierId = t_BD_Supplier.FSupplierId WHERE t_BD_Supplier.FSupplierId = @PKValue;

SELECT t_BD_SupplierContact.FContactId, t_BD_SupplierContact.FCONTACT, t_BD_SupplierContact.FPOST, t_BD_SupplierContact.FTEL, t_BD_SupplierContact.FMOBILE, t_BD_SupplierContact.FFAX, t_BD_SupplierContact.FEMAIL, t_BD_SupplierContact.FIMCODE, t_BD_SupplierContact.FISDEFAULT, t_BD_SupplierContact.FDESCRIPTION, t_BD_SupplierContact.FCOMMONCONTACTID, t_BD_SupplierContact.FCONTACTNUMBER, t_BD_SupplierContact.FFORBIDSTATUS, t_BD_SupplierContact.FGENDER, t_BD_SupplierContact.FSupplierId FROM t_BD_SupplierContact INNER JOIN t_BD_Supplier ON t_BD_SupplierContact.FSupplierId = t_BD_Supplier.FSupplierId WHERE t_BD_Supplier.FSupplierId = @PKValue;',N'@PKValue bigint',@PKValue=101628

其他信息这一个页签的数据是存在于t_BD_Supplier 这个表内的