SSIS Components for au PAY Market

Build 24.0.9062

ItemOptions

Retrieve and update information related to item options.

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 ItemOptions WHERE ItemCode LIKE '%CD00%'

SELECT * FROM ItemOptions WHERE ItemCode = 'CD001' AND LotNumber = 123543 

Insert

All columns can be specified. ItemCode, ItemOptionSeq are required for an insert.

INSERT INTO ItemOptions (ItemCode,  ItemOptionSeq, ItemOptionTitle, ItemOption) VALUES ('Code0001',  '1', 'title1', 'option1')

Batch Insert

All columns can be specified. ItemCode, ItemOptionSeq are required.

INSERT INTO ItemOptions#TEMP (ItemCode,  ItemOptionSeq, ItemOptionTitle, ItemOption)  VALUES ('Code0001',  '1', 'title1', 'option1') 

INSERT INTO ItemOptions#TEMP (ItemCode,  ItemOptionSeq, ItemOptionTitle, ItemOption)  VALUES ('Code0001',  '2', 'title2', 'option2') 

INSERT INTO ItemOptions#TEMP (ItemCode,  ItemOptionSeq, ItemOptionTitle, ItemOption)  VALUES ('Code0001',  '3', 'title7', 'option7') 

INSERT INTO ItemOptions SELECT ItemCode,  ItemOptionSeq, ItemOptionTitle, ItemOption FROM ItemOptions#TEMP 

Update

au PAY Market allows updates for all columns. ItemCode, ItemOptionSeq are required.

UPDATE ItemOptions SET ItemOptionTitle = 'title1', ItemOption = 'Code0001' WHERE ItemCode = 'MD001' AND ItemOptionSeq = '1'

Batch Update

au PAY Market allows updates in batches for all columns. ItemCode, ItemOptionSeq are required.

INSERT INTO ItemOptions#TEMP (ItemCode,  ItemOptionSeq, ItemOptionTitle, ItemOption)  VALUES ('Code0001',  '1', 'title1', 'option1') 

INSERT INTO ItemOptions#TEMP (ItemCode,  ItemOptionSeq, ItemOptionTitle, ItemOption)  VALUES ('Code0001',  '2', 'title2', 'option2') 

INSERT INTO ItemOptions#TEMP (ItemCode,  ItemOptionSeq, ItemOptionTitle, ItemOption)  VALUES ('Code0001',  '3', 'title7', 'option7') 

UPDATE ItemOptions SET ( ItemCode,  ItemOptionSeq, ItemOptionTitle, ItemOption ) SELECT  ItemCode,  ItemOptionSeq, ItemOptionTitle, ItemOption FROM ItemOptions#TEMP 

Delete

Delete is not supported for this table

Columns

Name Type ReadOnly References Description
ItemCode [KEY] String False

Items.ItemCode

Product code.

LotNumber Long False

Items.LotNumber

Lot number.

ItemOptionSeq [KEY] String False

Item option squence.

ItemOptionTitle String False

Item option title.

ItemOption String False

Item option value.

ShopId String False

Store account.

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