Power BI Connector for SugarCRM

Build 25.0.9454

Shippers

Stores shipping provider records that are used in fulfillment workflows. This table supports order fulfillment and logistics management.

Columns

Name Type ReadOnly Description
Commentlog String True

The comment log entries that are associated with this shipper record. This field stores collaboration notes, operational updates, or historical context.

Created_By String True

The unique identifier (Id) of the user who created this shipper 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 shipper record. This value is shown in the user interface for readability and reporting.

Date_Entered Datetime True

The date and time when this shipper record was created. This value supports lifecycle tracking and audit visibility.

Date_Modified Datetime True

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

Default_Cost Decimal True

The default shipping cost that is associated with this shipper. This value can be used for pricing, quoting, and billing calculations.

Default_Cost_Usdollar Decimal True

The default shipping cost expressed in U.S. dollars (USDs). This value is used for consistent currency comparison and financial reporting.

Deleted Bool False

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

Description String False

A detailed description of the shipper. This field can include service details, carrier notes, or usage guidance.

Following Bool False

A Boolean field that returns a value of 'true' when the current user is following this shipper 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 shipper record. This value is used to reference and manage the shipper across the system.

List_Order Int True

The position of this shipper in ordered lists or dropdown selections. This value influences display priority.

Locked_Fields String True

The list of fields that are restricted from editing for this shipper record. This field prevents unauthorized or system-managed fields from being changed.

Modified_By_Name String True

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

Modified_User_Id String True

The Id of the user who most recently updated this shipper record. This value identifies the source of the most recent modification.

My_Favorite Bool False

A Boolean field that returns a value of 'true' when the shipper 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 shipper. This value is used as the primary label throughout the system.

Status String False

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

Sync_Key String True

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

Tag String False

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

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