Table Abbreviation Description Module Activity code
PREPINVOICEP PREPIP Prepayment invoice payments A/P-A/R accounting PREPM

Key Description Duplicates Activity code
PREPIP0 INVNUM+PAYNUM+PAYLIN No  
PREPIP1 PAYNUM Yes  

Column Normal title Dim. Type Length Menu Link expression Cancellation Act
AUUID Single identifier   AUUID          
CREDATTIM Date time   ADATIM          
CREUSR User   AUS     [AUS]CODUSR=[PREPIP]CREUSR Other  
INVNUM Invoice number   VCR          
NUMVCR Accounting document   VCR          
PAYAMTNOT Paid amount -tax   MD1          
PAYAMTNOTLED Led. paid amt -tax   MD1          
PAYAMTTAX Tax paid   MD1          
PAYAMTTAXLED Tax paid led   MD1          
PAYLIN Line   C 4        
PAYNUM Payment number   VCR          
PCNTCUR Contract currency   CUR     [TCU]TCU0=[PREPIP]PCNTCUR Block  
PCNTLIN Line number   L 8        
PCNTNUM Contract number   PREPI     [PREPI]PREPI0=[PREPIP]PCNTNUM Other  
TYP Entry type   GTE     [GTE]GTE0=TYP(indice);[V]GCURLEG Block  
UPDDATTIM Date time   ADATIM          
UPDUSR User   AUS     [AUS]CODUSR=[PREPIP]UPDUSR Other  
VAT Tax code   VAT     [TVT]TVT0=VAT(indice);[V]GSUPCLE Block