JiwaAPI

<back to all web services

SH_CostsQuery

Requires Authentication
SH_CostsQuery Parameters:
NameParameterData TypeRequiredDescription
CostsIDquerystringNo
CostsIDStartsWithquerystringNo
CostsIDEndsWithquerystringNo
CostsIDContainsquerystringNo
CostsIDLikequerystringNo
CostsIDBetweenquerystring[]No
CostsIDInquerystring[]No
ShipmentIDquerystringNo
ShipmentIDStartsWithquerystringNo
ShipmentIDEndsWithquerystringNo
ShipmentIDContainsquerystringNo
ShipmentIDLikequerystringNo
ShipmentIDBetweenquerystring[]No
ShipmentIDInquerystring[]No
CreditorIDquerystringNo
CreditorIDStartsWithquerystringNo
CreditorIDEndsWithquerystringNo
CreditorIDContainsquerystringNo
CreditorIDLikequerystringNo
CreditorIDBetweenquerystring[]No
CreditorIDInquerystring[]No
CostTypequerystringNo
CostTypeStartsWithquerystringNo
CostTypeEndsWithquerystringNo
CostTypeContainsquerystringNo
CostTypeLikequerystringNo
CostTypeBetweenquerystring[]No
CostTypeInquerystring[]No
FXAmountquerydecimal?No
FXAmountGreaterThanOrEqualToquerydecimal?No
FXAmountGreaterThanquerydecimal?No
FXAmountLessThanquerydecimal?No
FXAmountLessThanOrEqualToquerydecimal?No
FXAmountNotEqualToquerydecimal?No
FXAmountBetweenqueryNullable<Decimal>[]No
FXAmountInqueryNullable<Decimal>[]No
FXRatequerydecimal?No
FXRateGreaterThanOrEqualToquerydecimal?No
FXRateGreaterThanquerydecimal?No
FXRateLessThanquerydecimal?No
FXRateLessThanOrEqualToquerydecimal?No
FXRateNotEqualToquerydecimal?No
FXRateBetweenqueryNullable<Decimal>[]No
FXRateInqueryNullable<Decimal>[]No
CurrencyIDquerystringNo
CurrencyIDStartsWithquerystringNo
CurrencyIDEndsWithquerystringNo
CurrencyIDContainsquerystringNo
CurrencyIDLikequerystringNo
CurrencyIDBetweenquerystring[]No
CurrencyIDInquerystring[]No
HomeAmountquerydecimal?No
HomeAmountGreaterThanOrEqualToquerydecimal?No
HomeAmountGreaterThanquerydecimal?No
HomeAmountLessThanquerydecimal?No
HomeAmountLessThanOrEqualToquerydecimal?No
HomeAmountNotEqualToquerydecimal?No
HomeAmountBetweenqueryNullable<Decimal>[]No
HomeAmountInqueryNullable<Decimal>[]No
GSTAmountquerydecimal?No
GSTAmountGreaterThanOrEqualToquerydecimal?No
GSTAmountGreaterThanquerydecimal?No
GSTAmountLessThanquerydecimal?No
GSTAmountLessThanOrEqualToquerydecimal?No
GSTAmountNotEqualToquerydecimal?No
GSTAmountBetweenqueryNullable<Decimal>[]No
GSTAmountInqueryNullable<Decimal>[]No
GSTRatequerydecimal?No
GSTRateGreaterThanOrEqualToquerydecimal?No
GSTRateGreaterThanquerydecimal?No
GSTRateLessThanquerydecimal?No
GSTRateLessThanOrEqualToquerydecimal?No
GSTRateNotEqualToquerydecimal?No
GSTRateBetweenqueryNullable<Decimal>[]No
GSTRateInqueryNullable<Decimal>[]No
GSTIDquerystringNo
GSTIDStartsWithquerystringNo
GSTIDEndsWithquerystringNo
GSTIDContainsquerystringNo
GSTIDLikequerystringNo
GSTIDBetweenquerystring[]No
GSTIDInquerystring[]No
TotalAmountquerydecimal?No
TotalAmountGreaterThanOrEqualToquerydecimal?No
TotalAmountGreaterThanquerydecimal?No
TotalAmountLessThanquerydecimal?No
TotalAmountLessThanOrEqualToquerydecimal?No
TotalAmountNotEqualToquerydecimal?No
TotalAmountBetweenqueryNullable<Decimal>[]No
TotalAmountInqueryNullable<Decimal>[]No
ApportionMethodqueryshort?No
ApportionMethodGreaterThanOrEqualToqueryshort?No
ApportionMethodGreaterThanqueryshort?No
ApportionMethodLessThanqueryshort?No
ApportionMethodLessThanOrEqualToqueryshort?No
ApportionMethodNotEqualToqueryshort?No
ApportionMethodBetweenqueryNullable<Int16>[]No
ApportionMethodInqueryNullable<Int16>[]No
Apportionedquerybool?No
Invoicedquerybool?No
CR_TransIDquerystringNo
CR_TransIDStartsWithquerystringNo
CR_TransIDEndsWithquerystringNo
CR_TransIDContainsquerystringNo
CR_TransIDLikequerystringNo
CR_TransIDBetweenquerystring[]No
CR_TransIDInquerystring[]No
DueDatequeryDateTime?No
DueDateGreaterThanOrEqualToqueryDateTime?No
DueDateGreaterThanqueryDateTime?No
DueDateLessThanqueryDateTime?No
DueDateLessThanOrEqualToqueryDateTime?No
DueDateNotEqualToqueryDateTime?No
DueDateBetweenqueryNullable<DateTime>[]No
DueDateInqueryNullable<DateTime>[]No
InvoiceNoquerystringNo
InvoiceNoStartsWithquerystringNo
InvoiceNoEndsWithquerystringNo
InvoiceNoContainsquerystringNo
InvoiceNoLikequerystringNo
InvoiceNoBetweenquerystring[]No
InvoiceNoInquerystring[]No
ReferencequerystringNo
ReferenceStartsWithquerystringNo
ReferenceEndsWithquerystringNo
ReferenceContainsquerystringNo
ReferenceLikequerystringNo
ReferenceBetweenquerystring[]No
ReferenceInquerystring[]No
CreditorLedgerIDquerystringNo
CreditorLedgerIDStartsWithquerystringNo
CreditorLedgerIDEndsWithquerystringNo
CreditorLedgerIDContainsquerystringNo
CreditorLedgerIDLikequerystringNo
CreditorLedgerIDBetweenquerystring[]No
CreditorLedgerIDInquerystring[]No
LedgerIDquerystringNo
LedgerIDStartsWithquerystringNo
LedgerIDEndsWithquerystringNo
LedgerIDContainsquerystringNo
LedgerIDLikequerystringNo
LedgerIDBetweenquerystring[]No
LedgerIDInquerystring[]No
UserField1querystringNo
UserField1StartsWithquerystringNo
UserField1EndsWithquerystringNo
UserField1ContainsquerystringNo
UserField1LikequerystringNo
UserField1Betweenquerystring[]No
UserField1Inquerystring[]No
UserField2querystringNo
UserField2StartsWithquerystringNo
UserField2EndsWithquerystringNo
UserField2ContainsquerystringNo
UserField2LikequerystringNo
UserField2Betweenquerystring[]No
UserField2Inquerystring[]No
UserField3querystringNo
UserField3StartsWithquerystringNo
UserField3EndsWithquerystringNo
UserField3ContainsquerystringNo
UserField3LikequerystringNo
UserField3Betweenquerystring[]No
UserField3Inquerystring[]No
UserField4querystringNo
UserField4StartsWithquerystringNo
UserField4EndsWithquerystringNo
UserField4ContainsquerystringNo
UserField4LikequerystringNo
UserField4Betweenquerystring[]No
UserField4Inquerystring[]No
UserField5querystringNo
UserField5StartsWithquerystringNo
UserField5EndsWithquerystringNo
UserField5ContainsquerystringNo
UserField5LikequerystringNo
UserField5Betweenquerystring[]No
UserField5Inquerystring[]No
UserField6querystringNo
UserField6StartsWithquerystringNo
UserField6EndsWithquerystringNo
UserField6ContainsquerystringNo
UserField6LikequerystringNo
UserField6Betweenquerystring[]No
UserField6Inquerystring[]No
UserField7querystringNo
UserField7StartsWithquerystringNo
UserField7EndsWithquerystringNo
UserField7ContainsquerystringNo
UserField7LikequerystringNo
UserField7Betweenquerystring[]No
UserField7Inquerystring[]No
UserField8querystringNo
UserField8StartsWithquerystringNo
UserField8EndsWithquerystringNo
UserField8ContainsquerystringNo
UserField8LikequerystringNo
UserField8Betweenquerystring[]No
UserField8Inquerystring[]No
UserField9querystringNo
UserField9StartsWithquerystringNo
UserField9EndsWithquerystringNo
UserField9ContainsquerystringNo
UserField9LikequerystringNo
UserField9Betweenquerystring[]No
UserField9Inquerystring[]No
UserField10querystringNo
UserField10StartsWithquerystringNo
UserField10EndsWithquerystringNo
UserField10ContainsquerystringNo
UserField10LikequerystringNo
UserField10Betweenquerystring[]No
UserField10Inquerystring[]No
LastSavedDateTimequeryDateTime?No
LastSavedDateTimeGreaterThanOrEqualToqueryDateTime?No
LastSavedDateTimeGreaterThanqueryDateTime?No
LastSavedDateTimeLessThanqueryDateTime?No
LastSavedDateTimeLessThanOrEqualToqueryDateTime?No
LastSavedDateTimeNotEqualToqueryDateTime?No
LastSavedDateTimeBetweenqueryDateTime[]No
LastSavedDateTimeInqueryDateTime[]No
AUDDecimalPlacesqueryint?No
AUDDecimalPlacesGreaterThanOrEqualToqueryint?No
AUDDecimalPlacesGreaterThanqueryint?No
AUDDecimalPlacesLessThanqueryint?No
AUDDecimalPlacesLessThanOrEqualToqueryint?No
AUDDecimalPlacesNotEqualToqueryint?No
AUDDecimalPlacesBetweenqueryNullable<Int32>[]No
AUDDecimalPlacesInqueryNullable<Int32>[]No
FXDecimalPlacesqueryint?No
FXDecimalPlacesGreaterThanOrEqualToqueryint?No
FXDecimalPlacesGreaterThanqueryint?No
FXDecimalPlacesLessThanqueryint?No
FXDecimalPlacesLessThanOrEqualToqueryint?No
FXDecimalPlacesNotEqualToqueryint?No
FXDecimalPlacesBetweenqueryNullable<Int32>[]No
FXDecimalPlacesInqueryNullable<Int32>[]No
InvoiceDatequeryDateTime?No
InvoiceDateGreaterThanOrEqualToqueryDateTime?No
InvoiceDateGreaterThanqueryDateTime?No
InvoiceDateLessThanqueryDateTime?No
InvoiceDateLessThanOrEqualToqueryDateTime?No
InvoiceDateNotEqualToqueryDateTime?No
InvoiceDateBetweenqueryNullable<DateTime>[]No
InvoiceDateInqueryNullable<DateTime>[]No
DisplayOrderqueryint?No
DisplayOrderGreaterThanOrEqualToqueryint?No
DisplayOrderGreaterThanqueryint?No
DisplayOrderLessThanqueryint?No
DisplayOrderLessThanOrEqualToqueryint?No
DisplayOrderNotEqualToqueryint?No
DisplayOrderBetweenqueryNullable<Int32>[]No
DisplayOrderInqueryNullable<Int32>[]No
SH_CostTypes_RecIDquerystringNo
SH_CostTypes_RecIDStartsWithquerystringNo
SH_CostTypes_RecIDEndsWithquerystringNo
SH_CostTypes_RecIDContainsquerystringNo
SH_CostTypes_RecIDLikequerystringNo
SH_CostTypes_RecIDBetweenquerystring[]No
SH_CostTypes_RecIDInquerystring[]No
QueryBase Parameters:
NameParameterData TypeRequiredDescription
Skipformint?No
Takeformint?No
OrderByformstringNo
OrderByDescformstringNo
IncludeformstringNo
FieldsformstringNo
MetaformDictionary<string, string>No
SH_Costs Parameters:
NameParameterData TypeRequiredDescription
CostsIDformstringNo
ShipmentIDformstringNo
CreditorIDformstringNo
CostTypeformstringNo
FXAmountformdecimal?No
FXRateformdecimal?No
CurrencyIDformstringNo
HomeAmountformdecimal?No
GSTAmountformdecimal?No
GSTRateformdecimal?No
GSTIDformstringNo
TotalAmountformdecimal?No
ApportionMethodformshort?No
ApportionedformboolNo
InvoicedformboolNo
CR_TransIDformstringNo
DueDateformDateTime?No
InvoiceNoformstringNo
ReferenceformstringNo
CreditorLedgerIDformstringNo
LedgerIDformstringNo
UserField1formstringNo
UserField2formstringNo
UserField3formstringNo
UserField4formstringNo
UserField5formstringNo
UserField6formstringNo
UserField7formstringNo
UserField8formstringNo
UserField9formstringNo
UserField10formstringNo
LastSavedDateTimeformDateTimeNo
AUDDecimalPlacesformint?No
FXDecimalPlacesformint?No
InvoiceDateformDateTime?No
DisplayOrderformint?No
SH_CostTypes_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 .xml suffix or ?format=xml

