Ratetablepoentry

Retrieves Ratetablepoentry report data.

Table Specific Information

To retrieve information from the Ratetable 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 cost code ID
Standardtaskkey	Long	True	Standard cost code key
Standardtaskname	String	False	Standard cost code 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
Itemdimkey	Long	True	Item key
Itemid	String	False	Item ID
Itemname	String	False	Item name
Locationkey	Long	True	Location key
Location	String	False	Location
Locationname	String	False	Location name
Startdate	Date	False	Start date
Markuppct	Decimal	False	Markup percent
Unitprice	Decimal	False	Unit price
Projectdimkey	Long	False	Projectdimkey
Projectid	String	False	Job
Projectname	String	False	Job 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
Taskdimkey	Long	False	Taskdimkey
Taskid	String	False	Cost Code
Taskname	String	False	Cost Code name
Costtypedimkey	Long	False	Costtypedimkey
Costtypeid	String	False	Cost type
Costtypename	String	False	Cost type name
Record_url	String	True	A portable, user-independent, deep-link URL for viewing this record

JDBC Driver for Sage Intacct

Ratetablepoentry

Table Specific Information

Columns