ODBC Driver for Salesforce

Build 25.0.9540

PicklistValueDependency

Contains predefined picklist relations for fields across different Salesforce objects.

Columns

Name Type References Description
TableName String The name of the Salesforce object (table) associated with the picklist. Required when retrieving picklist data.
ColumnName String The name of the column that the picklist is associated with. Optionally used to filter results to a specific column.
PickListValue String The internal value stored in Salesforce for this picklist entry.
PickListLabel String The user-friendly label displayed in the Salesforce UI for the picklist value.
PickListIsActive Boolean Indicates whether the picklist value is currently active and available for selection.
PickListIsDefault Boolean Indicates whether this picklist value is set as the default for its associated column.
DependentOn String The name of the PickList which the current list depends on.
DependentValue String The internal value stored in Salesforce for this picklist entry.
DependentLabel String The user-friendly label displayed in the Salesforce UI for the picklist value.
DependentIsActive Boolean Indicates whether the picklist value is currently active and available for selection.
DependentIsDefault Boolean Indicates whether this picklist value is set as the default for its associated column.

Pseudo-Columns

SELECT ステートメントのWHERE 句では、疑似カラムフィールドを使用して、データソースから返されるタプルを詳細に制御することができます。

Name Type Description
RecordTypeId String Optional identifier for the record type. Use this to return picklist values specific to a particular record type.

Copyright (c) 2026 CData Software, Inc. - All rights reserved.
Build 25.0.9540