Sourcing Cost Factor Details - Desupported

This view object is desupported and won't be maintained any more. Use the Sourcing Cost Factor Details view object instead.

Data Store Key : FscmTopModelAM.PrcExtractAM.PonBiccExtractAM.SourcingCostFactorPVO

Primary Keys : AuctionHeaderId, LineNumber, SequenceNumber

Initial Extract Date : SourcingCostFactorCreationDate

Incremental Extract Date : SourcingCostFactorLastUpdateDate

Attributes

This table provides the list of exposed attributes and their descriptions.

Name Description
AuctionHeaderId Unique identifier for the negotiation.
CategoryCategoryId Unique identifier of category.
CategoryCategoryName Name of the category.
CategoryDescription Description of the category.
CategoryEnabledFlag Value that indicates if the category is enabled.
CategoryJobDefinitionName Package of the job definition under which the negotiation is created.
CategoryJobDefinitionPackage Name of the job definition under which the negotiation is created.
CategoryStructureInstanceNumber Instance number of the requirement attribute structure.
DailyConversionTypeNegoHdrConversionType Conversion factor between negotiation line and alternate line.
DailyConversionTypeNegoHdrDescription Description of the response header.
DailyConversionTypeNegoHdrEnableCrossRateFlag Value that indicates if the cross rate has been enabled.
DailyConversionTypeNegoHdrEnforceInverseRateFlag Value that indicates if the inverse rate has been enforced.
DailyConversionTypeNegoHdrFemEnabledFlag Value that indicates if the fem is enabled in the negotiation header.
DailyConversionTypeNegoHdrFemRateTypeCode Code type for the fem rate in the negotiation header.
DailyConversionTypeNegoHdrFemScenario Code type for the fem rate in the negotiation header.
DailyConversionTypeNegoHdrFemTimeframe Time frame when the requirement was answered.
DailyConversionTypeNegoHdrPivotCurrencyCode Currency code of the best response.
DailyConversionTypeNegoHdrSecurityFlag Value that indicates if negotiation is secured.
DailyConversionTypeNegoHdrUserConversionType Conversion factor between negotiation line and alternate line.
DailyConversionTypeNegoHdrUserOverrideCrossRateFlag Value that indicates if the cross rate has been overridden.
ItemNumber Item number of the negotiation.
LineNumber Line number of the negotiation.
NegotiationHeaderAbstractDetails Identifier that indicates abstract details
NegotiationHeaderAbstractStatus Indicates current abstract status.
NegotiationHeaderAdvanceNegotiableFlag Value that indicates whether the Supplier can negotiate the amount of advance on a line.
NegotiationHeaderAllowOtherBidCurrencyFlag Value that indicates if other bid currencies are allowed.
NegotiationHeaderAmendmentDescription Indicates amendment description.
NegotiationHeaderAmendmentNumber Indicates amendment number.
NegotiationHeaderApprovalAmount Unique identifier indicating negotiation Approval Amount. If negotiation is created from requisitions, approval amount will be defaulted from requisition amount.
NegotiationHeaderApprovalStatus Indicates Approval status of the negotiation.
NegotiationHeaderAttributeLineNumber Denotes the line number for header attribute.
NegotiationHeaderAttributesExist Value that indicates existence of item attributes.
NegotiationHeaderAuctionHeaderId Auction Header ID which is being generated by the application.
NegotiationHeaderAuctionHeaderIdOrigAmend Auction header ID corresponding to the first amendment for this negotiation.
NegotiationHeaderAuctionHeaderIdOrigRound Auction header ID for the original round.
NegotiationHeaderAuctionHeaderIdPrevAmend Auction header ID for the previous amendment.
NegotiationHeaderAuctionHeaderIdPrevRound Auction header ID for the previous round.
NegotiationHeaderAuctionOriginationCode Indicates code for origin of auction.
NegotiationHeaderAuctionRoundNumber Indicates number of rounds for this auction.
NegotiationHeaderAuctionStatus Indicates status of the auction.
NegotiationHeaderAuctionTitle Indicates auction title.
NegotiationHeaderAutoExtendAllLinesFlag Value that indicates if all auction items are automatically extended if one item qualifies for auto-extension.
NegotiationHeaderAutoExtendDuration Duration to be added in each automatic extension of the auction, which is measured in minutes.
NegotiationHeaderAutoExtendEnabledFlag Value that indicates if auto-extension is enabled.
NegotiationHeaderAutoExtendFlag Value that indicates that auction can be automatically extended.
NegotiationHeaderAutoExtendMinTriggerRank The minimum rank that will trigger auto extension.
NegotiationHeaderAutoExtendNumber Allowable number of automatic extensions.
NegotiationHeaderAutoExtendTypeFlag Value to denote base date to use to calculate the new auction close time if the autoextend trigger is on for the auction.
NegotiationHeaderAutoextendChangedFlag Value that indicates that autoextension details are changed by the auctioneer.
NegotiationHeaderAwardApprAmeTransId Indicates current AME approval transaction ID.
NegotiationHeaderAwardApprAmeTransPrevId Indicates previous AME approval transaction ID.
NegotiationHeaderAwardApprAmeTxnDate Date and time at which the Award Approval was initiated.
NegotiationHeaderAwardApprovalFlag Value that indicates if award approval is required for this negotiation before the award process can be completed.
NegotiationHeaderAwardApprovalStatus Indicates current award approval status.
NegotiationHeaderAwardByDate Date on which the winning bids are scheduled for awarding by the auctioneer.
NegotiationHeaderAwardCompleteDate Date the negotiation award process was completed.
NegotiationHeaderAwardDate Date the latest Award was saved.
NegotiationHeaderAwardMode Indicates the mode in which the last award was saved.
NegotiationHeaderAwardStatus Identifier that indicates award status of auction.
NegotiationHeaderBidDecrementMethod Indicates the method used for bid decrement for open auctions.
NegotiationHeaderBidFrequencyCode Bid Frequency Code to indicate if only one bid per bidder can be entered or multiple bids are allowed.
NegotiationHeaderBidListType Bid List Type to indicate whether bidders are by invitation only or public bidders.
NegotiationHeaderBidRanking Bid evaluation method for this negotiation.
NegotiationHeaderBidScopeCode Identifier specifying whether bidder can bid on individual items or must bid on all items.
NegotiationHeaderBidVisibilityCode Identifier specifying who in the application can view the bids.
NegotiationHeaderCancelDate Date that indicates when the auction was canceled.
NegotiationHeaderCarrierId Indicates unique identifier of carrier.
NegotiationHeaderCloseBiddingDate Current date that auction closes for bidding.
NegotiationHeaderCloseDateType Indicates the type of close date.
NegotiationHeaderCompleteFlag Indicates whether all batches have finished successfully.
NegotiationHeaderContermsArticlesUpdDate Last update date for the negotiation's contract articles.
NegotiationHeaderContermsDelivUpdDate Last update date for the negotiation's contract deliverables.
NegotiationHeaderContermsExistFlag Indicates if the negotiation has contract terms.
NegotiationHeaderContractTemplateId Contract template ID for the template row.
NegotiationHeaderContractType Indicates type of contract, spot buy or long term buy.
NegotiationHeaderCreatedBy Indicates the user who created the row.
NegotiationHeaderCreationDate Indicates the date and time of the creation of the row.
NegotiationHeaderCreationDateOrigAmend Date on which the original amendment was created.
NegotiationHeaderCurrencyCode Base currency code in which the auction will be conducted.
NegotiationHeaderDaysAfterOpenDate Indicates close date by number of days after open date.
NegotiationHeaderDescription Template description.
NegotiationHeaderDisplayBestPriceBlindFlag Value that specifies whether the best price on blind negotiations can be displayed to suppliers.
NegotiationHeaderDoctypeId Identifier for document type associated with this auction.
NegotiationHeaderDocumentNumber Indicates negotiation number.
NegotiationHeaderDraftLocked Value that indicates if negotiation is locked.
NegotiationHeaderDraftLockedDate Date the draft was locked.
NegotiationHeaderDraftUnlockedDate Date the draft was unlocked.
NegotiationHeaderEnforcePrevrndBidPriceFlag Value that indicates if each supplier can see his previous active bid's quoted price as the start price of each line.
NegotiationHeaderEventId Auction Event Identifier for a group of auctions to be monitored.
NegotiationHeaderEventTitle Title of the event the auction is associated with.
NegotiationHeaderExtAttribute1 Character segment for the External Descriptive Flexfield. This segment is visible to all users.
NegotiationHeaderExtAttribute10 Character segment for the External Descriptive Flexfield. This segment is visible to all users.
NegotiationHeaderExtAttribute11 Character segment for the External Descriptive Flexfield. This segment is visible to all users.
NegotiationHeaderExtAttribute12 Character segment for the External Descriptive Flexfield. This segment is visible to all users.
NegotiationHeaderExtAttribute13 Character segment for the External Descriptive Flexfield. This segment is visible to all users.
NegotiationHeaderExtAttribute14 Character segment for the External Descriptive Flexfield. This segment is visible to all users.
NegotiationHeaderExtAttribute15 Character segment for the External Descriptive Flexfield. This segment is visible to all users.
NegotiationHeaderExtAttribute2 Character segment for the External Descriptive Flexfield. This segment is visible to all users.
NegotiationHeaderExtAttribute3 Character segment for the External Descriptive Flexfield. This segment is visible to all users.
NegotiationHeaderExtAttribute4 Character segment for the External Descriptive Flexfield. This segment is visible to all users.
NegotiationHeaderExtAttribute5 Character segment for the External Descriptive Flexfield. This segment is visible to all users.
NegotiationHeaderExtAttribute6 Character segment for the External Descriptive Flexfield. This segment is visible to all users.
NegotiationHeaderExtAttribute7 Character segment for the External Descriptive Flexfield. This segment is visible to all users.
NegotiationHeaderExtAttribute8 Character segment for the External Descriptive Flexfield. This segment is visible to all users.
NegotiationHeaderExtAttribute9 Character segment for the External Descriptive Flexfield. This segment is visible to all users.
NegotiationHeaderExtAttributeCategory Context name for the External Descriptive Flexfield. This segment is visible to all users.
NegotiationHeaderFirstLineCloseDate Date on which the first line is scheduled to close in a staggered closing scenario.
NegotiationHeaderFobCode Indicates code for free on board.
NegotiationHeaderFreightTermsCode Indicated code for freight terms.
NegotiationHeaderFullQuantityBidCode Value that indicates if full quantity bid are required.
NegotiationHeaderGlobalTemplateFlag Value that indicates whether the template is global or not.
NegotiationHeaderGroupEnabledFlag Value that indicates if group is enabled.
NegotiationHeaderHasHdrAttrFlag Value that denotes whether any header attributes exists for this negotiation.
NegotiationHeaderHasItemsFlag Value that indicates if there are any line items for this negotiation.
NegotiationHeaderHasPeForAllItems Value that indicates if all the items in the negotiation doc has Price Elements defined.
NegotiationHeaderHasPriceElements Value that indicates if any item in the negotiation doc has Price Elements defined.
NegotiationHeaderHasScoringTeamsFlag Indicates if this negotiation has been enabled for Team Scoring.
NegotiationHeaderHdrAttrDisplayScore Denotes whether to show header attribute scoring criteria to suppliers.
NegotiationHeaderHdrAttrEnableWeights Denotes whether weights are enabled on header attributes.
NegotiationHeaderHdrAttrMaximumScore Field that stores the default maximum score on the header attributes.
NegotiationHeaderHdrAttributeEnabledFlag Value that indicates if header attribute is enabled.
NegotiationHeaderImportFileName Spreadsheet file name that's used for importing.
NegotiationHeaderIncludePdfInExternalPage Indicates condition whether to include PDF in external page
NegotiationHeaderIntAttribute1 Character segment for the Internal Descriptive Flexfield. This segment isn't visible to supplier bidders.
NegotiationHeaderIntAttribute10 Character segment for the Internal Descriptive Flexfield. This segment isn't visible to supplier bidders.
NegotiationHeaderIntAttribute11 Character segment for the Internal Descriptive Flexfield. This segment isn't visible to supplier bidders.
NegotiationHeaderIntAttribute12 Character segment for the Internal Descriptive Flexfield. This segment isn't visible to supplier bidders.
NegotiationHeaderIntAttribute13 Character segment for the Internal Descriptive Flexfield. This segment isn't visible to supplier bidders.
NegotiationHeaderIntAttribute14 Character segment for the Internal Descriptive Flexfield. This segment isn't visible to supplier bidders.
NegotiationHeaderIntAttribute15 Character segment for the Internal Descriptive Flexfield. This segment isn't visible to supplier bidders.
NegotiationHeaderIntAttribute2 Character segment for the Internal Descriptive Flexfield. This segment isn't visible to supplier bidders.
NegotiationHeaderIntAttribute3 Character segment for the Internal Descriptive Flexfield. This segment isn't visible to supplier bidders.
NegotiationHeaderIntAttribute4 Character segment for the Internal Descriptive Flexfield. This segment isn't visible to supplier bidders.
NegotiationHeaderIntAttribute5 Character segment for the Internal Descriptive Flexfield. This segment isn't visible to supplier bidders.
NegotiationHeaderIntAttribute6 Character segment for the Internal Descriptive Flexfield. This segment isn't visible to supplier bidders.
NegotiationHeaderIntAttribute7 Character segment for the Internal Descriptive Flexfield. This segment isn't visible to supplier bidders.
NegotiationHeaderIntAttribute8 Character segment for the Internal Descriptive Flexfield. This segment isn't visible to supplier bidders.
NegotiationHeaderIntAttribute9 Character segment for the Internal Descriptive Flexfield. This segment isn't visible to supplier bidders.
NegotiationHeaderIntAttributeCategory Values that identifies the Internal Descriptive Flexfield context category. The segments under this category aren't visible to supplier bidders.
NegotiationHeaderIsPaused Indicates whether the negotiation is paused or not.
NegotiationHeaderIsTemplateFlag Value that identifies if the row represents a template or negotiation.
NegotiationHeaderLanguageCode Language in which the negotiation is created in
NegotiationHeaderLargeNegEnabledFlag Value that indicates if large negotiation is enabled.
NegotiationHeaderLastLineNumber Maximum line, lot, or group number in the negotiation.
NegotiationHeaderLastPauseDate Date on which the negotiation is paused.
NegotiationHeaderLastUpdateDate Indicates the date and time of the last update of the row.
NegotiationHeaderLastUpdateLogin Indicates the session login associated to the user who last updated the row.
NegotiationHeaderLastUpdatedBy Indicates the session login associated to the user who last updated the row.
NegotiationHeaderLineAttributeEnabledFlag Value that indicates if the attribute is enabled.
NegotiationHeaderLineMasEnabledFlag Value that indicates if MAS is enabled.
NegotiationHeaderLotEnabledFlag Value that indicates if lot is enabled.
NegotiationHeaderMaxBidColorSequenceId Maximum color sequence number allotted to the responses for this negotiation.
NegotiationHeaderMaxDocumentLineNum Indicates the maximum parent document line number throughout all the rounds and amendments.
NegotiationHeaderMaxInternalLineNum Indicates the maximum line number throughout all the rounds and amendments.
NegotiationHeaderMaxRetainageNegotiableFlag Value that indicates whether the maximum retainage amount on the line is negotiable.
NegotiationHeaderMinBidChangeType Indicates minimum bid change type.
NegotiationHeaderMinBidDecrement Minimum allowable bid decrement in a bidders bid if multiple bids are allowed.
NegotiationHeaderNegApprovalDate Date when the approve or reject decision is made.
NegotiationHeaderNegApprovalEnabledFlag Value that indicates whether negotiation approval is enabled.
NegotiationHeaderNegTeamEnabledFlag Value that indicates if collaboration team is enabled.
NegotiationHeaderNumberOfBids Indicates number of bids received.
NegotiationHeaderNumberOfExtensions Indicates number of extensions made.
NegotiationHeaderNumberOfLines Indicates number of lines in the negotiation.
NegotiationHeaderNumberPriceDecimals Required precision of bid price.
NegotiationHeaderObjectVersionNumber Unique identifier to implement optimistic locking. This number is incremented every time that the row is updated.
NegotiationHeaderOpenAuctionNowFlag Value that indicates the auction is open now.
NegotiationHeaderOpenBiddingDate Date when the auction is open for bidding.
NegotiationHeaderOriginalCloseBiddingDate Original date for which auction was setup to close for bidding.
NegotiationHeaderOutcomeStatus Status to indicate outcome creation.
NegotiationHeaderPauseRemarks Indicated the reason for which the negotiation is paused.
NegotiationHeaderPaymentTermsId Unique identifier for payment terms.
NegotiationHeaderPersonId Indicates ID of the auction creator.
NegotiationHeaderPfTypeAllowed Indicates the combination of buyer and supplier price factors.
NegotiationHeaderPoAgreedAmount Indicates purchase order's agreed amount. This is applicable only for long term buyer's auction.
NegotiationHeaderPoEndDate Indicates purchase order end date. This is applicable only for long term buyer's auction.
NegotiationHeaderPoMinRelAmount Indicates blanket minimum release amount.
NegotiationHeaderPoStartDate Indicates purchase order start date. This is applicable only for long term buyer's auction.
NegotiationHeaderPoStyleId Unique key identifier for purchase order style for the negotiation.
NegotiationHeaderPowerBiddingEnabledFlag Value that indicates if power bidding is enabled.
NegotiationHeaderPrcBuId Unique identifier for a procurement business unit
NegotiationHeaderPriceDrivenAuctionFlag Value that indicates that the auction is being price driven.
NegotiationHeaderPriceElementEnabledFlag Value that indicates if price element is enabled.
NegotiationHeaderPriceTiersIndicator Indicates the price tiers child entities in the line items.
NegotiationHeaderProgramAppName Identifies the application name spawning the concurrent request.
NegotiationHeaderProgramName Identifies the concurrent program.
NegotiationHeaderProgressPaymentType Indicates whether the negotiation is used for complex services and the type.
NegotiationHeaderProgressPymtNegotiableFlag Value that indicates whether the progress payment rate is negotiable.
NegotiationHeaderProjectId Unique identifier of the project in Oracle Projects which governs the negotiation.
NegotiationHeaderProxyBiddingEnabledFlag Value that indicates if proxy bidding is enabled.
NegotiationHeaderPublishAuctionNowFlag Value to publish the auction.
NegotiationHeaderPublishDate Date when the negotiation is published.
NegotiationHeaderPublishDateOrigAmend Publish date of the original amendment.
NegotiationHeaderPublishRatesToBiddersFlag Value that indicates if currency exchange rates are allowed to be published to bidders.
NegotiationHeaderQtyPriceTiersEnabledFlag Value to indicate if quantity based price tiers is enabled.
NegotiationHeaderRankIndicator Rank indicator for this negotiation.
NegotiationHeaderRateDate Indicates currency conversion rate date. Applicable only if the rate type is corporate.
NegotiationHeaderRateType Indicates currency rate type.
NegotiationHeaderRecoupmentNegotiableFlag Value that indicates whether the recoup rate on the line is negotiable
NegotiationHeaderReminderDate Reminder date that indicates email should be sent out if invited bidder hasn't acknowledged participation.
NegotiationHeaderReqBuId ID that represents a requisition business unit.
NegotiationHeaderRequestDate Date and time when concurrent request was submitted for creation or award flow.
NegotiationHeaderRequestId Enterprise Service Scheduler that indicates the request ID of the job that created or last updated the row.
NegotiationHeaderRequestedBy User ID of the person who made the concurrent request.
NegotiationHeaderRetainageNegotiableFlag Value that indicates whether the retainage rate on the line is negotiable.
NegotiationHeaderRfiLineEnabledFlag Yes or No Value to indicate if line is enabled, applicable only to RFI.
NegotiationHeaderScoringLockDate Date on which this negotiation was closed for team scoring.
NegotiationHeaderSealedActualUnlockDate Date when the sealed auction was unlocked.
NegotiationHeaderSealedActualUnsealDate Date when the sealed auction was unsealed.
NegotiationHeaderSealedAuctionStatus Status of sealed auction.
NegotiationHeaderShareAwardDecision Value to determine whether to share award decision with suppliers.
NegotiationHeaderShowBidderNotes Value that indicates if bidder notes and attachments are visible to other bidders
NegotiationHeaderShowBidderScores Value that indicates whether scoring model is displayed to bidders.
NegotiationHeaderSourceDocId ID that uniquely identifies source document.
NegotiationHeaderSourceDocLineMsg Source document line display message name.
NegotiationHeaderSourceDocMsg Source document message display name.
NegotiationHeaderSourceDocMsgApp Short name for message application.
NegotiationHeaderSourceDocNumber Number that uniquely identifies Source document.
NegotiationHeaderSourceReqsFlag Value that indicates whether to source requisitions against blanket agreements.
NegotiationHeaderStaggeredClosingInterval Interval identifying when the staggered line is closing.
NegotiationHeaderStyleId ID that uniquely identifies negotiation style.
NegotiationHeaderSupplierEnterablePymtFlag 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.
NegotiationHeaderSupplierViewType Indicates whether suppliers will transformed quotes.
NegotiationHeaderTeamScoringEnabledFlag 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.
NegotiationHeaderTechnicalActualUnlockDate Date when the negotiation was technically unlocked.
NegotiationHeaderTechnicalActualUnsealDate Date when the negotiation was technically unsealed.
NegotiationHeaderTechnicalEvaluationStatus Stores the technical evaluation completion status.
NegotiationHeaderTechnicalLockStatus Status that indicates technical part's lock status for a two-part RFQ.
NegotiationHeaderTemplateId Foreign Key that uniquely identifies Auction header for the template.
NegotiationHeaderTemplateScope Scope of template that indicates whether the template is private or public.
NegotiationHeaderTemplateStatus Template status that indicates whether the template is active or inactive.
NegotiationHeaderTwoPartFlag Yes or No Value to indicate whether if the negotiation is two-part RFQ.
NegotiationHeaderVersionNum Version number that uniquely identifies a contract.
NegotiationHeaderViewByDate Negotiation Date to view authorized suppliers.
NegotiationHeaderWfApprovalItemKey Key identifier for Approval workflow.
NegotiationHeaderWfAwardApprovalItemKey Item Key that's created for Award Approval Workflow.
NegotiationHeaderWfItemKey Workflow Item Key for the main AUCTION workflow.
NegotiationHeaderWfPoncomplCurrentRound Current Workflow round kicked off to create outcome documents.
NegotiationHeaderWfPoncomplItemKey Workflow item key created to hold the invited bidders as well as active bidders.
NegotiationHeaderWfRoleName Workflow Role name created to hold the invited bidders as well as active bidders.
NegotiationLineAdditionalJobDetails Unique identifier for additional job details.
NegotiationLineAdvanceAmount Amount that may be paid in advance for this line item.
NegotiationLineAllocationStatus Indicates the allocation status of the line item.
NegotiationLineAuctionHeaderId Unique identifier for the auction header.
NegotiationLineAwardMode Indicates mode through which this item was awarded.
NegotiationLineAwardStatus Award status for this item.
NegotiationLineAwardedQuantity Total quantity awarded for auction.
NegotiationLineBestBidBidCurrencyCode Bid currency code for bid with the best price and score.
NegotiationLineBestBidBidCurrencyPrice Price in bid currency for bid with the best price and score.
NegotiationLineBestBidBidNumber Bid number for bid with the best price and score ratio.
NegotiationLineBestBidBidPrice Price for bid with the best price and score ratio.
NegotiationLineBestBidCurrencyCode Currency code of best bid.
NegotiationLineBestBidCurrencyPrice Best bid price in the best bid currency.
NegotiationLineBestBidFirstBidPrice First Bid price received.
NegotiationLineBestBidNumber Bid Number of bid containing best price.
NegotiationLineBestBidPrice Identifier for the price in best bid.
NegotiationLineBestBidPromisedDate Date on which the best bid is promised.
NegotiationLineBestBidProxyLimitPrice Proxy Bid price for the best bid.
NegotiationLineBestBidQuantity Indicates quantity in best bid.
NegotiationLineBestBidScore Score for bid with the best price and score ratio.
NegotiationLineBidStartPrice Price that bids can start from.
NegotiationLineCategoryId Unique Identifier for category.
NegotiationLineCloseBiddingDate Date when the bidding is closed for this item.
NegotiationLineCreatedBy Indicates user who created the row.
NegotiationLineCreationDate Indicates date and time of the creation of the row.
NegotiationLineCurrentPrice Indicates current price of item being paid outside auction.
NegotiationLineDifferentialResponseType Indicates negotiation item's price differential response type.
NegotiationLineDispLineNumber Indicates internal number used for ordering lines.
NegotiationLineDisplayTargetPriceFlag Value that indicates whether to display target price to bidders.
NegotiationLineDocumentDispLineNumber Indicates document line number to display.
NegotiationLineGroupType Unique identifier indicating group type.
NegotiationLineHasAttributesFlag Value that indicates if the line item has attributes.
NegotiationLineHasBuyerPfsFlag Value that indicates whether this line has any buyer price factors or not.
NegotiationLineHasPaymentsFlag Value that indicates whether this line has payments defined under it.
NegotiationLineHasPriceDifferentialsFlag Value that indicates if the item has price differentials.
NegotiationLineHasPriceElementsFlag Value that indicates if any supplier cost factors exists for the line.
NegotiationLineHasQuantityTiers Indicates whether there are quantity tiers or not.
NegotiationLineHasShipmentsFlag Value that indicates if the line has shipments.
NegotiationLineInvOrgId Unique identifier for inventory organization ID.
NegotiationLineItemDescription Unique identifier for item description.
NegotiationLineItemId Unique identifier for item ID.
NegotiationLineItemRevision Unique identifier for item revision ID.
NegotiationLineJobId Unique identifier for job ID.
NegotiationLineLastAmendmentUpdate Amendment number for which this line was last modified.
NegotiationLineLastUpdateDate Indicates the date and time of the last update of the row.
NegotiationLineLastUpdateLogin Indicates the session login associated to the user who last updated the row.
NegotiationLineLastUpdatedBy Indicates the user who last updated the row.
NegotiationLineLineNumber Identifier for the internal line number.
NegotiationLineLineOriginationCode Indicates line origination code.
NegotiationLineLineTypeId Indicates line type ID.
NegotiationLineMaxRetainageAmount Maximum amount that can be retained across all invoices for this line.
NegotiationLineMaxSubLineSequenceNumber Maximum subline sequence number for a lot or group.
NegotiationLineModifiedDate Indicates last modified date.
NegotiationLineModifiedFlag Value that indicates if the item is modified in the current round compared to the previous round.
NegotiationLineNeedByDate Date on which the item is needed at shipping location.
NegotiationLineNoAward Value to identify if the negotiation line has been marked as no award.
NegotiationLineNoteToBidders Indicates note to the bidders in the negotiation.
NegotiationLineNumberOfBids Indicates number of bids received for this item.
NegotiationLineNumberOfExtensions Indicates number of auto extensions received on this line item.
NegotiationLineObjectVersionNumber Used to implement optimistic locking. The number is incremented every time that the row is updated.
NegotiationLineOrderTypeLookupCode Indicates line type basis lookup code.
NegotiationLineParentLineNumber Indicates line number of parent lot or group.
NegotiationLinePoAgreedAmount Indicates budgeted purchase order amount.
NegotiationLinePoMinRelAmount Indicates purchase order minimum release amount.
NegotiationLinePrcBuId Unique ID for procurement business unit.
NegotiationLinePriceBreakNegFlag Value that indicates if the price breaks are negotiable.
NegotiationLinePriceBreakType Indicates type of price break.
NegotiationLinePriceDiffShipmentNumber Indicates price differential shipment number.
NegotiationLinePriceDisabledFlag Value that indicates if price is disabled for the line in an RFI.
NegotiationLineProgressPymtRatePercent Percentage of the amount that will be due to the supplier upon fulfillment of a pay item for each invoice for this line.
NegotiationLineProjectAwardId Unique identifier of the award which is association with this line.
NegotiationLineProjectExpOrganizationId Unique identifier of the expenditure organization associated with this line for Oracle Projects.
NegotiationLineProjectExpenditureItemDate Date used for accounting the transaction for this line in Oracle Projects.
NegotiationLineProjectExpenditureType Expenditure type in Oracle Projects associated with this line.
NegotiationLineProjectId Unique identifier of the project in Oracle Projects to which the cost of this line will be charged when executed in Oracle Purchasing.
NegotiationLineProjectTaskId Unique identifier of the task in Oracle projects to which the cost of this line will be charged when executed in Oracle purchasing.
NegotiationLinePurchaseBasis Indicates line type purchase basis.
NegotiationLineQuantity Identifies the quantity of the line items.
NegotiationLineQuantityDisabledFlag Value that indicates if quantity is disabled for the line in RFI.
NegotiationLineRecoupmentRatePercent Percentage of the amount of each invoice for this line that can be recouped when financing or advances are provided to the supplier.
NegotiationLineReqBuId Identifies the requisitioning business unit for this item.
NegotiationLineRequisitionNumber Indicates requisition number.
NegotiationLineRetainageRatePercent Percentage of the invoice line amount that will be retained until the work is completed and accepted.
NegotiationLineShipToLocationId Unique location identifier to which auction items will be shipped.
NegotiationLineSourceDocId Indicates source document ID.
NegotiationLineSourceDocNumber Indicates source document number for display.
NegotiationLineSourceLineId Indicates source document line ID.
NegotiationLineSourceLineNumber Indicates source document line number for display.
NegotiationLineSubLineSequenceNumber Indicates lot or group line's sequence within the lot or group.
NegotiationLineTargetPrice Indicates target price for item
NegotiationLineUnitDisplayTargetFlag Value that indicates whether to display target price of unit price to suppliers or not.
NegotiationLineUnitTargetPrice Indicates target price for auction item unit price.
NegotiationLineUomCode Indicates code for unit of measure.
NegotiationLineWorkApproverUserId Unique identifier of the user who's responsible for confirming that the supplier has performed work as agreed.
NegotiationParentLineAdditionalJobDetails Unique identifier for additional job details.
NegotiationParentLineAdvanceAmount Amount that may be paid in advance for this line item.
NegotiationParentLineAllocationStatus Indicates the allocation status of the line item.
NegotiationParentLineAuctionHeaderId Unique identifier for the negotiation header.
NegotiationParentLineAwardMode Indicates mode through which this item was awarded.
NegotiationParentLineAwardStatus Award status for this item.
NegotiationParentLineAwardedQuantity Total quantity awarded for negotiation.
NegotiationParentLineBestBidBidCurrencyCode Response currency code for the response with the best price and score.
NegotiationParentLineBestBidBidCurrencyPrice Price in response currency for the response with the best price and score.
NegotiationParentLineBestBidBidNumber Response number for the response with the best price and score ratio.
NegotiationParentLineBestBidBidPrice Price for the response with the best price and score ratio.
NegotiationParentLineBestBidCurrencyCode Currency code of the best response.
NegotiationParentLineBestBidCurrencyPrice Best response price in the best response currency.
NegotiationParentLineBestBidFirstBidPrice First response price received.
NegotiationParentLineBestBidNumber Response number of the response containing the best price.
NegotiationParentLineBestBidPrice Identifier for the price in the best response.
NegotiationParentLineBestBidPromisedDate Date on which the best response is promised.
NegotiationParentLineBestBidProxyLimitPrice Proxy response price for the best response.
NegotiationParentLineBestBidQuantity Indicates the quantity in the best response.
NegotiationParentLineBestBidScore Score for the response with the best price and score ratio.
NegotiationParentLineBidStartPrice Price that responses can start from.
NegotiationParentLineCategoryId Unique identifier for the category.
NegotiationParentLineCloseBiddingDate Date when responding is closed for this item.
NegotiationParentLineCreatedBy Indicates the user who created the row.
NegotiationParentLineCreationDate Date and time of the creation of the row.
NegotiationParentLineCurrentPrice Indicates the current price of item being paid outside negotiation.
NegotiationParentLineDifferentialResponseType Indicates the negotiation item's price differential response type.
NegotiationParentLineDispLineNumber Indicates the internal number used for ordering lines.
NegotiationParentLineDisplayTargetPriceFlag Value that indicates whether to display the target price to respondents.
NegotiationParentLineDocumentDispLineNumber Indicates the document line number to display.
NegotiationParentLineGroupType Unique identifier indicating the group type.
NegotiationParentLineHasAttributesFlag Value that indicates if the line item has attributes.
NegotiationParentLineHasBuyerPfsFlag Value that indicates whether this line has any buyer price factors.
NegotiationParentLineHasPaymentsFlag Value that indicates whether this line has payments defined under it.
NegotiationParentLineHasPriceDifferentialsFlag Value that indicates if the item has price differentials.
NegotiationParentLineHasPriceElementsFlag Value that indicates if any supplier cost factors exists for the line.
NegotiationParentLineHasQuantityTiers Indicates whether there are quantity tiers.
NegotiationParentLineHasShipmentsFlag Value that indicates if the line has shipments.
NegotiationParentLineInvOrgId Unique identifier for inventory organization ID.
NegotiationParentLineItemDescription Unique identifier for item description.
NegotiationParentLineItemId Unique identifier for item ID.
NegotiationParentLineItemRevision Unique identifier for item revision ID.
NegotiationParentLineJobId Unique identifier for job ID.
NegotiationParentLineLastAmendmentUpdate Amendment number for which this line was last modified.
NegotiationParentLineLastUpdateDate Date and time of the last update of the parent line row.
NegotiationParentLineLastUpdateLogin Session login associated with the user who last updated the parent line row.
NegotiationParentLineLastUpdatedBy User who last updated the parent line row.
NegotiationParentLineLineNumber Identifier for the internal line number.
NegotiationParentLineLineOriginationCode Indicates line origination code.
NegotiationParentLineLineTypeId Indicates line type ID.
NegotiationParentLineMaxRetainageAmount Maximum amount that can be retained across all invoices for this line.
NegotiationParentLineMaxSubLineSequenceNumber Maximum subline sequence number for a lot or group.
NegotiationParentLineModifiedDate Indicates last modified date.
NegotiationParentLineModifiedFlag Value that indicates if the item is modified in the current round compared to the previous round.
NegotiationParentLineNeedByDate Date on which the item is needed at the shipping location.
NegotiationParentLineNoAward Value used to identify if the negotiation line has been marked as no award.
NegotiationParentLineNoteToBidders Indicates note to the respondents in the negotiation.
NegotiationParentLineNumberOfBids Indicates the number of responses received for this item.
NegotiationParentLineNumberOfExtensions Indicates the number of auto extensions received on this line item.
NegotiationParentLineObjectVersionNumber Used to implement optimistic locking. The number is incremented every time that the row is updated.
NegotiationParentLineOrderTypeLookupCode Indicates the line type basis lookup code.
NegotiationParentLineParentLineNumber Indicates the line number of parent lot or group.
NegotiationParentLinePoAgreedAmount Indicates the budgeted purchase order amount.
NegotiationParentLinePoMinRelAmount Indicates the purchase order minimum release amount.
NegotiationParentLinePrcBuId Unique ID for procurement business unit.
NegotiationParentLinePriceBreakNegFlag Value that indicates if the price breaks are negotiable.
NegotiationParentLinePriceBreakType Indicates type of price break.
NegotiationParentLinePriceDiffShipmentNumber Indicates the type of price differential shipment number.
NegotiationParentLinePriceDisabledFlag Value that indicates if price is disabled for the line in an RFI.
NegotiationParentLineProgressPymtRatePercent Percentage of the amount that will be due to the supplier upon fulfillment of a pay item for each invoice for this line.
NegotiationParentLineProjectAwardId Unique identifier of the award which is association with this line.
NegotiationParentLineProjectExpOrganizationId Unique identifier of the expenditure organization associated with this line for Oracle Projects.
NegotiationParentLineProjectExpenditureItemDate Date used for accounting the transaction for this line in Oracle Projects.
NegotiationParentLineProjectExpenditureType Expenditure type in Oracle Projects associated with this line.
NegotiationParentLineProjectId Unique identifier of the project in Oracle Projects to which the cost of this line will be charged when executed in Oracle Purchasing.
NegotiationParentLineProjectTaskId Unique identifier of the task in Oracle Projects to which the cost of this line will be charged when executed in Oracle Purchasing.
NegotiationParentLinePurchaseBasis Indicates the line type purchase basis.
NegotiationParentLineQuantity Identifies the quantity of the line items.
NegotiationParentLineQuantityDisabledFlag Value that indicates if quantity is disabled for the line in RFI.
NegotiationParentLineRecoupmentRatePercent Percentage of the amount of each invoice for this line that can be recouped when financing or advances are provided to the supplier.
NegotiationParentLineReqBuId Identifies the requisitioning business unit for this item.
NegotiationParentLineRequisitionNumber Indicates requisition number.
NegotiationParentLineRetainageRatePercent Percentage of the invoice line amount that will be retained until the work is completed and accepted.
NegotiationParentLineShipToLocationId Unique location identifier to which Negotiation items will be shipped.
NegotiationParentLineSourceDocId Indicates the source document ID.
NegotiationParentLineSourceDocNumber Indicates the source document number for display.
NegotiationParentLineSourceLineId Indicates the source document line ID.
NegotiationParentLineSourceLineNumber Indicates the source document line number for display.
NegotiationParentLineSubLineSequenceNumber Indicates the lot or group line sequence within the lot or group.
NegotiationParentLineTargetPrice Indicates the target price for the item
NegotiationParentLineUnitDisplayTargetFlag Value that indicates whether to display target price of unit price to suppliers or not.
NegotiationParentLineUnitTargetPrice Indicates the target price for negotiation item unit price.
NegotiationParentLineUomCode Code for the unit of measure.
NegotiationParentLineWorkApproverUserId Unique identifier of the user who's responsible for confirming that the supplier has performed work as agreed.
SequenceNumber Number denoting the sequence in which price element is added to line or list.
SourcingCostFactorCreatedBy User who created the cost factor row.
SourcingCostFactorCreationDate Date and time of the creation of the cost factor row.
SourcingCostFactorDisplayTargetFlag Value that indicates whether to display the target value to supplier.
SourcingCostFactorDisplayToSuppliersFlag Value that indicates whether to display this price factor to suppliers.
SourcingCostFactorLastUpdateDate Date and time of the last update of the cost factor row.
SourcingCostFactorLastUpdateLogin Session login associated with the user who last updated the cost factor row.
SourcingCostFactorLastUpdatedBy Indicates user who created the cost factor row.
SourcingCostFactorObjectVersionNumber Unique identifier used to implement optimistic locking. This number is incremented every time that the row is updated.
SourcingCostFactorPfType Indicates whether this price factor is of type buyer or supplier.
SourcingCostFactorPriceElementTypeId Unique system generated identifier of the price element.
SourcingCostFactorPricingBasis Pricing basis for the cost factor.
SourcingCostFactorProgramAppName Identifies the application name spawning the concurrent request.
SourcingCostFactorProgramName Concurrent program name.
SourcingCostFactorRequestId Unique identifier of the job that created or last updated the row.
SourcingCostFactorTypeDescription Description of the cost factor type.
SourcingCostFactorTypeEnabledFlag Value that indicates whether this price element type is enabled.
SourcingCostFactorTypeName Name of the cost factor type.
SourcingCostFactorTypePriceElementCode Alphanumeric code for price element defined by the user.
SourcingCostFactorTypePriceElementTypeId Unique system generated identifier of the price element.
SourcingCostFactorTypePricingBasis Pricing basis for the cost factor type.
SourcingCostFactorTypeRowId1 Unique identifier for the cost factor row.
SourcingCostFactorTypeSystemFlag Delivered price element for item price.
SourcingCostFactorValue Target value for the cost factor.