Variable productVendorTable`Const`

productVendorTable: Omit<
    PgTableWithColumns<
        {
            columns: {
                bankId: PgColumn<
                    {
                        baseColumn: never;
                        columnType: "PgInteger";
                        data: number;
                        dataType: "number";
                        driverParam: string
                        | number;
                        enumValues: undefined;
                        generated: undefined;
                        hasDefault: false;
                        hasRuntimeDefault: false;
                        identity: undefined;
                        isAutoincrement: false;
                        isPrimaryKey: false;
                        name: "bankId";
                        notNull: false;
                        tableName: "product_vendor";
                    },
                    {},
                    {},
                >;
                createdAt: PgColumn<
                    {
                        baseColumn: never;
                        columnType: "PgCustomColumn";
                        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_vendor";
                    },
                    {},
                    { pgColumnBuilderBrand: "PgCustomColumnBuilderBrand" },
                >;
                deletedAt: PgColumn<
                    {
                        baseColumn: never;
                        columnType: "PgCustomColumn";
                        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_vendor";
                    },
                    {},
                    { pgColumnBuilderBrand: "PgCustomColumnBuilderBrand" },
                >;
                externalId: PgColumn<
                    {
                        baseColumn: never;
                        columnType: "PgText";
                        data: Vendor;
                        dataType: "string";
                        driverParam: string;
                        enumValues: [string, ...string[]];
                        generated: undefined;
                        hasDefault: false;
                        hasRuntimeDefault: false;
                        identity: undefined;
                        isAutoincrement: false;
                        isPrimaryKey: false;
                        name: "externalId";
                        notNull: true;
                        tableName: "product_vendor";
                    },
                    {},
                    { $type: Vendor },
                >;
                feeVisible: PgColumn<
                    {
                        baseColumn: never;
                        columnType: "PgBoolean";
                        data: boolean;
                        dataType: "boolean";
                        driverParam: boolean;
                        enumValues: undefined;
                        generated: undefined;
                        hasDefault: false;
                        hasRuntimeDefault: false;
                        identity: undefined;
                        isAutoincrement: false;
                        isPrimaryKey: false;
                        name: "feeVisible";
                        notNull: false;
                        tableName: "product_vendor";
                    },
                    {},
                    {},
                >;
                fixedFeeAmount: PgColumn<
                    {
                        baseColumn: never;
                        columnType: "PgCustomColumn";
                        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_vendor";
                    },
                    {},
                    { pgColumnBuilderBrand: "PgCustomColumnBuilderBrand" },
                >;
                id: PgColumn<
                    {
                        baseColumn: never;
                        columnType: "PgInteger";
                        data: number;
                        dataType: "number";
                        driverParam: string
                        | number;
                        enumValues: undefined;
                        generated: undefined;
                        hasDefault: true;
                        hasRuntimeDefault: false;
                        identity: "byDefault";
                        isAutoincrement: false;
                        isPrimaryKey: true;
                        name: "id";
                        notNull: true;
                        tableName: "product_vendor";
                    },
                    {},
                    {},
                >;
                limit24hMaxCount: PgColumn<
                    {
                        baseColumn: never;
                        columnType: "PgCustomColumn";
                        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_vendor";
                    },
                    {},
                    { pgColumnBuilderBrand: "PgCustomColumnBuilderBrand" },
                >;
                limit24hMaxUsd: PgColumn<
                    {
                        baseColumn: never;
                        columnType: "PgCustomColumn";
                        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_vendor";
                    },
                    {},
                    { pgColumnBuilderBrand: "PgCustomColumnBuilderBrand" },
                >;
                limit30dMaxCount: PgColumn<
                    {
                        baseColumn: never;
                        columnType: "PgCustomColumn";
                        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_vendor";
                    },
                    {},
                    { pgColumnBuilderBrand: "PgCustomColumnBuilderBrand" },
                >;
                limit30dMaxUsd: PgColumn<
                    {
                        baseColumn: never;
                        columnType: "PgCustomColumn";
                        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_vendor";
                    },
                    {},
                    { pgColumnBuilderBrand: "PgCustomColumnBuilderBrand" },
                >;
                limit7dMaxCount: PgColumn<
                    {
                        baseColumn: never;
                        columnType: "PgCustomColumn";
                        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_vendor";
                    },
                    {},
                    { pgColumnBuilderBrand: "PgCustomColumnBuilderBrand" },
                >;
                limit7dMaxUsd: PgColumn<
                    {
                        baseColumn: never;
                        columnType: "PgCustomColumn";
                        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_vendor";
                    },
                    {},
                    { pgColumnBuilderBrand: "PgCustomColumnBuilderBrand" },
                >;
                limitTransactionMaxUsd: PgColumn<
                    {
                        baseColumn: never;
                        columnType: "PgCustomColumn";
                        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_vendor";
                    },
                    {},
                    { pgColumnBuilderBrand: "PgCustomColumnBuilderBrand" },
                >;
                limitTransactionMinUsd: PgColumn<
                    {
                        baseColumn: never;
                        columnType: "PgCustomColumn";
                        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_vendor";
                    },
                    {},
                    { pgColumnBuilderBrand: "PgCustomColumnBuilderBrand" },
                >;
                name: PgColumn<
                    {
                        baseColumn: never;
                        columnType: "PgText";
                        data: string;
                        dataType: "string";
                        driverParam: string;
                        enumValues: [string, ...string[]];
                        generated: undefined;
                        hasDefault: false;
                        hasRuntimeDefault: false;
                        identity: undefined;
                        isAutoincrement: false;
                        isPrimaryKey: false;
                        name: "name";
                        notNull: true;
                        tableName: "product_vendor";
                    },
                    {},
                    {},
                >;
                updatedAt: PgColumn<
                    {
                        baseColumn: never;
                        columnType: "PgCustomColumn";
                        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_vendor";
                    },
                    {},
                    { pgColumnBuilderBrand: "PgCustomColumnBuilderBrand" },
                >;
                variableFeeBps: PgColumn<
                    {
                        baseColumn: never;
                        columnType: "PgCustomColumn";
                        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_vendor";
                    },
                    {},
                    { pgColumnBuilderBrand: "PgCustomColumnBuilderBrand" },
                >;
            };
            dialect: "pg";
            name: "product_vendor";
            schema: "b2b";
        },
    >,
    "enableRLS",
> = ...

Reference table for product-route vendors. externalId is the literal Vendor string — productRouteVersionTable.vendorId FKs into this table.

bankId is set for BankVendor rows (must equal the vendor's externalId lookup against b2b.bank) and null for NonBankVendor rows. The pairing is asserted in service code via vendorBankIdMismatch.

Carries the per-vendor deal terms — fees and limits — directly. Each vendor has ONE current set of fee/limit values; prior values are captured in productVendorVersionTable. This is shared across every route that pins this vendor (route versions only carry routing decisions: which vendor

matcher).

Variable productVendorTableConst

Settings

Variable productVendorTable`Const`