Class GirasolCardTransactionAdminQueryService

constructor

• new GirasolCardTransactionAdminQueryService(
      args: { db: B2bDatabase },
  ): GirasolCardTransactionAdminQueryService

  Parameters

  • args: { db: B2bDatabase }

  Returns GirasolCardTransactionAdminQueryService

Staticinstance

get

• get(
      __namedParameters: { id: string },
  ): Promise<
      {
          ok: true;
          value: | {
              amount: BigNumber;
              clearing?: {
                  amountAdjusted: string;
                  amountCleared: string;
                  receipt?: { id: string; type: "SOLANA_TRANSACTION_SIGNATURE" };
                  type: "OVER_CLEARED" | "UNDER_CLEARED" | "MATCH";
              };
              clearingTypeDescription: string
              | null;
              createdAt: Date;
              currency: string;
              girasolTransactionId: string | null;
              id: string;
              merchant?: {
                  categoryCode?: string;
                  city?: string;
                  country?: string;
                  mcc: string;
                  name: string;
              };
              originalGirasolTransactionId: string
              | null;
              reason: string | null;
              receipt?: { id: string; type: "SOLANA_TRANSACTION_SIGNATURE" };
              status:
                  | "PENDING"
                  | "FAILED"
                  | "COMPLETED"
                  | "PROCESSING"
                  | "RETURNED"
                  | "CANCELLED";
              statusDescription: string;
              statusReason: GirasolCardTransactionStatusReason
              | null;
              type: "authorization" | "notification" | "reversal" | "refund";
              typeDescription: string;
              updatedAt: Date;
          } & { cardId: string; customerId: string; targetLedgerAccountId: string }
          | null;
      },
  >

  Parameters

  • __namedParameters: { id: string }

  Returns Promise<
      {
          ok: true;
          value: | {
              amount: BigNumber;
              clearing?: {
                  amountAdjusted: string;
                  amountCleared: string;
                  receipt?: { id: string; type: "SOLANA_TRANSACTION_SIGNATURE" };
                  type: "OVER_CLEARED" | "UNDER_CLEARED" | "MATCH";
              };
              clearingTypeDescription: string
              | null;
              createdAt: Date;
              currency: string;
              girasolTransactionId: string | null;
              id: string;
              merchant?: {
                  categoryCode?: string;
                  city?: string;
                  country?: string;
                  mcc: string;
                  name: string;
              };
              originalGirasolTransactionId: string
              | null;
              reason: string | null;
              receipt?: { id: string; type: "SOLANA_TRANSACTION_SIGNATURE" };
              status:
                  | "PENDING"
                  | "FAILED"
                  | "COMPLETED"
                  | "PROCESSING"
                  | "RETURNED"
                  | "CANCELLED";
              statusDescription: string;
              statusReason: GirasolCardTransactionStatusReason
              | null;
              type: "authorization" | "notification" | "reversal" | "refund";
              typeDescription: string;
              updatedAt: Date;
          } & { cardId: string; customerId: string; targetLedgerAccountId: string }
          | null;
      },
  >

relatedToHolds

• relatedToHolds(
      __namedParameters: { cardId: string; girasolTransactionIds: string[] },
  ): Promise<
      {
          ok: true;
          value: {
              knownGirasolIds: string[];
              related: (GirasolHoldRelatedRow & { holdGirasolTransactionId: string })[];
          };
      },
  >

  The rows Girasol sent about girasolTransactionIds: a reversal whose event names one as its original_transaction (its own id has a new base), or an advice whose id is one's <id>-<suffix>. Every Girasol id on the card is returned too, so a credit already recorded is never taken for a missed one.

  Parameters

  • __namedParameters: { cardId: string; girasolTransactionIds: string[] }

  Returns Promise<
      {
          ok: true;
          value: {
              knownGirasolIds: string[];
              related: (GirasolHoldRelatedRow & { holdGirasolTransactionId: string })[];
          };
      },
  >

search

