PaymentAppliedSyncModel
Less than to read
The PaymentAppliedSyncModel represents information coming into Sage Network 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 Sage Network platform.
Once imported, this record will be available in the Sage Network 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
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
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
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
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
The date this payment was applied to this invoice.
paymentAppliedAmount
The total amount that was applied to this Invoice from the Payment.
Optional Fields
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.