JiwaAPI

<back to all web services

DB_DetailedGLAuditQuery

Requires Authentication
DB_DetailedGLAuditQuery Parameters:
NameParameterData TypeRequiredDescription
ReceiptIDquerystringNo
ReceiptIDStartsWithquerystringNo
ReceiptIDEndsWithquerystringNo
ReceiptIDContainsquerystringNo
ReceiptIDLikequerystringNo
ReceiptIDBetweenquerystring[]No
ReceiptIDInquerystring[]No
AccountIDquerystringNo
AccountIDStartsWithquerystringNo
AccountIDEndsWithquerystringNo
AccountIDContainsquerystringNo
AccountIDLikequerystringNo
AccountIDBetweenquerystring[]No
AccountIDInquerystring[]No
DBAccountNoquerystringNo
DBAccountNoStartsWithquerystringNo
DBAccountNoEndsWithquerystringNo
DBAccountNoContainsquerystringNo
DBAccountNoLikequerystringNo
DBAccountNoBetweenquerystring[]No
DBAccountNoInquerystring[]No
RemitNoquerystringNo
RemitNoStartsWithquerystringNo
RemitNoEndsWithquerystringNo
RemitNoContainsquerystringNo
RemitNoLikequerystringNo
RemitNoBetweenquerystring[]No
RemitNoInquerystring[]No
ReceiptDatequeryDateTime?No
ReceiptDateGreaterThanOrEqualToqueryDateTime?No
ReceiptDateGreaterThanqueryDateTime?No
ReceiptDateLessThanqueryDateTime?No
ReceiptDateLessThanOrEqualToqueryDateTime?No
ReceiptDateNotEqualToqueryDateTime?No
ReceiptDateBetweenqueryNullable<DateTime>[]No
ReceiptDateInqueryNullable<DateTime>[]No
Amountquerydecimal?No
AmountGreaterThanOrEqualToquerydecimal?No
AmountGreaterThanquerydecimal?No
AmountLessThanquerydecimal?No
AmountLessThanOrEqualToquerydecimal?No
AmountNotEqualToquerydecimal?No
AmountBetweenqueryNullable<Decimal>[]No
AmountInqueryNullable<Decimal>[]No
SourceIDquerystringNo
SourceIDStartsWithquerystringNo
SourceIDEndsWithquerystringNo
SourceIDContainsquerystringNo
SourceIDLikequerystringNo
SourceIDBetweenquerystring[]No
SourceIDInquerystring[]No
SetTypequeryshort?No
SetTypeGreaterThanOrEqualToqueryshort?No
SetTypeGreaterThanqueryshort?No
SetTypeLessThanqueryshort?No
SetTypeLessThanOrEqualToqueryshort?No
SetTypeNotEqualToqueryshort?No
SetTypeBetweenqueryNullable<Int16>[]No
SetTypeInqueryNullable<Int16>[]No
GLSetIDquerystringNo
GLSetIDStartsWithquerystringNo
GLSetIDEndsWithquerystringNo
GLSetIDContainsquerystringNo
GLSetIDLikequerystringNo
GLSetIDBetweenquerystring[]No
GLSetIDInquerystring[]No
GLAccountNoquerystringNo
GLAccountNoStartsWithquerystringNo
GLAccountNoEndsWithquerystringNo
GLAccountNoContainsquerystringNo
GLAccountNoLikequerystringNo
GLAccountNoBetweenquerystring[]No
GLAccountNoInquerystring[]No
RefquerystringNo
RefStartsWithquerystringNo
RefEndsWithquerystringNo
RefContainsquerystringNo
RefLikequerystringNo
RefBetweenquerystring[]No
RefInquerystring[]No
GLTransAmountquerydecimal?No
GLTransAmountGreaterThanOrEqualToquerydecimal?No
GLTransAmountGreaterThanquerydecimal?No
GLTransAmountLessThanquerydecimal?No
GLTransAmountLessThanOrEqualToquerydecimal?No
GLTransAmountNotEqualToquerydecimal?No
GLTransAmountBetweenqueryNullable<Decimal>[]No
GLTransAmountInqueryNullable<Decimal>[]No
QueryBase Parameters:
NameParameterData TypeRequiredDescription
Skipformint?No
Takeformint?No
OrderByformstringNo
OrderByDescformstringNo
IncludeformstringNo
FieldsformstringNo
MetaformDictionary<string, string>No
DB_DetailedGLAudit Parameters:
NameParameterData TypeRequiredDescription
ReceiptIDformstringNo
AccountIDformstringNo
DBAccountNoformstringNo
RemitNoformstringNo
ReceiptDateformDateTime?No
Amountformdecimal?No
SourceIDformstringNo
SetTypeformshort?No
GLSetIDformstringNo
GLAccountNoformstringNo
RefformstringNo
GLTransAmountformdecimal?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/DB_DetailedGLAuditQuery HTTP/1.1 
Host: api.jiwa.com.au 
Accept: application/xml
Content-Type: application/xml
Content-Length: length

