Database
Company Hierarchy
branch

branch

Documentation for the branch database schema.

Fields

FieldData TypeUsage
companyIdObjectIdUnique reference to company.
nameStringThe name or title of the branch.
regionalOfficeObjectIdStores the regional office data.
codeStringStores the code data.
companyEsiCodeStringStores the company esi code data.
addressStringStores the address data.
countryStringStores the country data.
cityStringStores the city data.
stateStringTimestamp/Date for state.
postalCodeNumberStores the postal code data.
contactPersonStringStores the contact person data.
contactNumberStringStores the contact number data.
emailStringPrimary email address.
openingDateStringTimestamp/Date for openingDate.
numberofEmployeesNumberStores the numberof employees data.
remarksStringDetailed notes or remarks.
branchManagerObjectIdStores the branch manager data.
regionManagerObjectIdStores the region manager data.
isDeletedBooleanStores the is deleted data.
statusBooleanTimestamp/Date for status.
deletedByObjectIdStores the deleted by data.
deletedTimeDateTimestamp/Date for deletedTime.