SSIS Components for au PAY Market

Build 24.0.9062

ItemSpecifications

Retrieve and update information related to item specifications.

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

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

Insert

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

INSERT INTO ItemSpecifications (ItemCode, LotNumber, SpecificationName, Specificationseq) VALUES ('MD001', '9808450', 'M', 1)

Batch Insert

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

INSERT INTO  ItemSpecifications#TEMP  (ItemCode, LotNumber, SpecificationName, SpecificationValue, SpecificationSeq) VALUES ('MD001', '9808450', 'TESTtt  1', 'val1', 1)  

INSERT INTO  ItemSpecifications#TEMP  (ItemCode, LotNumber, SpecificationName, SpecificationValue, SpecificationSeq) VALUES ('MD001', '9808450', 'i dyti ', 'val2', 2)  
;
INSERT INTO  ItemSpecifications#TEMP  (ItemCode, LotNumber, SpecificationName, SpecificationValue, SpecificationSeq) VALUES ('MD001', '9808450', 'er', 'val3', 3) 

INSERT INTO   ItemSpecifications  SELECT ItemCode, LotNumber, ImageId, SpecificationSeq FROM ItemSpecifications#TEMP  

Update

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

UPDATE ItemSpecifications SET SpecificationName = 'M', Specificationseq = 1 WHERE ItemCode = 'MD001' AND LotNumber = 9808450

Batch Update

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

INSERT INTO  ItemSpecifications#TEMP  (ItemCode, LotNumber, SpecificationName, SpecificationValue, SpecificationSeq) VALUES ('MD001', '9808450', 'TESTtt  1', 'val1', 1)  

INSERT INTO  ItemSpecifications#TEMP  (ItemCode, LotNumber, SpecificationName, SpecificationValue, SpecificationSeq) VALUES ('MD001', '9808450', 'i dyti ', 'val2', 2)  
;
INSERT INTO  ItemSpecifications#TEMP  (ItemCode, LotNumber, SpecificationName, SpecificationValue, SpecificationSeq) VALUES ('MD001', '9808450', 'er', 'val3', 3) 

UPDATE ItemSpecifications SET (ItemCode, LotNumber, SpecificationName, SpecificationValue, SpecificationSeq ) SELECT  ItemCode, LotNumber, SpecificationName, SpecificationValue, SpecificationSeq  FROM ItemSpecifications#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.

SpecificationTitle String True

Specification title.

SpecificationSeq [KEY] String False

Specification item sequence.

SpecificationName String False

Specification name.

SpecificationValue String False

Specification value.

ShopId String False

Store account.

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