Table Abbreviation Description Module Activity code
EXPENSES EXS Expense A/P-A/R accounting  

Key Description Duplicates Activity code
EXS0 CLB+DATEXS+NBREXS No  
EXS1 ACCNUM No  
EXS2 CPY+CUR+FCY+DATEXS Yes  
EXS3 VCRTYP+VCRNUM+ACCNUM No  
EXS4 PJTLIN Yes PJM

Column Normal title Dim. Type Length Menu Link expression Cancellation Act
ACC Account 10 GAC     [GAC]GAC0=COA;ACC Delete  
ACCNUM Internal number   UNQ          
AMTATI Amount + tax   MD2          
AMTCUR Amount in currency   MD2          
AMTPAY Actual amt.   MD2          
AMTTAX1 Tax amount   MD2          
AMTTAX2 Tax amount   MD2          
AMTVAT Tax amount   MD2          
AUUID Single identifier   AUUID          
CCE Analytical dimension   CCE     [CCE]CCE0=DIE(indice);CCE(indice) Block ANA
CLB Employee   AUS     [AUS]CODUSR=[EXS]CLB Delete  
COA Chart code 10 COA     [COA]COA0=[EXS]COA Delete  
CODEXP Expense codes   TES     [TES]TES0=[EXS]CODEXP Block  
CPY Company   CPY     [CPY]CPY0=[EXS]CPY Delete  
CREDAT Date created   D          
CREDATTIM Date time   ADATIM          
CREUSR Creation user   A 5        
CUR Currency   CUR     [TCU]TCU0=[EXS]CUR Block  
CURLED Ledger currency 10 CUR     [TCU]TCU0=[EXS]CURLED Delete  
DATEXS Date   D          
DEDTAX1 Deductible tax   MD2          
DEDTAX2 Deductible tax   MD2          
DEDVAT Input VAT   MD2          
DES Comments   A 250        
DIE Analytical dimension type   DIE     [DIE]DIE0=[EXS]DIE Block ANA
FCY Site   FCY     [FCY]FCY0=[EXS]FCY Delete  
LED Ledger 10 LED     [LED]LED0=[EXS]LED Delete  
NBREXS Line no.   C 2        
PJTLIN Project   PJT     [PIM]PIM0=[EXS]PJTLIN Block PJM
QTY Quantity   L 6        
RATDAT Rate date   D          
RATDIV Dividing rate 10 RCU          
RATMLT Multiplying rate 10 RCU          
STA Status   M 15 2806      
TAX1 Tax 1   VAT     [TVT]TVT0=TAX1;[V]GSUPCLE Block  
TAX2 Tax 2   VAT     [TVT]TVT0=TAX2;[V]GSUPCLE Block  
TYPRAT Rate type   M 15 202      
UPDDAT Change date   D          
UPDDATTIM Date time   ADATIM          
UPDUSR Change user   A 5        
VAT Tax 3   VAT     [TVT]TVT0=VAT;[V]GSUPCLE Block  
VCRNUM Entry   VCR          
VCRTYP Entry type   GTE     [GTE]GTE0=VCRTYP;[V]GSUPCLE Block  
VISA   AUS     [AUS]CODUSR=[EXS]VISA Block