JiwaAPI

SM_CustomerReturnsQuery

**SM_CustomerReturnsQuery** Parameters:
Name	Parameter	Data Type	Required
RecID	query	string	No
RecIDStartsWith	query	string	No
RecIDEndsWith	query	string	No
RecIDContains	query	string	No
RecIDLike	query	string	No
RecIDBetween	query	string[]	No
RecIDIn	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
TaskID	query	string	No
TaskIDStartsWith	query	string	No
TaskIDEndsWith	query	string	No
TaskIDContains	query	string	No
TaskIDLike	query	string	No
TaskIDBetween	query	string[]	No
TaskIDIn	query	string[]	No
InventoryID	query	string	No
InventoryIDStartsWith	query	string	No
InventoryIDEndsWith	query	string	No
InventoryIDContains	query	string	No
InventoryIDLike	query	string	No
InventoryIDBetween	query	string[]	No
InventoryIDIn	query	string[]	No
PartNo	query	string	No
PartNoStartsWith	query	string	No
PartNoEndsWith	query	string	No
PartNoContains	query	string	No
PartNoLike	query	string	No
PartNoBetween	query	string[]	No
PartNoIn	query	string[]	No
Description	query	string	No
DescriptionStartsWith	query	string	No
DescriptionEndsWith	query	string	No
DescriptionContains	query	string	No
DescriptionLike	query	string	No
DescriptionBetween	query	string[]	No
DescriptionIn	query	string[]	No
CommentLine	query	bool?	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
PriceExGST	query	decimal?	No
PriceExGSTGreaterThanOrEqualTo	query	decimal?	No
PriceExGSTGreaterThan	query	decimal?	No
PriceExGSTLessThan	query	decimal?	No
PriceExGSTLessThanOrEqualTo	query	decimal?	No
PriceExGSTNotEqualTo	query	decimal?	No
PriceExGSTBetween	query	Nullable<Decimal>[]	No
PriceExGSTIn	query	Nullable<Decimal>[]	No
GSTID	query	string	No
GSTIDStartsWith	query	string	No
GSTIDEndsWith	query	string	No
GSTIDContains	query	string	No
GSTIDLike	query	string	No
GSTIDBetween	query	string[]	No
GSTIDIn	query	string[]	No
GSTRate	query	decimal?	No
GSTRateGreaterThanOrEqualTo	query	decimal?	No
GSTRateGreaterThan	query	decimal?	No
GSTRateLessThan	query	decimal?	No
GSTRateLessThanOrEqualTo	query	decimal?	No
GSTRateNotEqualTo	query	decimal?	No
GSTRateBetween	query	Nullable<Decimal>[]	No
GSTRateIn	query	Nullable<Decimal>[]	No
GSTAmount	query	decimal?	No
GSTAmountGreaterThanOrEqualTo	query	decimal?	No
GSTAmountGreaterThan	query	decimal?	No
GSTAmountLessThan	query	decimal?	No
GSTAmountLessThanOrEqualTo	query	decimal?	No
GSTAmountNotEqualTo	query	decimal?	No
GSTAmountBetween	query	Nullable<Decimal>[]	No
GSTAmountIn	query	Nullable<Decimal>[]	No
LineTotalIncGST	query	decimal?	No
LineTotalIncGSTGreaterThanOrEqualTo	query	decimal?	No
LineTotalIncGSTGreaterThan	query	decimal?	No
LineTotalIncGSTLessThan	query	decimal?	No
LineTotalIncGSTLessThanOrEqualTo	query	decimal?	No
LineTotalIncGSTNotEqualTo	query	decimal?	No
LineTotalIncGSTBetween	query	Nullable<Decimal>[]	No
LineTotalIncGSTIn	query	Nullable<Decimal>[]	No
Processed	query	bool?	No
InvoiceID	query	string	No
InvoiceIDStartsWith	query	string	No
InvoiceIDEndsWith	query	string	No
InvoiceIDContains	query	string	No
InvoiceIDLike	query	string	No
InvoiceIDBetween	query	string[]	No
InvoiceIDIn	query	string[]	No
InvoiceLineID	query	string	No
InvoiceLineIDStartsWith	query	string	No
InvoiceLineIDEndsWith	query	string	No
InvoiceLineIDContains	query	string	No
InvoiceLineIDLike	query	string	No
InvoiceLineIDBetween	query	string[]	No
InvoiceLineIDIn	query	string[]	No
DisplayOrder	query	int?	No
DisplayOrderGreaterThanOrEqualTo	query	int?	No
DisplayOrderGreaterThan	query	int?	No
DisplayOrderLessThan	query	int?	No
DisplayOrderLessThanOrEqualTo	query	int?	No
DisplayOrderNotEqualTo	query	int?	No
DisplayOrderBetween	query	Nullable<Int32>[]	No
DisplayOrderIn	query	Nullable<Int32>[]	No
PhysicalItem	query	bool?	No
UseSerials	query	bool?	No
QuantityDecimalPlaces	query	short?	No
QuantityDecimalPlacesGreaterThanOrEqualTo	query	short?	No
QuantityDecimalPlacesGreaterThan	query	short?	No
QuantityDecimalPlacesLessThan	query	short?	No
QuantityDecimalPlacesLessThanOrEqualTo	query	short?	No
QuantityDecimalPlacesNotEqualTo	query	short?	No
QuantityDecimalPlacesBetween	query	Nullable<Int16>[]	No
QuantityDecimalPlacesIn	query	Nullable<Int16>[]	No
SellPriceIsIncTax	query	bool?	No
CreditReasonID	query	string	No
CreditReasonIDStartsWith	query	string	No
CreditReasonIDEndsWith	query	string	No
CreditReasonIDContains	query	string	No
CreditReasonIDLike	query	string	No
CreditReasonIDBetween	query	string[]	No
CreditReasonIDIn	query	string[]	No
CreditIntoStock	query	bool?	No
Notes	query	string	No
NotesStartsWith	query	string	No
NotesEndsWith	query	string	No
NotesContains	query	string	No
NotesLike	query	string	No
NotesBetween	query	string[]	No
NotesIn	query	string[]	No
UserDefinedBit1	query	bool?	No
UserDefinedBit2	query	bool?	No
UserDefinedBit3	query	bool?	No
UserDefinedString1	query	string	No
UserDefinedString1StartsWith	query	string	No
UserDefinedString1EndsWith	query	string	No
UserDefinedString1Contains	query	string	No
UserDefinedString1Like	query	string	No
UserDefinedString1Between	query	string[]	No
UserDefinedString1In	query	string[]	No
UserDefinedString2	query	string	No
UserDefinedString2StartsWith	query	string	No
UserDefinedString2EndsWith	query	string	No
UserDefinedString2Contains	query	string	No
UserDefinedString2Like	query	string	No
UserDefinedString2Between	query	string[]	No
UserDefinedString2In	query	string[]	No
UserDefinedString3	query	string	No
UserDefinedString3StartsWith	query	string	No
UserDefinedString3EndsWith	query	string	No
UserDefinedString3Contains	query	string	No
UserDefinedString3Like	query	string	No
UserDefinedString3Between	query	string[]	No
UserDefinedString3In	query	string[]	No
UserDefinedDate1	query	DateTime?	No
UserDefinedDate1GreaterThanOrEqualTo	query	DateTime?	No
UserDefinedDate1GreaterThan	query	DateTime?	No
UserDefinedDate1LessThan	query	DateTime?	No
UserDefinedDate1LessThanOrEqualTo	query	DateTime?	No
UserDefinedDate1NotEqualTo	query	DateTime?	No
UserDefinedDate1Between	query	Nullable<DateTime>[]	No
UserDefinedDate1In	query	Nullable<DateTime>[]	No
UserDefinedDate2	query	DateTime?	No
UserDefinedDate2GreaterThanOrEqualTo	query	DateTime?	No
UserDefinedDate2GreaterThan	query	DateTime?	No
UserDefinedDate2LessThan	query	DateTime?	No
UserDefinedDate2LessThanOrEqualTo	query	DateTime?	No
UserDefinedDate2NotEqualTo	query	DateTime?	No
UserDefinedDate2Between	query	Nullable<DateTime>[]	No
UserDefinedDate2In	query	Nullable<DateTime>[]	No
UserDefinedDate3	query	DateTime?	No
UserDefinedDate3GreaterThanOrEqualTo	query	DateTime?	No
UserDefinedDate3GreaterThan	query	DateTime?	No
UserDefinedDate3LessThan	query	DateTime?	No
UserDefinedDate3LessThanOrEqualTo	query	DateTime?	No
UserDefinedDate3NotEqualTo	query	DateTime?	No
UserDefinedDate3Between	query	Nullable<DateTime>[]	No
UserDefinedDate3In	query	Nullable<DateTime>[]	No
UserDefinedFloat1	query	decimal?	No
UserDefinedFloat1GreaterThanOrEqualTo	query	decimal?	No
UserDefinedFloat1GreaterThan	query	decimal?	No
UserDefinedFloat1LessThan	query	decimal?	No
UserDefinedFloat1LessThanOrEqualTo	query	decimal?	No
UserDefinedFloat1NotEqualTo	query	decimal?	No
UserDefinedFloat1Between	query	Nullable<Decimal>[]	No
UserDefinedFloat1In	query	Nullable<Decimal>[]	No
UserDefinedFloat2	query	decimal?	No
UserDefinedFloat2GreaterThanOrEqualTo	query	decimal?	No
UserDefinedFloat2GreaterThan	query	decimal?	No
UserDefinedFloat2LessThan	query	decimal?	No
UserDefinedFloat2LessThanOrEqualTo	query	decimal?	No
UserDefinedFloat2NotEqualTo	query	decimal?	No
UserDefinedFloat2Between	query	Nullable<Decimal>[]	No
UserDefinedFloat2In	query	Nullable<Decimal>[]	No
UserDefinedFloat3	query	decimal?	No
UserDefinedFloat3GreaterThanOrEqualTo	query	decimal?	No
UserDefinedFloat3GreaterThan	query	decimal?	No
UserDefinedFloat3LessThan	query	decimal?	No
UserDefinedFloat3LessThanOrEqualTo	query	decimal?	No
UserDefinedFloat3NotEqualTo	query	decimal?	No
UserDefinedFloat3Between	query	Nullable<Decimal>[]	No
UserDefinedFloat3In	query	Nullable<Decimal>[]	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_CustomerReturns** Parameters:
Name	Parameter	Data Type	Required
RecID	form	string	No
LastSavedDateTime	form	DateTime	No
TaskID	form	string	No
InventoryID	form	string	No
PartNo	form	string	No
Description	form	string	No
CommentLine	form	bool?	No
Quantity	form	decimal?	No
PriceExGST	form	decimal?	No
GSTID	form	string	No
GSTRate	form	decimal?	No
GSTAmount	form	decimal?	No
LineTotalIncGST	form	decimal?	No
Processed	form	bool?	No
InvoiceID	form	string	No
InvoiceLineID	form	string	No
DisplayOrder	form	int?	No
PhysicalItem	form	bool?	No
UseSerials	form	bool?	No
QuantityDecimalPlaces	form	short?	No
SellPriceIsIncTax	form	bool?	No
CreditReasonID	form	string	No
CreditIntoStock	form	bool?	No
Notes	form	string	No
UserDefinedBit1	form	bool?	No
UserDefinedBit2	form	bool?	No
UserDefinedBit3	form	bool?	No
UserDefinedString1	form	string	No
UserDefinedString2	form	string	No
UserDefinedString3	form	string	No
UserDefinedDate1	form	DateTime?	No
UserDefinedDate2	form	DateTime?	No
UserDefinedDate3	form	DateTime?	No
UserDefinedFloat1	form	decimal?	No
UserDefinedFloat2	form	decimal?	No
UserDefinedFloat3	form	decimal?	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_CustomerReturnsQuery HTTP/1.1 
Host: api.jiwa.com.au 
Accept: application/xml
Content-Type: application/xml
Content-Length: length

