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

    Owns deposit-quote-search. A quote write also busts deposit-search, held as a writer-only instance because single inheritance rules out extending both.

    Hierarchy (View Summary)

    Index
    cache: ServiceCache<CachedSearchPage<DepositQuote>>
    instance: (...args: []) => DepositQuoteService = ...

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

    • Moves the quote ACTIVE to ACCEPTED under a row lock, in the caller's tx. A quote already ACCEPTED is a retry (alreadyAccepted); any other status is refused. The caller calls invalidateClaimed after it commits.

      Parameters

      • args: { id: string; tx: PgAsyncTransaction }

      Returns Promise<
          | { ok: true; value: { alreadyAccepted: boolean } }
          | { error: ServiceError; ok: false },
      >

    • Parameters

      • __namedParameters: {
            aggregateQuote?: {
                fees: (
                    {
                        amount: BigNumber;
                        receiver: "CUSTOMER"
                        | "PROVIDER"
                        | "CFX";
                        type: "FIXED" | "VARIABLE";
                    } & { currency: string }
                )[];
                sourceAmount: BigNumber;
                sourceAmountAfterFees: BigNumber;
                sourceCurrency: string;
                targetAmount: BigNumber;
                targetAmountAfterFees: BigNumber;
                targetCurrency: string;
            };
            customerId: string;
            data?: | {
                address?: string;
                barcodeNumber: string;
                barcodeStatus: | "EXPIRED"
                | "PENDING"
                | "DECLINED"
                | "CANCELLED"
                | "CONSUMED"
                | "CREATED"
                | "VOIDED";
                expiresAt: string;
                firstName: string;
                greendotId: string
                | null;
                lastName: string;
                phone?: string;
                retailerId: string;
                retailerName: string;
                targetCurrency?: "MOVEUSD" | "USDC";
                zipcode: string;
            }
            | {
                ffc_memo?: string;
                imad?: string;
                omad?: string;
                originating_fi?: string;
                originator_address_line1?: string;
                originator_address_line2?: string;
                originator_address_line3?: string;
                originator_info?: string;
                sender_name?: string;
                sending_fi?: { code: string; name: string };
            }
            | {
                achBatchId?: string;
                achId: string;
                bankId?: string;
                routeFusionIncomingTransferId?: string;
                sourcePaymentInstrumentId: string;
                speed?: string;
                vendorId?: string;
                victorTransactionId?: string;
            }
            | { providerId?: string; providerTransactionId?: string }
            | { ffcMemo?: string }
            | {
                achId?: string;
                achTraceId?: string;
                addenda?: string;
                companyDiscretionaryData?: string;
                companyEntryDescription?: string;
                companyId?: string;
                companyName?: string;
                effectiveEntryDate?: string;
                ffcMemo?: string;
                secCode?: string;
                senderName?: string;
                settlementDate?: string;
                vendorId?: string;
            }
            | { ffcMemo?: string; senderName?: string; tchInstitutionId?: string }
            | { ffcMemo?: string; institutionId?: string; senderName?: string }
            | null;
            deviceIpAddress: string | null;
            deviceLocation?: { lat: number; long: number; source: "ip" };
            entityId: string;
            metadata: {
                brand?: string;
                marketing?:
                    | EmptyObject
                    | {
                        fbp?: string;
                        gclid?: string;
                        sub1?: string;
                        sub2?: string;
                        sub3?: string;
                        userAgent?: string;
                        utmCampaign?: string;
                        utmContent?: string;
                        utmMedium?: string;
                        utmSource?: string;
                    };
            };
            productQuoteId: string;
            quote?: {
                fees: (
                    {
                        amount: BigNumber;
                        receiver: "CUSTOMER"
                        | "PROVIDER"
                        | "CFX";
                        type: "FIXED" | "VARIABLE";
                    } & { currency: string }
                )[];
                sourceAmount: BigNumber;
                sourceAmountAfterFees: BigNumber;
                sourceCurrency: string;
                targetAmount: BigNumber;
                targetAmountAfterFees: BigNumber;
                targetCurrency: string;
            };
            reference: string;
            type: | "CASH"
            | "ACH_CREDIT"
            | "RTP"
            | "FEDNOW"
            | "US_WIRE"
            | "US_BANK_ACH"
            | "SWIFT_WIRE";
            walletAddress: Address;
            walletBlockchain: string;
        } & {
            idempotencyKey?: string;
            productQuoteId: string;
            tx?: PgAsyncTransaction<NodePgQueryResultHKT, EmptyRelations>;
        }
        • OptionalaggregateQuote?: {
              fees: (
                  {
                      amount: BigNumber;
                      receiver: "CUSTOMER"
                      | "PROVIDER"
                      | "CFX";
                      type: "FIXED" | "VARIABLE";
                  } & { currency: string }
              )[];
              sourceAmount: BigNumber;
              sourceAmountAfterFees: BigNumber;
              sourceCurrency: string;
              targetAmount: BigNumber;
              targetAmountAfterFees: BigNumber;
              targetCurrency: string;
          }
        • customerId: string
        • Optionaldata?:
              | {
                  address?: string;
                  barcodeNumber: string;
                  barcodeStatus: | "EXPIRED"
                  | "PENDING"
                  | "DECLINED"
                  | "CANCELLED"
                  | "CONSUMED"
                  | "CREATED"
                  | "VOIDED";
                  expiresAt: string;
                  firstName: string;
                  greendotId: string
                  | null;
                  lastName: string;
                  phone?: string;
                  retailerId: string;
                  retailerName: string;
                  targetCurrency?: "MOVEUSD" | "USDC";
                  zipcode: string;
              }
              | {
                  ffc_memo?: string;
                  imad?: string;
                  omad?: string;
                  originating_fi?: string;
                  originator_address_line1?: string;
                  originator_address_line2?: string;
                  originator_address_line3?: string;
                  originator_info?: string;
                  sender_name?: string;
                  sending_fi?: { code: string; name: string };
              }
              | {
                  achBatchId?: string;
                  achId: string;
                  bankId?: string;
                  routeFusionIncomingTransferId?: string;
                  sourcePaymentInstrumentId: string;
                  speed?: string;
                  vendorId?: string;
                  victorTransactionId?: string;
              }
              | { providerId?: string; providerTransactionId?: string }
              | { ffcMemo?: string }
              | {
                  achId?: string;
                  achTraceId?: string;
                  addenda?: string;
                  companyDiscretionaryData?: string;
                  companyEntryDescription?: string;
                  companyId?: string;
                  companyName?: string;
                  effectiveEntryDate?: string;
                  ffcMemo?: string;
                  secCode?: string;
                  senderName?: string;
                  settlementDate?: string;
                  vendorId?: string;
              }
              | { ffcMemo?: string; senderName?: string; tchInstitutionId?: string }
              | { ffcMemo?: string; institutionId?: string; senderName?: string }
              | null

          this is the underlying db representation, don't use this by default

        • deviceIpAddress: string | null
        • OptionaldeviceLocation?: { lat: number; long: number; source: "ip" }
        • entityId: string
        • metadata: {
              brand?: string;
              marketing?:
                  | EmptyObject
                  | {
                      fbp?: string;
                      gclid?: string;
                      sub1?: string;
                      sub2?: string;
                      sub3?: string;
                      userAgent?: string;
                      utmCampaign?: string;
                      utmContent?: string;
                      utmMedium?: string;
                      utmSource?: string;
                  };
          }
        • productQuoteId: string

          External id (pq_...) of the engine-quote audit row that produced this deposit quote. Always populated — every deposit quote is now created via productQuoteService.quote(). Used by per-rail accept() methods to stamp accepted_at on the engine-quote row.

        • Optionalquote?: {
              fees: (
                  {
                      amount: BigNumber;
                      receiver: "CUSTOMER"
                      | "PROVIDER"
                      | "CFX";
                      type: "FIXED" | "VARIABLE";
                  } & { currency: string }
              )[];
              sourceAmount: BigNumber;
              sourceAmountAfterFees: BigNumber;
              sourceCurrency: string;
              targetAmount: BigNumber;
              targetAmountAfterFees: BigNumber;
              targetCurrency: string;
          }
        • reference: string
        • type:
              | "CASH"
              | "ACH_CREDIT"
              | "RTP"
              | "FEDNOW"
              | "US_WIRE"
              | "US_BANK_ACH"
              | "SWIFT_WIRE"
        • walletAddress: Address
        • walletBlockchain: string
        • OptionalidempotencyKey?: string

          Caller-supplied idempotency key (from the API Idempotency-Key header). When set, a repeated key returns the existing deposit quote instead of inserting a new one; dedup is enforced by the partial unique index deposit_quote_idempotency_idx.

        • productQuoteId: string
        • Optionaltx?: PgAsyncTransaction<NodePgQueryResultHKT, EmptyRelations>

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

    • Parameters

      • args: {
            customerId: string;
            id: string;
            tx?: PgAsyncTransaction<NodePgQueryResultHKT, EmptyRelations>;
        }

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

    • Clear each customer's membership tag and each record tag wherever cached, and always this namespace's collection tag. keys are exact deletes in this instance's key space: the only bust a null client honours.

      Parameters

      • __namedParameters: {
            customerIds: readonly string[];
            keys?: readonly CacheKey[];
            records?: readonly string[];
        }

      Returns Promise<void>

    • Moves an ACTIVE quote to REJECTED under a row lock. A quote already REJECTED is a retry; any other status is refused with it.

      Parameters

      • args: { customerId: string; id: string }

      Returns Promise<
          | { ok: true; value: DepositQuote }
          | {
              error:
                  | ServiceError<"QUOTE_NOT_FOUND">
                  | ServiceError<
                      "QUOTE_NOT_ACTIVE",
                      { status: "ACTIVE"
                      | "EXPIRED"
                      | "ACCEPTED"
                      | "REJECTED" },
                  >;
              ok: false;
          },
      >

    • Parameters

      • __namedParameters: {
            cashDepositBarcodeStatuses?: (
                | "EXPIRED"
                | "PENDING"
                | "DECLINED"
                | "CANCELLED"
                | "CONSUMED"
                | "CREATED"
                | "VOIDED"
            )[];
            createdAt?: DbTimestampCriteria;
            customerId: string;
            entityIds?: string[];
            idempotencyKeys?: string[];
            ids?: string[];
            orderBy?: DbOrderByCriterion<
                Omit<
                    PgTableWithColumns<
                        {
                            columns: {
                                achBatchExternalId: PgBuildColumn<
                                    "deposit_quote",
                                    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: "deposit_quote";
                                    },
                                >;
                                achBatchId: PgBuildColumn<
                                    "deposit_quote",
                                    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: "deposit_quote";
                                    },
                                >;
                                barcodeNumber: PgBuildColumn<
                                    "deposit_quote",
                                    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: "deposit_quote";
                                    },
                                >;
                                createdAt: PgBuildColumn<
                                    "deposit_quote",
                                    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: "deposit_quote";
                                    },
                                >;
                                customerExternalId: PgBuildColumn<
                                    "deposit_quote",
                                    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: "deposit_quote";
                                    },
                                >;
                                customerId: PgBuildColumn<
                                    "deposit_quote",
                                    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: "deposit_quote";
                                    },
                                >;
                                data: PgBuildColumn<
                                    "deposit_quote",
                                    Set$Type<
                                        PgJsonbBuilder,
                                        (...)
                                        | (...)
                                        | (...)
                                        | (...)
                                        | (...)
                                        | (...)
                                        | (...)
                                        | (...),
                                    >,
                                    {
                                        data:
                                            | (...)
                                            | (...)
                                            | (...)
                                            | (...)
                                            | (...)
                                            | (...)
                                            | (...)
                                            | (...);
                                        dataType: "object json";
                                        driverParam: unknown;
                                        enumValues: undefined;
                                        generated: undefined;
                                        hasDefault: false;
                                        hasRuntimeDefault: false;
                                        identity: undefined;
                                        isAutoincrement: false;
                                        isPrimaryKey: false;
                                        name: string;
                                        notNull: false;
                                        tableName: "deposit_quote";
                                    },
                                >;
                                deviceIpAddress: PgBuildColumn<
                                    "deposit_quote",
                                    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: "deposit_quote";
                                    },
                                >;
                                deviceLocation: PgBuildColumn<
                                    "deposit_quote",
                                    Set$Type<PgJsonbBuilder, (...) | (...)>,
                                    {
                                        data: (...) | (...);
                                        dataType: "object json";
                                        driverParam: unknown;
                                        enumValues: undefined;
                                        generated: undefined;
                                        hasDefault: false;
                                        hasRuntimeDefault: false;
                                        identity: undefined;
                                        isAutoincrement: false;
                                        isPrimaryKey: false;
                                        name: string;
                                        notNull: false;
                                        tableName: "deposit_quote";
                                    },
                                >;
                                externalId: PgBuildColumn<
                                    "deposit_quote",
                                    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: "deposit_quote";
                                    },
                                >;
                                id: PgBuildColumn<
                                    "deposit_quote",
                                    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: "deposit_quote";
                                    },
                                >;
                                idempotencyKey: PgBuildColumn<
                                    "deposit_quote",
                                    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: "deposit_quote";
                                    },
                                >;
                                identityExternalId: PgBuildColumn<
                                    "deposit_quote",
                                    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: "deposit_quote";
                                    },
                                >;
                                identityId: PgBuildColumn<
                                    "deposit_quote",
                                    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: "deposit_quote";
                                    },
                                >;
                                metadata: PgBuildColumn<
                                    "deposit_quote",
                                    Set$Type<SetHasDefault<(...)>, { brand?: ...; marketing?: ... }>,
                                    {
                                        data: { brand?: ...; marketing?: ... };
                                        dataType: "object json";
                                        driverParam: unknown;
                                        enumValues: undefined;
                                        generated: undefined;
                                        hasDefault: true;
                                        hasRuntimeDefault: false;
                                        identity: undefined;
                                        isAutoincrement: false;
                                        isPrimaryKey: false;
                                        name: string;
                                        notNull: true;
                                        tableName: "deposit_quote";
                                    },
                                >;
                                organizationExternalId: PgBuildColumn<
                                    "deposit_quote",
                                    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: "deposit_quote";
                                    },
                                >;
                                organizationId: PgBuildColumn<
                                    "deposit_quote",
                                    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: "deposit_quote";
                                    },
                                >;
                                productQuoteExternalId: PgBuildColumn<
                                    "deposit_quote",
                                    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: "deposit_quote";
                                    },
                                >;
                                productQuoteId: PgBuildColumn<
                                    "deposit_quote",
                                    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: "deposit_quote";
                                    },
                                >;
                                quote: PgBuildColumn<
                                    "deposit_quote",
                                    Set$Type<PgJsonbBuilder, (...) | (...)>,
                                    {
                                        data: (...) | (...);
                                        dataType: "object json";
                                        driverParam: unknown;
                                        enumValues: undefined;
                                        generated: undefined;
                                        hasDefault: false;
                                        hasRuntimeDefault: false;
                                        identity: undefined;
                                        isAutoincrement: false;
                                        isPrimaryKey: false;
                                        name: string;
                                        notNull: false;
                                        tableName: "deposit_quote";
                                    },
                                >;
                                reference: PgBuildColumn<
                                    "deposit_quote",
                                    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: "deposit_quote";
                                    },
                                >;
                                sourcePaymentInstrumentExternalId: PgBuildColumn<
                                    "deposit_quote",
                                    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: "deposit_quote";
                                    },
                                >;
                                sourcePaymentInstrumentId: PgBuildColumn<
                                    "deposit_quote",
                                    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: "deposit_quote";
                                    },
                                >;
                                status: PgBuildColumn<
                                    "deposit_quote",
                                    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: "deposit_quote";
                                    },
                                >;
                                type: PgBuildColumn<
                                    "deposit_quote",
                                    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: "deposit_quote";
                                    },
                                >;
                                updatedAt: PgBuildColumn<
                                    "deposit_quote",
                                    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: "deposit_quote";
                                    },
                                >;
                                walletAddress: PgBuildColumn<
                                    "deposit_quote",
                                    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: "deposit_quote";
                                    },
                                >;
                                walletChainExternalId: PgBuildColumn<
                                    "deposit_quote",
                                    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: "deposit_quote";
                                    },
                                >;
                                walletChainId: PgBuildColumn<
                                    "deposit_quote",
                                    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: "deposit_quote";
                                    },
                                >;
                            };
                            dialect: "pg";
                            isAlias: false;
                            name: "deposit_quote";
                            schema: "b2b";
                        },
                    >,
                    "enableRLS",
                >,
                "createdAt"
                | "updatedAt",
            >[];
            page?: number;
            pageSize?: number;
            references?: string[];
            tx?: PgAsyncTransaction<NodePgQueryResultHKT, EmptyRelations>;
            types?: (
                | "CASH"
                | "ACH_CREDIT"
                | "RTP"
                | "FEDNOW"
                | "US_WIRE"
                | "US_BANK_ACH"
                | "SWIFT_WIRE"
            )[];
            updatedAt?: DbTimestampCriteria;
        }
        • OptionalcashDepositBarcodeStatuses?: (
              | "EXPIRED"
              | "PENDING"
              | "DECLINED"
              | "CANCELLED"
              | "CONSUMED"
              | "CREATED"
              | "VOIDED"
          )[]
        • OptionalcreatedAt?: DbTimestampCriteria
        • customerId: string
        • OptionalentityIds?: string[]
        • OptionalidempotencyKeys?: string[]

          Caller-supplied idempotency keys (dedup lookup). Filters the raw deposit_quote.idempotency_key column — the key is not projected onto the returned DepositQuote.

        • Optionalids?: string[]
        • OptionalorderBy?: DbOrderByCriterion<
              Omit<
                  PgTableWithColumns<
                      {
                          columns: {
                              achBatchExternalId: PgBuildColumn<
                                  "deposit_quote",
                                  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: "deposit_quote";
                                  },
                              >;
                              achBatchId: PgBuildColumn<
                                  "deposit_quote",
                                  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: "deposit_quote";
                                  },
                              >;
                              barcodeNumber: PgBuildColumn<
                                  "deposit_quote",
                                  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: "deposit_quote";
                                  },
                              >;
                              createdAt: PgBuildColumn<
                                  "deposit_quote",
                                  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: "deposit_quote";
                                  },
                              >;
                              customerExternalId: PgBuildColumn<
                                  "deposit_quote",
                                  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: "deposit_quote";
                                  },
                              >;
                              customerId: PgBuildColumn<
                                  "deposit_quote",
                                  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: "deposit_quote";
                                  },
                              >;
                              data: PgBuildColumn<
                                  "deposit_quote",
                                  Set$Type<
                                      PgJsonbBuilder,
                                      (...)
                                      | (...)
                                      | (...)
                                      | (...)
                                      | (...)
                                      | (...)
                                      | (...)
                                      | (...),
                                  >,
                                  {
                                      data:
                                          | (...)
                                          | (...)
                                          | (...)
                                          | (...)
                                          | (...)
                                          | (...)
                                          | (...)
                                          | (...);
                                      dataType: "object json";
                                      driverParam: unknown;
                                      enumValues: undefined;
                                      generated: undefined;
                                      hasDefault: false;
                                      hasRuntimeDefault: false;
                                      identity: undefined;
                                      isAutoincrement: false;
                                      isPrimaryKey: false;
                                      name: string;
                                      notNull: false;
                                      tableName: "deposit_quote";
                                  },
                              >;
                              deviceIpAddress: PgBuildColumn<
                                  "deposit_quote",
                                  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: "deposit_quote";
                                  },
                              >;
                              deviceLocation: PgBuildColumn<
                                  "deposit_quote",
                                  Set$Type<PgJsonbBuilder, (...) | (...)>,
                                  {
                                      data: (...) | (...);
                                      dataType: "object json";
                                      driverParam: unknown;
                                      enumValues: undefined;
                                      generated: undefined;
                                      hasDefault: false;
                                      hasRuntimeDefault: false;
                                      identity: undefined;
                                      isAutoincrement: false;
                                      isPrimaryKey: false;
                                      name: string;
                                      notNull: false;
                                      tableName: "deposit_quote";
                                  },
                              >;
                              externalId: PgBuildColumn<
                                  "deposit_quote",
                                  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: "deposit_quote";
                                  },
                              >;
                              id: PgBuildColumn<
                                  "deposit_quote",
                                  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: "deposit_quote";
                                  },
                              >;
                              idempotencyKey: PgBuildColumn<
                                  "deposit_quote",
                                  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: "deposit_quote";
                                  },
                              >;
                              identityExternalId: PgBuildColumn<
                                  "deposit_quote",
                                  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: "deposit_quote";
                                  },
                              >;
                              identityId: PgBuildColumn<
                                  "deposit_quote",
                                  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: "deposit_quote";
                                  },
                              >;
                              metadata: PgBuildColumn<
                                  "deposit_quote",
                                  Set$Type<SetHasDefault<(...)>, { brand?: ...; marketing?: ... }>,
                                  {
                                      data: { brand?: ...; marketing?: ... };
                                      dataType: "object json";
                                      driverParam: unknown;
                                      enumValues: undefined;
                                      generated: undefined;
                                      hasDefault: true;
                                      hasRuntimeDefault: false;
                                      identity: undefined;
                                      isAutoincrement: false;
                                      isPrimaryKey: false;
                                      name: string;
                                      notNull: true;
                                      tableName: "deposit_quote";
                                  },
                              >;
                              organizationExternalId: PgBuildColumn<
                                  "deposit_quote",
                                  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: "deposit_quote";
                                  },
                              >;
                              organizationId: PgBuildColumn<
                                  "deposit_quote",
                                  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: "deposit_quote";
                                  },
                              >;
                              productQuoteExternalId: PgBuildColumn<
                                  "deposit_quote",
                                  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: "deposit_quote";
                                  },
                              >;
                              productQuoteId: PgBuildColumn<
                                  "deposit_quote",
                                  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: "deposit_quote";
                                  },
                              >;
                              quote: PgBuildColumn<
                                  "deposit_quote",
                                  Set$Type<PgJsonbBuilder, (...) | (...)>,
                                  {
                                      data: (...) | (...);
                                      dataType: "object json";
                                      driverParam: unknown;
                                      enumValues: undefined;
                                      generated: undefined;
                                      hasDefault: false;
                                      hasRuntimeDefault: false;
                                      identity: undefined;
                                      isAutoincrement: false;
                                      isPrimaryKey: false;
                                      name: string;
                                      notNull: false;
                                      tableName: "deposit_quote";
                                  },
                              >;
                              reference: PgBuildColumn<
                                  "deposit_quote",
                                  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: "deposit_quote";
                                  },
                              >;
                              sourcePaymentInstrumentExternalId: PgBuildColumn<
                                  "deposit_quote",
                                  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: "deposit_quote";
                                  },
                              >;
                              sourcePaymentInstrumentId: PgBuildColumn<
                                  "deposit_quote",
                                  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: "deposit_quote";
                                  },
                              >;
                              status: PgBuildColumn<
                                  "deposit_quote",
                                  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: "deposit_quote";
                                  },
                              >;
                              type: PgBuildColumn<
                                  "deposit_quote",
                                  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: "deposit_quote";
                                  },
                              >;
                              updatedAt: PgBuildColumn<
                                  "deposit_quote",
                                  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: "deposit_quote";
                                  },
                              >;
                              walletAddress: PgBuildColumn<
                                  "deposit_quote",
                                  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: "deposit_quote";
                                  },
                              >;
                              walletChainExternalId: PgBuildColumn<
                                  "deposit_quote",
                                  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: "deposit_quote";
                                  },
                              >;
                              walletChainId: PgBuildColumn<
                                  "deposit_quote",
                                  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: "deposit_quote";
                                  },
                              >;
                          };
                          dialect: "pg";
                          isAlias: false;
                          name: "deposit_quote";
                          schema: "b2b";
                      },
                  >,
                  "enableRLS",
              >,
              "createdAt"
              | "updatedAt",
          >[]
        • Optionalpage?: number
        • OptionalpageSize?: number
        • Optionalreferences?: string[]
        • Optionaltx?: PgAsyncTransaction<NodePgQueryResultHKT, EmptyRelations>
        • Optionaltypes?: (
              | "CASH"
              | "ACH_CREDIT"
              | "RTP"
              | "FEDNOW"
              | "US_WIRE"
              | "US_BANK_ACH"
              | "SWIFT_WIRE"
          )[]
        • OptionalupdatedAt?: DbTimestampCriteria

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

    • Tags for a page: the scope its query searched (each customer's membership tag, else the collection tag), so an empty page is bustable too, plus the records it projects and the fields that chose or ordered its rows.

      Parameters

      • __namedParameters: {
            customerIds: readonly string[] | undefined;
            fields?: readonly string[];
            records?: readonly string[];
        }

      Returns string[]

    • Parameters

      • args: {
            customerId: string;
            data: Partial<
                (
                    | {
                        address?: string;
                        barcodeNumber: string;
                        barcodeStatus: | "EXPIRED"
                        | "PENDING"
                        | "DECLINED"
                        | "CANCELLED"
                        | "CONSUMED"
                        | "CREATED"
                        | "VOIDED";
                        expiresAt: string;
                        firstName: string;
                        greendotId: string
                        | null;
                        lastName: string;
                        phone?: string;
                        retailerId: string;
                        retailerName: string;
                        targetCurrency?: "MOVEUSD" | "USDC";
                        zipcode: string;
                    }
                    | {
                        ffc_memo?: string;
                        imad?: string;
                        omad?: string;
                        originating_fi?: string;
                        originator_address_line1?: string;
                        originator_address_line2?: string;
                        originator_address_line3?: string;
                        originator_info?: string;
                        sender_name?: string;
                        sending_fi?: { code: string; name: string };
                    }
                    | {
                        achBatchId?: string;
                        achId: string;
                        bankId?: string;
                        routeFusionIncomingTransferId?: string;
                        sourcePaymentInstrumentId: string;
                        speed?: string;
                        vendorId?: string;
                        victorTransactionId?: string;
                    }
                    | { providerId?: string; providerTransactionId?: string }
                    | { ffcMemo?: string }
                    | {
                        achId?: string;
                        achTraceId?: string;
                        addenda?: string;
                        companyDiscretionaryData?: string;
                        companyEntryDescription?: string;
                        companyId?: string;
                        companyName?: string;
                        effectiveEntryDate?: string;
                        ffcMemo?: string;
                        secCode?: string;
                        senderName?: string;
                        settlementDate?: string;
                        vendorId?: string;
                    }
                    | { ffcMemo?: string; senderName?: string; tchInstitutionId?: string }
                    | { ffcMemo?: string; institutionId?: string; senderName?: string }
                    | null
                    | undefined
                ) & { status?: "ACTIVE" | "EXPIRED" | "ACCEPTED" | "REJECTED" },
            >;
            id: string;
            tx?: PgAsyncTransaction<NodePgQueryResultHKT, EmptyRelations>;
        }

      Returns Promise<DepositQuote>