Purchasing Transactions - Sage Intacct Data Target Requirements

DataBlend supports the API calls to Create and Update Purchasing Transactions 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.

Purchasing transactions are the records of a company’s purchases, including purchase requisitions, purchase orders, vendor invoices, and more.

DataBlend Query Object (SDK)	Sage Intacct Object (API)	Sage Intacct UI Name	Required	Notes
ATTACHMENTSID	SUPDOCID	Attachments ID	Optional	Expected value is free text
BASECURRENCY	BASECURR	Base currency	Optional	Expected value is free text
CREATEDFROM	CREATEDFROM	Converted from	Optional	Expected value is free text (30)
DUEDATE	WHENDUE	Date due	Optional	Required if not using `termname`. Date in the `mm/dd/yyyy` format
EXCHANGERATEDATE	EXCHRATEDATE	Exchange rate date	Optional	Date in the `mm/dd/yyyy` format
EXCHANGERATETYPE	EXCHRATETYPE	Exchange rate type	Optional	Expected value is free text (40)
EXCHANGERATEVALUE	EXCHRATE	Exchange rate	Optional	Exchange rate value. Do not use if `exchangeratetype` is set. Expected value is decimal.
EXTERNALID	EXTERNALID	External ID	Optional	Expected value is free text
GLPOSTINGDATE	WHENPOSTED	GL posting date	Optional	Date in the `mm/dd/yyyy` format
PAYMENTTERM	TERM.NAME	Payment terms	Optional	Payment term. Required if not using `datedue`.
PAYTO	PAYTO	Pay to	Yes	Object. Send it null to use vendor’s default.
REFERENCENUMBER	PONUMBER	Reference number	Optional	Expected value is free text (120)
RETURNTO	RETURNTO	Return to	Yes	Object. Set it to null to use vendor’s default.
TRANSACTIONCURRENCY	CURRENCY	Txn currency	Optional	Expected value is free text
DATECREATED	WHENCREATED	Date	Yes	Date in the `mm/dd/yyyy` format
TRANSACTIONTYPE	TRANSACTIONTYPE		Yes	Transaction definition to use, such as a Purchase Order
VENDORID	VENDORID	Vendor	Yes	Expected value is free text (20)
DELIVERTO	DELIVERTO.CONTACTNAME	Deliver to	Optional	Deliver to contact for tax calculation. Expected value is free text (200)
DOCUMENTNO	DOCNO	Document number	Optional	Leave blank to use auto numbering if set in definition. Expected value is free text (30)
MESSAGE	MESSAGE	Message	Optional	Expected value is free text (4000)
PROJECTID	PROJECT	Project	Optional	Expected value is free text (20)
SHIPPINGMETHOD	SHIPPINGMETHOD	Shipping method	Optional
STATE	STATE	State	Optional	`Draft`, `Pending`, `Closed`. Default depends on transaction definition configuration.
TAXSOLUTIONID	TAXSOLUTIONID	Tax solution	Optional	Tax solution name, such as `United Kingdom - VAT` or `Australia - GST`. Required only if the company is configured for multiple tax jurisdictions and the transaction is occurring at the top level of the company. The available tax solution names can be found in the Sage Intacct UI in the Taxes application from the top level of a multi-entity company. (GB, AU, and ZA only). Expected value is free text
VENDORDOCNO	VENDORDOCNO	Vendor document number	Optional	Expected value is free text (45)
KEY	DOCID	Document ID	Yes for Update	Document ID to update. Must be the docparid "-" docid (ex: Purchase Order-PO1234)

Purchasing Transaction Line (Required)

