OpenHouse

ClassID

Data Type: Int Maximum Length: 10
Sequential Enumerations (Lookup): _1, _2, _4, _8, _16, _32, _64, _128, _256, _512, _1024, _2048, _4096, _8192, _16384, _32768, _65536, CNTA, SVSR

ClassName

Data Type: Character Maximum Length: 25
Sequential Enumerations (Lookup): _1, _2, _4, _8, _16, _32, _64, _128, _256, _512, _1024, _2048, _4096, _8192, _16384, _32768, _65536, CNTA, SVSR

DeletedYN

Data Type: Boolean Maximum Length: 1

DrawingYN

Data Type: Boolean Maximum Length: 1

ListingId

Data Type: Character Maximum Length: 255

ListingKeyNumeric

Data Type: Int Maximum Length: 255

ModificationTimestamp

Data Type: DateTime Maximum Length: 27

OpenHouseAttendedBy

Data Type: Character Maximum Length: 25
Sequential Enumerations (Lookup): A, U, S

OpenHouseDate

Data Type: Date Maximum Length: 10

OpenHouseEndTime

Data Type: DateTime Maximum Length: 27

OpenHouseEndTime2

Data Type: Int Maximum Length: 27

OpenHouseId

Data Type: Character Maximum Length: 255

OpenHouseKeyNumeric

Data Type: Int Maximum Length: 255

OpenHouseRemarks

Data Type: Character Maximum Length: 500

OpenHouseStartTime

Data Type: DateTime Maximum Length: 27

OpenHouseStartTime2

Data Type: Int Maximum Length: 10

OpenHouseStatus

Data Type: Character Maximum Length: 25
Sequential Enumerations (Lookup): ACT, CAN, END

OpenHouseType

Data Type: Character Maximum Length: 25
Sequential Enumerations (Lookup):

Order

Data Type: Int Maximum Length: 11

OriginatingSystemID

Data Type: Character Maximum Length: 25

OriginatingSystemKey

Data Type: Character Maximum Length: 255

Refreshments

Data Type: Character Maximum Length: 255

ShowingAgentFirstName

Data Type: Character Maximum Length: 50

ShowingAgentKeyNumeric

Data Type: Int Maximum Length: 255

ShowingAgentLastName

Data Type: Character Maximum Length: 50

ShowingAgentMlsID

Data Type: Character Maximum Length: 25

ShowingContactPhone

Data Type: Character Maximum Length: 16

ShowingContactPhoneExt

Data Type: Character Maximum Length: 10

ShowingContactType

Data Type: Character Maximum Length: 75
Flag Enumerations (LookupMulti): OCC, AGT, OWN, PRPM, NONE, OTHR, SEER

ShowingOfficeKeyNumeric

Data Type: Int Maximum Length: 255

ShowingOfficeMlsId

Data Type: Character Maximum Length: 30

SourceDateModified

Data Type: DateTime Maximum Length: 27

TourID

Data Type: Int Maximum Length: 11

TourNumber

Data Type: Int Maximum Length: 10