EMUN1 ASP.NET

QueryCustomerRDB

**Requires Authentication**
Required role:	Administrator

The following routes are available for this service:
All Verbs	/service/QueryCustomerRDB

**QueryCustomerRDB** Parameters:
Name	Parameter	Data Type	Required
Skip	query	int?	No
Take	query	int?	No
OrderBy	query	string	No
OrderByDesc	query	string	No
Include	query	string	No
Fields	query	string	No
Meta	query	Dictionary<string, string>	No
Id	query	string	No
IdStartsWith	query	string	No
IdEndsWith	query	string	No
IdContains	query	string	No
IdLike	query	string	No
IdBetween	query	string[]	No
IdIn	query	string[]	No
CompanyName	query	string	No
CompanyNameStartsWith	query	string	No
CompanyNameEndsWith	query	string	No
CompanyNameContains	query	string	No
CompanyNameLike	query	string	No
CompanyNameBetween	query	string[]	No
CompanyNameIn	query	string[]	No
AccountType	query	string	No
AccountTypeStartsWith	query	string	No
AccountTypeEndsWith	query	string	No
AccountTypeContains	query	string	No
AccountTypeLike	query	string	No
AccountTypeBetween	query	string[]	No
AccountTypeIn	query	string[]	No
BillAddress	query	string	No
BillAddressStartsWith	query	string	No
BillAddressEndsWith	query	string	No
BillAddressContains	query	string	No
BillAddressLike	query	string	No
BillAddressBetween	query	string[]	No
BillAddressIn	query	string[]	No
BillAddress2	query	string	No
BillAddress2StartsWith	query	string	No
BillAddress2EndsWith	query	string	No
BillAddress2Contains	query	string	No
BillAddress2Like	query	string	No
BillAddress2Between	query	string[]	No
BillAddress2In	query	string[]	No
BillCity	query	string	No
BillCityStartsWith	query	string	No
BillCityEndsWith	query	string	No
BillCityContains	query	string	No
BillCityLike	query	string	No
BillCityBetween	query	string[]	No
BillCityIn	query	string[]	No
BillState	query	string	No
BillStateStartsWith	query	string	No
BillStateEndsWith	query	string	No
BillStateContains	query	string	No
BillStateLike	query	string	No
BillStateBetween	query	string[]	No
BillStateIn	query	string[]	No
BillZipcode	query	string	No
BillZipcodeStartsWith	query	string	No
BillZipcodeEndsWith	query	string	No
BillZipcodeContains	query	string	No
BillZipcodeLike	query	string	No
BillZipcodeBetween	query	string[]	No
BillZipcodeIn	query	string[]	No
BillCountry	query	string	No
BillCountryStartsWith	query	string	No
BillCountryEndsWith	query	string	No
BillCountryContains	query	string	No
BillCountryLike	query	string	No
BillCountryBetween	query	string[]	No
BillCountryIn	query	string[]	No
Phone	query	string	No
PhoneStartsWith	query	string	No
PhoneEndsWith	query	string	No
PhoneContains	query	string	No
PhoneLike	query	string	No
PhoneBetween	query	string[]	No
PhoneIn	query	string[]	No
ShipName	query	string	No
ShipNameStartsWith	query	string	No
ShipNameEndsWith	query	string	No
ShipNameContains	query	string	No
ShipNameLike	query	string	No
ShipNameBetween	query	string[]	No
ShipNameIn	query	string[]	No
ShipAddress	query	string	No
ShipAddressStartsWith	query	string	No
ShipAddressEndsWith	query	string	No
ShipAddressContains	query	string	No
ShipAddressLike	query	string	No
ShipAddressBetween	query	string[]	No
ShipAddressIn	query	string[]	No
ShipAddress2	query	string	No
ShipAddress2StartsWith	query	string	No
ShipAddress2EndsWith	query	string	No
ShipAddress2Contains	query	string	No
ShipAddress2Like	query	string	No
ShipAddress2Between	query	string[]	No
ShipAddress2In	query	string[]	No
ShipCity	query	string	No
ShipCityStartsWith	query	string	No
ShipCityEndsWith	query	string	No
ShipCityContains	query	string	No
ShipCityLike	query	string	No
ShipCityBetween	query	string[]	No
ShipCityIn	query	string[]	No
ShipState	query	string	No
ShipStateStartsWith	query	string	No
ShipStateEndsWith	query	string	No
ShipStateContains	query	string	No
ShipStateLike	query	string	No
ShipStateBetween	query	string[]	No
ShipStateIn	query	string[]	No
ShipZipcode	query	string	No
ShipZipcodeStartsWith	query	string	No
ShipZipcodeEndsWith	query	string	No
ShipZipcodeContains	query	string	No
ShipZipcodeLike	query	string	No
ShipZipcodeBetween	query	string[]	No
ShipZipcodeIn	query	string[]	No
ShipCountry	query	string	No
ShipCountryStartsWith	query	string	No
ShipCountryEndsWith	query	string	No
ShipCountryContains	query	string	No
ShipCountryLike	query	string	No
ShipCountryBetween	query	string[]	No
ShipCountryIn	query	string[]	No
ShipPhone	query	string	No
ShipPhoneStartsWith	query	string	No
ShipPhoneEndsWith	query	string	No
ShipPhoneContains	query	string	No
ShipPhoneLike	query	string	No
ShipPhoneBetween	query	string[]	No
ShipPhoneIn	query	string[]	No
Email	query	string	No
EmailStartsWith	query	string	No
EmailEndsWith	query	string	No
EmailContains	query	string	No
EmailLike	query	string	No
EmailBetween	query	string[]	No
EmailIn	query	string[]	No
Website	query	string	No
WebsiteStartsWith	query	string	No
WebsiteEndsWith	query	string	No
WebsiteContains	query	string	No
WebsiteLike	query	string	No
WebsiteBetween	query	string[]	No
WebsiteIn	query	string[]	No
Fax	query	string	No
FaxStartsWith	query	string	No
FaxEndsWith	query	string	No
FaxContains	query	string	No
FaxLike	query	string	No
FaxBetween	query	string[]	No
FaxIn	query	string[]	No
Contact	query	string	No
ContactStartsWith	query	string	No
ContactEndsWith	query	string	No
ContactContains	query	string	No
ContactLike	query	string	No
ContactBetween	query	string[]	No
ContactIn	query	string[]	No
CreditCardType	query	string	No
CreditCardTypeStartsWith	query	string	No
CreditCardTypeEndsWith	query	string	No
CreditCardTypeContains	query	string	No
CreditCardTypeLike	query	string	No
CreditCardTypeBetween	query	string[]	No
CreditCardTypeIn	query	string[]	No
CreditCardNumber	query	string	No
CreditCardNumberStartsWith	query	string	No
CreditCardNumberEndsWith	query	string	No
CreditCardNumberContains	query	string	No
CreditCardNumberLike	query	string	No
CreditCardNumberBetween	query	string[]	No
CreditCardNumberIn	query	string[]	No
CreditCardExpiration	query	string	No
CreditCardExpirationStartsWith	query	string	No
CreditCardExpirationEndsWith	query	string	No
CreditCardExpirationContains	query	string	No
CreditCardExpirationLike	query	string	No
CreditCardExpirationBetween	query	string[]	No
CreditCardExpirationIn	query	string[]	No
CreditCardAVS	query	string	No
CreditCardAVSStartsWith	query	string	No
CreditCardAVSEndsWith	query	string	No
CreditCardAVSContains	query	string	No
CreditCardAVSLike	query	string	No
CreditCardAVSBetween	query	string[]	No
CreditCardAVSIn	query	string[]	No
CreditCardName	query	string	No
CreditCardNameStartsWith	query	string	No
CreditCardNameEndsWith	query	string	No
CreditCardNameContains	query	string	No
CreditCardNameLike	query	string	No
CreditCardNameBetween	query	string[]	No
CreditCardNameIn	query	string[]	No
CreditCardAddress	query	string	No
CreditCardAddressStartsWith	query	string	No
CreditCardAddressEndsWith	query	string	No
CreditCardAddressContains	query	string	No
CreditCardAddressLike	query	string	No
CreditCardAddressBetween	query	string[]	No
CreditCardAddressIn	query	string[]	No
CreditCardAddress2	query	string	No
CreditCardAddress2StartsWith	query	string	No
CreditCardAddress2EndsWith	query	string	No
CreditCardAddress2Contains	query	string	No
CreditCardAddress2Like	query	string	No
CreditCardAddress2Between	query	string[]	No
CreditCardAddress2In	query	string[]	No
CreditCardCity	query	string	No
CreditCardCityStartsWith	query	string	No
CreditCardCityEndsWith	query	string	No
CreditCardCityContains	query	string	No
CreditCardCityLike	query	string	No
CreditCardCityBetween	query	string[]	No
CreditCardCityIn	query	string[]	No
CreditCardState	query	string	No
CreditCardStateStartsWith	query	string	No
CreditCardStateEndsWith	query	string	No
CreditCardStateContains	query	string	No
CreditCardStateLike	query	string	No
CreditCardStateBetween	query	string[]	No
CreditCardStateIn	query	string[]	No
CreditCardZipcode	query	string	No
CreditCardZipcodeStartsWith	query	string	No
CreditCardZipcodeEndsWith	query	string	No
CreditCardZipcodeContains	query	string	No
CreditCardZipcodeLike	query	string	No
CreditCardZipcodeBetween	query	string[]	No
CreditCardZipcodeIn	query	string[]	No
CreditCardCountry	query	string	No
CreditCardCountryStartsWith	query	string	No
CreditCardCountryEndsWith	query	string	No
CreditCardCountryContains	query	string	No
CreditCardCountryLike	query	string	No
CreditCardCountryBetween	query	string[]	No
CreditCardCountryIn	query	string[]	No
ShipVia	query	string	No
ShipViaStartsWith	query	string	No
ShipViaEndsWith	query	string	No
ShipViaContains	query	string	No
ShipViaLike	query	string	No
ShipViaBetween	query	string[]	No
ShipViaIn	query	string[]	No
Terms	query	string	No
TermsStartsWith	query	string	No
TermsEndsWith	query	string	No
TermsContains	query	string	No
TermsLike	query	string	No
TermsBetween	query	string[]	No
TermsIn	query	string[]	No
SalesRep	query	string	No
SalesRepStartsWith	query	string	No
SalesRepEndsWith	query	string	No
SalesRepContains	query	string	No
SalesRepLike	query	string	No
SalesRepBetween	query	string[]	No
SalesRepIn	query	string[]	No
Notes	query	string	No
NotesStartsWith	query	string	No
NotesEndsWith	query	string	No
NotesContains	query	string	No
NotesLike	query	string	No
NotesBetween	query	string[]	No
NotesIn	query	string[]	No
KeyAccount	query	bool?	No
CreditLimit	query	double?	No
CreditLimitGreaterThanOrEqualTo	query	double?	No
CreditLimitGreaterThan	query	double?	No
CreditLimitLessThan	query	double?	No
CreditLimitLessThanOrEqualTo	query	double?	No
CreditLimitNotEqualTo	query	double?	No
CreditLimitBetween	query	double[]	No
CreditLimitIn	query	double[]	No
DBNum	query	string	No
DBNumStartsWith	query	string	No
DBNumEndsWith	query	string	No
DBNumContains	query	string	No
DBNumLike	query	string	No
DBNumBetween	query	string[]	No
DBNumIn	query	string[]	No
Bank	query	string	No
BankStartsWith	query	string	No
BankEndsWith	query	string	No
BankContains	query	string	No
BankLike	query	string	No
BankBetween	query	string[]	No
BankIn	query	string[]	No
BankAccountNum	query	string	No
BankAccountNumStartsWith	query	string	No
BankAccountNumEndsWith	query	string	No
BankAccountNumContains	query	string	No
BankAccountNumLike	query	string	No
BankAccountNumBetween	query	string[]	No
BankAccountNumIn	query	string[]	No
BankAccountType	query	string	No
BankAccountTypeStartsWith	query	string	No
BankAccountTypeEndsWith	query	string	No
BankAccountTypeContains	query	string	No
BankAccountTypeLike	query	string	No
BankAccountTypeBetween	query	string[]	No
BankAccountTypeIn	query	string[]	No
FederalTaxId	query	string	No
FederalTaxIdStartsWith	query	string	No
FederalTaxIdEndsWith	query	string	No
FederalTaxIdContains	query	string	No
FederalTaxIdLike	query	string	No
FederalTaxIdBetween	query	string[]	No
FederalTaxIdIn	query	string[]	No
StateTaxId	query	string	No
StateTaxIdStartsWith	query	string	No
StateTaxIdEndsWith	query	string	No
StateTaxIdContains	query	string	No
StateTaxIdLike	query	string	No
StateTaxIdBetween	query	string[]	No
StateTaxIdIn	query	string[]	No
Reference1	query	string	No
Reference1StartsWith	query	string	No
Reference1EndsWith	query	string	No
Reference1Contains	query	string	No
Reference1Like	query	string	No
Reference1Between	query	string[]	No
Reference1In	query	string[]	No
Reference2	query	string	No
Reference2StartsWith	query	string	No
Reference2EndsWith	query	string	No
Reference2Contains	query	string	No
Reference2Like	query	string	No
Reference2Between	query	string[]	No
Reference2In	query	string[]	No
Reference3	query	string	No
Reference3StartsWith	query	string	No
Reference3EndsWith	query	string	No
Reference3Contains	query	string	No
Reference3Like	query	string	No
Reference3Between	query	string[]	No
Reference3In	query	string[]	No
Reference4	query	string	No
Reference4StartsWith	query	string	No
Reference4EndsWith	query	string	No
Reference4Contains	query	string	No
Reference4Like	query	string	No
Reference4Between	query	string[]	No
Reference4In	query	string[]	No
Reference5	query	string	No
Reference5StartsWith	query	string	No
Reference5EndsWith	query	string	No
Reference5Contains	query	string	No
Reference5Like	query	string	No
Reference5Between	query	string[]	No
Reference5In	query	string[]	No
FaxOrder	query	bool?	No
EmailOrder	query	bool?	No
Custom1STR	query	string	No
Custom1STRStartsWith	query	string	No
Custom1STREndsWith	query	string	No
Custom1STRContains	query	string	No
Custom1STRLike	query	string	No
Custom1STRBetween	query	string[]	No
Custom1STRIn	query	string[]	No
Custom2STR	query	string	No
Custom2STRStartsWith	query	string	No
Custom2STREndsWith	query	string	No
Custom2STRContains	query	string	No
Custom2STRLike	query	string	No
Custom2STRBetween	query	string[]	No
Custom2STRIn	query	string[]	No
Custom3STR	query	string	No
Custom3STRStartsWith	query	string	No
Custom3STREndsWith	query	string	No
Custom3STRContains	query	string	No
Custom3STRLike	query	string	No
Custom3STRBetween	query	string[]	No
Custom3STRIn	query	string[]	No
Custom4STR	query	string	No
Custom4STRStartsWith	query	string	No
Custom4STREndsWith	query	string	No
Custom4STRContains	query	string	No
Custom4STRLike	query	string	No
Custom4STRBetween	query	string[]	No
Custom4STRIn	query	string[]	No
Custom5STR	query	string	No
Custom5STRStartsWith	query	string	No
Custom5STREndsWith	query	string	No
Custom5STRContains	query	string	No
Custom5STRLike	query	string	No
Custom5STRBetween	query	string[]	No
Custom5STRIn	query	string[]	No
Custom6STR	query	string	No
Custom6STRStartsWith	query	string	No
Custom6STREndsWith	query	string	No
Custom6STRContains	query	string	No
Custom6STRLike	query	string	No
Custom6STRBetween	query	string[]	No
Custom6STRIn	query	string[]	No
Custom7STR	query	string	No
Custom7STRStartsWith	query	string	No
Custom7STREndsWith	query	string	No
Custom7STRContains	query	string	No
Custom7STRLike	query	string	No
Custom7STRBetween	query	string[]	No
Custom7STRIn	query	string[]	No
Custom8STR	query	string	No
Custom8STRStartsWith	query	string	No
Custom8STREndsWith	query	string	No
Custom8STRContains	query	string	No
Custom8STRLike	query	string	No
Custom8STRBetween	query	string[]	No
Custom8STRIn	query	string[]	No
Custom9STR	query	string	No
Custom9STRStartsWith	query	string	No
Custom9STREndsWith	query	string	No
Custom9STRContains	query	string	No
Custom9STRLike	query	string	No
Custom9STRBetween	query	string[]	No
Custom9STRIn	query	string[]	No
Custom10STR	query	string	No
Custom10STRStartsWith	query	string	No
Custom10STREndsWith	query	string	No
Custom10STRContains	query	string	No
Custom10STRLike	query	string	No
Custom10STRBetween	query	string[]	No
Custom10STRIn	query	string[]	No
Custom11STR	query	string	No
Custom11STRStartsWith	query	string	No
Custom11STREndsWith	query	string	No
Custom11STRContains	query	string	No
Custom11STRLike	query	string	No
Custom11STRBetween	query	string[]	No
Custom11STRIn	query	string[]	No
Custom12STR	query	string	No
Custom12STRStartsWith	query	string	No
Custom12STREndsWith	query	string	No
Custom12STRContains	query	string	No
Custom12STRLike	query	string	No
Custom12STRBetween	query	string[]	No
Custom12STRIn	query	string[]	No
Custom13STR	query	string	No
Custom13STRStartsWith	query	string	No
Custom13STREndsWith	query	string	No
Custom13STRContains	query	string	No
Custom13STRLike	query	string	No
Custom13STRBetween	query	string[]	No
Custom13STRIn	query	string[]	No
Custom14STR	query	string	No
Custom14STRStartsWith	query	string	No
Custom14STREndsWith	query	string	No
Custom14STRContains	query	string	No
Custom14STRLike	query	string	No
Custom14STRBetween	query	string[]	No
Custom14STRIn	query	string[]	No
Custom15STR	query	string	No
Custom15STRStartsWith	query	string	No
Custom15STREndsWith	query	string	No
Custom15STRContains	query	string	No
Custom15STRLike	query	string	No
Custom15STRBetween	query	string[]	No
Custom15STRIn	query	string[]	No
NewCustomer	query	bool?	No
Modified	query	bool?	No
Discount	query	double?	No
DiscountGreaterThanOrEqualTo	query	double?	No
DiscountGreaterThan	query	double?	No
DiscountLessThan	query	double?	No
DiscountLessThanOrEqualTo	query	double?	No
DiscountNotEqualTo	query	double?	No
DiscountBetween	query	double[]	No
DiscountIn	query	double[]	No
LineLevel	query	bool?	No
OrderLevel	query	bool?	No
PricingLevel	query	string	No
PricingLevelStartsWith	query	string	No
PricingLevelEndsWith	query	string	No
PricingLevelContains	query	string	No
PricingLevelLike	query	string	No
PricingLevelBetween	query	string[]	No
PricingLevelIn	query	string[]	No
Type	query	string	No
TypeStartsWith	query	string	No
TypeEndsWith	query	string	No
TypeContains	query	string	No
TypeLike	query	string	No
TypeBetween	query	string[]	No
TypeIn	query	string[]	No
Created	query	DateTime?	No
CreatedGreaterThanOrEqualTo	query	DateTime?	No
CreatedGreaterThan	query	DateTime?	No
CreatedLessThan	query	DateTime?	No
CreatedLessThanOrEqualTo	query	DateTime?	No
CreatedNotEqualTo	query	DateTime?	No
CreatedBetween	query	DateTime[]	No
CreatedIn	query	DateTime[]	No
SalesRep2	query	string	No
SalesRep2StartsWith	query	string	No
SalesRep2EndsWith	query	string	No
SalesRep2Contains	query	string	No
SalesRep2Like	query	string	No
SalesRep2Between	query	string[]	No
SalesRep2In	query	string[]	No
LastContact	query	DateTime?	No
LastContactGreaterThanOrEqualTo	query	DateTime?	No
LastContactGreaterThan	query	DateTime?	No
LastContactLessThan	query	DateTime?	No
LastContactLessThanOrEqualTo	query	DateTime?	No
LastContactNotEqualTo	query	DateTime?	No
LastContactBetween	query	DateTime[]	No
LastContactIn	query	DateTime[]	No
LastOrder	query	DateTime?	No
LastOrderGreaterThanOrEqualTo	query	DateTime?	No
LastOrderGreaterThan	query	DateTime?	No
LastOrderLessThan	query	DateTime?	No
LastOrderLessThanOrEqualTo	query	DateTime?	No
LastOrderNotEqualTo	query	DateTime?	No
LastOrderBetween	query	DateTime[]	No
LastOrderIn	query	DateTime[]	No
ERPNotes	query	string	No
ERPNotesStartsWith	query	string	No
ERPNotesEndsWith	query	string	No
ERPNotesContains	query	string	No
ERPNotesLike	query	string	No
ERPNotesBetween	query	string[]	No
ERPNotesIn	query	string[]	No
CurBalance	query	double?	No
CurBalanceGreaterThanOrEqualTo	query	double?	No
CurBalanceGreaterThan	query	double?	No
CurBalanceLessThan	query	double?	No
CurBalanceLessThanOrEqualTo	query	double?	No
CurBalanceNotEqualTo	query	double?	No
CurBalanceBetween	query	double[]	No
CurBalanceIn	query	double[]	No
Past30Days	query	double?	No
Past30DaysGreaterThanOrEqualTo	query	double?	No
Past30DaysGreaterThan	query	double?	No
Past30DaysLessThan	query	double?	No
Past30DaysLessThanOrEqualTo	query	double?	No
Past30DaysNotEqualTo	query	double?	No
Past30DaysBetween	query	double[]	No
Past30DaysIn	query	double[]	No
Past60Days	query	double?	No
Past60DaysGreaterThanOrEqualTo	query	double?	No
Past60DaysGreaterThan	query	double?	No
Past60DaysLessThan	query	double?	No
Past60DaysLessThanOrEqualTo	query	double?	No
Past60DaysNotEqualTo	query	double?	No
Past60DaysBetween	query	double[]	No
Past60DaysIn	query	double[]	No
Past90Days	query	double?	No
Past90DaysGreaterThanOrEqualTo	query	double?	No
Past90DaysGreaterThan	query	double?	No
Past90DaysLessThan	query	double?	No
Past90DaysLessThanOrEqualTo	query	double?	No
Past90DaysNotEqualTo	query	double?	No
Past90DaysBetween	query	double[]	No
Past90DaysIn	query	double[]	No
Past1Days	query	double?	No
Past1DaysGreaterThanOrEqualTo	query	double?	No
Past1DaysGreaterThan	query	double?	No
Past1DaysLessThan	query	double?	No
Past1DaysLessThanOrEqualTo	query	double?	No
Past1DaysNotEqualTo	query	double?	No
Past1DaysBetween	query	double[]	No
Past1DaysIn	query	double[]	No
Source	query	string	No
SourceStartsWith	query	string	No
SourceEndsWith	query	string	No
SourceContains	query	string	No
SourceLike	query	string	No
SourceBetween	query	string[]	No
SourceIn	query	string[]	No
TerritoryId	query	string	No
TerritoryIdStartsWith	query	string	No
TerritoryIdEndsWith	query	string	No
TerritoryIdContains	query	string	No
TerritoryIdLike	query	string	No
TerritoryIdBetween	query	string[]	No
TerritoryIdIn	query	string[]	No
RegionId	query	string	No
RegionIdStartsWith	query	string	No
RegionIdEndsWith	query	string	No
RegionIdContains	query	string	No
RegionIdLike	query	string	No
RegionIdBetween	query	string[]	No
RegionIdIn	query	string[]	No
OriginalCustomerId	query	string	No
OriginalCustomerIdStartsWith	query	string	No
OriginalCustomerIdEndsWith	query	string	No
OriginalCustomerIdContains	query	string	No
OriginalCustomerIdLike	query	string	No
OriginalCustomerIdBetween	query	string[]	No
OriginalCustomerIdIn	query	string[]	No
Exported	query	bool?	No
CurrencyCode	query	string	No
CurrencyCodeStartsWith	query	string	No
CurrencyCodeEndsWith	query	string	No
CurrencyCodeContains	query	string	No
CurrencyCodeLike	query	string	No
CurrencyCodeBetween	query	string[]	No
CurrencyCodeIn	query	string[]	No
CYForecast	query	double?	No
CYForecastGreaterThanOrEqualTo	query	double?	No
CYForecastGreaterThan	query	double?	No
CYForecastLessThan	query	double?	No
CYForecastLessThanOrEqualTo	query	double?	No
CYForecastNotEqualTo	query	double?	No
CYForecastBetween	query	double[]	No
CYForecastIn	query	double[]	No
NYForecast	query	double?	No
NYForecastGreaterThanOrEqualTo	query	double?	No
NYForecastGreaterThan	query	double?	No
NYForecastLessThan	query	double?	No
NYForecastLessThanOrEqualTo	query	double?	No
NYForecastNotEqualTo	query	double?	No
NYForecastBetween	query	double[]	No
NYForecastIn	query	double[]	No
InfoReviewed	query	DateTime?	No
InfoReviewedGreaterThanOrEqualTo	query	DateTime?	No
InfoReviewedGreaterThan	query	DateTime?	No
InfoReviewedLessThan	query	DateTime?	No
InfoReviewedLessThanOrEqualTo	query	DateTime?	No
InfoReviewedNotEqualTo	query	DateTime?	No
InfoReviewedBetween	query	DateTime[]	No
InfoReviewedIn	query	DateTime[]	No
_InfoReviewed	query	bool?	No
PriceList	query	string	No
PriceListStartsWith	query	string	No
PriceListEndsWith	query	string	No
PriceListContains	query	string	No
PriceListLike	query	string	No
PriceListBetween	query	string[]	No
PriceListIn	query	string[]	No
Ranking	query	string	No
RankingStartsWith	query	string	No
RankingEndsWith	query	string	No
RankingContains	query	string	No
RankingLike	query	string	No
RankingBetween	query	string[]	No
RankingIn	query	string[]	No
Hash	query	string	No
HashStartsWith	query	string	No
HashEndsWith	query	string	No
HashContains	query	string	No
HashLike	query	string	No
HashBetween	query	string[]	No
HashIn	query	string[]	No
SalesRep3	query	string	No
SalesRep3StartsWith	query	string	No
SalesRep3EndsWith	query	string	No
SalesRep3Contains	query	string	No
SalesRep3Like	query	string	No
SalesRep3Between	query	string[]	No
SalesRep3In	query	string[]	No
SalesRep4	query	string	No
SalesRep4StartsWith	query	string	No
SalesRep4EndsWith	query	string	No
SalesRep4Contains	query	string	No
SalesRep4Like	query	string	No
SalesRep4Between	query	string[]	No
SalesRep4In	query	string[]	No
SalesRep5	query	string	No
SalesRep5StartsWith	query	string	No
SalesRep5EndsWith	query	string	No
SalesRep5Contains	query	string	No
SalesRep5Like	query	string	No
SalesRep5Between	query	string[]	No
SalesRep5In	query	string[]	No
Residential	query	bool?	No
PORequired	query	bool?	No
Custom16STR	query	string	No
Custom16STRStartsWith	query	string	No
Custom16STREndsWith	query	string	No
Custom16STRContains	query	string	No
Custom16STRLike	query	string	No
Custom16STRBetween	query	string[]	No
Custom16STRIn	query	string[]	No
Custom17STR	query	string	No
Custom17STRStartsWith	query	string	No
Custom17STREndsWith	query	string	No
Custom17STRContains	query	string	No
Custom17STRLike	query	string	No
Custom17STRBetween	query	string[]	No
Custom17STRIn	query	string[]	No
Custom18STR	query	string	No
Custom18STRStartsWith	query	string	No
Custom18STREndsWith	query	string	No
Custom18STRContains	query	string	No
Custom18STRLike	query	string	No
Custom18STRBetween	query	string[]	No
Custom18STRIn	query	string[]	No
Custom19STR	query	string	No
Custom19STRStartsWith	query	string	No
Custom19STREndsWith	query	string	No
Custom19STRContains	query	string	No
Custom19STRLike	query	string	No
Custom19STRBetween	query	string[]	No
Custom19STRIn	query	string[]	No
Custom20STR	query	string	No
Custom20STRStartsWith	query	string	No
Custom20STREndsWith	query	string	No
Custom20STRContains	query	string	No
Custom20STRLike	query	string	No
Custom20STRBetween	query	string[]	No
Custom20STRIn	query	string[]	No
Custom21STR	query	string	No
Custom21STRStartsWith	query	string	No
Custom21STREndsWith	query	string	No
Custom21STRContains	query	string	No
Custom21STRLike	query	string	No
Custom21STRBetween	query	string[]	No
Custom21STRIn	query	string[]	No
Custom22STR	query	string	No
Custom22STRStartsWith	query	string	No
Custom22STREndsWith	query	string	No
Custom22STRContains	query	string	No
Custom22STRLike	query	string	No
Custom22STRBetween	query	string[]	No
Custom22STRIn	query	string[]	No
Custom23STR	query	string	No
Custom23STRStartsWith	query	string	No
Custom23STREndsWith	query	string	No
Custom23STRContains	query	string	No
Custom23STRLike	query	string	No
Custom23STRBetween	query	string[]	No
Custom23STRIn	query	string[]	No
Custom24STR	query	string	No
Custom24STRStartsWith	query	string	No
Custom24STREndsWith	query	string	No
Custom24STRContains	query	string	No
Custom24STRLike	query	string	No
Custom24STRBetween	query	string[]	No
Custom24STRIn	query	string[]	No
Custom25STR	query	string	No
Custom25STRStartsWith	query	string	No
Custom25STREndsWith	query	string	No
Custom25STRContains	query	string	No
Custom25STRLike	query	string	No
Custom25STRBetween	query	string[]	No
Custom25STRIn	query	string[]	No
Custom26STR	query	string	No
Custom26STRStartsWith	query	string	No
Custom26STREndsWith	query	string	No
Custom26STRContains	query	string	No
Custom26STRLike	query	string	No
Custom26STRBetween	query	string[]	No
Custom26STRIn	query	string[]	No
Custom27STR	query	string	No
Custom27STRStartsWith	query	string	No
Custom27STREndsWith	query	string	No
Custom27STRContains	query	string	No
Custom27STRLike	query	string	No
Custom27STRBetween	query	string[]	No
Custom27STRIn	query	string[]	No
Custom28STR	query	string	No
Custom28STRStartsWith	query	string	No
Custom28STREndsWith	query	string	No
Custom28STRContains	query	string	No
Custom28STRLike	query	string	No
Custom28STRBetween	query	string[]	No
Custom28STRIn	query	string[]	No
Custom29STR	query	string	No
Custom29STRStartsWith	query	string	No
Custom29STREndsWith	query	string	No
Custom29STRContains	query	string	No
Custom29STRLike	query	string	No
Custom29STRBetween	query	string[]	No
Custom29STRIn	query	string[]	No
Custom30STR	query	string	No
Custom30STRStartsWith	query	string	No
Custom30STREndsWith	query	string	No
Custom30STRContains	query	string	No
Custom30STRLike	query	string	No
Custom30STRBetween	query	string[]	No
Custom30STRIn	query	string[]	No
CreditAvailable	query	double?	No
CreditAvailableGreaterThanOrEqualTo	query	double?	No
CreditAvailableGreaterThan	query	double?	No
CreditAvailableLessThan	query	double?	No
CreditAvailableLessThanOrEqualTo	query	double?	No
CreditAvailableNotEqualTo	query	double?	No
CreditAvailableBetween	query	double[]	No
CreditAvailableIn	query	double[]	No
TotalBalance	query	double?	No
TotalBalanceGreaterThanOrEqualTo	query	double?	No
TotalBalanceGreaterThan	query	double?	No
TotalBalanceLessThan	query	double?	No
TotalBalanceLessThanOrEqualTo	query	double?	No
TotalBalanceNotEqualTo	query	double?	No
TotalBalanceBetween	query	double[]	No
TotalBalanceIn	query	double[]	No
FutureBalance	query	double?	No
FutureBalanceGreaterThanOrEqualTo	query	double?	No
FutureBalanceGreaterThan	query	double?	No
FutureBalanceLessThan	query	double?	No
FutureBalanceLessThanOrEqualTo	query	double?	No
FutureBalanceNotEqualTo	query	double?	No
FutureBalanceBetween	query	double[]	No
FutureBalanceIn	query	double[]	No
BankAddress	query	string	No
BankAddressStartsWith	query	string	No
BankAddressEndsWith	query	string	No
BankAddressContains	query	string	No
BankAddressLike	query	string	No
BankAddressBetween	query	string[]	No
BankAddressIn	query	string[]	No
BankCity	query	string	No
BankCityStartsWith	query	string	No
BankCityEndsWith	query	string	No
BankCityContains	query	string	No
BankCityLike	query	string	No
BankCityBetween	query	string[]	No
BankCityIn	query	string[]	No
BankState	query	string	No
BankStateStartsWith	query	string	No
BankStateEndsWith	query	string	No
BankStateContains	query	string	No
BankStateLike	query	string	No
BankStateBetween	query	string[]	No
BankStateIn	query	string[]	No
BankZipcode	query	string	No
BankZipcodeStartsWith	query	string	No
BankZipcodeEndsWith	query	string	No
BankZipcodeContains	query	string	No
BankZipcodeLike	query	string	No
BankZipcodeBetween	query	string[]	No
BankZipcodeIn	query	string[]	No
BankPhone	query	string	No
BankPhoneStartsWith	query	string	No
BankPhoneEndsWith	query	string	No
BankPhoneContains	query	string	No
BankPhoneLike	query	string	No
BankPhoneBetween	query	string[]	No
BankPhoneIn	query	string[]	No
BankFax	query	string	No
BankFaxStartsWith	query	string	No
BankFaxEndsWith	query	string	No
BankFaxContains	query	string	No
BankFaxLike	query	string	No
BankFaxBetween	query	string[]	No
BankFaxIn	query	string[]	No
BankContact	query	string	No
BankContactStartsWith	query	string	No
BankContactEndsWith	query	string	No
BankContactContains	query	string	No
BankContactLike	query	string	No
BankContactBetween	query	string[]	No
BankContactIn	query	string[]	No
Reference1Account	query	string	No
Reference1AccountStartsWith	query	string	No
Reference1AccountEndsWith	query	string	No
Reference1AccountContains	query	string	No
Reference1AccountLike	query	string	No
Reference1AccountBetween	query	string[]	No
Reference1AccountIn	query	string[]	No
Reference1Phone	query	string	No
Reference1PhoneStartsWith	query	string	No
Reference1PhoneEndsWith	query	string	No
Reference1PhoneContains	query	string	No
Reference1PhoneLike	query	string	No
Reference1PhoneBetween	query	string[]	No
Reference1PhoneIn	query	string[]	No
Reference1Fax	query	string	No
Reference1FaxStartsWith	query	string	No
Reference1FaxEndsWith	query	string	No
Reference1FaxContains	query	string	No
Reference1FaxLike	query	string	No
Reference1FaxBetween	query	string[]	No
Reference1FaxIn	query	string[]	No
Reference1Contact	query	string	No
Reference1ContactStartsWith	query	string	No
Reference1ContactEndsWith	query	string	No
Reference1ContactContains	query	string	No
Reference1ContactLike	query	string	No
Reference1ContactBetween	query	string[]	No
Reference1ContactIn	query	string[]	No
Reference2Account	query	string	No
Reference2AccountStartsWith	query	string	No
Reference2AccountEndsWith	query	string	No
Reference2AccountContains	query	string	No
Reference2AccountLike	query	string	No
Reference2AccountBetween	query	string[]	No
Reference2AccountIn	query	string[]	No
Reference2Phone	query	string	No
Reference2PhoneStartsWith	query	string	No
Reference2PhoneEndsWith	query	string	No
Reference2PhoneContains	query	string	No
Reference2PhoneLike	query	string	No
Reference2PhoneBetween	query	string[]	No
Reference2PhoneIn	query	string[]	No
Reference2Fax	query	string	No
Reference2FaxStartsWith	query	string	No
Reference2FaxEndsWith	query	string	No
Reference2FaxContains	query	string	No
Reference2FaxLike	query	string	No
Reference2FaxBetween	query	string[]	No
Reference2FaxIn	query	string[]	No
Reference2Contact	query	string	No
Reference2ContactStartsWith	query	string	No
Reference2ContactEndsWith	query	string	No
Reference2ContactContains	query	string	No
Reference2ContactLike	query	string	No
Reference2ContactBetween	query	string[]	No
Reference2ContactIn	query	string[]	No
Reference3Account	query	string	No
Reference3AccountStartsWith	query	string	No
Reference3AccountEndsWith	query	string	No
Reference3AccountContains	query	string	No
Reference3AccountLike	query	string	No
Reference3AccountBetween	query	string[]	No
Reference3AccountIn	query	string[]	No
Reference3Phone	query	string	No
Reference3PhoneStartsWith	query	string	No
Reference3PhoneEndsWith	query	string	No
Reference3PhoneContains	query	string	No
Reference3PhoneLike	query	string	No
Reference3PhoneBetween	query	string[]	No
Reference3PhoneIn	query	string[]	No
Reference3Fax	query	string	No
Reference3FaxStartsWith	query	string	No
Reference3FaxEndsWith	query	string	No
Reference3FaxContains	query	string	No
Reference3FaxLike	query	string	No
Reference3FaxBetween	query	string[]	No
Reference3FaxIn	query	string[]	No
Reference3Contact	query	string	No
Reference3ContactStartsWith	query	string	No
Reference3ContactEndsWith	query	string	No
Reference3ContactContains	query	string	No
Reference3ContactLike	query	string	No
Reference3ContactBetween	query	string[]	No
Reference3ContactIn	query	string[]	No
SalesRep1Sellable	query	bool?	No
SalesRep2Sellable	query	bool?	No
SalesRep3Sellable	query	bool?	No
SalesRep4Sellable	query	bool?	No
SalesRep5Sellable	query	bool?	No
BillAddress3	query	string	No
BillAddress3StartsWith	query	string	No
BillAddress3EndsWith	query	string	No
BillAddress3Contains	query	string	No
BillAddress3Like	query	string	No
BillAddress3Between	query	string[]	No
BillAddress3In	query	string[]	No
ShipAddress3	query	string	No
ShipAddress3StartsWith	query	string	No
ShipAddress3EndsWith	query	string	No
ShipAddress3Contains	query	string	No
ShipAddress3Like	query	string	No
ShipAddress3Between	query	string[]	No
ShipAddress3In	query	string[]	No
CreatedBy	query	string	No
CreatedByStartsWith	query	string	No
CreatedByEndsWith	query	string	No
CreatedByContains	query	string	No
CreatedByLike	query	string	No
CreatedByBetween	query	string[]	No
CreatedByIn	query	string[]	No
SetupCompleted	query	bool?	No
SendSetupForm	query	bool?	No
B2BUserId	query	string	No
B2BUserIdStartsWith	query	string	No
B2BUserIdEndsWith	query	string	No
B2BUserIdContains	query	string	No
B2BUserIdLike	query	string	No
B2BUserIdBetween	query	string[]	No
B2BUserIdIn	query	string[]	No
CreditChecksExecuted	query	int?	No
CreditChecksExecutedGreaterThanOrEqualTo	query	int?	No
CreditChecksExecutedGreaterThan	query	int?	No
CreditChecksExecutedLessThan	query	int?	No
CreditChecksExecutedLessThanOrEqualTo	query	int?	No
CreditChecksExecutedNotEqualTo	query	int?	No
CreditChecksExecutedBetween	query	int[]	No
CreditChecksExecutedIn	query	int[]	No
CreditHold	query	bool?	No
Owner	query	string	No
OwnerStartsWith	query	string	No
OwnerEndsWith	query	string	No
OwnerContains	query	string	No
OwnerLike	query	string	No
OwnerBetween	query	string[]	No
OwnerIn	query	string[]	No
LocationType	query	string	No
LocationTypeStartsWith	query	string	No
LocationTypeEndsWith	query	string	No
LocationTypeContains	query	string	No
LocationTypeLike	query	string	No
LocationTypeBetween	query	string[]	No
LocationTypeIn	query	string[]	No
AnnualSales	query	string	No
AnnualSalesStartsWith	query	string	No
AnnualSalesEndsWith	query	string	No
AnnualSalesContains	query	string	No
AnnualSalesLike	query	string	No
AnnualSalesBetween	query	string[]	No
AnnualSalesIn	query	string[]	No
NumOfEmployees	query	string	No
NumOfEmployeesStartsWith	query	string	No
NumOfEmployeesEndsWith	query	string	No
NumOfEmployeesContains	query	string	No
NumOfEmployeesLike	query	string	No
NumOfEmployeesBetween	query	string[]	No
NumOfEmployeesIn	query	string[]	No
YearBusinessOpened	query	string	No
YearBusinessOpenedStartsWith	query	string	No
YearBusinessOpenedEndsWith	query	string	No
YearBusinessOpenedContains	query	string	No
YearBusinessOpenedLike	query	string	No
YearBusinessOpenedBetween	query	string[]	No
YearBusinessOpenedIn	query	string[]	No
DaysHoursOfOperation	query	string	No
DaysHoursOfOperationStartsWith	query	string	No
DaysHoursOfOperationEndsWith	query	string	No
DaysHoursOfOperationContains	query	string	No
DaysHoursOfOperationLike	query	string	No
DaysHoursOfOperationBetween	query	string[]	No
DaysHoursOfOperationIn	query	string[]	No
BestTimesToContact	query	string	No
BestTimesToContactStartsWith	query	string	No
BestTimesToContactEndsWith	query	string	No
BestTimesToContactContains	query	string	No
BestTimesToContactLike	query	string	No
BestTimesToContactBetween	query	string[]	No
BestTimesToContactIn	query	string[]	No
BuyingMonths	query	string	No
BuyingMonthsStartsWith	query	string	No
BuyingMonthsEndsWith	query	string	No
BuyingMonthsContains	query	string	No
BuyingMonthsLike	query	string	No
BuyingMonthsBetween	query	string[]	No
BuyingMonthsIn	query	string[]	No
SICCode	query	string	No
SICCodeStartsWith	query	string	No
SICCodeEndsWith	query	string	No
SICCodeContains	query	string	No
SICCodeLike	query	string	No
SICCodeBetween	query	string[]	No
SICCodeIn	query	string[]	No
NAICSCode	query	string	No
NAICSCodeStartsWith	query	string	No
NAICSCodeEndsWith	query	string	No
NAICSCodeContains	query	string	No
NAICSCodeLike	query	string	No
NAICSCodeBetween	query	string[]	No
NAICSCodeIn	query	string[]	No
CreditProfileId	query	string	No
CreditProfileIdStartsWith	query	string	No
CreditProfileIdEndsWith	query	string	No
CreditProfileIdContains	query	string	No
CreditProfileIdLike	query	string	No
CreditProfileIdBetween	query	string[]	No
CreditProfileIdIn	query	string[]	No
BankBranchLocation	query	string	No
BankBranchLocationStartsWith	query	string	No
BankBranchLocationEndsWith	query	string	No
BankBranchLocationContains	query	string	No
BankBranchLocationLike	query	string	No
BankBranchLocationBetween	query	string[]	No
BankBranchLocationIn	query	string[]	No
Reference1Address	query	string	No
Reference1AddressStartsWith	query	string	No
Reference1AddressEndsWith	query	string	No
Reference1AddressContains	query	string	No
Reference1AddressLike	query	string	No
Reference1AddressBetween	query	string[]	No
Reference1AddressIn	query	string[]	No
Reference1City	query	string	No
Reference1CityStartsWith	query	string	No
Reference1CityEndsWith	query	string	No
Reference1CityContains	query	string	No
Reference1CityLike	query	string	No
Reference1CityBetween	query	string[]	No
Reference1CityIn	query	string[]	No
Reference1State	query	string	No
Reference1StateStartsWith	query	string	No
Reference1StateEndsWith	query	string	No
Reference1StateContains	query	string	No
Reference1StateLike	query	string	No
Reference1StateBetween	query	string[]	No
Reference1StateIn	query	string[]	No
Reference1Zip	query	string	No
Reference1ZipStartsWith	query	string	No
Reference1ZipEndsWith	query	string	No
Reference1ZipContains	query	string	No
Reference1ZipLike	query	string	No
Reference1ZipBetween	query	string[]	No
Reference1ZipIn	query	string[]	No
Reference2Address	query	string	No
Reference2AddressStartsWith	query	string	No
Reference2AddressEndsWith	query	string	No
Reference2AddressContains	query	string	No
Reference2AddressLike	query	string	No
Reference2AddressBetween	query	string[]	No
Reference2AddressIn	query	string[]	No
Reference2City	query	string	No
Reference2CityStartsWith	query	string	No
Reference2CityEndsWith	query	string	No
Reference2CityContains	query	string	No
Reference2CityLike	query	string	No
Reference2CityBetween	query	string[]	No
Reference2CityIn	query	string[]	No
Reference2State	query	string	No
Reference2StateStartsWith	query	string	No
Reference2StateEndsWith	query	string	No
Reference2StateContains	query	string	No
Reference2StateLike	query	string	No
Reference2StateBetween	query	string[]	No
Reference2StateIn	query	string[]	No
Reference2Zip	query	string	No
Reference2ZipStartsWith	query	string	No
Reference2ZipEndsWith	query	string	No
Reference2ZipContains	query	string	No
Reference2ZipLike	query	string	No
Reference2ZipBetween	query	string[]	No
Reference2ZipIn	query	string[]	No
Reference3Address	query	string	No
Reference3AddressStartsWith	query	string	No
Reference3AddressEndsWith	query	string	No
Reference3AddressContains	query	string	No
Reference3AddressLike	query	string	No
Reference3AddressBetween	query	string[]	No
Reference3AddressIn	query	string[]	No
Reference3City	query	string	No
Reference3CityStartsWith	query	string	No
Reference3CityEndsWith	query	string	No
Reference3CityContains	query	string	No
Reference3CityLike	query	string	No
Reference3CityBetween	query	string[]	No
Reference3CityIn	query	string[]	No
Reference3State	query	string	No
Reference3StateStartsWith	query	string	No
Reference3StateEndsWith	query	string	No
Reference3StateContains	query	string	No
Reference3StateLike	query	string	No
Reference3StateBetween	query	string[]	No
Reference3StateIn	query	string[]	No
Reference3Zip	query	string	No
Reference3ZipStartsWith	query	string	No
Reference3ZipEndsWith	query	string	No
Reference3ZipContains	query	string	No
Reference3ZipLike	query	string	No
Reference3ZipBetween	query	string[]	No
Reference3ZipIn	query	string[]	No
DNU	query	bool?	No
RestrictionGroup	query	string	No
RestrictionGroupStartsWith	query	string	No
RestrictionGroupEndsWith	query	string	No
RestrictionGroupContains	query	string	No
RestrictionGroupLike	query	string	No
RestrictionGroupBetween	query	string[]	No
RestrictionGroupIn	query	string[]	No
DiscountPercent1	query	double?	No
DiscountPercent1GreaterThanOrEqualTo	query	double?	No
DiscountPercent1GreaterThan	query	double?	No
DiscountPercent1LessThan	query	double?	No
DiscountPercent1LessThanOrEqualTo	query	double?	No
DiscountPercent1NotEqualTo	query	double?	No
DiscountPercent1Between	query	double[]	No
DiscountPercent1In	query	double[]	No
DiscountPercent2	query	double?	No
DiscountPercent2GreaterThanOrEqualTo	query	double?	No
DiscountPercent2GreaterThan	query	double?	No
DiscountPercent2LessThan	query	double?	No
DiscountPercent2LessThanOrEqualTo	query	double?	No
DiscountPercent2NotEqualTo	query	double?	No
DiscountPercent2Between	query	double[]	No
DiscountPercent2In	query	double[]	No
DiscountPercent3	query	double?	No
DiscountPercent3GreaterThanOrEqualTo	query	double?	No
DiscountPercent3GreaterThan	query	double?	No
DiscountPercent3LessThan	query	double?	No
DiscountPercent3LessThanOrEqualTo	query	double?	No
DiscountPercent3NotEqualTo	query	double?	No
DiscountPercent3Between	query	double[]	No
DiscountPercent3In	query	double[]	No
DiscountPercent4	query	double?	No
DiscountPercent4GreaterThanOrEqualTo	query	double?	No
DiscountPercent4GreaterThan	query	double?	No
DiscountPercent4LessThan	query	double?	No
DiscountPercent4LessThanOrEqualTo	query	double?	No
DiscountPercent4NotEqualTo	query	double?	No
DiscountPercent4Between	query	double[]	No
DiscountPercent4In	query	double[]	No
DiscountPercent5	query	double?	No
DiscountPercent5GreaterThanOrEqualTo	query	double?	No
DiscountPercent5GreaterThan	query	double?	No
DiscountPercent5LessThan	query	double?	No
DiscountPercent5LessThanOrEqualTo	query	double?	No
DiscountPercent5NotEqualTo	query	double?	No
DiscountPercent5Between	query	double[]	No
DiscountPercent5In	query	double[]	No
KeyAccountGroup	query	string	No
KeyAccountGroupStartsWith	query	string	No
KeyAccountGroupEndsWith	query	string	No
KeyAccountGroupContains	query	string	No
KeyAccountGroupLike	query	string	No
KeyAccountGroupBetween	query	string[]	No
KeyAccountGroupIn	query	string[]	No
Custom31STR	query	string	No
Custom31STRStartsWith	query	string	No
Custom31STREndsWith	query	string	No
Custom31STRContains	query	string	No
Custom31STRLike	query	string	No
Custom31STRBetween	query	string[]	No
Custom31STRIn	query	string[]	No
Custom32STR	query	string	No
Custom32STRStartsWith	query	string	No
Custom32STREndsWith	query	string	No
Custom32STRContains	query	string	No
Custom32STRLike	query	string	No
Custom32STRBetween	query	string[]	No
Custom32STRIn	query	string[]	No
Custom33STR	query	string	No
Custom33STRStartsWith	query	string	No
Custom33STREndsWith	query	string	No
Custom33STRContains	query	string	No
Custom33STRLike	query	string	No
Custom33STRBetween	query	string[]	No
Custom33STRIn	query	string[]	No
Custom34STR	query	string	No
Custom34STRStartsWith	query	string	No
Custom34STREndsWith	query	string	No
Custom34STRContains	query	string	No
Custom34STRLike	query	string	No
Custom34STRBetween	query	string[]	No
Custom34STRIn	query	string[]	No
Custom35STR	query	string	No
Custom35STRStartsWith	query	string	No
Custom35STREndsWith	query	string	No
Custom35STRContains	query	string	No
Custom35STRLike	query	string	No
Custom35STRBetween	query	string[]	No
Custom35STRIn	query	string[]	No
Custom36STR	query	string	No
Custom36STRStartsWith	query	string	No
Custom36STREndsWith	query	string	No
Custom36STRContains	query	string	No
Custom36STRLike	query	string	No
Custom36STRBetween	query	string[]	No
Custom36STRIn	query	string[]	No
Custom37STR	query	string	No
Custom37STRStartsWith	query	string	No
Custom37STREndsWith	query	string	No
Custom37STRContains	query	string	No
Custom37STRLike	query	string	No
Custom37STRBetween	query	string[]	No
Custom37STRIn	query	string[]	No
Custom38STR	query	string	No
Custom38STRStartsWith	query	string	No
Custom38STREndsWith	query	string	No
Custom38STRContains	query	string	No
Custom38STRLike	query	string	No
Custom38STRBetween	query	string[]	No
Custom38STRIn	query	string[]	No
Custom39STR	query	string	No
Custom39STRStartsWith	query	string	No
Custom39STREndsWith	query	string	No
Custom39STRContains	query	string	No
Custom39STRLike	query	string	No
Custom39STRBetween	query	string[]	No
Custom39STRIn	query	string[]	No
Custom40STR	query	string	No
Custom40STRStartsWith	query	string	No
Custom40STREndsWith	query	string	No
Custom40STRContains	query	string	No
Custom40STRLike	query	string	No
Custom40STRBetween	query	string[]	No
Custom40STRIn	query	string[]	No
Custom41STR	query	string	No
Custom41STRStartsWith	query	string	No
Custom41STREndsWith	query	string	No
Custom41STRContains	query	string	No
Custom41STRLike	query	string	No
Custom41STRBetween	query	string[]	No
Custom41STRIn	query	string[]	No
Custom42STR	query	string	No
Custom42STRStartsWith	query	string	No
Custom42STREndsWith	query	string	No
Custom42STRContains	query	string	No
Custom42STRLike	query	string	No
Custom42STRBetween	query	string[]	No
Custom42STRIn	query	string[]	No
Custom43STR	query	string	No
Custom43STRStartsWith	query	string	No
Custom43STREndsWith	query	string	No
Custom43STRContains	query	string	No
Custom43STRLike	query	string	No
Custom43STRBetween	query	string[]	No
Custom43STRIn	query	string[]	No
Custom44STR	query	string	No
Custom44STRStartsWith	query	string	No
Custom44STREndsWith	query	string	No
Custom44STRContains	query	string	No
Custom44STRLike	query	string	No
Custom44STRBetween	query	string[]	No
Custom44STRIn	query	string[]	No
Custom45STR	query	string	No
Custom45STRStartsWith	query	string	No
Custom45STREndsWith	query	string	No
Custom45STRContains	query	string	No
Custom45STRLike	query	string	No
Custom45STRBetween	query	string[]	No
Custom45STRIn	query	string[]	No
DefaultWarehouseId	query	string	No
DefaultWarehouseIdStartsWith	query	string	No
DefaultWarehouseIdEndsWith	query	string	No
DefaultWarehouseIdContains	query	string	No
DefaultWarehouseIdLike	query	string	No
DefaultWarehouseIdBetween	query	string[]	No
DefaultWarehouseIdIn	query	string[]	No
Status	query	string	No
StatusStartsWith	query	string	No
StatusEndsWith	query	string	No
StatusContains	query	string	No
StatusLike	query	string	No
StatusBetween	query	string[]	No
StatusIn	query	string[]	No
ContainerPriceList	query	string	No
ContainerPriceListStartsWith	query	string	No
ContainerPriceListEndsWith	query	string	No
ContainerPriceListContains	query	string	No
ContainerPriceListLike	query	string	No
ContainerPriceListBetween	query	string[]	No
ContainerPriceListIn	query	string[]	No
CreditSheetNotes	query	string	No
CreditSheetNotesStartsWith	query	string	No
CreditSheetNotesEndsWith	query	string	No
CreditSheetNotesContains	query	string	No
CreditSheetNotesLike	query	string	No
CreditSheetNotesBetween	query	string[]	No
CreditSheetNotesIn	query	string[]	No
DiscountPoints	query	double?	No
DiscountPointsGreaterThanOrEqualTo	query	double?	No
DiscountPointsGreaterThan	query	double?	No
DiscountPointsLessThan	query	double?	No
DiscountPointsLessThanOrEqualTo	query	double?	No
DiscountPointsNotEqualTo	query	double?	No
DiscountPointsBetween	query	double[]	No
DiscountPointsIn	query	double[]	No
CustomerTags	query	string	No
CustomerTagsStartsWith	query	string	No
CustomerTagsEndsWith	query	string	No
CustomerTagsContains	query	string	No
CustomerTagsLike	query	string	No
CustomerTagsBetween	query	string[]	No
CustomerTagsIn	query	string[]	No
StateTaxExpiration	query	DateTime?	No
StateTaxExpirationGreaterThanOrEqualTo	query	DateTime?	No
StateTaxExpirationGreaterThan	query	DateTime?	No
StateTaxExpirationLessThan	query	DateTime?	No
StateTaxExpirationLessThanOrEqualTo	query	DateTime?	No
StateTaxExpirationNotEqualTo	query	DateTime?	No
StateTaxExpirationBetween	query	DateTime[]	No
StateTaxExpirationIn	query	DateTime[]	No
BlockWebAccess	query	bool?	No
BackOrders	query	int?	No
BackOrdersGreaterThanOrEqualTo	query	int?	No
BackOrdersGreaterThan	query	int?	No
BackOrdersLessThan	query	int?	No
BackOrdersLessThanOrEqualTo	query	int?	No
BackOrdersNotEqualTo	query	int?	No
BackOrdersBetween	query	int[]	No
BackOrdersIn	query	int[]	No

