Query expense form fields.

Table Specific Information

Select

The driver uses the SAP Concur APIs to process filters that are based on the FormId column. The driver processes other filters client-side within the driver. For example, the following query is processed server side:

SELECT * FROM FormFields WHERE FormId = '12345'

You can turn off the client-side execution of the query by setting SupportEnhancedSQL to false.

Columns

Name	Type	References	Description
Id [KEY]	String		The form field ID.
FormId [KEY]	String	Forms.Id	The ID of the form.
Label	String		The form field label..
ControlType	String		The type of field.
DataType	String		The type of data accepted by the field.
MaxLength	Integer		The maximum length of the field value.
IsRequired	String		Whether the field is required.
ColumnNumber	Integer		The number of columns the field contains.
Access	String		The access level the specified user has to the field.
Width	String		The width of the field.
IsCustom	String		Whether the field is custom.
Sequence	Integer		The field order on the form.