Table Abbreviation Description Module Activity code
KPYIMPTRAN KPT Sage 50 import transcribe Financials MUIMP

Key Description Duplicates Activity code
KPYT0 TYP+INVALUE+COA+FCY+ACC No  
KPUT1 TYP+COA+FCY Yes  

Column Normal title Dim. Type Length Menu Link expression Cancellation Act
ACC Account   GAC     [GAC]GAC0=COA;ACC Block  
ACCDAT Report date   M 4 1      
AUUID Single identifier   AUUID          
CCE Analytical dimension   A 15        
CDE Default dimensions   CDE     [CDE]CDE0=CDE;[V]GSUPCLE Block  
COA Chart of accounts   COA     [COA]COA0=[KPT]COA Delete  
CONTRA Offset   M 4 1      
CREDATTIM Date time   ADATIM          
CREUSR User   AUS     [AUS]CODUSR=[KPT]CREUSR Other  
FCY Site   FCY     [FCY]FCY0=[KPT]FCY Delete  
GAU Automatic journal   GAU     [GAU]GAU0=[KPT]GAU Other  
GTE Entry type   GTE     [GTE]GTE0=GTE;[V]GSUPCLE Block  
INVALUE Source value   A 100        
TYP Type   M 15 3700      
UPDDATTIM Date time   ADATIM          
UPDUSR User   AUS     [AUS]CODUSR=[KPT]UPDUSR Other