Tableau Connector for Smaregi

Build 26.0.9655

TransactionLayaways

Generated schema file.

Columns

Name Type ReadOnly References Description
TransactionHeadId [KEY] Integer True

AdjustmentDateTime Datetime True

AdjustmentMile Integer True

AdjustmentMileDivision String True

AdjustmentMileValue Integer True

Amount Integer True

AuthDate Date True

AuthNumber String True

CancelDateTime Datetime True

CancelDivision String True

CancelSlipNumber String True

CardCompany String True

Carriage Integer True

CashTotal Integer True

Change Integer False

ChangeDifference Integer True

Commission Integer True

CostTotal Decimal True

CreditDivision String True

CreditTotal Integer True

CurrentMile Integer True

Customer String True

CustomerCode String False

CustomerGroupId Integer False

CustomerGroupId2 Integer False

CustomerGroupId3 Integer False

CustomerGroupId4 Integer False

CustomerGroupId5 Integer False

CustomerGroups String True

CustomerId Long False

CustomerPinCode String False

CustomerRank String False

Denomination String True

Deposit Integer False

DepositCash Integer False

DepositCredit Integer False

DiscountRoundingDivision String False

Discounts String True

DisposeDivision String True

DisposeServerTransactionHeadId String True

EarnMile Integer True

EnterDateTime Datetime False

ExchangeTicketNo String False

GiftReceiptValidDays Integer False

GuestNumbers Integer False

GuestNumbersFemale Integer False

GuestNumbersMale Integer False

GuestNumbersUnknown Integer False

InTaxSalesTotal Integer True

Layaway String False

LayawayPickUp String True

Memo String False

MileageDivision String False

MileageLabel String False

NetTaxFreeConsumableTaxExclude Integer False

NetTaxFreeConsumableTaxInclude Integer False

NetTaxFreeGeneralTaxExclude Integer False

NetTaxFreeGeneralTaxInclude Integer False

NewPoint Integer True

NonSalesTargetAmount Integer True

NonSalesTargetCostTotal Decimal True

NonSalesTargetInTaxTotal Integer True

NonSalesTargetOutTaxTotal Integer True

NonSalesTargetReturnAmount Integer True

NonSalesTargetTaxFreeTotal Integer True

NonSalesTargetTotal Integer True

NonTaxSalesTotal Integer True

OutTaxSalesTotal Integer True

PaymentCount Integer True

Point Integer True

PointDiscount Integer False

PointGivingDivision String False

PointGivingUnit Decimal False

PointGivingUnitPrice Integer False

PointSpendDivision String False

ReceiptMemo String False

ReturnAmount Integer True

ReturnSales String True

RoundingDivision String False

RoundingPrice Integer False

SalesHeadDivision String True

SellDivision String False

SlipNumber String True

SpendPoint Integer True

Staff String True

StaffCode String True

StaffId Integer False

StaffName String True

Store String True

StoreCode String True

StoreId Integer False

Subtotal Integer False

SubtotalDiscountDivision Integer False

SubtotalDiscountPrice Integer False

SubtotalDiscountRate Integer False

SubtotalForDiscount String True

SumDate Date False

SumDivision String False

Tags String False

TaxExclude Integer False

TaxFreeSalesDivision String False

TaxInclude Integer False

TaxRate Decimal False

TaxRounding String False

TerminalId Integer False

TerminalTranDateTime Datetime False

TerminalTranId Integer False

TipCash Integer True

TipCredit Integer True

Total Integer False

TotalMile Integer True

TotalPoint Integer True

TransactionDateTime Datetime True

TransactionHeadDivision String False

TransactionUuid String False

UnitBargainDiscountsubtotal Integer True

UnitDiscountsubtotal Integer True

UnitNonDiscountsubtotal Integer True

UnitStaffDiscountsubtotal Integer True

UpdDateTime Datetime True

Details String False

Pseudo-Columns

SELECT ステートメントのWHERE 句では、疑似カラムフィールドを使用して、データソースから返されるデータを詳細に制御することができます。

Name Type Description
WithCustomer String

WithCustomerGroups String

WithDiscounts String

WithStore String

WithStaff String

WithLayway String

WithLaywayPickUp String

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