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
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
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
The unique code/identifier assigned to each account in the chart of accounts.
accountName
The name of the account.
debit
Debit to account.
credit
Credit to account.
currencyCode
The transaction currency in which the entry is recorded, especially useful for multi-currency environments.
baseDebit
The base currency debit amount for the account.
baseCredit
The base currency credit amount for the account.
baseCurrencyCode
The base currency in which the entry is recorded, especially useful for multi-currency environments.
sourceCreatedUser
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.
Updated 20 days ago