To override the Content-type in your clients, use the HTTP Accept Header, append the .other suffix or ?format=other

HTTP + OTHER

The following are sample HTTP requests and responses. The placeholders shown need to be replaced with actual values.

POST /service/QueryCustomerRDB HTTP/1.1 
Host: www.bernhardthospitality.com 
Accept: application/vnd.openxmlformats-officedocument.spreadsheetml.sheet
Content-Type: application/vnd.openxmlformats-officedocument.spreadsheetml.sheet
Content-Length: length

{"skip":0,"take":0,"orderBy":"String","orderByDesc":"String","include":"String","fields":"String","meta":{"String":"String"},"id":"String","idStartsWith":"String","idEndsWith":"String","idContains":"String","idLike":"String","idBetween":["String"],"idIn":["String"],"companyName":"String","companyNameStartsWith":"String","companyNameEndsWith":"String","companyNameContains":"String","companyNameLike":"String","companyNameBetween":["String"],"companyNameIn":["String"],"accountType":"String","accountTypeStartsWith":"String","accountTypeEndsWith":"String","accountTypeContains":"String","accountTypeLike":"String","accountTypeBetween":["String"],"accountTypeIn":["String"],"billAddress":"String","billAddressStartsWith":"String","billAddressEndsWith":"String","billAddressContains":"String","billAddressLike":"String","billAddressBetween":["String"],"billAddressIn":["String"],"billAddress2":"String","billAddress2StartsWith":"String","billAddress2EndsWith":"String","billAddress2Contains":"String","billAddress2Like":"String","billAddress2Between":["String"],"billAddress2In":["String"],"billCity":"String","billCityStartsWith":"String","billCityEndsWith":"String","billCityContains":"String","billCityLike":"String","billCityBetween":["String"],"billCityIn":["String"],"billState":"String","billStateStartsWith":"String","billStateEndsWith":"String","billStateContains":"String","billStateLike":"String","billStateBetween":["String"],"billStateIn":["String"],"billZipcode":"String","billZipcodeStartsWith":"String","billZipcodeEndsWith":"String","billZipcodeContains":"String","billZipcodeLike":"String","billZipcodeBetween":["String"],"billZipcodeIn":["String"],"billCountry":"String","billCountryStartsWith":"String","billCountryEndsWith":"String","billCountryContains":"String","billCountryLike":"String","billCountryBetween":["String"],"billCountryIn":["String"],"phone":"String","phoneStartsWith":"String","phoneEndsWith":"String","phoneContains":"String","phoneLike":"String","phoneBetween":["String"],"phoneIn":["String"],"shipName":"String","shipNameStartsWith":"String","shipNameEndsWith":"String","shipNameContains":"String","shipNameLike":"String","shipNameBetween":["String"],"shipNameIn":["String"],"shipAddress":"String","shipAddressStartsWith":"String","shipAddressEndsWith":"String","shipAddressContains":"String","shipAddressLike":"String","shipAddressBetween":["String"],"shipAddressIn":["String"],"shipAddress2":"String","shipAddress2StartsWith":"String","shipAddress2EndsWith":"String","shipAddress2Contains":"String","shipAddress2Like":"String","shipAddress2Between":["String"],"shipAddress2In":["String"],"shipCity":"String","shipCityStartsWith":"String","shipCityEndsWith":"String","shipCityContains":"String","shipCityLike":"String","shipCityBetween":["String"],"shipCityIn":["String"],"shipState":"String","shipStateStartsWith":"String","shipStateEndsWith":"String","shipStateContains":"String","shipStateLike":"String","shipStateBetween":["String"],"shipStateIn":["String"],"shipZipcode":"String","shipZipcodeStartsWith":"String","shipZipcodeEndsWith":"String","shipZipcodeContains":"String","shipZipcodeLike":"String","shipZipcodeBetween":["String"],"shipZipcodeIn":["String"],"shipCountry":"String","shipCountryStartsWith":"String","shipCountryEndsWith":"String","shipCountryContains":"String","shipCountryLike":"String","shipCountryBetween":["String"],"shipCountryIn":["String"],"shipPhone":"String","shipPhoneStartsWith":"String","shipPhoneEndsWith":"String","shipPhoneContains":"String","shipPhoneLike":"String","shipPhoneBetween":["String"],"shipPhoneIn":["String"],"email":"String","emailStartsWith":"String","emailEndsWith":"String","emailContains":"String","emailLike":"String","emailBetween":["String"],"emailIn":["String"],"website":"String","websiteStartsWith":"String","websiteEndsWith":"String","websiteContains":"String","websiteLike":"String","websiteBetween":["String"],"websiteIn":["String"],"fax":"String","faxStartsWith":"String","faxEndsWith":"String","faxContains":"String","faxLike":"String","faxBetween":["String"],"faxIn":["String"],"contact":"String","contactStartsWith":"String","contactEndsWith":"String","contactContains":"String","contactLike":"String","contactBetween":["String"],"contactIn":["String"],"creditCardType":"String","creditCardTypeStartsWith":"String","creditCardTypeEndsWith":"String","creditCardTypeContains":"String","creditCardTypeLike":"String","creditCardTypeBetween":["String"],"creditCardTypeIn":["String"],"creditCardNumber":"String","creditCardNumberStartsWith":"String","creditCardNumberEndsWith":"String","creditCardNumberContains":"String","creditCardNumberLike":"String","creditCardNumberBetween":["String"],"creditCardNumberIn":["String"],"creditCardExpiration":"String","creditCardExpirationStartsWith":"String","creditCardExpirationEndsWith":"String","creditCardExpirationContains":"String","creditCardExpirationLike":"String","creditCardExpirationBetween":["String"],"creditCardExpirationIn":["String"],"creditCardAVS":"String","creditCardAVSStartsWith":"String","creditCardAVSEndsWith":"String","creditCardAVSContains":"String","creditCardAVSLike":"String","creditCardAVSBetween":["String"],"creditCardAVSIn":["String"],"creditCardName":"String","creditCardNameStartsWith":"String","creditCardNameEndsWith":"String","creditCardNameContains":"String","creditCardNameLike":"String","creditCardNameBetween":["String"],"creditCardNameIn":["String"],"creditCardAddress":"String","creditCardAddressStartsWith":"String","creditCardAddressEndsWith":"String","creditCardAddressContains":"String","creditCardAddressLike":"String","creditCardAddressBetween":["String"],"creditCardAddressIn":["String"],"creditCardAddress2":"String","creditCardAddress2StartsWith":"String","creditCardAddress2EndsWith":"String","creditCardAddress2Contains":"String","creditCardAddress2Like":"String","creditCardAddress2Between":["String"],"creditCardAddress2In":["String"],"creditCardCity":"String","creditCardCityStartsWith":"String","creditCardCityEndsWith":"String","creditCardCityContains":"String","creditCardCityLike":"String","creditCardCityBetween":["String"],"creditCardCityIn":["String"],"creditCardState":"String","creditCardStateStartsWith":"String","creditCardStateEndsWith":"String","creditCardStateContains":"String","creditCardStateLike":"String","creditCardStateBetween":["String"],"creditCardStateIn":["String"],"creditCardZipcode":"String","creditCardZipcodeStartsWith":"String","creditCardZipcodeEndsWith":"String","creditCardZipcodeContains":"String","creditCardZipcodeLike":"String","creditCardZipcodeBetween":["String"],"creditCardZipcodeIn":["String"],"creditCardCountry":"String","creditCardCountryStartsWith":"String","creditCardCountryEndsWith":"String","creditCardCountryContains":"String","creditCardCountryLike":"String","creditCardCountryBetween":["String"],"creditCardCountryIn":["String"],"shipVia":"String","shipViaStartsWith":"String","shipViaEndsWith":"String","shipViaContains":"String","shipViaLike":"String","shipViaBetween":["String"],"shipViaIn":["String"],"terms":"String","termsStartsWith":"String","termsEndsWith":"String","termsContains":"String","termsLike":"String","termsBetween":["String"],"termsIn":["String"],"salesRep":"String","salesRepStartsWith":"String","salesRepEndsWith":"String","salesRepContains":"String","salesRepLike":"String","salesRepBetween":["String"],"salesRepIn":["String"],"notes":"String","notesStartsWith":"String","notesEndsWith":"String","notesContains":"String","notesLike":"String","notesBetween":["String"],"notesIn":["String"],"keyAccount":false,"creditLimit":0,"creditLimitGreaterThanOrEqualTo":0,"creditLimitGreaterThan":0,"creditLimitLessThan":0,"creditLimitLessThanOrEqualTo":0,"creditLimitNotEqualTo":0,"creditLimitBetween":[0],"creditLimitIn":[0],"dbNum":"String","dbNumStartsWith":"String","dbNumEndsWith":"String","dbNumContains":"String","dbNumLike":"String","dbNumBetween":["String"],"dbNumIn":["String"],"bank":"String","bankStartsWith":"String","bankEndsWith":"String","bankContains":"String","bankLike":"String","bankBetween":["String"],"bankIn":["String"],"bankAccountNum":"String","bankAccountNumStartsWith":"String","bankAccountNumEndsWith":"String","bankAccountNumContains":"String","bankAccountNumLike":"String","bankAccountNumBetween":["String"],"bankAccountNumIn":["String"],"bankAccountType":"String","bankAccountTypeStartsWith":"String","bankAccountTypeEndsWith":"String","bankAccountTypeContains":"String","bankAccountTypeLike":"String","bankAccountTypeBetween":["String"],"bankAccountTypeIn":["String"],"federalTaxId":"String","federalTaxIdStartsWith":"String","federalTaxIdEndsWith":"String","federalTaxIdContains":"String","federalTaxIdLike":"String","federalTaxIdBetween":["String"],"federalTaxIdIn":["String"],"stateTaxId":"String","stateTaxIdStartsWith":"String","stateTaxIdEndsWith":"String","stateTaxIdContains":"String","stateTaxIdLike":"String","stateTaxIdBetween":["String"],"stateTaxIdIn":["String"],"reference1":"String","reference1StartsWith":"String","reference1EndsWith":"String","reference1Contains":"String","reference1Like":"String","reference1Between":["String"],"reference1In":["String"],"reference2":"String","reference2StartsWith":"String","reference2EndsWith":"String","reference2Contains":"String","reference2Like":"String","reference2Between":["String"],"reference2In":["String"],"reference3":"String","reference3StartsWith":"String","reference3EndsWith":"String","reference3Contains":"String","reference3Like":"String","reference3Between":["String"],"reference3In":["String"],"reference4":"String","reference4StartsWith":"String","reference4EndsWith":"String","reference4Contains":"String","reference4Like":"String","reference4Between":["String"],"reference4In":["String"],"reference5":"String","reference5StartsWith":"String","reference5EndsWith":"String","reference5Contains":"String","reference5Like":"String","reference5Between":["String"],"reference5In":["String"],"faxOrder":false,"emailOrder":false,"custom1STR":"String","custom1STRStartsWith":"String","custom1STREndsWith":"String","custom1STRContains":"String","custom1STRLike":"String","custom1STRBetween":["String"],"custom1STRIn":["String"],"custom2STR":"String","custom2STRStartsWith":"String","custom2STREndsWith":"String","custom2STRContains":"String","custom2STRLike":"String","custom2STRBetween":["String"],"custom2STRIn":["String"],"custom3STR":"String","custom3STRStartsWith":"String","custom3STREndsWith":"String","custom3STRContains":"String","custom3STRLike":"String","custom3STRBetween":["String"],"custom3STRIn":["String"],"custom4STR":"String","custom4STRStartsWith":"String","custom4STREndsWith":"String","custom4STRContains":"String","custom4STRLike":"String","custom4STRBetween":["String"],"custom4STRIn":["String"],"custom5STR":"String","custom5STRStartsWith":"String","custom5STREndsWith":"String","custom5STRContains":"String","custom5STRLike":"String","custom5STRBetween":["String"],"custom5STRIn":["String"],"custom6STR":"String","custom6STRStartsWith":"String","custom6STREndsWith":"String","custom6STRContains":"String","custom6STRLike":"String","custom6STRBetween":["String"],"custom6STRIn":["String"],"custom7STR":"String","custom7STRStartsWith":"String","custom7STREndsWith":"String","custom7STRContains":"String","custom7STRLike":"String","custom7STRBetween":["String"],"custom7STRIn":["String"],"custom8STR":"String","custom8STRStartsWith":"String","custom8STREndsWith":"String","custom8STRContains":"String","custom8STRLike":"String","custom8STRBetween":["String"],"custom8STRIn":["String"],"custom9STR":"String","custom9STRStartsWith":"String","custom9STREndsWith":"String","custom9STRContains":"String","custom9STRLike":"String","custom9STRBetween":["String"],"custom9STRIn":["String"],"custom10STR":"String","custom10STRStartsWith":"String","custom10STREndsWith":"String","custom10STRContains":"String","custom10STRLike":"String","custom10STRBetween":["String"],"custom10STRIn":["String"],"custom11STR":"String","custom11STRStartsWith":"String","custom11STREndsWith":"String","custom11STRContains":"String","custom11STRLike":"String","custom11STRBetween":["String"],"custom11STRIn":["String"],"custom12STR":"String","custom12STRStartsWith":"String","custom12STREndsWith":"String","custom12STRContains":"String","custom12STRLike":"String","custom12STRBetween":["String"],"custom12STRIn":["String"],"custom13STR":"String","custom13STRStartsWith":"String","custom13STREndsWith":"String","custom13STRContains":"String","custom13STRLike":"String","custom13STRBetween":["String"],"custom13STRIn":["String"],"custom14STR":"String","custom14STRStartsWith":"String","custom14STREndsWith":"String","custom14STRContains":"String","custom14STRLike":"String","custom14STRBetween":["String"],"custom14STRIn":["String"],"custom15STR":"String","custom15STRStartsWith":"String","custom15STREndsWith":"String","custom15STRContains":"String","custom15STRLike":"String","custom15STRBetween":["String"],"custom15STRIn":["String"],"newCustomer":false,"modified":false,"discount":0,"discountGreaterThanOrEqualTo":0,"discountGreaterThan":0,"discountLessThan":0,"discountLessThanOrEqualTo":0,"discountNotEqualTo":0,"discountBetween":[0],"discountIn":[0],"lineLevel":false,"orderLevel":false,"pricingLevel":"String","pricingLevelStartsWith":"String","pricingLevelEndsWith":"String","pricingLevelContains":"String","pricingLevelLike":"String","pricingLevelBetween":["String"],"pricingLevelIn":["String"],"type":"String","typeStartsWith":"String","typeEndsWith":"String","typeContains":"String","typeLike":"String","typeBetween":["String"],"typeIn":["String"],"created":"0001-01-01T00:00:00.0000000Z","createdGreaterThanOrEqualTo":"0001-01-01T00:00:00.0000000Z","createdGreaterThan":"0001-01-01T00:00:00.0000000Z","createdLessThan":"0001-01-01T00:00:00.0000000Z","createdLessThanOrEqualTo":"0001-01-01T00:00:00.0000000Z","createdNotEqualTo":"0001-01-01T00:00:00.0000000Z","createdBetween":["0001-01-01T00:00:00.0000000Z"],"createdIn":["0001-01-01T00:00:00.0000000Z"],"salesRep2":"String","salesRep2StartsWith":"String","salesRep2EndsWith":"String","salesRep2Contains":"String","salesRep2Like":"String","salesRep2Between":["String"],"salesRep2In":["String"],"lastContact":"0001-01-01T00:00:00.0000000Z","lastContactGreaterThanOrEqualTo":"0001-01-01T00:00:00.0000000Z","lastContactGreaterThan":"0001-01-01T00:00:00.0000000Z","lastContactLessThan":"0001-01-01T00:00:00.0000000Z","lastContactLessThanOrEqualTo":"0001-01-01T00:00:00.0000000Z","lastContactNotEqualTo":"0001-01-01T00:00:00.0000000Z","lastContactBetween":["0001-01-01T00:00:00.0000000Z"],"lastContactIn":["0001-01-01T00:00:00.0000000Z"],"lastOrder":"0001-01-01T00:00:00.0000000Z","lastOrderGreaterThanOrEqualTo":"0001-01-01T00:00:00.0000000Z","lastOrderGreaterThan":"0001-01-01T00:00:00.0000000Z","lastOrderLessThan":"0001-01-01T00:00:00.0000000Z","lastOrderLessThanOrEqualTo":"0001-01-01T00:00:00.0000000Z","lastOrderNotEqualTo":"0001-01-01T00:00:00.0000000Z","lastOrderBetween":["0001-01-01T00:00:00.0000000Z"],"lastOrderIn":["0001-01-01T00:00:00.0000000Z"],"erpNotes":"String","erpNotesStartsWith":"String","erpNotesEndsWith":"String","erpNotesContains":"String","erpNotesLike":"String","erpNotesBetween":["String"],"erpNotesIn":["String"],"curBalance":0,"curBalanceGreaterThanOrEqualTo":0,"curBalanceGreaterThan":0,"curBalanceLessThan":0,"curBalanceLessThanOrEqualTo":0,"curBalanceNotEqualTo":0,"curBalanceBetween":[0],"curBalanceIn":[0],"past30Days":0,"past30DaysGreaterThanOrEqualTo":0,"past30DaysGreaterThan":0,"past30DaysLessThan":0,"past30DaysLessThanOrEqualTo":0,"past30DaysNotEqualTo":0,"past30DaysBetween":[0],"past30DaysIn":[0],"past60Days":0,"past60DaysGreaterThanOrEqualTo":0,"past60DaysGreaterThan":0,"past60DaysLessThan":0,"past60DaysLessThanOrEqualTo":0,"past60DaysNotEqualTo":0,"past60DaysBetween":[0],"past60DaysIn":[0],"past90Days":0,"past90DaysGreaterThanOrEqualTo":0,"past90DaysGreaterThan":0,"past90DaysLessThan":0,"past90DaysLessThanOrEqualTo":0,"past90DaysNotEqualTo":0,"past90DaysBetween":[0],"past90DaysIn":[0],"past1Days":0,"past1DaysGreaterThanOrEqualTo":0,"past1DaysGreaterThan":0,"past1DaysLessThan":0,"past1DaysLessThanOrEqualTo":0,"past1DaysNotEqualTo":0,"past1DaysBetween":[0],"past1DaysIn":[0],"source":"String","sourceStartsWith":"String","sourceEndsWith":"String","sourceContains":"String","sourceLike":"String","sourceBetween":["String"],"sourceIn":["String"],"territoryId":"String","territoryIdStartsWith":"String","territoryIdEndsWith":"String","territoryIdContains":"String","territoryIdLike":"String","territoryIdBetween":["String"],"territoryIdIn":["String"],"regionId":"String","regionIdStartsWith":"String","regionIdEndsWith":"String","regionIdContains":"String","regionIdLike":"String","regionIdBetween":["String"],"regionIdIn":["String"],"originalCustomerId":"String","originalCustomerIdStartsWith":"String","originalCustomerIdEndsWith":"String","originalCustomerIdContains":"String","originalCustomerIdLike":"String","originalCustomerIdBetween":["String"],"originalCustomerIdIn":["String"],"exported":false,"currencyCode":"String","currencyCodeStartsWith":"String","currencyCodeEndsWith":"String","currencyCodeContains":"String","currencyCodeLike":"String","currencyCodeBetween":["String"],"currencyCodeIn":["String"],"cyForecast":0,"cyForecastGreaterThanOrEqualTo":0,"cyForecastGreaterThan":0,"cyForecastLessThan":0,"cyForecastLessThanOrEqualTo":0,"cyForecastNotEqualTo":0,"cyForecastBetween":[0],"cyForecastIn":[0],"nyForecast":0,"nyForecastGreaterThanOrEqualTo":0,"nyForecastGreaterThan":0,"nyForecastLessThan":0,"nyForecastLessThanOrEqualTo":0,"nyForecastNotEqualTo":0,"nyForecastBetween":[0],"nyForecastIn":[0],"infoReviewed":"0001-01-01T00:00:00.0000000Z","infoReviewedGreaterThanOrEqualTo":"0001-01-01T00:00:00.0000000Z","infoReviewedGreaterThan":"0001-01-01T00:00:00.0000000Z","infoReviewedLessThan":"0001-01-01T00:00:00.0000000Z","infoReviewedLessThanOrEqualTo":"0001-01-01T00:00:00.0000000Z","infoReviewedNotEqualTo":"0001-01-01T00:00:00.0000000Z","infoReviewedBetween":["0001-01-01T00:00:00.0000000Z"],"infoReviewedIn":["0001-01-01T00:00:00.0000000Z"],"_InfoReviewed":false,"priceList":"String","priceListStartsWith":"String","priceListEndsWith":"String","priceListContains":"String","priceListLike":"String","priceListBetween":["String"],"priceListIn":["String"],"ranking":"String","rankingStartsWith":"String","rankingEndsWith":"String","rankingContains":"String","rankingLike":"String","rankingBetween":["String"],"rankingIn":["String"],"hash":"String","hashStartsWith":"String","hashEndsWith":"String","hashContains":"String","hashLike":"String","hashBetween":["String"],"hashIn":["String"],"salesRep3":"String","salesRep3StartsWith":"String","salesRep3EndsWith":"String","salesRep3Contains":"String","salesRep3Like":"String","salesRep3Between":["String"],"salesRep3In":["String"],"salesRep4":"String","salesRep4StartsWith":"String","salesRep4EndsWith":"String","salesRep4Contains":"String","salesRep4Like":"String","salesRep4Between":["String"],"salesRep4In":["String"],"salesRep5":"String","salesRep5StartsWith":"String","salesRep5EndsWith":"String","salesRep5Contains":"String","salesRep5Like":"String","salesRep5Between":["String"],"salesRep5In":["String"],"residential":false,"poRequired":false,"custom16STR":"String","custom16STRStartsWith":"String","custom16STREndsWith":"String","custom16STRContains":"String","custom16STRLike":"String","custom16STRBetween":["String"],"custom16STRIn":["String"],"custom17STR":"String","custom17STRStartsWith":"String","custom17STREndsWith":"String","custom17STRContains":"String","custom17STRLike":"String","custom17STRBetween":["String"],"custom17STRIn":["String"],"custom18STR":"String","custom18STRStartsWith":"String","custom18STREndsWith":"String","custom18STRContains":"String","custom18STRLike":"String","custom18STRBetween":["String"],"custom18STRIn":["String"],"custom19STR":"String","custom19STRStartsWith":"String","custom19STREndsWith":"String","custom19STRContains":"String","custom19STRLike":"String","custom19STRBetween":["String"],"custom19STRIn":["String"],"custom20STR":"String","custom20STRStartsWith":"String","custom20STREndsWith":"String","custom20STRContains":"String","custom20STRLike":"String","custom20STRBetween":["String"],"custom20STRIn":["String"],"custom21STR":"String","custom21STRStartsWith":"String","custom21STREndsWith":"String","custom21STRContains":"String","custom21STRLike":"String","custom21STRBetween":["String"],"custom21STRIn":["String"],"custom22STR":"String","custom22STRStartsWith":"String","custom22STREndsWith":"String","custom22STRContains":"String","custom22STRLike":"String","custom22STRBetween":["String"],"custom22STRIn":["String"],"custom23STR":"String","custom23STRStartsWith":"String","custom23STREndsWith":"String","custom23STRContains":"String","custom23STRLike":"String","custom23STRBetween":["String"],"custom23STRIn":["String"],"custom24STR":"String","custom24STRStartsWith":"String","custom24STREndsWith":"String","custom24STRContains":"String","custom24STRLike":"String","custom24STRBetween":["String"],"custom24STRIn":["String"],"custom25STR":"String","custom25STRStartsWith":"String","custom25STREndsWith":"String","custom25STRContains":"String","custom25STRLike":"String","custom25STRBetween":["String"],"custom25STRIn":["String"],"custom26STR":"String","custom26STRStartsWith":"String","custom26STREndsWith":"String","custom26STRContains":"String","custom26STRLike":"String","custom26STRBetween":["String"],"custom26STRIn":["String"],"custom27STR":"String","custom27STRStartsWith":"String","custom27STREndsWith":"String","custom27STRContains":"String","custom27STRLike":"String","custom27STRBetween":["String"],"custom27STRIn":["String"],"custom28STR":"String","custom28STRStartsWith":"String","custom28STREndsWith":"String","custom28STRContains":"String","custom28STRLike":"String","custom28STRBetween":["String"],"custom28STRIn":["String"],"custom29STR":"String","custom29STRStartsWith":"String","custom29STREndsWith":"String","custom29STRContains":"String","custom29STRLike":"String","custom29STRBetween":["String"],"custom29STRIn":["String"],"custom30STR":"String","custom30STRStartsWith":"String","custom30STREndsWith":"String","custom30STRContains":"String","custom30STRLike":"String","custom30STRBetween":["String"],"custom30STRIn":["String"],"creditAvailable":0,"creditAvailableGreaterThanOrEqualTo":0,"creditAvailableGreaterThan":0,"creditAvailableLessThan":0,"creditAvailableLessThanOrEqualTo":0,"creditAvailableNotEqualTo":0,"creditAvailableBetween":[0],"creditAvailableIn":[0],"totalBalance":0,"totalBalanceGreaterThanOrEqualTo":0,"totalBalanceGreaterThan":0,"totalBalanceLessThan":0,"totalBalanceLessThanOrEqualTo":0,"totalBalanceNotEqualTo":0,"totalBalanceBetween":[0],"totalBalanceIn":[0],"futureBalance":0,"futureBalanceGreaterThanOrEqualTo":0,"futureBalanceGreaterThan":0,"futureBalanceLessThan":0,"futureBalanceLessThanOrEqualTo":0,"futureBalanceNotEqualTo":0,"futureBalanceBetween":[0],"futureBalanceIn":[0],"bankAddress":"String","bankAddressStartsWith":"String","bankAddressEndsWith":"String","bankAddressContains":"String","bankAddressLike":"String","bankAddressBetween":["String"],"bankAddressIn":["String"],"bankCity":"String","bankCityStartsWith":"String","bankCityEndsWith":"String","bankCityContains":"String","bankCityLike":"String","bankCityBetween":["String"],"bankCityIn":["String"],"bankState":"String","bankStateStartsWith":"String","bankStateEndsWith":"String","bankStateContains":"String","bankStateLike":"String","bankStateBetween":["String"],"bankStateIn":["String"],"bankZipcode":"String","bankZipcodeStartsWith":"String","bankZipcodeEndsWith":"String","bankZipcodeContains":"String","bankZipcodeLike":"String","bankZipcodeBetween":["String"],"bankZipcodeIn":["String"],"bankPhone":"String","bankPhoneStartsWith":"String","bankPhoneEndsWith":"String","bankPhoneContains":"String","bankPhoneLike":"String","bankPhoneBetween":["String"],"bankPhoneIn":["String"],"bankFax":"String","bankFaxStartsWith":"String","bankFaxEndsWith":"String","bankFaxContains":"String","bankFaxLike":"String","bankFaxBetween":["String"],"bankFaxIn":["String"],"bankContact":"String","bankContactStartsWith":"String","bankContactEndsWith":"String","bankContactContains":"String","bankContactLike":"String","bankContactBetween":["String"],"bankContactIn":["String"],"reference1Account":"String","reference1AccountStartsWith":"String","reference1AccountEndsWith":"String","reference1AccountContains":"String","reference1AccountLike":"String","reference1AccountBetween":["String"],"reference1AccountIn":["String"],"reference1Phone":"String","reference1PhoneStartsWith":"String","reference1PhoneEndsWith":"String","reference1PhoneContains":"String","reference1PhoneLike":"String","reference1PhoneBetween":["String"],"reference1PhoneIn":["String"],"reference1Fax":"String","reference1FaxStartsWith":"String","reference1FaxEndsWith":"String","reference1FaxContains":"String","reference1FaxLike":"String","reference1FaxBetween":["String"],"reference1FaxIn":["String"],"reference1Contact":"String","reference1ContactStartsWith":"String","reference1ContactEndsWith":"String","reference1ContactContains":"String","reference1ContactLike":"String","reference1ContactBetween":["String"],"reference1ContactIn":["String"],"reference2Account":"String","reference2AccountStartsWith":"String","reference2AccountEndsWith":"String","reference2AccountContains":"String","reference2AccountLike":"String","reference2AccountBetween":["String"],"reference2AccountIn":["String"],"reference2Phone":"String","reference2PhoneStartsWith":"String","reference2PhoneEndsWith":"String","reference2PhoneContains":"String","reference2PhoneLike":"String","reference2PhoneBetween":["String"],"reference2PhoneIn":["String"],"reference2Fax":"String","reference2FaxStartsWith":"String","reference2FaxEndsWith":"String","reference2FaxContains":"String","reference2FaxLike":"String","reference2FaxBetween":["String"],"reference2FaxIn":["String"],"reference2Contact":"String","reference2ContactStartsWith":"String","reference2ContactEndsWith":"String","reference2ContactContains":"String","reference2ContactLike":"String","reference2ContactBetween":["String"],"reference2ContactIn":["String"],"reference3Account":"String","reference3AccountStartsWith":"String","reference3AccountEndsWith":"String","reference3AccountContains":"String","reference3AccountLike":"String","reference3AccountBetween":["String"],"reference3AccountIn":["String"],"reference3Phone":"String","reference3PhoneStartsWith":"String","reference3PhoneEndsWith":"String","reference3PhoneContains":"String","reference3PhoneLike":"String","reference3PhoneBetween":["String"],"reference3PhoneIn":["String"],"reference3Fax":"String","reference3FaxStartsWith":"String","reference3FaxEndsWith":"String","reference3FaxContains":"String","reference3FaxLike":"String","reference3FaxBetween":["String"],"reference3FaxIn":["String"],"reference3Contact":"String","reference3ContactStartsWith":"String","reference3ContactEndsWith":"String","reference3ContactContains":"String","reference3ContactLike":"String","reference3ContactBetween":["String"],"reference3ContactIn":["String"],"salesRep1Sellable":false,"salesRep2Sellable":false,"salesRep3Sellable":false,"salesRep4Sellable":false,"salesRep5Sellable":false,"billAddress3":"String","billAddress3StartsWith":"String","billAddress3EndsWith":"String","billAddress3Contains":"String","billAddress3Like":"String","billAddress3Between":["String"],"billAddress3In":["String"],"shipAddress3":"String","shipAddress3StartsWith":"String","shipAddress3EndsWith":"String","shipAddress3Contains":"String","shipAddress3Like":"String","shipAddress3Between":["String"],"shipAddress3In":["String"],"createdBy":"String","createdByStartsWith":"String","createdByEndsWith":"String","createdByContains":"String","createdByLike":"String","createdByBetween":["String"],"createdByIn":["String"],"setupCompleted":false,"sendSetupForm":false,"b2BUserId":"String","b2BUserIdStartsWith":"String","b2BUserIdEndsWith":"String","b2BUserIdContains":"String","b2BUserIdLike":"String","b2BUserIdBetween":["String"],"b2BUserIdIn":["String"],"creditChecksExecuted":0,"creditChecksExecutedGreaterThanOrEqualTo":0,"creditChecksExecutedGreaterThan":0,"creditChecksExecutedLessThan":0,"creditChecksExecutedLessThanOrEqualTo":0,"creditChecksExecutedNotEqualTo":0,"creditChecksExecutedBetween":[0],"creditChecksExecutedIn":[0],"creditHold":false,"owner":"String","ownerStartsWith":"String","ownerEndsWith":"String","ownerContains":"String","ownerLike":"String","ownerBetween":["String"],"ownerIn":["String"],"locationType":"String","locationTypeStartsWith":"String","locationTypeEndsWith":"String","locationTypeContains":"String","locationTypeLike":"String","locationTypeBetween":["String"],"locationTypeIn":["String"],"annualSales":"String","annualSalesStartsWith":"String","annualSalesEndsWith":"String","annualSalesContains":"String","annualSalesLike":"String","annualSalesBetween":["String"],"annualSalesIn":["String"],"numOfEmployees":"String","numOfEmployeesStartsWith":"String","numOfEmployeesEndsWith":"String","numOfEmployeesContains":"String","numOfEmployeesLike":"String","numOfEmployeesBetween":["String"],"numOfEmployeesIn":["String"],"yearBusinessOpened":"String","yearBusinessOpenedStartsWith":"String","yearBusinessOpenedEndsWith":"String","yearBusinessOpenedContains":"String","yearBusinessOpenedLike":"String","yearBusinessOpenedBetween":["String"],"yearBusinessOpenedIn":["String"],"daysHoursOfOperation":"String","daysHoursOfOperationStartsWith":"String","daysHoursOfOperationEndsWith":"String","daysHoursOfOperationContains":"String","daysHoursOfOperationLike":"String","daysHoursOfOperationBetween":["String"],"daysHoursOfOperationIn":["String"],"bestTimesToContact":"String","bestTimesToContactStartsWith":"String","bestTimesToContactEndsWith":"String","bestTimesToContactContains":"String","bestTimesToContactLike":"String","bestTimesToContactBetween":["String"],"bestTimesToContactIn":["String"],"buyingMonths":"String","buyingMonthsStartsWith":"String","buyingMonthsEndsWith":"String","buyingMonthsContains":"String","buyingMonthsLike":"String","buyingMonthsBetween":["String"],"buyingMonthsIn":["String"],"sicCode":"String","sicCodeStartsWith":"String","sicCodeEndsWith":"String","sicCodeContains":"String","sicCodeLike":"String","sicCodeBetween":["String"],"sicCodeIn":["String"],"naicsCode":"String","naicsCodeStartsWith":"String","naicsCodeEndsWith":"String","naicsCodeContains":"String","naicsCodeLike":"String","naicsCodeBetween":["String"],"naicsCodeIn":["String"],"creditProfileId":"String","creditProfileIdStartsWith":"String","creditProfileIdEndsWith":"String","creditProfileIdContains":"String","creditProfileIdLike":"String","creditProfileIdBetween":["String"],"creditProfileIdIn":["String"],"bankBranchLocation":"String","bankBranchLocationStartsWith":"String","bankBranchLocationEndsWith":"String","bankBranchLocationContains":"String","bankBranchLocationLike":"String","bankBranchLocationBetween":["String"],"bankBranchLocationIn":["String"],"reference1Address":"String","reference1AddressStartsWith":"String","reference1AddressEndsWith":"String","reference1AddressContains":"String","reference1AddressLike":"String","reference1AddressBetween":["String"],"reference1AddressIn":["String"],"reference1City":"String","reference1CityStartsWith":"String","reference1CityEndsWith":"String","reference1CityContains":"String","reference1CityLike":"String","reference1CityBetween":["String"],"reference1CityIn":["String"],"reference1State":"String","reference1StateStartsWith":"String","reference1StateEndsWith":"String","reference1StateContains":"String","reference1StateLike":"String","reference1StateBetween":["String"],"reference1StateIn":["String"],"reference1Zip":"String","reference1ZipStartsWith":"String","reference1ZipEndsWith":"String","reference1ZipContains":"String","reference1ZipLike":"String","reference1ZipBetween":["String"],"reference1ZipIn":["String"],"reference2Address":"String","reference2AddressStartsWith":"String","reference2AddressEndsWith":"String","reference2AddressContains":"String","reference2AddressLike":"String","reference2AddressBetween":["String"],"reference2AddressIn":["String"],"reference2City":"String","reference2CityStartsWith":"String","reference2CityEndsWith":"String","reference2CityContains":"String","reference2CityLike":"String","reference2CityBetween":["String"],"reference2CityIn":["String"],"reference2State":"String","reference2StateStartsWith":"String","reference2StateEndsWith":"String","reference2StateContains":"String","reference2StateLike":"String","reference2StateBetween":["String"],"reference2StateIn":["String"],"reference2Zip":"String","reference2ZipStartsWith":"String","reference2ZipEndsWith":"String","reference2ZipContains":"String","reference2ZipLike":"String","reference2ZipBetween":["String"],"reference2ZipIn":["String"],"reference3Address":"String","reference3AddressStartsWith":"String","reference3AddressEndsWith":"String","reference3AddressContains":"String","reference3AddressLike":"String","reference3AddressBetween":["String"],"reference3AddressIn":["String"],"reference3City":"String","reference3CityStartsWith":"String","reference3CityEndsWith":"String","reference3CityContains":"String","reference3CityLike":"String","reference3CityBetween":["String"],"reference3CityIn":["String"],"reference3State":"String","reference3StateStartsWith":"String","reference3StateEndsWith":"String","reference3StateContains":"String","reference3StateLike":"String","reference3StateBetween":["String"],"reference3StateIn":["String"],"reference3Zip":"String","reference3ZipStartsWith":"String","reference3ZipEndsWith":"String","reference3ZipContains":"String","reference3ZipLike":"String","reference3ZipBetween":["String"],"reference3ZipIn":["String"],"dnu":false,"restrictionGroup":"String","restrictionGroupStartsWith":"String","restrictionGroupEndsWith":"String","restrictionGroupContains":"String","restrictionGroupLike":"String","restrictionGroupBetween":["String"],"restrictionGroupIn":["String"],"discountPercent1":0,"discountPercent1GreaterThanOrEqualTo":0,"discountPercent1GreaterThan":0,"discountPercent1LessThan":0,"discountPercent1LessThanOrEqualTo":0,"discountPercent1NotEqualTo":0,"discountPercent1Between":[0],"discountPercent1In":[0],"discountPercent2":0,"discountPercent2GreaterThanOrEqualTo":0,"discountPercent2GreaterThan":0,"discountPercent2LessThan":0,"discountPercent2LessThanOrEqualTo":0,"discountPercent2NotEqualTo":0,"discountPercent2Between":[0],"discountPercent2In":[0],"discountPercent3":0,"discountPercent3GreaterThanOrEqualTo":0,"discountPercent3GreaterThan":0,"discountPercent3LessThan":0,"discountPercent3LessThanOrEqualTo":0,"discountPercent3NotEqualTo":0,"discountPercent3Between":[0],"discountPercent3In":[0],"discountPercent4":0,"discountPercent4GreaterThanOrEqualTo":0,"discountPercent4GreaterThan":0,"discountPercent4LessThan":0,"discountPercent4LessThanOrEqualTo":0,"discountPercent4NotEqualTo":0,"discountPercent4Between":[0],"discountPercent4In":[0],"discountPercent5":0,"discountPercent5GreaterThanOrEqualTo":0,"discountPercent5GreaterThan":0,"discountPercent5LessThan":0,"discountPercent5LessThanOrEqualTo":0,"discountPercent5NotEqualTo":0,"discountPercent5Between":[0],"discountPercent5In":[0],"keyAccountGroup":"String","keyAccountGroupStartsWith":"String","keyAccountGroupEndsWith":"String","keyAccountGroupContains":"String","keyAccountGroupLike":"String","keyAccountGroupBetween":["String"],"keyAccountGroupIn":["String"],"custom31STR":"String","custom31STRStartsWith":"String","custom31STREndsWith":"String","custom31STRContains":"String","custom31STRLike":"String","custom31STRBetween":["String"],"custom31STRIn":["String"],"custom32STR":"String","custom32STRStartsWith":"String","custom32STREndsWith":"String","custom32STRContains":"String","custom32STRLike":"String","custom32STRBetween":["String"],"custom32STRIn":["String"],"custom33STR":"String","custom33STRStartsWith":"String","custom33STREndsWith":"String","custom33STRContains":"String","custom33STRLike":"String","custom33STRBetween":["String"],"custom33STRIn":["String"],"custom34STR":"String","custom34STRStartsWith":"String","custom34STREndsWith":"String","custom34STRContains":"String","custom34STRLike":"String","custom34STRBetween":["String"],"custom34STRIn":["String"],"custom35STR":"String","custom35STRStartsWith":"String","custom35STREndsWith":"String","custom35STRContains":"String","custom35STRLike":"String","custom35STRBetween":["String"],"custom35STRIn":["String"],"custom36STR":"String","custom36STRStartsWith":"String","custom36STREndsWith":"String","custom36STRContains":"String","custom36STRLike":"String","custom36STRBetween":["String"],"custom36STRIn":["String"],"custom37STR":"String","custom37STRStartsWith":"String","custom37STREndsWith":"String","custom37STRContains":"String","custom37STRLike":"String","custom37STRBetween":["String"],"custom37STRIn":["String"],"custom38STR":"String","custom38STRStartsWith":"String","custom38STREndsWith":"String","custom38STRContains":"String","custom38STRLike":"String","custom38STRBetween":["String"],"custom38STRIn":["String"],"custom39STR":"String","custom39STRStartsWith":"String","custom39STREndsWith":"String","custom39STRContains":"String","custom39STRLike":"String","custom39STRBetween":["String"],"custom39STRIn":["String"],"custom40STR":"String","custom40STRStartsWith":"String","custom40STREndsWith":"String","custom40STRContains":"String","custom40STRLike":"String","custom40STRBetween":["String"],"custom40STRIn":["String"],"custom41STR":"String","custom41STRStartsWith":"String","custom41STREndsWith":"String","custom41STRContains":"String","custom41STRLike":"String","custom41STRBetween":["String"],"custom41STRIn":["String"],"custom42STR":"String","custom42STRStartsWith":"String","custom42STREndsWith":"String","custom42STRContains":"String","custom42STRLike":"String","custom42STRBetween":["String"],"custom42STRIn":["String"],"custom43STR":"String","custom43STRStartsWith":"String","custom43STREndsWith":"String","custom43STRContains":"String","custom43STRLike":"String","custom43STRBetween":["String"],"custom43STRIn":["String"],"custom44STR":"String","custom44STRStartsWith":"String","custom44STREndsWith":"String","custom44STRContains":"String","custom44STRLike":"String","custom44STRBetween":["String"],"custom44STRIn":["String"],"custom45STR":"String","custom45STRStartsWith":"String","custom45STREndsWith":"String","custom45STRContains":"String","custom45STRLike":"String","custom45STRBetween":["String"],"custom45STRIn":["String"],"defaultWarehouseId":"String","defaultWarehouseIdStartsWith":"String","defaultWarehouseIdEndsWith":"String","defaultWarehouseIdContains":"String","defaultWarehouseIdLike":"String","defaultWarehouseIdBetween":["String"],"defaultWarehouseIdIn":["String"],"status":"String","statusStartsWith":"String","statusEndsWith":"String","statusContains":"String","statusLike":"String","statusBetween":["String"],"statusIn":["String"],"containerPriceList":"String","containerPriceListStartsWith":"String","containerPriceListEndsWith":"String","containerPriceListContains":"String","containerPriceListLike":"String","containerPriceListBetween":["String"],"containerPriceListIn":["String"],"creditSheetNotes":"String","creditSheetNotesStartsWith":"String","creditSheetNotesEndsWith":"String","creditSheetNotesContains":"String","creditSheetNotesLike":"String","creditSheetNotesBetween":["String"],"creditSheetNotesIn":["String"],"discountPoints":0,"discountPointsGreaterThanOrEqualTo":0,"discountPointsGreaterThan":0,"discountPointsLessThan":0,"discountPointsLessThanOrEqualTo":0,"discountPointsNotEqualTo":0,"discountPointsBetween":[0],"discountPointsIn":[0],"customerTags":"String","customerTagsStartsWith":"String","customerTagsEndsWith":"String","customerTagsContains":"String","customerTagsLike":"String","customerTagsBetween":["String"],"customerTagsIn":["String"],"stateTaxExpiration":"0001-01-01T00:00:00.0000000Z","stateTaxExpirationGreaterThanOrEqualTo":"0001-01-01T00:00:00.0000000Z","stateTaxExpirationGreaterThan":"0001-01-01T00:00:00.0000000Z","stateTaxExpirationLessThan":"0001-01-01T00:00:00.0000000Z","stateTaxExpirationLessThanOrEqualTo":"0001-01-01T00:00:00.0000000Z","stateTaxExpirationNotEqualTo":"0001-01-01T00:00:00.0000000Z","stateTaxExpirationBetween":["0001-01-01T00:00:00.0000000Z"],"stateTaxExpirationIn":["0001-01-01T00:00:00.0000000Z"],"blockWebAccess":false,"backOrders":0,"backOrdersGreaterThanOrEqualTo":0,"backOrdersGreaterThan":0,"backOrdersLessThan":0,"backOrdersLessThanOrEqualTo":0,"backOrdersNotEqualTo":0,"backOrdersBetween":[0],"backOrdersIn":[0]}

