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

For example, the following query is processed server side:

    SELECT * FROM Customers WHERE CompName = 'Sample Company'
    SELECT * FROM Customers WHERE ParentId IN (1,10)
    SELECT * FROM Customers WHERE UpdatedAt <= '2019-09-26 09:20:45'

Insert

To add a Customers, specify TantoLastName, Zip, Pref, Address1, Address2, Password and the non-read-only columns.

    INSERT INTO Customers(TantoLastName,Zip,Pref,Address1,Address2,Password)VALUES('Tanto','123-4567','Miyagi','Sendai','CData','PASSWPRD')

Bulk Insert

    INSERT INTO Customers#TEMP(TantoLastName,Zip,Pref,Address1,Address2,Password)VALUES('Tanto 1','123-4567','Miyagi','Sendai','CData','PASSWPRD')
    INSERT INTO Customers#TEMP(TantoLastName,Zip,Pref,Address1,Address2,Password)VALUES('Tanto 2','123-4567','Miyagi','Sendai','CData','PASSWPRD')
    INSERT INTO Customers (Name,CategoryId) SELECT Name,CategoryId FROM Customers#TEMP

Update

BCart allows updates for TantoLastName, Zip and the non-read-only columns.

    UPDATE Customers SET TantoLastName = 'Sample TantoLastName' WHERE Id = 2

Bulk Update

    INSERT INTO Customers#TEMP (Id,TantoLastName,Address1) VALUES(1,'Sample TantoLastName 1','Sendai')
    INSERT INTO Customers#TEMP (Id,TantoLastName,Address1) VALUES(2,'Sample TantoLastName 2','Sendai')
    UPDATE Customers (Id,TantoLastName,Address1) SELECT Id,TantoLastName,Address1 FROM Customers#TEMP

Delete

Delete is not supported for this table.

Columns

Name	Type	ReadOnly	Description
Id [KEY]	Integer	True
ExtId	String	False
AgentId	String	False
AgentRate	String	False
ParentId	Integer	False
DestinationCode	String	False
CompName	String	False
CompNameKana	String	False
CeoLastName	String	False
CeoFirstName	String	False
CeoLastNameKana	String	False
CeoFirstNameKana	String	False
Department	String	False
TantoLastName	String	False
TantoFirstName	String	False
TantoLastNameKana	String	False
TantoFirstNameKana	String	False
Zip	String	False
Pref	String	False
Address1	String	False
Address2	String	False
Address3	String	False
Email	String	False
EmailCc	String	False
Tel	String	False
MobilePhone	String	False
Fax	String	False
Url	String	False
Foundation	String	False
Sales	Integer	False
Job	String	False
Memo	String	False
Payment	String	False
SpecialShippingCost	String	False
Paid	String	True
SpecialView	Integer	False
MmFlag	Integer	False
Point	Integer	False
PriceGroupId	Integer	False
ViewGroupId	Integer	False
SalesmanId	String	False
AfId	String	False
CutoffDate	String	False
PaymentMonth	String	False
PaymentDate	String	False
DefaultOtherShippingId	Integer	False
DefaultPayment	String	False
HiddenPrice	Integer	False
Status	String	False
Password	String	False
CreatedAt	Datetime	False
UpdatedAt	Datetime	False