JiwaAPI

SO_LineDetailsQuery

The following routes are available for this service:
GET	/Queries/SO_LineDetails	Retrieves a list of sales order line details.

**SO_LineDetailsQuery** Parameters:
Name	Parameter	Data Type	Required
DetailsLineID	query	string	No
DetailsLineIDStartsWith	query	string	No
DetailsLineIDEndsWith	query	string	No
DetailsLineIDContains	query	string	No
DetailsLineIDLike	query	string	No
DetailsLineIDBetween	query	string[]	No
DetailsLineIDIn	query	string[]	No
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
InvoiceLineID	query	string	No
InvoiceLineIDStartsWith	query	string	No
InvoiceLineIDEndsWith	query	string	No
InvoiceLineIDContains	query	string	No
InvoiceLineIDLike	query	string	No
InvoiceLineIDBetween	query	string[]	No
InvoiceLineIDIn	query	string[]	No
SOHID	query	string	No
SOHIDStartsWith	query	string	No
SOHIDEndsWith	query	string	No
SOHIDContains	query	string	No
SOHIDLike	query	string	No
SOHIDBetween	query	string[]	No
SOHIDIn	query	string[]	No
Cost	query	decimal?	No
CostGreaterThanOrEqualTo	query	decimal?	No
CostGreaterThan	query	decimal?	No
CostLessThan	query	decimal?	No
CostLessThanOrEqualTo	query	decimal?	No
CostNotEqualTo	query	decimal?	No
CostBetween	query	Nullable<Decimal>[]	No
CostIn	query	Nullable<Decimal>[]	No
SpecialPrice	query	decimal?	No
SpecialPriceGreaterThanOrEqualTo	query	decimal?	No
SpecialPriceGreaterThan	query	decimal?	No
SpecialPriceLessThan	query	decimal?	No
SpecialPriceLessThanOrEqualTo	query	decimal?	No
SpecialPriceNotEqualTo	query	decimal?	No
SpecialPriceBetween	query	Nullable<Decimal>[]	No
SpecialPriceIn	query	Nullable<Decimal>[]	No
Quantity	query	decimal?	No
QuantityGreaterThanOrEqualTo	query	decimal?	No
QuantityGreaterThan	query	decimal?	No
QuantityLessThan	query	decimal?	No
QuantityLessThanOrEqualTo	query	decimal?	No
QuantityNotEqualTo	query	decimal?	No
QuantityBetween	query	Nullable<Decimal>[]	No
QuantityIn	query	Nullable<Decimal>[]	No
TaxPaid	query	decimal?	No
TaxPaidGreaterThanOrEqualTo	query	decimal?	No
TaxPaidGreaterThan	query	decimal?	No
TaxPaidLessThan	query	decimal?	No
TaxPaidLessThanOrEqualTo	query	decimal?	No
TaxPaidNotEqualTo	query	decimal?	No
TaxPaidBetween	query	Nullable<Decimal>[]	No
TaxPaidIn	query	Nullable<Decimal>[]	No
SerialNo	query	string	No
SerialNoStartsWith	query	string	No
SerialNoEndsWith	query	string	No
SerialNoContains	query	string	No
SerialNoLike	query	string	No
SerialNoBetween	query	string[]	No
SerialNoIn	query	string[]	No
ExpiryDate	query	DateTime?	No
ExpiryDateGreaterThanOrEqualTo	query	DateTime?	No
ExpiryDateGreaterThan	query	DateTime?	No
ExpiryDateLessThan	query	DateTime?	No
ExpiryDateLessThanOrEqualTo	query	DateTime?	No
ExpiryDateNotEqualTo	query	DateTime?	No
ExpiryDateBetween	query	Nullable<DateTime>[]	No
ExpiryDateIn	query	Nullable<DateTime>[]	No
BinLocation	query	string	No
BinLocationStartsWith	query	string	No
BinLocationEndsWith	query	string	No
BinLocationContains	query	string	No
BinLocationLike	query	string	No
BinLocationBetween	query	string[]	No
BinLocationIn	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_LineDetails** Parameters:
Name	Parameter	Data Type	Required
DetailsLineID	form	string	No
InvoiceHistoryID	form	string	No
InvoiceLineID	form	string	No
SOHID	form	string	No
Cost	form	decimal?	No
SpecialPrice	form	decimal?	No
Quantity	form	decimal?	No
TaxPaid	form	decimal?	No
SerialNo	form	string	No
ExpiryDate	form	DateTime?	No
BinLocation	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_LineDetails HTTP/1.1 
Host: localhost 
Accept: application/json

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

{"Results":[{"DetailsLineID":"String","InvoiceHistoryID":"String","InvoiceLineID":"String","SOHID":"String","Cost":0,"SpecialPrice":0,"Quantity":0,"TaxPaid":0,"SerialNo":"String","ExpiryDate":"0001-01-01T00:00:00.0000000","BinLocation":"String"}],"Meta":{"String":"String"},"ResponseStatus":{"ErrorCode":"String","Message":"String","StackTrace":"String","Errors":[{"ErrorCode":"String","FieldName":"String","Message":"String","Meta":{"String":"String"}}],"Meta":{"String":"String"}}}