Excel Add-In for BCart

Build 22.0.8503

Logistics

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

Copyright (c) 2023 CData Software, Inc. - All rights reserved.
Build 22.0.8503