Sales Proposal Line
API Details
Property | Value |
---|---|
Endpoint | /tablesHousing/salesProposalLines |
Table name | Sales Proposal Line |
Table id | 11024066 |
Table caption | Sales Proposal Line |
Data per company | True |
Group | Housing |
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 | |||||||
aanbieding | Aanbieding | Code | 20 | * | Sales Proposal | |||||
regelnr | Regelnr. | Integer | 4 | * | ||||||
aanbiedingsoort | Aanbiedingsoort | Code | 20 | Proposal Type | ||||||
aanbiedingsvorm | Aanbiedingsvorm | Code | 20 | Proposal Model | ||||||
status | Status | Option | 4 | Aangemaakt, Lopend, Geaccepteerd, Vervallen | ||||||
datumAanbieding | Datum aanbieding | Date | 4 | |||||||
korting | Korting | Code | 20 | |||||||
kortingsPct | Kortings % | Decimal | 12 | |||||||
extraKortingsPct | Extra kortings % | Decimal | 12 | |||||||
koopsomALV | Koopsom (A) (LV) | Decimal | 12 | |||||||
afkoopsomBLV | Afkoopsom (B) (LV) | Decimal | 12 | |||||||
totaleKoopsomLV | Totale koopsom (LV) | Decimal | 12 | |||||||
mutatienr | Mutatienr. | Text | 30 | |||||||
taxateur | Taxateur | Code | 20 | |||||||
taxatiesoort | Taxatiesoort | Option | 4 | Grond, Opstal, Grond en opstal | ||||||
taxatiegrondslag | Taxatiegrondslag | Code | 10 | |||||||
datumTaxatieopdracht | Datum taxatieopdracht | Date | 4 | |||||||
datumTaxatierapport | Datum taxatierapport | Date | 4 | |||||||
taxatiedatum | Taxatiedatum | Date | 4 | |||||||
taxatiewaardeLV | Taxatiewaarde (LV) | Decimal | 12 | |||||||
volgnrTaxatie | Volgnr. taxatie | Integer | 4 | |||||||
mutatienrVorigeMutatie | Mutatienr. vorige mutatie | Text | 30 | |||||||
redencodeExtraKorting | Redencode extra korting | Code | 20 | Discount Reason Code | ||||||
accept | Accept | Boolean | 4 | |||||||
extraKortingsbedrag | Extra Discount Amount | Decimal | 12 | |||||||
wozPct | Totale koopsom t.o.v. WOZ-waarde (%) | Decimal | 12 | |||||||
praisedValuePct | Totale koopsom t.o.v. taxatiewaarde (%) | Decimal | 12 | |||||||
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 |