/
Recognition event records
  • Verified
  • Recognition event records

    Table of contents

    Description

    A recognition event is a type of accounting record representing follow-up actions that happen on other accounting records, such as line items, taxes, and fees. Common examples of events include:

    • Gift card redemption

    • Shipment of an e-commerce product

    • Delivery of a project milestone

    • Subscription pauses

    Recognition event records are displayed in Leapfin as follows:

    Recognition event record creation

    Leapfin captures the following standard and custom fields when creating recognition event records. These fields ensure that all necessary data is recorded as transactions flow in from your integrated payment service providers (PSPs), allowing you to make data-driven decisions and create precise accounting rules based on your accounting policies.

    While the tables below describe the general data fields that comprise this record type, there may be nuances based on your integrated PSP. For information on how these fields are mapped for each specific integration, see the Data section of the Help Center.

    Standard fields

    In Leapfin, each recognition event record is comprised of the following standard data fields:

    Standard fields

    Description

    Standard fields

    Description

    objectType

    The target accounting record. For example, the objectTypefor a recognition event record is recognition event.

    id

    The unique identifier for the record. This is an external id received by Leapfin from your payment processor.

    amount

    The amount impacted by the recognition event. This value should be non-negative and is the primary amount for this record.

    currencyCode

    The 3-digit ISO code of the amount field, such as USD or GBP. This code indicates the primary currency of this record.

    date

    The date and time the recognition event occurred.

    Optional fields

    Leapfin can also bring in the following optional fields to use for reporting, determining journal entry logic, and configuring specific journal entries:

    Custom fields

    Description

    Custom fields

    Description

    description

    A description of the recognition event and what it represents.

    exchangeRates

    A list of exchange rates used to calculate currency conversions. Each rate contains the following values:

    • currencyCode: The 3-digit ISO code of the amount field, such as USD or GBP. This code indicates the primary currency of this record.

    • rate: The conversion rate from primary currency to target currency (amount in primary currency * rate = converted amount in target currency).

    links

    The directional relationships that connect this record to other accounting records. Recognition event records are typically linked to line item records. Leapfin adds links with the following fields:

    • objectType: The target accounting record.

    • id: The unique identifier for this record.

    customFields

    The additional fields related to this record.

    { "objectType": "event", "id": "event_001", "amount": 15.32, "currencyCode": "USD", "date": "2021-03-03T12:09:52", "description": "a sample event object", "exchangeRates": [ { "currencyCode": "EUR", "rate": 0.84 }, { "currencyCode": "GBP", "rate": 0.73 } ], "links": [ { "objectType": "line-item", "id": "lineitem_001" }, { "objectType": "line-item", "id": "lineitem_002" } ], "customFields": { "field1": "value1", "field2": "value2" } }

    Query recognition event records in your data warehouse

    Recognition event records are stored in the VW_FT_RECOGNITION_EVENT data table of your connected data warehouse. Reference the following articles for detailed information on setting up your database and querying Recognition event records:

    Related content