Table Abbreviation Description Module Activity code
BALANCE BAL General balance Financials  

Key Description Duplicates Activity code
BAL0 LEDTYP+CPY+FCY+FIY+ACC+BPR+CUR No  
BAL1 ACCNUM No  
BAL2 LEDTYP+CUR+CPY+FCY+ACC+BPR+FIY No  

Column Normal title Dim. Type Length Menu Link expression Cancellation Act
ACC Account   GAC     [GAC]GAC0=COA;ACC Block  
ACCNUM Unique number   UNQ          
AUUID Single identifier   AUUID          
BPR BP   BPR     [BPR]BPR0=[BAL]BPR Block  
CDT Credit   MD1         PER
CDTLED Ledger credit   MD1         PER
COA Chart code   COA     [COA]COA0=[BAL]COA Delete  
CPY Company   CPY     [CPY]CPY0=[BAL]CPY Block  
CREDATTIM Date time   ADATIM          
CREUSR User   AUS     [AUS]CODUSR=[BAL]CREUSR Other  
CUR Currency   CUR     [TCU]TCU0=[BAL]CUR Block  
CURLED Ledger currency   CUR     [TCU]TCU0=[BAL]CURLED Block  
DEB Debit   MD1         PER
DEBLED Ledger debit   MD1         PER
FCY Site   FCY     [FCY]FCY0=[BAL]FCY Block  
FIY Fiscal year   C 2        
LED Ledger   LED     [LED]LED0=[BAL]LED Delete  
LEDTYP Ledger type   M   2644      
UPDDATTIM Date time   ADATIM          
UPDUSR User   AUS     [AUS]CODUSR=[BAL]UPDUSR Other