JDBC Driver for Oracle Fusion Cloud Financials

Build 25.0.9434

ContentZonescatalogAssignments

Specifies which local, punchout, or informational catalogs are linked to a given content zone, defining available shopping resources.

Columns

Name Type Description
ContentZonesContentZoneId [KEY] Long Unique identifier for the content zone in the catalog assignment. This ID links the content zone to the catalog assignment, helping to track and manage which content zone the catalog is associated with.
CatalogAssignmentId [KEY] Long Unique identifier for the catalog assignment. This ID is used to reference a specific assignment of a catalog to a content zone within the system.
ContentZoneId Long Unique identifier for the content zone associated with the catalog assignment. This value helps establish the relationship between the content zone and the catalog it is assigned to.
CatalogId Long Unique identifier for the catalog assigned to the content zone. This ID helps track and manage which catalog is linked to the content zone.
Catalog String The name of the catalog that is assigned to the content zone. This field provides context about the specific catalog linked to the content zone for organizational or operational purposes.
CatalogTypeCode String An abbreviation that identifies the type of catalog. Valid values include 'LOCAL' for internally managed catalogs, 'PUNCHOUT' for external catalogs accessed via punchout functionality, or 'INFORMATIONAL' for informational catalogs.
CatalogType String Describes the type of catalog assigned to the content zone. The values indicate whether the catalog is local, punchout (external), or informational, providing clarity on how the catalog is accessed and used.
CreationDate Datetime The date and time when the catalog assignment was created. This timestamp tracks when the catalog was linked to the content zone for the first time.
CreatedBy String The user who created the catalog assignment. This field helps identify the person responsible for linking the catalog to the content zone.
LastUpdatedBy String The user who most recently updated the catalog assignment. This field provides accountability for changes made to the catalog assignment after its creation.
LastUpdatedDate Datetime The date and time when the catalog assignment was last updated. This timestamp ensures that users can track when the most recent changes to the assignment occurred.
ContentZone String The name or identifier of the content zone. This value helps identify the specific content zone that the catalog is linked to.
DeliverToLocationCode String A code representing the location to which the catalog is delivered. This helps define the specific destination or site where the catalog is used in the procurement or requisitioning process.
Finder String A field used to search or locate specific catalog assignment records within the system. It contains search criteria or parameters to assist users in finding relevant catalog assignments quickly.
ProcurementBU String The name of the procurement business unit where the catalog assignment is created. This field helps to identify which procurement unit is responsible for managing the catalog within the content zone.
RequisitioningBU String The name of the requisitioning business unit associated with the catalog assignment. This field is used to identify the requisitioning unit responsible for initiating requests using the assigned catalog.
SecuredByCode String An abbreviation that identifies how the catalog assignment is secured within the content zone. It specifies whether access is restricted by business unit, worker, or location. Valid values include 'SECURED_BY_BU', 'SECURED_BY_WORKER', and 'SECURED_BY_DEL_LOC'.
UsageCode String An abbreviation that identifies the usage context of the catalog assignment. This field helps specify how the catalog is used, such as in requisitioning or procurement. Valid values include 'REQUISITIONING' or 'PROCUREMENT'.
WorkerEmail String The email address of the worker associated with the catalog assignment. This field is used to link workers to specific catalogs, helping to facilitate communication and catalog access.
EffectiveDate Date This query parameter is used to fetch resources that are effective as of the specified start date. It ensures that only records that are valid as of the given date are returned.

Copyright (c) 2025 CData Software, Inc. - All rights reserved.
Build 25.0.9434