Views
Views are similar to tables in the way that data is represented; however, views are read-only.
Queries can be executed against a view as if it were a normal table.
CData JDBC Driver for Oracle Fusion Cloud Financials Views
| Name | Description |
| AssessmentsInSupplierPortal | Returns supplier qualification assessments and their outcomes as displayed to suppliers in the Oracle Supplier Portal. |
| AssessmentsInSupplierPortalQualifications | Returns the qualifications evaluated for suppliers as part of the assessments accessible in the Supplier Portal. |
| AwardedLinesRequisitioningBusinessUnitsLOV | Returns the list of requisitioning business unit values that can be selected for the awarded lines of a negotiation. |
| BidderSellerNegotiations | Returns procurement negotiations in which the current user participates as a bidder or seller. |
| BuyersLOV | Returns the list of buyer values, including procurement agents and their business unit assignments, that can be selected when creating procurement documents. |
| CatalogCategoryHierarchyNodes | Organizes catalog categories in a hierarchical structure, enabling guided navigation for items or services in procurement. |
| ComplianceChecklists | Stores procurement compliance checklist details, supporting evaluations or audits of supplier qualifications and practices. |
| ComplianceChecklistTemplates | Defines reusable templates for compliance checklists, allowing systematic creation of supplier qualification or audit processes. |
| ContentZones | Manages content zones that determine available catalogs, forms, and lists in Self Service Procurement, controlling visibility and security. |
| ContentZonescatalogAssignments | Specifies which local, punchout, or informational catalogs are linked to a given content zone, defining available shopping resources. |
| ContentZonespublicShoppingListAssignments | Assigns public shopping lists to a content zone, allowing employees to access common requisition items in Self Service Procurement. |
| ContentZonessecurityAssignments | Controls security access for content zones by requisitioning BU, worker, or deliver-to location, determining who can view specific content. |
| ContentZonessmartFormAssignments | Associates smart forms with a content zone, enabling tailored form-based requests for goods or services. |
| DraftPurchaseOrdersattachments | Manages files attached to draft purchase orders, such as specs or contractual clauses, before finalization. |
| DraftPurchaseOrdersDFF | Captures descriptive flexfields specific to draft purchase orders, accommodating custom procurement data. |
| DraftPurchaseOrdersglobalDFFs | Stores global descriptive flexfields for draft purchase orders, addressing regional or enterprise-wide attributes. |
| DraftPurchaseOrderslines | Details each line item (for example, item ID, quantity, unit price) within a draft purchase order prior to supplier communication. |
| DraftPurchaseOrderslinesattachments | Enables users to attach line-level documents (specifications, drawings) to a draft purchase order. |
| DraftPurchaseOrderslinesDFF | Holds descriptive flexfields for draft purchase order lines, capturing additional user-defined data points. |
| DraftPurchaseOrderslinesschedulesattachments | Stores files tied to draft purchase order schedules, such as shipping instructions or special handling documents. |
| DraftPurchaseOrderslinesschedulesDFF | Provides descriptive flexfields for schedules on a draft purchase order, supporting custom scheduling details. |
| DraftPurchaseOrderslinesschedulesdistributions | Allocates costs of a draft purchase order schedule to accounts or projects, preparing accurate financial coding. |
| DraftPurchaseOrderslinesschedulesglobalDFFs | Houses global descriptive flexfields on draft PO schedules, meeting organizational or geographic compliance needs. |
| DraftPurchaseOrdersspecialHandlingDFF | A data field that includes the special handling flexfields for purchase orders. |
| DraftPurchaseOrderssummaryAttributes | Summarizes high-level attributes of a draft purchase order, compiling data from all lines for review or analysis. |
| DraftSupplierNegotiationResponses | Tracks supplier draft responses to negotiations (RFI, RFQ, auctions) before final submission, allowing iterative updates. |
| DraftSupplierNegotiationResponsesattachments | Manages documents supporting a draft negotiation response (for example, quotes, clarifications) submitted by a supplier. |
| DraftSupplierNegotiationResponseslines | Captures line-level information in a supplier’s draft response, including price, quantity, and delivery terms. |
| DraftSupplierNegotiationResponseslinesattachments | Stores supporting documents for each line of a supplier’s draft response, such as technical specifications or proposals. |
| DraftSupplierNegotiationResponseslinescostFactors | Tracks additional cost details, such as freight and setup charges, in a supplier’s draft response to a negotiation line. |
| DraftSupplierNegotiationResponseslineslineAttributeGroups | Groups negotiation line attributes (for example, color, model, capacity) in a supplier’s draft response, supporting complex bid details. |
| DraftSupplierNegotiationResponseslineslineAttributeGroupslineAttributes | Lists the individual attributes of a negotiation line within a supplier’s draft response, providing granular specification data. |
| DraftSupplierNegotiationResponseslinespriceBreaks | Defines price variations based on location, volume, or date in a supplier’s draft negotiation response line. |
| DraftSupplierNegotiationResponseslinespriceTiers | Captures tiered pricing details for a supplier’s draft negotiation line, allowing discounted rates at higher order quantities. |
| DraftSupplierNegotiationResponsessections | Groups various sections (for example, commercial, technical) in a supplier's draft negotiation response, organizing requirements and replies. |
| DraftSupplierNegotiationResponsessectionsrequirements | Lists specific requirements or questions within each section, prompting suppliers to provide data or clarifications. |
| DraftSupplierNegotiationResponsessectionsrequirementsattachments | Stores supporting files linked to a draft requirement, such as technical documents or references from the supplier. |
| DraftSupplierNegotiationResponsessectionsrequirementsresponseValues | Holds the supplier's actual responses (text, numeric, date) for each requirement in a draft negotiation response. |
| ExternalDataProviderAndSupplierAttributeMappings | Returns the attribute mappings that link fields supplied by an external data provider to the corresponding supplier registration and profile attributes in the application. |
| ExternalDataProviderForSuppliers | Configuration that associates suppliers with their external data providers. |
| ExternalPurchasePricesBusinessUnitsrequisitioningBusinessUnits | A list of business units resource which manages the requisitioning business units mapped with a source organization. |
| ExternalPurchasePricesBuyers | Returns the buyers associated with external purchase price records. |
| Finders | Displays search finder names and corresponding attributes for a specific view, helping locate and filter procurement data. |
| FlexFndDffDescriptiveFlexfieldContexts | Retrieves descriptive flexfield contexts for extended data capture, customizing the procurement application's data structures. |
| FlexFndPvsCharacterIdCharacterValues | Exposes character-based values in a value set, letting users manage permissible entries for specific procurement fields. |
| PersonalShoppingLists | Stores user-specific shopping lists containing favorite or frequently purchased items for quick requisition creation. |
| PersonalShoppingListslines | Breaks down a personal shopping list into individual items or services, enabling faster selection during requisitioning. |
| ProcurementAgents | Maintains records of users designated as procurement agents (buyers, supplier managers), defining their responsibilities and privileges. |
| ProcurementApprovedSupplierListEntries | Tracks relationships between suppliers and the items or categories they’re approved to supply, ensuring compliance and vendor checks. |
| ProcurementApprovedSupplierListEntriesDFF | Holds descriptive flexfields tied to approved supplier list entries, allowing additional data capture or custom validations. |
| ProcurementCardsLOV | List of values for procurement cards available for use on purchasing documents. |
| ProcurementDocumentNumberings | Returns the document numbering configurations that define how procurement document numbers are generated, including prefixes, suffixes, and sequence values. |
| ProcurementPersonsLOV | Supports lookups of employees or individuals who can create or approve requisitions, ensuring authorized procurement actions. |
| PublicShoppingListLines | Represents items included in a publicly accessible shopping list, shared across multiple users or business units. |
| PublicShoppingLists | Defines public shopping list headers, grouping related items for streamlined requisition or bulk purchasing. |
| PunchoutConnections | Manages URL redirections for punchout catalogs, integrating external supplier catalogs into the procurement flow. |
| PurchaseAgreementAcknowledgments | Returns supplier acknowledgments submitted in response to purchase agreements. |
| PurchaseAgreementAcknowledgmentsLines | Returns the individual document lines and their acknowledgment responses for purchase agreements that require supplier acknowledgment. |
| PurchaseAgreementImportRequests | Facilitates bulk import of procurement documents (for example, blanket purchase agreements), verifying and loading them into the system. |
| PurchaseAgreementImportRequestsbusinessUnitAccess | Defines which requisitioning business units can leverage an imported purchase agreement, enabling multi-BU procurement sharing. |
| PurchaseAgreementImportRequestslines | Specifies goods or services from the imported agreement, listing line details without delivery schedules or discrete distributions. |
| PurchaseAgreementImportRequestslinesitemAttributes | Captures extended item data, like manufacturer part numbers or supplier URLs, during purchase agreement imports. |
| PurchaseAgreementImportRequestslinespriceBreaks | Handles bulk or location-based pricing discounts in imported agreements, detailing cost variations for different purchase conditions. |
| PurchaseAgreementImportRequestslinestranslationItemAttributes | Records translation-specific item attributes for multilingual or localized agreement data imports. |
| PurchaseAgreementLines | Describes goods or services in a purchase agreement, excluding delivery or fulfillment specifics, to outline negotiated items. |
| PurchaseAgreementLinesitemAttributes | Contains auxiliary item data in a purchase agreement (supplier part number, manufacturer info) to ensure accurate fulfillment. |
| PurchaseAgreementLinespriceBreaks | Displays volume-based or location-based price variations for each agreement line, providing cost details beyond the base unit price. |
| PurchaseAgreements | Holds purchase agreement headers (quantity- or value-based) with negotiated terms, used by subsequent POs or contracts. |
| PurchaseAgreementsbusinessUnitAccess | Specifies which business units can use a purchase agreement, enabling enterprise-wide or localized access to negotiated terms. |
| PurchaseAgreementslines | Defines the line items (goods/services) under a purchase agreement, detailing negotiated prices and quantities. |
| PurchaseAgreementslinesitemAttributes | Carries supplemental item information on a purchase agreement line, such as manufacturer details or supplier item reference. |
| PurchaseAgreementslinespriceBreaks | Captures location- or quantity-based price adjustments for agreement lines, ensuring appropriate pricing for each scenario. |
| PurchaseAgreementsnotificationControls | Configures alerts (for example, expiration, usage threshold) for purchase agreements, notifying stakeholders of key milestones. |
| PurchaseOrderAcknowledgments | Returns the acknowledgment responses that suppliers submit for purchase orders, indicating whether each order is accepted or rejected. |
| PurchaseOrderAcknowledgmentsSchedules | Returns the schedule-level acknowledgments submitted by suppliers in response to purchase orders. |
| PurchaseOrderLifeCycleDetails | Displays the full life cycle of a purchase order, showing how requisitions progress through ordering, shipment, receiving, invoicing, and payment to support procure-to-pay tracking. |
| PurchaseOrderLifeCycleDetailsinvoices | Displays details about supplier invoices that are created against purchase orders, such as matched quantities and amounts and total invoice amounts. |
| PurchaseOrderLifeCycleDetailsreceipts | Displays details about receipts and deliveries that are created against purchase orders, such as how many items have been received and when they were received. |
| PurchaseOrderLifeCycleDetailsschedules | Displays details about the purchase order schedule, such as how many items were requested and ordered, as well information regarding how many of those items were shipped, received, and invoiced. |
| PurchaseOrderLifeCycleDetailsshipments | Displays the details about shipments that are created against purchase orders, such as how many items have been shipped, when they were shipped, and the carrier and tracking numbers for those shipments. |
| PurchaseOrders | Represents finalized purchase orders for goods or services from external suppliers, capturing key terms and statuses. |
| PurchaseOrdersattachments | Stores documents (for example, contracts, specifications) linked to a purchase order, enhancing detail for audits or approvals. |
| PurchaseOrderSchedules | Manages delivery schedules within a purchase order, tracking ship-to locations, dates, and associated quantities. |
| PurchaseOrdersDFF | Captures additional descriptive flexfield data at the purchase order header level, allowing custom fields. |
| PurchaseOrdersglobalDFFs | Houses global descriptive flexfields used across purchase orders to accommodate standardized international or enterprise data. |
| PurchaseOrderslines | Lists line-level details within a purchase order, specifying items, quantities, unit prices, and related buying terms. |
| PurchaseOrderslinesattachments | Contains attached documents for individual purchase order lines, such as technical specs or regulatory certifications. |
| PurchaseOrderslinesDFF | Offers descriptive flexfields for purchase order lines, capturing extra information beyond the standard line fields. |
| PurchaseOrderslinesschedules | Defines the planned shipment dates and delivery details for each line item in a purchase order. |
| PurchaseOrderslinesschedulesattachments | Manages attachments for purchase order schedules, such as shipping instructions or agreement references. |
| PurchaseOrderslinesschedulesDFF | Enables descriptive flexfields at the schedule level, supporting specialized shipping or delivery requirements. |
| PurchaseOrderslinesschedulesdistributions | Allocates purchase order schedule costs to particular accounts or projects, ensuring accurate financial tracking. |
| PurchaseOrderslinesschedulesglobalDFFs | Holds global descriptive flexfields for purchase order schedules, enabling consistent enterprise or region-level data. |
| PurchaseOrdersLOV | Provides a quick search interface for existing purchase orders, aiding users in referencing or reusing prior orders. |
| PurchaseRequisitionsattachments | Maintains documents attached to purchase requisitions, such as quotes, justifications, or requirement definitions. |
| PurchaseRequisitionsDFF | Stores descriptive flexfields at the requisition header level, enabling custom data elements beyond standard fields. |
| PurchaseRequisitionslinesattachments | Attaches supporting files to requisition lines, such as product specs or vendor quotes, ensuring clear documentation. |
| PurchaseRequisitionslinesDFF | Provides descriptive flexfields for requisition lines, capturing unique data like internal codes or cost justification details. |
| PurchaseRequisitionslinesdistributions | Splits the requisition line cost across multiple accounts or projects, aiding correct budget and financial reporting. |
| PurchaseRequisitionslinesdistributionsDFF | Enables descriptive flexfields for requisition line distributions, adding specialized data for cost allocations. |
| PurchaseRequisitionslinesdistributionsprojectDFF | Captures project-specific descriptive flexfields for requisition line distributions, linking costs to project tasks or milestones. |
| PurchaseRequisitionslinesinformationTemplates | Associates custom information templates (for example, extra fields or questionnaires) with requisition lines for specialized scenarios. |
| PurchaseRequisitionslinesinformationTemplatesinformationTemplateDFF | Stores descriptive flexfields related to an information template, accommodating extra user-defined attributes for a requisition line. |
| PurchaseRequisitionslinesspecialHandlingDFF | Manages special handling flexfields for unique shipping or handling requirements at the requisition line level. |
| PurchaseRequisitionsspecialHandlingDFF | Enables descriptive flexfields for special handling instructions at the requisition header, ensuring compliance or safety measures. |
| PurchaseRequisitionssummaryAttributes | Aggregates summary-level data on a requisition, consolidating details from all lines for higher-level review or analysis. |
| PurchasingChangeOrderTemplates | Returns the change order templates that define how changes to purchasing documents are processed. |
| PurchasingChangeOrderTemplatesAttributes | Returns the attribute entries defined for purchasing change order templates, which control how change orders are applied to purchasing documents. |
| PurchasingDocumentImportErrors | Lists errors encountered during bulk imports of purchasing documents, such as invalid data or missing references. |
| PurchasingDocumentStyles | Purchasing document styles that control the appearance and behavior of purchasing documents. |
| PurchasingDocumentStylesLineTypes | Returns the line types associated with each purchasing document style, indicating which line types are enabled for use with that style. |
| PurchasingDocumentStylesLOV | Returns the list of purchasing document style values that can be selected to control the appearance and behavior of purchasing documents. |
| PurchasingHazardClasses | Returns the hazard classes used to identify hazardous materials referenced on purchasing documents. |
| PurchasingHazardClassesLOV | Returns the list of purchasing hazard class values that can be used to classify hazardous materials on purchasing documents. |
| PurchasingLineTypes | Returns the purchasing line types that classify how goods and services are ordered, along with their default matching, categorization, and unit of measure settings. |
| PurchasingLineTypesDFF | Returns the descriptive flexfield attributes associated with purchasing line types. |
| PurchasingLineTypesLOV | Lists purchasing line types with which purchasing documents can be created. Line type is an important part of purchasing documents as it enables differentiating orders for goods from those of services. |
| PurchasingNews | Publishes announcements or updates for procurement teams, covering new policies, system changes, or supplier updates. |
| PurchasingUNNumbers | Returns the United Nations hazardous material numbers used to identify dangerous goods on purchasing documents. |
| PurchasingUNNumbersLOV | Returns the list of United Nations number values that can be used to identify hazardous materials on purchasing documents. |
| QualificationsInSupplierPortal | Returns supplier qualifications as displayed to suppliers in the Oracle Supplier Portal. |
| QualificationsInSupplierPortalResponses | Returns the question responses recorded for supplier qualifications accessible in the Supplier Portal. |
| QualificationsInSupplierPortalResponsesBusinessClassifications | Returns the business classifications and certifications reported in supplier qualification responses accessible in the Supplier Portal. |
| QualificationsInSupplierPortalResponsesBusinessClassificationsBusinessClassificationAttachments | Returns the document attachments associated with business classifications reported in supplier qualification responses accessible in the Supplier Portal. |
| QualificationsInSupplierPortalResponsesQuestionAttachments | Returns the attachments added to individual questions within qualification responses that suppliers submit through the supplier portal. |
| QualificationsInSupplierPortalResponsesValues | Returns the individual response values entered for supplier qualification questions displayed in the Oracle Supplier Portal. |
| QualificationsInSupplierPortalResponsesValuesResponseAttachments | Returns the attachments added to response values within qualification responses that suppliers submit through the supplier portal. |
| QuestionnaireResponses | Manages supplier or compliance questionnaire responses, collecting details for audits, qualifications, and due diligence. |
| QuestionnaireResponsesquestionnaireAttachments | Stores attachments linked to questionnaire responses (for example, supporting documents, references), providing additional context for responses. |
| QuestionnaireResponsesquestionnaireResponseSections | Organizes questionnaires into sections, each containing related questions or topics for supplier or compliance evaluations. |
| QuestionnaireResponsesquestionnaireResponseSectionsquestionnaireResponseDetails | Captures individual answers or notes for each question in a questionnaire section, reflecting the respondent’s input. |
| QuestionnaireResponsesquestionnaireResponseSectionsquestionnaireResponseDetailsquestionAttachments | Manages files attached to specific question responses, such as certificates or documentation supporting the respondent’s claims. |
| QuestionnaireResponsesquestionnaireResponseSectionsquestionnaireResponseDetailsquestionnaireResponseValues | Holds the actual data points (for example, text, dates, numeric values) provided in response to each question, enabling detailed analysis. |
| QuestionResponsesInSupplierPortal | Returns the responses that suppliers submit to qualification questions through the supplier portal. |
| QuestionResponsesInSupplierPortalBusinessClassifications | Returns the business classification details provided in question responses displayed to suppliers in the Oracle Supplier Portal. |
| QuestionResponsesInSupplierPortalBusinessClassificationsAttachments | Returns the attachments associated with business classification question responses displayed in the Oracle Supplier Portal. |
| QuestionResponsesInSupplierPortalValues | Returns the individual response values captured for supplier questionnaire question responses accessible in the Supplier Portal. |
| QuestionResponsesInSupplierPortalValuesAttachments | Returns the document attachments associated with question response values for supplier questionnaire responses accessible in the Supplier Portal. |
| RecentRequisitions | Lists the most recently created or submitted requisitions for a given user, speeding up reorders or reference checks. |
| RequisitionOneTimeLocations | Maintains ad-hoc delivery addresses (for example, temporary job sites) for requisitions, capturing non-standard ship-to details. |
| RequisitionPreferences | Stores user-defined requisition defaults—like favorite charge accounts, default delivery locations, or preference settings. |
| RequisitionPreferencesfavoriteChargeAccounts | Tracks a user’s most commonly used charge accounts, simplifying account selection during requisition line allocation. |
| RequisitionPreferencesprojectDFF | Enables descriptive flexfields for project costing within a user’s requisition preferences, linking requisition data to project tasks. |
| RequisitionPreferencespurchasingNews | Surfaces relevant procurement announcements or updates within a user’s requisitioning context (for example, changes in policy). |
| RequisitionPreferencesrequisitioningOptions | Reflects configured requisitioning BU features, profile options, and active functional opt-ins that shape the user’s requisition interface. |
| RequisitionProcessingRequests | Handles the conversion of approved requisition lines into purchase documents (for example, purchase orders), orchestrating the procurement flow. |
| RequisitionProcessingRequestslines | Specifies which approved requisition lines are to be processed into new or existing purchasing documents. |
| RequisitionProductDetails | Retrieves extended information about a requisition item, including its description, category, and associated services or configurations. |
| RequisitionProductDetailspriceBreaks | Displays tiered or location-based price variations for an item in a requisition, guiding cost-effective purchasing decisions. |
| SellerNegotiationBids | Returns the bids that sellers submit in response to procurement negotiations. |
| SellerNegotiationBidsLines | Returns the line-level entries of the bids that sellers submit in procurement negotiations. |
| SellerNegotiations | Returns procurement negotiations from the perspective of the participating seller. |
| SellerNegotiationsAttachments | Returns the attachments associated with seller negotiations. |
| SellerNegotiationsBidders | Returns the bidders invited to or participating in each seller negotiation. |
| SellerNegotiationsLines | Returns the negotiation lines that are visible to sellers participating in procurement negotiations. |
| SellerNegotiationsLinesAttachments | Returns the document attachments associated with individual lines of seller negotiations. |
| SellerNegotiationsPublishNegotiationErrors | Returns the errors raised when a seller negotiation is published. |
| ShoppingCatalogInformationTemplates | The Shopping Catalog Information Templates resource manages the information templates associated with a category or an item used to create a requisition line. |
| ShoppingCatalogItemDetails | The Shopping Catalog Item Details resource gets the product details of any item, which helps the requester to check the details before procuring the item. |
| ShoppingCatalogItemDetailsagreementLineItemDFF | A flexible data field for Agreement Line Item resources that provides details about the descriptive flexfields associated with an agreement line item. |
| ShoppingCatalogItemDetailsagreementLinePriceBreaks | Agreement price breaks are reductions in the price of an item based on certain conditions, such as purchasing in bulk or ordering from a specific location. |
| ShoppingCatalogItemDetailsbuyingOptions | The Buying Options resource gets the different buying options when an item is referenced by multiple agreements. |
| ShoppingCatalogItemDetailsitemGTINRelationships | The Item GTIN Relationships resource gets the global trade item number (GTIN) details for the master item. |
| ShoppingCatalogItemDetailsitemImages | The Item Images resource gets the images for the master item. |
| ShoppingCatalogItemDetailsitemManufacturers | The Item Manufacturers resource gets the manufacturer details for the master item. |
| ShoppingCatalogItemDetailsitemRevisions | A revision represents a particular version of an item. |
| ShoppingCatalogItemDetailsitemSuppliers | The Item Suppliers resource gets the supplier details for the master item. |
| ShoppingCatalogSmartFormDetails | Represents the smart form configuration for procuring items or services, capturing fields and validation logic for shopper input. |
| ShoppingCatalogSmartFormDetailsagreementRequisitionBUAssignments | Indicates which requisitioning business units are assigned to an agreement specified in a smart form, defining usage scope. |
| ShoppingCatalogSmartFormDetailsattachments | Holds references to files attached to a smart form, such as instructions or supplementary materials for the shopper. |
| ShoppingCatalogSmartFormDetailsinformationTemplateAssignments | Associates information templates (additional fields or questionnaires) with a smart form, ensuring comprehensive data collection. |
| ShoppingLists | Aggregates both personal and public shopping list headers to quickly locate items for requisition creation. |
| ShoppingSearches | Enables keyword or attribute-based item searches within procurement catalogs, streamlining the user’s shopping experience. |
| ShoppingSearchesbrandFilters | Applies brand-specific filters to search results, helping users refine item listings by preferred or authorized brands. |
| ShoppingSearchesresultItems | Holds detailed data for items returned in a shopping search, including item ID, pricing, and availability. |
| ShoppingSearchesresultPunchoutCatalogs | Lists punchout catalog links included in search results, letting users directly access supplier-hosted catalogs. |
| SpendClassificationDatasetDefinitions | Returns the dataset definitions used to configure spend classification for procurement spend analysis. |
| SpendClassificationDataSetTransactions | The Spend Classification Data Set Transactions resource manages data set transactions in Oracle Fusion Cloud Spend Classification. |
| SpendClassificationSeededDataSets | Returns the predefined seeded data sets used by spend classification to categorize procurement spend. |
| SpendClassificationSummaryByCategories | The Spend Classification Summary by Categories resource aggregates the transaction amounts for transactions in a data set organized by category. |
| SpendClassificationSummaryFromSources | The Spend Classification Summary From Sources resource aggregates the transaction amounts for source transactions in a data set organized by categories. |
| StandardLookupsLOV | Queries the list of valid codes and meanings for standard lookups, ensuring consistent use of reference data. |
| SupplierContentMapSetsLOV | Returns the list of supplier content map set values that can be used when mapping external supplier content to catalog categories. |
| SupplierEligibilities | Designates whether a supplier is allowed to participate in sourcing events, capturing approval statuses or disqualifications. |
| SupplierEntityConfigurations | Returns the entity configuration settings that control how supplier data is captured and managed in the application. |
| SupplierInitiatives | Tracks the creation and status of supplier initiatives, which manage supplier assessments or qualification projects. |
| SupplierInitiativesattachments | Manages files related to a supplier initiative, such as supporting documents or evidence of compliance. |
| SupplierInitiativesDFF | Provides descriptive flexfields for supplier initiatives, capturing additional contextual or compliance-related data. |
| SupplierInitiativesevaluationTeamMembers | Lists members of the evaluation team assigned to a supplier initiative, detailing their roles and responsibilities in the review process. |
| SupplierInitiativesqualificationAreas | Identifies the qualification areas within an initiative, specifying the criteria against which suppliers are assessed. |
| SupplierInitiativessuppliers | Tracks the suppliers participating in an initiative, providing status updates and scoring information for qualification or selection. |
| SupplierNegotiationAttributeLists | Returns the attribute lists defined for supplier negotiations, which group the attributes evaluated during a negotiation. |
| SupplierNegotiationContracts | Returns the contract terms and documents associated with supplier negotiations. |
| SupplierNegotiationContractsSupplierContracts | Returns the supplier contracts associated with supplier negotiation contracts. |
| SupplierNegotiationCostFactorListsLOV | Returns the list of cost factor lists that can be applied to lines when creating supplier negotiations. |
| SupplierNegotiationCostFactorListsLOVCostFactors | Returns the cost factors belonging to supplier negotiation cost factor lists that can be selected when defining negotiation pricing. |
| SupplierNegotiationPurchasingDocuments | Returns the purchasing documents that are generated from or associated with supplier negotiations. |
| SupplierNegotiationPurchasingDocumentsLineAllocationsDetails | Returns the requisition line allocation details for lines awarded in supplier negotiation purchasing documents, including requisition quantities and award allocation status. |
| SupplierNegotiationPurchasingDocumentsLineAllocationsSummary | Returns a summary of the line allocations for purchasing documents associated with supplier negotiations. |
| SupplierNegotiationPurchasingDocumentsLineAllocationsSummaryAwardedLineResponses | Returns the awarded line responses summarized by line allocation for supplier negotiation purchasing documents. |
| SupplierNegotiationPurchasingDocumentsLineAllocationsSummaryLineAllocationsByResponse | Returns the line allocation amounts for supplier negotiation purchasing documents broken down by supplier response. |
| SupplierNegotiationPurchasingDocumentsPurchasingDocuments | Returns the purchasing documents associated with supplier negotiations. |
| SupplierNegotiationPurchasingDocumentsPurchasingDocumentsAgreementBusinessUnitAccesses | Returns the business unit access assignments for purchasing documents associated with supplier negotiations. |
| SupplierNegotiationPurchasingDocumentsPurchasingDocumentsAwardedLines | Returns the awarded negotiation lines included in the purchasing documents created from supplier negotiations. |
| SupplierNegotiationResponses | Retrieves supplier-submitted responses to sourcing negotiations (for example, RFI, RFQ), offering visibility into proposed terms and pricing. |
| SupplierNegotiationResponsesattachments | Manages files (for example, statements of work, supporting documents) attached to negotiation responses, ensuring comprehensive bid details. |
| SupplierNegotiationResponseslines | Displays line-level details, such as pricing or lead times, in a supplier’s negotiation response for each item or service. |
| SupplierNegotiationResponseslinesattachments | Holds documents specifically tied to each negotiation response line, such as product specifications or compliance certificates. |
| SupplierNegotiationResponseslinescostFactors | Captures additional line-level cost factors (shipping, setup fees) entered by suppliers, contributing to the final bid amount. |
| SupplierNegotiationResponseslineslineAttributeGroups | Groups relevant attributes (color, dimensions, performance) for a negotiation line in the supplier’s response. |
| SupplierNegotiationResponseslineslineAttributeGroupslineAttributes | Lists each attribute within an attribute group for a negotiation line, enabling detailed supplier-submitted specifications. |
| SupplierNegotiationResponseslinespriceBreaks | Defines tiered or location-based discounts proposed by suppliers, applied to negotiated line pricing. |
| SupplierNegotiationResponseslinespriceTiers | Specifies quantity-based price tiers in a supplier’s response, outlining price changes above certain order thresholds. |
| SupplierNegotiationResponsessections | Structures supplier negotiation requirements into sections (for example, technical, legal), allowing organized input and review. |
| SupplierNegotiationResponsessectionsrequirements | Lists requirement questions or prompts within each negotiation section, requesting supplier input on capabilities or compliance. |
| SupplierNegotiationResponsessectionsrequirementsattachments | Holds supporting files (drawings, certificates) attached to specific negotiation requirements, clarifying supplier responses. |
| SupplierNegotiationResponsessectionsrequirementsresponseValues | Records the supplier's answers or data points for each requirement, supporting thorough analysis of submitted proposals. |
| SupplierNegotiations | Oversees key negotiation details (for example, objectives, timelines, participants) for supplier sourcing events or auctions. |
| SupplierNegotiationsabstracts | Maintains summary or abstract information for the negotiation, providing a concise overview of the event. |
| SupplierNegotiationsabstractsDFF | Houses descriptive flexfields for negotiation abstracts, allowing custom data points at the summary level. |
| SupplierNegotiationsattachments | Holds reference documents (terms, supporting files) at the negotiation header, enriching the negotiation record. |
| SupplierNegotiationscollaborationTeamMembers | Identifies internal team members collaborating on the negotiation, specifying roles (for example, evaluator, observer). |
| SupplierNegotiationsDFF | Employs internal descriptive flexfields at the negotiation header level, adding fields for specialized data capture. |
| SupplierNegotiationslines | Details products and services being sourced in the negotiation, including specifications, baseline pricing, or quantity. |
| SupplierNegotiationslinesattachments | Manages line-level attachments (drawings, product sheets) for negotiation lines, ensuring clarity in requested goods or services. |
| SupplierNegotiationslinescostFactors | Tracks cost factors (transport, warranty, extras) at the negotiation line level, influencing total evaluated cost. |
| SupplierNegotiationslinesDFF | Uses descriptive flexfields for negotiation lines, capturing additional data beyond standard fields. |
| SupplierNegotiationslineslineAttributeGroups | Defines attribute groups for negotiation lines, grouping characteristic sets for more complex products or services. |
| SupplierNegotiationslineslineAttributeGroupslineAttributes | Lists each distinct attribute within a line attribute group, giving evaluators granular insight into supplier bids. |
| SupplierNegotiationslinesnegotiationLineRecommendedSuppliers | Identifies recommended suppliers for a specific negotiation line, guiding targeted invitations or shortlisting. |
| SupplierNegotiationslinespriceBreaks | Stores line-level price break data (volume discounts, date-based pricing) to refine cost evaluations. |
| SupplierNegotiationslinespriceTiers | Holds quantity-based pricing tiers for negotiation lines, capturing cost variations that apply once certain purchase thresholds are reached. |
| SupplierNegotiationsnegotiationActivities | Lists the sourcing activities (for example, approvals, messages, updates) performed within a negotiation’s lifecycle. |
| SupplierNegotiationsnegotiationRecommendedSuppliers | Marks suppliers that are preselected or recommended for a negotiation, streamlining invitations and bid evaluations. |
| SupplierNegotiationsresponseCurrencies | Specifies the currencies accepted for negotiation responses, along with exchange rates to normalize bids against the negotiation currency. |
| SupplierNegotiationsscoringTeams | Defines teams responsible for evaluating or scoring suppliers’ bids, including their assigned negotiation roles. |
| SupplierNegotiationsscoringTeamsscoringTeamMembers | Lists individual members in each scoring team, capturing their roles and responsibilities in the bid evaluation process. |
| SupplierNegotiationssections | Breaks down a negotiation into logical sections (for example, commercial requirements, technical specs, contractual terms). |
| SupplierNegotiationssectionsrequirements | Enables creation of structured negotiation requirements or questions, requesting detailed information from bidding suppliers. |
| SupplierNegotiationssectionsrequirementsacceptableResponseScoreValues | Lists scoring rules or acceptable answers for each requirement, helping evaluators rate supplier responses consistently. |
| SupplierNegotiationssectionsrequirementsattachments | Stores supplementary files associated with specific negotiation requirements, such as reference documents or images. |
| SupplierNegotiationssupplierDFF | Houses descriptive flexfields at the negotiation header for supplier-specific data, capturing additional attributes not in standard fields. |
| SupplierNegotiationssuppliers | Shows suppliers invited or participating in the negotiation, logging their bids, statuses, and communication history. |
| SupplierNegotiationssupplierssupplierLineAccessRestrictions | Implements line-level access restrictions, ensuring certain suppliers only see or bid on designated negotiation lines. |
| SupplierNegotiationsthreads | Details about the series of messages that are grouped by a subject in a negotiation. |
| SupplierNegotiationsthreadsmessages | Details about the content of the conversation in a negotiation. |
| SupplierNegotiationsthreadsmessagesattachments | The Attachments resource manages details about attachments for supplier negotiation. |
| SupplierNegotiationsthreadsmessagesrecipients | Details about members that receive messages in a negotiation. |
| SupplierOptions | Supplier-related configuration options for the procurement application. |
| SupplierQualificationAreas | Manages qualification areas, like compliance or financial stability, for assessing supplier eligibility and performance. |
| SupplierQualificationAreasattachments | Stores attachments for qualification areas, such as policy files or reference documents supporting the qualification criteria. |
| SupplierQualificationAreasbusinessUnits | Connects qualification areas to specific business units, indicating which organizational segments require those assessments. |
| SupplierQualificationAreasoutcomes | Defines possible results (for example, pass, fail, conditional) for a qualification area, aiding standardized supplier evaluations. |
| SupplierQualificationAreasquestions | Lists questions for a given qualification area, capturing the required data to assess supplier compliance or capability. |
| SupplierQualificationQuestionResponses | Collects the actual answers suppliers provide to qualification questions, forming a record for subsequent review. |
| SupplierQualificationQuestionResponsesvalues | Captures detailed data points (for example, numeric values, text inputs) for each question response, enabling in-depth analysis. |
| SupplierQualificationQuestionResponsesvaluesattachments | Associates supporting documents or certificates with question responses, demonstrating supplier qualifications or compliance. |
| SupplierQualificationQuestions | Defines the questions used in supplier qualification, covering areas like safety standards or financial viability. |
| SupplierQualificationQuestionsacceptableResponses | Lists potential valid answers or response choices for a qualification question, ensuring standardized input options. |
| SupplierQualificationQuestionsacceptableResponsesbranches | Indicates subsequent branching logic for a given response, posing follow-up questions based on the initial answer. |
| SupplierQualificationQuestionsattachments | Holds documents (images, policy PDFs) linked to a question, giving respondents extra context or references. |
| SupplierQualificationQuestionsscores | Applies scoring rules (for example, numeric weighting) to question responses, letting evaluators quantify supplier qualification results. |
| SupplierQualifications | Returns the qualifications defined for suppliers, including their status and evaluation details. |
| SupplierQualificationsAttachments | Returns the attachments associated with supplier qualifications. |
| SupplierQualificationsDFF | Returns the descriptive flexfield attributes associated with supplier qualifications. |
| SupplierQualificationsResponses | Returns the supplier responses submitted for qualification initiatives. |
| SupplierQualificationsResponsesBusinessClassifications | Returns the business classification details provided in supplier qualification responses. |
| SupplierQualificationsResponsesBusinessClassificationsBusinessClassificationAttachments | Returns the attachments associated with business classifications provided in supplier qualification responses. |
| SupplierQualificationsResponsesQuestionAttachments | Returns the document attachments associated with question responses recorded for supplier qualifications. |
| SupplierQualificationsResponsesValues | Returns the response values captured for supplier qualification questions. |
| SupplierQualificationsResponsesValuesResponseAttachments | Returns the document attachments associated with individual response values recorded for supplier qualification responses. |
| SupplierRegistrationAddressGeographies | Returns the geography values available for entering addresses during supplier registration. |
| SupplierRegistrationAddressStyleFormats | Address style formats used during supplier registration. |
| SupplierRegistrationAddressStyleFormatsAddressStyleFormatLayout | Returns the field-by-field layout of each supplier registration address style format, describing how address attributes are positioned and formatted. |
| SupplierRegistrationBankBranchesLOV | Returns the list of bank branch values that can be selected when entering banking details during supplier registration. |
| SupplierRegistrationBanksLOV | Returns the list of banks that can be selected when registering supplier bank account details. |
| SupplierRegistrationCertifyingAgenciesLOV | Returns the list of certifying agencies that can be selected when recording supplier business classification certifications during registration. |
| SupplierRegistrationConfigurations | Returns the configuration settings that control how the supplier registration process behaves. |
| SupplierRegistrationOptions | Returns the configuration options that govern how the supplier registration process behaves. |
| SupplierRegistrationPhoneCountryCodes | Returns the phone country codes that can be selected when suppliers provide phone numbers during registration. |
| SupplierRegistrationProductsAndServicesLOV | Returns the list of products and services category values that suppliers can select during registration. |
| SupplierRegistrationProductsAndServicesLOVChildCategories | Returns the child product and service category values that can be selected when classifying products and services during supplier registration. |
| SupplierRegistrationQuestionnaireResponses | Returns the questionnaire responses submitted by suppliers during supplier registration. |
| SupplierRegistrationQuestionnaireResponsesQuestionnaireAttachments | Returns the attachments added to questionnaire responses that suppliers submit during registration. |
| SupplierRegistrationQuestionnaireResponsesQuestionnaireResponseSections | Returns the sections that make up each supplier registration questionnaire response, including their display order and completion status. |
| SupplierRegistrationQuestionnaireResponsesQuestionnaireResponseSectionsQuestionnaireResponses | Returns the nested question responses captured within questionnaire response sections during supplier registration. |
| SupplierRegistrationQuestionnaireResponsesQuestionnaireResponseSectionsQuestionnaireResponsesQuestionAttachments | Returns the attachments associated with question responses within supplier registration questionnaire sections. |
| SupplierRegistrationQuestionnaireResponsesQuestionnaireResponseSectionsQuestionnaireResponsesQuestionnaireResponseValues | Returns the individual answer values captured for each question within the sections of a supplier registration questionnaire response. |
| SupplierRegistrationRolesLOV | Returns the list of contact roles that can be assigned to supplier contacts during supplier registration. |
| SuppliersaddressesDFF | Holds custom descriptive flexfields for supplier address records, enabling extended data capture as needed. |
| Suppliersattachments | Provides attachment capabilities for supplier records (for example, contracts, certifications), enhancing reference documentation. |
| SuppliersbusinessClassifications | Specifies recognized business types or certifications (for example, minority-owned) for a supplier, meeting regulatory or diversity goals. |
| SuppliersbusinessClassificationsattachments | Associates proof documents (certificates, letters) with the supplier’s business classification, validating their status. |
| Supplierscontactsaddresses | Links specific addresses to a supplier contact (for example, branch office, headquarters), clarifying shipping or invoice routes. |
| SupplierscontactsDFF | Provides descriptive flexfields for supplier contact details, enabling custom fields beyond standard attributes. |
| SuppliersDFF | Contains descriptive flexfields for supplier data at the header, storing extra organizational or region-specific information. |
| SuppliersglobalDFF | Holds global descriptive flexfields for supplier records, allowing consistent multi-national data capture. |
| SuppliersproductsAndServices | Specifies the goods or services a supplier offers, mapped to relevant categories in the procurement system. |
| Supplierssites | Records supplier site details (for example, operational addresses, payment methods), facilitating transaction-level usage. |
| Supplierssitesassignments | Determines how supplier sites are assigned to internal business units or ledger sets, managing usage boundaries. |
| Supplierssitesattachments | Tracks documents tied to a supplier site, such as compliance documents or service-level agreements. |
| SupplierssitesDFF | Enables custom descriptive flexfields at the supplier site level, supporting additional operational or region-specific data. |
| SupplierssitesglobalDFF | Stores global descriptive flexfields for supplier sites, accommodating enterprise-wide requirements for site metadata. |
| SupplierssitesthirdPartyPaymentRelationships | Manages third-party payment setups (for example, factoring relationships) for supplier sites, ensuring correct pay-to instructions. |
| ValueSets | Stores definitions for standardized lookups or data validation sets, ensuring consistent entries across the procurement module. |
| ValueSetsvalidationTable | Indicates the base table used for validation, defining the permissible values for procurement data fields. |
| ValueSetsValues | Enumerates allowed values in a value set (codes, translations), ensuring data consistency in user inputs. |
| WorkConfirmations | Handles confirmations of completed work for complex service or construction purchase orders, aiding accurate billing and progress tracking. |
| WorkConfirmationsattachments | Associates files (for example, progress photos, sign-off sheets) with a work confirmation, substantiating the claimed progress or deliverables. |
| WorkConfirmationsdocumentActions | Reflects the actions (approve, reject, revise) taken on a work confirmation document, ensuring an audit trail of changes. |
| WorkConfirmationslines | Details line-level entries for a work confirmation, tracking the portions of work completed or amounts to be billed. |