EMUN1 ASP.NET

QuerySalesOrderRDB

**Requires Authentication**
Required role:	Administrator

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

**QuerySalesOrderRDB** 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
PONumber	query	string	No
PONumberStartsWith	query	string	No
PONumberEndsWith	query	string	No
PONumberContains	query	string	No
PONumberLike	query	string	No
PONumberBetween	query	string[]	No
PONumberIn	query	string[]	No
OrderPrefix	query	string	No
OrderPrefixStartsWith	query	string	No
OrderPrefixEndsWith	query	string	No
OrderPrefixContains	query	string	No
OrderPrefixLike	query	string	No
OrderPrefixBetween	query	string[]	No
OrderPrefixIn	query	string[]	No
CustomerId	query	string	No
CustomerIdStartsWith	query	string	No
CustomerIdEndsWith	query	string	No
CustomerIdContains	query	string	No
CustomerIdLike	query	string	No
CustomerIdBetween	query	string[]	No
CustomerIdIn	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
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
BillPhone	query	string	No
BillPhoneStartsWith	query	string	No
BillPhoneEndsWith	query	string	No
BillPhoneContains	query	string	No
BillPhoneLike	query	string	No
BillPhoneBetween	query	string[]	No
BillPhoneIn	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
OrderDate	query	DateTime?	No
OrderDateGreaterThanOrEqualTo	query	DateTime?	No
OrderDateGreaterThan	query	DateTime?	No
OrderDateLessThan	query	DateTime?	No
OrderDateLessThanOrEqualTo	query	DateTime?	No
OrderDateNotEqualTo	query	DateTime?	No
OrderDateBetween	query	DateTime[]	No
OrderDateIn	query	DateTime[]	No
ShipDate	query	DateTime?	No
ShipDateGreaterThanOrEqualTo	query	DateTime?	No
ShipDateGreaterThan	query	DateTime?	No
ShipDateLessThan	query	DateTime?	No
ShipDateLessThanOrEqualTo	query	DateTime?	No
ShipDateNotEqualTo	query	DateTime?	No
ShipDateBetween	query	DateTime[]	No
ShipDateIn	query	DateTime[]	No
Buyer	query	string	No
BuyerStartsWith	query	string	No
BuyerEndsWith	query	string	No
BuyerContains	query	string	No
BuyerLike	query	string	No
BuyerBetween	query	string[]	No
BuyerIn	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
WritingRep	query	string	No
WritingRepStartsWith	query	string	No
WritingRepEndsWith	query	string	No
WritingRepContains	query	string	No
WritingRepLike	query	string	No
WritingRepBetween	query	string[]	No
WritingRepIn	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
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
CancelDate	query	DateTime?	No
CancelDateGreaterThanOrEqualTo	query	DateTime?	No
CancelDateGreaterThan	query	DateTime?	No
CancelDateLessThan	query	DateTime?	No
CancelDateLessThanOrEqualTo	query	DateTime?	No
CancelDateNotEqualTo	query	DateTime?	No
CancelDateBetween	query	DateTime[]	No
CancelDateIn	query	DateTime[]	No
OrderTotal	query	double?	No
OrderTotalGreaterThanOrEqualTo	query	double?	No
OrderTotalGreaterThan	query	double?	No
OrderTotalLessThan	query	double?	No
OrderTotalLessThanOrEqualTo	query	double?	No
OrderTotalNotEqualTo	query	double?	No
OrderTotalBetween	query	double[]	No
OrderTotalIn	query	double[]	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
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
OrderStatus	query	string	No
OrderStatusStartsWith	query	string	No
OrderStatusEndsWith	query	string	No
OrderStatusContains	query	string	No
OrderStatusLike	query	string	No
OrderStatusBetween	query	string[]	No
OrderStatusIn	query	string[]	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
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
ManufacturerId	query	string	No
ManufacturerIdStartsWith	query	string	No
ManufacturerIdEndsWith	query	string	No
ManufacturerIdContains	query	string	No
ManufacturerIdLike	query	string	No
ManufacturerIdBetween	query	string[]	No
ManufacturerIdIn	query	string[]	No
CommPercentRep	query	double?	No
CommPercentRepGreaterThanOrEqualTo	query	double?	No
CommPercentRepGreaterThan	query	double?	No
CommPercentRepLessThan	query	double?	No
CommPercentRepLessThanOrEqualTo	query	double?	No
CommPercentRepNotEqualTo	query	double?	No
CommPercentRepBetween	query	double[]	No
CommPercentRepIn	query	double[]	No
CommPercentMfg	query	double?	No
CommPercentMfgGreaterThanOrEqualTo	query	double?	No
CommPercentMfgGreaterThan	query	double?	No
CommPercentMfgLessThan	query	double?	No
CommPercentMfgLessThanOrEqualTo	query	double?	No
CommPercentMfgNotEqualTo	query	double?	No
CommPercentMfgBetween	query	double[]	No
CommPercentMfgIn	query	double[]	No
Balance	query	double?	No
BalanceGreaterThanOrEqualTo	query	double?	No
BalanceGreaterThan	query	double?	No
BalanceLessThan	query	double?	No
BalanceLessThanOrEqualTo	query	double?	No
BalanceNotEqualTo	query	double?	No
BalanceBetween	query	double[]	No
BalanceIn	query	double[]	No
MfgEmail	query	bool?	No
MfgFax	query	bool?	No
CustEmail	query	bool?	No
CustFax	query	bool?	No
RepEmail	query	bool?	No
RepFax	query	bool?	No
_CustEmail	query	string	No
_CustEmailStartsWith	query	string	No
_CustEmailEndsWith	query	string	No
_CustEmailContains	query	string	No
_CustEmailLike	query	string	No
_CustEmailBetween	query	string[]	No
_CustEmailIn	query	string[]	No
_CustFax	query	string	No
_CustFaxStartsWith	query	string	No
_CustFaxEndsWith	query	string	No
_CustFaxContains	query	string	No
_CustFaxLike	query	string	No
_CustFaxBetween	query	string[]	No
_CustFaxIn	query	string[]	No
Modified	query	bool?	No
ModificationReason	query	string	No
ModificationReasonStartsWith	query	string	No
ModificationReasonEndsWith	query	string	No
ModificationReasonContains	query	string	No
ModificationReasonLike	query	string	No
ModificationReasonBetween	query	string[]	No
ModificationReasonIn	query	string[]	No
SendCreditSheet	query	bool?	No
Uploaded	query	bool?	No
Active	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
imgSignature	query	byte[]	No
ShipId	query	string	No
ShipIdStartsWith	query	string	No
ShipIdEndsWith	query	string	No
ShipIdContains	query	string	No
ShipIdLike	query	string	No
ShipIdBetween	query	string[]	No
ShipIdIn	query	string[]	No
TransactionType	query	string	No
TransactionTypeStartsWith	query	string	No
TransactionTypeEndsWith	query	string	No
TransactionTypeContains	query	string	No
TransactionTypeLike	query	string	No
TransactionTypeBetween	query	string[]	No
TransactionTypeIn	query	string[]	No
Revision	query	int?	No
RevisionGreaterThanOrEqualTo	query	int?	No
RevisionGreaterThan	query	int?	No
RevisionLessThan	query	int?	No
RevisionLessThanOrEqualTo	query	int?	No
RevisionNotEqualTo	query	int?	No
RevisionBetween	query	int[]	No
RevisionIn	query	int[]	No
ReasonCode	query	string	No
ReasonCodeStartsWith	query	string	No
ReasonCodeEndsWith	query	string	No
ReasonCodeContains	query	string	No
ReasonCodeLike	query	string	No
ReasonCodeBetween	query	string[]	No
ReasonCodeIn	query	string[]	No
Exported	query	bool?	No
SessionId	query	string	No
SessionIdStartsWith	query	string	No
SessionIdEndsWith	query	string	No
SessionIdContains	query	string	No
SessionIdLike	query	string	No
SessionIdBetween	query	string[]	No
SessionIdIn	query	string[]	No
ShowCode	query	string	No
ShowCodeStartsWith	query	string	No
ShowCodeEndsWith	query	string	No
ShowCodeContains	query	string	No
ShowCodeLike	query	string	No
ShowCodeBetween	query	string[]	No
ShowCodeIn	query	string[]	No
ReviewReason	query	string	No
ReviewReasonStartsWith	query	string	No
ReviewReasonEndsWith	query	string	No
ReviewReasonContains	query	string	No
ReviewReasonLike	query	string	No
ReviewReasonBetween	query	string[]	No
ReviewReasonIn	query	string[]	No
ReviewedBy	query	string	No
ReviewedByStartsWith	query	string	No
ReviewedByEndsWith	query	string	No
ReviewedByContains	query	string	No
ReviewedByLike	query	string	No
ReviewedByBetween	query	string[]	No
ReviewedByIn	query	string[]	No
ExpectedToClear	query	DateTime?	No
ExpectedToClearGreaterThanOrEqualTo	query	DateTime?	No
ExpectedToClearGreaterThan	query	DateTime?	No
ExpectedToClearLessThan	query	DateTime?	No
ExpectedToClearLessThanOrEqualTo	query	DateTime?	No
ExpectedToClearNotEqualTo	query	DateTime?	No
ExpectedToClearBetween	query	DateTime[]	No
ExpectedToClearIn	query	DateTime[]	No
ReviewLog	query	string	No
ReviewLogStartsWith	query	string	No
ReviewLogEndsWith	query	string	No
ReviewLogContains	query	string	No
ReviewLogLike	query	string	No
ReviewLogBetween	query	string[]	No
ReviewLogIn	query	string[]	No
SoldToId	query	string	No
SoldToIdStartsWith	query	string	No
SoldToIdEndsWith	query	string	No
SoldToIdContains	query	string	No
SoldToIdLike	query	string	No
SoldToIdBetween	query	string[]	No
SoldToIdIn	query	string[]	No
SoldName	query	string	No
SoldNameStartsWith	query	string	No
SoldNameEndsWith	query	string	No
SoldNameContains	query	string	No
SoldNameLike	query	string	No
SoldNameBetween	query	string[]	No
SoldNameIn	query	string[]	No
SoldAddress	query	string	No
SoldAddressStartsWith	query	string	No
SoldAddressEndsWith	query	string	No
SoldAddressContains	query	string	No
SoldAddressLike	query	string	No
SoldAddressBetween	query	string[]	No
SoldAddressIn	query	string[]	No
SoldAddress2	query	string	No
SoldAddress2StartsWith	query	string	No
SoldAddress2EndsWith	query	string	No
SoldAddress2Contains	query	string	No
SoldAddress2Like	query	string	No
SoldAddress2Between	query	string[]	No
SoldAddress2In	query	string[]	No
SoldCity	query	string	No
SoldCityStartsWith	query	string	No
SoldCityEndsWith	query	string	No
SoldCityContains	query	string	No
SoldCityLike	query	string	No
SoldCityBetween	query	string[]	No
SoldCityIn	query	string[]	No
SoldState	query	string	No
SoldStateStartsWith	query	string	No
SoldStateEndsWith	query	string	No
SoldStateContains	query	string	No
SoldStateLike	query	string	No
SoldStateBetween	query	string[]	No
SoldStateIn	query	string[]	No
SoldZipcode	query	string	No
SoldZipcodeStartsWith	query	string	No
SoldZipcodeEndsWith	query	string	No
SoldZipcodeContains	query	string	No
SoldZipcodeLike	query	string	No
SoldZipcodeBetween	query	string[]	No
SoldZipcodeIn	query	string[]	No
SoldCountry	query	string	No
SoldCountryStartsWith	query	string	No
SoldCountryEndsWith	query	string	No
SoldCountryContains	query	string	No
SoldCountryLike	query	string	No
SoldCountryBetween	query	string[]	No
SoldCountryIn	query	string[]	No
SoldPhone	query	string	No
SoldPhoneStartsWith	query	string	No
SoldPhoneEndsWith	query	string	No
SoldPhoneContains	query	string	No
SoldPhoneLike	query	string	No
SoldPhoneBetween	query	string[]	No
SoldPhoneIn	query	string[]	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
TimeStamp	query	DateTime?	No
TimeStampGreaterThanOrEqualTo	query	DateTime?	No
TimeStampGreaterThan	query	DateTime?	No
TimeStampLessThan	query	DateTime?	No
TimeStampLessThanOrEqualTo	query	DateTime?	No
TimeStampNotEqualTo	query	DateTime?	No
TimeStampBetween	query	DateTime[]	No
TimeStampIn	query	DateTime[]	No
DropShip	query	bool?	No
ERPStatus	query	string	No
ERPStatusStartsWith	query	string	No
ERPStatusEndsWith	query	string	No
ERPStatusContains	query	string	No
ERPStatusLike	query	string	No
ERPStatusBetween	query	string[]	No
ERPStatusIn	query	string[]	No
OriginalOrderNumber	query	string	No
OriginalOrderNumberStartsWith	query	string	No
OriginalOrderNumberEndsWith	query	string	No
OriginalOrderNumberContains	query	string	No
OriginalOrderNumberLike	query	string	No
OriginalOrderNumberBetween	query	string[]	No
OriginalOrderNumberIn	query	string[]	No
ShippedAmount	query	double?	No
ShippedAmountGreaterThanOrEqualTo	query	double?	No
ShippedAmountGreaterThan	query	double?	No
ShippedAmountLessThan	query	double?	No
ShippedAmountLessThanOrEqualTo	query	double?	No
ShippedAmountNotEqualTo	query	double?	No
ShippedAmountBetween	query	double[]	No
ShippedAmountIn	query	double[]	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
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
PromoTransId	query	string	No
PromoTransIdStartsWith	query	string	No
PromoTransIdEndsWith	query	string	No
PromoTransIdContains	query	string	No
PromoTransIdLike	query	string	No
PromoTransIdBetween	query	string[]	No
PromoTransIdIn	query	string[]	No
SplitOrder	query	bool?	No
RepOrderNumber	query	string	No
RepOrderNumberStartsWith	query	string	No
RepOrderNumberEndsWith	query	string	No
RepOrderNumberContains	query	string	No
RepOrderNumberLike	query	string	No
RepOrderNumberBetween	query	string[]	No
RepOrderNumberIn	query	string[]	No
CorpOrderNumber	query	string	No
CorpOrderNumberStartsWith	query	string	No
CorpOrderNumberEndsWith	query	string	No
CorpOrderNumberContains	query	string	No
CorpOrderNumberLike	query	string	No
CorpOrderNumberBetween	query	string[]	No
CorpOrderNumberIn	query	string[]	No
CCAuthorized	query	bool?	No
TerritoryRepOverride	query	bool?	No
CheckNumber	query	string	No
CheckNumberStartsWith	query	string	No
CheckNumberEndsWith	query	string	No
CheckNumberContains	query	string	No
CheckNumberLike	query	string	No
CheckNumberBetween	query	string[]	No
CheckNumberIn	query	string[]	No
CheckAmount	query	double?	No
CheckAmountGreaterThanOrEqualTo	query	double?	No
CheckAmountGreaterThan	query	double?	No
CheckAmountLessThan	query	double?	No
CheckAmountLessThanOrEqualTo	query	double?	No
CheckAmountNotEqualTo	query	double?	No
CheckAmountBetween	query	double[]	No
CheckAmountIn	query	double[]	No
CancelDatesOK	query	bool?	No
Company	query	string	No
CompanyStartsWith	query	string	No
CompanyEndsWith	query	string	No
CompanyContains	query	string	No
CompanyLike	query	string	No
CompanyBetween	query	string[]	No
CompanyIn	query	string[]	No
ShipComplete	query	bool?	No
ShippingNotes	query	string	No
ShippingNotesStartsWith	query	string	No
ShippingNotesEndsWith	query	string	No
ShippingNotesContains	query	string	No
ShippingNotesLike	query	string	No
ShippingNotesBetween	query	string[]	No
ShippingNotesIn	query	string[]	No
DeliveryNotes	query	string	No
DeliveryNotesStartsWith	query	string	No
DeliveryNotesEndsWith	query	string	No
DeliveryNotesContains	query	string	No
DeliveryNotesLike	query	string	No
DeliveryNotesBetween	query	string[]	No
DeliveryNotesIn	query	string[]	No
InternalNotes	query	string	No
InternalNotesStartsWith	query	string	No
InternalNotesEndsWith	query	string	No
InternalNotesContains	query	string	No
InternalNotesLike	query	string	No
InternalNotesBetween	query	string[]	No
InternalNotesIn	query	string[]	No
ShippingNotes2	query	string	No
ShippingNotes2StartsWith	query	string	No
ShippingNotes2EndsWith	query	string	No
ShippingNotes2Contains	query	string	No
ShippingNotes2Like	query	string	No
ShippingNotes2Between	query	string[]	No
ShippingNotes2In	query	string[]	No
VendorNotes	query	string	No
VendorNotesStartsWith	query	string	No
VendorNotesEndsWith	query	string	No
VendorNotesContains	query	string	No
VendorNotesLike	query	string	No
VendorNotesBetween	query	string[]	No
VendorNotesIn	query	string[]	No
RepGroup	query	string	No
RepGroupStartsWith	query	string	No
RepGroupEndsWith	query	string	No
RepGroupContains	query	string	No
RepGroupLike	query	string	No
RepGroupBetween	query	string[]	No
RepGroupIn	query	string[]	No
CurrentRep	query	string	No
CurrentRepStartsWith	query	string	No
CurrentRepEndsWith	query	string	No
CurrentRepContains	query	string	No
CurrentRepLike	query	string	No
CurrentRepBetween	query	string[]	No
CurrentRepIn	query	string[]	No
GeneratedFrom	query	string	No
GeneratedFromStartsWith	query	string	No
GeneratedFromEndsWith	query	string	No
GeneratedFromContains	query	string	No
GeneratedFromLike	query	string	No
GeneratedFromBetween	query	string[]	No
GeneratedFromIn	query	string[]	No
CommissionRep	query	string	No
CommissionRepStartsWith	query	string	No
CommissionRepEndsWith	query	string	No
CommissionRepContains	query	string	No
CommissionRepLike	query	string	No
CommissionRepBetween	query	string[]	No
CommissionRepIn	query	string[]	No
WarehouseId	query	string	No
WarehouseIdStartsWith	query	string	No
WarehouseIdEndsWith	query	string	No
WarehouseIdContains	query	string	No
WarehouseIdLike	query	string	No
WarehouseIdBetween	query	string[]	No
WarehouseIdIn	query	string[]	No
AllowBackorders	query	bool?	No
FiscalYear	query	string	No
FiscalYearStartsWith	query	string	No
FiscalYearEndsWith	query	string	No
FiscalYearContains	query	string	No
FiscalYearLike	query	string	No
FiscalYearBetween	query	string[]	No
FiscalYearIn	query	string[]	No
FiscalMonth	query	string	No
FiscalMonthStartsWith	query	string	No
FiscalMonthEndsWith	query	string	No
FiscalMonthContains	query	string	No
FiscalMonthLike	query	string	No
FiscalMonthBetween	query	string[]	No
FiscalMonthIn	query	string[]	No
OriginalOrderTotal	query	double?	No
OriginalOrderTotalGreaterThanOrEqualTo	query	double?	No
OriginalOrderTotalGreaterThan	query	double?	No
OriginalOrderTotalLessThan	query	double?	No
OriginalOrderTotalLessThanOrEqualTo	query	double?	No
OriginalOrderTotalNotEqualTo	query	double?	No
OriginalOrderTotalBetween	query	double[]	No
OriginalOrderTotalIn	query	double[]	No
ModifiedExportedOrderNotes	query	string	No
ModifiedExportedOrderNotesStartsWith	query	string	No
ModifiedExportedOrderNotesEndsWith	query	string	No
ModifiedExportedOrderNotesContains	query	string	No
ModifiedExportedOrderNotesLike	query	string	No
ModifiedExportedOrderNotesBetween	query	string[]	No
ModifiedExportedOrderNotesIn	query	string[]	No
ContainerId	query	string	No
ContainerIdStartsWith	query	string	No
ContainerIdEndsWith	query	string	No
ContainerIdContains	query	string	No
ContainerIdLike	query	string	No
ContainerIdBetween	query	string[]	No
ContainerIdIn	query	string[]	No
TagFor	query	string	No
TagForStartsWith	query	string	No
TagForEndsWith	query	string	No
TagForContains	query	string	No
TagForLike	query	string	No
TagForBetween	query	string[]	No
TagForIn	query	string[]	No
CorpUploaded	query	bool?	No
CorpModified	query	bool?	No
ClientVersion	query	string	No
ClientVersionStartsWith	query	string	No
ClientVersionEndsWith	query	string	No
ClientVersionContains	query	string	No
ClientVersionLike	query	string	No
ClientVersionBetween	query	string[]	No
ClientVersionIn	query	string[]	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
SendNewAcct	query	bool?	No
CreditCardLastFour	query	string	No
CreditCardLastFourStartsWith	query	string	No
CreditCardLastFourEndsWith	query	string	No
CreditCardLastFourContains	query	string	No
CreditCardLastFourLike	query	string	No
CreditCardLastFourBetween	query	string[]	No
CreditCardLastFourIn	query	string[]	No
CreditCardToken	query	string	No
CreditCardTokenStartsWith	query	string	No
CreditCardTokenEndsWith	query	string	No
CreditCardTokenContains	query	string	No
CreditCardTokenLike	query	string	No
CreditCardTokenBetween	query	string[]	No
CreditCardTokenIn	query	string[]	No
CreditCardTransId	query	string	No
CreditCardTransIdStartsWith	query	string	No
CreditCardTransIdEndsWith	query	string	No
CreditCardTransIdContains	query	string	No
CreditCardTransIdLike	query	string	No
CreditCardTransIdBetween	query	string[]	No
CreditCardTransIdIn	query	string[]	No
CreditCardId	query	string	No
CreditCardIdStartsWith	query	string	No
CreditCardIdEndsWith	query	string	No
CreditCardIdContains	query	string	No
CreditCardIdLike	query	string	No
CreditCardIdBetween	query	string[]	No
CreditCardIdIn	query	string[]	No
Location	query	string	No
LocationStartsWith	query	string	No
LocationEndsWith	query	string	No
LocationContains	query	string	No
LocationLike	query	string	No
LocationBetween	query	string[]	No
LocationIn	query	string[]	No
TokenizationCode	query	string	No
TokenizationCodeStartsWith	query	string	No
TokenizationCodeEndsWith	query	string	No
TokenizationCodeContains	query	string	No
TokenizationCodeLike	query	string	No
TokenizationCodeBetween	query	string[]	No
TokenizationCodeIn	query	string[]	No
TokenizationProvider	query	string	No
TokenizationProviderStartsWith	query	string	No
TokenizationProviderEndsWith	query	string	No
TokenizationProviderContains	query	string	No
TokenizationProviderLike	query	string	No
TokenizationProviderBetween	query	string[]	No
TokenizationProviderIn	query	string[]	No
ShipEmail	query	string	No
ShipEmailStartsWith	query	string	No
ShipEmailEndsWith	query	string	No
ShipEmailContains	query	string	No
ShipEmailLike	query	string	No
ShipEmailBetween	query	string[]	No
ShipEmailIn	query	string[]	No

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

