Class BankTransactionService

Hierarchy (View Summary)

BankTransactionQueryService
- BankTransactionService

Index

Constructors

constructor

Properties

Methods

create get search stat update

Constructors

constructor

new BankTransactionService(
args: { adminEventPublisher: AdminEventPublisher; db: B2bDatabase },
): BankTransactionService
Parameters
- args: { adminEventPublisher: AdminEventPublisher; db: B2bDatabase }
Returns BankTransactionService
Overrides BankTransactionQueryService.constructor
- Defined in packages/bank-transaction-services/src/BankTransactionService.ts:334

Properties

`Protected` `Readonly`db

db: B2bDatabase

Methods

create

create(
    args: Pick<
        {
            accountNumber: string;
            amount: string;
            bankId: string;
            bankStatus: "POSTED";
            bankTransactionId: string;
            createdAt: Date;
            data: {
                isManual?: boolean;
                methodData: | Record<string, never>
                | (
                    { victorTransactionId?: string | undefined; victorReferenceId?: string | undefined; } & ({ method: "BOOK_TRANSFER"; } | { method: "ACH"; senderName?: string | undefined; achId?: string | undefined; achTraceId?: string | undefined; sourceRoutingNumber?: string | undefined; sourceBankName?: string | undefined; targetAccountName?: string | undefined; targetAccountNumber?: string | undefined; targetRoutingNumber?: string | undefined; targetBankName?: string | undefined; } | { method: "ACH_DEBIT"; senderName?: string | undefined; achId?: string | undefined; achTraceId?: string | undefined; sourceRoutingNumber?: string | undefined; sourceBankName?: string | undefined; targetRoutingNumber?: string | undefined; targetBankName?: string | undefined; } | { method: "RTP"; senderName?: string | undefined; tchInstitutionId?: string | undefined; } | { method: "SWIFT"; imad: string; omad?: string | undefined; senderName?: string | undefined; ffcMemo?: string | undefined; } | { method: "FEDWIRE"; imad: string; omad?: string | undefined; senderName?: string | undefined; sourceAccountNumber?: string | undefined; sourceRoutingNumber?: string | undefined; sourceBankName?: string | undefined; targetAccountName?: string | undefined; targetAccountNumber?: string | undefined; targetRoutingNumber?: string | undefined; targetBankName?: string | undefined; ffcMemo?: string | undefined; })
                );
                reconciliation: Partial<
                    Record<
                        | "WITHDRAWAL"
                        | "DEPOSIT"
                        | "REDEMPTION"
                        | "ACH_BATCH"
                        | "MANUAL_MINT"
                        | "BANK_INTERNAL_TRANSFER",
                        string,
                    >,
                > & Partial<
                    Record<
                        "WITHDRAWAL_IDS"
                        | "DEPOSIT_IDS"
                        | "REDEMPTION_IDS",
                        string[],
                    >,
                >;
            };
            description: string;
            externalId: string;
            id: number;
            postedAt: Date;
            routingNumber: string;
            statementDescription: string;
            type: "CREDIT"
            | "DEBIT";
            updatedAt: Date;
        },
        | "type"
        | "description"
        | "routingNumber"
        | "bankTransactionId"
        | "bankId"
        | "accountNumber"
        | "bankStatus"
        | "amount"
        | "statementDescription"
        | "postedAt",
    > & {
        isManual?: boolean;
        methodData?: | Record<string, never>
        | (
            { victorTransactionId?: string | undefined; victorReferenceId?: string | undefined; } & ({ method: "BOOK_TRANSFER"; } | { method: "ACH"; senderName?: string | undefined; achId?: string | undefined; achTraceId?: string | undefined; sourceRoutingNumber?: string | undefined; sourceBankName?: string | undefined; targetAccountName?: string | undefined; targetAccountNumber?: string | undefined; targetRoutingNumber?: string | undefined; targetBankName?: string | undefined; } | { method: "ACH_DEBIT"; senderName?: string | undefined; achId?: string | undefined; achTraceId?: string | undefined; sourceRoutingNumber?: string | undefined; sourceBankName?: string | undefined; targetRoutingNumber?: string | undefined; targetBankName?: string | undefined; } | { method: "RTP"; senderName?: string | undefined; tchInstitutionId?: string | undefined; } | { method: "SWIFT"; imad: string; omad?: string | undefined; senderName?: string | undefined; ffcMemo?: string | undefined; } | { method: "FEDWIRE"; imad: string; omad?: string | undefined; senderName?: string | undefined; sourceAccountNumber?: string | undefined; sourceRoutingNumber?: string | undefined; sourceBankName?: string | undefined; targetAccountName?: string | undefined; targetAccountNumber?: string | undefined; targetRoutingNumber?: string | undefined; targetBankName?: string | undefined; ffcMemo?: string | undefined; })
        );
    },
): Promise<{ ok: true; value: BankTransaction }>
Parameters
- args: Pick<
      {
          accountNumber: string;
          amount: string;
          bankId: string;
          bankStatus: "POSTED";
          bankTransactionId: string;
          createdAt: Date;
          data: {
              isManual?: boolean;
              methodData: | Record<string, never>
              | (
                  { victorTransactionId?: string | undefined; victorReferenceId?: string | undefined; } & ({ method: "BOOK_TRANSFER"; } | { method: "ACH"; senderName?: string | undefined; achId?: string | undefined; achTraceId?: string | undefined; sourceRoutingNumber?: string | undefined; sourceBankName?: string | undefined; targetAccountName?: string | undefined; targetAccountNumber?: string | undefined; targetRoutingNumber?: string | undefined; targetBankName?: string | undefined; } | { method: "ACH_DEBIT"; senderName?: string | undefined; achId?: string | undefined; achTraceId?: string | undefined; sourceRoutingNumber?: string | undefined; sourceBankName?: string | undefined; targetRoutingNumber?: string | undefined; targetBankName?: string | undefined; } | { method: "RTP"; senderName?: string | undefined; tchInstitutionId?: string | undefined; } | { method: "SWIFT"; imad: string; omad?: string | undefined; senderName?: string | undefined; ffcMemo?: string | undefined; } | { method: "FEDWIRE"; imad: string; omad?: string | undefined; senderName?: string | undefined; sourceAccountNumber?: string | undefined; sourceRoutingNumber?: string | undefined; sourceBankName?: string | undefined; targetAccountName?: string | undefined; targetAccountNumber?: string | undefined; targetRoutingNumber?: string | undefined; targetBankName?: string | undefined; ffcMemo?: string | undefined; })
              );
              reconciliation: Partial<
                  Record<
                      | "WITHDRAWAL"
                      | "DEPOSIT"
                      | "REDEMPTION"
                      | "ACH_BATCH"
                      | "MANUAL_MINT"
                      | "BANK_INTERNAL_TRANSFER",
                      string,
                  >,
              > & Partial<
                  Record<"WITHDRAWAL_IDS" | "DEPOSIT_IDS" | "REDEMPTION_IDS", string[]>,
              >;
          };
          description: string;
          externalId: string;
          id: number;
          postedAt: Date;
          routingNumber: string;
          statementDescription: string;
          type: "CREDIT"
          | "DEBIT";
          updatedAt: Date;
      },
      | "type"
      | "description"
      | "routingNumber"
      | "bankTransactionId"
      | "bankId"
      | "accountNumber"
      | "bankStatus"
      | "amount"
      | "statementDescription"
      | "postedAt",
  > & {
      isManual?: boolean;
      methodData?: | Record<string, never>
      | (
          { victorTransactionId?: string | undefined; victorReferenceId?: string | undefined; } & ({ method: "BOOK_TRANSFER"; } | { method: "ACH"; senderName?: string | undefined; achId?: string | undefined; achTraceId?: string | undefined; sourceRoutingNumber?: string | undefined; sourceBankName?: string | undefined; targetAccountName?: string | undefined; targetAccountNumber?: string | undefined; targetRoutingNumber?: string | undefined; targetBankName?: string | undefined; } | { method: "ACH_DEBIT"; senderName?: string | undefined; achId?: string | undefined; achTraceId?: string | undefined; sourceRoutingNumber?: string | undefined; sourceBankName?: string | undefined; targetRoutingNumber?: string | undefined; targetBankName?: string | undefined; } | { method: "RTP"; senderName?: string | undefined; tchInstitutionId?: string | undefined; } | { method: "SWIFT"; imad: string; omad?: string | undefined; senderName?: string | undefined; ffcMemo?: string | undefined; } | { method: "FEDWIRE"; imad: string; omad?: string | undefined; senderName?: string | undefined; sourceAccountNumber?: string | undefined; sourceRoutingNumber?: string | undefined; sourceBankName?: string | undefined; targetAccountName?: string | undefined; targetAccountNumber?: string | undefined; targetRoutingNumber?: string | undefined; targetBankName?: string | undefined; ffcMemo?: string | undefined; })
      );
  }
