Database
Salary
SAL_LoanTransaction_Mst

SAL_LoanTransaction_Mst

Documentation for the SAL_LoanTransaction_Mst database schema.

Fields

FieldData TypeUsage
companyIdObjectIdUnique reference to company.
loanIdStringUnique reference to loan.
loanCodeStringStores the loan code data.
headIdObjectIdUnique reference to head.
allotmentIdStringUnique reference to allotment.
loanDateDateTimestamp/Date for loanDate.
employeeIdObjectIdUnique reference to employee.
loanNatureIdStringUnique reference to loan Nature.
remarksStringDetailed notes or remarks.
isDeletedBooleanStores the is deleted data.
createdByObjectIdTimestamp/Date for createdBy.
updatedByObjectIdTimestamp/Date for updatedBy.
createdDateIdObjectIdUnique reference to created Date.
updatedDateIdObjectIdUnique reference to updated Date.
timestampDateTimestamp/Date for timestamp.