JDBC Driver for Oracle Fusion Cloud Financials

Build 25.0.9434

SuppliersproductsAndServices

Specifies the goods or services a supplier offers, mapped to relevant categories in the procurement system.

Columns

Name Type Description
SuppliersSupplierId [KEY] Long The unique identifier for the supplier associated with the products and services record.
ProductsServicesCategoryId Long The unique identifier for the products and services category that the supplier is associated with.
SupplierProductsServicesId [KEY] Long A unique identifier for the products and services record assigned to the supplier.
CategoryName String The name of the products and services category assigned to the supplier by the application.
CategoryDescription String A detailed description of the products and services category, explaining its scope or classification.
CategoryType String The type of products and services category assigned to the supplier, which can help categorize suppliers based on their offerings.
CreationDate Datetime The timestamp when the products and services record for the supplier was created in the system.
CreatedBy String The user or system that created the products and services record for the supplier.
LastUpdateDate Datetime The timestamp of the most recent update made to the products and services record for the supplier.
LastUpdatedBy String The user or system that last updated the products and services record for the supplier.
BilltoBuId Long The unique identifier for the billing business unit associated with the supplier's products and services record.
BindPurchaseFlag String Indicates whether the supplier's products and services record is linked to purchasing-related activities. The value can be 'true' (linked) or 'false' (not linked).
BindReqBuId Long The unique identifier for the business unit required for processing the supplier's products and services record.
BindSourcingOnlyFlag String Indicates whether the supplier's products and services record is restricted to sourcing-related activities only. 'True' means it is limited to sourcing; 'False' means it is available for other purposes.
BindSysdate Date The system date when the binding operation for the supplier's products and services record was executed.
Finder String A reference to a lookup or search function used for locating or retrieving the supplier's products and services record.
SupplierId Long The unique identifier for the supplier associated with this products and services record.

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