EMUN1 ASP.NET

QuerySalesOrderLineRDB

**Requires Authentication**
Required role:	Administrator

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

**QuerySalesOrderLineRDB** 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
OrderNumber	query	string	No
OrderNumberStartsWith	query	string	No
OrderNumberEndsWith	query	string	No
OrderNumberContains	query	string	No
OrderNumberLike	query	string	No
OrderNumberBetween	query	string[]	No
OrderNumberIn	query	string[]	No
Position	query	int?	No
PositionGreaterThanOrEqualTo	query	int?	No
PositionGreaterThan	query	int?	No
PositionLessThan	query	int?	No
PositionLessThanOrEqualTo	query	int?	No
PositionNotEqualTo	query	int?	No
PositionBetween	query	int[]	No
PositionIn	query	int[]	No
ProductId	query	string	No
ProductIdStartsWith	query	string	No
ProductIdEndsWith	query	string	No
ProductIdContains	query	string	No
ProductIdLike	query	string	No
ProductIdBetween	query	string[]	No
ProductIdIn	query	string[]	No
Description	query	string	No
DescriptionStartsWith	query	string	No
DescriptionEndsWith	query	string	No
DescriptionContains	query	string	No
DescriptionLike	query	string	No
DescriptionBetween	query	string[]	No
DescriptionIn	query	string[]	No
QtyOrdered	query	double?	No
QtyOrderedGreaterThanOrEqualTo	query	double?	No
QtyOrderedGreaterThan	query	double?	No
QtyOrderedLessThan	query	double?	No
QtyOrderedLessThanOrEqualTo	query	double?	No
QtyOrderedNotEqualTo	query	double?	No
QtyOrderedBetween	query	double[]	No
QtyOrderedIn	query	double[]	No
SalesPrice	query	double?	No
SalesPriceGreaterThanOrEqualTo	query	double?	No
SalesPriceGreaterThan	query	double?	No
SalesPriceLessThan	query	double?	No
SalesPriceLessThanOrEqualTo	query	double?	No
SalesPriceNotEqualTo	query	double?	No
SalesPriceBetween	query	double[]	No
SalesPriceIn	query	double[]	No
ListPrice	query	double?	No
ListPriceGreaterThanOrEqualTo	query	double?	No
ListPriceGreaterThan	query	double?	No
ListPriceLessThan	query	double?	No
ListPriceLessThanOrEqualTo	query	double?	No
ListPriceNotEqualTo	query	double?	No
ListPriceBetween	query	double[]	No
ListPriceIn	query	double[]	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
UnitMeasure	query	string	No
UnitMeasureStartsWith	query	string	No
UnitMeasureEndsWith	query	string	No
UnitMeasureContains	query	string	No
UnitMeasureLike	query	string	No
UnitMeasureBetween	query	string[]	No
UnitMeasureIn	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
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
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
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
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
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
ShipMethod	query	string	No
ShipMethodStartsWith	query	string	No
ShipMethodEndsWith	query	string	No
ShipMethodContains	query	string	No
ShipMethodLike	query	string	No
ShipMethodBetween	query	string[]	No
ShipMethodIn	query	string[]	No
Color	query	string	No
ColorStartsWith	query	string	No
ColorEndsWith	query	string	No
ColorContains	query	string	No
ColorLike	query	string	No
ColorBetween	query	string[]	No
ColorIn	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
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
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
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
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
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
Entered	query	DateTime?	No
EnteredGreaterThanOrEqualTo	query	DateTime?	No
EnteredGreaterThan	query	DateTime?	No
EnteredLessThan	query	DateTime?	No
EnteredLessThanOrEqualTo	query	DateTime?	No
EnteredNotEqualTo	query	DateTime?	No
EnteredBetween	query	DateTime[]	No
EnteredIn	query	DateTime[]	No
Category	query	string	No
CategoryStartsWith	query	string	No
CategoryEndsWith	query	string	No
CategoryContains	query	string	No
CategoryLike	query	string	No
CategoryBetween	query	string[]	No
CategoryIn	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
OrderDiscount	query	double?	No
OrderDiscountGreaterThanOrEqualTo	query	double?	No
OrderDiscountGreaterThan	query	double?	No
OrderDiscountLessThan	query	double?	No
OrderDiscountLessThanOrEqualTo	query	double?	No
OrderDiscountNotEqualTo	query	double?	No
OrderDiscountBetween	query	double[]	No
OrderDiscountIn	query	double[]	No
LineDiscount	query	double?	No
LineDiscountGreaterThanOrEqualTo	query	double?	No
LineDiscountGreaterThan	query	double?	No
LineDiscountLessThan	query	double?	No
LineDiscountLessThanOrEqualTo	query	double?	No
LineDiscountNotEqualTo	query	double?	No
LineDiscountBetween	query	double[]	No
LineDiscountIn	query	double[]	No
QtyBreakPrice	query	double?	No
QtyBreakPriceGreaterThanOrEqualTo	query	double?	No
QtyBreakPriceGreaterThan	query	double?	No
QtyBreakPriceLessThan	query	double?	No
QtyBreakPriceLessThanOrEqualTo	query	double?	No
QtyBreakPriceNotEqualTo	query	double?	No
QtyBreakPriceBetween	query	double[]	No
QtyBreakPriceIn	query	double[]	No
PriceOverride	query	double?	No
PriceOverrideGreaterThanOrEqualTo	query	double?	No
PriceOverrideGreaterThan	query	double?	No
PriceOverrideLessThan	query	double?	No
PriceOverrideLessThanOrEqualTo	query	double?	No
PriceOverrideNotEqualTo	query	double?	No
PriceOverrideBetween	query	double[]	No
PriceOverrideIn	query	double[]	No
PromoDiscount	query	double?	No
PromoDiscountGreaterThanOrEqualTo	query	double?	No
PromoDiscountGreaterThan	query	double?	No
PromoDiscountLessThan	query	double?	No
PromoDiscountLessThanOrEqualTo	query	double?	No
PromoDiscountNotEqualTo	query	double?	No
PromoDiscountBetween	query	double[]	No
PromoDiscountIn	query	double[]	No
CustomerLevelPrice	query	double?	No
CustomerLevelPriceGreaterThanOrEqualTo	query	double?	No
CustomerLevelPriceGreaterThan	query	double?	No
CustomerLevelPriceLessThan	query	double?	No
CustomerLevelPriceLessThanOrEqualTo	query	double?	No
CustomerLevelPriceNotEqualTo	query	double?	No
CustomerLevelPriceBetween	query	double[]	No
CustomerLevelPriceIn	query	double[]	No
ItemGroupDiscount	query	double?	No
ItemGroupDiscountGreaterThanOrEqualTo	query	double?	No
ItemGroupDiscountGreaterThan	query	double?	No
ItemGroupDiscountLessThan	query	double?	No
ItemGroupDiscountLessThanOrEqualTo	query	double?	No
ItemGroupDiscountNotEqualTo	query	double?	No
ItemGroupDiscountBetween	query	double[]	No
ItemGroupDiscountIn	query	double[]	No
CustomerContractPrice	query	double?	No
CustomerContractPriceGreaterThanOrEqualTo	query	double?	No
CustomerContractPriceGreaterThan	query	double?	No
CustomerContractPriceLessThan	query	double?	No
CustomerContractPriceLessThanOrEqualTo	query	double?	No
CustomerContractPriceNotEqualTo	query	double?	No
CustomerContractPriceBetween	query	double[]	No
CustomerContractPriceIn	query	double[]	No
CustomerOrderLevelDiscount	query	double?	No
CustomerOrderLevelDiscountGreaterThanOrEqualTo	query	double?	No
CustomerOrderLevelDiscountGreaterThan	query	double?	No
CustomerOrderLevelDiscountLessThan	query	double?	No
CustomerOrderLevelDiscountLessThanOrEqualTo	query	double?	No
CustomerOrderLevelDiscountNotEqualTo	query	double?	No
CustomerOrderLevelDiscountBetween	query	double[]	No
CustomerOrderLevelDiscountIn	query	double[]	No
CustomerLineLevelDiscount	query	double?	No
CustomerLineLevelDiscountGreaterThanOrEqualTo	query	double?	No
CustomerLineLevelDiscountGreaterThan	query	double?	No
CustomerLineLevelDiscountLessThan	query	double?	No
CustomerLineLevelDiscountLessThanOrEqualTo	query	double?	No
CustomerLineLevelDiscountNotEqualTo	query	double?	No
CustomerLineLevelDiscountBetween	query	double[]	No
CustomerLineLevelDiscountIn	query	double[]	No
CustomerLineLevelQty	query	double?	No
CustomerLineLevelQtyGreaterThanOrEqualTo	query	double?	No
CustomerLineLevelQtyGreaterThan	query	double?	No
CustomerLineLevelQtyLessThan	query	double?	No
CustomerLineLevelQtyLessThanOrEqualTo	query	double?	No
CustomerLineLevelQtyNotEqualTo	query	double?	No
CustomerLineLevelQtyBetween	query	double[]	No
CustomerLineLevelQtyIn	query	double[]	No
ExtendedTotal	query	double?	No
ExtendedTotalGreaterThanOrEqualTo	query	double?	No
ExtendedTotalGreaterThan	query	double?	No
ExtendedTotalLessThan	query	double?	No
ExtendedTotalLessThanOrEqualTo	query	double?	No
ExtendedTotalNotEqualTo	query	double?	No
ExtendedTotalBetween	query	double[]	No
ExtendedTotalIn	query	double[]	No
PromoNote	query	string	No
PromoNoteStartsWith	query	string	No
PromoNoteEndsWith	query	string	No
PromoNoteContains	query	string	No
PromoNoteLike	query	string	No
PromoNoteBetween	query	string[]	No
PromoNoteIn	query	string[]	No
PromoDollarAmount	query	double?	No
PromoDollarAmountGreaterThanOrEqualTo	query	double?	No
PromoDollarAmountGreaterThan	query	double?	No
PromoDollarAmountLessThan	query	double?	No
PromoDollarAmountLessThanOrEqualTo	query	double?	No
PromoDollarAmountNotEqualTo	query	double?	No
PromoDollarAmountBetween	query	double[]	No
PromoDollarAmountIn	query	double[]	No
SplitOrigSO	query	string	No
SplitOrigSOStartsWith	query	string	No
SplitOrigSOEndsWith	query	string	No
SplitOrigSOContains	query	string	No
SplitOrigSOLike	query	string	No
SplitOrigSOBetween	query	string[]	No
SplitOrigSOIn	query	string[]	No
PromoCode	query	string	No
PromoCodeStartsWith	query	string	No
PromoCodeEndsWith	query	string	No
PromoCodeContains	query	string	No
PromoCodeLike	query	string	No
PromoCodeBetween	query	string[]	No
PromoCodeIn	query	string[]	No
QtyShipped	query	double?	No
QtyShippedGreaterThanOrEqualTo	query	double?	No
QtyShippedGreaterThan	query	double?	No
QtyShippedLessThan	query	double?	No
QtyShippedLessThanOrEqualTo	query	double?	No
QtyShippedNotEqualTo	query	double?	No
QtyShippedBetween	query	double[]	No
QtyShippedIn	query	double[]	No
SubCategory	query	string	No
SubCategoryStartsWith	query	string	No
SubCategoryEndsWith	query	string	No
SubCategoryContains	query	string	No
SubCategoryLike	query	string	No
SubCategoryBetween	query	string[]	No
SubCategoryIn	query	string[]	No
Warehouse	query	string	No
WarehouseStartsWith	query	string	No
WarehouseEndsWith	query	string	No
WarehouseContains	query	string	No
WarehouseLike	query	string	No
WarehouseBetween	query	string[]	No
WarehouseIn	query	string[]	No
KitComponent	query	bool?	No
LineNotes	query	string	No
LineNotesStartsWith	query	string	No
LineNotesEndsWith	query	string	No
LineNotesContains	query	string	No
LineNotesLike	query	string	No
LineNotesBetween	query	string[]	No
LineNotesIn	query	string[]	No
BrandId	query	string	No
BrandIdStartsWith	query	string	No
BrandIdEndsWith	query	string	No
BrandIdContains	query	string	No
BrandIdLike	query	string	No
BrandIdBetween	query	string[]	No
BrandIdIn	query	string[]	No
PromoCode2	query	string	No
PromoCode2StartsWith	query	string	No
PromoCode2EndsWith	query	string	No
PromoCode2Contains	query	string	No
PromoCode2Like	query	string	No
PromoCode2Between	query	string[]	No
PromoCode2In	query	string[]	No
Comments	query	string	No
CommentsStartsWith	query	string	No
CommentsEndsWith	query	string	No
CommentsContains	query	string	No
CommentsLike	query	string	No
CommentsBetween	query	string[]	No
CommentsIn	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
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
ParentPosition	query	int?	No
ParentPositionGreaterThanOrEqualTo	query	int?	No
ParentPositionGreaterThan	query	int?	No
ParentPositionLessThan	query	int?	No
ParentPositionLessThanOrEqualTo	query	int?	No
ParentPositionNotEqualTo	query	int?	No
ParentPositionBetween	query	int[]	No
ParentPositionIn	query	int[]	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
QtyAdjusted	query	bool?	No
SuperCategory	query	string	No
SuperCategoryStartsWith	query	string	No
SuperCategoryEndsWith	query	string	No
SuperCategoryContains	query	string	No
SuperCategoryLike	query	string	No
SuperCategoryBetween	query	string[]	No
SuperCategoryIn	query	string[]	No
EnforceESA	query	string	No
EnforceESAStartsWith	query	string	No
EnforceESAEndsWith	query	string	No
EnforceESAContains	query	string	No
EnforceESALike	query	string	No
EnforceESABetween	query	string[]	No
EnforceESAIn	query	string[]	No
ESADate	query	DateTime?	No
ESADateGreaterThanOrEqualTo	query	DateTime?	No
ESADateGreaterThan	query	DateTime?	No
ESADateLessThan	query	DateTime?	No
ESADateLessThanOrEqualTo	query	DateTime?	No
ESADateNotEqualTo	query	DateTime?	No
ESADateBetween	query	DateTime[]	No
ESADateIn	query	DateTime[]	No
Custom1DBL	query	double?	No
Custom1DBLGreaterThanOrEqualTo	query	double?	No
Custom1DBLGreaterThan	query	double?	No
Custom1DBLLessThan	query	double?	No
Custom1DBLLessThanOrEqualTo	query	double?	No
Custom1DBLNotEqualTo	query	double?	No
Custom1DBLBetween	query	double[]	No
Custom1DBLIn	query	double[]	No
Custom2DBL	query	double?	No
Custom2DBLGreaterThanOrEqualTo	query	double?	No
Custom2DBLGreaterThan	query	double?	No
Custom2DBLLessThan	query	double?	No
Custom2DBLLessThanOrEqualTo	query	double?	No
Custom2DBLNotEqualTo	query	double?	No
Custom2DBLBetween	query	double[]	No
Custom2DBLIn	query	double[]	No
Custom3DBL	query	double?	No
Custom3DBLGreaterThanOrEqualTo	query	double?	No
Custom3DBLGreaterThan	query	double?	No
Custom3DBLLessThan	query	double?	No
Custom3DBLLessThanOrEqualTo	query	double?	No
Custom3DBLNotEqualTo	query	double?	No
Custom3DBLBetween	query	double[]	No
Custom3DBLIn	query	double[]	No
Custom4DBL	query	double?	No
Custom4DBLGreaterThanOrEqualTo	query	double?	No
Custom4DBLGreaterThan	query	double?	No
Custom4DBLLessThan	query	double?	No
Custom4DBLLessThanOrEqualTo	query	double?	No
Custom4DBLNotEqualTo	query	double?	No
Custom4DBLBetween	query	double[]	No
Custom4DBLIn	query	double[]	No
Custom5DBL	query	double?	No
Custom5DBLGreaterThanOrEqualTo	query	double?	No
Custom5DBLGreaterThan	query	double?	No
Custom5DBLLessThan	query	double?	No
Custom5DBLLessThanOrEqualTo	query	double?	No
Custom5DBLNotEqualTo	query	double?	No
Custom5DBLBetween	query	double[]	No
Custom5DBLIn	query	double[]	No
Custom1INT	query	int?	No
Custom1INTGreaterThanOrEqualTo	query	int?	No
Custom1INTGreaterThan	query	int?	No
Custom1INTLessThan	query	int?	No
Custom1INTLessThanOrEqualTo	query	int?	No
Custom1INTNotEqualTo	query	int?	No
Custom1INTBetween	query	int[]	No
Custom1INTIn	query	int[]	No
Custom2INT	query	int?	No
Custom2INTGreaterThanOrEqualTo	query	int?	No
Custom2INTGreaterThan	query	int?	No
Custom2INTLessThan	query	int?	No
Custom2INTLessThanOrEqualTo	query	int?	No
Custom2INTNotEqualTo	query	int?	No
Custom2INTBetween	query	int[]	No
Custom2INTIn	query	int[]	No
Custom3INT	query	int?	No
Custom3INTGreaterThanOrEqualTo	query	int?	No
Custom3INTGreaterThan	query	int?	No
Custom3INTLessThan	query	int?	No
Custom3INTLessThanOrEqualTo	query	int?	No
Custom3INTNotEqualTo	query	int?	No
Custom3INTBetween	query	int[]	No
Custom3INTIn	query	int[]	No
Custom4INT	query	int?	No
Custom4INTGreaterThanOrEqualTo	query	int?	No
Custom4INTGreaterThan	query	int?	No
Custom4INTLessThan	query	int?	No
Custom4INTLessThanOrEqualTo	query	int?	No
Custom4INTNotEqualTo	query	int?	No
Custom4INTBetween	query	int[]	No
Custom4INTIn	query	int[]	No
Custom5INT	query	int?	No
Custom5INTGreaterThanOrEqualTo	query	int?	No
Custom5INTGreaterThan	query	int?	No
Custom5INTLessThan	query	int?	No
Custom5INTLessThanOrEqualTo	query	int?	No
Custom5INTNotEqualTo	query	int?	No
Custom5INTBetween	query	int[]	No
Custom5INTIn	query	int[]	No
Upcharge	query	double?	No
UpchargeGreaterThanOrEqualTo	query	double?	No
UpchargeGreaterThan	query	double?	No
UpchargeLessThan	query	double?	No
UpchargeLessThanOrEqualTo	query	double?	No
UpchargeNotEqualTo	query	double?	No
UpchargeBetween	query	double[]	No
UpchargeIn	query	double[]	No
QtyOpen	query	double?	No
QtyOpenGreaterThanOrEqualTo	query	double?	No
QtyOpenGreaterThan	query	double?	No
QtyOpenLessThan	query	double?	No
QtyOpenLessThanOrEqualTo	query	double?	No
QtyOpenNotEqualTo	query	double?	No
QtyOpenBetween	query	double[]	No
QtyOpenIn	query	double[]	No
DICost	query	string	No
DICostStartsWith	query	string	No
DICostEndsWith	query	string	No
DICostContains	query	string	No
DICostLike	query	string	No
DICostBetween	query	string[]	No
DICostIn	query	string[]	No
HTS	query	string	No
HTSStartsWith	query	string	No
HTSEndsWith	query	string	No
HTSContains	query	string	No
HTSLike	query	string	No
HTSBetween	query	string[]	No
HTSIn	query	string[]	No
Duty	query	string	No
DutyStartsWith	query	string	No
DutyEndsWith	query	string	No
DutyContains	query	string	No
DutyLike	query	string	No
DutyBetween	query	string[]	No
DutyIn	query	string[]	No
Weight	query	string	No
WeightStartsWith	query	string	No
WeightEndsWith	query	string	No
WeightContains	query	string	No
WeightLike	query	string	No
WeightBetween	query	string[]	No
WeightIn	query	string[]	No
Cube	query	string	No
CubeStartsWith	query	string	No
CubeEndsWith	query	string	No
CubeContains	query	string	No
CubeLike	query	string	No
CubeBetween	query	string[]	No
CubeIn	query	string[]	No
Port	query	string	No
PortStartsWith	query	string	No
PortEndsWith	query	string	No
PortContains	query	string	No
PortLike	query	string	No
PortBetween	query	string[]	No
PortIn	query	string[]	No
UPC	query	string	No
UPCStartsWith	query	string	No
UPCEndsWith	query	string	No
UPCContains	query	string	No
UPCLike	query	string	No
UPCBetween	query	string[]	No
UPCIn	query	string[]	No
CaseDimensions	query	string	No
CaseDimensionsStartsWith	query	string	No
CaseDimensionsEndsWith	query	string	No
CaseDimensionsContains	query	string	No
CaseDimensionsLike	query	string	No
CaseDimensionsBetween	query	string[]	No
CaseDimensionsIn	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
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
UsedProductShipDate	query	bool?	No
xmlOptions	query	string	No
xmlOptionsStartsWith	query	string	No
xmlOptionsEndsWith	query	string	No
xmlOptionsContains	query	string	No
xmlOptionsLike	query	string	No
xmlOptionsBetween	query	string[]	No
xmlOptionsIn	query	string[]	No
OptionGroupList	query	string	No
OptionGroupListStartsWith	query	string	No
OptionGroupListEndsWith	query	string	No
OptionGroupListContains	query	string	No
OptionGroupListLike	query	string	No
OptionGroupListBetween	query	string[]	No
OptionGroupListIn	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
ContractPrice	query	bool?	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/QuerySalesOrderLineRDB HTTP/1.1 
Host: www.bernhardthospitality.com 
Accept: application/xlsx
Content-Type: application/xlsx
Content-Length: length

