Table Abbreviation Description Module Activity code
TMPEXPENSE EXT Temporary table - Expenses A/P-A/R accounting  

Key Description Duplicates Activity code
EXT0 CPY+CUR+BPRGTETYP+FCY+SEP+DATEXS Yes  
EXT1 ACCNUM No  

Column Normal title Dim. Type Length Menu Link expression Cancellation Act
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          
BPRGTETYP Entry type   GTE     [GTE]GTE0=BPRGTETYP;[V]GSUPCLE Delete  
CCE Analytical dimension   CCE     [CCE]CCE0=DIE(indice);CCE(indice) Block ANA
CLB Employee   AUS     [AUS]CODUSR=[EXT]CLB Delete  
CODEXP Expense codes   TES     [TES]TES0=[EXT]CODEXP Delete  
CPY Company   CPY     [CPY]CPY0=[EXT]CPY Delete  
CREDAT Date created   D          
CREDATTIM Date time   ADATIM          
CREUSR Creation user   A 5        
CUR Currency   CUR     [TCU]TCU0=[EXT]CUR 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=[EXT]DIE Block ANA
EXPBPR Miscellaneous BP   BPR     [BPR]BPR0=[EXT]EXPBPR Delete  
FCY Site   FCY     [FCY]FCY0=[EXT]FCY Delete  
NBREXS Line no.   C 2        
PJTLIN Project   PJT     [PIM]PIM0=[EXT]PJTLIN BSRA PJM
QTY Quantity   L 6        
RATDAT Rate date   D          
RATDIV Dividing rate 10 RCU          
RATMLT Multiplying rate 10 RCU          
SEP Separator   A 30        
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=[EXT]VISA Block