Class VirtualAccountAdminQueryService

Index

Constructors

constructor

new VirtualAccountAdminQueryService(
    args: {
        db: B2bDatabase;
        productQuoteService: ProductQuoteService;
        walletAccountBalanceQueryService: WalletAccountBalanceQueryService;
    },
): VirtualAccountAdminQueryService
Parameters
- args: {
      db: B2bDatabase;
      productQuoteService: ProductQuoteService;
      walletAccountBalanceQueryService: WalletAccountBalanceQueryService;
  }
Returns VirtualAccountAdminQueryService
- Defined in packages/virtual-account-services/src/VirtualAccountAdminService.ts:88

Properties

`Static`instance

instance: (...args: []) => VirtualAccountAdminQueryService = ...

The process default: built from each dependency's own instance().

Methods

get

get(
args: { id: string },
): Promise<{ ok: true; value: VirtualAccountAdminSearchItem | null }>
Parameters
- args: { id: string }
Returns Promise<{ ok: true; value: VirtualAccountAdminSearchItem | null }>
- Defined in packages/virtual-account-services/src/VirtualAccountAdminService.ts:170

isProductActive

isProductActive(
    args: {
        customerId: string;
        entityId: string;
        ledgerAccountId: string;
        providerType: "VICTOR" | "BIVO" | "ROUTE_FUSION" | "ZENUS" | "MANUAL";
    },
): Promise<{ ok: true; value: void } | { error: ServiceError; ok: false }>
Resolves account.virtual-account.v1 activation for a specific entity (the ledger account's owning identity or organization). The route engine derives the customer's programIds from customerId and sourceWalletType from ledgerAccountId.

Pass providerType to signal creation/mutation intent — the matcher only enforces Dart-parity preconditions when virtualAccountProvider === "VICTOR" (see migration 20260418004128_virtual_account_victor_preconditions).
Parameters
- args: {
      customerId: string;
      entityId: string;
      ledgerAccountId: string;
      providerType: "VICTOR" | "BIVO" | "ROUTE_FUSION" | "ZENUS" | "MANUAL";
  }
Returns Promise<{ ok: true; value: void } | { error: ServiceError; ok: false }>
- Defined in packages/virtual-account-services/src/VirtualAccountAdminService.ts:109

search

search(
    args: {
        accountNumbers?: string[];
        bankIds?: string[];
        blockTime?: Date;
        createdAt?: DbTimestampCriteria;
        customerIds?: string[];
        entityIds?: string[];
        ids?: string[];
        includeDeleted?: boolean;
        ledgerAccountAddresses?: Address[];
        ledgerAccountIds?: string[];
        orderBy?: DbOrderByCriterion<
            Omit<
                PgTableWithColumns<
                    {
                        columns: {
                            accountNumber: PgBuildColumn<
                                "virtual_account",
                                SetNotNull<PgTextBuilder<(...)>>,
                                {
                                    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";
                                },
                            >;
                            bankAccountExternalId: PgBuildColumn<
                                "virtual_account",
                                PgTextBuilder<[(...), ...(...)[]]>,
                                {
                                    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";
                                },
                            >;
                            bankAccountId: PgBuildColumn<
                                "virtual_account",
                                PgIntegerBuilder,
                                {
                                    data: number;
                                    dataType: "number int32";
                                    driverParam: (...)
                                    | (...);
                                    enumValues: undefined;
                                    generated: undefined;
                                    hasDefault: false;
                                    hasRuntimeDefault: false;
                                    identity: undefined;
                                    isAutoincrement: false;
                                    isPrimaryKey: false;
                                    name: string;
                                    notNull: false;
                                    tableName: "virtual_account";
                                },
                            >;
                            bankExternalId: PgBuildColumn<
                                "virtual_account",
                                Set$Type<PgTextBuilder<(...)>, 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";
                                },
                            >;
                            bankId: PgBuildColumn<
                                "virtual_account",
                                PgIntegerBuilder,
                                {
                                    data: number;
                                    dataType: "number int32";
                                    driverParam: (...)
                                    | (...);
                                    enumValues: undefined;
                                    generated: undefined;
                                    hasDefault: false;
                                    hasRuntimeDefault: false;
                                    identity: undefined;
                                    isAutoincrement: false;
                                    isPrimaryKey: false;
                                    name: string;
                                    notNull: false;
                                    tableName: "virtual_account";
                                },
                            >;
                            beneficiaryAddress: PgBuildColumn<
                                "virtual_account",
                                Set$Type<PgJsonbBuilder, Address>,
                                {
                                    data: Address;
                                    dataType: "object json";
                                    driverParam: unknown;
                                    enumValues: undefined;
                                    generated: undefined;
                                    hasDefault: false;
                                    hasRuntimeDefault: false;
                                    identity: undefined;
                                    isAutoincrement: false;
                                    isPrimaryKey: false;
                                    name: string;
                                    notNull: false;
                                    tableName: "virtual_account";
                                },
                            >;
                            beneficiaryName: PgBuildColumn<
                                "virtual_account",
                                PgTextBuilder<[(...), ...(...)[]]>,
                                {
                                    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";
                                },
                            >;
                            createdAt: PgBuildColumn<
                                "virtual_account",
                                SetHasDefault<SetNotNull<(...)>>,
                                {
                                    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: "virtual_account";
                                },
                            >;
                            customerExternalId: PgBuildColumn<
                                "virtual_account",
                                SetNotNull<PgTextBuilder<(...)>>,
                                {
                                    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";
                                },
                            >;
                            customerId: PgBuildColumn<
                                "virtual_account",
                                SetNotNull<PgIntegerBuilder>,
                                {
                                    data: number;
                                    dataType: "number int32";
                                    driverParam: (...) | (...);
                                    enumValues: undefined;
                                    generated: undefined;
                                    hasDefault: false;
                                    hasRuntimeDefault: false;
                                    identity: undefined;
                                    isAutoincrement: false;
                                    isPrimaryKey: false;
                                    name: string;
                                    notNull: true;
                                    tableName: "virtual_account";
                                },
                            >;
                            data: PgBuildColumn<
                                "virtual_account",
                                Set$Type<PgJsonbBuilder, (...) | (...) | (...)>,
                                {
                                    data: (...) | (...) | (...);
                                    dataType: "object json";
                                    driverParam: unknown;
                                    enumValues: undefined;
                                    generated: undefined;
                                    hasDefault: false;
                                    hasRuntimeDefault: false;
                                    identity: undefined;
                                    isAutoincrement: false;
                                    isPrimaryKey: false;
                                    name: string;
                                    notNull: false;
                                    tableName: "virtual_account";
                                },
                            >;
                            deletedAt: PgBuildColumn<
                                "virtual_account",
                                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";
                                },
                            >;
                            depositReference: PgBuildColumn<
                                "virtual_account",
                                PgTextBuilder<[(...), ...(...)[]]>,
                                {
                                    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";
                                },
                            >;
                            externalId: PgBuildColumn<
                                "virtual_account",
                                SetHasRuntimeDefault<SetNotNull<(...)>>,
                                {
                                    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: "virtual_account";
                                },
                            >;
                            id: PgBuildColumn<
                                "virtual_account",
                                HasIdentity<SetIsPrimaryKey<(...)>, "byDefault">,
                                {
                                    data: number;
                                    dataType: "number int32";
                                    driverParam: (...) | (...);
                                    enumValues: undefined;
                                    generated: undefined;
                                    hasDefault: true;
                                    hasRuntimeDefault: false;
                                    identity: "byDefault";
                                    isAutoincrement: false;
                                    isPrimaryKey: false;
                                    name: string;
                                    notNull: true;
                                    tableName: "virtual_account";
                                },
                            >;
                            identityExternalId: PgBuildColumn<
                                "virtual_account",
                                PgTextBuilder<[(...), ...(...)[]]>,
                                {
                                    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";
                                },
                            >;
                            identityId: PgBuildColumn<
                                "virtual_account",
                                PgIntegerBuilder,
                                {
                                    data: number;
                                    dataType: "number int32";
                                    driverParam: (...)
                                    | (...);
                                    enumValues: undefined;
                                    generated: undefined;
                                    hasDefault: false;
                                    hasRuntimeDefault: false;
                                    identity: undefined;
                                    isAutoincrement: false;
                                    isPrimaryKey: false;
                                    name: string;
                                    notNull: false;
                                    tableName: "virtual_account";
                                },
                            >;
                            ledgerAccountExternalId: PgBuildColumn<
                                "virtual_account",
                                PgTextBuilder<[(...), ...(...)[]]>,
                                {
                                    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";
                                },
                            >;
                            ledgerAccountId: PgBuildColumn<
                                "virtual_account",
                                PgIntegerBuilder,
                                {
                                    data: number;
                                    dataType: "number int32";
                                    driverParam: (...)
                                    | (...);
                                    enumValues: undefined;
                                    generated: undefined;
                                    hasDefault: false;
                                    hasRuntimeDefault: false;
                                    identity: undefined;
                                    isAutoincrement: false;
                                    isPrimaryKey: false;
                                    name: string;
                                    notNull: false;
                                    tableName: "virtual_account";
                                },
                            >;
                            name: PgBuildColumn<
                                "virtual_account",
                                PgTextBuilder<[(...), ...(...)[]]>,
                                {
                                    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";
                                },
                            >;
                            organizationExternalId: PgBuildColumn<
                                "virtual_account",
                                PgTextBuilder<[(...), ...(...)[]]>,
                                {
                                    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";
                                },
                            >;
                            organizationId: PgBuildColumn<
                                "virtual_account",
                                PgIntegerBuilder,
                                {
                                    data: number;
                                    dataType: "number int32";
                                    driverParam: (...)
                                    | (...);
                                    enumValues: undefined;
                                    generated: undefined;
                                    hasDefault: false;
                                    hasRuntimeDefault: false;
                                    identity: undefined;
                                    isAutoincrement: false;
                                    isPrimaryKey: false;
                                    name: string;
                                    notNull: false;
                                    tableName: "virtual_account";
                                },
                            >;
                            productQuoteExternalId: PgBuildColumn<
                                "virtual_account",
                                PgTextBuilder<[(...), ...(...)[]]>,
                                {
                                    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";
                                },
                            >;
                            productQuoteId: PgBuildColumn<
                                "virtual_account",
                                PgIntegerBuilder,
                                {
                                    data: number;
                                    dataType: "number int32";
                                    driverParam: (...)
                                    | (...);
                                    enumValues: undefined;
                                    generated: undefined;
                                    hasDefault: false;
                                    hasRuntimeDefault: false;
                                    identity: undefined;
                                    isAutoincrement: false;
                                    isPrimaryKey: false;
                                    name: string;
                                    notNull: false;
                                    tableName: "virtual_account";
                                },
                            >;
                            programExternalId: PgBuildColumn<
                                "virtual_account",
                                PgTextBuilder<[(...), ...(...)[]]>,
                                {
                                    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";
                                },
                            >;
                            programId: PgBuildColumn<
                                "virtual_account",
                                PgIntegerBuilder,
                                {
                                    data: number;
                                    dataType: "number int32";
                                    driverParam: (...)
                                    | (...);
                                    enumValues: undefined;
                                    generated: undefined;
                                    hasDefault: false;
                                    hasRuntimeDefault: false;
                                    identity: undefined;
                                    isAutoincrement: false;
                                    isPrimaryKey: false;
                                    name: string;
                                    notNull: false;
                                    tableName: "virtual_account";
                                },
                            >;
                            provider: PgBuildColumn<
                                "virtual_account",
                                Set$Type<PgTextBuilder<(...)>, (...) | (...) | (...)>,
                                {
                                    data: (...) | (...) | (...);
                                    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";
                                },
                            >;
                            providerExternalId: PgBuildColumn<
                                "virtual_account",
                                SetNotNull<PgTextBuilder<(...)>>,
                                {
                                    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";
                                },
                            >;
                            providerId: PgBuildColumn<
                                "virtual_account",
                                SetNotNull<PgIntegerBuilder>,
                                {
                                    data: number;
                                    dataType: "number int32";
                                    driverParam: (...) | (...);
                                    enumValues: undefined;
                                    generated: undefined;
                                    hasDefault: false;
                                    hasRuntimeDefault: false;
                                    identity: undefined;
                                    isAutoincrement: false;
                                    isPrimaryKey: false;
                                    name: string;
                                    notNull: true;
                                    tableName: "virtual_account";
                                },
                            >;
                            referenceId: PgBuildColumn<
                                "virtual_account",
                                PgTextBuilder<[(...), ...(...)[]]>,
                                {
                                    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";
                                },
                            >;
                            routefusionWalletId: PgBuildColumn<
                                "virtual_account",
                                PgTextBuilder<[(...), ...(...)[]]>,
                                {
                                    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";
                                },
                            >;
                            routingNumber: PgBuildColumn<
                                "virtual_account",
                                SetNotNull<PgTextBuilder<(...)>>,
                                {
                                    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";
                                },
                            >;
                            searchDocument: PgBuildColumn<
                                "virtual_account",
                                SetHasGenerated<SetNotNull<(...)>>,
                                {
                                    data: string;
                                    dataType: "string";
                                    driverParam: string;
                                    enumValues: undefined;
                                    generated: true;
                                    hasDefault: true;
                                    hasRuntimeDefault: false;
                                    identity: undefined;
                                    isAutoincrement: false;
                                    isPrimaryKey: false;
                                    name: string;
                                    notNull: true;
                                    tableName: "virtual_account";
                                },
                            >;
                            searchDocumentAdmin: PgBuildColumn<
                                "virtual_account",
                                SetHasGenerated<SetNotNull<(...)>>,
                                {
                                    data: string;
                                    dataType: "string";
                                    driverParam: string;
                                    enumValues: undefined;
                                    generated: true;
                                    hasDefault: true;
                                    hasRuntimeDefault: false;
                                    identity: undefined;
                                    isAutoincrement: false;
                                    isPrimaryKey: false;
                                    name: string;
                                    notNull: true;
                                    tableName: "virtual_account";
                                },
                            >;
                            status: PgBuildColumn<
                                "virtual_account",
                                Set$Type<SetNotNull<(...)>, (...) | (...) | (...) | (...)>,
                                {
                                    data: (...) | (...) | (...) | (...);
                                    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";
                                },
                            >;
                            type: PgBuildColumn<
                                "virtual_account",
                                Set$Type<SetNotNull<(...)>, (...) | (...)>,
                                {
                                    data: (...) | (...);
                                    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";
                                },
                            >;
                            updatedAt: PgBuildColumn<
                                "virtual_account",
                                SetHasDefault<SetNotNull<(...)>>,
                                {
                                    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: "virtual_account";
                                },
                            >;
                        };
                        dialect: "pg";
                        isAlias: false;
                        name: "virtual_account";
                        schema: "b2b";
                    },
                >,
                "enableRLS",
            >,
            "createdAt"
            | "updatedAt",
        >[];
        page?: number;
        pageSize?: number;
        providerTypes?: ("VICTOR" | "BIVO" | "ROUTE_FUSION" | "ZENUS" | "MANUAL")[];
        q?: string;
        routeFusionEntityIds?: string[];
        routeFusionProgramIds?: string[];
        routeFusionWalletIds?: string[];
        statuses?: ("PENDING" | "ACTIVE" | "FAILED" | "INACTIVE")[];
        updatedAt?: DbTimestampCriteria;
    },
    __namedParameters?: StatementOptions,
): Promise<
    {
        ok: true;
        value: {
            hasNext: boolean;
            items: VirtualAccountAdminSearchItem[];
            total: number;
        };
    },
