JiwaAPI

<back to all web services

CR_BatchTranLinesQuery

Requires Authentication
CR_BatchTranLinesQuery Parameters:
NameParameterData TypeRequiredDescription
ReceiptLineIDquerystringNo
ReceiptLineIDStartsWithquerystringNo
ReceiptLineIDEndsWithquerystringNo
ReceiptLineIDContainsquerystringNo
ReceiptLineIDLikequerystringNo
ReceiptLineIDBetweenquerystring[]No
ReceiptLineIDInquerystring[]No
ReceiptIDquerystringNo
ReceiptIDStartsWithquerystringNo
ReceiptIDEndsWithquerystringNo
ReceiptIDContainsquerystringNo
ReceiptIDLikequerystringNo
ReceiptIDBetweenquerystring[]No
ReceiptIDInquerystring[]No
LastSavedDateTimequeryDateTime?No
LastSavedDateTimeGreaterThanOrEqualToqueryDateTime?No
LastSavedDateTimeGreaterThanqueryDateTime?No
LastSavedDateTimeLessThanqueryDateTime?No
LastSavedDateTimeLessThanOrEqualToqueryDateTime?No
LastSavedDateTimeNotEqualToqueryDateTime?No
LastSavedDateTimeBetweenqueryNullable<DateTime>[]No
LastSavedDateTimeInqueryNullable<DateTime>[]No
AccountIDquerystringNo
AccountIDStartsWithquerystringNo
AccountIDEndsWithquerystringNo
AccountIDContainsquerystringNo
AccountIDLikequerystringNo
AccountIDBetweenquerystring[]No
AccountIDInquerystring[]No
LedgerIDquerystringNo
LedgerIDStartsWithquerystringNo
LedgerIDEndsWithquerystringNo
LedgerIDContainsquerystringNo
LedgerIDLikequerystringNo
LedgerIDBetweenquerystring[]No
LedgerIDInquerystring[]No
LineReferencequerystringNo
LineReferenceStartsWithquerystringNo
LineReferenceEndsWithquerystringNo
LineReferenceContainsquerystringNo
LineReferenceLikequerystringNo
LineReferenceBetweenquerystring[]No
LineReferenceInquerystring[]No
RemarkquerystringNo
RemarkStartsWithquerystringNo
RemarkEndsWithquerystringNo
RemarkContainsquerystringNo
RemarkLikequerystringNo
RemarkBetweenquerystring[]No
RemarkInquerystring[]No
RemitNoquerystringNo
RemitNoStartsWithquerystringNo
RemitNoEndsWithquerystringNo
RemitNoContainsquerystringNo
RemitNoLikequerystringNo
RemitNoBetweenquerystring[]No
RemitNoInquerystring[]No
HomeTransAmountquerydecimal?No
HomeTransAmountGreaterThanOrEqualToquerydecimal?No
HomeTransAmountGreaterThanquerydecimal?No
HomeTransAmountLessThanquerydecimal?No
HomeTransAmountLessThanOrEqualToquerydecimal?No
HomeTransAmountNotEqualToquerydecimal?No
HomeTransAmountBetweenqueryNullable<Decimal>[]No
HomeTransAmountInqueryNullable<Decimal>[]No
LineNumqueryint?No
LineNumGreaterThanOrEqualToqueryint?No
LineNumGreaterThanqueryint?No
LineNumLessThanqueryint?No
LineNumLessThanOrEqualToqueryint?No
LineNumNotEqualToqueryint?No
LineNumBetweenqueryint[]No
LineNumInqueryint[]No
OtherLedgerIDquerystringNo
OtherLedgerIDStartsWithquerystringNo
OtherLedgerIDEndsWithquerystringNo
OtherLedgerIDContainsquerystringNo
OtherLedgerIDLikequerystringNo
OtherLedgerIDBetweenquerystring[]No
OtherLedgerIDInquerystring[]No
HomeDispAmountquerydecimal?No
HomeDispAmountGreaterThanOrEqualToquerydecimal?No
HomeDispAmountGreaterThanquerydecimal?No
HomeDispAmountLessThanquerydecimal?No
HomeDispAmountLessThanOrEqualToquerydecimal?No
HomeDispAmountNotEqualToquerydecimal?No
HomeDispAmountBetweenqueryNullable<Decimal>[]No
HomeDispAmountInqueryNullable<Decimal>[]No
ReceiptDatequeryDateTime?No
ReceiptDateGreaterThanOrEqualToqueryDateTime?No
ReceiptDateGreaterThanqueryDateTime?No
ReceiptDateLessThanqueryDateTime?No
ReceiptDateLessThanOrEqualToqueryDateTime?No
ReceiptDateNotEqualToqueryDateTime?No
ReceiptDateBetweenqueryNullable<DateTime>[]No
ReceiptDateInqueryNullable<DateTime>[]No
SupplierTransAmountquerydecimal?No
SupplierTransAmountGreaterThanOrEqualToquerydecimal?No
SupplierTransAmountGreaterThanquerydecimal?No
SupplierTransAmountLessThanquerydecimal?No
SupplierTransAmountLessThanOrEqualToquerydecimal?No
SupplierTransAmountNotEqualToquerydecimal?No
SupplierTransAmountBetweenqueryNullable<Decimal>[]No
SupplierTransAmountInqueryNullable<Decimal>[]No
SupplierDispAmountquerydecimal?No
SupplierDispAmountGreaterThanOrEqualToquerydecimal?No
SupplierDispAmountGreaterThanquerydecimal?No
SupplierDispAmountLessThanquerydecimal?No
SupplierDispAmountLessThanOrEqualToquerydecimal?No
SupplierDispAmountNotEqualToquerydecimal?No
SupplierDispAmountBetweenqueryNullable<Decimal>[]No
SupplierDispAmountInqueryNullable<Decimal>[]No
CurrencyRateUsedquerydecimal?No
CurrencyRateUsedGreaterThanOrEqualToquerydecimal?No
CurrencyRateUsedGreaterThanquerydecimal?No
CurrencyRateUsedLessThanquerydecimal?No
CurrencyRateUsedLessThanOrEqualToquerydecimal?No
CurrencyRateUsedNotEqualToquerydecimal?No
CurrencyRateUsedBetweenqueryNullable<Decimal>[]No
CurrencyRateUsedInqueryNullable<Decimal>[]No
TaxIDquerystringNo
TaxIDStartsWithquerystringNo
TaxIDEndsWithquerystringNo
TaxIDContainsquerystringNo
TaxIDLikequerystringNo
TaxIDBetweenquerystring[]No
TaxIDInquerystring[]No
TaxRatequerydecimal?No
TaxRateGreaterThanOrEqualToquerydecimal?No
TaxRateGreaterThanquerydecimal?No
TaxRateLessThanquerydecimal?No
TaxRateLessThanOrEqualToquerydecimal?No
TaxRateNotEqualToquerydecimal?No
TaxRateBetweenqueryNullable<Decimal>[]No
TaxRateInqueryNullable<Decimal>[]No
TaxAmountquerydecimal?No
TaxAmountGreaterThanOrEqualToquerydecimal?No
TaxAmountGreaterThanquerydecimal?No
TaxAmountLessThanquerydecimal?No
TaxAmountLessThanOrEqualToquerydecimal?No
TaxAmountNotEqualToquerydecimal?No
TaxAmountBetweenqueryNullable<Decimal>[]No
TaxAmountInqueryNullable<Decimal>[]No
DueDatequeryDateTime?No
DueDateGreaterThanOrEqualToqueryDateTime?No
DueDateGreaterThanqueryDateTime?No
DueDateLessThanqueryDateTime?No
DueDateLessThanOrEqualToqueryDateTime?No
DueDateNotEqualToqueryDateTime?No
DueDateBetweenqueryNullable<DateTime>[]No
DueDateInqueryNullable<DateTime>[]No
HomeDispAmountIncGSTquerydecimal?No
HomeDispAmountIncGSTGreaterThanOrEqualToquerydecimal?No
HomeDispAmountIncGSTGreaterThanquerydecimal?No
HomeDispAmountIncGSTLessThanquerydecimal?No
HomeDispAmountIncGSTLessThanOrEqualToquerydecimal?No
HomeDispAmountIncGSTNotEqualToquerydecimal?No
HomeDispAmountIncGSTBetweenqueryNullable<Decimal>[]No
HomeDispAmountIncGSTInqueryNullable<Decimal>[]No
CurrencyIDquerystringNo
CurrencyIDStartsWithquerystringNo
CurrencyIDEndsWithquerystringNo
CurrencyIDContainsquerystringNo
CurrencyIDLikequerystringNo
CurrencyIDBetweenquerystring[]No
CurrencyIDInquerystring[]No
JobChargeAmountquerydecimal?No
JobChargeAmountGreaterThanOrEqualToquerydecimal?No
JobChargeAmountGreaterThanquerydecimal?No
JobChargeAmountLessThanquerydecimal?No
JobChargeAmountLessThanOrEqualToquerydecimal?No
JobChargeAmountNotEqualToquerydecimal?No
JobChargeAmountBetweenqueryNullable<Decimal>[]No
JobChargeAmountInqueryNullable<Decimal>[]No
JB_JobStages_RecIDquerystringNo
JB_JobStages_RecIDStartsWithquerystringNo
JB_JobStages_RecIDEndsWithquerystringNo
JB_JobStages_RecIDContainsquerystringNo
JB_JobStages_RecIDLikequerystringNo
JB_JobStages_RecIDBetweenquerystring[]No
JB_JobStages_RecIDInquerystring[]No
QueryBase Parameters:
NameParameterData TypeRequiredDescription
Skipformint?No
Takeformint?No
OrderByformstringNo
OrderByDescformstringNo
IncludeformstringNo
FieldsformstringNo
MetaformDictionary<string, string>No
CR_BatchTranLines Parameters:
NameParameterData TypeRequiredDescription
ReceiptLineIDformstringNo
ReceiptIDformstringNo
LastSavedDateTimeformDateTime?No
AccountIDformstringNo
LedgerIDformstringNo
LineReferenceformstringNo
RemarkformstringNo
RemitNoformstringNo
HomeTransAmountformdecimal?No
LineNumformintNo
OtherLedgerIDformstringNo
HomeDispAmountformdecimal?No
ReceiptDateformDateTime?No
SupplierTransAmountformdecimal?No
SupplierDispAmountformdecimal?No
CurrencyRateUsedformdecimal?No
TaxIDformstringNo
TaxRateformdecimal?No
TaxAmountformdecimal?No
DueDateformDateTime?No
HomeDispAmountIncGSTformdecimal?No
CurrencyIDformstringNo
JobChargeAmountformdecimal?No
JB_JobStages_RecIDformstringNo
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/CR_BatchTranLinesQuery HTTP/1.1 
Host: localhost 
Accept: application/json
Content-Type: application/json
Content-Length: length

