JiwaAPI

<back to all web services

DB_TransQuery

Requires Authentication
DB_TransQuery Parameters:
NameParameterData TypeRequiredDescription
TransIDquerystringNo
TransIDStartsWithquerystringNo
TransIDEndsWithquerystringNo
TransIDContainsquerystringNo
TransIDLikequerystringNo
TransIDBetweenquerystring[]No
TransIDInquerystring[]No
DebtorIDquerystringNo
DebtorIDStartsWithquerystringNo
DebtorIDEndsWithquerystringNo
DebtorIDContainsquerystringNo
DebtorIDLikequerystringNo
DebtorIDBetweenquerystring[]No
DebtorIDInquerystring[]No
DebitCreditquerybool?No
SourcequerystringNo
SourceStartsWithquerystringNo
SourceEndsWithquerystringNo
SourceContainsquerystringNo
SourceLikequerystringNo
SourceBetweenquerystring[]No
SourceInquerystring[]No
RefquerystringNo
RefStartsWithquerystringNo
RefEndsWithquerystringNo
RefContainsquerystringNo
RefLikequerystringNo
RefBetweenquerystring[]No
RefInquerystring[]No
RemarkquerystringNo
RemarkStartsWithquerystringNo
RemarkEndsWithquerystringNo
RemarkContainsquerystringNo
RemarkLikequerystringNo
RemarkBetweenquerystring[]No
RemarkInquerystring[]No
TranDatequeryDateTime?No
TranDateGreaterThanOrEqualToqueryDateTime?No
TranDateGreaterThanqueryDateTime?No
TranDateLessThanqueryDateTime?No
TranDateLessThanOrEqualToqueryDateTime?No
TranDateNotEqualToqueryDateTime?No
TranDateBetweenqueryNullable<DateTime>[]No
TranDateInqueryNullable<DateTime>[]No
InvRemitNoquerystringNo
InvRemitNoStartsWithquerystringNo
InvRemitNoEndsWithquerystringNo
InvRemitNoContainsquerystringNo
InvRemitNoLikequerystringNo
InvRemitNoBetweenquerystring[]No
InvRemitNoInquerystring[]No
Amountquerydecimal?No
AmountGreaterThanOrEqualToquerydecimal?No
AmountGreaterThanquerydecimal?No
AmountLessThanquerydecimal?No
AmountLessThanOrEqualToquerydecimal?No
AmountNotEqualToquerydecimal?No
AmountBetweenqueryNullable<Decimal>[]No
AmountInqueryNullable<Decimal>[]No
DiscountedAmountquerydecimal?No
DiscountedAmountGreaterThanOrEqualToquerydecimal?No
DiscountedAmountGreaterThanquerydecimal?No
DiscountedAmountLessThanquerydecimal?No
DiscountedAmountLessThanOrEqualToquerydecimal?No
DiscountedAmountNotEqualToquerydecimal?No
DiscountedAmountBetweenqueryNullable<Decimal>[]No
DiscountedAmountInqueryNullable<Decimal>[]No
AgedOutquerybool?No
SourceIDquerystringNo
SourceIDStartsWithquerystringNo
SourceIDEndsWithquerystringNo
SourceIDContainsquerystringNo
SourceIDLikequerystringNo
SourceIDBetweenquerystring[]No
SourceIDInquerystring[]No
AllocatedAmountquerydecimal?No
AllocatedAmountGreaterThanOrEqualToquerydecimal?No
AllocatedAmountGreaterThanquerydecimal?No
AllocatedAmountLessThanquerydecimal?No
AllocatedAmountLessThanOrEqualToquerydecimal?No
AllocatedAmountNotEqualToquerydecimal?No
AllocatedAmountBetweenqueryNullable<Decimal>[]No
AllocatedAmountInqueryNullable<Decimal>[]No
InitDateTimequeryDateTime?No
InitDateTimeGreaterThanOrEqualToqueryDateTime?No
InitDateTimeGreaterThanqueryDateTime?No
InitDateTimeLessThanqueryDateTime?No
InitDateTimeLessThanOrEqualToqueryDateTime?No
InitDateTimeNotEqualToqueryDateTime?No
InitDateTimeBetweenqueryNullable<DateTime>[]No
InitDateTimeInqueryNullable<DateTime>[]No
LastSavedDateTimequeryDateTime?No
LastSavedDateTimeGreaterThanOrEqualToqueryDateTime?No
LastSavedDateTimeGreaterThanqueryDateTime?No
LastSavedDateTimeLessThanqueryDateTime?No
LastSavedDateTimeLessThanOrEqualToqueryDateTime?No
LastSavedDateTimeNotEqualToqueryDateTime?No
LastSavedDateTimeBetweenqueryNullable<DateTime>[]No
LastSavedDateTimeInqueryNullable<DateTime>[]No
SubTypequeryshort?No
SubTypeGreaterThanOrEqualToqueryshort?No
SubTypeGreaterThanqueryshort?No
SubTypeLessThanqueryshort?No
SubTypeLessThanOrEqualToqueryshort?No
SubTypeNotEqualToqueryshort?No
SubTypeBetweenqueryNullable<Int16>[]No
SubTypeInqueryNullable<Int16>[]No
BatchNoquerystringNo
BatchNoStartsWithquerystringNo
BatchNoEndsWithquerystringNo
BatchNoContainsquerystringNo
BatchNoLikequerystringNo
BatchNoBetweenquerystring[]No
BatchNoInquerystring[]No
ChildDebtorIDquerystringNo
ChildDebtorIDStartsWithquerystringNo
ChildDebtorIDEndsWithquerystringNo
ChildDebtorIDContainsquerystringNo
ChildDebtorIDLikequerystringNo
ChildDebtorIDBetweenquerystring[]No
ChildDebtorIDInquerystring[]No
GSTAmountquerydecimal?No
GSTAmountGreaterThanOrEqualToquerydecimal?No
GSTAmountGreaterThanquerydecimal?No
GSTAmountLessThanquerydecimal?No
GSTAmountLessThanOrEqualToquerydecimal?No
GSTAmountNotEqualToquerydecimal?No
GSTAmountBetweenqueryNullable<Decimal>[]No
GSTAmountInqueryNullable<Decimal>[]No
DueDatequeryDateTime?No
DueDateGreaterThanOrEqualToqueryDateTime?No
DueDateGreaterThanqueryDateTime?No
DueDateLessThanqueryDateTime?No
DueDateLessThanOrEqualToqueryDateTime?No
DueDateNotEqualToqueryDateTime?No
DueDateBetweenqueryNullable<DateTime>[]No
DueDateInqueryNullable<DateTime>[]No
FXAmountquerydecimal?No
FXAmountGreaterThanOrEqualToquerydecimal?No
FXAmountGreaterThanquerydecimal?No
FXAmountLessThanquerydecimal?No
FXAmountLessThanOrEqualToquerydecimal?No
FXAmountNotEqualToquerydecimal?No
FXAmountBetweenqueryNullable<Decimal>[]No
FXAmountInqueryNullable<Decimal>[]No
FXAllocAmountquerydecimal?No
FXAllocAmountGreaterThanOrEqualToquerydecimal?No
FXAllocAmountGreaterThanquerydecimal?No
FXAllocAmountLessThanquerydecimal?No
FXAllocAmountLessThanOrEqualToquerydecimal?No
FXAllocAmountNotEqualToquerydecimal?No
FXAllocAmountBetweenqueryNullable<Decimal>[]No
FXAllocAmountInqueryNullable<Decimal>[]No
CurrencyRateUsedquerydecimal?No
CurrencyRateUsedGreaterThanOrEqualToquerydecimal?No
CurrencyRateUsedGreaterThanquerydecimal?No
CurrencyRateUsedLessThanquerydecimal?No
CurrencyRateUsedLessThanOrEqualToquerydecimal?No
CurrencyRateUsedNotEqualToquerydecimal?No
CurrencyRateUsedBetweenqueryNullable<Decimal>[]No
CurrencyRateUsedInqueryNullable<Decimal>[]No
RealisedGainLossquerydecimal?No
RealisedGainLossGreaterThanOrEqualToquerydecimal?No
RealisedGainLossGreaterThanquerydecimal?No
RealisedGainLossLessThanquerydecimal?No
RealisedGainLossLessThanOrEqualToquerydecimal?No
RealisedGainLossNotEqualToquerydecimal?No
RealisedGainLossBetweenqueryNullable<Decimal>[]No
RealisedGainLossInqueryNullable<Decimal>[]No
UnRealisedGainLossquerydecimal?No
UnRealisedGainLossGreaterThanOrEqualToquerydecimal?No
UnRealisedGainLossGreaterThanquerydecimal?No
UnRealisedGainLossLessThanquerydecimal?No
UnRealisedGainLossLessThanOrEqualToquerydecimal?No
UnRealisedGainLossNotEqualToquerydecimal?No
UnRealisedGainLossBetweenqueryNullable<Decimal>[]No
UnRealisedGainLossInqueryNullable<Decimal>[]No
CurrencyIDquerystringNo
CurrencyIDStartsWithquerystringNo
CurrencyIDEndsWithquerystringNo
CurrencyIDContainsquerystringNo
CurrencyIDLikequerystringNo
CurrencyIDBetweenquerystring[]No
CurrencyIDInquerystring[]No
Cartage1Amountquerydecimal?No
Cartage1AmountGreaterThanOrEqualToquerydecimal?No
Cartage1AmountGreaterThanquerydecimal?No
Cartage1AmountLessThanquerydecimal?No
Cartage1AmountLessThanOrEqualToquerydecimal?No
Cartage1AmountNotEqualToquerydecimal?No
Cartage1AmountBetweenqueryNullable<Decimal>[]No
Cartage1AmountInqueryNullable<Decimal>[]No
Cartage1TaxAmountquerydecimal?No
Cartage1TaxAmountGreaterThanOrEqualToquerydecimal?No
Cartage1TaxAmountGreaterThanquerydecimal?No
Cartage1TaxAmountLessThanquerydecimal?No
Cartage1TaxAmountLessThanOrEqualToquerydecimal?No
Cartage1TaxAmountNotEqualToquerydecimal?No
Cartage1TaxAmountBetweenqueryNullable<Decimal>[]No
Cartage1TaxAmountInqueryNullable<Decimal>[]No
Cartage2Amountquerydecimal?No
Cartage2AmountGreaterThanOrEqualToquerydecimal?No
Cartage2AmountGreaterThanquerydecimal?No
Cartage2AmountLessThanquerydecimal?No
Cartage2AmountLessThanOrEqualToquerydecimal?No
Cartage2AmountNotEqualToquerydecimal?No
Cartage2AmountBetweenqueryNullable<Decimal>[]No
Cartage2AmountInqueryNullable<Decimal>[]No
Cartage2TaxAmountquerydecimal?No
Cartage2TaxAmountGreaterThanOrEqualToquerydecimal?No
Cartage2TaxAmountGreaterThanquerydecimal?No
Cartage2TaxAmountLessThanquerydecimal?No
Cartage2TaxAmountLessThanOrEqualToquerydecimal?No
Cartage2TaxAmountNotEqualToquerydecimal?No
Cartage2TaxAmountBetweenqueryNullable<Decimal>[]No
Cartage2TaxAmountInqueryNullable<Decimal>[]No
Cartage3Amountquerydecimal?No
Cartage3AmountGreaterThanOrEqualToquerydecimal?No
Cartage3AmountGreaterThanquerydecimal?No
Cartage3AmountLessThanquerydecimal?No
Cartage3AmountLessThanOrEqualToquerydecimal?No
Cartage3AmountNotEqualToquerydecimal?No
Cartage3AmountBetweenqueryNullable<Decimal>[]No
Cartage3AmountInqueryNullable<Decimal>[]No
Cartage3TaxAmountquerydecimal?No
Cartage3TaxAmountGreaterThanOrEqualToquerydecimal?No
Cartage3TaxAmountGreaterThanquerydecimal?No
Cartage3TaxAmountLessThanquerydecimal?No
Cartage3TaxAmountLessThanOrEqualToquerydecimal?No
Cartage3TaxAmountNotEqualToquerydecimal?No
Cartage3TaxAmountBetweenqueryNullable<Decimal>[]No
Cartage3TaxAmountInqueryNullable<Decimal>[]No
FXDecimalPlacesqueryshort?No
FXDecimalPlacesGreaterThanOrEqualToqueryshort?No
FXDecimalPlacesGreaterThanqueryshort?No
FXDecimalPlacesLessThanqueryshort?No
FXDecimalPlacesLessThanOrEqualToqueryshort?No
FXDecimalPlacesNotEqualToqueryshort?No
FXDecimalPlacesBetweenqueryNullable<Int16>[]No
FXDecimalPlacesInqueryNullable<Int16>[]No
DecimalPlacesqueryshort?No
DecimalPlacesGreaterThanOrEqualToqueryshort?No
DecimalPlacesGreaterThanqueryshort?No
DecimalPlacesLessThanqueryshort?No
DecimalPlacesLessThanOrEqualToqueryshort?No
DecimalPlacesNotEqualToqueryshort?No
DecimalPlacesBetweenqueryNullable<Int16>[]No
DecimalPlacesInqueryNullable<Int16>[]No
NotequerystringNo
NoteStartsWithquerystringNo
NoteEndsWithquerystringNo
NoteContainsquerystringNo
NoteLikequerystringNo
NoteBetweenquerystring[]No
NoteInquerystring[]No
QueryBase Parameters:
NameParameterData TypeRequiredDescription
Skipformint?No
Takeformint?No
OrderByformstringNo
OrderByDescformstringNo
IncludeformstringNo
FieldsformstringNo
MetaformDictionary<string, string>No
DB_Trans Parameters:
NameParameterData TypeRequiredDescription
TransIDformstringNo
DebtorIDformstringNo
DebitCreditformboolNo
SourceformstringNo
RefformstringNo
RemarkformstringNo
TranDateformDateTime?No
InvRemitNoformstringNo
Amountformdecimal?No
DiscountedAmountformdecimal?No
AgedOutformboolNo
SourceIDformstringNo
AllocatedAmountformdecimal?No
InitDateTimeformDateTime?No
LastSavedDateTimeformDateTime?No
SubTypeformshort?No
BatchNoformstringNo
ChildDebtorIDformstringNo
GSTAmountformdecimal?No
DueDateformDateTime?No
FXAmountformdecimal?No
FXAllocAmountformdecimal?No
CurrencyRateUsedformdecimal?No
RealisedGainLossformdecimal?No
UnRealisedGainLossformdecimal?No
CurrencyIDformstringNo
Cartage1Amountformdecimal?No
Cartage1TaxAmountformdecimal?No
Cartage2Amountformdecimal?No
Cartage2TaxAmountformdecimal?No
Cartage3Amountformdecimal?No
Cartage3TaxAmountformdecimal?No
FXDecimalPlacesformshort?No
DecimalPlacesformshort?No
NoteformstringNo
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/DB_TransQuery HTTP/1.1 
Host: localhost 
Accept: application/xml
Content-Type: application/xml
Content-Length: length

