FormFields
Query expense form fields.
Table Specific Information
Select
The adapter uses the SAP Concur APIs to process filters that are based on the FormId column. The adapter processes other filters client-side within the adapter. 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. |