Sourcing Requirement and Attribute Details

The Sourcing Requirement and Attribute Details view object consolidates common information about sourcing requirements and their attributes.

Data Store Key : FscmTopModelAM.PrcExtractAM.PonBiccExtractAM.SourcingRequirementAndAttributePVO

Primary Keys : AttributeListId, AuctionHeaderId, LineNumber, SequenceNumber

Initial Extract Date : SourcingReqAttCreationDate

Incremental Extract Date : SourcingReqAttLastUpdateDate

Attributes

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

Name Description
AgingOnsetPoint Time frame until which the requirement is valid.
AgingPeriodDays Number of days until which the requirement is valid.
AllowItemDescUpdateFlag Value that indicates if the item descriptions can be updated.
AllowManulPriceUpdateOrder Order in which the manual price entry was updated.
AllowRetroPricing Value that indicates whether retro active pricing is enabled.
AttributeListId Unique Identifier for attribute list.
AuctionHeaderId Unique identifier for the Negotiation header.
AwardApprovalEnabledFlag Control to enable approval of award decision before it is completed.
BestPriceVisibleBlind Value that indicates if the best price Response is visible in blind negotiations.
BuyerManagedTransportFlag Value that indicates that the buying company is responsible for arranging the transportation, from picking up the requested goods to delivering to ship-to locations specified on the order.
CarrierId Indicates unique identifier of carrier.
CatAdminAuthoringAcceptance Catalog administrator acceptance level for agreement change.
CategoryCategoryId Unique identifier of category.
CategoryCategoryName Name of the category.
CategoryDescription Description of the category.
CategoryEnabledFlag Value that indicates if the requirement category has been 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.
CloseBidDate Date on which the negotiation was closed for bidding.
CollabSecurityProfileId Unique identifier for the security profile of the collaboration team.
ConsumptionAdviceFrequency Frequency at which the Create Consumption Advice program will run for all consumption transactions for consigned inventory purchased under the agreements created in this business unit.
ConsumptionAdviceSummary Granularity at which consumption advices will be generated.
CreateDebitMemoFlag Value that indicates whether a debit memo should be created.
CreatedBy User who created the row.
CreationDate Date and time the row was last updated.
CurrencyCode Code of the currency used by the buyer organization.
DailyConversionTypeNegoHdrConversionType Conversion factor between the negotiation line and the 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.
DailyConversionTypeNegoHdrLastUpdateDate Date and time when the negotiation header row was updated.
DailyConversionTypeNegoHdrLastUpdateLogin Session login associated with the user who last updated the negotiation header row.
DailyConversionTypeNegoHdrLastUpdatedBy User who created the negotiation header row.
DailyConversionTypeNegoHdrObjectVersionNumber Used to implement optimistic locking. The number is incremented every time that the row is updated.
DailyConversionTypeNegoHdrPivotCurrencyCode Currency code of the best bid.
DailyConversionTypeNegoHdrSecurityFlag Value that indicates if the negotiation is secured.
DailyConversionTypeNegoHdrUserConversionType Conversion factor between the negotiation line and the alternate line.
DailyConversionTypeNegoHdrUserOverrideCrossRateFlag Value that indicates if the cross rate has been overridden.
DefaultBuyerId Unique identifier for the default buyer.
DefaultPromiseDate Indicates if the application should check the default promise date from need-by date.
DefaultRateType Default currency rate type for your documents.
DoctypeId Unique identifier for the document type.
EmailAttachmentFilename File name for the email attachment.
EnforceBuyerAuthorityFlag Value that indicates buyer authority for the procurement business unit.
EnforceMinBidPrice Value that indicates if the minimum response price is enforced.
EnforceVendorHoldFlag Indicates whether you enforce supplier holds during purchase order approval.
FobLookupCode Code for the procurement business unit.
FreightTermsLookupCode Freight terms code for the procurement business unit.
GenOrderForNegReqsFlag Indicates whether negotiated requisition lines having valid supplier information should be automatically processed to purchase orders even without any purchase agreement reference.
GlobalAttribute1 Segment for the Sourcing Requirement and Attribute global descriptive flexfield.
GlobalAttribute10 Segment for the Sourcing Requirement and Attribute global descriptive flexfield.
GlobalAttribute11 Segment for the Sourcing Requirement and Attribute global descriptive flexfield.
GlobalAttribute12 Segment for the Sourcing Requirement and Attribute global descriptive flexfield.
GlobalAttribute13 Segment for the Sourcing Requirement and Attribute global descriptive flexfield.
GlobalAttribute14 Segment for the Sourcing Requirement and Attribute global descriptive flexfield.
GlobalAttribute15 Segment for the Sourcing Requirement and Attribute global descriptive flexfield.
GlobalAttribute16 Segment for the Sourcing Requirement and Attribute global descriptive flexfield.
GlobalAttribute17 Segment for the Sourcing Requirement and Attribute global descriptive flexfield.
GlobalAttribute18 Segment for the Sourcing Requirement and Attribute global descriptive flexfield.
GlobalAttribute19 Segment for the Sourcing Requirement and Attribute global descriptive flexfield.
GlobalAttribute2 Segment for the Sourcing Requirement and Attribute global descriptive flexfield.
GlobalAttribute20 Segment for the Sourcing Requirement and Attribute global descriptive flexfield.
GlobalAttribute3 Segment for the Sourcing Requirement and Attribute global descriptive flexfield.
GlobalAttribute4 Segment for the Sourcing Requirement and Attribute global descriptive flexfield.
GlobalAttribute5 Segment for the Sourcing Requirement and Attribute global descriptive flexfield.
GlobalAttribute6 Segment for the Sourcing Requirement and Attribute global descriptive flexfield.
GlobalAttribute7 Segment for the Sourcing Requirement and Attribute global descriptive flexfield.
GlobalAttribute8 Segment for the Sourcing Requirement and Attribute global descriptive flexfield.
GlobalAttribute9 Segment for the Sourcing Requirement and Attribute global descriptive flexfield.
GlobalAttributeCategory Segment for the Sourcing Requirement and Attribute global descriptive flexfield.
GroupRequisitionLines Indicates to check group requisition lines.
GroupRequisitions Indicates to check requirement grouping functionality.
HdrAttrDefaultMaxScore Maximum score for the header level attribute.
HdrAttrDispScoreCriteria Value that indicates if the scoring criteria should be displayed to suppliers.
HdrAttrEnableWeights Value that indicates if requirement weights are enabled.
HdrAwardDate Date on which the negotiation is awarded.
InspectionRequiredFlag Value that indicates whether you require inspection for items you order.
InventoryOrganizationId Default inventory organization ID for the procurement business unit.
InvoiceCloseCode Default receiving close point.
InvoiceCloseTolerance Default receiving close tolerance percentage.
ItemInventoryItemId Unique identifier for inventory item.
ItemInventoryOrganizationId Default inventory organization ID for the procurement business unit.
ItemItemNumber Number of the line item.
ItemItemType Type of line item.
ItemNumber Number of the line item.
ItemOrganizationId Default inventory organization ID for the procurement business unit.
ItemPrimaryUomCode Indicates the code for the unit of measure.
LanguageCode Code of the language in which the negotiation is created.
LastUpdateDate Date and time of the last update of the row.
LastUpdateLogin Session login associated to the user who last updated the row.
LastUpdatedBy User who created the row.
LineNumber Negotiation line item number.
LineTypeId Unique identifier for the line item type.
ManualReceiptNumType Receipt number type.
ManualReqNumType Requisition number type.
MatchOption Value that indicates whether the invoice for the shipment should be matched to the purchase order or the receipt.
MaxAttachmentSize Maximum allowed size of attachment files.
MinReleaseAmount Default minimum release amount for blanket and planned purchase orders in functional currency.
ModeOfTransport Type of transportation used to ship the product, such as truck, air, boat.
NegApprovalEnabledFlag Control to enable approval of the negotiation before it is published.
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.
NegotiationHeaderAllowAlternateLines Value that indicates whether allow control alternate lines is enabled or not.
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.
NegotiationHeaderAwardCompleteDateOnly Date on which the award 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.
NegotiationHeaderBuyerTransportEnabledFlag Value that indicates whether buyer managed transportation is enabled.
NegotiationHeaderBuyerTransportFlag Value that indicates whether buyer will manage transportation.
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 is 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.
NegotiationHeaderModeOfTransport Type of transportation used to ship the product, such as truck, air or boat.
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 has not acknowledged participation.
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.
NegotiationHeaderServiceLevel Priority of transportation that affects how quickly goods are transported.
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.
NegotiationHeaderTwostageEvalEnabledFlag Yes or No Value to indicate whether the two stage evaluation is enabled.
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 is 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 sub-line 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.
NegotiationLineRequestedDeliveryDate Date when the designated product that the procurement organization intends to buy is needed.
NegotiationLineRequestedShipDate Date when the buyer company wants the supplier to ship out the designated product that the buyer company intends to buy.
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 is responsible for confirming that the supplier has performed work as agreed.
NegotiationStatus Current status of the negotiation.
NegotiationStatusDisplayName Display name of the negotiation status.
NextApproverLookupCode Indicates the type of next approver.
NextNegotiationNumber Unique identifier for the next negotiation.
ObjectVersionNumber Used to implement optimistic locking. The number is incremented every time that the row is updated.
ObjectVersionNumber1 Used to implement optimistic locking. The number is incremented every time that the row is updated.
OpenBidDate Date on which the negotiation is open for bidding.
PrcBuId Unique identifier of the procurement business unit.
PriceBreakLookupCode Default price break type for catalog quotations and blanket agreements.
PriceChangeAmount Price difference amount that you allow between requisition and purchase order price.
ProcurementItemNumber Item number which has been procured.
PublishDate Date on which the negotiation is published.
RankIndicator Indicator for the response rank.
RankVisibleBlind Value that indicates if the rank visibility is enabled in blind negotiations.
ReceiveCloseCode Default receiving close point.
ReceiveCloseTolerance Default receiving close tolerance percentage.
ReceivingFlag Value that indicates whether you require receipt for items you order or not.
RfqOnlySiteFlag Value that indicates if there is a supplier site in RFQ.
SequenceNumber Sequence number for attribute display order.
ServiceLevel Priority of transportation that affects how quickly goods will be transported.
SourcingReqAttAttrDispSeqNumber Display sequence number of the requirement attribute.
SourcingReqAttAttrGroupSeqNumber Group sequence number of the requirement attribute.
SourcingReqAttAttrLevel Level of the requirement attribute.
SourcingReqAttAttrMaxScore Maximum score for the header level attribute.
SourcingReqAttAttributeName Name of the requirement attribute.
SourcingReqAttCreatedBy User who created the requirement row.
SourcingReqAttCreationDate Date and time of the creation of the requirement row.
SourcingReqAttDatatype Data type of the attribute value.
SourcingReqAttDateValue Date value of the requirement attribute.
SourcingReqAttDisplayTargetFlag Value that indicates whether to display target value to the bidder.
SourcingReqAttIpCategoryId Unique identifier for the category IP.
SourcingReqAttIpDescriptorId Unique identifier for the descriptor IP.
SourcingReqAttKnockoutScore Knockout score for the attribute.
SourcingReqAttLastAmendmentUpdate Amendment number for which the attribute was last modified.
SourcingReqAttLastUpdateDate Date and time of the last update of the requirement row.
SourcingReqAttLastUpdateLogin Session login associated to the user who last updated the requirement row.
SourcingReqAttLastUpdatedBy User who created the requirement row.
SourcingReqAttModifiedDate Stores the date the attribute was modified.
SourcingReqAttModifiedFlag Denotes whether the attribute has been modified in a new round or amendment.
SourcingReqAttNumberValue Number of the requirement attribute.
SourcingReqAttObjectVersionNumber Used to implement optimistic locking. The number is incremented every time that the row is updated.
SourcingReqAttProgramAppName Program application name of the requirement attribute.
SourcingReqAttProgramName Program name of the requirement attribute.
SourcingReqAttRequestId Unique identifier for the request number.
SourcingReqAttResponseType Response type of a requirement attribute.
SourcingReqAttScoringMethod Scoring method of a requirement attribute.
SourcingReqAttScoringType Indicates scoring type for the requirement attribute.
SourcingReqAttSectionName Section name or group description.
SourcingReqAttTextValue Text value of the requirement attribute.
SourcingReqAttWeight Weight of the requirement attribute.
SourcingRequirementSectionObjectVersionNumber Used to implement optimistic locking. The number is incremented every time that the row is updated.
SourcingRequirementSectionSectionId Unique identifier for the requirement section.
SourcingRequirementSectionTwoPartSectionType Classification of the section if the the section is created for a two part RFQ or two part attribute list.
StyleId Unique identifier for the negotiation style.
SupplierAuthoringAcceptance Indicates supplier acceptance level for agreement change.
SupplierHistoryDuration Indicates total duration for which the supplier has been there.
SystemConfiguredFlag Value that indicates whether the procurement business unit was created using procurement setup simplification.
TaxFromItemFlag Value that indicates default tax code from the inventory item.
TaxFromShipToLocFlag Value that indicates default tax code from ship to location.
TaxFromSystemFlag Value that indicates default tax code from Financial Options window.
TaxFromVendorFlag Value that indicates default tax code from the supplier.
TaxFromVendorSiteFlag Value that indicates default tax code from supplier site.
TaxHierItem Item position in the tax code defaulting hierarchy.
TaxHierShipToLoc Ship to location position in tax code defaulting hierarchy.
TaxHierSystem Financial options in the tax code defaulting hierarchy.
TaxHierVendor Supplier position in the tax code defaulting hierarchy.
TaxHierVendorSite Supplier Site position in the tax code defaulting hierarchy.
TaxableFlag Value that indicates whether the purchases are taxable.
TermsId Unique ID that indicates default Terms for the procurement business unit.
UseNeedByDate Option used to check the need-by date.
UseSalesOrderNumberFlag Value that indicates whether requisition lines should be grouped by sales order number to create distinct purchase order headers.
UseShipTo Option used to check ship to organization and location.
UserDefinedReceiptNumCode Indicates receipt numbering type.
UserDefinedReqNumCode Indicates requisition numbering type.