CorporationYN

Data Type: Boolean Maximum Length: 1

DeletedBy

Data Type: Character Maximum Length: 8

HomesDotComYN

Data Type: Boolean Maximum Length: 1

IDXOfficeParticipationYN

Data Type: Boolean Maximum Length: 1

MainOfficeKeyNumeric

Data Type: Int Maximum Length: 255

MainOfficeMlsId

Data Type: Character Maximum Length: 25

ModificationTimestamp

Data Type: DateTime Maximum Length: 27

NMROfficeParticipationYN

Data Type: Boolean Maximum Length: 1

OfficeAddress1

Data Type: Character Maximum Length: 50

OfficeAddress2

Data Type: Character Maximum Length: 50

OfficeAOR

Data Type: Character Maximum Length: 50
Sequential Enumerations (Lookup): AR, CV, IG, EV, GD, IN, IV, MB, PV, PF, SB, SW, TR, WS, ZZ, EL, EY, XX, AV, BH, BB, CD, CLAW, CJ, CRIS, DAMLS, DW, HM, ITEC, LG, MU, NP, OC, OA, PW, PS, PD, RS, SAND, SI, SOCAL, SR, SU, VC, AM, DN, LC, MD, MP, MC, OR, PA, PL, SC, TC, YG, AL, AT, BF, BW, BE, BK, BI, CL, CE, CM, CA, CO, DL, DC, ES, ED, FR, GA, HH, HU, ID, IC, KR, KC, LN, LI, LV, ML, MN, MO, NV, NB, ND, NC, NS, OK, OJ, OB, PT, PR, PI, PC, RI, RW, SO, SE, SD, SG, SF, SP, SM, SA, SL, SZ, SJ, SV, SH, SQ, SS, ST, SK, SY, TA, TI, TY, TU, TE, VCRDS, VV, WT, WC, YC, MLSL, JT, PJ, SN
Go To Lookup

OfficeAORkeyNumeric

Data Type: Int Maximum Length: 255

OfficeAORPhone

Data Type: Character Maximum Length: 16

OfficeAORPhoneExt

Data Type: Character Maximum Length: 10

OfficeAssociationComments

Data Type: Character Maximum Length: 500

OfficeBrokerKeyNumeric

Data Type: Int Maximum Length: 255

OfficeBrokerMlsId

Data Type: Character Maximum Length: 25

OfficeCity

Data Type: Character Maximum Length: 50

OfficeCorporateLicense

Data Type: Character Maximum Length: 50

OfficeCountry

Data Type: Character Maximum Length: 60
Sequential Enumerations (Lookup): US, CA, MX, AF, AL, DZ, AS, AD, AO, AI, AQ, AG, AR, AM, AW, AU, AT, AZ, BS, BH, BD, BB, BY, BE, BZ, BJ, BM, BT, BO, BA, BW, BV, BR, IO, BN, BG, BF, BI, CI, KH, CM, CV, KY, CF, TD, CL, CN, CX, CC, CO, KM, CG, CD, CK, CR, HR, CU, CY, CZ, DK, DJ, DM, DO, EC, EG, SV, GQ, ER, EE, ET, FK, FO, FJ, FI, FR, GF, PF, TF, GA, GM, GE, DE, GH, GI, GR, GL, GD, GP, GU, GT, GG, GN, GW, GY, HT, HM, VA, HN, HK, HU, IS, IN, ID, IR, IQ, IE, IM, IL, IT, JM, JP, JE, JO, KZ, KE, KI, KP, KR, KW, KG, LA, AX, LV, LB, LS, LR, LY, LI, LT, LU, MO, MK, MG, MW, MY, MV, ML, MT, MH, MQ, MR, MU, YT, FM, MD, MC, MN, ME, MS, MA, MZ, MM, NA, NR, NP, NL, AN, NC, NZ, NI, NE, NG, NU, NF, MP, NO, OM, PK, PW, PS, PA, PG, PY, PE, PH, PN, PL, PT, PR, QA, RE, RO, RU, RW, BL, SH, KN, LC, MF, PM, VC, WS, SM, ST, SA, SN, RS, SC, SL, SG, SK, SI, SB, SO, ZA, GS, ES, LK, SD, SR, SJ, SZ, SE, CH, SY, TW, TJ, TZ, TH, TL, TG, TK, TO, TT, TN, TR, TM, TC, TV, UG, UA, AE, GB, UM, UY, UZ, VU, VE, VN, VG, VI, WF, EH, YE, ZM, ZW
Go To Lookup

