Items - Sage Intacct Data Target Requirements

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

Items are goods, services, or kits that you purchase from vendors or sell to customers. Items are used in Inventory Control, Order Entry, and Purchasing.

DataBlend Query Object (SDK)	Sage Intacct Object (API)	Sage Intacct UI Name	Required	Notes
ACTIVE	STATUS	Status	Optional	Text. Use `true` for Active or `false` for Inactive (Default: `true`)
APGLACCOUNTNO	OFFSETPOGLACCOUNTKEY	Accounts Payable GL account	Optional	AP GL account number. Expected value is free text (24)
ARGLACCOUNTNO	OFFSETOEGLACCOUNTKEY	Accounts Receivable GL account	Optional	AR GL account number. Expected value is free text (24)
BASEPRICE	BASEPRICE	Base price	Optional	Expected value is decimal
BINTRACKING	ENABLE_BINS	Enable bin tracking	Optional	`false` - No (default), `true` - Yes. Applicable to inventory or stockable kit item types.
COGSGLACCOUNTNO	COGSACCTKEY	COGS account	Optional	COGS GL account number. Expected value is free text (24)
COSTMETHOD	COST_METHOD	Cost method	Optional	`Standard`, `Average`, `FIFO, LIFO`
DEFAULTRENEWALMACROID	RENEWALMACROID	Default renewal template	Optional	Expected value is free text (30)
DEFAULTREVRECTEMPLATEID	DEFAULTREVRECTEMPLKEY	Default revenue recognition template	Optional	Expected value is free text (30)
DEFFEREDREVGLACCOUNTNO	DEFERREDREVACCTKEY	Deferred revenue account	Optional	Expected value is free text (24)
EXPENSEGLACCOUNTNO	EXPENSEACCTKEY	Expense account	Optional	Expected value is free text (24)
EXPTRACKINGENABLED	ENABLE_EXPIRATION	Enable expiration tracking	Optional	`false` - No (default), `true` - Yes
EXTENDEDDESCRIPTION	EXTENDED_DESCRIPTION	Extended description	Optional	Expected value is free text (400)
INVENTORYGLACCOUNTNO	INVACCTKEY	Inventory account	Optional	Expected value is free text (24)
ITEMGLGROUPNAME	GLGROUP	GL group	Optional	Expected value is free text (80)
ITEMID	ITEMID	Item ID	Yes	Item ID to create. Expected value is free text
ITEMNAME	NAME	Name	Yes	Expected value is free text (100)
ITEMSTARTENDDATEENABLED	HASSTARTENDDATES	Item has start and end date	Optional	Check Box. `false` - No (default), `true` - Yes
ITEMTAXGROUPNAME	TAXGROUP.NAME	Item tax group	Optional	Expected value is free text
ITEMTYPE	ITEMTYPE	Item type	Yes	`Inventory`, `Non-Inventory`, `Non-Inventory (Purchase only)`, `Non-Inventory (Sales only)`, `Kit`, `Stockable Kit`. Not available for Update.
KITPRINTFORMAT	REVPRINTING	Print format	Optional	Expected value is free text
KITREVENUEPOSTING	REVPOSTING	Revenue posting	Optional	Expected value is free text
LOTCATEGORY	LOT_CATEGORYKEY	Lot category	Optional	Expected value is free text (30)
LOTTRACKINGENABLED	ENABLE_LOT_CATEGORY	Enable lot tracking	Optional	Expected value is free text
NOTE	NOTE	Note	Optional	Expected value is free text (1000)
NUMBEROFPERIODS	TOTALPERIODS	Number of periods	Optional	Expected value is integer
PERIODSMEASUREDIN	TERMPERIOD	Periods measured in	Optional	Expected value is free text
PRODUCTLINEID	PRODUCTLINEID	Product line ID	Optional	`PRODUCTLINEID` of the product line that you want to add this product to. Expected value is free text (30)
PRORATEPRICEALLOWED	COMPUTEFORSHORTTERM	Allow to prorate price	Optional	Check Box. `false` - No (default), `true` - Yes
PURCHASINGDESCRIPTION	PODESCRIPTION	Description on purchase transactions	Optional	Expected value is free text (400)
REVENUEGLACCOUNTNO	INCOMEACCTKEY	Revenue account	Optional	Expected value is free text (24)
SALESDESCRIPTION	SODESCRIPTION	Description on sales transactions	Optional	Expected value is free text (400)
SERIALNUMBERMASK	SERIAL_MASKKEY	Serial number mask	Optional	Expected value is free text (30)
SERIALTRACKINGENABLED	ENABLE_SERIALNO	Enable serial tracking	Optional	Expected value is free text
SHIPPINGWEIGHT	SHIP_WEIGHT	Shipping weight	Optional	Expected value is decimal
STANDARDCOST	STANDARD_COST	Standard cost	Optional	Expected value is free text (15)
SUBSTITUTEITEMID	SUBSTITUTEID	Substitute item	Optional	Expected value is free text (30)
TAXABLE	TAXABLE	Taxable	Optional	Use `false` for No, `true` for Yes. (Default: `true`)
UNITCOSTPRECISIONINVENTORY	INV_PRECISION	Inventory	Optional	Expected value is free text (2)
UNITCOSTPRECISIONPURCHASING	PO_PRECISION	Purchasing	Optional	Expected value is free text (2)
UNITCOSTPRECISIONSALES	SO_PRECISION	Sales	Optional	Expected value is free text (2)
UNITOFMEASURE	UOMGRP	Unit of measure	Optional	Expected value is free text (80)
UPC	UPC	UPC	Optional	Expected value is free text (40)
VSOECATEGORY	VSOECATEGORY	Fair value category	Optional	`Product - Specified`, `Product - Unspecified`, `Upgrade - Specified`, `Upgrade - Unspecified`, `Software`, `Services`, `Post Contract Support(PCS)`
VSOEDEFAULTDEFERRALSTATUS	VSOEDLVRSTATUS	Default delivery status	Optional	`D` - Delivered, `U` - Undelivered