JDBC Driver for Smaregi

Build 26.0.9770

DailySummaries

Returns daily summaries.

Columns

Name Type References Description
Amount Integer
CalculateBalance Integer
Carriage Integer
CarryOver Integer
CashDrawerId [KEY] Integer
CashSales Integer
ChangeDifference Integer
Comment String
Commission Integer
CostTotal Decimal
CreditSales Integer
Deposit Integer
Difference Integer
Discount Integer
FiftyYen Integer
FiveHundredYen Integer
FiveThousandYen Integer
FiveYen Integer
GrossMargin Integer
InsDateTime Datetime
InTaxSalesTotal Integer
NonSalesCashTotal Integer
NonSalesCreditTotal Integer
NonSalesOtherTotal Integer
NonSalesTargetTaxFreeTotal Integer
NonSalesTargetTotal Integer
NonSalesTaxFreeTotal Integer
NonTaxSalesTotal Integer
OneHundredYen Integer
OneThousandYen Integer
OneYen Integer
OtherSalesList String
OutTaxSalesTotal Integer
PartPayment Integer
PartPaymentCancel Integer
PartPaymentCash Integer
PartPaymentCashCancel Integer
PartPaymentCredit Integer
PartPaymentCreditCancel Integer
Payment Integer
PointDiscount Integer
PreparationCash Integer
RealBalance Integer
Receipt Integer
ReceivedDepositCash Integer
ReceivedDepositCashTotal Integer
ReceivedDepositCreditTotal Integer
ReturnAmount Integer
ReturnDeposit Integer
SalesTotal Integer
SalesTotalNonSalesTargetDivision String
Saving Integer
Status String
StoreId [KEY] Integer
SumDate [KEY] Date
TaxDetailList String
TaxExclude Integer
TaxExcludeReceive Integer
TaxFreeTotal Integer
TaxInclude Integer
TaxTotal Integer
TenThousandYen Integer
TenYen Integer
Total Integer
TotalExcludeTax Integer
TotalExcludTax Integer
TotalTaxFreeDivision String
TransactionCount Integer
TwoThousandYen Integer
UpdDateTime Datetime

Copyright (c) 2026 CData Software, Inc. - All rights reserved.
Build 26.0.9770