JDBC Driver for Oracle Fusion Cloud Financials

Build 25.0.9434

DraftSupplierNegotiationResponsessectionsrequirementsresponseValues

Holds the supplier's actual responses (text, numeric, date) for each requirement in a draft negotiation response.

Columns

Name Type Description
DraftSupplierNegotiationResponsesResponseNumber [KEY] Long The unique identifier for the negotiation response, linking the response value to a specific response within the negotiation.
SectionsResponseNumber [KEY] Long The unique identifier for the response within the section, allowing the response value to be associated with a specific section in the negotiation.
SectionsSectionId [KEY] Long The unique identifier for the section in the response, linking the requirement response value to a specific section within the negotiation.
RequirementsRequirementId [KEY] Long The unique identifier for the requirement, linking the response value to a specific requirement within the negotiation.
RequirementsResponseNumber [KEY] Long The unique identifier for the response within the requirement, linking the response value to the supplier's response to that specific requirement.
ResponseNumber Long The unique identifier for the requirement response value, applicable for text entry box responses where no scoring is involved.
SectionId Long The unique identifier for the section, associating the requirement response value with a specific section of the negotiation.
Section String The name of the requirement section, providing context for the group of requirements in the negotiation.
RequirementId Long The unique identifier for the requirement, linking the response value to the specific requirement in the negotiation.
RequirementNumber String The unique identifier for the sequence of the requirement, helping to order and track individual requirements within the negotiation.
Requirement String The name of the requirement, describing what the supplier is asked to respond to in the negotiation.
RequirementLevel Decimal The hierarchical level at which the requirement is located, with Level 1 being the parent section and subsequent levels representing branching requirements with acceptable response scores.
RequirementValueId [KEY] Long The unique identifier for the response value, linking the specific value provided by the supplier to the requirement.
ScoreId Long The unique identifier for the response score, applicable for requirements such as 'Multiple Choice with Single Selection' or 'Multiple Choice with Multiple Selections'.
QuestionId Long The unique identifier for the requirement associated with a predefined question, linking the response value to the specific question.
ScoreDisplayNumber String The display number assigned to the score, helping to organize and identify the scores associated with multiple-choice responses or other numerical responses.
ResponseValueText String The response value for a requirement where the response type is text, providing the supplier's text-based answer.
ResponseValueNumber Decimal The response value for a requirement where the response type is a number, representing the numerical answer provided by the supplier.
ResponseValueDate Date The response value for a requirement where the response type is a date, representing the date provided by the supplier.
ResponseValueDateTime Datetime The response value for a requirement where the response type is date and time, representing the specific datetime provided by the supplier.
IsSelectedFlag Bool A flag indicating whether the response value is selected in 'Multiple Choice' requirements. If true, the response is selected; if false, it is not selected.
TargetTextValue String The target value set by the category manager for text or URL responses, providing the desired response for the requirement.
TargetNumberValue Decimal The target value set by the category manager for numerical responses, indicating the desired numerical answer for the requirement.
TargetDateValue Date The target value set by the category manager for date responses, specifying the desired date for the requirement.
TargetDatetimeValue Datetime The target value set by the category manager for date and time responses, specifying the desired datetime for the requirement.
CreatedBy String The user who created the response value record, providing accountability for the data entry.
CreationDate Datetime The timestamp when the response value record was created, establishing when the data was first entered into the system.
LastUpdateDate Datetime The timestamp of the last update to the response value record, tracking modifications after the initial creation.
LastUpdatedBy String The user who most recently updated the response value record, ensuring accountability for changes made.
AllowAttachmentCode String A value that determines whether the supplier can add attachments with the requirement responses. Valid values include 'OPTIONAL', 'REQUIRED', and 'NON_ALLOWED', with the default being 'NON_ALLOWED'.
attachments String A placeholder for attachment data, allowing the supplier to attach additional files or documents related to the requirement response.
Finder String A search identifier used to locate specific requirement response value records within the system.
EffectiveDate Date The date from which the requirement response value is considered effective, marking when it starts to apply in the negotiation process.

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