JiwaAPI

SO_HistoryQuery

The following routes are available for this service:
GET	/Queries/SO_History	Retrieves a list of sales orders histories.

**SO_HistoryQuery** Parameters:
Name	Parameter	Data Type	Required
InvoiceHistoryID	query	string	No
InvoiceHistoryIDStartsWith	query	string	No
InvoiceHistoryIDEndsWith	query	string	No
InvoiceHistoryIDContains	query	string	No
InvoiceHistoryIDLike	query	string	No
InvoiceHistoryIDBetween	query	string[]	No
InvoiceHistoryIDIn	query	string[]	No
InvoiceID	query	string	No
InvoiceIDStartsWith	query	string	No
InvoiceIDEndsWith	query	string	No
InvoiceIDContains	query	string	No
InvoiceIDLike	query	string	No
InvoiceIDBetween	query	string[]	No
InvoiceIDIn	query	string[]	No
LastModifiedBy	query	string	No
LastModifiedByStartsWith	query	string	No
LastModifiedByEndsWith	query	string	No
LastModifiedByContains	query	string	No
LastModifiedByLike	query	string	No
LastModifiedByBetween	query	string[]	No
LastModifiedByIn	query	string[]	No
RecordDate	query	DateTime?	No
RecordDateGreaterThanOrEqualTo	query	DateTime?	No
RecordDateGreaterThan	query	DateTime?	No
RecordDateLessThan	query	DateTime?	No
RecordDateLessThanOrEqualTo	query	DateTime?	No
RecordDateNotEqualTo	query	DateTime?	No
RecordDateBetween	query	DateTime[]	No
RecordDateIn	query	DateTime[]	No
Ref	query	string	No
RefStartsWith	query	string	No
RefEndsWith	query	string	No
RefContains	query	string	No
RefLike	query	string	No
RefBetween	query	string[]	No
RefIn	query	string[]	No
HistoryNo	query	short?	No
HistoryNoGreaterThanOrEqualTo	query	short?	No
HistoryNoGreaterThan	query	short?	No
HistoryNoLessThan	query	short?	No
HistoryNoLessThanOrEqualTo	query	short?	No
HistoryNoNotEqualTo	query	short?	No
HistoryNoBetween	query	Nullable<Int16>[]	No
HistoryNoIn	query	Nullable<Int16>[]	No
HistoryTotal	query	decimal?	No
HistoryTotalGreaterThanOrEqualTo	query	decimal?	No
HistoryTotalGreaterThan	query	decimal?	No
HistoryTotalLessThan	query	decimal?	No
HistoryTotalLessThanOrEqualTo	query	decimal?	No
HistoryTotalNotEqualTo	query	decimal?	No
HistoryTotalBetween	query	Nullable<Decimal>[]	No
HistoryTotalIn	query	Nullable<Decimal>[]	No
DelAddress1	query	string	No
DelAddress1StartsWith	query	string	No
DelAddress1EndsWith	query	string	No
DelAddress1Contains	query	string	No
DelAddress1Like	query	string	No
DelAddress1Between	query	string[]	No
DelAddress1In	query	string[]	No
DelAddress2	query	string	No
DelAddress2StartsWith	query	string	No
DelAddress2EndsWith	query	string	No
DelAddress2Contains	query	string	No
DelAddress2Like	query	string	No
DelAddress2Between	query	string[]	No
DelAddress2In	query	string[]	No
DelAddress3	query	string	No
DelAddress3StartsWith	query	string	No
DelAddress3EndsWith	query	string	No
DelAddress3Contains	query	string	No
DelAddress3Like	query	string	No
DelAddress3Between	query	string[]	No
DelAddress3In	query	string[]	No
DelAddress4	query	string	No
DelAddress4StartsWith	query	string	No
DelAddress4EndsWith	query	string	No
DelAddress4Contains	query	string	No
DelAddress4Like	query	string	No
DelAddress4Between	query	string[]	No
DelAddress4In	query	string[]	No
PostCode	query	string	No
PostCodeStartsWith	query	string	No
PostCodeEndsWith	query	string	No
PostCodeContains	query	string	No
PostCodeLike	query	string	No
PostCodeBetween	query	string[]	No
PostCodeIn	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
CourierDetails	query	string	No
CourierDetailsStartsWith	query	string	No
CourierDetailsEndsWith	query	string	No
CourierDetailsContains	query	string	No
CourierDetailsLike	query	string	No
CourierDetailsBetween	query	string[]	No
CourierDetailsIn	query	string[]	No
PaymentTypeID	query	string	No
PaymentTypeIDStartsWith	query	string	No
PaymentTypeIDEndsWith	query	string	No
PaymentTypeIDContains	query	string	No
PaymentTypeIDLike	query	string	No
PaymentTypeIDBetween	query	string[]	No
PaymentTypeIDIn	query	string[]	No
PaymentRef	query	string	No
PaymentRefStartsWith	query	string	No
PaymentRefEndsWith	query	string	No
PaymentRefContains	query	string	No
PaymentRefLike	query	string	No
PaymentRefBetween	query	string[]	No
PaymentRefIn	query	string[]	No
AmountPaid	query	decimal?	No
AmountPaidGreaterThanOrEqualTo	query	decimal?	No
AmountPaidGreaterThan	query	decimal?	No
AmountPaidLessThan	query	decimal?	No
AmountPaidLessThanOrEqualTo	query	decimal?	No
AmountPaidNotEqualTo	query	decimal?	No
AmountPaidBetween	query	Nullable<Decimal>[]	No
AmountPaidIn	query	Nullable<Decimal>[]	No
RunNo	query	string	No
RunNoStartsWith	query	string	No
RunNoEndsWith	query	string	No
RunNoContains	query	string	No
RunNoLike	query	string	No
RunNoBetween	query	string[]	No
RunNoIn	query	string[]	No
CartageCharge1	query	decimal?	No
CartageCharge1GreaterThanOrEqualTo	query	decimal?	No
CartageCharge1GreaterThan	query	decimal?	No
CartageCharge1LessThan	query	decimal?	No
CartageCharge1LessThanOrEqualTo	query	decimal?	No
CartageCharge1NotEqualTo	query	decimal?	No
CartageCharge1Between	query	Nullable<Decimal>[]	No
CartageCharge1In	query	Nullable<Decimal>[]	No
CartageCharge2	query	decimal?	No
CartageCharge2GreaterThanOrEqualTo	query	decimal?	No
CartageCharge2GreaterThan	query	decimal?	No
CartageCharge2LessThan	query	decimal?	No
CartageCharge2LessThanOrEqualTo	query	decimal?	No
CartageCharge2NotEqualTo	query	decimal?	No
CartageCharge2Between	query	Nullable<Decimal>[]	No
CartageCharge2In	query	Nullable<Decimal>[]	No
CartageCharge3	query	decimal?	No
CartageCharge3GreaterThanOrEqualTo	query	decimal?	No
CartageCharge3GreaterThan	query	decimal?	No
CartageCharge3LessThan	query	decimal?	No
CartageCharge3LessThanOrEqualTo	query	decimal?	No
CartageCharge3NotEqualTo	query	decimal?	No
CartageCharge3Between	query	Nullable<Decimal>[]	No
CartageCharge3In	query	Nullable<Decimal>[]	No
DelContactName	query	string	No
DelContactNameStartsWith	query	string	No
DelContactNameEndsWith	query	string	No
DelContactNameContains	query	string	No
DelContactNameLike	query	string	No
DelContactNameBetween	query	string[]	No
DelContactNameIn	query	string[]	No
Delivered	query	bool?	No
DeliveredDate	query	DateTime?	No
DeliveredDateGreaterThanOrEqualTo	query	DateTime?	No
DeliveredDateGreaterThan	query	DateTime?	No
DeliveredDateLessThan	query	DateTime?	No
DeliveredDateLessThanOrEqualTo	query	DateTime?	No
DeliveredDateNotEqualTo	query	DateTime?	No
DeliveredDateBetween	query	Nullable<DateTime>[]	No
DeliveredDateIn	query	Nullable<DateTime>[]	No
Cartage1TaxRateID	query	string	No
Cartage1TaxRateIDStartsWith	query	string	No
Cartage1TaxRateIDEndsWith	query	string	No
Cartage1TaxRateIDContains	query	string	No
Cartage1TaxRateIDLike	query	string	No
Cartage1TaxRateIDBetween	query	string[]	No
Cartage1TaxRateIDIn	query	string[]	No
Cartage1TaxRate	query	decimal?	No
Cartage1TaxRateGreaterThanOrEqualTo	query	decimal?	No
Cartage1TaxRateGreaterThan	query	decimal?	No
Cartage1TaxRateLessThan	query	decimal?	No
Cartage1TaxRateLessThanOrEqualTo	query	decimal?	No
Cartage1TaxRateNotEqualTo	query	decimal?	No
Cartage1TaxRateBetween	query	Nullable<Decimal>[]	No
Cartage1TaxRateIn	query	Nullable<Decimal>[]	No
Cartage1TaxAmount	query	decimal?	No
Cartage1TaxAmountGreaterThanOrEqualTo	query	decimal?	No
Cartage1TaxAmountGreaterThan	query	decimal?	No
Cartage1TaxAmountLessThan	query	decimal?	No
Cartage1TaxAmountLessThanOrEqualTo	query	decimal?	No
Cartage1TaxAmountNotEqualTo	query	decimal?	No
Cartage1TaxAmountBetween	query	Nullable<Decimal>[]	No
Cartage1TaxAmountIn	query	Nullable<Decimal>[]	No
Cartage2TaxRateID	query	string	No
Cartage2TaxRateIDStartsWith	query	string	No
Cartage2TaxRateIDEndsWith	query	string	No
Cartage2TaxRateIDContains	query	string	No
Cartage2TaxRateIDLike	query	string	No
Cartage2TaxRateIDBetween	query	string[]	No
Cartage2TaxRateIDIn	query	string[]	No
Cartage2TaxRate	query	decimal?	No
Cartage2TaxRateGreaterThanOrEqualTo	query	decimal?	No
Cartage2TaxRateGreaterThan	query	decimal?	No
Cartage2TaxRateLessThan	query	decimal?	No
Cartage2TaxRateLessThanOrEqualTo	query	decimal?	No
Cartage2TaxRateNotEqualTo	query	decimal?	No
Cartage2TaxRateBetween	query	Nullable<Decimal>[]	No
Cartage2TaxRateIn	query	Nullable<Decimal>[]	No
Cartage2TaxAmount	query	decimal?	No
Cartage2TaxAmountGreaterThanOrEqualTo	query	decimal?	No
Cartage2TaxAmountGreaterThan	query	decimal?	No
Cartage2TaxAmountLessThan	query	decimal?	No
Cartage2TaxAmountLessThanOrEqualTo	query	decimal?	No
Cartage2TaxAmountNotEqualTo	query	decimal?	No
Cartage2TaxAmountBetween	query	Nullable<Decimal>[]	No
Cartage2TaxAmountIn	query	Nullable<Decimal>[]	No
Cartage3TaxRateID	query	string	No
Cartage3TaxRateIDStartsWith	query	string	No
Cartage3TaxRateIDEndsWith	query	string	No
Cartage3TaxRateIDContains	query	string	No
Cartage3TaxRateIDLike	query	string	No
Cartage3TaxRateIDBetween	query	string[]	No
Cartage3TaxRateIDIn	query	string[]	No
Cartage3TaxRate	query	decimal?	No
Cartage3TaxRateGreaterThanOrEqualTo	query	decimal?	No
Cartage3TaxRateGreaterThan	query	decimal?	No
Cartage3TaxRateLessThan	query	decimal?	No
Cartage3TaxRateLessThanOrEqualTo	query	decimal?	No
Cartage3TaxRateNotEqualTo	query	decimal?	No
Cartage3TaxRateBetween	query	Nullable<Decimal>[]	No
Cartage3TaxRateIn	query	Nullable<Decimal>[]	No
Cartage3TaxAmount	query	decimal?	No
Cartage3TaxAmountGreaterThanOrEqualTo	query	decimal?	No
Cartage3TaxAmountGreaterThan	query	decimal?	No
Cartage3TaxAmountLessThan	query	decimal?	No
Cartage3TaxAmountLessThanOrEqualTo	query	decimal?	No
Cartage3TaxAmountNotEqualTo	query	decimal?	No
Cartage3TaxAmountBetween	query	Nullable<Decimal>[]	No
Cartage3TaxAmountIn	query	Nullable<Decimal>[]	No
FreightForwardAddress1	query	string	No
FreightForwardAddress1StartsWith	query	string	No
FreightForwardAddress1EndsWith	query	string	No
FreightForwardAddress1Contains	query	string	No
FreightForwardAddress1Like	query	string	No
FreightForwardAddress1Between	query	string[]	No
FreightForwardAddress1In	query	string[]	No
FreightForwardAddress2	query	string	No
FreightForwardAddress2StartsWith	query	string	No
FreightForwardAddress2EndsWith	query	string	No
FreightForwardAddress2Contains	query	string	No
FreightForwardAddress2Like	query	string	No
FreightForwardAddress2Between	query	string[]	No
FreightForwardAddress2In	query	string[]	No
FreightForwardAddress3	query	string	No
FreightForwardAddress3StartsWith	query	string	No
FreightForwardAddress3EndsWith	query	string	No
FreightForwardAddress3Contains	query	string	No
FreightForwardAddress3Like	query	string	No
FreightForwardAddress3Between	query	string[]	No
FreightForwardAddress3In	query	string[]	No
FreightForwardAddress4	query	string	No
FreightForwardAddress4StartsWith	query	string	No
FreightForwardAddress4EndsWith	query	string	No
FreightForwardAddress4Contains	query	string	No
FreightForwardAddress4Like	query	string	No
FreightForwardAddress4Between	query	string[]	No
FreightForwardAddress4In	query	string[]	No
FreightForwardNotes	query	string	No
FreightForwardNotesStartsWith	query	string	No
FreightForwardNotesEndsWith	query	string	No
FreightForwardNotesContains	query	string	No
FreightForwardNotesLike	query	string	No
FreightForwardNotesBetween	query	string[]	No
FreightForwardNotesIn	query	string[]	No
DBTransID	query	string	No
DBTransIDStartsWith	query	string	No
DBTransIDEndsWith	query	string	No
DBTransIDContains	query	string	No
DBTransIDLike	query	string	No
DBTransIDBetween	query	string[]	No
DBTransIDIn	query	string[]	No
Status	query	byte?	No
StatusGreaterThanOrEqualTo	query	byte?	No
StatusGreaterThan	query	byte?	No
StatusLessThan	query	byte?	No
StatusLessThanOrEqualTo	query	byte?	No
StatusNotEqualTo	query	byte?	No
StatusBetween	query	Nullable<Byte>[]	No
StatusIn	query	Nullable<Byte>[]	No
EmailAddress	query	string	No
EmailAddressStartsWith	query	string	No
EmailAddressEndsWith	query	string	No
EmailAddressContains	query	string	No
EmailAddressLike	query	string	No
EmailAddressBetween	query	string[]	No
EmailAddressIn	query	string[]	No
ConsignmentNote	query	string	No
ConsignmentNoteStartsWith	query	string	No
ConsignmentNoteEndsWith	query	string	No
ConsignmentNoteContains	query	string	No
ConsignmentNoteLike	query	string	No
ConsignmentNoteBetween	query	string[]	No
ConsignmentNoteIn	query	string[]	No
EDIASNNumber	query	string	No
EDIASNNumberStartsWith	query	string	No
EDIASNNumberEndsWith	query	string	No
EDIASNNumberContains	query	string	No
EDIASNNumberLike	query	string	No
EDIASNNumberBetween	query	string[]	No
EDIASNNumberIn	query	string[]	No
EDIPickStatus	query	byte?	No
EDIPickStatusGreaterThanOrEqualTo	query	byte?	No
EDIPickStatusGreaterThan	query	byte?	No
EDIPickStatusLessThan	query	byte?	No
EDIPickStatusLessThanOrEqualTo	query	byte?	No
EDIPickStatusNotEqualTo	query	byte?	No
EDIPickStatusBetween	query	Nullable<Byte>[]	No
EDIPickStatusIn	query	Nullable<Byte>[]	No
DateCreated	query	DateTime?	No
DateCreatedGreaterThanOrEqualTo	query	DateTime?	No
DateCreatedGreaterThan	query	DateTime?	No
DateCreatedLessThan	query	DateTime?	No
DateCreatedLessThanOrEqualTo	query	DateTime?	No
DateCreatedNotEqualTo	query	DateTime?	No
DateCreatedBetween	query	Nullable<DateTime>[]	No
DateCreatedIn	query	Nullable<DateTime>[]	No
DateLastSaved	query	DateTime?	No
DateLastSavedGreaterThanOrEqualTo	query	DateTime?	No
DateLastSavedGreaterThan	query	DateTime?	No
DateLastSavedLessThan	query	DateTime?	No
DateLastSavedLessThanOrEqualTo	query	DateTime?	No
DateLastSavedNotEqualTo	query	DateTime?	No
DateLastSavedBetween	query	Nullable<DateTime>[]	No
DateLastSavedIn	query	Nullable<DateTime>[]	No
DatePosted	query	DateTime?	No
DatePostedGreaterThanOrEqualTo	query	DateTime?	No
DatePostedGreaterThan	query	DateTime?	No
DatePostedLessThan	query	DateTime?	No
DatePostedLessThanOrEqualTo	query	DateTime?	No
DatePostedNotEqualTo	query	DateTime?	No
DatePostedBetween	query	Nullable<DateTime>[]	No
DatePostedIn	query	Nullable<DateTime>[]	No
DateProcessed	query	DateTime?	No
DateProcessedGreaterThanOrEqualTo	query	DateTime?	No
DateProcessedGreaterThan	query	DateTime?	No
DateProcessedLessThan	query	DateTime?	No
DateProcessedLessThanOrEqualTo	query	DateTime?	No
DateProcessedNotEqualTo	query	DateTime?	No
DateProcessedBetween	query	Nullable<DateTime>[]	No
DateProcessedIn	query	Nullable<DateTime>[]	No
DropShipment	query	bool?	No
DeliveryAddressee	query	string	No
DeliveryAddresseeStartsWith	query	string	No
DeliveryAddresseeEndsWith	query	string	No
DeliveryAddresseeContains	query	string	No
DeliveryAddresseeLike	query	string	No
DeliveryAddresseeBetween	query	string[]	No
DeliveryAddresseeIn	query	string[]	No
DeliveryAddressCountry	query	string	No
DeliveryAddressCountryStartsWith	query	string	No
DeliveryAddressCountryEndsWith	query	string	No
DeliveryAddressCountryContains	query	string	No
DeliveryAddressCountryLike	query	string	No
DeliveryAddressCountryBetween	query	string[]	No
DeliveryAddressCountryIn	query	string[]	No
FreightForwardAddressCountry	query	string	No
FreightForwardAddressCountryStartsWith	query	string	No
FreightForwardAddressCountryEndsWith	query	string	No
FreightForwardAddressCountryContains	query	string	No
FreightForwardAddressCountryLike	query	string	No
FreightForwardAddressCountryBetween	query	string[]	No
FreightForwardAddressCountryIn	query	string[]	No