HTTP + JSV

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

POST /service/QuerySalesOrderRDB HTTP/1.1 
Host: www.bernhardt.com 
Accept: text/jsv
Content-Type: text/jsv
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
	],
	poNumber: String,
	poNumberStartsWith: String,
	poNumberEndsWith: String,
	poNumberContains: String,
	poNumberLike: String,
	poNumberBetween: 
	[
		String
	],
	poNumberIn: 
	[
		String
	],
	orderPrefix: String,
	orderPrefixStartsWith: String,
	orderPrefixEndsWith: String,
	orderPrefixContains: String,
	orderPrefixLike: String,
	orderPrefixBetween: 
	[
		String
	],
	orderPrefixIn: 
	[
		String
	],
	customerId: String,
	customerIdStartsWith: String,
	customerIdEndsWith: String,
	customerIdContains: String,
	customerIdLike: String,
	customerIdBetween: 
	[
		String
	],
	customerIdIn: 
	[
		String
	],
	companyName: String,
	companyNameStartsWith: String,
	companyNameEndsWith: String,
	companyNameContains: String,
	companyNameLike: String,
	companyNameBetween: 
	[
		String
	],
	companyNameIn: 
	[
		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
	],
	billPhone: String,
	billPhoneStartsWith: String,
	billPhoneEndsWith: String,
	billPhoneContains: String,
	billPhoneLike: String,
	billPhoneBetween: 
	[
		String
	],
	billPhoneIn: 
	[
		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
	],
	orderDate: 0001-01-01,
	orderDateGreaterThanOrEqualTo: 0001-01-01,
	orderDateGreaterThan: 0001-01-01,
	orderDateLessThan: 0001-01-01,
	orderDateLessThanOrEqualTo: 0001-01-01,
	orderDateNotEqualTo: 0001-01-01,
	orderDateBetween: 
	[
		0001-01-01
	],
	orderDateIn: 
	[
		0001-01-01
	],
	shipDate: 0001-01-01,
	shipDateGreaterThanOrEqualTo: 0001-01-01,
	shipDateGreaterThan: 0001-01-01,
	shipDateLessThan: 0001-01-01,
	shipDateLessThanOrEqualTo: 0001-01-01,
	shipDateNotEqualTo: 0001-01-01,
	shipDateBetween: 
	[
		0001-01-01
	],
	shipDateIn: 
	[
		0001-01-01
	],
	buyer: String,
	buyerStartsWith: String,
	buyerEndsWith: String,
	buyerContains: String,
	buyerLike: String,
	buyerBetween: 
	[
		String
	],
	buyerIn: 
	[
		String
	],
	salesRep: String,
	salesRepStartsWith: String,
	salesRepEndsWith: String,
	salesRepContains: String,
	salesRepLike: String,
	salesRepBetween: 
	[
		String
	],
	salesRepIn: 
	[
		String
	],
	writingRep: String,
	writingRepStartsWith: String,
	writingRepEndsWith: String,
	writingRepContains: String,
	writingRepLike: String,
	writingRepBetween: 
	[
		String
	],
	writingRepIn: 
	[
		String
	],
	terms: String,
	termsStartsWith: String,
	termsEndsWith: String,
	termsContains: String,
	termsLike: String,
	termsBetween: 
	[
		String
	],
	termsIn: 
	[
		String
	],
	shipVia: String,
	shipViaStartsWith: String,
	shipViaEndsWith: String,
	shipViaContains: String,
	shipViaLike: String,
	shipViaBetween: 
	[
		String
	],
	shipViaIn: 
	[
		String
	],
	cancelDate: 0001-01-01,
	cancelDateGreaterThanOrEqualTo: 0001-01-01,
	cancelDateGreaterThan: 0001-01-01,
	cancelDateLessThan: 0001-01-01,
	cancelDateLessThanOrEqualTo: 0001-01-01,
	cancelDateNotEqualTo: 0001-01-01,
	cancelDateBetween: 
	[
		0001-01-01
	],
	cancelDateIn: 
	[
		0001-01-01
	],
	orderTotal: 0,
	orderTotalGreaterThanOrEqualTo: 0,
	orderTotalGreaterThan: 0,
	orderTotalLessThan: 0,
	orderTotalLessThanOrEqualTo: 0,
	orderTotalNotEqualTo: 0,
	orderTotalBetween: 
	[
		0
	],
	orderTotalIn: 
	[
		0
	],
	notes: String,
	notesStartsWith: String,
	notesEndsWith: String,
	notesContains: String,
	notesLike: String,
	notesBetween: 
	[
		String
	],
	notesIn: 
	[
		String
	],
	created: 0001-01-01,
	createdGreaterThanOrEqualTo: 0001-01-01,
	createdGreaterThan: 0001-01-01,
	createdLessThan: 0001-01-01,
	createdLessThanOrEqualTo: 0001-01-01,
	createdNotEqualTo: 0001-01-01,
	createdBetween: 
	[
		0001-01-01
	],
	createdIn: 
	[
		0001-01-01
	],
	orderStatus: String,
	orderStatusStartsWith: String,
	orderStatusEndsWith: String,
	orderStatusContains: String,
	orderStatusLike: String,
	orderStatusBetween: 
	[
		String
	],
	orderStatusIn: 
	[
		String
	],
	source: String,
	sourceStartsWith: String,
	sourceEndsWith: String,
	sourceContains: String,
	sourceLike: String,
	sourceBetween: 
	[
		String
	],
	sourceIn: 
	[
		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
	],
	manufacturerId: String,
	manufacturerIdStartsWith: String,
	manufacturerIdEndsWith: String,
	manufacturerIdContains: String,
	manufacturerIdLike: String,
	manufacturerIdBetween: 
	[
		String
	],
	manufacturerIdIn: 
	[
		String
	],
	commPercentRep: 0,
	commPercentRepGreaterThanOrEqualTo: 0,
	commPercentRepGreaterThan: 0,
	commPercentRepLessThan: 0,
	commPercentRepLessThanOrEqualTo: 0,
	commPercentRepNotEqualTo: 0,
	commPercentRepBetween: 
	[
		0
	],
	commPercentRepIn: 
	[
		0
	],
	commPercentMfg: 0,
	commPercentMfgGreaterThanOrEqualTo: 0,
	commPercentMfgGreaterThan: 0,
	commPercentMfgLessThan: 0,
	commPercentMfgLessThanOrEqualTo: 0,
	commPercentMfgNotEqualTo: 0,
	commPercentMfgBetween: 
	[
		0
	],
	commPercentMfgIn: 
	[
		0
	],
	balance: 0,
	balanceGreaterThanOrEqualTo: 0,
	balanceGreaterThan: 0,
	balanceLessThan: 0,
	balanceLessThanOrEqualTo: 0,
	balanceNotEqualTo: 0,
	balanceBetween: 
	[
		0
	],
	balanceIn: 
	[
		0
	],
	mfgEmail: False,
	mfgFax: False,
	custEmail: False,
	custFax: False,
	repEmail: False,
	repFax: False,
	_CustEmail: String,
	_CustEmailStartsWith: String,
	_CustEmailEndsWith: String,
	_CustEmailContains: String,
	_CustEmailLike: String,
	_CustEmailBetween: 
	[
		String
	],
	_CustEmailIn: 
	[
		String
	],
	_CustFax: String,
	_CustFaxStartsWith: String,
	_CustFaxEndsWith: String,
	_CustFaxContains: String,
	_CustFaxLike: String,
	_CustFaxBetween: 
	[
		String
	],
	_CustFaxIn: 
	[
		String
	],
	modified: False,
	modificationReason: String,
	modificationReasonStartsWith: String,
	modificationReasonEndsWith: String,
	modificationReasonContains: String,
	modificationReasonLike: String,
	modificationReasonBetween: 
	[
		String
	],
	modificationReasonIn: 
	[
		String
	],
	sendCreditSheet: False,
	uploaded: False,
	active: 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
	],
	imgSignature: AA==,
	shipId: String,
	shipIdStartsWith: String,
	shipIdEndsWith: String,
	shipIdContains: String,
	shipIdLike: String,
	shipIdBetween: 
	[
		String
	],
	shipIdIn: 
	[
		String
	],
	transactionType: String,
	transactionTypeStartsWith: String,
	transactionTypeEndsWith: String,
	transactionTypeContains: String,
	transactionTypeLike: String,
	transactionTypeBetween: 
	[
		String
	],
	transactionTypeIn: 
	[
		String
	],
	revision: 0,
	revisionGreaterThanOrEqualTo: 0,
	revisionGreaterThan: 0,
	revisionLessThan: 0,
	revisionLessThanOrEqualTo: 0,
	revisionNotEqualTo: 0,
	revisionBetween: 
	[
		0
	],
	revisionIn: 
	[
		0
	],
	reasonCode: String,
	reasonCodeStartsWith: String,
	reasonCodeEndsWith: String,
	reasonCodeContains: String,
	reasonCodeLike: String,
	reasonCodeBetween: 
	[
		String
	],
	reasonCodeIn: 
	[
		String
	],
	exported: False,
	sessionId: String,
	sessionIdStartsWith: String,
	sessionIdEndsWith: String,
	sessionIdContains: String,
	sessionIdLike: String,
	sessionIdBetween: 
	[
		String
	],
	sessionIdIn: 
	[
		String
	],
	showCode: String,
	showCodeStartsWith: String,
	showCodeEndsWith: String,
	showCodeContains: String,
	showCodeLike: String,
	showCodeBetween: 
	[
		String
	],
	showCodeIn: 
	[
		String
	],
	reviewReason: String,
	reviewReasonStartsWith: String,
	reviewReasonEndsWith: String,
	reviewReasonContains: String,
	reviewReasonLike: String,
	reviewReasonBetween: 
	[
		String
	],
	reviewReasonIn: 
	[
		String
	],
	reviewedBy: String,
	reviewedByStartsWith: String,
	reviewedByEndsWith: String,
	reviewedByContains: String,
	reviewedByLike: String,
	reviewedByBetween: 
	[
		String
	],
	reviewedByIn: 
	[
		String
	],
	expectedToClear: 0001-01-01,
	expectedToClearGreaterThanOrEqualTo: 0001-01-01,
	expectedToClearGreaterThan: 0001-01-01,
	expectedToClearLessThan: 0001-01-01,
	expectedToClearLessThanOrEqualTo: 0001-01-01,
	expectedToClearNotEqualTo: 0001-01-01,
	expectedToClearBetween: 
	[
		0001-01-01
	],
	expectedToClearIn: 
	[
		0001-01-01
	],
	reviewLog: String,
	reviewLogStartsWith: String,
	reviewLogEndsWith: String,
	reviewLogContains: String,
	reviewLogLike: String,
	reviewLogBetween: 
	[
		String
	],
	reviewLogIn: 
	[
		String
	],
	soldToId: String,
	soldToIdStartsWith: String,
	soldToIdEndsWith: String,
	soldToIdContains: String,
	soldToIdLike: String,
	soldToIdBetween: 
	[
		String
	],
	soldToIdIn: 
	[
		String
	],
	soldName: String,
	soldNameStartsWith: String,
	soldNameEndsWith: String,
	soldNameContains: String,
	soldNameLike: String,
	soldNameBetween: 
	[
		String
	],
	soldNameIn: 
	[
		String
	],
	soldAddress: String,
	soldAddressStartsWith: String,
	soldAddressEndsWith: String,
	soldAddressContains: String,
	soldAddressLike: String,
	soldAddressBetween: 
	[
		String
	],
	soldAddressIn: 
	[
		String
	],
	soldAddress2: String,
	soldAddress2StartsWith: String,
	soldAddress2EndsWith: String,
	soldAddress2Contains: String,
	soldAddress2Like: String,
	soldAddress2Between: 
	[
		String
	],
	soldAddress2In: 
	[
		String
	],
	soldCity: String,
	soldCityStartsWith: String,
	soldCityEndsWith: String,
	soldCityContains: String,
	soldCityLike: String,
	soldCityBetween: 
	[
		String
	],
	soldCityIn: 
	[
		String
	],
	soldState: String,
	soldStateStartsWith: String,
	soldStateEndsWith: String,
	soldStateContains: String,
	soldStateLike: String,
	soldStateBetween: 
	[
		String
	],
	soldStateIn: 
	[
		String
	],
	soldZipcode: String,
	soldZipcodeStartsWith: String,
	soldZipcodeEndsWith: String,
	soldZipcodeContains: String,
	soldZipcodeLike: String,
	soldZipcodeBetween: 
	[
		String
	],
	soldZipcodeIn: 
	[
		String
	],
	soldCountry: String,
	soldCountryStartsWith: String,
	soldCountryEndsWith: String,
	soldCountryContains: String,
	soldCountryLike: String,
	soldCountryBetween: 
	[
		String
	],
	soldCountryIn: 
	[
		String
	],
	soldPhone: String,
	soldPhoneStartsWith: String,
	soldPhoneEndsWith: String,
	soldPhoneContains: String,
	soldPhoneLike: String,
	soldPhoneBetween: 
	[
		String
	],
	soldPhoneIn: 
	[
		String
	],
	discount: 0,
	discountGreaterThanOrEqualTo: 0,
	discountGreaterThan: 0,
	discountLessThan: 0,
	discountLessThanOrEqualTo: 0,
	discountNotEqualTo: 0,
	discountBetween: 
	[
		0
	],
	discountIn: 
	[
		0
	],
	timeStamp: 0001-01-01,
	timeStampGreaterThanOrEqualTo: 0001-01-01,
	timeStampGreaterThan: 0001-01-01,
	timeStampLessThan: 0001-01-01,
	timeStampLessThanOrEqualTo: 0001-01-01,
	timeStampNotEqualTo: 0001-01-01,
	timeStampBetween: 
	[
		0001-01-01
	],
	timeStampIn: 
	[
		0001-01-01
	],
	dropShip: False,
	erpStatus: String,
	erpStatusStartsWith: String,
	erpStatusEndsWith: String,
	erpStatusContains: String,
	erpStatusLike: String,
	erpStatusBetween: 
	[
		String
	],
	erpStatusIn: 
	[
		String
	],
	originalOrderNumber: String,
	originalOrderNumberStartsWith: String,
	originalOrderNumberEndsWith: String,
	originalOrderNumberContains: String,
	originalOrderNumberLike: String,
	originalOrderNumberBetween: 
	[
		String
	],
	originalOrderNumberIn: 
	[
		String
	],
	shippedAmount: 0,
	shippedAmountGreaterThanOrEqualTo: 0,
	shippedAmountGreaterThan: 0,
	shippedAmountLessThan: 0,
	shippedAmountLessThanOrEqualTo: 0,
	shippedAmountNotEqualTo: 0,
	shippedAmountBetween: 
	[
		0
	],
	shippedAmountIn: 
	[
		0
	],
	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
	],
	currencyCode: String,
	currencyCodeStartsWith: String,
	currencyCodeEndsWith: String,
	currencyCodeContains: String,
	currencyCodeLike: String,
	currencyCodeBetween: 
	[
		String
	],
	currencyCodeIn: 
	[
		String
	],
	promoTransId: String,
	promoTransIdStartsWith: String,
	promoTransIdEndsWith: String,
	promoTransIdContains: String,
	promoTransIdLike: String,
	promoTransIdBetween: 
	[
		String
	],
	promoTransIdIn: 
	[
		String
	],
	splitOrder: False,
	repOrderNumber: String,
	repOrderNumberStartsWith: String,
	repOrderNumberEndsWith: String,
	repOrderNumberContains: String,
	repOrderNumberLike: String,
	repOrderNumberBetween: 
	[
		String
	],
	repOrderNumberIn: 
	[
		String
	],
	corpOrderNumber: String,
	corpOrderNumberStartsWith: String,
	corpOrderNumberEndsWith: String,
	corpOrderNumberContains: String,
	corpOrderNumberLike: String,
	corpOrderNumberBetween: 
	[
		String
	],
	corpOrderNumberIn: 
	[
		String
	],
	ccAuthorized: False,
	territoryRepOverride: False,
	checkNumber: String,
	checkNumberStartsWith: String,
	checkNumberEndsWith: String,
	checkNumberContains: String,
	checkNumberLike: String,
	checkNumberBetween: 
	[
		String
	],
	checkNumberIn: 
	[
		String
	],
	checkAmount: 0,
	checkAmountGreaterThanOrEqualTo: 0,
	checkAmountGreaterThan: 0,
	checkAmountLessThan: 0,
	checkAmountLessThanOrEqualTo: 0,
	checkAmountNotEqualTo: 0,
	checkAmountBetween: 
	[
		0
	],
	checkAmountIn: 
	[
		0
	],
	cancelDatesOK: False,
	company: String,
	companyStartsWith: String,
	companyEndsWith: String,
	companyContains: String,
	companyLike: String,
	companyBetween: 
	[
		String
	],
	companyIn: 
	[
		String
	],
	shipComplete: False,
	shippingNotes: String,
	shippingNotesStartsWith: String,
	shippingNotesEndsWith: String,
	shippingNotesContains: String,
	shippingNotesLike: String,
	shippingNotesBetween: 
	[
		String
	],
	shippingNotesIn: 
	[
		String
	],
	deliveryNotes: String,
	deliveryNotesStartsWith: String,
	deliveryNotesEndsWith: String,
	deliveryNotesContains: String,
	deliveryNotesLike: String,
	deliveryNotesBetween: 
	[
		String
	],
	deliveryNotesIn: 
	[
		String
	],
	internalNotes: String,
	internalNotesStartsWith: String,
	internalNotesEndsWith: String,
	internalNotesContains: String,
	internalNotesLike: String,
	internalNotesBetween: 
	[
		String
	],
	internalNotesIn: 
	[
		String
	],
	shippingNotes2: String,
	shippingNotes2StartsWith: String,
	shippingNotes2EndsWith: String,
	shippingNotes2Contains: String,
	shippingNotes2Like: String,
	shippingNotes2Between: 
	[
		String
	],
	shippingNotes2In: 
	[
		String
	],
	vendorNotes: String,
	vendorNotesStartsWith: String,
	vendorNotesEndsWith: String,
	vendorNotesContains: String,
	vendorNotesLike: String,
	vendorNotesBetween: 
	[
		String
	],
	vendorNotesIn: 
	[
		String
	],
	repGroup: String,
	repGroupStartsWith: String,
	repGroupEndsWith: String,
	repGroupContains: String,
	repGroupLike: String,
	repGroupBetween: 
	[
		String
	],
	repGroupIn: 
	[
		String
	],
	currentRep: String,
	currentRepStartsWith: String,
	currentRepEndsWith: String,
	currentRepContains: String,
	currentRepLike: String,
	currentRepBetween: 
	[
		String
	],
	currentRepIn: 
	[
		String
	],
	generatedFrom: String,
	generatedFromStartsWith: String,
	generatedFromEndsWith: String,
	generatedFromContains: String,
	generatedFromLike: String,
	generatedFromBetween: 
	[
		String
	],
	generatedFromIn: 
	[
		String
	],
	commissionRep: String,
	commissionRepStartsWith: String,
	commissionRepEndsWith: String,
	commissionRepContains: String,
	commissionRepLike: String,
	commissionRepBetween: 
	[
		String
	],
	commissionRepIn: 
	[
		String
	],
	warehouseId: String,
	warehouseIdStartsWith: String,
	warehouseIdEndsWith: String,
	warehouseIdContains: String,
	warehouseIdLike: String,
	warehouseIdBetween: 
	[
		String
	],
	warehouseIdIn: 
	[
		String
	],
	allowBackorders: False,
	fiscalYear: String,
	fiscalYearStartsWith: String,
	fiscalYearEndsWith: String,
	fiscalYearContains: String,
	fiscalYearLike: String,
	fiscalYearBetween: 
	[
		String
	],
	fiscalYearIn: 
	[
		String
	],
	fiscalMonth: String,
	fiscalMonthStartsWith: String,
	fiscalMonthEndsWith: String,
	fiscalMonthContains: String,
	fiscalMonthLike: String,
	fiscalMonthBetween: 
	[
		String
	],
	fiscalMonthIn: 
	[
		String
	],
	originalOrderTotal: 0,
	originalOrderTotalGreaterThanOrEqualTo: 0,
	originalOrderTotalGreaterThan: 0,
	originalOrderTotalLessThan: 0,
	originalOrderTotalLessThanOrEqualTo: 0,
	originalOrderTotalNotEqualTo: 0,
	originalOrderTotalBetween: 
	[
		0
	],
	originalOrderTotalIn: 
	[
		0
	],
	modifiedExportedOrderNotes: String,
	modifiedExportedOrderNotesStartsWith: String,
	modifiedExportedOrderNotesEndsWith: String,
	modifiedExportedOrderNotesContains: String,
	modifiedExportedOrderNotesLike: String,
	modifiedExportedOrderNotesBetween: 
	[
		String
	],
	modifiedExportedOrderNotesIn: 
	[
		String
	],
	containerId: String,
	containerIdStartsWith: String,
	containerIdEndsWith: String,
	containerIdContains: String,
	containerIdLike: String,
	containerIdBetween: 
	[
		String
	],
	containerIdIn: 
	[
		String
	],
	tagFor: String,
	tagForStartsWith: String,
	tagForEndsWith: String,
	tagForContains: String,
	tagForLike: String,
	tagForBetween: 
	[
		String
	],
	tagForIn: 
	[
		String
	],
	corpUploaded: False,
	corpModified: False,
	clientVersion: String,
	clientVersionStartsWith: String,
	clientVersionEndsWith: String,
	clientVersionContains: String,
	clientVersionLike: String,
	clientVersionBetween: 
	[
		String
	],
	clientVersionIn: 
	[
		String
	],
	priceList: String,
	priceListStartsWith: String,
	priceListEndsWith: String,
	priceListContains: String,
	priceListLike: String,
	priceListBetween: 
	[
		String
	],
	priceListIn: 
	[
		String
	],
	sendNewAcct: False,
	creditCardLastFour: String,
	creditCardLastFourStartsWith: String,
	creditCardLastFourEndsWith: String,
	creditCardLastFourContains: String,
	creditCardLastFourLike: String,
	creditCardLastFourBetween: 
	[
		String
	],
	creditCardLastFourIn: 
	[
		String
	],
	creditCardToken: String,
	creditCardTokenStartsWith: String,
	creditCardTokenEndsWith: String,
	creditCardTokenContains: String,
	creditCardTokenLike: String,
	creditCardTokenBetween: 
	[
		String
	],
	creditCardTokenIn: 
	[
		String
	],
	creditCardTransId: String,
	creditCardTransIdStartsWith: String,
	creditCardTransIdEndsWith: String,
	creditCardTransIdContains: String,
	creditCardTransIdLike: String,
	creditCardTransIdBetween: 
	[
		String
	],
	creditCardTransIdIn: 
	[
		String
	],
	creditCardId: String,
	creditCardIdStartsWith: String,
	creditCardIdEndsWith: String,
	creditCardIdContains: String,
	creditCardIdLike: String,
	creditCardIdBetween: 
	[
		String
	],
	creditCardIdIn: 
	[
		String
	],
	location: String,
	locationStartsWith: String,
	locationEndsWith: String,
	locationContains: String,
	locationLike: String,
	locationBetween: 
	[
		String
	],
	locationIn: 
	[
		String
	],
	tokenizationCode: String,
	tokenizationCodeStartsWith: String,
	tokenizationCodeEndsWith: String,
	tokenizationCodeContains: String,
	tokenizationCodeLike: String,
	tokenizationCodeBetween: 
	[
		String
	],
	tokenizationCodeIn: 
	[
		String
	],
	tokenizationProvider: String,
	tokenizationProviderStartsWith: String,
	tokenizationProviderEndsWith: String,
	tokenizationProviderContains: String,
	tokenizationProviderLike: String,
	tokenizationProviderBetween: 
	[
		String
	],
	tokenizationProviderIn: 
	[
		String
	],
	shipEmail: String,
	shipEmailStartsWith: String,
	shipEmailEndsWith: String,
	shipEmailContains: String,
	shipEmailLike: String,
	shipEmailBetween: 
	[
		String
	],
	shipEmailIn: 
	[
		String
	]
}

