JiwaAPI

SM_CustomerReturnLineDetailsQuery

**SM_CustomerReturnLineDetailsQuery** Parameters:
Name	Parameter	Data Type	Required
CustomerReturnLineDetailsID	query	string	No
CustomerReturnLineDetailsIDStartsWith	query	string	No
CustomerReturnLineDetailsIDEndsWith	query	string	No
CustomerReturnLineDetailsIDContains	query	string	No
CustomerReturnLineDetailsIDLike	query	string	No
CustomerReturnLineDetailsIDBetween	query	string[]	No
CustomerReturnLineDetailsIDIn	query	string[]	No
LastSavedDateTime	query	DateTime?	No
LastSavedDateTimeGreaterThanOrEqualTo	query	DateTime?	No
LastSavedDateTimeGreaterThan	query	DateTime?	No
LastSavedDateTimeLessThan	query	DateTime?	No
LastSavedDateTimeLessThanOrEqualTo	query	DateTime?	No
LastSavedDateTimeNotEqualTo	query	DateTime?	No
LastSavedDateTimeBetween	query	DateTime[]	No
LastSavedDateTimeIn	query	DateTime[]	No
CustomerReturnID	query	string	No
CustomerReturnIDStartsWith	query	string	No
CustomerReturnIDEndsWith	query	string	No
CustomerReturnIDContains	query	string	No
CustomerReturnIDLike	query	string	No
CustomerReturnIDBetween	query	string[]	No
CustomerReturnIDIn	query	string[]	No
Quantity	query	decimal?	No
QuantityGreaterThanOrEqualTo	query	decimal?	No
QuantityGreaterThan	query	decimal?	No
QuantityLessThan	query	decimal?	No
QuantityLessThanOrEqualTo	query	decimal?	No
QuantityNotEqualTo	query	decimal?	No
QuantityBetween	query	Nullable<Decimal>[]	No
QuantityIn	query	Nullable<Decimal>[]	No
Cost	query	decimal?	No
CostGreaterThanOrEqualTo	query	decimal?	No
CostGreaterThan	query	decimal?	No
CostLessThan	query	decimal?	No
CostLessThanOrEqualTo	query	decimal?	No
CostNotEqualTo	query	decimal?	No
CostBetween	query	Nullable<Decimal>[]	No
CostIn	query	Nullable<Decimal>[]	No
SerialNo	query	string	No
SerialNoStartsWith	query	string	No
SerialNoEndsWith	query	string	No
SerialNoContains	query	string	No
SerialNoLike	query	string	No
SerialNoBetween	query	string[]	No
SerialNoIn	query	string[]	No
BinLocationDesc	query	string	No
BinLocationDescStartsWith	query	string	No
BinLocationDescEndsWith	query	string	No
BinLocationDescContains	query	string	No
BinLocationDescLike	query	string	No
BinLocationDescBetween	query	string[]	No
BinLocationDescIn	query	string[]	No
ExpiryDate	query	DateTime?	No
ExpiryDateGreaterThanOrEqualTo	query	DateTime?	No
ExpiryDateGreaterThan	query	DateTime?	No
ExpiryDateLessThan	query	DateTime?	No
ExpiryDateLessThanOrEqualTo	query	DateTime?	No
ExpiryDateNotEqualTo	query	DateTime?	No
ExpiryDateBetween	query	Nullable<DateTime>[]	No
ExpiryDateIn	query	Nullable<DateTime>[]	No
SOHID	query	string	No
SOHIDStartsWith	query	string	No
SOHIDEndsWith	query	string	No
SOHIDContains	query	string	No
SOHIDLike	query	string	No
SOHIDBetween	query	string[]	No
SOHIDIn	query	string[]	No
SY_Plugin_RecID	query	Guid?	No
SY_Plugin_RecIDIn	query	Nullable<Guid>[]	No

**QueryBase** Parameters:
Name	Parameter	Data Type	Required
Skip	form	int?	No
Take	form	int?	No
OrderBy	form	string	No
OrderByDesc	form	string	No
Include	form	string	No
Fields	form	string	No
Meta	form	Dictionary<string, string>	No

**SM_CustomerReturnLineDetails** Parameters:
Name	Parameter	Data Type	Required
CustomerReturnLineDetailsID	form	string	No
LastSavedDateTime	form	DateTime	No
CustomerReturnID	form	string	No
Quantity	form	decimal?	No
Cost	form	decimal?	No
SerialNo	form	string	No
BinLocationDesc	form	string	No
ExpiryDate	form	DateTime?	No
SOHID	form	string	No
SY_Plugin_RecID	form	Guid?	No