Returns Promise<{ ok: true; value: BankTransaction }>
- Defined in packages/bank-transaction-services/src/BankTransactionService.ts:342

get

get(
    args: {
        id: string;
        tx?: PgAsyncTransaction<
            PostgresJsQueryResultHKT,
            __module,
            EmptyRelations,
            ExtractTablesWithRelations<__module>,
        >;
    },
): Promise<{ ok: true; value: BankTransaction | null }>
Parameters
- args: {
      id: string;
      tx?: PgAsyncTransaction<
          PostgresJsQueryResultHKT,
          __module,
          EmptyRelations,
          ExtractTablesWithRelations<__module>,
      >;
  }
Returns Promise<{ ok: true; value: BankTransaction | null }>
Inherited from BankTransactionQueryService.get
- Defined in packages/bank-transaction-services/src/BankTransactionService.ts:128

search

search(
    __namedParameters: {
        accountNumber?: string;
        amount?: string;
        bankIds?: string[];
        bankTransactionIds?: string[];
        createdAt?: DbTimestampCriteria;
        id?: string[];
        orderBy?: DbOrderByCriterion<
            Omit<
                PgTableWithColumns<
                    {
                        columns: {
                            accountNumber: PgBuildColumn<
                                "bank_transaction",
                                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: "bank_transaction";
                                },
                            >;
                            amount: PgBuildColumn<
                                "bank_transaction",
                                SetNotNull<PgNumericBuilder>,
                                {
                                    data: string;
                                    dataType: "string numeric";
                                    driverParam: string;
                                    enumValues: undefined;
                                    generated: undefined;
                                    hasDefault: false;
                                    hasRuntimeDefault: false;
                                    identity: undefined;
                                    isAutoincrement: false;
                                    isPrimaryKey: false;
                                    name: string;
                                    notNull: true;
                                    tableName: "bank_transaction";
                                },
                            >;
                            bankId: PgBuildColumn<
                                "bank_transaction",
                                Set$Type<SetNotNull<(...)>, string>,
                                {
                                    data: string;
                                    dataType: "string";
                                    driverParam: string;
                                    enumValues: undefined;
                                    generated: undefined;
                                    hasDefault: false;
                                    hasRuntimeDefault: false;
                                    identity: undefined;
                                    isAutoincrement: false;
                                    isPrimaryKey: false;
                                    name: string;
                                    notNull: true;
                                    tableName: "bank_transaction";
                                },
                            >;
                            bankStatus: PgBuildColumn<
                                "bank_transaction",
                                Set$Type<SetNotNull<(...)>, "POSTED">,
                                {
                                    data: "POSTED";
                                    dataType: "string";
                                    driverParam: string;
                                    enumValues: undefined;
                                    generated: undefined;
                                    hasDefault: false;
                                    hasRuntimeDefault: false;
                                    identity: undefined;
                                    isAutoincrement: false;
                                    isPrimaryKey: false;
                                    name: string;
                                    notNull: true;
                                    tableName: "bank_transaction";
                                },
                            >;
                            bankTransactionId: PgBuildColumn<
                                "bank_transaction",
                                SetNotNull<PgTextBuilder<(...)>>,
                                {
                                    data: string;
                                    dataType: "string";
                                    driverParam: string;
                                    enumValues: undefined;
                                    generated: undefined;
                                    hasDefault: false;
                                    hasRuntimeDefault: false;
                                    identity: undefined;
                                    isAutoincrement: false;
                                    isPrimaryKey: false;
                                    name: string;
                                    notNull: true;
                                    tableName: "bank_transaction";
                                },
                            >;
                            createdAt: PgBuildColumn<
                                "bank_transaction",
                                SetHasDefault<SetNotNull<(...)>>,
                                {
                                    data: Date;
                                    dataType: "object date";
                                    driverParam: string;
                                    enumValues: undefined;
                                    generated: undefined;
                                    hasDefault: true;
                                    hasRuntimeDefault: false;
                                    identity: undefined;
                                    isAutoincrement: false;
                                    isPrimaryKey: false;
                                    name: string;
                                    notNull: true;
                                    tableName: "bank_transaction";
                                },
                            >;
                            data: PgBuildColumn<
                                "bank_transaction",
                                Set$Type<
                                    SetHasDefault<(...)>,
                                    { isManual?: ...; methodData: ...; reconciliation: ... },
                                >,
                                {
                                    data: { isManual?: ...; methodData: ...; reconciliation: ... };
                                    dataType: "object json";
                                    driverParam: unknown;
                                    enumValues: undefined;
                                    generated: undefined;
                                    hasDefault: true;
                                    hasRuntimeDefault: false;
                                    identity: undefined;
                                    isAutoincrement: false;
                                    isPrimaryKey: false;
                                    name: string;
                                    notNull: true;
                                    tableName: "bank_transaction";
                                },
                            >;
                            description: PgBuildColumn<
                                "bank_transaction",
                                SetNotNull<PgTextBuilder<(...)>>,
                                {
                                    data: string;
                                    dataType: "string";
                                    driverParam: string;
                                    enumValues: undefined;
                                    generated: undefined;
                                    hasDefault: false;
                                    hasRuntimeDefault: false;
                                    identity: undefined;
                                    isAutoincrement: false;
                                    isPrimaryKey: false;
                                    name: string;
                                    notNull: true;
                                    tableName: "bank_transaction";
                                },
                            >;
                            externalId: PgBuildColumn<
                                "bank_transaction",
                                SetHasRuntimeDefault<SetNotNull<(...)>>,
                                {
                                    data: string;
                                    dataType: "string";
                                    driverParam: string;
                                    enumValues: undefined;
                                    generated: undefined;
                                    hasDefault: true;
                                    hasRuntimeDefault: false;
                                    identity: undefined;
                                    isAutoincrement: false;
                                    isPrimaryKey: false;
                                    name: string;
                                    notNull: true;
                                    tableName: "bank_transaction";
                                },
                            >;
                            id: PgBuildColumn<
                                "bank_transaction",
                                HasIdentity<SetIsPrimaryKey<(...)>, "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: "bank_transaction";
                                },
                            >;
                            postedAt: PgBuildColumn<
                                "bank_transaction",
                                SetNotNull<PgTimestampBuilder>,
                                {
                                    data: Date;
                                    dataType: "object date";
                                    driverParam: string;
                                    enumValues: undefined;
                                    generated: undefined;
                                    hasDefault: false;
                                    hasRuntimeDefault: false;
                                    identity: undefined;
                                    isAutoincrement: false;
                                    isPrimaryKey: false;
                                    name: string;
                                    notNull: true;
                                    tableName: "bank_transaction";
                                },
                            >;
                            routingNumber: PgBuildColumn<
                                "bank_transaction",
                                SetNotNull<PgTextBuilder<(...)>>,
                                {
                                    data: string;
                                    dataType: "string";
                                    driverParam: string;
                                    enumValues: undefined;
                                    generated: undefined;
                                    hasDefault: false;
                                    hasRuntimeDefault: false;
                                    identity: undefined;
                                    isAutoincrement: false;
                                    isPrimaryKey: false;
                                    name: string;
                                    notNull: true;
                                    tableName: "bank_transaction";
                                },
                            >;
                            statementDescription: PgBuildColumn<
                                "bank_transaction",
                                SetNotNull<PgTextBuilder<(...)>>,
                                {
                                    data: string;
                                    dataType: "string";
                                    driverParam: string;
                                    enumValues: undefined;
                                    generated: undefined;
                                    hasDefault: false;
                                    hasRuntimeDefault: false;
                                    identity: undefined;
                                    isAutoincrement: false;
                                    isPrimaryKey: false;
                                    name: string;
                                    notNull: true;
                                    tableName: "bank_transaction";
                                },
                            >;
                            type: PgBuildColumn<
                                "bank_transaction",
                                Set$Type<SetNotNull<(...)>, (...) | (...)>,
                                {
                                    data: (...) | (...);
                                    dataType: "string";
                                    driverParam: string;
                                    enumValues: undefined;
                                    generated: undefined;
                                    hasDefault: false;
                                    hasRuntimeDefault: false;
                                    identity: undefined;
                                    isAutoincrement: false;
                                    isPrimaryKey: false;
                                    name: string;
                                    notNull: true;
                                    tableName: "bank_transaction";
                                },
                            >;
                            updatedAt: PgBuildColumn<
                                "bank_transaction",
                                SetHasDefault<SetHasDefault<(...)>>,
                                {
                                    data: Date;
                                    dataType: "object date";
                                    driverParam: string;
                                    enumValues: undefined;
                                    generated: undefined;
                                    hasDefault: true;
                                    hasRuntimeDefault: false;
                                    identity: undefined;
                                    isAutoincrement: false;
                                    isPrimaryKey: false;
                                    name: string;
                                    notNull: true;
                                    tableName: "bank_transaction";
                                },
                            >;
                        };
                        dialect: "pg";
                        name: "bank_transaction";
                        schema: "b2b";
                    },
                >,
                "enableRLS",
            >,
            "createdAt"
            | "updatedAt",
        >[];
        page?: number;
        pageSize?: number;
        q?: string;
        routingNumber?: string;
        status?: "POSTED" | "RECONCILED";
        tx?: PgAsyncTransaction<
            PostgresJsQueryResultHKT,
            __module,
            EmptyRelations,
            ExtractTablesWithRelations<__module>,
        >;
        type?: "CREDIT" | "DEBIT";
        updatedAt?: DbTimestampCriteria;
    },
): Promise<
    {
        ok: true;
        value: { hasNext: boolean; items: BankTransaction[]; total: number };
    },
