Payments Module

Module purpose

The Payments module manages the authorisation, execution and reconciliation of all CAP payments. This includes direct payments (BPS, greening, VCS, young farmer), RDP payments (AECM, ANC, investment tranches) and recoveries.

Key tables

Core payment tables

Table Description Rows
TPAGAMENTO Main payment records 299,632
TELC_ELENCO Payment lists/batches 58,801
TELC_ELENCO_OGGETTO Objects in payment lists 595,552
TELC_FLUSSO Payment flows 3,050
TELC_FLUSSO_OBJ Payment flow objects 595,406
TELC_PAGATO Paid amounts 100,317
TEXP_DOM_LIQUIDAZIONE Liquidation export 593,730

Payment processing

Table Description Rows
TMOD_PAGAMENTO Payment modifications 16,453
TMOD_PAGAMENTO_IBAN Payment IBAN records 16,200
TPM_BUDGET Budget allocations 38,959
TPM_BUDGET_REGISTRO Budget register 2,221

Payment logs

Table Description Rows
TEXP_LOG_SMS SMS payment notifications 506,202
TEXP_LOG_SMS_PAGAMENTO Payment SMS logs 64,213
TEXP_LOG Export log 176,434
TELC_FLUSSO_DOWNLOAD_LOG Flow download log 4,135
TELC_STAMPA_FLUSSO_LOG Flow print log 2,157

Definition tables

Table Description Rows
TELC_DEF_TIPO_ELENCO List type definitions 175
TELC_DEF_CARICA Position definitions 348
TELC_DEF_FLUSSO_STAMPA Flow print definitions 184
TPM_DEF_BUDGET Budget definitions 4
TPM_DEF_GERARCHIA Hierarchy definitions 7
TPM_COMPONENTE Budget components 32
TPM_CLC_DEF_BUDGET_COMPONENTE Budget component calcs 54
TPM_CLC_DEF_DOM_MODULO Module calc definitions 211

Key columns

TPAGAMENTO (Main Payment)

Column Type Nullable Description
PKID NUMBER N Primary key
ID_SOGGETTO NUMBER N Beneficiary subject ID
ID_PAGAMENTO VARCHAR2(50) Y Payment identifier
ID_RICHIESTA VARCHAR2(50) Y Request identifier
COD_PAGATORE VARCHAR2(6) N Payer code
SETTORE VARCHAR2(250) Y Sector
CAMPAGNA NUMBER Y Campaign year
COD_ABI / COD_CAB VARCHAR2(5) Y Bank codes
CONTO VARCHAR2(100) Y Account number
DT_PAGAMENTO DATE Y Payment date
IMPORTO NUMBER Y Amount
COD_TIPO_PAGAMENTO VARCHAR2(6) N Payment type
TIPO_FONDO VARCHAR2(50) Y Fund type (EAGF/EAFRD)

TELC_ELENCO (Payment Lists)

Column Type Nullable Description
ID_ELENCO NUMBER N List identifier
COD_ELENCO VARCHAR2(100) Y List code
ID_TIPO_ELENCO NUMBER N List type
COD_STATO / SCO_STATO VARCHAR2(6) N Status

TELC_PAGATO (Paid Amounts)

Column Type Nullable Description
ID_DOMANDA NUMBER N Application ID
TIPO_RECORD VARCHAR2(200) N Record type
ANNO_CAMPAGNA NUMBER Y Campaign year
ANNO_PAGAMENTO NUMBER Y Payment year
IMPORTO_PAGATO_UE NUMBER Y EU-funded amount
IMPORTO_PAGATO_ST NUMBER Y State-funded amount
PAYMENT_BATCH VARCHAR2(10) Y Batch identifier

Data flow

See diagram: Payments Data Flow

Integration points

Inbound

  • Applications: Approved applications feed into payment lists
  • Commitments: Commitment claims generate AECM/M11 payments
  • Contracts: Invoice approvals generate investment payments
  • Calculations: TCLC_* results determine payment amounts

Outbound

  • Treasury: Payment files exported to national treasury
  • Banking: IBAN validation and payment execution
  • Reporting: Payment data for EU financial reporting
  • Audit: Full payment trail for audit compliance

Key packages

Package Purpose
PAMS_UTILS_PCK Payment management utilities
EXPORT_LIQUIDAZIONE_PCK Liquidation export
REIMBURSEMENT_PCK Reimbursement processing
EXPORT_PCK General export
MANDATI_PCK Mandate/payment order processing

Key views

View Purpose
VMANDATO Mandate/payment order view
VPAMS_PAGATO Paid amounts view
VPAMS_MAX_FUNDS Maximum funds view
VPAYMENTS_REJECTED Rejected payments
VEXP_LOG_SMS_PAGAMENTO SMS payment log view

Export tables

Table Description Rows
TEXP_STRUTTURA_LIQUIDAZIONE Liquidation structure 30,292
TEXP_REGISTRO Export register 179,498
TEXP_REG_MOBILE Mobile export register 65,683
TEXP_REC_SMS SMS export records 751,391
TEXP_REC_SMS_PAGAMENTO Payment SMS records 75,535
TPRC_SMS SMS processing 1,196,604
TPRC_EXPORT_SMS SMS export processing 835,837
TPRC_EXPORT_SMS_PAGAMENTO Payment SMS export 144,177

Configuration

Payment list types are configured in TELC_DEF_TIPO_ELENCO.

Budget allocations are managed via:

  • TPM_DEF_BUDGET: Budget type definitions
  • TPM_BUDGET: Budget amounts per year/measure
  • TPM_COMPONENTE: Budget breakdown components

Quick reference

  • Acronyms — full abbreviation list
  • Glossary — term definitions and Italian translations
  • Home — system overview