PurchaseRequisitionssummaryAttributes
Aggregates summary-level data on a requisition, consolidating details from all lines for higher-level review or analysis.
Columns
| Name | Type | SupportedFinders | Description |
| PurchaseRequisitionsRequisitionHeaderId [KEY] | Long | The unique identifier for the requisition header associated with the summary attributes data, linking the summary to a specific requisition. Example: 1001 for Requisition Header 1001. | |
| RequisitionHeaderId [KEY] | Long | PrimaryKey | The identifier for the requisition header, linking the summary attributes data to the parent requisition record. Example: 2001 for 'Requisition Header 2001'. |
| ActiveLineCount | Decimal | The total number of active lines within the requisition header, indicating the number of lines still in use or not completed. Example: 5 for five active lines. | |
| PurchaseOrderCount | Decimal | The total number of purchase orders associated with the requisition. Example: 3 for three purchase orders linked to the requisition. | |
| TransferOrderCount | Decimal | The total number of transfer orders associated with the requisition. Example: 2 for two transfer orders created for the requisition. | |
| BuyerCount | Decimal | The total number of buyers associated with the requisition. Example: 1 for a single buyer responsible for the requisition. | |
| PurchaseOrder | String | The purchase order number associated with the requisition. Example: 'PO12345' for a specific purchase order. | |
| TransferOrder | String | The transfer order number associated with the requisition. Example: 'TO6789' for a specific transfer order. | |
| Buyer | String | The name of the buyer responsible for the requisition. Example: 'John Smith' for the buyer managing the requisition. | |
| BuyerId | Long | The unique identifier for the buyer assigned to the requisition. Example: 1234 for 'John Smith'. | |
| POHeaderId | Long | The unique identifier for the purchase order header linked to the requisition. Example: 5678 for 'PO5678'. | |
| TOHeaderId | Long | The unique identifier for the transfer order header linked to the requisition. Example: 9012 for 'TO9012'. | |
| LineCount | Decimal | The total number of lines in the requisition. Example: 10 for ten lines in the requisition. | |
| DeliverToSingleLocationFlag | Bool | Indicates whether the requisition items are to be delivered to a single location. Example: True if all items are delivered to one location. | |
| DeliverToLocationCode | String | The code representing the delivery location for the requisition items. Example: 'NYC' for New York City. | |
| DeliverToLocationId | Long | The unique identifier for the location to which the requisition items will be delivered. Example: 12345 for 'Main Warehouse'. | |
| DeliverToOneTimeLocationAddress | String | The address of a one-time delivery location for the requisition items, if applicable. Example: '456 Temporary St, New York, NY'. | |
| DeliverToOneTimeLocationId | Long | The unique identifier for a one-time delivery location. Example: 67890 for a temporary delivery address. | |
| SameRequestedDeliveryDateFlag | Bool | Indicates whether all lines in the requisition have the same requested delivery date. Example: True if all lines share the same date. | |
| RequestedDeliveryDate | Date | The requested delivery date for the requisition items. Example: '2023-06-15' for items requested to be delivered on June 15, 2023. | |
| SameBudgetDateFlag | Bool | Indicates whether all requisition lines have the same budget date. Example: True if all lines are tied to the same budget date. | |
| BudgetDate | Date | The budget date associated with the requisition, used for budget consumption tracking. Example: '2023-01-01' for the start of the budget period. | |
| ChargeToSingleAccountFlag | Bool | Indicates whether all requisition items are charged to a single account. Example: True if all charges go to one account. | |
| ChargeAccount | String | The account to which the requisition items are charged. Example: 'Office Supplies' for the relevant charge account. | |
| ChargeAccountId | Long | The unique identifier for the charge account associated with the requisition. Example: 101 for 'Office Supplies Account'. | |
| RequisitionTotalAmount | Decimal | The total amount for the requisition, including all items and charges. Example: 5000 for a requisition totaling $5000. | |
| RequisitionNonRecoverableTaxAmount | Decimal | The amount of non-recoverable tax associated with the requisition. Example: 50 for $50 of non-recoverable tax. | |
| RequisitionApprovalAmount | Decimal | The approved amount for the requisition, which may differ from the requested amount based on approval processes. Example: 4800 for an approved amount of $4800. | |
| OneTimeLocationCountAcrossRequisition | Long | The number of one-time locations used across the entire requisition. Example: 2 for two one-time locations. | |
| OneTimeLocationCountAcrossRequisitionLine | Long | The number of one-time locations used across the individual lines in the requisition. Example: 1 for one line with a one-time location. | |
| ProjectCostingDetailsCode | String | The project costing details code, used to categorize the requisition for project-based accounting. Example: 'PCD123' for a specific project cost code. | |
| ProjectId | Decimal | The unique identifier for the project associated with the requisition. Example: 1001 for 'Project 1001'. | |
| ProjectNumber | String | The project number associated with the requisition. Example: 'PRJ-567' for a specific project number. | |
| ProjectName | String | The name of the project associated with the requisition. Example: 'Office Expansion Project'. | |
| CategoryId | Long | The unique identifier for the category of items or services requested in the requisition. Example: 101 for 'Office Supplies'. | |
| SameCategoryIdFlag | Bool | Indicates whether all requisition lines share the same category. Example: True if all items belong to the same category. | |
| VendorId | Long | The unique identifier for the vendor supplying the requisition items. Example: 12345 for 'XYZ Corporation'. | |
| SameVendorIdFlag | Bool | Indicates whether all requisition lines are associated with the same vendor. Example: True if all lines are supplied by the same vendor. | |
| RequesterId | Long | The unique identifier for the requester of the requisition. Example: 2345 for 'Alice Johnson'. | |
| Requester | String | The name of the individual who requested the requisition items. Example: 'Alice Johnson'. | |
| SameRequesterIdFlag | Bool | Indicates whether all requisition lines have the same requester. Example: True if all lines were requested by the same person. | |
| SuggestedBuyerId | Long | The unique identifier for the suggested buyer of the requisition items. Example: 3456 for 'Bob Smith'. | |
| SuggestedBuyer | String | The name of the suggested buyer for the requisition items. Example: 'Bob Smith'. | |
| SameSuggestedBuyerIdFlag | Bool | Indicates whether all requisition lines have the same suggested buyer. Example: True if all lines are suggested to be bought by the same buyer. | |
| PrcBUId | Long | The unique identifier for the procurement business unit associated with the requisition. Example: 4567 for 'Procurement Unit A'. | |
| SamePrcBUIdFlag | Bool | Indicates whether all requisition lines are assigned to the same procurement business unit. Example: True if all lines are handled by the same unit. | |
| DestinationTypeCode | String | The code representing the type of destination for the requisition items, such as 'WARE' for warehouse or 'STOR' for store. Example: 'WARE'. | |
| SameDestinationTypeCodeFlag | Bool | Indicates whether all requisition lines share the same destination type. Example: True if all lines are destined for the warehouse. | |
| AccountUserOverrideFlag | Bool | Indicates whether the user has overridden the default account for the requisition. Example: True if the account was manually adjusted. | |
| SameAccountUserOverrideFlag | Bool | Indicates whether all requisition lines have the same account override status. Example: True if all lines have the same override status. | |
| TaskNumber | String | The task number associated with the requisition, often used in project-based requisitions. Example: 'TASK-001' for the first task. | |
| TaskName | String | The name or description of the task associated with the requisition. Example: 'Procurement for Office Supplies'. | |
| ProjectsInformationAcrossLines | String | A summary or categorization of project-related information shared across all lines in the requisition. Example: 'Office Expansion Project'. | |
| TotalIMTLinesCount | Decimal | The total number of IMT (Internal Material Transfer) lines within the requisition. Example: 5 for five IMT lines. | |
| UnprocessedIMTLinesCount | Decimal | The number of unprocessed IMT lines within the requisition. Example: 2 for two unprocessed lines. | |
| ContainsNoneditableLinesFlag | Bool | Indicates whether the requisition contains lines that are non-editable. Example: True if there are non-editable lines. | |
| SameDestinationOrganizationIdFlag | Bool | Indicates whether all requisition lines have the same destination organization. Example: True if all lines are assigned to the same organization. | |
| SameDestinationSubinventoryFlag | Bool | Indicates whether all requisition lines have the same destination subinventory. Example: True if all lines are assigned to the same subinventory. | |
| HasOneTimeLocAcrossLinesFlag | Bool | Indicates whether the requisition contains one-time locations across multiple lines. Example: True if multiple lines involve one-time locations. | |
| HasAllMasterItemsFlag | Bool | Indicates whether the requisition contains only master items. Example: True if all items are master items. | |
| MaximumSequenceNumber | Long | The maximum sequence number assigned to the requisition lines, used to track line order. Example: 10 for the 10th sequence number. | |
| BindPreparerId | Long | InternallyManagedRequisitionsFinder, ActiveRequisitionInPreferredBUFinder | The unique identifier for the preparer of the requisition, linking the summary attributes data to the preparer. Example: 1234 for 'John Doe'. |
| BindRequisitionHeaderId | Long | ViewAccessibleRequisitionDetailsFinder | The unique identifier for the requisition header, linking the summary attributes data to the parent requisition record. Example: 2001 for 'Requisition Header 2001'. |
| Finder | String | A placeholder or reference used for searching and locating specific requisition summary data. Example: 'Search by PO Number'. | |
| CUReferenceNumber | Int | The reference number used to map child aggregates (such as summary attributes) to their parent requisition or requisition line. Example: 1001 for 'Requisition Line 1'. | |
| EffectiveDate | Date | The date from which the requisition summary attributes data is considered effective. Example: '2023-01-01' for data valid from the start of the year. |