📄Placeholders Database

This table lists all the dynamic fields (placeholders) available in a template or document. These placeholders are used to automatically insert specific information, such as names, dates, addresses, and other variable data, into a document. The table helps users understand where and how to use each placeholder, ensuring accurate and efficient document generation. To insert (copy) a placeholder into your document template, use the following structure:

MERGEFIELD $placeholder_title \*MERGEFORMAT

This format ensures the placeholder is correctly set up for dynamic data insertion. Replace $placeholder_title with the specific placeholder name from your list (e.g., $price).

Variable	Description	Category	Status
r	List of condominiums	Units (lists)
foreach($u in $art_workshop)	List of art workshops	Units (lists)
foreach($u in $motorbike_parking)	List of parking positions for motorbikes	Units (lists)
foreach($u in $apartment)	List of suites	Units (lists)
foreach($u in $parking)	List of parking positions	Units (lists)
foreach($u in $land)	List of lands	Units (lists)
foreach($u in $office)	List of offices	Units (lists)
foreach($u in $storage)	List of storages	Units (lists)
foreach($u in $atelier)	List of ateliers	Units (lists)
foreach($u in $utility_room)	List of utility rooms	Units (lists)
foreach($u in $non_residential_unit)	List of non-residential units	Units (lists)
foreach($u in $townhouse)	List of townhouses	Units (lists)
foreach($u in $commercial_space)	List of commercial spaces	Units (lists)
foreach($u in $flat)	List of flats	Units (lists)
foreach($u in $garage)	List of garages	Units (lists)
foreach($u in $family_house)	List of family houses	Units (lists)
foreach($u in $outdoor_parking)	List of outdoor parking positions	Units (lists)
foreach($u in $accommodation_unit)	List of accommodation units	Units (lists)
foreach($u in $creative_workshop)	List of creative workshops	Units (lists)
foreach($u in $cellar)	List of cellars	Units (lists)
u.priceVatRate	VAT rate of the unit (as percent i.e. 20%)	Units (item)
u.priceNoVAT	Price of the unit without VAT	Units (item)
u.priceVatAmount_sk	VAT amount of the unit in Slovak	Units (item)
u.area	Area of the unit	Units (item)
u.priceVatAmount	VAT amount of the unit	Units (item)
u.priceVAT_cz	Price of the unit with VAT (amount as words in Czech)	Units (item)
u.floorNo	Floor number of the unit	Units (item)
u.building	Building name	Units (item)
u.priceVAT	Price of the unit with VAT	Units (item)
u.floorNoAbsolute	Absolute value of floor number of the unit	Units (item)
u.priceVAT_sk	Price of the unit with VAT (amount as words in Slovak)	Units (item)
u.priceNoVAT_cz	Price of the unit without VAT (amount as words in Czech)	Units (item)
u.priceVatAmount_cz	VAT amount of the unit in Czech	Units (item)
u.priceNoVAT_sk	Price of the unit without VAT (amount as words in Slovak)	Units (item)
u.internalId	Internal ID of the unit	Units (item)
outdoorParkingPriceVAT_cz	Outdoor parking price with VAT (amount as words in Czech)	Units
aggregated_office_vat	Sum of discounted prices of all offices on the deal with VAT	Units
flatFinalPriceNoVat	Final price of main unit on the deal without VAT (after all discounts)	Units
parkingFloorNo	Parking floor number	Units
outdoorParkingFloorN	???	Units
cellarArea	Cellar area	Units
cellarPriceVAT_cz	Cellar price with VAT (amount as words in Czech)	Units
aggregated_flat_novat	Sum of discounted prices of all flats on the deal without VAT	Units
parkingPriceNoVAT	Parking price without VAT	Units
terraceArea	Terrace area of main unit on the deal	Units
aggregated_storage_vat	Sum of discounted prices of all storages on the deal with VAT	Units
isBalcony	True if main unit on the deal has balcony	Units
outdoorParkingId	???	Units
aggregated_family_house_novat	Sum of discounted prices of all family houses on the deal without VAT	Units
aggregated_apartment_vat	Sum of discounted prices of all suites on the deal with VAT	Units
aggregated_townhouse_novat	Sum of discounted prices of all townhouses on the deal without VAT	Units
flatPriceVAT_sk	Price of main unit on the deal with VAT (amount as words in Slovak)	Units
aggregated_cellar_novat	Sum of discounted prices of all cellars on the deal without VAT	Units
parkingPriceVAT_sk	Parking price with VAT (amount as words in Slovak)	Units
aggregated_flat_vat	Sum of discounted prices of all flats on the deal with VAT	Units
parkingPriceNoVAT_cz	Parking price without VAT (amount as words in Czech)	Units
flatPriceVAT_cz	Price of main unit on the deal with VAT (amount as words in Czech)	Units
aggregated_garage_vat	Sum of discounted prices of all garages on the deal with VAT	Units
parkingPriceVAT_cz	Parking price with VAT (amount as words in Czech)	Units
aggregated_creative_workshop_vat	Sum of discounted prices of all creative workshops on the deal with VAT	Units
aggregated_parking_vat	Sum of discounted prices of all parking positions on the deal with VAT	Units
garageFloorNo	Garage floor number	Units
gardenArea	Garden area of main unit on the deal	Units
aggregated_motorbike_parking_novat	Sum of discounted prices of all parking positions for motorbikes on the deal without VAT	Units
isLoggia	True if main unit on the deal has loggia	Units
aggregated_land_vat	Sum of discounted prices of all lands on the deal with VAT	Units
cellarPriceVAT	Cellar price with VAT	Units
garageId	Garage internal ID	Units
aggregated_atelier_vat	Sum of discounted prices of all ateliers on the deal with VAT	Units
aggregated_motorbike_parking_vat	Sum of discounted prices of all parking positions for motorbikes on the deal with VAT	Units
aggregated_cellar_vat	Sum of discounted prices of all cellars on the deal with VAT	Units
outdoorParkingPriceNoVAT	Outdoor parking price without VAT	Units
aggregated_garage_novat	Sum of discounted prices of all garages on the deal without VAT	Units
outdoorParkingPriceNoVAT_sk	Outdoor parking price without VAT (amount as words in Slovak)	Units
aggregated_atelier_novat	Sum of discounted prices of all ateliers on the deal without VAT	Units
aggregated_art_workshop_vat	Sum of discounted prices of all art workshops on the deal with VAT	Units
flatFloorNo	Floor number of main unit on the deal	Units
aggregated_accommodation_unit_novat	Sum of discounted prices of all accommodation units on the deal without VAT	Units
aggregated_non_residential_unit_vat	Sum of discounted prices of all non-residential units on the deal with VAT	Units
aggregated_family_house_vat	Sum of discounted prices of all family houses on the deal with VAT	Units
aggregated_accommodation_unit_vat	Sum of discounted prices of all accommodation units on the deal with VAT	Units
aggregated_non_residential_unit_novat	Sum of discounted prices of all non-residential units on the deal without VAT	Units
aggregated_art_workshop_novat	Sum of discounted prices of all art workshops on the deal without VAT	Units
cellarId	Cellar internal ID	Units
parcelNumber	Value of “parcel_number” attribute	Units
aggregated_office_novat	Sum of discounted prices of all offices on the deal without VAT	Units
buildingName	Building name of the main unit on the deal	Units
parkingPriceNoVAT_sk	Parking price without VAT (amount as words in Slovak)	Units
flatDisposition	Disposition of main unit on the deal	Units
aggregated_land_novat	Sum of discounted prices of all lands on the deal without VAT	Units
aggregated_utility_room_novat	Sum of discounted prices of all utility rooms on the deal without VAT	Units
isTerrace	True if main unit on the deal has terrace	Units
isGross	True if main unit on the deal has gross area	Units
outdoorParkingPriceVAT	Outdoor parking price with VAT	Units
garagePriceNoVAT_cz	Garage price without VAT (amount as words in Czech)	Units
flatPriceVAT	Price of main unit on the deal with VAT	Units
grossArea	Gross area of main unit on the deal	Units
parkingId	Parking internal ID	Units
aggregated_condominium_vat	Sum of discounted prices of all condominiums on the deal with VAT	Units
loggiaArea	Loggia area of main unit on the deal	Units
flatPriceNoVAT_cz	Price of main unit on the deal without VAT (amount as words in Czech)	Units
flatVAT	VAT rate of main unit on the deal	Units
garagePriceNoVAT	Garage price without VAT	Units
isParking	True if deal has parking	Units
cellarPriceVAT_sk	Cellar price with VAT (amount as words in Slovak)	Units
aggregated_creative_workshop_novat	Sum of discounted prices of all creative workshops on the deal without VAT	Units
flatFinalSQMPrice	Final price per square meter/foot of main unit on the deal without VAT (after all discounts)	Units
isMotorbikeParking	True if deal has motorbike parking	Units
aggregated_apartment_novat	Sum of discounted prices of all suites on the deal without VAT	Units
garagePriceVAT	Garage price with VAT	Units
flatFinalPriceVat	Final price of main unit on the deal with VAT (after all discounts)	Units
flatPriceNoVAT_sk	Price of main unit on the deal without VAT (amount as words in Slovak)	Units
outdoorParkingPriceNoVAT_cz	Outdoor parking price without VAT (amount as words in Czech)	Units
flatId	Internal ID of main unit on the deal	Units
aggregated_commercial_space_vat	Sum of discounted prices of all commercial spaces on the deal with VAT	Units
aggregated_utility_room_vat	Sum of discounted prices of all utility rooms on the deal with VAT	Units
isCellar	True if deal has cellar	Units
aggregated_townhouse_vat	Sum of discounted prices of all townhouses on the deal with VAT	Units
unitsDescription	Descriptions of all units of the deal	Units
garagePriceVAT_sk	Garage price with VAT (amount as words in Slovak)	Units
aggregated_storage_novat	Sum of discounted prices of all storages on the deal without VAT	Units
aggregated_outdoor_parking_vat	Sum of discounted prices of all outdoor parking positions on the deal with VAT	Units
aggregated_commercial_space_novat	Sum of discounted prices of all commercial spaces on the deal without VAT	Units
cellarFloorNo	Cellar floor number	Units
isGarage	True if deal has garage	Units
flatArea	Area of main unit on the deal	Units
garagePriceNoVAT_sk	Garage price without VAT (amount as words in Slovak)	Units
flatPriceNoVAT	Price of main unit on the deal without VAT	Units
garagePriceVAT_cz	Garage price with VAT (amount as words in Czech)	Units
aggregated_condominium_novat	Sum of discounted prices of all condominiums on the deal without VAT	Units
balconyArea	Balcony area of main unit on the deal	Units
isOutdoorParking	True if deal has outdoor parking	Units
parkingPriceVAT	Parking price with VAT	Units
isGarden	True if main unit on the deal has garden	Units
isStorage	True if deal has storage	Units
aggregated_outdoor_parking_novat	Sum of discounted prices of all outdoor parking positions on the deal without VAT	Units
outdoorParkingPriceVAT_sk	Outdoor parking price with VAT (amount as words in Slovak)	Units
c.customer_escrow_account_number	Customer attribute	Customers (Item)
c.customer_court	Customer attribute	Customers (Item)
c.address	Contact address of the customer	Customers (Item)
c.isLegal	True if customer is legal entity	Customers (Item)
c.isNatural	True if customer is person	Customers (Item)
c.maritalStatus	Marital status of the customer (person only)	Customers (Item)
c.nationality	Nationality of the customer (person only)	Customers (Item)
c.birthDate	Birth date of the customer (person only)	Customers (Item)
c.isBankConnection	True if customer has bank connection	Customers (Item)
c.iban	IBAN of the customer	Customers (Item)
c.isAddress	True if customer has contact address	Customers (Item)
c.executive	Executive of the customer (legal entity only)	Customers (Item)
c.permanentAddress	Permanent (person) or resident (legal entity) address	Customers (Item)
c.customer_registration_number	Customer attribute	Customers (Item)
c.vatid	VAT ID (SK) of the customer (legal entity only)	Customers (Item)
c.isPermanentAddress	True if customer has permanent (person) or resident (legal entity) address	Customers (Item)
c.phone	Phone number of the customer	Customers (Item)
c.isSomeoneAfter	True if this isn’t last customer in the list	Customers (Item)
c.personalNumber	Personal number of the customer (person only)	Customers (Item)
c.fullName	Full name of the customer	Customers (Item)
c.firstName	Name of the customer	Customers (Item)
c.surname	Surname of the customer	Customers (Item)
c.maidenName	Maiden name of the customer (person only)	Customers (Item)
c.title	Title of the customer	Customers (Item)
c.in	IN of the customer (legal entity only)	Customers (Item)
c.email	Email address of the customer	Customers (Item)
c.bankConnection	Bank connection of the customer	Customers (Item)
c.tin	VAT ID of the customer (legal entity only)	Customers (Item)
c.accountNumber	Account number of the customer	Customers (Item)
customer1Name	Name of the main customer on the deal	Customers
isAdditionalCustomers	True if there are additional customers on the deal	Customers
customer5Name	Name of the 4th additional customer on the deal	Customers
customer4Name	Name of the 3rd additional customer on the deal	Customers
customer6Name	Name of the 5th additional customer on the deal	Customers
customer2Name	Name of the 1st additional customer on the deal	Customers
customer3Name	Name of the 2nd additional customer on the deal	Customers
deal_specific_symbol	Value of “deal_specific_symbol” attribute	Deal (attributes)
deal_rc_number	Value of “deal_rc_number” attribute	Deal (attributes)
is_deal_specific_symbol	True if “deal_specific_symbol” attribute has value	Deal (attributes)
is_deal_rc_number	True if “deal_rc_number” attribute has value	Deal (attributes)
documentRECLAMATION_RECEIVED_PROTOCOLType	Reclamation protocol document name (in current user locale)	Deal (documents)
documentTRANSFER_AGREEMENTSignatureDate	Transfer agreement document signature date	Deal (documents)
documentFPC_ADDENDUMType	FPC addendum document name (in current user locale)	Deal (documents)
documentINFORMATIONAL_LETTERSignatureDate	Informational letter document signature date	Deal (documents)
documentADDITIONAL_PRODUCT_CONTRACTType	Additional product contract document name (in current user locale)	Deal (documents)
documentRESERVATION_AGREEMENTSignatureDate	Reservation agreement document signature date	Deal (documents)
documentRESERVATIONS_LIFTING_CONFIRMATIONSignatureDate	Confirmation of lifting the reservations document signature date	Deal (documents)
documentTECHNICAL_INSPECTION_PROTOCOLSignatureDate	Technical inspection protocol document signature date	Deal (documents)
documentDEFECT_REMOVAL_INSPECTION_PROTOCOLType	Defect removal inspection protocol document name (in current user locale)	Deal (documents)
documentESCROW_CONTRACTSignatureDate	Escrow contract document signature date	Deal (documents)
documentRESERVATIONS_LISTDeadline	List of reservations document signature deadline	Deal (documents)
documentPLEDGE_CONTRACTType	Pledge contract document name (in current user locale)	Deal (documents)
documentPURCHASE_CONTRACTDeadline	Purchase contract document signature deadline	Deal (documents)
documentFUTURE_PURCHASE_CONTRACTType	Future purchase contract document name (in current user locale)	Deal (documents)
documentOTHERSignatureDate	Other document signature date	Deal (documents)
documentADDITIONAL_PRODUCT_CONTRACTSignatureDate	Additional product contract document signature date	Deal (documents)
documentRECLAMATION_RECEIVED_PROTOCOLDeadline	Reclamation protocol document signature deadline	Deal (documents)
documentRESERVATION_CONTRACTSignatureDate	Reservation contract document signature date	Deal (documents)
documentINFORMATIONAL_LETTERDeadline	Informational letter document signature deadline	Deal (documents)
documentPLEDGE_CONTRACTSignatureDate	Pledge contract document signature date	Deal (documents)
documentRESERVATIONS_LISTType	List of reservations document name (in current user locale)	Deal (documents)
documentRECLAMATION_PROTOCOL_GENERAL_CONTACTORType	Reclamation protocol general contractor document name (in current user locale)	Deal (documents)
documentCADASTRE_ENTRY_CONFIRMATIONSignatureDate	Cadastre entry notification document signature date	Deal (documents)
documentMORTGAGE_CONTRACTType	Mortgage contract document name (in current user locale)	Deal (documents)
documentTRANSFER_AGREEMENTDeadline	Transfer agreement document signature deadline	Deal (documents)
documentTECHNICAL_INSPECTION_PROTOCOLDeadline	Technical inspection protocol document signature deadline	Deal (documents)
documentPURCHASE_CONTRACTSignatureDate	Purchase contract document signature date	Deal (documents)
documentRESERVATIONS_LIFTING_CONFIRMATIONDeadline	Confirmation of lifting the reservations document signature deadline	Deal (documents)
documentADDITIONAL_PRODUCT_CONTRACTDeadline	Additional product contract document signature deadline	Deal (documents)
documentUNIT_HANDOVER_PROTOCOLSignatureDate	Unit handover protocol document signature date	Deal (documents)
documentPURCHASE_CONTRACTType	Purchase contract document name (in current user locale)	Deal (documents)
documentOTHERType	Other document name (in current user locale)	Deal (documents)
documentBANK_AGREEMENTType	Bank agreement document name (in current user locale)	Deal (documents)
documentRECLAMATION_PROTOCOL_GENERAL_CONTACTORDeadline	Reclamation protocol general contractor document signature deadline	Deal (documents)
documentMORTGAGE_CONTRACTDeadline	Mortgage contract document signature deadline	Deal (documents)
documentESCROW_CONTRACTDeadline	Escrow contract document signature deadline	Deal (documents)
documentSECUREMENT_AGREEMENTSignatureDate	Securement agreement document signature date	Deal (documents)
documentCADASTRE_ENTRY_CONFIRMATIONType	Cadastre entry notification document name (in current user locale)	Deal (documents)
documentRESERVATION_AGREEMENTType	Reservation agreement document name (in current user locale)	Deal (documents)
documentOTHERDeadline	Other document signature deadline	Deal (documents)
documentSECUREMENT_AGREEMENTType	Securement agreement document name (in current user locale)	Deal (documents)
documentBANK_AGREEMENTDeadline	Bank agreement document signature deadline	Deal (documents)
documentFPC_ADDENDUMDeadline	FPC addendum document signature deadline	Deal (documents)
documentRESERVATION_CONTRACTType	Reservation contract document name (in current user locale)	Deal (documents)
documentDEFECT_REMOVAL_INSPECTION_PROTOCOLDeadline	Defect removal inspection protocol document signature deadline	Deal (documents)
documentINFORMATIONAL_LETTERType	Informational letter document name (in current user locale)	Deal (documents)
documentRECLAMATION_RECEIVED_PROTOCOLSignatureDate	Reclamation protocol document signature date	Deal (documents)
documentDEFECT_REMOVAL_INSPECTION_PROTOCOLSignatureDate	Defect removal inspection protocol document signature date	Deal (documents)
documentSECUREMENT_AGREEMENTDeadline	Securement agreement document signature deadline	Deal (documents)
documentFFS_AGREEMENTSignatureDate	FFS agreement document signature date	Deal (documents)
documentFUTURE_PURCHASE_CONTRACTSignatureDate	Future purchase contract document signature date	Deal (documents)
documentFPC_ADDENDUMSignatureDate	FPC addendum document signature date	Deal (documents)
documentRECLAMATION_PROTOCOL_GENERAL_CONTRACTORSignatureDate	Reclamation protocol general contractor document signature date	Deal (documents)
documentFFS_AGREEMENTType	FFS agreement document name (in current user locale)	Deal (documents)
documentCADASTRE_ENTRY_CONFIRMATIONDeadline	Cadastre entry notification document signature deadline	Deal (documents)
documentRESERVATION_CONTRACTDeadline	Reservation contract document signature deadline	Deal (documents)
documentUNIT_HANDOVER_PROTOCOLDeadline	Unit handover protocol document signature deadline	Deal (documents)
documentESCROW_CONTRACTType	Escrow contract document name (in current user locale)	Deal (documents)
documentRESERVATIONS_LISTSignatureDate	List of reservations document signature date	Deal (documents)
documentMORTGAGE_CONTRACTSignatureDate	Mortgage contract document signature date	Deal (documents)
documentTECHNICAL_INSPECTION_PROTOCOLType	Technical inspection protocol document name (in current user locale)	Deal (documents)
documentFFS_AGREEMENTDeadline	FFS agreement document signature deadline	Deal (documents)
documentTRANSFER_AGREEMENTType	Transfer agreement document name (in current user locale)	Deal (documents)
documentPLEDGE_CONTRACTDeadline	Pledge contract document signature deadline	Deal (documents)
documentRESERVATIONS_LIFTING_CONFIRMATIONType	Confirmation of lifting the reservations document name (in current user locale)	Deal (documents)
documentFUTURE_PURCHASE_CONTRACTDeadline	Future purchase contract document signature deadline	Deal (documents)
documentRESERVATION_AGREEMENTDeadline	Reservation agreement document signature deadline	Deal (documents)
documentBANK_AGREEMENTSignatureDate	Bank agreement document signature date	Deal (documents)
documentUNIT_HANDOVER_PROTOCOLType	Unit handover protocol document name (in current user locale)	Deal (documents)
paymentFpc6Amount_cz	6th FPC payment amount with VAT (amount as words in Czech)	Deal (payments)
paymentFpc5AmountJustVAT_sk	VAT amount in 5th FPC payment (amount as words in Slovak)	Deal (payments)
paymentFpc3Amount_cz	3rd FPC payment amount with VAT (amount as words in Czech)	Deal (payments)
is_paymentFpc6AmountNoVAT	True if 6th FPC payment amount without VAT exists	Deal (payments)
paymentReservationFeeAndFpc1Amount_cz	Reservation fee and 1st FPC payments amount with VAT (amount as words in Czech)	Deal (payments)
is_paymentFpc6AmountJustVAT	True if VAT amount in 6th FPC payment exists	Deal (payments)
paymentFpc3Amount	3rd FPC payment amount with VAT	Deal (payments)
paymentFpc4Amount_cz	4th FPC payment amount with VAT (amount as words in Czech)	Deal (payments)
paymentFpc3AmountNoVAT_cz	3rd FPC payment amount without VAT (amount as words in Czech)	Deal (payments)
is_paymentFpc3Amount	True if 3rd FPC payment amount with VAT exists	Deal (payments)
paymentFpc5AmountJustVAT	VAT amount in 5th FPC payment	Deal (payments)
paymentFpc6AmountNoVAT_cz	6th FPC payment amount without VAT (amount as words in Czech)	Deal (payments)
paymentFpc5Amount_sk	5th FPC payment amount with VAT (amount as words in Slovak)	Deal (payments)
paymentFpc3AmountJustVAT_sk	VAT amount in 3rd FPC payment (amount as words in Slovak)	Deal (payments)
paymentFpc6AmountJustVAT_sk	VAT amount in 6th FPC payment (amount as words in Slovak)	Deal (payments)
paymentFpc5Amount	5th FPC payment amount with VAT	Deal (payments)
paymentFpc1AmountJustVAT_cz	VAT amount in 1st FPC payment (amount as words in Czech)	Deal (payments)
paymentReservationFeeAndFpc1AmountJustVAT	VAT amount of reservation fee and 1st FPC payments	Deal (payments)
paymentReservationFeeAndFpc1Amount	Reservation fee and 1st FPC payments amount with VAT	Deal (payments)
paymentFpc4Amount_sk	4th FPC payment amount with VAT (amount as words in Slovak)	Deal (payments)
paymentFpc6AmountNoVAT_sk	6th FPC payment amount without VAT (amount as words in Slovak)	Deal (payments)
paymentFpc2AmountNoVAT_cz	2nd FPC payment amount without VAT (amount as words in Czech)	Deal (payments)
paymentFpc2AmountNoVAT	2nd FPC payment amount without VAT	Deal (payments)
is_paymentFpc2AmountJustVAT	True if VAT amount in 2nd FPC payment exists	Deal (payments)
paymentFpc3AmountJustVAT	VAT amount in 3rd FPC payment	Deal (payments)
paymentReservationFeeAndFpc1AmountNoVAT	Reservation fee and 1st FPC payments amount without VAT	Deal (payments)
paymentFpc6AmountNoVAT	6th FPC payment amount without VAT	Deal (payments)
paymentFpc3AmountJustVAT_cz	VAT amount in 3rd FPC payment (amount as words in Czech)	Deal (payments)
paymentFpc4AmountJustVAT_cz	VAT amount in 4th FPC payment (amount as words in Czech)	Deal (payments)
is_paymentFpc4Amount	True if 4th FPC payment amount with VAT exists	Deal (payments)
paymentReservationFeeAndFpc1AmountNoVAT_cz	Reservation fee and 1st FPC payments amount without VAT (amount as words in Czech)	Deal (payments)
paymentFpc2Amount_cz	2nd FPC payment amount with VAT (amount as words in Czech)	Deal (payments)
paymentFpc4AmountJustVAT	VAT amount in 4th FPC payment	Deal (payments)
paymentFpc2AmountJustVAT_cz	VAT amount in 2nd FPC payment (amount as words in Czech)	Deal (payments)
paymentFpc3AmountNoVAT_sk	3rd FPC payment amount without VAT (amount as words in Slovak)	Deal (payments)
paymentFpc4Amount	4th FPC payment amount with VAT	Deal (payments)
is_paymentFpc2AmountNoVAT	True if 2nd FPC payment amount without VAT exists	Deal (payments)
paymentFpc6Amount_sk	6th FPC payment amount with VAT (amount as words in Slovak)	Deal (payments)
is_paymentFpc4AmountJustVAT	True if VAT amount in 4th FPC payment exists	Deal (payments)
paymentFpc5AmountNoVAT	5th FPC payment amount without VAT	Deal (payments)
paymentFpc3AmountNoVAT	3rd FPC payment amount without VAT	Deal (payments)
paymentFpc6AmountJustVAT	VAT amount in 6th FPC payment	Deal (payments)
paymentFpc5AmountNoVAT_sk	5th FPC payment amount without VAT (amount as words in Slovak)	Deal (payments)
is_paymentFpc3AmountNoVAT	True if 3rd FPC payment amount without VAT exists	Deal (payments)
is_paymentFpc1AmountJustVAT	True if VAT amount in 1st FPC payment exists	Deal (payments)
is_paymentFpc5Amount	True if 5th FPC payment amount with VAT exists	Deal (payments)
paymentReservationFeeAndFpc1AmountNoVAT_sk	Reservation fee and 1st FPC payments amount without VAT (amount as words in Slovak)	Deal (payments)
paymentFpc2AmountNoVAT_sk	2nd FPC payment amount without VAT (amount as words in Slovak)	Deal (payments)
paymentFpc6AmountJustVAT_cz	VAT amount in 6th FPC payment (amount as words in Czech)	Deal (payments)
is_paymentFpc5AmountNoVAT	True if 5th FPC payment amount without VAT exists	Deal (payments)
paymentReservationFeeAndFpc1Amount_sk	Reservation fee and 1st FPC payments amount with VAT (amount as words in Slovak)	Deal (payments)
paymentFpc5AmountNoVAT_cz	5th FPC payment amount without VAT (amount as words in Czech)	Deal (payments)
paymentReservationFeeAndFpc1AmountJustVAT_sk	VAT amount of reservation fee and 1st FPC payments (amount as words in Slovak)	Deal (payments)
paymentFpc3Amount_sk	3rd FPC payment amount with VAT (amount as words in Slovak)	Deal (payments)
paymentFpc6Amount	6th FPC payment amount with VAT	Deal (payments)
is_paymentFpc5AmountJustVAT	True if VAT amount in 5th FPC payment exists	Deal (payments)
paymentReservationFeeAndFpc1AmountJustVAT_cz	VAT amount of reservation fee and 1st FPC payments (amount as words in Czech)	Deal (payments)
variableSymbol	Deal variable symbol	Basic (deals)
technicalInspectionDate	Date of the first technical inspection	Basic (deals)
salesman	Salesman name	Basic (deals)
salesmanEmail	Salesman email	Basic (deals)
dealPriceVATAmount_sk	VAT amount in discounted deal price (amount as words in Slovak)	Deal (price)
dealPriceWithAdditionalProductsNoVat	Deal price including additional products without VAT	Deal (price)
dealPriceTotal30Percent	30% of discounted deal price with VAT	Deal (price)
customerModificationImplementationPriceNoVat_cz	Customer modification implementation price without VAT (amount as words in Czech)	Deal (price)
dealPriceVAT_cz	Discounted deal price with VAT (amount as words in Czech)	Deal (price)
dealPriceTotal30PercentCustModImplSum	30% of discounted deal price with VAT + customer modification implementation price with VAT	Deal (price)
dealPriceIncludingElectrometerVat	Discounted deal price + electrometer price with VAT	Deal (price)
customerModificationImplementationPriceVat	Customer modification implementation price with VAT	Deal (price)
dealPriceVAT	Discounted deal price with VAT	Deal (price)
dealPriceVATRate_sk	VAT rate in discounted deal price (amount as words in Slovak)	Deal (price)
dealPriceTotal10PercentCustModImplSum	10% of discounted deal price with VAT + customer modification implementation price with VAT	Deal (price)
customerModificationImplementationPriceNoVat	Customer modification implementation price without VAT	Deal (price)
dealPriceVATAmount_cz	VAT amount in discounted deal price (amount as words in Czech)	Deal (price)
dealPriceIgnoredProductsNoVat	Additional products price without VAT	Deal (price)
dealPriceVATAmount	VAT amount in discounted deal price	Deal (price)
dealDiscountVat	Total deal discount with VAT	Deal (price)
dealPriceTotal50ReservationFeePercent	50% of (discounted deal price + reservation fee with VAT)	Deal (price)
electrometerPriceNoVat	Electrometer price without VAT	Deal (price)
dealPriceVATRate_cz	VAT rate in discounted deal price (amount as words in Czech)	Deal (price)
customerModificationImplementationPriceVatAmount	VAT amount in customer modification implementation price	Deal (price)
dealPriceTotal10Percent	10% of discounted deal price with VAT	Deal (price)
dealDiscountNoVat	Total deal discount without VAT	Deal (price)
dealPriceIgnoredProductsVat	Additional products price with VAT	Deal (price)
dealPriceTotal20ReservationFeePercent	20% of (discounted deal price + reservation fee with VAT)	Deal (price)
customerModificationImplementationPriceNoVat_sk	Customer modification implementation price without VAT (amount as words in Slovak)	Deal (price)
customerModificationImplementationPriceVat_cz	Customer modification implementation price with VAT (amount as words in Czech)	Deal (price)
dealPriceWithAdditionalProductsVat	Deal price including additional products with VAT	Deal (price)
dealPriceNoVAT	Discounted deal price without VAT	Deal (price)
dealPriceTotal40PercentCustModImplSum	40% of discounted deal price with VAT + customer modification implementation price with VAT	Deal (price)
dealPriceVAT_sk	Discounted deal price with VAT (amount as words in Slovak)	Deal (price)
electrometerPriceVat	Electrometer price with VAT	Deal (price)
dealPriceIncludingElectrometerNoVat	Discounted deal price + electrometer price without VAT	Deal (price)
customerModificationImplementationPriceVat_sk	Customer modification implementation price with VAT (amount as words in Slovak)	Deal (price)
dealPriceTotal20PercentCustModImplSum	20% of discounted deal price with VAT + customer modification implementation price with VAT	Deal (price)
dealPriceTotal20Percent	20% of discounted deal price with VAT	Deal (price)
dealPriceNoVAT_cz	Discounted deal price without VAT (amount as words in Czech)	Deal (price)
dealPriceVATRate	VAT rate in discounted deal price	Deal (price)
dealPriceTotal10ReservationFeePercent	10% of (discounted deal price + reservation fee with VAT)	Deal (price)
dealPriceNoVAT_sk	Discounted deal price without VAT (amount as words in Slovak)	Deal (price)
dealPriceTotal40Percent	40% of discounted deal price with VAT	Deal (price)
paymentRESERVATION_FEEDeadline	Calculated deadline of reservation fee payment	Deal (payments)
paymentFIRST_PAYMENTType	First payment name (in current user locale)	Deal (payments)
paymentTHIRD_PAYMENTType	Third payment name (in current user locale)	Deal (payments)
paymentRESERVATION_DEPOSITDeadline	Calculated deadline of reservation deposit payment	Deal (payments)
paymentTHIRD_PAYMENTAmountJustVAT	VAT amount in third payment	Deal (payments)
paymentTHIRD_PAYMENTDeadline	Calculated deadline of third payment	Deal (payments)
paymentRESERVATION_DEPOSITAccountType	Account type of reservation deposit payment	Deal (payments)
paymentFPC_PAYMENTAccountType	Account type of FPC payment	Deal (payments)
paymentRESERVATION_DEPOSITType	Reservation deposit payment name (in current user locale)	Deal (payments)
paymentRESERVATION_DEPOSITAmount_cz	Reservation deposit payment amount with VAT (amount as words in Czech)	Deal (payments)
paymentFPC_PAYMENTType	FPC payment name (in current user locale)	Deal (payments)
paymentFIRST_PAYMENTAmount_sk	First payment amount with VAT (amount as words in Slovak)	Deal (payments)
paymentRESERVATION_FEEType	Reservation fee payment name (in current user locale)	Deal (payments)
paymentRESERVATION_DEPOSITAmount_sk	Reservation deposit payment amount with VAT (amount as words in Slovak)	Deal (payments)
paymentRESERVATION_DEPOSITAmountJustVAT	VAT amount in reservation deposit payment	Deal (payments)
paymentSECOND_PAYMENTAmount	Second payment amount with VAT	Deal (payments)
paymentTHIRD_PAYMENTAmount_sk	Third payment amount with VAT (amount as words in Slovak)	Deal (payments)
paymentSECOND_PAYMENTAmountNoVAT	Second payment amount without VAT	Deal (payments)
paymentFIRST_PAYMENTDeadline	Calculated deadline of first payment	Deal (payments)
paymentFPC_PAYMENTAmount_sk	FPC payment amount with VAT (amount as words in Slovak)	Deal (payments)
paymentRESERVATION_FEEAmountJustVAT	VAT amount in reservation fee payment	Deal (payments)
paymentRESERVATION_FEEAmount_sk	Reservation fee payment amount with VAT (amount as words in Slovak)	Deal (payments)
paymentFIRST_PAYMENTAccountType	Account type of first payment	Deal (payments)
paymentSECOND_PAYMENTType	Second payment name (in current user locale)	Deal (payments)
paymentRESERVATION_DEPOSITAmountNoVAT	Reservation deposit payment amount without VAT	Deal (payments)
paymentFIRST_PAYMENTAmountJustVAT	VAT amount in first payment	Deal (payments)
paymentRESERVATION_DEPOSITAmount	Reservation deposit payment amount with VAT	Deal (payments)
paymentFPC_PAYMENTAmountJustVAT	VAT amount in FPC payment	Deal (payments)
paymentFPC_PAYMENTAmount_cz	FPC payment amount with VAT (amount as words in Czech)	Deal (payments)
paymentRESERVATION_FEEAmount_cz	Reservation fee payment amount with VAT (amount as words in Czech)	Deal (payments)
paymentFPC_PAYMENTDeadline	Calculated deadline of FPC payment	Deal (payments)
paymentSECOND_PAYMENTAccountType	Account type of second payment	Deal (payments)
paymentRESERVATION_FEEAmount	Reservation fee payment amount with VAT	Deal (payments)
paymentSECOND_PAYMENTAmountJustVAT	VAT amount in second payment	Deal (payments)
paymentTHIRD_PAYMENTAmountNoVAT	Third payment amount without VAT	Deal (payments)
paymentSECOND_PAYMENTAmount_cz	Second payment amount with VAT (amount as words in Czech)	Deal (payments)
paymentTHIRD_PAYMENTAmount_cz	Third payment amount with VAT (amount as words in Czech)	Deal (payments)
paymentTHIRD_PAYMENTAmount	Third payment amount with VAT	Deal (payments)
paymentFIRST_PAYMENTAmount	First payment amount with VAT	Deal (payments)
paymentFIRST_PAYMENTAmountNoVAT	First payment amount without VAT	Deal (payments)
paymentSECOND_PAYMENTAmount_sk	Second payment amount with VAT (amount as words in Slovak)	Deal (payments)
paymentRESERVATION_FEEAccountType	Account type of reservation fee payment	Deal (payments)
paymentFPC_PAYMENTAmountNoVAT	FPC payment amount without VAT	Deal (payments)
paymentSECOND_PAYMENTDeadline	Calculated deadline of second payment	Deal (payments)
paymentTHIRD_PAYMENTAccountType	Account type of third payment	Deal (payments)
paymentRESERVATION_FEEAmountNoVAT	Reservation fee payment amount without VAT	Deal (payments)
paymentFIRST_PAYMENTAmount_cz	First payment amount with VAT (amount as words in Czech)	Deal (payments)
paymentFPC_PAYMENTAmount	FPC payment amount with VAT	Deal (payments)
paymentADDITIONAL_PAYMENTDeadline	Calculated deadline of additional payment	Deal (payments)
paymentTECHNICAL_AREA_PAYMENTAmount_sk	Technical area payment amount with VAT (amount as words in Slovak)	Deal (payments)
paymentADDITIONAL_PRODUCT_PAYMENTAmount_sk	Additional product payment amount with VAT (amount as words in Slovak)	Deal (payments)
paymentADDITIONAL_PRODUCT_PAYMENTDeadline	Calculated deadline of additional product payment	Deal (payments)
paymentADDITIONAL_PRODUCT_PAYMENTAmountNoVAT	Additional product payment amount without VAT	Deal (payments)
paymentADDITIONAL_PAYMENTAmountNoVAT	Additional payment amount without VAT	Deal (payments)
paymentADDITIONAL_PRODUCT_PAYMENTAccountType	Account type of additional product payment	Deal (payments)
paymentPAYMENTAccountType	Account type of universal payment	Deal (payments)
paymentADDITIONAL_PRODUCT_PAYMENTAmount	Additional product payment amount with VAT	Deal (payments)
paymentPAYMENTAmountJustVAT	VAT amount in universal payment	Deal (payments)
paymentPAYMENTAmount	Universal payment amount with VAT	Deal (payments)
paymentPAYMENTAmount_sk	Universal payment amount with VAT (amount as words in Slovak)	Deal (payments)
paymentADDITIONAL_PRODUCT_PAYMENTType	Additional product payment name (in current user locale)	Deal (payments)
paymentTECHNICAL_AREA_PAYMENTAmount	Technical area payment amount with VAT	Deal (payments)
paymentADDITIONAL_PAYMENTAmount_cz	Additional payment amount with VAT (amount as words in Czech)	Deal (payments)
paymentPAYMENTAmount_cz	Universal payment amount with VAT (amount as words in Czech)	Deal (payments)
paymentPAYMENTType	Universal payment name (in current user locale)	Deal (payments)
paymentADDITIONAL_PAYMENTAmountJustVAT	VAT amount in additional payment	Deal (payments)
paymentPAYMENTDeadline	Calculated deadline of universal payment	Deal (payments)
paymentTECHNICAL_AREA_PAYMENTDeadline	Calculated deadline of technical area payment	Deal (payments)
paymentTECHNICAL_AREA_PAYMENTAmount_cz	Technical area payment amount with VAT (amount as words in Czech)	Deal (payments)
paymentADDITIONAL_PAYMENTAmount_sk	Additional payment amount with VAT (amount as words in Slovak)	Deal (payments)
paymentADDITIONAL_PAYMENTType	Additional payment name (in current user locale)	Deal (payments)
paymentPAYMENTAmountNoVAT	Universal payment amount without VAT	Deal (payments)
paymentADDITIONAL_PRODUCT_PAYMENTAmountJustVAT	VAT amount in additional product payment	Deal (payments)
paymentADDITIONAL_PRODUCT_PAYMENTAmount_cz	Additional product payment amount with VAT (amount as words in Czech)	Deal (payments)
paymentTECHNICAL_AREA_PAYMENTAmountJustVAT	VAT amount in technical area payment	Deal (payments)
paymentADDITIONAL_PAYMENTAccountType	Account type of additional payment	Deal (payments)
paymentADDITIONAL_PAYMENTAmount	Additional payment amount with VAT	Deal (payments)
paymentTECHNICAL_AREA_PAYMENTType	Technical area payment name (in current user locale)	Deal (payments)
paymentTECHNICAL_AREA_PAYMENTAccountType	Account type of technical area payment	Deal (payments)
paymentTECHNICAL_AREA_PAYMENTAmountNoVAT	Technical area payment amount without VAT	Deal (payments)
paymentFpc1Amount_cz	1st FPC payment amount with VAT (amount as words in Czech)	Deal (payments)
isPaymentRESERVATION_FEEPaid	True if Reservation fee is paid	Deal (payments)
paymentFpc1Amount	1st FPC payment amount with VAT	Deal (payments)
is_paymentFpc1Amount	True if 1st FPC payment amount with VAT exists	Deal (payments)
paymentFpc1AmountJustVAT	VAT amount in 1st FPC payment	Deal (payments)
is_paymentFpc1AmountNoVAT	True if 1st FPC payment amount without VAT exists	Deal (payments)
paymentFpc1AmountNoVAT	1st FPC payment amount without VAT	Deal (payments)
paymentFpc1AmountNoVAT_sk	1st FPC payment amount without VAT (amount as words in Slovak)	Deal (payments)
paymentFpc1Amount_sk	1st FPC payment amount with VAT (amount as words in Slovak)	Deal (payments)
paymentFpc1AmountNoVAT_cz	1st FPC payment amount without VAT (amount as words in Czech)	Deal (payments)
paymentFpc5Amount_cz	5th FPC payment amount with VAT (amount as words in Czech)	Deal (payments)
paymentFpc1AmountJustVAT_sk	VAT amount in 1st FPC payment (amount as words in Slovak)	Deal (payments)
paymentFpc4AmountNoVAT_sk	4th FPC payment amount without VAT (amount as words in Slovak)	Deal (payments)
is_paymentFpc3AmountJustVAT	True if VAT amount in 3rd FPC payment exists	Deal (payments)
paymentFpc2AmountJustVAT_sk	VAT amount in 2nd FPC payment (amount as words in Slovak)	Deal (payments)
paymentFpc5AmountJustVAT_cz	VAT amount in 5th FPC payment (amount as words in Czech)	Deal (payments)
is_paymentFpc4AmountNoVAT	True if 4th FPC payment amount without VAT exists	Deal (payments)
paymentFpc2AmountJustVAT	VAT amount in 2nd FPC payment	Deal (payments)
is_paymentFpc6Amount	True if 6th FPC payment amount with VAT exists	Deal (payments)
paymentFpc4AmountNoVAT	4th FPC payment amount without VAT	Deal (payments)
paymentFpc2Amount_sk	2nd FPC payment amount with VAT (amount as words in Slovak)	Deal (payments)
paymentFpc4AmountNoVAT_cz	4th FPC payment amount without VAT (amount as words in Czech)	Deal (payments)
paymentFpc2Amount	2nd FPC payment amount with VAT	Deal (payments)
is_paymentFpc2Amount	True if 2nd FPC payment amount with VAT exists	Deal (payments)
paymentFpc4AmountJustVAT_sk	VAT amount in 4th FPC payment (amount as words in Slovak)	Deal (payments)