CData Python Connector for SugarCRM

Build 25.0.9454

TaxRates

Stores tax rate definitions used in pricing and billing. This table supports financial compliance and transaction accuracy.

Columns

Name Type ReadOnly Description
Commentlog String True

The comment log entries that are associated with this tax rate record. This field stores collaboration notes or administrative context.

Created_By String True

The unique identifier (Id) of the user who created this tax rate record. This value identifies the record author for auditing and ownership tracking.

Created_By_Name String True

The display name of the user who created this tax rate record. This value is shown in the user interface for clarity and reference.

Date_Entered Datetime True

The date and time when this tax rate record was created. This value supports lifecycle tracking and audit review.

Date_Modified Datetime True

The date and time when this tax rate record was most recently updated. This field supports version history and change transparency.

Deleted Bool False

A Boolean field that returns a value of 'true' when this tax rate record is marked as deleted. It returns a value of 'false' when the record remains active and available.

Description String False

A detailed description of the tax rate. This field can include usage notes, jurisdiction details, or regulatory context.

Following Bool False

A Boolean field that returns a value of 'true' when the current user is following this tax rate record to receive activity updates. It returns a value of 'false' when the user is not following the record.

Id [KEY] String True

The Id for this tax rate record. This value is used to reference and manage the record throughout the system.

List_Order Int False

The position of this tax rate in ordered lists or selection menus. This value influences display priority.

Locked_Fields String True

The list of fields that are restricted from editing for this tax rate record. This field prevents modification of protected or system-governed values.

Modified_By_Name String True

The display name of the user who most recently modified this tax rate record. This value provides visibility into update history.

Modified_User_Id String True

The Id of the user who most recently updated this tax rate record. This value identifies the source of the latest change.

My_Favorite Bool False

A Boolean field that returns a value of 'true' when the tax rate record is marked as a favorite by the current user. It returns a value of 'false' when it is not marked as a favorite.

Name String False

The name of the tax rate. This value is used as the primary label in user interfaces and reporting.

Status String False

The current status of the tax rate (for example, 'Active' or 'Inactive'). This value determines whether the tax rate is available for use.

Sync_Key String True

The synchronization key that is used to match this tax rate record with external systems. This value supports data consistency across integrations.

Tag String False

The tags that are associated with this tax rate record. Tags support flexible classification, grouping, and filtering.

Value Decimal False

The rate value expressed as a decimal. This value is used to calculate tax amounts on applicable transactions.

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