| 1 |
37.71 ms |
SELECT t0.idTenant AS idTenant_1, t0.name AS name_2, t0.legalForm AS legalForm_3, t0.activityCode AS activityCode_4, t0.status AS status_5, t0.siren AS siren_6, t0.siret AS siret_7, t0.vatNumber AS vatNumber_8, t0.firstname AS firstname_9, t0.lastname AS lastname_10, t0.phone AS phone_11, t0.email AS email_12, t0.web AS web_13, t0.refSepa AS refSepa_14, t0.logo AS logo_15, t0.docslogo AS docslogo_16, t0.idPayeeBC AS idPayeeBC_17, t0.idPayerBC AS idPayerBC_18, t0.registration AS registration_19, t0.footer AS footer_20, t0.header AS header_21, t0.contractFooter AS contractFooter_22, t0.allMustSign AS allMustSign_23, t0.transferFeeVendor AS transferFeeVendor_24, t0.transferFeeBuyer AS transferFeeBuyer_25, t0.transferFee AS transferFee_26, t0.recoveryFee AS recoveryFee_27, t0.recoveryFeeCodes AS recoveryFeeCodes_28, t0.documentProvider AS documentProvider_29, t0.recoveryDelay AS recoveryDelay_30, t0.maxElementInvoices AS maxElementInvoices_31, t0.defaultFundersDelay AS defaultFundersDelay_32, t0.target AS target_33, t0.useQuote AS useQuote_34, t0.useAI AS useAI_35, t0.useAssetUrl AS useAssetUrl_36, t0.withoutPartnerVr AS withoutPartnerVr_37, t0.useMicrosoftAuth AS useMicrosoftAuth_38, t0.useGoogleAuth AS useGoogleAuth_39, t0.useAccounting AS useAccounting_40, t0.usePartnerDeals AS usePartnerDeals_41, t0.useContractLots AS useContractLots_42, t0.useProlong AS useProlong_43, t0.useElliPro AS useElliPro_44, t0.useCreditsafe AS useCreditsafe_45, t0.useEbicsExport AS useEbicsExport_46, t0.useEbicsImport AS useEbicsImport_47, t0.liOnScheduler AS liOnScheduler_48, t0.alwaysFunderAutoScoring AS alwaysFunderAutoScoring_49, t0.ibanOnClientSign AS ibanOnClientSign_50, t0.scoringMethodAutoAccept AS scoringMethodAutoAccept_51, t0.canManagePartnerFee AS canManagePartnerFee_52, t0.autoReject AS autoReject_53, t0.extraSignCheck AS extraSignCheck_54, t0.blockedSirens AS blockedSirens_55, t0.slug AS slug_56, t0.primaryColor AS primaryColor_57, t0.secondaryColor AS secondaryColor_58, t0.fixedAssetCode AS fixedAssetCode_59, t0.lossCalculationBase AS lossCalculationBase_60, t0.clientBalanceCalcMode AS clientBalanceCalcMode_61, t0.clientBalanceSurcharge AS clientBalanceSurcharge_62, t0.creditCardLink AS creditCardLink_63, t0.postingGroups AS postingGroups_64 FROM tenant t0 WHERE t0.idTenant = ?
SELECT
t0.idTenant AS idTenant_1,
t0.name AS name_2,
t0.legalForm AS legalForm_3,
t0.activityCode AS activityCode_4,
t0.status AS status_5,
t0.siren AS siren_6,
t0.siret AS siret_7,
t0.vatNumber AS vatNumber_8,
t0.firstname AS firstname_9,
t0.lastname AS lastname_10,
t0.phone AS phone_11,
t0.email AS email_12,
t0.web AS web_13,
t0.refSepa AS refSepa_14,
t0.logo AS logo_15,
t0.docslogo AS docslogo_16,
t0.idPayeeBC AS idPayeeBC_17,
t0.idPayerBC AS idPayerBC_18,
t0.registration AS registration_19,
t0.footer AS footer_20,
t0.header AS header_21,
t0.contractFooter AS contractFooter_22,
t0.allMustSign AS allMustSign_23,
t0.transferFeeVendor AS transferFeeVendor_24,
t0.transferFeeBuyer AS transferFeeBuyer_25,
t0.transferFee AS transferFee_26,
t0.recoveryFee AS recoveryFee_27,
t0.recoveryFeeCodes AS recoveryFeeCodes_28,
t0.documentProvider AS documentProvider_29,
t0.recoveryDelay AS recoveryDelay_30,
t0.maxElementInvoices AS maxElementInvoices_31,
t0.defaultFundersDelay AS defaultFundersDelay_32,
t0.target AS target_33,
t0.useQuote AS useQuote_34,
t0.useAI AS useAI_35,
t0.useAssetUrl AS useAssetUrl_36,
t0.withoutPartnerVr AS withoutPartnerVr_37,
t0.useMicrosoftAuth AS useMicrosoftAuth_38,
t0.useGoogleAuth AS useGoogleAuth_39,
t0.useAccounting AS useAccounting_40,
t0.usePartnerDeals AS usePartnerDeals_41,
t0.useContractLots AS useContractLots_42,
t0.useProlong AS useProlong_43,
t0.useElliPro AS useElliPro_44,
t0.useCreditsafe AS useCreditsafe_45,
t0.useEbicsExport AS useEbicsExport_46,
t0.useEbicsImport AS useEbicsImport_47,
t0.liOnScheduler AS liOnScheduler_48,
t0.alwaysFunderAutoScoring AS alwaysFunderAutoScoring_49,
t0.ibanOnClientSign AS ibanOnClientSign_50,
t0.scoringMethodAutoAccept AS scoringMethodAutoAccept_51,
t0.canManagePartnerFee AS canManagePartnerFee_52,
t0.autoReject AS autoReject_53,
t0.extraSignCheck AS extraSignCheck_54,
t0.blockedSirens AS blockedSirens_55,
t0.slug AS slug_56,
t0.primaryColor AS primaryColor_57,
t0.secondaryColor AS secondaryColor_58,
t0.fixedAssetCode AS fixedAssetCode_59,
t0.lossCalculationBase AS lossCalculationBase_60,
t0.clientBalanceCalcMode AS clientBalanceCalcMode_61,
t0.clientBalanceSurcharge AS clientBalanceSurcharge_62,
t0.creditCardLink AS creditCardLink_63,
t0.postingGroups AS postingGroups_64
FROM
tenant t0
WHERE
t0.idTenant = ?
SELECT t0.idTenant AS idTenant_1, t0.name AS name_2, t0.legalForm AS legalForm_3, t0.activityCode AS activityCode_4, t0.status AS status_5, t0.siren AS siren_6, t0.siret AS siret_7, t0.vatNumber AS vatNumber_8, t0.firstname AS firstname_9, t0.lastname AS lastname_10, t0.phone AS phone_11, t0.email AS email_12, t0.web AS web_13, t0.refSepa AS refSepa_14, t0.logo AS logo_15, t0.docslogo AS docslogo_16, t0.idPayeeBC AS idPayeeBC_17, t0.idPayerBC AS idPayerBC_18, t0.registration AS registration_19, t0.footer AS footer_20, t0.header AS header_21, t0.contractFooter AS contractFooter_22, t0.allMustSign AS allMustSign_23, t0.transferFeeVendor AS transferFeeVendor_24, t0.transferFeeBuyer AS transferFeeBuyer_25, t0.transferFee AS transferFee_26, t0.recoveryFee AS recoveryFee_27, t0.recoveryFeeCodes AS recoveryFeeCodes_28, t0.documentProvider AS documentProvider_29, t0.recoveryDelay AS recoveryDelay_30, t0.maxElementInvoices AS maxElementInvoices_31, t0.defaultFundersDelay AS defaultFundersDelay_32, t0.target AS target_33, t0.useQuote AS useQuote_34, t0.useAI AS useAI_35, t0.useAssetUrl AS useAssetUrl_36, t0.withoutPartnerVr AS withoutPartnerVr_37, t0.useMicrosoftAuth AS useMicrosoftAuth_38, t0.useGoogleAuth AS useGoogleAuth_39, t0.useAccounting AS useAccounting_40, t0.usePartnerDeals AS usePartnerDeals_41, t0.useContractLots AS useContractLots_42, t0.useProlong AS useProlong_43, t0.useElliPro AS useElliPro_44, t0.useCreditsafe AS useCreditsafe_45, t0.useEbicsExport AS useEbicsExport_46, t0.useEbicsImport AS useEbicsImport_47, t0.liOnScheduler AS liOnScheduler_48, t0.alwaysFunderAutoScoring AS alwaysFunderAutoScoring_49, t0.ibanOnClientSign AS ibanOnClientSign_50, t0.scoringMethodAutoAccept AS scoringMethodAutoAccept_51, t0.canManagePartnerFee AS canManagePartnerFee_52, t0.autoReject AS autoReject_53, t0.extraSignCheck AS extraSignCheck_54, t0.blockedSirens AS blockedSirens_55, t0.slug AS slug_56, t0.primaryColor AS primaryColor_57, t0.secondaryColor AS secondaryColor_58, t0.fixedAssetCode AS fixedAssetCode_59, t0.lossCalculationBase AS lossCalculationBase_60, t0.clientBalanceCalcMode AS clientBalanceCalcMode_61, t0.clientBalanceSurcharge AS clientBalanceSurcharge_62, t0.creditCardLink AS creditCardLink_63, t0.postingGroups AS postingGroups_64 FROM tenant t0 WHERE t0.idTenant = 1;
|
| 3 |
12.83 ms |
SELECT t0.idPartner AS idPartner_1, t0.name AS name_2, t0.migV1locked AS migV1locked_3, t0.agreementV1Locked AS agreementV1Locked_4, t0.attachmentInsurance AS attachmentInsurance_5, t0.autoFundingParams AS autoFundingParams_6, t0.canSignOnDevice AS canSignOnDevice_7, t0.canSignWithSales AS canSignWithSales_8, t0.useDefaultAsset AS useDefaultAsset_9, t0.useDeLay AS useDeLay_10, t0.prefillContract AS prefillContract_11, t0.updateDate AS updateDate_12, t0.insertDate AS insertDate_13, t0.startDate AS startDate_14, t0.endDate AS endDate_15, t0.legalForm AS legalForm_16, t0.activityCode AS activityCode_17, t0.activitySector AS activitySector_18, t0.country AS country_19, t0.status AS status_20, t0.type AS type_21, t0.typeOfService AS typeOfService_22, t0.phone AS phone_23, t0.autoAccept AS autoAccept_24, t0.autoReject AS autoReject_25, t0.email AS email_26, t0.web AS web_27, t0.logo AS logo_28, t0.idPayeeBC AS idPayeeBC_29, t0.idPayerBC AS idPayerBC_30, t0.siren AS siren_31, t0.vatNumber AS vatNumber_32, t0.registration AS registration_33, t0.agreementRegistration AS agreementRegistration_34, t0.defaultFinancialProduct AS defaultFinancialProduct_35, t0.defaultFinancialScheme AS defaultFinancialScheme_36, t0.renewalBalanceCalcMode AS renewalBalanceCalcMode_37, t0.renewalBalanceFee AS renewalBalanceFee_38, t0.nonRenewalBalanceFee AS nonRenewalBalanceFee_39, t0.nonRenewalBalanceCalcMode AS nonRenewalBalanceCalcMode_40, t0.nonRenewalSurcharge AS nonRenewalSurcharge_41, t0.renewalSurcharge AS renewalSurcharge_42, t0.renewalMandatedSurcharge AS renewalMandatedSurcharge_43, t0.nonRenewalIndemnity AS nonRenewalIndemnity_44, t0.defaultPartnerContact AS defaultPartnerContact_45, t0.target AS target_46, t0.potential AS potential_47, t0.segment AS segment_48, t0.risk AS risk_49, t0.createContractAtStatus AS createContractAtStatus_50, t0.docusignAuto AS docusignAuto_51, t0.emptyRentalChain AS emptyRentalChain_52, t0.docusignAutoAtStatus AS docusignAutoAtStatus_53, t0.hasClientSpace AS hasClientSpace_54, t0.useDeals AS useDeals_55, t0.useHamonLaw AS useHamonLaw_56, t0.notUseAutoMailHamon AS notUseAutoMailHamon_57, t0.hasPartnerSpace AS hasPartnerSpace_58, t0.canCancelEnvelope AS canCancelEnvelope_59, t0.canSignWithoutApproval AS canSignWithoutApproval_60, t0.needClientDocsOnSign AS needClientDocsOnSign_61, t0.canUseCapacity AS canUseCapacity_62, t0.canCancelInsurance AS canCancelInsurance_63, t0.canCancelProlong AS canCancelProlong_64, t0.canUsePaymentOffset AS canUsePaymentOffset_65, t0.canRenewContract AS canRenewContract_66, t0.stopPrintContract AS stopPrintContract_67, t0.activeLockedForSales AS activeLockedForSales_68, t0.displayPartnerSpaceInsInfo AS displayPartnerSpaceInsInfo_69, t0.sendDocsToClientAfterSigned AS sendDocsToClientAfterSigned_70, t0.paymentCondition AS paymentCondition_71, t0.paymentMode AS paymentMode_72, t0.comment AS comment_73, t0.active AS active_74, t0.canUseAssetOnCalc AS canUseAssetOnCalc_75, t0.useSepaDate AS useSepaDate_76, t0.rewardsOnPreComp AS rewardsOnPreComp_77, t0.useMultiStages AS useMultiStages_78, t0.riskSharing AS riskSharing_79, t0.paidAfterCAL AS paidAfterCAL_80, t0.wantToSeeHomeMap AS wantToSeeHomeMap_81, t0.oauth2 AS oauth2_82, t0.clientSecret AS clientSecret_83, t0.clientId AS clientId_84, t0.tenantId AS tenantId_85, t0.slug AS slug_86, t0.invoiceLogo AS invoiceLogo_87, t0.spaceLogo AS spaceLogo_88, t0.spaceFavicon AS spaceFavicon_89, t0.spacePrimaryColor AS spacePrimaryColor_90, t0.spaceSecondaryColor AS spaceSecondaryColor_91, t0.contractLogo AS contractLogo_92, t0.bdcLogo AS bdcLogo_93, t0.bdcAgree AS bdcAgree_94, t0.agreeLogo AS agreeLogo_95, t0.addressContract AS addressContract_96, t0.addressAgree AS addressAgree_97, t0.addressInvoice AS addressInvoice_98, t0.addressBdc AS addressBdc_99, t0.welcomeAddon AS welcomeAddon_100, t0.footer AS footer_101, t0.header AS header_102, t0.vendorPostingGroup AS vendorPostingGroup_103, t0.acceptThresholdEL AS acceptThresholdEL_104, t0.acceptThresholdCS AS acceptThresholdCS_105, t0.acceptAmount AS acceptAmount_106, t0.rejectThresholdEL AS rejectThresholdEL_107, t0.rejectThresholdCS AS rejectThresholdCS_108, t0.useGracePeriod AS useGracePeriod_109, t0.gracePeriodMax AS gracePeriodMax_110, t0.noInsuranceOnGracePeriod AS noInsuranceOnGracePeriod_111, t0.noLiOnGracePeriod AS noLiOnGracePeriod_112, t0.canViewRewards AS canViewRewards_113, t0.canViewAcceptRate AS canViewAcceptRate_114, t0.hasProlongationCommission AS hasProlongationCommission_115, t0.prolongationCommission AS prolongationCommission_116, t0.prolongationCommissionAllin AS prolongationCommissionAllin_117, t0.prolongationCommissionFrequency AS prolongationCommissionFrequency_118, t0.prolongationCommissionTarget AS prolongationCommissionTarget_119, t0.idLeasLiaison AS idLeasLiaison_120, t0.idLeasSale AS idLeasSale_121, t0.idPartnerScheme AS idPartnerScheme_122, t0.idContractTemplate AS idContractTemplate_123, t0.idPvTemplate AS idPvTemplate_124, t0.idSepaTemplate AS idSepaTemplate_125, t0.idCgvTemplate AS idCgvTemplate_126, t0.idAnnexTemplate AS idAnnexTemplate_127, t0.idBdcTemplate AS idBdcTemplate_128 FROM partner t0 WHERE t0.slug = ? AND t0.active = ? LIMIT 1
SELECT
t0.idPartner AS idPartner_1,
t0.name AS name_2,
t0.migV1locked AS migV1locked_3,
t0.agreementV1Locked AS agreementV1Locked_4,
t0.attachmentInsurance AS attachmentInsurance_5,
t0.autoFundingParams AS autoFundingParams_6,
t0.canSignOnDevice AS canSignOnDevice_7,
t0.canSignWithSales AS canSignWithSales_8,
t0.useDefaultAsset AS useDefaultAsset_9,
t0.useDeLay AS useDeLay_10,
t0.prefillContract AS prefillContract_11,
t0.updateDate AS updateDate_12,
t0.insertDate AS insertDate_13,
t0.startDate AS startDate_14,
t0.endDate AS endDate_15,
t0.legalForm AS legalForm_16,
t0.activityCode AS activityCode_17,
t0.activitySector AS activitySector_18,
t0.country AS country_19,
t0.status AS status_20,
t0.type AS type_21,
t0.typeOfService AS typeOfService_22,
t0.phone AS phone_23,
t0.autoAccept AS autoAccept_24,
t0.autoReject AS autoReject_25,
t0.email AS email_26,
t0.web AS web_27,
t0.logo AS logo_28,
t0.idPayeeBC AS idPayeeBC_29,
t0.idPayerBC AS idPayerBC_30,
t0.siren AS siren_31,
t0.vatNumber AS vatNumber_32,
t0.registration AS registration_33,
t0.agreementRegistration AS agreementRegistration_34,
t0.defaultFinancialProduct AS defaultFinancialProduct_35,
t0.defaultFinancialScheme AS defaultFinancialScheme_36,
t0.renewalBalanceCalcMode AS renewalBalanceCalcMode_37,
t0.renewalBalanceFee AS renewalBalanceFee_38,
t0.nonRenewalBalanceFee AS nonRenewalBalanceFee_39,
t0.nonRenewalBalanceCalcMode AS nonRenewalBalanceCalcMode_40,
t0.nonRenewalSurcharge AS nonRenewalSurcharge_41,
t0.renewalSurcharge AS renewalSurcharge_42,
t0.renewalMandatedSurcharge AS renewalMandatedSurcharge_43,
t0.nonRenewalIndemnity AS nonRenewalIndemnity_44,
t0.defaultPartnerContact AS defaultPartnerContact_45,
t0.target AS target_46,
t0.potential AS potential_47,
t0.segment AS segment_48,
t0.risk AS risk_49,
t0.createContractAtStatus AS createContractAtStatus_50,
t0.docusignAuto AS docusignAuto_51,
t0.emptyRentalChain AS emptyRentalChain_52,
t0.docusignAutoAtStatus AS docusignAutoAtStatus_53,
t0.hasClientSpace AS hasClientSpace_54,
t0.useDeals AS useDeals_55,
t0.useHamonLaw AS useHamonLaw_56,
t0.notUseAutoMailHamon AS notUseAutoMailHamon_57,
t0.hasPartnerSpace AS hasPartnerSpace_58,
t0.canCancelEnvelope AS canCancelEnvelope_59,
t0.canSignWithoutApproval AS canSignWithoutApproval_60,
t0.needClientDocsOnSign AS needClientDocsOnSign_61,
t0.canUseCapacity AS canUseCapacity_62,
t0.canCancelInsurance AS canCancelInsurance_63,
t0.canCancelProlong AS canCancelProlong_64,
t0.canUsePaymentOffset AS canUsePaymentOffset_65,
t0.canRenewContract AS canRenewContract_66,
t0.stopPrintContract AS stopPrintContract_67,
t0.activeLockedForSales AS activeLockedForSales_68,
t0.displayPartnerSpaceInsInfo AS displayPartnerSpaceInsInfo_69,
t0.sendDocsToClientAfterSigned AS sendDocsToClientAfterSigned_70,
t0.paymentCondition AS paymentCondition_71,
t0.paymentMode AS paymentMode_72,
t0.comment AS comment_73,
t0.active AS active_74,
t0.canUseAssetOnCalc AS canUseAssetOnCalc_75,
t0.useSepaDate AS useSepaDate_76,
t0.rewardsOnPreComp AS rewardsOnPreComp_77,
t0.useMultiStages AS useMultiStages_78,
t0.riskSharing AS riskSharing_79,
t0.paidAfterCAL AS paidAfterCAL_80,
t0.wantToSeeHomeMap AS wantToSeeHomeMap_81,
t0.oauth2 AS oauth2_82,
t0.clientSecret AS clientSecret_83,
t0.clientId AS clientId_84,
t0.tenantId AS tenantId_85,
t0.slug AS slug_86,
t0.invoiceLogo AS invoiceLogo_87,
t0.spaceLogo AS spaceLogo_88,
t0.spaceFavicon AS spaceFavicon_89,
t0.spacePrimaryColor AS spacePrimaryColor_90,
t0.spaceSecondaryColor AS spaceSecondaryColor_91,
t0.contractLogo AS contractLogo_92,
t0.bdcLogo AS bdcLogo_93,
t0.bdcAgree AS bdcAgree_94,
t0.agreeLogo AS agreeLogo_95,
t0.addressContract AS addressContract_96,
t0.addressAgree AS addressAgree_97,
t0.addressInvoice AS addressInvoice_98,
t0.addressBdc AS addressBdc_99,
t0.welcomeAddon AS welcomeAddon_100,
t0.footer AS footer_101,
t0.header AS header_102,
t0.vendorPostingGroup AS vendorPostingGroup_103,
t0.acceptThresholdEL AS acceptThresholdEL_104,
t0.acceptThresholdCS AS acceptThresholdCS_105,
t0.acceptAmount AS acceptAmount_106,
t0.rejectThresholdEL AS rejectThresholdEL_107,
t0.rejectThresholdCS AS rejectThresholdCS_108,
t0.useGracePeriod AS useGracePeriod_109,
t0.gracePeriodMax AS gracePeriodMax_110,
t0.noInsuranceOnGracePeriod AS noInsuranceOnGracePeriod_111,
t0.noLiOnGracePeriod AS noLiOnGracePeriod_112,
t0.canViewRewards AS canViewRewards_113,
t0.canViewAcceptRate AS canViewAcceptRate_114,
t0.hasProlongationCommission AS hasProlongationCommission_115,
t0.prolongationCommission AS prolongationCommission_116,
t0.prolongationCommissionAllin AS prolongationCommissionAllin_117,
t0.prolongationCommissionFrequency AS prolongationCommissionFrequency_118,
t0.prolongationCommissionTarget AS prolongationCommissionTarget_119,
t0.idLeasLiaison AS idLeasLiaison_120,
t0.idLeasSale AS idLeasSale_121,
t0.idPartnerScheme AS idPartnerScheme_122,
t0.idContractTemplate AS idContractTemplate_123,
t0.idPvTemplate AS idPvTemplate_124,
t0.idSepaTemplate AS idSepaTemplate_125,
t0.idCgvTemplate AS idCgvTemplate_126,
t0.idAnnexTemplate AS idAnnexTemplate_127,
t0.idBdcTemplate AS idBdcTemplate_128
FROM
partner t0
WHERE
t0.slug = ?
AND t0.active = ?
LIMIT
1
SELECT t0.idPartner AS idPartner_1, t0.name AS name_2, t0.migV1locked AS migV1locked_3, t0.agreementV1Locked AS agreementV1Locked_4, t0.attachmentInsurance AS attachmentInsurance_5, t0.autoFundingParams AS autoFundingParams_6, t0.canSignOnDevice AS canSignOnDevice_7, t0.canSignWithSales AS canSignWithSales_8, t0.useDefaultAsset AS useDefaultAsset_9, t0.useDeLay AS useDeLay_10, t0.prefillContract AS prefillContract_11, t0.updateDate AS updateDate_12, t0.insertDate AS insertDate_13, t0.startDate AS startDate_14, t0.endDate AS endDate_15, t0.legalForm AS legalForm_16, t0.activityCode AS activityCode_17, t0.activitySector AS activitySector_18, t0.country AS country_19, t0.status AS status_20, t0.type AS type_21, t0.typeOfService AS typeOfService_22, t0.phone AS phone_23, t0.autoAccept AS autoAccept_24, t0.autoReject AS autoReject_25, t0.email AS email_26, t0.web AS web_27, t0.logo AS logo_28, t0.idPayeeBC AS idPayeeBC_29, t0.idPayerBC AS idPayerBC_30, t0.siren AS siren_31, t0.vatNumber AS vatNumber_32, t0.registration AS registration_33, t0.agreementRegistration AS agreementRegistration_34, t0.defaultFinancialProduct AS defaultFinancialProduct_35, t0.defaultFinancialScheme AS defaultFinancialScheme_36, t0.renewalBalanceCalcMode AS renewalBalanceCalcMode_37, t0.renewalBalanceFee AS renewalBalanceFee_38, t0.nonRenewalBalanceFee AS nonRenewalBalanceFee_39, t0.nonRenewalBalanceCalcMode AS nonRenewalBalanceCalcMode_40, t0.nonRenewalSurcharge AS nonRenewalSurcharge_41, t0.renewalSurcharge AS renewalSurcharge_42, t0.renewalMandatedSurcharge AS renewalMandatedSurcharge_43, t0.nonRenewalIndemnity AS nonRenewalIndemnity_44, t0.defaultPartnerContact AS defaultPartnerContact_45, t0.target AS target_46, t0.potential AS potential_47, t0.segment AS segment_48, t0.risk AS risk_49, t0.createContractAtStatus AS createContractAtStatus_50, t0.docusignAuto AS docusignAuto_51, t0.emptyRentalChain AS emptyRentalChain_52, t0.docusignAutoAtStatus AS docusignAutoAtStatus_53, t0.hasClientSpace AS hasClientSpace_54, t0.useDeals AS useDeals_55, t0.useHamonLaw AS useHamonLaw_56, t0.notUseAutoMailHamon AS notUseAutoMailHamon_57, t0.hasPartnerSpace AS hasPartnerSpace_58, t0.canCancelEnvelope AS canCancelEnvelope_59, t0.canSignWithoutApproval AS canSignWithoutApproval_60, t0.needClientDocsOnSign AS needClientDocsOnSign_61, t0.canUseCapacity AS canUseCapacity_62, t0.canCancelInsurance AS canCancelInsurance_63, t0.canCancelProlong AS canCancelProlong_64, t0.canUsePaymentOffset AS canUsePaymentOffset_65, t0.canRenewContract AS canRenewContract_66, t0.stopPrintContract AS stopPrintContract_67, t0.activeLockedForSales AS activeLockedForSales_68, t0.displayPartnerSpaceInsInfo AS displayPartnerSpaceInsInfo_69, t0.sendDocsToClientAfterSigned AS sendDocsToClientAfterSigned_70, t0.paymentCondition AS paymentCondition_71, t0.paymentMode AS paymentMode_72, t0.comment AS comment_73, t0.active AS active_74, t0.canUseAssetOnCalc AS canUseAssetOnCalc_75, t0.useSepaDate AS useSepaDate_76, t0.rewardsOnPreComp AS rewardsOnPreComp_77, t0.useMultiStages AS useMultiStages_78, t0.riskSharing AS riskSharing_79, t0.paidAfterCAL AS paidAfterCAL_80, t0.wantToSeeHomeMap AS wantToSeeHomeMap_81, t0.oauth2 AS oauth2_82, t0.clientSecret AS clientSecret_83, t0.clientId AS clientId_84, t0.tenantId AS tenantId_85, t0.slug AS slug_86, t0.invoiceLogo AS invoiceLogo_87, t0.spaceLogo AS spaceLogo_88, t0.spaceFavicon AS spaceFavicon_89, t0.spacePrimaryColor AS spacePrimaryColor_90, t0.spaceSecondaryColor AS spaceSecondaryColor_91, t0.contractLogo AS contractLogo_92, t0.bdcLogo AS bdcLogo_93, t0.bdcAgree AS bdcAgree_94, t0.agreeLogo AS agreeLogo_95, t0.addressContract AS addressContract_96, t0.addressAgree AS addressAgree_97, t0.addressInvoice AS addressInvoice_98, t0.addressBdc AS addressBdc_99, t0.welcomeAddon AS welcomeAddon_100, t0.footer AS footer_101, t0.header AS header_102, t0.vendorPostingGroup AS vendorPostingGroup_103, t0.acceptThresholdEL AS acceptThresholdEL_104, t0.acceptThresholdCS AS acceptThresholdCS_105, t0.acceptAmount AS acceptAmount_106, t0.rejectThresholdEL AS rejectThresholdEL_107, t0.rejectThresholdCS AS rejectThresholdCS_108, t0.useGracePeriod AS useGracePeriod_109, t0.gracePeriodMax AS gracePeriodMax_110, t0.noInsuranceOnGracePeriod AS noInsuranceOnGracePeriod_111, t0.noLiOnGracePeriod AS noLiOnGracePeriod_112, t0.canViewRewards AS canViewRewards_113, t0.canViewAcceptRate AS canViewAcceptRate_114, t0.hasProlongationCommission AS hasProlongationCommission_115, t0.prolongationCommission AS prolongationCommission_116, t0.prolongationCommissionAllin AS prolongationCommissionAllin_117, t0.prolongationCommissionFrequency AS prolongationCommissionFrequency_118, t0.prolongationCommissionTarget AS prolongationCommissionTarget_119, t0.idLeasLiaison AS idLeasLiaison_120, t0.idLeasSale AS idLeasSale_121, t0.idPartnerScheme AS idPartnerScheme_122, t0.idContractTemplate AS idContractTemplate_123, t0.idPvTemplate AS idPvTemplate_124, t0.idSepaTemplate AS idSepaTemplate_125, t0.idCgvTemplate AS idCgvTemplate_126, t0.idAnnexTemplate AS idAnnexTemplate_127, t0.idBdcTemplate AS idBdcTemplate_128 FROM partner t0 WHERE t0.slug = 'ww12' AND t0.active = 1 LIMIT 1;
|