JiwaAPI

JB_EstimateFinishedGoodLinesQuery

**JB_EstimateFinishedGoodLinesQuery** 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
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
IN_Main_RecID	query	string	No
IN_Main_RecIDStartsWith	query	string	No
IN_Main_RecIDEndsWith	query	string	No
IN_Main_RecIDContains	query	string	No
IN_Main_RecIDLike	query	string	No
IN_Main_RecIDBetween	query	string[]	No
IN_Main_RecIDIn	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
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
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
HR_Staff_RecID	query	string	No
HR_Staff_RecIDStartsWith	query	string	No
HR_Staff_RecIDEndsWith	query	string	No
HR_Staff_RecIDContains	query	string	No
HR_Staff_RecIDLike	query	string	No
HR_Staff_RecIDBetween	query	string[]	No
HR_Staff_RecIDIn	query	string[]	No
RowHash	query	byte[]	No
JB_EstimateLines_RecID	query	string	No
JB_EstimateLines_RecIDStartsWith	query	string	No
JB_EstimateLines_RecIDEndsWith	query	string	No
JB_EstimateLines_RecIDContains	query	string	No
JB_EstimateLines_RecIDLike	query	string	No
JB_EstimateLines_RecIDBetween	query	string[]	No
JB_EstimateLines_RecIDIn	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

**JB_EstimateFinishedGoodLines** Parameters:
Name	Parameter	Data Type	Required
RecID	form	string	No
JB_Estimates_RecID	form	string	No
JB_JobStages_RecID	form	string	No
IN_Main_RecID	form	string	No
TransactionDate	form	DateTime	No
Quantity	form	decimal	No
Remark	form	string	No
ItemNo	form	int	No
LastSavedDateTime	form	DateTime	No
HR_Staff_RecID	form	string	No
RowHash	form	byte[]	No
JB_EstimateLines_RecID	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/JB_EstimateFinishedGoodLinesQuery HTTP/1.1 
Host: localhost 
Accept: application/xml
Content-Type: application/xml
Content-Length: length

