Cashflow
API Details
Property | Value |
---|---|
Endpoint | /tablesFinance/cashFlows |
Table name | Kasstroom |
Table id | 11030209 |
Table caption | Cashflow |
Data per company | True |
Group | Finance |
Schema
Properties
Property | Table Fieldname | Type | Max.Length | Key | Options | Table relation | Version introduced | Version removed | Obsolete state | Obsolete reason |
---|---|---|---|---|---|---|---|---|---|---|
id | System Id | GUID | 16 | |||||||
financieringsnr | Financing No. | Code | 20 | * | ||||||
finmodelvolgnr | Fin. Model Entry No. | Integer | 4 | * | ||||||
kasstroomvolgnr | Cash Flow Entry No. | Integer | 4 | * | ||||||
ingangsdatum | Start Date | Date | 4 | * | ||||||
soortKasstroom | Cash Flow Type | Code | 10 | Soort kasstroom | ||||||
bedrag | Amount | Decimal | 12 | |||||||
percentageBoete | Early Redemption Perc. | Decimal | 12 | |||||||
percentageSchuldrestant | Percentage Remaining Capital | Decimal | 12 | |||||||
mutatiedatum | Date Approved | Date | 4 | |||||||
gebruikersID | User ID | Code | 50 | User Setup | ||||||
foutmelding | Error Message | Text | 125 | |||||||
prolongatiestatus | Posting Status | Option | 4 | , Akkoord, Actief, Oud | ||||||
vervallen | Void | Boolean | 4 | |||||||
eindaflossing | Final Capital Payment | Boolean | 4 | |||||||
systemId | System ID | GUID | 16 | |||||||
systemCreatedAt | Created At | DateTime | 8 | |||||||
systemCreatedBy | Created By | GUID | 16 | User | ||||||
systemModifiedAt | Modified At | DateTime | 8 | |||||||
systemModifiedBy | Modified By | GUID | 16 | User | ||||||
lastModifiedDateTime | Last Modified Date Time | DateTime | 8 |