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

    Variable routeCriteriaUsageViewConst

    routeCriteriaUsageView: PgViewWithSelection<
        {
            existing: true;
            isAlias: false;
            name: "route_criteria_usage";
            schema: "b2b";
            selectedFields: {
                criteria: PgBuildColumn<
                    "route_criteria_usage",
                    Set$Type<
                        SetNotNull<PgJsonbBuilder>,
                        Required<
                            Pick<
                                Partial<
                                    {
                                        bankId: string;
                                        cashDepositRetailerId: string;
                                        countryCode: string;
                                        customerId: string;
                                        customerStatus: NonNullable<
                                            (...)
                                            | (...)
                                            | (...)
                                            | (...)
                                            | (...)
                                            | (...),
                                        >;
                                        dayOfWeek: number;
                                        entityStatus: NonNullable<
                                            (...)
                                            | (...)
                                            | (...)
                                            | (...)
                                            | (...)
                                            | (...)
                                            | (...)
                                            | (...),
                                        >;
                                        entityType: "IDENTITY" | "ORGANIZATION";
                                        hasIdentityDocument: boolean;
                                        identityId: string;
                                        ledgerAccountBalance: string;
                                        ledgerAccountId: string;
                                        organizationId: string;
                                        paymentInstrumentProviders: ((...) | (...))[];
                                        paymentInstrumentStatus: NonNullable<
                                            (...)
                                            | (...)
                                            | (...)
                                            | (...)
                                            | (...),
                                        >;
                                        placement: true;
                                        productId: string;
                                        programIds: string[];
                                        regionCode: string;
                                        sourceAmount: string;
                                        sourceChain: string;
                                        sourceCurrency: string;
                                        sourceWalletType: SourceWalletType;
                                        speed: Speed;
                                        systemInitiated: boolean;
                                        targetAmount: string;
                                        targetCurrency: string;
                                        timeOfDay: string;
                                        usage24hCount: string;
                                        usage24hUsd: string;
                                        usage30dCount: string;
                                        usage30dUsd: string;
                                        usage7dCount: string;
                                        usage7dUsd: string;
                                        usageCalendarMonthCount: string;
                                        usageCalendarMonthUsd: string;
                                        vendorId: Vendor;
                                        verificationByo: boolean;
                                        virtualAccountId: string;
                                        virtualAccountNumber: string;
                                        virtualAccountProvider: string;
                                        virtualAccountStatus: "PENDING" | "ACTIVE" | "FAILED" | "INACTIVE";
                                    },
                                >,
                                | "usage24hUsd"
                                | "usage24hCount"
                                | "usage7dUsd"
                                | "usage7dCount"
                                | "usage30dUsd"
                                | "usage30dCount"
                                | "usageCalendarMonthUsd"
                                | "usageCalendarMonthCount",
                            >,
                        >,
                    >,
                    {
                        data: TData;
                        dataType: "object json";
                        driverParam: unknown;
                        enumValues: undefined;
                        generated: undefined;
                        hasDefault: false;
                        hasRuntimeDefault: false;
                        identity: undefined;
                        isAutoincrement: false;
                        isPrimaryKey: false;
                        name: string;
                        notNull: true;
                        tableName: "route_criteria_usage";
                    },
                >;
                customerId: PgBuildColumn<
                    "route_criteria_usage",
                    SetNotNull<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: true;
                        tableName: "route_criteria_usage";
                    },
                >;
                entityId: PgBuildColumn<
                    "route_criteria_usage",
                    SetNotNull<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: true;
                        tableName: "route_criteria_usage";
                    },
                >;
                entityType: PgBuildColumn<
                    "route_criteria_usage",
                    Set$Type<
                        SetNotNull<PgTextBuilder<[string, ...string[]]>>,
                        NonNullable<"IDENTITY" | "ORGANIZATION" | undefined>,
                    >,
                    {
                        data: NonNullable;
                        dataType: "string";
                        driverParam: string;
                        enumValues: undefined;
                        generated: undefined;
                        hasDefault: false;
                        hasRuntimeDefault: false;
                        identity: undefined;
                        isAutoincrement: false;
                        isPrimaryKey: false;
                        name: string;
                        notNull: true;
                        tableName: "route_criteria_usage";
                    },
                >;
                productCategory: PgBuildColumn<
                    "route_criteria_usage",
                    Set$Type<PgTextBuilder<[string, ...string[]]>, ProductCategory>,
                    {
                        data: ProductCategory;
                        dataType: "string";
                        driverParam: string;
                        enumValues: undefined;
                        generated: undefined;
                        hasDefault: false;
                        hasRuntimeDefault: false;
                        identity: undefined;
                        isAutoincrement: false;
                        isPrimaryKey: false;
                        name: string;
                        notNull: false;
                        tableName: "route_criteria_usage";
                    },
                >;
                productId: PgBuildColumn<
                    "route_criteria_usage",
                    Set$Type<SetNotNull<PgTextBuilder<[string, ...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: true;
                        tableName: "route_criteria_usage";
                    },
                >;
                usage24hCount: PgBuildColumn<
                    "route_criteria_usage",
                    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: "route_criteria_usage";
                    },
                >;
                usage24hUsd: PgBuildColumn<
                    "route_criteria_usage",
                    SetNotNull<
                        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: true;
                        tableName: "route_criteria_usage";
                    },
                >;
                usage30dCount: PgBuildColumn<
                    "route_criteria_usage",
                    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: "route_criteria_usage";
                    },
                >;
                usage30dUsd: PgBuildColumn<
                    "route_criteria_usage",
                    SetNotNull<
                        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: true;
                        tableName: "route_criteria_usage";
                    },
                >;
                usage7dCount: PgBuildColumn<
                    "route_criteria_usage",
                    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: "route_criteria_usage";
                    },
                >;
                usage7dUsd: PgBuildColumn<
                    "route_criteria_usage",
                    SetNotNull<
                        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: true;
                        tableName: "route_criteria_usage";
                    },
                >;
                usageCalendarMonthCount: PgBuildColumn<
                    "route_criteria_usage",
                    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: "route_criteria_usage";
                    },
                >;
                usageCalendarMonthUsd: PgBuildColumn<
                    "route_criteria_usage",
                    SetNotNull<
                        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: true;
                        tableName: "route_criteria_usage";
                    },
                >;
            };
        },
    > = ...

    An entity's accepted, non-failed usage of each product, computed at read time: one row per (customer, entity, product), zeros for a product with no quotes. A category's usage is the sum of its products' rows.