ItemDeliveries
Retrieve and update information related to item deliveries.
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 ItemDeliveries WHERE ItemCode LIKE '%CD00%'
SELECT * FROM ItemDeliveries WHERE ItemCode = 'CD001' AND LotNumber = 123543
Insert
All columns can be specified. ItemCode, DeliveryId, DeliverySeq are required for an insert.
INSERT INTO ItemDeliveries (ItemCode, LotNumber, DeliveryId, DeliverySeq) VALUES ('Code0001', '9804120', '10', 1)
Batch Insert
All columns can be specified. ItemCode, DeliveryId, DeliverySeq are required.
INSERT INTO ItemDeliveries#TEMP (ItemCode, LotNumber, DeliveryId, DeliverySeq) VALUES ('Code0001', '9804120', '10', 1)
INSERT INTO ItemDeliveries#TEMP (ItemCode, LotNumber, DeliveryId, DeliverySeq) VALUES ('Code0001', '9804120', '11', 2)
INSERT INTO ItemDeliveries#TEMP (ItemCode, LotNumber, DeliveryId, DeliverySeq) VALUES ('Code0001', '9804120', '12', 3)
INSERT INTO ItemDeliveries SELECT ItemCode, LotNumber, DeliveryId, DeliverySeq FROM ItemDeliveries#TEMP
Update
au PAY Market allows updates for all columns. ItemCode, DeliveryId are required.
UPDATE ItemDeliveries SET DeliveryId = '10', DeliverySeq = 1 WHERE ItemCode = 'Code0001' AND LotNumber = 9804120
Batch Update
au PAY Market allows updates in batches for all columns. ItemCode, DeliveryId are required.
INSERT INTO ItemDeliveries#TEMP (ItemCode, LotNumber, DeliveryId, DeliverySeq) VALUES ('Code0001', '9804120', '10', 1)
INSERT INTO ItemDeliveries#TEMP (ItemCode, LotNumber, DeliveryId, DeliverySeq) VALUES ('Code0001', '9804120', '11', 2)
INSERT INTO ItemDeliveries#TEMP (ItemCode, LotNumber, DeliveryId, DeliverySeq) VALUES ('Code0001', '9804120', '12', 3)
UPDATE ItemDeliveries SET (ItemCode, LotNumber, DeliveryId, StockSegment) SELECT ItemCode, LotNumber, DeliveryId, DeliverySeq FROM ItemDeliveries#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. |
DeliveryId [KEY] | String | False |
Delivery id. | |
DeliverySeq | String | False |
Delivery sequence. | |
ShopId | String | False |
Store account. |