<JB_EstimateFinishedGoodLinesQuery 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>
  <HR_Staff_RecID>String</HR_Staff_RecID>
  <HR_Staff_RecIDBetween xmlns:d2p1="http://schemas.microsoft.com/2003/10/Serialization/Arrays">
    <d2p1:string>String</d2p1:string>
  </HR_Staff_RecIDBetween>
  <HR_Staff_RecIDContains>String</HR_Staff_RecIDContains>
  <HR_Staff_RecIDEndsWith>String</HR_Staff_RecIDEndsWith>
  <HR_Staff_RecIDIn xmlns:d2p1="http://schemas.microsoft.com/2003/10/Serialization/Arrays">
    <d2p1:string>String</d2p1:string>
  </HR_Staff_RecIDIn>
  <HR_Staff_RecIDLike>String</HR_Staff_RecIDLike>
  <HR_Staff_RecIDStartsWith>String</HR_Staff_RecIDStartsWith>
  <IN_Main_RecID>String</IN_Main_RecID>
  <IN_Main_RecIDBetween xmlns:d2p1="http://schemas.microsoft.com/2003/10/Serialization/Arrays">
    <d2p1:string>String</d2p1:string>
  </IN_Main_RecIDBetween>
  <IN_Main_RecIDContains>String</IN_Main_RecIDContains>
  <IN_Main_RecIDEndsWith>String</IN_Main_RecIDEndsWith>
  <IN_Main_RecIDIn xmlns:d2p1="http://schemas.microsoft.com/2003/10/Serialization/Arrays">
    <d2p1:string>String</d2p1:string>
  </IN_Main_RecIDIn>
  <IN_Main_RecIDLike>String</IN_Main_RecIDLike>
  <IN_Main_RecIDStartsWith>String</IN_Main_RecIDStartsWith>
  <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_EstimateLines_RecID>String</JB_EstimateLines_RecID>
  <JB_EstimateLines_RecIDBetween xmlns:d2p1="http://schemas.microsoft.com/2003/10/Serialization/Arrays">
    <d2p1:string>String</d2p1:string>
  </JB_EstimateLines_RecIDBetween>
  <JB_EstimateLines_RecIDContains>String</JB_EstimateLines_RecIDContains>
  <JB_EstimateLines_RecIDEndsWith>String</JB_EstimateLines_RecIDEndsWith>
  <JB_EstimateLines_RecIDIn xmlns:d2p1="http://schemas.microsoft.com/2003/10/Serialization/Arrays">
    <d2p1:string>String</d2p1:string>
  </JB_EstimateLines_RecIDIn>
  <JB_EstimateLines_RecIDLike>String</JB_EstimateLines_RecIDLike>
  <JB_EstimateLines_RecIDStartsWith>String</JB_EstimateLines_RecIDStartsWith>
  <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>
  <LastSavedDateTime>0001-01-01T00:00:00</LastSavedDateTime>
  <LastSavedDateTimeBetween xmlns:d2p1="http://schemas.microsoft.com/2003/10/Serialization/Arrays">
    <d2p1:dateTime>0001-01-01T00:00:00</d2p1:dateTime>
  </LastSavedDateTimeBetween>
  <LastSavedDateTimeGreaterThan>0001-01-01T00:00:00</LastSavedDateTimeGreaterThan>
  <LastSavedDateTimeGreaterThanOrEqualTo>0001-01-01T00:00:00</LastSavedDateTimeGreaterThanOrEqualTo>
  <LastSavedDateTimeIn xmlns:d2p1="http://schemas.microsoft.com/2003/10/Serialization/Arrays">
    <d2p1:dateTime>0001-01-01T00:00:00</d2p1:dateTime>
  </LastSavedDateTimeIn>
  <LastSavedDateTimeLessThan>0001-01-01T00:00:00</LastSavedDateTimeLessThan>
  <LastSavedDateTimeLessThanOrEqualTo>0001-01-01T00:00:00</LastSavedDateTimeLessThanOrEqualTo>
  <LastSavedDateTimeNotEqualTo>0001-01-01T00:00:00</LastSavedDateTimeNotEqualTo>
  <Quantity>0</Quantity>
  <QuantityBetween xmlns:d2p1="http://schemas.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>
  <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>
  <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>
  <RowHash>AA==</RowHash>
  <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>
</JB_EstimateFinishedGoodLinesQuery>

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

<QueryResponseOfJB_EstimateFinishedGoodLines7kRqkrSv 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:JB_EstimateFinishedGoodLines>
      <d2p1:_x003C_HR_Staff_RecID_x003E_k__BackingField>String</d2p1:_x003C_HR_Staff_RecID_x003E_k__BackingField>
      <d2p1:_x003C_IN_Main_RecID_x003E_k__BackingField>String</d2p1:_x003C_IN_Main_RecID_x003E_k__BackingField>
      <d2p1:_x003C_ItemNo_x003E_k__BackingField>0</d2p1:_x003C_ItemNo_x003E_k__BackingField>
      <d2p1:_x003C_JB_EstimateLines_RecID_x003E_k__BackingField>String</d2p1:_x003C_JB_EstimateLines_RecID_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_LastSavedDateTime_x003E_k__BackingField>0001-01-01T00:00:00</d2p1:_x003C_LastSavedDateTime_x003E_k__BackingField>
      <d2p1:_x003C_Quantity_x003E_k__BackingField>0</d2p1:_x003C_Quantity_x003E_k__BackingField>
      <d2p1:_x003C_RecID_x003E_k__BackingField>String</d2p1:_x003C_RecID_x003E_k__BackingField>
      <d2p1:_x003C_Remark_x003E_k__BackingField>String</d2p1:_x003C_Remark_x003E_k__BackingField>
      <d2p1:_x003C_RowHash_x003E_k__BackingField>AA==</d2p1:_x003C_RowHash_x003E_k__BackingField>
      <d2p1:_x003C_TransactionDate_x003E_k__BackingField>0001-01-01T00:00:00</d2p1:_x003C_TransactionDate_x003E_k__BackingField>
    </d2p1:JB_EstimateFinishedGoodLines>
  </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>
</QueryResponseOfJB_EstimateFinishedGoodLines7kRqkrSv>