{"ReceiptLineID":"String","ReceiptLineIDStartsWith":"String","ReceiptLineIDEndsWith":"String","ReceiptLineIDContains":"String","ReceiptLineIDLike":"String","ReceiptLineIDBetween":["String"],"ReceiptLineIDIn":["String"],"ReceiptID":"String","ReceiptIDStartsWith":"String","ReceiptIDEndsWith":"String","ReceiptIDContains":"String","ReceiptIDLike":"String","ReceiptIDBetween":["String"],"ReceiptIDIn":["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"],"AccountID":"String","AccountIDStartsWith":"String","AccountIDEndsWith":"String","AccountIDContains":"String","AccountIDLike":"String","AccountIDBetween":["String"],"AccountIDIn":["String"],"LedgerID":"String","LedgerIDStartsWith":"String","LedgerIDEndsWith":"String","LedgerIDContains":"String","LedgerIDLike":"String","LedgerIDBetween":["String"],"LedgerIDIn":["String"],"LineReference":"String","LineReferenceStartsWith":"String","LineReferenceEndsWith":"String","LineReferenceContains":"String","LineReferenceLike":"String","LineReferenceBetween":["String"],"LineReferenceIn":["String"],"Remark":"String","RemarkStartsWith":"String","RemarkEndsWith":"String","RemarkContains":"String","RemarkLike":"String","RemarkBetween":["String"],"RemarkIn":["String"],"RemitNo":"String","RemitNoStartsWith":"String","RemitNoEndsWith":"String","RemitNoContains":"String","RemitNoLike":"String","RemitNoBetween":["String"],"RemitNoIn":["String"],"HomeTransAmount":0,"HomeTransAmountGreaterThanOrEqualTo":0,"HomeTransAmountGreaterThan":0,"HomeTransAmountLessThan":0,"HomeTransAmountLessThanOrEqualTo":0,"HomeTransAmountNotEqualTo":0,"HomeTransAmountBetween":[0],"HomeTransAmountIn":[0],"LineNum":0,"LineNumGreaterThanOrEqualTo":0,"LineNumGreaterThan":0,"LineNumLessThan":0,"LineNumLessThanOrEqualTo":0,"LineNumNotEqualTo":0,"LineNumBetween":[0],"LineNumIn":[0],"OtherLedgerID":"String","OtherLedgerIDStartsWith":"String","OtherLedgerIDEndsWith":"String","OtherLedgerIDContains":"String","OtherLedgerIDLike":"String","OtherLedgerIDBetween":["String"],"OtherLedgerIDIn":["String"],"HomeDispAmount":0,"HomeDispAmountGreaterThanOrEqualTo":0,"HomeDispAmountGreaterThan":0,"HomeDispAmountLessThan":0,"HomeDispAmountLessThanOrEqualTo":0,"HomeDispAmountNotEqualTo":0,"HomeDispAmountBetween":[0],"HomeDispAmountIn":[0],"ReceiptDate":"0001-01-01T00:00:00.0000000","ReceiptDateGreaterThanOrEqualTo":"0001-01-01T00:00:00.0000000","ReceiptDateGreaterThan":"0001-01-01T00:00:00.0000000","ReceiptDateLessThan":"0001-01-01T00:00:00.0000000","ReceiptDateLessThanOrEqualTo":"0001-01-01T00:00:00.0000000","ReceiptDateNotEqualTo":"0001-01-01T00:00:00.0000000","ReceiptDateBetween":["0001-01-01T00:00:00.0000000"],"ReceiptDateIn":["0001-01-01T00:00:00.0000000"],"SupplierTransAmount":0,"SupplierTransAmountGreaterThanOrEqualTo":0,"SupplierTransAmountGreaterThan":0,"SupplierTransAmountLessThan":0,"SupplierTransAmountLessThanOrEqualTo":0,"SupplierTransAmountNotEqualTo":0,"SupplierTransAmountBetween":[0],"SupplierTransAmountIn":[0],"SupplierDispAmount":0,"SupplierDispAmountGreaterThanOrEqualTo":0,"SupplierDispAmountGreaterThan":0,"SupplierDispAmountLessThan":0,"SupplierDispAmountLessThanOrEqualTo":0,"SupplierDispAmountNotEqualTo":0,"SupplierDispAmountBetween":[0],"SupplierDispAmountIn":[0],"CurrencyRateUsed":0,"CurrencyRateUsedGreaterThanOrEqualTo":0,"CurrencyRateUsedGreaterThan":0,"CurrencyRateUsedLessThan":0,"CurrencyRateUsedLessThanOrEqualTo":0,"CurrencyRateUsedNotEqualTo":0,"CurrencyRateUsedBetween":[0],"CurrencyRateUsedIn":[0],"TaxID":"String","TaxIDStartsWith":"String","TaxIDEndsWith":"String","TaxIDContains":"String","TaxIDLike":"String","TaxIDBetween":["String"],"TaxIDIn":["String"],"TaxRate":0,"TaxRateGreaterThanOrEqualTo":0,"TaxRateGreaterThan":0,"TaxRateLessThan":0,"TaxRateLessThanOrEqualTo":0,"TaxRateNotEqualTo":0,"TaxRateBetween":[0],"TaxRateIn":[0],"TaxAmount":0,"TaxAmountGreaterThanOrEqualTo":0,"TaxAmountGreaterThan":0,"TaxAmountLessThan":0,"TaxAmountLessThanOrEqualTo":0,"TaxAmountNotEqualTo":0,"TaxAmountBetween":[0],"TaxAmountIn":[0],"DueDate":"0001-01-01T00:00:00.0000000","DueDateGreaterThanOrEqualTo":"0001-01-01T00:00:00.0000000","DueDateGreaterThan":"0001-01-01T00:00:00.0000000","DueDateLessThan":"0001-01-01T00:00:00.0000000","DueDateLessThanOrEqualTo":"0001-01-01T00:00:00.0000000","DueDateNotEqualTo":"0001-01-01T00:00:00.0000000","DueDateBetween":["0001-01-01T00:00:00.0000000"],"DueDateIn":["0001-01-01T00:00:00.0000000"],"HomeDispAmountIncGST":0,"HomeDispAmountIncGSTGreaterThanOrEqualTo":0,"HomeDispAmountIncGSTGreaterThan":0,"HomeDispAmountIncGSTLessThan":0,"HomeDispAmountIncGSTLessThanOrEqualTo":0,"HomeDispAmountIncGSTNotEqualTo":0,"HomeDispAmountIncGSTBetween":[0],"HomeDispAmountIncGSTIn":[0],"CurrencyID":"String","CurrencyIDStartsWith":"String","CurrencyIDEndsWith":"String","CurrencyIDContains":"String","CurrencyIDLike":"String","CurrencyIDBetween":["String"],"CurrencyIDIn":["String"],"JobChargeAmount":0,"JobChargeAmountGreaterThanOrEqualTo":0,"JobChargeAmountGreaterThan":0,"JobChargeAmountLessThan":0,"JobChargeAmountLessThanOrEqualTo":0,"JobChargeAmountNotEqualTo":0,"JobChargeAmountBetween":[0],"JobChargeAmountIn":[0],"JB_JobStages_RecID":"String","JB_JobStages_RecIDStartsWith":"String","JB_JobStages_RecIDEndsWith":"String","JB_JobStages_RecIDContains":"String","JB_JobStages_RecIDLike":"String","JB_JobStages_RecIDBetween":["String"],"JB_JobStages_RecIDIn":["String"],"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":[{"ReceiptLineID":"String","ReceiptID":"String","LastSavedDateTime":"0001-01-01T00:00:00.0000000","AccountID":"String","LedgerID":"String","LineReference":"String","Remark":"String","RemitNo":"String","HomeTransAmount":0,"OtherLedgerID":"String","HomeDispAmount":0,"ReceiptDate":"0001-01-01T00:00:00.0000000","SupplierTransAmount":0,"SupplierDispAmount":0,"CurrencyRateUsed":0,"TaxID":"String","TaxRate":0,"TaxAmount":0,"DueDate":"0001-01-01T00:00:00.0000000","HomeDispAmountIncGST":0,"CurrencyID":"String","JobChargeAmount":0,"JB_JobStages_RecID":"String"}],"Meta":{"String":"String"},"ResponseStatus":{"ErrorCode":"String","Message":"String","StackTrace":"String","Errors":[{"ErrorCode":"String","FieldName":"String","Message":"String","Meta":{"String":"String"}}],"Meta":{"String":"String"}}}