Required role: | Administrator |
All Verbs | /service/DeleteSalesOrderLineRDB |
---|
Name | Parameter | Data Type | Required | Description |
---|---|---|---|---|
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
The following are sample HTTP requests and responses. The placeholders shown need to be replaced with actual values.
POST /service/DeleteSalesOrderLineRDB HTTP/1.1
Host: www.bernhardthospitality.com
Accept: application/vnd.openxmlformats-officedocument.spreadsheetml.sheet
Content-Type: application/vnd.openxmlformats-officedocument.spreadsheetml.sheet
Content-Length: length
{"skip":0,"take":0,"orderBy":"String","orderByDesc":"String","include":"String","fields":"String","meta":{"String":"String"},"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/vnd.openxmlformats-officedocument.spreadsheetml.sheet Content-Length: length 0