JiwaAPI

v_JB_MainQuery

**v_JB_MainQuery** Parameters:
Name	Parameter	Data Type	Required
JobID	query	string	No
JobIDStartsWith	query	string	No
JobIDEndsWith	query	string	No
JobIDContains	query	string	No
JobIDLike	query	string	No
JobIDBetween	query	string[]	No
JobIDIn	query	string[]	No
JobNo	query	string	No
JobNoStartsWith	query	string	No
JobNoEndsWith	query	string	No
JobNoContains	query	string	No
JobNoLike	query	string	No
JobNoBetween	query	string[]	No
JobNoIn	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
JobGroup	query	string	No
JobGroupStartsWith	query	string	No
JobGroupEndsWith	query	string	No
JobGroupContains	query	string	No
JobGroupLike	query	string	No
JobGroupBetween	query	string[]	No
JobGroupIn	query	string[]	No
AccountNo	query	string	No
AccountNoStartsWith	query	string	No
AccountNoEndsWith	query	string	No
AccountNoContains	query	string	No
AccountNoLike	query	string	No
AccountNoBetween	query	string[]	No
AccountNoIn	query	string[]	No
Name	query	string	No
NameStartsWith	query	string	No
NameEndsWith	query	string	No
NameContains	query	string	No
NameLike	query	string	No
NameBetween	query	string[]	No
NameIn	query	string[]	No
OrderNo	query	string	No
OrderNoStartsWith	query	string	No
OrderNoEndsWith	query	string	No
OrderNoContains	query	string	No
OrderNoLike	query	string	No
OrderNoBetween	query	string[]	No
OrderNoIn	query	string[]	No
IsTemplate	query	bool?	No
Status	query	string	No
StatusStartsWith	query	string	No
StatusEndsWith	query	string	No
StatusContains	query	string	No
StatusLike	query	string	No
StatusBetween	query	string[]	No
StatusIn	query	string[]	No
StartDate	query	DateTime?	No
StartDateGreaterThanOrEqualTo	query	DateTime?	No
StartDateGreaterThan	query	DateTime?	No
StartDateLessThan	query	DateTime?	No
StartDateLessThanOrEqualTo	query	DateTime?	No
StartDateNotEqualTo	query	DateTime?	No
StartDateBetween	query	DateTime[]	No
StartDateIn	query	DateTime[]	No
EstEndDate	query	DateTime?	No
EstEndDateGreaterThanOrEqualTo	query	DateTime?	No
EstEndDateGreaterThan	query	DateTime?	No
EstEndDateLessThan	query	DateTime?	No
EstEndDateLessThanOrEqualTo	query	DateTime?	No
EstEndDateNotEqualTo	query	DateTime?	No
EstEndDateBetween	query	DateTime[]	No
EstEndDateIn	query	DateTime[]	No
EstStartDate	query	DateTime?	No
EstStartDateGreaterThanOrEqualTo	query	DateTime?	No
EstStartDateGreaterThan	query	DateTime?	No
EstStartDateLessThan	query	DateTime?	No
EstStartDateLessThanOrEqualTo	query	DateTime?	No
EstStartDateNotEqualTo	query	DateTime?	No
EstStartDateBetween	query	DateTime[]	No
EstStartDateIn	query	DateTime[]	No
ClosedDate	query	DateTime?	No
ClosedDateGreaterThanOrEqualTo	query	DateTime?	No
ClosedDateGreaterThan	query	DateTime?	No
ClosedDateLessThan	query	DateTime?	No
ClosedDateLessThanOrEqualTo	query	DateTime?	No
ClosedDateNotEqualTo	query	DateTime?	No
ClosedDateBetween	query	DateTime[]	No
ClosedDateIn	query	DateTime[]	No
InventorySellType	query	short?	No
InventorySellTypeGreaterThanOrEqualTo	query	short?	No
InventorySellTypeGreaterThan	query	short?	No
InventorySellTypeLessThan	query	short?	No
InventorySellTypeLessThanOrEqualTo	query	short?	No
InventorySellTypeNotEqualTo	query	short?	No
InventorySellTypeBetween	query	Nullable<Int16>[]	No
InventorySellTypeIn	query	Nullable<Int16>[]	No
ContractAmount	query	decimal?	No
ContractAmountGreaterThanOrEqualTo	query	decimal?	No
ContractAmountGreaterThan	query	decimal?	No
ContractAmountLessThan	query	decimal?	No
ContractAmountLessThanOrEqualTo	query	decimal?	No
ContractAmountNotEqualTo	query	decimal?	No
ContractAmountBetween	query	Nullable<Decimal>[]	No
ContractAmountIn	query	Nullable<Decimal>[]	No
MarkUpMaterials	query	decimal?	No
MarkUpMaterialsGreaterThanOrEqualTo	query	decimal?	No
MarkUpMaterialsGreaterThan	query	decimal?	No
MarkUpMaterialsLessThan	query	decimal?	No
MarkUpMaterialsLessThanOrEqualTo	query	decimal?	No
MarkUpMaterialsNotEqualTo	query	decimal?	No
MarkUpMaterialsBetween	query	Nullable<Decimal>[]	No
MarkUpMaterialsIn	query	Nullable<Decimal>[]	No
MarkUpLabour	query	decimal?	No
MarkUpLabourGreaterThanOrEqualTo	query	decimal?	No
MarkUpLabourGreaterThan	query	decimal?	No
MarkUpLabourLessThan	query	decimal?	No
MarkUpLabourLessThanOrEqualTo	query	decimal?	No
MarkUpLabourNotEqualTo	query	decimal?	No
MarkUpLabourBetween	query	Nullable<Decimal>[]	No
MarkUpLabourIn	query	Nullable<Decimal>[]	No
MarkUpSubContract	query	decimal?	No
MarkUpSubContractGreaterThanOrEqualTo	query	decimal?	No
MarkUpSubContractGreaterThan	query	decimal?	No
MarkUpSubContractLessThan	query	decimal?	No
MarkUpSubContractLessThanOrEqualTo	query	decimal?	No
MarkUpSubContractNotEqualTo	query	decimal?	No
MarkUpSubContractBetween	query	Nullable<Decimal>[]	No
MarkUpSubContractIn	query	Nullable<Decimal>[]	No
MarkUpResource	query	decimal?	No
MarkUpResourceGreaterThanOrEqualTo	query	decimal?	No
MarkUpResourceGreaterThan	query	decimal?	No
MarkUpResourceLessThan	query	decimal?	No
MarkUpResourceLessThanOrEqualTo	query	decimal?	No
MarkUpResourceNotEqualTo	query	decimal?	No
MarkUpResourceBetween	query	Nullable<Decimal>[]	No
MarkUpResourceIn	query	Nullable<Decimal>[]	No
RetentionType	query	short?	No
RetentionTypeGreaterThanOrEqualTo	query	short?	No
RetentionTypeGreaterThan	query	short?	No
RetentionTypeLessThan	query	short?	No
RetentionTypeLessThanOrEqualTo	query	short?	No
RetentionTypeNotEqualTo	query	short?	No
RetentionTypeBetween	query	Nullable<Int16>[]	No
RetentionTypeIn	query	Nullable<Int16>[]	No
RetentionValue	query	decimal?	No
RetentionValueGreaterThanOrEqualTo	query	decimal?	No
RetentionValueGreaterThan	query	decimal?	No
RetentionValueLessThan	query	decimal?	No
RetentionValueLessThanOrEqualTo	query	decimal?	No
RetentionValueNotEqualTo	query	decimal?	No
RetentionValueBetween	query	Nullable<Decimal>[]	No
RetentionValueIn	query	Nullable<Decimal>[]	No
GstApplicable	query	bool?	No
Priority	query	string	No
PriorityStartsWith	query	string	No
PriorityEndsWith	query	string	No
PriorityContains	query	string	No
PriorityLike	query	string	No
PriorityBetween	query	string[]	No
PriorityIn	query	string[]	No
CostCentreNo	query	string	No
CostCentreNoStartsWith	query	string	No
CostCentreNoEndsWith	query	string	No
CostCentreNoContains	query	string	No
CostCentreNoLike	query	string	No
CostCentreNoBetween	query	string[]	No
CostCentreNoIn	query	string[]	No
CostCentreDesc	query	string	No
CostCentreDescStartsWith	query	string	No
CostCentreDescEndsWith	query	string	No
CostCentreDescContains	query	string	No
CostCentreDescLike	query	string	No
CostCentreDescBetween	query	string[]	No
CostCentreDescIn	query	string[]	No
CostCentreIsEnabled	query	bool?	No
StageNo	query	string	No
StageNoStartsWith	query	string	No
StageNoEndsWith	query	string	No
StageNoContains	query	string	No
StageNoLike	query	string	No
StageNoBetween	query	string[]	No
StageNoIn	query	string[]	No
StageDesc	query	string	No
StageDescStartsWith	query	string	No
StageDescEndsWith	query	string	No
StageDescContains	query	string	No
StageDescLike	query	string	No
StageDescBetween	query	string[]	No
StageDescIn	query	string[]	No
StageIsEnabled	query	bool?	No
ClassDesc	query	string	No
ClassDescStartsWith	query	string	No
ClassDescEndsWith	query	string	No
ClassDescContains	query	string	No
ClassDescLike	query	string	No
ClassDescBetween	query	string[]	No
ClassDescIn	query	string[]	No
JobClass	query	string	No
JobClassStartsWith	query	string	No
JobClassEndsWith	query	string	No
JobClassContains	query	string	No
JobClassLike	query	string	No
JobClassBetween	query	string[]	No
JobClassIn	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_JB_Main** Parameters:
Name	Parameter	Data Type	Required
JobID	form	string	No
JobNo	form	string	No
Description	form	string	No
JobGroup	form	string	No
AccountNo	form	string	No
Name	form	string	No
OrderNo	form	string	No
IsTemplate	form	bool?	No
Status	form	string	No
StartDate	form	DateTime	No
EstEndDate	form	DateTime	No
EstStartDate	form	DateTime	No
ClosedDate	form	DateTime	No
InventorySellType	form	short?	No
ContractAmount	form	decimal?	No
MarkUpMaterials	form	decimal?	No
MarkUpLabour	form	decimal?	No
MarkUpSubContract	form	decimal?	No
MarkUpResource	form	decimal?	No
RetentionType	form	short?	No
RetentionValue	form	decimal?	No
GstApplicable	form	bool?	No
Priority	form	string	No
CostCentreNo	form	string	No
CostCentreDesc	form	string	No
CostCentreIsEnabled	form	bool?	No
StageNo	form	string	No
StageDesc	form	string	No
StageIsEnabled	form	bool?	No
ClassDesc	form	string	No
JobClass	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_JB_MainQuery HTTP/1.1 
Host: api.jiwa.com.au 
Accept: application/xml
Content-Type: application/xml
Content-Length: length

