テーブル

本製品はSmaregi のデータを、標準のSQL ステートメントを使用してクエリできるリレーショナルデータベースのテーブルのリストとしてモデル化します。

CData Excel Add-In for Smaregi テーブル


Name	Description
BargainProducts	Returns a list of the products included in each bargain.
Bargains	Returns a list of bargains, which are sale promotions applied to products over a set period.
BargainStores	Returns a list of the stores where each bargain is applied.
Categories	Returns a list of product categories.
Customers	Returns a list of customers (members).
Losses	Returns a list of inventory loss records.
ProductInventoryReservations	Returns a list of product inventory allocations, including the allocated product and quantity for each product.
ProductPrices	Returns a list of product prices.
ProductReserveItemLabels	Returns a list of labels that define the product reserve (custom) fields.
ProductReserveItems	Returns a list of the reserve (custom) field values set for products.
Products	Returns a list of products.
ProductStores	Returns a list of store-specific product settings.
Receivings	Returns a list of stock-in records received from inter-store transfers.
Shipments	Returns a list of shipment records for goods sent to suppliers, such as returns and promotional items.
Shippings	Returns a list of stock-out (dispatch) records for inter-store transfers.
Staff	Returns a list of staff members.
Stocks	Returns a list of product stock quantities.
StorageInfo	Returns a list of purchase orders placed with suppliers.
Storages	Returns a list of stock arrival (receiving) records for purchase orders.
Stores	Returns a list of stores.
TransactionHeads	Returns a list of transaction headers for sales transactions.