ReceiptSAPupdatedRange
A 'system vsap' view template that queries 'Receipt' transaction data.
View-Specific Information
Select
The add-in uses the SAP Ariba API to process WHERE clause conditions built with the following columns and operators. The add-in processes other filters client-side within the add-in.
- IncludeInactive supports the '=' comparison operator.
- updatedDateFrom supports the '=' comparison operator.
- updatedDateTo supports the '=' comparison operator.
SELECT * FROM ReceiptSAPupdatedRange WHERE updatedDateFrom='2024-01-01 00:00:00.0' AND updatedDateTo='2024-02-01 00:00:00.0'
SELECT * FROM ReceiptSAPupdatedRange WHERE IncludeInactive='True'
Columns
| Name | Type | References | Description |
| ApprovedState | String | An integer value that represents the current approval state of a receipt. This field is used for internal purpose only. | |
| ReceiptItems | String | ||
| ProcessedState | String | The post-approval processing state of a receipt. The post-approval processing states can be one of the following for receipts imported from external systems: 0 - Unprocessed, 1 – Awaiting Processing, 2 – Processing, 3 – Failed Processing, or 4 - Processed. Note: Receipts created in the buying solution move to the Processed state after they are fully approved. | |
| MasterAgreement_UniqueName | String | ||
| InitialUniqueName | String | The ID of the receipt when it was first created. This field is used for internal purpose only. | |
| SubmitDate | Datetime | The date when a receipt was successfully submitted for approval. | |
| HoldTillDate | Datetime | The date until which post-approval processing of the associated requisition was withheld. | |
| CreateDate | Datetime | The date when a receipt was created. | |
| Attachments | String | ||
| IsReceiptPushFailed | Bool | Indicates whether a receipt failed to be pushed to the external ERP system. | |
| Name | String | The title of the receipt. | |
| IsInTransitionToManual | Bool | Indicates the transition stage of a receipt in which line items configured for auto-receiving transition from automatic receiving to the manual receiving state. This field is set to true when a user creates manual receipts for line items that are configured for automatic receiving. | |
| LastModified | Datetime | The date when a receipt was last modified. Actions that lead to updates to the history record or the comments section of a receipt trigger changes to the last modified date. | |
| TimeCreated | Datetime | The time when a receipt was created. | |
| GoodsReturnTrackingNumber | String | The goods return tracking number to identify items returned to suppliers. | |
| Requester_UniqueName | String | The user on behalf of whom a requisition is created. Typically, the preparer and requester of a requisition are the same user. If a preparer creates a requisition for someone else, the requester is the user for whom the requisition is created. | |
| CloseOrder | Bool | Indicates whether the buying solution automatically closes an order for further receiving after the associated receipts are fully approved. | |
| ERPReceiptNumber | String | The ID assigned to a receipt imported from the external ERP system. | |
| DueDate | Datetime | The due date for creation of an automatic receipt. | |
| Order_UniqueName | String | ||
| StatusString | String | The approval state of a receipt. Example: Composing, Submitted, or Approved. | |
| ChangedBy_UniqueName | String | ||
| ApprovedDate | Datetime | The date when the status of a receipt changed to Approved. | |
| PreviousApprovalRequestsVersion | Int | The version number for the previous version of the approval request. This field is used for internal purpose only. | |
| RecentReceiveDate | Datetime | The most recent date when a receipt transaction was performed for a line item. | |
| PreviousVersion | String | ||
| ResubmitDate | Datetime | The date when a receipt was resubmitted for approval. A receipt is considered as resubmitted when a user edits a denied receipt and resubmits it for approval. Note: Receipts that are withdrawn by the preparer and submitted again are not considered as resubmitted receipts. | |
| ApprovalRequestsVersion | Int | The version of an approval request when it was generated. This field is used for internal purpose only. | |
| TimeUpdated | Datetime | The time when a receipt was last updated. | |
| VersionNumber | Int | Indicates whether the changes for the receipt version are internal to the buying solution. | |
| ApprovalRequests | String | ||
| Active | Bool | Indicates whether a receipt is currently in use in the buying solution. This field can contain the values as True or False. False indicates inactive receipts. Inactive receipts are considered as those that are deleted and do not appear in search results and receipt choosers. | |
| IsImported | Bool | Indicates whether a receipt is imported from an external system | |
| Type | String | The internal name for the approvable document. For example, the internal name for receipt is ariba.receiving.core.Receipt. | |
| ANSentState | String | The state of transmission of a receipt to Ariba Network. This field can contain one of the following values: Sent (2), Sending (4), or Failed (8). | |
| ProcurementUnit_UniqueName | String | ||
| NextVersion | String | ||
| IsUnitPriceChanged | Bool | Indicates whether the unit price of a line item on a receipt was edited. | |
| UniqueName | String | The unique ID of a receipt. Example: RC678. | |
| Preparer_UniqueName | String | The user who creates a requisition and submits it for approval. | |
| IncludeInactive | Bool | By default, API responses do not include inactive transactions. You can set this query parameter to true to include inactive transactions in the responses. | |
| updatedDateFrom | Datetime | This filter corresponds to the 'TimeUpdated' field. The operation is '>' and the default value is '2018-03-01T23:59:59Z'. | |
| updatedDateTo | Datetime | This filter corresponds to the 'TimeUpdated' field. The operation is '<=' and the default value is '2018-03-29T23:59:59Z'. |