JiwaAPI

<back to all web services

BO_ManualReleaseBatchLinesQuery

Requires Authentication
BO_ManualReleaseBatchLinesQuery Parameters:
NameParameterData TypeRequiredDescription
RecIDquerystringNo
RecIDStartsWithquerystringNo
RecIDEndsWithquerystringNo
RecIDContainsquerystringNo
RecIDLikequerystringNo
RecIDBetweenquerystring[]No
RecIDInquerystring[]No
BatchIDquerystringNo
BatchIDStartsWithquerystringNo
BatchIDEndsWithquerystringNo
BatchIDContainsquerystringNo
BatchIDLikequerystringNo
BatchIDBetweenquerystring[]No
BatchIDInquerystring[]No
LineNumberqueryint?No
LineNumberGreaterThanOrEqualToqueryint?No
LineNumberGreaterThanqueryint?No
LineNumberLessThanqueryint?No
LineNumberLessThanOrEqualToqueryint?No
LineNumberNotEqualToqueryint?No
LineNumberBetweenqueryint[]No
LineNumberInqueryint[]No
LastSavedDateTimequeryDateTime?No
LastSavedDateTimeGreaterThanOrEqualToqueryDateTime?No
LastSavedDateTimeGreaterThanqueryDateTime?No
LastSavedDateTimeLessThanqueryDateTime?No
LastSavedDateTimeLessThanOrEqualToqueryDateTime?No
LastSavedDateTimeNotEqualToqueryDateTime?No
LastSavedDateTimeBetweenqueryDateTime[]No
LastSavedDateTimeInqueryDateTime[]No
IN_OnBackOrder_OrdersOnBackIDquerystringNo
IN_OnBackOrder_OrdersOnBackIDStartsWithquerystringNo
IN_OnBackOrder_OrdersOnBackIDEndsWithquerystringNo
IN_OnBackOrder_OrdersOnBackIDContainsquerystringNo
IN_OnBackOrder_OrdersOnBackIDLikequerystringNo
IN_OnBackOrder_OrdersOnBackIDBetweenquerystring[]No
IN_OnBackOrder_OrdersOnBackIDInquerystring[]No
InventoryIDquerystringNo
InventoryIDStartsWithquerystringNo
InventoryIDEndsWithquerystringNo
InventoryIDContainsquerystringNo
InventoryIDLikequerystringNo
InventoryIDBetweenquerystring[]No
InventoryIDInquerystring[]No
PartNoquerystringNo
PartNoStartsWithquerystringNo
PartNoEndsWithquerystringNo
PartNoContainsquerystringNo
PartNoLikequerystringNo
PartNoBetweenquerystring[]No
PartNoInquerystring[]No
DescriptionquerystringNo
DescriptionStartsWithquerystringNo
DescriptionEndsWithquerystringNo
DescriptionContainsquerystringNo
DescriptionLikequerystringNo
DescriptionBetweenquerystring[]No
DescriptionInquerystring[]No
QuantityDecimalPlacesqueryint?No
QuantityDecimalPlacesGreaterThanOrEqualToqueryint?No
QuantityDecimalPlacesGreaterThanqueryint?No
QuantityDecimalPlacesLessThanqueryint?No
QuantityDecimalPlacesLessThanOrEqualToqueryint?No
QuantityDecimalPlacesNotEqualToqueryint?No
QuantityDecimalPlacesBetweenqueryint[]No
QuantityDecimalPlacesInqueryint[]No
BackOrderQuantityquerydecimal?No
BackOrderQuantityGreaterThanOrEqualToquerydecimal?No
BackOrderQuantityGreaterThanquerydecimal?No
BackOrderQuantityLessThanquerydecimal?No
BackOrderQuantityLessThanOrEqualToquerydecimal?No
BackOrderQuantityNotEqualToquerydecimal?No
BackOrderQuantityBetweenquerydecimal[]No
BackOrderQuantityInquerydecimal[]No
BackOrderValuequerydecimal?No
BackOrderValueGreaterThanOrEqualToquerydecimal?No
BackOrderValueGreaterThanquerydecimal?No
BackOrderValueLessThanquerydecimal?No
BackOrderValueLessThanOrEqualToquerydecimal?No
BackOrderValueNotEqualToquerydecimal?No
BackOrderValueBetweenquerydecimal[]No
BackOrderValueInquerydecimal[]No
QuantityAvailablequerydecimal?No
QuantityAvailableGreaterThanOrEqualToquerydecimal?No
QuantityAvailableGreaterThanquerydecimal?No
QuantityAvailableLessThanquerydecimal?No
QuantityAvailableLessThanOrEqualToquerydecimal?No
QuantityAvailableNotEqualToquerydecimal?No
QuantityAvailableBetweenquerydecimal[]No
QuantityAvailableInquerydecimal[]No
InvoiceInitDatequeryDateTime?No
InvoiceInitDateGreaterThanOrEqualToqueryDateTime?No
InvoiceInitDateGreaterThanqueryDateTime?No
InvoiceInitDateLessThanqueryDateTime?No
InvoiceInitDateLessThanOrEqualToqueryDateTime?No
InvoiceInitDateNotEqualToqueryDateTime?No
InvoiceInitDateBetweenqueryDateTime[]No
InvoiceInitDateInqueryDateTime[]No
ExpectedDeliveryDatequeryDateTime?No
ExpectedDeliveryDateGreaterThanOrEqualToqueryDateTime?No
ExpectedDeliveryDateGreaterThanqueryDateTime?No
ExpectedDeliveryDateLessThanqueryDateTime?No
ExpectedDeliveryDateLessThanOrEqualToqueryDateTime?No
ExpectedDeliveryDateNotEqualToqueryDateTime?No
ExpectedDeliveryDateBetweenqueryDateTime[]No
ExpectedDeliveryDateInqueryDateTime[]No
BackOrderPriorityquerystringNo
BackOrderPriorityStartsWithquerystringNo
BackOrderPriorityEndsWithquerystringNo
BackOrderPriorityContainsquerystringNo
BackOrderPriorityLikequerystringNo
BackOrderPriorityBetweenquerystring[]No
BackOrderPriorityInquerystring[]No
BackOrderPriorityWeightqueryint?No
BackOrderPriorityWeightGreaterThanOrEqualToqueryint?No
BackOrderPriorityWeightGreaterThanqueryint?No
BackOrderPriorityWeightLessThanqueryint?No
BackOrderPriorityWeightLessThanOrEqualToqueryint?No
BackOrderPriorityWeightNotEqualToqueryint?No
BackOrderPriorityWeightBetweenqueryint[]No
BackOrderPriorityWeightInqueryint[]No
DebtorIDquerystringNo
DebtorIDStartsWithquerystringNo
DebtorIDEndsWithquerystringNo
DebtorIDContainsquerystringNo
DebtorIDLikequerystringNo
DebtorIDBetweenquerystring[]No
DebtorIDInquerystring[]No
DebtorAccountNoquerystringNo
DebtorAccountNoStartsWithquerystringNo
DebtorAccountNoEndsWithquerystringNo
DebtorAccountNoContainsquerystringNo
DebtorAccountNoLikequerystringNo
DebtorAccountNoBetweenquerystring[]No
DebtorAccountNoInquerystring[]No
DebtorNamequerystringNo
DebtorNameStartsWithquerystringNo
DebtorNameEndsWithquerystringNo
DebtorNameContainsquerystringNo
DebtorNameLikequerystringNo
DebtorNameBetweenquerystring[]No
DebtorNameInquerystring[]No
InvoiceIDquerystringNo
InvoiceIDStartsWithquerystringNo
InvoiceIDEndsWithquerystringNo
InvoiceIDContainsquerystringNo
InvoiceIDLikequerystringNo
InvoiceIDBetweenquerystring[]No
InvoiceIDInquerystring[]No
InvoiceNoquerystringNo
InvoiceNoStartsWithquerystringNo
InvoiceNoEndsWithquerystringNo
InvoiceNoContainsquerystringNo
InvoiceNoLikequerystringNo
InvoiceNoBetweenquerystring[]No
InvoiceNoInquerystring[]No
InvoiceHistoryIDquerystringNo
InvoiceHistoryIDStartsWithquerystringNo
InvoiceHistoryIDEndsWithquerystringNo
InvoiceHistoryIDContainsquerystringNo
InvoiceHistoryIDLikequerystringNo
InvoiceHistoryIDBetweenquerystring[]No
InvoiceHistoryIDInquerystring[]No
HistoryNoqueryint?No
HistoryNoGreaterThanOrEqualToqueryint?No
HistoryNoGreaterThanqueryint?No
HistoryNoLessThanqueryint?No
HistoryNoLessThanOrEqualToqueryint?No
HistoryNoNotEqualToqueryint?No
HistoryNoBetweenqueryint[]No
HistoryNoInqueryint[]No
InvoiceLineIDquerystringNo
InvoiceLineIDStartsWithquerystringNo
InvoiceLineIDEndsWithquerystringNo
InvoiceLineIDContainsquerystringNo
InvoiceLineIDLikequerystringNo
InvoiceLineIDBetweenquerystring[]No
InvoiceLineIDInquerystring[]No
FulfillBackOrderFlagquerybool?No
KitTypequeryshort?No
KitTypeGreaterThanOrEqualToqueryshort?No
KitTypeGreaterThanqueryshort?No
KitTypeLessThanqueryshort?No
KitTypeLessThanOrEqualToqueryshort?No
KitTypeNotEqualToqueryshort?No
KitTypeBetweenqueryshort[]No
KitTypeInqueryshort[]No
BillTypequeryshort?No
BillTypeGreaterThanOrEqualToqueryshort?No
BillTypeGreaterThanqueryshort?No
BillTypeLessThanqueryshort?No
BillTypeLessThanOrEqualToqueryshort?No
BillTypeNotEqualToqueryshort?No
BillTypeBetweenqueryshort[]No
BillTypeInqueryshort[]No
WholesaleInvoicequeryshort?No
WholesaleInvoiceGreaterThanOrEqualToqueryshort?No
WholesaleInvoiceGreaterThanqueryshort?No
WholesaleInvoiceLessThanqueryshort?No
WholesaleInvoiceLessThanOrEqualToqueryshort?No
WholesaleInvoiceNotEqualToqueryshort?No
WholesaleInvoiceBetweenqueryshort[]No
WholesaleInvoiceInqueryshort[]No
OrderTypequeryshort?No
OrderTypeGreaterThanOrEqualToqueryshort?No
OrderTypeGreaterThanqueryshort?No
OrderTypeLessThanqueryshort?No
OrderTypeLessThanOrEqualToqueryshort?No
OrderTypeNotEqualToqueryshort?No
OrderTypeBetweenqueryshort[]No
OrderTypeInqueryshort[]No
ErrorMessagequerystringNo
ErrorMessageStartsWithquerystringNo
ErrorMessageEndsWithquerystringNo
ErrorMessageContainsquerystringNo
ErrorMessageLikequerystringNo
ErrorMessageBetweenquerystring[]No
ErrorMessageInquerystring[]No
QuantityLeftquerydecimal?No
QuantityLeftGreaterThanOrEqualToquerydecimal?No
QuantityLeftGreaterThanquerydecimal?No
QuantityLeftLessThanquerydecimal?No
QuantityLeftLessThanOrEqualToquerydecimal?No
QuantityLeftNotEqualToquerydecimal?No
QuantityLeftBetweenquerydecimal[]No
QuantityLeftInquerydecimal[]No
QueryBase Parameters:
NameParameterData TypeRequiredDescription
Skipformint?No
Takeformint?No
OrderByformstringNo
OrderByDescformstringNo
IncludeformstringNo
FieldsformstringNo
MetaformDictionary<string, string>No
BO_ManualReleaseBatchLines Parameters:
NameParameterData TypeRequiredDescription
RecIDformstringNo
BatchIDformstringNo
LineNumberformintNo
LastSavedDateTimeformDateTimeNo
IN_OnBackOrder_OrdersOnBackIDformstringNo
InventoryIDformstringNo
PartNoformstringNo
DescriptionformstringNo
QuantityDecimalPlacesformintNo
BackOrderQuantityformdecimalNo
BackOrderValueformdecimalNo
QuantityAvailableformdecimalNo
InvoiceInitDateformDateTimeNo
ExpectedDeliveryDateformDateTimeNo
BackOrderPriorityformstringNo
BackOrderPriorityWeightformintNo
DebtorIDformstringNo
DebtorAccountNoformstringNo
DebtorNameformstringNo
InvoiceIDformstringNo
InvoiceNoformstringNo
InvoiceHistoryIDformstringNo
HistoryNoformintNo
InvoiceLineIDformstringNo
FulfillBackOrderFlagformbool?No
KitTypeformshortNo
BillTypeformshortNo
WholesaleInvoiceformshortNo
OrderTypeformshortNo
ErrorMessageformstringNo
QuantityLeftformdecimalNo
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 .csv suffix or ?format=csv

