JiwaAPI

v_SalesInformationQuery

**v_SalesInformationQuery** Parameters:
Name	Parameter	Data Type	Required
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
InvoiceNo	query	string	No
InvoiceNoStartsWith	query	string	No
InvoiceNoEndsWith	query	string	No
InvoiceNoContains	query	string	No
InvoiceNoLike	query	string	No
InvoiceNoBetween	query	string[]	No
InvoiceNoIn	query	string[]	No
StaffID	query	string	No
StaffIDStartsWith	query	string	No
StaffIDEndsWith	query	string	No
StaffIDContains	query	string	No
StaffIDLike	query	string	No
StaffIDBetween	query	string[]	No
StaffIDIn	query	string[]	No
IN_LogicalID	query	string	No
IN_LogicalIDStartsWith	query	string	No
IN_LogicalIDEndsWith	query	string	No
IN_LogicalIDContains	query	string	No
IN_LogicalIDLike	query	string	No
IN_LogicalIDBetween	query	string[]	No
IN_LogicalIDIn	query	string[]	No
IN_PhysicalID	query	string	No
IN_PhysicalIDStartsWith	query	string	No
IN_PhysicalIDEndsWith	query	string	No
IN_PhysicalIDContains	query	string	No
IN_PhysicalIDLike	query	string	No
IN_PhysicalIDBetween	query	string[]	No
IN_PhysicalIDIn	query	string[]	No
BranchID	query	string	No
BranchIDStartsWith	query	string	No
BranchIDEndsWith	query	string	No
BranchIDContains	query	string	No
BranchIDLike	query	string	No
BranchIDBetween	query	string[]	No
BranchIDIn	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
PartDescription	query	string	No
PartDescriptionStartsWith	query	string	No
PartDescriptionEndsWith	query	string	No
PartDescriptionContains	query	string	No
PartDescriptionLike	query	string	No
PartDescriptionBetween	query	string[]	No
PartDescriptionIn	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
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
LineTaxTotal	query	decimal?	No
LineTaxTotalGreaterThanOrEqualTo	query	decimal?	No
LineTaxTotalGreaterThan	query	decimal?	No
LineTaxTotalLessThan	query	decimal?	No
LineTaxTotalLessThanOrEqualTo	query	decimal?	No
LineTaxTotalNotEqualTo	query	decimal?	No
LineTaxTotalBetween	query	Nullable<Decimal>[]	No
LineTaxTotalIn	query	Nullable<Decimal>[]	No
LineTotalExGST	query	decimal?	No
LineTotalExGSTGreaterThanOrEqualTo	query	decimal?	No
LineTotalExGSTGreaterThan	query	decimal?	No
LineTotalExGSTLessThan	query	decimal?	No
LineTotalExGSTLessThanOrEqualTo	query	decimal?	No
LineTotalExGSTNotEqualTo	query	decimal?	No
LineTotalExGSTBetween	query	Nullable<Decimal>[]	No
LineTotalExGSTIn	query	Nullable<Decimal>[]	No
LineCost	query	decimal?	No
LineCostGreaterThanOrEqualTo	query	decimal?	No
LineCostGreaterThan	query	decimal?	No
LineCostLessThan	query	decimal?	No
LineCostLessThanOrEqualTo	query	decimal?	No
LineCostNotEqualTo	query	decimal?	No
LineCostBetween	query	Nullable<Decimal>[]	No
LineCostIn	query	Nullable<Decimal>[]	No
LineProfit	query	decimal?	No
LineProfitGreaterThanOrEqualTo	query	decimal?	No
LineProfitGreaterThan	query	decimal?	No
LineProfitLessThan	query	decimal?	No
LineProfitLessThanOrEqualTo	query	decimal?	No
LineProfitNotEqualTo	query	decimal?	No
LineProfitBetween	query	Nullable<Decimal>[]	No
LineProfitIn	query	Nullable<Decimal>[]	No
ClassificationDescription	query	string	No
ClassificationDescriptionStartsWith	query	string	No
ClassificationDescriptionEndsWith	query	string	No
ClassificationDescriptionContains	query	string	No
ClassificationDescriptionLike	query	string	No
ClassificationDescriptionBetween	query	string[]	No
ClassificationDescriptionIn	query	string[]	No
Category1DescriptionAtTimeOfSale	query	string	No
Category1DescriptionAtTimeOfSaleStartsWith	query	string	No
Category1DescriptionAtTimeOfSaleEndsWith	query	string	No
Category1DescriptionAtTimeOfSaleContains	query	string	No
Category1DescriptionAtTimeOfSaleLike	query	string	No
Category1DescriptionAtTimeOfSaleBetween	query	string[]	No
Category1DescriptionAtTimeOfSaleIn	query	string[]	No
Category2DescriptionAtTimeOfSale	query	string	No
Category2DescriptionAtTimeOfSaleStartsWith	query	string	No
Category2DescriptionAtTimeOfSaleEndsWith	query	string	No
Category2DescriptionAtTimeOfSaleContains	query	string	No
Category2DescriptionAtTimeOfSaleLike	query	string	No
Category2DescriptionAtTimeOfSaleBetween	query	string[]	No
Category2DescriptionAtTimeOfSaleIn	query	string[]	No
Category3DescriptionAtTimeOfSale	query	string	No
Category3DescriptionAtTimeOfSaleStartsWith	query	string	No
Category3DescriptionAtTimeOfSaleEndsWith	query	string	No
Category3DescriptionAtTimeOfSaleContains	query	string	No
Category3DescriptionAtTimeOfSaleLike	query	string	No
Category3DescriptionAtTimeOfSaleBetween	query	string[]	No
Category3DescriptionAtTimeOfSaleIn	query	string[]	No
DebtorID	query	string	No
DebtorIDStartsWith	query	string	No
DebtorIDEndsWith	query	string	No
DebtorIDContains	query	string	No
DebtorIDLike	query	string	No
DebtorIDBetween	query	string[]	No
DebtorIDIn	query	string[]	No
DebtorClassificationID	query	string	No
DebtorClassificationIDStartsWith	query	string	No
DebtorClassificationIDEndsWith	query	string	No
DebtorClassificationIDContains	query	string	No
DebtorClassificationIDLike	query	string	No
DebtorClassificationIDBetween	query	string[]	No
DebtorClassificationIDIn	query	string[]	No
ProcessDate	query	DateTime?	No
ProcessDateGreaterThanOrEqualTo	query	DateTime?	No
ProcessDateGreaterThan	query	DateTime?	No
ProcessDateLessThan	query	DateTime?	No
ProcessDateLessThanOrEqualTo	query	DateTime?	No
ProcessDateNotEqualTo	query	DateTime?	No
ProcessDateBetween	query	Nullable<DateTime>[]	No
ProcessDateIn	query	Nullable<DateTime>[]	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