>
Parameters
- __namedParameters: {
      accountNumber?: string;
      amount?: string;
      bankIds?: string[];
      bankTransactionIds?: string[];
      createdAt?: DbTimestampCriteria;
      id?: string[];
      orderBy?: DbOrderByCriterion<
          Omit<
              PgTableWithColumns<
                  {
                      columns: {
                          accountNumber: PgBuildColumn<
                              "bank_transaction",
                              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: "bank_transaction";
                              },
                          >;
                          amount: PgBuildColumn<
                              "bank_transaction",
                              SetNotNull<PgNumericBuilder>,
                              {
                                  data: string;
                                  dataType: "string numeric";
                                  driverParam: string;
                                  enumValues: undefined;
                                  generated: undefined;
                                  hasDefault: false;
                                  hasRuntimeDefault: false;
                                  identity: undefined;
                                  isAutoincrement: false;
                                  isPrimaryKey: false;
                                  name: string;
                                  notNull: true;
                                  tableName: "bank_transaction";
                              },
                          >;
                          bankId: PgBuildColumn<
                              "bank_transaction",
                              Set$Type<SetNotNull<(...)>, string>,
                              {
                                  data: string;
                                  dataType: "string";
                                  driverParam: string;
                                  enumValues: undefined;
                                  generated: undefined;
                                  hasDefault: false;
                                  hasRuntimeDefault: false;
                                  identity: undefined;
                                  isAutoincrement: false;
                                  isPrimaryKey: false;
                                  name: string;
                                  notNull: true;
                                  tableName: "bank_transaction";
                              },
                          >;
                          bankStatus: PgBuildColumn<
                              "bank_transaction",
                              Set$Type<SetNotNull<(...)>, "POSTED">,
                              {
                                  data: "POSTED";
                                  dataType: "string";
                                  driverParam: string;
                                  enumValues: undefined;
                                  generated: undefined;
                                  hasDefault: false;
                                  hasRuntimeDefault: false;
                                  identity: undefined;
                                  isAutoincrement: false;
                                  isPrimaryKey: false;
                                  name: string;
                                  notNull: true;
                                  tableName: "bank_transaction";
                              },
                          >;
                          bankTransactionId: PgBuildColumn<
                              "bank_transaction",
                              SetNotNull<PgTextBuilder<(...)>>,
                              {
                                  data: string;
                                  dataType: "string";
                                  driverParam: string;
                                  enumValues: undefined;
                                  generated: undefined;
                                  hasDefault: false;
                                  hasRuntimeDefault: false;
                                  identity: undefined;
                                  isAutoincrement: false;
                                  isPrimaryKey: false;
                                  name: string;
                                  notNull: true;
                                  tableName: "bank_transaction";
                              },
                          >;
                          createdAt: PgBuildColumn<
                              "bank_transaction",
                              SetHasDefault<SetNotNull<(...)>>,
                              {
                                  data: Date;
                                  dataType: "object date";
                                  driverParam: string;
                                  enumValues: undefined;
                                  generated: undefined;
                                  hasDefault: true;
                                  hasRuntimeDefault: false;
                                  identity: undefined;
                                  isAutoincrement: false;
                                  isPrimaryKey: false;
                                  name: string;
                                  notNull: true;
                                  tableName: "bank_transaction";
                              },
                          >;
                          data: PgBuildColumn<
                              "bank_transaction",
                              Set$Type<
                                  SetHasDefault<(...)>,
                                  { isManual?: ...; methodData: ...; reconciliation: ... },
                              >,
                              {
                                  data: { isManual?: ...; methodData: ...; reconciliation: ... };
                                  dataType: "object json";
                                  driverParam: unknown;
                                  enumValues: undefined;
                                  generated: undefined;
                                  hasDefault: true;
                                  hasRuntimeDefault: false;
                                  identity: undefined;
                                  isAutoincrement: false;
                                  isPrimaryKey: false;
                                  name: string;
                                  notNull: true;
                                  tableName: "bank_transaction";
                              },
                          >;
                          description: PgBuildColumn<
                              "bank_transaction",
                              SetNotNull<PgTextBuilder<(...)>>,
                              {
                                  data: string;
                                  dataType: "string";
                                  driverParam: string;
                                  enumValues: undefined;
                                  generated: undefined;
                                  hasDefault: false;
                                  hasRuntimeDefault: false;
                                  identity: undefined;
                                  isAutoincrement: false;
                                  isPrimaryKey: false;
                                  name: string;
                                  notNull: true;
                                  tableName: "bank_transaction";
                              },
                          >;
                          externalId: PgBuildColumn<
                              "bank_transaction",
                              SetHasRuntimeDefault<SetNotNull<(...)>>,
                              {
                                  data: string;
                                  dataType: "string";
                                  driverParam: string;
                                  enumValues: undefined;
                                  generated: undefined;
                                  hasDefault: true;
                                  hasRuntimeDefault: false;
                                  identity: undefined;
                                  isAutoincrement: false;
                                  isPrimaryKey: false;
                                  name: string;
                                  notNull: true;
                                  tableName: "bank_transaction";
                              },
                          >;
                          id: PgBuildColumn<
                              "bank_transaction",
                              HasIdentity<SetIsPrimaryKey<(...)>, "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: "bank_transaction";
                              },
                          >;
                          postedAt: PgBuildColumn<
                              "bank_transaction",
                              SetNotNull<PgTimestampBuilder>,
                              {
                                  data: Date;
                                  dataType: "object date";
                                  driverParam: string;
                                  enumValues: undefined;
                                  generated: undefined;
                                  hasDefault: false;
                                  hasRuntimeDefault: false;
                                  identity: undefined;
                                  isAutoincrement: false;
                                  isPrimaryKey: false;
                                  name: string;
                                  notNull: true;
                                  tableName: "bank_transaction";
                              },
                          >;
                          routingNumber: PgBuildColumn<
                              "bank_transaction",
                              SetNotNull<PgTextBuilder<(...)>>,
                              {
                                  data: string;
                                  dataType: "string";
                                  driverParam: string;
                                  enumValues: undefined;
                                  generated: undefined;
                                  hasDefault: false;
                                  hasRuntimeDefault: false;
                                  identity: undefined;
                                  isAutoincrement: false;
                                  isPrimaryKey: false;
                                  name: string;
                                  notNull: true;
                                  tableName: "bank_transaction";
                              },
                          >;
                          statementDescription: PgBuildColumn<
                              "bank_transaction",
                              SetNotNull<PgTextBuilder<(...)>>,
                              {
                                  data: string;
                                  dataType: "string";
                                  driverParam: string;
                                  enumValues: undefined;
                                  generated: undefined;
                                  hasDefault: false;
                                  hasRuntimeDefault: false;
                                  identity: undefined;
                                  isAutoincrement: false;
                                  isPrimaryKey: false;
                                  name: string;
                                  notNull: true;
                                  tableName: "bank_transaction";
                              },
                          >;
                          type: PgBuildColumn<
                              "bank_transaction",
                              Set$Type<SetNotNull<(...)>, (...) | (...)>,
                              {
                                  data: (...) | (...);
                                  dataType: "string";
                                  driverParam: string;
                                  enumValues: undefined;
                                  generated: undefined;
                                  hasDefault: false;
                                  hasRuntimeDefault: false;
                                  identity: undefined;
                                  isAutoincrement: false;
                                  isPrimaryKey: false;
                                  name: string;
                                  notNull: true;
                                  tableName: "bank_transaction";
                              },
                          >;
                          updatedAt: PgBuildColumn<
                              "bank_transaction",
                              SetHasDefault<SetHasDefault<(...)>>,
                              {
                                  data: Date;
                                  dataType: "object date";
                                  driverParam: string;
                                  enumValues: undefined;
                                  generated: undefined;
                                  hasDefault: true;
                                  hasRuntimeDefault: false;
                                  identity: undefined;
                                  isAutoincrement: false;
                                  isPrimaryKey: false;
                                  name: string;
                                  notNull: true;
                                  tableName: "bank_transaction";
                              },
                          >;
                      };
                      dialect: "pg";
                      name: "bank_transaction";
                      schema: "b2b";
                  },
              >,
              "enableRLS",
          >,
          "createdAt"
          | "updatedAt",
      >[];
      page?: number;
      pageSize?: number;
      q?: string;
      routingNumber?: string;
      status?: "POSTED" | "RECONCILED";
      tx?: PgAsyncTransaction<
          PostgresJsQueryResultHKT,
          __module,
          EmptyRelations,
          ExtractTablesWithRelations<__module>,
      >;
      type?: "CREDIT" | "DEBIT";
      updatedAt?: DbTimestampCriteria;
  }
  - OptionalaccountNumber?: string
  - Optionalamount?: string
  - OptionalbankIds?: string[]
  - OptionalbankTransactionIds?: string[]
  - OptionalcreatedAt?: DbTimestampCriteria
  - Optionalid?: string[]
  - OptionalorderBy?: DbOrderByCriterion<
        Omit<
            PgTableWithColumns<
                {
                    columns: {
                        accountNumber: PgBuildColumn<
                            "bank_transaction",
                            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: "bank_transaction";
                            },
                        >;
                        amount: PgBuildColumn<
                            "bank_transaction",
                            SetNotNull<PgNumericBuilder>,
                            {
                                data: string;
                                dataType: "string numeric";
                                driverParam: string;
                                enumValues: undefined;
                                generated: undefined;
                                hasDefault: false;
                                hasRuntimeDefault: false;
                                identity: undefined;
                                isAutoincrement: false;
                                isPrimaryKey: false;
                                name: string;
                                notNull: true;
                                tableName: "bank_transaction";
                            },
                        >;
                        bankId: PgBuildColumn<
                            "bank_transaction",
                            Set$Type<SetNotNull<(...)>, string>,
                            {
                                data: string;
                                dataType: "string";
                                driverParam: string;
                                enumValues: undefined;
                                generated: undefined;
                                hasDefault: false;
                                hasRuntimeDefault: false;
                                identity: undefined;
                                isAutoincrement: false;
                                isPrimaryKey: false;
                                name: string;
                                notNull: true;
                                tableName: "bank_transaction";
                            },
                        >;
                        bankStatus: PgBuildColumn<
                            "bank_transaction",
                            Set$Type<SetNotNull<(...)>, "POSTED">,
                            {
                                data: "POSTED";
                                dataType: "string";
                                driverParam: string;
                                enumValues: undefined;
                                generated: undefined;
                                hasDefault: false;
                                hasRuntimeDefault: false;
                                identity: undefined;
                                isAutoincrement: false;
                                isPrimaryKey: false;
                                name: string;
                                notNull: true;
                                tableName: "bank_transaction";
                            },
                        >;
                        bankTransactionId: PgBuildColumn<
                            "bank_transaction",
                            SetNotNull<PgTextBuilder<(...)>>,
                            {
                                data: string;
                                dataType: "string";
                                driverParam: string;
                                enumValues: undefined;
                                generated: undefined;
                                hasDefault: false;
                                hasRuntimeDefault: false;
                                identity: undefined;
                                isAutoincrement: false;
                                isPrimaryKey: false;
                                name: string;
                                notNull: true;
                                tableName: "bank_transaction";
                            },
                        >;
                        createdAt: PgBuildColumn<
                            "bank_transaction",
                            SetHasDefault<SetNotNull<(...)>>,
                            {
                                data: Date;
                                dataType: "object date";
                                driverParam: string;
                                enumValues: undefined;
                                generated: undefined;
                                hasDefault: true;
                                hasRuntimeDefault: false;
                                identity: undefined;
                                isAutoincrement: false;
                                isPrimaryKey: false;
                                name: string;
                                notNull: true;
                                tableName: "bank_transaction";
                            },
                        >;
                        data: PgBuildColumn<
                            "bank_transaction",
                            Set$Type<
                                SetHasDefault<(...)>,
                                { isManual?: ...; methodData: ...; reconciliation: ... },
                            >,
                            {
                                data: { isManual?: ...; methodData: ...; reconciliation: ... };
                                dataType: "object json";
                                driverParam: unknown;
                                enumValues: undefined;
                                generated: undefined;
                                hasDefault: true;
                                hasRuntimeDefault: false;
                                identity: undefined;
                                isAutoincrement: false;
                                isPrimaryKey: false;
                                name: string;
                                notNull: true;
                                tableName: "bank_transaction";
                            },
                        >;
                        description: PgBuildColumn<
                            "bank_transaction",
                            SetNotNull<PgTextBuilder<(...)>>,
                            {
                                data: string;
                                dataType: "string";
                                driverParam: string;
                                enumValues: undefined;
                                generated: undefined;
                                hasDefault: false;
                                hasRuntimeDefault: false;
                                identity: undefined;
                                isAutoincrement: false;
                                isPrimaryKey: false;
                                name: string;
                                notNull: true;
                                tableName: "bank_transaction";
                            },
                        >;
                        externalId: PgBuildColumn<
                            "bank_transaction",
                            SetHasRuntimeDefault<SetNotNull<(...)>>,
                            {
                                data: string;
                                dataType: "string";
                                driverParam: string;
                                enumValues: undefined;
                                generated: undefined;
                                hasDefault: true;
                                hasRuntimeDefault: false;
                                identity: undefined;
                                isAutoincrement: false;
                                isPrimaryKey: false;
                                name: string;
                                notNull: true;
                                tableName: "bank_transaction";
                            },
                        >;
                        id: PgBuildColumn<
                            "bank_transaction",
                            HasIdentity<SetIsPrimaryKey<(...)>, "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: "bank_transaction";
                            },
                        >;
                        postedAt: PgBuildColumn<
                            "bank_transaction",
                            SetNotNull<PgTimestampBuilder>,
                            {
                                data: Date;
                                dataType: "object date";
                                driverParam: string;
                                enumValues: undefined;
                                generated: undefined;
                                hasDefault: false;
                                hasRuntimeDefault: false;
                                identity: undefined;
                                isAutoincrement: false;
                                isPrimaryKey: false;
                                name: string;
                                notNull: true;
                                tableName: "bank_transaction";
                            },
                        >;
                        routingNumber: PgBuildColumn<
                            "bank_transaction",
                            SetNotNull<PgTextBuilder<(...)>>,
                            {
                                data: string;
                                dataType: "string";
                                driverParam: string;
                                enumValues: undefined;
                                generated: undefined;
                                hasDefault: false;
                                hasRuntimeDefault: false;
                                identity: undefined;
                                isAutoincrement: false;
                                isPrimaryKey: false;
                                name: string;
                                notNull: true;
                                tableName: "bank_transaction";
                            },
                        >;
                        statementDescription: PgBuildColumn<
                            "bank_transaction",
                            SetNotNull<PgTextBuilder<(...)>>,
                            {
                                data: string;
                                dataType: "string";
                                driverParam: string;
                                enumValues: undefined;
                                generated: undefined;
                                hasDefault: false;
                                hasRuntimeDefault: false;
                                identity: undefined;
                                isAutoincrement: false;
                                isPrimaryKey: false;
                                name: string;
                                notNull: true;
                                tableName: "bank_transaction";
                            },
                        >;
                        type: PgBuildColumn<
                            "bank_transaction",
                            Set$Type<SetNotNull<(...)>, (...) | (...)>,
                            {
                                data: (...) | (...);
                                dataType: "string";
                                driverParam: string;
                                enumValues: undefined;
                                generated: undefined;
                                hasDefault: false;
                                hasRuntimeDefault: false;
                                identity: undefined;
                                isAutoincrement: false;
                                isPrimaryKey: false;
                                name: string;
                                notNull: true;
                                tableName: "bank_transaction";
                            },
                        >;
                        updatedAt: PgBuildColumn<
                            "bank_transaction",
                            SetHasDefault<SetHasDefault<(...)>>,
                            {
                                data: Date;
                                dataType: "object date";
                                driverParam: string;
                                enumValues: undefined;
                                generated: undefined;
                                hasDefault: true;
                                hasRuntimeDefault: false;
                                identity: undefined;
                                isAutoincrement: false;
                                isPrimaryKey: false;
                                name: string;
                                notNull: true;
                                tableName: "bank_transaction";
                            },
                        >;
                    };
                    dialect: "pg";
                    name: "bank_transaction";
                    schema: "b2b";
                },
            >,
            "enableRLS",
        >,
        "createdAt"
        | "updatedAt",
    >[]
  - Optionalpage?: number
    Defaults to 1
  - OptionalpageSize?: number
    Defaults to 10
  - Optionalq?: string
    Free-text filter: case-insensitive substring match on bankTransactionId, description, and statementDescription; when it parses as a positive decimal it also matches the exact amount.
  - OptionalroutingNumber?: string
  - Optionalstatus?: "POSTED" | "RECONCILED"
  - Optionaltx?: PgAsyncTransaction<
        PostgresJsQueryResultHKT,
        __module,
        EmptyRelations,
        ExtractTablesWithRelations<__module>,
    >
  - Optionaltype?: "CREDIT" | "DEBIT"
  - OptionalupdatedAt?: DbTimestampCriteria
