Database
Company Hierarchy
Unit

Unit

Documentation for the Unit database schema.

Fields

FieldData TypeUsage
companyIdObjectIdUnique reference to company.
nameStringThe name or title of the unit.
branchObjectIdStores the branch data.
clientTypeStringStores the client type data.
codeStringStores the code data.
headOrManagerStringStores the head or manager data.
DescriptionStringDetailed notes or remarks.
AddressStringStores the address data.
cityObjectIdStores the city data.
siteTypeStringStores the site type data.
stateObjectIdTimestamp/Date for state.
buildingStreetStringStores the building street data.
AreaStringStores the area data.
landmarkStringStores the landmark data.
districtObjectIdStores the district data.
postalCodeNumberStores the postal code data.
latitudeNumberTimestamp/Date for latitude.
validatorNumberUnique reference to validator.
longitudeNumberStores the longitude data.
countryStringStores the country data.
phoneStringContact phone number.
openingDateDateTimestamp/Date for openingDate.
closeDateDateTimestamp/Date for closeDate.
CloseRemarksStringDetailed notes or remarks.
locationCodeStringTimestamp/Date for locationCode.
locationNameStringThe name or title of the unit.
clientObjectIdStores the client data.
emailHOStringPrimary email address.
emailSiteStringPrimary email address.
navisionCodeStringStores the navision code data.
bonusBasedOnStringStores the bonus based on data.
emailStringPrimary email address.
faxStringStores the fax data.
loginAllowBooleanStores the login allow data.
dailyAttenAllowBooleanTimestamp/Date for dailyAttenAllow.
EmpLoginAttenAllowBooleanTimestamp/Date for EmpLoginAttenAllow.
WCRemarksStringDetailed notes or remarks.
OTasperStringStores the o tasper data.
ESIonOTBooleanStores the e s ion o t data.
esiOnOThoursBooleanStores the esi on o thours data.
PFonOTBooleanStores the p fon o t data.
pfOnNFHBooleanStores the pf on n f h data.
ESITypeStringStores the e s i type data.
OTCalculateOnDaysNumberTimestamp/Date for OTCalculateOnDays.
OTCalculateOnasperStringTimestamp/Date for OTCalculateOnasper.
OTMultipleNumberStores the o t multiple data.
AttendanceDaysNumberTimestamp/Date for AttendanceDays.
monthDaysNumberStores the month days data.
UnitESINoStringStores the unit e s i no data.
ATMIDStringUnique reference to A T M I D.
segmentStringStores the segment data.
sol_idStringUnique reference to sol_id.
ADRStringStores the a d r data.
specialAttendanceBooleanTimestamp/Date for specialAttendance.
aggregatePFBooleanTimestamp/Date for aggregatePF.
aggregateESIBooleanTimestamp/Date for aggregateESI.
esionnhBooleanStores the esionnh data.
nhUse26DaysBooleanStores the nh use26 days data.
TrustApplicableBooleanStores the trust applicable data.
trustDeductionNumberStores the trust deduction data.
gtliDeductionNumberUnique reference to gtli Deduction.
TraineeBooleanStores the trainee data.
UniformBooleanStores the uniform data.
traineeAmountNumberMonetary or numeric value.
uniformAmountNumberMonetary or numeric value.
upiNumberStores the upi data.
customerStatusStringTimestamp/Date for customerStatus.
surveillanceBooleanStores the surveillance data.
BillableTypeStringStores the billable type data.
insertedUserIdObjectIdUnique reference to inserted User.
updatedUserIdObjectIdUnique reference to updated User.
insertedDateIdDateUnique reference to inserted Date.
updatedDateIdDateUnique reference to updated Date.
isDeletedBooleanStores the is deleted data.
statusBooleanTimestamp/Date for status.
deletedByObjectIdStores the deleted by data.
deletedTimeDateTimestamp/Date for deletedTime.