Tables
The driver models the data in Oracle Fusion Cloud Financials as a list of tables in a relational database that can be queried using standard SQL statements.
CData JDBC Driver for Oracle Fusion Cloud Financials Tables
| Name | Description |
| ApprovedSupplierListSourceDocuments | Links source documents (like contracts or quotes) to approved supplier list entries, ensuring that procurement references are accurate and accessible. |
| ApprovedSupplierListSourceDocumentsDFF | Holds descriptive flexfields related to source documents on the approved supplier list, capturing extra procurement details. |
| DraftPurchaseOrders | Maintains partially completed purchase orders not yet communicated to suppliers, tracking preliminary details for further updates. |
| DraftPurchaseOrderslinesschedules | Manages shipping schedules, delivery dates, and receiving locations for each line in a draft purchase order. |
| PurchaseRequisitions | Handles internal purchase requests for items or services, capturing details for eventual PO creation or approval. |
| PurchaseRequisitionslines | Displays item-level details (part, quantity, pricing) for each line in the requisition, forming the basis for purchasing decisions. |
| Suppliers | Manages core supplier records, including contact details, addresses, business classifications, and attachments. |
| Suppliersaddresses | Captures location data for suppliers, such as physical or mailing addresses, to support invoicing and shipping. |
| Supplierscontacts | Maintains supplier contact records, including names, emails, and roles for consistent communication and procurement updates. |