Table Abbreviation Description Module Activity code
BLAQTY BLQ Analytical quantity balance Financials  

Key Description Duplicates Activity code
BLQ0 LEDTYP+CPY+FCY+FIY+ACC+BPR+CCE1+CCE2+CCE3+CCE4+CCE5+CCE6+CCE7+CCE8+CCE9+CUR No  
BLQ1 ACCNUM No  
BLQ3 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=[BLQ]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  
COA Chart code   COA     [COA]COA0=[BLQ]COA Delete  
CPY Company   CPY     [CPY]CPY0=[BLQ]CPY Block  
CREDATTIM Date time   ADATIM          
CREUSR User   AUS     [AUS]CODUSR=[BLQ]CREUSR Other  
CUR Currency   CUR     [TCU]TCU0=[BLQ]CUR Block  
DIE Dimension type code 9 DIE     [DIE]DIE0=[BLQ]DIE Block  
FCY Site   FCY     [FCY]FCY0=[BLQ]FCY Block  
FIY Fiscal year   C 2        
LED Ledger   LED     [LED]LED0=[BLQ]LED Delete  
LEDTYP Ledger type   M   2644      
QTY Quantity   QTY         PER
QTYCMM Commitment   QTY         PER
QTYPRP Precommitment   QTY         PER
UOM Nonfinancial unit   UOM     [TUN]TUN0=[BLQ]UOM Block  
UPDDATTIM Date time   ADATIM          
UPDUSR User   AUS     [AUS]CODUSR=[BLQ]UPDUSR Other