Search

PowerExchange for Salesforce User Guide

PowerExchange for Salesforce User Guide

10.5.3
- 10.5.9
- 10.5.8
- 10.5.7
- 10.5.4
- 10.5.2
- 10.5.1
- 10.5
- 10.4.1
- 10.4.0

Back Next

Column Properties

Column Properties

The column properties display the data types, precision, and scale of the source property in the data object read operation.

The following table describes the source column properties of the data object read operation:

Property	Description
Name	Name of the column
Type	Native data type of the column
Precision	Maximum number of significant digits for numeric data types, or maximum number of characters for string data types. For numeric data types, precision includes scale.
Scale	Maximum number of digits after the decimal point for numeric values
Description	Description of the column
Creatable	Indicates whether the field allows inserts
Updateable	Indicates whether the field allows updates
ExternalD	Salesforce custom fields only. Indicates whether the field is designated as an external ID field. Each Salesforce object can contain a single custom field designated as the external ID field. Salesforce appends custom field names with “__c”. For more information about external ID and custom fields, see the Salesforce documentation.
SforceName	Field name in Salesforce
ReferenceTo	Gets referenced object
IDLookup	Specifies a record in an upsert call. The ID field of each object and some Name fields have this property. There are exceptions, so use Salesforce to check for this property in any object that you want to upsert.
Filterable	Indicates whether the field can be used in the FROM or WHERE clause of an SOQL query.
Label	Field label in Salesforce
Access Type	Indicates whether the field has read and write permissions.

Source Properties of the Data Object Read Operation

Watch

Comments

0 COMMENTS

We’d like to hear from you! Log in to comment.