Table Abbreviation Description Module Activity code
PREPINVOICED PREPID Prepayment invoice detail A/P-A/R accounting PREPM

Key Description Duplicates Activity code
PREPID0 PCNTNUM+PCNTLIN No  
PREPID1 INVNUM Yes  

Column Normal title Dim. Type Length Menu Link expression Cancellation Act
ACCLIN General account   GAC     [GAC]GAC0=COA;ACCLIN Block  
AMTATILIN Invoice amount +tax   MD1          
AMTNOTLIN Invoice amount -tax   MD1          
AUUID Single identifier   AUUID          
COA Chart of accounts   COA     [COA]COA0=[PREPID]COA Block  
CREDATTIM Date time   ADATIM          
CREMEMNUM Credit memo no.   VCR          
CREUSR User   AUS     [AUS]CODUSR=[PREPID]CREUSR Other  
INVDAT Invoice date   D          
INVNUM Invoice number   VCR          
PAYAMTNOT Paid amount -tax   MD1          
PAYAMTNOTLED Led. paid amt -tax   MD1          
PAYAMTTAX Tax paid   MD1          
PAYAMTTAXLED Tax paid led   MD1          
PCNTLIN Line number   L 8        
PCNTNUM Contract number   PREPI     [PREPI]PREPI0=[PREPID]PCNTNUM Other  
PPCT Prepayment percentage   COE          
UPDDATTIM Date time   ADATIM          
UPDUSR User   AUS     [AUS]CODUSR=[PREPID]UPDUSR Other  
VATLIN Tax code   VAT     [TVT]TVT0=VATLIN;[V]GSUPCLE Block