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 |