<v_JB_MainQuery 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>
  <AccountNo>String</AccountNo>
  <AccountNoBetween xmlns:d2p1="http://schemas.microsoft.com/2003/10/Serialization/Arrays">
    <d2p1:string>String</d2p1:string>
  </AccountNoBetween>
  <AccountNoContains>String</AccountNoContains>
  <AccountNoEndsWith>String</AccountNoEndsWith>
  <AccountNoIn xmlns:d2p1="http://schemas.microsoft.com/2003/10/Serialization/Arrays">
    <d2p1:string>String</d2p1:string>
  </AccountNoIn>
  <AccountNoLike>String</AccountNoLike>
  <AccountNoStartsWith>String</AccountNoStartsWith>
  <ClassDesc>String</ClassDesc>
  <ClassDescBetween xmlns:d2p1="http://schemas.microsoft.com/2003/10/Serialization/Arrays">
    <d2p1:string>String</d2p1:string>
  </ClassDescBetween>
  <ClassDescContains>String</ClassDescContains>
  <ClassDescEndsWith>String</ClassDescEndsWith>
  <ClassDescIn xmlns:d2p1="http://schemas.microsoft.com/2003/10/Serialization/Arrays">
    <d2p1:string>String</d2p1:string>
  </ClassDescIn>
  <ClassDescLike>String</ClassDescLike>
  <ClassDescStartsWith>String</ClassDescStartsWith>
  <ClosedDate>0001-01-01T00:00:00</ClosedDate>
  <ClosedDateBetween xmlns:d2p1="http://schemas.microsoft.com/2003/10/Serialization/Arrays">
    <d2p1:dateTime>0001-01-01T00:00:00</d2p1:dateTime>
  </ClosedDateBetween>
  <ClosedDateGreaterThan>0001-01-01T00:00:00</ClosedDateGreaterThan>
  <ClosedDateGreaterThanOrEqualTo>0001-01-01T00:00:00</ClosedDateGreaterThanOrEqualTo>
  <ClosedDateIn xmlns:d2p1="http://schemas.microsoft.com/2003/10/Serialization/Arrays">
    <d2p1:dateTime>0001-01-01T00:00:00</d2p1:dateTime>
  </ClosedDateIn>
  <ClosedDateLessThan>0001-01-01T00:00:00</ClosedDateLessThan>
  <ClosedDateLessThanOrEqualTo>0001-01-01T00:00:00</ClosedDateLessThanOrEqualTo>
  <ClosedDateNotEqualTo>0001-01-01T00:00:00</ClosedDateNotEqualTo>
  <ContractAmount>0</ContractAmount>
  <ContractAmountBetween xmlns:d2p1="http://schemas.datacontract.org/2004/07/System">
    <d2p1:decimal>0</d2p1:decimal>
  </ContractAmountBetween>
  <ContractAmountGreaterThan>0</ContractAmountGreaterThan>
  <ContractAmountGreaterThanOrEqualTo>0</ContractAmountGreaterThanOrEqualTo>
  <ContractAmountIn xmlns:d2p1="http://schemas.datacontract.org/2004/07/System">
    <d2p1:decimal>0</d2p1:decimal>
  </ContractAmountIn>
  <ContractAmountLessThan>0</ContractAmountLessThan>
  <ContractAmountLessThanOrEqualTo>0</ContractAmountLessThanOrEqualTo>
  <ContractAmountNotEqualTo>0</ContractAmountNotEqualTo>
  <CostCentreDesc>String</CostCentreDesc>
  <CostCentreDescBetween xmlns:d2p1="http://schemas.microsoft.com/2003/10/Serialization/Arrays">
    <d2p1:string>String</d2p1:string>
  </CostCentreDescBetween>
  <CostCentreDescContains>String</CostCentreDescContains>
  <CostCentreDescEndsWith>String</CostCentreDescEndsWith>
  <CostCentreDescIn xmlns:d2p1="http://schemas.microsoft.com/2003/10/Serialization/Arrays">
    <d2p1:string>String</d2p1:string>
  </CostCentreDescIn>
  <CostCentreDescLike>String</CostCentreDescLike>
  <CostCentreDescStartsWith>String</CostCentreDescStartsWith>
  <CostCentreIsEnabled>false</CostCentreIsEnabled>
  <CostCentreNo>String</CostCentreNo>
  <CostCentreNoBetween xmlns:d2p1="http://schemas.microsoft.com/2003/10/Serialization/Arrays">
    <d2p1:string>String</d2p1:string>
  </CostCentreNoBetween>
  <CostCentreNoContains>String</CostCentreNoContains>
  <CostCentreNoEndsWith>String</CostCentreNoEndsWith>
  <CostCentreNoIn xmlns:d2p1="http://schemas.microsoft.com/2003/10/Serialization/Arrays">
    <d2p1:string>String</d2p1:string>
  </CostCentreNoIn>
  <CostCentreNoLike>String</CostCentreNoLike>
  <CostCentreNoStartsWith>String</CostCentreNoStartsWith>
  <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>
  <EstEndDate>0001-01-01T00:00:00</EstEndDate>
  <EstEndDateBetween xmlns:d2p1="http://schemas.microsoft.com/2003/10/Serialization/Arrays">
    <d2p1:dateTime>0001-01-01T00:00:00</d2p1:dateTime>
  </EstEndDateBetween>
  <EstEndDateGreaterThan>0001-01-01T00:00:00</EstEndDateGreaterThan>
  <EstEndDateGreaterThanOrEqualTo>0001-01-01T00:00:00</EstEndDateGreaterThanOrEqualTo>
  <EstEndDateIn xmlns:d2p1="http://schemas.microsoft.com/2003/10/Serialization/Arrays">
    <d2p1:dateTime>0001-01-01T00:00:00</d2p1:dateTime>
  </EstEndDateIn>
  <EstEndDateLessThan>0001-01-01T00:00:00</EstEndDateLessThan>
  <EstEndDateLessThanOrEqualTo>0001-01-01T00:00:00</EstEndDateLessThanOrEqualTo>
  <EstEndDateNotEqualTo>0001-01-01T00:00:00</EstEndDateNotEqualTo>
  <EstStartDate>0001-01-01T00:00:00</EstStartDate>
  <EstStartDateBetween xmlns:d2p1="http://schemas.microsoft.com/2003/10/Serialization/Arrays">
    <d2p1:dateTime>0001-01-01T00:00:00</d2p1:dateTime>
  </EstStartDateBetween>
  <EstStartDateGreaterThan>0001-01-01T00:00:00</EstStartDateGreaterThan>
  <EstStartDateGreaterThanOrEqualTo>0001-01-01T00:00:00</EstStartDateGreaterThanOrEqualTo>
  <EstStartDateIn xmlns:d2p1="http://schemas.microsoft.com/2003/10/Serialization/Arrays">
    <d2p1:dateTime>0001-01-01T00:00:00</d2p1:dateTime>
  </EstStartDateIn>
  <EstStartDateLessThan>0001-01-01T00:00:00</EstStartDateLessThan>
  <EstStartDateLessThanOrEqualTo>0001-01-01T00:00:00</EstStartDateLessThanOrEqualTo>
  <EstStartDateNotEqualTo>0001-01-01T00:00:00</EstStartDateNotEqualTo>
  <GstApplicable>false</GstApplicable>
  <InventorySellType>0</InventorySellType>
  <InventorySellTypeBetween xmlns:d2p1="http://schemas.datacontract.org/2004/07/System">
    <d2p1:short>0</d2p1:short>
  </InventorySellTypeBetween>
  <InventorySellTypeGreaterThan>0</InventorySellTypeGreaterThan>
  <InventorySellTypeGreaterThanOrEqualTo>0</InventorySellTypeGreaterThanOrEqualTo>
  <InventorySellTypeIn xmlns:d2p1="http://schemas.datacontract.org/2004/07/System">
    <d2p1:short>0</d2p1:short>
  </InventorySellTypeIn>
  <InventorySellTypeLessThan>0</InventorySellTypeLessThan>
  <InventorySellTypeLessThanOrEqualTo>0</InventorySellTypeLessThanOrEqualTo>
  <InventorySellTypeNotEqualTo>0</InventorySellTypeNotEqualTo>
  <IsTemplate>false</IsTemplate>
  <JobClass>String</JobClass>
  <JobClassBetween xmlns:d2p1="http://schemas.microsoft.com/2003/10/Serialization/Arrays">
    <d2p1:string>String</d2p1:string>
  </JobClassBetween>
  <JobClassContains>String</JobClassContains>
  <JobClassEndsWith>String</JobClassEndsWith>
  <JobClassIn xmlns:d2p1="http://schemas.microsoft.com/2003/10/Serialization/Arrays">
    <d2p1:string>String</d2p1:string>
  </JobClassIn>
  <JobClassLike>String</JobClassLike>
  <JobClassStartsWith>String</JobClassStartsWith>
  <JobGroup>String</JobGroup>
  <JobGroupBetween xmlns:d2p1="http://schemas.microsoft.com/2003/10/Serialization/Arrays">
    <d2p1:string>String</d2p1:string>
  </JobGroupBetween>
  <JobGroupContains>String</JobGroupContains>
  <JobGroupEndsWith>String</JobGroupEndsWith>
  <JobGroupIn xmlns:d2p1="http://schemas.microsoft.com/2003/10/Serialization/Arrays">
    <d2p1:string>String</d2p1:string>
  </JobGroupIn>
  <JobGroupLike>String</JobGroupLike>
  <JobGroupStartsWith>String</JobGroupStartsWith>
  <JobID>String</JobID>
  <JobIDBetween xmlns:d2p1="http://schemas.microsoft.com/2003/10/Serialization/Arrays">
    <d2p1:string>String</d2p1:string>
  </JobIDBetween>
  <JobIDContains>String</JobIDContains>
  <JobIDEndsWith>String</JobIDEndsWith>
  <JobIDIn xmlns:d2p1="http://schemas.microsoft.com/2003/10/Serialization/Arrays">
    <d2p1:string>String</d2p1:string>
  </JobIDIn>
  <JobIDLike>String</JobIDLike>
  <JobIDStartsWith>String</JobIDStartsWith>
  <JobNo>String</JobNo>
  <JobNoBetween xmlns:d2p1="http://schemas.microsoft.com/2003/10/Serialization/Arrays">
    <d2p1:string>String</d2p1:string>
  </JobNoBetween>
  <JobNoContains>String</JobNoContains>
  <JobNoEndsWith>String</JobNoEndsWith>
  <JobNoIn xmlns:d2p1="http://schemas.microsoft.com/2003/10/Serialization/Arrays">
    <d2p1:string>String</d2p1:string>
  </JobNoIn>
  <JobNoLike>String</JobNoLike>
  <JobNoStartsWith>String</JobNoStartsWith>
  <MarkUpLabour>0</MarkUpLabour>
  <MarkUpLabourBetween xmlns:d2p1="http://schemas.datacontract.org/2004/07/System">
    <d2p1:decimal>0</d2p1:decimal>
  </MarkUpLabourBetween>
  <MarkUpLabourGreaterThan>0</MarkUpLabourGreaterThan>
  <MarkUpLabourGreaterThanOrEqualTo>0</MarkUpLabourGreaterThanOrEqualTo>
  <MarkUpLabourIn xmlns:d2p1="http://schemas.datacontract.org/2004/07/System">
    <d2p1:decimal>0</d2p1:decimal>
  </MarkUpLabourIn>
  <MarkUpLabourLessThan>0</MarkUpLabourLessThan>
  <MarkUpLabourLessThanOrEqualTo>0</MarkUpLabourLessThanOrEqualTo>
  <MarkUpLabourNotEqualTo>0</MarkUpLabourNotEqualTo>
  <MarkUpMaterials>0</MarkUpMaterials>
  <MarkUpMaterialsBetween xmlns:d2p1="http://schemas.datacontract.org/2004/07/System">
    <d2p1:decimal>0</d2p1:decimal>
  </MarkUpMaterialsBetween>
  <MarkUpMaterialsGreaterThan>0</MarkUpMaterialsGreaterThan>
  <MarkUpMaterialsGreaterThanOrEqualTo>0</MarkUpMaterialsGreaterThanOrEqualTo>
  <MarkUpMaterialsIn xmlns:d2p1="http://schemas.datacontract.org/2004/07/System">
    <d2p1:decimal>0</d2p1:decimal>
  </MarkUpMaterialsIn>
  <MarkUpMaterialsLessThan>0</MarkUpMaterialsLessThan>
  <MarkUpMaterialsLessThanOrEqualTo>0</MarkUpMaterialsLessThanOrEqualTo>
  <MarkUpMaterialsNotEqualTo>0</MarkUpMaterialsNotEqualTo>
  <MarkUpResource>0</MarkUpResource>
  <MarkUpResourceBetween xmlns:d2p1="http://schemas.datacontract.org/2004/07/System">
    <d2p1:decimal>0</d2p1:decimal>
  </MarkUpResourceBetween>
  <MarkUpResourceGreaterThan>0</MarkUpResourceGreaterThan>
  <MarkUpResourceGreaterThanOrEqualTo>0</MarkUpResourceGreaterThanOrEqualTo>
  <MarkUpResourceIn xmlns:d2p1="http://schemas.datacontract.org/2004/07/System">
    <d2p1:decimal>0</d2p1:decimal>
  </MarkUpResourceIn>
  <MarkUpResourceLessThan>0</MarkUpResourceLessThan>
  <MarkUpResourceLessThanOrEqualTo>0</MarkUpResourceLessThanOrEqualTo>
  <MarkUpResourceNotEqualTo>0</MarkUpResourceNotEqualTo>
  <MarkUpSubContract>0</MarkUpSubContract>
  <MarkUpSubContractBetween xmlns:d2p1="http://schemas.datacontract.org/2004/07/System">
    <d2p1:decimal>0</d2p1:decimal>
  </MarkUpSubContractBetween>
  <MarkUpSubContractGreaterThan>0</MarkUpSubContractGreaterThan>
  <MarkUpSubContractGreaterThanOrEqualTo>0</MarkUpSubContractGreaterThanOrEqualTo>
  <MarkUpSubContractIn xmlns:d2p1="http://schemas.datacontract.org/2004/07/System">
    <d2p1:decimal>0</d2p1:decimal>
  </MarkUpSubContractIn>
  <MarkUpSubContractLessThan>0</MarkUpSubContractLessThan>
  <MarkUpSubContractLessThanOrEqualTo>0</MarkUpSubContractLessThanOrEqualTo>
  <MarkUpSubContractNotEqualTo>0</MarkUpSubContractNotEqualTo>
  <Name>String</Name>
  <NameBetween xmlns:d2p1="http://schemas.microsoft.com/2003/10/Serialization/Arrays">
    <d2p1:string>String</d2p1:string>
  </NameBetween>
  <NameContains>String</NameContains>
  <NameEndsWith>String</NameEndsWith>
  <NameIn xmlns:d2p1="http://schemas.microsoft.com/2003/10/Serialization/Arrays">
    <d2p1:string>String</d2p1:string>
  </NameIn>
  <NameLike>String</NameLike>
  <NameStartsWith>String</NameStartsWith>
  <OrderNo>String</OrderNo>
  <OrderNoBetween xmlns:d2p1="http://schemas.microsoft.com/2003/10/Serialization/Arrays">
    <d2p1:string>String</d2p1:string>
  </OrderNoBetween>
  <OrderNoContains>String</OrderNoContains>
  <OrderNoEndsWith>String</OrderNoEndsWith>
  <OrderNoIn xmlns:d2p1="http://schemas.microsoft.com/2003/10/Serialization/Arrays">
    <d2p1:string>String</d2p1:string>
  </OrderNoIn>
  <OrderNoLike>String</OrderNoLike>
  <OrderNoStartsWith>String</OrderNoStartsWith>
  <Priority>String</Priority>
  <PriorityBetween xmlns:d2p1="http://schemas.microsoft.com/2003/10/Serialization/Arrays">
    <d2p1:string>String</d2p1:string>
  </PriorityBetween>
  <PriorityContains>String</PriorityContains>
  <PriorityEndsWith>String</PriorityEndsWith>
  <PriorityIn xmlns:d2p1="http://schemas.microsoft.com/2003/10/Serialization/Arrays">
    <d2p1:string>String</d2p1:string>
  </PriorityIn>
  <PriorityLike>String</PriorityLike>
  <PriorityStartsWith>String</PriorityStartsWith>
  <RetentionType>0</RetentionType>
  <RetentionTypeBetween xmlns:d2p1="http://schemas.datacontract.org/2004/07/System">
    <d2p1:short>0</d2p1:short>
  </RetentionTypeBetween>
  <RetentionTypeGreaterThan>0</RetentionTypeGreaterThan>
  <RetentionTypeGreaterThanOrEqualTo>0</RetentionTypeGreaterThanOrEqualTo>
  <RetentionTypeIn xmlns:d2p1="http://schemas.datacontract.org/2004/07/System">
    <d2p1:short>0</d2p1:short>
  </RetentionTypeIn>
  <RetentionTypeLessThan>0</RetentionTypeLessThan>
  <RetentionTypeLessThanOrEqualTo>0</RetentionTypeLessThanOrEqualTo>
  <RetentionTypeNotEqualTo>0</RetentionTypeNotEqualTo>
  <RetentionValue>0</RetentionValue>
  <RetentionValueBetween xmlns:d2p1="http://schemas.datacontract.org/2004/07/System">
    <d2p1:decimal>0</d2p1:decimal>
  </RetentionValueBetween>
  <RetentionValueGreaterThan>0</RetentionValueGreaterThan>
  <RetentionValueGreaterThanOrEqualTo>0</RetentionValueGreaterThanOrEqualTo>
  <RetentionValueIn xmlns:d2p1="http://schemas.datacontract.org/2004/07/System">
    <d2p1:decimal>0</d2p1:decimal>
  </RetentionValueIn>
  <RetentionValueLessThan>0</RetentionValueLessThan>
  <RetentionValueLessThanOrEqualTo>0</RetentionValueLessThanOrEqualTo>
  <RetentionValueNotEqualTo>0</RetentionValueNotEqualTo>
  <StageDesc>String</StageDesc>
  <StageDescBetween xmlns:d2p1="http://schemas.microsoft.com/2003/10/Serialization/Arrays">
    <d2p1:string>String</d2p1:string>
  </StageDescBetween>
  <StageDescContains>String</StageDescContains>
  <StageDescEndsWith>String</StageDescEndsWith>
  <StageDescIn xmlns:d2p1="http://schemas.microsoft.com/2003/10/Serialization/Arrays">
    <d2p1:string>String</d2p1:string>
  </StageDescIn>
  <StageDescLike>String</StageDescLike>
  <StageDescStartsWith>String</StageDescStartsWith>
  <StageIsEnabled>false</StageIsEnabled>
  <StageNo>String</StageNo>
  <StageNoBetween xmlns:d2p1="http://schemas.microsoft.com/2003/10/Serialization/Arrays">
    <d2p1:string>String</d2p1:string>
  </StageNoBetween>
  <StageNoContains>String</StageNoContains>
  <StageNoEndsWith>String</StageNoEndsWith>
  <StageNoIn xmlns:d2p1="http://schemas.microsoft.com/2003/10/Serialization/Arrays">
    <d2p1:string>String</d2p1:string>
  </StageNoIn>
  <StageNoLike>String</StageNoLike>
  <StageNoStartsWith>String</StageNoStartsWith>
  <StartDate>0001-01-01T00:00:00</StartDate>
  <StartDateBetween xmlns:d2p1="http://schemas.microsoft.com/2003/10/Serialization/Arrays">
    <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.microsoft.com/2003/10/Serialization/Arrays">
    <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>
  <Status>String</Status>
  <StatusBetween xmlns:d2p1="http://schemas.microsoft.com/2003/10/Serialization/Arrays">
    <d2p1:string>String</d2p1:string>
  </StatusBetween>
  <StatusContains>String</StatusContains>
  <StatusEndsWith>String</StatusEndsWith>
  <StatusIn xmlns:d2p1="http://schemas.microsoft.com/2003/10/Serialization/Arrays">
    <d2p1:string>String</d2p1:string>
  </StatusIn>
  <StatusLike>String</StatusLike>
  <StatusStartsWith>String</StatusStartsWith>
