Less than to read
The PaymentSyncModel 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 PaymentSyncModel 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 PaymentModel.
For more information on writing your own connector, see Connector Data.
Indicates what action to take when an existing object has been found during the sync process.
This is the primary key of the Payment record. For this field, you should use whatever the payment’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 payment records in a database, whatever the primary key for the payment table is in the database should be the “ErpKey”.
For more information, see Identity Columns.
The original primary key or unique ID of the company to which this payment belongs. This value should match the Company ErpKey field on the CompanySyncModel.
The type of payment, AR Payment or AP Payment.
Recognized PaymentType values are:
AR Payment- A payment made by a Customer to the Company
AP Payment- A payment made by the Company to a Vendor
True if this payment includes some unassigned amount that has not yet been applied to an invoice. If this
value is true, the field
UnappliedAmount will be nonzero.
The date when this payment was received. This typically is the date when an accounting employee recorded that they received notification that the payment had occurred, whether they were notified by email, postal mail, or financial transaction notification.
The date when a payment was posted to a ledger. This date is often determined by a company’s accounting practices and may be different than the date when the payment was received. This date may be affected by issues such as temporary holds on funds transferred, bank holidays, or other actions.
Total amount of this payment in the payment’s currency.
Unapplied balance of this payment in the payment’s currency. If this amount is nonzero, the field
IsOpen will be true.
The Currency Rate used to get from the account’s base currency to the payment amount.
Total amount of this payment in the erp’s base currency.
Unapplied balance of this payment in the erp’s base currency. If this amount is nonzero, the field
IsOpen will be true.
Cash, check, credit card, wire transfer.
Recognized TenderType values are:
Cash- A cash payment or other direct transfer.
Check- A check payment.
Credit Card- A payment made via a credit card.
Wire Transfer- A payment made via wire transfer from another financial institution.
Other- A payment made via another method not listed above.
Memo or reference text (ex. memo field on a check).
The ISO 4217 currency code for this payment.
For a list of ISO 4217 currency codes, see Query Currencies.
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.
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.
A reference code for the payment for the given financial or ERP system. This can be any value that the
originating system uses to designate the payment, such as a confirmation number or tracking number, that
is different from the
True if this payment was voided.
True if this payment is in dispute.