CNSAcctBal
Provides consolidated account balance data, summarizing financial entries and subsidiary relationships.
Columns
| Name | Type | Description |
| Recordno [KEY] | String | A unique identifier for the consolidated account balance record. |
| Subsidiarykey | String | The key identifying the subsidiary associated with the account balance. |
| Subaccountkey | String | The key identifying the subaccount within the subsidiary. |
| Subaccountno | String | The number identifying the subaccount. |
| Subtitle | String | The title or label associated with the subaccount. |
| Cnsperiodkey | String | The key identifying the consolidation period for the account balance. |
| Consbsrrate | String | The consolidation balance sheet rate. |
| Conswarrate | String | The consolidation weighted average rate. |
| Subaccttype | String | The type of the subaccount (e.g., asset, liability). |
| JournalNUM | Int64 | The number identifying the journal associated with the account balance. |
| Symbol | String | The symbol representing the currency or unit for the account balance. |
| Batch_title | String | The title or label for the batch of transactions. |
| Batch_date | Datetime | The date associated with the batch of transactions. |
| AccountNUM | Int64 | The number identifying the account within the system. |
| Acct_no | String | The account number for the consolidated account balance. |
| Entry_date | Datetime | The date of the entry in the account balance. |
| Timeperiod | Int64 | The time period associated with the account balance. |
| Debit | Double | The total debit amount in the account balance. |
| Credit | Double | The total credit amount in the account balance. |
| PeriodNUM | Int64 | The number identifying the period associated with the account balance. |
| Pname | String | The name of the period or process associated with the account balance. |
| Subsidiaryid | String | The identifier for the subsidiary associated with the account balance. |
| Formula_debit | Double | The calculated debit amount based on the formula applied. |
| Formula_credit | Double | The calculated credit amount based on the formula applied. |
| Record_url | String | A URL providing direct access to the consolidated account balance record. |