FormFields
Query expense form fields.
Table Specific Information
Select
The add-in uses the SAP Concur APIs to process filters that are based on the FormId column. The add-in processes other filters client-side within the add-in. For example, the following query is processed server side:
SELECT * FROM FormFields WHERE FormId = '12345'
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. |