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 | 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. |