Entity Accounting Periods - Upsert Mode of Data Loading

UPSERT mode is the loading mode, directly mapping data from the incoming EagleML message to DB fields without any logic.

To use the UPSERT mode, leave the Accounting Validation Flag (entityTransaction/entityAccountingPeriods/accountingValidationFlag) empty or set it to ‘N’:

UPSERT is the default mode for Accounting Period interface. Data can be inserted or updated in UPSERT mode.

The key of a record consists of the following values:

Entity Id (Portfolio Acct) + Accounting Basis + Start Date + End Date

The action to be applied (insert or update) is defined automatically.

Insert Data in UPSERT mode

New record will be inserted into ESTAR.ESTAR_ACCOUNTING_PERIODS DB table if the key described above does not exist in DB.

Update Data in UPSERT mode

The record with a key already existing in DB will be updated by the values from incoming message.

If an element does is missing in the incoming message, an empty value will be loaded into the database