T5FDSN_PP_CONSOL

Payments process, grouping rule for blocks 20 | #other | Component: France
Column Name Description
TYPID FK Type of OPS (Social Protection Agency)
SIRPY Role regarding the payer SIRET Show values
VEMOD Payment type Show values
DENAT Nature of declaration for DSN Show values
ENDDA End Date
Column Name Description
Column Name Description
Column Name Description
ENDDA End Date
BEGDA Start Date
DEFBG Default incorporation period start date 20.006
DFEND Default incorporation period end date 20.007
Column Name Description
SIRPY Role regarding the payer SIRET Show values
VEMOD Payment type Show values
DENAT Nature of declaration for DSN Show values
CPGRP Grouping rule blocks 20 for reference period Show values
RPGRP Grouping rule for retroactive blocks 20 Show values
BANKD BIC/IBAN to be cleared (fields 20.003/20.004) Show values
AMNEG Negative amount allowed in DSN PP S21.G00.20.010 Show values
SIRET Payer SIRET to be cleared (fields S21.G00.20.012) Show values
AMOUN Amount to be cleared (fields S21.G00.20.005) Show values
VEENT Entity to be cleared (fields S21.G00.20.002) Show values
VEDAT Payment date to clear (S21.G00.20.011 fields) Show values
PREDM Grouping rule for the paid amount (Pre-DME) Show values
Column Name Description Domain name
Other Relations Join Conditions
Type of OPS (Social Protection Agency)
  • Type of OPS (Social Protection Agency)
  • ?