<DB_TransQuery 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>
  <AgedOut>false</AgedOut>
  <AllocatedAmount>0</AllocatedAmount>
  <AllocatedAmountBetween xmlns:d2p1="http://schemas.datacontract.org/2004/07/System">
    <d2p1:decimal>0</d2p1:decimal>
  </AllocatedAmountBetween>
  <AllocatedAmountGreaterThan>0</AllocatedAmountGreaterThan>
  <AllocatedAmountGreaterThanOrEqualTo>0</AllocatedAmountGreaterThanOrEqualTo>
  <AllocatedAmountIn xmlns:d2p1="http://schemas.datacontract.org/2004/07/System">
    <d2p1:decimal>0</d2p1:decimal>
  </AllocatedAmountIn>
  <AllocatedAmountLessThan>0</AllocatedAmountLessThan>
  <AllocatedAmountLessThanOrEqualTo>0</AllocatedAmountLessThanOrEqualTo>
  <AllocatedAmountNotEqualTo>0</AllocatedAmountNotEqualTo>
  <Amount>0</Amount>
  <AmountBetween xmlns:d2p1="http://schemas.datacontract.org/2004/07/System">
    <d2p1:decimal>0</d2p1:decimal>
  </AmountBetween>
  <AmountGreaterThan>0</AmountGreaterThan>
  <AmountGreaterThanOrEqualTo>0</AmountGreaterThanOrEqualTo>
  <AmountIn xmlns:d2p1="http://schemas.datacontract.org/2004/07/System">
    <d2p1:decimal>0</d2p1:decimal>
  </AmountIn>
  <AmountLessThan>0</AmountLessThan>
  <AmountLessThanOrEqualTo>0</AmountLessThanOrEqualTo>
  <AmountNotEqualTo>0</AmountNotEqualTo>
  <BatchNo>String</BatchNo>
  <BatchNoBetween xmlns:d2p1="http://schemas.microsoft.com/2003/10/Serialization/Arrays">
    <d2p1:string>String</d2p1:string>
  </BatchNoBetween>
  <BatchNoContains>String</BatchNoContains>
  <BatchNoEndsWith>String</BatchNoEndsWith>
  <BatchNoIn xmlns:d2p1="http://schemas.microsoft.com/2003/10/Serialization/Arrays">
    <d2p1:string>String</d2p1:string>
  </BatchNoIn>
  <BatchNoLike>String</BatchNoLike>
  <BatchNoStartsWith>String</BatchNoStartsWith>
  <Cartage1Amount>0</Cartage1Amount>
  <Cartage1AmountBetween xmlns:d2p1="http://schemas.datacontract.org/2004/07/System">
    <d2p1:decimal>0</d2p1:decimal>
  </Cartage1AmountBetween>
  <Cartage1AmountGreaterThan>0</Cartage1AmountGreaterThan>
  <Cartage1AmountGreaterThanOrEqualTo>0</Cartage1AmountGreaterThanOrEqualTo>
  <Cartage1AmountIn xmlns:d2p1="http://schemas.datacontract.org/2004/07/System">
    <d2p1:decimal>0</d2p1:decimal>
  </Cartage1AmountIn>
  <Cartage1AmountLessThan>0</Cartage1AmountLessThan>
  <Cartage1AmountLessThanOrEqualTo>0</Cartage1AmountLessThanOrEqualTo>
  <Cartage1AmountNotEqualTo>0</Cartage1AmountNotEqualTo>
  <Cartage1TaxAmount>0</Cartage1TaxAmount>
  <Cartage1TaxAmountBetween xmlns:d2p1="http://schemas.datacontract.org/2004/07/System">
    <d2p1:decimal>0</d2p1:decimal>
  </Cartage1TaxAmountBetween>
  <Cartage1TaxAmountGreaterThan>0</Cartage1TaxAmountGreaterThan>
  <Cartage1TaxAmountGreaterThanOrEqualTo>0</Cartage1TaxAmountGreaterThanOrEqualTo>
  <Cartage1TaxAmountIn xmlns:d2p1="http://schemas.datacontract.org/2004/07/System">
    <d2p1:decimal>0</d2p1:decimal>
  </Cartage1TaxAmountIn>
  <Cartage1TaxAmountLessThan>0</Cartage1TaxAmountLessThan>
  <Cartage1TaxAmountLessThanOrEqualTo>0</Cartage1TaxAmountLessThanOrEqualTo>
  <Cartage1TaxAmountNotEqualTo>0</Cartage1TaxAmountNotEqualTo>
  <Cartage2Amount>0</Cartage2Amount>
  <Cartage2AmountBetween xmlns:d2p1="http://schemas.datacontract.org/2004/07/System">
    <d2p1:decimal>0</d2p1:decimal>
  </Cartage2AmountBetween>
  <Cartage2AmountGreaterThan>0</Cartage2AmountGreaterThan>
  <Cartage2AmountGreaterThanOrEqualTo>0</Cartage2AmountGreaterThanOrEqualTo>
  <Cartage2AmountIn xmlns:d2p1="http://schemas.datacontract.org/2004/07/System">
    <d2p1:decimal>0</d2p1:decimal>
  </Cartage2AmountIn>
  <Cartage2AmountLessThan>0</Cartage2AmountLessThan>
  <Cartage2AmountLessThanOrEqualTo>0</Cartage2AmountLessThanOrEqualTo>
  <Cartage2AmountNotEqualTo>0</Cartage2AmountNotEqualTo>
  <Cartage2TaxAmount>0</Cartage2TaxAmount>
  <Cartage2TaxAmountBetween xmlns:d2p1="http://schemas.datacontract.org/2004/07/System">
    <d2p1:decimal>0</d2p1:decimal>
  </Cartage2TaxAmountBetween>
  <Cartage2TaxAmountGreaterThan>0</Cartage2TaxAmountGreaterThan>
  <Cartage2TaxAmountGreaterThanOrEqualTo>0</Cartage2TaxAmountGreaterThanOrEqualTo>
  <Cartage2TaxAmountIn xmlns:d2p1="http://schemas.datacontract.org/2004/07/System">
    <d2p1:decimal>0</d2p1:decimal>
  </Cartage2TaxAmountIn>
  <Cartage2TaxAmountLessThan>0</Cartage2TaxAmountLessThan>
  <Cartage2TaxAmountLessThanOrEqualTo>0</Cartage2TaxAmountLessThanOrEqualTo>
  <Cartage2TaxAmountNotEqualTo>0</Cartage2TaxAmountNotEqualTo>
  <Cartage3Amount>0</Cartage3Amount>
  <Cartage3AmountBetween xmlns:d2p1="http://schemas.datacontract.org/2004/07/System">
    <d2p1:decimal>0</d2p1:decimal>
  </Cartage3AmountBetween>
  <Cartage3AmountGreaterThan>0</Cartage3AmountGreaterThan>
  <Cartage3AmountGreaterThanOrEqualTo>0</Cartage3AmountGreaterThanOrEqualTo>
  <Cartage3AmountIn xmlns:d2p1="http://schemas.datacontract.org/2004/07/System">
    <d2p1:decimal>0</d2p1:decimal>
  </Cartage3AmountIn>
  <Cartage3AmountLessThan>0</Cartage3AmountLessThan>
  <Cartage3AmountLessThanOrEqualTo>0</Cartage3AmountLessThanOrEqualTo>
  <Cartage3AmountNotEqualTo>0</Cartage3AmountNotEqualTo>
  <Cartage3TaxAmount>0</Cartage3TaxAmount>
  <Cartage3TaxAmountBetween xmlns:d2p1="http://schemas.datacontract.org/2004/07/System">
    <d2p1:decimal>0</d2p1:decimal>
  </Cartage3TaxAmountBetween>
  <Cartage3TaxAmountGreaterThan>0</Cartage3TaxAmountGreaterThan>
  <Cartage3TaxAmountGreaterThanOrEqualTo>0</Cartage3TaxAmountGreaterThanOrEqualTo>
  <Cartage3TaxAmountIn xmlns:d2p1="http://schemas.datacontract.org/2004/07/System">
    <d2p1:decimal>0</d2p1:decimal>
  </Cartage3TaxAmountIn>
  <Cartage3TaxAmountLessThan>0</Cartage3TaxAmountLessThan>
  <Cartage3TaxAmountLessThanOrEqualTo>0</Cartage3TaxAmountLessThanOrEqualTo>
  <Cartage3TaxAmountNotEqualTo>0</Cartage3TaxAmountNotEqualTo>
  <ChildDebtorID>String</ChildDebtorID>
  <ChildDebtorIDBetween xmlns:d2p1="http://schemas.microsoft.com/2003/10/Serialization/Arrays">
    <d2p1:string>String</d2p1:string>
  </ChildDebtorIDBetween>
  <ChildDebtorIDContains>String</ChildDebtorIDContains>
  <ChildDebtorIDEndsWith>String</ChildDebtorIDEndsWith>
  <ChildDebtorIDIn xmlns:d2p1="http://schemas.microsoft.com/2003/10/Serialization/Arrays">
    <d2p1:string>String</d2p1:string>
  </ChildDebtorIDIn>
  <ChildDebtorIDLike>String</ChildDebtorIDLike>
  <ChildDebtorIDStartsWith>String</ChildDebtorIDStartsWith>
  <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>
  <CurrencyRateUsed>0</CurrencyRateUsed>
  <CurrencyRateUsedBetween xmlns:d2p1="http://schemas.datacontract.org/2004/07/System">
    <d2p1:decimal>0</d2p1:decimal>
  </CurrencyRateUsedBetween>
  <CurrencyRateUsedGreaterThan>0</CurrencyRateUsedGreaterThan>
  <CurrencyRateUsedGreaterThanOrEqualTo>0</CurrencyRateUsedGreaterThanOrEqualTo>
  <CurrencyRateUsedIn xmlns:d2p1="http://schemas.datacontract.org/2004/07/System">
    <d2p1:decimal>0</d2p1:decimal>
  </CurrencyRateUsedIn>
  <CurrencyRateUsedLessThan>0</CurrencyRateUsedLessThan>
  <CurrencyRateUsedLessThanOrEqualTo>0</CurrencyRateUsedLessThanOrEqualTo>
  <CurrencyRateUsedNotEqualTo>0</CurrencyRateUsedNotEqualTo>
  <DebitCredit>false</DebitCredit>
  <DebtorID>String</DebtorID>
  <DebtorIDBetween xmlns:d2p1="http://schemas.microsoft.com/2003/10/Serialization/Arrays">
    <d2p1:string>String</d2p1:string>
  </DebtorIDBetween>
  <DebtorIDContains>String</DebtorIDContains>
  <DebtorIDEndsWith>String</DebtorIDEndsWith>
  <DebtorIDIn xmlns:d2p1="http://schemas.microsoft.com/2003/10/Serialization/Arrays">
    <d2p1:string>String</d2p1:string>
  </DebtorIDIn>
  <DebtorIDLike>String</DebtorIDLike>
  <DebtorIDStartsWith>String</DebtorIDStartsWith>
  <DecimalPlaces>0</DecimalPlaces>
  <DecimalPlacesBetween xmlns:d2p1="http://schemas.datacontract.org/2004/07/System">
    <d2p1:short>0</d2p1:short>
  </DecimalPlacesBetween>
  <DecimalPlacesGreaterThan>0</DecimalPlacesGreaterThan>
  <DecimalPlacesGreaterThanOrEqualTo>0</DecimalPlacesGreaterThanOrEqualTo>
  <DecimalPlacesIn xmlns:d2p1="http://schemas.datacontract.org/2004/07/System">
    <d2p1:short>0</d2p1:short>
  </DecimalPlacesIn>
  <DecimalPlacesLessThan>0</DecimalPlacesLessThan>
  <DecimalPlacesLessThanOrEqualTo>0</DecimalPlacesLessThanOrEqualTo>
  <DecimalPlacesNotEqualTo>0</DecimalPlacesNotEqualTo>
  <DiscountedAmount>0</DiscountedAmount>
  <DiscountedAmountBetween xmlns:d2p1="http://schemas.datacontract.org/2004/07/System">
    <d2p1:decimal>0</d2p1:decimal>
  </DiscountedAmountBetween>
  <DiscountedAmountGreaterThan>0</DiscountedAmountGreaterThan>
  <DiscountedAmountGreaterThanOrEqualTo>0</DiscountedAmountGreaterThanOrEqualTo>
  <DiscountedAmountIn xmlns:d2p1="http://schemas.datacontract.org/2004/07/System">
    <d2p1:decimal>0</d2p1:decimal>
  </DiscountedAmountIn>
  <DiscountedAmountLessThan>0</DiscountedAmountLessThan>
  <DiscountedAmountLessThanOrEqualTo>0</DiscountedAmountLessThanOrEqualTo>
  <DiscountedAmountNotEqualTo>0</DiscountedAmountNotEqualTo>
  <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>
  <FXAllocAmount>0</FXAllocAmount>
  <FXAllocAmountBetween xmlns:d2p1="http://schemas.datacontract.org/2004/07/System">
    <d2p1:decimal>0</d2p1:decimal>
  </FXAllocAmountBetween>
  <FXAllocAmountGreaterThan>0</FXAllocAmountGreaterThan>
  <FXAllocAmountGreaterThanOrEqualTo>0</FXAllocAmountGreaterThanOrEqualTo>
  <FXAllocAmountIn xmlns:d2p1="http://schemas.datacontract.org/2004/07/System">
    <d2p1:decimal>0</d2p1:decimal>
  </FXAllocAmountIn>
  <FXAllocAmountLessThan>0</FXAllocAmountLessThan>
  <FXAllocAmountLessThanOrEqualTo>0</FXAllocAmountLessThanOrEqualTo>
  <FXAllocAmountNotEqualTo>0</FXAllocAmountNotEqualTo>
  <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:short>0</d2p1:short>
  </FXDecimalPlacesBetween>
  <FXDecimalPlacesGreaterThan>0</FXDecimalPlacesGreaterThan>
  <FXDecimalPlacesGreaterThanOrEqualTo>0</FXDecimalPlacesGreaterThanOrEqualTo>
  <FXDecimalPlacesIn xmlns:d2p1="http://schemas.datacontract.org/2004/07/System">
    <d2p1:short>0</d2p1:short>
  </FXDecimalPlacesIn>
  <FXDecimalPlacesLessThan>0</FXDecimalPlacesLessThan>
  <FXDecimalPlacesLessThanOrEqualTo>0</FXDecimalPlacesLessThanOrEqualTo>
  <FXDecimalPlacesNotEqualTo>0</FXDecimalPlacesNotEqualTo>
  <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>
  <InitDateTime>0001-01-01T00:00:00</InitDateTime>
  <InitDateTimeBetween xmlns:d2p1="http://schemas.datacontract.org/2004/07/System">
    <d2p1:dateTime>0001-01-01T00:00:00</d2p1:dateTime>
  </InitDateTimeBetween>
  <InitDateTimeGreaterThan>0001-01-01T00:00:00</InitDateTimeGreaterThan>
  <InitDateTimeGreaterThanOrEqualTo>0001-01-01T00:00:00</InitDateTimeGreaterThanOrEqualTo>
  <InitDateTimeIn xmlns:d2p1="http://schemas.datacontract.org/2004/07/System">
    <d2p1:dateTime>0001-01-01T00:00:00</d2p1:dateTime>
  </InitDateTimeIn>
  <InitDateTimeLessThan>0001-01-01T00:00:00</InitDateTimeLessThan>
  <InitDateTimeLessThanOrEqualTo>0001-01-01T00:00:00</InitDateTimeLessThanOrEqualTo>
  <InitDateTimeNotEqualTo>0001-01-01T00:00:00</InitDateTimeNotEqualTo>
  <InvRemitNo>String</InvRemitNo>
  <InvRemitNoBetween xmlns:d2p1="http://schemas.microsoft.com/2003/10/Serialization/Arrays">
    <d2p1:string>String</d2p1:string>
  </InvRemitNoBetween>
  <InvRemitNoContains>String</InvRemitNoContains>
  <InvRemitNoEndsWith>String</InvRemitNoEndsWith>
  <InvRemitNoIn xmlns:d2p1="http://schemas.microsoft.com/2003/10/Serialization/Arrays">
    <d2p1:string>String</d2p1:string>
  </InvRemitNoIn>
  <InvRemitNoLike>String</InvRemitNoLike>
  <InvRemitNoStartsWith>String</InvRemitNoStartsWith>
  <LastSavedDateTime>0001-01-01T00:00:00</LastSavedDateTime>
  <LastSavedDateTimeBetween xmlns:d2p1="http://schemas.datacontract.org/2004/07/System">
    <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.datacontract.org/2004/07/System">
    <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>
  <Note>String</Note>
  <NoteBetween xmlns:d2p1="http://schemas.microsoft.com/2003/10/Serialization/Arrays">
    <d2p1:string>String</d2p1:string>
  </NoteBetween>
  <NoteContains>String</NoteContains>
  <NoteEndsWith>String</NoteEndsWith>
  <NoteIn xmlns:d2p1="http://schemas.microsoft.com/2003/10/Serialization/Arrays">
    <d2p1:string>String</d2p1:string>
  </NoteIn>
  <NoteLike>String</NoteLike>
  <NoteStartsWith>String</NoteStartsWith>
  <RealisedGainLoss>0</RealisedGainLoss>
  <RealisedGainLossBetween xmlns:d2p1="http://schemas.datacontract.org/2004/07/System">
    <d2p1:decimal>0</d2p1:decimal>
  </RealisedGainLossBetween>
  <RealisedGainLossGreaterThan>0</RealisedGainLossGreaterThan>
  <RealisedGainLossGreaterThanOrEqualTo>0</RealisedGainLossGreaterThanOrEqualTo>
  <RealisedGainLossIn xmlns:d2p1="http://schemas.datacontract.org/2004/07/System">
    <d2p1:decimal>0</d2p1:decimal>
  </RealisedGainLossIn>
  <RealisedGainLossLessThan>0</RealisedGainLossLessThan>
  <RealisedGainLossLessThanOrEqualTo>0</RealisedGainLossLessThanOrEqualTo>
  <RealisedGainLossNotEqualTo>0</RealisedGainLossNotEqualTo>
  <Ref>String</Ref>
  <RefBetween xmlns:d2p1="http://schemas.microsoft.com/2003/10/Serialization/Arrays">
    <d2p1:string>String</d2p1:string>
  </RefBetween>
  <RefContains>String</RefContains>
  <RefEndsWith>String</RefEndsWith>
  <RefIn xmlns:d2p1="http://schemas.microsoft.com/2003/10/Serialization/Arrays">
    <d2p1:string>String</d2p1:string>
  </RefIn>
  <RefLike>String</RefLike>
  <RefStartsWith>String</RefStartsWith>
  <Remark>String</Remark>
  <RemarkBetween xmlns:d2p1="http://schemas.microsoft.com/2003/10/Serialization/Arrays">
    <d2p1:string>String</d2p1:string>
  </RemarkBetween>
  <RemarkContains>String</RemarkContains>
  <RemarkEndsWith>String</RemarkEndsWith>
  <RemarkIn xmlns:d2p1="http://schemas.microsoft.com/2003/10/Serialization/Arrays">
    <d2p1:string>String</d2p1:string>
  </RemarkIn>
  <RemarkLike>String</RemarkLike>
  <RemarkStartsWith>String</RemarkStartsWith>
  <Source>String</Source>
  <SourceBetween xmlns:d2p1="http://schemas.microsoft.com/2003/10/Serialization/Arrays">
    <d2p1:string>String</d2p1:string>
  </SourceBetween>
  <SourceContains>String</SourceContains>
  <SourceEndsWith>String</SourceEndsWith>
  <SourceID>String</SourceID>
  <SourceIDBetween xmlns:d2p1="http://schemas.microsoft.com/2003/10/Serialization/Arrays">
    <d2p1:string>String</d2p1:string>
  </SourceIDBetween>
  <SourceIDContains>String</SourceIDContains>
  <SourceIDEndsWith>String</SourceIDEndsWith>
  <SourceIDIn xmlns:d2p1="http://schemas.microsoft.com/2003/10/Serialization/Arrays">
    <d2p1:string>String</d2p1:string>
  </SourceIDIn>
  <SourceIDLike>String</SourceIDLike>
  <SourceIDStartsWith>String</SourceIDStartsWith>
  <SourceIn xmlns:d2p1="http://schemas.microsoft.com/2003/10/Serialization/Arrays">
    <d2p1:string>String</d2p1:string>
  </SourceIn>
  <SourceLike>String</SourceLike>
  <SourceStartsWith>String</SourceStartsWith>
  <SubType>0</SubType>
  <SubTypeBetween xmlns:d2p1="http://schemas.datacontract.org/2004/07/System">
    <d2p1:short>0</d2p1:short>
  </SubTypeBetween>
  <SubTypeGreaterThan>0</SubTypeGreaterThan>
  <SubTypeGreaterThanOrEqualTo>0</SubTypeGreaterThanOrEqualTo>
  <SubTypeIn xmlns:d2p1="http://schemas.datacontract.org/2004/07/System">
    <d2p1:short>0</d2p1:short>
  </SubTypeIn>
  <SubTypeLessThan>0</SubTypeLessThan>
  <SubTypeLessThanOrEqualTo>0</SubTypeLessThanOrEqualTo>
  <SubTypeNotEqualTo>0</SubTypeNotEqualTo>
  <TranDate>0001-01-01T00:00:00</TranDate>
  <TranDateBetween xmlns:d2p1="http://schemas.datacontract.org/2004/07/System">
    <d2p1:dateTime>0001-01-01T00:00:00</d2p1:dateTime>
  </TranDateBetween>
  <TranDateGreaterThan>0001-01-01T00:00:00</TranDateGreaterThan>
  <TranDateGreaterThanOrEqualTo>0001-01-01T00:00:00</TranDateGreaterThanOrEqualTo>
  <TranDateIn xmlns:d2p1="http://schemas.datacontract.org/2004/07/System">
    <d2p1:dateTime>0001-01-01T00:00:00</d2p1:dateTime>
  </TranDateIn>
  <TranDateLessThan>0001-01-01T00:00:00</TranDateLessThan>
  <TranDateLessThanOrEqualTo>0001-01-01T00:00:00</TranDateLessThanOrEqualTo>
  <TranDateNotEqualTo>0001-01-01T00:00:00</TranDateNotEqualTo>
  <TransID>String</TransID>
  <TransIDBetween xmlns:d2p1="http://schemas.microsoft.com/2003/10/Serialization/Arrays">
    <d2p1:string>String</d2p1:string>
  </TransIDBetween>
  <TransIDContains>String</TransIDContains>
  <TransIDEndsWith>String</TransIDEndsWith>
  <TransIDIn xmlns:d2p1="http://schemas.microsoft.com/2003/10/Serialization/Arrays">
    <d2p1:string>String</d2p1:string>
  </TransIDIn>
  <TransIDLike>String</TransIDLike>
  <TransIDStartsWith>String</TransIDStartsWith>
  <UnRealisedGainLoss>0</UnRealisedGainLoss>
  <UnRealisedGainLossBetween xmlns:d2p1="http://schemas.datacontract.org/2004/07/System">
    <d2p1:decimal>0</d2p1:decimal>
  </UnRealisedGainLossBetween>
  <UnRealisedGainLossGreaterThan>0</UnRealisedGainLossGreaterThan>
  <UnRealisedGainLossGreaterThanOrEqualTo>0</UnRealisedGainLossGreaterThanOrEqualTo>
  <UnRealisedGainLossIn xmlns:d2p1="http://schemas.datacontract.org/2004/07/System">
    <d2p1:decimal>0</d2p1:decimal>
  </UnRealisedGainLossIn>
  <UnRealisedGainLossLessThan>0</UnRealisedGainLossLessThan>
  <UnRealisedGainLossLessThanOrEqualTo>0</UnRealisedGainLossLessThanOrEqualTo>
  <UnRealisedGainLossNotEqualTo>0</UnRealisedGainLossNotEqualTo>
