General informations
Fields (70)
Name | Label | Type | Description |
---|---|---|---|
Id | Customer Property ID | ID | |
OwnerId | Owner ID | LOOKUP | |
IsDeleted | Deleted | CHECKBOX | |
Name | Name | AUTO NUMBER | |
CreatedDate | Created Date | DATETIME | |
CreatedById | Created By ID | LOOKUP | |
LastModifiedDate | Last Modified Date | DATETIME | |
LastModifiedById | Last Modified By ID | LOOKUP | |
SystemModstamp | System Modstamp | DATETIME | |
LastViewedDate | Last Viewed Date | DATETIME | |
LastReferencedDate | Last Referenced Date | DATETIME | |
PrimaryOwnerId | Account ID | MASTER-DETAIL | |
SourceSystemIdentifier | Source System Identifier | TEXT(255) | |
YearBuilt | Year Built | AUTO NUMBER | |
PurchaseDate | Purchase Date | DATE | |
LotArea | Lot Area | TEXT(100) | |
BuiltUpArea | Built-Up Area | TEXT(100) | |
FloorCount | Number of Floors | AUTO NUMBER | |
BedroomCount | Number of Bedrooms | NUMBER(18,0) | |
BathroomCount | Number of Bathrooms | NUMBER(18,0) | |
KitchenCount | Number of Kitchens | NUMBER(18,0) | |
RoofType | Roof Type | PICKLIST | |
GarageType | Garage Type | PICKLIST | |
IsBasementIncluded | Includes Basement | CHECKBOX | |
FoundationType | Foundation Type | PICKLIST | |
LeasePeriod | Lease Period | AUTO NUMBER | |
AssetId | Asset ID | LOOKUP | |
IsChimneyIncluded | Includes Chimney | CHECKBOX | |
DwellingType | Dwelling Type | PICKLIST | |
CeilingType | Ceiling Type | PICKLIST | |
FloorType | Floor Type | PICKLIST | |
ConstructionClass | Construction Class | PICKLIST | |
GrossVehicleWeight | Gross Vehicle Weight | AUTO NUMBER | |
IsSwimmingPoolIncluded | Includes Swimming Pool | CHECKBOX | |
GarageSpaceCount | Number of Parking Spaces in Garage | AUTO NUMBER | |
MakeYear | Make Year | AUTO NUMBER | |
ModelName | Model Name | TEXT(255) | |
EngineDisplacementVolume | Engine Displacement Volume | AUTO NUMBER | |
FuelType | Fuel Type | PICKLIST | |
TransmissionType | Transmission Type | PICKLIST | |
PassengerSeatCapacity | Passenger Seat Capacity | AUTO NUMBER | |
LoadCapacity | Load Capacity | TEXT(255) | |
FactoryPrice | Factory Price | CURRENCY(16,2) | |
OdometerReading | Odometer Reading | AUTO NUMBER | |
FairMarketValue | Fair Market Value | CURRENCY(16,2) | |
PurchasePrice | Purchase Price | CURRENCY(16,2) | |
Vin | VIN | TEXT(255) | |
RegistrationNumber | Registration Number | TEXT(255) | |
Description | Description | TEXT AREA (LONG)(32000) | |
RegistrationType | Registration Type | PICKLIST | |
PrimaryUse | Primary Use | PICKLIST | |
FinancingType | Financing Type | PICKLIST | |
AnnualMileage | Expected Annual Mileage | AUTO NUMBER | |
DaysDrivenTowork | Days Driven to Work (One Way) | AUTO NUMBER | |
MilesDrivenToWork | Miles Driven to Work (One way) | AUTO NUMBER | |
IsPassedSmogCheck | Passed Smog Check | CHECKBOX | |
LienHolderName | Lien Holder Name | TEXT(255) | |
Make | Make | TEXT(255) | |
Street | Street | TEXT AREA(255) | |
City | City | TEXT(40) | |
State | State | TEXT(80) | |
PostalCode | Postal Code | TEXT(20) | |
Country | Country | TEXT(80) | |
StateCode | State Code | PICKLIST | |
CountryCode | Country Code | PICKLIST | |
Latitude | Latitude | NUMBER(3,15) | |
Longitude | Longitude | NUMBER(3,15) | |
GeocodeAccuracy | Geocode Accuracy | PICKLIST | |
Address | Address | AUTO NUMBER | |
SourceSystem | Source System | TEXT(255) |
Fields Details (70)
Name | Id |
Label | Customer Property ID |
Type | ID |
Required | Yes |
Name | OwnerId |
Label | Owner ID |
Type | LOOKUP |
Foreign key | Yes |
Required | Yes |
Name | IsDeleted |
Label | Deleted |
Type | CHECKBOX |
Required | Yes |
Default value | false |
Name | Name |
Label | Name |
Type | AUTO NUMBER |
Required | Yes |
Name | CreatedDate |
Label | Created Date |
Type | DATETIME |
Required | Yes |
Name | CreatedById |
Label | Created By ID |
Type | LOOKUP |
Foreign key | Yes |
Required | Yes |
Name | LastModifiedDate |
Label | Last Modified Date |
Type | DATETIME |
Required | Yes |
Name | LastModifiedById |
Label | Last Modified By ID |
Type | LOOKUP |
Foreign key | Yes |
Required | Yes |
Name | SystemModstamp |
Label | System Modstamp |
Type | DATETIME |
Required | Yes |
Name | LastViewedDate |
Label | Last Viewed Date |
Type | DATETIME |
Name | LastReferencedDate |
Label | Last Referenced Date |
Type | DATETIME |
Name | PrimaryOwnerId |
Label | Account ID |
Type | MASTER-DETAIL |
Foreign key | Yes |
Required | Yes |
Name | SourceSystemIdentifier |
Label | Source System Identifier |
Type | TEXT(255) |
Unique | Yes |
Name | YearBuilt |
Label | Year Built |
Type | AUTO NUMBER |
Name | PurchaseDate |
Label | Purchase Date |
Type | DATE |
Name | LotArea |
Label | Lot Area |
Type | TEXT(100) |
Name | BuiltUpArea |
Label | Built-Up Area |
Type | TEXT(100) |
Name | FloorCount |
Label | Number of Floors |
Type | AUTO NUMBER |
Name | BedroomCount |
Label | Number of Bedrooms |
Type | NUMBER(18,0) |
Name | BathroomCount |
Label | Number of Bathrooms |
Type | NUMBER(18,0) |
Name | KitchenCount |
Label | Number of Kitchens |
Type | NUMBER(18,0) |
Name | RoofType |
Label | Roof Type |
Type | PICKLIST |
Picklist values | Solar Tiles Asphalt Shingles Metal Roofing Stone-coated steel Slate Rubber Slate Clay and concrete tiles Green roof Built-up roofing |
Name | GarageType |
Label | Garage Type |
Type | PICKLIST |
Picklist values | Attached Basement Built-In Carport |
Name | IsBasementIncluded |
Label | Includes Basement |
Type | CHECKBOX |
Required | Yes |
Default value | false |
Name | FoundationType |
Label | Foundation Type |
Type | PICKLIST |
Picklist values | Basement Crawlspace Pier and Beam Slab |
Name | LeasePeriod |
Label | Lease Period |
Type | AUTO NUMBER |
Name | AssetId |
Label | Asset ID |
Type | LOOKUP |
Foreign key | Yes |
Name | IsChimneyIncluded |
Label | Includes Chimney |
Type | CHECKBOX |
Required | Yes |
Default value | false |
Name | DwellingType |
Label | Dwelling Type |
Type | PICKLIST |
Picklist values | Duplex High rise multiple units Low rise multiple units Single Family Detached Four Square Single Family Detached Ranch Single Family Row Home |
Name | CeilingType |
Label | Ceiling Type |
Type | PICKLIST |
Picklist values | Conventional Beam Shed Cove Coffered Tray Suspended |
Name | FloorType |
Label | Floor Type |
Type | PICKLIST |
Picklist values | Ceramic Tile Porcelain Tile Floating wood tile Carpet Hardwood Engineered wood Bamboo Cork Stone Vinyl |
Name | ConstructionClass |
Label | Construction Class |
Type | PICKLIST |
Picklist values | Average/Standard Builders Grade Basic Custom Custom/Luxury Designer Economy Economy/Standard Luxury Minimum Standard/Custom Superior |
Name | GrossVehicleWeight |
Label | Gross Vehicle Weight |
Type | AUTO NUMBER |
Name | IsSwimmingPoolIncluded |
Label | Includes Swimming Pool |
Type | CHECKBOX |
Required | Yes |
Default value | false |
Name | GarageSpaceCount |
Label | Number of Parking Spaces in Garage |
Type | AUTO NUMBER |
Name | MakeYear |
Label | Make Year |
Type | AUTO NUMBER |
Name | ModelName |
Label | Model Name |
Type | TEXT(255) |
Name | EngineDisplacementVolume |
Label | Engine Displacement Volume |
Type | AUTO NUMBER |
Name | FuelType |
Label | Fuel Type |
Type | PICKLIST |
Picklist values | Biodiesel Ethanol Petrol Diesel Hybrid Electric Other |
Name | TransmissionType |
Label | Transmission Type |
Type | PICKLIST |
Picklist values | Five Gear Manual Four Gear Automatic Four Gear Manual Six Gear Manual |
Name | PassengerSeatCapacity |
Label | Passenger Seat Capacity |
Type | AUTO NUMBER |
Name | LoadCapacity |
Label | Load Capacity |
Type | TEXT(255) |
Name | FactoryPrice |
Label | Factory Price |
Type | CURRENCY(16,2) |
Name | OdometerReading |
Label | Odometer Reading |
Type | AUTO NUMBER |
Name | FairMarketValue |
Label | Fair Market Value |
Type | CURRENCY(16,2) |
Name | PurchasePrice |
Label | Purchase Price |
Type | CURRENCY(16,2) |
Name | Vin |
Label | VIN |
Type | TEXT(255) |
Name | RegistrationNumber |
Label | Registration Number |
Type | TEXT(255) |
Name | Description |
Label | Description |
Type | TEXT AREA (LONG)(32000) |
Name | RegistrationType |
Label | Registration Type |
Type | PICKLIST |
Picklist values | Antique Combo Apportioned Commercial SUB |
Name | PrimaryUse |
Label | Primary Use |
Type | PICKLIST |
Picklist values | Personal Work Business |
Name | FinancingType |
Label | Financing Type |
Type | PICKLIST |
Picklist values | Standard Loan Commercial hire purchase Finance Lease Novated Lease Operating Lease Chattel Mortgage |
Name | AnnualMileage |
Label | Expected Annual Mileage |
Type | AUTO NUMBER |
Name | DaysDrivenTowork |
Label | Days Driven to Work (One Way) |
Type | AUTO NUMBER |
Name | MilesDrivenToWork |
Label | Miles Driven to Work (One way) |
Type | AUTO NUMBER |
Name | IsPassedSmogCheck |
Label | Passed Smog Check |
Type | CHECKBOX |
Required | Yes |
Default value | false |
Name | LienHolderName |
Label | Lien Holder Name |
Type | TEXT(255) |
Name | Make |
Label | Make |
Type | TEXT(255) |
Name | Street |
Label | Street |
Type | TEXT AREA(255) |
Name | City |
Label | City |
Type | TEXT(40) |
Name | State |
Label | State |
Type | TEXT(80) |
Name | PostalCode |
Label | Postal Code |
Type | TEXT(20) |
Name | Country |
Label | Country |
Type | TEXT(80) |
Name | StateCode |
Label | State Code |
Type | PICKLIST |
Picklist values | AC AG AG 05 02 AL AL AK AB AL AP AM AN AN AP 34 23 AO AR AZ AR AR AP AS AT ACT AV BA BC BS BA BT 11 BL BN BG BI BR BO BZ BS BR BC CA CA CL CM CB CI CW CE CT CZ CN CE CH CT CS 12 CH CH 50 CE CO CL CO CO CT CO CS CR KR CN DN DD DE DL DC DF DL D DG 38 EN ES DF FM FE FI FL FG FC FR 35 18 40 07 G 62 GE GA 21 GA GO GO GR GT 44 45 GR 52 GJ 10 46 HR HI 13 23 41 HG HP 34 01 91 42 43 28 08 ID IL IM IN IA IS 17 03 JA JK JH 32 36 22 37 46 14 KS KA KY KL KY KE KK 39 43 26 AQ LD LS SP LT LE LC LM 21 LK LI LO LD LA LH LU 92 MC MP MH ME MN MB MN MA MD MS MA MT MT MS MO MH VS ML ME ME MI MI 24 MI MG MN MS MO 04 45 MZ MO MN MT MB MO NL 20 42 NA 29 NA NE 15 NV NB NL NH NJ NM NSW NY 15 64 NC ND NT NT NO NS NL NU NU OA OR OY OG OH 44 33 47 OK OT ON OR OR 27 PD PA PA PB PR PR PV PA PE PG PU PE PC PI PI PT PN PZ PO PE PY PB PB 63 QC QLD QE QR RG RJ RA RC RE RI RI RN RJ RN RS RM RO RR RN RO 41 11 SA SL SC SP SK SS SV SE 61 37 31 14 25 32 22 51 SI SK SI SO SO SO SA SC SD SR TB 71 TM TN TA TAS TG TN TE TR TX 12 TA TL TO 09 36 13 31 16 TP TN TV TS TR TO UD UT UT UP VA VE VE VB VC VT VR VV VI VIC VA VT 30 WA WD WB WA WH WV WX WW WI WY 65 54 06 35 19 YU YT 53 ZA 33 |
Name | CountryCode |
Label | Country Code |
Type | PICKLIST |
Picklist values | AF AX AL DZ AD AO AI AQ AG AR AM AW AU AT AZ BS BH BD BB BY BE BZ BJ BM BT BO BQ BA BW BV BR IO BN BG BF BI KH CM CA CV KY CF TD CL CN CX CC CO KM CG CD CK CR CI HR CW CY CZ DK DJ DM DO EC EG SV GQ ER EE SZ ET FK FO FJ FI FR GF PF TF GA GM GE DE GH GI GR GL GD GP GT GG GN GW GY HT HM VA HN HU IS IN ID IQ IE IM IL IT JM JP JE JO KZ KE KI KR XK KW KG LA LV LB LS LR LY LI LT LU MO MG MW MY MV ML MT MQ MR MU YT MX MD MC MN ME MS MA MZ MM NA NR NP NL NC NZ NI NE NG NU NF MK NO OM PK PS PA PG PY PE PH PN PL PT QA RE RO RU RW BL SH KN LC MF PM VC WS SM ST SA SN RS SC SL SG SX SK SI SB SO ZA GS SS ES LK SR SJ SE CH TW TJ TZ TH TL TG TK TO TT TN TR TM TC TV UG UA AE GB US UY UZ VU VE VN VG WF EH YE ZM ZW |
Name | Latitude |
Label | Latitude |
Type | NUMBER(3,15) |
Name | Longitude |
Label | Longitude |
Type | NUMBER(3,15) |
Name | GeocodeAccuracy |
Label | Geocode Accuracy |
Type | PICKLIST |
Picklist values | Address NearAddress Block Street ExtendedZip Zip Neighborhood City County State Unknown |
Name | Address |
Label | Address |
Type | AUTO NUMBER |
Name | SourceSystem |
Label | Source System |
Type | TEXT(255) |
Parents relationships(12)
Children relationships(5)
Name | Parent object | Child object | Parent object field | Child object field |
---|---|---|---|---|
Owner | User | CustomerProperty |
|
|
CreatedBy | User | CustomerProperty |
|
|
LastModifiedBy | User | CustomerProperty |
|
|
PrimaryOwner | Account | CustomerProperty |
|
|
Asset | Asset | CustomerProperty |
|
|
Object User-defined metadata (0)
Label | Value |
---|