Tableau Connector for Sage Intacct

Build 21.0.7930

Item

Retrieves Item report data.

Columns

Name Type ReadOnly Description
Recordno Int64 False

The Recordno field of the Item object.

Itemid [KEY] String False

The Itemid field of the Item object.

Status String False

The Status field of the Item object.

Name String False

The Name field of the Item object.

Extended_description String False

The Extended_description field of the Item object.

Podescription String False

The Podescription field of the Item object.

Sodescription String False

The Sodescription field of the Item object.

Productlineid String False

The Productlineid field of the Item object.

Cycle String False

The Cycle field of the Item object.

Producttype String False

The Producttype field of the Item object.

Substituteid String False

The Substituteid field of the Item object.

Ship_weight Double False

The Ship_weight field of the Item object.

Whenlastsold Datetime False

The Whenlastsold field of the Item object.

Whenlastreceived Datetime False

The Whenlastreceived field of the Item object.

Incomeacctkey String False

The Incomeacctkey field of the Item object.

Expenseacctkey String False

The Expenseacctkey field of the Item object.

Invacctkey String False

The Invacctkey field of the Item object.

Cogsacctkey String False

The Cogsacctkey field of the Item object.

Offsetoeglaccountkey String False

The Offsetoeglaccountkey field of the Item object.

Offsetpoglaccountkey String False

The Offsetpoglaccountkey field of the Item object.

Deferredrevacctkey String False

The Deferredrevacctkey field of the Item object.

Defaultrevrectemplkey String False

The Defaultrevrectemplkey field of the Item object.

Allow_backorder String False

The Allow_backorder field of the Item object.

Taxable String False

The Taxable field of the Item object.

Taxgroup_name String False

The Taxgroup_name field of the Item object.

Taxcode String False

The Taxcode field of the Item object.

Cost_method String False

The Cost_method field of the Item object.

Standard_cost String False

The Standard_cost field of the Item object.

Average_cost String False

The Average_cost field of the Item object.

Uomgrp String False

The Uomgrp field of the Item object.

Uom_invuomdetail_unit String False

The Uom_invuomdetail_unit field of the Item object.

Uom_pouomdetail_unit String False

The Uom_pouomdetail_unit field of the Item object.

Uom_pouomdetail_convfactor Double False

The Uom_pouomdetail_convfactor field of the Item object.

Uom_souomdetail_unit String False

The Uom_souomdetail_unit field of the Item object.

Uom_souomdetail_convfactor Double False

The Uom_souomdetail_convfactor field of the Item object.

Default_warehouse String False

The Default_warehouse field of the Item object.

Glgroup String False

The Glgroup field of the Item object.

Note String False

The Note field of the Item object.

Inv_precision String False

The Inv_precision field of the Item object.

Po_precision String False

The Po_precision field of the Item object.

So_precision String False

The So_precision field of the Item object.

Itemtype String False

The Itemtype field of the Item object.

Enable_serialno String False

The Enable_serialno field of the Item object.

Serial_maskkey String False

The Serial_maskkey field of the Item object.

Enable_lot_category String False

The Enable_lot_category field of the Item object.

Lot_categorykey String False

The Lot_categorykey field of the Item object.

Enable_bins String False

The Enable_bins field of the Item object.

Enable_expiration String False

The Enable_expiration field of the Item object.

Upc String False

The Upc field of the Item object.

Revposting String False

The Revposting field of the Item object.

Revprinting String False

The Revprinting field of the Item object.

Vsoecategory String False

The Vsoecategory field of the Item object.

Vsoedlvrstatus String False

The Vsoedlvrstatus field of the Item object.

Vsoerevdefstatus String False

The Vsoerevdefstatus field of the Item object.

Hasstartenddates Boolean False

The Hasstartenddates field of the Item object.

Termperiod String False

The Termperiod field of the Item object.

Totalperiods Int64 False

The Totalperiods field of the Item object.

Computeforshortterm Boolean False

The Computeforshortterm field of the Item object.

Renewalmacroid String False

The Renewalmacroid field of the Item object.

Renewalmacrokey Int64 False

The Renewalmacrokey field of the Item object.

Itemglgroup_incomeaccount_acctno String False

The Itemglgroup_incomeaccount_acctno field of the Item object.

Itemglgroup_expenseaccount_acctno String False

The Itemglgroup_expenseaccount_acctno field of the Item object.

Itemglgroup_inventoryaccount_acctno String False

The Itemglgroup_inventoryaccount_acctno field of the Item object.

Itemglgroup_cogsaccount_acctno String False

The Itemglgroup_cogsaccount_acctno field of the Item object.

Itemglgroup_defrrglaccount_acctno String False

The Itemglgroup_defrrglaccount_acctno field of the Item object.

Itemglgroup_oeglaccount_acctno String False

The Itemglgroup_oeglaccount_acctno field of the Item object.

Itemglgroup_poglaccount_acctno String False

The Itemglgroup_poglaccount_acctno field of the Item object.

Whencreated Datetime False

The Whencreated field of the Item object.

Whenmodified Datetime False

The Whenmodified field of the Item object.

Createdby Int64 False

The Createdby field of the Item object.

Modifiedby Int64 False

The Modifiedby field of the Item object.

Ionorder Double False

The Ionorder field of the Item object.

Ionhand Double False

The Ionhand field of the Item object.

Ionhold Double False

The Ionhold field of the Item object.

Glgrpkey Int64 False

The Glgrpkey field of the Item object.

Uomgrpkey Int64 False

The Uomgrpkey field of the Item object.

Taxgroupkey Int64 False

The Taxgroupkey field of the Item object.

Megaentitykey Int64 False

The Megaentitykey field of the Item object.

Megaentityid String False

The Megaentityid field of the Item object.

Megaentityname String False

The Megaentityname field of the Item object.

Record_url String False

The Record_url field of the Item object.

Copyright (c) 2021 CData Software, Inc. - All rights reserved.
Build 21.0.7930