The daily journal line view consolidates all journal entries across all financial records on Leapfin Platform. Each line of this view represents a daily journal line.
The daily JL view is commonly used as the base for aggregated JE reports, such as loading JE data to Netsuite. Journal entries can be easily grouped and aggregated across financial records.
Daily journal lines are stored in
VW_AG_JOURNAL_ENTRY table. It can be accessed via Snowflake Data Sharing and Access.
|LEAPFIN_ID||unique identifier created by Leapfin|
|LEAPFIN_DATA_TYPE||type of financial record, i.e. "LeapfinLineItem", "LeapfinInvoice", etc. (see full list under "Financial Data Records" section)|
|DECODED_LEAPFIN_ID_VT||decoded version of LEAPFIN_ID in json format. It contains the following values:|
|ORGANIZATION_ID||unique identifier of the account. This is an internal id created by Leapfin.|
|DATA_VT||all data fields of this financial record in json format.|
|DATE_DT||the book date of the journal entry. Value format "2022-01-31"|
|DOCUMENT_DATE_DT||the date when this financial record is created in external systems outside Leapfin. Value format "2022-01-31"|
|PRODUCT_NAME||the name of the product associated with the financial record.|
|CURRENCY_CODE||3-digit ISO code of |
|CUSTOM_FIELD_VT||additional fields (i.e. key-value pairs) about the financial record in JSON format|
|ACCOUNT||the unique identifier of ledger account impacted by this journal line. To get the account name and other details, this |
|ACCOUNTING_SIDE||the booking direction of the journal line. Acceptable values are "dr" and "cr".|
|JE_PAIR_VT||the journal entry that contains this journal lines. (refer "Journal entry" section for exact data structure)|
|AMOUNT||the amount of the journal line. A positive number means that the booking direction of the journal line (e.g. "dr") matches with the increasing side of the ledger account (e.g. "dr"). A negative number means the booking direction (e.g. "cr") differs from the account side (e.g. "dr")|
|AMOUNT_DR||the debit amount of the journal line.|
|AMOUNT_CR||the credit amount of the journal line.|
|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 12 months ago