ItemDeliveryMethods
Retrieve and information related to item delivery methods.
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.
SELECT * FROM ItemDeliveryMethods WHERE ItemCode LIKE '%CD00%'
SELECT * FROM ItemDeliveryMethods WHERE ItemCode = 'CD001' AND LotNumber = 123543
Insert
All columns can be specified. ItemCode, DeliveryMethodId, DeliveryMethodSeq are required for an insert.
INSERT INTO ItemDeliveryMethods (ItemCode, LotNumber, DeliveryMethodId, DeliveryMethodSeq) VALUES ('MD001', '9808450', 'M', 1)
Batch Insert
All columns can be specified. ItemCode, DeliveryMethodId, DeliveryMethodSeq are required.
INSERT INTO ItemDeliveryMethods#TEMP (ItemCode, LotNumber, DeliveryMethodId, DeliveryMethodSeq) VALUES ('MD001', '9808450', 'M', 1)
INSERT INTO ItemDeliveryMethods#TEMP (ItemCode, LotNumber, DeliveryMethodId, DeliveryMethodSeq) VALUES ('MD001', '9808450', 'S', 2)
INSERT INTO ItemDeliveryMethods#TEMP (ItemCode, LotNumber, DeliveryMethodId, DeliveryMethodSeq) VALUES ('MD001', '9808450', 'F', 3)
INSERT INTO ItemDeliveryMethods SELECT ItemCode, LotNumber, DeliveryMethodId, DeliveryMethodSeq FROM ItemDeliveryMethods#TEMP
Update
au PAY Market allows updates for all columns. ItemCode, DeliveryMethodId are required.
UPDATE ItemDeliveryMethods SET DeliveryMethodId = 'M', DeliveryMethodSeq = 1 WHERE ItemCode = 'MD001' AND LotNumber = '9808450'
Batch Update
au PAY Market allows updates in batches for all columns. ItemCode, DeliveryMethodId are required.
INSERT INTO ItemDeliveryMethods#TEMP (ItemCode, LotNumber, DeliveryMethodId, DeliveryMethodSeq) VALUES ('MD001', '9808450', 'M', 1)
INSERT INTO ItemDeliveryMethods#TEMP (ItemCode, LotNumber, DeliveryMethodId, DeliveryMethodSeq) VALUES ('MD001', '9808450', 'S', 2)
INSERT INTO ItemDeliveryMethods#TEMP (ItemCode, LotNumber, DeliveryMethodId, DeliveryMethodSeq) VALUES ('MD001', '9808450', 'F', 3)
UPDATE ItemDeliveryMethods SET ( ItemCode, LotNumber, DeliveryMethodId, DeliveryMethodSeq ) SELECT ItemCode, LotNumber, DeliveryMethodId, DeliveryMethodSeq FROM ItemDeliveryMethods#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. |
DeliveryMethodId [KEY] | String | False |
Delivery method id. | |
DeliveryMethodSeq | String | False |
Delivery method sequence. | |
DeliveryMethodName | String | False |
Delivery method name. | |
ShopId | String | False |
Store account. |