JiwaAPI

v_JIWA_JobCosting_EstimateAndActualLinesQuery

**v_JIWA_JobCosting_EstimateAndActualLinesQuery** Parameters:
Name	Parameter	Data Type	Required
JB_Estimates_RecID	query	string	No
JB_Estimates_RecIDStartsWith	query	string	No
JB_Estimates_RecIDEndsWith	query	string	No
JB_Estimates_RecIDContains	query	string	No
JB_Estimates_RecIDLike	query	string	No
JB_Estimates_RecIDBetween	query	string[]	No
JB_Estimates_RecIDIn	query	string[]	No
JB_JobStages_RecID	query	string	No
JB_JobStages_RecIDStartsWith	query	string	No
JB_JobStages_RecIDEndsWith	query	string	No
JB_JobStages_RecIDContains	query	string	No
JB_JobStages_RecIDLike	query	string	No
JB_JobStages_RecIDBetween	query	string[]	No
JB_JobStages_RecIDIn	query	string[]	No
ComponentID	query	string	No
ComponentIDStartsWith	query	string	No
ComponentIDEndsWith	query	string	No
ComponentIDContains	query	string	No
ComponentIDLike	query	string	No
ComponentIDBetween	query	string[]	No
ComponentIDIn	query	string[]	No
ComponentNo	query	string	No
ComponentNoStartsWith	query	string	No
ComponentNoEndsWith	query	string	No
ComponentNoContains	query	string	No
ComponentNoLike	query	string	No
ComponentNoBetween	query	string[]	No
ComponentNoIn	query	string[]	No
ComponentDescription	query	string	No
ComponentDescriptionStartsWith	query	string	No
ComponentDescriptionEndsWith	query	string	No
ComponentDescriptionContains	query	string	No
ComponentDescriptionLike	query	string	No
ComponentDescriptionBetween	query	string[]	No
ComponentDescriptionIn	query	string[]	No
TransactionDate	query	DateTime?	No
TransactionDateGreaterThanOrEqualTo	query	DateTime?	No
TransactionDateGreaterThan	query	DateTime?	No
TransactionDateLessThan	query	DateTime?	No
TransactionDateLessThanOrEqualTo	query	DateTime?	No
TransactionDateNotEqualTo	query	DateTime?	No
TransactionDateBetween	query	DateTime[]	No
TransactionDateIn	query	DateTime[]	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	decimal[]	No
QuantityIn	query	decimal[]	No
UnitCost	query	decimal?	No
UnitCostGreaterThanOrEqualTo	query	decimal?	No
UnitCostGreaterThan	query	decimal?	No
UnitCostLessThan	query	decimal?	No
UnitCostLessThanOrEqualTo	query	decimal?	No
UnitCostNotEqualTo	query	decimal?	No
UnitCostBetween	query	decimal[]	No
UnitCostIn	query	decimal[]	No
UnitCharge	query	decimal?	No
UnitChargeGreaterThanOrEqualTo	query	decimal?	No
UnitChargeGreaterThan	query	decimal?	No
UnitChargeLessThan	query	decimal?	No
UnitChargeLessThanOrEqualTo	query	decimal?	No
UnitChargeNotEqualTo	query	decimal?	No
UnitChargeBetween	query	decimal[]	No
UnitChargeIn	query	decimal[]	No
Remark	query	string	No
RemarkStartsWith	query	string	No
RemarkEndsWith	query	string	No
RemarkContains	query	string	No
RemarkLike	query	string	No
RemarkBetween	query	string[]	No
RemarkIn	query	string[]	No
ItemNo	query	int?	No
ItemNoGreaterThanOrEqualTo	query	int?	No
ItemNoGreaterThan	query	int?	No
ItemNoLessThan	query	int?	No
ItemNoLessThanOrEqualTo	query	int?	No
ItemNoNotEqualTo	query	int?	No
ItemNoBetween	query	int[]	No
ItemNoIn	query	int[]	No
Units	query	string	No
UnitsStartsWith	query	string	No
UnitsEndsWith	query	string	No
UnitsContains	query	string	No
UnitsLike	query	string	No
UnitsBetween	query	string[]	No
UnitsIn	query	string[]	No
ComponentType	query	int?	No
ComponentTypeGreaterThanOrEqualTo	query	int?	No
ComponentTypeGreaterThan	query	int?	No
ComponentTypeLessThan	query	int?	No
ComponentTypeLessThanOrEqualTo	query	int?	No
ComponentTypeNotEqualTo	query	int?	No
ComponentTypeBetween	query	Nullable<Int32>[]	No
ComponentTypeIn	query	Nullable<Int32>[]	No
IsEstimate	query	int?	No
IsEstimateGreaterThanOrEqualTo	query	int?	No
IsEstimateGreaterThan	query	int?	No
IsEstimateLessThan	query	int?	No
IsEstimateLessThanOrEqualTo	query	int?	No
IsEstimateNotEqualTo	query	int?	No
IsEstimateBetween	query	int[]	No
IsEstimateIn	query	int[]	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_JIWA_JobCosting_EstimateAndActualLines** Parameters:
Name	Parameter	Data Type	Required
JB_Estimates_RecID	form	string	No
JB_JobStages_RecID	form	string	No
ComponentID	form	string	No
ComponentNo	form	string	No
ComponentDescription	form	string	No
TransactionDate	form	DateTime	No
Quantity	form	decimal	No
UnitCost	form	decimal	No
UnitCharge	form	decimal	No
Remark	form	string	No
ItemNo	form	int	No
Units	form	string	No
ComponentType	form	int?	No
IsEstimate	form	int	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_JIWA_JobCosting_EstimateAndActualLinesQuery HTTP/1.1 
Host: api.jiwa.com.au 
Accept: application/xml
Content-Type: application/xml
Content-Length: length

