Stock database of nventory data in au PAY Market. Retrieve and update stock information.

Select

The connector 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 connector.

• LotNumber, ShopId columns support the = operator.
• StockCount column supports the =,<,<=,>,>= operators.
• ItemCode column supports the LIKE operator.

For example, the following queries are processed server side:

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.