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 |