JournalEntrySyncModel

The JournalEntrySyncModel represents information coming into ADS from an external financial system or other
enterprise resource planning system. To import data from an external system, convert your original data into
the JournalEntrySyncModel 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 ADS
Platform.

Once imported, this record will be available in the ADS Platform API as a JournalEntryModel

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 record. For this field, you should use whatever the Journal Entry'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 records in a database, whatever the primary key for the Journal Entry table is
in the database should be the "ErpKey".

For more information, see Identity Columns.

source

JournalEntrySource

Possible sources for a Journal Entry.

status

JournalEntryStatus

Possible statuses for a Journal Entry.

sourcePostingDate

date-time

The raw posting date from the source.

Optional Fields

journalId

string, nullable

The ERP’s identifier for this journal entry, usually has meaning to the user.
May be the same value of the ERP Key.

description

string, nullable

A brief description explaining the purpose of the journal entry.

comment

string, nullable

An additional comment related to the entry.

referenceNumber

string, nullable

Any reference number or identifier associated with the entry, such as an invoice number or purchase order.

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.