JiwaAPI

<back to all web services

V_CR_AgedTransQuery

Requires Authentication
V_CR_AgedTransQuery Parameters:
NameParameterData TypeRequiredDescription
TransIDquerystringNo
TransIDStartsWithquerystringNo
TransIDEndsWithquerystringNo
TransIDContainsquerystringNo
TransIDLikequerystringNo
TransIDBetweenquerystring[]No
TransIDInquerystring[]No
CreditorIDquerystringNo
CreditorIDStartsWithquerystringNo
CreditorIDEndsWithquerystringNo
CreditorIDContainsquerystringNo
CreditorIDLikequerystringNo
CreditorIDBetweenquerystring[]No
CreditorIDInquerystring[]No
DebitCreditquerybool?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
AllocatedAmountquerydecimal?No
AllocatedAmountGreaterThanOrEqualToquerydecimal?No
AllocatedAmountGreaterThanquerydecimal?No
AllocatedAmountLessThanquerydecimal?No
AllocatedAmountLessThanOrEqualToquerydecimal?No
AllocatedAmountNotEqualToquerydecimal?No
AllocatedAmountBetweenqueryNullable<Decimal>[]No
AllocatedAmountInqueryNullable<Decimal>[]No
SourcequerystringNo
SourceStartsWithquerystringNo
SourceEndsWithquerystringNo
SourceContainsquerystringNo
SourceLikequerystringNo
SourceBetweenquerystring[]No
SourceInquerystring[]No
Amountquerydecimal?No
AmountGreaterThanOrEqualToquerydecimal?No
AmountGreaterThanquerydecimal?No
AmountLessThanquerydecimal?No
AmountLessThanOrEqualToquerydecimal?No
AmountNotEqualToquerydecimal?No
AmountBetweenqueryNullable<Decimal>[]No
AmountInqueryNullable<Decimal>[]No
QueryBase Parameters:
NameParameterData TypeRequiredDescription
Skipformint?No
Takeformint?No
OrderByformstringNo
OrderByDescformstringNo
IncludeformstringNo
FieldsformstringNo
MetaformDictionary<string, string>No
V_CR_AgedTrans Parameters:
NameParameterData TypeRequiredDescription
TransIDformstringNo
CreditorIDformstringNo
DebitCreditformboolNo
RefformstringNo
RemarkformstringNo
TranDateformDateTime?No
InvRemitNoformstringNo
AllocatedAmountformdecimal?No
SourceformstringNo
Amountformdecimal?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 .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/V_CR_AgedTransQuery HTTP/1.1 
Host: api.jiwa.com.au 
Accept: application/xml
Content-Type: application/xml
Content-Length: length

<V_CR_AgedTransQuery 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>
  <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>
  <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>
  <DebitCredit>false</DebitCredit>
  <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>
  <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>
  <SourceIn xmlns:d2p1="http://schemas.microsoft.com/2003/10/Serialization/Arrays">
    <d2p1:string>String</d2p1:string>
  </SourceIn>
  <SourceLike>String</SourceLike>
  <SourceStartsWith>String</SourceStartsWith>
  <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>
</V_CR_AgedTransQuery>
HTTP/1.1 200 OK
Content-Type: application/xml
Content-Length: length

<QueryResponseOfV_CR_AgedTrans7kRqkrSv 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:V_CR_AgedTrans>
      <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_CreditorID_x003E_k__BackingField>String</d2p1:_x003C_CreditorID_x003E_k__BackingField>
      <d2p1:_x003C_DebitCredit_x003E_k__BackingField>false</d2p1:_x003C_DebitCredit_x003E_k__BackingField>
      <d2p1:_x003C_InvRemitNo_x003E_k__BackingField>String</d2p1:_x003C_InvRemitNo_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_Source_x003E_k__BackingField>String</d2p1:_x003C_Source_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:V_CR_AgedTrans>
  </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>
</QueryResponseOfV_CR_AgedTrans7kRqkrSv>