TABLE OF CONTENTS
Overview
Grain: One row per disbursement per application | Foreign key: application_id → loan_applications.id
Disbursements capture where loan proceeds are directed. A single closing may have multiple disbursements — for example, proceeds to checking plus payoff of an existing loan.
Delivery folders: las_disbursements-1-day and las_disbursements-30-day
This article covers one table. For delivery options, ingestion guidance, the full table relationship diagram, and the export FAQ, see Data Exports: Clutch Lending LOS (LAS).
Things to Know About This Table
- Fields are conditional on
disbursement_type:check_*fields are populated for CHECK only,internal_*for INTERNAL_ACCOUNT only,gl_account_numberfor GENERAL_LEDGER only, andloan_payoff_*for INTERNAL_LOAN_PAYOFF only. - This table has no
idor timestamp columns of its own; it follows its parent closing record.
Important: Because this table has no primary key of its own, deduplicate on the full row (or on
application_idplusdisbursement_typeplusamount) rather than on anidcolumn when you ingest it.
Data Dictionary
| Field Name | Description | Example | Required? |
|---|---|---|---|
application_id | UUID: foreign key to loan_applications. | a1b2c3d4-e5f6-7890-abcd-ef1234567890 | Yes |
partner_id | UUID: your credit union identifier. | 550e8400-e29b-41d4-a716-446655440000 | Yes |
disbursement_type | Enum: disbursement method: CHECK / INTERNAL_ACCOUNT / GENERAL_LEDGER / INTERNAL_LOAN_PAYOFF | INTERNAL_ACCOUNT | Yes |
amount | Decimal: disbursement amount in dollars. | 15000.00 | Yes |
check_payable_to | String: check payee name. Populated for CHECK disbursements only. | Jane Q Doe | No |
check_reference | String: reference or memo line for the check. Populated for CHECK disbursements only. | Loan 1042 proceeds | No |
check_address | String: mailing address for check delivery. Populated for CHECK disbursements only. | 1 Main St, Austin, TX 78701 | No |
check_comment | String: optional comment. Populated for CHECK disbursements only. | Overnight delivery requested | No |
check_number | String: assigned check number at issuance. Populated for CHECK disbursements only. | 100234 | No |
internal_membership_id | String: core system membership ID for the destination account. Populated for INTERNAL_ACCOUNT disbursements only. | 78901 | No |
internal_account_number | String: account number for proceeds deposit. Populated for INTERNAL_ACCOUNT disbursements only. | 0012345678 | No |
internal_account_category | String: account category (for example CHECKING, SAVINGS). Populated for INTERNAL_ACCOUNT disbursements only. | CHECKING | No |
gl_account_number | String: general ledger account number. Populated for GENERAL_LEDGER disbursements only. | GL-4010 | No |
loan_payoff_membership_id | String: membership ID of the loan being paid off. Populated for INTERNAL_LOAN_PAYOFF disbursements only. | 78901 | No |
loan_payoff_loan_id | String: core system loan ID being paid off. Populated for INTERNAL_LOAN_PAYOFF disbursements only. | LN-55231 | No |
How This Table Joins to the Others
application_id→loan_applications.id.- Disbursement rows are nested within the closing record for the same application, so they also line up with closing_information on
application_id.
Was this article helpful?
That’s Great!
Thank you for your feedback
Sorry! We couldn't be helpful
Thank you for your feedback
Feedback sent
We appreciate your effort and will try to fix the article