Event
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 ofamount
field, e.g. “USD”, "GBP", etc. This is the primary currency of this recorddate
: 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 conversionscurrencyCode
: 3-digit ISO code, e.g. “USD”, "GBP", etc. This is the target currency of this recordrate
: 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.
Column | Description |
---|---|
LEAPFIN_ID | unique identifier created by Leapfin. |
DECODED_LEAPFIN_ID_VT | decoded 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_ID | unique identifier of the account. This is an internal id created by Leapfin. |
DATE_DT | the date of when this Event happened. |
CURRENCY_CODE | 3-digit ISO code of amount field, e.g. “USD”, "GBP", etc. This is the primary currency of this record. |
AMOUNT | amount of money impacted by this Event. The value should be non-negative. This is the primary amount of this record. |
EXCHANGE_RATES_VT | a 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_VT | additional fields (i.e. key-value pairs) about the financial record in json format |
ACCOUNTING_TRANSACTIONS_VT | a 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_DT | the date-time when the financial record is created by Leapfin. Value format: "2022-07-14 23:01:26.400" |
UPDATED_AT_DT | the date-time when the financial record is last updated by Leapfin. Value format: "2022-09-01 06:09:57.379" |
Updated 11 months ago