JiwaAPI

<back to all web services

WH_TransferLineDetailsQuery

Requires Authentication
WH_TransferLineDetailsQuery Parameters:
NameParameterData TypeRequiredDescription
WH_TransferLineDetailsIDquerystringNo
WH_TransferLineDetailsIDStartsWithquerystringNo
WH_TransferLineDetailsIDEndsWithquerystringNo
WH_TransferLineDetailsIDContainsquerystringNo
WH_TransferLineDetailsIDLikequerystringNo
WH_TransferLineDetailsIDBetweenquerystring[]No
WH_TransferLineDetailsIDInquerystring[]No
WH_TransferLineIDquerystringNo
WH_TransferLineIDStartsWithquerystringNo
WH_TransferLineIDEndsWithquerystringNo
WH_TransferLineIDContainsquerystringNo
WH_TransferLineIDLikequerystringNo
WH_TransferLineIDBetweenquerystring[]No
WH_TransferLineIDInquerystring[]No
InventoryIDquerystringNo
InventoryIDStartsWithquerystringNo
InventoryIDEndsWithquerystringNo
InventoryIDContainsquerystringNo
InventoryIDLikequerystringNo
InventoryIDBetweenquerystring[]No
InventoryIDInquerystring[]No
Quantityquerydecimal?No
QuantityGreaterThanOrEqualToquerydecimal?No
QuantityGreaterThanquerydecimal?No
QuantityLessThanquerydecimal?No
QuantityLessThanOrEqualToquerydecimal?No
QuantityNotEqualToquerydecimal?No
QuantityBetweenqueryNullable<Decimal>[]No
QuantityInqueryNullable<Decimal>[]No
Costquerydecimal?No
CostGreaterThanOrEqualToquerydecimal?No
CostGreaterThanquerydecimal?No
CostLessThanquerydecimal?No
CostLessThanOrEqualToquerydecimal?No
CostNotEqualToquerydecimal?No
CostBetweenqueryNullable<Decimal>[]No
CostInqueryNullable<Decimal>[]No
SerialNoquerystringNo
SerialNoStartsWithquerystringNo
SerialNoEndsWithquerystringNo
SerialNoContainsquerystringNo
SerialNoLikequerystringNo
SerialNoBetweenquerystring[]No
SerialNoInquerystring[]No
IN_SOHIDquerystringNo
IN_SOHIDStartsWithquerystringNo
IN_SOHIDEndsWithquerystringNo
IN_SOHIDContainsquerystringNo
IN_SOHIDLikequerystringNo
IN_SOHIDBetweenquerystring[]No
IN_SOHIDInquerystring[]No
Source_IN_SOHIDquerystringNo
Source_IN_SOHIDStartsWithquerystringNo
Source_IN_SOHIDEndsWithquerystringNo
Source_IN_SOHIDContainsquerystringNo
Source_IN_SOHIDLikequerystringNo
Source_IN_SOHIDBetweenquerystring[]No
Source_IN_SOHIDInquerystring[]No
InTransit_IN_SOHIDquerystringNo
InTransit_IN_SOHIDStartsWithquerystringNo
InTransit_IN_SOHIDEndsWithquerystringNo
InTransit_IN_SOHIDContainsquerystringNo
InTransit_IN_SOHIDLikequerystringNo
InTransit_IN_SOHIDBetweenquerystring[]No
InTransit_IN_SOHIDInquerystring[]No
CostReceivedquerydecimal?No
CostReceivedGreaterThanOrEqualToquerydecimal?No
CostReceivedGreaterThanquerydecimal?No
CostReceivedLessThanquerydecimal?No
CostReceivedLessThanOrEqualToquerydecimal?No
CostReceivedNotEqualToquerydecimal?No
CostReceivedBetweenquerydecimal[]No
CostReceivedInquerydecimal[]No
QuantityReceivedquerydecimal?No
QuantityReceivedGreaterThanOrEqualToquerydecimal?No
QuantityReceivedGreaterThanquerydecimal?No
QuantityReceivedLessThanquerydecimal?No
QuantityReceivedLessThanOrEqualToquerydecimal?No
QuantityReceivedNotEqualToquerydecimal?No
QuantityReceivedBetweenquerydecimal[]No
QuantityReceivedInquerydecimal[]No
SerialNoInwardsquerystringNo
SerialNoInwardsStartsWithquerystringNo
SerialNoInwardsEndsWithquerystringNo
SerialNoInwardsContainsquerystringNo
SerialNoInwardsLikequerystringNo
SerialNoInwardsBetweenquerystring[]No
SerialNoInwardsInquerystring[]No
BinLocationquerystringNo
BinLocationStartsWithquerystringNo
BinLocationEndsWithquerystringNo
BinLocationContainsquerystringNo
BinLocationLikequerystringNo
BinLocationBetweenquerystring[]No
BinLocationInquerystring[]No
BinLocationInwardsquerystringNo
BinLocationInwardsStartsWithquerystringNo
BinLocationInwardsEndsWithquerystringNo
BinLocationInwardsContainsquerystringNo
BinLocationInwardsLikequerystringNo
BinLocationInwardsBetweenquerystring[]No
BinLocationInwardsInquerystring[]No
ExpiryDatequeryDateTime?No
ExpiryDateGreaterThanOrEqualToqueryDateTime?No
ExpiryDateGreaterThanqueryDateTime?No
ExpiryDateLessThanqueryDateTime?No
ExpiryDateLessThanOrEqualToqueryDateTime?No
ExpiryDateNotEqualToqueryDateTime?No
ExpiryDateBetweenqueryNullable<DateTime>[]No
ExpiryDateInqueryNullable<DateTime>[]No
ExpiryDateInwardsqueryDateTime?No
ExpiryDateInwardsGreaterThanOrEqualToqueryDateTime?No
ExpiryDateInwardsGreaterThanqueryDateTime?No
ExpiryDateInwardsLessThanqueryDateTime?No
ExpiryDateInwardsLessThanOrEqualToqueryDateTime?No
ExpiryDateInwardsNotEqualToqueryDateTime?No
ExpiryDateInwardsBetweenqueryNullable<DateTime>[]No
ExpiryDateInwardsInqueryNullable<DateTime>[]No
DateInqueryDateTime?No
DateInGreaterThanOrEqualToqueryDateTime?No
DateInGreaterThanqueryDateTime?No
DateInLessThanqueryDateTime?No
DateInLessThanOrEqualToqueryDateTime?No
DateInNotEqualToqueryDateTime?No
DateInBetweenqueryNullable<DateTime>[]No
DateInInqueryNullable<DateTime>[]No
SpecialPricequerydecimal?No
SpecialPriceGreaterThanOrEqualToquerydecimal?No
SpecialPriceGreaterThanquerydecimal?No
SpecialPriceLessThanquerydecimal?No
SpecialPriceLessThanOrEqualToquerydecimal?No
SpecialPriceNotEqualToquerydecimal?No
SpecialPriceBetweenquerydecimal[]No
SpecialPriceInquerydecimal[]No
AddedCostquerydecimal?No
AddedCostGreaterThanOrEqualToquerydecimal?No
AddedCostGreaterThanquerydecimal?No
AddedCostLessThanquerydecimal?No
AddedCostLessThanOrEqualToquerydecimal?No
AddedCostNotEqualToquerydecimal?No
AddedCostBetweenquerydecimal[]No
AddedCostInquerydecimal[]No
QueryBase Parameters:
NameParameterData TypeRequiredDescription
Skipformint?No
Takeformint?No
OrderByformstringNo
OrderByDescformstringNo
IncludeformstringNo
FieldsformstringNo
MetaformDictionary<string, string>No
WH_TransferLineDetails Parameters:
NameParameterData TypeRequiredDescription
WH_TransferLineDetailsIDformstringNo
WH_TransferLineIDformstringNo
InventoryIDformstringNo
Quantityformdecimal?No
Costformdecimal?No
SerialNoformstringNo
IN_SOHIDformstringNo
Source_IN_SOHIDformstringNo
InTransit_IN_SOHIDformstringNo
CostReceivedformdecimalNo
QuantityReceivedformdecimalNo
SerialNoInwardsformstringNo
BinLocationformstringNo
BinLocationInwardsformstringNo
ExpiryDateformDateTime?No
ExpiryDateInwardsformDateTime?No
DateInformDateTime?No
SpecialPriceformdecimalNo
AddedCostformdecimalNo
QueryResponse<T> Parameters:
NameParameterData TypeRequiredDescription
OffsetformintNo
TotalformintNo
ResultsformList<T>No
MetaformDictionary<string, string>No
ResponseStatusformResponseStatusNo

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.