{"skip":0,"take":0,"orderBy":"String","orderByDesc":"String","include":"String","fields":"String","meta":{"String":"String"},"orderNumber":"String","orderNumberStartsWith":"String","orderNumberEndsWith":"String","orderNumberContains":"String","orderNumberLike":"String","orderNumberBetween":["String"],"orderNumberIn":["String"],"position":0,"positionGreaterThanOrEqualTo":0,"positionGreaterThan":0,"positionLessThan":0,"positionLessThanOrEqualTo":0,"positionNotEqualTo":0,"positionBetween":[0],"positionIn":[0],"productId":"String","productIdStartsWith":"String","productIdEndsWith":"String","productIdContains":"String","productIdLike":"String","productIdBetween":["String"],"productIdIn":["String"],"description":"String","descriptionStartsWith":"String","descriptionEndsWith":"String","descriptionContains":"String","descriptionLike":"String","descriptionBetween":["String"],"descriptionIn":["String"],"qtyOrdered":0,"qtyOrderedGreaterThanOrEqualTo":0,"qtyOrderedGreaterThan":0,"qtyOrderedLessThan":0,"qtyOrderedLessThanOrEqualTo":0,"qtyOrderedNotEqualTo":0,"qtyOrderedBetween":[0],"qtyOrderedIn":[0],"salesPrice":0,"salesPriceGreaterThanOrEqualTo":0,"salesPriceGreaterThan":0,"salesPriceLessThan":0,"salesPriceLessThanOrEqualTo":0,"salesPriceNotEqualTo":0,"salesPriceBetween":[0],"salesPriceIn":[0],"listPrice":0,"listPriceGreaterThanOrEqualTo":0,"listPriceGreaterThan":0,"listPriceLessThan":0,"listPriceLessThanOrEqualTo":0,"listPriceNotEqualTo":0,"listPriceBetween":[0],"listPriceIn":[0],"discount":0,"discountGreaterThanOrEqualTo":0,"discountGreaterThan":0,"discountLessThan":0,"discountLessThanOrEqualTo":0,"discountNotEqualTo":0,"discountBetween":[0],"discountIn":[0],"unitMeasure":"String","unitMeasureStartsWith":"String","unitMeasureEndsWith":"String","unitMeasureContains":"String","unitMeasureLike":"String","unitMeasureBetween":["String"],"unitMeasureIn":["String"],"notes":"String","notesStartsWith":"String","notesEndsWith":"String","notesContains":"String","notesLike":"String","notesBetween":["String"],"notesIn":["String"],"shipDate":"0001-01-01T00:00:00.0000000Z","shipDateGreaterThanOrEqualTo":"0001-01-01T00:00:00.0000000Z","shipDateGreaterThan":"0001-01-01T00:00:00.0000000Z","shipDateLessThan":"0001-01-01T00:00:00.0000000Z","shipDateLessThanOrEqualTo":"0001-01-01T00:00:00.0000000Z","shipDateNotEqualTo":"0001-01-01T00:00:00.0000000Z","shipDateBetween":["0001-01-01T00:00:00.0000000Z"],"shipDateIn":["0001-01-01T00:00:00.0000000Z"],"cancelDate":"0001-01-01T00:00:00.0000000Z","cancelDateGreaterThanOrEqualTo":"0001-01-01T00:00:00.0000000Z","cancelDateGreaterThan":"0001-01-01T00:00:00.0000000Z","cancelDateLessThan":"0001-01-01T00:00:00.0000000Z","cancelDateLessThanOrEqualTo":"0001-01-01T00:00:00.0000000Z","cancelDateNotEqualTo":"0001-01-01T00:00:00.0000000Z","cancelDateBetween":["0001-01-01T00:00:00.0000000Z"],"cancelDateIn":["0001-01-01T00:00:00.0000000Z"],"manufacturerId":"String","manufacturerIdStartsWith":"String","manufacturerIdEndsWith":"String","manufacturerIdContains":"String","manufacturerIdLike":"String","manufacturerIdBetween":["String"],"manufacturerIdIn":["String"],"poNumber":"String","poNumberStartsWith":"String","poNumberEndsWith":"String","poNumberContains":"String","poNumberLike":"String","poNumberBetween":["String"],"poNumberIn":["String"],"terms":"String","termsStartsWith":"String","termsEndsWith":"String","termsContains":"String","termsLike":"String","termsBetween":["String"],"termsIn":["String"],"shipMethod":"String","shipMethodStartsWith":"String","shipMethodEndsWith":"String","shipMethodContains":"String","shipMethodLike":"String","shipMethodBetween":["String"],"shipMethodIn":["String"],"color":"String","colorStartsWith":"String","colorEndsWith":"String","colorContains":"String","colorLike":"String","colorBetween":["String"],"colorIn":["String"],"creditCardNumber":"String","creditCardNumberStartsWith":"String","creditCardNumberEndsWith":"String","creditCardNumberContains":"String","creditCardNumberLike":"String","creditCardNumberBetween":["String"],"creditCardNumberIn":["String"],"creditCardType":"String","creditCardTypeStartsWith":"String","creditCardTypeEndsWith":"String","creditCardTypeContains":"String","creditCardTypeLike":"String","creditCardTypeBetween":["String"],"creditCardTypeIn":["String"],"creditCardName":"String","creditCardNameStartsWith":"String","creditCardNameEndsWith":"String","creditCardNameContains":"String","creditCardNameLike":"String","creditCardNameBetween":["String"],"creditCardNameIn":["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"],"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"],"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"],"entered":"0001-01-01T00:00:00.0000000Z","enteredGreaterThanOrEqualTo":"0001-01-01T00:00:00.0000000Z","enteredGreaterThan":"0001-01-01T00:00:00.0000000Z","enteredLessThan":"0001-01-01T00:00:00.0000000Z","enteredLessThanOrEqualTo":"0001-01-01T00:00:00.0000000Z","enteredNotEqualTo":"0001-01-01T00:00:00.0000000Z","enteredBetween":["0001-01-01T00:00:00.0000000Z"],"enteredIn":["0001-01-01T00:00:00.0000000Z"],"category":"String","categoryStartsWith":"String","categoryEndsWith":"String","categoryContains":"String","categoryLike":"String","categoryBetween":["String"],"categoryIn":["String"],"revision":0,"revisionGreaterThanOrEqualTo":0,"revisionGreaterThan":0,"revisionLessThan":0,"revisionLessThanOrEqualTo":0,"revisionNotEqualTo":0,"revisionBetween":[0],"revisionIn":[0],"orderDiscount":0,"orderDiscountGreaterThanOrEqualTo":0,"orderDiscountGreaterThan":0,"orderDiscountLessThan":0,"orderDiscountLessThanOrEqualTo":0,"orderDiscountNotEqualTo":0,"orderDiscountBetween":[0],"orderDiscountIn":[0],"lineDiscount":0,"lineDiscountGreaterThanOrEqualTo":0,"lineDiscountGreaterThan":0,"lineDiscountLessThan":0,"lineDiscountLessThanOrEqualTo":0,"lineDiscountNotEqualTo":0,"lineDiscountBetween":[0],"lineDiscountIn":[0],"qtyBreakPrice":0,"qtyBreakPriceGreaterThanOrEqualTo":0,"qtyBreakPriceGreaterThan":0,"qtyBreakPriceLessThan":0,"qtyBreakPriceLessThanOrEqualTo":0,"qtyBreakPriceNotEqualTo":0,"qtyBreakPriceBetween":[0],"qtyBreakPriceIn":[0],"priceOverride":0,"priceOverrideGreaterThanOrEqualTo":0,"priceOverrideGreaterThan":0,"priceOverrideLessThan":0,"priceOverrideLessThanOrEqualTo":0,"priceOverrideNotEqualTo":0,"priceOverrideBetween":[0],"priceOverrideIn":[0],"promoDiscount":0,"promoDiscountGreaterThanOrEqualTo":0,"promoDiscountGreaterThan":0,"promoDiscountLessThan":0,"promoDiscountLessThanOrEqualTo":0,"promoDiscountNotEqualTo":0,"promoDiscountBetween":[0],"promoDiscountIn":[0],"customerLevelPrice":0,"customerLevelPriceGreaterThanOrEqualTo":0,"customerLevelPriceGreaterThan":0,"customerLevelPriceLessThan":0,"customerLevelPriceLessThanOrEqualTo":0,"customerLevelPriceNotEqualTo":0,"customerLevelPriceBetween":[0],"customerLevelPriceIn":[0],"itemGroupDiscount":0,"itemGroupDiscountGreaterThanOrEqualTo":0,"itemGroupDiscountGreaterThan":0,"itemGroupDiscountLessThan":0,"itemGroupDiscountLessThanOrEqualTo":0,"itemGroupDiscountNotEqualTo":0,"itemGroupDiscountBetween":[0],"itemGroupDiscountIn":[0],"customerContractPrice":0,"customerContractPriceGreaterThanOrEqualTo":0,"customerContractPriceGreaterThan":0,"customerContractPriceLessThan":0,"customerContractPriceLessThanOrEqualTo":0,"customerContractPriceNotEqualTo":0,"customerContractPriceBetween":[0],"customerContractPriceIn":[0],"customerOrderLevelDiscount":0,"customerOrderLevelDiscountGreaterThanOrEqualTo":0,"customerOrderLevelDiscountGreaterThan":0,"customerOrderLevelDiscountLessThan":0,"customerOrderLevelDiscountLessThanOrEqualTo":0,"customerOrderLevelDiscountNotEqualTo":0,"customerOrderLevelDiscountBetween":[0],"customerOrderLevelDiscountIn":[0],"customerLineLevelDiscount":0,"customerLineLevelDiscountGreaterThanOrEqualTo":0,"customerLineLevelDiscountGreaterThan":0,"customerLineLevelDiscountLessThan":0,"customerLineLevelDiscountLessThanOrEqualTo":0,"customerLineLevelDiscountNotEqualTo":0,"customerLineLevelDiscountBetween":[0],"customerLineLevelDiscountIn":[0],"customerLineLevelQty":0,"customerLineLevelQtyGreaterThanOrEqualTo":0,"customerLineLevelQtyGreaterThan":0,"customerLineLevelQtyLessThan":0,"customerLineLevelQtyLessThanOrEqualTo":0,"customerLineLevelQtyNotEqualTo":0,"customerLineLevelQtyBetween":[0],"customerLineLevelQtyIn":[0],"extendedTotal":0,"extendedTotalGreaterThanOrEqualTo":0,"extendedTotalGreaterThan":0,"extendedTotalLessThan":0,"extendedTotalLessThanOrEqualTo":0,"extendedTotalNotEqualTo":0,"extendedTotalBetween":[0],"extendedTotalIn":[0],"promoNote":"String","promoNoteStartsWith":"String","promoNoteEndsWith":"String","promoNoteContains":"String","promoNoteLike":"String","promoNoteBetween":["String"],"promoNoteIn":["String"],"promoDollarAmount":0,"promoDollarAmountGreaterThanOrEqualTo":0,"promoDollarAmountGreaterThan":0,"promoDollarAmountLessThan":0,"promoDollarAmountLessThanOrEqualTo":0,"promoDollarAmountNotEqualTo":0,"promoDollarAmountBetween":[0],"promoDollarAmountIn":[0],"splitOrigSO":"String","splitOrigSOStartsWith":"String","splitOrigSOEndsWith":"String","splitOrigSOContains":"String","splitOrigSOLike":"String","splitOrigSOBetween":["String"],"splitOrigSOIn":["String"],"promoCode":"String","promoCodeStartsWith":"String","promoCodeEndsWith":"String","promoCodeContains":"String","promoCodeLike":"String","promoCodeBetween":["String"],"promoCodeIn":["String"],"qtyShipped":0,"qtyShippedGreaterThanOrEqualTo":0,"qtyShippedGreaterThan":0,"qtyShippedLessThan":0,"qtyShippedLessThanOrEqualTo":0,"qtyShippedNotEqualTo":0,"qtyShippedBetween":[0],"qtyShippedIn":[0],"subCategory":"String","subCategoryStartsWith":"String","subCategoryEndsWith":"String","subCategoryContains":"String","subCategoryLike":"String","subCategoryBetween":["String"],"subCategoryIn":["String"],"warehouse":"String","warehouseStartsWith":"String","warehouseEndsWith":"String","warehouseContains":"String","warehouseLike":"String","warehouseBetween":["String"],"warehouseIn":["String"],"kitComponent":false,"lineNotes":"String","lineNotesStartsWith":"String","lineNotesEndsWith":"String","lineNotesContains":"String","lineNotesLike":"String","lineNotesBetween":["String"],"lineNotesIn":["String"],"brandId":"String","brandIdStartsWith":"String","brandIdEndsWith":"String","brandIdContains":"String","brandIdLike":"String","brandIdBetween":["String"],"brandIdIn":["String"],"promoCode2":"String","promoCode2StartsWith":"String","promoCode2EndsWith":"String","promoCode2Contains":"String","promoCode2Like":"String","promoCode2Between":["String"],"promoCode2In":["String"],"comments":"String","commentsStartsWith":"String","commentsEndsWith":"String","commentsContains":"String","commentsLike":"String","commentsBetween":["String"],"commentsIn":["String"],"salesRep":"String","salesRepStartsWith":"String","salesRepEndsWith":"String","salesRepContains":"String","salesRepLike":"String","salesRepBetween":["String"],"salesRepIn":["String"],"reasonCode":"String","reasonCodeStartsWith":"String","reasonCodeEndsWith":"String","reasonCodeContains":"String","reasonCodeLike":"String","reasonCodeBetween":["String"],"reasonCodeIn":["String"],"parentPosition":0,"parentPositionGreaterThanOrEqualTo":0,"parentPositionGreaterThan":0,"parentPositionLessThan":0,"parentPositionLessThanOrEqualTo":0,"parentPositionNotEqualTo":0,"parentPositionBetween":[0],"parentPositionIn":[0],"status":"String","statusStartsWith":"String","statusEndsWith":"String","statusContains":"String","statusLike":"String","statusBetween":["String"],"statusIn":["String"],"qtyAdjusted":false,"superCategory":"String","superCategoryStartsWith":"String","superCategoryEndsWith":"String","superCategoryContains":"String","superCategoryLike":"String","superCategoryBetween":["String"],"superCategoryIn":["String"],"enforceESA":"String","enforceESAStartsWith":"String","enforceESAEndsWith":"String","enforceESAContains":"String","enforceESALike":"String","enforceESABetween":["String"],"enforceESAIn":["String"],"esaDate":"0001-01-01T00:00:00.0000000Z","esaDateGreaterThanOrEqualTo":"0001-01-01T00:00:00.0000000Z","esaDateGreaterThan":"0001-01-01T00:00:00.0000000Z","esaDateLessThan":"0001-01-01T00:00:00.0000000Z","esaDateLessThanOrEqualTo":"0001-01-01T00:00:00.0000000Z","esaDateNotEqualTo":"0001-01-01T00:00:00.0000000Z","esaDateBetween":["0001-01-01T00:00:00.0000000Z"],"esaDateIn":["0001-01-01T00:00:00.0000000Z"],"custom1DBL":0,"custom1DBLGreaterThanOrEqualTo":0,"custom1DBLGreaterThan":0,"custom1DBLLessThan":0,"custom1DBLLessThanOrEqualTo":0,"custom1DBLNotEqualTo":0,"custom1DBLBetween":[0],"custom1DBLIn":[0],"custom2DBL":0,"custom2DBLGreaterThanOrEqualTo":0,"custom2DBLGreaterThan":0,"custom2DBLLessThan":0,"custom2DBLLessThanOrEqualTo":0,"custom2DBLNotEqualTo":0,"custom2DBLBetween":[0],"custom2DBLIn":[0],"custom3DBL":0,"custom3DBLGreaterThanOrEqualTo":0,"custom3DBLGreaterThan":0,"custom3DBLLessThan":0,"custom3DBLLessThanOrEqualTo":0,"custom3DBLNotEqualTo":0,"custom3DBLBetween":[0],"custom3DBLIn":[0],"custom4DBL":0,"custom4DBLGreaterThanOrEqualTo":0,"custom4DBLGreaterThan":0,"custom4DBLLessThan":0,"custom4DBLLessThanOrEqualTo":0,"custom4DBLNotEqualTo":0,"custom4DBLBetween":[0],"custom4DBLIn":[0],"custom5DBL":0,"custom5DBLGreaterThanOrEqualTo":0,"custom5DBLGreaterThan":0,"custom5DBLLessThan":0,"custom5DBLLessThanOrEqualTo":0,"custom5DBLNotEqualTo":0,"custom5DBLBetween":[0],"custom5DBLIn":[0],"custom1INT":0,"custom1INTGreaterThanOrEqualTo":0,"custom1INTGreaterThan":0,"custom1INTLessThan":0,"custom1INTLessThanOrEqualTo":0,"custom1INTNotEqualTo":0,"custom1INTBetween":[0],"custom1INTIn":[0],"custom2INT":0,"custom2INTGreaterThanOrEqualTo":0,"custom2INTGreaterThan":0,"custom2INTLessThan":0,"custom2INTLessThanOrEqualTo":0,"custom2INTNotEqualTo":0,"custom2INTBetween":[0],"custom2INTIn":[0],"custom3INT":0,"custom3INTGreaterThanOrEqualTo":0,"custom3INTGreaterThan":0,"custom3INTLessThan":0,"custom3INTLessThanOrEqualTo":0,"custom3INTNotEqualTo":0,"custom3INTBetween":[0],"custom3INTIn":[0],"custom4INT":0,"custom4INTGreaterThanOrEqualTo":0,"custom4INTGreaterThan":0,"custom4INTLessThan":0,"custom4INTLessThanOrEqualTo":0,"custom4INTNotEqualTo":0,"custom4INTBetween":[0],"custom4INTIn":[0],"custom5INT":0,"custom5INTGreaterThanOrEqualTo":0,"custom5INTGreaterThan":0,"custom5INTLessThan":0,"custom5INTLessThanOrEqualTo":0,"custom5INTNotEqualTo":0,"custom5INTBetween":[0],"custom5INTIn":[0],"upcharge":0,"upchargeGreaterThanOrEqualTo":0,"upchargeGreaterThan":0,"upchargeLessThan":0,"upchargeLessThanOrEqualTo":0,"upchargeNotEqualTo":0,"upchargeBetween":[0],"upchargeIn":[0],"qtyOpen":0,"qtyOpenGreaterThanOrEqualTo":0,"qtyOpenGreaterThan":0,"qtyOpenLessThan":0,"qtyOpenLessThanOrEqualTo":0,"qtyOpenNotEqualTo":0,"qtyOpenBetween":[0],"qtyOpenIn":[0],"diCost":"String","diCostStartsWith":"String","diCostEndsWith":"String","diCostContains":"String","diCostLike":"String","diCostBetween":["String"],"diCostIn":["String"],"hts":"String","htsStartsWith":"String","htsEndsWith":"String","htsContains":"String","htsLike":"String","htsBetween":["String"],"htsIn":["String"],"duty":"String","dutyStartsWith":"String","dutyEndsWith":"String","dutyContains":"String","dutyLike":"String","dutyBetween":["String"],"dutyIn":["String"],"weight":"String","weightStartsWith":"String","weightEndsWith":"String","weightContains":"String","weightLike":"String","weightBetween":["String"],"weightIn":["String"],"cube":"String","cubeStartsWith":"String","cubeEndsWith":"String","cubeContains":"String","cubeLike":"String","cubeBetween":["String"],"cubeIn":["String"],"port":"String","portStartsWith":"String","portEndsWith":"String","portContains":"String","portLike":"String","portBetween":["String"],"portIn":["String"],"upc":"String","upcStartsWith":"String","upcEndsWith":"String","upcContains":"String","upcLike":"String","upcBetween":["String"],"upcIn":["String"],"caseDimensions":"String","caseDimensionsStartsWith":"String","caseDimensionsEndsWith":"String","caseDimensionsContains":"String","caseDimensionsLike":"String","caseDimensionsBetween":["String"],"caseDimensionsIn":["String"],"warehouseId":"String","warehouseIdStartsWith":"String","warehouseIdEndsWith":"String","warehouseIdContains":"String","warehouseIdLike":"String","warehouseIdBetween":["String"],"warehouseIdIn":["String"],"tagFor":"String","tagForStartsWith":"String","tagForEndsWith":"String","tagForContains":"String","tagForLike":"String","tagForBetween":["String"],"tagForIn":["String"],"usedProductShipDate":false,"xmlOptions":"String","xmlOptionsStartsWith":"String","xmlOptionsEndsWith":"String","xmlOptionsContains":"String","xmlOptionsLike":"String","xmlOptionsBetween":["String"],"xmlOptionsIn":["String"],"optionGroupList":"String","optionGroupListStartsWith":"String","optionGroupListEndsWith":"String","optionGroupListContains":"String","optionGroupListLike":"String","optionGroupListBetween":["String"],"optionGroupListIn":["String"],"priceList":"String","priceListStartsWith":"String","priceListEndsWith":"String","priceListContains":"String","priceListLike":"String","priceListBetween":["String"],"priceListIn":["String"],"contractPrice":false}

