NameDescriptionTypeAdditional information
RecordID

integer

None.
RecType

string

String length: inclusive between 0 and 50
RecCode

string

String length: inclusive between 0 and 15
MasterRecord

string

String length: inclusive between 0 and 1
MasterRecCode

string

String length: inclusive between 0 and 15
CompanyName

string

String length: inclusive between 0 and 50
Address1

string

String length: inclusive between 0 and 50
Address2

string

String length: inclusive between 0 and 50
City

string

String length: inclusive between 0 and 30
State

string

String length: inclusive between 0 and 2
ZipCode

string

String length: inclusive between 0 and 15
Phone

string

String length: inclusive between 0 and 25
Fax

string

String length: inclusive between 0 and 25
WebSite

string

String length: inclusive between 0 and 100
TaxID

string

String length: inclusive between 0 and 20
Rank

string

String length: inclusive between 0 and 20
CitiesServed

string

String length: inclusive between 0 and 8000
ZipCodesServed

string

String length: inclusive between 0 and 8000
Contact1First

string

String length: inclusive between 0 and 30
Contact1Last

string

String length: inclusive between 0 and 30
Contact1Phone

string

String length: inclusive between 0 and 25
Contact1Email

string

String length: inclusive between 0 and 100
Contact1Fax

string

String length: inclusive between 0 and 25
Contact1Mobile

string

String length: inclusive between 0 and 25
Contact2First

string

String length: inclusive between 0 and 30
Contact2Last

string

String length: inclusive between 0 and 30
Contact2Phone

string

String length: inclusive between 0 and 25
Contact2Email

string

String length: inclusive between 0 and 100
Contact2Fax

string

String length: inclusive between 0 and 25
Contact2Mobile

string

String length: inclusive between 0 and 25
Contact3First

string

String length: inclusive between 0 and 30
Contact3Last

string

String length: inclusive between 0 and 30
Contact3Phone

string

String length: inclusive between 0 and 25
Contact3Email

string

String length: inclusive between 0 and 100
Contact3Fax

string

String length: inclusive between 0 and 25
Contact3Mobile

string

String length: inclusive between 0 and 25
User1

string

String length: inclusive between 0 and 255
User2

string

String length: inclusive between 0 and 255
User3

string

String length: inclusive between 0 and 255
User4

string

String length: inclusive between 0 and 255
User5

date

None.
User6

date

None.
User7

date

None.
User8

decimal number

None.
User9

decimal number

None.
User10

decimal number

None.
ReferralPct

decimal number

None.
StandardFee

decimal number

None.
MaxFee

decimal number

None.
EntityType

string

String length: inclusive between 0 and 15
APVendorNbr

string

String length: inclusive between 0 and 20
TotalAssignments

integer

None.
AvgVariancePer

decimal number

None.
AddedBy

string

String length: inclusive between 0 and 50
AddedOn

date

None.
ModifiedBy

string

String length: inclusive between 0 and 50
ModifiedOn

date

None.
ContactType

string

String length: inclusive between 0 and 50
CommissionPct

decimal number

None.
Country

string

String length: inclusive between 0 and 30
SurveyRating

decimal number

None.
SurveyCount

integer

None.
ERCMember

string

String length: inclusive between 0 and 1
Status

string

String length: inclusive between 0 and 20
Contact4First

string

String length: inclusive between 0 and 30
Contact4Last

string

String length: inclusive between 0 and 30
Contact4Phone

string

String length: inclusive between 0 and 25
Contact4Email

string

String length: inclusive between 0 and 100
Contact4Fax

string

String length: inclusive between 0 and 25
Contact4Mobile

string

String length: inclusive between 0 and 25
Contact5First

string

String length: inclusive between 0 and 30
Contact5Last

string

String length: inclusive between 0 and 30
Contact5Phone

string

String length: inclusive between 0 and 25
Contact5Email

string

String length: inclusive between 0 and 100
Contact5Fax

string

String length: inclusive between 0 and 25
Contact5Mobile

string

String length: inclusive between 0 and 25
Contact2Title

string

String length: inclusive between 0 and 25
Contact3Title

string

String length: inclusive between 0 and 25
Contact4Title

string

String length: inclusive between 0 and 25
Contact5Title

string

String length: inclusive between 0 and 25
MasterRefRecRcvd

string

String length: inclusive between 0 and 1
Prefix

string

String length: inclusive between 0 and 5
Nickname

string

String length: inclusive between 0 and 30
TimeZoneGMT

integer

None.
TollFreePhone

string

String length: inclusive between 0 and 25
VendorId

integer

None.
ID

integer

None.