POST /json/reply/WH_TransferLineDetailsQuery HTTP/1.1 
Host: api.jiwa.com.au 
Accept: application/json
Content-Type: application/json
Content-Length: length

{"WH_TransferLineDetailsID":"String","WH_TransferLineDetailsIDStartsWith":"String","WH_TransferLineDetailsIDEndsWith":"String","WH_TransferLineDetailsIDContains":"String","WH_TransferLineDetailsIDLike":"String","WH_TransferLineDetailsIDBetween":["String"],"WH_TransferLineDetailsIDIn":["String"],"WH_TransferLineID":"String","WH_TransferLineIDStartsWith":"String","WH_TransferLineIDEndsWith":"String","WH_TransferLineIDContains":"String","WH_TransferLineIDLike":"String","WH_TransferLineIDBetween":["String"],"WH_TransferLineIDIn":["String"],"InventoryID":"String","InventoryIDStartsWith":"String","InventoryIDEndsWith":"String","InventoryIDContains":"String","InventoryIDLike":"String","InventoryIDBetween":["String"],"InventoryIDIn":["String"],"Quantity":0,"QuantityGreaterThanOrEqualTo":0,"QuantityGreaterThan":0,"QuantityLessThan":0,"QuantityLessThanOrEqualTo":0,"QuantityNotEqualTo":0,"QuantityBetween":[0],"QuantityIn":[0],"Cost":0,"CostGreaterThanOrEqualTo":0,"CostGreaterThan":0,"CostLessThan":0,"CostLessThanOrEqualTo":0,"CostNotEqualTo":0,"CostBetween":[0],"CostIn":[0],"SerialNo":"String","SerialNoStartsWith":"String","SerialNoEndsWith":"String","SerialNoContains":"String","SerialNoLike":"String","SerialNoBetween":["String"],"SerialNoIn":["String"],"IN_SOHID":"String","IN_SOHIDStartsWith":"String","IN_SOHIDEndsWith":"String","IN_SOHIDContains":"String","IN_SOHIDLike":"String","IN_SOHIDBetween":["String"],"IN_SOHIDIn":["String"],"Source_IN_SOHID":"String","Source_IN_SOHIDStartsWith":"String","Source_IN_SOHIDEndsWith":"String","Source_IN_SOHIDContains":"String","Source_IN_SOHIDLike":"String","Source_IN_SOHIDBetween":["String"],"Source_IN_SOHIDIn":["String"],"InTransit_IN_SOHID":"String","InTransit_IN_SOHIDStartsWith":"String","InTransit_IN_SOHIDEndsWith":"String","InTransit_IN_SOHIDContains":"String","InTransit_IN_SOHIDLike":"String","InTransit_IN_SOHIDBetween":["String"],"InTransit_IN_SOHIDIn":["String"],"CostReceived":0,"CostReceivedGreaterThanOrEqualTo":0,"CostReceivedGreaterThan":0,"CostReceivedLessThan":0,"CostReceivedLessThanOrEqualTo":0,"CostReceivedNotEqualTo":0,"CostReceivedBetween":[0],"CostReceivedIn":[0],"QuantityReceived":0,"QuantityReceivedGreaterThanOrEqualTo":0,"QuantityReceivedGreaterThan":0,"QuantityReceivedLessThan":0,"QuantityReceivedLessThanOrEqualTo":0,"QuantityReceivedNotEqualTo":0,"QuantityReceivedBetween":[0],"QuantityReceivedIn":[0],"SerialNoInwards":"String","SerialNoInwardsStartsWith":"String","SerialNoInwardsEndsWith":"String","SerialNoInwardsContains":"String","SerialNoInwardsLike":"String","SerialNoInwardsBetween":["String"],"SerialNoInwardsIn":["String"],"BinLocation":"String","BinLocationStartsWith":"String","BinLocationEndsWith":"String","BinLocationContains":"String","BinLocationLike":"String","BinLocationBetween":["String"],"BinLocationIn":["String"],"BinLocationInwards":"String","BinLocationInwardsStartsWith":"String","BinLocationInwardsEndsWith":"String","BinLocationInwardsContains":"String","BinLocationInwardsLike":"String","BinLocationInwardsBetween":["String"],"BinLocationInwardsIn":["String"],"ExpiryDate":"0001-01-01T00:00:00.0000000","ExpiryDateGreaterThanOrEqualTo":"0001-01-01T00:00:00.0000000","ExpiryDateGreaterThan":"0001-01-01T00:00:00.0000000","ExpiryDateLessThan":"0001-01-01T00:00:00.0000000","ExpiryDateLessThanOrEqualTo":"0001-01-01T00:00:00.0000000","ExpiryDateNotEqualTo":"0001-01-01T00:00:00.0000000","ExpiryDateBetween":["0001-01-01T00:00:00.0000000"],"ExpiryDateIn":["0001-01-01T00:00:00.0000000"],"ExpiryDateInwards":"0001-01-01T00:00:00.0000000","ExpiryDateInwardsGreaterThanOrEqualTo":"0001-01-01T00:00:00.0000000","ExpiryDateInwardsGreaterThan":"0001-01-01T00:00:00.0000000","ExpiryDateInwardsLessThan":"0001-01-01T00:00:00.0000000","ExpiryDateInwardsLessThanOrEqualTo":"0001-01-01T00:00:00.0000000","ExpiryDateInwardsNotEqualTo":"0001-01-01T00:00:00.0000000","ExpiryDateInwardsBetween":["0001-01-01T00:00:00.0000000"],"ExpiryDateInwardsIn":["0001-01-01T00:00:00.0000000"],"DateIn":"0001-01-01T00:00:00.0000000","DateInGreaterThanOrEqualTo":"0001-01-01T00:00:00.0000000","DateInGreaterThan":"0001-01-01T00:00:00.0000000","DateInLessThan":"0001-01-01T00:00:00.0000000","DateInLessThanOrEqualTo":"0001-01-01T00:00:00.0000000","DateInNotEqualTo":"0001-01-01T00:00:00.0000000","DateInBetween":["0001-01-01T00:00:00.0000000"],"DateInIn":["0001-01-01T00:00:00.0000000"],"SpecialPrice":0,"SpecialPriceGreaterThanOrEqualTo":0,"SpecialPriceGreaterThan":0,"SpecialPriceLessThan":0,"SpecialPriceLessThanOrEqualTo":0,"SpecialPriceNotEqualTo":0,"SpecialPriceBetween":[0],"SpecialPriceIn":[0],"AddedCost":0,"AddedCostGreaterThanOrEqualTo":0,"AddedCostGreaterThan":0,"AddedCostLessThan":0,"AddedCostLessThanOrEqualTo":0,"AddedCostNotEqualTo":0,"AddedCostBetween":[0],"AddedCostIn":[0],"Skip":0,"Take":0,"OrderBy":"String","OrderByDesc":"String","Include":"String","Fields":"String","Meta":{"String":"String"}}
HTTP/1.1 200 OK
Content-Type: application/json
Content-Length: length

{"Results":[{"WH_TransferLineDetailsID":"String","WH_TransferLineID":"String","InventoryID":"String","Quantity":0,"Cost":0,"SerialNo":"String","IN_SOHID":"String","Source_IN_SOHID":"String","InTransit_IN_SOHID":"String","SerialNoInwards":"String","BinLocation":"String","BinLocationInwards":"String","ExpiryDate":"0001-01-01T00:00:00.0000000","ExpiryDateInwards":"0001-01-01T00:00:00.0000000","DateIn":"0001-01-01T00:00:00.0000000"}],"Meta":{"String":"String"},"ResponseStatus":{"ErrorCode":"String","Message":"String","StackTrace":"String","Errors":[{"ErrorCode":"String","FieldName":"String","Message":"String","Meta":{"String":"String"}}],"Meta":{"String":"String"}}}