Returns Promise<
    {
        ok: true;
        value: { hasNext: boolean; items: BankTransaction[]; total: number };
    },
>
Inherited from BankTransactionQueryService.search
- Defined in packages/bank-transaction-services/src/BankTransactionService.ts:156

stat

stat(
    args: {
        accountNumber: string;
        includeManual?: boolean;
        routingNumber: string;
        tx?: PgAsyncTransaction<
            PostgresJsQueryResultHKT,
            __module,
            EmptyRelations,
            ExtractTablesWithRelations<__module>,
        >;
    },
): Promise<{ ok: true; value: { txCount: number } }>
Parameters
- args: {
      accountNumber: string;
      includeManual?: boolean;
      routingNumber: string;
      tx?: PgAsyncTransaction<
          PostgresJsQueryResultHKT,
          __module,
          EmptyRelations,
          ExtractTablesWithRelations<__module>,
      >;
  }
Returns Promise<{ ok: true; value: { txCount: number } }>
Inherited from BankTransactionQueryService.stat
- Defined in packages/bank-transaction-services/src/BankTransactionService.ts:297

update

update(
    __namedParameters: {
        id: string;
        tx?: PgAsyncTransaction<
            PostgresJsQueryResultHKT,
            __module,
            EmptyRelations,
            ExtractTablesWithRelations<__module>,
        >;
    } & (
        | {
            data: {
                methodData?: Record<string, never> | ({ victorTransactionId?: string | undefined; victorReferenceId?: string | undefined; } & ({ method: "BOOK_TRANSFER"; } | { method: "ACH"; senderName?: string | undefined; achId?: string | undefined; achTraceId?: string | undefined; sourceRoutingNumber?: string | undefined; sourceBankName?: string | undefined; targetAccountName?: string | undefined; targetAccountNumber?: string | undefined; targetRoutingNumber?: string | undefined; targetBankName?: string | undefined; } | { method: "ACH_DEBIT"; senderName?: string | undefined; achId?: string | undefined; achTraceId?: string | undefined; sourceRoutingNumber?: string | undefined; sourceBankName?: string | undefined; targetRoutingNumber?: string | undefined; targetBankName?: string | undefined; } | { method: "RTP"; senderName?: string | undefined; tchInstitutionId?: string | undefined; } | { method: "SWIFT"; imad: string; omad?: string | undefined; senderName?: string | undefined; ffcMemo?: string | undefined; } | { method: "FEDWIRE"; imad: string; omad?: string | undefined; senderName?: string | undefined; sourceAccountNumber?: string | undefined; sourceRoutingNumber?: string | undefined; sourceBankName?: string | undefined; targetAccountName?: string | undefined; targetAccountNumber?: string | undefined; targetRoutingNumber?: string | undefined; targetBankName?: string | undefined; ffcMemo?: string | undefined; })) | undefined;
                reconciliation?: {
                    achBatchId?: string;
                    depositId?: string;
                    depositIds?: string[];
                    internalTransferId?: string;
                    manualMintId?: string;
                };
            };
            type: "CREDIT";
        }
        | {
            data: {
                methodData?: Record<string, never> | ({ victorTransactionId?: string | undefined; victorReferenceId?: string | undefined; } & ({ method: "BOOK_TRANSFER"; } | { method: "ACH"; senderName?: string | undefined; achId?: string | undefined; achTraceId?: string | undefined; sourceRoutingNumber?: string | undefined; sourceBankName?: string | undefined; targetAccountName?: string | undefined; targetAccountNumber?: string | undefined; targetRoutingNumber?: string | undefined; targetBankName?: string | undefined; } | { method: "ACH_DEBIT"; senderName?: string | undefined; achId?: string | undefined; achTraceId?: string | undefined; sourceRoutingNumber?: string | undefined; sourceBankName?: string | undefined; targetRoutingNumber?: string | undefined; targetBankName?: string | undefined; } | { method: "RTP"; senderName?: string | undefined; tchInstitutionId?: string | undefined; } | { method: "SWIFT"; imad: string; omad?: string | undefined; senderName?: string | undefined; ffcMemo?: string | undefined; } | { method: "FEDWIRE"; imad: string; omad?: string | undefined; senderName?: string | undefined; sourceAccountNumber?: string | undefined; sourceRoutingNumber?: string | undefined; sourceBankName?: string | undefined; targetAccountName?: string | undefined; targetAccountNumber?: string | undefined; targetRoutingNumber?: string | undefined; targetBankName?: string | undefined; ffcMemo?: string | undefined; })) | undefined;
                reconciliation?: {
                    achBatchId?: string;
                    internalTransferId?: string;
                    redemptionId?: string;
                    redemptionIds?: string[];
                    withdrawalId?: string;
                    withdrawalIds?: string[];
                };
            };
            type: "DEBIT";
        }
    ),
): Promise<{ ok: true; value: BankTransaction }>
Parameters
- __namedParameters: {
      id: string;
      tx?: PgAsyncTransaction<
          PostgresJsQueryResultHKT,
          __module,
          EmptyRelations,
          ExtractTablesWithRelations<__module>,
      >;
  } & (
      | {
          data: {
              methodData?: Record<string, never> | ({ victorTransactionId?: string | undefined; victorReferenceId?: string | undefined; } & ({ method: "BOOK_TRANSFER"; } | { method: "ACH"; senderName?: string | undefined; achId?: string | undefined; achTraceId?: string | undefined; sourceRoutingNumber?: string | undefined; sourceBankName?: string | undefined; targetAccountName?: string | undefined; targetAccountNumber?: string | undefined; targetRoutingNumber?: string | undefined; targetBankName?: string | undefined; } | { method: "ACH_DEBIT"; senderName?: string | undefined; achId?: string | undefined; achTraceId?: string | undefined; sourceRoutingNumber?: string | undefined; sourceBankName?: string | undefined; targetRoutingNumber?: string | undefined; targetBankName?: string | undefined; } | { method: "RTP"; senderName?: string | undefined; tchInstitutionId?: string | undefined; } | { method: "SWIFT"; imad: string; omad?: string | undefined; senderName?: string | undefined; ffcMemo?: string | undefined; } | { method: "FEDWIRE"; imad: string; omad?: string | undefined; senderName?: string | undefined; sourceAccountNumber?: string | undefined; sourceRoutingNumber?: string | undefined; sourceBankName?: string | undefined; targetAccountName?: string | undefined; targetAccountNumber?: string | undefined; targetRoutingNumber?: string | undefined; targetBankName?: string | undefined; ffcMemo?: string | undefined; })) | undefined;
              reconciliation?: {
                  achBatchId?: string;
                  depositId?: string;
                  depositIds?: string[];
                  internalTransferId?: string;
                  manualMintId?: string;
              };
          };
          type: "CREDIT";
      }
      | {
          data: {
              methodData?: Record<string, never> | ({ victorTransactionId?: string | undefined; victorReferenceId?: string | undefined; } & ({ method: "BOOK_TRANSFER"; } | { method: "ACH"; senderName?: string | undefined; achId?: string | undefined; achTraceId?: string | undefined; sourceRoutingNumber?: string | undefined; sourceBankName?: string | undefined; targetAccountName?: string | undefined; targetAccountNumber?: string | undefined; targetRoutingNumber?: string | undefined; targetBankName?: string | undefined; } | { method: "ACH_DEBIT"; senderName?: string | undefined; achId?: string | undefined; achTraceId?: string | undefined; sourceRoutingNumber?: string | undefined; sourceBankName?: string | undefined; targetRoutingNumber?: string | undefined; targetBankName?: string | undefined; } | { method: "RTP"; senderName?: string | undefined; tchInstitutionId?: string | undefined; } | { method: "SWIFT"; imad: string; omad?: string | undefined; senderName?: string | undefined; ffcMemo?: string | undefined; } | { method: "FEDWIRE"; imad: string; omad?: string | undefined; senderName?: string | undefined; sourceAccountNumber?: string | undefined; sourceRoutingNumber?: string | undefined; sourceBankName?: string | undefined; targetAccountName?: string | undefined; targetAccountNumber?: string | undefined; targetRoutingNumber?: string | undefined; targetBankName?: string | undefined; ffcMemo?: string | undefined; })) | undefined;
              reconciliation?: {
                  achBatchId?: string;
                  internalTransferId?: string;
                  redemptionId?: string;
                  redemptionIds?: string[];
                  withdrawalId?: string;
                  withdrawalIds?: string[];
              };
          };
          type: "DEBIT";
      }
  )
