Service dr190 / 45190

Internal service

The service returns a listing of transfers from the cdcp.transfer_snapshot table. For each transfer ID, returns only the most recent occurrence according to the date_acc field for settlement_cycle_number = 'E'. The input field is a filter, at least one must be entered.

Input field

NameTypeDomainDescription
PREV Char (15) Transfer ID
PREVP Char (15) Parent Transfer ID
PREVU Char (15) Ultimate Transfer ID
CDAC Numeric (4,0) Participant code
CARM Numeric (4,0) [0-9]{1,3} Debit side participant code
CAEM Numeric (4,0) [0-9]{1,3} Credit side participant code
RCMA Char (12) CDCP Account number
DRCMA Char (12) [0-9]{12} Debited asset account number
KRCMA Char (12) [0-9]{12} Credited asset account number
SEME Char (16) SWIFT message ID
CVAL Char (12) Investment instrument ID
TYOP Char (3) TYPOPE Operation type
TYPT Char (4) TYPT Type of transaction
STMV Char (2) STAMVT Status
QTET Numeric (11,0) Quantity
MTMV Numeric (14,2) Transfer amount
DEVI Char (3) DEVISE Currency
IUDE Date Statement date
UODT Date Trade date
NEDT Date Transfer Creation date
ISDT Date Intended settlement date
DEDT Date Settlement date
FIDT Date Setttlement finality date
ENDDT Date End settlement date
CDCP Boolean CDCP creation flag
TYPV Char (1) TYPVYP Type of settlement instruction
OBC Char (11) Seller/Buyer BIC code
POBC Char (11) Seller BIC code
NOBC Char (11) Buyer BIC code
CUST Numeric (4,0) Custodian code

Output field

NameTypeDomainDescription
PREVU * Char (15) Ultimate Transfer ID
PREV * Char (15) Transfer ID
PREVP Char (15) Parent Transfer ID
DNOOR Numeric (12,0) DB instruction ID
KNOOR Numeric (12,0) CR instruction ID
CARM * Numeric (4,0) [0-9]{1,3} Debit side participant code
CAEM * Numeric (4,0) [0-9]{1,3} Credit side participant code
DRCMA Char (12) CDCP Account number - debit site
KRCMA Char (12) [0-9]{12} Credited asset account number
CNDC * Char (2) NDCPTE DB sub-account type
CNCC * Char (2) NDCPTE CR sub-account type
DSEME Char (16) DB SWIFT message ID
KSEME Char (16) CR SWIFT message ID
CVAL * Char (12) [A-Z0-9]{12} Instrument ID
TYOP * Char (3) TYPOPE Operation type
DTYPT Char (4) TYPT Type of transaction - debit
KTYPT Char (4) TYPT Type of transaction - credit
STMV * Char (2) STAMVT Instruction/transfer status
QTET * Numeric (11,0) Quantity
CREX Numeric (18,7) Trade price
MTMV Numeric (15,2) Trade value
DEVI * Char (3) DEVISE Currency
IUDE * Date Statement date
UODT * Date Trade date
NEDT * Date Transfer Creation date
ISDT * Date Intended settlement date
DEDT * Date Settlement date
FITS Timestamp Setttlement finality timestamp
ENDDT * Date End settlement date
DCODA Char (7) DB reason of current status
KCODA Char (7) CR reason of current status
ZASP Numeric (12,0) Right ID
CDCP Boolean CDCP creation flag
CMMT Char (250) Comments
TYPV * Char (1) TYPVYP Type of settlement instruction
POBC Char (11) Seller BIC code
NOBC Char (11) Buyer BIC code
PCUS Numeric (4,0) [0-9]{1,3} Custodian participant code -debit side
NCUS Numeric (4,0) [0-9]{1,3} Custodian participant code -credit side
NETS * Timestamp Transfer creation timestamp
SCTS Timestamp Settlement blockation
DFTTS Timestamp Last change performed by participant DB
CFTTS Timestamp Last change performed by participant CR