SupplierNegotiationPurchasingDocumentsPurchasingDocumentsAwardedLines
Returns the awarded negotiation lines included in the purchasing documents created from supplier negotiations.
Columns
| Name | Type | SupportedFinders | Description |
| SupplierNegotiationPurchasingDocumentsAuctionHeaderId [KEY] | Long | Value that finds purchasing document header details using the AuctionHeaderId as the primary key. | |
| PurchasingDocumentsResponseNumber [KEY] | Long | Value that finds purchasing document details using the Response Number as the primary key. | |
| PurchasingDocumentsSequenceNumber [KEY] | Decimal | Value that finds purchasing document details using the Sequence Number as the primary key. | |
| AuctionHeaderId | Long | PrimaryKey | Value that uniquely identifies a negotiation. |
| ResponseNumber [KEY] | Long | Uniquely identifies supplier's response for a negotiation. | |
| SequenceNumber [KEY] | Decimal | Display sequence of the staged purchasing documents or purchasing documents within a negotiation. | |
| LineNumber [KEY] | Decimal | Line number in a supplier response. | |
| LineFilteringNumber | Decimal | Converts the values in the Line column from strings to numbers, allowing the column to be sorted and the values to be used in filters. | |
| AuctionLineNumber | Decimal | Value that identifies the line number of the negotiation line. For an alternate line, the value refers to the line number of the original negotiation line for which the alternate was created. | |
| Quantity | Decimal | Quantity of the item in the negotiation. | |
| ItemRevision | String | Item revision associated to the purchase order line. | |
| Description | String | Description of the awarded line item. | |
| ItemId | Long | Unique identifier for the item. | |
| CategoryId | Long | Value that identifies the purchasing category for the negotiation line. | |
| LineTypeLookupCode | String | Value that uniquely identifies the line item type using the lookup code. | |
| RequisitioningBUId | Long | Unique identifier of the requisitioning business unit in business unit access. | |
| InvOrgId | Long | An organization that tracks inventory transactions and balances, and may also manufacture or distribute products. | |
| CategorySetId | Long | Collection of items grouped into categories. | |
| DisplayLineNumber | Decimal | Display line number of the negotiation line. | |
| PromisedDeliveryDate | Date | Date on which the supplier has promised to deliver the goods to the buying organization. | |
| PromisedShipDate | Date | Date on which the supplier has promised to ship the goods to the buying organization if the Buyer Managed transportation is checked in negotiation terms. | |
| AlternateLineFlag | Bool | Value that indicates if alternate lines are present in the negotiation. | |
| UOMCode | String | Abbreviation that identifies the unit of measure for the item in the negotiation. | |
| RetainageRate | Decimal | Percentage of the amount requested that will be withheld before releasing payments to the contractor. | |
| MaximumRetainageAmount | Decimal | Maximum amount of retainage that can be withheld on a line. | |
| StagedDocumentDisplayLineNumber | String | Display line number for a negotiation line in a staged purchasing document. | |
| AlternateLineDescription | String | Description of an alternate line. | |
| CategoryName | String | Name of the purchasing category. | |
| UnitOfMeasure | String | Abbreviation that identifies the unit of measure for the item in the negotiation. | |
| ResponseCurrencyCode | String | Abbreviation that identifies the currency that the response uses. | |
| PricePrecision | Int | Indicates the accuracy (number of decimal places) with which the price values will be displayed in the award. | |
| OrderLineAmount | Decimal | Total amount ordered for the purchase order line. | |
| OrderLineAmountResponseCurrency | Decimal | Total amount ordered for the purchase order line in response currency. | |
| AgreementLineAmount | Decimal | Amount in negotiation currency for the awarded line in a purchasing agreement. | |
| AgreementLineAmountResponseCurrency | Decimal | Amount in response currency for the awarded line in a purchasing agreement. | |
| LinePriceResponseCurrency | Decimal | Price of the negotiation line item in response currency. | |
| UnitPrice | Decimal | Price per unit in negotiation currency. | |
| OrderLineItemNumber | String | Value that identifies the item number of a purchase order line. | |
| SupplierItem | String | Name of the item in the supplier company. | |
| Requisition | String | Requisition number that the negotiation line references. | |
| RequisitionLine | String | Requisition line number that the negotiation line references. | |
| OutcomeStatus | String | Status to indicate outcome creation. | |
| RequisitionLineItemId | Long | Unique identifier of the backing requisition line item in a supplier negotiation. | |
| Finder | String | A named finder reference used to filter or locate specific awarded purchasing document lines when querying. |