Возможные запросы к базе данных

select "Name", "Inn", "PartnersGrpID", "Enabled", "PhoneNumber", "ExtCode" from "dcPartners"

select "PartnersGrpID", "Enabled", "PhoneNumber", "ExtCode", " IsSeparateRests" from "dcPartners" where "Inn" = :"Inn"

Группа, вкл/выкл, номер телефона, внешний код, тип системы расчетов(балансовая, ограничения), балансы на доступных кошельках, кредитные ограничения на кошельках.

select "dcPartners"."PartnerID", "dcAmounts"."Name" as "AmountName", "dcAmounts"."AmountID" as "AmountID",
        "sysCreditTypes"."Name" as "CreditName",
        "dcCreditRestrictions"."Credit", "dcCreditRestrictions"."Period", "dcCreditRestrictions"."Price",
        "dcCreditRestrictions"."AutoMigration", "GetCreditRest"."Rest" from "dcPartners"
        left join "dcCreditRestrictions" on "dcCreditRestrictions"."PartnerID" = "dcPartners"."PartnerID"
        left join "dcAmounts" on "dcAmounts"."AmountID" = "dcCreditRestrictions"."AmountID"
        left join "sysCreditTypes" on "sysCreditTypes"."CreditTypeID" = "dcCreditRestrictions"."CreditTypeID"
        left join "GetCreditRest"("dcCreditRestrictions"."PartnerID", "dcCreditRestrictions"."AmountID") on 1=1
        where "dcPartners"."PartnerID" = :"PartnerID";