<DB_DetailedGLAuditQuery 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>
  <AccountID>String</AccountID>
  <AccountIDBetween xmlns:d2p1="http://schemas.microsoft.com/2003/10/Serialization/Arrays">
    <d2p1:string>String</d2p1:string>
  </AccountIDBetween>
  <AccountIDContains>String</AccountIDContains>
  <AccountIDEndsWith>String</AccountIDEndsWith>
  <AccountIDIn xmlns:d2p1="http://schemas.microsoft.com/2003/10/Serialization/Arrays">
    <d2p1:string>String</d2p1:string>
  </AccountIDIn>
  <AccountIDLike>String</AccountIDLike>
  <AccountIDStartsWith>String</AccountIDStartsWith>
  <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>
  <DBAccountNo>String</DBAccountNo>
  <DBAccountNoBetween xmlns:d2p1="http://schemas.microsoft.com/2003/10/Serialization/Arrays">
    <d2p1:string>String</d2p1:string>
  </DBAccountNoBetween>
  <DBAccountNoContains>String</DBAccountNoContains>
  <DBAccountNoEndsWith>String</DBAccountNoEndsWith>
  <DBAccountNoIn xmlns:d2p1="http://schemas.microsoft.com/2003/10/Serialization/Arrays">
    <d2p1:string>String</d2p1:string>
  </DBAccountNoIn>
  <DBAccountNoLike>String</DBAccountNoLike>
  <DBAccountNoStartsWith>String</DBAccountNoStartsWith>
  <GLAccountNo>String</GLAccountNo>
  <GLAccountNoBetween xmlns:d2p1="http://schemas.microsoft.com/2003/10/Serialization/Arrays">
    <d2p1:string>String</d2p1:string>
  </GLAccountNoBetween>
  <GLAccountNoContains>String</GLAccountNoContains>
  <GLAccountNoEndsWith>String</GLAccountNoEndsWith>
  <GLAccountNoIn xmlns:d2p1="http://schemas.microsoft.com/2003/10/Serialization/Arrays">
    <d2p1:string>String</d2p1:string>
  </GLAccountNoIn>
  <GLAccountNoLike>String</GLAccountNoLike>
  <GLAccountNoStartsWith>String</GLAccountNoStartsWith>
  <GLSetID>String</GLSetID>
  <GLSetIDBetween xmlns:d2p1="http://schemas.microsoft.com/2003/10/Serialization/Arrays">
    <d2p1:string>String</d2p1:string>
  </GLSetIDBetween>
  <GLSetIDContains>String</GLSetIDContains>
  <GLSetIDEndsWith>String</GLSetIDEndsWith>
  <GLSetIDIn xmlns:d2p1="http://schemas.microsoft.com/2003/10/Serialization/Arrays">
    <d2p1:string>String</d2p1:string>
  </GLSetIDIn>
  <GLSetIDLike>String</GLSetIDLike>
  <GLSetIDStartsWith>String</GLSetIDStartsWith>
  <GLTransAmount>0</GLTransAmount>
  <GLTransAmountBetween xmlns:d2p1="http://schemas.datacontract.org/2004/07/System">
    <d2p1:decimal>0</d2p1:decimal>
  </GLTransAmountBetween>
  <GLTransAmountGreaterThan>0</GLTransAmountGreaterThan>
  <GLTransAmountGreaterThanOrEqualTo>0</GLTransAmountGreaterThanOrEqualTo>
  <GLTransAmountIn xmlns:d2p1="http://schemas.datacontract.org/2004/07/System">
    <d2p1:decimal>0</d2p1:decimal>
  </GLTransAmountIn>
  <GLTransAmountLessThan>0</GLTransAmountLessThan>
  <GLTransAmountLessThanOrEqualTo>0</GLTransAmountLessThanOrEqualTo>
  <GLTransAmountNotEqualTo>0</GLTransAmountNotEqualTo>
  <ReceiptDate>0001-01-01T00:00:00</ReceiptDate>
  <ReceiptDateBetween xmlns:d2p1="http://schemas.datacontract.org/2004/07/System">
    <d2p1:dateTime>0001-01-01T00:00:00</d2p1:dateTime>
  </ReceiptDateBetween>
  <ReceiptDateGreaterThan>0001-01-01T00:00:00</ReceiptDateGreaterThan>
  <ReceiptDateGreaterThanOrEqualTo>0001-01-01T00:00:00</ReceiptDateGreaterThanOrEqualTo>
  <ReceiptDateIn xmlns:d2p1="http://schemas.datacontract.org/2004/07/System">
    <d2p1:dateTime>0001-01-01T00:00:00</d2p1:dateTime>
  </ReceiptDateIn>
  <ReceiptDateLessThan>0001-01-01T00:00:00</ReceiptDateLessThan>
  <ReceiptDateLessThanOrEqualTo>0001-01-01T00:00:00</ReceiptDateLessThanOrEqualTo>
  <ReceiptDateNotEqualTo>0001-01-01T00:00:00</ReceiptDateNotEqualTo>
  <ReceiptID>String</ReceiptID>
  <ReceiptIDBetween xmlns:d2p1="http://schemas.microsoft.com/2003/10/Serialization/Arrays">
    <d2p1:string>String</d2p1:string>
  </ReceiptIDBetween>
  <ReceiptIDContains>String</ReceiptIDContains>
  <ReceiptIDEndsWith>String</ReceiptIDEndsWith>
  <ReceiptIDIn xmlns:d2p1="http://schemas.microsoft.com/2003/10/Serialization/Arrays">
    <d2p1:string>String</d2p1:string>
  </ReceiptIDIn>
  <ReceiptIDLike>String</ReceiptIDLike>
  <ReceiptIDStartsWith>String</ReceiptIDStartsWith>
  <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>
  <RemitNo>String</RemitNo>
  <RemitNoBetween xmlns:d2p1="http://schemas.microsoft.com/2003/10/Serialization/Arrays">
    <d2p1:string>String</d2p1:string>
  </RemitNoBetween>
  <RemitNoContains>String</RemitNoContains>
  <RemitNoEndsWith>String</RemitNoEndsWith>
  <RemitNoIn xmlns:d2p1="http://schemas.microsoft.com/2003/10/Serialization/Arrays">
    <d2p1:string>String</d2p1:string>
  </RemitNoIn>
  <RemitNoLike>String</RemitNoLike>
  <RemitNoStartsWith>String</RemitNoStartsWith>
  <SetType>0</SetType>
  <SetTypeBetween xmlns:d2p1="http://schemas.datacontract.org/2004/07/System">
    <d2p1:short>0</d2p1:short>
  </SetTypeBetween>
  <SetTypeGreaterThan>0</SetTypeGreaterThan>
  <SetTypeGreaterThanOrEqualTo>0</SetTypeGreaterThanOrEqualTo>
  <SetTypeIn xmlns:d2p1="http://schemas.datacontract.org/2004/07/System">
    <d2p1:short>0</d2p1:short>
  </SetTypeIn>
  <SetTypeLessThan>0</SetTypeLessThan>
  <SetTypeLessThanOrEqualTo>0</SetTypeLessThanOrEqualTo>
  <SetTypeNotEqualTo>0</SetTypeNotEqualTo>
  <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>
