PaymentAppliedSyncModel

The PaymentAppliedSyncModel 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 PaymentAppliedSyncModel 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 PaymentAppliedModel.

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 Payment Application record. For this field, you should use whatever this
transaction's unique identifying number is in the originating system. Search for a unique, non-changing
number within the originating financial system for this record.

Since Payment Applications are often considered transactions, a typical value to look for will be
the transaction ID number, the payment confirmation number, or some other record of this payment.

For more information, see Identity Columns.

invoiceErpKey

string

This field indicates which Invoice had its balance reduced by applying this payment. In this field,
identify the original primary key or unique ID of the Invoice which had its balance reduced.

This information lets you track how an invoice was paid. You can identify what proportion of an invoice's
balance was paid by which methods by joining this field to Invoices.

This value should match the Invoice ErpKey
field on the InvoiceSyncModel.

paymentErpKey

string

This field indicates which Payment was used to provide the funds for this payment application. In this
field, identify the original primary key or unique ID of the Payment that was used for this payment
application.

This information lets you track how an invoice was paid. You can identify what proportion of an payment's
balance was paid by which methods by joining this field to the Payment.

This value should match the Payment ErpKey
field on the PaymentSyncModel.

entryNumber

int32

The entry number of this payment application. This is often a journal entry number, confirmation code,
or other identifying field for this payment application.

applyToInvoiceDate

date-time

The date this payment was applied to this invoice.

paymentAppliedAmount

double

The total amount that was applied to this Invoice from the Payment.

Optional Fields

networkId

uuid, nullable

The unique identifier of this object in the Sage Network platform.

invoiceNetworkId

uuid, nullable

The network id of the related Invoice.

paymentNetworkId

uuid, nullable

The network id of the related Payment.

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.