HTTP/1.1 200 OK
Content-Type: application/vnd.openxmlformats-officedocument.spreadsheetml.sheet
Content-Length: length

[{"id":"String","companyName":"String","accountType":"String","billAddress":"String","billAddress2":"String","billCity":"String","billState":"String","billZipcode":"String","billCountry":"String","phone":"String","shipName":"String","shipAddress":"String","shipAddress2":"String","shipCity":"String","shipState":"String","shipZipcode":"String","shipCountry":"String","shipPhone":"String","email":"String","website":"String","fax":"String","contact":"String","creditCardType":"String","creditCardNumber":"String","creditCardExpiration":"String","creditCardAVS":"String","creditCardName":"String","creditCardAddress":"String","creditCardAddress2":"String","creditCardCity":"String","creditCardState":"String","creditCardZipcode":"String","creditCardCountry":"String","shipVia":"String","terms":"String","salesRep":"String","notes":"String","keyAccount":false,"creditLimit":0,"dbNum":"String","bank":"String","bankAccountNum":"String","bankAccountType":"String","federalTaxId":"String","stateTaxId":"String","reference1":"String","reference2":"String","reference3":"String","reference4":"String","reference5":"String","faxOrder":false,"emailOrder":false,"custom1STR":"String","custom2STR":"String","custom3STR":"String","custom4STR":"String","custom5STR":"String","custom6STR":"String","custom7STR":"String","custom8STR":"String","custom9STR":"String","custom10STR":"String","custom11STR":"String","custom12STR":"String","custom13STR":"String","custom14STR":"String","custom15STR":"String","newCustomer":false,"modified":false,"discount":0,"lineLevel":false,"orderLevel":false,"pricingLevel":"String","type":"String","created":"0001-01-01T00:00:00.0000000Z","salesRep2":"String","lastContact":"0001-01-01T00:00:00.0000000Z","lastOrder":"0001-01-01T00:00:00.0000000Z","erpNotes":"String","curBalance":0,"past30Days":0,"past60Days":0,"past90Days":0,"past1Days":0,"source":"String","territoryId":"String","regionId":"String","originalCustomerId":"String","exported":false,"currencyCode":"String","cyForecast":0,"nyForecast":0,"infoReviewed":"0001-01-01T00:00:00.0000000Z","_InfoReviewed":false,"priceList":"String","ranking":"String","hash":"String","salesRep3":"String","salesRep4":"String","salesRep5":"String","residential":false,"poRequired":false,"custom16STR":"String","custom17STR":"String","custom18STR":"String","custom19STR":"String","custom20STR":"String","custom21STR":"String","custom22STR":"String","custom23STR":"String","custom24STR":"String","custom25STR":"String","custom26STR":"String","custom27STR":"String","custom28STR":"String","custom29STR":"String","custom30STR":"String","creditAvailable":0,"totalBalance":0,"futureBalance":0,"bankAddress":"String","bankCity":"String","bankState":"String","bankZipcode":"String","bankPhone":"String","bankFax":"String","bankContact":"String","reference1Account":"String","reference1Phone":"String","reference1Fax":"String","reference1Contact":"String","reference2Account":"String","reference2Phone":"String","reference2Fax":"String","reference2Contact":"String","reference3Account":"String","reference3Phone":"String","reference3Fax":"String","reference3Contact":"String","salesRep1Sellable":false,"salesRep2Sellable":false,"salesRep3Sellable":false,"salesRep4Sellable":false,"salesRep5Sellable":false,"billAddress3":"String","shipAddress3":"String","createdBy":"String","setupCompleted":false,"sendSetupForm":false,"b2BUserId":"String","creditChecksExecuted":0,"creditHold":false,"owner":"String","locationType":"String","annualSales":"String","numOfEmployees":"String","yearBusinessOpened":"String","daysHoursOfOperation":"String","bestTimesToContact":"String","buyingMonths":"String","sicCode":"String","naicsCode":"String","creditProfileId":"String","bankBranchLocation":"String","reference1Address":"String","reference1City":"String","reference1State":"String","reference1Zip":"String","reference2Address":"String","reference2City":"String","reference2State":"String","reference2Zip":"String","reference3Address":"String","reference3City":"String","reference3State":"String","reference3Zip":"String","dnu":false,"restrictionGroup":"String","discountPercent1":0,"discountPercent2":0,"discountPercent3":0,"discountPercent4":0,"discountPercent5":0,"keyAccountGroup":"String","custom31STR":"String","custom32STR":"String","custom33STR":"String","custom34STR":"String","custom35STR":"String","custom36STR":"String","custom37STR":"String","custom38STR":"String","custom39STR":"String","custom40STR":"String","custom41STR":"String","custom42STR":"String","custom43STR":"String","custom44STR":"String","custom45STR":"String","defaultWarehouseId":"String","status":"String","containerPriceList":"String","creditSheetNotes":"String","discountPoints":0,"customerTags":"String","stateTaxExpiration":"0001-01-01T00:00:00.0000000Z","blockWebAccess":false,"backOrders":0}]