HTTP/1.1 200 OK
Content-Type: application/xlsx
Content-Length: length

[{"orderNumber":"String","position":0,"productId":"String","description":"String","qtyOrdered":0,"salesPrice":0,"listPrice":0,"discount":0,"unitMeasure":"String","notes":"String","shipDate":"0001-01-01T00:00:00.0000000Z","cancelDate":"0001-01-01T00:00:00.0000000Z","manufacturerId":"String","poNumber":"String","terms":"String","shipMethod":"String","color":"String","creditCardNumber":"String","creditCardType":"String","creditCardName":"String","creditCardExpiration":"String","creditCardAVS":"String","creditCardAddress":"String","creditCardAddress2":"String","creditCardCity":"String","creditCardState":"String","creditCardZipcode":"String","creditCardCountry":"String","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","entered":"0001-01-01T00:00:00.0000000Z","category":"String","revision":0,"orderDiscount":0,"lineDiscount":0,"qtyBreakPrice":0,"priceOverride":0,"promoDiscount":0,"customerLevelPrice":0,"itemGroupDiscount":0,"customerContractPrice":0,"customerOrderLevelDiscount":0,"customerLineLevelDiscount":0,"customerLineLevelQty":0,"extendedTotal":0,"promoNote":"String","promoDollarAmount":0,"splitOrigSO":"String","promoCode":"String","qtyShipped":0,"subCategory":"String","warehouse":"String","kitComponent":false,"lineNotes":"String","brandId":"String","promoCode2":"String","comments":"String","salesRep":"String","reasonCode":"String","parentPosition":0,"status":"String","qtyAdjusted":false,"superCategory":"String","enforceESA":"String","esaDate":"0001-01-01T00:00:00.0000000Z","custom1DBL":0,"custom2DBL":0,"custom3DBL":0,"custom4DBL":0,"custom5DBL":0,"custom1INT":0,"custom2INT":0,"custom3INT":0,"custom4INT":0,"custom5INT":0,"upcharge":0,"qtyOpen":0,"diCost":"String","hts":"String","duty":"String","weight":"String","cube":"String","port":"String","upc":"String","caseDimensions":"String","warehouseId":"String","tagFor":"String","usedProductShipDate":false,"xmlOptions":"String","optionGroupList":"String","priceList":"String","contractPrice":false}]