Database
Payroll
Payroll Master
Common
CompanyHeadMaster

CompanyHeadMaster

Documentation for the CompanyHeadMaster database schema.

Fields

FieldData TypeUsage
companyIdObjectIdUnique reference to company.
descriptionStringDetailed notes or remarks.
shortDescriptionStringDetailed notes or remarks.
headIdNumberUnique reference to head.
headTypeStringStores the head type data.
deductionTypeStringStores the deduction type data.
headFixedIdObjectIdUnique reference to head Fixed.
mappingBooleanStores the mapping data.
amountNumberMonetary or numeric value.
formulaIdObjectIdUnique reference to formula.
displayOrderNumberStores the display order data.
orderLevelNumberStores the order level data.
taxableStringStores the taxable data.
nonTaxableLimitNumberStores the non taxable limit data.
chapterVITypeStringStores the chapter v i type data.
subofBillSubmissionBooleanStores the subof bill submission data.
underSectionStringStores the under section data.
calculateInterestBooleanTimestamp/Date for calculateInterest.
interestPercentageNumberStores the interest percentage data.
parentHeadIdObjectIdUnique reference to parent Head.
roundingStringStores the rounding data.
salaryRegisterShowFlagBooleanStores the salary register show flag data.
activeBooleanStores the active data.
blockSummationBooleanTimestamp/Date for blockSummation.
providentFundGrossPartBooleanUnique reference to provident Fund Gross Part.
employeeStateInsuranceGrossPartBooleanTimestamp/Date for employeeStateInsuranceGrossPart.
grossPartBooleanStores the gross part data.
OTRateHoursNumberTimestamp/Date for OTRateHours.
AttendBonusRateNumberTimestamp/Date for AttendBonusRate.
AttendBonusDaysLimitNumberTimestamp/Date for AttendBonusDaysLimit.
otGrossBooleanStores the ot gross data.
nfhgrossBooleanStores the nfhgross data.
presenceDependentBooleanStores the presence dependent data.
EffectTypeStringStores the effect type data.
ImportDescStringStores the import desc data.
remarksStringDetailed notes or remarks.
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.
esiGrossPartBooleanStores the esi gross part data.