SuiteTalk Data Model
本製品 はNetSuite 情報をテーブル、ビュー、ストアドプロシージャを備えた使いやすいSQL データベースとしてモデル化します。テーブル定義は、NetSuite アカウントに基づいて動的に取得されます。
テーブル
Tables セクションには標準SQL テーブルの詳細が、Views セクションには読み取り専用SQL テーブルの一覧が記載されています。これらには、NetSuite アカウントでのアクセスを想定したサンプルが含まれています。
一般的なテーブルには以下のものが含まれます。
| テーブル | 説明 |
| Customer | Stores customer records, including contact details, preferences, and transaction history. |
| Transactions | Provides a comprehensive view of all transactions recorded in NetSuite, useful for auditing, reporting, and data analysis. |
| SalesOrder | Stores sales order details, tracking order processing, fulfillment, and invoicing. |
| Invoice | Stores details of customer invoices for sales transactions, including payment terms and due dates. |
| Employee | Manages employee records, including personal details, roles, and payroll information. |
| Vendor | Stores vendor records, including contact details, transaction history, and payment terms. |
| PurchaseOrder | Records purchase orders for goods and services, including vendor details and approval status. |
| Contact | Stores details of individuals associated with customers, vendors, and partners. |
| CustomerPayment | Tracks payments received from customers and their application to outstanding invoices. |
| JournalEntry | Records financial transactions manually entered into the general ledger. |
| Account | Stores financial account details used in transactions, reporting, and budgeting. |
| Department | Stores department classifications for financial reporting and organizational structure. |
| Location | Manages physical locations, including warehouses, offices, and retail stores. |
| Classification | Defines classifications used to categorize records for reporting and accounting segmentation. |
| ItemFulfillment | Records the fulfillment of sales orders, tracking shipments and deliveries. |
| Opportunity | Tracks potential sales opportunities, including estimated revenue, stage, and probability. |
| Estimate | Tracks sales estimates and quotes provided to customers before finalizing orders. |
| CreditMemo | Tracks issued credit memos for customer refunds, adjustments, or overpayments. |
| ExpenseReport | Stores submitted employee expense reports for approval and reimbursement. |
| TimeBill | Records billable hours logged by employees or contractors for project and service tracking. |