<SM_CustomerReturnsQuery 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>
  <CommentLine>false</CommentLine>
  <CreditIntoStock>false</CreditIntoStock>
  <CreditReasonID>String</CreditReasonID>
  <CreditReasonIDBetween xmlns:d2p1="http://schemas.microsoft.com/2003/10/Serialization/Arrays">
    <d2p1:string>String</d2p1:string>
  </CreditReasonIDBetween>
  <CreditReasonIDContains>String</CreditReasonIDContains>
  <CreditReasonIDEndsWith>String</CreditReasonIDEndsWith>
  <CreditReasonIDIn xmlns:d2p1="http://schemas.microsoft.com/2003/10/Serialization/Arrays">
    <d2p1:string>String</d2p1:string>
  </CreditReasonIDIn>
  <CreditReasonIDLike>String</CreditReasonIDLike>
  <CreditReasonIDStartsWith>String</CreditReasonIDStartsWith>
  <Description>String</Description>
  <DescriptionBetween xmlns:d2p1="http://schemas.microsoft.com/2003/10/Serialization/Arrays">
    <d2p1:string>String</d2p1:string>
  </DescriptionBetween>
  <DescriptionContains>String</DescriptionContains>
  <DescriptionEndsWith>String</DescriptionEndsWith>
  <DescriptionIn xmlns:d2p1="http://schemas.microsoft.com/2003/10/Serialization/Arrays">
    <d2p1:string>String</d2p1:string>
  </DescriptionIn>
  <DescriptionLike>String</DescriptionLike>
  <DescriptionStartsWith>String</DescriptionStartsWith>
  <DisplayOrder>0</DisplayOrder>
  <DisplayOrderBetween xmlns:d2p1="http://schemas.datacontract.org/2004/07/System">
    <d2p1:int>0</d2p1:int>
  </DisplayOrderBetween>
  <DisplayOrderGreaterThan>0</DisplayOrderGreaterThan>
  <DisplayOrderGreaterThanOrEqualTo>0</DisplayOrderGreaterThanOrEqualTo>
  <DisplayOrderIn xmlns:d2p1="http://schemas.datacontract.org/2004/07/System">
    <d2p1:int>0</d2p1:int>
  </DisplayOrderIn>
  <DisplayOrderLessThan>0</DisplayOrderLessThan>
  <DisplayOrderLessThanOrEqualTo>0</DisplayOrderLessThanOrEqualTo>
  <DisplayOrderNotEqualTo>0</DisplayOrderNotEqualTo>
  <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>
  <GSTID>String</GSTID>
  <GSTIDBetween xmlns:d2p1="http://schemas.microsoft.com/2003/10/Serialization/Arrays">
    <d2p1:string>String</d2p1:string>
  </GSTIDBetween>
  <GSTIDContains>String</GSTIDContains>
  <GSTIDEndsWith>String</GSTIDEndsWith>
  <GSTIDIn xmlns:d2p1="http://schemas.microsoft.com/2003/10/Serialization/Arrays">
    <d2p1:string>String</d2p1:string>
  </GSTIDIn>
  <GSTIDLike>String</GSTIDLike>
  <GSTIDStartsWith>String</GSTIDStartsWith>
  <GSTRate>0</GSTRate>
  <GSTRateBetween xmlns:d2p1="http://schemas.datacontract.org/2004/07/System">
    <d2p1:decimal>0</d2p1:decimal>
  </GSTRateBetween>
  <GSTRateGreaterThan>0</GSTRateGreaterThan>
  <GSTRateGreaterThanOrEqualTo>0</GSTRateGreaterThanOrEqualTo>
  <GSTRateIn xmlns:d2p1="http://schemas.datacontract.org/2004/07/System">
    <d2p1:decimal>0</d2p1:decimal>
  </GSTRateIn>
  <GSTRateLessThan>0</GSTRateLessThan>
  <GSTRateLessThanOrEqualTo>0</GSTRateLessThanOrEqualTo>
  <GSTRateNotEqualTo>0</GSTRateNotEqualTo>
  <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>
  <InvoiceID>String</InvoiceID>
  <InvoiceIDBetween xmlns:d2p1="http://schemas.microsoft.com/2003/10/Serialization/Arrays">
    <d2p1:string>String</d2p1:string>
  </InvoiceIDBetween>
  <InvoiceIDContains>String</InvoiceIDContains>
  <InvoiceIDEndsWith>String</InvoiceIDEndsWith>
  <InvoiceIDIn xmlns:d2p1="http://schemas.microsoft.com/2003/10/Serialization/Arrays">
    <d2p1:string>String</d2p1:string>
  </InvoiceIDIn>
  <InvoiceIDLike>String</InvoiceIDLike>
  <InvoiceIDStartsWith>String</InvoiceIDStartsWith>
  <InvoiceLineID>String</InvoiceLineID>
  <InvoiceLineIDBetween xmlns:d2p1="http://schemas.microsoft.com/2003/10/Serialization/Arrays">
    <d2p1:string>String</d2p1:string>
  </InvoiceLineIDBetween>
  <InvoiceLineIDContains>String</InvoiceLineIDContains>
  <InvoiceLineIDEndsWith>String</InvoiceLineIDEndsWith>
  <InvoiceLineIDIn xmlns:d2p1="http://schemas.microsoft.com/2003/10/Serialization/Arrays">
    <d2p1:string>String</d2p1:string>
  </InvoiceLineIDIn>
  <InvoiceLineIDLike>String</InvoiceLineIDLike>
  <InvoiceLineIDStartsWith>String</InvoiceLineIDStartsWith>
  <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>
  <LineTotalIncGST>0</LineTotalIncGST>
  <LineTotalIncGSTBetween xmlns:d2p1="http://schemas.datacontract.org/2004/07/System">
    <d2p1:decimal>0</d2p1:decimal>
  </LineTotalIncGSTBetween>
  <LineTotalIncGSTGreaterThan>0</LineTotalIncGSTGreaterThan>
  <LineTotalIncGSTGreaterThanOrEqualTo>0</LineTotalIncGSTGreaterThanOrEqualTo>
  <LineTotalIncGSTIn xmlns:d2p1="http://schemas.datacontract.org/2004/07/System">
    <d2p1:decimal>0</d2p1:decimal>
  </LineTotalIncGSTIn>
  <LineTotalIncGSTLessThan>0</LineTotalIncGSTLessThan>
  <LineTotalIncGSTLessThanOrEqualTo>0</LineTotalIncGSTLessThanOrEqualTo>
  <LineTotalIncGSTNotEqualTo>0</LineTotalIncGSTNotEqualTo>
  <Notes>String</Notes>
  <NotesBetween xmlns:d2p1="http://schemas.microsoft.com/2003/10/Serialization/Arrays">
    <d2p1:string>String</d2p1:string>
  </NotesBetween>
  <NotesContains>String</NotesContains>
  <NotesEndsWith>String</NotesEndsWith>
  <NotesIn xmlns:d2p1="http://schemas.microsoft.com/2003/10/Serialization/Arrays">
    <d2p1:string>String</d2p1:string>
  </NotesIn>
  <NotesLike>String</NotesLike>
  <NotesStartsWith>String</NotesStartsWith>
  <PartNo>String</PartNo>
  <PartNoBetween xmlns:d2p1="http://schemas.microsoft.com/2003/10/Serialization/Arrays">
    <d2p1:string>String</d2p1:string>
  </PartNoBetween>
  <PartNoContains>String</PartNoContains>
  <PartNoEndsWith>String</PartNoEndsWith>
  <PartNoIn xmlns:d2p1="http://schemas.microsoft.com/2003/10/Serialization/Arrays">
    <d2p1:string>String</d2p1:string>
  </PartNoIn>
  <PartNoLike>String</PartNoLike>
  <PartNoStartsWith>String</PartNoStartsWith>
  <PhysicalItem>false</PhysicalItem>
  <PriceExGST>0</PriceExGST>
  <PriceExGSTBetween xmlns:d2p1="http://schemas.datacontract.org/2004/07/System">
    <d2p1:decimal>0</d2p1:decimal>
  </PriceExGSTBetween>
  <PriceExGSTGreaterThan>0</PriceExGSTGreaterThan>
  <PriceExGSTGreaterThanOrEqualTo>0</PriceExGSTGreaterThanOrEqualTo>
  <PriceExGSTIn xmlns:d2p1="http://schemas.datacontract.org/2004/07/System">
    <d2p1:decimal>0</d2p1:decimal>
  </PriceExGSTIn>
  <PriceExGSTLessThan>0</PriceExGSTLessThan>
  <PriceExGSTLessThanOrEqualTo>0</PriceExGSTLessThanOrEqualTo>
  <PriceExGSTNotEqualTo>0</PriceExGSTNotEqualTo>
  <Processed>false</Processed>
  <Quantity>0</Quantity>
  <QuantityBetween xmlns:d2p1="http://schemas.datacontract.org/2004/07/System">
    <d2p1:decimal>0</d2p1:decimal>
  </QuantityBetween>
  <QuantityDecimalPlaces>0</QuantityDecimalPlaces>
  <QuantityDecimalPlacesBetween xmlns:d2p1="http://schemas.datacontract.org/2004/07/System">
    <d2p1:short>0</d2p1:short>
  </QuantityDecimalPlacesBetween>
  <QuantityDecimalPlacesGreaterThan>0</QuantityDecimalPlacesGreaterThan>
  <QuantityDecimalPlacesGreaterThanOrEqualTo>0</QuantityDecimalPlacesGreaterThanOrEqualTo>
  <QuantityDecimalPlacesIn xmlns:d2p1="http://schemas.datacontract.org/2004/07/System">
    <d2p1:short>0</d2p1:short>
  </QuantityDecimalPlacesIn>
  <QuantityDecimalPlacesLessThan>0</QuantityDecimalPlacesLessThan>
  <QuantityDecimalPlacesLessThanOrEqualTo>0</QuantityDecimalPlacesLessThanOrEqualTo>
  <QuantityDecimalPlacesNotEqualTo>0</QuantityDecimalPlacesNotEqualTo>
  <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>
  <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>
  <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>
  <SellPriceIsIncTax>false</SellPriceIsIncTax>
  <TaskID>String</TaskID>
  <TaskIDBetween xmlns:d2p1="http://schemas.microsoft.com/2003/10/Serialization/Arrays">
    <d2p1:string>String</d2p1:string>
  </TaskIDBetween>
  <TaskIDContains>String</TaskIDContains>
  <TaskIDEndsWith>String</TaskIDEndsWith>
  <TaskIDIn xmlns:d2p1="http://schemas.microsoft.com/2003/10/Serialization/Arrays">
    <d2p1:string>String</d2p1:string>
  </TaskIDIn>
  <TaskIDLike>String</TaskIDLike>
  <TaskIDStartsWith>String</TaskIDStartsWith>
  <UseSerials>false</UseSerials>
  <UserDefinedBit1>false</UserDefinedBit1>
  <UserDefinedBit2>false</UserDefinedBit2>
  <UserDefinedBit3>false</UserDefinedBit3>
  <UserDefinedDate1>0001-01-01T00:00:00</UserDefinedDate1>
  <UserDefinedDate1Between xmlns:d2p1="http://schemas.datacontract.org/2004/07/System">
    <d2p1:dateTime>0001-01-01T00:00:00</d2p1:dateTime>
  </UserDefinedDate1Between>
  <UserDefinedDate1GreaterThan>0001-01-01T00:00:00</UserDefinedDate1GreaterThan>
  <UserDefinedDate1GreaterThanOrEqualTo>0001-01-01T00:00:00</UserDefinedDate1GreaterThanOrEqualTo>
  <UserDefinedDate1In xmlns:d2p1="http://schemas.datacontract.org/2004/07/System">
    <d2p1:dateTime>0001-01-01T00:00:00</d2p1:dateTime>
  </UserDefinedDate1In>
  <UserDefinedDate1LessThan>0001-01-01T00:00:00</UserDefinedDate1LessThan>
  <UserDefinedDate1LessThanOrEqualTo>0001-01-01T00:00:00</UserDefinedDate1LessThanOrEqualTo>
  <UserDefinedDate1NotEqualTo>0001-01-01T00:00:00</UserDefinedDate1NotEqualTo>
  <UserDefinedDate2>0001-01-01T00:00:00</UserDefinedDate2>
  <UserDefinedDate2Between xmlns:d2p1="http://schemas.datacontract.org/2004/07/System">
    <d2p1:dateTime>0001-01-01T00:00:00</d2p1:dateTime>
  </UserDefinedDate2Between>
  <UserDefinedDate2GreaterThan>0001-01-01T00:00:00</UserDefinedDate2GreaterThan>
  <UserDefinedDate2GreaterThanOrEqualTo>0001-01-01T00:00:00</UserDefinedDate2GreaterThanOrEqualTo>
  <UserDefinedDate2In xmlns:d2p1="http://schemas.datacontract.org/2004/07/System">
    <d2p1:dateTime>0001-01-01T00:00:00</d2p1:dateTime>
  </UserDefinedDate2In>
  <UserDefinedDate2LessThan>0001-01-01T00:00:00</UserDefinedDate2LessThan>
  <UserDefinedDate2LessThanOrEqualTo>0001-01-01T00:00:00</UserDefinedDate2LessThanOrEqualTo>
  <UserDefinedDate2NotEqualTo>0001-01-01T00:00:00</UserDefinedDate2NotEqualTo>
  <UserDefinedDate3>0001-01-01T00:00:00</UserDefinedDate3>
  <UserDefinedDate3Between xmlns:d2p1="http://schemas.datacontract.org/2004/07/System">
    <d2p1:dateTime>0001-01-01T00:00:00</d2p1:dateTime>
  </UserDefinedDate3Between>
  <UserDefinedDate3GreaterThan>0001-01-01T00:00:00</UserDefinedDate3GreaterThan>
  <UserDefinedDate3GreaterThanOrEqualTo>0001-01-01T00:00:00</UserDefinedDate3GreaterThanOrEqualTo>
  <UserDefinedDate3In xmlns:d2p1="http://schemas.datacontract.org/2004/07/System">
    <d2p1:dateTime>0001-01-01T00:00:00</d2p1:dateTime>
  </UserDefinedDate3In>
  <UserDefinedDate3LessThan>0001-01-01T00:00:00</UserDefinedDate3LessThan>
  <UserDefinedDate3LessThanOrEqualTo>0001-01-01T00:00:00</UserDefinedDate3LessThanOrEqualTo>
  <UserDefinedDate3NotEqualTo>0001-01-01T00:00:00</UserDefinedDate3NotEqualTo>
  <UserDefinedFloat1>0</UserDefinedFloat1>
  <UserDefinedFloat1Between xmlns:d2p1="http://schemas.datacontract.org/2004/07/System">
    <d2p1:decimal>0</d2p1:decimal>
  </UserDefinedFloat1Between>
  <UserDefinedFloat1GreaterThan>0</UserDefinedFloat1GreaterThan>
  <UserDefinedFloat1GreaterThanOrEqualTo>0</UserDefinedFloat1GreaterThanOrEqualTo>
  <UserDefinedFloat1In xmlns:d2p1="http://schemas.datacontract.org/2004/07/System">
    <d2p1:decimal>0</d2p1:decimal>
  </UserDefinedFloat1In>
  <UserDefinedFloat1LessThan>0</UserDefinedFloat1LessThan>
  <UserDefinedFloat1LessThanOrEqualTo>0</UserDefinedFloat1LessThanOrEqualTo>
  <UserDefinedFloat1NotEqualTo>0</UserDefinedFloat1NotEqualTo>
  <UserDefinedFloat2>0</UserDefinedFloat2>
  <UserDefinedFloat2Between xmlns:d2p1="http://schemas.datacontract.org/2004/07/System">
    <d2p1:decimal>0</d2p1:decimal>
  </UserDefinedFloat2Between>
  <UserDefinedFloat2GreaterThan>0</UserDefinedFloat2GreaterThan>
  <UserDefinedFloat2GreaterThanOrEqualTo>0</UserDefinedFloat2GreaterThanOrEqualTo>
  <UserDefinedFloat2In xmlns:d2p1="http://schemas.datacontract.org/2004/07/System">
    <d2p1:decimal>0</d2p1:decimal>
  </UserDefinedFloat2In>
  <UserDefinedFloat2LessThan>0</UserDefinedFloat2LessThan>
  <UserDefinedFloat2LessThanOrEqualTo>0</UserDefinedFloat2LessThanOrEqualTo>
  <UserDefinedFloat2NotEqualTo>0</UserDefinedFloat2NotEqualTo>
  <UserDefinedFloat3>0</UserDefinedFloat3>
  <UserDefinedFloat3Between xmlns:d2p1="http://schemas.datacontract.org/2004/07/System">
    <d2p1:decimal>0</d2p1:decimal>
  </UserDefinedFloat3Between>
  <UserDefinedFloat3GreaterThan>0</UserDefinedFloat3GreaterThan>
  <UserDefinedFloat3GreaterThanOrEqualTo>0</UserDefinedFloat3GreaterThanOrEqualTo>
  <UserDefinedFloat3In xmlns:d2p1="http://schemas.datacontract.org/2004/07/System">
    <d2p1:decimal>0</d2p1:decimal>
  </UserDefinedFloat3In>
  <UserDefinedFloat3LessThan>0</UserDefinedFloat3LessThan>
  <UserDefinedFloat3LessThanOrEqualTo>0</UserDefinedFloat3LessThanOrEqualTo>
  <UserDefinedFloat3NotEqualTo>0</UserDefinedFloat3NotEqualTo>
  <UserDefinedString1>String</UserDefinedString1>
  <UserDefinedString1Between xmlns:d2p1="http://schemas.microsoft.com/2003/10/Serialization/Arrays">
    <d2p1:string>String</d2p1:string>
  </UserDefinedString1Between>
  <UserDefinedString1Contains>String</UserDefinedString1Contains>
  <UserDefinedString1EndsWith>String</UserDefinedString1EndsWith>
  <UserDefinedString1In xmlns:d2p1="http://schemas.microsoft.com/2003/10/Serialization/Arrays">
    <d2p1:string>String</d2p1:string>
  </UserDefinedString1In>
  <UserDefinedString1Like>String</UserDefinedString1Like>
  <UserDefinedString1StartsWith>String</UserDefinedString1StartsWith>
  <UserDefinedString2>String</UserDefinedString2>
  <UserDefinedString2Between xmlns:d2p1="http://schemas.microsoft.com/2003/10/Serialization/Arrays">
    <d2p1:string>String</d2p1:string>
  </UserDefinedString2Between>
  <UserDefinedString2Contains>String</UserDefinedString2Contains>
  <UserDefinedString2EndsWith>String</UserDefinedString2EndsWith>
  <UserDefinedString2In xmlns:d2p1="http://schemas.microsoft.com/2003/10/Serialization/Arrays">
    <d2p1:string>String</d2p1:string>
  </UserDefinedString2In>
  <UserDefinedString2Like>String</UserDefinedString2Like>
  <UserDefinedString2StartsWith>String</UserDefinedString2StartsWith>
  <UserDefinedString3>String</UserDefinedString3>
  <UserDefinedString3Between xmlns:d2p1="http://schemas.microsoft.com/2003/10/Serialization/Arrays">
    <d2p1:string>String</d2p1:string>
  </UserDefinedString3Between>
  <UserDefinedString3Contains>String</UserDefinedString3Contains>
  <UserDefinedString3EndsWith>String</UserDefinedString3EndsWith>
  <UserDefinedString3In xmlns:d2p1="http://schemas.microsoft.com/2003/10/Serialization/Arrays">
    <d2p1:string>String</d2p1:string>
  </UserDefinedString3In>
  <UserDefinedString3Like>String</UserDefinedString3Like>
  <UserDefinedString3StartsWith>String</UserDefinedString3StartsWith>
