Proposal Element
API Details
Property | Value |
---|---|
Endpoint | /tablesHousing/proposalElements |
Table name | Aanbiedingselement |
Table id | 11024061 |
Table caption | Proposal Element |
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 | |||||||
tabel | Table | Option | 4 | * | Rekenhuur, Aanbiedhuur | |||||
clusternr | Cluster No. | Code | 20 | * | ||||||
code | Code | Code | 20 | * | ||||||
eenheidnr | Realty Object No. | Code | 20 | * | ||||||
volgnummer | Contract No. | Integer | 4 | * | ||||||
nr | Element No. | Text | 10 | * | ||||||
btWproductboekingsgroep | VAT Prod. Posting Group | Code | 20 | VAT Product Posting Group | ||||||
omschrijving | Description | Text | 50 | |||||||
soort | Type | Option | 4 | Element, Titel, Totaal, Begintotaal, Eindtotaal | ||||||
samentelling | Addition | Text | 30 | |||||||
bedragLV | Amount (LCY) | Decimal | 12 | |||||||
productboekingsgroep | Prod. Posting Group | Code | 20 | Gen. Product Posting Group | ||||||
elementsoort | Element Type | Option | 4 | , Service, Verbruik, Water, Kale huur, Waarborgsom, Huurmatiging, Parkeerplaats buiten, Parkeerplaats binnen, Huurkorting, BTW-compensatie | ||||||
eenmalig | One-off | Boolean | 4 | |||||||
eenheid | Unit | Text | 10 | |||||||
afrekenenOpBasisVan | Settlement basis | Option | 4 | Geïnd excl. voorstand, Geïnd incl. voorstand, Vervallen | ||||||
afrekenenMet | Settle with | Option | 4 | Eigenaar, Beheerder | ||||||
provisieOver | Commision on | Option | 4 | Geïnd (incl. BTW), Vervallen (incl. BTW), Geïnd (excl. BTW), Vervallen (excl. BTW), Geen | ||||||
aantal | Quantity | Decimal | 12 | |||||||
inspringen | Indent | Integer | 4 | |||||||
eenheidprijsLV | Unit Price (LCY) | Decimal | 12 | |||||||
afdrukken | Boolean | 4 | ||||||||
prioriteit | Priority | Integer | 4 | |||||||
verhogingsoort | Type Of Increase | Option | 4 | Niet, %, Bedrag, Punten, Indexering, Vervalt, Toevoegen, Was/Wordt | ||||||
verhoging | Increase | Decimal | 12 | |||||||
indexteller | Index Numerator | Decimal | 12 | |||||||
indexnoemer | Index Denominator | Decimal | 12 | |||||||
indexcode | Index Code | Code | 20 | Indexing Code | ||||||
indexeringsmethode | Indexing Method | Code | 10 | Indexeringsmethode | ||||||
subsidiabel | Eligible | Boolean | 4 | |||||||
openstaandSaldo | Outstanding Balance | Decimal | 12 | |||||||
opHuurverhogingAfdrukken | Print on rent increase document | Boolean | 4 | |||||||
afronding | Rounding Method | Option | 4 | Dichtstbijzijnd, Boven, Onder | ||||||
nauwkeurigheid | Precision | Decimal | 12 | |||||||
belastLeeg | Taxed (Vacant) | Decimal | 12 | |||||||
aantalBelastLeeg | Quantity Taxed (Vacant) | Decimal | 12 | |||||||
belast | Taxed | Decimal | 12 | |||||||
aantalBelast | Quantitiy Taxed | Decimal | 12 | |||||||
btw | VAT | Decimal | 12 | |||||||
btwLeeg | VAT (Vacant) | Decimal | 12 | |||||||
teller | Numerator | Decimal | 12 | |||||||
noemer | Denominator | Decimal | 12 | |||||||
complexnoemer | Complex Denominator | Decimal | 12 | |||||||
noemerBerekend | Calculated Denominator | Decimal | 12 | |||||||
bedrag | Amount | Decimal | 12 | |||||||
eenheidprijs | Unit Price | Decimal | 12 | |||||||
rentIncreaseAmount | Rent Increase Amount | Decimal | 12 | |||||||
voorschotBedrag | Advance Amount | Decimal | 12 | |||||||
verdelingBedrag | Allocation Amount | Decimal | 12 | |||||||
voorschotBTWbedrag | Advance VAT Amount | Decimal | 12 | |||||||
verdelingBTWbedrag | Allocation VAT Amount | Decimal | 12 | |||||||
component | Component | Option | 4 | , G/D-component, Serviceabonnement | ||||||
schoorsteen | Chimney | Boolean | 4 | |||||||
vast | Fixed | Boolean | 4 | |||||||
verrekenbaar | Deductible | Boolean | 4 | |||||||
administratie | Administration | Boolean | 4 | |||||||
leges | Fees | Boolean | 4 | |||||||
diversen | Miscellaneous | Boolean | 4 | |||||||
aanbiedbedrag | Proposal Amount | Decimal | 12 | |||||||
verschil | Difference | Decimal | 12 | |||||||
lopendBedrag | Original Amount | Decimal | 12 | |||||||
aanbiedbedragInclBTWLV | Proposal Amt. incl. VAT (LCY) | Decimal | 12 | |||||||
lopendBedragInclBTWLV | Original Amt. incl. VAT (LCY) | Decimal | 12 | |||||||
verschilBedragInclBTWLV | Difference Amt. incl. VAT (LCY) | Decimal | 12 | |||||||
bedragInclBTW | Amount incl. VAT | Decimal | 12 | |||||||
veraPriceComponentTypeCode | VERA Price Component Type Code | Code | 10 | VERA Price Component Type | ||||||
veraPriceCompDetTypeCode | VERA Price Component Detail Type Code | Code | 10 | |||||||
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 |