Service dl850 / 40850

Internal service

Download of LBS collateral from the lbs.collateral and lbs_collateral_his tables. The input field serves as a filter and at least one must be entered. An empty POSL field means false.

Input field

NameTypeDomainDescription
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
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
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