OfficeDBA

Data Type: Character Maximum Length: 255

OfficeEmail

Data Type: Character Maximum Length: 80

OfficeFax

Data Type: Character Maximum Length: 16

OfficeKeyNumeric

Data Type: Int Maximum Length: 255

OfficeLicense

Data Type: Character Maximum Length: 50

OfficeLicenseType

Data Type: Character Maximum Length: 25
Sequential Enumerations (Lookup): CORP, BROK, APPR
Go To Lookup

OfficeMlsAccessYN

Data Type: Boolean Maximum Length: 1

OfficeMlsId

Data Type: Character Maximum Length: 25

OfficeName

Data Type: Character Maximum Length: 255

OfficeNationalAssociationId

Data Type: Character Maximum Length: 25

OfficeNotificationEmail

Data Type: Character Maximum Length: 1024

OfficePhone

Data Type: Character Maximum Length: 16

OfficePhoneExt

Data Type: Character Maximum Length: 10

OfficePostalCode

Data Type: Character Maximum Length: 10

OfficePostalCodePlus4

Data Type: Character Maximum Length: 4

OfficeStateOrProvince

Data Type: Character Maximum Length: 2
Sequential Enumerations (Lookup): AK, AL, AR, AZ, CA, CO, CT, DC, DE, FL, GA, HI, IA, ID, IL, IN, KS, KY, LA, MA, MD, ME, MI, MN, MO, MS, MT, NC, ND, NE, NH, NJ, NM, NV, NY, OH, OK, OR, OS, PA, RI, SC, SD, TN, TX, UT, VA, VI, VT, WA, WI, WV, WY, BC, MB, NB, NF, NS, NT, NU, ON, PE, QC, SK, YT, AB
Go To Lookup

OfficeStatus

Data Type: Character Maximum Length: 25
Sequential Enumerations (Lookup): A, I, D
Go To Lookup

OriginalEntryTimestamp

Data Type: DateTime Maximum Length: 27

OriginatingSystemID

Data Type: Character Maximum Length: 25

OriginatingSystemMainOfficeKey

Data Type: Character Maximum Length: 255

OriginatingSystemModificationTimestamp

Data Type: DateTime Maximum Length: 27

OriginatingSystemOfficeAORKey

Data Type: Character Maximum Length: 255

OriginatingSystemOfficeBrokerKey

Data Type: Character Maximum Length: 255

OriginatingSystemOfficeKey

Data Type: Character Maximum Length: 255

OtherAdvertisingYN

Data Type: Boolean Maximum Length: 1

PhotosChangeTimestamp

Data Type: DateTime Maximum Length: 27

PhotosCount

Data Type: Int Maximum Length: 2

RealtorDotComYN

Data Type: Boolean Maximum Length: 1

RPRYN

Data Type: Boolean Maximum Length: 1

SocialMediaWebsiteUrlOrId

Data Type: Character Maximum Length: 8000

SourceSystemID

Data Type: Character Maximum Length: 25

SourceSystemModificationTimestamp

Data Type: DateTime Maximum Length: 27

SourceSystemOfficeKey

Data Type: Character Maximum Length: 255

SyndicateAgentOption

Data Type: Character Maximum Length: 50
Sequential Enumerations (Lookup): AASA, RTAS, NOAC
Go To Lookup

SyndicateTo

Data Type: Character Maximum Length: 1024
Flag Enumerations (LookupMulti): ZILL, RCOM, HCOM, TRUL
Go To Lookup