Service dr215 / 45215

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) TYPPLT3 Payment type
MTMV Numeric (14,2) Transfer amount
DEVI Char (3) DEVIS1 Currency code
STMV Char (2) STAVPPN 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
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)
CPP Numeric (7,0) Payment n.
CSOU Numeric (6,0) CC file number

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) TYPPLT3 Payment type
MTMV * Numeric (14,2) Transfer amount
DEVI * Char (3) DEVIS1 Currency code
STMV * Char (2) STAVPPN 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
CLCE * Char (3) TYPCLC Clearing centre
ZPVY Char (1) Creation way
CMMT Char (250) Comments
PORA * Char (2) PORA2 Intra-day batch order
VZDT Date The date of the reason for the payment
MIDO Char (2) Order type
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