Service dr210 / 45210

Internal service

Download of payments from the cdcp.payment 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) TYPPLT Payment type
MTMV Numeric (14,2) Transfer amount
DEVI Char (3) DEVISE Currency code
STMV Char (2) Status
CARM Numeric (4,0) [0-9]{1,3} Debit side participant code
DCLE Numeric (4,0) [0-9]{1,3} DB clearing bank code
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)
CAEM Numeric (4,0) [0-9]{1,3} Credit side participant code
KCLE Numeric (4,0) [0-9]{1,3} CR clearing bank code
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
PREV Char (15) Transfer ID
CLCE Char (3) TYPCLC Clearing centre
ZPVY Char (1) Creation way
PORA Char (2) Intra-day batch order
VZDT Date The date of the reason for the payment
ZADU Char (10) Creator of payment
CRDT Date Creation date
CDAC Numeric (4,0) [0-9]{1,3} Participant code
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.
TYPL * Char (3) TYPPLT Payment type
MTMV * Numeric (14,2) Transfer amount
DEVI * Char (3) DEVISE Currency code
STMV * Char (2) Status
CARM * Numeric (4,0) [0-9]{1,3} Debit side participant code
DCLE * Numeric (4,0) [0-9]{1,3} DB clearing bank code
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)
DRLI Numeric (12,0) DB instruction ID
DNORE Char (35) DB reference
CAEM * Numeric (4,0) [0-9]{1,3} Credit side participant code
KCLE * Numeric (4,0) [0-9]{1,3} CR clearing bank code
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)
KRLI Numeric (12,0) CR instruction ID
KNORE Char (35) CCR reference
KONS Char (10) Constant payment symbol
SPEC Char (10) Payment specific symbol
VARS Char (10) [0-9]{1,10} Payment variable symbol
PREV Char (15) Transfer ID
CLCE * Char (3) TYPCLC Clearing centre
ZPVY Char (1) Creation way
CMMT Char (250) Comments
PORA * Char (2) PORA2 Intra-day batch order
MIDO Char (2) Order type
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
CVAL Char (12) Investment instrument ID