Returns Promise<{ ok: true; value: BankTransaction }>
- Defined in packages/bank-transaction-services/src/BankTransactionService.ts:416

Class BankTransactionService

Hierarchy (View Summary)

Index

Constructors

Properties

Methods

Constructors

constructor

Parameters

Returns BankTransactionService

Properties

Protected Readonlydb

Methods

create

Parameters

Returns Promise<{ ok: true; value: BankTransaction }>

get

Parameters

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

search

Parameters

OptionalaccountNumber?: string

Optionalamount?: string

OptionalbankIds?: string[]

OptionalbankTransactionIds?: string[]

OptionalcreatedAt?: DbTimestampCriteria

Optionalid?: string[]

Optionalpage?: number

OptionalpageSize?: number

Optionalq?: string

OptionalroutingNumber?: string

Optionalstatus?: "POSTED" | "RECONCILED"

Optionaltx?: PgAsyncTransaction< PostgresJsQueryResultHKT, __module, EmptyRelations, ExtractTablesWithRelations<__module>,>

Optionaltype?: "CREDIT" | "DEBIT"

OptionalupdatedAt?: DbTimestampCriteria

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

stat

Parameters

Returns Promise<{ ok: true; value: { txCount: number } }>

update

Parameters

Returns Promise<{ ok: true; value: BankTransaction }>

Settings

On This Page

`Protected` `Readonly`db

`Optional`accountNumber?: string

`Optional`amount?: string

`Optional`bankIds?: string[]

`Optional`bankTransactionIds?: string[]

`Optional`createdAt?: DbTimestampCriteria

`Optional`id?: string[]

`Optional`page?: number

`Optional`pageSize?: number

`Optional`q?: string

`Optional`routingNumber?: string

`Optional`status?: "POSTED" | "RECONCILED"

`Optional`tx?: PgAsyncTransaction<
PostgresJsQueryResultHKT,
module,
EmptyRelations,
ExtractTablesWithRelations<module>,
>

`Optional`type?: "CREDIT" | "DEBIT"

`Optional`updatedAt?: DbTimestampCriteria

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