>
Parameters
- args: {
      accountNumbers?: string[];
      bankIds?: string[];
      blockTime?: Date;
      createdAt?: DbTimestampCriteria;
      customerIds?: string[];
      entityIds?: string[];
      ids?: string[];
      includeDeleted?: boolean;
      ledgerAccountAddresses?: Address[];
      ledgerAccountIds?: string[];
      orderBy?: DbOrderByCriterion<
          Omit<
              PgTableWithColumns<
                  {
                      columns: {
                          accountNumber: PgBuildColumn<
                              "virtual_account",
                              SetNotNull<PgTextBuilder<(...)>>,
                              {
                                  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";
                              },
                          >;
                          bankAccountExternalId: PgBuildColumn<
                              "virtual_account",
                              PgTextBuilder<[(...), ...(...)[]]>,
                              {
                                  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";
                              },
                          >;
                          bankAccountId: PgBuildColumn<
                              "virtual_account",
                              PgIntegerBuilder,
                              {
                                  data: number;
                                  dataType: "number int32";
                                  driverParam: (...)
                                  | (...);
                                  enumValues: undefined;
                                  generated: undefined;
                                  hasDefault: false;
                                  hasRuntimeDefault: false;
                                  identity: undefined;
                                  isAutoincrement: false;
                                  isPrimaryKey: false;
                                  name: string;
                                  notNull: false;
                                  tableName: "virtual_account";
                              },
                          >;
                          bankExternalId: PgBuildColumn<
                              "virtual_account",
                              Set$Type<PgTextBuilder<(...)>, 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";
                              },
                          >;
                          bankId: PgBuildColumn<
                              "virtual_account",
                              PgIntegerBuilder,
                              {
                                  data: number;
                                  dataType: "number int32";
                                  driverParam: (...)
                                  | (...);
                                  enumValues: undefined;
                                  generated: undefined;
                                  hasDefault: false;
                                  hasRuntimeDefault: false;
                                  identity: undefined;
                                  isAutoincrement: false;
                                  isPrimaryKey: false;
                                  name: string;
                                  notNull: false;
                                  tableName: "virtual_account";
                              },
                          >;
                          beneficiaryAddress: PgBuildColumn<
                              "virtual_account",
                              Set$Type<PgJsonbBuilder, Address>,
                              {
                                  data: Address;
                                  dataType: "object json";
                                  driverParam: unknown;
                                  enumValues: undefined;
                                  generated: undefined;
                                  hasDefault: false;
                                  hasRuntimeDefault: false;
                                  identity: undefined;
                                  isAutoincrement: false;
                                  isPrimaryKey: false;
                                  name: string;
                                  notNull: false;
                                  tableName: "virtual_account";
                              },
                          >;
                          beneficiaryName: PgBuildColumn<
                              "virtual_account",
                              PgTextBuilder<[(...), ...(...)[]]>,
                              {
                                  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";
                              },
                          >;
                          createdAt: PgBuildColumn<
                              "virtual_account",
                              SetHasDefault<SetNotNull<(...)>>,
                              {
                                  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: "virtual_account";
                              },
                          >;
                          customerExternalId: PgBuildColumn<
                              "virtual_account",
                              SetNotNull<PgTextBuilder<(...)>>,
                              {
                                  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";
                              },
                          >;
                          customerId: PgBuildColumn<
                              "virtual_account",
                              SetNotNull<PgIntegerBuilder>,
                              {
                                  data: number;
                                  dataType: "number int32";
                                  driverParam: (...) | (...);
                                  enumValues: undefined;
                                  generated: undefined;
                                  hasDefault: false;
                                  hasRuntimeDefault: false;
                                  identity: undefined;
                                  isAutoincrement: false;
                                  isPrimaryKey: false;
                                  name: string;
                                  notNull: true;
                                  tableName: "virtual_account";
                              },
                          >;
                          data: PgBuildColumn<
                              "virtual_account",
                              Set$Type<PgJsonbBuilder, (...) | (...) | (...)>,
                              {
                                  data: (...) | (...) | (...);
                                  dataType: "object json";
                                  driverParam: unknown;
                                  enumValues: undefined;
                                  generated: undefined;
                                  hasDefault: false;
                                  hasRuntimeDefault: false;
                                  identity: undefined;
                                  isAutoincrement: false;
                                  isPrimaryKey: false;
                                  name: string;
                                  notNull: false;
                                  tableName: "virtual_account";
                              },
                          >;
                          deletedAt: PgBuildColumn<
                              "virtual_account",
                              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";
                              },
                          >;
                          depositReference: PgBuildColumn<
                              "virtual_account",
                              PgTextBuilder<[(...), ...(...)[]]>,
                              {
                                  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";
                              },
                          >;
                          externalId: PgBuildColumn<
                              "virtual_account",
                              SetHasRuntimeDefault<SetNotNull<(...)>>,
                              {
                                  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: "virtual_account";
                              },
                          >;
                          id: PgBuildColumn<
                              "virtual_account",
                              HasIdentity<SetIsPrimaryKey<(...)>, "byDefault">,
                              {
                                  data: number;
                                  dataType: "number int32";
                                  driverParam: (...) | (...);
                                  enumValues: undefined;
                                  generated: undefined;
                                  hasDefault: true;
                                  hasRuntimeDefault: false;
                                  identity: "byDefault";
                                  isAutoincrement: false;
                                  isPrimaryKey: false;
                                  name: string;
                                  notNull: true;
                                  tableName: "virtual_account";
                              },
                          >;
                          identityExternalId: PgBuildColumn<
                              "virtual_account",
                              PgTextBuilder<[(...), ...(...)[]]>,
                              {
                                  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";
                              },
                          >;
                          identityId: PgBuildColumn<
                              "virtual_account",
                              PgIntegerBuilder,
                              {
                                  data: number;
                                  dataType: "number int32";
                                  driverParam: (...)
                                  | (...);
                                  enumValues: undefined;
                                  generated: undefined;
                                  hasDefault: false;
                                  hasRuntimeDefault: false;
                                  identity: undefined;
                                  isAutoincrement: false;
                                  isPrimaryKey: false;
                                  name: string;
                                  notNull: false;
                                  tableName: "virtual_account";
                              },
                          >;
                          ledgerAccountExternalId: PgBuildColumn<
                              "virtual_account",
                              PgTextBuilder<[(...), ...(...)[]]>,
                              {
                                  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";
                              },
                          >;
                          ledgerAccountId: PgBuildColumn<
                              "virtual_account",
                              PgIntegerBuilder,
                              {
                                  data: number;
                                  dataType: "number int32";
                                  driverParam: (...)
                                  | (...);
                                  enumValues: undefined;
                                  generated: undefined;
                                  hasDefault: false;
                                  hasRuntimeDefault: false;
                                  identity: undefined;
                                  isAutoincrement: false;
                                  isPrimaryKey: false;
                                  name: string;
                                  notNull: false;
                                  tableName: "virtual_account";
                              },
                          >;
                          name: PgBuildColumn<
                              "virtual_account",
                              PgTextBuilder<[(...), ...(...)[]]>,
                              {
                                  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";
                              },
                          >;
                          organizationExternalId: PgBuildColumn<
                              "virtual_account",
                              PgTextBuilder<[(...), ...(...)[]]>,
                              {
                                  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";
                              },
                          >;
                          organizationId: PgBuildColumn<
                              "virtual_account",
                              PgIntegerBuilder,
                              {
                                  data: number;
                                  dataType: "number int32";
                                  driverParam: (...)
                                  | (...);
                                  enumValues: undefined;
                                  generated: undefined;
                                  hasDefault: false;
                                  hasRuntimeDefault: false;
                                  identity: undefined;
                                  isAutoincrement: false;
                                  isPrimaryKey: false;
                                  name: string;
                                  notNull: false;
                                  tableName: "virtual_account";
                              },
                          >;
                          productQuoteExternalId: PgBuildColumn<
                              "virtual_account",
                              PgTextBuilder<[(...), ...(...)[]]>,
                              {
                                  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";
                              },
                          >;
                          productQuoteId: PgBuildColumn<
                              "virtual_account",
                              PgIntegerBuilder,
                              {
                                  data: number;
                                  dataType: "number int32";
                                  driverParam: (...)
                                  | (...);
                                  enumValues: undefined;
                                  generated: undefined;
                                  hasDefault: false;
                                  hasRuntimeDefault: false;
                                  identity: undefined;
                                  isAutoincrement: false;
                                  isPrimaryKey: false;
                                  name: string;
                                  notNull: false;
                                  tableName: "virtual_account";
                              },
                          >;
                          programExternalId: PgBuildColumn<
                              "virtual_account",
                              PgTextBuilder<[(...), ...(...)[]]>,
                              {
                                  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";
                              },
                          >;
                          programId: PgBuildColumn<
                              "virtual_account",
                              PgIntegerBuilder,
                              {
                                  data: number;
                                  dataType: "number int32";
                                  driverParam: (...)
                                  | (...);
                                  enumValues: undefined;
                                  generated: undefined;
                                  hasDefault: false;
                                  hasRuntimeDefault: false;
                                  identity: undefined;
                                  isAutoincrement: false;
                                  isPrimaryKey: false;
                                  name: string;
                                  notNull: false;
                                  tableName: "virtual_account";
                              },
                          >;
                          provider: PgBuildColumn<
                              "virtual_account",
                              Set$Type<PgTextBuilder<(...)>, (...) | (...) | (...)>,
                              {
                                  data: (...) | (...) | (...);
                                  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";
                              },
                          >;
                          providerExternalId: PgBuildColumn<
                              "virtual_account",
                              SetNotNull<PgTextBuilder<(...)>>,
                              {
                                  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";
                              },
                          >;
                          providerId: PgBuildColumn<
                              "virtual_account",
                              SetNotNull<PgIntegerBuilder>,
                              {
                                  data: number;
                                  dataType: "number int32";
                                  driverParam: (...) | (...);
                                  enumValues: undefined;
                                  generated: undefined;
                                  hasDefault: false;
                                  hasRuntimeDefault: false;
                                  identity: undefined;
                                  isAutoincrement: false;
                                  isPrimaryKey: false;
                                  name: string;
                                  notNull: true;
                                  tableName: "virtual_account";
                              },
                          >;
                          referenceId: PgBuildColumn<
                              "virtual_account",
                              PgTextBuilder<[(...), ...(...)[]]>,
                              {
                                  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";
                              },
                          >;
                          routefusionWalletId: PgBuildColumn<
                              "virtual_account",
                              PgTextBuilder<[(...), ...(...)[]]>,
                              {
                                  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";
                              },
                          >;
                          routingNumber: PgBuildColumn<
                              "virtual_account",
                              SetNotNull<PgTextBuilder<(...)>>,
                              {
                                  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";
                              },
                          >;
                          searchDocument: PgBuildColumn<
                              "virtual_account",
                              SetHasGenerated<SetNotNull<(...)>>,
                              {
                                  data: string;
                                  dataType: "string";
                                  driverParam: string;
                                  enumValues: undefined;
                                  generated: true;
                                  hasDefault: true;
                                  hasRuntimeDefault: false;
                                  identity: undefined;
                                  isAutoincrement: false;
                                  isPrimaryKey: false;
                                  name: string;
                                  notNull: true;
                                  tableName: "virtual_account";
                              },
                          >;
                          searchDocumentAdmin: PgBuildColumn<
                              "virtual_account",
                              SetHasGenerated<SetNotNull<(...)>>,
                              {
                                  data: string;
                                  dataType: "string";
                                  driverParam: string;
                                  enumValues: undefined;
                                  generated: true;
                                  hasDefault: true;
                                  hasRuntimeDefault: false;
                                  identity: undefined;
                                  isAutoincrement: false;
                                  isPrimaryKey: false;
                                  name: string;
                                  notNull: true;
                                  tableName: "virtual_account";
                              },
                          >;
                          status: PgBuildColumn<
                              "virtual_account",
                              Set$Type<SetNotNull<(...)>, (...) | (...) | (...) | (...)>,
                              {
                                  data: (...) | (...) | (...) | (...);
                                  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";
                              },
                          >;
                          type: PgBuildColumn<
                              "virtual_account",
                              Set$Type<SetNotNull<(...)>, (...) | (...)>,
                              {
                                  data: (...) | (...);
                                  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";
                              },
                          >;
                          updatedAt: PgBuildColumn<
                              "virtual_account",
                              SetHasDefault<SetNotNull<(...)>>,
                              {
                                  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: "virtual_account";
                              },
                          >;
                      };
                      dialect: "pg";
                      isAlias: false;
                      name: "virtual_account";
                      schema: "b2b";
                  },
              >,
              "enableRLS",
          >,
          "createdAt"
          | "updatedAt",
      >[];
      page?: number;
      pageSize?: number;
      providerTypes?: ("VICTOR" | "BIVO" | "ROUTE_FUSION" | "ZENUS" | "MANUAL")[];
      q?: string;
      routeFusionEntityIds?: string[];
      routeFusionProgramIds?: string[];
      routeFusionWalletIds?: string[];
      statuses?: ("PENDING" | "ACTIVE" | "FAILED" | "INACTIVE")[];
      updatedAt?: DbTimestampCriteria;
  }
  - OptionalaccountNumbers?: string[]
  - OptionalbankIds?: string[]
    
    Filter by the linked bank's externalId.
  - OptionalblockTime?: Date
    
    Snapshot point for the balance lookup. Defaults to the latest known balance.
  - OptionalcreatedAt?: DbTimestampCriteria
  - OptionalcustomerIds?: string[]
    
    Filter by the owning customer's externalId.
  - OptionalentityIds?: string[]
    
    Filter by the owning entity (identity or organization) externalId.
  - Optionalids?: string[]
  - OptionalincludeDeleted?: boolean
    
    Defaults to false — deleted rows are hidden unless explicitly included.
  - OptionalledgerAccountAddresses?: Address[]
  - OptionalledgerAccountIds?: string[]
  - OptionalorderBy?: DbOrderByCriterion<
        Omit<
            PgTableWithColumns<
                {
                    columns: {
                        accountNumber: PgBuildColumn<
                            "virtual_account",
                            SetNotNull<PgTextBuilder<(...)>>,
                            {
                                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";
                            },
                        >;
                        bankAccountExternalId: PgBuildColumn<
                            "virtual_account",
                            PgTextBuilder<[(...), ...(...)[]]>,
                            {
                                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";
                            },
                        >;
                        bankAccountId: PgBuildColumn<
                            "virtual_account",
                            PgIntegerBuilder,
                            {
                                data: number;
                                dataType: "number int32";
                                driverParam: (...)
                                | (...);
                                enumValues: undefined;
                                generated: undefined;
                                hasDefault: false;
                                hasRuntimeDefault: false;
                                identity: undefined;
                                isAutoincrement: false;
                                isPrimaryKey: false;
                                name: string;
                                notNull: false;
                                tableName: "virtual_account";
                            },
                        >;
                        bankExternalId: PgBuildColumn<
                            "virtual_account",
                            Set$Type<PgTextBuilder<(...)>, 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";
                            },
                        >;
                        bankId: PgBuildColumn<
                            "virtual_account",
                            PgIntegerBuilder,
                            {
                                data: number;
                                dataType: "number int32";
                                driverParam: (...)
                                | (...);
                                enumValues: undefined;
                                generated: undefined;
                                hasDefault: false;
                                hasRuntimeDefault: false;
                                identity: undefined;
                                isAutoincrement: false;
                                isPrimaryKey: false;
                                name: string;
                                notNull: false;
                                tableName: "virtual_account";
                            },
                        >;
                        beneficiaryAddress: PgBuildColumn<
                            "virtual_account",
                            Set$Type<PgJsonbBuilder, Address>,
                            {
                                data: Address;
                                dataType: "object json";
                                driverParam: unknown;
                                enumValues: undefined;
                                generated: undefined;
                                hasDefault: false;
                                hasRuntimeDefault: false;
                                identity: undefined;
                                isAutoincrement: false;
                                isPrimaryKey: false;
                                name: string;
                                notNull: false;
                                tableName: "virtual_account";
                            },
                        >;
                        beneficiaryName: PgBuildColumn<
                            "virtual_account",
                            PgTextBuilder<[(...), ...(...)[]]>,
                            {
                                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";
                            },
                        >;
                        createdAt: PgBuildColumn<
                            "virtual_account",
                            SetHasDefault<SetNotNull<(...)>>,
                            {
                                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: "virtual_account";
                            },
                        >;
                        customerExternalId: PgBuildColumn<
                            "virtual_account",
                            SetNotNull<PgTextBuilder<(...)>>,
                            {
                                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";
                            },
                        >;
                        customerId: PgBuildColumn<
                            "virtual_account",
                            SetNotNull<PgIntegerBuilder>,
                            {
                                data: number;
                                dataType: "number int32";
                                driverParam: (...) | (...);
                                enumValues: undefined;
                                generated: undefined;
                                hasDefault: false;
                                hasRuntimeDefault: false;
                                identity: undefined;
                                isAutoincrement: false;
                                isPrimaryKey: false;
                                name: string;
                                notNull: true;
                                tableName: "virtual_account";
                            },
                        >;
                        data: PgBuildColumn<
                            "virtual_account",
                            Set$Type<PgJsonbBuilder, (...) | (...) | (...)>,
                            {
                                data: (...) | (...) | (...);
                                dataType: "object json";
                                driverParam: unknown;
                                enumValues: undefined;
                                generated: undefined;
                                hasDefault: false;
                                hasRuntimeDefault: false;
                                identity: undefined;
                                isAutoincrement: false;
                                isPrimaryKey: false;
                                name: string;
                                notNull: false;
                                tableName: "virtual_account";
                            },
                        >;
                        deletedAt: PgBuildColumn<
                            "virtual_account",
                            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";
                            },
                        >;
                        depositReference: PgBuildColumn<
                            "virtual_account",
                            PgTextBuilder<[(...), ...(...)[]]>,
                            {
                                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";
                            },
                        >;
                        externalId: PgBuildColumn<
                            "virtual_account",
                            SetHasRuntimeDefault<SetNotNull<(...)>>,
                            {
                                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: "virtual_account";
                            },
                        >;
                        id: PgBuildColumn<
                            "virtual_account",
                            HasIdentity<SetIsPrimaryKey<(...)>, "byDefault">,
                            {
                                data: number;
                                dataType: "number int32";
                                driverParam: (...) | (...);
                                enumValues: undefined;
                                generated: undefined;
                                hasDefault: true;
                                hasRuntimeDefault: false;
                                identity: "byDefault";
                                isAutoincrement: false;
                                isPrimaryKey: false;
                                name: string;
                                notNull: true;
                                tableName: "virtual_account";
                            },
                        >;
                        identityExternalId: PgBuildColumn<
                            "virtual_account",
                            PgTextBuilder<[(...), ...(...)[]]>,
                            {
                                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";
                            },
                        >;
                        identityId: PgBuildColumn<
                            "virtual_account",
                            PgIntegerBuilder,
                            {
                                data: number;
                                dataType: "number int32";
                                driverParam: (...)
                                | (...);
                                enumValues: undefined;
                                generated: undefined;
                                hasDefault: false;
                                hasRuntimeDefault: false;
                                identity: undefined;
                                isAutoincrement: false;
                                isPrimaryKey: false;
                                name: string;
                                notNull: false;
                                tableName: "virtual_account";
                            },
                        >;
                        ledgerAccountExternalId: PgBuildColumn<
                            "virtual_account",
                            PgTextBuilder<[(...), ...(...)[]]>,
                            {
                                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";
                            },
                        >;
                        ledgerAccountId: PgBuildColumn<
                            "virtual_account",
                            PgIntegerBuilder,
                            {
                                data: number;
                                dataType: "number int32";
                                driverParam: (...)
                                | (...);
                                enumValues: undefined;
                                generated: undefined;
                                hasDefault: false;
                                hasRuntimeDefault: false;
                                identity: undefined;
                                isAutoincrement: false;
                                isPrimaryKey: false;
                                name: string;
                                notNull: false;
                                tableName: "virtual_account";
                            },
                        >;
                        name: PgBuildColumn<
                            "virtual_account",
                            PgTextBuilder<[(...), ...(...)[]]>,
                            {
                                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";
                            },
                        >;
                        organizationExternalId: PgBuildColumn<
                            "virtual_account",
                            PgTextBuilder<[(...), ...(...)[]]>,
                            {
                                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";
                            },
                        >;
                        organizationId: PgBuildColumn<
                            "virtual_account",
                            PgIntegerBuilder,
                            {
                                data: number;
                                dataType: "number int32";
                                driverParam: (...)
                                | (...);
                                enumValues: undefined;
                                generated: undefined;
                                hasDefault: false;
                                hasRuntimeDefault: false;
                                identity: undefined;
                                isAutoincrement: false;
                                isPrimaryKey: false;
                                name: string;
                                notNull: false;
                                tableName: "virtual_account";
                            },
                        >;
                        productQuoteExternalId: PgBuildColumn<
                            "virtual_account",
                            PgTextBuilder<[(...), ...(...)[]]>,
                            {
                                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";
                            },
                        >;
                        productQuoteId: PgBuildColumn<
                            "virtual_account",
                            PgIntegerBuilder,
                            {
                                data: number;
                                dataType: "number int32";
                                driverParam: (...)
                                | (...);
                                enumValues: undefined;
                                generated: undefined;
                                hasDefault: false;
                                hasRuntimeDefault: false;
                                identity: undefined;
                                isAutoincrement: false;
                                isPrimaryKey: false;
                                name: string;
                                notNull: false;
                                tableName: "virtual_account";
                            },
                        >;
                        programExternalId: PgBuildColumn<
                            "virtual_account",
                            PgTextBuilder<[(...), ...(...)[]]>,
                            {
                                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";
                            },
                        >;
                        programId: PgBuildColumn<
                            "virtual_account",
                            PgIntegerBuilder,
                            {
                                data: number;
                                dataType: "number int32";
                                driverParam: (...)
                                | (...);
                                enumValues: undefined;
                                generated: undefined;
                                hasDefault: false;
                                hasRuntimeDefault: false;
                                identity: undefined;
                                isAutoincrement: false;
                                isPrimaryKey: false;
                                name: string;
                                notNull: false;
                                tableName: "virtual_account";
                            },
                        >;
                        provider: PgBuildColumn<
                            "virtual_account",
                            Set$Type<PgTextBuilder<(...)>, (...) | (...) | (...)>,
                            {
                                data: (...) | (...) | (...);
                                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";
                            },
                        >;
                        providerExternalId: PgBuildColumn<
                            "virtual_account",
                            SetNotNull<PgTextBuilder<(...)>>,
                            {
                                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";
                            },
                        >;
                        providerId: PgBuildColumn<
                            "virtual_account",
                            SetNotNull<PgIntegerBuilder>,
                            {
                                data: number;
                                dataType: "number int32";
                                driverParam: (...) | (...);
                                enumValues: undefined;
                                generated: undefined;
                                hasDefault: false;
                                hasRuntimeDefault: false;
                                identity: undefined;
                                isAutoincrement: false;
                                isPrimaryKey: false;
                                name: string;
                                notNull: true;
                                tableName: "virtual_account";
                            },
                        >;
                        referenceId: PgBuildColumn<
                            "virtual_account",
                            PgTextBuilder<[(...), ...(...)[]]>,
                            {
                                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";
                            },
                        >;
                        routefusionWalletId: PgBuildColumn<
                            "virtual_account",
                            PgTextBuilder<[(...), ...(...)[]]>,
                            {
                                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";
                            },
                        >;
                        routingNumber: PgBuildColumn<
                            "virtual_account",
                            SetNotNull<PgTextBuilder<(...)>>,
                            {
                                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";
                            },
                        >;
                        searchDocument: PgBuildColumn<
                            "virtual_account",
                            SetHasGenerated<SetNotNull<(...)>>,
                            {
                                data: string;
                                dataType: "string";
                                driverParam: string;
                                enumValues: undefined;
                                generated: true;
                                hasDefault: true;
                                hasRuntimeDefault: false;
                                identity: undefined;
                                isAutoincrement: false;
                                isPrimaryKey: false;
                                name: string;
                                notNull: true;
                                tableName: "virtual_account";
                            },
                        >;
                        searchDocumentAdmin: PgBuildColumn<
                            "virtual_account",
                            SetHasGenerated<SetNotNull<(...)>>,
                            {
                                data: string;
                                dataType: "string";
                                driverParam: string;
                                enumValues: undefined;
                                generated: true;
                                hasDefault: true;
                                hasRuntimeDefault: false;
                                identity: undefined;
                                isAutoincrement: false;
                                isPrimaryKey: false;
                                name: string;
                                notNull: true;
                                tableName: "virtual_account";
                            },
                        >;
                        status: PgBuildColumn<
                            "virtual_account",
                            Set$Type<SetNotNull<(...)>, (...) | (...) | (...) | (...)>,
                            {
                                data: (...) | (...) | (...) | (...);
                                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";
                            },
                        >;
                        type: PgBuildColumn<
                            "virtual_account",
                            Set$Type<SetNotNull<(...)>, (...) | (...)>,
                            {
                                data: (...) | (...);
                                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";
                            },
                        >;
                        updatedAt: PgBuildColumn<
                            "virtual_account",
                            SetHasDefault<SetNotNull<(...)>>,
                            {
                                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: "virtual_account";
                            },
                        >;
                    };
                    dialect: "pg";
                    isAlias: false;
                    name: "virtual_account";
                    schema: "b2b";
                },
            >,
            "enableRLS",
        >,
        "createdAt"
        | "updatedAt",
    >[]
    
    Defaults to createdAt DESC when omitted.
  - Optionalpage?: number
    
    Defaults to 1.
  - OptionalpageSize?: number
    
    Rows per page, default 50 (clamped to 200). Results are always paginated. total is the full match count regardless of pageSize, so pageSize: 1 counts matches cheaply without materializing every row.
  - OptionalproviderTypes?: ("VICTOR" | "BIVO" | "ROUTE_FUSION" | "ZENUS" | "MANUAL")[]
  - Optionalq?: string
    
    Case-insensitive substring match on account name or account number. Whitespace-only values are a no-op.
  - OptionalrouteFusionEntityIds?: string[]
    
    Matches the RouteFusion entity id stored on data->>'entityId'.
  - OptionalrouteFusionProgramIds?: string[]
    
    Matches the RouteFusion program id stored on data->>'programId'. NOT index-backed — this seq-scans virtual_account.
  - OptionalrouteFusionWalletIds?: string[]
    
    Matches the routefusion_wallet_id column, served by the partial index virtual_account_routefusion_wallet_id_idx.
  - Optionalstatuses?: ("PENDING" | "ACTIVE" | "FAILED" | "INACTIVE")[]
  - OptionalupdatedAt?: DbTimestampCriteria