DataBlend Query Object (SDK)	Sage Intacct Object (API)	Sage Intacct UI Name	Required	Notes
LINE_BILLABLE	BILLABLE	Billable	Optional	Check box. `false` - No (default), `true` - Yes
LINE_CLASSID	CLASSID	Class	Optional	Expected value is free text (50)
LINE_CONTRACTID	RECURCONTRACTID	RECURCONTRACTID	Optional	Expected value is free text
LINE_CUSTOMERID	CUSTOMERID	Customer	Optional	Expected value is free text (20)
LINE_DEPARTMENTID	DEPARTMENTID	Department ID	Optional	Expected value is free text
LINE_EMPLOYEEID	EMPLOYEEID	Employee	Optional	Expected value is free text (20)
LINE_ITEM1099	ITEM1099	Form 1099	Optional	Check box. Vendor must be set up for 1099s. `false` - No, `true` - Yes
LINE_ITEMID	ITEMID	Item ID	Yes	Required for Create. Expected value is free text
LINE_LOCATIONID	LOCATIONID	Location ID	Optional	Expected value is free text
LINE_MEMO	MEMO	Memo	Optional	Expected value is free text (400)
LINE_PROJECTID	PROJECTID	Project	Optional	Expected value is free text (20)
LINE_VENDORID	VENDORID	Vendor	Optional	Expected value is free text (20)
LINE_WAREHOUSEID	WAREHOUSEID	Warehouse	Optional	Expected value is free text (20)
LINE_FORM1099BOX	FORM1099BOX	Form 1099 Box	Optional	Expected value is free text
LINE_FORM1099TYPE	FORM1099TYPE	Form 1099 Type	Optional	Expected value is free text
LINE_ITEMDESC	ITEMDESC	Item description	Optional	Expected value is free text (400)
LINE_LINELEVELSIMPLETAXTYPE	LINELEVELSIMPLETAXTYPE	Tax Type	Optional	Expected value is free text (200)
LINE_DELIVERTO	DELIVERTO	Deliver to	Optional	Object. Deliver to contact for tax calculation
LINE_OVERRIDETAXAMOUNT	OVERRIDETAXAMOUNT	Override tax amount	Optional	Expected value is decimal
LINE_PRICE	PRICE	Price	Optional	Expected value is decimal
LINE_QUANTITY	QUANTITY	Quantity	Yes	Expected value is decimal
LINE_LINENO	LINE_NO	Line number	Optional	Yes - Associated by referenceno. Expected value is integer
LINE_TAX	TAXABSVAL	Tax	Optional	Expected value is decimal
LINE_TAXABLE	TAXABLE	Taxable	Optional	Check box. `false` - No, `true` - Yes. Customer must be set up for taxable.
LINE_UNIT	UNIT	Unit	Optional	Expected value is free text

Transaction Item Details

DataBlend Query Object (SDK)	Sage Intacct Object (API)	Sage Intacct UI Name	Required	Notes
DETAIL_AISLE	AISLE	Aisle	Optional	Expected value is free text
DETAIL_BIN	BIN	Bin	Optional	Expected value is free text
DETAIL_ITEMEXPIRATION	ITEMEXPIRATION	Item expiration	Optional	Object
DETAIL_LOTNO	LOTNO	Lot number	Optional	Expected value is free text
DETAIL_QUANTITY	QUANTITY	Quantity	Optional	Expected value is integer
DETAIL_ROW	ROW	Row	Optional	Expected value is free text
DETAIL_SERIALNO	SERIALNO	Serial Number	Optional	Expected value is free text

Transaction Subtotal

DataBlend Query Object (SDK)	Sage Intacct Object (API)	Sage Intacct UI Name	Required	Notes
SUBTOTAL_CLASSID	CLASSID	Class	Optional	Expected value is free text (50)
SUBTOTAL_CONTRACTID	RECURCONTRACTID	RECURCONTRACTID	Optional	Expected value is free text
SUBTOTAL_CUSTOMERID	CUSTOMERID	Customer	Optional	Expected value is free text (20)
SUBTOTAL_DEPARTMENTID	DEPARTMENT	Department	Optional	Expected value is free text (40)
SUBTOTAL_EMPLOYEEID	EMPLOYEEID	Employee	Optional	Expected value is free text (20)
SUBTOTAL_ITEMID	ITEMID	Item	Optional	Expected value is free text (30)
SUBTOTAL_LOCATIONID	LOCATION	Location	Optional	Expected value is free text (40)
SUBTOTAL_PROJECTID	PROJECTID	Project	Optional	Expected value is free text (20)
SUBTOTAL_VENDORID	VENDORID	Vendor	Optional	Expected value is free text (20)
SUBTOTAL_ABSVAL	ABSVAL	Value	Optional	Expected value is decimal
SUBTOTAL_DESCRIPTION	DESCRIPTION	Description	Yes	Expected value is free text (100). Only if subtotals are turned on
SUBTOTAL_PERCENTVAL	PERCENTVAL	Percent	Optional	Expected value is decimal
SUBTOTAL_TOTAL	TOTAL	Total	Yes	Expected value is decimal. Only if subtotals are turned on