P2RF_SV

Payroll Result: Social Insurance (F) | #transactional | Component: France
Column Name Description
MANDT Client
DCT_PERNR Personnel Number
DCT_SEQNR FK Sequence Number
DCT_ROWID Unique Row Number
Column Name Description
Column Name Description
Column Name Description
BEGDA Start Date
ENDDA End Date
INBEG Original start of contract or start of renewal
INEND Employment contract: End of contract/renewal
PREND Employment contract: End of contract prenotification date
PEEND Employment contract: End date of trial period
Column Name Description
TPART Checkbox Show values
MRCDD Employment contract: Reason for recourse to a CDD Show values
CASPA Employment contract: Specific case Show values
CATDU Employment contract: Law on Securing emplymt - Duration cat. Show values
CTFTE Full-Time Equivalent Show values
Column Name Description Domain name
CNTR1 Tax split RAW1
NUMSS Social insurance number NUMSS
CLESS Verification key for the SI number NUM2
REGNO SI contrib. model P06_REGNO
ORG01 SI contribution funds P06_ORGA1
ORG02 SI contribution funds P06_ORGA1
ORG03 SI contribution funds P06_ORGA1
ORG04 SI contribution funds P06_ORGA1
ORG05 SI contribution funds P06_ORGA1
ORG06 SI contribution funds P06_ORGA1
ORG07 SI contribution funds P06_ORGA1
ORG08 SI contribution funds P06_ORGA1
ORG09 SI contribution funds P06_ORGA1
ORG10 SI contribution funds P06_ORGA1
REGSS SI contrib. model P06_REGNO
REGAC SI contrib. model P06_REGNO
REGRT SI contrib. model P06_REGNO
CTTYP Contract Type CTTYP
Other Relations Join Conditions
Tax and social insurance payroll costs
  • Tax and social insurance payroll costs
  • Client
  • P2RF_SV.COT01 == T5F1B.COTIS
  • P2RF_SV.MANDT == T5F1B.MANDT
Tax and social insurance payroll costs
  • Tax and social insurance payroll costs
  • Client
  • P2RF_SV.COT02 == T5F1B.COTIS
  • P2RF_SV.MANDT == T5F1B.MANDT
Tax and social insurance payroll costs
  • Tax and social insurance payroll costs
  • Client
  • P2RF_SV.COT03 == T5F1B.COTIS
  • P2RF_SV.MANDT == T5F1B.MANDT
Tax and social insurance payroll costs
  • Tax and social insurance payroll costs
  • Client
  • P2RF_SV.COT04 == T5F1B.COTIS
  • P2RF_SV.MANDT == T5F1B.MANDT
Tax and social insurance payroll costs
  • Tax and social insurance payroll costs
  • Client
  • P2RF_SV.COT05 == T5F1B.COTIS
  • P2RF_SV.MANDT == T5F1B.MANDT
Tax and social insurance payroll costs
  • Tax and social insurance payroll costs
  • Client
  • P2RF_SV.COT06 == T5F1B.COTIS
  • P2RF_SV.MANDT == T5F1B.MANDT
Tax and social insurance payroll costs
  • Tax and social insurance payroll costs
  • Client
  • P2RF_SV.COT07 == T5F1B.COTIS
  • P2RF_SV.MANDT == T5F1B.MANDT
Tax and social insurance payroll costs
  • Tax and social insurance payroll costs
  • Client
  • P2RF_SV.COT08 == T5F1B.COTIS
  • P2RF_SV.MANDT == T5F1B.MANDT
Tax and social insurance payroll costs
  • Tax and social insurance payroll costs
  • Client
  • P2RF_SV.COT09 == T5F1B.COTIS
  • P2RF_SV.MANDT == T5F1B.MANDT
Tax and social insurance payroll costs
  • Tax and social insurance payroll costs
  • Client
  • P2RF_SV.COT10 == T5F1B.COTIS
  • P2RF_SV.MANDT == T5F1B.MANDT