Service dr300 / 45300

Internal service

Download CLF member balances from the cdcp.clf_balance table. The input field serves as a filter and at least one must be entered.

Input field

NameTypeDomainDescription
ID Numeric (10,0) Balance ID
CRDT Date Accounting day
CDAC Numeric (4,0)
TYPL Char (3) TYPPLT Payment type
PRIS Numeric (14,2) Contribution
ZUST Numeric (14,2) New balance
DEVI Char (3) DEVISE Currency
POSL Boolean Current balances

Output field

NameTypeDomainDescription
ID * Numeric (10,0) Balance ID
CRDT * Date Accounting day
CCDT * Date Payment date
CDAC * Numeric (4,0) [0-9]{1,3} Participant code
TYPL * Char (3) TYPPLT Payment type
PRIS * Numeric (14,2) Contribution
ZUST * Numeric (14,2) New balance
BEZS * Numeric (14,2) Balance without penalty
DEVI * Char (3) DEVISE Currency code
CMMT Char (250) Comments
NMDM * Char (10) Last changing user
SERV * Char (10) Last changing user
UPDT * Date Update date
UPTS * Timestamp Timestamp date