Excel Add-In for Sage Intacct

Build 25.0.9434

Ratetableapentry

Stores AP-specific rate table entries, providing currency exchange data, rates, and related accounts payable fields.

Table Specific Information

To retrieve information from the Ratetablepoentry table, Sage Intacct needs to have the Construction subscription enabled and the EnableSubscriptions connection property set to one or more subscription names.

  • If the connection property is not set, the table is not visible in the metadata for users.
  • If the connection property is set, you can run simple SELECT * queries.

Columns

Name Type ReadOnly Description
Recordno [KEY] Long True

Unique identifier for the record entry.

Lineno Long True

Unique identifier for a specific line item within the entry.

Ratetablekey Long True

Reference key for the associated rate table.

Ratetableid String False

Identifier for the rate table.

Ratetablename String False

Name of the associated rate table.

Description String False

Description or notes about the entry.

Whencreated Datetime True

Timestamp indicating when the entry was created.

Whenmodified Datetime True

Timestamp indicating when the entry was last modified.

Createdby Long True

Identifier of the user who created the entry.

Modifiedby Long True

Identifier of the user who last modified the entry.

Standardtaskid String False

Identifier for the associated standard cost code.

Standardtaskkey Long True

Reference key for the associated standard cost code.

Standardtaskname String False

Name of the associated standard cost code.

Standardcosttypeid String False

Identifier for the associated standard cost type.

Standardcosttypekey Long True

Reference key for the associated standard cost type.

Standardcosttypename String False

Name of the associated standard cost type.

Accumulationtypekey Long True

Reference key for the accumulation type.

Accumulationtypename String False

Name of the accumulation type.

Locationkey Long True

Reference key for the associated location.

Location String False

Details of the associated location.

Locationname String False

Name of the associated location.

Departmentkey Long True

Reference key for the associated department.

Department String False

Details of the associated department.

Departmenttitle String False

Title of the associated department.

Startdate Date False

Start date of the entry.

Markuppct Decimal False

Percentage markup applied to the entry.

Projectdimkey Long False

Reference key for the associated project dimension.

Projectid String False

Identifier for the associated project or job.

Projectname String False

Name of the associated project or job.

Customerdimkey Long False

Reference key for the associated customer dimension.

Customerid String False

Identifier for the associated customer.

Customername String False

Name of the associated customer.

Vendordimkey Long False

Reference key for the associated vendor dimension.

Vendorid String False

Identifier for the associated vendor.

Vendorname String False

Name of the associated vendor.

Employeedimkey Long False

Reference key for the associated employee dimension.

Employeeid String False

Identifier for the associated employee.

Employeename String False

Name of the associated employee.

Itemdimkey Long False

Reference key for the associated item dimension.

Itemid String False

Identifier for the associated item.

Itemname String False

Name of the associated item.

Taskdimkey Long False

Reference key for the associated task dimension.

Taskid String False

Identifier for the associated cost code.

Taskname String False

Name of the associated cost code.

Costtypedimkey Long False

Reference key for the associated cost type dimension.

Costtypeid String False

Identifier for the associated cost type.

Costtypename String False

Name of the associated cost type.

Record_url String True

User-independent, deep-link URL for accessing the record.

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