</SM_CustomerReturnsQuery>

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

<QueryResponseOfSM_CustomerReturns7kRqkrSv 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_CustomerReturns>
      <d2p1:_x003C_CommentLine_x003E_k__BackingField>false</d2p1:_x003C_CommentLine_x003E_k__BackingField>
      <d2p1:_x003C_CreditIntoStock_x003E_k__BackingField>false</d2p1:_x003C_CreditIntoStock_x003E_k__BackingField>
      <d2p1:_x003C_CreditReasonID_x003E_k__BackingField>String</d2p1:_x003C_CreditReasonID_x003E_k__BackingField>
      <d2p1:_x003C_Description_x003E_k__BackingField>String</d2p1:_x003C_Description_x003E_k__BackingField>
      <d2p1:_x003C_DisplayOrder_x003E_k__BackingField>0</d2p1:_x003C_DisplayOrder_x003E_k__BackingField>
      <d2p1:_x003C_GSTAmount_x003E_k__BackingField>0</d2p1:_x003C_GSTAmount_x003E_k__BackingField>
      <d2p1:_x003C_GSTID_x003E_k__BackingField>String</d2p1:_x003C_GSTID_x003E_k__BackingField>
      <d2p1:_x003C_GSTRate_x003E_k__BackingField>0</d2p1:_x003C_GSTRate_x003E_k__BackingField>
      <d2p1:_x003C_InventoryID_x003E_k__BackingField>String</d2p1:_x003C_InventoryID_x003E_k__BackingField>
      <d2p1:_x003C_InvoiceID_x003E_k__BackingField>String</d2p1:_x003C_InvoiceID_x003E_k__BackingField>
      <d2p1:_x003C_InvoiceLineID_x003E_k__BackingField>String</d2p1:_x003C_InvoiceLineID_x003E_k__BackingField>
      <d2p1:_x003C_LastSavedDateTime_x003E_k__BackingField>0001-01-01T00:00:00</d2p1:_x003C_LastSavedDateTime_x003E_k__BackingField>
      <d2p1:_x003C_LineTotalIncGST_x003E_k__BackingField>0</d2p1:_x003C_LineTotalIncGST_x003E_k__BackingField>
      <d2p1:_x003C_Notes_x003E_k__BackingField>String</d2p1:_x003C_Notes_x003E_k__BackingField>
      <d2p1:_x003C_PartNo_x003E_k__BackingField>String</d2p1:_x003C_PartNo_x003E_k__BackingField>
      <d2p1:_x003C_PhysicalItem_x003E_k__BackingField>false</d2p1:_x003C_PhysicalItem_x003E_k__BackingField>
      <d2p1:_x003C_PriceExGST_x003E_k__BackingField>0</d2p1:_x003C_PriceExGST_x003E_k__BackingField>
      <d2p1:_x003C_Processed_x003E_k__BackingField>false</d2p1:_x003C_Processed_x003E_k__BackingField>
      <d2p1:_x003C_QuantityDecimalPlaces_x003E_k__BackingField>0</d2p1:_x003C_QuantityDecimalPlaces_x003E_k__BackingField>
      <d2p1:_x003C_Quantity_x003E_k__BackingField>0</d2p1:_x003C_Quantity_x003E_k__BackingField>
      <d2p1:_x003C_RecID_x003E_k__BackingField>String</d2p1:_x003C_RecID_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_SellPriceIsIncTax_x003E_k__BackingField>false</d2p1:_x003C_SellPriceIsIncTax_x003E_k__BackingField>
      <d2p1:_x003C_TaskID_x003E_k__BackingField>String</d2p1:_x003C_TaskID_x003E_k__BackingField>
      <d2p1:_x003C_UseSerials_x003E_k__BackingField>false</d2p1:_x003C_UseSerials_x003E_k__BackingField>
      <d2p1:_x003C_UserDefinedBit1_x003E_k__BackingField>false</d2p1:_x003C_UserDefinedBit1_x003E_k__BackingField>
      <d2p1:_x003C_UserDefinedBit2_x003E_k__BackingField>false</d2p1:_x003C_UserDefinedBit2_x003E_k__BackingField>
      <d2p1:_x003C_UserDefinedBit3_x003E_k__BackingField>false</d2p1:_x003C_UserDefinedBit3_x003E_k__BackingField>
      <d2p1:_x003C_UserDefinedDate1_x003E_k__BackingField>0001-01-01T00:00:00</d2p1:_x003C_UserDefinedDate1_x003E_k__BackingField>
      <d2p1:_x003C_UserDefinedDate2_x003E_k__BackingField>0001-01-01T00:00:00</d2p1:_x003C_UserDefinedDate2_x003E_k__BackingField>
      <d2p1:_x003C_UserDefinedDate3_x003E_k__BackingField>0001-01-01T00:00:00</d2p1:_x003C_UserDefinedDate3_x003E_k__BackingField>
      <d2p1:_x003C_UserDefinedFloat1_x003E_k__BackingField>0</d2p1:_x003C_UserDefinedFloat1_x003E_k__BackingField>
      <d2p1:_x003C_UserDefinedFloat2_x003E_k__BackingField>0</d2p1:_x003C_UserDefinedFloat2_x003E_k__BackingField>
      <d2p1:_x003C_UserDefinedFloat3_x003E_k__BackingField>0</d2p1:_x003C_UserDefinedFloat3_x003E_k__BackingField>
      <d2p1:_x003C_UserDefinedString1_x003E_k__BackingField>String</d2p1:_x003C_UserDefinedString1_x003E_k__BackingField>
      <d2p1:_x003C_UserDefinedString2_x003E_k__BackingField>String</d2p1:_x003C_UserDefinedString2_x003E_k__BackingField>
      <d2p1:_x003C_UserDefinedString3_x003E_k__BackingField>String</d2p1:_x003C_UserDefinedString3_x003E_k__BackingField>
    </d2p1:SM_CustomerReturns>
  </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_CustomerReturns7kRqkrSv>