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