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. |