**QueryBase** Parameters:
Name	Parameter	Data Type	Required
Skip	form	int?	No
Take	form	int?	No
OrderBy	form	string	No
OrderByDesc	form	string	No
Include	form	string	No
Fields	form	string	No
Meta	form	Dictionary<string, string>	No

**SO_History** Parameters:
Name	Parameter	Data Type	Required
InvoiceHistoryID	form	string	No
InvoiceID	form	string	No
LastModifiedBy	form	string	No
RecordDate	form	DateTime	No
Ref	form	string	No
HistoryNo	form	short?	No
HistoryTotal	form	decimal?	No
DelAddress1	form	string	No
DelAddress2	form	string	No
DelAddress3	form	string	No
DelAddress4	form	string	No
PostCode	form	string	No
Notes	form	string	No
CourierDetails	form	string	No
PaymentTypeID	form	string	No
PaymentRef	form	string	No
AmountPaid	form	decimal?	No
RunNo	form	string	No
CartageCharge1	form	decimal?	No
CartageCharge2	form	decimal?	No
CartageCharge3	form	decimal?	No
DelContactName	form	string	No
Delivered	form	bool	No
DeliveredDate	form	DateTime?	No
Cartage1TaxRateID	form	string	No
Cartage1TaxRate	form	decimal?	No
Cartage1TaxAmount	form	decimal?	No
Cartage2TaxRateID	form	string	No
Cartage2TaxRate	form	decimal?	No
Cartage2TaxAmount	form	decimal?	No
Cartage3TaxRateID	form	string	No
Cartage3TaxRate	form	decimal?	No
Cartage3TaxAmount	form	decimal?	No
FreightForwardAddress1	form	string	No
FreightForwardAddress2	form	string	No
FreightForwardAddress3	form	string	No
FreightForwardAddress4	form	string	No
FreightForwardNotes	form	string	No
DBTransID	form	string	No
Status	form	byte?	No
EmailAddress	form	string	No
ConsignmentNote	form	string	No
EDIASNNumber	form	string	No
EDIPickStatus	form	byte?	No
DateCreated	form	DateTime?	No
DateLastSaved	form	DateTime?	No
DatePosted	form	DateTime?	No
DateProcessed	form	DateTime?	No
DropShipment	form	bool	No
DeliveryAddressee	form	string	No
DeliveryAddressCountry	form	string	No
FreightForwardAddressCountry	form	string	No

