SuiteQL Data Model
本製品 はNetSuite 情報をビューおよびストアドプロシージャを備えた使いやすいSQL データベースとしてモデル化します。
ビュー
ビュー セクションには読み取り専用SQL テーブルの一覧が記載されています。これらには、NetSuite アカウントでのアクセスを想定したサンプルが含まれています。
一般的なビューには以下のものが含まれます。
| ビュー | 説明 |
| transaction | Stores financial transaction records, linking them to customers, vendors, and accounts. |
| customer | Tracks detailed customer information, including contact details, account status, and transaction history for billing and Customer Relationship Management. |
| vendor | Stores detailed information about vendors, including company details, contact information, and relationships. |
| employee | Tracks employee records, storing personal and professional details for HR, payroll, and management purposes. |
| item | Holds details about inventory and non-inventory items, including products, materials, and services available in NetSuite. |
| account | Stores financial account details, including general ledger accounts used for recording transactions. |
| salesorder | Stores details of sales orders, including order status, customer, and line items. |
| creditmemo | Stores credit memo records, which are issued to customers when an amount is credited back to their account, often due to returns or billing errors. |
| journalentry | Stores financial journal entries, tracking debits and credits for accounting purposes. |
| department | Contains details about the departments within an organization, used for categorizing and organizing personnel, expenses, and tasks. |
| classification | Defines the classification system used for categorizing different records within the platform, such as customer types or item categories. |
| location | Stores details about business locations, including warehouses and offices. |
| itemfulfillment | Stores records of item fulfillment transactions, detailing how and when items are shipped to customers. |
| itemreceipt | Records the receipt of inventory items, capturing details such as purchase order fulfillment and supplier shipments. |
| expensereport | Tracks employee expense reports, used for submission, approval, and reimbursement of employee-incurred expenses. |
| timebill | Records time billing data, tracking billable hours for projects and services. |
| supportcase | Logs customer support cases, including issue descriptions, statuses, resolutions, and assigned agents. |
| opportunity | Stores information about sales opportunities, including potential revenue and deal details. |