JiwaAPI

<back to all web services

JB_CostEntryLinesQuery

Requires Authentication
JB_CostEntryLinesQuery Parameters:
NameParameterData TypeRequiredDescription
RecIDquerystringNo
RecIDStartsWithquerystringNo
RecIDEndsWithquerystringNo
RecIDContainsquerystringNo
RecIDLikequerystringNo
RecIDBetweenquerystring[]No
RecIDInquerystring[]No
JobEntryIDquerystringNo
JobEntryIDStartsWithquerystringNo
JobEntryIDEndsWithquerystringNo
JobEntryIDContainsquerystringNo
JobEntryIDLikequerystringNo
JobEntryIDBetweenquerystring[]No
JobEntryIDInquerystring[]No
JobCodequerystringNo
JobCodeStartsWithquerystringNo
JobCodeEndsWithquerystringNo
JobCodeContainsquerystringNo
JobCodeLikequerystringNo
JobCodeBetweenquerystring[]No
JobCodeInquerystring[]No
JobIDquerystringNo
JobIDStartsWithquerystringNo
JobIDEndsWithquerystringNo
JobIDContainsquerystringNo
JobIDLikequerystringNo
JobIDBetweenquerystring[]No
JobIDInquerystring[]No
CostCentreIDquerystringNo
CostCentreIDStartsWithquerystringNo
CostCentreIDEndsWithquerystringNo
CostCentreIDContainsquerystringNo
CostCentreIDLikequerystringNo
CostCentreIDBetweenquerystring[]No
CostCentreIDInquerystring[]No
StageIDquerystringNo
StageIDStartsWithquerystringNo
StageIDEndsWithquerystringNo
StageIDContainsquerystringNo
StageIDLikequerystringNo
StageIDBetweenquerystring[]No
StageIDInquerystring[]No
Qtyquerydecimal?No
QtyGreaterThanOrEqualToquerydecimal?No
QtyGreaterThanquerydecimal?No
QtyLessThanquerydecimal?No
QtyLessThanOrEqualToquerydecimal?No
QtyNotEqualToquerydecimal?No
QtyBetweenquerydecimal[]No
QtyInquerydecimal[]No
UnitCostquerydecimal?No
UnitCostGreaterThanOrEqualToquerydecimal?No
UnitCostGreaterThanquerydecimal?No
UnitCostLessThanquerydecimal?No
UnitCostLessThanOrEqualToquerydecimal?No
UnitCostNotEqualToquerydecimal?No
UnitCostBetweenquerydecimal[]No
UnitCostInquerydecimal[]No
UnitChargequerydecimal?No
UnitChargeGreaterThanOrEqualToquerydecimal?No
UnitChargeGreaterThanquerydecimal?No
UnitChargeLessThanquerydecimal?No
UnitChargeLessThanOrEqualToquerydecimal?No
UnitChargeNotEqualToquerydecimal?No
UnitChargeBetweenquerydecimal[]No
UnitChargeInquerydecimal[]No
MarkUpquerydecimal?No
MarkUpGreaterThanOrEqualToquerydecimal?No
MarkUpGreaterThanquerydecimal?No
MarkUpLessThanquerydecimal?No
MarkUpLessThanOrEqualToquerydecimal?No
MarkUpNotEqualToquerydecimal?No
MarkUpBetweenqueryNullable<Decimal>[]No
MarkUpInqueryNullable<Decimal>[]No
ComponentIDquerystringNo
ComponentIDStartsWithquerystringNo
ComponentIDEndsWithquerystringNo
ComponentIDContainsquerystringNo
ComponentIDLikequerystringNo
ComponentIDBetweenquerystring[]No
ComponentIDInquerystring[]No
ComponentNoquerystringNo
ComponentNoStartsWithquerystringNo
ComponentNoEndsWithquerystringNo
ComponentNoContainsquerystringNo
ComponentNoLikequerystringNo
ComponentNoBetweenquerystring[]No
ComponentNoInquerystring[]No
ComponentDescquerystringNo
ComponentDescStartsWithquerystringNo
ComponentDescEndsWithquerystringNo
ComponentDescContainsquerystringNo
ComponentDescLikequerystringNo
ComponentDescBetweenquerystring[]No
ComponentDescInquerystring[]No
ComponentTypequeryshort?No
ComponentTypeGreaterThanOrEqualToqueryshort?No
ComponentTypeGreaterThanqueryshort?No
ComponentTypeLessThanqueryshort?No
ComponentTypeLessThanOrEqualToqueryshort?No
ComponentTypeNotEqualToqueryshort?No
ComponentTypeBetweenqueryNullable<Int16>[]No
ComponentTypeInqueryNullable<Int16>[]No
InvoiceNoquerystringNo
InvoiceNoStartsWithquerystringNo
InvoiceNoEndsWithquerystringNo
InvoiceNoContainsquerystringNo
InvoiceNoLikequerystringNo
InvoiceNoBetweenquerystring[]No
InvoiceNoInquerystring[]No
TranTypequeryshort?No
TranTypeGreaterThanOrEqualToqueryshort?No
TranTypeGreaterThanqueryshort?No
TranTypeLessThanqueryshort?No
TranTypeLessThanOrEqualToqueryshort?No
TranTypeNotEqualToqueryshort?No
TranTypeBetweenqueryNullable<Int16>[]No
TranTypeInqueryNullable<Int16>[]No
TaxIDquerystringNo
TaxIDStartsWithquerystringNo
TaxIDEndsWithquerystringNo
TaxIDContainsquerystringNo
TaxIDLikequerystringNo
TaxIDBetweenquerystring[]No
TaxIDInquerystring[]No
Statusqueryshort?No
StatusGreaterThanOrEqualToqueryshort?No
StatusGreaterThanqueryshort?No
StatusLessThanqueryshort?No
StatusLessThanOrEqualToqueryshort?No
StatusNotEqualToqueryshort?No
StatusBetweenqueryNullable<Int16>[]No
StatusInqueryNullable<Int16>[]No
LinkIDquerystringNo
LinkIDStartsWithquerystringNo
LinkIDEndsWithquerystringNo
LinkIDContainsquerystringNo
LinkIDLikequerystringNo
LinkIDBetweenquerystring[]No
LinkIDInquerystring[]No
LastSavedDateTimequeryDateTime?No
LastSavedDateTimeGreaterThanOrEqualToqueryDateTime?No
LastSavedDateTimeGreaterThanqueryDateTime?No
LastSavedDateTimeLessThanqueryDateTime?No
LastSavedDateTimeLessThanOrEqualToqueryDateTime?No
LastSavedDateTimeNotEqualToqueryDateTime?No
LastSavedDateTimeBetweenqueryDateTime[]No
LastSavedDateTimeInqueryDateTime[]No
TranDatequeryDateTime?No
TranDateGreaterThanOrEqualToqueryDateTime?No
TranDateGreaterThanqueryDateTime?No
TranDateLessThanqueryDateTime?No
TranDateLessThanOrEqualToqueryDateTime?No
TranDateNotEqualToqueryDateTime?No
TranDateBetweenqueryDateTime[]No
TranDateInqueryDateTime[]No
InvoicedAmountquerydecimal?No
InvoicedAmountGreaterThanOrEqualToquerydecimal?No
InvoicedAmountGreaterThanquerydecimal?No
InvoicedAmountLessThanquerydecimal?No
InvoicedAmountLessThanOrEqualToquerydecimal?No
InvoicedAmountNotEqualToquerydecimal?No
InvoicedAmountBetweenqueryNullable<Decimal>[]No
InvoicedAmountInqueryNullable<Decimal>[]No
UnitquerystringNo
UnitStartsWithquerystringNo
UnitEndsWithquerystringNo
UnitContainsquerystringNo
UnitLikequerystringNo
UnitBetweenquerystring[]No
UnitInquerystring[]No
RemarkquerystringNo
RemarkStartsWithquerystringNo
RemarkEndsWithquerystringNo
RemarkContainsquerystringNo
RemarkLikequerystringNo
RemarkBetweenquerystring[]No
RemarkInquerystring[]No
ServiceNoquerystringNo
ServiceNoStartsWithquerystringNo
ServiceNoEndsWithquerystringNo
ServiceNoContainsquerystringNo
ServiceNoLikequerystringNo
ServiceNoBetweenquerystring[]No
ServiceNoInquerystring[]No
BackOrderQtyquerydecimal?No
BackOrderQtyGreaterThanOrEqualToquerydecimal?No
BackOrderQtyGreaterThanquerydecimal?No
BackOrderQtyLessThanquerydecimal?No
BackOrderQtyLessThanOrEqualToquerydecimal?No
BackOrderQtyNotEqualToquerydecimal?No
BackOrderQtyBetweenqueryNullable<Decimal>[]No
BackOrderQtyInqueryNullable<Decimal>[]No
QtyDeliveredquerydecimal?No
QtyDeliveredGreaterThanOrEqualToquerydecimal?No
QtyDeliveredGreaterThanquerydecimal?No
QtyDeliveredLessThanquerydecimal?No
QtyDeliveredLessThanOrEqualToquerydecimal?No
QtyDeliveredNotEqualToquerydecimal?No
QtyDeliveredBetweenqueryNullable<Decimal>[]No
QtyDeliveredInqueryNullable<Decimal>[]No
QtyDecimalPlacesqueryshort?No
QtyDecimalPlacesGreaterThanOrEqualToqueryshort?No
QtyDecimalPlacesGreaterThanqueryshort?No
QtyDecimalPlacesLessThanqueryshort?No
QtyDecimalPlacesLessThanOrEqualToqueryshort?No
QtyDecimalPlacesNotEqualToqueryshort?No
QtyDecimalPlacesBetweenqueryNullable<Int16>[]No
QtyDecimalPlacesInqueryNullable<Int16>[]No
QueryBase Parameters:
NameParameterData TypeRequiredDescription
Skipformint?No
Takeformint?No
OrderByformstringNo
OrderByDescformstringNo
IncludeformstringNo
FieldsformstringNo
MetaformDictionary<string, string>No
JB_CostEntryLines Parameters:
NameParameterData TypeRequiredDescription
RecIDformstringNo
JobEntryIDformstringNo
JobCodeformstringNo
JobIDformstringNo
CostCentreIDformstringNo
StageIDformstringNo
QtyformdecimalNo
UnitCostformdecimalNo
UnitChargeformdecimalNo
MarkUpformdecimal?No
ComponentIDformstringNo
ComponentNoformstringNo
ComponentDescformstringNo
ComponentTypeformshort?No
InvoiceNoformstringNo
TranTypeformshort?No
TaxIDformstringNo
Statusformshort?No
LinkIDformstringNo
LastSavedDateTimeformDateTimeNo
TranDateformDateTimeNo
InvoicedAmountformdecimal?No
UnitformstringNo
RemarkformstringNo
ServiceNoformstringNo
BackOrderQtyformdecimal?No
QtyDeliveredformdecimal?No
QtyDecimalPlacesformshort?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/JB_CostEntryLinesQuery 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"],"JobEntryID":"String","JobEntryIDStartsWith":"String","JobEntryIDEndsWith":"String","JobEntryIDContains":"String","JobEntryIDLike":"String","JobEntryIDBetween":["String"],"JobEntryIDIn":["String"],"JobCode":"String","JobCodeStartsWith":"String","JobCodeEndsWith":"String","JobCodeContains":"String","JobCodeLike":"String","JobCodeBetween":["String"],"JobCodeIn":["String"],"JobID":"String","JobIDStartsWith":"String","JobIDEndsWith":"String","JobIDContains":"String","JobIDLike":"String","JobIDBetween":["String"],"JobIDIn":["String"],"CostCentreID":"String","CostCentreIDStartsWith":"String","CostCentreIDEndsWith":"String","CostCentreIDContains":"String","CostCentreIDLike":"String","CostCentreIDBetween":["String"],"CostCentreIDIn":["String"],"StageID":"String","StageIDStartsWith":"String","StageIDEndsWith":"String","StageIDContains":"String","StageIDLike":"String","StageIDBetween":["String"],"StageIDIn":["String"],"Qty":0,"QtyGreaterThanOrEqualTo":0,"QtyGreaterThan":0,"QtyLessThan":0,"QtyLessThanOrEqualTo":0,"QtyNotEqualTo":0,"QtyBetween":[0],"QtyIn":[0],"UnitCost":0,"UnitCostGreaterThanOrEqualTo":0,"UnitCostGreaterThan":0,"UnitCostLessThan":0,"UnitCostLessThanOrEqualTo":0,"UnitCostNotEqualTo":0,"UnitCostBetween":[0],"UnitCostIn":[0],"UnitCharge":0,"UnitChargeGreaterThanOrEqualTo":0,"UnitChargeGreaterThan":0,"UnitChargeLessThan":0,"UnitChargeLessThanOrEqualTo":0,"UnitChargeNotEqualTo":0,"UnitChargeBetween":[0],"UnitChargeIn":[0],"MarkUp":0,"MarkUpGreaterThanOrEqualTo":0,"MarkUpGreaterThan":0,"MarkUpLessThan":0,"MarkUpLessThanOrEqualTo":0,"MarkUpNotEqualTo":0,"MarkUpBetween":[0],"MarkUpIn":[0],"ComponentID":"String","ComponentIDStartsWith":"String","ComponentIDEndsWith":"String","ComponentIDContains":"String","ComponentIDLike":"String","ComponentIDBetween":["String"],"ComponentIDIn":["String"],"ComponentNo":"String","ComponentNoStartsWith":"String","ComponentNoEndsWith":"String","ComponentNoContains":"String","ComponentNoLike":"String","ComponentNoBetween":["String"],"ComponentNoIn":["String"],"ComponentDesc":"String","ComponentDescStartsWith":"String","ComponentDescEndsWith":"String","ComponentDescContains":"String","ComponentDescLike":"String","ComponentDescBetween":["String"],"ComponentDescIn":["String"],"ComponentType":0,"ComponentTypeGreaterThanOrEqualTo":0,"ComponentTypeGreaterThan":0,"ComponentTypeLessThan":0,"ComponentTypeLessThanOrEqualTo":0,"ComponentTypeNotEqualTo":0,"ComponentTypeBetween":[0],"ComponentTypeIn":[0],"InvoiceNo":"String","InvoiceNoStartsWith":"String","InvoiceNoEndsWith":"String","InvoiceNoContains":"String","InvoiceNoLike":"String","InvoiceNoBetween":["String"],"InvoiceNoIn":["String"],"TranType":0,"TranTypeGreaterThanOrEqualTo":0,"TranTypeGreaterThan":0,"TranTypeLessThan":0,"TranTypeLessThanOrEqualTo":0,"TranTypeNotEqualTo":0,"TranTypeBetween":[0],"TranTypeIn":[0],"TaxID":"String","TaxIDStartsWith":"String","TaxIDEndsWith":"String","TaxIDContains":"String","TaxIDLike":"String","TaxIDBetween":["String"],"TaxIDIn":["String"],"Status":0,"StatusGreaterThanOrEqualTo":0,"StatusGreaterThan":0,"StatusLessThan":0,"StatusLessThanOrEqualTo":0,"StatusNotEqualTo":0,"StatusBetween":[0],"StatusIn":[0],"LinkID":"String","LinkIDStartsWith":"String","LinkIDEndsWith":"String","LinkIDContains":"String","LinkIDLike":"String","LinkIDBetween":["String"],"LinkIDIn":["String"],"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"],"TranDate":"0001-01-01T00:00:00.0000000","TranDateGreaterThanOrEqualTo":"0001-01-01T00:00:00.0000000","TranDateGreaterThan":"0001-01-01T00:00:00.0000000","TranDateLessThan":"0001-01-01T00:00:00.0000000","TranDateLessThanOrEqualTo":"0001-01-01T00:00:00.0000000","TranDateNotEqualTo":"0001-01-01T00:00:00.0000000","TranDateBetween":["0001-01-01T00:00:00.0000000"],"TranDateIn":["0001-01-01T00:00:00.0000000"],"InvoicedAmount":0,"InvoicedAmountGreaterThanOrEqualTo":0,"InvoicedAmountGreaterThan":0,"InvoicedAmountLessThan":0,"InvoicedAmountLessThanOrEqualTo":0,"InvoicedAmountNotEqualTo":0,"InvoicedAmountBetween":[0],"InvoicedAmountIn":[0],"Unit":"String","UnitStartsWith":"String","UnitEndsWith":"String","UnitContains":"String","UnitLike":"String","UnitBetween":["String"],"UnitIn":["String"],"Remark":"String","RemarkStartsWith":"String","RemarkEndsWith":"String","RemarkContains":"String","RemarkLike":"String","RemarkBetween":["String"],"RemarkIn":["String"],"ServiceNo":"String","ServiceNoStartsWith":"String","ServiceNoEndsWith":"String","ServiceNoContains":"String","ServiceNoLike":"String","ServiceNoBetween":["String"],"ServiceNoIn":["String"],"BackOrderQty":0,"BackOrderQtyGreaterThanOrEqualTo":0,"BackOrderQtyGreaterThan":0,"BackOrderQtyLessThan":0,"BackOrderQtyLessThanOrEqualTo":0,"BackOrderQtyNotEqualTo":0,"BackOrderQtyBetween":[0],"BackOrderQtyIn":[0],"QtyDelivered":0,"QtyDeliveredGreaterThanOrEqualTo":0,"QtyDeliveredGreaterThan":0,"QtyDeliveredLessThan":0,"QtyDeliveredLessThanOrEqualTo":0,"QtyDeliveredNotEqualTo":0,"QtyDeliveredBetween":[0],"QtyDeliveredIn":[0],"QtyDecimalPlaces":0,"QtyDecimalPlacesGreaterThanOrEqualTo":0,"QtyDecimalPlacesGreaterThan":0,"QtyDecimalPlacesLessThan":0,"QtyDecimalPlacesLessThanOrEqualTo":0,"QtyDecimalPlacesNotEqualTo":0,"QtyDecimalPlacesBetween":[0],"QtyDecimalPlacesIn":[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":[{"RecID":"String","JobEntryID":"String","JobCode":"String","JobID":"String","CostCentreID":"String","StageID":"String","MarkUp":0,"ComponentID":"String","ComponentNo":"String","ComponentDesc":"String","ComponentType":0,"InvoiceNo":"String","TranType":0,"TaxID":"String","Status":0,"LinkID":"String","InvoicedAmount":0,"Unit":"String","Remark":"String","ServiceNo":"String","BackOrderQty":0,"QtyDelivered":0,"QtyDecimalPlaces":0}],"Meta":{"String":"String"},"ResponseStatus":{"ErrorCode":"String","Message":"String","StackTrace":"String","Errors":[{"ErrorCode":"String","FieldName":"String","Message":"String","Meta":{"String":"String"}}],"Meta":{"String":"String"}}}