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

    Variable bankInstructionAccountViewConst

    bankInstructionAccountView: PgViewWithSelection<
        {
            existing: false;
            isAlias: false;
            name: "bank_instruction_account";
            schema: "b2b";
            selectedFields: {
                accountNumber: PgBuildColumn<
                    "bank_instruction_account",
                    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: "bank_instruction_account";
                    },
                >;
                bankId: PgBuildColumn<
                    "bank_instruction_account",
                    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: "bank_instruction_account";
                    },
                >;
                bankName: PgBuildColumn<
                    "bank_instruction_account",
                    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: "bank_instruction_account";
                    },
                >;
                createdAt: PgBuildColumn<
                    "bank_instruction_account",
                    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: "bank_instruction_account";
                    },
                >;
                currency: PgBuildColumn<
                    "bank_instruction_account",
                    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: "bank_instruction_account";
                    },
                >;
                entryId: PgBuildColumn<
                    "bank_instruction_account",
                    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: "bank_instruction_account";
                    },
                >;
                name: PgBuildColumn<
                    "bank_instruction_account",
                    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: "bank_instruction_account";
                    },
                >;
                rail: PgBuildColumn<
                    "bank_instruction_account",
                    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: "bank_instruction_account";
                    },
                >;
                routingNumber: PgBuildColumn<
                    "bank_instruction_account",
                    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: "bank_instruction_account";
                    },
                >;
                updatedAt: PgBuildColumn<
                    "bank_instruction_account",
                    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: "bank_instruction_account";
                    },
                >;
            };
        },
    > = ...

    CFX's own accounts at each partner bank, unpacked from the four JSONB rail columns on bank into one row per (bank, rail, SWIFT entry).

    Not part of the bank_account_view contract, and deliberately named so it does not match the %_bank_account_view pattern the contract test enumerates. It exists because two consumers need exactly this set and must not disagree about it: bankInstructionBankAccountView projects it as the BANK_INSTRUCTION arm, and the OBSERVED arm anti-joins against it to decide which (routing_number, account_number) pairs in the feed belong to no registered account. Two copies of the unnest would drift, and a drifted copy shows up as phantom unregistered accounts.

    routing_number and account_number are both nullable here, and that is the point rather than an oversight — see bankAccountViewColumns's keyable. A named-deposit ACH bank has a routing number and no account number (AchInstructionData.accountNumber is optional, because the per-deposit or per-VA number is supplied at use time); a foreign SWIFT entry has an account number and no routing number (ForeignSwiftWireInstructionData carries the intermediary-bank trio instead).

    Settings
    Member Visibility