Database
Payroll
Settings
SalaryCompanyConfigMaster

SalaryCompanyConfigMaster

Documentation for the SalaryCompanyConfigMaster database schema.

Fields

FieldData TypeUsage
anyIdObjectIdUnique reference to any.
providentFundPercentageNumberUnique reference to provident Fund Percentage.
providentFundMaximumLimitNumberUnique reference to provident Fund Maximum Limit.
pensionLimitNumberStores the pension limit data.
account1PercentageNumberStores the account1 percentage data.
account10PercentageNumberStores the account10 percentage data.
account2PercentageNumberStores the account2 percentage data.
account21PercentageNumberStores the account21 percentage data.
account22PercentageNumberStores the account22 percentage data.
esiPercentageNumberStores the esi percentage data.
esiMaximumLimitNumberStores the esi maximum limit data.
providentFundApplicableBooleanUnique reference to provident Fund Applicable.
providentFundNumberStringUnique reference to provident Fund Number.
voluntaryProvidentFundApplicableBooleanUnique reference to voluntary Provident Fund Applicable.
esiApplicableBooleanStores the esi applicable data.
esiNumberStringStores the esi number data.
esiLocalOfficeStringStores the esi local office data.
professionalTaxApplicableBooleanStores the professional tax applicable data.
professionalTaxCertificateNumberStringTimestamp/Date for professionalTaxCertificateNumber.
professionalTaxOfficeCircleNumberStringStores the professional tax office circle number data.
tdsApplicableBooleanStores the tds applicable data.
gratuityApplicableBooleanTimestamp/Date for gratuityApplicable.
esiRoundOffNumberStores the esi round off data.
providentFundRoundOffNumberUnique reference to provident Fund Round Off.
esiEmrPercentageNumberStores the esi emr percentage data.
dbfFileCodeStringStores the dbf file code data.
dbfFileExtensionStringStores the dbf file extension data.
bonusPercentageNumberStores the bonus percentage data.
bonusMaxLimitNumberStores the bonus max limit data.
lettersNumberStringStores the letters number data.
corporateIdStringUnique reference to corporate.
locationCodePrefixStringTimestamp/Date for locationCodePrefix.
locationCodeMaxNumberTimestamp/Date for locationCodeMax.
isLocationCodeAutoBooleanTimestamp/Date for isLocationCodeAuto.
lwfApplicableBooleanStores the lwf applicable data.
employeeIdObjectIdUnique reference to employee.
insertedUserIdObjectIdUnique reference to inserted User.
updatedUserIdObjectIdUnique reference to updated User.
insertedDateIdObjectIdUnique reference to inserted Date.
updatedDateIdObjectIdUnique reference to updated Date.
isDeletedBooleanStores the is deleted data.
statusBooleanTimestamp/Date for status.
deletedByObjectIdStores the deleted by data.
deletedTimeDateTimestamp/Date for deletedTime.