CData Python Connector for au PAY Market

Build 24.0.9062

InventoryChoices

Retrieve and update information related to inventory choices.

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.
  • ItemCode column supports the LIKE operator.
For example, the following queries are processed server side:
SELECT * FROM InventoryChoices WHERE ItemCode LIKE 'CD001'

SELECT * FROM InventoryChoices WHERE LotNumber  = 1234455 AND ShopId = '123'

Insert

All columns can be specified. ItemCode, ChoicesHorizontalCode, ChoicesVerticalCode are required for an Insert

INSERT INTO InventoryChoices (ItemCode, ChoicesHorizontalCode, ChoicesVerticalCode, ChoicesCount, ChoicesShippingDayId, ChoicesShippingDayDisplayText) VALUES ('CD001', 'S', 'Red', 3, '2132', 'text') 

Batch Insert

All columns can be specified. ItemCode, ChoicesHorizontalCode, ChoicesVerticalCode are required.

INSERT INTO InventoryChoices#TEMP (ItemCode, ChoicesHorizontalCode, ChoicesVerticalCode, ChoicesCount)  VALUES ('CD001', 'S', 'Red', 0)

INSERT INTO InventoryChoices#TEMP (ItemCode, ChoicesHorizontalCode, ChoicesVerticalCode, ChoicesCount)  VALUES ('CD001', 'M', 'Red', 4)

INSERT INTO InventoryChoices#TEMP (ItemCode, ChoicesHorizontalCode, ChoicesVerticalCode, ChoicesCount)  VALUES ('CD001', 'S', 'Yellow', 3)

INSERT INTO InventoryChoices SELECT ItemCode, ChoicesHorizontalCode, ChoicesVerticalCode, ChoicesCount FROM InventoryChoices#TEMP

Update

au PAY Market allows updates for all columns. ItemCode is required.

UPDATE InventoryChoices SET ChoicesCount = 0, ChoicesShippingDayId = '2132', ChoicesShippingDayDisplayText = 'txt' WHERE ItemCode = 'CD001' AND ChoicesHorizontalCode = 'S' AND ChoicesVerticalCode = 'Red'

Batch Update

au PAY Market allows updates in batches for all columns. ItemCode, ChoicesHorizontalCode and ChoicesVerticalCode are required.

INSERT INTO InventoryChoices#TEMP (ItemCode, ChoicesHorizontalCode, ChoicesVerticalCode, ChoicesCount) VALUES ('CD001', 'S', 'Red', 0)

INSERT INTO InventoryChoices#TEMP (ItemCode, ChoicesHorizontalCode, ChoicesVerticalCode, ChoicesCount) VALUES ('CD001', 'M', 'Red', 4)

INSERT INTO InventoryChoices#TEMP (ItemCode, ChoicesHorizontalCode, ChoicesVerticalCode, ChoicesCount) VALUES ('CD001', 'S', 'Yellow', 3)

UPDATE InventoryChoices SET (ItemCode, ChoicesHorizontalCode, ChoicesVerticalCode, ChoicesCount) SELECT ItemCode, ChoicesHorizontalCode, ChoicesVerticalCode, ChoicesCount FROM InventoryChoices#TEMP

Delete

Delete is not supported for this table

Columns

Name Type ReadOnly References Description
ItemCode [KEY] String False

Inventory.ItemCode

Product code.

LotNumber Long False

Inventory.LotNumber

Lot number.

ChoicesHorizontalCode [KEY] String False

Choice horizontal code.

ChoicesVerticalCode [KEY] String False

Choice vertical code.

ChoicesCount String False

Choice count..

ChoicesShippingDayId String False

Choice shipping date id.

ChoicesShippingDayDisplayText String False

Choice shipping date information.

ShopId String False

Store account.

Copyright (c) 2024 CData Software, Inc. - All rights reserved.
Build 24.0.9062