Negotiation and Template Details
This Negotiation and Template Details view object consolidates common information about negotiation template details used while creating negotiations.
Data Store Key : FscmTopModelAM.PrcExtractAM.PonBiccExtractAM.NegotiationAndTemplateExtractPVO
Primary Keys : AuctionHeaderId
Initial Extract Date : CreationDate
Incremental Extract Date : LastUpdateDate
Attributes
This table provides the list of exposed attributes and their descriptions.
| Name | Description |
|---|---|
| AbstractDetails | Identifier that indicates abstract details |
| AbstractEnabledFlag | Value that indicates whether abstract is enabled. |
| AbstractStatus | Indicates current abstract status. |
| AcceptTermsBeforeNegFlag | Value that indicates if accept terms before view negotiation control is enabled or not. |
| AdvanceNegotiableFlag | Value that indicates whether the Supplier can negotiate the amount of advance on a line. |
| AllowAlternateLines | Value that indicates whether allow control alternate lines is enabled or not. |
| AllowContractCrtFlag | Value that indicates whether negotiation is created with contracts. |
| AllowOtherBidCurrencyFlag | Value that indicates if other bid currencies are allowed. |
| AlternateLinesEnabledFlag | Value that indicates whether allow control alternate lines is enabled. |
| AmendmentDescription | Indicates amendment description. |
| AmendmentNumber | Indicates amendment number. |
| ApprovalAmount | Unique identifier indicating negotiation Approval Amount. If negotiation is created from requisitions, approval amount will be defaulted from requisition amount. |
| ApprovalStatus | Indicates Approval status of the negotiation. |
| ApprovalStatus1 | Indicates Approval status of the negotiation. |
| Attribute1 | Segment for the Negotiation and Template Extract descriptive flexfield. |
| Attribute10 | Segment for the Negotiation and Template Extract descriptive flexfield. |
| Attribute11 | Segment for the Negotiation and Template Extract descriptive flexfield. |
| Attribute12 | Segment for the Negotiation and Template Extract descriptive flexfield. |
| Attribute13 | Segment for the Negotiation and Template Extract descriptive flexfield. |
| Attribute14 | Segment for the Negotiation and Template Extract descriptive flexfield. |
| Attribute15 | Segment for the Negotiation and Template Extract descriptive flexfield. |
| Attribute16 | Segment for the Negotiation and Template Extract descriptive flexfield. |
| Attribute17 | Segment for the Negotiation and Template Extract descriptive flexfield. |
| Attribute18 | Segment for the Negotiation and Template Extract descriptive flexfield. |
| Attribute19 | Segment for the Negotiation and Template Extract descriptive flexfield. |
| Attribute2 | Segment for the Negotiation and Template Extract descriptive flexfield. |
| Attribute20 | Segment for the Negotiation and Template Extract descriptive flexfield. |
| Attribute3 | Segment for the Negotiation and Template Extract descriptive flexfield. |
| Attribute4 | Segment for the Negotiation and Template Extract descriptive flexfield. |
| Attribute5 | Segment for the Negotiation and Template Extract descriptive flexfield. |
| Attribute6 | Segment for the Negotiation and Template Extract descriptive flexfield. |
| Attribute7 | Segment for the Negotiation and Template Extract descriptive flexfield. |
| Attribute8 | Segment for the Negotiation and Template Extract descriptive flexfield. |
| Attribute9 | Segment for the Negotiation and Template Extract descriptive flexfield. |
| AttributeCategory | Context name for the Negotiation and Template Extract descriptive flexfield. |
| AttributeDate1 | Date segment for the Negotiation and Template Extract descriptive flexfield. |
| AttributeDate10 | Date segment for the Negotiation and Template Extract descriptive flexfield. |
| AttributeDate2 | Date segment for the Negotiation and Template Extract descriptive flexfield. |
| AttributeDate3 | Date segment for the Negotiation and Template Extract descriptive flexfield. |
| AttributeDate4 | Date segment for the Negotiation and Template Extract descriptive flexfield. |
| AttributeDate5 | Date segment for the Negotiation and Template Extract descriptive flexfield. |
| AttributeDate6 | Date segment for the Negotiation and Template Extract descriptive flexfield. |
| AttributeDate7 | Date segment for the Negotiation and Template Extract descriptive flexfield. |
| AttributeDate8 | Date segment for the Negotiation and Template Extract descriptive flexfield. |
| AttributeDate9 | Date segment for the Negotiation and Template Extract descriptive flexfield. |
| AttributeLineNumber | Denotes the line number for header attribute. |
| AttributeNumber1 | Number segment for the Negotiation and Template Extract descriptive flexfield. |
| AttributeNumber10 | Number segment for the Negotiation and Template Extract descriptive flexfield. |
| AttributeNumber2 | Number segment for the Negotiation and Template Extract descriptive flexfield. |
| AttributeNumber3 | Number segment for the Negotiation and Template Extract descriptive flexfield. |
| AttributeNumber4 | Number segment for the Negotiation and Template Extract descriptive flexfield. |
| AttributeNumber5 | Number segment for the Negotiation and Template Extract descriptive flexfield. |
| AttributeNumber6 | Number segment for the Negotiation and Template Extract descriptive flexfield. |
| AttributeNumber7 | Number segment for the Negotiation and Template Extract descriptive flexfield. |
| AttributeNumber8 | Number segment for the Negotiation and Template Extract descriptive flexfield. |
| AttributeNumber9 | Number segment for the Negotiation and Template Extract descriptive flexfield. |
| AttributeTimestamp1 | Date and time segment for the Negotiation and Template Extract descriptive flexfield. |
| AttributeTimestamp10 | Date and time segment for the Negotiation and Template Extract descriptive flexfield. |
| AttributeTimestamp2 | Date and time segment for the Negotiation and Template Extract descriptive flexfield. |
| AttributeTimestamp3 | Date and time segment for the Negotiation and Template Extract descriptive flexfield. |
| AttributeTimestamp4 | Date and time segment for the Negotiation and Template Extract descriptive flexfield. |
| AttributeTimestamp5 | Date and time segment for the Negotiation and Template Extract descriptive flexfield. |
| AttributeTimestamp6 | Date and time segment for the Negotiation and Template Extract descriptive flexfield. |
| AttributeTimestamp7 | Date and time segment for the Negotiation and Template Extract descriptive flexfield. |
| AttributeTimestamp8 | Date and time segment for the Negotiation and Template Extract descriptive flexfield. |
| AttributeTimestamp9 | Date and time segment for the Negotiation and Template Extract descriptive flexfield. |
| AttributesExist | Value that indicates existence of item attributes. |
| AuctionHeaderId | Auction Header ID which is being generated by the application. |
| AuctionHeaderIdOrigAmend | Auction header ID corresponding to the first amendment for this negotiation. |
| AuctionHeaderIdOrigRound | Auction header ID for the original round. |
| AuctionHeaderIdPrevAmend | Auction header ID for the previous amendment. |
| AuctionHeaderIdPrevRound | Auction header ID for the previous round. |
| AuctionOriginationCode | Indicates code for origin of auction. |
| AuctionRoundNumber | Indicates number of rounds for this auction. |
| AuctionStatus | Indicates status of the auction. |
| AuctionTitle | Indicates auction title. |
| AutoExtendAllLinesFlag | Value that indicates if all auction items are automatically extended if one item qualifies for auto-extension. |
| AutoExtendDuration | Duration to be added in each automatic extension of the auction, which is measured in minutes. |
| AutoExtendEnabledFlag | Value that indicates if auto-extension is enabled. |
| AutoExtendFlag | Value that indicates that auction can be automatically extended. |
| AutoExtendMinTriggerRank | The minimum rank that will trigger auto extension. |
| AutoExtendNumber | Allowable number of automatic extensions. |
| AutoExtendTriggerPeriod | Indicates triggering Period in autoextend settings. |
| AutoExtendTypeFlag | Value to denote base date to use to calculate the new auction close time if the autoextend trigger is on for the auction. |
| AutoextendChangedFlag | Value that indicates that autoextension details are changed by the auctioneer. |
| AwardApprAmeTransId | Indicates current AME approval transaction ID. |
| AwardApprAmeTransPrevId | Indicates previous AME approval transaction ID. |
| AwardApprAmeTxnDate | Date and time at which the Award Approval was initiated. |
| AwardApprIdentificationKey | Identification key for the most recent award approval for the negotiation. |
| AwardApprovalDate | Date on which the award approval decision was made. |
| AwardApprovalFlag | Value that indicates if award approval is required for this negotiation before the award process can be completed. |
| AwardApprovalNote | Field that depicts the note to approvers field entered in the manage award approval page. |
| AwardApprovalStatus | Indicates current award approval status. |
| AwardByDate | Date on which the winning bids are scheduled for awarding by the auctioneer. |
| AwardCompleteDate | Date the negotiation award process was completed. |
| AwardDate | Date the latest Award was saved. |
| AwardMode | Indicates the mode in which the last award was saved. |
| AwardNoticeLayoutName | Award Notice Layout Template Name. |
| AwardStatus | Identifier that indicates award status of auction. |
| BidDecrementMethod | Indicates the method used for bid decrement for open auctions. |
| BidFrequencyCode | Bid Frequency Code to indicate if only one bid per bidder can be entered or multiple bids are allowed. |
| BidFrequencyCodeDspFlag | Value that indicates whether to display response rule to supplier about allowing supplier to submit multiple responses. |
| BidListType | Bid List Type to indicate whether bidders are by invitation only or public bidders. |
| BidListTypeDspFlag | Value that indicates whether to display response rule to supplier about restricting the negotiation to invited suppliers only. |
| BidRanking | Bid evaluation method for this negotiation. |
| BidRevisionType | Bid Revision Type to indicate whether response revision is allowed. |
| BidRevisionTypeDspFlag | Value that indicates whether to show bid revision type to supplier. |
| BidScopeCode | Identifier specifying whether bidder can bid on individual items or must bid on all items. |
| BidScopeCodeDspFlag | Value that indicates whether to display response rule to supplier about allowing supplier to select lines on which to respond. |
| BidVisibilityCode | Identifier specifying who in the application can view the bids. |
| BuyerTransportEnabledFlag | Value that indicates whether buyer managed transportation is enabled. |
| BuyerTransportFlag | Value that indicates whether buyer will manage transportation. |
| CancelDate | Date that indicates when the auction was canceled. |
| CarrierId | Indicates unique identifier of carrier. |
| CloseBiddingDate | Current date that auction closes for bidding. |
| CloseDatePauseAdjusted | Indicates close bidding date except when the negotiation is in paused status. |
| CloseDateType | Indicates the type of close date. |
| CompleteFlag | Indicates whether all batches have finished successfully. |
| ContermsArticlesUpdDate | Last update date for the negotiation's contract articles. |
| ContermsDelivUpdDate | Last update date for the negotiation's contract deliverables. |
| ContermsEnabledFlag | Value that indicates whether contract terms is enabled. |
| ContermsExistFlag | Indicates if the negotiation has contract terms. |
| ContractErrorMsg | Error code along with message returned by contracts create or update API. |
| ContractId | Identifier for contracts. |
| ContractLayoutId | Contract terms layout ID. |
| ContractLayoutName | Contract layout template name. |
| ContractTemplateId | Contract template ID for the template row. |
| ContractType | Indicates type of contract, spot buy or long term buy. |
| CoverPageEnabledFlag | Value that indicates whether cover page is enabled. |
| CoverPageText | Cover page content text. |
| CreatedBy | Indicates the user who created the row. |
| CreationDate | Indicates the date and time of the creation of the row. |
| CreationDateOrigAmend | Date on which the original amendment was created. |
| CurrencyCode | Base currency code in which the auction will be conducted. |
| DaysAfterOpenDate | Indicates close date by number of days after open date. |
| Description | Template description. |
| DisplayBestPriceBlindFlag | Value that specifies whether the best price on blind negotiations can be displayed to suppliers. |
| DisplayBestPriceDspFlag | Value that indicates whether to display response rule to supplier about displaying best price to supplier. |
| DisplayBidRankToSuppFlag | Value that indicates whether display overall response rank to suppliers. |
| DisplayTransAmountSuppFlag | Value that indicates whether display transformed amount to suppliers. |
| DoctypeId | Identifier for document type associated with this auction. |
| DocumentNumber | Indicates negotiation number. |
| DraftLocked | Value that indicates if negotiation is locked. |
| DraftLockedByPersonId | ID of the person who locked the draft. |
| DraftLockedDate | Date the draft was locked. |
| DraftUnlockedByPersonId | ID of the person who unlocked the draft. |
| DraftUnlockedDate | Date the draft was unlocked. |
| EnforcePrevrndBidDspFlag | Value that indicates whether to display response rule to supplier about enforcing supplier's previous round price as start price for this round. |
| EnforcePrevrndBidPriceFlag | Value that indicates if each supplier can see his previous active bid's quoted price as the start price of each line. |
| EventId | Auction Event Identifier for a group of auctions to be monitored. |
| EventTitle | Title of the event the auction is associated with. |
| ExtAttribute1 | Character segment for the External Descriptive Flexfield. This segment is visible to all users. |
| ExtAttribute10 | Character segment for the External Descriptive Flexfield. This segment is visible to all users. |
| ExtAttribute11 | Character segment for the External Descriptive Flexfield. This segment is visible to all users. |
| ExtAttribute12 | Character segment for the External Descriptive Flexfield. This segment is visible to all users. |
| ExtAttribute13 | Character segment for the External Descriptive Flexfield. This segment is visible to all users. |
| ExtAttribute14 | Character segment for the External Descriptive Flexfield. This segment is visible to all users. |
| ExtAttribute15 | Character segment for the External Descriptive Flexfield. This segment is visible to all users. |
| ExtAttribute16 | Character segment for the External Descriptive Flexfield. This segment is visible to all users. |
| ExtAttribute17 | Character segment for the External Descriptive Flexfield. This segment is visible to all users. |
| ExtAttribute18 | Character segment for the External Descriptive Flexfield. This segment is visible to all users. |
| ExtAttribute19 | Character segment for the External Descriptive Flexfield. This segment is visible to all users. |
| ExtAttribute2 | Character segment for the External Descriptive Flexfield. This segment is visible to all users. |
| ExtAttribute20 | Character segment for the External Descriptive Flexfield. This segment is visible to all users. |
| ExtAttribute3 | Character segment for the External Descriptive Flexfield. This segment is visible to all users. |
| ExtAttribute4 | Character segment for the External Descriptive Flexfield. This segment is visible to all users. |
| ExtAttribute5 | Character segment for the External Descriptive Flexfield. This segment is visible to all users. |
| ExtAttribute6 | Character segment for the External Descriptive Flexfield. This segment is visible to all users. |
| ExtAttribute7 | Character segment for the External Descriptive Flexfield. This segment is visible to all users. |
| ExtAttribute8 | Character segment for the External Descriptive Flexfield. This segment is visible to all users. |
| ExtAttribute9 | Character segment for the External Descriptive Flexfield. This segment is visible to all users. |
| ExtAttributeCategory | Context name for the External Descriptive Flexfield. This segment is visible to all users. |
| ExtAttributeDate1 | Date segment for the Negotiation and Template Extract external descriptive flexfield. This segment is visible to all users. |
| ExtAttributeDate10 | Date segment for the Negotiation and Template Extract external descriptive flexfield. This segment is visible to all users. |
| ExtAttributeDate2 | Date segment for the Negotiation and Template Extract external descriptive flexfield. This segment is visible to all users. |
| ExtAttributeDate3 | Date segment for the Negotiation and Template Extract external descriptive flexfield. This segment is visible to all users. |
| ExtAttributeDate4 | Date segment for the Negotiation and Template Extract external descriptive flexfield. This segment is visible to all users. |
| ExtAttributeDate5 | Date segment for the Negotiation and Template Extract external descriptive flexfield. This segment is visible to all users. |
| ExtAttributeDate6 | Date segment for the Negotiation and Template Extract external descriptive flexfield. This segment is visible to all users. |
| ExtAttributeDate7 | Date segment for the Negotiation and Template Extract external descriptive flexfield. This segment is visible to all users. |
| ExtAttributeDate8 | Date segment for the Negotiation and Template Extract external descriptive flexfield context. This segment is visible to all users. |
| ExtAttributeDate9 | Date segment for the Negotiation and Template Extract external descriptive flexfield. This segment is visible to all users. |
| ExtAttributeNumber1 | Number segment for the Negotiation and Template Extract external descriptive flexfield. This segment is visible to all users. |
| ExtAttributeNumber10 | Number segment for the Negotiation and Template Extract external descriptive flexfield. This segment is visible to all users. |
| ExtAttributeNumber2 | Number segment for the Negotiation and Template Extract external descriptive flexfield. This segment is visible to all users. |
| ExtAttributeNumber3 | Number segment for the Negotiation and Template Extract external descriptive flexfield. This segment is visible to all users. |
| ExtAttributeNumber4 | Number segment for the Negotiation and Template Extract external descriptive flexfield. This segment is visible to all users. |
| ExtAttributeNumber5 | Number segment for the Negotiation and Template Extract external descriptive flexfield. This segment is visible to all users. |
| ExtAttributeNumber6 | Number segment for the Negotiation and Template Extract external descriptive flexfield. This segment is visible to all users. |
| ExtAttributeNumber7 | Number segment for the Negotiation and Template Extract external descriptive flexfield. This segment is visible to all users. |
| ExtAttributeNumber8 | Number segment for the Negotiation and Template Extract external descriptive flexfield. This segment is visible to all users. |
| ExtAttributeNumber9 | Number segment for the Negotiation and Template Extract external descriptive flexfield. This segment is visible to all users. |
| ExtAttributeTimestamp1 | Date and time segment for the Negotiation and Template Extract external descriptive flexfield. This segment is visible to all users. |
| ExtAttributeTimestamp10 | Date and time segment for the Negotiation and Template Extract external descriptive flexfield context. This segment is visible to all users. |
| ExtAttributeTimestamp2 | Date and time segment for the Negotiation and Template Extract external descriptive flexfield context. This segment is visible to all users. |
| ExtAttributeTimestamp3 | Date and time segment for the Negotiation and Template Extract external descriptive flexfield context. This segment is visible to all users. |
| ExtAttributeTimestamp4 | Date and time segment for the Negotiation and Template Extract external descriptive flexfield context. This segment is visible to all users. |
| ExtAttributeTimestamp5 | Date and time segment for the Negotiation and Template Extract external descriptive flexfield context. This segment is visible to all users. |
| ExtAttributeTimestamp6 | Date and time segment for the Negotiation and Template Extract external descriptive flexfield context. This segment is visible to all users. |
| ExtAttributeTimestamp7 | Date and time segment for the Negotiation and Template Extract external descriptive flexfield context. This segment is visible to all users. |
| ExtAttributeTimestamp8 | Date and time segment for the Negotiation and Template Extract external descriptive flexfield context. This segment is visible to all users. |
| ExtAttributeTimestamp9 | Date and time segment for the Negotiation and Template Extract external descriptive flexfield context. This segment is visible to all users. |
| ExternalPoCreationStatus | Status of purchasing document creation process when the purchasing document is created through external service. |
| FirstLineCloseDate | Date on which the first line is scheduled to close in a staggered closing scenario. |
| FobCode | Indicates code for free on board. |
| FreightTermsCode | Indicated code for freight terms. |
| FullQuantityBidCode | Value that indicates if full quantity bid are required. |
| FullQuantityBidDspFlag | Value that indicates whether to display response rule about full quantity to be responded by supplier. |
| GeneralIntroEnabledFlag | Value that indicates whether general introduction section is enabled. |
| GeneralIntroText | General introduction rich text in the negotiation. |
| GlobalTemplateFlag | Value that indicates whether the template is global or not. |
| GroupEnabledFlag | Value that indicates if group is enabled. |
| HasHdrAttrFlag | Value that denotes whether any header attributes exists for this negotiation. |
| HasItemsFlag | Value that indicates if there are any line items for this negotiation. |
| HasLineCurrentPrice | Indicates whether at least one line has a current price defined. |
| HasPeForAllItems | Value that indicates if all the items in the negotiation doc has Price Elements defined. |
| HasPriceElements | Value that indicates if any item in the negotiation doc has Price Elements defined. |
| HasScoringTeamsFlag | Indicates if this negotiation has been enabled for Team Scoring. |
| HdrAttrDisplayScore | Denotes whether to show header attribute scoring criteria to suppliers. |
| HdrAttrEnableWeights | Denotes whether weights are enabled on header attributes. |
| HdrAttrMaximumScore | Field that stores the default maximum score on the header attributes. |
| HdrAttributeEnabledFlag | Value that indicates if header attribute is enabled. |
| ImportFileName | Spreadsheet file name that's used for importing. |
| IncludePdfInExternalPage | Indicates condition whether to include PDF in external page |
| IntAttribute1 | Character segment for the Internal Descriptive Flexfield. This segment isn't visible to supplier bidders. |
| IntAttribute10 | Character segment for the Internal Descriptive Flexfield. This segment isn't visible to supplier bidders. |
| IntAttribute11 | Character segment for the Internal Descriptive Flexfield. This segment isn't visible to supplier bidders. |
| IntAttribute12 | Character segment for the Internal Descriptive Flexfield. This segment isn't visible to supplier bidders. |
| IntAttribute13 | Character segment for the Internal Descriptive Flexfield. This segment isn't visible to supplier bidders. |
| IntAttribute14 | Character segment for the Internal Descriptive Flexfield. This segment isn't visible to supplier bidders. |
| IntAttribute15 | Character segment for the Internal Descriptive Flexfield. This segment isn't visible to supplier bidders. |
| IntAttribute2 | Character segment for the Internal Descriptive Flexfield. This segment isn't visible to supplier bidders. |
| IntAttribute3 | Character segment for the Internal Descriptive Flexfield. This segment isn't visible to supplier bidders. |
| IntAttribute4 | Character segment for the Internal Descriptive Flexfield. This segment isn't visible to supplier bidders. |
| IntAttribute5 | Character segment for the Internal Descriptive Flexfield. This segment isn't visible to supplier bidders. |
| IntAttribute6 | Character segment for the Internal Descriptive Flexfield. This segment isn't visible to supplier bidders. |
| IntAttribute7 | Character segment for the Internal Descriptive Flexfield. This segment isn't visible to supplier bidders. |
| IntAttribute8 | Character segment for the Internal Descriptive Flexfield. This segment isn't visible to supplier bidders. |
| IntAttribute9 | Character segment for the Internal Descriptive Flexfield. This segment isn't visible to supplier bidders. |
| IntAttributeCategory | Values that identifies the Internal Descriptive Flexfield context category. The segments under this category aren't visible to supplier bidders. |
| InternalCfEnabledFlag | Value that indicates whether Internal cost factors is enabled. |
| IsCreatedFromRest | Value that indicates whether this negotiation is created from REST Service. |
| IsPaused | Indicates whether the negotiation is paused or not. |
| IsTemplateFlag | Value that identifies if the row represents a template or negotiation. |
| LanguageCode | Language in which the negotiation is created in |
| LargeNegEnabledFlag | Value that indicates if large negotiation is enabled. |
| LastLineNumber | Maximum line, lot, or group number in the negotiation. |
| LastPauseDate | Date on which the negotiation is paused. |
| LastUpdateDate | Indicates the date and time of the last update of the row. |
| LastUpdateLogin | Indicates the session login associated to the user who last updated the row. |
| LastUpdatedBy | Indicates the session login associated to the user who last updated the row. |
| LineAttributeEnabledFlag | Value that indicates if the attribute is enabled. |
| LineDefaultsEnabledFlag | Value that indicates if line defaults is enabled. |
| LineDefaultsExistFlag | Value that indicates if user has defined line defaults or not. |
| LineMasEnabledFlag | Value that indicates if MAS is enabled. |
| LinesInstrEnabledFlag | Value that indicates whether lines instruction is enabled. |
| LinesInstrText | Lines instruction rich text. |
| LotEnabledFlag | Value that indicates if lot is enabled. |
| MaxBidColorSequenceId | Maximum color sequence number allotted to the responses for this negotiation. |
| MaxDocumentLineNum | Indicates the maximum parent document line number throughout all the rounds and amendments. |
| MaxInternalLineNum | Indicates the maximum line number throughout all the rounds and amendments. |
| MaxRetainageNegotiableFlag | Value that indicates whether the maximum retainage amount on the line is negotiable. |
| MinBidChangeType | Indicates minimum bid change type. |
| MinBidDecrement | Minimum allowable bid decrement in a bidders bid if multiple bids are allowed. |
| ModeOfTransport | Type of transportation used to ship the product, such as truck, air or boat. |
| NegApprIdentificationKey | Identification key of the most recent negotiation approval request. |
| NegApprovalDate | Date when the approve or reject decision is made. |
| NegApprovalEnabledFlag | Value that indicates whether negotiation approval is enabled. |
| NegApprovalNote | Stores the note to approvers entered on manage negotiation approval page. |
| NegApprovalStatus | Indicates approval status of the negotiation. |
| NegTeamEnabledFlag | Value that indicates if collaboration team is enabled. |
| NegotiationLayoutId | Indicates negotiation layout ID. |
| NegotiationLayoutName | Indicates negotiation layout template name. |
| NumberOfBids | Indicates number of bids received. |
| NumberOfExtensions | Indicates number of extensions made. |
| NumberOfLines | Indicates number of lines in the negotiation. |
| NumberPriceDecimals | Required precision of bid price. |
| ObjectVersionNumber | Unique identifier to implement optimistic locking. This number is incremented every time that the row is updated. |
| OpenAuctionNowFlag | Value that indicates the auction is open now. |
| OpenBiddingDate | Date when the auction is open for bidding. |
| OriginalCloseBiddingDate | Original date for which auction was setup to close for bidding. |
| OutcomeStatus | Status to indicate outcome creation. |
| OverallRespRankEnabledFlag | Value that indicates whether overall response rank is enabled. |
| PauseRemarks | Indicated the reason for which the negotiation is paused. |
| PaymentTermsId | Unique identifier for payment terms. |
| PersonId | Indicates ID of the auction creator. |
| PfTypeAllowed | Indicates the combination of buyer and supplier price factors. |
| PoAgreedAmount | Indicates purchase order's agreed amount. This is applicable only for long term buyer's auction. |
| PoCreationProcess | Indicates whether purchasing document creation process for the negotiation is through web service or purchasing. |
| PoEndDate | Indicates purchase order end date. This is applicable only for long term buyer's auction. |
| PoMinRelAmount | Indicates blanket minimum release amount. |
| PoStartDate | Indicates purchase order start date. This is applicable only for long term buyer's auction. |
| PoStyleId | Unique key identifier for purchase order style for the negotiation. |
| PonNegotiationCode | Unique identifier for the negotiation code. |
| PowerBiddingEnabledFlag | Value that indicates if power bidding is enabled. |
| PrcBuId | Unique identifier for a procurement business unit |
| PriceDrivenAuctionFlag | Value that indicates that the auction is being price driven. |
| PriceElementEnabledFlag | Value that indicates if price element is enabled. |
| PriceTiersIndicator | Indicates the price tiers child entities in the line items. |
| ProgramAppName | Identifies the application name spawning the concurrent request. |
| ProgramName | Identifies the concurrent program. |
| ProgressPaymentType | Indicates whether the negotiation is used for complex services and the type. |
| ProgressPymtNegotiableFlag | Value that indicates whether the progress payment rate is negotiable. |
| ProjectId | Unique identifier of the project in Oracle Projects which governs the negotiation. |
| ProjectsEnabledFlag | Value that indicates if the projects is enabled. |
| ProxyBiddingEnabledFlag | Value that indicates if proxy bidding is enabled. |
| PublishAuctionNowFlag | Value to publish the auction. |
| PublishDate | Date when the negotiation is published. |
| PublishDateOrigAmend | Publish date of the original amendment. |
| PublishRatesToBiddersFlag | Value that indicates if currency exchange rates are allowed to be published to bidders. |
| QtyPriceTiersEnabledFlag | Value to indicate if quantity based price tiers is enabled. |
| RankIndicator | Rank indicator for this negotiation. |
| RateDate | Indicates currency conversion rate date. Applicable only if the rate type is corporate. |
| RateType | Indicates currency rate type. |
| RebuildIndex | Column which has an Oracle Text Domain Index defined to support Keyword Search. |
| RecoupmentNegotiableFlag | Value that indicates whether the recoup rate on the line is negotiable |
| ReminderDate | Reminder date that indicates email should be sent out if invited bidder hasn't acknowledged participation. |
| ReqBuId | ID that represents a requisition business unit. |
| ReqmntsInstrEnabledFlag | Value that indicates whether requirements instruction is enabled. |
| ReqmntsInstrText | Requirements instruction rich text. |
| RequestDate | Date and time when concurrent request was submitted for creation or award flow. |
| RequestId | Enterprise Service Scheduler that indicates the request ID of the job that created or last updated the row. |
| RequestedBy | User ID of the person who made the concurrent request. |
| RespLinesSpshetEnabledFlag | Value that indicates whether Linear Response Line spreadsheet is enabled. |
| RespReqtSpshetEnabledFlag | Value that indicates whether XML Response spreadsheet with Requirements only is enabled. |
| RespSpshetEnabledFlag | Value that indicates whether response by spreadsheet feature is enabled. |
| RespTabulationLayoutName | Response tabulation layout template name. |
| RespXmlSpshetEnabledFlag | Value that indicates whether XML Response spreadsheet with Requirements and Lines is enabled. |
| ResponseLayoutId | Response Layout Template ID. |
| ResponseLayoutName | Response Layout Template Name. |
| RetainageNegotiableFlag | Value that indicates whether the retainage rate on the line is negotiable. |
| RfiLineEnabledFlag | Yes or No Value to indicate if line is enabled, applicable only to RFI. |
| ScoringLockDate | Date on which this negotiation was closed for team scoring. |
| ScoringLockPersonId | ID of the person who locked the team scoring. |
| ScoringOpenDate | Most recent date on which a negotiation was opened for team scoring. |
| ScoringOpenPersonId | ID indicating most recent person who opened the team scoring. |
| ScoringStatus | Value indicating status of scoring. For two part RFQ, this will be used for commercial stage. |
| SealedActualUnlockDate | Date when the sealed auction was unlocked. |
| SealedActualUnsealDate | Date when the sealed auction was unsealed. |
| SealedAuctionStatus | Status of sealed auction. |
| SealedUnlockPersonId | ID of the person who unlocked the sealed auction |
| SealedUnsealPersonId | ID of the person who unsealed the sealed auction |
| ServiceLevel | Priority of transportation that affects how quickly goods are transported. |
| ShareAwardDecision | Value to determine whether to share award decision with suppliers. |
| ShareAwdDecisionDate | Date on which Share award decision was taken. |
| ShowBidderNotes | Value that indicates if bidder notes and attachments are visible to other bidders |
| ShowBidderNotesDspFlag | Value that indicates whether to display other supplier's notes and attachments to the supplier |
| ShowBidderScores | Value that indicates whether scoring model is displayed to bidders. |
| SourceDocId | ID that uniquely identifies source document. |
| SourceDocLineMsg | Source document line display message name. |
| SourceDocMsg | Source document message display name. |
| SourceDocMsgApp | Short name for message application. |
| SourceDocNumber | Number that uniquely identifies Source document. |
| SourceReqsFlag | Value that indicates whether to source requisitions against blanket agreements. |
| StagCloseEnabledFlag | Value that indicates whether staggered closing is enabled. |
| StaggeredClosingFlag | Value that indicates whether staggered closing is enabled or not. |
| StaggeredClosingInterval | Interval identifying when the staggered line is closing. |
| StyleId | ID that uniquely identifies negotiation style. |
| SupplierEnterablePymtFlag | Indicates whether the supplier is allowed to create or modify pay items on negotiations with complex services. If not, the supplier can only respond to the pay items as proposed by the buyer. |
| SupplierViewType | Indicates whether suppliers will transformed quotes. |
| Synopsis | Brief description of the negotiation |
| TeamScoringEnabledFlag | Value that indicates if the style applied to the negotiation has team scoring enabled. The team scoring will be shown during the negotiation creation and review screens only if this Value is set. If team scoring is enabled, the value will be E, else will be D. |
| TechnicalActualUnlockDate | Date when the negotiation was technically unlocked. |
| TechnicalActualUnsealDate | Date when the negotiation was technically unsealed. |
| TechnicalEvaluationStatus | Stores the technical evaluation completion status. |
| TechnicalLockStatus | Status that indicates technical part's lock status for a two-part RFQ. |
| TechnicalScoringStatus | Status of scoring of technical stage of two-part RFQ. The values can be OPEN, CLOSED and NOT STARTED. |
| TechnicalUnlockPersonId | ID of the person who unlocked the technical part of the RFQ. |
| TechnicalUnsealPersonId | ID of the person who unsealed the technical part of the RFQ. |
| TemplateId | Foreign Key that uniquely identifies Auction header for the template. |
| TemplateScope | Scope of template that indicates whether the template is private or public. |
| TemplateStatus | Template status that indicates whether the template is active or inactive. |
| TermsInstrEnabledFlag | Yes or No Value to indicate whether terms instruction is enabled. |
| TermsInstrText | Terms instruction rich text. |
| TwoPartFlag | Yes or No Value to indicate whether if the negotiation is two-part RFQ. |
| TwostageEvalEnabledFlag | Yes or No Value to indicate whether the two stage evaluation is enabled. |
| VersionNum | Version number that uniquely identifies a contract. |
| ViewByDate | Negotiation Date to view authorized suppliers. |
| WfApprovalItemKey | Key identifier for Approval workflow. |
| WfAwardApprovalItemKey | Item Key that's created for Award Approval Workflow. |
| WfItemKey | Workflow Item Key for the main AUCTION workflow. |
| WfPoncomplCurrentRound | Current Workflow round kicked off to create outcome documents. |
| WfPoncomplItemKey | Workflow item key created to hold the invited bidders as well as active bidders. |
| WfRoleName | Workflow Role name created to hold the invited bidders as well as active bidders. |