Table Abbreviation Description Module Activity code
KPYIMPDTL KPD Sage 50/Murano payroll detail Financials MUIMP

Key Description Duplicates Activity code
KPYD0 RECID+LINENO No  

Column Normal title Dim. Type Length Menu Link expression Cancellation Act
ACC Account 10 GAC     [GAC]GAC0=COA(indice);ACC(indice) Delete  
ACC_CODE Code   A 20        
AMTCUR Amount   MD1          
AUUID Single identifier   AUUID          
CCE Analytical dimension   CCE     [CCE]CCE0=DIE(indice);CCE(indice) Other ANA
CCEACC_CODE Code   A 20        
CCECOSTCENTR Cost Centre   A 20        
CCEDEPT Department   A 20        
CCEEMPLOYEE Employee   A 15        
COA Chart of accounts 10 COA     [COA]COA0=[KPD]COA Block  
COSTCENTRE Cost Centre   A 20        
CREDATTIM Date time   ADATIM          
CREUSR User   AUS     [AUS]CODUSR=[KPD]CREUSR Other  
DEPT Department   A 20        
DIE Dimension type code   DIE     [DIE]DIE0=[KPD]DIE Block ANA
DSP Distribution   DSP     [DSP]DSP0=DSP;1 Other MURAN
EMPLOYEE Employee   A 10        
GRPGAS Group entry   A 30       MURAN
LED Ledger 10 LED     [LED]LED0=[KPD]LED Delete MURAN
LINENO Line no.   L 4        
NARRATIVE Narrative   A 50        
NUMMURANO Number   L 8       MURAN
QTY Quantity   QTY         MURAN
RECID Identifier   A 25        
REFNO Report line   A 50        
SNS Sign   C 2        
SRC_LINE Source line   A 10        
TMPACC1 Source account   A 50        
TRSDAT Transaction date   D          
UOM Unit   UOM     [TUN]TUN0=[KPD]UOM Delete MURAN
UPDDATTIM Date time   ADATIM          
UPDUSR User   AUS     [AUS]CODUSR=[KPD]UPDUSR Other