**QueryResponse<T>** Parameters:
Name	Parameter	Data Type	Required
Offset	form	int	No
Total	form	int	No
Results	form	List<T>	No
Meta	form	Dictionary<string, string>	No
ResponseStatus	form	ResponseStatus	No

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/SM_CustomerReturnLineDetailsQuery HTTP/1.1 
Host: api.jiwa.com.au 
Accept: application/xml
Content-Type: application/xml
Content-Length: length

<SM_CustomerReturnLineDetailsQuery 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>
  <BinLocationDesc>String</BinLocationDesc>
  <BinLocationDescBetween xmlns:d2p1="http://schemas.microsoft.com/2003/10/Serialization/Arrays">
    <d2p1:string>String</d2p1:string>
  </BinLocationDescBetween>
  <BinLocationDescContains>String</BinLocationDescContains>
  <BinLocationDescEndsWith>String</BinLocationDescEndsWith>
  <BinLocationDescIn xmlns:d2p1="http://schemas.microsoft.com/2003/10/Serialization/Arrays">
    <d2p1:string>String</d2p1:string>
  </BinLocationDescIn>
  <BinLocationDescLike>String</BinLocationDescLike>
  <BinLocationDescStartsWith>String</BinLocationDescStartsWith>
  <Cost>0</Cost>
  <CostBetween xmlns:d2p1="http://schemas.datacontract.org/2004/07/System">
    <d2p1:decimal>0</d2p1:decimal>
  </CostBetween>
  <CostGreaterThan>0</CostGreaterThan>
  <CostGreaterThanOrEqualTo>0</CostGreaterThanOrEqualTo>
  <CostIn xmlns:d2p1="http://schemas.datacontract.org/2004/07/System">
    <d2p1:decimal>0</d2p1:decimal>
  </CostIn>
  <CostLessThan>0</CostLessThan>
  <CostLessThanOrEqualTo>0</CostLessThanOrEqualTo>
  <CostNotEqualTo>0</CostNotEqualTo>
  <CustomerReturnID>String</CustomerReturnID>
  <CustomerReturnIDBetween xmlns:d2p1="http://schemas.microsoft.com/2003/10/Serialization/Arrays">
    <d2p1:string>String</d2p1:string>
  </CustomerReturnIDBetween>
  <CustomerReturnIDContains>String</CustomerReturnIDContains>
  <CustomerReturnIDEndsWith>String</CustomerReturnIDEndsWith>
  <CustomerReturnIDIn xmlns:d2p1="http://schemas.microsoft.com/2003/10/Serialization/Arrays">
    <d2p1:string>String</d2p1:string>
  </CustomerReturnIDIn>
  <CustomerReturnIDLike>String</CustomerReturnIDLike>
  <CustomerReturnIDStartsWith>String</CustomerReturnIDStartsWith>
  <CustomerReturnLineDetailsID>String</CustomerReturnLineDetailsID>
  <CustomerReturnLineDetailsIDBetween xmlns:d2p1="http://schemas.microsoft.com/2003/10/Serialization/Arrays">
    <d2p1:string>String</d2p1:string>
  </CustomerReturnLineDetailsIDBetween>
  <CustomerReturnLineDetailsIDContains>String</CustomerReturnLineDetailsIDContains>
  <CustomerReturnLineDetailsIDEndsWith>String</CustomerReturnLineDetailsIDEndsWith>
  <CustomerReturnLineDetailsIDIn xmlns:d2p1="http://schemas.microsoft.com/2003/10/Serialization/Arrays">
    <d2p1:string>String</d2p1:string>
  </CustomerReturnLineDetailsIDIn>
  <CustomerReturnLineDetailsIDLike>String</CustomerReturnLineDetailsIDLike>
  <CustomerReturnLineDetailsIDStartsWith>String</CustomerReturnLineDetailsIDStartsWith>
  <ExpiryDate>0001-01-01T00:00:00</ExpiryDate>
  <ExpiryDateBetween xmlns:d2p1="http://schemas.datacontract.org/2004/07/System">
    <d2p1:dateTime>0001-01-01T00:00:00</d2p1:dateTime>
  </ExpiryDateBetween>
  <ExpiryDateGreaterThan>0001-01-01T00:00:00</ExpiryDateGreaterThan>
  <ExpiryDateGreaterThanOrEqualTo>0001-01-01T00:00:00</ExpiryDateGreaterThanOrEqualTo>
  <ExpiryDateIn xmlns:d2p1="http://schemas.datacontract.org/2004/07/System">
    <d2p1:dateTime>0001-01-01T00:00:00</d2p1:dateTime>
  </ExpiryDateIn>
  <ExpiryDateLessThan>0001-01-01T00:00:00</ExpiryDateLessThan>
  <ExpiryDateLessThanOrEqualTo>0001-01-01T00:00:00</ExpiryDateLessThanOrEqualTo>
  <ExpiryDateNotEqualTo>0001-01-01T00:00:00</ExpiryDateNotEqualTo>
  <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>
  <Quantity>0</Quantity>
  <QuantityBetween xmlns:d2p1="http://schemas.datacontract.org/2004/07/System">
    <d2p1:decimal>0</d2p1:decimal>
  </QuantityBetween>
  <QuantityGreaterThan>0</QuantityGreaterThan>
  <QuantityGreaterThanOrEqualTo>0</QuantityGreaterThanOrEqualTo>
  <QuantityIn xmlns:d2p1="http://schemas.datacontract.org/2004/07/System">
    <d2p1:decimal>0</d2p1:decimal>
  </QuantityIn>
  <QuantityLessThan>0</QuantityLessThan>
  <QuantityLessThanOrEqualTo>0</QuantityLessThanOrEqualTo>
  <QuantityNotEqualTo>0</QuantityNotEqualTo>
  <SOHID>String</SOHID>
  <SOHIDBetween xmlns:d2p1="http://schemas.microsoft.com/2003/10/Serialization/Arrays">
    <d2p1:string>String</d2p1:string>
  </SOHIDBetween>
  <SOHIDContains>String</SOHIDContains>
  <SOHIDEndsWith>String</SOHIDEndsWith>
  <SOHIDIn xmlns:d2p1="http://schemas.microsoft.com/2003/10/Serialization/Arrays">
    <d2p1:string>String</d2p1:string>
  </SOHIDIn>
  <SOHIDLike>String</SOHIDLike>
  <SOHIDStartsWith>String</SOHIDStartsWith>
  <SY_Plugin_RecID>00000000-0000-0000-0000-000000000000</SY_Plugin_RecID>
  <SY_Plugin_RecIDIn xmlns:d2p1="http://schemas.datacontract.org/2004/07/System">
    <d2p1:guid>00000000-0000-0000-0000-000000000000</d2p1:guid>
  </SY_Plugin_RecIDIn>
  <SerialNo>String</SerialNo>
  <SerialNoBetween xmlns:d2p1="http://schemas.microsoft.com/2003/10/Serialization/Arrays">
    <d2p1:string>String</d2p1:string>
  </SerialNoBetween>
  <SerialNoContains>String</SerialNoContains>
  <SerialNoEndsWith>String</SerialNoEndsWith>
  <SerialNoIn xmlns:d2p1="http://schemas.microsoft.com/2003/10/Serialization/Arrays">
    <d2p1:string>String</d2p1:string>
  </SerialNoIn>
  <SerialNoLike>String</SerialNoLike>
  <SerialNoStartsWith>String</SerialNoStartsWith>
