Table BALCONSO
| Table | Abbreviation | Description | Module | Activity code |
|---|---|---|---|---|
| BALCONSO | BLC | Consolidation trial balance | Financials | CSL1 |
| Key | Description | Duplicates | Activity code |
|---|---|---|---|
| BLC0 | LEDTYP+GRUGPY+CPYGRU+ACCGRU+BPRGRU+CCE1+CCE2+CCE3+CCE4+CCE5+CCE6+CCE7+CCE8+CCE9+CURTRS+CRI | No |
| Column | Normal title | Dim. | Type | Length | Menu | Link expression | Cancellation | Act |
|---|---|---|---|---|---|---|---|---|
| ACCGRU | General account | A | 15 | |||||
| ANOUV | Prior balances | M | 4 | 1 | ||||
| AUUID | Single identifier | AUUID | ||||||
| BLC | Accounting balance | MD1 | ||||||
| BPRGRU | Partner company | A | 15 | |||||
| CCE1 | Analytical dimension 1 | CCE | [CCE]CCE0=DIE1;CCE1 | Block | ||||
| CCE2 | Analytical dimension 2 | CCE | [CCE]CCE0=DIE2;CCE2 | Block | ||||
| CCE3 | Analytical dimension 3 | CCE | [CCE]CCE0=DIE3;CCE3 | Block | ||||
| CCE4 | Analytical dimension 4 | CCE | [CCE]CCE0=DIE4;CCE4 | Block | ||||
| CCE5 | Analytical dimension 5 | CCE | [CCE]CCE0=DIE5;CCE5 | Block | ||||
| CCE6 | Analytical dimension 6 | CCE | [CCE]CCE0=DIE6;CCE6 | Block | ||||
| CCE7 | Analytical dimension 7 | CCE | [CCE]CCE0=DIE7;CCE7 | Block | ||||
| CCE8 | Analytical dimension 8 | CCE | [CCE]CCE0=DIE8;CCE8 | Block | ||||
| CCE9 | Analytical dimension 9 | CCE | [CCE]CCE0=DIE9;CCE9 | Block | ||||
| CDTCNS | Credit | MD1 | ||||||
| CDTTRS | Credit | MD1 | ||||||
| CPYGRU | Company | A | 10 | |||||
| CREDAT | Date created | D | ||||||
| CREDATTIM | Date time | ADATIM | ||||||
| CRETIM | Time | L | 8 | |||||
| CREUSR | Creation user | A | 5 | |||||
| CRI | Criteria | A | 30 | |||||
| CURCNS | Currency | CUR | [TCU]TCU0=[BLC]CURCNS | Block | ||||
| CURTRS | Currency | CUR | [TCU]TCU0=[BLC]CURTRS | Block | ||||
| DATDEB | Start date | D | ||||||
| DATFIN | End date | D | ||||||
| DEBCNS | Debit | MD1 | ||||||
| DEBTRS | Debit | MD1 | ||||||
| DES | Description | DES | ||||||
| DIE1 | Dimension type code | DIE | [DIE]DIE0=[BLC]DIE1 | Block | ||||
| DIE2 | Dimension type code | DIE | [DIE]DIE0=[BLC]DIE2 | Block | ||||
| DIE3 | Dimension type code | DIE | [DIE]DIE0=[BLC]DIE3 | Block | ||||
| DIE4 | Dimension type code | DIE | [DIE]DIE0=[BLC]DIE4 | Block | ||||
| DIE5 | Dimension type code | DIE | [DIE]DIE0=[BLC]DIE5 | Block | ||||
| DIE6 | Dimension type code | DIE | [DIE]DIE0=[BLC]DIE6 | Block | ||||
| DIE7 | Dimension type code | DIE | [DIE]DIE0=[BLC]DIE7 | Block | ||||
| DIE8 | Dimension type code | DIE | [DIE]DIE0=[BLC]DIE8 | Block | ||||
| DIE9 | Dimension type code | DIE | [DIE]DIE0=[BLC]DIE9 | Block | ||||
| GRUGPY | Conso. scope | AGF | [AGF]AGF0=[BLC]GRUGPY | Block | ||||
| LEDTYP | Ledger type | M | 2644 | |||||
| SNSBLC | Balance sign | C | 2 | |||||
| UPDDATTIM | Date time | ADATIM | ||||||
| UPDUSR | User | AUS | [AUS]CODUSR=[BLC]UPDUSR | Other |