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

    Variable virtualAccountBankAccountViewConst

    virtualAccountBankAccountView: PgViewWithSelection<
        "virtual_account_bank_account_view",
        false,
        {
            accountNumber: PgBuildColumn<
                "virtual_account_bank_account_view",
                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: "virtual_account_bank_account_view";
                },
            >;
            bankId: PgBuildColumn<
                "virtual_account_bank_account_view",
                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: "virtual_account_bank_account_view";
                },
            >;
            bankName: PgBuildColumn<
                "virtual_account_bank_account_view",
                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: "virtual_account_bank_account_view";
                },
            >;
            createdAt: PgBuildColumn<
                "virtual_account_bank_account_view",
                SetNotNull<PgTimestampBuilder>,
                {
                    data: Date;
                    dataType: "object date";
                    driverParam: string;
                    enumValues: undefined;
                    generated: undefined;
                    hasDefault: false;
                    hasRuntimeDefault: false;
                    identity: undefined;
                    isAutoincrement: false;
                    isPrimaryKey: false;
                    name: string;
                    notNull: true;
                    tableName: "virtual_account_bank_account_view";
                },
            >;
            credits: PgBuildColumn<
                "virtual_account_bank_account_view",
                PgNumericBuilder,
                {
                    data: string;
                    dataType: "string numeric";
                    driverParam: string;
                    enumValues: undefined;
                    generated: undefined;
                    hasDefault: false;
                    hasRuntimeDefault: false;
                    identity: undefined;
                    isAutoincrement: false;
                    isPrimaryKey: false;
                    name: string;
                    notNull: false;
                    tableName: "virtual_account_bank_account_view";
                },
            >;
            creditsExInternal: PgBuildColumn<
                "virtual_account_bank_account_view",
                PgNumericBuilder,
                {
                    data: string;
                    dataType: "string numeric";
                    driverParam: string;
                    enumValues: undefined;
                    generated: undefined;
                    hasDefault: false;
                    hasRuntimeDefault: false;
                    identity: undefined;
                    isAutoincrement: false;
                    isPrimaryKey: false;
                    name: string;
                    notNull: false;
                    tableName: "virtual_account_bank_account_view";
                },
            >;
            currency: PgBuildColumn<
                "virtual_account_bank_account_view",
                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: "virtual_account_bank_account_view";
                },
            >;
            customerId: PgBuildColumn<
                "virtual_account_bank_account_view",
                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: "virtual_account_bank_account_view";
                },
            >;
            customerName: PgBuildColumn<
                "virtual_account_bank_account_view",
                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: "virtual_account_bank_account_view";
                },
            >;
            debits: PgBuildColumn<
                "virtual_account_bank_account_view",
                PgNumericBuilder,
                {
                    data: string;
                    dataType: "string numeric";
                    driverParam: string;
                    enumValues: undefined;
                    generated: undefined;
                    hasDefault: false;
                    hasRuntimeDefault: false;
                    identity: undefined;
                    isAutoincrement: false;
                    isPrimaryKey: false;
                    name: string;
                    notNull: false;
                    tableName: "virtual_account_bank_account_view";
                },
            >;
            debitsExInternal: PgBuildColumn<
                "virtual_account_bank_account_view",
                PgNumericBuilder,
                {
                    data: string;
                    dataType: "string numeric";
                    driverParam: string;
                    enumValues: undefined;
                    generated: undefined;
                    hasDefault: false;
                    hasRuntimeDefault: false;
                    identity: undefined;
                    isAutoincrement: false;
                    isPrimaryKey: false;
                    name: string;
                    notNull: false;
                    tableName: "virtual_account_bank_account_view";
                },
            >;
            deletedAt: PgBuildColumn<
                "virtual_account_bank_account_view",
                PgTimestampBuilder,
                {
                    data: Date;
                    dataType: "object date";
                    driverParam: string;
                    enumValues: undefined;
                    generated: undefined;
                    hasDefault: false;
                    hasRuntimeDefault: false;
                    identity: undefined;
                    isAutoincrement: false;
                    isPrimaryKey: false;
                    name: string;
                    notNull: false;
                    tableName: "virtual_account_bank_account_view";
                },
            >;
            entityId: PgBuildColumn<
                "virtual_account_bank_account_view",
                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: "virtual_account_bank_account_view";
                },
            >;
            entityName: PgBuildColumn<
                "virtual_account_bank_account_view",
                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: "virtual_account_bank_account_view";
                },
            >;
            entityType: PgBuildColumn<
                "virtual_account_bank_account_view",
                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: "virtual_account_bank_account_view";
                },
            >;
            firstPostedAt: PgBuildColumn<
                "virtual_account_bank_account_view",
                PgTimestampBuilder,
                {
                    data: Date;
                    dataType: "object date";
                    driverParam: string;
                    enumValues: undefined;
                    generated: undefined;
                    hasDefault: false;
                    hasRuntimeDefault: false;
                    identity: undefined;
                    isAutoincrement: false;
                    isPrimaryKey: false;
                    name: string;
                    notNull: false;
                    tableName: "virtual_account_bank_account_view";
                },
            >;
            id: PgBuildColumn<
                "virtual_account_bank_account_view",
                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: "virtual_account_bank_account_view";
                },
            >;
            impliedBalance: PgBuildColumn<
                "virtual_account_bank_account_view",
                PgNumericBuilder,
                {
                    data: string;
                    dataType: "string numeric";
                    driverParam: string;
                    enumValues: undefined;
                    generated: undefined;
                    hasDefault: false;
                    hasRuntimeDefault: false;
                    identity: undefined;
                    isAutoincrement: false;
                    isPrimaryKey: false;
                    name: string;
                    notNull: false;
                    tableName: "virtual_account_bank_account_view";
                },
            >;
            impliedBalanceExInternal: PgBuildColumn<
                "virtual_account_bank_account_view",
                PgNumericBuilder,
                {
                    data: string;
                    dataType: "string numeric";
                    driverParam: string;
                    enumValues: undefined;
                    generated: undefined;
                    hasDefault: false;
                    hasRuntimeDefault: false;
                    identity: undefined;
                    isAutoincrement: false;
                    isPrimaryKey: false;
                    name: string;
                    notNull: false;
                    tableName: "virtual_account_bank_account_view";
                },
            >;
            key: PgBuildColumn<
                "virtual_account_bank_account_view",
                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: "virtual_account_bank_account_view";
                },
            >;
            keyable: PgBuildColumn<
                "virtual_account_bank_account_view",
                SetNotNull<PgBooleanBuilder>,
                {
                    data: boolean;
                    dataType: "boolean";
                    driverParam: boolean;
                    enumValues: undefined;
                    generated: undefined;
                    hasDefault: false;
                    hasRuntimeDefault: false;
                    identity: undefined;
                    isAutoincrement: false;
                    isPrimaryKey: false;
                    name: string;
                    notNull: true;
                    tableName: "virtual_account_bank_account_view";
                },
            >;
            lastPostedAt: PgBuildColumn<
                "virtual_account_bank_account_view",
                PgTimestampBuilder,
                {
                    data: Date;
                    dataType: "object date";
                    driverParam: string;
                    enumValues: undefined;
                    generated: undefined;
                    hasDefault: false;
                    hasRuntimeDefault: false;
                    identity: undefined;
                    isAutoincrement: false;
                    isPrimaryKey: false;
                    name: string;
                    notNull: false;
                    tableName: "virtual_account_bank_account_view";
                },
            >;
            ledgerAccountId: PgBuildColumn<
                "virtual_account_bank_account_view",
                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: "virtual_account_bank_account_view";
                },
            >;
            memo: PgBuildColumn<
                "virtual_account_bank_account_view",
                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: "virtual_account_bank_account_view";
                },
            >;
            name: PgBuildColumn<
                "virtual_account_bank_account_view",
                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: "virtual_account_bank_account_view";
                },
            >;
            parentKey: PgBuildColumn<
                "virtual_account_bank_account_view",
                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: "virtual_account_bank_account_view";
                },
            >;
            provider: PgBuildColumn<
                "virtual_account_bank_account_view",
                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: "virtual_account_bank_account_view";
                },
            >;
            providerAccountId: PgBuildColumn<
                "virtual_account_bank_account_view",
                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: "virtual_account_bank_account_view";
                },
            >;
            routingNumber: PgBuildColumn<
                "virtual_account_bank_account_view",
                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: "virtual_account_bank_account_view";
                },
            >;
            source: PgBuildColumn<
                "virtual_account_bank_account_view",
                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: "virtual_account_bank_account_view";
                },
            >;
            sourceRecordId: PgBuildColumn<
                "virtual_account_bank_account_view",
                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: "virtual_account_bank_account_view";
                },
            >;
            status: PgBuildColumn<
                "virtual_account_bank_account_view",
                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: "virtual_account_bank_account_view";
                },
            >;
            transactionCount: PgBuildColumn<
                "virtual_account_bank_account_view",
                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: "virtual_account_bank_account_view";
                },
            >;
            type: PgBuildColumn<
                "virtual_account_bank_account_view",
                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: "virtual_account_bank_account_view";
                },
            >;
            updatedAt: PgBuildColumn<
                "virtual_account_bank_account_view",
                SetNotNull<PgTimestampBuilder>,
                {
                    data: Date;
                    dataType: "object date";
                    driverParam: string;
                    enumValues: undefined;
                    generated: undefined;
                    hasDefault: false;
                    hasRuntimeDefault: false;
                    identity: undefined;
                    isAutoincrement: false;
                    isPrimaryKey: false;
                    name: string;
                    notNull: true;
                    tableName: "virtual_account_bank_account_view";
                },
            >;
        },
    > = ...

    The VIRTUAL_ACCOUNT arm of bankAccountView — per-entity virtual accounts at Victor and RouteFusion, with balances implied from the bank_transaction feed.

    This arm carries one of the two hierarchy edges the schema actually proves. victor_account.victorLedgerProgramId is documented as "Only on FBO rows — backs the Victor ledger program for virtual accounts", and data.victorLedgerProgramId here is its counterpart, so the edge is asserted from both sides rather than inferred. It is guarded on data ->> 'provider' = 'VICTOR': a RouteFusion VA has no parent to point at — route_fusion_program carries a bankId and no account number, so there is no account for the edge to reach (§ 4.5).

    Only Victor-provider rows contribute to the feed at all. The Victor sync resolves each side of a transaction against victor_account ∪ Victor-provider virtual_account and discards the rest, so a ROUTE_FUSION-provider VA is keyable and correlates to zero rows — a true 0 / 0 / 0 with a transaction_count of 0, not a measurement failure.

    dbmate owns the DDL: the body below is mirrored by 20260814200000_bank_account_view.sql. securityInvoker is required — see victorAccountBankAccountView.

    Settings
    Member Visibility