Fields tab

The Fields tab shows the fields that are read from the Salesforce module selected on the Settings tab. You will need to go to the Fields tab and press the Get Fields button to populate the fields returned before you can preview the rows returned.

Fields tab in Salesforce Input

The following properties are shown in the Fields tab.

Option	Description
Name	The name of the input field.
Field	The name of the field that contains the record.
IsIdLookup?	Specify if the field will be used as a fieldname ID (links to an External ID) when accessing the database to perform other calls, such as delete, insert, update, and upsert. Select Y (Yes) or N (No).
Type	The data type of the field.
Format	An optional mask for converting the format of the original field.
Length	The length of the field depends on the following field types:- Number Total number of significant figures in a number. String Total length of string. Date Length of printed output of the string (for example, four is a length for a year).
Precision	Number of floating-point digits for number-type fields.
Currency	Symbol used to represent currencies. For example: $ or €
Decimal	A decimal point can be a . or , (5,000.00 or 5.000,00 for example).
Group	A grouping can be a , or . (5,000.00 or 5.000,00 for example).
Trim type	The trimming method to apply to a string. Trimming only works when no field length is specified.
Repeat	If the corresponding value in this row is empty, repeat the one from the last time it was not empty. Select Y (Yes) or N (No).

See [Understanding PDI data types and field metadata](../../../../Data%20Integration%20Perspective/Data%20Integration%20perspective%20in%20the%20PDI%20client/Advanced%20topics%20(PDI%20perspective)/Understanding%20PDI%20data%20types%20and%20field%20metadata.md) to maximize the efficiency of your transformation and job results.