Ratetabletsentry

Retrieves Ratetabletsentry report data.

Table Specific Information

To retrieve information from the Ratetabletsentry table, Sage Intacct needs to have the Construction subscription enabled and the EnableSubscriptions connection property set.

Columns


Name	Type	ReadOnly	Description
Recordno [KEY]	Long	True	Record number
Lineno	Long	True	Line number
Ratetablekey	Long	True	Rate table key
Ratetableid	String	False	Rate table ID
Ratetablename	String	False	Rate table name
Description	String	False	Description
Whencreated	Datetime	True	Timestamp marking last time this was created.
Whenmodified	Datetime	True	Timestamp marking last time this was changed.
Createdby	Long	True	User who created this.
Modifiedby	Long	True	User who modified this.
Standardtaskid	String	False	Standard task ID
Standardtaskkey	Long	True	Standard task key
Standardtaskname	String	False	Standard task name
Standardcosttypeid	String	False	Standard cost type ID
Standardcosttypekey	Long	True	Standard cost type key
Standardcosttypename	String	False	Standard cost type name
Accumulationtypekey	Long	True	Accumulation type key
Accumulationtypename	String	False	Accumulation type name
Emppositionkey	Long	True	Employee position key
Emppositionid	String	False	Employee position ID
Emppositionname	String	False	Employee position name
Timetypekey	Long	True	Time type key
Timetypename	String	False	Time type name
Laborclasskey	Long	True	Labor class key
Laborclassid	String	False	Labor class ID
Laborclassname	String	False	Labor class name
Laborshiftkey	Long	True	Labor shift key
Laborshiftid	String	False	Labor shift ID
Laborshiftname	String	False	Labor shift name
Laborunionkey	Long	True	Labor union key
Laborunionid	String	False	Labor union ID
Laborunionname	String	False	Labor union name
Locationkey	Long	True	Location key
Location	String	False	Location
Locationname	String	False	Location name
Departmentkey	Long	True	Department key
Department	String	False	Department
Departmenttitle	String	False	Department title
Startdate	Date	False	Start date
Markuppct	Decimal	False	Markup percent
Laborrate	Decimal	False	Labor rate
Projectdimkey	Long	False	Projectdimkey
Projectid	String	False	Project
Projectname	String	False	Project name
Customerdimkey	Long	False	Customerdimkey
Customerid	String	False	Customer
Customername	String	False	Customer name
Vendordimkey	Long	False	Vendordimkey
Vendorid	String	False	Vendor
Vendorname	String	False	Vendor name
Employeedimkey	Long	False	Employeedimkey
Employeeid	String	False	Employee
Employeename	String	False	Employee name
Itemdimkey	Long	False	Itemdimkey
Itemid	String	False	Item
Itemname	String	False	Item name
Classdimkey	Long	False	Classdimkey
Classid	String	False	Class
Classname	String	False	Class name
Record_url	String	True	A portable, user-independent, deep-link URL for viewing this record

Power BI Connector for Sage Intacct

Ratetabletsentry

Table Specific Information

Columns