JiwaAPI

<back to all web services

IN_DebtorClassificationSpecificPriceQuery

Requires Authentication
IN_DebtorClassificationSpecificPriceQuery Parameters:
NameParameterData TypeRequiredDescription
RecIDquerystringNo
RecIDStartsWithquerystringNo
RecIDEndsWithquerystringNo
RecIDContainsquerystringNo
RecIDLikequerystringNo
RecIDBetweenquerystring[]No
RecIDInquerystring[]No
InventoryIDquerystringNo
InventoryIDStartsWithquerystringNo
InventoryIDEndsWithquerystringNo
InventoryIDContainsquerystringNo
InventoryIDLikequerystringNo
InventoryIDBetweenquerystring[]No
InventoryIDInquerystring[]No
DebtorClassificationIDquerystringNo
DebtorClassificationIDStartsWithquerystringNo
DebtorClassificationIDEndsWithquerystringNo
DebtorClassificationIDContainsquerystringNo
DebtorClassificationIDLikequerystringNo
DebtorClassificationIDBetweenquerystring[]No
DebtorClassificationIDInquerystring[]No
Sourcequeryshort?No
SourceGreaterThanOrEqualToqueryshort?No
SourceGreaterThanqueryshort?No
SourceLessThanqueryshort?No
SourceLessThanOrEqualToqueryshort?No
SourceNotEqualToqueryshort?No
SourceBetweenqueryshort[]No
SourceInqueryshort[]No
OPModequeryshort?No
OPModeGreaterThanOrEqualToqueryshort?No
OPModeGreaterThanqueryshort?No
OPModeLessThanqueryshort?No
OPModeLessThanOrEqualToqueryshort?No
OPModeNotEqualToqueryshort?No
OPModeBetweenqueryshort[]No
OPModeInqueryshort[]No
Amountquerydecimal?No
AmountGreaterThanOrEqualToquerydecimal?No
AmountGreaterThanquerydecimal?No
AmountLessThanquerydecimal?No
AmountLessThanOrEqualToquerydecimal?No
AmountNotEqualToquerydecimal?No
AmountBetweenqueryNullable<Decimal>[]No
AmountInqueryNullable<Decimal>[]No
StartDatequeryDateTime?No
StartDateGreaterThanOrEqualToqueryDateTime?No
StartDateGreaterThanqueryDateTime?No
StartDateLessThanqueryDateTime?No
StartDateLessThanOrEqualToqueryDateTime?No
StartDateNotEqualToqueryDateTime?No
StartDateBetweenqueryNullable<DateTime>[]No
StartDateInqueryNullable<DateTime>[]No
EndDatequeryDateTime?No
EndDateGreaterThanOrEqualToqueryDateTime?No
EndDateGreaterThanqueryDateTime?No
EndDateLessThanqueryDateTime?No
EndDateLessThanOrEqualToqueryDateTime?No
EndDateNotEqualToqueryDateTime?No
EndDateBetweenqueryNullable<DateTime>[]No
EndDateInqueryNullable<DateTime>[]No
UseQuantityBreakquerybool?No
QuantityBreakquerydecimal?No
QuantityBreakGreaterThanOrEqualToquerydecimal?No
QuantityBreakGreaterThanquerydecimal?No
QuantityBreakLessThanquerydecimal?No
QuantityBreakLessThanOrEqualToquerydecimal?No
QuantityBreakNotEqualToquerydecimal?No
QuantityBreakBetweenqueryNullable<Decimal>[]No
QuantityBreakInqueryNullable<Decimal>[]No
NotequerystringNo
NoteStartsWithquerystringNo
NoteEndsWithquerystringNo
NoteContainsquerystringNo
NoteLikequerystringNo
NoteBetweenquerystring[]No
NoteInquerystring[]No
ItemNoqueryint?No
ItemNoGreaterThanOrEqualToqueryint?No
ItemNoGreaterThanqueryint?No
ItemNoLessThanqueryint?No
ItemNoLessThanOrEqualToqueryint?No
ItemNoNotEqualToqueryint?No
ItemNoBetweenqueryint[]No
ItemNoInqueryint[]No
RowHashquerybyte[]No
QueryBase Parameters:
NameParameterData TypeRequiredDescription
Skipformint?No
Takeformint?No
OrderByformstringNo
OrderByDescformstringNo
IncludeformstringNo
FieldsformstringNo
MetaformDictionary<string, string>No
IN_DebtorClassificationSpecificPrice Parameters:
NameParameterData TypeRequiredDescription
RecIDformstringNo
InventoryIDformstringNo
DebtorClassificationIDformstringNo
SourceformshortNo
OPModeformshortNo
Amountformdecimal?No
StartDateformDateTime?No
EndDateformDateTime?No
UseQuantityBreakformboolNo
QuantityBreakformdecimal?No
NoteformstringNo
ItemNoformintNo
RowHashformbyte[]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/IN_DebtorClassificationSpecificPriceQuery HTTP/1.1 
Host: api.jiwa.com.au 
Accept: application/xml
Content-Type: application/xml
Content-Length: length

