Skip to content
Docs

Funding transaction

One row per funding transaction, including every ACH attempt and direct debt cash disbursement.

View as Markdown
On this page· 2 sections
Report typeOne row perDefault delivery
funding_transactionFunding transaction (0 to many per loan)Daily at 02:45, 06:45, 10:45, 14:45, 18:45, and 22:45 UTC
Report type
funding_transaction
One row per
Funding transaction (0 to many per loan)
Default delivery
Daily at 02:45, 06:45, 10:45, 14:45, 18:45, and 22:45 UTC

About this export#

  • 1 row per funding transaction
  • 0 to many rows per loan
  • Every ACH funding attempt will have its own row
    • ACH re-attempts will have the same loan_uuid_value and loan_funding_attempt_number incremented by 1
  • Direct debt (Intellidebt) cash disbursements will have is_liability_payoff_cash_disbursement set to true
    • A Direct debt cash disbursement makes the borrower whole in the event of a lower-than-reported liability balance (e.g., payoff amount was $10,000 but the actual balance at funding time was $9,500, so a $500 cash disbursement is made to the borrower)

Fields#

funding-transaction.csv
#FieldDescription
1funding_transaction_id
stringAlways setAdded 2023-09-14
—
2loan_uuid_value
stringAlways setAdded 2023-06-23
—
3loan_short_id
stringAlways setAdded 2023-06-23
—
4organization
stringAlways setAdded 2023-06-23
—
5funding_amount
floatAlways setAdded 2023-06-23
—
6funding_initiated_timestamp
timestampNullableAdded 2023-06-23
—
7funding_initiated_datetime_pst
datetime (pacific time)NullableAdded 2023-06-23
—
8nacha_message_uuid
stringNullableAdded 2023-06-23
—
9loan_funding_attempt_number
integerNullableAdded 2023-06-23
—
10batching_status
stringAlways setAdded 2023-06-23

Values

  • PENDING BATCHING
  • RETURNED
  • SENT - REATTEMPT
  • SENT
11nacha_sent_timestamp
timestamp (utc)NullableAdded 2023-06-23
—
12nacha_sent_datetime_pst
datetime (pacific time)NullableAdded 2023-06-23
—