JiwaAPI

<back to all web services

PO_BatchPurchaseOrderLinesQuery

Requires Authentication
PO_BatchPurchaseOrderLinesQuery Parameters:
NameParameterData TypeRequiredDescription
RecIDquerystringNo
RecIDStartsWithquerystringNo
RecIDEndsWithquerystringNo
RecIDContainsquerystringNo
RecIDLikequerystringNo
RecIDBetweenquerystring[]No
RecIDInquerystring[]No
PO_BatchPurchaseOrders_RecIDquerystringNo
PO_BatchPurchaseOrders_RecIDStartsWithquerystringNo
PO_BatchPurchaseOrders_RecIDEndsWithquerystringNo
PO_BatchPurchaseOrders_RecIDContainsquerystringNo
PO_BatchPurchaseOrders_RecIDLikequerystringNo
PO_BatchPurchaseOrders_RecIDBetweenquerystring[]No
PO_BatchPurchaseOrders_RecIDInquerystring[]No
ItemNoqueryint?No
ItemNoGreaterThanOrEqualToqueryint?No
ItemNoGreaterThanqueryint?No
ItemNoLessThanqueryint?No
ItemNoLessThanOrEqualToqueryint?No
ItemNoNotEqualToqueryint?No
ItemNoBetweenqueryint[]No
ItemNoInqueryint[]No
IN_Main_RecIDquerystringNo
IN_Main_RecIDStartsWithquerystringNo
IN_Main_RecIDEndsWithquerystringNo
IN_Main_RecIDContainsquerystringNo
IN_Main_RecIDLikequerystringNo
IN_Main_RecIDBetweenquerystring[]No
IN_Main_RecIDInquerystring[]No
UnitCostquerydecimal?No
UnitCostGreaterThanOrEqualToquerydecimal?No
UnitCostGreaterThanquerydecimal?No
UnitCostLessThanquerydecimal?No
UnitCostLessThanOrEqualToquerydecimal?No
UnitCostNotEqualToquerydecimal?No
UnitCostBetweenquerydecimal[]No
UnitCostInquerydecimal[]No
FXUnitCostquerydecimal?No
FXUnitCostGreaterThanOrEqualToquerydecimal?No
FXUnitCostGreaterThanquerydecimal?No
FXUnitCostLessThanquerydecimal?No
FXUnitCostLessThanOrEqualToquerydecimal?No
FXUnitCostNotEqualToquerydecimal?No
FXUnitCostBetweenquerydecimal[]No
FXUnitCostInquerydecimal[]No
SuggestedOrderQuantityquerydecimal?No
SuggestedOrderQuantityGreaterThanOrEqualToquerydecimal?No
SuggestedOrderQuantityGreaterThanquerydecimal?No
SuggestedOrderQuantityLessThanquerydecimal?No
SuggestedOrderQuantityLessThanOrEqualToquerydecimal?No
SuggestedOrderQuantityNotEqualToquerydecimal?No
SuggestedOrderQuantityBetweenquerydecimal[]No
SuggestedOrderQuantityInquerydecimal[]No
OrderQuantityquerydecimal?No
OrderQuantityGreaterThanOrEqualToquerydecimal?No
OrderQuantityGreaterThanquerydecimal?No
OrderQuantityLessThanquerydecimal?No
OrderQuantityLessThanOrEqualToquerydecimal?No
OrderQuantityNotEqualToquerydecimal?No
OrderQuantityBetweenquerydecimal[]No
OrderQuantityInquerydecimal[]No
LineCostquerydecimal?No
LineCostGreaterThanOrEqualToquerydecimal?No
LineCostGreaterThanquerydecimal?No
LineCostLessThanquerydecimal?No
LineCostLessThanOrEqualToquerydecimal?No
LineCostNotEqualToquerydecimal?No
LineCostBetweenquerydecimal[]No
LineCostInquerydecimal[]No
FXLineCostquerydecimal?No
FXLineCostGreaterThanOrEqualToquerydecimal?No
FXLineCostGreaterThanquerydecimal?No
FXLineCostLessThanquerydecimal?No
FXLineCostLessThanOrEqualToquerydecimal?No
FXLineCostNotEqualToquerydecimal?No
FXLineCostBetweenquerydecimal[]No
FXLineCostInquerydecimal[]No
QuantitySOHquerydecimal?No
QuantitySOHGreaterThanOrEqualToquerydecimal?No
QuantitySOHGreaterThanquerydecimal?No
QuantitySOHLessThanquerydecimal?No
QuantitySOHLessThanOrEqualToquerydecimal?No
QuantitySOHNotEqualToquerydecimal?No
QuantitySOHBetweenquerydecimal[]No
QuantitySOHInquerydecimal[]No
QuantityMinSOHquerydecimal?No
QuantityMinSOHGreaterThanOrEqualToquerydecimal?No
QuantityMinSOHGreaterThanquerydecimal?No
QuantityMinSOHLessThanquerydecimal?No
QuantityMinSOHLessThanOrEqualToquerydecimal?No
QuantityMinSOHNotEqualToquerydecimal?No
QuantityMinSOHBetweenquerydecimal[]No
QuantityMinSOHInquerydecimal[]No
QuantityOnPOquerydecimal?No
QuantityOnPOGreaterThanOrEqualToquerydecimal?No
QuantityOnPOGreaterThanquerydecimal?No
QuantityOnPOLessThanquerydecimal?No
QuantityOnPOLessThanOrEqualToquerydecimal?No
QuantityOnPONotEqualToquerydecimal?No
QuantityOnPOBetweenquerydecimal[]No
QuantityOnPOInquerydecimal[]No
QuantityOnBOquerydecimal?No
QuantityOnBOGreaterThanOrEqualToquerydecimal?No
QuantityOnBOGreaterThanquerydecimal?No
QuantityOnBOLessThanquerydecimal?No
QuantityOnBOLessThanOrEqualToquerydecimal?No
QuantityOnBONotEqualToquerydecimal?No
QuantityOnBOBetweenquerydecimal[]No
QuantityOnBOInquerydecimal[]No
QuantitySalesForecastquerydecimal?No
QuantitySalesForecastGreaterThanOrEqualToquerydecimal?No
QuantitySalesForecastGreaterThanquerydecimal?No
QuantitySalesForecastLessThanquerydecimal?No
QuantitySalesForecastLessThanOrEqualToquerydecimal?No
QuantitySalesForecastNotEqualToquerydecimal?No
QuantitySalesForecastBetweenquerydecimal[]No
QuantitySalesForecastInquerydecimal[]No
QuantityLastYearPurchasesquerydecimal?No
QuantityLastYearPurchasesGreaterThanOrEqualToquerydecimal?No
QuantityLastYearPurchasesGreaterThanquerydecimal?No
QuantityLastYearPurchasesLessThanquerydecimal?No
QuantityLastYearPurchasesLessThanOrEqualToquerydecimal?No
QuantityLastYearPurchasesNotEqualToquerydecimal?No
QuantityLastYearPurchasesBetweenquerydecimal[]No
QuantityLastYearPurchasesInquerydecimal[]No
QuantityLastYearSalesquerydecimal?No
QuantityLastYearSalesGreaterThanOrEqualToquerydecimal?No
QuantityLastYearSalesGreaterThanquerydecimal?No
QuantityLastYearSalesLessThanquerydecimal?No
QuantityLastYearSalesLessThanOrEqualToquerydecimal?No
QuantityLastYearSalesNotEqualToquerydecimal?No
QuantityLastYearSalesBetweenquerydecimal[]No
QuantityLastYearSalesInquerydecimal[]No
PO_Lines_RecIDquerystringNo
PO_Lines_RecIDStartsWithquerystringNo
PO_Lines_RecIDEndsWithquerystringNo
PO_Lines_RecIDContainsquerystringNo
PO_Lines_RecIDLikequerystringNo
PO_Lines_RecIDBetweenquerystring[]No
PO_Lines_RecIDInquerystring[]No
UnitCubicquerydecimal?No
UnitCubicGreaterThanOrEqualToquerydecimal?No
UnitCubicGreaterThanquerydecimal?No
UnitCubicLessThanquerydecimal?No
UnitCubicLessThanOrEqualToquerydecimal?No
UnitCubicNotEqualToquerydecimal?No
UnitCubicBetweenquerydecimal[]No
UnitCubicInquerydecimal[]No
UnitWeightquerydecimal?No
UnitWeightGreaterThanOrEqualToquerydecimal?No
UnitWeightGreaterThanquerydecimal?No
UnitWeightLessThanquerydecimal?No
UnitWeightLessThanOrEqualToquerydecimal?No
UnitWeightNotEqualToquerydecimal?No
UnitWeightBetweenquerydecimal[]No
UnitWeightInquerydecimal[]No
LineCubicquerydecimal?No
LineCubicGreaterThanOrEqualToquerydecimal?No
LineCubicGreaterThanquerydecimal?No
LineCubicLessThanquerydecimal?No
LineCubicLessThanOrEqualToquerydecimal?No
LineCubicNotEqualToquerydecimal?No
LineCubicBetweenquerydecimal[]No
LineCubicInquerydecimal[]No
LineWeightquerydecimal?No
LineWeightGreaterThanOrEqualToquerydecimal?No
LineWeightGreaterThanquerydecimal?No
LineWeightLessThanquerydecimal?No
LineWeightLessThanOrEqualToquerydecimal?No
LineWeightNotEqualToquerydecimal?No
LineWeightBetweenquerydecimal[]No
LineWeightInquerydecimal[]No
DeliveryDaysqueryint?No
DeliveryDaysGreaterThanOrEqualToqueryint?No
DeliveryDaysGreaterThanqueryint?No
DeliveryDaysLessThanqueryint?No
DeliveryDaysLessThanOrEqualToqueryint?No
DeliveryDaysNotEqualToqueryint?No
DeliveryDaysBetweenqueryint[]No
DeliveryDaysInqueryint[]No
OrderUnitsquerydecimal?No
OrderUnitsGreaterThanOrEqualToquerydecimal?No
OrderUnitsGreaterThanquerydecimal?No
OrderUnitsLessThanquerydecimal?No
OrderUnitsLessThanOrEqualToquerydecimal?No
OrderUnitsNotEqualToquerydecimal?No
OrderUnitsBetweenquerydecimal[]No
OrderUnitsInquerydecimal[]No
RowHashquerybyte[]No
QueryBase Parameters:
NameParameterData TypeRequiredDescription
Skipformint?No
Takeformint?No
OrderByformstringNo
OrderByDescformstringNo
IncludeformstringNo
FieldsformstringNo
MetaformDictionary<string, string>No
PO_BatchPurchaseOrderLines Parameters:
NameParameterData TypeRequiredDescription
RecIDformstringNo
PO_BatchPurchaseOrders_RecIDformstringNo
ItemNoformintNo
IN_Main_RecIDformstringNo
UnitCostformdecimalNo
FXUnitCostformdecimalNo
SuggestedOrderQuantityformdecimalNo
OrderQuantityformdecimalNo
LineCostformdecimalNo
FXLineCostformdecimalNo
QuantitySOHformdecimalNo
QuantityMinSOHformdecimalNo
QuantityOnPOformdecimalNo
QuantityOnBOformdecimalNo
QuantitySalesForecastformdecimalNo
QuantityLastYearPurchasesformdecimalNo
QuantityLastYearSalesformdecimalNo
PO_Lines_RecIDformstringNo
UnitCubicformdecimalNo
UnitWeightformdecimalNo
LineCubicformdecimalNo
LineWeightformdecimalNo
DeliveryDaysformintNo
OrderUnitsformdecimalNo
RowHashformbyte[]No
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/PO_BatchPurchaseOrderLinesQuery HTTP/1.1 
Host: api.jiwa.com.au 
Accept: application/json
Content-Type: application/json
Content-Length: length