<IN_DebtorClassificationSpecificPriceQuery 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>
  <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>
  <DebtorClassificationID>String</DebtorClassificationID>
  <DebtorClassificationIDBetween xmlns:d2p1="http://schemas.microsoft.com/2003/10/Serialization/Arrays">
    <d2p1:string>String</d2p1:string>
  </DebtorClassificationIDBetween>
  <DebtorClassificationIDContains>String</DebtorClassificationIDContains>
  <DebtorClassificationIDEndsWith>String</DebtorClassificationIDEndsWith>
  <DebtorClassificationIDIn xmlns:d2p1="http://schemas.microsoft.com/2003/10/Serialization/Arrays">
    <d2p1:string>String</d2p1:string>
  </DebtorClassificationIDIn>
  <DebtorClassificationIDLike>String</DebtorClassificationIDLike>
  <DebtorClassificationIDStartsWith>String</DebtorClassificationIDStartsWith>
  <EndDate>0001-01-01T00:00:00</EndDate>
  <EndDateBetween xmlns:d2p1="http://schemas.datacontract.org/2004/07/System">
    <d2p1:dateTime>0001-01-01T00:00:00</d2p1:dateTime>
  </EndDateBetween>
  <EndDateGreaterThan>0001-01-01T00:00:00</EndDateGreaterThan>
  <EndDateGreaterThanOrEqualTo>0001-01-01T00:00:00</EndDateGreaterThanOrEqualTo>
  <EndDateIn xmlns:d2p1="http://schemas.datacontract.org/2004/07/System">
    <d2p1:dateTime>0001-01-01T00:00:00</d2p1:dateTime>
  </EndDateIn>
  <EndDateLessThan>0001-01-01T00:00:00</EndDateLessThan>
  <EndDateLessThanOrEqualTo>0001-01-01T00:00:00</EndDateLessThanOrEqualTo>
  <EndDateNotEqualTo>0001-01-01T00:00:00</EndDateNotEqualTo>
  <InventoryID>String</InventoryID>
  <InventoryIDBetween xmlns:d2p1="http://schemas.microsoft.com/2003/10/Serialization/Arrays">
    <d2p1:string>String</d2p1:string>
  </InventoryIDBetween>
  <InventoryIDContains>String</InventoryIDContains>
  <InventoryIDEndsWith>String</InventoryIDEndsWith>
  <InventoryIDIn xmlns:d2p1="http://schemas.microsoft.com/2003/10/Serialization/Arrays">
    <d2p1:string>String</d2p1:string>
  </InventoryIDIn>
  <InventoryIDLike>String</InventoryIDLike>
  <InventoryIDStartsWith>String</InventoryIDStartsWith>
  <ItemNo>0</ItemNo>
  <ItemNoBetween xmlns:d2p1="http://schemas.microsoft.com/2003/10/Serialization/Arrays">
    <d2p1:int>0</d2p1:int>
  </ItemNoBetween>
  <ItemNoGreaterThan>0</ItemNoGreaterThan>
  <ItemNoGreaterThanOrEqualTo>0</ItemNoGreaterThanOrEqualTo>
  <ItemNoIn xmlns:d2p1="http://schemas.microsoft.com/2003/10/Serialization/Arrays">
    <d2p1:int>0</d2p1:int>
  </ItemNoIn>
  <ItemNoLessThan>0</ItemNoLessThan>
  <ItemNoLessThanOrEqualTo>0</ItemNoLessThanOrEqualTo>
  <ItemNoNotEqualTo>0</ItemNoNotEqualTo>
  <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>
  <OPMode>0</OPMode>
  <OPModeBetween xmlns:d2p1="http://schemas.microsoft.com/2003/10/Serialization/Arrays">
    <d2p1:short>0</d2p1:short>
  </OPModeBetween>
  <OPModeGreaterThan>0</OPModeGreaterThan>
  <OPModeGreaterThanOrEqualTo>0</OPModeGreaterThanOrEqualTo>
  <OPModeIn xmlns:d2p1="http://schemas.microsoft.com/2003/10/Serialization/Arrays">
    <d2p1:short>0</d2p1:short>
  </OPModeIn>
  <OPModeLessThan>0</OPModeLessThan>
  <OPModeLessThanOrEqualTo>0</OPModeLessThanOrEqualTo>
  <OPModeNotEqualTo>0</OPModeNotEqualTo>
  <QuantityBreak>0</QuantityBreak>
  <QuantityBreakBetween xmlns:d2p1="http://schemas.datacontract.org/2004/07/System">
    <d2p1:decimal>0</d2p1:decimal>
  </QuantityBreakBetween>
  <QuantityBreakGreaterThan>0</QuantityBreakGreaterThan>
  <QuantityBreakGreaterThanOrEqualTo>0</QuantityBreakGreaterThanOrEqualTo>
  <QuantityBreakIn xmlns:d2p1="http://schemas.datacontract.org/2004/07/System">
    <d2p1:decimal>0</d2p1:decimal>
  </QuantityBreakIn>
  <QuantityBreakLessThan>0</QuantityBreakLessThan>
  <QuantityBreakLessThanOrEqualTo>0</QuantityBreakLessThanOrEqualTo>
  <QuantityBreakNotEqualTo>0</QuantityBreakNotEqualTo>
  <RecID>String</RecID>
  <RecIDBetween xmlns:d2p1="http://schemas.microsoft.com/2003/10/Serialization/Arrays">
    <d2p1:string>String</d2p1:string>
  </RecIDBetween>
  <RecIDContains>String</RecIDContains>
  <RecIDEndsWith>String</RecIDEndsWith>
  <RecIDIn xmlns:d2p1="http://schemas.microsoft.com/2003/10/Serialization/Arrays">
    <d2p1:string>String</d2p1:string>
  </RecIDIn>
  <RecIDLike>String</RecIDLike>
  <RecIDStartsWith>String</RecIDStartsWith>
  <RowHash>AA==</RowHash>
  <Source>0</Source>
  <SourceBetween xmlns:d2p1="http://schemas.microsoft.com/2003/10/Serialization/Arrays">
    <d2p1:short>0</d2p1:short>
  </SourceBetween>
  <SourceGreaterThan>0</SourceGreaterThan>
  <SourceGreaterThanOrEqualTo>0</SourceGreaterThanOrEqualTo>
  <SourceIn xmlns:d2p1="http://schemas.microsoft.com/2003/10/Serialization/Arrays">
    <d2p1:short>0</d2p1:short>
  </SourceIn>
  <SourceLessThan>0</SourceLessThan>
  <SourceLessThanOrEqualTo>0</SourceLessThanOrEqualTo>
  <SourceNotEqualTo>0</SourceNotEqualTo>
  <StartDate>0001-01-01T00:00:00</StartDate>
  <StartDateBetween xmlns:d2p1="http://schemas.datacontract.org/2004/07/System">
    <d2p1:dateTime>0001-01-01T00:00:00</d2p1:dateTime>
  </StartDateBetween>
  <StartDateGreaterThan>0001-01-01T00:00:00</StartDateGreaterThan>
  <StartDateGreaterThanOrEqualTo>0001-01-01T00:00:00</StartDateGreaterThanOrEqualTo>
  <StartDateIn xmlns:d2p1="http://schemas.datacontract.org/2004/07/System">
    <d2p1:dateTime>0001-01-01T00:00:00</d2p1:dateTime>
  </StartDateIn>
  <StartDateLessThan>0001-01-01T00:00:00</StartDateLessThan>
  <StartDateLessThanOrEqualTo>0001-01-01T00:00:00</StartDateLessThanOrEqualTo>
  <StartDateNotEqualTo>0001-01-01T00:00:00</StartDateNotEqualTo>
  <UseQuantityBreak>false</UseQuantityBreak>
