Database
Payroll
Transactions
SalaryRecovery

SalaryRecovery

Documentation for the SalaryRecovery database schema.

Fields

FieldData TypeUsage
companyIdObjectIdUnique reference to company.
empCodeStringStores the emp code data.
employeeIdObjectIdUnique reference to employee.
amountNumberMonetary or numeric value.
monthStringStores the month data.
yearStringStores the year data.
unitObjectIdStores the unit data.
salaryProcessIdObjectIdUnique reference to salary Process.
attendanceIdObjectIdUnique reference to attendance.
isRecoveredBooleanStores the is recovered data.
recoveredAmountNumberMonetary or numeric value.
remainingAmountNumberMonetary or numeric value.
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.