Power BI Connector for Oracle Fusion Cloud Financials

Build 25.0.9454

DraftSupplierNegotiationResponses

Tracks supplier draft responses to negotiations (RFI, RFQ, auctions) before final submission, allowing iterative updates.

Columns

Name Type Description
ResponseNumber [KEY] Long The unique identifier for the supplier's response, used to differentiate and reference individual responses in the negotiation.
ResponseDisplayName String A descriptive label for the response, such as 'Bid', 'Quote', or 'Response', providing context for the response's purpose.
ResponseIntent String Indicates whether the supplier's intent is to revise or copy an existing response. Accepted values are 'Copy' (to copy the existing response), 'Revise' (to update an existing response), and 'Null' (no change to the original response).
ResponseStatus String The current status of the response, such as 'Submitted', 'Under Review', or 'Closed', indicating the stage of the negotiation process.
PreviousResponseNumber Long The identifier for the previous response, used to default values from the earlier response into the current one, ensuring consistency in revisions.
OriginalResponseNumber Long The identifier for the original response in a series of revised bids, tracking the first submission in the sequence.
AuctionHeaderId Long The unique identifier for each negotiation, linking the response to a specific auction or negotiation event.
NegotiationTitle String The title given to the negotiation, defined by the category manager to summarize the purpose or scope of the negotiation.
Negotiation String The unique number that identifies the negotiation, allowing for tracking and referencing the negotiation across systems.
CloseDate Datetime The date when the negotiation stops accepting responses from suppliers, indicating the final deadline for submitting offers.
TimeRemaining String The remaining time until the negotiation is closed, typically displayed in days, hours, or minutes.
BuyerId Long The unique identifier for the user who created the negotiation, helping to link the negotiation to the buyer responsible for it.
Buyer String The name of the user who initiated the negotiation, providing accountability for the negotiation process.
BuyerEmail String The email address of the buyer who created the negotiation, used for communication and updates.
CompanyId Long The unique identifier for the buyer's company, linking the negotiation to the company responsible for it.
Company String The name of the company associated with the buyer, providing context for which organization is conducting the negotiation.
SupplierId Long The unique identifier for the supplier responding to the negotiation, helping to track which supplier provided the response.
Supplier String The name of the supplier who submitted the response to the negotiation, indicating the entity involved.
SupplierSiteId Long The identifier for the supplier site, allowing for differentiation between multiple locations of the same supplier.
SupplierSite String The name of the supplier site where the response originated, indicating the physical location of the supplier.
SupplierContactId Long The identifier for the supplier contact associated with the response, helping to track who from the supplier’s organization is responsible for the response.
SupplierContact String The name of the supplier contact who responded to the negotiation, used for follow-up communication.
TwoStageEvaluationFlag Bool Indicates whether a two-stage evaluation process is enabled for the negotiation. If true, it allows for both technical and commercial evaluation; if false, it is not enabled.
NegotiationDisplayName String A display name for the type of supplier negotiation, such as 'Solicitation' or 'Request for Proposals', providing a clear description of the negotiation type.
NegotiationCurrencyCode String The abbreviation of the currency used in the negotiation, such as 'USD' for US Dollars or 'EUR' for Euros.
NegotiationCurrency String The name of the currency used in the negotiation, for example, US Dollars or Euros.
ResponseAmount Decimal The total amount for all line items that the supplier offered prices for in their response, reflecting the total cost of their offer.
ResponseCurrencyCode String The abbreviation for the currency used in the supplier's response, indicating the currency in which the offer is made.
ResponseCurrency String The name of the currency used in the supplier’s response, such as US Dollars or Euros.
ResponseCurrencyPricePrecision Decimal The number of decimal places used for pricing in the response currency, specifying the precision of the supplier’s price.
ResponseValidUntilDate Datetime The date on which the supplier’s response expires, indicating the deadline for accepting the offer.
ResponseTypeCode String The abbreviation identifying the response type, such as primary or alternate. The list of valid values is available in the lookup table 'TYPE_OF_RESPONSE'.
ResponseType String The type of response submitted by the supplier, such as primary or alternate, defining whether the offer is the main or an alternative bid.
ReferenceNumber String An identification number used for the supplier's internal tracking of the response, helping the supplier reference the response internally.
NoteToBuyer String A message from the supplier to the buyer, typically containing additional context or clarifications regarding the response.
EvaluationStage String Indicates whether the response is part of the technical or commercial evaluation in a two-stage negotiation process.
PriceDecrement Decimal The minimum reduction in bid price required for a revised bid, ensuring that revised offers are lower than the original.
ProxyBidFlag Bool Indicates whether a proxy bid is allowed. If true, the system can automatically place bids on behalf of the supplier; if false, proxy bidding is not allowed.
ProxyDecrementType String The method by which the response price is reduced during the submission of a proxy bid, either by a flat amount or a percentage.
ProxyDecrementAmount Decimal The amount by which the response price is reduced during a proxy bid submission, based on the specified decrement type.
PartialResponseFlag Bool Indicates whether the supplier has submitted a partial response, meaning they did not bid on all lines or offered less than the requested quantity.
SurrogateResponseEnteredById Long The identifier for the buyer who created the surrogate response on behalf of the supplier, typically in situations where the supplier is unable to respond directly.
SurrogateResponseReceivedOn Datetime The timestamp when the buyer received the surrogate response from the supplier, such as via email or fax.
SurrogateResponseEntryDate Datetime The timestamp when the buyer entered the surrogate response into the system, representing when the response was formally recorded.
SurrogateResponseFlag Bool Indicates whether the buyer has entered a surrogate response on behalf of the supplier. If true, the response was entered by the buyer; if false, the supplier entered the response.
SurrogDraftLockPersonId Long The identifier for the buyer who locked the draft surrogate response for editing, preventing further changes until unlocked.
SurrogateDraftLockPerson String The name of the buyer who locked the draft surrogate response for editing, ensuring only authorized personnel can make changes.
SurrogDraftUnlockPersonId Long The identifier for the buyer who unlocked the draft surrogate response for editing, allowing further modifications.
SurrogateDraftUnlockPerson String The name of the buyer who unlocked the draft surrogate response for editing, enabling continued editing or final submission.
MethodOfResponseCode String An abbreviation that identifies the method by which the supplier submits the response, such as 'Fax', 'Email', or 'Online'.
MethodOfResponse String Specifies how the supplier submitted their response, with values like fax, email, or through an online portal.
DraftLocked String Indicates whether the draft response is locked for editing. If true, the response is locked; if false, the draft is unlocked for edits.
DraftLockedById Long The identifier for the supplier who locked the response draft, preventing further edits.
DraftLockedBy String The name of the supplier who locked the response draft, indicating who is responsible for the draft's final version.
DraftLockedByContactId Long The identifier for the supplier contact who locked the draft response, providing more specific details on who in the supplier organization is responsible.
DraftLockedByContact String The name of the supplier contact who locked the draft response, helping identify the point of contact for the response.
DraftLockedDate Datetime The date and time when the draft response was locked for editing, indicating when no further changes can be made.
DraftUnlockedById Long The identifier for the supplier who unlocked the previous draft response, allowing further edits.
DraftUnlockedBy String The name of the supplier who unlocked the previous draft response, indicating who authorized the edit.
DraftUnlockedByContactId Long The identifier for the supplier contact who unlocked the draft response, providing more details on who approved the unlocking.
DraftUnlockedByContact String The name of the supplier contact who unlocked the previous draft response, indicating the responsible person.
DraftUnlockedDate Datetime The date and time when the draft response was unlocked for editing, allowing modifications to be made before final submission.
CreatedBy String The user who created the row, providing accountability for data entry.
CreationDate Datetime The timestamp of when the row was created in the system, helping with audit tracking.
LastUpdateDate Datetime The timestamp of the last update to the row, used for tracking changes.
LastUpdatedBy String The user who last updated the row, providing accountability for changes made after the initial creation.
BidVisibilityCode String The abbreviation that specifies when the supplier can view competing response details. Values include 'Open', 'Sealed', or 'Blind', with accepted values defined in the lookup table.
ContractType String The type of contract associated with the negotiation, indicating whether it’s short-term or long-term.
DisplayBestPriceBlindFlag Bool Indicates whether the best price in blind negotiations can be displayed to suppliers. If true, the best price is visible; if false, it’s hidden.
RequirementInstructionText String Instructions for the supplier on how to respond to the requirements in the negotiation, helping ensure that the response aligns with expectations.
LinesInstructionText String Instructions for the supplier on how to respond to specific negotiation lines, providing additional guidance on the line items.
BuyerTransportFlag Bool Indicates whether the buying company is responsible for arranging transportation. If true, the buyer is responsible; if false, the supplier arranges transportation.
NegotiationType String The type of negotiation document, such as 'RFQ', 'RFI', or 'Auction', indicating the nature of the procurement process.
Finder String A search identifier used to locate specific supplier negotiation responses in the system.
EffectiveDate Date The date from which the negotiation response is considered effective, marking when it becomes valid for review or processing.

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