JDBC Driver for Oracle Fusion Cloud Financials

Build 25.0.9434

ShoppingCatalogSmartFormDetailsagreementRequisitionBUAssignments

Indicates which requisitioning business units are assigned to an agreement specified in a smart form, defining usage scope.

Columns

Name Type Description
ShoppingCatalogSmartFormDetailsSmartFormId [KEY] Long The unique identifier for the smart form associated with the agreement requisition business unit assignment. Example: 1001 for Smart Form ID.
RequisitionBUAssignmentId [KEY] Long The unique identifier for the requisition business unit assignment related to the smart form. Example: 2001 for the assignment ID.
RequisitioningBUId Long The unique identifier for the business unit that raised the requisition. Example: 3001 for the business unit raising the requisition.
RequisitioningBUName String The name of the business unit that raised the requisition. Example: 'Purchasing Department' for the name of the requisitioning business unit.
SupplierSiteId Long The unique identifier for the supplier site associated with the requisition. Example: 4001 for Supplier Site ID 4001.
SupplierSite String The name of the supplier site where goods or services will be delivered. Example: 'Main Warehouse' for the supplier site.
SupplierContactId Long The unique identifier for the supplier contact. Example: 5001 for Supplier Contact ID 5001.
SupplierContact String The name of the supplier contact person for the requisition. Example: 'John Doe' for the contact person at the supplier.
SupplierContactEmail String The email address of the supplier contact. Example: '[email protected]' for the supplier contact's email.
SupplierContactPhone String The phone number of the supplier contact. Example: '(123) 456-7890' for the supplier contact's phone number.
SupplierContactFax String The fax number of the supplier contact. Example: '(123) 456-7891' for the supplier contact's fax number.
Finder String A reference or placeholder used for searching and locating specific records of supplier contact details in the agreement requisition assignments. Example: 'Search by Supplier Contact Name'.
SmartFormId Long The unique identifier for the associated smart form. Example: 1002 for SmartForm ID 1002.
SysEffectiveDate String The system-effective date used for filtering the resource by its effective date. Example: '2023-06-01' for filtering based on this date.
EffectiveDate Date This query parameter is used to fetch resources that are effective as of the specified start date. Example: '2023-06-01' for filtering by June 1st, 2023.

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