• search(
      __namedParameters: {
          cardIds?: string[];
          customerId?: string;
          fromDate?: Date;
          girasolCardTransactionIds?: string[];
          idempotencyKeys?: string[];
          ids?: string[];
          orderBy?: DbOrderByCriterion<
              Omit<
                  PgTableWithColumns<
                      {
                          columns: {
                              amount: PgBuildColumn<
                                  "girasol_card_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: "girasol_card_transaction";
                                  },
                              >;
                              clearingData: PgBuildColumn<
                                  "girasol_card_transaction",
                                  Set$Type<
                                      PgJsonbBuilder,
                                      {
                                          amountAdjusted: ...;
                                          amountCleared: ...;
                                          receipt?: ...;
                                          type: ...;
                                      },
                                  >,
                                  {
                                      data: {
                                          amountAdjusted: ...;
                                          amountCleared: ...;
                                          receipt?: ...;
                                          type: ...;
                                      };
                                      dataType: "object json";
                                      driverParam: unknown;
                                      enumValues: undefined;
                                      generated: undefined;
                                      hasDefault: false;
                                      hasRuntimeDefault: false;
                                      identity: undefined;
                                      isAutoincrement: false;
                                      isPrimaryKey: false;
                                      name: string;
                                      notNull: false;
                                      tableName: "girasol_card_transaction";
                                  },
                              >;
                              createdAt: PgBuildColumn<
                                  "girasol_card_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: "girasol_card_transaction";
                                  },
                              >;
                              currency: PgBuildColumn<
                                  "girasol_card_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: "girasol_card_transaction";
                                  },
                              >;
                              customerExternalId: PgBuildColumn<
                                  "girasol_card_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: "girasol_card_transaction";
                                  },
                              >;
                              customerId: PgBuildColumn<
                                  "girasol_card_transaction",
                                  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: "girasol_card_transaction";
                                  },
                              >;
                              data: PgBuildColumn<
                                  "girasol_card_transaction",
                                  Set$Type<PgJsonbBuilder, { girasolEvent?: ...; merchant?: ... }>,
                                  {
                                      data: { girasolEvent?: ...; merchant?: ... };
                                      dataType: "object json";
                                      driverParam: unknown;
                                      enumValues: undefined;
                                      generated: undefined;
                                      hasDefault: false;
                                      hasRuntimeDefault: false;
                                      identity: undefined;
                                      isAutoincrement: false;
                                      isPrimaryKey: false;
                                      name: string;
                                      notNull: false;
                                      tableName: "girasol_card_transaction";
                                  },
                              >;
                              externalId: PgBuildColumn<
                                  "girasol_card_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: "girasol_card_transaction";
                                  },
                              >;
                              girasolCardExternalId: PgBuildColumn<
                                  "girasol_card_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: "girasol_card_transaction";
                                  },
                              >;
                              girasolCardId: PgBuildColumn<
                                  "girasol_card_transaction",
                                  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: "girasol_card_transaction";
                                  },
                              >;
                              girasolTransactionId: PgBuildColumn<
                                  "girasol_card_transaction",
                                  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: "girasol_card_transaction";
                                  },
                              >;
                              id: PgBuildColumn<
                                  "girasol_card_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: "girasol_card_transaction";
                                  },
                              >;
                              idempotencyKey: PgBuildColumn<
                                  "girasol_card_transaction",
                                  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: "girasol_card_transaction";
                                  },
                              >;
                              originalGirasolTransactionId: PgBuildColumn<
                                  "girasol_card_transaction",
                                  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: "girasol_card_transaction";
                                  },
                              >;
                              reason: PgBuildColumn<
                                  "girasol_card_transaction",
                                  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: "girasol_card_transaction";
                                  },
                              >;
                              receipt: PgBuildColumn<
                                  "girasol_card_transaction",
                                  Set$Type<PgJsonbBuilder, { id: ...; type: ... }>,
                                  {
                                      data: { id: ...; type: ... };
                                      dataType: "object json";
                                      driverParam: unknown;
                                      enumValues: undefined;
                                      generated: undefined;
                                      hasDefault: false;
                                      hasRuntimeDefault: false;
                                      identity: undefined;
                                      isAutoincrement: false;
                                      isPrimaryKey: false;
                                      name: string;
                                      notNull: false;
                                      tableName: "girasol_card_transaction";
                                  },
                              >;
                              settlementLedgerAccountExternalId: PgBuildColumn<
                                  "girasol_card_transaction",
                                  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: "girasol_card_transaction";
                                  },
                              >;
                              settlementLedgerAccountId: PgBuildColumn<
                                  "girasol_card_transaction",
                                  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: "girasol_card_transaction";
                                  },
                              >;
                              status: PgBuildColumn<
                                  "girasol_card_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: "girasol_card_transaction";
                                  },
                              >;
                              statusReason: PgBuildColumn<
                                  "girasol_card_transaction",
                                  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: "girasol_card_transaction";
                                  },
                              >;
                              type: PgBuildColumn<
                                  "girasol_card_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: "girasol_card_transaction";
                                  },
                              >;
                              updatedAt: PgBuildColumn<
                                  "girasol_card_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: "girasol_card_transaction";
                                  },
                              >;
                          };
                          dialect: "pg";
                          isAlias: false;
                          name: "girasol_card_transaction";
                          schema: "b2b";
                      },
                  >,
                  "enableRLS",
              >,
              "createdAt"
              | "updatedAt",
          >[];
          originalGirasolCardTransactionIds?: string[];
          page?: number;
          pageSize?: number;
          statuses?: (
              | "PENDING"
              | "FAILED"
              | "COMPLETED"
              | "PROCESSING"
              | "RETURNED"
              | "CANCELLED"
          )[];
          toDate?: Date;
          types?: ("authorization" | "notification" | "reversal" | "refund")[];
          uncleared?: boolean;
      },
  ): Promise<
      {
          ok: true;
          value: {
              hasNext: boolean;
              items: (
                  {
                      amount: BigNumber;
                      clearing?: {
                          amountAdjusted: string;
                          amountCleared: string;
                          receipt?: { id: string; type: "SOLANA_TRANSACTION_SIGNATURE" };
                          type: "OVER_CLEARED" | "UNDER_CLEARED" | "MATCH";
                      };
                      clearingTypeDescription: string
                      | null;
                      createdAt: Date;
                      currency: string;
                      girasolTransactionId: string | null;
                      id: string;
                      merchant?: {
                          categoryCode?: string;
                          city?: string;
                          country?: string;
                          mcc: string;
                          name: string;
                      };
                      originalGirasolTransactionId: string
                      | null;
                      reason: string | null;
                      receipt?: { id: string; type: "SOLANA_TRANSACTION_SIGNATURE" };
                      status:
                          | "PENDING"
                          | "FAILED"
                          | "COMPLETED"
                          | "PROCESSING"
                          | "RETURNED"
                          | "CANCELLED";
                      statusDescription: string;
                      statusReason: GirasolCardTransactionStatusReason
                      | null;
                      type: "authorization" | "notification" | "reversal" | "refund";
                      typeDescription: string;
                      updatedAt: Date;
                  } & {
                      cardId: string;
                      customerId: string;
                      targetLedgerAccountId: string;
                  }
              )[];
              total: number;
          };
      },
  >

  Parameters

  • __namedParameters: {
        cardIds?: string[];
        customerId?: string;
        fromDate?: Date;
        girasolCardTransactionIds?: string[];
        idempotencyKeys?: string[];
        ids?: string[];
        orderBy?: DbOrderByCriterion<
            Omit<
                PgTableWithColumns<
                    {
                        columns: {
                            amount: PgBuildColumn<
                                "girasol_card_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: "girasol_card_transaction";
                                },
                            >;
                            clearingData: PgBuildColumn<
                                "girasol_card_transaction",
                                Set$Type<
                                    PgJsonbBuilder,
                                    {
                                        amountAdjusted: ...;
                                        amountCleared: ...;
                                        receipt?: ...;
                                        type: ...;
                                    },
                                >,
                                {
                                    data: {
                                        amountAdjusted: ...;
                                        amountCleared: ...;
                                        receipt?: ...;
                                        type: ...;
                                    };
                                    dataType: "object json";
                                    driverParam: unknown;
                                    enumValues: undefined;
                                    generated: undefined;
                                    hasDefault: false;
                                    hasRuntimeDefault: false;
                                    identity: undefined;
                                    isAutoincrement: false;
                                    isPrimaryKey: false;
                                    name: string;
                                    notNull: false;
                                    tableName: "girasol_card_transaction";
                                },
                            >;
                            createdAt: PgBuildColumn<
                                "girasol_card_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: "girasol_card_transaction";
                                },
                            >;
                            currency: PgBuildColumn<
                                "girasol_card_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: "girasol_card_transaction";
                                },
                            >;
                            customerExternalId: PgBuildColumn<
                                "girasol_card_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: "girasol_card_transaction";
                                },
                            >;
                            customerId: PgBuildColumn<
                                "girasol_card_transaction",
                                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: "girasol_card_transaction";
                                },
                            >;
                            data: PgBuildColumn<
                                "girasol_card_transaction",
                                Set$Type<PgJsonbBuilder, { girasolEvent?: ...; merchant?: ... }>,
                                {
                                    data: { girasolEvent?: ...; merchant?: ... };
                                    dataType: "object json";
                                    driverParam: unknown;
                                    enumValues: undefined;
                                    generated: undefined;
                                    hasDefault: false;
                                    hasRuntimeDefault: false;
                                    identity: undefined;
                                    isAutoincrement: false;
                                    isPrimaryKey: false;
                                    name: string;
                                    notNull: false;
                                    tableName: "girasol_card_transaction";
                                },
                            >;
                            externalId: PgBuildColumn<
                                "girasol_card_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: "girasol_card_transaction";
                                },
                            >;
                            girasolCardExternalId: PgBuildColumn<
                                "girasol_card_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: "girasol_card_transaction";
                                },
                            >;
                            girasolCardId: PgBuildColumn<
                                "girasol_card_transaction",
                                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: "girasol_card_transaction";
                                },
                            >;
                            girasolTransactionId: PgBuildColumn<
                                "girasol_card_transaction",
                                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: "girasol_card_transaction";
                                },
                            >;
                            id: PgBuildColumn<
                                "girasol_card_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: "girasol_card_transaction";
                                },
                            >;
                            idempotencyKey: PgBuildColumn<
                                "girasol_card_transaction",
                                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: "girasol_card_transaction";
                                },
                            >;
                            originalGirasolTransactionId: PgBuildColumn<
                                "girasol_card_transaction",
                                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: "girasol_card_transaction";
                                },
                            >;
                            reason: PgBuildColumn<
                                "girasol_card_transaction",
                                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: "girasol_card_transaction";
                                },
                            >;
                            receipt: PgBuildColumn<
                                "girasol_card_transaction",
                                Set$Type<PgJsonbBuilder, { id: ...; type: ... }>,
                                {
                                    data: { id: ...; type: ... };
                                    dataType: "object json";
                                    driverParam: unknown;
                                    enumValues: undefined;
                                    generated: undefined;
                                    hasDefault: false;
                                    hasRuntimeDefault: false;
                                    identity: undefined;
                                    isAutoincrement: false;
                                    isPrimaryKey: false;
                                    name: string;
                                    notNull: false;
                                    tableName: "girasol_card_transaction";
                                },
                            >;
                            settlementLedgerAccountExternalId: PgBuildColumn<
                                "girasol_card_transaction",
                                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: "girasol_card_transaction";
                                },
                            >;
                            settlementLedgerAccountId: PgBuildColumn<
                                "girasol_card_transaction",
                                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: "girasol_card_transaction";
                                },
                            >;
                            status: PgBuildColumn<
                                "girasol_card_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: "girasol_card_transaction";
                                },
                            >;
                            statusReason: PgBuildColumn<
                                "girasol_card_transaction",
                                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: "girasol_card_transaction";
                                },
                            >;
                            type: PgBuildColumn<
                                "girasol_card_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: "girasol_card_transaction";
                                },
                            >;
                            updatedAt: PgBuildColumn<
                                "girasol_card_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: "girasol_card_transaction";
                                },
                            >;
                        };
                        dialect: "pg";
                        isAlias: false;
                        name: "girasol_card_transaction";
                        schema: "b2b";
                    },
                >,
                "enableRLS",
            >,
            "createdAt"
            | "updatedAt",
        >[];
        originalGirasolCardTransactionIds?: string[];
        page?: number;
        pageSize?: number;
        statuses?: (
            | "PENDING"
            | "FAILED"
            | "COMPLETED"
            | "PROCESSING"
            | "RETURNED"
            | "CANCELLED"
        )[];
        toDate?: Date;
        types?: ("authorization" | "notification" | "reversal" | "refund")[];
        uncleared?: boolean;
    }

    • OptionalcardIds?: string[]

    • OptionalcustomerId?: string

    • OptionalfromDate?: Date

    • OptionalgirasolCardTransactionIds?: string[]

    • OptionalidempotencyKeys?: string[]

    • Optionalids?: string[]

    • OptionalorderBy?: DbOrderByCriterion<
          Omit<
              PgTableWithColumns<
                  {
                      columns: {
                          amount: PgBuildColumn<
                              "girasol_card_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: "girasol_card_transaction";
                              },
                          >;
                          clearingData: PgBuildColumn<
                              "girasol_card_transaction",
                              Set$Type<
                                  PgJsonbBuilder,
                                  { amountAdjusted: ...; amountCleared: ...; receipt?: ...; type: ... },
                              >,
                              {
                                  data: {
                                      amountAdjusted: ...;
                                      amountCleared: ...;
                                      receipt?: ...;
                                      type: ...;
                                  };
                                  dataType: "object json";
                                  driverParam: unknown;
                                  enumValues: undefined;
                                  generated: undefined;
                                  hasDefault: false;
                                  hasRuntimeDefault: false;
                                  identity: undefined;
                                  isAutoincrement: false;
                                  isPrimaryKey: false;
                                  name: string;
                                  notNull: false;
                                  tableName: "girasol_card_transaction";
                              },
                          >;
                          createdAt: PgBuildColumn<
                              "girasol_card_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: "girasol_card_transaction";
                              },
                          >;
                          currency: PgBuildColumn<
                              "girasol_card_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: "girasol_card_transaction";
                              },
                          >;
                          customerExternalId: PgBuildColumn<
                              "girasol_card_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: "girasol_card_transaction";
                              },
                          >;
                          customerId: PgBuildColumn<
                              "girasol_card_transaction",
                              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: "girasol_card_transaction";
                              },
                          >;
                          data: PgBuildColumn<
                              "girasol_card_transaction",
                              Set$Type<PgJsonbBuilder, { girasolEvent?: ...; merchant?: ... }>,
                              {
                                  data: { girasolEvent?: ...; merchant?: ... };
                                  dataType: "object json";
                                  driverParam: unknown;
                                  enumValues: undefined;
                                  generated: undefined;
                                  hasDefault: false;
                                  hasRuntimeDefault: false;
                                  identity: undefined;
                                  isAutoincrement: false;
                                  isPrimaryKey: false;
                                  name: string;
                                  notNull: false;
                                  tableName: "girasol_card_transaction";
                              },
                          >;
                          externalId: PgBuildColumn<
                              "girasol_card_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: "girasol_card_transaction";
                              },
                          >;
                          girasolCardExternalId: PgBuildColumn<
                              "girasol_card_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: "girasol_card_transaction";
                              },
                          >;
                          girasolCardId: PgBuildColumn<
                              "girasol_card_transaction",
                              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: "girasol_card_transaction";
                              },
                          >;
                          girasolTransactionId: PgBuildColumn<
                              "girasol_card_transaction",
                              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: "girasol_card_transaction";
                              },
                          >;
                          id: PgBuildColumn<
                              "girasol_card_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: "girasol_card_transaction";
                              },
                          >;
                          idempotencyKey: PgBuildColumn<
                              "girasol_card_transaction",
                              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: "girasol_card_transaction";
                              },
                          >;
                          originalGirasolTransactionId: PgBuildColumn<
                              "girasol_card_transaction",
                              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: "girasol_card_transaction";
                              },
                          >;
                          reason: PgBuildColumn<
                              "girasol_card_transaction",
                              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: "girasol_card_transaction";
                              },
                          >;
                          receipt: PgBuildColumn<
                              "girasol_card_transaction",
                              Set$Type<PgJsonbBuilder, { id: ...; type: ... }>,
                              {
                                  data: { id: ...; type: ... };
                                  dataType: "object json";
                                  driverParam: unknown;
                                  enumValues: undefined;
                                  generated: undefined;
                                  hasDefault: false;
                                  hasRuntimeDefault: false;
                                  identity: undefined;
                                  isAutoincrement: false;
                                  isPrimaryKey: false;
                                  name: string;
                                  notNull: false;
                                  tableName: "girasol_card_transaction";
                              },
                          >;
                          settlementLedgerAccountExternalId: PgBuildColumn<
                              "girasol_card_transaction",
                              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: "girasol_card_transaction";
                              },
                          >;
                          settlementLedgerAccountId: PgBuildColumn<
                              "girasol_card_transaction",
                              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: "girasol_card_transaction";
                              },
                          >;
                          status: PgBuildColumn<
                              "girasol_card_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: "girasol_card_transaction";
                              },
                          >;
                          statusReason: PgBuildColumn<
                              "girasol_card_transaction",
                              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: "girasol_card_transaction";
                              },
                          >;
                          type: PgBuildColumn<
                              "girasol_card_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: "girasol_card_transaction";
                              },
                          >;
                          updatedAt: PgBuildColumn<
                              "girasol_card_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: "girasol_card_transaction";
                              },
                          >;
                      };
                      dialect: "pg";
                      isAlias: false;
                      name: "girasol_card_transaction";
                      schema: "b2b";
                  },
              >,
              "enableRLS",
          >,
          "createdAt"
          | "updatedAt",
      >[]

    • OptionaloriginalGirasolCardTransactionIds?: string[]

    • Optionalpage?: number

    • OptionalpageSize?: number

    • Optionalstatuses?: ("PENDING" | "FAILED" | "COMPLETED" | "PROCESSING" | "RETURNED" | "CANCELLED")[]

    • OptionaltoDate?: Date

    • Optionaltypes?: ("authorization" | "notification" | "reversal" | "refund")[]

    • Optionaluncleared?: boolean

      Only those with no clearing record.

  Returns Promise<
      {
          ok: true;
          value: {
              hasNext: boolean;
              items: (
                  {
                      amount: BigNumber;
                      clearing?: {
                          amountAdjusted: string;
                          amountCleared: string;
                          receipt?: { id: string; type: "SOLANA_TRANSACTION_SIGNATURE" };
                          type: "OVER_CLEARED" | "UNDER_CLEARED" | "MATCH";
                      };
                      clearingTypeDescription: string
                      | null;
                      createdAt: Date;
                      currency: string;
                      girasolTransactionId: string | null;
                      id: string;
                      merchant?: {
                          categoryCode?: string;
                          city?: string;
                          country?: string;
                          mcc: string;
                          name: string;
                      };
                      originalGirasolTransactionId: string
                      | null;
                      reason: string | null;
                      receipt?: { id: string; type: "SOLANA_TRANSACTION_SIGNATURE" };
                      status:
                          | "PENDING"
                          | "FAILED"
                          | "COMPLETED"
                          | "PROCESSING"
                          | "RETURNED"
                          | "CANCELLED";
                      statusDescription: string;
                      statusReason: GirasolCardTransactionStatusReason
                      | null;
                      type: "authorization" | "notification" | "reversal" | "refund";
                      typeDescription: string;
                      updatedAt: Date;
                  } & {
                      cardId: string;
                      customerId: string;
                      targetLedgerAccountId: string;
                  }
              )[];
              total: number;
          };
      },
  >