AP Payments - Sage Intacct Data Target Requirements

DataBlend supports the API calls to Create and Update AP Payment records within Sage Intacct leveraging the Sage Intacct SDK. In addition, Custom Fields can be added for data that is unique to your business practices.

An AP payment is a transaction that records a payment against an AP bill or AP adjustment.

DataBlend Query Object (SDK)	Sage Intacct Object (API)	Sage Intacct UI Name	Required	Notes
ACTION	ACTION	Action	Optional	Use `Draft` to move the payment to the outbox in the system, or `Submit` to submit/post the payment depending on the approval workflow (Default: `Submit`).
ADJUSTMENTAMOUNT	TRX_ADJUSTMENTAMOUNT	Adjustment transaction amount	Optional	Expected value is decimal
ADJUSTMENTENTRYKEY	ADJUSTMENTENTRYKEY	Debit memo entry record number	Optional	Expected value is integer
ADJUSTMENTKEY	ADJUSTMENTKEY	Debit memo record number	Optional	Expected value is integer
ADVANCEENTRYKEY	ADVANCEENTRYKEY	Advance entry record number	Optional	Expected value is integer
ADVANCEKEY	ADVANCEKEY	Advance record number	Optional	Expected value is integer
AMOUNTTOPAY	AMOUNTTOPAY	Amount to pay	Optional	Amount to pay in the currency of the financial entity making the payment. Only applicable when paying from a bank with a different currency than that of the transaction.
BASECURRENCY	BASECURR	Base currency	Optional	Base currency code. Expected value is free text
CURRENCY	CURRENCY	Transaction currency	Yes	Transaction currency code. Expected value is free text
DESCRIPTION	DESCRIPTION	Description	Optional	Description of the payment. Expected value is free text (1000). This field will not update if the ACTION field is included in the call that is being sent to Intacct.
DISCOUNTDATE	DISCOUNTDATE	Discount date	Optional	Discount date in format `mm/dd/yyyy`. All discounts available at this date are applied. You can supply a date in the past to access a discount whose deadline has already passed. You must provide the correct `TRX_PAYMENTAMOUNT` for the entire amount due (with the discount amount calculated in) for the discount to apply. Discounts are not applied when bill lines are provided.
DOCUMENTNUMBER	DOCUMENTNUMBER	Document number	Optional	Expected value is free text
ENTRYKEY	ENTRYKEY	Bill line record number	Optional	Not supported for discounts. Expected value is integer
EXCHANGERATEDATE	EXCH_RATE_DATE	Exchange rate date	Optional	Exchange rate date in format `mm/dd/yyyy` (Default: payment date of the request)
EXCHANGERATETYPE	EXCH_RATE_TYPE_ID	Exchange rate type	Optional	Exchange rate type (Default: `Intacct Daily Rate`)
FINANCIALENTITY	FINANCIALENTITY	Financial entity	Yes	Financial entity from which the payment will be paid. Can be a checking account ID, a savings account ID, or a credit card ID.
INLINEAMOUNT	TRX_INLINEAMOUNT	Negative bill transaction amount	Optional	Expected value is decimal
INLINEKEY	INLINEKEY	Negative bill transaction record number	Optional	Expected value is integer
INLINEENTRYKEY	INLINEENTRYKEY	Record number of a negative line on a bill	Optional	Expected value is integer
MEMOENTRYRECORDNO	POSADJENTRYKEY	Credit memo entry record number	Optional	Expected value is integer
MEMORECORDNO	POSADJKEY	Credit memo record number	Optional	Expected value is integer
PAYMENTAMOUNT	TRX_PAYMENTAMOUNT	Amount of the payment	Optional	Must be the full amount of the bill (with the discount amount calculated in) in order to apply a discount. Expected value is decimal
PAYMENTDATE	PAYMENTDATE	Payment date	Yes	Payment date in format `mm/dd/yyyy`. Parameter value is shown in `WHENCREATED` in subsequent read operations.
PAYMENTMETHOD	PAYMENTMETHOD	Payment method	Yes	Use `Printed Check`, `Cash`, `EFT`, `Credit Card`, `ACH`, `Check Delivery`, `Amex ACH`, `Amex Charge Card`, `WF Check`, `WF Domestic ACH`, or `WF USD Wire`
PAYMENTREQUESTMETHOD	PAYMENTREQUESTMETHOD	Approach for paying the bill	Optional	Use `vendorpref` to apply the preference for the vendor as specified in the Sage Intacct UI, `vendor` to pay all bills from the vendor in one payment, `bill` to pay each bill from the vendor as as separate payment, or `payto` to merge the request into one per vendor pay-to contact (Default: `vendorpref`).
POSTEDADVANCEAMOUNT	TRX_POSTEDADVANCEAMOUNT	Posted advance transaction amount	Optional	Expected value is decimal
RECORDKEY	RECORDKEY	Bill record number	Yes/Optional	Required if not using a credit memo record number. Expected value is integer
VENDORID	VENDORID	Vendor ID	Yes	Expected value is free text