- __namedParameters: StatementOptions = {}
Returns Promise<
    {
        ok: true;
        value: {
            hasNext: boolean;
            items: VirtualAccountAdminSearchItem[];
            total: number;
        };
    },
>
- Defined in packages/virtual-account-services/src/VirtualAccountAdminService.ts:185

Class VirtualAccountAdminQueryService

Index

Constructors

Properties

Methods

Constructors

constructor

Parameters

Returns VirtualAccountAdminQueryService

Properties

Staticinstance

Methods

get

Parameters

Returns Promise<{ ok: true; value: VirtualAccountAdminSearchItem | null }>

isProductActive

Parameters

Returns Promise<{ ok: true; value: void } | { error: ServiceError; ok: false }>

search

Parameters

OptionalaccountNumbers?: string[]

OptionalbankIds?: string[]

OptionalblockTime?: Date

OptionalcreatedAt?: DbTimestampCriteria

OptionalcustomerIds?: string[]

OptionalentityIds?: string[]

Optionalids?: string[]

OptionalincludeDeleted?: boolean

OptionalledgerAccountAddresses?: Address[]

OptionalledgerAccountIds?: string[]

Optionalpage?: number

OptionalpageSize?: number

OptionalproviderTypes?: ("VICTOR" | "BIVO" | "ROUTE_FUSION" | "ZENUS" | "MANUAL")[]

