SupplierNegotiationssectionsrequirements
Enables creation of structured negotiation requirements or questions, requesting detailed information from bidding suppliers.
Columns
| Name | Type | Description |
| SupplierNegotiationsAuctionHeaderId [KEY] | Long | Unique identifier for the auction header, linking the requirement data to a specific auction event. This ID connects the requirement to its corresponding auction and can be found in the auction-related tables in the system. |
| SectionsSectionId [KEY] | Long | Unique identifier for the section within the auction, associating each requirement to a specific section. This value helps categorize requirements within the overall structure of the auction. |
| SectionId | Long | Unique identifier for the section, providing a consistent reference to the section in which the requirement is located. This is used to organize and manage requirements in the auction. |
| Section | String | Name or title of the section containing the requirement. This provides clarity on what part of the negotiation or auction the requirement belongs to. Accepted values can be found in the auction setup under 'Section' names. |
| RequirementId [KEY] | Long | Unique identifier for each requirement, used to track and reference specific requirements throughout the negotiation process. This ID helps differentiate each requirement within the section. |
| ScoreId | Long | Unique identifier for the scoring method associated with the requirement. This ties the requirement to its scoring criteria, which could be based on predefined or custom scoring methods. |
| ParentType | String | Defines the parent entity to which the requirement is linked, such as Supplier or Supplier site. Accepted values include 'Supplier' and 'Supplier Site', which can be found in the lookup type PON_SUPPLIER_LEVEL. |
| RequirementLevel | Decimal | Indicates the importance or priority level of the requirement. This value is used to weigh the requirement relative to others in the scoring process, determining how heavily it influences the overall score. |
| RequirementNumber | String | Unique number assigned to each requirement, helping to organize and reference them easily during negotiations. This number can be seen in the requirement catalog or auction documentation. |
| QuestionId | Long | Unique identifier for the question tied to the requirement. This ID links the requirement to the specific query or request the supplier must answer. |
| QuestionRevisionNumber | Int | Revision number of the question associated with the requirement, indicating if the question has been updated or modified. This helps track changes made to requirements. |
| PricingRequirementFlag | Bool | Indicates whether the requirement is related to pricing. If true, the requirement involves pricing information; if false, it does not. This can be cross-referenced with other pricing-related requirements in the auction. |
| Requirement | String | The name or title of the requirement, summarizing the key expectation or condition that the supplier must meet. This description can be found in the auction or negotiation documentation. |
| RequirementText | String | Text description providing detailed context for the requirement. This text clarifies what is being asked from the supplier and often includes additional instructions. |
| Hint | String | Helpful text displayed to suppliers to guide their response to the requirement. The hint offers additional clarification or advice to ensure correct and complete responses. |
| LevelCode | String | Abbreviation indicating the supplier level that the requirement applies to, such as 'Supplier' or 'Supplier Site'. Accepted values for this field are listed in the lookup type PON_SUPPLIER_LEVEL. |
| Level | String | Defines the supplier level for the requirement, providing clarity on whether the requirement applies to the supplier or their site. Accepted values include 'Supplier' and 'Supplier Site', which can be referenced in PON_SUPPLIER_LEVEL lookup. |
| ResponseTypeCode | String | Abbreviation indicating the required response type for the requirement, such as 'Required', 'Optional', 'Display Only', or 'Internal'. These values define the supplier's obligations regarding the requirement and can be found in the lookup type PON_HDR_ATTR_RESPONSE_TYPE. |
| ResponseType | String | Describes whether the response to the requirement is mandatory, optional, for display only, or for internal use. Accepted values are 'Required', 'Optional', 'Display Only', and 'Internal', defined in the lookup type PON_HDR_ATTR_RESPONSE_TYPE. |
| RequirementTypeCode | String | Abbreviation identifying the response type required for the requirement, such as 'Text Entry Box', 'Multiple Choice with Multiple Selections', or 'Multiple Choice with Single Selection'. These are found in the lookup type PON_REQUIREMENT_TYPE. |
| RequirementType | String | Specifies the format of the response expected for the requirement, such as 'Text Entry Box' or 'Multiple Choice'. Accepted values include 'Text Entry Box', 'Multiple Choice with Multiple Selections', or 'Multiple Choice with Single Selection', listed in the PON_REQUIREMENT_TYPE lookup. |
| ValueTypeCode | String | Abbreviation identifying the type of value expected for the requirement response, such as 'TXT' for text, 'NUM' for numbers, 'DAT' for dates, or 'URL' for web addresses. Refer to PON_REQ_RESPONSE_TYPE for accepted values. |
| ValueType | String | Defines the type of value the supplier should provide for the requirement, such as 'Single Line Text', 'Multiple Line Text', 'Number', 'Date', 'DateTime', or 'URL'. Accepted values are defined in the PON_REQ_RESPONSE_TYPE lookup. |
| TargetTextValue | String | The target text or URL that the supplier must match or respond with. This serves as the reference value for text-based responses, such as a specific URL or predefined text. |
| TargetNumberValue | Decimal | The target numeric value for the requirement, which suppliers need to match or align with in their responses. |
| TargetDateValue | Date | The target date value for the requirement, indicating the date that the supplier should reference in their response. |
| TargetDateTimeValue | Datetime | The target date and time value for the requirement, specifying an exact moment that the supplier must meet in their response. |
| DisplayTargetFlag | Bool | Indicates whether the target value should be visible to the supplier. If true, the supplier can see the target value; if false, they cannot. Default is false. |
| AttachmentsFromSuppliersCode | String | Abbreviation identifying whether supplier attachments are allowed, optional, or required. Accepted values include 'Not Allowed', 'Optional', or 'Required'. These can be found in the lookup type PON_REQ_ALLOW_ATTACHMENT. |
| AttachmentsFromSuppliers | String | Specifies the supplier attachment requirement for each requirement. Values include 'Not Allowed', 'Optional', or 'Required', as defined in the PON_REQ_ALLOW_ATTACHMENT lookup. |
| AllowCommentsFromSuppliersFlag | Bool | Indicates whether suppliers can provide comments on the requirement. If true, comments are allowed; if false, they are not. Default is false. |
| ScoringMethodCode | String | Abbreviation for the scoring method used to evaluate the supplier’s response, such as 'Automatic', 'Manual', or 'None'. These values are found in the lookup type PON_SCORING_TYPE. |
| ScoringMethod | String | Describes the method used to score the supplier’s response, with possible values including 'Automatic', 'Manual', or 'None'. This is used to standardize the evaluation process. |
| Weight | Decimal | Represents the relative importance of the requirement compared to other requirements in the negotiation. This weight is used to calculate the overall score for the requirement. |
| MaximumScore | Decimal | The maximum score a supplier can receive for a requirement response, setting the highest possible evaluation for the response. |
| KnockoutScore | Decimal | The minimum score required for the response to be considered acceptable and remain on the shortlist. Responses below this score are excluded. |
| CreatedBy | String | The name or identifier of the user who created the requirement record, ensuring accountability for data entry. |
| CreationDate | Datetime | The date and time when the requirement record was created, marking its initial entry into the system. |
| LastUpdateDate | Datetime | The date and time when the requirement record was last updated, indicating when the most recent changes were made. |
| LastUpdatedBy | String | The name or identifier of the user who last updated the requirement record, ensuring accountability for modifications. |
| AuctionHeaderId | Long | Unique identifier linking the requirement to the overall auction event, ensuring the requirement is associated with the correct auction. |
| Finder | String | Search reference used to filter or locate specific requirement records within the system. It aids in searching and managing requirements efficiently. |
| EffectiveDate | Date | This parameter is used to fetch resources that are valid as of the specified date, ensuring only relevant and up-to-date records are retrieved. |