**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

**v_SalesInformation** Parameters:
Name	Parameter	Data Type	Required
InvoiceLineID	form	string	No
InvoiceNo	form	string	No
StaffID	form	string	No
IN_LogicalID	form	string	No
IN_PhysicalID	form	string	No
BranchID	form	string	No
PartNo	form	string	No
PartDescription	form	string	No
Quantity	form	decimal?	No
LineTotalIncGST	form	decimal?	No
LineTaxTotal	form	decimal?	No
LineTotalExGST	form	decimal?	No
LineCost	form	decimal?	No
LineProfit	form	decimal?	No
ClassificationDescription	form	string	No
Category1DescriptionAtTimeOfSale	form	string	No
Category2DescriptionAtTimeOfSale	form	string	No
Category3DescriptionAtTimeOfSale	form	string	No
DebtorID	form	string	No
DebtorClassificationID	form	string	No
ProcessDate	form	DateTime?	No
InventoryID	form	string	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/v_SalesInformationQuery HTTP/1.1 
Host: localhost 
Accept: application/xml
Content-Type: application/xml
Content-Length: length

<v_SalesInformationQuery 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>
  <BranchID>String</BranchID>
  <BranchIDBetween xmlns:d2p1="http://schemas.microsoft.com/2003/10/Serialization/Arrays">
    <d2p1:string>String</d2p1:string>
  </BranchIDBetween>
  <BranchIDContains>String</BranchIDContains>
  <BranchIDEndsWith>String</BranchIDEndsWith>
  <BranchIDIn xmlns:d2p1="http://schemas.microsoft.com/2003/10/Serialization/Arrays">
    <d2p1:string>String</d2p1:string>
  </BranchIDIn>
  <BranchIDLike>String</BranchIDLike>
  <BranchIDStartsWith>String</BranchIDStartsWith>
  <Category1DescriptionAtTimeOfSale>String</Category1DescriptionAtTimeOfSale>
  <Category1DescriptionAtTimeOfSaleBetween xmlns:d2p1="http://schemas.microsoft.com/2003/10/Serialization/Arrays">
    <d2p1:string>String</d2p1:string>
  </Category1DescriptionAtTimeOfSaleBetween>
  <Category1DescriptionAtTimeOfSaleContains>String</Category1DescriptionAtTimeOfSaleContains>
  <Category1DescriptionAtTimeOfSaleEndsWith>String</Category1DescriptionAtTimeOfSaleEndsWith>
  <Category1DescriptionAtTimeOfSaleIn xmlns:d2p1="http://schemas.microsoft.com/2003/10/Serialization/Arrays">
    <d2p1:string>String</d2p1:string>
  </Category1DescriptionAtTimeOfSaleIn>
  <Category1DescriptionAtTimeOfSaleLike>String</Category1DescriptionAtTimeOfSaleLike>
  <Category1DescriptionAtTimeOfSaleStartsWith>String</Category1DescriptionAtTimeOfSaleStartsWith>
  <Category2DescriptionAtTimeOfSale>String</Category2DescriptionAtTimeOfSale>
  <Category2DescriptionAtTimeOfSaleBetween xmlns:d2p1="http://schemas.microsoft.com/2003/10/Serialization/Arrays">
    <d2p1:string>String</d2p1:string>
  </Category2DescriptionAtTimeOfSaleBetween>
  <Category2DescriptionAtTimeOfSaleContains>String</Category2DescriptionAtTimeOfSaleContains>
  <Category2DescriptionAtTimeOfSaleEndsWith>String</Category2DescriptionAtTimeOfSaleEndsWith>
  <Category2DescriptionAtTimeOfSaleIn xmlns:d2p1="http://schemas.microsoft.com/2003/10/Serialization/Arrays">
    <d2p1:string>String</d2p1:string>
  </Category2DescriptionAtTimeOfSaleIn>
  <Category2DescriptionAtTimeOfSaleLike>String</Category2DescriptionAtTimeOfSaleLike>
  <Category2DescriptionAtTimeOfSaleStartsWith>String</Category2DescriptionAtTimeOfSaleStartsWith>
  <Category3DescriptionAtTimeOfSale>String</Category3DescriptionAtTimeOfSale>
  <Category3DescriptionAtTimeOfSaleBetween xmlns:d2p1="http://schemas.microsoft.com/2003/10/Serialization/Arrays">
    <d2p1:string>String</d2p1:string>
  </Category3DescriptionAtTimeOfSaleBetween>
  <Category3DescriptionAtTimeOfSaleContains>String</Category3DescriptionAtTimeOfSaleContains>
  <Category3DescriptionAtTimeOfSaleEndsWith>String</Category3DescriptionAtTimeOfSaleEndsWith>
  <Category3DescriptionAtTimeOfSaleIn xmlns:d2p1="http://schemas.microsoft.com/2003/10/Serialization/Arrays">
    <d2p1:string>String</d2p1:string>
  </Category3DescriptionAtTimeOfSaleIn>
  <Category3DescriptionAtTimeOfSaleLike>String</Category3DescriptionAtTimeOfSaleLike>
  <Category3DescriptionAtTimeOfSaleStartsWith>String</Category3DescriptionAtTimeOfSaleStartsWith>
  <ClassificationDescription>String</ClassificationDescription>
  <ClassificationDescriptionBetween xmlns:d2p1="http://schemas.microsoft.com/2003/10/Serialization/Arrays">
    <d2p1:string>String</d2p1:string>
  </ClassificationDescriptionBetween>
  <ClassificationDescriptionContains>String</ClassificationDescriptionContains>
  <ClassificationDescriptionEndsWith>String</ClassificationDescriptionEndsWith>
  <ClassificationDescriptionIn xmlns:d2p1="http://schemas.microsoft.com/2003/10/Serialization/Arrays">
    <d2p1:string>String</d2p1:string>
  </ClassificationDescriptionIn>
  <ClassificationDescriptionLike>String</ClassificationDescriptionLike>
  <ClassificationDescriptionStartsWith>String</ClassificationDescriptionStartsWith>
  <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>
  <DebtorID>String</DebtorID>
  <DebtorIDBetween xmlns:d2p1="http://schemas.microsoft.com/2003/10/Serialization/Arrays">
    <d2p1:string>String</d2p1:string>
  </DebtorIDBetween>
  <DebtorIDContains>String</DebtorIDContains>
  <DebtorIDEndsWith>String</DebtorIDEndsWith>
  <DebtorIDIn xmlns:d2p1="http://schemas.microsoft.com/2003/10/Serialization/Arrays">
    <d2p1:string>String</d2p1:string>
  </DebtorIDIn>
  <DebtorIDLike>String</DebtorIDLike>
  <DebtorIDStartsWith>String</DebtorIDStartsWith>
  <IN_LogicalID>String</IN_LogicalID>
  <IN_LogicalIDBetween xmlns:d2p1="http://schemas.microsoft.com/2003/10/Serialization/Arrays">
    <d2p1:string>String</d2p1:string>
  </IN_LogicalIDBetween>
  <IN_LogicalIDContains>String</IN_LogicalIDContains>
  <IN_LogicalIDEndsWith>String</IN_LogicalIDEndsWith>
  <IN_LogicalIDIn xmlns:d2p1="http://schemas.microsoft.com/2003/10/Serialization/Arrays">
    <d2p1:string>String</d2p1:string>
  </IN_LogicalIDIn>
  <IN_LogicalIDLike>String</IN_LogicalIDLike>
  <IN_LogicalIDStartsWith>String</IN_LogicalIDStartsWith>
  <IN_PhysicalID>String</IN_PhysicalID>
  <IN_PhysicalIDBetween xmlns:d2p1="http://schemas.microsoft.com/2003/10/Serialization/Arrays">
    <d2p1:string>String</d2p1:string>
  </IN_PhysicalIDBetween>
  <IN_PhysicalIDContains>String</IN_PhysicalIDContains>
  <IN_PhysicalIDEndsWith>String</IN_PhysicalIDEndsWith>
  <IN_PhysicalIDIn xmlns:d2p1="http://schemas.microsoft.com/2003/10/Serialization/Arrays">
    <d2p1:string>String</d2p1:string>
  </IN_PhysicalIDIn>
  <IN_PhysicalIDLike>String</IN_PhysicalIDLike>
  <IN_PhysicalIDStartsWith>String</IN_PhysicalIDStartsWith>
  <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>
  <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>
  <InvoiceNo>String</InvoiceNo>
  <InvoiceNoBetween xmlns:d2p1="http://schemas.microsoft.com/2003/10/Serialization/Arrays">
    <d2p1:string>String</d2p1:string>
  </InvoiceNoBetween>
  <InvoiceNoContains>String</InvoiceNoContains>
  <InvoiceNoEndsWith>String</InvoiceNoEndsWith>
  <InvoiceNoIn xmlns:d2p1="http://schemas.microsoft.com/2003/10/Serialization/Arrays">
    <d2p1:string>String</d2p1:string>
  </InvoiceNoIn>
  <InvoiceNoLike>String</InvoiceNoLike>
  <InvoiceNoStartsWith>String</InvoiceNoStartsWith>
  <LineCost>0</LineCost>
  <LineCostBetween xmlns:d2p1="http://schemas.datacontract.org/2004/07/System">
    <d2p1:decimal>0</d2p1:decimal>
  </LineCostBetween>
  <LineCostGreaterThan>0</LineCostGreaterThan>
  <LineCostGreaterThanOrEqualTo>0</LineCostGreaterThanOrEqualTo>
  <LineCostIn xmlns:d2p1="http://schemas.datacontract.org/2004/07/System">
    <d2p1:decimal>0</d2p1:decimal>
  </LineCostIn>
  <LineCostLessThan>0</LineCostLessThan>
  <LineCostLessThanOrEqualTo>0</LineCostLessThanOrEqualTo>
  <LineCostNotEqualTo>0</LineCostNotEqualTo>
  <LineProfit>0</LineProfit>
  <LineProfitBetween xmlns:d2p1="http://schemas.datacontract.org/2004/07/System">
    <d2p1:decimal>0</d2p1:decimal>
  </LineProfitBetween>
  <LineProfitGreaterThan>0</LineProfitGreaterThan>
  <LineProfitGreaterThanOrEqualTo>0</LineProfitGreaterThanOrEqualTo>
  <LineProfitIn xmlns:d2p1="http://schemas.datacontract.org/2004/07/System">
    <d2p1:decimal>0</d2p1:decimal>
  </LineProfitIn>
  <LineProfitLessThan>0</LineProfitLessThan>
  <LineProfitLessThanOrEqualTo>0</LineProfitLessThanOrEqualTo>
  <LineProfitNotEqualTo>0</LineProfitNotEqualTo>
  <LineTaxTotal>0</LineTaxTotal>
  <LineTaxTotalBetween xmlns:d2p1="http://schemas.datacontract.org/2004/07/System">
    <d2p1:decimal>0</d2p1:decimal>
  </LineTaxTotalBetween>
  <LineTaxTotalGreaterThan>0</LineTaxTotalGreaterThan>
  <LineTaxTotalGreaterThanOrEqualTo>0</LineTaxTotalGreaterThanOrEqualTo>
  <LineTaxTotalIn xmlns:d2p1="http://schemas.datacontract.org/2004/07/System">
    <d2p1:decimal>0</d2p1:decimal>
  </LineTaxTotalIn>
  <LineTaxTotalLessThan>0</LineTaxTotalLessThan>
  <LineTaxTotalLessThanOrEqualTo>0</LineTaxTotalLessThanOrEqualTo>
  <LineTaxTotalNotEqualTo>0</LineTaxTotalNotEqualTo>
  <LineTotalExGST>0</LineTotalExGST>
  <LineTotalExGSTBetween xmlns:d2p1="http://schemas.datacontract.org/2004/07/System">
    <d2p1:decimal>0</d2p1:decimal>
  </LineTotalExGSTBetween>
  <LineTotalExGSTGreaterThan>0</LineTotalExGSTGreaterThan>
  <LineTotalExGSTGreaterThanOrEqualTo>0</LineTotalExGSTGreaterThanOrEqualTo>
  <LineTotalExGSTIn xmlns:d2p1="http://schemas.datacontract.org/2004/07/System">
    <d2p1:decimal>0</d2p1:decimal>
  </LineTotalExGSTIn>
  <LineTotalExGSTLessThan>0</LineTotalExGSTLessThan>
  <LineTotalExGSTLessThanOrEqualTo>0</LineTotalExGSTLessThanOrEqualTo>
  <LineTotalExGSTNotEqualTo>0</LineTotalExGSTNotEqualTo>
  <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>
  <PartDescription>String</PartDescription>
  <PartDescriptionBetween xmlns:d2p1="http://schemas.microsoft.com/2003/10/Serialization/Arrays">
    <d2p1:string>String</d2p1:string>
  </PartDescriptionBetween>
  <PartDescriptionContains>String</PartDescriptionContains>
  <PartDescriptionEndsWith>String</PartDescriptionEndsWith>
  <PartDescriptionIn xmlns:d2p1="http://schemas.microsoft.com/2003/10/Serialization/Arrays">
    <d2p1:string>String</d2p1:string>
  </PartDescriptionIn>
  <PartDescriptionLike>String</PartDescriptionLike>
  <PartDescriptionStartsWith>String</PartDescriptionStartsWith>
  <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>
  <ProcessDate>0001-01-01T00:00:00</ProcessDate>
  <ProcessDateBetween xmlns:d2p1="http://schemas.datacontract.org/2004/07/System">
    <d2p1:dateTime>0001-01-01T00:00:00</d2p1:dateTime>
  </ProcessDateBetween>
  <ProcessDateGreaterThan>0001-01-01T00:00:00</ProcessDateGreaterThan>
  <ProcessDateGreaterThanOrEqualTo>0001-01-01T00:00:00</ProcessDateGreaterThanOrEqualTo>
  <ProcessDateIn xmlns:d2p1="http://schemas.datacontract.org/2004/07/System">
    <d2p1:dateTime>0001-01-01T00:00:00</d2p1:dateTime>
  </ProcessDateIn>
  <ProcessDateLessThan>0001-01-01T00:00:00</ProcessDateLessThan>
  <ProcessDateLessThanOrEqualTo>0001-01-01T00:00:00</ProcessDateLessThanOrEqualTo>
  <ProcessDateNotEqualTo>0001-01-01T00:00:00</ProcessDateNotEqualTo>
  <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>
  <StaffID>String</StaffID>
  <StaffIDBetween xmlns:d2p1="http://schemas.microsoft.com/2003/10/Serialization/Arrays">
    <d2p1:string>String</d2p1:string>
  </StaffIDBetween>
  <StaffIDContains>String</StaffIDContains>
  <StaffIDEndsWith>String</StaffIDEndsWith>
  <StaffIDIn xmlns:d2p1="http://schemas.microsoft.com/2003/10/Serialization/Arrays">
    <d2p1:string>String</d2p1:string>
  </StaffIDIn>
  <StaffIDLike>String</StaffIDLike>
  <StaffIDStartsWith>String</StaffIDStartsWith>
