Service dr220 / 45220

Internal service

Download of payments from the cdcp.payment_cdcp table. The input field serves as a filter and at least one must be entered.

Input field

NameTypeDomainDescription
IDPP Numeric (14,0) Payment instruction ID
CCDT Date Payment date
TYPL Char (3) TYPPLT1 Payment type
TYPO Char (2) Item type in clearing centre
MTMV Numeric (14,2) Transfer amount
DEVI Char (3) DEVIS1 Currency code
STMV Char (2) STAVPP Status
DKCC Char (4) DB bank code
DPRE Char (6) DB number of Czech cash account (1st part)
DCIU Char (10) DB number of Czech cash account (2nd part)
KKCC Char (4) CR bank code
KPRE Char (6) CR number of Czech cash account (1st part)
KCIU Char (10) CR number of Czech cash account (2nd part)
KONS Char (10) Constant payment symbol
SPEC Char (10) Payment specific symbol
VARS Char (10) [0-9]{1,10} Payment variable symbol
ZPVY Char (1) Creation way
PUCE Char (22) Original CR bank account
ZADU Char (10) Creator of payment
CRDT Date Creation date
KCCB Char (4) Bank code
PRED Char (6) Number of Czech cash account (1st part)
CIUC Char (10) Number of Czech cash account (2nd part)

Output field

NameTypeDomainDescription
IDPP * Numeric (14,0) Payment instruction ID
CCDT * Date Payment date
CSOU Numeric (6,0) CC file number
CPP Numeric (7,0) Payment n.
CERT Numeric (7,0) Payment number in clearing centre
TYPL * Char (3) TYPPLT1 Payment type
TYPO Char (2) Item type in clearing centre
MTMV * Numeric (14,2) Transfer amount
DEVI * Char (3) DEVIS1 Currency code
STMV * Char (2) STAVPP Status
IDDO Char (13) ID of original document
DKCC * Char (4) DB bank code
DPRE * Char (6) DB number of Czech cash account (1st part)
DCIU * Char (10) DB number of Czech cash account (2nd part)
DNAZ Char (20) DB account owner name
DIDE Char (140) DB paymennt reason or identification
KKCC * Char (4) CR bank code
KPRE * Char (6) CR number of Czech cash account (1st part)
KCIU * Char (10) CR number of Czech cash account (2nd part)
KNAZ Char (20) CR account owner name
KIDE Char (140) CR paymennt reason or identification
ZPRK Char (140) Client message
PUCE Char (22) Original CR bank account
KONS Char (10) Constant payment symbol
SPEC Char (10) Payment specific symbol
VARS Char (10) [0-9]{1,10} Payment variable symbol
ZPVY Char (1) Creation way
CMMT Char (250) Comments
VZDT Date The date of the reason for the payment
ZADU * Char (10) Creator of payment
CRDT * Date Creation date
CRTS * Timestamp Timestamp of creation of the payment
NMDM * Char (10) Last changing user
SERV * Char (10) Last changing user
UPDT * Date Update date
UPTS * Timestamp Timestamp date