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
Output field
Name | Type | Domain | Description
|
---|
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 |