</IN_DebtorClassificationSpecificPriceQuery>
HTTP/1.1 200 OK
Content-Type: application/xml
Content-Length: length

<QueryResponseOfIN_DebtorClassificationSpecificPrice7kRqkrSv 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:IN_DebtorClassificationSpecificPrice>
      <d2p1:_x003C_Amount_x003E_k__BackingField>0</d2p1:_x003C_Amount_x003E_k__BackingField>
      <d2p1:_x003C_DebtorClassificationID_x003E_k__BackingField>String</d2p1:_x003C_DebtorClassificationID_x003E_k__BackingField>
      <d2p1:_x003C_EndDate_x003E_k__BackingField>0001-01-01T00:00:00</d2p1:_x003C_EndDate_x003E_k__BackingField>
      <d2p1:_x003C_InventoryID_x003E_k__BackingField>String</d2p1:_x003C_InventoryID_x003E_k__BackingField>
      <d2p1:_x003C_ItemNo_x003E_k__BackingField>0</d2p1:_x003C_ItemNo_x003E_k__BackingField>
      <d2p1:_x003C_Note_x003E_k__BackingField>String</d2p1:_x003C_Note_x003E_k__BackingField>
      <d2p1:_x003C_OPMode_x003E_k__BackingField>0</d2p1:_x003C_OPMode_x003E_k__BackingField>
      <d2p1:_x003C_QuantityBreak_x003E_k__BackingField>0</d2p1:_x003C_QuantityBreak_x003E_k__BackingField>
      <d2p1:_x003C_RecID_x003E_k__BackingField>String</d2p1:_x003C_RecID_x003E_k__BackingField>
      <d2p1:_x003C_RowHash_x003E_k__BackingField>AA==</d2p1:_x003C_RowHash_x003E_k__BackingField>
      <d2p1:_x003C_Source_x003E_k__BackingField>0</d2p1:_x003C_Source_x003E_k__BackingField>
      <d2p1:_x003C_StartDate_x003E_k__BackingField>0001-01-01T00:00:00</d2p1:_x003C_StartDate_x003E_k__BackingField>
      <d2p1:_x003C_UseQuantityBreak_x003E_k__BackingField>false</d2p1:_x003C_UseQuantityBreak_x003E_k__BackingField>
    </d2p1:IN_DebtorClassificationSpecificPrice>
  </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>
</QueryResponseOfIN_DebtorClassificationSpecificPrice7kRqkrSv>