Overview

Event is a type of financial records representing follow-up actions that happen on other financial records, such as Line Item, Tax, etc. Common examples of Events:

  • redemption of a gift card
  • shipment of an e-commerce product
  • delivery of a project milestone
  • pause during subscription period

Create an Event

The following fields are required :

  • objectType: type of financial record. For Event, the value is "event".
  • id: unique identifier of this record. This is an external id received by Leapfin.
  • amount: amount of money impacted by this Event. The value should be non-negative. This is the primary amount of this record.
  • currencyCode: 3-digit ISO code of amount field, e.g. “USD”, "GBP", etc. This is the primary currency of this record
  • date: the date-time of when this Event happened

The following fields are optional but are commonly needed for creating journal entries.

  • description: description of the record. Use this field to explain what the Event represents.
  • exchangeRates: a list of exchange rates used to calculate currency conversions
    • currencyCode: 3-digit ISO code, e.g. “USD”, "GBP", etc. This is the target currency of this record
    • rate: conversion rate from primary currency to target currency. i.e. amount in primary currency * rate = converted amount in target currency.
  • links: directional relationships pointing from this record to other financial records. Event is commonly linked to Line Item.
    • objectType: type of the target financial record, e.g. "line-item"
    • id: unique identifier of the target financial record
  • customFields: additional fields (i.e. key-value pairs) related to this record

Sample Data

{
    "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 an Event

Event records are stored in VW_FT_RECOGNITION_EVENT table. It can be accessed via Snowflake Data Sharing and Access.

ColumnDescription
LEAPFIN_IDunique identifier created by Leapfin.
DECODED_LEAPFIN_ID_VTdecoded version of LEAPFIN_ID in JSON format. It contains the following values:

- external_code: unique identifier of this record. This is an external id received by Leapfin.
- integration_id: unique identifier of the data source. This is an internal id created by Leapfin.
- leapfin_data_type: type of financial record, i.e. "LeapfinRecognitionEvent"
- leapfin_suffix: additional string to distinguish different financial records when the same external_code is received from the data source.
- raw_data_type: type of raw data record received from the data source.
ORGANIZATION_IDunique identifier of the account. This is an internal id created by Leapfin.
DATE_DTthe date of when this Event happened.
CURRENCY_CODE3-digit ISO code of amount field, e.g. “USD”, "GBP", etc. This is the primary currency of this record.
AMOUNTamount of money impacted by this Event. The value should be non-negative. This is the primary amount of this record.
EXCHANGE_RATES_VTa list of exchange rates used to calculate currency conversions. Each rate contains the following values:

- currencyCode: 3-digit ISO code, e.g. “USD”, "GBP", etc. This is the target currency of this record.
- rate: conversion rate from primary currency to target currency. i.e. amount in primary currency * rate = converted amount in target currency.
CUSTOM_FIELDS_VTadditional fields (i.e. key-value pairs) about the financial record in json format
ACCOUNTING_TRANSACTIONS_VTa list of journal entries associated with this financial record. Each item contains the following values:

- date: the date of the journal entry
- entries: a list of journal lines within the journal entry. Each line contains the following values:
--- account: unique identifier of the financial account. This is an internal id created by Leapfin (refer to VW_LK_ACCOUNT).
--- amount: amount of money booked towards the account.
--- accountingSide: an indicator of whether the amount is a debt ("dr") or credit ("cr") to the acount.
- comments: additional fields (i.e. key-value pairs) on the journal entry in JSON format.
CREATED_AT_DTthe date-time when the financial record is created by Leapfin. Value format: "2022-07-14 23:01:26.400"
UPDATED_AT_DTthe date-time when the financial record is last updated by Leapfin. Value format: "2022-09-01 06:09:57.379"