JDBC Driver for Oracle Fusion Cloud Financials

Build 25.0.9434

DraftSupplierNegotiationResponsessectionsrequirements

Lists specific requirements or questions within each section, prompting suppliers to provide data or clarifications.

Columns

Name Type Description
DraftSupplierNegotiationResponsesResponseNumber [KEY] Long The unique identifier for the negotiation response, linking the requirement section to a specific response within the negotiation.
SectionsResponseNumber [KEY] Long The unique identifier for the response within the section, linking the requirement section to a specific response in the negotiation.
SectionsSectionId [KEY] Long The unique identifier for the section in the response, linking the requirement section to a specific part of the negotiation.
ResponseNumber [KEY] Long The unique identifier for the supplier’s response, used to track and manage the specific offer made by the supplier for the requirement.
SectionId Long The unique identifier for the section, linking the requirement to the specific section within the negotiation response.
Section String The name of the requirement section, providing context for the group of requirements within the negotiation.
RequirementId [KEY] Long The unique identifier for the requirement, linking it to the specific element of the negotiation and its corresponding response.
ScoreId Long The unique identifier for the score associated with the requirement, providing a reference for the evaluation of the supplier’s response.
ParentType String The type of the requirement's parent. If the section is the parent of another requirement, the ParentType is SECTION. If not, it is SCORE.
RequirementLevel Decimal The level of the requirement in the hierarchy. Level 1 is for parent sections, while level 2 and beyond represent branching requirements with specific score-based responses.
RequirementNumber String The unique identifier for the requirement’s sequence, helping to order the requirements within the negotiation process.
QuestionId Long The unique identifier for the question associated with the requirement, linking the requirement to a predefined question.
QuestionRevisionNumber Int The revision number of the predefined question associated with the requirement, tracking updates or changes to the question over time.
Requirement String The name or title of the requirement, describing what the supplier needs to respond to in the negotiation.
RequirementText String The description of the requirement, providing detailed instructions or context to help the supplier understand the expectation.
Hint String Text that is displayed to the supplier to assist in responding to the requirement, offering guidance on how to meet the requirement.
LevelCode String An abbreviation that identifies the supplier level for the requirement. Values include 'Supplier' or 'Supplier Site', as defined in the 'PON_SUPPLIER_LEVEL' lookup.
Level String The supplier level for the requirement, indicating whether the requirement is for the supplier or the supplier site, as defined in the 'PON_SUPPLIER_LEVEL' lookup.
ResponseTypeCode String An abbreviation that specifies whether a response is required for the requirement. Values include 'Required', 'Optional', 'Display Only', or 'Internal', defined in the 'PON_HDR_ATTR_RESPONSE_TYPE' lookup.
ResponseType String Specifies whether a response for the requirement is required, optional, displayed only for reference, or internal for the negotiation process. Values are defined in the 'PON_HDR_ATTR_RESPONSE_TYPE' lookup.
RequirementTypeCode String An abbreviation that uniquely identifies the type of response required for the requirement. Values include 'Text Entry Box', 'Multiple Choice with Multiple Selections', and 'Multiple Choice with Single Selection', defined in the 'PON_REQUIREMENT_TYPE' lookup.
RequirementType String The type of response required for the negotiation, such as 'Text Entry Box' for open text, 'Multiple Choice with Multiple Selections', or 'Multiple Choice with Single Selection', defined in the 'PON_REQUIREMENT_TYPE' lookup.
ValueTypeCode String An abbreviation that identifies the type of value expected for the requirement. Accepted values are defined in the 'PON_REQ_RESPONSE_TYPE' lookup.
ValueType String The type of value expected for the requirement, such as 'Single Line Text', 'Multiple Line Text', 'Number', 'Date', 'Date and Time', or 'URL', as defined in the 'PON_REQ_RESPONSE_TYPE' lookup.
TargetTextValue String The target value for the requirement when the value type is text or URL, representing the desired response.
TargetNumberValue Decimal The target value for the requirement when the value type is a number, indicating the expected numerical response.
TargetDateValue Date The target value for the requirement when the value type is a date, specifying the desired date response.
TargetDateTimeValue Datetime The target value for the requirement when the value type is a date and time, specifying the expected datetime response.
Comments String Comments entered by the supplier in response to the requirement, providing additional context or explanations related to the requirement.
CreatedBy String The user who created the requirement record, providing accountability for the data entry.
CreationDate Datetime The timestamp when the requirement record was created, establishing when the information was first entered into the system.
LastUpdateDate Datetime The timestamp of the last update to the requirement record, tracking modifications made after the initial creation.
LastUpdatedBy String The user who most recently updated the requirement record, ensuring accountability for changes.
AllowAttachmentCode String A value that determines whether the supplier can add attachments with the requirement. Valid values are 'OPTIONAL', 'REQUIRED', and 'NON_ALLOWED'. The default is 'NON_ALLOWED'.
AllowCommentsFlag Bool A flag indicating whether the supplier is allowed to add comments with the requirement. If true, comments can be added; if false, comments are not allowed. The default value is false.
Finder String A search identifier used to locate specific requirement records within the system.
EffectiveDate Date The date from which the requirement is considered effective, marking when the requirement starts to apply within the negotiation process.

Copyright (c) 2025 CData Software, Inc. - All rights reserved.
Build 25.0.9434