000-349 · Question #21
Refer to the Exhibit. The Exhibit shows the components of a purchase order. The application requires that the total number of items (TotalItems) in the Trailer Record equals the sum of the quantity…
The correct answer is C. Trailer Record. A component rule on the Trailer Record can access both TotalItems and the QtyOrdered fields from all Detail Records, making it the correct scope for this cross-record validation.
Question
Refer to the Exhibit. The Exhibit shows the components of a purchase order. The application requires that the total number of items (TotalItems) in the Trailer Record equals the sum of the quantity ordered (QtyOrdered) for each purchase order. This verification can be performed by a component rule. Which component should have the component rule?
Options
- ATotalItems
- BQtyOrdered
- CTrailer Record
- DDetail Record
How the community answered
(30 responses)- A3% (1)
- B7% (2)
- C77% (23)
- D13% (4)
Why each option
A component rule on the Trailer Record can access both TotalItems and the QtyOrdered fields from all Detail Records, making it the correct scope for this cross-record validation.
TotalItems is a single field within the Trailer Record and does not have the scope to iterate over or sum QtyOrdered values across multiple Detail Records.
QtyOrdered is a field within an individual Detail Record and only has visibility into that single line item's quantity, not the trailer summary.
A component rule placed on the Trailer Record has access to TotalItems within the trailer and can iterate over all subordinate Detail Records to sum the QtyOrdered values, giving it the full scope needed for this verification. The Trailer Record is the parent container that logically owns both the summary field and the relationship to the detail data. This is the appropriate level to enforce a rule that compares a summary field against an aggregated value from child records.
Placing the rule on the Detail Record would only validate individual occurrences and lacks access to the Trailer Record's TotalItems field for comparison.
Concept tested: Component rule scope for cross-record aggregation validation
Topics
Community Discussion
No community discussion yet for this question.