Table BALANA
| Table | Abbreviation | Description | Module | Activity code |
|---|---|---|---|---|
| BALANA | BLA | Analytical balance | Financials |
| Key | Description | Duplicates | Activity code |
|---|---|---|---|
| BLA0 | LEDTYP+CPY+FCY+FIY+ACC+BPR+CCE1+CCE2+CCE3+CCE4+CCE5+CCE6+CCE7+CCE8+CCE9+CUR | No | |
| BLA1 | ACCNUM | No | |
| BLA2 | LEDTYP+CPY+CUR+FCY+ACC+BPR+CCE1+CCE2+CCE3+CCE4+CCE5+CCE6+CCE7+CCE8+CCE9+FIY | No | |
| BLA3 | LEDTYP+CUR+FCY+FIY+ACC+CCE1+CCE2+CCE3+CCE4+CCE5+CCE6+CCE7+CCE8+CCE9+BPR+CPY | No |
| Column | Normal title | Dim. | Type | Length | Menu | Link expression | Cancellation | Act |
|---|---|---|---|---|---|---|---|---|
| ACC | General accounts | GAC | [GAC]GAC0=COA;ACC | Block | ||||
| ACCNUM | Unique number | UNQ | ||||||
| AUUID | Single identifier | AUUID | ||||||
| BPR | BP | BPR | [BPR]BPR0=[BLA]BPR | Block | ||||
| CCE1 | Analytical dimension 1 | CCE | [CCE]CCE0=DIE(0);CCE1 | Block | ||||
| CCE2 | Analytical dimension 2 | CCE | [CCE]CCE0=DIE(1);CCE2 | Block | ||||
| CCE3 | Analytical dimension 3 | CCE | [CCE]CCE0=DIE(2);CCE3 | Block | ||||
| CCE4 | Analytical dimension 4 | CCE | [CCE]CCE0=DIE(3);CCE4 | Block | ||||
| CCE5 | Analytical dimension 5 | CCE | [CCE]CCE0=DIE(4);CCE5 | Block | ||||
| CCE6 | Analytical dimension 6 | CCE | [CCE]CCE0=DIE(5);CCE6 | Block | ||||
| CCE7 | Analytical dimension 7 | CCE | [CCE]CCE0=DIE(6);CCE7 | Block | ||||
| CCE8 | Analytical dimension 8 | CCE | [CCE]CCE0=DIE(7);CCE8 | Block | ||||
| CCE9 | Analytical dimension 9 | CCE | [CCE]CCE0=DIE(8);CCE9 | Block | ||||
| CDT | Credit | MD1 | PER | |||||
| CDTLED | Ledger credit | MD1 | PER | |||||
| COA | Chart code | COA | [COA]COA0=[BLA]COA | Delete | ||||
| CPY | Company | CPY | [CPY]CPY0=[BLA]CPY | Block | ||||
| CREDATTIM | Date time | ADATIM | ||||||
| CREUSR | User | AUS | [AUS]CODUSR=[BLA]CREUSR | Other | ||||
| CUR | Currency | CUR | [TCU]TCU0=[BLA]CUR | Block | ||||
| CURLED | Ledger currency | CUR | [TCU]TCU0=[BLA]CURLED | Block | ||||
| DEB | Debit | MD1 | PER | |||||
| DEBLED | Ledger debit | MD1 | PER | |||||
| DIE | Dimension type code | 9 | DIE | [DIE]DIE0=[BLA]DIE | Block | |||
| FCY | Site | FCY | [FCY]FCY0=[BLA]FCY | Block | ||||
| FIY | Fiscal year | C | 2 | |||||
| LED | Ledger | LED | [LED]LED0=[BLA]LED | Delete | ||||
| LEDTYP | Ledger type | M | 2644 | |||||
| UPDDATTIM | Date time | ADATIM | ||||||
| UPDUSR | User | AUS | [AUS]CODUSR=[BLA]UPDUSR | Other |