</DB_DetailedGLAuditQuery>
HTTP/1.1 200 OK
Content-Type: application/xml
Content-Length: length

<QueryResponseOfDB_DetailedGLAudit7kRqkrSv 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_DetailedGLAudit>
      <d2p1:_x003C_AccountID_x003E_k__BackingField>String</d2p1:_x003C_AccountID_x003E_k__BackingField>
      <d2p1:_x003C_Amount_x003E_k__BackingField>0</d2p1:_x003C_Amount_x003E_k__BackingField>
      <d2p1:_x003C_DBAccountNo_x003E_k__BackingField>String</d2p1:_x003C_DBAccountNo_x003E_k__BackingField>
      <d2p1:_x003C_GLAccountNo_x003E_k__BackingField>String</d2p1:_x003C_GLAccountNo_x003E_k__BackingField>
      <d2p1:_x003C_GLSetID_x003E_k__BackingField>String</d2p1:_x003C_GLSetID_x003E_k__BackingField>
      <d2p1:_x003C_GLTransAmount_x003E_k__BackingField>0</d2p1:_x003C_GLTransAmount_x003E_k__BackingField>
      <d2p1:_x003C_ReceiptDate_x003E_k__BackingField>0001-01-01T00:00:00</d2p1:_x003C_ReceiptDate_x003E_k__BackingField>
      <d2p1:_x003C_ReceiptID_x003E_k__BackingField>String</d2p1:_x003C_ReceiptID_x003E_k__BackingField>
      <d2p1:_x003C_Ref_x003E_k__BackingField>String</d2p1:_x003C_Ref_x003E_k__BackingField>
      <d2p1:_x003C_RemitNo_x003E_k__BackingField>String</d2p1:_x003C_RemitNo_x003E_k__BackingField>
      <d2p1:_x003C_SetType_x003E_k__BackingField>0</d2p1:_x003C_SetType_x003E_k__BackingField>
      <d2p1:_x003C_SourceID_x003E_k__BackingField>String</d2p1:_x003C_SourceID_x003E_k__BackingField>
    </d2p1:DB_DetailedGLAudit>
  </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_DetailedGLAudit7kRqkrSv>