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