Transactions balance report files
The Transactions balance report contains the transactions balances from the previous day. The files for this job are saved in your designated cloud storage container in the reports/transactions_balance/ subfolder. See Report file generation and path for more information.
The following table lists the Transactions balance report fields.
The report's decimal values are rounded to the hundredths.
| Field | Type | Description |
|---|---|---|
| Org_ID | string | Organization ID |
| RefDate | timestamp | File creation date |
| Account_ID | int | Account ID |
| Statement_ID | int | Statement ID |
| Balance | double | Invoice balance |
| CicleClosingDate | date | Cycle closing date |
| DueDate | date | Due date |
| DueDays | int | Number of days the account has been in arrears |
| Type | string | Balance record type:ROTATIVOCREDORCORRENTECORTADAFUTURA |
| Program_ID | int | Program ID |
| ProgramName | string | Program name |
Updated 3 months ago