xMatix
Sign in Request demo
xMatix
PRODUCTS
SalesField SalesCRMRewardsClaimsInventoryProcurementWarehouse ManagementField ServiceServiceSupportTelephony & MessagingFinance & AccountingPayrollExpense ManagementCommercePortalsAnalytics & ReportingData StudioMobile AppSee all products →
PLATFORM
Platform overviewApp BuilderAutomationIntegrationsSecurity & GovernanceChange ManagementDevelopers
SENSE AI
Sense AI overviewSense AssistSense ControlSense VisionAI StudioTrust & governanceIn Claude & ChatGPTUse cases
SOLUTIONS
FMCG & DistributionManufacturing & Dealer NetworksAutomotive & DealershipsPharma & HealthcareConsumer DurablesAgri-InputsBuilding MaterialsService NetworksWarehousing & 3PLFinancial AccountingERP SoftwareIndia GST ComplianceUAE VAT & e-InvoicingSaudi ZATCA & VATAll solutions →
RESOURCES
Knowledge CenterDeveloper & CLIBlogGuidesWhat is xMatix?Company facts
COMPANY
AboutCareersPartnersEventsContactAuthorsLegal
Sign in Request demo
Home/Docs/Entity Reference/Loan Recovery — entity reference
REFERENCE · Last reviewed

Loan Recovery — entity reference

The audit row for one installment taken out of one payroll run against a loan or advance; the payroll calculation writes these, users do not create them. Each row records the amount recovered and the loan balance immediately after that recovery, so reading the rows in payroll-run order reconstructs the repayment history without recomputing anything. Recalculating a payroll run adds each row's amount back onto the loan balance and its open item before soft-deleting the row, so a deleted recovery means the money was returned to the loan rather than lost.

Fields

FieldLabelTypeRequiredWhat it does
AmountAmountCurrency
CreatedByIdCreated ByLookup → UserAccountYes
CreatedDateTimeCreated DateDateAndTimeYes
IdIdGuidYes
LabelLabelText
LoanAdvanceIdLoan AdvanceLookup → LoanAdvance
ModifiedByIdModified ByLookup → UserAccountYes
NameNameText, uniqueYes
OutstandingAfterOutstanding AfterCurrencyThe loan balance immediately after this installment was taken, written once at calculation time. It is a point-in-time snapshot rather than a live figure, so reading the rows in run order reconstructs the repayment history without recomputing anything.
OwnerIdOwnerLookup → UserAccountYes
PartnerAccountIdPartner AccountLookup → Account
PayrollPeriodIdPayroll PeriodLookup → PayrollPeriod
PayrollRunIdPayroll RunLookup → PayrollRunThe run that took this installment. Recalculating that run adds this amount back onto the loan and its open item before soft-deleting the row, so recovery rows exist strictly per surviving run.
RecordTypeIdRecord TypeGuid, hidden
ResourceIdResourceLookup → Resource
UIPropsUI PropsText
UpdatedDateTimeModified DateDateAndTimeYes

Actions

ActionLabelTypeWhat it does
CloneCloneServerAction (Clone)Create a copy of this record
DeleteDeleteDeleteDelete this LoanAdvanceRecovery.
DeleteEntityDeleteDeleteDeleteEntity
DeleteHeaderDeleteDeleteDeleteHeader
EditEditEditEdit this LoanAdvanceRecovery.
EditEntityEditEditEditEntity
EditInLineEditEditInlineEditInLine
NewNewNewInlineCreate a LoanAdvanceRecovery.
ViewViewViewView this LoanAdvanceRecovery.