Inventory
Stock database of nventory data in au PAY Market. Retrieve and update stock information.
Select
The 本製品 will use the au PAY Market API to process WHERE clause conditions built with the following columns and operators. The rest of the filter is executed client side within the 本製品.
- LotNumber, ShopId columns support the = operator.
- StockCount column supports the =,<,<=,>,>= operators.
- ItemCode column supports the LIKE operator.
SELECT * FROM Inventory WHERE ItemCode LIKE 'CD001' AND StockCount > 12 AND StockCount <= 30
SELECT * FROM Inventory WHERE LotNumber = 1234455 AND ShopId = '123' AND StockCount = 12
Insert
Insert is not supported for this table
Update
au PAY Market allows updates for all columns. ItemCode is required.
UPDATE Inventory SET StockShippingDayId = 'id', StockShippingDayDisplayText = 'display text', DisplayStockSegment = 'categ', ChoicesStockLowerDescription = 'desc', DisplayStockThreshold = 'threshold' WHERE ItemCode = 'MD001' AND LotNumber = 9808450
InventoryChoices, InventoryVerticalChoices, InventoryHorizontalChoices columns contain information on the subtables with the same names. These fields can be updated as aggregated values, or by using temporary tables.
UPDATE Inventory SET InventoryChoices = '<choicesStocks> <choicesStockCount>5</choicesStockCount> <choicesStockHorizontalCode>M</choicesStockHorizontalCode> <choicesStockVerticalCode>Green</choicesStockVerticalCode> </choicesStocks> <choicesStocks> <choicesStockCount>2</choicesStockCount> <choicesStockHorizontalCode>S</choicesStockHorizontalCode> <choicesStockVerticalCode>Green</choicesStockVerticalCode> </choicesStocks> <choicesStocks> <choicesStockCount>4</choicesStockCount> <choicesStockHorizontalCode>M</choicesStockHorizontalCode> <choicesStockVerticalCode>Red</choicesStockVerticalCode> </choicesStocks> <choicesStocks> <choicesStockCount>0</choicesStockCount> <choicesStockHorizontalCode>S</choicesStockHorizontalCode> <choicesStockVerticalCode>Red</choicesStockVerticalCode> </choicesStocks>', InventoryHorizontalChoices = '<choicesStockHorizontals> <choicesStockHorizontalCode>S</choicesStockHorizontalCode> <choicesStockHorizontalName>S</choicesStockHorizontalName> <choicesStockHorizontalSeq>1</choicesStockHorizontalSeq> </choicesStockHorizontals> <choicesStockHorizontals> <choicesStockHorizontalCode>M</choicesStockHorizontalCode> <choicesStockHorizontalName>M</choicesStockHorizontalName> <choicesStockHorizontalSeq>2</choicesStockHorizontalSeq> </choicesStockHorizontals>', InventoryVerticalChoices = '<choicesStockVerticals> <choicesStockVerticalCode>Red</choicesStockVerticalCode> <choicesStockVerticalName>Red</choicesStockVerticalName> <choicesStockVerticalSeq>1</choicesStockVerticalSeq> </choicesStockVerticals> <choicesStockVerticals> <choicesStockVerticalCode>Green</choicesStockVerticalCode> <choicesStockVerticalName>Green</choicesStockVerticalName> <choicesStockVerticalSeq>2</choicesStockVerticalSeq> </choicesStockVerticals>' WHERE ItemCode = 'Cd001' AND LotNumber = 9808450
INSERT INTO InventoryChoices#TEMP (ChoicesHorizontalCode, ChoicesVerticalCode, ChoicesCount) VALUES ('M', 'Green', 5)
INSERT INTO InventoryChoices#TEMP (ChoicesHorizontalCode, ChoicesVerticalCode, ChoicesCount) VALUES ('S', 'Green', 2)
INSERT INTO InventoryChoices#TEMP (ChoicesHorizontalCode, ChoicesVerticalCode, ChoicesCount) VALUES ('M', 'Red', 4)
INSERT INTO InventoryChoices#TEMP (ChoicesHorizontalCode, ChoicesVerticalCode, ChoicesCount) VALUES ('S', 'Red', 0)
INSERT INTO InventoryVerticalChoices#TEMP (ChoicesVerticalCode, ChoicesVerticalName, ChoicesVerticalSeq) VALUES ('Red', 'Red', 1)
INSERT INTO InventoryVerticalChoices#TEMP (ChoicesVerticalCode, ChoicesVerticalName, ChoicesVerticalSeq) VALUES ('Green', 'Green', 2)
INSERT INTO InventoryHorizontalChoices#TEMP (ChoicesHorizontalCode, ChoicesHorizontalName, ChoicesHorizontalSeq) VALUES ('S', 'S', 1)
INSERT INTO InventoryHorizontalChoices#TEMP (ChoicesHorizontalCode, ChoicesHorizontalName, ChoicesHorizontalSeq) VALUES ('M', 'M', 2)
UPDATE Inventory SET InventoryChoices = 'InventoryChoices#TEMP', InventoryVerticalChoices = 'InventoryVerticalChoices#TEMP', InventoryHorizontalChoices = 'InventoryHorizontalChoices#TEMP' WHERE ItemCode = 'CD001' AND LotNumber = 9808450
Batch Update
au PAY Market allows updates in batches for all columns except InventoryChoices, InventoryVerticalChoices and InventoryHorizontalChoices. ItemCode is required.
INSERT INTO Inventory#TEMP (StockShippingDayId, DisplayStockThreshold, ItemCode, LotNumber) VALUES ('a', 'threshold1', 'CD001', 9808450)
INSERT INTO Inventory#TEMP (StockShippingDayId, DisplayStockThreshold, ItemCode, LotNumber) VALUES ('b', 'threshold2', 'CD002', 9804323)
INSERT INTO Inventory#TEMP (StockShippingDayId, DisplayStockThreshold, ItemCode, LotNumber) VALUES ('c', 'threshold3', 'CD003', 9804312)
UPDATE Inventory SET (StockShippingDayId, DisplayStockThreshold, ItemCode, LotNumber) SELECT StockShippingDayId, DisplayStockThreshold, ItemCode, LotNumber FROM Inventory#TEMP
Delete
Delete is not supported for this table
Columns
Name | Type | ReadOnly | References | Description |
ItemCode [KEY] | String | False |
Product code. | |
LotNumber | Long | False |
Lot number. | |
StockCount | Integer | False |
Usually the number of stock. | |
StockSegment | String | False |
Stock division. | |
StockShippingDayId | String | False |
Normal inventory shipping day ID. | |
StockShippingDayDisplayText | String | False |
Inventory shipping information. | |
DisplayStockSegment | String | False |
Stock display category. | |
DisplayStockThreshold | String | False |
Stock display threshold. | |
ChoicesStockHorizontalItemName | String | False |
Choices by stock horizontal axis item name. | |
ChoicesStockVerticalItemName | String | False |
Choices by stock horizontal axis item name. | |
ChoicesStockUpperDescription | String | False |
Choices by stock upper description. | |
ChoicesStockLowerDescription | String | False |
Choices by stock lower description. | |
DisplayChoicesStockSegment | Integer | False |
The remaining choices by stock Display category. | |
DisplayChoicesStockThreshold | Integer | False |
Choices by stock display threshold. | |
DisplayBackorderMessage | String | False |
Out of stock message. | |
InventoryHorizontalChoices | String | False |
Aggregated data for inventory horizontal options. Readable data found at sub-table with the same name. | |
InventoryVerticalChoices | String | False |
Aggregated data for inventory vertical options. Readable data found at sub-table with the same name. | |
InventoryChoices | String | False |
Aggregated data for inventory choices. Readable data found at sub-table with the same name. | |
ShopId | String | False |
Store account. |