Returns data from OrderProducts 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: =.
• Options column does not support server side operators.

For example, the following query is processed server side:

    SELECT * FROM OrderProducts WHERE ProductName = 'Sample Order Product'
    SELECT * FROM OrderProducts WHERE OrderId IN (1,10)
    SELECT * FROM OrderProducts WHERE ShippingSize <= 10

Insert

Insert is not supported for this table.

Update

BCart allows updates for ProductName, MainNo and the non-read-only columns.

    UPDATE OrderProducts SET ProductName = 'Sample Order Product' WHERE Id = 2

Bulk Update

    INSERT INTO OrderProducts#TEMP (Id,ProductName,MainNo) VALUES(1,'Sample Order Product 1','1')
    INSERT INTO OrderProducts#TEMP (Id,ProductName,MainNo) VALUES(2,'Sample Order Product 2','2')
    UPDATE OrderProducts (Id,ProductName,MainNo) SELECT Id,ProductName,MainNo FROM OrderProducts#TEMP

Delete

Delete is not supported for this table.

Columns

Name	Type	ReadOnly	Description
Id [KEY]	Integer	True
OrderId	Integer	False
LogisticsId	Integer	False
ProductId	Integer	False
MainNo	String	False
ProductNo	String	False
JanCode	String	False
LocationNo	String	False
ProductName	String	False
ProductSetId	Integer	False
SetName	String	False
UnitPrice	Decimal	True
SetQuantity	Integer	True
SetUnit	String	False
OrderProCount	Integer	True
ShippingSize	Integer	False
TaxRate	String	True
TaxTypeId	Integer	True
TaxIncl	Integer	True
ItemType	String	True
Options	String	True