@cfxlabsinc/b2b-services
    Preparing search index...

    Class ProductQuoteAdminService

    Admin-tier reads over product_quote. The audit table is append-only — ProductQuoteService.quote() is the sole writer. There is no create / update / delete here by design.

    Index
    constructor
    db
    get getRouteTiming search
    db: B2bDatabase

    • Projects the timing-relevant subset of product_route_version.data for the route version this quote was pinned to. Returned values are normalized with the same defaults ProductQuoteService.quote() applies when stamping minSettlementDate, so workflows enforcing the same hold contract post-settlement (e.g. the Metcap ACH debit deposit hold) can read a single source of truth. Returns null when no quote matches id.

      Parameters

      • input: { id: string }

      Returns Promise<
          | {
              cutoffTimezone: string;
              holdBusinessDays: number;
              settlementBusinessDays: number;
          }
          | null,
      >

    • Parameters

      • input: {
            createdAt?: DbTimestampCriteria<Instant>;
            customerIds?: string[];
            ids?: string[];
            orderBy?: DbOrderByCriterion<
                Omit<
                    PgTableWithColumns<
                        {
                            columns: {
                                acceptedAt: PgBuildColumn<
                                    "product_quote",
                                    PgCustomColumnBuilder<{ data: ...; dataType: ...; driverParam: ... }>,
                                    {
                                        data: Instant;
                                        dataType: "custom";
                                        driverParam: string;
                                        enumValues: undefined;
                                        generated: undefined;
                                        hasDefault: false;
                                        hasRuntimeDefault: false;
                                        identity: undefined;
                                        isAutoincrement: false;
                                        isPrimaryKey: false;
                                        name: string;
                                        notNull: false;
                                        tableName: "product_quote";
                                    },
                                >;
                                activationRuleVersionId: PgBuildColumn<
                                    "product_quote",
                                    PgIntegerBuilder,
                                    {
                                        data: number;
                                        dataType: "number int32";
                                        driverParam: (...)
                                        | (...);
                                        enumValues: undefined;
                                        generated: undefined;
                                        hasDefault: false;
                                        hasRuntimeDefault: false;
                                        identity: undefined;
                                        isAutoincrement: false;
                                        isPrimaryKey: false;
                                        name: string;
                                        notNull: false;
                                        tableName: "product_quote";
                                    },
                                >;
                                aggregateUsage: PgBuildColumn<
                                    "product_quote",
                                    Set$Type<PgJsonbBuilder, PinnedUsageSnapshot>,
                                    {
                                        data: PinnedUsageSnapshot;
                                        dataType: "object json";
                                        driverParam: unknown;
                                        enumValues: undefined;
                                        generated: undefined;
                                        hasDefault: false;
                                        hasRuntimeDefault: false;
                                        identity: undefined;
                                        isAutoincrement: false;
                                        isPrimaryKey: false;
                                        name: string;
                                        notNull: false;
                                        tableName: "product_quote";
                                    },
                                >;
                                bankId: PgBuildColumn<
                                    "product_quote",
                                    Set$Type<PgTextBuilder<(...)>, string>,
                                    {
                                        data: string;
                                        dataType: "string";
                                        driverParam: string;
                                        enumValues: undefined;
                                        generated: undefined;
                                        hasDefault: false;
                                        hasRuntimeDefault: false;
                                        identity: undefined;
                                        isAutoincrement: false;
                                        isPrimaryKey: false;
                                        name: string;
                                        notNull: false;
                                        tableName: "product_quote";
                                    },
                                >;
                                cashDepositRetailerId: PgBuildColumn<
                                    "product_quote",
                                    PgTextBuilder<[(...), ...(...)[]]>,
                                    {
                                        data: string;
                                        dataType: "string";
                                        driverParam: string;
                                        enumValues: undefined;
                                        generated: undefined;
                                        hasDefault: false;
                                        hasRuntimeDefault: false;
                                        identity: undefined;
                                        isAutoincrement: false;
                                        isPrimaryKey: false;
                                        name: string;
                                        notNull: false;
                                        tableName: "product_quote";
                                    },
                                >;
                                cfxFixedFeeAmount: PgBuildColumn<
                                    "product_quote",
                                    PgCustomColumnBuilder<{ data: ...; dataType: ...; driverParam: ... }>,
                                    {
                                        data: BigNumber;
                                        dataType: "custom";
                                        driverParam: string;
                                        enumValues: undefined;
                                        generated: undefined;
                                        hasDefault: false;
                                        hasRuntimeDefault: false;
                                        identity: undefined;
                                        isAutoincrement: false;
                                        isPrimaryKey: false;
                                        name: string;
                                        notNull: false;
                                        tableName: "product_quote";
                                    },
                                >;
                                cfxVariableFeeAmount: PgBuildColumn<
                                    "product_quote",
                                    PgCustomColumnBuilder<{ data: ...; dataType: ...; driverParam: ... }>,
                                    {
                                        data: BigNumber;
                                        dataType: "custom";
                                        driverParam: string;
                                        enumValues: undefined;
                                        generated: undefined;
                                        hasDefault: false;
                                        hasRuntimeDefault: false;
                                        identity: undefined;
                                        isAutoincrement: false;
                                        isPrimaryKey: false;
                                        name: string;
                                        notNull: false;
                                        tableName: "product_quote";
                                    },
                                >;
                                cfxVariableFeeBps: PgBuildColumn<
                                    "product_quote",
                                    PgCustomColumnBuilder<{ data: ...; dataType: ...; driverParam: ... }>,
                                    {
                                        data: BigNumber;
                                        dataType: "custom";
                                        driverParam: string;
                                        enumValues: undefined;
                                        generated: undefined;
                                        hasDefault: false;
                                        hasRuntimeDefault: false;
                                        identity: undefined;
                                        isAutoincrement: false;
                                        isPrimaryKey: false;
                                        name: string;
                                        notNull: false;
                                        tableName: "product_quote";
                                    },
                                >;
                                createdAt: PgBuildColumn<
                                    "product_quote",
                                    SetHasDefault<SetNotNull<(...)>>,
                                    {
                                        data: Instant;
                                        dataType: "custom";
                                        driverParam: string;
                                        enumValues: undefined;
                                        generated: undefined;
                                        hasDefault: true;
                                        hasRuntimeDefault: false;
                                        identity: undefined;
                                        isAutoincrement: false;
                                        isPrimaryKey: false;
                                        name: string;
                                        notNull: true;
                                        tableName: "product_quote";
                                    },
                                >;
                                customerFixedFeeAmount: PgBuildColumn<
                                    "product_quote",
                                    PgCustomColumnBuilder<{ data: ...; dataType: ...; driverParam: ... }>,
                                    {
                                        data: BigNumber;
                                        dataType: "custom";
                                        driverParam: string;
                                        enumValues: undefined;
                                        generated: undefined;
                                        hasDefault: false;
                                        hasRuntimeDefault: false;
                                        identity: undefined;
                                        isAutoincrement: false;
                                        isPrimaryKey: false;
                                        name: string;
                                        notNull: false;
                                        tableName: "product_quote";
                                    },
                                >;
                                customerId: PgBuildColumn<
                                    "product_quote",
                                    SetNotNull<PgIntegerBuilder>,
                                    {
                                        data: number;
                                        dataType: "number int32";
                                        driverParam: (...) | (...);
                                        enumValues: undefined;
                                        generated: undefined;
                                        hasDefault: false;
                                        hasRuntimeDefault: false;
                                        identity: undefined;
                                        isAutoincrement: false;
                                        isPrimaryKey: false;
                                        name: string;
                                        notNull: true;
                                        tableName: "product_quote";
                                    },
                                >;
                                customerVariableFeeAmount: PgBuildColumn<
                                    "product_quote",
                                    PgCustomColumnBuilder<{ data: ...; dataType: ...; driverParam: ... }>,
                                    {
                                        data: BigNumber;
                                        dataType: "custom";
                                        driverParam: string;
                                        enumValues: undefined;
                                        generated: undefined;
                                        hasDefault: false;
                                        hasRuntimeDefault: false;
                                        identity: undefined;
                                        isAutoincrement: false;
                                        isPrimaryKey: false;
                                        name: string;
                                        notNull: false;
                                        tableName: "product_quote";
                                    },
                                >;
                                customerVariableFeeBps: PgBuildColumn<
                                    "product_quote",
                                    PgCustomColumnBuilder<{ data: ...; dataType: ...; driverParam: ... }>,
                                    {
                                        data: BigNumber;
                                        dataType: "custom";
                                        driverParam: string;
                                        enumValues: undefined;
                                        generated: undefined;
                                        hasDefault: false;
                                        hasRuntimeDefault: false;
                                        identity: undefined;
                                        isAutoincrement: false;
                                        isPrimaryKey: false;
                                        name: string;
                                        notNull: false;
                                        tableName: "product_quote";
                                    },
                                >;
                                data: PgBuildColumn<
                                    "product_quote",
                                    Set$Type<SetHasDefault<(...)>, Partial<(...)>>,
                                    {
                                        data: Partial<(...)>;
                                        dataType: "object json";
                                        driverParam: unknown;
                                        enumValues: undefined;
                                        generated: undefined;
                                        hasDefault: true;
                                        hasRuntimeDefault: false;
                                        identity: undefined;
                                        isAutoincrement: false;
                                        isPrimaryKey: false;
                                        name: string;
                                        notNull: true;
                                        tableName: "product_quote";
                                    },
                                >;
                                decimalPlaces: PgBuildColumn<
                                    "product_quote",
                                    SetHasDefault<SetNotNull<(...)>>,
                                    {
                                        data: number;
                                        dataType: "number int32";
                                        driverParam: (...) | (...);
                                        enumValues: undefined;
                                        generated: undefined;
                                        hasDefault: true;
                                        hasRuntimeDefault: false;
                                        identity: undefined;
                                        isAutoincrement: false;
                                        isPrimaryKey: false;
                                        name: string;
                                        notNull: true;
                                        tableName: "product_quote";
                                    },
                                >;
                                expiresAt: PgBuildColumn<
                                    "product_quote",
                                    SetNotNull<PgCustomColumnBuilder<(...)>>,
                                    {
                                        data: Instant;
                                        dataType: "custom";
                                        driverParam: string;
                                        enumValues: undefined;
                                        generated: undefined;
                                        hasDefault: false;
                                        hasRuntimeDefault: false;
                                        identity: undefined;
                                        isAutoincrement: false;
                                        isPrimaryKey: false;
                                        name: string;
                                        notNull: true;
                                        tableName: "product_quote";
                                    },
                                >;
                                externalId: PgBuildColumn<
                                    "product_quote",
                                    SetHasRuntimeDefault<SetNotNull<(...)>>,
                                    {
                                        data: string;
                                        dataType: "string";
                                        driverParam: string;
                                        enumValues: undefined;
                                        generated: undefined;
                                        hasDefault: true;
                                        hasRuntimeDefault: false;
                                        identity: undefined;
                                        isAutoincrement: false;
                                        isPrimaryKey: false;
                                        name: string;
                                        notNull: true;
                                        tableName: "product_quote";
                                    },
                                >;
                                feeRuleVersionId: PgBuildColumn<
                                    "product_quote",
                                    PgIntegerBuilder,
                                    {
                                        data: number;
                                        dataType: "number int32";
                                        driverParam: (...)
                                        | (...);
                                        enumValues: undefined;
                                        generated: undefined;
                                        hasDefault: false;
                                        hasRuntimeDefault: false;
                                        identity: undefined;
                                        isAutoincrement: false;
                                        isPrimaryKey: false;
                                        name: string;
                                        notNull: false;
                                        tableName: "product_quote";
                                    },
                                >;
                                id: PgBuildColumn<
                                    "product_quote",
                                    HasIdentity<SetIsPrimaryKey<(...)>, "byDefault">,
                                    {
                                        data: number;
                                        dataType: "number int32";
                                        driverParam: (...) | (...);
                                        enumValues: undefined;
                                        generated: undefined;
                                        hasDefault: true;
                                        hasRuntimeDefault: false;
                                        identity: "byDefault";
                                        isAutoincrement: false;
                                        isPrimaryKey: false;
                                        name: string;
                                        notNull: true;
                                        tableName: "product_quote";
                                    },
                                >;
                                idempotencyKey: PgBuildColumn<
                                    "product_quote",
                                    PgTextBuilder<[(...), ...(...)[]]>,
                                    {
                                        data: string;
                                        dataType: "string";
                                        driverParam: string;
                                        enumValues: undefined;
                                        generated: undefined;
                                        hasDefault: false;
                                        hasRuntimeDefault: false;
                                        identity: undefined;
                                        isAutoincrement: false;
                                        isPrimaryKey: false;
                                        name: string;
                                        notNull: false;
                                        tableName: "product_quote";
                                    },
                                >;
                                identityId: PgBuildColumn<
                                    "product_quote",
                                    PgIntegerBuilder,
                                    {
                                        data: number;
                                        dataType: "number int32";
                                        driverParam: (...)
                                        | (...);
                                        enumValues: undefined;
                                        generated: undefined;
                                        hasDefault: false;
                                        hasRuntimeDefault: false;
                                        identity: undefined;
                                        isAutoincrement: false;
                                        isPrimaryKey: false;
                                        name: string;
                                        notNull: false;
                                        tableName: "product_quote";
                                    },
                                >;
                                inputSourceAmount: PgBuildColumn<
                                    "product_quote",
                                    PgCustomColumnBuilder<{ data: ...; dataType: ...; driverParam: ... }>,
                                    {
                                        data: BigNumber;
                                        dataType: "custom";
                                        driverParam: string;
                                        enumValues: undefined;
                                        generated: undefined;
                                        hasDefault: false;
                                        hasRuntimeDefault: false;
                                        identity: undefined;
                                        isAutoincrement: false;
                                        isPrimaryKey: false;
                                        name: string;
                                        notNull: false;
                                        tableName: "product_quote";
                                    },
                                >;
                                inputTargetAmount: PgBuildColumn<
                                    "product_quote",
                                    PgCustomColumnBuilder<{ data: ...; dataType: ...; driverParam: ... }>,
                                    {
                                        data: BigNumber;
                                        dataType: "custom";
                                        driverParam: string;
                                        enumValues: undefined;
                                        generated: undefined;
                                        hasDefault: false;
                                        hasRuntimeDefault: false;
                                        identity: undefined;
                                        isAutoincrement: false;
                                        isPrimaryKey: false;
                                        name: string;
                                        notNull: false;
                                        tableName: "product_quote";
                                    },
                                >;
                                limitEvaluation: PgBuildColumn<
                                    "product_quote",
                                    Set$Type<PgJsonbBuilder, LimitEvaluation>,
                                    {
                                        data: LimitEvaluation;
                                        dataType: "object json";
                                        driverParam: unknown;
                                        enumValues: undefined;
                                        generated: undefined;
                                        hasDefault: false;
                                        hasRuntimeDefault: false;
                                        identity: undefined;
                                        isAutoincrement: false;
                                        isPrimaryKey: false;
                                        name: string;
                                        notNull: false;
                                        tableName: "product_quote";
                                    },
                                >;
                                limitRuleVersionId: PgBuildColumn<
                                    "product_quote",
                                    PgIntegerBuilder,
                                    {
                                        data: number;
                                        dataType: "number int32";
                                        driverParam: (...)
                                        | (...);
                                        enumValues: undefined;
                                        generated: undefined;
                                        hasDefault: false;
                                        hasRuntimeDefault: false;
                                        identity: undefined;
                                        isAutoincrement: false;
                                        isPrimaryKey: false;
                                        name: string;
                                        notNull: false;
                                        tableName: "product_quote";
                                    },
                                >;
                                minSettlementDate: PgBuildColumn<
                                    "product_quote",
                                    PgDateStringBuilder,
                                    {
                                        data: string;
                                        dataType: "string date";
                                        driverParam: string;
                                        enumValues: undefined;
                                        generated: undefined;
                                        hasDefault: false;
                                        hasRuntimeDefault: false;
                                        identity: undefined;
                                        isAutoincrement: false;
                                        isPrimaryKey: false;
                                        name: string;
                                        notNull: false;
                                        tableName: "product_quote";
                                    },
                                >;
                                organizationId: PgBuildColumn<
                                    "product_quote",
                                    PgIntegerBuilder,
                                    {
                                        data: number;
                                        dataType: "number int32";
                                        driverParam: (...)
                                        | (...);
                                        enumValues: undefined;
                                        generated: undefined;
                                        hasDefault: false;
                                        hasRuntimeDefault: false;
                                        identity: undefined;
                                        isAutoincrement: false;
                                        isPrimaryKey: false;
                                        name: string;
                                        notNull: false;
                                        tableName: "product_quote";
                                    },
                                >;
                                outcome: PgBuildColumn<
                                    "product_quote",
                                    Set$Type<SetNotNull<(...)>, (...) | (...) | (...) | (...)>,
                                    {
                                        data: (...) | (...) | (...) | (...);
                                        dataType: "string";
                                        driverParam: string;
                                        enumValues: undefined;
                                        generated: undefined;
                                        hasDefault: false;
                                        hasRuntimeDefault: false;
                                        identity: undefined;
                                        isAutoincrement: false;
                                        isPrimaryKey: false;
                                        name: string;
                                        notNull: true;
                                        tableName: "product_quote";
                                    },
                                >;
                                productId: PgBuildColumn<
                                    "product_quote",
                                    SetNotNull<PgIntegerBuilder>,
                                    {
                                        data: number;
                                        dataType: "number int32";
                                        driverParam: (...) | (...);
                                        enumValues: undefined;
                                        generated: undefined;
                                        hasDefault: false;
                                        hasRuntimeDefault: false;
                                        identity: undefined;
                                        isAutoincrement: false;
                                        isPrimaryKey: false;
                                        name: string;
                                        notNull: true;
                                        tableName: "product_quote";
                                    },
                                >;
                                providerFeeVisible: PgBuildColumn<
                                    "product_quote",
                                    PgBooleanBuilder,
                                    {
                                        data: boolean;
                                        dataType: "boolean";
                                        driverParam: boolean;
                                        enumValues: undefined;
                                        generated: undefined;
                                        hasDefault: false;
                                        hasRuntimeDefault: false;
                                        identity: undefined;
                                        isAutoincrement: false;
                                        isPrimaryKey: false;
                                        name: string;
                                        notNull: false;
                                        tableName: "product_quote";
                                    },
                                >;
                                providerFixedFeeAmount: PgBuildColumn<
                                    "product_quote",
                                    PgCustomColumnBuilder<{ data: ...; dataType: ...; driverParam: ... }>,
                                    {
                                        data: BigNumber;
                                        dataType: "custom";
                                        driverParam: string;
                                        enumValues: undefined;
                                        generated: undefined;
                                        hasDefault: false;
                                        hasRuntimeDefault: false;
                                        identity: undefined;
                                        isAutoincrement: false;
                                        isPrimaryKey: false;
                                        name: string;
                                        notNull: false;
                                        tableName: "product_quote";
                                    },
                                >;
                                providerVariableFeeAmount: PgBuildColumn<
                                    "product_quote",
                                    PgCustomColumnBuilder<{ data: ...; dataType: ...; driverParam: ... }>,
                                    {
                                        data: BigNumber;
                                        dataType: "custom";
                                        driverParam: string;
                                        enumValues: undefined;
                                        generated: undefined;
                                        hasDefault: false;
                                        hasRuntimeDefault: false;
                                        identity: undefined;
                                        isAutoincrement: false;
                                        isPrimaryKey: false;
                                        name: string;
                                        notNull: false;
                                        tableName: "product_quote";
                                    },
                                >;
                                providerVariableFeeBps: PgBuildColumn<
                                    "product_quote",
                                    PgCustomColumnBuilder<{ data: ...; dataType: ...; driverParam: ... }>,
                                    {
                                        data: BigNumber;
                                        dataType: "custom";
                                        driverParam: string;
                                        enumValues: undefined;
                                        generated: undefined;
                                        hasDefault: false;
                                        hasRuntimeDefault: false;
                                        identity: undefined;
                                        isAutoincrement: false;
                                        isPrimaryKey: false;
                                        name: string;
                                        notNull: false;
                                        tableName: "product_quote";
                                    },
                                >;
                                quantity: PgBuildColumn<
                                    "product_quote",
                                    SetHasDefault<SetNotNull<(...)>>,
                                    {
                                        data: number;
                                        dataType: "number int32";
                                        driverParam: (...) | (...);
                                        enumValues: undefined;
                                        generated: undefined;
                                        hasDefault: true;
                                        hasRuntimeDefault: false;
                                        identity: undefined;
                                        isAutoincrement: false;
                                        isPrimaryKey: false;
                                        name: string;
                                        notNull: true;
                                        tableName: "product_quote";
                                    },
                                >;
                                regionCode: PgBuildColumn<
                                    "product_quote",
                                    PgTextBuilder<[(...), ...(...)[]]>,
                                    {
                                        data: string;
                                        dataType: "string";
                                        driverParam: string;
                                        enumValues: undefined;
                                        generated: undefined;
                                        hasDefault: false;
                                        hasRuntimeDefault: false;
                                        identity: undefined;
                                        isAutoincrement: false;
                                        isPrimaryKey: false;
                                        name: string;
                                        notNull: false;
                                        tableName: "product_quote";
                                    },
                                >;
                                routeVersionId: PgBuildColumn<
                                    "product_quote",
                                    SetNotNull<PgIntegerBuilder>,
                                    {
                                        data: number;
                                        dataType: "number int32";
                                        driverParam: (...) | (...);
                                        enumValues: undefined;
                                        generated: undefined;
                                        hasDefault: false;
                                        hasRuntimeDefault: false;
                                        identity: undefined;
                                        isAutoincrement: false;
                                        isPrimaryKey: false;
                                        name: string;
                                        notNull: true;
                                        tableName: "product_quote";
                                    },
                                >;
                                sourceAmount: PgBuildColumn<
                                    "product_quote",
                                    PgCustomColumnBuilder<{ data: ...; dataType: ...; driverParam: ... }>,
                                    {
                                        data: BigNumber;
                                        dataType: "custom";
                                        driverParam: string;
                                        enumValues: undefined;
                                        generated: undefined;
                                        hasDefault: false;
                                        hasRuntimeDefault: false;
                                        identity: undefined;
                                        isAutoincrement: false;
                                        isPrimaryKey: false;
                                        name: string;
                                        notNull: false;
                                        tableName: "product_quote";
                                    },
                                >;
                                sourceCurrency: PgBuildColumn<
                                    "product_quote",
                                    PgTextBuilder<[(...), ...(...)[]]>,
                                    {
                                        data: string;
                                        dataType: "string";
                                        driverParam: string;
                                        enumValues: undefined;
                                        generated: undefined;
                                        hasDefault: false;
                                        hasRuntimeDefault: false;
                                        identity: undefined;
                                        isAutoincrement: false;
                                        isPrimaryKey: false;
                                        name: string;
                                        notNull: false;
                                        tableName: "product_quote";
                                    },
                                >;
                                speed: PgBuildColumn<
                                    "product_quote",
                                    Set$Type<PgTextBuilder<(...)>, Speed>,
                                    {
                                        data: Speed;
                                        dataType: "string";
                                        driverParam: string;
                                        enumValues: undefined;
                                        generated: undefined;
                                        hasDefault: false;
                                        hasRuntimeDefault: false;
                                        identity: undefined;
                                        isAutoincrement: false;
                                        isPrimaryKey: false;
                                        name: string;
                                        notNull: false;
                                        tableName: "product_quote";
                                    },
                                >;
                                targetAmountAfterFees: PgBuildColumn<
                                    "product_quote",
                                    PgCustomColumnBuilder<{ data: ...; dataType: ...; driverParam: ... }>,
                                    {
                                        data: BigNumber;
                                        dataType: "custom";
                                        driverParam: string;
                                        enumValues: undefined;
                                        generated: undefined;
                                        hasDefault: false;
                                        hasRuntimeDefault: false;
                                        identity: undefined;
                                        isAutoincrement: false;
                                        isPrimaryKey: false;
                                        name: string;
                                        notNull: false;
                                        tableName: "product_quote";
                                    },
                                >;
                                targetCurrency: PgBuildColumn<
                                    "product_quote",
                                    PgTextBuilder<[(...), ...(...)[]]>,
                                    {
                                        data: string;
                                        dataType: "string";
                                        driverParam: string;
                                        enumValues: undefined;
                                        generated: undefined;
                                        hasDefault: false;
                                        hasRuntimeDefault: false;
                                        identity: undefined;
                                        isAutoincrement: false;
                                        isPrimaryKey: false;
                                        name: string;
                                        notNull: false;
                                        tableName: "product_quote";
                                    },
                                >;
                                totalFees: PgBuildColumn<
                                    "product_quote",
                                    PgCustomColumnBuilder<{ data: ...; dataType: ...; driverParam: ... }>,
                                    {
                                        data: BigNumber;
                                        dataType: "custom";
                                        driverParam: string;
                                        enumValues: undefined;
                                        generated: undefined;
                                        hasDefault: false;
                                        hasRuntimeDefault: false;
                                        identity: undefined;
                                        isAutoincrement: false;
                                        isPrimaryKey: false;
                                        name: string;
                                        notNull: false;
                                        tableName: "product_quote";
                                    },
                                >;
                                vendorVersionId: PgBuildColumn<
                                    "product_quote",
                                    SetNotNull<PgIntegerBuilder>,
                                    {
                                        data: number;
                                        dataType: "number int32";
                                        driverParam: (...) | (...);
                                        enumValues: undefined;
                                        generated: undefined;
                                        hasDefault: false;
                                        hasRuntimeDefault: false;
                                        identity: undefined;
                                        isAutoincrement: false;
                                        isPrimaryKey: false;
                                        name: string;
                                        notNull: true;
                                        tableName: "product_quote";
                                    },
                                >;
                                violationLimit: PgBuildColumn<
                                    "product_quote",
                                    PgCustomColumnBuilder<{ data: ...; dataType: ...; driverParam: ... }>,
                                    {
                                        data: BigNumber;
                                        dataType: "custom";
                                        driverParam: string;
                                        enumValues: undefined;
                                        generated: undefined;
                                        hasDefault: false;
                                        hasRuntimeDefault: false;
                                        identity: undefined;
                                        isAutoincrement: false;
                                        isPrimaryKey: false;
                                        name: string;
                                        notNull: false;
                                        tableName: "product_quote";
                                    },
                                >;
                                violationType: PgBuildColumn<
                                    "product_quote",
                                    Set$Type<PgTextBuilder<(...)>, (...) | (...) | (...)>,
                                    {
                                        data: (...) | (...) | (...);
                                        dataType: "string";
                                        driverParam: string;
                                        enumValues: undefined;
                                        generated: undefined;
                                        hasDefault: false;
                                        hasRuntimeDefault: false;
                                        identity: undefined;
                                        isAutoincrement: false;
                                        isPrimaryKey: false;
                                        name: string;
                                        notNull: false;
                                        tableName: "product_quote";
                                    },
                                >;
                                violationUsage: PgBuildColumn<
                                    "product_quote",
                                    PgCustomColumnBuilder<{ data: ...; dataType: ...; driverParam: ... }>,
                                    {
                                        data: BigNumber;
                                        dataType: "custom";
                                        driverParam: string;
                                        enumValues: undefined;
                                        generated: undefined;
                                        hasDefault: false;
                                        hasRuntimeDefault: false;
                                        identity: undefined;
                                        isAutoincrement: false;
                                        isPrimaryKey: false;
                                        name: string;
                                        notNull: false;
                                        tableName: "product_quote";
                                    },
                                >;
                                violationWindow: PgBuildColumn<
                                    "product_quote",
                                    Set$Type<PgTextBuilder<(...)>, (...) | (...) | (...) | (...) | (...)>,
                                    {
                                        data: (...) | (...) | (...) | (...) | (...);
                                        dataType: "string";
                                        driverParam: string;
                                        enumValues: undefined;
                                        generated: undefined;
                                        hasDefault: false;
                                        hasRuntimeDefault: false;
                                        identity: undefined;
                                        isAutoincrement: false;
                                        isPrimaryKey: false;
                                        name: string;
                                        notNull: false;
                                        tableName: "product_quote";
                                    },
                                >;
                            };
                            dialect: "pg";
                            name: "product_quote";
                            schema: "b2b";
                        },
                    >,
                    "enableRLS",
                >,
                "sourceAmount"
                | "createdAt"
                | "totalFees"
                | "targetAmountAfterFees",
            >[];
            outcomes?: ("INACTIVE" | "LIMIT_EXCEEDED" | "OK")[];
            page?: number;
            pageSize?: number;
            productNames?: (
                | "organization.v1"
                | "identity.v1"
                | "card.physical_card.v1"
                | "card.virtual_card.v1"
                | "deposit.us_cash.v1"
                | "deposit.rtp.v1"
                | "deposit.us_bank_ach.v1"
                | "deposit.ach_credit.v1"
                | "deposit.us_wire.v1"
                | "deposit.swift_wire.v1"
                | "transfer.redemption.v1"
                | "swap.v1"
                | "withdraw.blockchain.v1"
                | "withdraw.ke_bank.v1"
                | "withdraw.ke_momo.v1"
                | "withdraw.mx_bank_spei.v1"
                | "withdraw.swift_wire.v1"
                | "withdraw.tg_momo.v1"
                | "withdraw.us_bank_ach.v1"
                | "withdraw.us_instant.v1"
                | "withdraw.us_wire.v1"
                | "withdraw.ach_pull.v1"
                | "withdraw.us_wire_drawdown.v1"
                | "account.virtual-account.v1"
                | "deposit.*"
                | "withdraw.*"
            )[];
            q?: string;
            routeIds?: string[];
        }
        • OptionalcreatedAt?: DbTimestampCriteria<Instant>
        • OptionalcustomerIds?: string[]
        • Optionalids?: string[]
        • OptionalorderBy?: DbOrderByCriterion<
              Omit<
                  PgTableWithColumns<
                      {
                          columns: {
                              acceptedAt: PgBuildColumn<
                                  "product_quote",
                                  PgCustomColumnBuilder<{ data: ...; dataType: ...; driverParam: ... }>,
                                  {
                                      data: Instant;
                                      dataType: "custom";
                                      driverParam: string;
                                      enumValues: undefined;
                                      generated: undefined;
                                      hasDefault: false;
                                      hasRuntimeDefault: false;
                                      identity: undefined;
                                      isAutoincrement: false;
                                      isPrimaryKey: false;
                                      name: string;
                                      notNull: false;
                                      tableName: "product_quote";
                                  },
                              >;
                              activationRuleVersionId: PgBuildColumn<
                                  "product_quote",
                                  PgIntegerBuilder,
                                  {
                                      data: number;
                                      dataType: "number int32";
                                      driverParam: (...)
                                      | (...);
                                      enumValues: undefined;
                                      generated: undefined;
                                      hasDefault: false;
                                      hasRuntimeDefault: false;
                                      identity: undefined;
                                      isAutoincrement: false;
                                      isPrimaryKey: false;
                                      name: string;
                                      notNull: false;
                                      tableName: "product_quote";
                                  },
                              >;
                              aggregateUsage: PgBuildColumn<
                                  "product_quote",
                                  Set$Type<PgJsonbBuilder, PinnedUsageSnapshot>,
                                  {
                                      data: PinnedUsageSnapshot;
                                      dataType: "object json";
                                      driverParam: unknown;
                                      enumValues: undefined;
                                      generated: undefined;
                                      hasDefault: false;
                                      hasRuntimeDefault: false;
                                      identity: undefined;
                                      isAutoincrement: false;
                                      isPrimaryKey: false;
                                      name: string;
                                      notNull: false;
                                      tableName: "product_quote";
                                  },
                              >;
                              bankId: PgBuildColumn<
                                  "product_quote",
                                  Set$Type<PgTextBuilder<(...)>, string>,
                                  {
                                      data: string;
                                      dataType: "string";
                                      driverParam: string;
                                      enumValues: undefined;
                                      generated: undefined;
                                      hasDefault: false;
                                      hasRuntimeDefault: false;
                                      identity: undefined;
                                      isAutoincrement: false;
                                      isPrimaryKey: false;
                                      name: string;
                                      notNull: false;
                                      tableName: "product_quote";
                                  },
                              >;
                              cashDepositRetailerId: PgBuildColumn<
                                  "product_quote",
                                  PgTextBuilder<[(...), ...(...)[]]>,
                                  {
                                      data: string;
                                      dataType: "string";
                                      driverParam: string;
                                      enumValues: undefined;
                                      generated: undefined;
                                      hasDefault: false;
                                      hasRuntimeDefault: false;
                                      identity: undefined;
                                      isAutoincrement: false;
                                      isPrimaryKey: false;
                                      name: string;
                                      notNull: false;
                                      tableName: "product_quote";
                                  },
                              >;
                              cfxFixedFeeAmount: PgBuildColumn<
                                  "product_quote",
                                  PgCustomColumnBuilder<{ data: ...; dataType: ...; driverParam: ... }>,
                                  {
                                      data: BigNumber;
                                      dataType: "custom";
                                      driverParam: string;
                                      enumValues: undefined;
                                      generated: undefined;
                                      hasDefault: false;
                                      hasRuntimeDefault: false;
                                      identity: undefined;
                                      isAutoincrement: false;
                                      isPrimaryKey: false;
                                      name: string;
                                      notNull: false;
                                      tableName: "product_quote";
                                  },
                              >;
                              cfxVariableFeeAmount: PgBuildColumn<
                                  "product_quote",
                                  PgCustomColumnBuilder<{ data: ...; dataType: ...; driverParam: ... }>,
                                  {
                                      data: BigNumber;
                                      dataType: "custom";
                                      driverParam: string;
                                      enumValues: undefined;
                                      generated: undefined;
                                      hasDefault: false;
                                      hasRuntimeDefault: false;
                                      identity: undefined;
                                      isAutoincrement: false;
                                      isPrimaryKey: false;
                                      name: string;
                                      notNull: false;
                                      tableName: "product_quote";
                                  },
                              >;
                              cfxVariableFeeBps: PgBuildColumn<
                                  "product_quote",
                                  PgCustomColumnBuilder<{ data: ...; dataType: ...; driverParam: ... }>,
                                  {
                                      data: BigNumber;
                                      dataType: "custom";
                                      driverParam: string;
                                      enumValues: undefined;
                                      generated: undefined;
                                      hasDefault: false;
                                      hasRuntimeDefault: false;
                                      identity: undefined;
                                      isAutoincrement: false;
                                      isPrimaryKey: false;
                                      name: string;
                                      notNull: false;
                                      tableName: "product_quote";
                                  },
                              >;
                              createdAt: PgBuildColumn<
                                  "product_quote",
                                  SetHasDefault<SetNotNull<(...)>>,
                                  {
                                      data: Instant;
                                      dataType: "custom";
                                      driverParam: string;
                                      enumValues: undefined;
                                      generated: undefined;
                                      hasDefault: true;
                                      hasRuntimeDefault: false;
                                      identity: undefined;
                                      isAutoincrement: false;
                                      isPrimaryKey: false;
                                      name: string;
                                      notNull: true;
                                      tableName: "product_quote";
                                  },
                              >;
                              customerFixedFeeAmount: PgBuildColumn<
                                  "product_quote",
                                  PgCustomColumnBuilder<{ data: ...; dataType: ...; driverParam: ... }>,
                                  {
                                      data: BigNumber;
                                      dataType: "custom";
                                      driverParam: string;
                                      enumValues: undefined;
                                      generated: undefined;
                                      hasDefault: false;
                                      hasRuntimeDefault: false;
                                      identity: undefined;
                                      isAutoincrement: false;
                                      isPrimaryKey: false;
                                      name: string;
                                      notNull: false;
                                      tableName: "product_quote";
                                  },
                              >;
                              customerId: PgBuildColumn<
                                  "product_quote",
                                  SetNotNull<PgIntegerBuilder>,
                                  {
                                      data: number;
                                      dataType: "number int32";
                                      driverParam: (...) | (...);
                                      enumValues: undefined;
                                      generated: undefined;
                                      hasDefault: false;
                                      hasRuntimeDefault: false;
                                      identity: undefined;
                                      isAutoincrement: false;
                                      isPrimaryKey: false;
                                      name: string;
                                      notNull: true;
                                      tableName: "product_quote";
                                  },
                              >;
                              customerVariableFeeAmount: PgBuildColumn<
                                  "product_quote",
                                  PgCustomColumnBuilder<{ data: ...; dataType: ...; driverParam: ... }>,
                                  {
                                      data: BigNumber;
                                      dataType: "custom";
                                      driverParam: string;
                                      enumValues: undefined;
                                      generated: undefined;
                                      hasDefault: false;
                                      hasRuntimeDefault: false;
                                      identity: undefined;
                                      isAutoincrement: false;
                                      isPrimaryKey: false;
                                      name: string;
                                      notNull: false;
                                      tableName: "product_quote";
                                  },
                              >;
                              customerVariableFeeBps: PgBuildColumn<
                                  "product_quote",
                                  PgCustomColumnBuilder<{ data: ...; dataType: ...; driverParam: ... }>,
                                  {
                                      data: BigNumber;
                                      dataType: "custom";
                                      driverParam: string;
                                      enumValues: undefined;
                                      generated: undefined;
                                      hasDefault: false;
                                      hasRuntimeDefault: false;
                                      identity: undefined;
                                      isAutoincrement: false;
                                      isPrimaryKey: false;
                                      name: string;
                                      notNull: false;
                                      tableName: "product_quote";
                                  },
                              >;
                              data: PgBuildColumn<
                                  "product_quote",
                                  Set$Type<SetHasDefault<(...)>, Partial<(...)>>,
                                  {
                                      data: Partial<(...)>;
                                      dataType: "object json";
                                      driverParam: unknown;
                                      enumValues: undefined;
                                      generated: undefined;
                                      hasDefault: true;
                                      hasRuntimeDefault: false;
                                      identity: undefined;
                                      isAutoincrement: false;
                                      isPrimaryKey: false;
                                      name: string;
                                      notNull: true;
                                      tableName: "product_quote";
                                  },
                              >;
                              decimalPlaces: PgBuildColumn<
                                  "product_quote",
                                  SetHasDefault<SetNotNull<(...)>>,
                                  {
                                      data: number;
                                      dataType: "number int32";
                                      driverParam: (...) | (...);
                                      enumValues: undefined;
                                      generated: undefined;
                                      hasDefault: true;
                                      hasRuntimeDefault: false;
                                      identity: undefined;
                                      isAutoincrement: false;
                                      isPrimaryKey: false;
                                      name: string;
                                      notNull: true;
                                      tableName: "product_quote";
                                  },
                              >;
                              expiresAt: PgBuildColumn<
                                  "product_quote",
                                  SetNotNull<PgCustomColumnBuilder<(...)>>,
                                  {
                                      data: Instant;
                                      dataType: "custom";
                                      driverParam: string;
                                      enumValues: undefined;
                                      generated: undefined;
                                      hasDefault: false;
                                      hasRuntimeDefault: false;
                                      identity: undefined;
                                      isAutoincrement: false;
                                      isPrimaryKey: false;
                                      name: string;
                                      notNull: true;
                                      tableName: "product_quote";
                                  },
                              >;
                              externalId: PgBuildColumn<
                                  "product_quote",
                                  SetHasRuntimeDefault<SetNotNull<(...)>>,
                                  {
                                      data: string;
                                      dataType: "string";
                                      driverParam: string;
                                      enumValues: undefined;
                                      generated: undefined;
                                      hasDefault: true;
                                      hasRuntimeDefault: false;
                                      identity: undefined;
                                      isAutoincrement: false;
                                      isPrimaryKey: false;
                                      name: string;
                                      notNull: true;
                                      tableName: "product_quote";
                                  },
                              >;
                              feeRuleVersionId: PgBuildColumn<
                                  "product_quote",
                                  PgIntegerBuilder,
                                  {
                                      data: number;
                                      dataType: "number int32";
                                      driverParam: (...)
                                      | (...);
                                      enumValues: undefined;
                                      generated: undefined;
                                      hasDefault: false;
                                      hasRuntimeDefault: false;
                                      identity: undefined;
                                      isAutoincrement: false;
                                      isPrimaryKey: false;
                                      name: string;
                                      notNull: false;
                                      tableName: "product_quote";
                                  },
                              >;
                              id: PgBuildColumn<
                                  "product_quote",
                                  HasIdentity<SetIsPrimaryKey<(...)>, "byDefault">,
                                  {
                                      data: number;
                                      dataType: "number int32";
                                      driverParam: (...) | (...);
                                      enumValues: undefined;
                                      generated: undefined;
                                      hasDefault: true;
                                      hasRuntimeDefault: false;
                                      identity: "byDefault";
                                      isAutoincrement: false;
                                      isPrimaryKey: false;
                                      name: string;
                                      notNull: true;
                                      tableName: "product_quote";
                                  },
                              >;
                              idempotencyKey: PgBuildColumn<
                                  "product_quote",
                                  PgTextBuilder<[(...), ...(...)[]]>,
                                  {
                                      data: string;
                                      dataType: "string";
                                      driverParam: string;
                                      enumValues: undefined;
                                      generated: undefined;
                                      hasDefault: false;
                                      hasRuntimeDefault: false;
                                      identity: undefined;
                                      isAutoincrement: false;
                                      isPrimaryKey: false;
                                      name: string;
                                      notNull: false;
                                      tableName: "product_quote";
                                  },
                              >;
                              identityId: PgBuildColumn<
                                  "product_quote",
                                  PgIntegerBuilder,
                                  {
                                      data: number;
                                      dataType: "number int32";
                                      driverParam: (...)
                                      | (...);
                                      enumValues: undefined;
                                      generated: undefined;
                                      hasDefault: false;
                                      hasRuntimeDefault: false;
                                      identity: undefined;
                                      isAutoincrement: false;
                                      isPrimaryKey: false;
                                      name: string;
                                      notNull: false;
                                      tableName: "product_quote";
                                  },
                              >;
                              inputSourceAmount: PgBuildColumn<
                                  "product_quote",
                                  PgCustomColumnBuilder<{ data: ...; dataType: ...; driverParam: ... }>,
                                  {
                                      data: BigNumber;
                                      dataType: "custom";
                                      driverParam: string;
                                      enumValues: undefined;
                                      generated: undefined;
                                      hasDefault: false;
                                      hasRuntimeDefault: false;
                                      identity: undefined;
                                      isAutoincrement: false;
                                      isPrimaryKey: false;
                                      name: string;
                                      notNull: false;
                                      tableName: "product_quote";
                                  },
                              >;
                              inputTargetAmount: PgBuildColumn<
                                  "product_quote",
                                  PgCustomColumnBuilder<{ data: ...; dataType: ...; driverParam: ... }>,
                                  {
                                      data: BigNumber;
                                      dataType: "custom";
                                      driverParam: string;
                                      enumValues: undefined;
                                      generated: undefined;
                                      hasDefault: false;
                                      hasRuntimeDefault: false;
                                      identity: undefined;
                                      isAutoincrement: false;
                                      isPrimaryKey: false;
                                      name: string;
                                      notNull: false;
                                      tableName: "product_quote";
                                  },
                              >;
                              limitEvaluation: PgBuildColumn<
                                  "product_quote",
                                  Set$Type<PgJsonbBuilder, LimitEvaluation>,
                                  {
                                      data: LimitEvaluation;
                                      dataType: "object json";
                                      driverParam: unknown;
                                      enumValues: undefined;
                                      generated: undefined;
                                      hasDefault: false;
                                      hasRuntimeDefault: false;
                                      identity: undefined;
                                      isAutoincrement: false;
                                      isPrimaryKey: false;
                                      name: string;
                                      notNull: false;
                                      tableName: "product_quote";
                                  },
                              >;
                              limitRuleVersionId: PgBuildColumn<
                                  "product_quote",
                                  PgIntegerBuilder,
                                  {
                                      data: number;
                                      dataType: "number int32";
                                      driverParam: (...)
                                      | (...);
                                      enumValues: undefined;
                                      generated: undefined;
                                      hasDefault: false;
                                      hasRuntimeDefault: false;
                                      identity: undefined;
                                      isAutoincrement: false;
                                      isPrimaryKey: false;
                                      name: string;
                                      notNull: false;
                                      tableName: "product_quote";
                                  },
                              >;
                              minSettlementDate: PgBuildColumn<
                                  "product_quote",
                                  PgDateStringBuilder,
                                  {
                                      data: string;
                                      dataType: "string date";
                                      driverParam: string;
                                      enumValues: undefined;
                                      generated: undefined;
                                      hasDefault: false;
                                      hasRuntimeDefault: false;
                                      identity: undefined;
                                      isAutoincrement: false;
                                      isPrimaryKey: false;
                                      name: string;
                                      notNull: false;
                                      tableName: "product_quote";
                                  },
                              >;
                              organizationId: PgBuildColumn<
                                  "product_quote",
                                  PgIntegerBuilder,
                                  {
                                      data: number;
                                      dataType: "number int32";
                                      driverParam: (...)
                                      | (...);
                                      enumValues: undefined;
                                      generated: undefined;
                                      hasDefault: false;
                                      hasRuntimeDefault: false;
                                      identity: undefined;
                                      isAutoincrement: false;
                                      isPrimaryKey: false;
                                      name: string;
                                      notNull: false;
                                      tableName: "product_quote";
                                  },
                              >;
                              outcome: PgBuildColumn<
                                  "product_quote",
                                  Set$Type<SetNotNull<(...)>, (...) | (...) | (...) | (...)>,
                                  {
                                      data: (...) | (...) | (...) | (...);
                                      dataType: "string";
                                      driverParam: string;
                                      enumValues: undefined;
                                      generated: undefined;
                                      hasDefault: false;
                                      hasRuntimeDefault: false;
                                      identity: undefined;
                                      isAutoincrement: false;
                                      isPrimaryKey: false;
                                      name: string;
                                      notNull: true;
                                      tableName: "product_quote";
                                  },
                              >;
                              productId: PgBuildColumn<
                                  "product_quote",
                                  SetNotNull<PgIntegerBuilder>,
                                  {
                                      data: number;
                                      dataType: "number int32";
                                      driverParam: (...) | (...);
                                      enumValues: undefined;
                                      generated: undefined;
                                      hasDefault: false;
                                      hasRuntimeDefault: false;
                                      identity: undefined;
                                      isAutoincrement: false;
                                      isPrimaryKey: false;
                                      name: string;
                                      notNull: true;
                                      tableName: "product_quote";
                                  },
                              >;
                              providerFeeVisible: PgBuildColumn<
                                  "product_quote",
                                  PgBooleanBuilder,
                                  {
                                      data: boolean;
                                      dataType: "boolean";
                                      driverParam: boolean;
                                      enumValues: undefined;
                                      generated: undefined;
                                      hasDefault: false;
                                      hasRuntimeDefault: false;
                                      identity: undefined;
                                      isAutoincrement: false;
                                      isPrimaryKey: false;
                                      name: string;
                                      notNull: false;
                                      tableName: "product_quote";
                                  },
                              >;
                              providerFixedFeeAmount: PgBuildColumn<
                                  "product_quote",
                                  PgCustomColumnBuilder<{ data: ...; dataType: ...; driverParam: ... }>,
                                  {
                                      data: BigNumber;
                                      dataType: "custom";
                                      driverParam: string;
                                      enumValues: undefined;
                                      generated: undefined;
                                      hasDefault: false;
                                      hasRuntimeDefault: false;
                                      identity: undefined;
                                      isAutoincrement: false;
                                      isPrimaryKey: false;
                                      name: string;
                                      notNull: false;
                                      tableName: "product_quote";
                                  },
                              >;
                              providerVariableFeeAmount: PgBuildColumn<
                                  "product_quote",
                                  PgCustomColumnBuilder<{ data: ...; dataType: ...; driverParam: ... }>,
                                  {
                                      data: BigNumber;
                                      dataType: "custom";
                                      driverParam: string;
                                      enumValues: undefined;
                                      generated: undefined;
                                      hasDefault: false;
                                      hasRuntimeDefault: false;
                                      identity: undefined;
                                      isAutoincrement: false;
                                      isPrimaryKey: false;
                                      name: string;
                                      notNull: false;
                                      tableName: "product_quote";
                                  },
                              >;
                              providerVariableFeeBps: PgBuildColumn<
                                  "product_quote",
                                  PgCustomColumnBuilder<{ data: ...; dataType: ...; driverParam: ... }>,
                                  {
                                      data: BigNumber;
                                      dataType: "custom";
                                      driverParam: string;
                                      enumValues: undefined;
                                      generated: undefined;
                                      hasDefault: false;
                                      hasRuntimeDefault: false;
                                      identity: undefined;
                                      isAutoincrement: false;
                                      isPrimaryKey: false;
                                      name: string;
                                      notNull: false;
                                      tableName: "product_quote";
                                  },
                              >;
                              quantity: PgBuildColumn<
                                  "product_quote",
                                  SetHasDefault<SetNotNull<(...)>>,
                                  {
                                      data: number;
                                      dataType: "number int32";
                                      driverParam: (...) | (...);
                                      enumValues: undefined;
                                      generated: undefined;
                                      hasDefault: true;
                                      hasRuntimeDefault: false;
                                      identity: undefined;
                                      isAutoincrement: false;
                                      isPrimaryKey: false;
                                      name: string;
                                      notNull: true;
                                      tableName: "product_quote";
                                  },
                              >;
                              regionCode: PgBuildColumn<
                                  "product_quote",
                                  PgTextBuilder<[(...), ...(...)[]]>,
                                  {
                                      data: string;
                                      dataType: "string";
                                      driverParam: string;
                                      enumValues: undefined;
                                      generated: undefined;
                                      hasDefault: false;
                                      hasRuntimeDefault: false;
                                      identity: undefined;
                                      isAutoincrement: false;
                                      isPrimaryKey: false;
                                      name: string;
                                      notNull: false;
                                      tableName: "product_quote";
                                  },
                              >;
                              routeVersionId: PgBuildColumn<
                                  "product_quote",
                                  SetNotNull<PgIntegerBuilder>,
                                  {
                                      data: number;
                                      dataType: "number int32";
                                      driverParam: (...) | (...);
                                      enumValues: undefined;
                                      generated: undefined;
                                      hasDefault: false;
                                      hasRuntimeDefault: false;
                                      identity: undefined;
                                      isAutoincrement: false;
                                      isPrimaryKey: false;
                                      name: string;
                                      notNull: true;
                                      tableName: "product_quote";
                                  },
                              >;
                              sourceAmount: PgBuildColumn<
                                  "product_quote",
                                  PgCustomColumnBuilder<{ data: ...; dataType: ...; driverParam: ... }>,
                                  {
                                      data: BigNumber;
                                      dataType: "custom";
                                      driverParam: string;
                                      enumValues: undefined;
                                      generated: undefined;
                                      hasDefault: false;
                                      hasRuntimeDefault: false;
                                      identity: undefined;
                                      isAutoincrement: false;
                                      isPrimaryKey: false;
                                      name: string;
                                      notNull: false;
                                      tableName: "product_quote";
                                  },
                              >;
                              sourceCurrency: PgBuildColumn<
                                  "product_quote",
                                  PgTextBuilder<[(...), ...(...)[]]>,
                                  {
                                      data: string;
                                      dataType: "string";
                                      driverParam: string;
                                      enumValues: undefined;
                                      generated: undefined;
                                      hasDefault: false;
                                      hasRuntimeDefault: false;
                                      identity: undefined;
                                      isAutoincrement: false;
                                      isPrimaryKey: false;
                                      name: string;
                                      notNull: false;
                                      tableName: "product_quote";
                                  },
                              >;
                              speed: PgBuildColumn<
                                  "product_quote",
                                  Set$Type<PgTextBuilder<(...)>, Speed>,
                                  {
                                      data: Speed;
                                      dataType: "string";
                                      driverParam: string;
                                      enumValues: undefined;
                                      generated: undefined;
                                      hasDefault: false;
                                      hasRuntimeDefault: false;
                                      identity: undefined;
                                      isAutoincrement: false;
                                      isPrimaryKey: false;
                                      name: string;
                                      notNull: false;
                                      tableName: "product_quote";
                                  },
                              >;
                              targetAmountAfterFees: PgBuildColumn<
                                  "product_quote",
                                  PgCustomColumnBuilder<{ data: ...; dataType: ...; driverParam: ... }>,
                                  {
                                      data: BigNumber;
                                      dataType: "custom";
                                      driverParam: string;
                                      enumValues: undefined;
                                      generated: undefined;
                                      hasDefault: false;
                                      hasRuntimeDefault: false;
                                      identity: undefined;
                                      isAutoincrement: false;
                                      isPrimaryKey: false;
                                      name: string;
                                      notNull: false;
                                      tableName: "product_quote";
                                  },
                              >;
                              targetCurrency: PgBuildColumn<
                                  "product_quote",
                                  PgTextBuilder<[(...), ...(...)[]]>,
                                  {
                                      data: string;
                                      dataType: "string";
                                      driverParam: string;
                                      enumValues: undefined;
                                      generated: undefined;
                                      hasDefault: false;
                                      hasRuntimeDefault: false;
                                      identity: undefined;
                                      isAutoincrement: false;
                                      isPrimaryKey: false;
                                      name: string;
                                      notNull: false;
                                      tableName: "product_quote";
                                  },
                              >;
                              totalFees: PgBuildColumn<
                                  "product_quote",
                                  PgCustomColumnBuilder<{ data: ...; dataType: ...; driverParam: ... }>,
                                  {
                                      data: BigNumber;
                                      dataType: "custom";
                                      driverParam: string;
                                      enumValues: undefined;
                                      generated: undefined;
                                      hasDefault: false;
                                      hasRuntimeDefault: false;
                                      identity: undefined;
                                      isAutoincrement: false;
                                      isPrimaryKey: false;
                                      name: string;
                                      notNull: false;
                                      tableName: "product_quote";
                                  },
                              >;
                              vendorVersionId: PgBuildColumn<
                                  "product_quote",
                                  SetNotNull<PgIntegerBuilder>,
                                  {
                                      data: number;
                                      dataType: "number int32";
                                      driverParam: (...) | (...);
                                      enumValues: undefined;
                                      generated: undefined;
                                      hasDefault: false;
                                      hasRuntimeDefault: false;
                                      identity: undefined;
                                      isAutoincrement: false;
                                      isPrimaryKey: false;
                                      name: string;
                                      notNull: true;
                                      tableName: "product_quote";
                                  },
                              >;
                              violationLimit: PgBuildColumn<
                                  "product_quote",
                                  PgCustomColumnBuilder<{ data: ...; dataType: ...; driverParam: ... }>,
                                  {
                                      data: BigNumber;
                                      dataType: "custom";
                                      driverParam: string;
                                      enumValues: undefined;
                                      generated: undefined;
                                      hasDefault: false;
                                      hasRuntimeDefault: false;
                                      identity: undefined;
                                      isAutoincrement: false;
                                      isPrimaryKey: false;
                                      name: string;
                                      notNull: false;
                                      tableName: "product_quote";
                                  },
                              >;
                              violationType: PgBuildColumn<
                                  "product_quote",
                                  Set$Type<PgTextBuilder<(...)>, (...) | (...) | (...)>,
                                  {
                                      data: (...) | (...) | (...);
                                      dataType: "string";
                                      driverParam: string;
                                      enumValues: undefined;
                                      generated: undefined;
                                      hasDefault: false;
                                      hasRuntimeDefault: false;
                                      identity: undefined;
                                      isAutoincrement: false;
                                      isPrimaryKey: false;
                                      name: string;
                                      notNull: false;
                                      tableName: "product_quote";
                                  },
                              >;
                              violationUsage: PgBuildColumn<
                                  "product_quote",
                                  PgCustomColumnBuilder<{ data: ...; dataType: ...; driverParam: ... }>,
                                  {
                                      data: BigNumber;
                                      dataType: "custom";
                                      driverParam: string;
                                      enumValues: undefined;
                                      generated: undefined;
                                      hasDefault: false;
                                      hasRuntimeDefault: false;
                                      identity: undefined;
                                      isAutoincrement: false;
                                      isPrimaryKey: false;
                                      name: string;
                                      notNull: false;
                                      tableName: "product_quote";
                                  },
                              >;
                              violationWindow: PgBuildColumn<
                                  "product_quote",
                                  Set$Type<PgTextBuilder<(...)>, (...) | (...) | (...) | (...) | (...)>,
                                  {
                                      data: (...) | (...) | (...) | (...) | (...);
                                      dataType: "string";
                                      driverParam: string;
                                      enumValues: undefined;
                                      generated: undefined;
                                      hasDefault: false;
                                      hasRuntimeDefault: false;
                                      identity: undefined;
                                      isAutoincrement: false;
                                      isPrimaryKey: false;
                                      name: string;
                                      notNull: false;
                                      tableName: "product_quote";
                                  },
                              >;
                          };
                          dialect: "pg";
                          name: "product_quote";
                          schema: "b2b";
                      },
                  >,
                  "enableRLS",
              >,
              "sourceAmount"
              | "createdAt"
              | "totalFees"
              | "targetAmountAfterFees",
          >[]

          Direction-honoring sort over the audit row's own columns: the quote timestamp plus the three result amount columns (sourceAmount, targetAmountAfterFees, totalFees). Absent/empty falls back to createdAt DESC. A stable id tiebreak is always appended.

        • Optionaloutcomes?: ("INACTIVE" | "LIMIT_EXCEEDED" | "OK")[]
        • Optionalpage?: number
        • OptionalpageSize?: number
        • OptionalproductNames?: (
              | "organization.v1"
              | "identity.v1"
              | "card.physical_card.v1"
              | "card.virtual_card.v1"
              | "deposit.us_cash.v1"
              | "deposit.rtp.v1"
              | "deposit.us_bank_ach.v1"
              | "deposit.ach_credit.v1"
              | "deposit.us_wire.v1"
              | "deposit.swift_wire.v1"
              | "transfer.redemption.v1"
              | "swap.v1"
              | "withdraw.blockchain.v1"
              | "withdraw.ke_bank.v1"
              | "withdraw.ke_momo.v1"
              | "withdraw.mx_bank_spei.v1"
              | "withdraw.swift_wire.v1"
              | "withdraw.tg_momo.v1"
              | "withdraw.us_bank_ach.v1"
              | "withdraw.us_instant.v1"
              | "withdraw.us_wire.v1"
              | "withdraw.ach_pull.v1"
              | "withdraw.us_wire_drawdown.v1"
              | "account.virtual-account.v1"
              | "deposit.*"
              | "withdraw.*"
          )[]
        • Optionalq?: string

          Free-text filter: case-insensitive substring match on the quote's external id, the joined customer + product display names, and the outcome. total reflects the q-filtered set.

        • OptionalrouteIds?: string[]

      Returns Promise<
          {
              ok: true;
              value: { hasNext: boolean; items: AdminProductQuote[]; total: number };
          },
      >

    Settings
    Member Visibility

    On This Page
    Constructors
    Properties
    Methods