HTTP/1.1 200 OK
Content-Type: text/jsv
Content-Length: length

[
	{
		id: String,
		poNumber: String,
		orderPrefix: String,
		customerId: String,
		companyName: String,
		billAddress: String,
		billAddress2: String,
		billCity: String,
		billState: String,
		billZipcode: String,
		billCountry: String,
		billPhone: String,
		shipName: String,
		shipAddress: String,
		shipAddress2: String,
		shipCity: String,
		shipState: String,
		shipZipcode: String,
		shipCountry: String,
		shipPhone: String,
		orderDate: 0001-01-01,
		shipDate: 0001-01-01,
		buyer: String,
		salesRep: String,
		writingRep: String,
		terms: String,
		shipVia: String,
		cancelDate: 0001-01-01,
		orderTotal: 0,
		notes: String,
		created: 0001-01-01,
		orderStatus: String,
		source: String,
		creditCardType: String,
		creditCardNumber: String,
		creditCardExpiration: String,
		creditCardAVS: String,
		creditCardName: String,
		creditCardAddress: String,
		creditCardAddress2: String,
		creditCardCity: String,
		creditCardState: String,
		creditCardZipcode: String,
		creditCardCountry: String,
		manufacturerId: String,
		commPercentRep: 0,
		commPercentMfg: 0,
		balance: 0,
		mfgEmail: False,
		mfgFax: False,
		custEmail: False,
		custFax: False,
		repEmail: False,
		repFax: False,
		_CustEmail: String,
		_CustFax: String,
		modified: False,
		modificationReason: String,
		sendCreditSheet: False,
		uploaded: False,
		active: 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,
		imgSignature: AA==,
		shipId: String,
		transactionType: String,
		revision: 0,
		reasonCode: String,
		exported: False,
		sessionId: String,
		showCode: String,
		reviewReason: String,
		reviewedBy: String,
		expectedToClear: 0001-01-01,
		reviewLog: String,
		soldToId: String,
		soldName: String,
		soldAddress: String,
		soldAddress2: String,
		soldCity: String,
		soldState: String,
		soldZipcode: String,
		soldCountry: String,
		soldPhone: String,
		discount: 0,
		timeStamp: 0001-01-01,
		dropShip: False,
		erpStatus: String,
		originalOrderNumber: String,
		shippedAmount: 0,
		territoryId: String,
		regionId: String,
		currencyCode: String,
		promoTransId: String,
		splitOrder: False,
		repOrderNumber: String,
		corpOrderNumber: String,
		ccAuthorized: False,
		territoryRepOverride: False,
		checkNumber: String,
		checkAmount: 0,
		cancelDatesOK: False,
		company: String,
		shipComplete: False,
		shippingNotes: String,
		deliveryNotes: String,
		internalNotes: String,
		shippingNotes2: String,
		vendorNotes: String,
		repGroup: String,
		currentRep: String,
		generatedFrom: String,
		commissionRep: String,
		warehouseId: String,
		allowBackorders: False,
		fiscalYear: String,
		fiscalMonth: String,
		originalOrderTotal: 0,
		modifiedExportedOrderNotes: String,
		containerId: String,
		tagFor: String,
		corpUploaded: False,
		corpModified: False,
		clientVersion: String,
		priceList: String,
		sendNewAcct: False,
		creditCardLastFour: String,
		creditCardToken: String,
		creditCardTransId: String,
		creditCardId: String,
		location: String,
		tokenizationCode: String,
		tokenizationProvider: String,
		shipEmail: String
	}
]