Excel Add-In for BCart

Build 22.0.8503

Orders

Returns data from Orders 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.
  • Custom field columns support the following operator: =.
For example, the following query is processed server side:
    SELECT * FROM Orders WHERE CustomerCompName = 'Sample Customer'
    SELECT * FROM Orders WHERE Id IN (1,10)
    SELECT * FROM Orders WHERE OrderedAt <= '2019-09-26 09:20:45'

Insert

Insert is not supported for this table.

Update

BCart allows updates for CustomerCompName, Memo and the non-read-only columns.

    UPDATE Orders SET CustomerCompName = 'Sample Customer' WHERE Id = 2

Bulk Update


    INSERT INTO Orders#TEMP (Id,CustomerCompName,Memo) VALUES(1,'Sample Customer 1','Sample Memo')
    INSERT INTO Orders#TEMP (Id,CustomerCompName,Memo) VALUES(2,'Sample Customer 2','Sample Memo')
    UPDATE Orders (Id,CustomerCompName,Memo) SELECT Id,CustomerCompName,Memo FROM Orders#TEMP

Delete

Delete is not supported for this table.

Columns

Name Type ReadOnly Description
Id [KEY] Integer True

Code String True

CustomerId Integer False

CustomerExtId String False

CustomerParentId Integer False

CustomerSalesmanId String False

CustomerCompName String False

CustomerDepartment String False

CustomerName String False

CustomerTel String False

CustomerMobilePhone String False

CustomerEmail String False

CustomerPriceGroupId String False

CustomerZip String False

CustomerPref String False

CustomerAddress1 String False

CustomerAddress2 String False

CustomerAddress3 String False

Payment String False

PaymentAt Date False

TotalPrice Decimal True

Tax Decimal True

TaxRate String True

CODCost Decimal True

ShippingCost Decimal True

FinalPrice Decimal True

UsePoint Integer True

GetPoint Integer True

OrderTotals String True

CustomerMessage String False

AdminMessage String False

Memo String False

Enquete1 String False

Enquete2 String False

Enquete3 String False

Enquete4 String False

Enquete5 String False

OrderedAt Datetime True

AffiliateId String True

EstimateId String False

Status String False

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