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

    A row of b2b.bank_transaction_reconcile_queue_view.

    type UnreconciledBankTransaction = {
        accountName: string | null;
        accountNumber: string;
        accountType: string | null;
        ageDays: number;
        amount: string;
        bankId: BankId;
        createdAt: Date;
        customerId: string | null;
        customerName: string | null;
        description: string;
        entityId: string | null;
        entityName: string | null;
        feedSource: BankTransactionRawSource | null;
        id: string;
        ledgerAccountId: string | null;
        postedAt: Date;
        routingNumber: string;
        statementDescription: string;
        type: "CREDIT" | "DEBIT";
    }
    Index
    accountName: string | null
    accountNumber: string
    accountType: string | null
    ageDays: number
    amount: string

    Kept as the numeric string the column holds, matching BankTransaction. amount. Nothing here does arithmetic on it — this is a work queue, not a ledger.

    bankId: BankId
    createdAt: Date
    customerId: string | null
    customerName: string | null
    description: string
    entityId: string | null
    entityName: string | null
    feedSource: BankTransactionRawSource | null
    id: string

    bank_transaction.external_id — what the reconciliation workflow keys on.

    ledgerAccountId: string | null
    postedAt: Date
    routingNumber: string
    statementDescription: string
    type: "CREDIT" | "DEBIT"