JDBC Driver for Oracle Fusion Cloud Financials

Build 24.0.9060

SupplierNegotiationssectionsrequirements

The Requirements resource manages details about the requirements of a supplier negotiation.

Columns

Name Type Description
SupplierNegotiationsAuctionHeaderId [KEY] Long SupplierNegotiationsAuctionHeaderId of SupplierNegotiationssectionsrequirements
SectionsSectionId [KEY] Long SectionsSectionId of SupplierNegotiationssectionsrequirements
SectionId Long SectionId of SupplierNegotiationssectionsrequirements
Section String Section of SupplierNegotiationssectionsrequirements
RequirementId [KEY] Long RequirementId of SupplierNegotiationssectionsrequirements
ScoreId Long ScoreId of SupplierNegotiationssectionsrequirements
ParentType String ParentType of SupplierNegotiationssectionsrequirements
RequirementLevel Decimal RequirementLevel of SupplierNegotiationssectionsrequirements
RequirementNumber String RequirementNumber of SupplierNegotiationssectionsrequirements
QuestionId Long QuestionId of SupplierNegotiationssectionsrequirements
QuestionRevisionNumber Int QuestionRevisionNumber of SupplierNegotiationssectionsrequirements
PricingRequirementFlag Bool PricingRequirementFlag of SupplierNegotiationssectionsrequirements
Requirement String Name of the requirement.
RequirementText String Text that describes the requirement.
Hint String Text that the application displays to the supplier to help respond to the requirements.
LevelCode String Abbreviation that uniquely identifies the supplier level for the requirement. Values include Supplier or Supplier site. A list of accepted values is defined in the lookup type PON_SUPPLIER_LEVEL.
Level String Supplier level for the requirement. Values include Supplier or Supplier site. A list of accepted values is defined in the lookup type PON_SUPPLIER_LEVEL.
ResponseTypeCode String Abbreviation that specifies whether the response for the requirement is required. Values include Required, Optional, Display Only, or Internal. A list of accepted values is defined in the lookup type PON_HDR_ATTR_RESPONSE_TYPE.
ResponseType String Specifies whether the response for the requirement is required. Values include Required, Optional, Display Only, or Internal. A list of accepted values is defined in the lookup type PON_HDR_ATTR_RESPONSE_TYPE.
RequirementTypeCode String Abbreviation that uniquely identifies the type of response that the negotiation requires. Values include Text Entry Box, Multiple Choice with Multiple Selections, or Multiple Choice with Single Selection. A list of accepted values is defined in the lookup type PON_REQUIREMENT_TYPE.
RequirementType String Type of response that the negotiation requires. Values include Text Entry Box, Multiple Choice with Multiple Selections, or Multiple Choice with Single Selection. A list of accepted values is defined in the lookup type PON_REQUIREMENT_TYPE.
ValueTypeCode String Abbreviation that identifies the type of value for the requirement. A list of accepted values is defined in the lookup type PON_REQ_RESPONSE_TYPE.
ValueType String Type of value for the requirement. Values include Single Line Text, Multiple Line Text, Number, Date, Date and Time, or URL (Uniform Resource Locator). A list of accepted values is defined in the lookup type PON_REQ_RESPONSE_TYPE.
TargetTextValue String Target text or URL (Uniform Resource Locator) values of the requirement.
TargetNumberValue Decimal Value that the user entered in the attribute. This value is applicable for numbers.
TargetDateValue Date Value that the user entered in the attribute. This value is applicable for dates.
TargetDateTimeValue Datetime Value that the user entered. This value is applicable for date and time.
DisplayTargetFlag Bool Contains one of the following values: true or false. If true, then display the target value to the supplier. If false, then do not display. The default value is false.
AttachmentsFromSuppliersCode String Abbreviation that uniquely identifies the requirement for each supplier attachment. Values include Not Allowed, Optional, or Required. A list of accepted values is defined in the lookup type PON_REQ_ALLOW_ATTACHMENT.
AttachmentsFromSuppliers String Requirement for each supplier attachment. Values include Not Allowed, Optional, or Required. A list of accepted values is defined in the lookup type PON_REQ_ALLOW_ATTACHMENT.
AllowCommentsFromSuppliersFlag Bool Contains one of the following values: true or false. If true, then allow the supplier to provide comments to each requirement. If false, then do not allow. The default value is false.
ScoringMethodCode String Abbreviation that uniquely identifies the method that the application uses to score each requirement response. Values include Automatic, Manual, or None. A list of accepted values is defined in the lookup type PON_SCORING_TYPE.
ScoringMethod String Method that the application uses to score each requirement response. Values include Automatic, Manual, or None. A list of accepted values is defined in the lookup type PON_SCORING_TYPE.
Weight Decimal Importance of the requirement when compared to other requirements. The application uses this weight when it calculates the requirement score.
MaximumScore Decimal Highest possible score for the requirement response.
KnockoutScore Decimal Lowest requirement score that the response can receive and remain part of the shortlist.
CreatedBy String CreatedBy of SupplierNegotiationssectionsrequirements
CreationDate Datetime CreationDate of SupplierNegotiationssectionsrequirements
LastUpdateDate Datetime LastUpdateDate of SupplierNegotiationssectionsrequirements
LastUpdatedBy String LastUpdatedBy of SupplierNegotiationssectionsrequirements
AuctionHeaderId Long AuctionHeaderId of SupplierNegotiationssectionsrequirements
Finder String Finder of SupplierNegotiationssectionsrequirements

Copyright (c) 2024 CData Software, Inc. - All rights reserved.
Build 24.0.9060