Optionalq?: string

OptionalrouteFusionEntityIds?: string[]

OptionalrouteFusionProgramIds?: string[]

OptionalrouteFusionWalletIds?: string[]

Optionalstatuses?: ("PENDING" | "ACTIVE" | "FAILED" | "INACTIVE")[]

OptionalupdatedAt?: DbTimestampCriteria

Returns Promise< { ok: true; value: { hasNext: boolean; items: VirtualAccountAdminSearchItem[]; total: number; }; },>

Settings

On This Page

`Static`instance

`Optional`accountNumbers?: string[]

`Optional`bankIds?: string[]

`Optional`blockTime?: Date

`Optional`createdAt?: DbTimestampCriteria

`Optional`customerIds?: string[]

`Optional`entityIds?: string[]

`Optional`ids?: string[]

`Optional`includeDeleted?: boolean

`Optional`ledgerAccountAddresses?: Address[]

`Optional`ledgerAccountIds?: string[]

`Optional`page?: number

`Optional`pageSize?: number

`Optional`providerTypes?: ("VICTOR" | "BIVO" | "ROUTE_FUSION" | "ZENUS" | "MANUAL")[]

`Optional`q?: string

`Optional`routeFusionEntityIds?: string[]

`Optional`routeFusionProgramIds?: string[]

`Optional`routeFusionWalletIds?: string[]

`Optional`statuses?: ("PENDING" | "ACTIVE" | "FAILED" | "INACTIVE")[]

`Optional`updatedAt?: DbTimestampCriteria

Returns Promise<
{
ok: true;
value: {
hasNext: boolean;
items: VirtualAccountAdminSearchItem[];
total: number;
};
},
>