Exigo OData Service

Customers

Read-Only
Yes

Properties
CustomerID
Int32
No
The unique identifier of the customer
FirstName
String
No
The customer's first name
MiddleName
String
No
The customer's middle name
LastName
String
No
The customer's last name
NameSuffix
String
No
The customer's name suffix
Company
String
No
The customer's company name
CustomerTypeID
Int32
No
The customer's type ID. This identifier represents the customer's relationship with the company (ex. retail customer, distributor, etc.)
CustomerStatusID
Int32
No
The customer's status ID. This identifier represents the customer's status with the company (ex. active, deleted, etc.)
Email
String
No
The customer's email address
Phone
String
No
The customer's primary phone number
Phone2
String
No
The customer's secondary phone number
MobilePhone
String
No
The customer's mobile phone number
Fax
String
No
The customer's fax number
MainAddress1
String
No
The customer's primary address' street address
MainAddress2
String
No
The customer's primary address' apartment, suite or box number. This field is not used when validating the address with the Exigo address validation service.
MainCity
String
No
The customer's primary address' city
MainState
String
No
The customer's primary address' state or region code (ie. TX, CA, etc.)
MainZip
String
No
The customer's primary address' zip code
MainCountry
String
No
The customer's primary address' country code (ie. US, CA, etc.)
MainCounty
String
No
The customer's primary address' county
MailAddress1
String
No
The customer's secondary address' street address
MailAddress2
String
No
The customer's secondary address' apartment, suite or box number. This field is not used when validating the address with the Exigo address validation service.
MailCity
String
No
The customer's secondary address' city
MailState
String
No
The customer's secondary address' state or region code (ie. TX, CA, etc.)
MailZip
String
No
The customer's secondary address' zip code
MailCountry
String
No
The customer's secondary address' country code (ie. US, CA, etc.)
MailCounty
String
No
The customer's secondary address' county
OtherAddress1
String
No
The customer's additional address' street address
OtherAddress2
String
No
The customer's additional address' apartment, suite or box number. This field is not used when validating the address with the Exigo address validation service.
OtherCity
String
No
The customer's additional address' city
OtherState
String
No
The customer's additional address' state or region code (ie. TX, CA, etc.)
OtherZip
String
No
The customer's additional address' zip code
OtherCountry
String
No
The customer's additional address' country code (ie. US, CA, etc.)
OtherCounty
String
No
The customer's additional address' county
LoginName
String
No
The customer's login name
RankID
Int32
No
EnrollerID
Int32?
Yes
The customer's enroller's ID
SponsorID
Int32?
Yes
The customer's Unilevel sponsor's ID
BirthDate
DateTime?
Yes
The customer's birth date
CurrencyCode
String
No
The standard ISO 4217 3-letter currency code
PayableToName
String
No
The customer's preferred name used in commisson payouts
DefaultWarehouseID
Int32
No
The customer's default warehouse ID
PayableTypeID
Int32
No
The customer's commission payout preference
CheckThreshold
Decimal
No
The customer's preferred minimum amount for each paid commission. For example, if the CheckThreshold is 50.00, the customer will not be paid a commission until their commissions meet or exceed 50.00.
LanguageID
Int32
No
The customer's preferred language ID (ex. 0 (English), 1 (Spanish), etc.)
Gender
String
No
The customer's gender (ie. 'M' (Male), 'F' (Female), 'U' (Undecided))
SalesTaxCode
String
No
The customer's sales tax ID
IsSalesTaxExempt
Boolean
No
Specifies whether the customer is exempt from sales tax.
UseBinaryHoldingTank
Boolean
No
Specifies whether the customer is using the Binary holding tank to manage their downline
IsInBinaryHoldingTank
Boolean
No
Specifies whether the customer is currently in a Binary holding tank
Field1
String
No
Field2
String
No
Field3
String
No
Field4
String
No
Field5
String
No
Field6
String
No
Field7
String
No
Field8
String
No
Field9
String
No
Field10
String
No
Field11
String
No
Field12
String
No
Field13
String
No
Field14
String
No
Field15
String
No
Date1
DateTime?
Yes
A company-defined custom date
Date2
DateTime?
Yes
A company-defined custom date
Date3
DateTime?
Yes
A company-defined custom date
Date4
DateTime?
Yes
A company-defined custom date
Date5
DateTime?
Yes
A company-defined custom date
CreatedDate
DateTime
No
The date the record was created
ModifiedDate
DateTime
No
The date the record was last modified
Notes
String
No
Any additional notes or information about this record
CreatedBy
String
No
The user or entity that created the record
ModifiedBy
String
No
The user or entity that last modified the record
CanLogin
Boolean
No
Specifies whether the customer can be authenticated with their LoginName and Password
BinaryPlacementTypeID
Int32
No
VatRegistration
String
No
The customer's VAT registration number
IsEmailSubscribed
Boolean
No
EmailSubscribeIP
String
No
Rank
No
CustomerType
No
The customer's type ID. This identifier represents the customer's relationship with the company (ex. retail customer, distributor, etc.)
CustomerStatus
No
The customer's status ID. This identifier represents the customer's status with the company (ex. active, deleted, etc.)
SocialNetworks
No
Enroller
No
Sponsor
No