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

    Variable bankTransactionTableConst

    bankTransactionTable: Omit<
        PgTableWithColumns<
            {
                columns: {
                    accountNumber: PgBuildColumn<
                        "bank_transaction",
                        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_transaction";
                        },
                    >;
                    amount: PgBuildColumn<
                        "bank_transaction",
                        SetNotNull<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: true;
                            tableName: "bank_transaction";
                        },
                    >;
                    bankId: PgBuildColumn<
                        "bank_transaction",
                        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: "bank_transaction";
                        },
                    >;
                    bankStatus: PgBuildColumn<
                        "bank_transaction",
                        Set$Type<SetNotNull<PgTextBuilder<[string, ...string[]]>>, "POSTED">,
                        {
                            data: "POSTED";
                            dataType: "string";
                            driverParam: string;
                            enumValues: undefined;
                            generated: undefined;
                            hasDefault: false;
                            hasRuntimeDefault: false;
                            identity: undefined;
                            isAutoincrement: false;
                            isPrimaryKey: false;
                            name: string;
                            notNull: true;
                            tableName: "bank_transaction";
                        },
                    >;
                    bankTransactionId: PgBuildColumn<
                        "bank_transaction",
                        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_transaction";
                        },
                    >;
                    createdAt: PgBuildColumn<
                        "bank_transaction",
                        SetHasDefault<SetNotNull<PgTimestampBuilder>>,
                        {
                            data: Date;
                            dataType: "object date";
                            driverParam: string;
                            enumValues: undefined;
                            generated: undefined;
                            hasDefault: true;
                            hasRuntimeDefault: false;
                            identity: undefined;
                            isAutoincrement: false;
                            isPrimaryKey: false;
                            name: string;
                            notNull: true;
                            tableName: "bank_transaction";
                        },
                    >;
                    data: PgBuildColumn<
                        "bank_transaction",
                        Set$Type<
                            SetHasDefault<SetNotNull<PgJsonbBuilder>>,
                            {
                                isManual?: boolean;
                                methodData:
                                    | Record<string, never>
                                    | (
                                        { victorTransactionId?: string | undefined; victorReferenceId?: string | undefined; } & ({ method: "BOOK_TRANSFER"; } | { method: "ACH"; senderName?: string | undefined; achId?: string | undefined; achTraceId?: string | undefined; sourceRoutingNumber?: string | undefined; sourceBankName?: string | undefined; targetAccountName?: string | undefined; targetAccountNumber?: string | undefined; targetRoutingNumber?: string | undefined; targetBankName?: string | undefined; } | { method: "ACH_DEBIT"; senderName?: string | undefined; achId?: string | undefined; achTraceId?: string | undefined; sourceRoutingNumber?: string | undefined; sourceBankName?: string | undefined; targetRoutingNumber?: string | undefined; targetBankName?: string | undefined; } | { method: "RTP"; senderName?: string | undefined; tchInstitutionId?: string | undefined; } | { method: "SWIFT"; imad: string; omad?: string | undefined; senderName?: string | undefined; ffcMemo?: string | undefined; } | { method: "FEDWIRE"; imad: string; omad?: string | undefined; senderName?: string | undefined; sourceAccountNumber?: string | undefined; sourceRoutingNumber?: string | undefined; sourceBankName?: string | undefined; targetAccountName?: string | undefined; targetAccountNumber?: string | undefined; targetRoutingNumber?: string | undefined; targetBankName?: string | undefined; ffcMemo?: string | undefined; })
                                    );
                                reconciliation: Partial<
                                    Record<(...) | (...) | (...) | (...) | (...) | (...), string>,
                                > & Partial<Record<(...) | (...) | (...), (...)[]>>;
                            },
                        >,
                        {
                            data: {
                                isManual?: boolean;
                                methodData: | Record<string, never>
                                | (
                                    { victorTransactionId?: string | undefined; victorReferenceId?: string | undefined; } & ({ method: "BOOK_TRANSFER"; } | { method: "ACH"; senderName?: string | undefined; achId?: string | undefined; achTraceId?: string | undefined; sourceRoutingNumber?: string | undefined; sourceBankName?: string | undefined; targetAccountName?: string | undefined; targetAccountNumber?: string | undefined; targetRoutingNumber?: string | undefined; targetBankName?: string | undefined; } | { method: "ACH_DEBIT"; senderName?: string | undefined; achId?: string | undefined; achTraceId?: string | undefined; sourceRoutingNumber?: string | undefined; sourceBankName?: string | undefined; targetRoutingNumber?: string | undefined; targetBankName?: string | undefined; } | { method: "RTP"; senderName?: string | undefined; tchInstitutionId?: string | undefined; } | { method: "SWIFT"; imad: string; omad?: string | undefined; senderName?: string | undefined; ffcMemo?: string | undefined; } | { method: "FEDWIRE"; imad: string; omad?: string | undefined; senderName?: string | undefined; sourceAccountNumber?: string | undefined; sourceRoutingNumber?: string | undefined; sourceBankName?: string | undefined; targetAccountName?: string | undefined; targetAccountNumber?: string | undefined; targetRoutingNumber?: string | undefined; targetBankName?: string | undefined; ffcMemo?: string | undefined; })
                                );
                                reconciliation: Partial<
                                    Record<(...) | (...) | (...) | (...) | (...) | (...), string>,
                                > & Partial<Record<(...) | (...) | (...), (...)[]>>;
                            };
                            dataType: "object json";
                            driverParam: unknown;
                            enumValues: undefined;
                            generated: undefined;
                            hasDefault: true;
                            hasRuntimeDefault: false;
                            identity: undefined;
                            isAutoincrement: false;
                            isPrimaryKey: false;
                            name: string;
                            notNull: true;
                            tableName: "bank_transaction";
                        },
                    >;
                    description: PgBuildColumn<
                        "bank_transaction",
                        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_transaction";
                        },
                    >;
                    externalId: PgBuildColumn<
                        "bank_transaction",
                        SetHasRuntimeDefault<SetNotNull<PgTextBuilder<[string, ...string[]]>>>,
                        {
                            data: string;
                            dataType: "string";
                            driverParam: string;
                            enumValues: undefined;
                            generated: undefined;
                            hasDefault: true;
                            hasRuntimeDefault: false;
                            identity: undefined;
                            isAutoincrement: false;
                            isPrimaryKey: false;
                            name: string;
                            notNull: true;
                            tableName: "bank_transaction";
                        },
                    >;
                    id: PgBuildColumn<
                        "bank_transaction",
                        HasIdentity<SetIsPrimaryKey<PgIntegerBuilder>, "byDefault">,
                        {
                            data: number;
                            dataType: "number int32";
                            driverParam: string | number;
                            enumValues: undefined;
                            generated: undefined;
                            hasDefault: true;
                            hasRuntimeDefault: false;
                            identity: "byDefault";
                            isAutoincrement: false;
                            isPrimaryKey: false;
                            name: string;
                            notNull: true;
                            tableName: "bank_transaction";
                        },
                    >;
                    postedAt: PgBuildColumn<
                        "bank_transaction",
                        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: "bank_transaction";
                        },
                    >;
                    routingNumber: PgBuildColumn<
                        "bank_transaction",
                        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_transaction";
                        },
                    >;
                    statementDescription: PgBuildColumn<
                        "bank_transaction",
                        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_transaction";
                        },
                    >;
                    type: PgBuildColumn<
                        "bank_transaction",
                        Set$Type<
                            SetNotNull<PgTextBuilder<[string, ...string[]]>>,
                            "CREDIT" | "DEBIT",
                        >,
                        {
                            data: "CREDIT" | "DEBIT";
                            dataType: "string";
                            driverParam: string;
                            enumValues: undefined;
                            generated: undefined;
                            hasDefault: false;
                            hasRuntimeDefault: false;
                            identity: undefined;
                            isAutoincrement: false;
                            isPrimaryKey: false;
                            name: string;
                            notNull: true;
                            tableName: "bank_transaction";
                        },
                    >;
                    updatedAt: PgBuildColumn<
                        "bank_transaction",
                        SetHasDefault<SetHasDefault<SetNotNull<PgTimestampBuilder>>>,
                        {
                            data: Date;
                            dataType: "object date";
                            driverParam: string;
                            enumValues: undefined;
                            generated: undefined;
                            hasDefault: true;
                            hasRuntimeDefault: false;
                            identity: undefined;
                            isAutoincrement: false;
                            isPrimaryKey: false;
                            name: string;
                            notNull: true;
                            tableName: "bank_transaction";
                        },
                    >;
                };
                dialect: "pg";
                name: "bank_transaction";
                schema: "b2b";
            },
        >,
        "enableRLS",
    > = ...