</SM_CustomerReturnLineDetailsQuery>

HTTP/1.1 200 OK
Content-Type: application/xml
Content-Length: length

<QueryResponseOfSM_CustomerReturnLineDetails7kRqkrSv 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:SM_CustomerReturnLineDetails>
      <d2p1:_x003C_BinLocationDesc_x003E_k__BackingField>String</d2p1:_x003C_BinLocationDesc_x003E_k__BackingField>
      <d2p1:_x003C_Cost_x003E_k__BackingField>0</d2p1:_x003C_Cost_x003E_k__BackingField>
      <d2p1:_x003C_CustomerReturnID_x003E_k__BackingField>String</d2p1:_x003C_CustomerReturnID_x003E_k__BackingField>
      <d2p1:_x003C_CustomerReturnLineDetailsID_x003E_k__BackingField>String</d2p1:_x003C_CustomerReturnLineDetailsID_x003E_k__BackingField>
      <d2p1:_x003C_ExpiryDate_x003E_k__BackingField>0001-01-01T00:00:00</d2p1:_x003C_ExpiryDate_x003E_k__BackingField>
      <d2p1:_x003C_LastSavedDateTime_x003E_k__BackingField>0001-01-01T00:00:00</d2p1:_x003C_LastSavedDateTime_x003E_k__BackingField>
      <d2p1:_x003C_Quantity_x003E_k__BackingField>0</d2p1:_x003C_Quantity_x003E_k__BackingField>
      <d2p1:_x003C_SOHID_x003E_k__BackingField>String</d2p1:_x003C_SOHID_x003E_k__BackingField>
      <d2p1:_x003C_SY_Plugin_RecID_x003E_k__BackingField>00000000-0000-0000-0000-000000000000</d2p1:_x003C_SY_Plugin_RecID_x003E_k__BackingField>
      <d2p1:_x003C_SerialNo_x003E_k__BackingField>String</d2p1:_x003C_SerialNo_x003E_k__BackingField>
    </d2p1:SM_CustomerReturnLineDetails>
  </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>
</QueryResponseOfSM_CustomerReturnLineDetails7kRqkrSv>