PurchaseRequisitionssummaryAttributes
Aggregates summary-level data on a requisition, consolidating details from all lines for higher-level review or analysis.
Columns
| Name | Type | 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 | 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 | The unique identifier for the preparer of the requisition, linking the summary attributes data to the preparer. Example: 1234 for 'John Doe'. |
| BindRequisitionHeaderId | Long | 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. |