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 ADO.NET Provider for Oracle Fusion Cloud Financials Views
| Name | Description |
| 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. |
| 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. |
| 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. |
| 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. |
| 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. |
| 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. |
| PurchasingDocumentImportErrors | Lists errors encountered during bulk imports of purchasing documents, such as invalid data or missing references. |
| PurchasingNews | Publishes announcements or updates for procurement teams, covering new policies, system changes, or supplier updates. |
| 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. |
| 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. |
| 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. |
| StandardLookupsLOV | Queries the list of valid codes and meanings for standard lookups, ensuring consistent use of reference data. |
| SupplierEligibilities | Designates whether a supplier is allowed to participate in sourcing events, capturing approval statuses or disqualifications. |
| 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. |
| 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. |
| 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. |
| SupplierRegistrationAddressGeographies | Tracks geographic data (country, region) for supplier addresses, enforcing location-based validations during registration. |
| SupplierRegistrationAddressStyleFormats | Defines distinct layouts for addresses in various countries, aligning supplier registration with local postal standards. |
| SupplierRegistrationAddressStyleFormatsAddressStyleFormatLayout | Describes how address components (street, city, postal code) are placed in a given address format layout. |
| SupplierRegistrationBankBranchesLOV | Presents valid bank branch lookups for supplier bank account setup, ensuring precise banking details in registrations. |
| SupplierRegistrationBanksLOV | Lists recognized banks usable in supplier registration flows, allowing accurate banking information and payment routing. |
| SupplierRegistrationCertifyingAgenciesLOV | Lists agencies authorized to certify supplier business classifications (for example, small business, minority-owned), ensuring accurate accreditation data. |
| SupplierRegistrationConfigurations | Enables retrieval of prospective and spend-authorized registration configurations, controlling mandatory fields and setup details for supplier signups. |
| SupplierRegistrationOptions | Defines supplier registration flow options (for example, attachments required, tax ID fields), shaping the onboarding experience and required data. |
| SupplierRegistrationPhoneCountryCodes | Enumerates valid country dialing codes for supplier phone numbers, aligning registration data with international standards. |
| SupplierRegistrationProductsAndServicesLOV | Retrieves categories (for example, office supplies, IT services) used to classify supplier offerings during registration. |
| SupplierRegistrationProductsAndServicesLOVchildCategories | Tracks subcategories under primary product and service classifications, enabling multi-level supplier categorization. |
| SupplierRegistrationQuestionnaireResponses | Handles supplier-provided answers to registration questionnaires, capturing additional information like financial details or compliance data. |
| SupplierRegistrationQuestionnaireResponsesquestionnaireAttachments | Facilitates attachments (for example, supporting documents) to questionnaire responses, adding evidence or documentation during supplier onboarding. |
| SupplierRegistrationQuestionnaireResponsesquestionnaireResponseSections | Organizes questionnaire content into logical sections, grouping related questions for clarity and streamlined completion. |
| SupplierRegistrationQuestionnaireResponsesquestionnaireResponseSectionsquestionnaireResponses | Stores the supplier’s answers to each question in a section, capturing all responses for thorough review. |
| SupplierRegistrationQuestionnaireResponsesquestionnaireResponseSectionsquestionnaireResponsesquestionAttachments | Maintains files attached to specific questions in a supplier’s registration questionnaire, supporting claims or validations. |
| SupplierRegistrationQuestionnaireResponsesquestionnaireResponseSectionsquestionnaireResponsesquestionnaireResponseValues | Details the actual data inputs (for example, numeric, text) for each question, enabling precise analysis of supplier registration responses. |
| SupplierRegistrationRequests | Controls supplier registration requests, whether prospective or spend-authorized, storing essential onboarding data and statuses. |
| SupplierRegistrationRequestsaddresses | Manages address information tied to a supplier registration request, capturing physical location details for the supplier. |
| SupplierRegistrationRequestsaddressesaddressContacts | Tracks contact people (for example, branch manager, local admin) at a specific supplier address, supporting multi-contact setups. |
| SupplierRegistrationRequestsaddressesDFF | Captures descriptive flexfields for address records in supplier registration requests, supporting unique business data needs. |
| SupplierRegistrationRequestsattachments | Holds uploaded files (for example, tax forms, certificates) linked to a supplier registration, improving documentation completeness. |
| SupplierRegistrationRequestsbankAccounts | Stores supplier bank account details during registration, ensuring valid routing information for future payments. |
| SupplierRegistrationRequestsbankAccountsattachments | Allows attachments related to a supplier’s bank account (for example, proof of account ownership, voided checks). |
| SupplierRegistrationRequestsbusinessClassifications | Maintains classification records (for example, minority-owned, small business) for a supplier registration request, aligning with compliance requirements. |
| SupplierRegistrationRequestsbusinessClassificationsattachments | Holds files proving or explaining a supplier’s business classification, ensuring accurate and documented registrations. |
| SupplierRegistrationRequestscontacts | Stores contact information (for example, phone, email) for supplier representatives, forming the basis for communication. |
| SupplierRegistrationRequestscontactsDFF | Enables descriptive flexfields on supplier contact data, allowing extra fields beyond standard attributes. |
| SupplierRegistrationRequestscontactsroles | Tracks user account roles assigned to a supplier contact (for example, primary contact, user administrator), controlling system access. |
| SupplierRegistrationRequestsDFF | Houses descriptive flexfields at the registration request header, supporting additional data not covered by standard fields. |
| SupplierRegistrationRequestsproductsAndServices | Logs the products and services a supplier offers, matching them to internal categories for procurement decisions. |
| SupplierRegistrationRolesLOV | Lists user roles available for assignment during supplier registration, ensuring appropriate access for new supplier users. |
| 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. |