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

    Variable productRouteEffectiveVersionViewConst

    productRouteEffectiveVersionView: PgViewWithSelection<
        {
            existing: true;
            isAlias: false;
            name: "product_route_effective_version";
            schema: "b2b";
            selectedFields: {
                bankAccountExternalId: PgBuildColumn<
                    "product_route_effective_version",
                    PgTextBuilder<[string, ...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_route_effective_version";
                    },
                >;
                bankAccountId: PgBuildColumn<
                    "product_route_effective_version",
                    PgIntegerBuilder,
                    {
                        data: number;
                        dataType: "number int32";
                        driverParam: string
                        | number;
                        enumValues: undefined;
                        generated: undefined;
                        hasDefault: false;
                        hasRuntimeDefault: false;
                        identity: undefined;
                        isAutoincrement: false;
                        isPrimaryKey: false;
                        name: string;
                        notNull: false;
                        tableName: "product_route_effective_version";
                    },
                >;
                data: PgBuildColumn<
                    "product_route_effective_version",
                    Set$Type<SetNotNull<PgJsonbBuilder>, ProductRouteVersionData>,
                    {
                        data: ProductRouteVersionData;
                        dataType: "object json";
                        driverParam: unknown;
                        enumValues: undefined;
                        generated: undefined;
                        hasDefault: false;
                        hasRuntimeDefault: false;
                        identity: undefined;
                        isAutoincrement: false;
                        isPrimaryKey: false;
                        name: string;
                        notNull: true;
                        tableName: "product_route_effective_version";
                    },
                >;
                effectiveFrom: PgBuildColumn<
                    "product_route_effective_version",
                    SetNotNull<
                        PgCustomColumnBuilder<
                            { data: Instant; dataType: "custom"; driverParam: string },
                        >,
                    >,
                    {
                        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_route_effective_version";
                    },
                >;
                feeVisible: PgBuildColumn<
                    "product_route_effective_version",
                    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_route_effective_version";
                    },
                >;
                fixedFeeAmount: PgBuildColumn<
                    "product_route_effective_version",
                    PgCustomColumnBuilder<
                        { data: BigNumber; dataType: "custom"; driverParam: string },
                    >,
                    {
                        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_route_effective_version";
                    },
                >;
                id: PgBuildColumn<
                    "product_route_effective_version",
                    SetNotNull<PgIntegerBuilder>,
                    {
                        data: number;
                        dataType: "number int32";
                        driverParam: string | number;
                        enumValues: undefined;
                        generated: undefined;
                        hasDefault: false;
                        hasRuntimeDefault: false;
                        identity: undefined;
                        isAutoincrement: false;
                        isPrimaryKey: false;
                        name: string;
                        notNull: true;
                        tableName: "product_route_effective_version";
                    },
                >;
                matcher: PgBuildColumn<
                    "product_route_effective_version",
                    SetNotNull<Set$Type<PgJsonbBuilder, Matcher>>,
                    {
                        data: Matcher;
                        dataType: "object json";
                        driverParam: unknown;
                        enumValues: undefined;
                        generated: undefined;
                        hasDefault: false;
                        hasRuntimeDefault: false;
                        identity: undefined;
                        isAutoincrement: false;
                        isPrimaryKey: false;
                        name: string;
                        notNull: true;
                        tableName: "product_route_effective_version";
                    },
                >;
                programExternalId: PgBuildColumn<
                    "product_route_effective_version",
                    PgTextBuilder<[string, ...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_route_effective_version";
                    },
                >;
                programId: PgBuildColumn<
                    "product_route_effective_version",
                    PgIntegerBuilder,
                    {
                        data: number;
                        dataType: "number int32";
                        driverParam: string
                        | number;
                        enumValues: undefined;
                        generated: undefined;
                        hasDefault: false;
                        hasRuntimeDefault: false;
                        identity: undefined;
                        isAutoincrement: false;
                        isPrimaryKey: false;
                        name: string;
                        notNull: false;
                        tableName: "product_route_effective_version";
                    },
                >;
                routeId: PgBuildColumn<
                    "product_route_effective_version",
                    SetNotNull<PgIntegerBuilder>,
                    {
                        data: number;
                        dataType: "number int32";
                        driverParam: string | number;
                        enumValues: undefined;
                        generated: undefined;
                        hasDefault: false;
                        hasRuntimeDefault: false;
                        identity: undefined;
                        isAutoincrement: false;
                        isPrimaryKey: false;
                        name: string;
                        notNull: true;
                        tableName: "product_route_effective_version";
                    },
                >;
                variableFeeBps: PgBuildColumn<
                    "product_route_effective_version",
                    PgCustomColumnBuilder<
                        { data: BigNumber; dataType: "custom"; driverParam: string },
                    >,
                    {
                        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_route_effective_version";
                    },
                >;
                vendorId: PgBuildColumn<
                    "product_route_effective_version",
                    SetNotNull<PgIntegerBuilder>,
                    {
                        data: number;
                        dataType: "number int32";
                        driverParam: string | number;
                        enumValues: undefined;
                        generated: undefined;
                        hasDefault: false;
                        hasRuntimeDefault: false;
                        identity: undefined;
                        isAutoincrement: false;
                        isPrimaryKey: false;
                        name: string;
                        notNull: true;
                        tableName: "product_route_effective_version";
                    },
                >;
            };
        },
    > = ...

    The live product_route_version per route: the newest whose effectiveFrom has passed, with its target account and program. SQL in 20261009120000_route_effective_version_target.sql.