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