HTTP + XML

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

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

<SH_CostsQuery xmlns:i="http://www.w3.org/2001/XMLSchema-instance" xmlns="http://schemas.datacontract.org/2004/07/JiwaFinancials.Jiwa.JiwaServiceModel.Tables">
  <Fields xmlns="http://schemas.servicestack.net/types">String</Fields>
  <Include xmlns="http://schemas.servicestack.net/types">String</Include>
  <Meta xmlns:d2p1="http://schemas.microsoft.com/2003/10/Serialization/Arrays" xmlns="http://schemas.servicestack.net/types">
    <d2p1:KeyValueOfstringstring>
      <d2p1:Key>String</d2p1:Key>
      <d2p1:Value>String</d2p1:Value>
    </d2p1:KeyValueOfstringstring>
  </Meta>
  <OrderBy xmlns="http://schemas.servicestack.net/types">String</OrderBy>
  <OrderByDesc xmlns="http://schemas.servicestack.net/types">String</OrderByDesc>
  <Skip xmlns="http://schemas.servicestack.net/types">0</Skip>
  <Take xmlns="http://schemas.servicestack.net/types">0</Take>
  <AUDDecimalPlaces>0</AUDDecimalPlaces>
  <AUDDecimalPlacesBetween xmlns:d2p1="http://schemas.datacontract.org/2004/07/System">
    <d2p1:int>0</d2p1:int>
  </AUDDecimalPlacesBetween>
  <AUDDecimalPlacesGreaterThan>0</AUDDecimalPlacesGreaterThan>
  <AUDDecimalPlacesGreaterThanOrEqualTo>0</AUDDecimalPlacesGreaterThanOrEqualTo>
  <AUDDecimalPlacesIn xmlns:d2p1="http://schemas.datacontract.org/2004/07/System">
    <d2p1:int>0</d2p1:int>
  </AUDDecimalPlacesIn>
  <AUDDecimalPlacesLessThan>0</AUDDecimalPlacesLessThan>
  <AUDDecimalPlacesLessThanOrEqualTo>0</AUDDecimalPlacesLessThanOrEqualTo>
  <AUDDecimalPlacesNotEqualTo>0</AUDDecimalPlacesNotEqualTo>
  <ApportionMethod>0</ApportionMethod>
  <ApportionMethodBetween xmlns:d2p1="http://schemas.datacontract.org/2004/07/System">
    <d2p1:short>0</d2p1:short>
  </ApportionMethodBetween>
  <ApportionMethodGreaterThan>0</ApportionMethodGreaterThan>
  <ApportionMethodGreaterThanOrEqualTo>0</ApportionMethodGreaterThanOrEqualTo>
  <ApportionMethodIn xmlns:d2p1="http://schemas.datacontract.org/2004/07/System">
    <d2p1:short>0</d2p1:short>
  </ApportionMethodIn>
  <ApportionMethodLessThan>0</ApportionMethodLessThan>
  <ApportionMethodLessThanOrEqualTo>0</ApportionMethodLessThanOrEqualTo>
  <ApportionMethodNotEqualTo>0</ApportionMethodNotEqualTo>
  <Apportioned>false</Apportioned>
  <CR_TransID>String</CR_TransID>
  <CR_TransIDBetween xmlns:d2p1="http://schemas.microsoft.com/2003/10/Serialization/Arrays">
    <d2p1:string>String</d2p1:string>
  </CR_TransIDBetween>
  <CR_TransIDContains>String</CR_TransIDContains>
  <CR_TransIDEndsWith>String</CR_TransIDEndsWith>
  <CR_TransIDIn xmlns:d2p1="http://schemas.microsoft.com/2003/10/Serialization/Arrays">
    <d2p1:string>String</d2p1:string>
  </CR_TransIDIn>
  <CR_TransIDLike>String</CR_TransIDLike>
  <CR_TransIDStartsWith>String</CR_TransIDStartsWith>
  <CostType>String</CostType>
  <CostTypeBetween xmlns:d2p1="http://schemas.microsoft.com/2003/10/Serialization/Arrays">
    <d2p1:string>String</d2p1:string>
  </CostTypeBetween>
  <CostTypeContains>String</CostTypeContains>
  <CostTypeEndsWith>String</CostTypeEndsWith>
  <CostTypeIn xmlns:d2p1="http://schemas.microsoft.com/2003/10/Serialization/Arrays">
    <d2p1:string>String</d2p1:string>
  </CostTypeIn>
  <CostTypeLike>String</CostTypeLike>
  <CostTypeStartsWith>String</CostTypeStartsWith>
  <CostsID>String</CostsID>
  <CostsIDBetween xmlns:d2p1="http://schemas.microsoft.com/2003/10/Serialization/Arrays">
    <d2p1:string>String</d2p1:string>
  </CostsIDBetween>
  <CostsIDContains>String</CostsIDContains>
  <CostsIDEndsWith>String</CostsIDEndsWith>
  <CostsIDIn xmlns:d2p1="http://schemas.microsoft.com/2003/10/Serialization/Arrays">
    <d2p1:string>String</d2p1:string>
  </CostsIDIn>
  <CostsIDLike>String</CostsIDLike>
  <CostsIDStartsWith>String</CostsIDStartsWith>
  <CreditorID>String</CreditorID>
  <CreditorIDBetween xmlns:d2p1="http://schemas.microsoft.com/2003/10/Serialization/Arrays">
    <d2p1:string>String</d2p1:string>
  </CreditorIDBetween>
  <CreditorIDContains>String</CreditorIDContains>
  <CreditorIDEndsWith>String</CreditorIDEndsWith>
  <CreditorIDIn xmlns:d2p1="http://schemas.microsoft.com/2003/10/Serialization/Arrays">
    <d2p1:string>String</d2p1:string>
  </CreditorIDIn>
  <CreditorIDLike>String</CreditorIDLike>
  <CreditorIDStartsWith>String</CreditorIDStartsWith>
  <CreditorLedgerID>String</CreditorLedgerID>
  <CreditorLedgerIDBetween xmlns:d2p1="http://schemas.microsoft.com/2003/10/Serialization/Arrays">
    <d2p1:string>String</d2p1:string>
  </CreditorLedgerIDBetween>
  <CreditorLedgerIDContains>String</CreditorLedgerIDContains>
  <CreditorLedgerIDEndsWith>String</CreditorLedgerIDEndsWith>
  <CreditorLedgerIDIn xmlns:d2p1="http://schemas.microsoft.com/2003/10/Serialization/Arrays">
    <d2p1:string>String</d2p1:string>
  </CreditorLedgerIDIn>
  <CreditorLedgerIDLike>String</CreditorLedgerIDLike>
  <CreditorLedgerIDStartsWith>String</CreditorLedgerIDStartsWith>
  <CurrencyID>String</CurrencyID>
  <CurrencyIDBetween xmlns:d2p1="http://schemas.microsoft.com/2003/10/Serialization/Arrays">
    <d2p1:string>String</d2p1:string>
  </CurrencyIDBetween>
  <CurrencyIDContains>String</CurrencyIDContains>
  <CurrencyIDEndsWith>String</CurrencyIDEndsWith>
  <CurrencyIDIn xmlns:d2p1="http://schemas.microsoft.com/2003/10/Serialization/Arrays">
    <d2p1:string>String</d2p1:string>
  </CurrencyIDIn>
  <CurrencyIDLike>String</CurrencyIDLike>
  <CurrencyIDStartsWith>String</CurrencyIDStartsWith>
  <DisplayOrder>0</DisplayOrder>
  <DisplayOrderBetween xmlns:d2p1="http://schemas.datacontract.org/2004/07/System">
    <d2p1:int>0</d2p1:int>
  </DisplayOrderBetween>
  <DisplayOrderGreaterThan>0</DisplayOrderGreaterThan>
  <DisplayOrderGreaterThanOrEqualTo>0</DisplayOrderGreaterThanOrEqualTo>
  <DisplayOrderIn xmlns:d2p1="http://schemas.datacontract.org/2004/07/System">
    <d2p1:int>0</d2p1:int>
  </DisplayOrderIn>
  <DisplayOrderLessThan>0</DisplayOrderLessThan>
  <DisplayOrderLessThanOrEqualTo>0</DisplayOrderLessThanOrEqualTo>
  <DisplayOrderNotEqualTo>0</DisplayOrderNotEqualTo>
  <DueDate>0001-01-01T00:00:00</DueDate>
  <DueDateBetween xmlns:d2p1="http://schemas.datacontract.org/2004/07/System">
    <d2p1:dateTime>0001-01-01T00:00:00</d2p1:dateTime>
  </DueDateBetween>
  <DueDateGreaterThan>0001-01-01T00:00:00</DueDateGreaterThan>
  <DueDateGreaterThanOrEqualTo>0001-01-01T00:00:00</DueDateGreaterThanOrEqualTo>
  <DueDateIn xmlns:d2p1="http://schemas.datacontract.org/2004/07/System">
    <d2p1:dateTime>0001-01-01T00:00:00</d2p1:dateTime>
  </DueDateIn>
  <DueDateLessThan>0001-01-01T00:00:00</DueDateLessThan>
  <DueDateLessThanOrEqualTo>0001-01-01T00:00:00</DueDateLessThanOrEqualTo>
  <DueDateNotEqualTo>0001-01-01T00:00:00</DueDateNotEqualTo>
  <FXAmount>0</FXAmount>
  <FXAmountBetween xmlns:d2p1="http://schemas.datacontract.org/2004/07/System">
    <d2p1:decimal>0</d2p1:decimal>
  </FXAmountBetween>
  <FXAmountGreaterThan>0</FXAmountGreaterThan>
  <FXAmountGreaterThanOrEqualTo>0</FXAmountGreaterThanOrEqualTo>
  <FXAmountIn xmlns:d2p1="http://schemas.datacontract.org/2004/07/System">
    <d2p1:decimal>0</d2p1:decimal>
  </FXAmountIn>
  <FXAmountLessThan>0</FXAmountLessThan>
  <FXAmountLessThanOrEqualTo>0</FXAmountLessThanOrEqualTo>
  <FXAmountNotEqualTo>0</FXAmountNotEqualTo>
  <FXDecimalPlaces>0</FXDecimalPlaces>
  <FXDecimalPlacesBetween xmlns:d2p1="http://schemas.datacontract.org/2004/07/System">
    <d2p1:int>0</d2p1:int>
  </FXDecimalPlacesBetween>
  <FXDecimalPlacesGreaterThan>0</FXDecimalPlacesGreaterThan>
  <FXDecimalPlacesGreaterThanOrEqualTo>0</FXDecimalPlacesGreaterThanOrEqualTo>
  <FXDecimalPlacesIn xmlns:d2p1="http://schemas.datacontract.org/2004/07/System">
    <d2p1:int>0</d2p1:int>
  </FXDecimalPlacesIn>
  <FXDecimalPlacesLessThan>0</FXDecimalPlacesLessThan>
  <FXDecimalPlacesLessThanOrEqualTo>0</FXDecimalPlacesLessThanOrEqualTo>
  <FXDecimalPlacesNotEqualTo>0</FXDecimalPlacesNotEqualTo>
  <FXRate>0</FXRate>
  <FXRateBetween xmlns:d2p1="http://schemas.datacontract.org/2004/07/System">
    <d2p1:decimal>0</d2p1:decimal>
  </FXRateBetween>
  <FXRateGreaterThan>0</FXRateGreaterThan>
  <FXRateGreaterThanOrEqualTo>0</FXRateGreaterThanOrEqualTo>
  <FXRateIn xmlns:d2p1="http://schemas.datacontract.org/2004/07/System">
    <d2p1:decimal>0</d2p1:decimal>
  </FXRateIn>
  <FXRateLessThan>0</FXRateLessThan>
  <FXRateLessThanOrEqualTo>0</FXRateLessThanOrEqualTo>
  <FXRateNotEqualTo>0</FXRateNotEqualTo>
  <GSTAmount>0</GSTAmount>
  <GSTAmountBetween xmlns:d2p1="http://schemas.datacontract.org/2004/07/System">
    <d2p1:decimal>0</d2p1:decimal>
  </GSTAmountBetween>
  <GSTAmountGreaterThan>0</GSTAmountGreaterThan>
  <GSTAmountGreaterThanOrEqualTo>0</GSTAmountGreaterThanOrEqualTo>
  <GSTAmountIn xmlns:d2p1="http://schemas.datacontract.org/2004/07/System">
    <d2p1:decimal>0</d2p1:decimal>
  </GSTAmountIn>
  <GSTAmountLessThan>0</GSTAmountLessThan>
  <GSTAmountLessThanOrEqualTo>0</GSTAmountLessThanOrEqualTo>
  <GSTAmountNotEqualTo>0</GSTAmountNotEqualTo>
  <GSTID>String</GSTID>
  <GSTIDBetween xmlns:d2p1="http://schemas.microsoft.com/2003/10/Serialization/Arrays">
    <d2p1:string>String</d2p1:string>
  </GSTIDBetween>
  <GSTIDContains>String</GSTIDContains>
  <GSTIDEndsWith>String</GSTIDEndsWith>
  <GSTIDIn xmlns:d2p1="http://schemas.microsoft.com/2003/10/Serialization/Arrays">
    <d2p1:string>String</d2p1:string>
  </GSTIDIn>
  <GSTIDLike>String</GSTIDLike>
  <GSTIDStartsWith>String</GSTIDStartsWith>
  <GSTRate>0</GSTRate>
  <GSTRateBetween xmlns:d2p1="http://schemas.datacontract.org/2004/07/System">
    <d2p1:decimal>0</d2p1:decimal>
  </GSTRateBetween>
  <GSTRateGreaterThan>0</GSTRateGreaterThan>
  <GSTRateGreaterThanOrEqualTo>0</GSTRateGreaterThanOrEqualTo>
  <GSTRateIn xmlns:d2p1="http://schemas.datacontract.org/2004/07/System">
    <d2p1:decimal>0</d2p1:decimal>
  </GSTRateIn>
  <GSTRateLessThan>0</GSTRateLessThan>
  <GSTRateLessThanOrEqualTo>0</GSTRateLessThanOrEqualTo>
  <GSTRateNotEqualTo>0</GSTRateNotEqualTo>
  <HomeAmount>0</HomeAmount>
  <HomeAmountBetween xmlns:d2p1="http://schemas.datacontract.org/2004/07/System">
    <d2p1:decimal>0</d2p1:decimal>
  </HomeAmountBetween>
  <HomeAmountGreaterThan>0</HomeAmountGreaterThan>
  <HomeAmountGreaterThanOrEqualTo>0</HomeAmountGreaterThanOrEqualTo>
  <HomeAmountIn xmlns:d2p1="http://schemas.datacontract.org/2004/07/System">
    <d2p1:decimal>0</d2p1:decimal>
  </HomeAmountIn>
  <HomeAmountLessThan>0</HomeAmountLessThan>
  <HomeAmountLessThanOrEqualTo>0</HomeAmountLessThanOrEqualTo>
  <HomeAmountNotEqualTo>0</HomeAmountNotEqualTo>
  <InvoiceDate>0001-01-01T00:00:00</InvoiceDate>
  <InvoiceDateBetween xmlns:d2p1="http://schemas.datacontract.org/2004/07/System">
    <d2p1:dateTime>0001-01-01T00:00:00</d2p1:dateTime>
  </InvoiceDateBetween>
  <InvoiceDateGreaterThan>0001-01-01T00:00:00</InvoiceDateGreaterThan>
  <InvoiceDateGreaterThanOrEqualTo>0001-01-01T00:00:00</InvoiceDateGreaterThanOrEqualTo>
  <InvoiceDateIn xmlns:d2p1="http://schemas.datacontract.org/2004/07/System">
    <d2p1:dateTime>0001-01-01T00:00:00</d2p1:dateTime>
  </InvoiceDateIn>
  <InvoiceDateLessThan>0001-01-01T00:00:00</InvoiceDateLessThan>
  <InvoiceDateLessThanOrEqualTo>0001-01-01T00:00:00</InvoiceDateLessThanOrEqualTo>
  <InvoiceDateNotEqualTo>0001-01-01T00:00:00</InvoiceDateNotEqualTo>
  <InvoiceNo>String</InvoiceNo>
  <InvoiceNoBetween xmlns:d2p1="http://schemas.microsoft.com/2003/10/Serialization/Arrays">
    <d2p1:string>String</d2p1:string>
  </InvoiceNoBetween>
  <InvoiceNoContains>String</InvoiceNoContains>
  <InvoiceNoEndsWith>String</InvoiceNoEndsWith>
  <InvoiceNoIn xmlns:d2p1="http://schemas.microsoft.com/2003/10/Serialization/Arrays">
    <d2p1:string>String</d2p1:string>
  </InvoiceNoIn>
  <InvoiceNoLike>String</InvoiceNoLike>
  <InvoiceNoStartsWith>String</InvoiceNoStartsWith>
  <Invoiced>false</Invoiced>
  <LastSavedDateTime>0001-01-01T00:00:00</LastSavedDateTime>
  <LastSavedDateTimeBetween xmlns:d2p1="http://schemas.microsoft.com/2003/10/Serialization/Arrays">
    <d2p1:dateTime>0001-01-01T00:00:00</d2p1:dateTime>
  </LastSavedDateTimeBetween>
  <LastSavedDateTimeGreaterThan>0001-01-01T00:00:00</LastSavedDateTimeGreaterThan>
  <LastSavedDateTimeGreaterThanOrEqualTo>0001-01-01T00:00:00</LastSavedDateTimeGreaterThanOrEqualTo>
  <LastSavedDateTimeIn xmlns:d2p1="http://schemas.microsoft.com/2003/10/Serialization/Arrays">
    <d2p1:dateTime>0001-01-01T00:00:00</d2p1:dateTime>
  </LastSavedDateTimeIn>
  <LastSavedDateTimeLessThan>0001-01-01T00:00:00</LastSavedDateTimeLessThan>
  <LastSavedDateTimeLessThanOrEqualTo>0001-01-01T00:00:00</LastSavedDateTimeLessThanOrEqualTo>
  <LastSavedDateTimeNotEqualTo>0001-01-01T00:00:00</LastSavedDateTimeNotEqualTo>
  <LedgerID>String</LedgerID>
  <LedgerIDBetween xmlns:d2p1="http://schemas.microsoft.com/2003/10/Serialization/Arrays">
    <d2p1:string>String</d2p1:string>
  </LedgerIDBetween>
  <LedgerIDContains>String</LedgerIDContains>
  <LedgerIDEndsWith>String</LedgerIDEndsWith>
  <LedgerIDIn xmlns:d2p1="http://schemas.microsoft.com/2003/10/Serialization/Arrays">
    <d2p1:string>String</d2p1:string>
  </LedgerIDIn>
  <LedgerIDLike>String</LedgerIDLike>
  <LedgerIDStartsWith>String</LedgerIDStartsWith>
  <Reference>String</Reference>
  <ReferenceBetween xmlns:d2p1="http://schemas.microsoft.com/2003/10/Serialization/Arrays">
    <d2p1:string>String</d2p1:string>
  </ReferenceBetween>
  <ReferenceContains>String</ReferenceContains>
  <ReferenceEndsWith>String</ReferenceEndsWith>
  <ReferenceIn xmlns:d2p1="http://schemas.microsoft.com/2003/10/Serialization/Arrays">
    <d2p1:string>String</d2p1:string>
  </ReferenceIn>
  <ReferenceLike>String</ReferenceLike>
  <ReferenceStartsWith>String</ReferenceStartsWith>
  <SH_CostTypes_RecID>String</SH_CostTypes_RecID>
  <SH_CostTypes_RecIDBetween xmlns:d2p1="http://schemas.microsoft.com/2003/10/Serialization/Arrays">
    <d2p1:string>String</d2p1:string>
  </SH_CostTypes_RecIDBetween>
  <SH_CostTypes_RecIDContains>String</SH_CostTypes_RecIDContains>
  <SH_CostTypes_RecIDEndsWith>String</SH_CostTypes_RecIDEndsWith>
  <SH_CostTypes_RecIDIn xmlns:d2p1="http://schemas.microsoft.com/2003/10/Serialization/Arrays">
    <d2p1:string>String</d2p1:string>
  </SH_CostTypes_RecIDIn>
  <SH_CostTypes_RecIDLike>String</SH_CostTypes_RecIDLike>
  <SH_CostTypes_RecIDStartsWith>String</SH_CostTypes_RecIDStartsWith>
  <ShipmentID>String</ShipmentID>
  <ShipmentIDBetween xmlns:d2p1="http://schemas.microsoft.com/2003/10/Serialization/Arrays">
    <d2p1:string>String</d2p1:string>
  </ShipmentIDBetween>
  <ShipmentIDContains>String</ShipmentIDContains>
  <ShipmentIDEndsWith>String</ShipmentIDEndsWith>
  <ShipmentIDIn xmlns:d2p1="http://schemas.microsoft.com/2003/10/Serialization/Arrays">
    <d2p1:string>String</d2p1:string>
  </ShipmentIDIn>
  <ShipmentIDLike>String</ShipmentIDLike>
  <ShipmentIDStartsWith>String</ShipmentIDStartsWith>
  <TotalAmount>0</TotalAmount>
  <TotalAmountBetween xmlns:d2p1="http://schemas.datacontract.org/2004/07/System">
    <d2p1:decimal>0</d2p1:decimal>
  </TotalAmountBetween>
  <TotalAmountGreaterThan>0</TotalAmountGreaterThan>
  <TotalAmountGreaterThanOrEqualTo>0</TotalAmountGreaterThanOrEqualTo>
  <TotalAmountIn xmlns:d2p1="http://schemas.datacontract.org/2004/07/System">
    <d2p1:decimal>0</d2p1:decimal>
  </TotalAmountIn>
  <TotalAmountLessThan>0</TotalAmountLessThan>
  <TotalAmountLessThanOrEqualTo>0</TotalAmountLessThanOrEqualTo>
  <TotalAmountNotEqualTo>0</TotalAmountNotEqualTo>
  <UserField1>String</UserField1>
  <UserField10>String</UserField10>
  <UserField10Between xmlns:d2p1="http://schemas.microsoft.com/2003/10/Serialization/Arrays">
    <d2p1:string>String</d2p1:string>
  </UserField10Between>
  <UserField10Contains>String</UserField10Contains>
  <UserField10EndsWith>String</UserField10EndsWith>
  <UserField10In xmlns:d2p1="http://schemas.microsoft.com/2003/10/Serialization/Arrays">
    <d2p1:string>String</d2p1:string>
  </UserField10In>
  <UserField10Like>String</UserField10Like>
  <UserField10StartsWith>String</UserField10StartsWith>
  <UserField1Between xmlns:d2p1="http://schemas.microsoft.com/2003/10/Serialization/Arrays">
    <d2p1:string>String</d2p1:string>
  </UserField1Between>
  <UserField1Contains>String</UserField1Contains>
  <UserField1EndsWith>String</UserField1EndsWith>
  <UserField1In xmlns:d2p1="http://schemas.microsoft.com/2003/10/Serialization/Arrays">
    <d2p1:string>String</d2p1:string>
  </UserField1In>
  <UserField1Like>String</UserField1Like>
  <UserField1StartsWith>String</UserField1StartsWith>
  <UserField2>String</UserField2>
  <UserField2Between xmlns:d2p1="http://schemas.microsoft.com/2003/10/Serialization/Arrays">
    <d2p1:string>String</d2p1:string>
  </UserField2Between>
  <UserField2Contains>String</UserField2Contains>
  <UserField2EndsWith>String</UserField2EndsWith>
  <UserField2In xmlns:d2p1="http://schemas.microsoft.com/2003/10/Serialization/Arrays">
    <d2p1:string>String</d2p1:string>
  </UserField2In>
  <UserField2Like>String</UserField2Like>
  <UserField2StartsWith>String</UserField2StartsWith>
  <UserField3>String</UserField3>
  <UserField3Between xmlns:d2p1="http://schemas.microsoft.com/2003/10/Serialization/Arrays">
    <d2p1:string>String</d2p1:string>
  </UserField3Between>
  <UserField3Contains>String</UserField3Contains>
  <UserField3EndsWith>String</UserField3EndsWith>
  <UserField3In xmlns:d2p1="http://schemas.microsoft.com/2003/10/Serialization/Arrays">
    <d2p1:string>String</d2p1:string>
  </UserField3In>
  <UserField3Like>String</UserField3Like>
  <UserField3StartsWith>String</UserField3StartsWith>
  <UserField4>String</UserField4>
  <UserField4Between xmlns:d2p1="http://schemas.microsoft.com/2003/10/Serialization/Arrays">
    <d2p1:string>String</d2p1:string>
  </UserField4Between>
  <UserField4Contains>String</UserField4Contains>
  <UserField4EndsWith>String</UserField4EndsWith>
  <UserField4In xmlns:d2p1="http://schemas.microsoft.com/2003/10/Serialization/Arrays">
    <d2p1:string>String</d2p1:string>
  </UserField4In>
  <UserField4Like>String</UserField4Like>
  <UserField4StartsWith>String</UserField4StartsWith>
  <UserField5>String</UserField5>
  <UserField5Between xmlns:d2p1="http://schemas.microsoft.com/2003/10/Serialization/Arrays">
    <d2p1:string>String</d2p1:string>
  </UserField5Between>
  <UserField5Contains>String</UserField5Contains>
  <UserField5EndsWith>String</UserField5EndsWith>
  <UserField5In xmlns:d2p1="http://schemas.microsoft.com/2003/10/Serialization/Arrays">
    <d2p1:string>String</d2p1:string>
  </UserField5In>
  <UserField5Like>String</UserField5Like>
  <UserField5StartsWith>String</UserField5StartsWith>
  <UserField6>String</UserField6>
  <UserField6Between xmlns:d2p1="http://schemas.microsoft.com/2003/10/Serialization/Arrays">
    <d2p1:string>String</d2p1:string>
  </UserField6Between>
  <UserField6Contains>String</UserField6Contains>
  <UserField6EndsWith>String</UserField6EndsWith>
  <UserField6In xmlns:d2p1="http://schemas.microsoft.com/2003/10/Serialization/Arrays">
    <d2p1:string>String</d2p1:string>
  </UserField6In>
  <UserField6Like>String</UserField6Like>
  <UserField6StartsWith>String</UserField6StartsWith>
  <UserField7>String</UserField7>
  <UserField7Between xmlns:d2p1="http://schemas.microsoft.com/2003/10/Serialization/Arrays">
    <d2p1:string>String</d2p1:string>
  </UserField7Between>
  <UserField7Contains>String</UserField7Contains>
  <UserField7EndsWith>String</UserField7EndsWith>
  <UserField7In xmlns:d2p1="http://schemas.microsoft.com/2003/10/Serialization/Arrays">
    <d2p1:string>String</d2p1:string>
  </UserField7In>
  <UserField7Like>String</UserField7Like>
  <UserField7StartsWith>String</UserField7StartsWith>
  <UserField8>String</UserField8>
  <UserField8Between xmlns:d2p1="http://schemas.microsoft.com/2003/10/Serialization/Arrays">
    <d2p1:string>String</d2p1:string>
  </UserField8Between>
  <UserField8Contains>String</UserField8Contains>
  <UserField8EndsWith>String</UserField8EndsWith>
  <UserField8In xmlns:d2p1="http://schemas.microsoft.com/2003/10/Serialization/Arrays">
    <d2p1:string>String</d2p1:string>
  </UserField8In>
  <UserField8Like>String</UserField8Like>
  <UserField8StartsWith>String</UserField8StartsWith>
  <UserField9>String</UserField9>
  <UserField9Between xmlns:d2p1="http://schemas.microsoft.com/2003/10/Serialization/Arrays">
    <d2p1:string>String</d2p1:string>
  </UserField9Between>
  <UserField9Contains>String</UserField9Contains>
  <UserField9EndsWith>String</UserField9EndsWith>
  <UserField9In xmlns:d2p1="http://schemas.microsoft.com/2003/10/Serialization/Arrays">
    <d2p1:string>String</d2p1:string>
  </UserField9In>
  <UserField9Like>String</UserField9Like>
  <UserField9StartsWith>String</UserField9StartsWith>
