DailySums
Returns a list of daily sales summaries.
ビュー固有の情報
SELECT
本製品 は Smaregi API を使用してWHERE 句条件を処理します。次のカラムはサーバー側フィルタリングをサポートします：
| カラム | サポートされる演算子 |
| SumDate | =, !=, >, <, >=, <= |
| StoreId | =, !=, >, <, >=, <=, LIKE |
| CashDrawerId | =, !=, >, <, >=, <=, LIKE |
| InsDateTime | =, !=, >, <, >=, <= |
| UpdDateTime | =, !=, >, <, >=, <= |
IN 演算子、およびdate/datetime 型のカラムに対するLIKE 演算子は、クライアント側で処理されます。
例えば、次のクエリはサーバー側で処理されます：
SELECT * FROM DailySums WHERE SumDate = '2019-08-02'
Columns
| Name | Type | References | Description |
| SumDate [KEY] | Date | ||
| StoreId [KEY] | Integer |
Stores.StoreId | |
| CashDrawerId [KEY] | Integer | ||
| Status | Integer | ||
| SalesTotal | Decimal | ||
| Discount | Decimal | ||
| PointDiscount | Decimal | ||
| TaxExcludeReceive | Decimal | ||
| NonSalesTargetTotal | Decimal | ||
| Total | Decimal | ||
| TotalExcludTax | Decimal | ||
| InTaxSalesTotal | Decimal | ||
| TaxInclude | Decimal | ||
| OutTaxSalesTotal | Decimal | ||
| TaxExclude | Decimal | ||
| TaxTotal | Decimal | ||
| TaxDetailList | String | ||
| NonTaxSalesTotal | Decimal | ||
| TaxFreeTotal | Decimal | ||
| NonSalesTargetTaxFreeTotal | Decimal | ||
| CostTotal | Decimal | ||
| GrossMargin | Decimal | ||
| Amount | Integer | ||
| TransactionCount | Integer | ||
| ReturnAmount | Integer | ||
| Carriage | Decimal | ||
| Commission | Decimal | ||
| PreparationCash | Decimal | ||
| CashSales | Decimal | ||
| CreditSales | Decimal | ||
| OtherSalseList | String | ||
| PartPayment | Decimal | ||
| PartPaymentCash | Decimal | ||
| PartPaymentCredit | Decimal | ||
| ReceivedDepositCash | Decimal | ||
| ReceivedDepositCashTotal | Decimal | ||
| ReceivedDepositCreditTotal | Decimal | ||
| PartPaymentCancel | Decimal | ||
| PartPaymentCashCancel | Decimal | ||
| PartPaymentCreditCancel | Decimal | ||
| Deposit | Decimal | ||
| ReturnDeposit | Decimal | ||
| Receipt | Decimal | ||
| Payment | Decimal | ||
| NonSalesCashTotal | Decimal | ||
| NonSalesCreditTotal | Decimal | ||
| NonSalesOtherTotal | Decimal | ||
| NonSalesTaxFreeTotal | Decimal | ||
| ChangeDifference | Decimal | ||
| CalculateBalance | Decimal | ||
| RealBalance | Decimal | ||
| Difference | Decimal | ||
| Saving | Decimal | ||
| CarryOver | Decimal | ||
| TenThousandYen | Integer | ||
| FiveThousandYen | Integer | ||
| TwoThousandYen | Integer | ||
| OneThousandYen | Integer | ||
| FiveHundredYen | Integer | ||
| OneHundredYen | Integer | ||
| FiftyYen | Integer | ||
| TenYen | Integer | ||
| FiveYen | Integer | ||
| OneYen | Integer | ||
| Comment | String | ||
| InsDateTime | Datetime | ||
| UpdDateTime | Datetime | ||
| SalesTotalNonSalesTargetDivision | String | ||
| TotalTaxFreeDivision | String |