ビュー

ビューは、データを示すという点でテーブルに似ていますが、ビューは読み取り専用です。

クエリは、ビューに対して通常のテーブルと同様に実行することができます。

CData JDBC Driver for Smaregi ビュー


Name	Description
DailySums	Returns a list of daily sales summaries.
DailySumsSalesList	Returns the individual sales that make up each daily sales summary.
LossDetails	Returns the line-item details of inventory loss records.
ReceivingDetails	Returns the product line items of stock-in (receiving) records.
ShipmentDetails	Returns the product line items of shipment records.
ShippingDetails	Returns the product line items of stock-out (dispatch) records.
StaffStores	Returns a list of the stores each staff member is assigned to.
StockHistories	Returns a list of stock change history records.
StocktakingDetails	Returns the product line items of stocktaking records.
StocktakingHeads	Returns a list of stocktaking headers, one per stocktaking split.
StocktakingInfo	Returns a list of stocktaking records, including the store and split unit for each inventory count.
StocktakingStockDetails	Returns the counted stock details for each stocktaking.
StorageDetails	Returns the product line items of stock arrival (receiving) records.
StorageInfoDeliveries	Returns the per-store delivery schedules for purchase orders.
StorageInfoDeliveryProducts	Returns the products scheduled for delivery in each purchase order.
StorageInfoProducts	Returns the products included in each purchase order.
TransactionCoupons	Returns a list of coupons applied to transactions.
TransactionDepositOthers	Returns the additional payment amounts, by payment method, for each transaction.
TransactionDetails	Returns the line-item details of sales transactions.