**QueryResponse<T>** Parameters:
Name	Parameter	Data Type	Required
Offset	form	int	No
Total	form	int	No
Results	form	List<T>	No
Meta	form	Dictionary<string, string>	No
ResponseStatus	form	ResponseStatus	No

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

To embed the response in a jsonp callback, append ?callback=myCallback

HTTP + JSON

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

GET /Queries/SO_History HTTP/1.1 
Host: localhost 
Accept: application/json

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

{"Results":[{"InvoiceHistoryID":"String","InvoiceID":"String","LastModifiedBy":"String","Ref":"String","HistoryNo":0,"HistoryTotal":0,"DelAddress1":"String","DelAddress2":"String","DelAddress3":"String","DelAddress4":"String","PostCode":"String","Notes":"String","CourierDetails":"String","PaymentTypeID":"String","PaymentRef":"String","AmountPaid":0,"RunNo":"String","CartageCharge1":0,"CartageCharge2":0,"CartageCharge3":0,"DelContactName":"String","DeliveredDate":"0001-01-01T00:00:00.0000000","Cartage1TaxRateID":"String","Cartage1TaxRate":0,"Cartage1TaxAmount":0,"Cartage2TaxRateID":"String","Cartage2TaxRate":0,"Cartage2TaxAmount":0,"Cartage3TaxRateID":"String","Cartage3TaxRate":0,"Cartage3TaxAmount":0,"FreightForwardAddress1":"String","FreightForwardAddress2":"String","FreightForwardAddress3":"String","FreightForwardAddress4":"String","FreightForwardNotes":"String","DBTransID":"String","Status":0,"EmailAddress":"String","ConsignmentNote":"String","EDIASNNumber":"String","EDIPickStatus":0,"DateCreated":"0001-01-01T00:00:00.0000000","DateLastSaved":"0001-01-01T00:00:00.0000000","DatePosted":"0001-01-01T00:00:00.0000000","DateProcessed":"0001-01-01T00:00:00.0000000","DeliveryAddressee":"String","DeliveryAddressCountry":"String","FreightForwardAddressCountry":"String"}],"Meta":{"String":"String"},"ResponseStatus":{"ErrorCode":"String","Message":"String","StackTrace":"String","Errors":[{"ErrorCode":"String","FieldName":"String","Message":"String","Meta":{"String":"String"}}],"Meta":{"String":"String"}}}