</SH_CostsQuery>
HTTP/1.1 200 OK
Content-Type: application/xml
Content-Length: length

<QueryResponseOfSH_Costs7kRqkrSv xmlns:i="http://www.w3.org/2001/XMLSchema-instance" xmlns="http://schemas.servicestack.net/types">
  <Offset>0</Offset>
  <Total>0</Total>
  <Results xmlns:d2p1="http://schemas.datacontract.org/2004/07/JiwaFinancials.Jiwa.JiwaServiceModel.Tables">
    <d2p1:SH_Costs>
      <d2p1:_x003C_AUDDecimalPlaces_x003E_k__BackingField>0</d2p1:_x003C_AUDDecimalPlaces_x003E_k__BackingField>
      <d2p1:_x003C_ApportionMethod_x003E_k__BackingField>0</d2p1:_x003C_ApportionMethod_x003E_k__BackingField>
      <d2p1:_x003C_Apportioned_x003E_k__BackingField>false</d2p1:_x003C_Apportioned_x003E_k__BackingField>
      <d2p1:_x003C_CR_TransID_x003E_k__BackingField>String</d2p1:_x003C_CR_TransID_x003E_k__BackingField>
      <d2p1:_x003C_CostType_x003E_k__BackingField>String</d2p1:_x003C_CostType_x003E_k__BackingField>
      <d2p1:_x003C_CostsID_x003E_k__BackingField>String</d2p1:_x003C_CostsID_x003E_k__BackingField>
      <d2p1:_x003C_CreditorID_x003E_k__BackingField>String</d2p1:_x003C_CreditorID_x003E_k__BackingField>
      <d2p1:_x003C_CreditorLedgerID_x003E_k__BackingField>String</d2p1:_x003C_CreditorLedgerID_x003E_k__BackingField>
      <d2p1:_x003C_CurrencyID_x003E_k__BackingField>String</d2p1:_x003C_CurrencyID_x003E_k__BackingField>
      <d2p1:_x003C_DisplayOrder_x003E_k__BackingField>0</d2p1:_x003C_DisplayOrder_x003E_k__BackingField>
      <d2p1:_x003C_DueDate_x003E_k__BackingField>0001-01-01T00:00:00</d2p1:_x003C_DueDate_x003E_k__BackingField>
      <d2p1:_x003C_FXAmount_x003E_k__BackingField>0</d2p1:_x003C_FXAmount_x003E_k__BackingField>
      <d2p1:_x003C_FXDecimalPlaces_x003E_k__BackingField>0</d2p1:_x003C_FXDecimalPlaces_x003E_k__BackingField>
      <d2p1:_x003C_FXRate_x003E_k__BackingField>0</d2p1:_x003C_FXRate_x003E_k__BackingField>
      <d2p1:_x003C_GSTAmount_x003E_k__BackingField>0</d2p1:_x003C_GSTAmount_x003E_k__BackingField>
      <d2p1:_x003C_GSTID_x003E_k__BackingField>String</d2p1:_x003C_GSTID_x003E_k__BackingField>
      <d2p1:_x003C_GSTRate_x003E_k__BackingField>0</d2p1:_x003C_GSTRate_x003E_k__BackingField>
      <d2p1:_x003C_HomeAmount_x003E_k__BackingField>0</d2p1:_x003C_HomeAmount_x003E_k__BackingField>
      <d2p1:_x003C_InvoiceDate_x003E_k__BackingField>0001-01-01T00:00:00</d2p1:_x003C_InvoiceDate_x003E_k__BackingField>
      <d2p1:_x003C_InvoiceNo_x003E_k__BackingField>String</d2p1:_x003C_InvoiceNo_x003E_k__BackingField>
      <d2p1:_x003C_Invoiced_x003E_k__BackingField>false</d2p1:_x003C_Invoiced_x003E_k__BackingField>
      <d2p1:_x003C_LastSavedDateTime_x003E_k__BackingField>0001-01-01T00:00:00</d2p1:_x003C_LastSavedDateTime_x003E_k__BackingField>
      <d2p1:_x003C_LedgerID_x003E_k__BackingField>String</d2p1:_x003C_LedgerID_x003E_k__BackingField>
      <d2p1:_x003C_Reference_x003E_k__BackingField>String</d2p1:_x003C_Reference_x003E_k__BackingField>
      <d2p1:_x003C_SH_CostTypes_RecID_x003E_k__BackingField>String</d2p1:_x003C_SH_CostTypes_RecID_x003E_k__BackingField>
      <d2p1:_x003C_ShipmentID_x003E_k__BackingField>String</d2p1:_x003C_ShipmentID_x003E_k__BackingField>
      <d2p1:_x003C_TotalAmount_x003E_k__BackingField>0</d2p1:_x003C_TotalAmount_x003E_k__BackingField>
      <d2p1:_x003C_UserField10_x003E_k__BackingField>String</d2p1:_x003C_UserField10_x003E_k__BackingField>
      <d2p1:_x003C_UserField1_x003E_k__BackingField>String</d2p1:_x003C_UserField1_x003E_k__BackingField>
      <d2p1:_x003C_UserField2_x003E_k__BackingField>String</d2p1:_x003C_UserField2_x003E_k__BackingField>
      <d2p1:_x003C_UserField3_x003E_k__BackingField>String</d2p1:_x003C_UserField3_x003E_k__BackingField>
      <d2p1:_x003C_UserField4_x003E_k__BackingField>String</d2p1:_x003C_UserField4_x003E_k__BackingField>
      <d2p1:_x003C_UserField5_x003E_k__BackingField>String</d2p1:_x003C_UserField5_x003E_k__BackingField>
      <d2p1:_x003C_UserField6_x003E_k__BackingField>String</d2p1:_x003C_UserField6_x003E_k__BackingField>
      <d2p1:_x003C_UserField7_x003E_k__BackingField>String</d2p1:_x003C_UserField7_x003E_k__BackingField>
      <d2p1:_x003C_UserField8_x003E_k__BackingField>String</d2p1:_x003C_UserField8_x003E_k__BackingField>
      <d2p1:_x003C_UserField9_x003E_k__BackingField>String</d2p1:_x003C_UserField9_x003E_k__BackingField>
    </d2p1:SH_Costs>
  </Results>
  <Meta xmlns:d2p1="http://schemas.microsoft.com/2003/10/Serialization/Arrays">
    <d2p1:KeyValueOfstringstring>
      <d2p1:Key>String</d2p1:Key>
      <d2p1:Value>String</d2p1:Value>
    </d2p1:KeyValueOfstringstring>
  </Meta>
  <ResponseStatus>
    <ErrorCode>String</ErrorCode>
    <Message>String</Message>
    <StackTrace>String</StackTrace>
    <Errors>
      <ResponseError>
        <ErrorCode>String</ErrorCode>
        <FieldName>String</FieldName>
        <Message>String</Message>
        <Meta xmlns:d5p1="http://schemas.microsoft.com/2003/10/Serialization/Arrays">
          <d5p1:KeyValueOfstringstring>
            <d5p1:Key>String</d5p1:Key>
            <d5p1:Value>String</d5p1:Value>
          </d5p1:KeyValueOfstringstring>
        </Meta>
      </ResponseError>
    </Errors>
    <Meta xmlns:d3p1="http://schemas.microsoft.com/2003/10/Serialization/Arrays">
      <d3p1:KeyValueOfstringstring>
        <d3p1:Key>String</d3p1:Key>
        <d3p1:Value>String</d3p1:Value>
      </d3p1:KeyValueOfstringstring>
    </Meta>
  </ResponseStatus>
</QueryResponseOfSH_Costs7kRqkrSv>