<v_JIWA_JobCosting_EstimateAndActualLinesQuery 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>
  <ComponentDescription>String</ComponentDescription>
  <ComponentDescriptionBetween xmlns:d2p1="http://schemas.microsoft.com/2003/10/Serialization/Arrays">
    <d2p1:string>String</d2p1:string>
  </ComponentDescriptionBetween>
  <ComponentDescriptionContains>String</ComponentDescriptionContains>
  <ComponentDescriptionEndsWith>String</ComponentDescriptionEndsWith>
  <ComponentDescriptionIn xmlns:d2p1="http://schemas.microsoft.com/2003/10/Serialization/Arrays">
    <d2p1:string>String</d2p1:string>
  </ComponentDescriptionIn>
  <ComponentDescriptionLike>String</ComponentDescriptionLike>
  <ComponentDescriptionStartsWith>String</ComponentDescriptionStartsWith>
  <ComponentID>String</ComponentID>
  <ComponentIDBetween xmlns:d2p1="http://schemas.microsoft.com/2003/10/Serialization/Arrays">
    <d2p1:string>String</d2p1:string>
  </ComponentIDBetween>
  <ComponentIDContains>String</ComponentIDContains>
  <ComponentIDEndsWith>String</ComponentIDEndsWith>
  <ComponentIDIn xmlns:d2p1="http://schemas.microsoft.com/2003/10/Serialization/Arrays">
    <d2p1:string>String</d2p1:string>
  </ComponentIDIn>
  <ComponentIDLike>String</ComponentIDLike>
  <ComponentIDStartsWith>String</ComponentIDStartsWith>
  <ComponentNo>String</ComponentNo>
  <ComponentNoBetween xmlns:d2p1="http://schemas.microsoft.com/2003/10/Serialization/Arrays">
    <d2p1:string>String</d2p1:string>
  </ComponentNoBetween>
  <ComponentNoContains>String</ComponentNoContains>
  <ComponentNoEndsWith>String</ComponentNoEndsWith>
  <ComponentNoIn xmlns:d2p1="http://schemas.microsoft.com/2003/10/Serialization/Arrays">
    <d2p1:string>String</d2p1:string>
  </ComponentNoIn>
  <ComponentNoLike>String</ComponentNoLike>
  <ComponentNoStartsWith>String</ComponentNoStartsWith>
  <ComponentType>0</ComponentType>
  <ComponentTypeBetween xmlns:d2p1="http://schemas.datacontract.org/2004/07/System">
    <d2p1:int>0</d2p1:int>
  </ComponentTypeBetween>
  <ComponentTypeGreaterThan>0</ComponentTypeGreaterThan>
  <ComponentTypeGreaterThanOrEqualTo>0</ComponentTypeGreaterThanOrEqualTo>
  <ComponentTypeIn xmlns:d2p1="http://schemas.datacontract.org/2004/07/System">
    <d2p1:int>0</d2p1:int>
  </ComponentTypeIn>
  <ComponentTypeLessThan>0</ComponentTypeLessThan>
  <ComponentTypeLessThanOrEqualTo>0</ComponentTypeLessThanOrEqualTo>
  <ComponentTypeNotEqualTo>0</ComponentTypeNotEqualTo>
  <IsEstimate>0</IsEstimate>
  <IsEstimateBetween xmlns:d2p1="http://schemas.microsoft.com/2003/10/Serialization/Arrays">
    <d2p1:int>0</d2p1:int>
  </IsEstimateBetween>
  <IsEstimateGreaterThan>0</IsEstimateGreaterThan>
  <IsEstimateGreaterThanOrEqualTo>0</IsEstimateGreaterThanOrEqualTo>
  <IsEstimateIn xmlns:d2p1="http://schemas.microsoft.com/2003/10/Serialization/Arrays">
    <d2p1:int>0</d2p1:int>
  </IsEstimateIn>
  <IsEstimateLessThan>0</IsEstimateLessThan>
  <IsEstimateLessThanOrEqualTo>0</IsEstimateLessThanOrEqualTo>
  <IsEstimateNotEqualTo>0</IsEstimateNotEqualTo>
  <ItemNo>0</ItemNo>
  <ItemNoBetween xmlns:d2p1="http://schemas.microsoft.com/2003/10/Serialization/Arrays">
    <d2p1:int>0</d2p1:int>
  </ItemNoBetween>
  <ItemNoGreaterThan>0</ItemNoGreaterThan>
  <ItemNoGreaterThanOrEqualTo>0</ItemNoGreaterThanOrEqualTo>
  <ItemNoIn xmlns:d2p1="http://schemas.microsoft.com/2003/10/Serialization/Arrays">
    <d2p1:int>0</d2p1:int>
  </ItemNoIn>
  <ItemNoLessThan>0</ItemNoLessThan>
  <ItemNoLessThanOrEqualTo>0</ItemNoLessThanOrEqualTo>
  <ItemNoNotEqualTo>0</ItemNoNotEqualTo>
  <JB_Estimates_RecID>String</JB_Estimates_RecID>
  <JB_Estimates_RecIDBetween xmlns:d2p1="http://schemas.microsoft.com/2003/10/Serialization/Arrays">
    <d2p1:string>String</d2p1:string>
  </JB_Estimates_RecIDBetween>
  <JB_Estimates_RecIDContains>String</JB_Estimates_RecIDContains>
  <JB_Estimates_RecIDEndsWith>String</JB_Estimates_RecIDEndsWith>
  <JB_Estimates_RecIDIn xmlns:d2p1="http://schemas.microsoft.com/2003/10/Serialization/Arrays">
    <d2p1:string>String</d2p1:string>
  </JB_Estimates_RecIDIn>
  <JB_Estimates_RecIDLike>String</JB_Estimates_RecIDLike>
  <JB_Estimates_RecIDStartsWith>String</JB_Estimates_RecIDStartsWith>
  <JB_JobStages_RecID>String</JB_JobStages_RecID>
  <JB_JobStages_RecIDBetween xmlns:d2p1="http://schemas.microsoft.com/2003/10/Serialization/Arrays">
    <d2p1:string>String</d2p1:string>
  </JB_JobStages_RecIDBetween>
  <JB_JobStages_RecIDContains>String</JB_JobStages_RecIDContains>
  <JB_JobStages_RecIDEndsWith>String</JB_JobStages_RecIDEndsWith>
  <JB_JobStages_RecIDIn xmlns:d2p1="http://schemas.microsoft.com/2003/10/Serialization/Arrays">
    <d2p1:string>String</d2p1:string>
  </JB_JobStages_RecIDIn>
  <JB_JobStages_RecIDLike>String</JB_JobStages_RecIDLike>
  <JB_JobStages_RecIDStartsWith>String</JB_JobStages_RecIDStartsWith>
  <Quantity>0</Quantity>
  <QuantityBetween xmlns:d2p1="http://schemas.microsoft.com/2003/10/Serialization/Arrays">
    <d2p1:decimal>0</d2p1:decimal>
  </QuantityBetween>
  <QuantityGreaterThan>0</QuantityGreaterThan>
  <QuantityGreaterThanOrEqualTo>0</QuantityGreaterThanOrEqualTo>
  <QuantityIn xmlns:d2p1="http://schemas.microsoft.com/2003/10/Serialization/Arrays">
    <d2p1:decimal>0</d2p1:decimal>
  </QuantityIn>
  <QuantityLessThan>0</QuantityLessThan>
  <QuantityLessThanOrEqualTo>0</QuantityLessThanOrEqualTo>
  <QuantityNotEqualTo>0</QuantityNotEqualTo>
  <Remark>String</Remark>
  <RemarkBetween xmlns:d2p1="http://schemas.microsoft.com/2003/10/Serialization/Arrays">
    <d2p1:string>String</d2p1:string>
  </RemarkBetween>
  <RemarkContains>String</RemarkContains>
  <RemarkEndsWith>String</RemarkEndsWith>
  <RemarkIn xmlns:d2p1="http://schemas.microsoft.com/2003/10/Serialization/Arrays">
    <d2p1:string>String</d2p1:string>
  </RemarkIn>
  <RemarkLike>String</RemarkLike>
  <RemarkStartsWith>String</RemarkStartsWith>
  <TransactionDate>0001-01-01T00:00:00</TransactionDate>
  <TransactionDateBetween xmlns:d2p1="http://schemas.microsoft.com/2003/10/Serialization/Arrays">
    <d2p1:dateTime>0001-01-01T00:00:00</d2p1:dateTime>
  </TransactionDateBetween>
  <TransactionDateGreaterThan>0001-01-01T00:00:00</TransactionDateGreaterThan>
  <TransactionDateGreaterThanOrEqualTo>0001-01-01T00:00:00</TransactionDateGreaterThanOrEqualTo>
  <TransactionDateIn xmlns:d2p1="http://schemas.microsoft.com/2003/10/Serialization/Arrays">
    <d2p1:dateTime>0001-01-01T00:00:00</d2p1:dateTime>
  </TransactionDateIn>
  <TransactionDateLessThan>0001-01-01T00:00:00</TransactionDateLessThan>
  <TransactionDateLessThanOrEqualTo>0001-01-01T00:00:00</TransactionDateLessThanOrEqualTo>
  <TransactionDateNotEqualTo>0001-01-01T00:00:00</TransactionDateNotEqualTo>
  <UnitCharge>0</UnitCharge>
  <UnitChargeBetween xmlns:d2p1="http://schemas.microsoft.com/2003/10/Serialization/Arrays">
    <d2p1:decimal>0</d2p1:decimal>
  </UnitChargeBetween>
  <UnitChargeGreaterThan>0</UnitChargeGreaterThan>
  <UnitChargeGreaterThanOrEqualTo>0</UnitChargeGreaterThanOrEqualTo>
  <UnitChargeIn xmlns:d2p1="http://schemas.microsoft.com/2003/10/Serialization/Arrays">
    <d2p1:decimal>0</d2p1:decimal>
  </UnitChargeIn>
  <UnitChargeLessThan>0</UnitChargeLessThan>
  <UnitChargeLessThanOrEqualTo>0</UnitChargeLessThanOrEqualTo>
  <UnitChargeNotEqualTo>0</UnitChargeNotEqualTo>
  <UnitCost>0</UnitCost>
  <UnitCostBetween xmlns:d2p1="http://schemas.microsoft.com/2003/10/Serialization/Arrays">
    <d2p1:decimal>0</d2p1:decimal>
  </UnitCostBetween>
  <UnitCostGreaterThan>0</UnitCostGreaterThan>
  <UnitCostGreaterThanOrEqualTo>0</UnitCostGreaterThanOrEqualTo>
  <UnitCostIn xmlns:d2p1="http://schemas.microsoft.com/2003/10/Serialization/Arrays">
    <d2p1:decimal>0</d2p1:decimal>
  </UnitCostIn>
  <UnitCostLessThan>0</UnitCostLessThan>
  <UnitCostLessThanOrEqualTo>0</UnitCostLessThanOrEqualTo>
  <UnitCostNotEqualTo>0</UnitCostNotEqualTo>
  <Units>String</Units>
  <UnitsBetween xmlns:d2p1="http://schemas.microsoft.com/2003/10/Serialization/Arrays">
    <d2p1:string>String</d2p1:string>
  </UnitsBetween>
  <UnitsContains>String</UnitsContains>
  <UnitsEndsWith>String</UnitsEndsWith>
  <UnitsIn xmlns:d2p1="http://schemas.microsoft.com/2003/10/Serialization/Arrays">
    <d2p1:string>String</d2p1:string>
  </UnitsIn>
  <UnitsLike>String</UnitsLike>
  <UnitsStartsWith>String</UnitsStartsWith>
