Database
Payroll
Payroll Master
Common
CommonClientDetails

CommonClientDetails

Documentation for the CommonClientDetails database schema.

Fields

FieldData TypeUsage
anyIdObjectIdUnique reference to any.
companyCodeStringStores the company code data.
contactPersonStringStores the contact person data.
companyNameStringThe name or title of the commonclientdetails.
clientTypeStringStores the client type data.
clientCategoryStringTimestamp/Date for clientCategory.
industryTypeObjectIdStores the industry type data.
creationDateDateTimestamp/Date for creationDate.
emailStringPrimary email address.
websiteStringStores the website data.
faxNumberStringStores the fax number data.
grossPFESIApplicableBooleanStores the gross p f e s i applicable data.
phoneStringContact phone number.
mobileStringContact phone number.
alternateContactNumberStringTimestamp/Date for alternateContactNumber.
designationStringTimestamp/Date for designation.
emailIdsStringUnique reference to emails.
addressLine1StringStores the address line1 data.
addressLine2StringStores the address line2 data.
numberOfUsersNumberStores the number of users data.
numberOfLocationsNumberTimestamp/Date for numberOfLocations.
validityFromDateUnique reference to validity From.
validityToDateUnique reference to validity To.
companyLogoStringStores the company logo data.
companyLogoByteBufferStores the company logo byte data.
isActiveBooleanActive status flag.
remarksStringDetailed notes or remarks.
isDeletedBooleanStores the is deleted data.
statusBooleanTimestamp/Date for status.
deletedByObjectIdStores the deleted by data.
deletedTimeDateTimestamp/Date for deletedTime.