Stores
Returns a list of stores.
テーブル固有の情報
SELECT
connector は Smaregi API を使用してWHERE 句条件を処理します。すべてのカラムは=、!=、>、<、>=、<= 演算子によるサーバー側フィルタリングをサポートし、文字列型のカラムはLIKE もサポートします。IN 演算子、およびdate/datetime 型のカラムに対するLIKE 演算子は、クライアント側で処理されます。
例えば、次のクエリはサーバー側で処理されます：
SELECT * FROM Stores WHERE StoreId = 2
SELECT StoreName, StoreCode, PostCode FROM Stores ORDER BY StoreId
INSERT
Stores を追加するには、StoreId、StoreCode およびStoreName フィールドを指定します。
INSERT INTO Stores (StoreId, StoreCode, StoreName) VALUES (35, 'YSM', 'TATA')
UPDATE
Smaregi はStoreCode、StoreName、StoreAbbr、PostCode、Address、PhoneNumber、FaxNumber、MailAddress、Homepage、TempTranMailAddress、PriceChangeFlag、SellDivision、SumProcDivision、SumDateChangeTime、SumRefColumn、PointNotApplicable、TaxFreeDivision、MaxBundleProductCount、RoundingDivision およびDiscountRoundingDivision カラムの更新を許可します。
UPDATE Stores SET StoreCode = 'YM', StoreName = 'TATASONS' WHERE StoreId = 35
Columns
| Name | Type | ReadOnly | References | Description |
| StoreId [KEY] | Integer | False |
Store Id. | |
| StoreCode | String | False |
Store Code. | |
| StoreName | String | False |
Store Name. | |
| StoreAbbr | String | False |
Store name abbreviation. | |
| Division | Integer | False |
Store classification, 1=Normal Store, 2=Warehouse. Its default value is 1. It cannot be changed after registeration. | |
| PostCode | String | False |
Store zip code with hyphen. | |
| Address | String | False |
Store address. | |
| PhoneNumber | String | False |
Store phone number with hyphen. | |
| FaxNumber | String | False |
Store fax number. | |
| MailAddress | String | False |
Store email address. | |
| Homepage | String | False |
Store homepage. | |
| TempTranMailAddress | String | False |
Email address to be sent when registering a temporary transaction. Multiple specifications can be specified separated by commas. | |
| PriceChangeFlag | Integer | False |
To prevent the selling price from being changed on the iPod or iPad, set 0:Cannot be changed, set 1: can be changed. Its default value is 1. | |
| SellDivision | Integer | False |
Sales category, 0:Tax-included sales, 1:Tax-excluded sales. Its default value is 1. | |
| SumProcDivision | Integer | False |
Distinguishable by means of association, 0:Manual tightening process, 1:Automatic tightening process. Its default value is 0. | |
| SumDateChangeTime | String | False |
Date change time. Used during tightening[HHMM]. Tightening method classification is 1: Required for automatic tightening. | |
| SumRefColumn | String | False |
The time to refer to when performing the tightening process. Used during closing process(0:terminal time, 1:server time). Tightening method classification is 1: Required for automatic closing process. Its default value is 0. | |
| PointNotApplicable | Integer | False |
Point target classification. 0 means Add points and 1 means Do not add points. Its default value is 0. | |
| TaxFreeDivision | Integer | False |
Tax free distinction. 0 means not applicable, 1 means General products and 2 means Consumables. Its default value is 0. | |
| MaxBundleProductCount | Integer | False |
Maximum number of simple bundle product registrations. Set the maximum number of registered products on the simple bundle sales screen. Its Default value is from 9 upto 999. Its default value is 9. | |
| RoundingDivision | String | False |
Fractional value subtraction classification. Set whether to round the total amount at the time of sale. 00:None, 11: Round off the ones place, 12: Round off the ones place, 13: Round up the ones place, 21: Round off the tens place , 22: Round the tens place, 23: Round the tens place, 31: Round the hundreds place, 32: Round the hundreds place, 33: Round the hundreds place, 41: Round the thousands place , 42: Round off the thousand's place, 43: Round up the thousand's place, 99: Manually entered. Its default value is 00. | |
| DiscountRoundingDivision | String | False |
Discount Rounding Category. 0 means rounding, 1 means rounding down, 2 means rounding up and 3 means bank rounding. Its default value is 0. | |
| PauseFlag | Boolean | True |
Pause flag (0:normal, 1:pause). | |
| PointUseDivision | Integer | True |
Point usage classification. Determine whether to use the point function(0:not used and 1: used). Its default value is 1. | |
| InsDateTime | Datetime | True |
Creation date and time: Date and time at the time of registration. [YYYY-MM-DDThh: mm: ssTZD]. | |
| UpdDateTime | Datetime | True |
Update date and time: Date and time of registration / update. [YYYY-MM-DDThh: mm: ssTZD]. |