Database
Company Hierarchy
Company

Company

Documentation for the Company database schema.

Fields

FieldData TypeUsage
nameStringThe name or title of the company.
shortNameStringThe name or title of the company.
groupObjectIdStores the group data.
bankIdObjectIdUnique reference to bank.
bankAccountNoStringStores the bank account no data.
codeStringStores the code data.
locationStringTimestamp/Date for location.
structureStringStores the structure data.
addressStringStores the address data.
isHeadOfficeBooleanStores the is head office data.
countryStringStores the country data.
stateOrProvinceStringTimestamp/Date for stateOrProvince.
cityStringStores the city data.
postalCodeNumberStores the postal code data.
companyLogoStringStores the company logo data.
contactPersonStringStores the contact person data.
emailStringPrimary email address.
websiteStringStores the website data.
phoneNoNumberContact phone number.
mobileNumberContact phone number.
faxNoStringStores the fax no data.
registrationNoStringTimestamp/Date for registrationNo.
serviceTaxNoStringStores the service tax no data.
tanNoStringStores the tan no data.
isActiveBooleanActive status flag.
isDeletedBooleanStores the is deleted data.
statusBooleanTimestamp/Date for status.
deletedByObjectIdStores the deleted by data.
deletedTimeDateTimestamp/Date for deletedTime.