</v_SalesInformationQuery>

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

<QueryResponseOfv_SalesInformation7kRqkrSv 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_SalesInformation>
      <d2p1:_x003C_BranchID_x003E_k__BackingField>String</d2p1:_x003C_BranchID_x003E_k__BackingField>
      <d2p1:_x003C_Category1DescriptionAtTimeOfSale_x003E_k__BackingField>String</d2p1:_x003C_Category1DescriptionAtTimeOfSale_x003E_k__BackingField>
      <d2p1:_x003C_Category2DescriptionAtTimeOfSale_x003E_k__BackingField>String</d2p1:_x003C_Category2DescriptionAtTimeOfSale_x003E_k__BackingField>
      <d2p1:_x003C_Category3DescriptionAtTimeOfSale_x003E_k__BackingField>String</d2p1:_x003C_Category3DescriptionAtTimeOfSale_x003E_k__BackingField>
      <d2p1:_x003C_ClassificationDescription_x003E_k__BackingField>String</d2p1:_x003C_ClassificationDescription_x003E_k__BackingField>
      <d2p1:_x003C_DebtorClassificationID_x003E_k__BackingField>String</d2p1:_x003C_DebtorClassificationID_x003E_k__BackingField>
      <d2p1:_x003C_DebtorID_x003E_k__BackingField>String</d2p1:_x003C_DebtorID_x003E_k__BackingField>
      <d2p1:_x003C_IN_LogicalID_x003E_k__BackingField>String</d2p1:_x003C_IN_LogicalID_x003E_k__BackingField>
      <d2p1:_x003C_IN_PhysicalID_x003E_k__BackingField>String</d2p1:_x003C_IN_PhysicalID_x003E_k__BackingField>
      <d2p1:_x003C_InventoryID_x003E_k__BackingField>String</d2p1:_x003C_InventoryID_x003E_k__BackingField>
      <d2p1:_x003C_InvoiceLineID_x003E_k__BackingField>String</d2p1:_x003C_InvoiceLineID_x003E_k__BackingField>
      <d2p1:_x003C_InvoiceNo_x003E_k__BackingField>String</d2p1:_x003C_InvoiceNo_x003E_k__BackingField>
      <d2p1:_x003C_LineCost_x003E_k__BackingField>0</d2p1:_x003C_LineCost_x003E_k__BackingField>
      <d2p1:_x003C_LineProfit_x003E_k__BackingField>0</d2p1:_x003C_LineProfit_x003E_k__BackingField>
      <d2p1:_x003C_LineTaxTotal_x003E_k__BackingField>0</d2p1:_x003C_LineTaxTotal_x003E_k__BackingField>
      <d2p1:_x003C_LineTotalExGST_x003E_k__BackingField>0</d2p1:_x003C_LineTotalExGST_x003E_k__BackingField>
      <d2p1:_x003C_LineTotalIncGST_x003E_k__BackingField>0</d2p1:_x003C_LineTotalIncGST_x003E_k__BackingField>
      <d2p1:_x003C_PartDescription_x003E_k__BackingField>String</d2p1:_x003C_PartDescription_x003E_k__BackingField>
      <d2p1:_x003C_PartNo_x003E_k__BackingField>String</d2p1:_x003C_PartNo_x003E_k__BackingField>
      <d2p1:_x003C_ProcessDate_x003E_k__BackingField>0001-01-01T00:00:00</d2p1:_x003C_ProcessDate_x003E_k__BackingField>
      <d2p1:_x003C_Quantity_x003E_k__BackingField>0</d2p1:_x003C_Quantity_x003E_k__BackingField>
      <d2p1:_x003C_StaffID_x003E_k__BackingField>String</d2p1:_x003C_StaffID_x003E_k__BackingField>
    </d2p1:v_SalesInformation>
  </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_SalesInformation7kRqkrSv>