DailySumsSalesList
Returns the individual sales that make up each daily sales summary.
View-Specific Information
SELECT
The 本製品 uses the Smaregi API to process WHERE clause conditions. The following columns support server-side filtering:
| Column | Supported Operators |
| SumDate | =, !=, >, <, >=, <= |
| StoreId | =, !=, >, <, >=, <=, LIKE |
| CashDrawerId | =, !=, >, <, >=, <=, LIKE |
| InsDateTime | =, !=, >, <, >=, <= |
| UpdDateTime | =, !=, >, <, >=, <= |
The IN operator, and the LIKE operator on date and datetime columns, are processed client-side.
For example, the following query is processed server-side:
SELECT * FROM DailySumsSalesList WHERE StoreId = '1234'
Columns
| Name | Type | References | Description |
| SumDate [KEY] | Date | ||
| StoreId [KEY] | Integer |
Stores.StoreId | |
| CashDrawerId [KEY] | Integer | ||
| Id [KEY] | Integer | ||
| Name | String | ||
| PaymentMethodDivision | String | ||
| PaymentMethodDivisionName | String | ||
| Sales | Decimal | ||
| InsDateTime | Datetime | ||
| UpdDateTime | Datetime |