FormFields
Query all 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 | Description |
| Id [KEY] | String | The form field ID. |
| FormId [KEY] | String | 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. |