JournalEntryLineSyncModel

The JournalEntryLineSyncModel represents information coming into Lockstep from an external financial system or other
enterprise resource planning system. To import data from an external system, convert your original data into
the JournalEntryLineSyncModel format and call the Upload Sync File API.
This API retrieves all of the data you uploaded in a compressed ZIP file and imports it into the Lockstep
platform.

Once imported, this record will be available in the Lockstep API as a JournalEntryLineModel

For more information on writing your own connector, see Connector Data.

Required Fields

onMatchAction

MatchAction

Indicates what action to take when an existing object has been found during the sync process.

erpKey

string

This is the primary key of the Journal Entry Line record. For this field, you should use whatever the Journal Entry Line's unique
identifying number is in the originating system. Search for a unique, non-changing number within the
originating financial system for this record.

Example: If you store your Journal Entry Line records in a database, whatever the primary key for the Journal Entry Line table is
in the database should be the "ErpKey".

For more information, see Identity Columns.

journalEntryErpKey

string

The original primary key or unique ID of the journal entry to which this line belongs. This value should
match the Journal Entry ErpKey field on the JournalEntrySyncModel.

accountNumber

string

The unique code/identifier assigned to each account in the chart of accounts.

accountName

string

The name of the account.

debit

double

Debit to account.

credit

double

Credit to account.

currencyCode

string

The transaction currency in which the entry is recorded, especially useful for multi-currency environments.

baseDebit

double

The base currency debit amount for the account.

baseCredit

double

The base currency credit amount for the account.

baseCurrencyCode

string

The base currency in which the entry is recorded, especially useful for multi-currency environments.

sourceCreatedUser

string

The ERP’s identifier for the user who recorded the journal entry line.

Optional Fields

financialAccountErpKey

string, nullable

An optional Financial Account with which this line is associated. This value should
match the Financial Account ErpKey field on the FinancialAccountSyncModel.

memo

string, nullable

A memo related to this line.

dimensions

object, nullable

A JSON string representing the dimensions for this journal entry line.

sourceObjectErpKey

string, nullable

The source object ERP key for this journal entry line.

sourceObjectType

SourceObjectType, nullable

The ID of the SourceObjectType for this journal entry line.

created

date-time, nullable

If known, the date when this record was created according to the originating financial system
in which this record is maintained. If the originating financial system does not maintain a
created-date, leave this field null.

modified

date-time, nullable

If known, the date when this record was most recently modified according to the originating
financial system in which this record is maintained. If the originating financial system does
not maintain a most-recently-modified-date, leave this field null.