</v_JB_MainQuery>

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

<QueryResponseOfv_JB_Main7kRqkrSv 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_JB_Main>
      <d2p1:_x003C_AccountNo_x003E_k__BackingField>String</d2p1:_x003C_AccountNo_x003E_k__BackingField>
      <d2p1:_x003C_ClassDesc_x003E_k__BackingField>String</d2p1:_x003C_ClassDesc_x003E_k__BackingField>
      <d2p1:_x003C_ClosedDate_x003E_k__BackingField>0001-01-01T00:00:00</d2p1:_x003C_ClosedDate_x003E_k__BackingField>
      <d2p1:_x003C_ContractAmount_x003E_k__BackingField>0</d2p1:_x003C_ContractAmount_x003E_k__BackingField>
      <d2p1:_x003C_CostCentreDesc_x003E_k__BackingField>String</d2p1:_x003C_CostCentreDesc_x003E_k__BackingField>
      <d2p1:_x003C_CostCentreIsEnabled_x003E_k__BackingField>false</d2p1:_x003C_CostCentreIsEnabled_x003E_k__BackingField>
      <d2p1:_x003C_CostCentreNo_x003E_k__BackingField>String</d2p1:_x003C_CostCentreNo_x003E_k__BackingField>
      <d2p1:_x003C_Description_x003E_k__BackingField>String</d2p1:_x003C_Description_x003E_k__BackingField>
      <d2p1:_x003C_EstEndDate_x003E_k__BackingField>0001-01-01T00:00:00</d2p1:_x003C_EstEndDate_x003E_k__BackingField>
      <d2p1:_x003C_EstStartDate_x003E_k__BackingField>0001-01-01T00:00:00</d2p1:_x003C_EstStartDate_x003E_k__BackingField>
      <d2p1:_x003C_GstApplicable_x003E_k__BackingField>false</d2p1:_x003C_GstApplicable_x003E_k__BackingField>
      <d2p1:_x003C_InventorySellType_x003E_k__BackingField>0</d2p1:_x003C_InventorySellType_x003E_k__BackingField>
      <d2p1:_x003C_IsTemplate_x003E_k__BackingField>false</d2p1:_x003C_IsTemplate_x003E_k__BackingField>
      <d2p1:_x003C_JobClass_x003E_k__BackingField>String</d2p1:_x003C_JobClass_x003E_k__BackingField>
      <d2p1:_x003C_JobGroup_x003E_k__BackingField>String</d2p1:_x003C_JobGroup_x003E_k__BackingField>
      <d2p1:_x003C_JobID_x003E_k__BackingField>String</d2p1:_x003C_JobID_x003E_k__BackingField>
      <d2p1:_x003C_JobNo_x003E_k__BackingField>String</d2p1:_x003C_JobNo_x003E_k__BackingField>
      <d2p1:_x003C_MarkUpLabour_x003E_k__BackingField>0</d2p1:_x003C_MarkUpLabour_x003E_k__BackingField>
      <d2p1:_x003C_MarkUpMaterials_x003E_k__BackingField>0</d2p1:_x003C_MarkUpMaterials_x003E_k__BackingField>
      <d2p1:_x003C_MarkUpResource_x003E_k__BackingField>0</d2p1:_x003C_MarkUpResource_x003E_k__BackingField>
      <d2p1:_x003C_MarkUpSubContract_x003E_k__BackingField>0</d2p1:_x003C_MarkUpSubContract_x003E_k__BackingField>
      <d2p1:_x003C_Name_x003E_k__BackingField>String</d2p1:_x003C_Name_x003E_k__BackingField>
      <d2p1:_x003C_OrderNo_x003E_k__BackingField>String</d2p1:_x003C_OrderNo_x003E_k__BackingField>
      <d2p1:_x003C_Priority_x003E_k__BackingField>String</d2p1:_x003C_Priority_x003E_k__BackingField>
      <d2p1:_x003C_RetentionType_x003E_k__BackingField>0</d2p1:_x003C_RetentionType_x003E_k__BackingField>
      <d2p1:_x003C_RetentionValue_x003E_k__BackingField>0</d2p1:_x003C_RetentionValue_x003E_k__BackingField>
      <d2p1:_x003C_StageDesc_x003E_k__BackingField>String</d2p1:_x003C_StageDesc_x003E_k__BackingField>
      <d2p1:_x003C_StageIsEnabled_x003E_k__BackingField>false</d2p1:_x003C_StageIsEnabled_x003E_k__BackingField>
      <d2p1:_x003C_StageNo_x003E_k__BackingField>String</d2p1:_x003C_StageNo_x003E_k__BackingField>
      <d2p1:_x003C_StartDate_x003E_k__BackingField>0001-01-01T00:00:00</d2p1:_x003C_StartDate_x003E_k__BackingField>
      <d2p1:_x003C_Status_x003E_k__BackingField>String</d2p1:_x003C_Status_x003E_k__BackingField>
    </d2p1:v_JB_Main>
  </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_JB_Main7kRqkrSv>