Database
Leaveandattendance
salLeaveEncashmentDetailsModel

salLeaveEncashmentDetailsModel

Documentation for the salLeaveEncashmentDetailsModel database schema.

Fields

FieldData TypeUsage
anyIdObjectIdUnique reference to any.
encashmentIdStringUnique reference to encashment.
employeeIdObjectIdUnique reference to employee.
leaveIdObjectIdUnique reference to leave.
transactionDateDateTimestamp/Date for transactionDate.
balanceLeavemongoose.Types.Decimal128Stores the balance leave data.
totalLeaveEncashmentmongoose.Types.Decimal128Stores the total leave encashment data.
encashmentAmountmongoose.Types.Decimal128Monetary or numeric value.
payableAmountmongoose.Types.Decimal128Monetary or numeric value.
monthIdObjectIdUnique reference to month.
yearIdObjectIdUnique reference to year.
employeeAc1mongoose.Types.Decimal128Stores the employee ac1 data.
employerAc1mongoose.Types.Decimal128Stores the employer ac1 data.
accountAc10mongoose.Types.Decimal128Stores the account ac10 data.
accountAc2mongoose.Types.Decimal128Stores the account ac2 data.
accountAc21mongoose.Types.Decimal128Stores the account ac21 data.
accountAc22mongoose.Types.Decimal128Stores the account ac22 data.
totalEmployeeAmountmongoose.Types.Decimal128Monetary or numeric value.
totalEmployerAmountmongoose.Types.Decimal128Monetary or numeric value.
totalAdminAmountmongoose.Types.Decimal128Monetary or numeric value.
totalPayableAmountmongoose.Types.Decimal128Monetary or numeric value.
isPaidBooleanUnique reference to is Paid.
remarksStringDetailed notes or remarks.
insertedUserIdObjectIdUnique reference to inserted User.
updatedUserIdObjectIdUnique reference to updated User.
insertedDateIdObjectIdUnique reference to inserted Date.
updatedDateIdObjectIdUnique reference to updated Date.
timestampDateTimestamp/Date for timestamp.