Procurement データモデル
Procurement データモデルスキーマでは、本製品 は認証されたアカウントに関連する仕入先、購買注文、ショッピングリストなどの情報を、使いやすいSQL データベースとしてモデル化します。これらのオブジェクトへのライブ接続により、Oracle Fusion Cloud Financials アカウントへのあらゆる変更は本製品 に即座に反映されます。
テーブル
テーブル セクションには標準SQL テーブルの詳細が、ビュー セクションには読み取り専用SQL テーブルの一覧が記載されています。これらには、Oracle Fusion Cloud Financials アカウントでのアクセスを想定したサンプルが含まれています。
一般的なテーブルには以下のものが含まれます。
| テーブル | 説明 |
| PurchaseOrders | Represents finalized purchase orders for goods or services from external suppliers, capturing key terms and statuses. |
| PurchaseOrderslines | Lists line-level details within a purchase order, specifying items, quantities, unit prices, and related buying terms. |
| PurchaseOrderslinesschedules | Defines the planned shipment dates and delivery details for each line item in a purchase order. |
| PurchaseOrderslinesschedulesdistributions | Allocates purchase order schedule costs to particular accounts or projects, ensuring accurate financial tracking. |
| 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. |
| PurchaseAgreementLines | Describes goods or services in a purchase agreement, excluding delivery or fulfillment specifics, to outline negotiated items. |
| PurchaseAgreements | Holds purchase agreement headers (quantity- or value-based) with negotiated terms, used by subsequent POs or contracts. |
| 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. |
| ProcurementApprovedSupplierListEntries | Tracks relationships between suppliers and the items or categories they’re approved to supply, ensuring compliance and vendor checks. |
| PurchaseOrdersattachments | Stores documents (for example, contracts, specifications) linked to a purchase order, enhancing detail for audits or approvals. |
| PurchaseRequisitionsattachments | Maintains documents attached to purchase requisitions, such as quotes, justifications, or requirement definitions. |
| PurchaseOrdersDFF | Captures additional descriptive flexfield data at the purchase order header level, allowing custom fields. |
| PurchaseRequisitionslinesdistributions ; | Splits the requisition line cost across multiple accounts or projects, aiding correct budget and financial reporting. |
| RequisitionProcessingRequests | Handles the conversion of approved requisition lines into purchase documents (for example, purchase orders), orchestrating the procurement flow. |
| WorkConfirmations | Handles confirmations of completed work for complex service or construction purchase orders, aiding accurate billing and progress tracking. |
| SupplierNegotiationResponses | Retrieves supplier-submitted responses to sourcing negotiations (for example, RFI, RFQ), offering visibility into proposed terms and pricing. |
| PublicShoppingLists | Defines public shopping list headers, grouping related items for streamlined requisition or bulk purchasing. |
ストアドプロシージャ
ストアドプロシージャ は、SQLクエリを介して呼び出されるアクションです。標準的なCRUD 操作だけでなく、契約の修正や添付ファイルのアップロードなど、より高度なタスクも実行します。