Company

The table below describes the Company table.

This table contains the following virtual tables:

• CompanyStreet
• CompanyFilter
• CompanySortOrders

None of the columns in this table are updatable.

This table contains the following foldable columns:

• Id
• Applicable_Payment_Method
• Applicable_Shipping_Method
• Available_Payment_Methods
• Available_Shipping_Methods
• City
• Comment
• Company_Email
• Company_Name
• Country_Id
• Customer_Group_Id
• Is_Purchase_Order_Enabled
• Legal_Name
• Postcode
• Quote_Config_Company_Id
• Quote_Config_Is_Quote_Enabled
• Region
• Region_Id
• Reject_Reason
• Rejected_At
• Reseller_Id
• Sales_Representative_Id
• Status
• Super_User_Id
• Telephone
• Use_Config_Settings
• Use_Config_Settings_Shipping
• Vat_Tax_Id

This table does not contain Return Primary Key columns.

Column Name	SQL Type	Nullable
Id Primary Key	SQL_INTEGER(unsigned)	False
Applicable_Payment_Method	SQL_INTEGER(unsigned)	True
Applicable_Shipping_Method	SQL_INTEGER(unsigned)	True
Available_Payment_Methods	SQL_VARCHAR(255)	True
Available_Shipping_Methods	SQL_VARCHAR(255)	True
City	SQL_VARCHAR(255)	True
Comment	SQL_VARCHAR(255)	True
Company_Email	SQL_VARCHAR(255)	True
Company_Name	SQL_VARCHAR(255)	True
Country_Id	SQL_VARCHAR(255)	True
Customer_Group_Id	SQL_INTEGER(unsigned)	False
Is_Purchase_Order_Enabled	SQL_BIT	True
Legal_Name	SQL_VARCHAR(255)	True
Postcode	SQL_VARCHAR(255)	True
Quote_Config_Company_Id	SQL_VARCHAR(255)	True
Quote_Config_Is_Quote_Enabled	SQL_BIT	False
Region	SQL_VARCHAR(255)	True
Region_Id	SQL_VARCHAR(255)	True
Reject_Reason	SQL_VARCHAR(255)	False
Rejected_At	SQL_VARCHAR(255)	False
Reseller_Id	SQL_VARCHAR(255)	True
Sales_Representative_Id	SQL_INTEGER(unsigned)	False
Status	SQL_INTEGER(unsigned)	True
Super_User_Id	SQL_INTEGER(unsigned)	False
Telephone	SQL_VARCHAR(255)	True
Use_Config_Settings	SQL_INTEGER(unsigned)	True
Use_Config_Settings_Shipping	SQL_INTEGER(unsigned)	True
Vat_Tax_Id	SQL_VARCHAR(255)	True