{"RecID":"String","RecIDStartsWith":"String","RecIDEndsWith":"String","RecIDContains":"String","RecIDLike":"String","RecIDBetween":["String"],"RecIDIn":["String"],"PO_BatchPurchaseOrders_RecID":"String","PO_BatchPurchaseOrders_RecIDStartsWith":"String","PO_BatchPurchaseOrders_RecIDEndsWith":"String","PO_BatchPurchaseOrders_RecIDContains":"String","PO_BatchPurchaseOrders_RecIDLike":"String","PO_BatchPurchaseOrders_RecIDBetween":["String"],"PO_BatchPurchaseOrders_RecIDIn":["String"],"ItemNo":0,"ItemNoGreaterThanOrEqualTo":0,"ItemNoGreaterThan":0,"ItemNoLessThan":0,"ItemNoLessThanOrEqualTo":0,"ItemNoNotEqualTo":0,"ItemNoBetween":[0],"ItemNoIn":[0],"IN_Main_RecID":"String","IN_Main_RecIDStartsWith":"String","IN_Main_RecIDEndsWith":"String","IN_Main_RecIDContains":"String","IN_Main_RecIDLike":"String","IN_Main_RecIDBetween":["String"],"IN_Main_RecIDIn":["String"],"UnitCost":0,"UnitCostGreaterThanOrEqualTo":0,"UnitCostGreaterThan":0,"UnitCostLessThan":0,"UnitCostLessThanOrEqualTo":0,"UnitCostNotEqualTo":0,"UnitCostBetween":[0],"UnitCostIn":[0],"FXUnitCost":0,"FXUnitCostGreaterThanOrEqualTo":0,"FXUnitCostGreaterThan":0,"FXUnitCostLessThan":0,"FXUnitCostLessThanOrEqualTo":0,"FXUnitCostNotEqualTo":0,"FXUnitCostBetween":[0],"FXUnitCostIn":[0],"SuggestedOrderQuantity":0,"SuggestedOrderQuantityGreaterThanOrEqualTo":0,"SuggestedOrderQuantityGreaterThan":0,"SuggestedOrderQuantityLessThan":0,"SuggestedOrderQuantityLessThanOrEqualTo":0,"SuggestedOrderQuantityNotEqualTo":0,"SuggestedOrderQuantityBetween":[0],"SuggestedOrderQuantityIn":[0],"OrderQuantity":0,"OrderQuantityGreaterThanOrEqualTo":0,"OrderQuantityGreaterThan":0,"OrderQuantityLessThan":0,"OrderQuantityLessThanOrEqualTo":0,"OrderQuantityNotEqualTo":0,"OrderQuantityBetween":[0],"OrderQuantityIn":[0],"LineCost":0,"LineCostGreaterThanOrEqualTo":0,"LineCostGreaterThan":0,"LineCostLessThan":0,"LineCostLessThanOrEqualTo":0,"LineCostNotEqualTo":0,"LineCostBetween":[0],"LineCostIn":[0],"FXLineCost":0,"FXLineCostGreaterThanOrEqualTo":0,"FXLineCostGreaterThan":0,"FXLineCostLessThan":0,"FXLineCostLessThanOrEqualTo":0,"FXLineCostNotEqualTo":0,"FXLineCostBetween":[0],"FXLineCostIn":[0],"QuantitySOH":0,"QuantitySOHGreaterThanOrEqualTo":0,"QuantitySOHGreaterThan":0,"QuantitySOHLessThan":0,"QuantitySOHLessThanOrEqualTo":0,"QuantitySOHNotEqualTo":0,"QuantitySOHBetween":[0],"QuantitySOHIn":[0],"QuantityMinSOH":0,"QuantityMinSOHGreaterThanOrEqualTo":0,"QuantityMinSOHGreaterThan":0,"QuantityMinSOHLessThan":0,"QuantityMinSOHLessThanOrEqualTo":0,"QuantityMinSOHNotEqualTo":0,"QuantityMinSOHBetween":[0],"QuantityMinSOHIn":[0],"QuantityOnPO":0,"QuantityOnPOGreaterThanOrEqualTo":0,"QuantityOnPOGreaterThan":0,"QuantityOnPOLessThan":0,"QuantityOnPOLessThanOrEqualTo":0,"QuantityOnPONotEqualTo":0,"QuantityOnPOBetween":[0],"QuantityOnPOIn":[0],"QuantityOnBO":0,"QuantityOnBOGreaterThanOrEqualTo":0,"QuantityOnBOGreaterThan":0,"QuantityOnBOLessThan":0,"QuantityOnBOLessThanOrEqualTo":0,"QuantityOnBONotEqualTo":0,"QuantityOnBOBetween":[0],"QuantityOnBOIn":[0],"QuantitySalesForecast":0,"QuantitySalesForecastGreaterThanOrEqualTo":0,"QuantitySalesForecastGreaterThan":0,"QuantitySalesForecastLessThan":0,"QuantitySalesForecastLessThanOrEqualTo":0,"QuantitySalesForecastNotEqualTo":0,"QuantitySalesForecastBetween":[0],"QuantitySalesForecastIn":[0],"QuantityLastYearPurchases":0,"QuantityLastYearPurchasesGreaterThanOrEqualTo":0,"QuantityLastYearPurchasesGreaterThan":0,"QuantityLastYearPurchasesLessThan":0,"QuantityLastYearPurchasesLessThanOrEqualTo":0,"QuantityLastYearPurchasesNotEqualTo":0,"QuantityLastYearPurchasesBetween":[0],"QuantityLastYearPurchasesIn":[0],"QuantityLastYearSales":0,"QuantityLastYearSalesGreaterThanOrEqualTo":0,"QuantityLastYearSalesGreaterThan":0,"QuantityLastYearSalesLessThan":0,"QuantityLastYearSalesLessThanOrEqualTo":0,"QuantityLastYearSalesNotEqualTo":0,"QuantityLastYearSalesBetween":[0],"QuantityLastYearSalesIn":[0],"PO_Lines_RecID":"String","PO_Lines_RecIDStartsWith":"String","PO_Lines_RecIDEndsWith":"String","PO_Lines_RecIDContains":"String","PO_Lines_RecIDLike":"String","PO_Lines_RecIDBetween":["String"],"PO_Lines_RecIDIn":["String"],"UnitCubic":0,"UnitCubicGreaterThanOrEqualTo":0,"UnitCubicGreaterThan":0,"UnitCubicLessThan":0,"UnitCubicLessThanOrEqualTo":0,"UnitCubicNotEqualTo":0,"UnitCubicBetween":[0],"UnitCubicIn":[0],"UnitWeight":0,"UnitWeightGreaterThanOrEqualTo":0,"UnitWeightGreaterThan":0,"UnitWeightLessThan":0,"UnitWeightLessThanOrEqualTo":0,"UnitWeightNotEqualTo":0,"UnitWeightBetween":[0],"UnitWeightIn":[0],"LineCubic":0,"LineCubicGreaterThanOrEqualTo":0,"LineCubicGreaterThan":0,"LineCubicLessThan":0,"LineCubicLessThanOrEqualTo":0,"LineCubicNotEqualTo":0,"LineCubicBetween":[0],"LineCubicIn":[0],"LineWeight":0,"LineWeightGreaterThanOrEqualTo":0,"LineWeightGreaterThan":0,"LineWeightLessThan":0,"LineWeightLessThanOrEqualTo":0,"LineWeightNotEqualTo":0,"LineWeightBetween":[0],"LineWeightIn":[0],"DeliveryDays":0,"DeliveryDaysGreaterThanOrEqualTo":0,"DeliveryDaysGreaterThan":0,"DeliveryDaysLessThan":0,"DeliveryDaysLessThanOrEqualTo":0,"DeliveryDaysNotEqualTo":0,"DeliveryDaysBetween":[0],"DeliveryDaysIn":[0],"OrderUnits":0,"OrderUnitsGreaterThanOrEqualTo":0,"OrderUnitsGreaterThan":0,"OrderUnitsLessThan":0,"OrderUnitsLessThanOrEqualTo":0,"OrderUnitsNotEqualTo":0,"OrderUnitsBetween":[0],"OrderUnitsIn":[0],"RowHash":"AA==","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":[{"RecID":"String","PO_BatchPurchaseOrders_RecID":"String","IN_Main_RecID":"String","PO_Lines_RecID":"String","RowHash":"AA=="}],"Meta":{"String":"String"},"ResponseStatus":{"ErrorCode":"String","Message":"String","StackTrace":"String","Errors":[{"ErrorCode":"String","FieldName":"String","Message":"String","Meta":{"String":"String"}}],"Meta":{"String":"String"}}}