RequisitionAttachments
Attachments for the requisition.
View-Specific Information
Select
The connector uses the SAP Ariba API to process WHERE clause conditions that are built with the following column and operators:
- ApprovableId supports the '=,IN' comparison operators.
For example, the following queries are processed server-side:
SELECT * FROM [RequisitionAttachments]
SELECT * FROM [RequisitionAttachments] WHERE [ApprovableId] = 'Val1'
The connector processes other filters client-side within the connector.
Columns
| Name | Type | References | Description |
| ApprovableId | String |
Requisitions.ApprovableId | The unique identifier of the approvable requisition. |
| RequisitionId | String | The identifier of the parent requisition. | |
| NumberInCollection | Int | The position index of this attachment entry. | |
| Id [KEY] | String | The unique identifier for the attachment. | |
| FileName | String | The filename of the attachment. | |
| ContentType | String | The MIME content type of the attachment. | |
| ContentLength | Int | The byte length of the attachment content. | |
| Url | String | The relative URL to download the attachment. | |
| ExternalAttachment | Bool | Indicates whether the attachment is stored externally. | |
| Date | Datetime | The date when the attachment was added. | |
| UserUniqueName | String | The unique system identifier for the user who added the attachment. | |
| UserName | String | The system login name of the user who added the attachment. | |
| UserFullName | String | The full human-readable name of the user who added the attachment. | |
| UserEmailAddress | String | The email address of the user who added the attachment. | |
| UserPhone | String | The phone number of the user who added the attachment. | |
| UserPasswordAdapter | String | The password adapter mechanism of the user who added the attachment. | |
| UserRealm | String | The realm of the user who added the attachment. |