ERPOrderSAPcreatedRange
A 'system vsap' view template that queries 'ERPOrder' transaction data.
View-Specific Information
Select
The cmdlet uses the SAP Ariba API to process WHERE clause conditions built with the following columns and operators. The cmdlet processes other filters client-side within the cmdlet.
- IncludeInactive supports the '=' comparison operator.
- createdDateFrom supports the '=' comparison operator.
- createdDateTo supports the '=' comparison operator.
SELECT * FROM ERPOrderSAPcreatedRange WHERE createdDateFrom='2024-01-01 00:00:00.0' AND createdDateTo='2024-02-01 00:00:00.0'
SELECT * FROM ERPOrderSAPcreatedRange WHERE IncludeInactive='True'
Columns
Name | Type | References | Description |
ApprovedState | String | An integer value representing the current approval state of a purchase order. This field is used for internal purpose only. | |
InitialUniqueName | String | The ID of the purchase order when it was first created. This field is used for internal purpose only. | |
InvoicedState | String | The status indicating whether a line item is invoiced (fully or partially) or not invoiced. | |
SubmitDate | Datetime | The date when a purchase order is successfully submitted for approval. | |
ReceivedState | String | The status indicating whether a line item is received (either fully or partially) or not received. | |
HoldTillDate | Datetime | The date until which processing of a fully approved requisition is withheld. | |
SupplierLocation_State | String | ||
SupplierLocation_Phone | String | ||
SupplierLocation_Country_UniqueName | String | ||
SupplierLocation_PostalCode | String | ||
SupplierLocation_City | String | ||
SupplierLocation_Fax | String | ||
SupplierLocation_UniqueName | String | ||
SupplierLocation_Lines | String | ||
SupplierLocation_Name | String | ||
NumberReceivableOrders | Int | The number of orders that are not fully received. | |
OrderID | String | The unique ID of a purchase order. Example: PO456. | |
OrderStatusPunchOutDisabled | Bool | Indicates whether the punchout link on a purchase order is disabled. | |
ChargeAmount_AmountInReportingCurrency | Decimal | ||
ChargeAmount_ApproxAmountInBaseCurrency | Decimal | ||
ChargeAmount_Amount | Decimal | ||
ChargeAmount_ConversionDate | Datetime | ||
ChargeAmount_Currency_UniqueName | String | ||
CreateDate | Datetime | The date when a purchase order is created. | |
Conditions_UniqueName | String | ||
Conditions_TAndCVersion | Int | ||
Name | String | The title of a purchase order. | |
TotalCost_AmountInReportingCurrency | Decimal | ||
TotalCost_ApproxAmountInBaseCurrency | Decimal | ||
TotalCost_Amount | Decimal | ||
TotalCost_ConversionDate | Datetime | ||
TotalCost_Currency_UniqueName | String | ||
OrderConfirmationState | String | The status of the order confirmation for a purchase order. | |
LastModified | Datetime | The date when a purchase order was last modified. Actions that lead to updates to the history record of a purchase order trigger changes to the last modified date. | |
TimeCreated | Datetime | The time when a purchase order is created. | |
AdvancedShipNoticeState | String | The status of the ship notice for an order. | |
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. | |
Version | Int | The internal version number assigned to an approvable document. This field is used for optimistic locking and ensures that changes to the document are followed in an appropriate sequence. This field is used for internal purposes only. | |
InvoicedDate | Datetime | The date when an order was last invoiced. | |
UsePOLineNumberForIntegration | Bool | Determines how a line number is assigned to an item on the purchase order. Depending on the settings for the Application.Procure.UsePOLineNumberForExternalIntegration parameter, this field can contain the line number assigned to it in the buying solution or retain the line number assigned in the external ERP system. | |
AmountAccepted_AmountInReportingCurrency | Decimal | ||
AmountAccepted_ApproxAmountInBaseCurrency | Decimal | ||
AmountAccepted_Amount | Decimal | ||
AmountAccepted_ConversionDate | Datetime | ||
AmountAccepted_Currency_UniqueName | String | ||
LineItems | String | ||
OrderConfirmationStatusString | String | The status of the order confirmation associated with a purchase order. | |
ChangedBy_UniqueName | String | ||
OrderedState | String | The status of an order. This field can contain one of the following values: Ordering, Ordered, Canceled, Ordered with Errors or Unordered. | |
ApprovedDate | Datetime | The date when a purchase order is fully approved. | |
PreviousApprovalRequestsVersion | Int | The version number for the previous version of the approval request. This field is used for internal purpose only. | |
ResubmitDate | Datetime | The date when a purchase order is resubmitted for approval. A purchase order is considered as resubmitted if a user edits a denied purchase order and resubmits it for approval. Note: Purchase orders that are withdrawn by the preparer and submitted again are not considered as resubmitted purchase orders. | |
NumberCleared | Decimal | The number of invoiced items on an order that have been cleared after invoices are reconciled. | |
OrderMethodCategory | String | The ordering method configured for a customer site. This field contains one of the following values: Direct, PCard, or ERP. | |
RejectionReason | String | The reason provided by a supplier on Ariba Network while rejecting an order. | |
Active | Bool | Indicates whether a purchase order is currently in use in the buying solution. This field can contain the values as True or False. False indicates inactive purchase orders. Inactive purchase orders are considered as those that are deleted and do not appear in search results and purchase order choosers. | |
ReceivedDate | Datetime | The date when a shipment of an item was last received. | |
AmountBilled_AmountInReportingCurrency | Decimal | ||
AmountBilled_ApproxAmountInBaseCurrency | Decimal | ||
AmountBilled_Amount | Decimal | ||
AmountBilled_ConversionDate | Datetime | ||
AmountBilled_Currency_UniqueName | String | ||
NextVersion | String | ||
NumberBilled | Decimal | The total number of invoiced items on an order. | |
UniqueName | String | The unique ID of a purchase order. Example: PO456. | |
ReportingCurrency_UniqueName | String | ||
OrderedDate | Datetime | The date when an order is sent to the supplier. | |
ManuallyOrdered | Bool | Indicates whether an order needs to be processed manually. | |
IsFromExternalReq | Bool | Indicates whether an order originated from Fieldglass. Fieldglass orders are not included in order choosers when users select orders to create PO-based invoices. | |
MasterAgreement_UniqueName | String | ||
AmountCleared_AmountInReportingCurrency | Decimal | ||
AmountCleared_ApproxAmountInBaseCurrency | Decimal | ||
AmountCleared_Amount | Decimal | ||
AmountCleared_ConversionDate | Datetime | ||
AmountCleared_Currency_UniqueName | String | ||
OriginatingSystem | String | The external system from which a order is imported. This field contains the value Imported if the ID of the external system is not available. | |
PaymentTerms_UniqueName | String | ||
NumberReceivableLineItems | Int | The number of line items on a purchase order that are not fully received. | |
Attachments | String | ||
AmountReconciled_AmountInReportingCurrency | Decimal | ||
AmountReconciled_ApproxAmountInBaseCurrency | Decimal | ||
AmountReconciled_Amount | Decimal | ||
AmountReconciled_ConversionDate | Datetime | ||
AmountReconciled_Currency_UniqueName | String | ||
Supplier_UniqueName | String | ||
Supplier_Name | String | ||
AmountRejected_AmountInReportingCurrency | Decimal | ||
AmountRejected_ApproxAmountInBaseCurrency | Decimal | ||
AmountRejected_Amount | Decimal | ||
AmountRejected_ConversionDate | Datetime | ||
AmountRejected_Currency_UniqueName | String | ||
StatusString | String | The status of a purchase order. Example: Ordering or Ordered. | |
PreOrdered | Bool | Indicates whether a purchasing card order originated from the buying solution and not an external system. | |
IsBlanketOrder | Bool | Indicates whether an order is a blanket purchase order. | |
PreviousVersion | String | ||
ApprovalRequestsVersion | Int | The version of an approval request when it was generated. This field is used for internal purpose only. | |
AmountInvoiced_AmountInReportingCurrency | Decimal | ||
AmountInvoiced_ApproxAmountInBaseCurrency | Decimal | ||
AmountInvoiced_Amount | Decimal | ||
AmountInvoiced_ConversionDate | Datetime | ||
AmountInvoiced_Currency_UniqueName | String | ||
TimeUpdated | Datetime | The time when a purchase order was last updated. | |
OriginatingSystemReferenceID | String | The external system ID of an order associated with an imported requisition. | |
VersionNumber | Int | The version number of an order. | |
Type | String | The internal name for the approvable document. For example, the internal name for purchase order is ariba.purchasing.core.PurchaseOrder. | |
ExpirationDate | Datetime | The expiration date of a purchase order. | |
Closed | String | Indicates whether an order is closed for invoicing. This field can contain one of these values: 1 - The purchase order is in an Open state, 2 - The purchase order is closed for change, 3 - The purchase order is closed for receiving, 4 - The purchase order is closed for invoicing, 5 - The purchase order is closed for all actions, 6 - The purchase order is adjusted and closed for receiving, 7 - The purchase order is closed for receiving and invoicing, or -1 - The purchase order is closed for various actions. | |
IsServiceOrder | Bool | Indicates whether a purchase order is a service purchase order. Note: Service purchase orders are orders consisting of service items that follow the service sheet process. | |
Requisition_UniqueName | String | ||
Preparer_UniqueName | String | The user who creates a requisition and submits it for approval. | |
CompanyCode_UniqueName | String | The unique name for the SAP company code. | |
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. | |
createdDateFrom | Datetime | This filter corresponds to the 'TimeCreated' field. The operation is '>' and the default value is '2018-03-01T23:59:59Z'. | |
createdDateTo | Datetime | This filter corresponds to the 'TimeCreated' field. The operation is '<=' and the default value is '2018-03-29T23:59:59Z'. |