Get all summary attributes

get

/fscmRestApi/resources/11.13.18.05/purchaseRequisitions/{purchaseRequisitionsUniqID}/child/summaryAttributes

Request

Path Parameters
  • This is the hash key of the attributes which make up the composite key for the Purchase Requisitions resource and used to uniquely identify an instance of Purchase Requisitions. The client should not generate the hash key value. Instead, the client should query on the Purchase Requisitions collection resource in order to navigate to a specific instance of Purchase Requisitions to get the hash key.
Query Parameters
  • This parameter specifies dependencies which are fields that are set before and rolled back after generating the response. Generally they are used to preview the effects of an attribute change. The fields specified in this parameter are always set in the resource instance in question. When a child resource collection is requested and the parameter is set, the fields will be set in the parent resource instance before generating the resource collection payload. The value of this query parameter is a set of dependency fields. Example: dependency=ProductId=2

    Format: <attr1>=<val1>,<attr2>=<value2>
  • When this parameter is provided, the specified children are included in the resource payload (instead of just a link). The value of this query parameter is "all" or "". More than one child can be specified using comma as a separator. Example: ?expand=Employees,Localizations. Nested children can also be provided following the format "Child.NestedChild" (Example: ?expand=Employees.Managers). If a nested child is provided (Example: Employees.Managers), the missing children will be processed implicitly. For example, "?expand=Employees.Managers" is the same as "?expand=Employees,Employees.Managers" (which will expand Employees and Managers).
  • This parameter filters the resource fields. Only the specified fields are returned, which means that if no fields are specified, no fields are returned (useful to get only the links). If an indirect child resource is provided (Example: Employees.Managers), the missing children will be processed implicitly. For example, "?fields=Employees.Managers:Empname" is the same as "?fields=;Employees:;Employees.Managers:Empname" (which will only return the "Empname" field for Managers). the value of this query parameter is a list of resource fields. The attribute can be a direct (Example: Employees) or indirect (Example: Employees.Managers) child. It cannot be combined with expand query parameter. If both are provided, only fields will be considered.

    Format: ?fields=Attribute1,Attribute2

    Format for fields in child resource: ?fields=Accessor1:Attribute1,Attribute2
  • Used as a predefined finder to search the collection.

    Format: ?finder=<finderName>;<variableName>=<variableValue>,<variableName2>=<variableValue2>

    The following are the available finder names and corresponding finder variables:

    • DeliveryAndAmountSummaryFinder: Finds aggregated delivery, charge account, project, and requisition amount information across active lines and distributions in a requisition. The summary contains information about whether or not all the lines are delivered to the same location and the corresponding location details. It specifies if all the distributions are charged to the same charge account and provides corresponding account details. It retrieves the total requisition amount, the total nonrecoverable tax amount, and the requisition approval amount in the functional currency. It also specifies if the same project is applied to all distributions and provides corresponding project information.
      Finder Variables:
      • HeaderStatus; string; Value that identifies the requisition status.
    • IMTLinesSummaryFinder: Finds summary information about internal material transfer lines in a requisition. The summary includes the total number of internal material transfer lines and the number of lines for which the transfer price hasn't been derived.
      Finder Variables:
      • OneTimeLocationAcrossRequisitionFinder: Finds the count of the one-time location ID across different requisitions.
        Finder Variables:
        • bindOneTimeLocationId; integer; Value of the one-time location ID to find the one-time location count across requisitions.
        • bindRequisitionLineId; integer.
      • OneTimeLocationAcrossRequisitionLineFinder: Finds the count of one-time location ID across different requisition lines.
        Finder Variables:
        • bindOneTimeLocationId; integer; Value of the one-time location ID to find the one-time location count across requisition lines.
        • bindRequisitionLineId; integer; Value of the requisition line ID to find the one-time location count across other requisition lines.
      • OrdersAndBuyersSummaryFinder: Finds aggregated order and buyer information across lines in a requisition. The summary includes number of requisition lines excluding split and replaced lines, number of purchase orders that were opened, first purchase order number that has been moved to open status, first buyer either from the purchase order or the assigned buyer from the approved or returned requisition lines, and number of distinct buyers.
        Finder Variables:
        • PrimaryKey: Finds summary attributes for the purchase requisition according to the primary key.
          Finder Variables:
          • RequisitionHeaderId; integer; Value that uniquely identifies the requisition.
        • RequisitionDetailsSummaryFinder: Finds aggregated delivery information across all lines in a requisition. The summary contains information about whether or not all the lines are delivered to the same requester and the same location, and the corresponding requester and location details.
          Finder Variables:
        • This parameter restricts the number of resources returned inside the resource collection. If the limit exceeds the resource count then the framework will only return the available resources.
        • This parameter can be used to show only certain links while accessing a singular resource or a resource collection. The parameter value format is a comma-separated list of : <link_relation>

          Example:
          self,canonical
        • Used to define the starting position of the resource collection. If offset exceeds the resource count then no resources are returned. Default value is 0.
        • The resource item payload will be filtered in order to contain only data (no links section, for example).
        • This parameter orders a resource collection based on the specified fields. The parameter value is a comma-separated string of attribute names, each optionally followed by a colon and "asc" or "desc". Specify "asc" for ascending and "desc" for descending. The default value is "asc". For example, ?orderBy=field1:asc,field2:desc
        • This query parameter defines the where clause. The resource collection will be queried using the provided expressions. The value of this query parameter is one or more expressions. Example: ?q=Deptno>=10 and <= 30;Loc!=NY

          Format: ?q=expression1;expression2

          You can use these queryable attributes to filter this collection resource using the q query parameter:
          • OneTimeLocationCountAcrossRequisition; integer; Total count of the one-time locations available across requisition. This count doesn't include one-time location for the current requisition.
          • OneTimeLocationCountAcrossRequisitionLine; integer; Total count of the one-time locations available across requisition lines. This count doesn't include one-time location for the current requisition line.
        • The resource collection representation will include the "estimated row count" when "?totalResults=true", otherwise the count is not included. The default value is "false".
        Header Parameters
        • If the REST API supports runtime customizations, the shape of the service may change during runtime. The REST client may isolate itself from these changes or choose to interact with the latest version of the API by specifying this header. For example: Metadata-Context:sandbox="TrackEmployeeFeature".
        • The protocol version between a REST client and service. If the client does not specify this header in the request the server will pick a default version for the API.

        There's no request body for this operation.

        Back to Top

        Response

        Supported Media Types

        Default Response

        The following table describes the default response for this task.
        Headers
        • If the REST API supports runtime customizations, the shape of the service may change during runtime. The REST client may isolate itself from these changes or choose to interact with the latest version of the API by specifying this header. For example: Metadata-Context:sandbox="TrackEmployeeFeature".
        • The protocol version between a REST client and service. If the client does not specify this header in the request the server will pick a default version for the API.
        Body ()
        Root Schema : purchaseRequisitions-summaryAttributes
        Type: object
        Show Source
        Nested Schema : Items
        Type: array
        Title: Items
        The items in the collection.
        Show Source
        Nested Schema : purchaseRequisitions-summaryAttributes-item-response
        Type: object
        Show Source
        • Maximum Length: 1
          Contains one of the following values: Y, or N, or Null. If Y, the charge account is updated by the user on all the requisition lines. If N, the charge account isn't updated by the user on all the requisition lines. If Null, the charge account is updated by the user on some of the requisition lines.
        • Number of requisition lines excluding split and replaced lines for the requisition.
        • Maximum Length: 255
          Name of the buyer responsible for managing the requisition line or purchase order associated with the line through its life cycle.
        • Number of buyers from the orders that were opened or assigned to the lines for the requisition.
        • Value that uniquely identifies the buyer responsible for managing the requisition line or purchase order associated with the line through its life cycle.
        • Value that uniquely identifies the purchasing category across all the requisition lines. The value is set to Null if the purchasing category is different across the requisition lines.
        • Title: Charge Account
          Maximum Length: 255
          Account that the purchase from a requisition is charged to.
        • Value that uniquely identifies the account that the purchase from a requisition is charged to.
        • Maximum Length: 1
          Contains one of the following values: true or false. If true, all the requisition lines are charged to the same charge account. If false, then the charge account is different on lines. The default value is false.
        • Maximum Length: 1
          Contains one of the following values: true or false. If true, then the requisition contains lines that can't be edited. If false, then it doesn't contain noneditable lines. The default value is false.
        • Title: Deliver-to Location
          Maximum Length: 255
          Abbreviation that identifies the final location where the buying company should deliver the goods that were previously received from a supplier.
        • Value that uniquely identifies the final location where the buying company should deliver the goods that were previously received from a supplier.
        • Title: One-Time Location Address
          Maximum Length: 255
          Physical address of the one time location where the buying company should deliver the goods previously received from a supplier.
        • Value that uniquely identifies the one time location where the buying company should deliver the goods that were previously received from a supplier.
        • Maximum Length: 1
          Contains one of the following values: true or false. If true, all the requisition lines have the same delivery location. If false, then the delivery location is different on lines. The default value is false.
        • Maximum Length: 255
          Value that uniquely identifies the destination type code on the requisition lines. The value is set to Null if the destination type code is different across the requisition lines.
        • Maximum Length: 1
          Contains one of the following values: true or false. If true, then all the requisition lines are for master items. This attribute doesn't have a default value.
        • Maximum Length: 1
          Contains one of the following values: true or false. If true, then at least one of the requisition lines has a one-time deliver-to location type. This attribute doesn't have a default value.
        • Number of lines in the requisition.
        • Links
        • Value that's used to generate the identification key for a requisition.
        • Total count of the one-time locations available across requisition. This count doesn't include one-time location for the current requisition.
        • Total count of the one-time locations available across requisition lines. This count doesn't include one-time location for the current requisition line.
        • Value that uniquely identifies first purchase order that was opened for the requisition.
        • Maximum Length: 25
          Contains one of the following values: NONE, SINGLE, or MULTIPLE. If none of the distributions have project costing details associated with them, the attribute value is set to NONE. If all the distributions have exactly the same project and task associated with them, it is set to SINGLE. If the project and task associated with the distributions are different, it is set to MULTIPLE.
        • Value that uniquely identifies the project.
        • Maximum Length: 240
          Name of the project, which is displayed on the requisition header.
        • Maximum Length: 25
          Number of the project, which is displayed on the requisition header.
        • Maximum Length: 25
          Contains one of the following values: NONE, SINGLE, or MULTIPLE. If none of the distributions have project costing details associated with them, the attribute value is set to NONE. If all the distributions have the same project associated with them and the costing details are exactly the same, it is set to SINGLE. If the project costing details of the distributions are different, it is set to MULTIPLE.
        • Maximum Length: 255
          Number that identifies the first purchase order that was opened for the requisition.
        • Number of purchase orders that were opened for the requisition.
        • Title: Requested Delivery Date
          Date when the buying company requested the ordered item or service to be delivered.
        • Maximum Length: 240
          Display name of the person for whom goods or services are being ordered. The value is set to Null if the requester is different across requisition lines.
        • Value that uniquely identifies the person for whom goods or services are being ordered. The value is set to Null if the requester is different across the requisition lines.
        • Title: Approval Amount
          Sum total of RequisitionTotalAmount and RequisitionNonRecoverableTaxAmount expressed in the functional currency.
        • Value that uniquely identifies the requisition.
        • Title: Nonrecoverable Tax
          Sum total of nonrecoverable tax amounts across all requisition lines expressed in the functional currency.
        • Title: Requisition Amount
          Sum total of distribution amounts across all requisition lines expressed in the functional currency.
        • Maximum Length: 1
          Contains one of the following values: true or false. If true, all the requisition lines have the charge account either updated or not updated by the user. If false, the charge account is updated on some of the requisition lines by the user. This attribute doesn't have a default value.
        • Maximum Length: 1
          Contains one of the following values: true or false. If true, all the requisition lines have the same purchasing category. If false, the purchasing category is different across the requisition lines. This attribute doesn't have a default value.
        • Maximum Length: 1
          Contains one of the following values: true or false. If true, then all the lines in the requisition contain the same destination organization ID.
        • Maximum Length: 1
          Contains one of the following values: true or false. If true, then all the requisition lines have the same destination subinventory attribute. This attribute doesn't have a default value.
        • Maximum Length: 1
          Contains one of the following values: true or false. If true, all the requisition lines have the same destination type. If false, the destination type is different on the requisition lines. This attribute doesn't have a default value.
        • Maximum Length: 1
          Contains one of the following values: true or false. If true, all the requisition lines carry the same requested delivery date value. If false, then the requested delivery date is different on lines. The default value is false.
        • Maximum Length: 1
          Contains one of the following values: true or false. If true, all the requisition lines are ordered for the same person. If false, the requisition lines are ordered for different persons. This attribute doesn't have a default value.
        • Maximum Length: 1
          Contains one of the following values: true or false. If true, all the requisition lines have the same supplier. If false, the supplier is different across the requisition lines. This attribute doesn't have a default value.
        • Maximum Length: 240
          Name of the project task, which is displayed on the requisition header.
        • Maximum Length: 240
          Number of the project task, which is displayed on the requisition header.
        • Value that uniquely identifies the first transfer order that was opened for the requisition.
        • Number of internal material transfer lines in a requisition.
        • Maximum Length: 255
          Number that identifies the first transfer order that was opened for the requisition.
        • Number of transfer orders that were opened for the requisition.
        • Number of internal material transfer lines in a requisition for which the transfer price hasn't been derived.
        • Value that uniquely identifies the supplier across all the requisition lines. The value is set to Null if the supplier is different across the requisition lines.
        Back to Top

        Examples

        In this example, you use the finder in the following cURL command to get number of requisition lines excluding split and replaced lines, number of purchase orders that were opened, first purchase order number that has been moved to open status, first buyer either from the open purchase order or the assigned buyer from the approved or returned requisition lines, and number of distinct buyers.

        Example cURL Command

        Use the following cURL command to submit a request on the REST resource:

        curl -u username:password "https://servername/fscmRestApi/resources/version/purchaseRequisitions/purchaseRequisitionsUniqID/child/summaryAttributes?finder=OrdersAndBuyersSummaryFinder"

        Example Response Body

        The following shows an example of the response body in JSON format.

        {
        	"items": [
        	{
        		"RequisitionHeaderId": 300100195673138,
        		"ActiveLineCount": 4,
        		"PurchaseOrderCount": 2,
        		"BuyerCount": 2,
        		"PurchaseOrder": "1005761",
        		"Buyer": "Clare Jones",
        		"BuyerId": 100010026863783,
        		"POHeaderId": 300100195673174,
        		"links": [
        		{
        			"rel": "self",
        			"href": "https://servername/fscmRestApi/resources/version/purchaseRequisitions/300100195673138/child/summaryAttributes/300100195673138",
        			"name": "summaryAttributes",
        			"kind": "item"
        		},
        		{
        			"rel": "canonical",
        			"href": "https://servername/fscmRestApi/resources/version/purchaseRequisitions/300100195673138/child/summaryAttributes/300100195673138",
        			"name": "summaryAttributes",
        			"kind": "item"
        		},
        		{
        			"rel": "parent",
        			"href": "https://servername/fscmRestApi/resources/version/purchaseRequisitions/300100195673138",
        			"name": "purchaseRequisitions",
        			"kind": "item"
        		}
        		]
        	}
        	],
        	"count": 1,
        	"hasMore": false,
        	"limit": 25,
        	"offset": 0,
        	"links": [
        	{
        		"rel": "self",
        		"href": "https://servername/fscmRestApi/resources/version/purchaseRequisitions/300100195673138/child/summaryAttributes",
        		"name": "summaryAttributes",
        		"kind": "collection"
        	}
        	]
        }
        
        Back to Top