Power BI Connector for Sage Intacct

Build 25.0.9454

Item

Maintains comprehensive details about items, including descriptions, pricing, and tax data, for inventory and sales processes.

To retrieve multi-warehouse items, set the following:

  • UseLegacy: Set this to true to utilize the legacy API.
  • ReadByName: Set this to true to include the ReadByName clause in the XML request. The warehouseinfo field will not populate without ReadByName being set to True.

Setting ReadByName to true exposes the Warehouseinfo field, which can be used to query for the warehouse details for each item. 

SELECT Warehouseinfo FROM Item WHERE Itemid IN (SELECT Itemid FROM Item)

Columns

Name Type ReadOnly Description
Recordno Int64 False

The unique identifier for the Item record.

Itemid [KEY] String False

The unique item identifier for the Item record.

Status String False

The status of the Item record (for example, active, inactive).

Name String False

The name of the item.

Extended_description String False

An extended description of the item.

Podescription String False

The description of the item for purchase orders.

Sodescription String False

The description of the item for sales orders.

Productlineid String False

The product line identifier associated with the item.

Cycle String False

The cycle associated with the item (for example, monthly, annual).

Producttype String False

The type of product for this item (for example, physical, digital).

Substituteid String False

The identifier of a substitute item for this item.

Ship_weight Double False

The shipping weight of the item.

Whenlastsold Datetime False

The date and time when the item was last sold.

Whenlastreceived Datetime False

The date and time when the item was last received.

Incomeacctkey String False

The income account key associated with the item.

Expenseacctkey String False

The expense account key associated with the item.

Invacctkey String False

The inventory account key associated with the item.

Cogsacctkey String False

The cost of goods sold account key associated with the item.

Offsetoeglaccountkey String False

The offset to the OEGL account key for this item.

Offsetpoglaccountkey String False

The offset to the POGL account key for this item.

Deferredrevacctkey String False

The deferred revenue account key for this item.

Defaultrevrectemplkey String False

The default revenue recognition template key for the item.

Allow_backorder String False

Indicates whether backorders are allowed for the item.

Taxable String False

Indicates whether the item is taxable.

Taxgroup_name String False

The name of the tax group to which the item belongs.

Taxcode String False

The tax code associated with the item.

Cost_method String False

The method used to calculate the cost of the item (for example, FIFO, LIFO, Standard).

Standard_cost String False

The standard cost of the item.

Average_cost String False

The average cost of the item.

Uomgrp String False

The unit of measure group for the item.

Uom_invuomdetail_unit String False

The unit of measure used in inventory for the item.

Uom_pouomdetail_unit String False

The unit of measure used in purchase orders for the item.

Uom_pouomdetail_convfactor Double False

The conversion factor for the unit of measure in purchase orders.

Uom_souomdetail_unit String False

The unit of measure used in sales orders for the item.

Uom_souomdetail_convfactor Double False

The conversion factor for the unit of measure in sales orders.

Default_warehouse String False

The default warehouse associated with the item.

Warehouseinfo String False

Information about the warehouse where the item is stored, only available when ReadByName is set to True.

Glgroup String False

The general ledger group associated with the item.

Note String False

Additional notes related to the item.

Inv_precision String False

The precision used for inventory transactions related to the item.

Po_precision String False

The precision used for purchase orders related to the item.

So_precision String False

The precision used for sales orders related to the item.

Itemtype String False

The type of the item (for example, goods, service).

Enable_serialno String False

Indicates whether the item supports serial numbers.

Serial_maskkey String False

The mask key for serial numbers of the item.

Enable_lot_category String False

Indicates whether the item is associated with lot categories.

Lot_categorykey String False

The key for the lot category associated with the item.

Enable_bins String False

Indicates whether bins are enabled for the item in inventory.

Enable_expiration String False

Indicates whether expiration dates are enabled for the item.

Upc String False

The universal product code (UPC) for the item.

Revposting String False

Indicates whether the item is subject to revenue posting.

Revprinting String False

Indicates whether the item is subject to revenue printing.

Vsoecategory String False

The sales order entry category associated with the item.

Vsoedlvrstatus String False

The delivery status of the sales order for the item.

Vsoerevdefstatus String False

The revenue definition status for the item in the sales order.

Hasstartenddates Boolean False

Indicates whether the item has start and end dates for its life cycle.

Termperiod String False

The period term for the item.

Totalperiods Int64 False

The total number of periods for the item.

Computeforshortterm Boolean False

Indicates whether the item is computed for short-term calculations.

Renewalmacroid String False

The renewal macro ID associated with the item.

Renewalmacrokey Int64 False

The renewal macro key associated with the item.

Itemglgroup_incomeaccount_acctno String False

The income account number for the item in the general ledger.

Itemglgroup_expenseaccount_acctno String False

The expense account number for the item in the general ledger.

Itemglgroup_inventoryaccount_acctno String False

The inventory account number for the item in the general ledger.

Itemglgroup_cogsaccount_acctno String False

The cost of goods sold (COGS) account number for the item in the general ledger.

Itemglgroup_defrrglaccount_acctno String False

The deferred revenue recognition general ledger account number for the item.

Itemglgroup_oeglaccount_acctno String False

The other expense general ledger account number for the item.

Itemglgroup_poglaccount_acctno String False

The purchase order general ledger account number for the item.

Whencreated Datetime False

The creation date and time of the item.

Whenmodified Datetime False

The last modified date and time of the item.

Createdby Int64 False

The ID of the user who created the item.

Modifiedby Int64 False

The ID of the user who last modified the item.

Ionorder Double False

The quantity of the item in order.

Ionhand Double False

The quantity of the item on hand.

Ionhold Double False

The quantity of the item on hold.

Glgrpkey Int64 False

The general ledger group key associated with the item.

Uomgrpkey Int64 False

The unit of measure group key associated with the item.

Taxgroupkey Int64 False

The tax group key associated with the item.

Megaentitykey Int64 False

The mega entity key associated with the item.

Megaentityid String False

The mega entity ID associated with the item.

Megaentityname String False

The name of the mega entity associated with the item.

Record_url String False

The URL for the item record.

Copyright (c) 2025 CData Software, Inc. - All rights reserved.
Build 25.0.9454