</v_JIWA_JobCosting_EstimateAndActualLinesQuery>

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

<QueryResponseOfv_JIWA_JobCosting_EstimateAndActualLines7kRqkrSv 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_JIWA_JobCosting_EstimateAndActualLines>
      <d2p1:_x003C_ComponentDescription_x003E_k__BackingField>String</d2p1:_x003C_ComponentDescription_x003E_k__BackingField>
      <d2p1:_x003C_ComponentID_x003E_k__BackingField>String</d2p1:_x003C_ComponentID_x003E_k__BackingField>
      <d2p1:_x003C_ComponentNo_x003E_k__BackingField>String</d2p1:_x003C_ComponentNo_x003E_k__BackingField>
      <d2p1:_x003C_ComponentType_x003E_k__BackingField>0</d2p1:_x003C_ComponentType_x003E_k__BackingField>
      <d2p1:_x003C_IsEstimate_x003E_k__BackingField>0</d2p1:_x003C_IsEstimate_x003E_k__BackingField>
      <d2p1:_x003C_ItemNo_x003E_k__BackingField>0</d2p1:_x003C_ItemNo_x003E_k__BackingField>
      <d2p1:_x003C_JB_Estimates_RecID_x003E_k__BackingField>String</d2p1:_x003C_JB_Estimates_RecID_x003E_k__BackingField>
      <d2p1:_x003C_JB_JobStages_RecID_x003E_k__BackingField>String</d2p1:_x003C_JB_JobStages_RecID_x003E_k__BackingField>
      <d2p1:_x003C_Quantity_x003E_k__BackingField>0</d2p1:_x003C_Quantity_x003E_k__BackingField>
      <d2p1:_x003C_Remark_x003E_k__BackingField>String</d2p1:_x003C_Remark_x003E_k__BackingField>
      <d2p1:_x003C_TransactionDate_x003E_k__BackingField>0001-01-01T00:00:00</d2p1:_x003C_TransactionDate_x003E_k__BackingField>
      <d2p1:_x003C_UnitCharge_x003E_k__BackingField>0</d2p1:_x003C_UnitCharge_x003E_k__BackingField>
      <d2p1:_x003C_UnitCost_x003E_k__BackingField>0</d2p1:_x003C_UnitCost_x003E_k__BackingField>
      <d2p1:_x003C_Units_x003E_k__BackingField>String</d2p1:_x003C_Units_x003E_k__BackingField>
    </d2p1:v_JIWA_JobCosting_EstimateAndActualLines>
  </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_JIWA_JobCosting_EstimateAndActualLines7kRqkrSv>