|
|
Context |
Optional. Property set of variables shared across all rows. |
Row Set |
The set of rows to process. |
Output Row Set |
Optional. The property set used for output. |
Process Condition |
A Boolean condition that is evaluated to determine whether to process each row. |
Hierarchy Business Object |
The business object to query to retrieve the hierarchy (example: Account). |
Hierarchy Business Component |
The business component to query to retrieve the hierarchy (example: Account). |
Row ID Field |
The hierarchical ID field in the input row (example: "Account Id"). |
HBC ID Field |
The ID field of the hierarchy business component (example: "Id"). |
HBC Parent Field |
The parent ID field in the hierarchy business component (example: "Parent Account Id"). |
HBC Visibility Mode |
Optional. The visibility mode of the hierarchy business component query. |
HBC Search Specification |
Optional. An additional search specification that is applied to the hierarchy query. |
Business Object |
The business object to query for matching records (example: Agreement). |
Business Component |
The business component to query for matching records (example: Agreement Item). |
Search Specification |
A search expression comprised of business component fields, literals, and variable values from {Context} and {Row}. For example: [Product Id] = {Row.Product Id} AND [Effective From] <= Today() AND ([Effective To] IS NULL OR [Effective To] >= Today())
|
In Memory Search Specification |
Optional. Additional terms that are ANDed with the Search Specification. The In Memory Search Specification is executed in memory. This can be used only if Cache Enabled is Y. |
Cache Search Specification |
Optional. Additional terms that define the key values for the Level 1 cache; for example: [Price List Id] = {Row.Price List Id})
For more information, see About PSP Cache. |
Sort Specification |
Optional. A comma-separated list of business component fields used to sort the query result. |
Cache Enabled |
Optional. Specifies whether to cache query results. Y or N. The default is N. |
BC ID Field |
The hierarchy object ID field on the query business component (example: Account Id). |
On First Match [1..20] |
Actions to perform on the first query result for each input row. |
On Match [1..20] |
Actions to perform on every query result for each input row. |
On Last Match [1..20] |
Actions to perform on the last query result for each input row. |
On No Match [1..20] |
Actions to perform if there are no query results for an input row. |