Examples: query, "exact match", wildcard*, wild?ard, wild*rd
Fuzzy search: cake~ (finds cakes, bake)
Term boost: "red velvet"^4, chocolate^2
Field grouping: tags:(+work -"fun-stuff")
Escape special characters +-&|!(){}[]^"~*?:\ - e.g. \+ \* \!
Range search: properties.timestamp:[1587729413488 TO *] (inclusive), properties.title:{A TO Z}(excluding A and Z)
Combinations: chocolate AND vanilla, chocolate OR vanilla, (chocolate OR vanilla) NOT "vanilla pudding"
Field search: properties.title:"The Title" AND text
 
Answered
Transaction fields

What field tells you if a transaction is a deposit or a withdrawal?

WWhat is the difference between SignedTxnAmount and TxnAmount?

What OfxTrnTypes are there? Just credit or debit?

Also what do the numbers 14633 and 1042 represent in the reponse for getHistory https://docs.q2api.com/docs/q2-caliper-api/c8d410579d01e-get-history?

Screenshot 2023-06-28 at 10.49.50 AM.png Screenshot 2023-06-28 at 3.13.31 PM.png

Votes Newest

Answers


Hi Draden,

  1. What field tells you if a transaction is a deposit or a withdrawal?
    Please refer to the list provided for OfxTrnTypes.

  2. What is the difference between SignedTxnAmount and TxnAmount?
    Signed in SignedTxnAmount refers to signed integers, which can be either positive or negative. TxnAmount is unsigned and therefore always positive.

  3. What OfxTrnTypes are there? Just credit or debit?

    List of OfxTrnTypes:
    CREDIT
    DEBIT
    INT (interest earned)
    DIV (dividend)
    FEE (FI fee)
    SRVCHG (Service charge),
    DEP (Deposit)
    ATM
    POS (Point of Sale)
    XFER (Transfer),
    CHECK
    PAYMENT (Electronic payment)
    CASH (Cash deposit),
    DIRECTDEP (Direct deposit)
    DIRECTDEBIT (Merchant initiated debit),
    REPEATPMT (repeating payment/standing order)
    OTHER

  4. what do the numbers 14633 and 1042 represent in the reponse for getHistory
    These refer to the ID of the account you are passing into the request (haid)

  • Solène
Posted 3 years ago