FormFields
Query all expense form fields.
テーブル固有の情報
Select
本製品 はSAP Concur API を使用して、FormId カラムに基づくフィルタを処理します。本製品 はクライアント側で本製品 内で他のフィルタを処理します。例えば、次のクエリはサーバー側で処理されます。
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. |