Service dr230 / 45230

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
IDPI Numeric (10,0) Preadvice information ID
DODT Date Participant distribution date
DBDT Date Clearing bank distribution date
CDAC Numeric (4,0)
CLEB Numeric (4,0) [0-9]{1,3} Clearing bank code
TYPL Char (3) TYPPLT Payment type
MTMD Numeric (14,2) Debited amount
MTMK Numeric (14,2) Credited amount
DEVI Char (3) DEVISE Currency
NEDT Date Creation date
DEDT Date Settlement date
CCDT Date Payment date
PREV Char (15) [0-9]{1,15} Transfer ID
SMER Char (1) SMEROB Buy/Sell indicator
NOOR Numeric (12,0) Instruction ID
CLCE Char (3) TYPCLC Clearing centre
ZPVY Char (1) Creation way
NMDM Char (10) Last changing user
UPDT Date Update date

Output field

NameTypeDomainDescription
IDPI * Numeric (10,0) Preadvice information ID
DODT * Date Participant distribution date
DBDT * Date Clearing bank distribution date
CDAC * Numeric (4,0) [0-9]{1,3} Participant code
CLEB * Numeric (4,0) [0-9]{1,3} Clearing bank code
FAUC * Numeric (4,0) Invoiced participant code
TYPL * Char (3) TYPPLT Payment type
MTMD * Numeric (14,2) Debited amount
MTMK * Numeric (14,2) Credited amount
DEVI * Char (3) DEVISE Currency code
NEDT * Date Creation date
DEDT * Date Settlement date
CCDT * Date Payment date
PREV Char (15) [0-9]{1,15} Transfer ID
SMER Char (1) SMEROB Buy/Sell indicator
NORE Char (35) Reference
NOOR Numeric (12,0) Instruction ID
CMMT Char (250) Comments
CLCE * Char (3) TYPCLC Clearing centre
ZPVY Char (1) Creation way
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