HTTP + CSV

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

POST /csv/reply/BO_ManualReleaseBatchLinesQuery HTTP/1.1 
Host: api.jiwa.com.au 
Accept: text/csv
Content-Type: text/csv
Content-Length: length

{"RecID":"String","RecIDStartsWith":"String","RecIDEndsWith":"String","RecIDContains":"String","RecIDLike":"String","RecIDBetween":["String"],"RecIDIn":["String"],"BatchID":"String","BatchIDStartsWith":"String","BatchIDEndsWith":"String","BatchIDContains":"String","BatchIDLike":"String","BatchIDBetween":["String"],"BatchIDIn":["String"],"LineNumber":0,"LineNumberGreaterThanOrEqualTo":0,"LineNumberGreaterThan":0,"LineNumberLessThan":0,"LineNumberLessThanOrEqualTo":0,"LineNumberNotEqualTo":0,"LineNumberBetween":[0],"LineNumberIn":[0],"LastSavedDateTime":"0001-01-01T00:00:00.0000000","LastSavedDateTimeGreaterThanOrEqualTo":"0001-01-01T00:00:00.0000000","LastSavedDateTimeGreaterThan":"0001-01-01T00:00:00.0000000","LastSavedDateTimeLessThan":"0001-01-01T00:00:00.0000000","LastSavedDateTimeLessThanOrEqualTo":"0001-01-01T00:00:00.0000000","LastSavedDateTimeNotEqualTo":"0001-01-01T00:00:00.0000000","LastSavedDateTimeBetween":["0001-01-01T00:00:00.0000000"],"LastSavedDateTimeIn":["0001-01-01T00:00:00.0000000"],"IN_OnBackOrder_OrdersOnBackID":"String","IN_OnBackOrder_OrdersOnBackIDStartsWith":"String","IN_OnBackOrder_OrdersOnBackIDEndsWith":"String","IN_OnBackOrder_OrdersOnBackIDContains":"String","IN_OnBackOrder_OrdersOnBackIDLike":"String","IN_OnBackOrder_OrdersOnBackIDBetween":["String"],"IN_OnBackOrder_OrdersOnBackIDIn":["String"],"InventoryID":"String","InventoryIDStartsWith":"String","InventoryIDEndsWith":"String","InventoryIDContains":"String","InventoryIDLike":"String","InventoryIDBetween":["String"],"InventoryIDIn":["String"],"PartNo":"String","PartNoStartsWith":"String","PartNoEndsWith":"String","PartNoContains":"String","PartNoLike":"String","PartNoBetween":["String"],"PartNoIn":["String"],"Description":"String","DescriptionStartsWith":"String","DescriptionEndsWith":"String","DescriptionContains":"String","DescriptionLike":"String","DescriptionBetween":["String"],"DescriptionIn":["String"],"QuantityDecimalPlaces":0,"QuantityDecimalPlacesGreaterThanOrEqualTo":0,"QuantityDecimalPlacesGreaterThan":0,"QuantityDecimalPlacesLessThan":0,"QuantityDecimalPlacesLessThanOrEqualTo":0,"QuantityDecimalPlacesNotEqualTo":0,"QuantityDecimalPlacesBetween":[0],"QuantityDecimalPlacesIn":[0],"BackOrderQuantity":0,"BackOrderQuantityGreaterThanOrEqualTo":0,"BackOrderQuantityGreaterThan":0,"BackOrderQuantityLessThan":0,"BackOrderQuantityLessThanOrEqualTo":0,"BackOrderQuantityNotEqualTo":0,"BackOrderQuantityBetween":[0],"BackOrderQuantityIn":[0],"BackOrderValue":0,"BackOrderValueGreaterThanOrEqualTo":0,"BackOrderValueGreaterThan":0,"BackOrderValueLessThan":0,"BackOrderValueLessThanOrEqualTo":0,"BackOrderValueNotEqualTo":0,"BackOrderValueBetween":[0],"BackOrderValueIn":[0],"QuantityAvailable":0,"QuantityAvailableGreaterThanOrEqualTo":0,"QuantityAvailableGreaterThan":0,"QuantityAvailableLessThan":0,"QuantityAvailableLessThanOrEqualTo":0,"QuantityAvailableNotEqualTo":0,"QuantityAvailableBetween":[0],"QuantityAvailableIn":[0],"InvoiceInitDate":"0001-01-01T00:00:00.0000000","InvoiceInitDateGreaterThanOrEqualTo":"0001-01-01T00:00:00.0000000","InvoiceInitDateGreaterThan":"0001-01-01T00:00:00.0000000","InvoiceInitDateLessThan":"0001-01-01T00:00:00.0000000","InvoiceInitDateLessThanOrEqualTo":"0001-01-01T00:00:00.0000000","InvoiceInitDateNotEqualTo":"0001-01-01T00:00:00.0000000","InvoiceInitDateBetween":["0001-01-01T00:00:00.0000000"],"InvoiceInitDateIn":["0001-01-01T00:00:00.0000000"],"ExpectedDeliveryDate":"0001-01-01T00:00:00.0000000","ExpectedDeliveryDateGreaterThanOrEqualTo":"0001-01-01T00:00:00.0000000","ExpectedDeliveryDateGreaterThan":"0001-01-01T00:00:00.0000000","ExpectedDeliveryDateLessThan":"0001-01-01T00:00:00.0000000","ExpectedDeliveryDateLessThanOrEqualTo":"0001-01-01T00:00:00.0000000","ExpectedDeliveryDateNotEqualTo":"0001-01-01T00:00:00.0000000","ExpectedDeliveryDateBetween":["0001-01-01T00:00:00.0000000"],"ExpectedDeliveryDateIn":["0001-01-01T00:00:00.0000000"],"BackOrderPriority":"String","BackOrderPriorityStartsWith":"String","BackOrderPriorityEndsWith":"String","BackOrderPriorityContains":"String","BackOrderPriorityLike":"String","BackOrderPriorityBetween":["String"],"BackOrderPriorityIn":["String"],"BackOrderPriorityWeight":0,"BackOrderPriorityWeightGreaterThanOrEqualTo":0,"BackOrderPriorityWeightGreaterThan":0,"BackOrderPriorityWeightLessThan":0,"BackOrderPriorityWeightLessThanOrEqualTo":0,"BackOrderPriorityWeightNotEqualTo":0,"BackOrderPriorityWeightBetween":[0],"BackOrderPriorityWeightIn":[0],"DebtorID":"String","DebtorIDStartsWith":"String","DebtorIDEndsWith":"String","DebtorIDContains":"String","DebtorIDLike":"String","DebtorIDBetween":["String"],"DebtorIDIn":["String"],"DebtorAccountNo":"String","DebtorAccountNoStartsWith":"String","DebtorAccountNoEndsWith":"String","DebtorAccountNoContains":"String","DebtorAccountNoLike":"String","DebtorAccountNoBetween":["String"],"DebtorAccountNoIn":["String"],"DebtorName":"String","DebtorNameStartsWith":"String","DebtorNameEndsWith":"String","DebtorNameContains":"String","DebtorNameLike":"String","DebtorNameBetween":["String"],"DebtorNameIn":["String"],"InvoiceID":"String","InvoiceIDStartsWith":"String","InvoiceIDEndsWith":"String","InvoiceIDContains":"String","InvoiceIDLike":"String","InvoiceIDBetween":["String"],"InvoiceIDIn":["String"],"InvoiceNo":"String","InvoiceNoStartsWith":"String","InvoiceNoEndsWith":"String","InvoiceNoContains":"String","InvoiceNoLike":"String","InvoiceNoBetween":["String"],"InvoiceNoIn":["String"],"InvoiceHistoryID":"String","InvoiceHistoryIDStartsWith":"String","InvoiceHistoryIDEndsWith":"String","InvoiceHistoryIDContains":"String","InvoiceHistoryIDLike":"String","InvoiceHistoryIDBetween":["String"],"InvoiceHistoryIDIn":["String"],"HistoryNo":0,"HistoryNoGreaterThanOrEqualTo":0,"HistoryNoGreaterThan":0,"HistoryNoLessThan":0,"HistoryNoLessThanOrEqualTo":0,"HistoryNoNotEqualTo":0,"HistoryNoBetween":[0],"HistoryNoIn":[0],"InvoiceLineID":"String","InvoiceLineIDStartsWith":"String","InvoiceLineIDEndsWith":"String","InvoiceLineIDContains":"String","InvoiceLineIDLike":"String","InvoiceLineIDBetween":["String"],"InvoiceLineIDIn":["String"],"FulfillBackOrderFlag":false,"KitType":0,"KitTypeGreaterThanOrEqualTo":0,"KitTypeGreaterThan":0,"KitTypeLessThan":0,"KitTypeLessThanOrEqualTo":0,"KitTypeNotEqualTo":0,"KitTypeBetween":[0],"KitTypeIn":[0],"BillType":0,"BillTypeGreaterThanOrEqualTo":0,"BillTypeGreaterThan":0,"BillTypeLessThan":0,"BillTypeLessThanOrEqualTo":0,"BillTypeNotEqualTo":0,"BillTypeBetween":[0],"BillTypeIn":[0],"WholesaleInvoice":0,"WholesaleInvoiceGreaterThanOrEqualTo":0,"WholesaleInvoiceGreaterThan":0,"WholesaleInvoiceLessThan":0,"WholesaleInvoiceLessThanOrEqualTo":0,"WholesaleInvoiceNotEqualTo":0,"WholesaleInvoiceBetween":[0],"WholesaleInvoiceIn":[0],"OrderType":0,"OrderTypeGreaterThanOrEqualTo":0,"OrderTypeGreaterThan":0,"OrderTypeLessThan":0,"OrderTypeLessThanOrEqualTo":0,"OrderTypeNotEqualTo":0,"OrderTypeBetween":[0],"OrderTypeIn":[0],"ErrorMessage":"String","ErrorMessageStartsWith":"String","ErrorMessageEndsWith":"String","ErrorMessageContains":"String","ErrorMessageLike":"String","ErrorMessageBetween":["String"],"ErrorMessageIn":["String"],"QuantityLeft":0,"QuantityLeftGreaterThanOrEqualTo":0,"QuantityLeftGreaterThan":0,"QuantityLeftLessThan":0,"QuantityLeftLessThanOrEqualTo":0,"QuantityLeftNotEqualTo":0,"QuantityLeftBetween":[0],"QuantityLeftIn":[0],"Skip":0,"Take":0,"OrderBy":"String","OrderByDesc":"String","Include":"String","Fields":"String","Meta":{"String":"String"}}
HTTP/1.1 200 OK
Content-Type: text/csv
Content-Length: length

{"Results":[{"RecID":"String","BatchID":"String","IN_OnBackOrder_OrdersOnBackID":"String","InventoryID":"String","PartNo":"String","Description":"String","BackOrderPriority":"String","DebtorID":"String","DebtorAccountNo":"String","DebtorName":"String","InvoiceID":"String","InvoiceNo":"String","InvoiceHistoryID":"String","InvoiceLineID":"String","FulfillBackOrderFlag":false,"ErrorMessage":"String"}],"Meta":{"String":"String"},"ResponseStatus":{"ErrorCode":"String","Message":"String","StackTrace":"String","Errors":[{"ErrorCode":"String","FieldName":"String","Message":"String","Meta":{"String":"String"}}],"Meta":{"String":"String"}}}