</DB_TransQuery>
HTTP/1.1 200 OK
Content-Type: application/xml
Content-Length: length

<QueryResponseOfDB_Trans7kRqkrSv 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:DB_Trans>
      <d2p1:_x003C_AgedOut_x003E_k__BackingField>false</d2p1:_x003C_AgedOut_x003E_k__BackingField>
      <d2p1:_x003C_AllocatedAmount_x003E_k__BackingField>0</d2p1:_x003C_AllocatedAmount_x003E_k__BackingField>
      <d2p1:_x003C_Amount_x003E_k__BackingField>0</d2p1:_x003C_Amount_x003E_k__BackingField>
      <d2p1:_x003C_BatchNo_x003E_k__BackingField>String</d2p1:_x003C_BatchNo_x003E_k__BackingField>
      <d2p1:_x003C_Cartage1Amount_x003E_k__BackingField>0</d2p1:_x003C_Cartage1Amount_x003E_k__BackingField>
      <d2p1:_x003C_Cartage1TaxAmount_x003E_k__BackingField>0</d2p1:_x003C_Cartage1TaxAmount_x003E_k__BackingField>
      <d2p1:_x003C_Cartage2Amount_x003E_k__BackingField>0</d2p1:_x003C_Cartage2Amount_x003E_k__BackingField>
      <d2p1:_x003C_Cartage2TaxAmount_x003E_k__BackingField>0</d2p1:_x003C_Cartage2TaxAmount_x003E_k__BackingField>
      <d2p1:_x003C_Cartage3Amount_x003E_k__BackingField>0</d2p1:_x003C_Cartage3Amount_x003E_k__BackingField>
      <d2p1:_x003C_Cartage3TaxAmount_x003E_k__BackingField>0</d2p1:_x003C_Cartage3TaxAmount_x003E_k__BackingField>
      <d2p1:_x003C_ChildDebtorID_x003E_k__BackingField>String</d2p1:_x003C_ChildDebtorID_x003E_k__BackingField>
      <d2p1:_x003C_CurrencyID_x003E_k__BackingField>String</d2p1:_x003C_CurrencyID_x003E_k__BackingField>
      <d2p1:_x003C_CurrencyRateUsed_x003E_k__BackingField>0</d2p1:_x003C_CurrencyRateUsed_x003E_k__BackingField>
      <d2p1:_x003C_DebitCredit_x003E_k__BackingField>false</d2p1:_x003C_DebitCredit_x003E_k__BackingField>
      <d2p1:_x003C_DebtorID_x003E_k__BackingField>String</d2p1:_x003C_DebtorID_x003E_k__BackingField>
      <d2p1:_x003C_DecimalPlaces_x003E_k__BackingField>0</d2p1:_x003C_DecimalPlaces_x003E_k__BackingField>
      <d2p1:_x003C_DiscountedAmount_x003E_k__BackingField>0</d2p1:_x003C_DiscountedAmount_x003E_k__BackingField>
      <d2p1:_x003C_DueDate_x003E_k__BackingField>0001-01-01T00:00:00</d2p1:_x003C_DueDate_x003E_k__BackingField>
      <d2p1:_x003C_FXAllocAmount_x003E_k__BackingField>0</d2p1:_x003C_FXAllocAmount_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_GSTAmount_x003E_k__BackingField>0</d2p1:_x003C_GSTAmount_x003E_k__BackingField>
      <d2p1:_x003C_InitDateTime_x003E_k__BackingField>0001-01-01T00:00:00</d2p1:_x003C_InitDateTime_x003E_k__BackingField>
      <d2p1:_x003C_InvRemitNo_x003E_k__BackingField>String</d2p1:_x003C_InvRemitNo_x003E_k__BackingField>
      <d2p1:_x003C_LastSavedDateTime_x003E_k__BackingField>0001-01-01T00:00:00</d2p1:_x003C_LastSavedDateTime_x003E_k__BackingField>
      <d2p1:_x003C_Note_x003E_k__BackingField>String</d2p1:_x003C_Note_x003E_k__BackingField>
      <d2p1:_x003C_RealisedGainLoss_x003E_k__BackingField>0</d2p1:_x003C_RealisedGainLoss_x003E_k__BackingField>
      <d2p1:_x003C_Ref_x003E_k__BackingField>String</d2p1:_x003C_Ref_x003E_k__BackingField>
      <d2p1:_x003C_Remark_x003E_k__BackingField>String</d2p1:_x003C_Remark_x003E_k__BackingField>
      <d2p1:_x003C_SourceID_x003E_k__BackingField>String</d2p1:_x003C_SourceID_x003E_k__BackingField>
      <d2p1:_x003C_Source_x003E_k__BackingField>String</d2p1:_x003C_Source_x003E_k__BackingField>
      <d2p1:_x003C_SubType_x003E_k__BackingField>0</d2p1:_x003C_SubType_x003E_k__BackingField>
      <d2p1:_x003C_TranDate_x003E_k__BackingField>0001-01-01T00:00:00</d2p1:_x003C_TranDate_x003E_k__BackingField>
      <d2p1:_x003C_TransID_x003E_k__BackingField>String</d2p1:_x003C_TransID_x003E_k__BackingField>
      <d2p1:_x003C_UnRealisedGainLoss_x003E_k__BackingField>0</d2p1:_x003C_UnRealisedGainLoss_x003E_k__BackingField>
    </d2p1:DB_Trans>
  </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>
</QueryResponseOfDB_Trans7kRqkrSv>