Returns data from Logistics table.

Select

The 本製品 will use the BCart API to process WHERE clause conditions built with the following columns and operators. The rest of the filter is executed client side within the 本製品.

• Most of the columns support the following operators: <, >, <=, >=, =, !=, IN, NOT_IN.

For example, the following query is processed server side:

    SELECT * FROM Logistics WHERE Name = 'Sample Product'
    SELECT * FROM Logistics WHERE ShippingGroupId IN (1,10)
    SELECT * FROM Logistics WHERE ShipmentDate <= '2019-09-26 09:20:45'

Insert

Insert is not supported for this table.

Update

BCart allows updates for ShipmentCode, DeliveryCode and the non-read-only columns.

    UPDATE Logistics ShipmentCode = '123' WHERE Id = 20000001

Bulk Update

    INSERT INTO Logistics#TEMP (Id,ShipmentCode,Name) VALUES(20000001,'Sample ShipmentCode 1','Sample Name 1')
    INSERT INTO Logistics#TEMP (Id,ShipmentCode,Name) VALUES(20000002,'Sample ShipmentCode 2','Sample Name 2')
    UPDATE Logistics (Id,ShipmentCode,Name) SELECT Id,ShipmentCode,Name FROM Logistics#TEMP

Delete

Delete is not supported for this table.

Columns

Name	Type	ReadOnly	Description
Id [KEY]	Integer	True
ShipmentCode	String	False
DeliveryCode	String	False
DestinationCode	String	False
ShippingGroupId	Integer	False
CompName	String	False
Department	String	False
Name	String	False
Zip	String	False
Pref	String	False
Address1	String	False
Address2	String	False
Address3	String	False
Tel	String	False
DueDate	Date	False
DueTime	String	False
Memo	String	False
ShipmentDate	Date	False
Status	String	False