This is an old revision of the document!
Field Name | Suggested field name | Type | Mandatory | Default | Description |
---|---|---|---|---|---|
ID | BIGINT | YES | Arkadia internal identifier. Use this field only when importing Arkadia ads to your site. | ||
ID_local | VARCHAR(120) | Partner Internal identifier | |||
ID_import | VARCHAR(50) | ||||
ID_broker | INTEGER | ||||
ID_agent | BIGINT | ||||
ID_notary | BIGINT | The ID of the notary | |||
Creation_date | TIMESTAMP | YES | 'NOW' | ||
Last_alteration_date | TIMESTAMP | YES | 'NOW' | ||
Last_alteration_by | BIGINT | ||||
Transaction | SMALLINT | YES | |||
Category | SMALLINT | YES | |||
Type | SMALLINT | YES | |||
Subtype | SMALLINT | ||||
Classification | SMALLINT | ||||
Admin_status | SMALLINT | YES | 2 (Pending) | ||
Moderate_status | SMALLINT | YES | 1 (Available) | ||
Duplicate_status | SMALLINT | YES | 1 (Available) | ||
User_status | SMALLINT | YES | 2 (Pending) | ||
Status | SMALLINT | YES | |||
Agreement_to_sell_date | DATE | ||||
Closing_date | DATE | ||||
Listing_contract_type | SMALLINT | ||||
Listing_contract_number | VARCHAR(10) | ||||
Listing_contract_begin_date | DATE | ||||
Listing_contract_end_date | DATE | ||||
Listing_contract_renewal_type | SMALLINT | ||||
Availability_date | DATE | ||||
Budget_promotion | Advertising_budget | NUMERIC(18,5) | |||
Salesman_price | Salesman’s_price | NUMERIC(18,5) | The price of a salesman. | ||
Salesman_price_max | Salesman’s_price_max | NUMERIC(18,5) | The maximum price of a salesman. | ||
Original_total_sale_price | NUMERIC(18,5) | The original total price of the selling a real estate. | |||
Total_sale_price_last_mod_date | Total_sale_price_on_last_modified_data | DATE | 'NOW' | The total price of the selling a real estate on last modified data. | |
Total_sale_price | NUMERIC(18,5) | The total price of the selling a real estate. | |||
Total_sale_price_max | NUMERIC(18,5) | The maximum total price of the selling a real estate. | |||
Lease_price | NUMERIC(18,5) | The price for the lease of a real estate. | |||
Lease_end_date | Lease_End_Date | DATE | The expiration date of the lease of a real estate. | ||
ID_tenant | Tenant’s_ID | BIGINT | ID of the Tenant. | ||
tenant_monthly_rent_price | Tenant’s_monthly_rental_price | NUMERIC(18,5) | The tenant’s price for a month for the lease of a real estate. | ||
Monthly_charge | NUMERIC(18,5) | The charge for a month. | |||
Monthly_charge_max | NUMERIC(18,5) | The maximum charge for a month. | |||
Monthly_rent_price | Monthly_rental_price | NUMERIC(18,5) | The price for a month for the lease of a real estate. | ||
Monthly_rent_price_max | Monthly_rental_price_max | NUMERIC(18,5) | The maximum price for a month for the lease of a real estate. | ||
Annual_charge_by_sqm | Annual_charge_per_sqm | NUMERIC(18,5) | The minimum charge for a year per sqm. | ||
Annual_charge_by_sqm_max | Annual_charge_per_sqm_max | NUMERIC(18,5) | The maximum charge for a year per sqm. | ||
Annual_rent_price_by_sqm | Annual_rental_price_per_sqm | NUMERIC(18,5) | The minimum price for a year per sqm for the lease of a real estate. | ||
Annual_rent_price_by_sqm_max | Annual_rental_price_per_sqm_max | NUMERIC(18,5) | The maximum price for a year per sqm for the lease of a real estate. | ||
Week_rent_price_min | Weekly_rental_price_min | NUMERIC(18,5) | The minimum price for a week for the lease of a real estate. | ||
Week_rent_price_max | Weekly_rental_price_max | NUMERIC(18,5) | The maximum price for a week for the lease of a real estate. | ||
Monthly_pension | NUMERIC(18,5) | A fixed sum to be paid regularly to a person, following retirement from service. | |||
Deposit | NUMERIC(18,5) | The amount, that is deposited before the lease of a real estate to insure the owner against the damage. | |||
Land_tax | NUMERIC(18,5) | A levy on the land. | |||
Estimated_price | NUMERIC(18,5) | The price that is estimated. | |||
Hide_prices | NUMERIC(1,0) | The price that is hided. | |||
Transaction_fee_owner | Owner’s_transaction_fees | NUMERIC(18,5) | The owner’s rate of the fee for the transaction. | ||
Transaction_fee_buyer | Buyer’s_transaction_fees | NUMERIC(18,5) | The buyer’s rate of the fee for the transaction. | ||
Inspection_fee_owner | Owner’s_inspection_fees | NUMERIC(18,5) | The owner’s rate of the fee for the inspection. | ||
Inspection_fee_buyer | Buyer’s_inspection_fees | NUMERIC(18,5) | The buyer’s rate of the fee for the inspection. | ||
Document_drafting_fee_owner | Owner’s_document-drafting_fees | NUMERIC(18,5) | The owner’s rate of the fee for the document-drafting. | ||
Document_drafting_fee_buyer | Buyer’s_document-drafting_fees | NUMERIC(18,5) | The buyer’s rate of the fee for the document-drafting. | ||
Transaction_fee_rate_owner | Owner’s_rate_of_transaction_fees | NUMERIC(9,6) | The owner’s rate of the fee for the transaction. | ||
Transaction_fee_rate_buyer | Buyer’s_rate_of_transaction_fees | NUMERIC(9,6) | The buyer’s rate of the fee for the transaction. | ||
Transaction_fee_base_rate | Base_rate_of_transaction_fees | SMALLINT | The base rate of the fee for transaction. | ||
Fee_vat_rate | Vat_rate_on_fees | NUMERIC(4,2) | 0 | The rate of VAT that the fees are charged. | |
Listing_type | Ad_type | SMALLINT | Thy type of the ad in compliance with the package. | ||
Listing_expiration_date | Ad_expiration_date | DATE | The last day that the ad is valid. | ||
Listing_weight | Ad_weight | INTEGER | 0 | The weight of the ad. | |
Listing_weight_extra | Ad_extra_weight | SMALLINT | 0 | The maximum weight of the ad. | |
ID_geo_place | Integer | YES | A place in the world. | ||
Address | VARCHAR(750) | The address of the real estate’s location. | |||
District | VARCHAR(150) | The district, where the real estate is located. | |||
Zip_code | VARCHAR(10) | A postal codes used by the United States Postal Service. | |||
City | VARCHAR(150) | The city, where the real estate is located. | |||
Province | VARCHAR(150) | The province, where the real estate is located. | |||
Country | VARCHAR(2) | The country, where the real estate is located. | |||
Longitude | NUMERIC(11,8) | A geographic coordinate that specifies the east-west position of a point on the Earth's surface. | |||
Latitude | NUMERIC(10,8) | A geographic coordinate that specifies the north-south position of a point on the Earth's surface. | |||
Map_zoom | SMALLINT | 15 | The map’s zoom. | ||
Map_type | SMALLINT | 1 | Types of Google maps, where it is possible to find the real estate’s location. | ||
Occupied | NUMERIC(1,0) | The real estate is on lease at that moment. | |||
Equity_release_woman_age | Equity_release_woman’s_age | SMALLINT | The age of a woman taking equity release. | ||
Equity_release_man_age | Equity_release_man’s_age | SMALLINT | The age of a man taking equity release. | ||
People_capacity | Seating_capacity | SMALLINT | The number of people who can be seated in a specific space. | ||
Floor_area_ratio | NUMERIC(4,2) | The ratio of a building's total floor area to the size of the parcel of land upon which it is built. | |||
Floor_area_min | NUMERIC(18,6) | The minimum area of the quarters. | |||
Floor_area | NUMERIC(18,6) | The total area of the quarters. | |||
Floor_area_carrez_law | Carrez_law (area) | NUMERIC(18,6) | The effective usable surface area. | ||
Lot_size_min | Plot/land_area_min | NUMERIC(18,6) | The minimum area of the plot. | ||
Lot_size | Total_plot/land_area | NUMERIC(18,6) | The area of the plot. | ||
Rooms_min | SMALLINT | The minimum number of the rooms. | |||
Rooms | SMALLINT | The number of the rooms. | |||
Bedrooms_min | SMALLINT | The minimum number of the bedrooms. | |||
Bedrooms | SMALLINT | The number of the bedrooms. | |||
Offices | SMALLINT | The number of the offices. | |||
Shower_rooms | SMALLINT | The number of the shower rooms. | |||
Bathrooms | SMALLINT | The number of the bathrooms. | |||
Water_closets | SMALLINT | The number of the water closets. | |||
Levels | SMALLINT | The number of the levels. | |||
Double_beds | SMALLINT | The number of the double beds. | |||
Simple_beds | Single_beds | SMALLINT | The number of the single beds. | ||
Child_beds | Child’s_beds | SMALLINT | The number of the child’s beds. | ||
Parkings | SMALLINT | The presence of the parking. | |||
Garages | SMALLINT | The presence of the garage. | |||
Floor | SMALLINT | The number of the floors. | |||
Construction_year | SMALLINT | The year of construction of a real estate. | |||
Condition | SMALLINT | The condition of a real estate. | |||
Heating_type | SMALLINT | A type of heating. | |||
Heating_combustible | SMALLINT | The fuel for heating. | |||
Turnover | NUMERIC(18,5) | The income that Arkadia receives from the business activities. | |||
Net_income | NUMERIC(18,5) | The net earnings. | |||
Real_estate_annual_rent_price | Real_estate_annual_rental_price | NUMERIC(18,5) | The annual price for leasing a real estate. | ||
Real_estate_sale_price | NUMERIC(18,5) | The sale price of a real estate. | |||
Energy_consumption | VARCHAR(7) | The consumption of energy or power. | |||
Greenhouse_gas_emissions | VARCHAR(7) | The emissions of the gas in an atmosphere that absorbs and emits radiation within the thermal infrared range. | |||
Image_name_1 | VARCHAR(40) | The name of the image installed number 1. | |||
Image_name_2 | VARCHAR(40) | The name of the image installed number 2. | |||
Image_name_3 | VARCHAR(40) | The name of the image installed number 3. | |||
Image_name_4 | VARCHAR(40) | The name of the image installed number 4. | |||
Currency_code | VARCHAR(3) | YES | 'EUR' | Three-letter alphabetic codes that represent the various currencies used throughout the world. |