JiwaAPI

IN_DebtorPricingGroupSpecificPriceQuery

The following routes are available for this service:
GET	/Queries/IN_DebtorPricingGroupSpecificPrice	Retrieves a list of debtor pricing group specific inventory prices.

**IN_DebtorPricingGroupSpecificPriceQuery** 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
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
DB_PricingGroups_RecID	query	string	No
DB_PricingGroups_RecIDStartsWith	query	string	No
DB_PricingGroups_RecIDEndsWith	query	string	No
DB_PricingGroups_RecIDContains	query	string	No
DB_PricingGroups_RecIDLike	query	string	No
DB_PricingGroups_RecIDBetween	query	string[]	No
DB_PricingGroups_RecIDIn	query	string[]	No
Source	query	short?	No
SourceGreaterThanOrEqualTo	query	short?	No
SourceGreaterThan	query	short?	No
SourceLessThan	query	short?	No
SourceLessThanOrEqualTo	query	short?	No
SourceNotEqualTo	query	short?	No
SourceBetween	query	short[]	No
SourceIn	query	short[]	No
OPMode	query	short?	No
OPModeGreaterThanOrEqualTo	query	short?	No
OPModeGreaterThan	query	short?	No
OPModeLessThan	query	short?	No
OPModeLessThanOrEqualTo	query	short?	No
OPModeNotEqualTo	query	short?	No
OPModeBetween	query	short[]	No
OPModeIn	query	short[]	No
Amount	query	decimal?	No
AmountGreaterThanOrEqualTo	query	decimal?	No
AmountGreaterThan	query	decimal?	No
AmountLessThan	query	decimal?	No
AmountLessThanOrEqualTo	query	decimal?	No
AmountNotEqualTo	query	decimal?	No
AmountBetween	query	Nullable<Decimal>[]	No
AmountIn	query	Nullable<Decimal>[]	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	Nullable<DateTime>[]	No
StartDateIn	query	Nullable<DateTime>[]	No
EndDate	query	DateTime?	No
EndDateGreaterThanOrEqualTo	query	DateTime?	No
EndDateGreaterThan	query	DateTime?	No
EndDateLessThan	query	DateTime?	No
EndDateLessThanOrEqualTo	query	DateTime?	No
EndDateNotEqualTo	query	DateTime?	No
EndDateBetween	query	Nullable<DateTime>[]	No
EndDateIn	query	Nullable<DateTime>[]	No
UseQuantityBreak	query	bool?	No
QuantityBreak	query	decimal?	No
QuantityBreakGreaterThanOrEqualTo	query	decimal?	No
QuantityBreakGreaterThan	query	decimal?	No
QuantityBreakLessThan	query	decimal?	No
QuantityBreakLessThanOrEqualTo	query	decimal?	No
QuantityBreakNotEqualTo	query	decimal?	No
QuantityBreakBetween	query	Nullable<Decimal>[]	No
QuantityBreakIn	query	Nullable<Decimal>[]	No
Note	query	string	No
NoteStartsWith	query	string	No
NoteEndsWith	query	string	No
NoteContains	query	string	No
NoteLike	query	string	No
NoteBetween	query	string[]	No
NoteIn	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
RowHash	query	byte[]	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

**IN_DebtorPricingGroupSpecificPrice** Parameters:
Name	Parameter	Data Type	Required
RecID	form	string	No
InventoryID	form	string	No
DB_PricingGroups_RecID	form	string	No
Source	form	short	No
OPMode	form	short	No
Amount	form	decimal?	No
StartDate	form	DateTime?	No
EndDate	form	DateTime?	No
UseQuantityBreak	form	bool	No
QuantityBreak	form	decimal?	No
Note	form	string	No
ItemNo	form	int	No
RowHash	form	byte[]	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.

GET /Queries/IN_DebtorPricingGroupSpecificPrice HTTP/1.1 
Host: testapi.wagga.redpoint.com.au 
Accept: application/xml

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

<QueryResponseOfIN_DebtorPricingGroupSpecificPrice7kRqkrSv 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:IN_DebtorPricingGroupSpecificPrice>
      <d2p1:_x003C_Amount_x003E_k__BackingField>0</d2p1:_x003C_Amount_x003E_k__BackingField>
      <d2p1:_x003C_DB_PricingGroups_RecID_x003E_k__BackingField>String</d2p1:_x003C_DB_PricingGroups_RecID_x003E_k__BackingField>
      <d2p1:_x003C_EndDate_x003E_k__BackingField>0001-01-01T00:00:00</d2p1:_x003C_EndDate_x003E_k__BackingField>
      <d2p1:_x003C_InventoryID_x003E_k__BackingField>String</d2p1:_x003C_InventoryID_x003E_k__BackingField>
      <d2p1:_x003C_ItemNo_x003E_k__BackingField>0</d2p1:_x003C_ItemNo_x003E_k__BackingField>
      <d2p1:_x003C_Note_x003E_k__BackingField>String</d2p1:_x003C_Note_x003E_k__BackingField>
      <d2p1:_x003C_OPMode_x003E_k__BackingField>0</d2p1:_x003C_OPMode_x003E_k__BackingField>
      <d2p1:_x003C_QuantityBreak_x003E_k__BackingField>0</d2p1:_x003C_QuantityBreak_x003E_k__BackingField>
      <d2p1:_x003C_RecID_x003E_k__BackingField>String</d2p1:_x003C_RecID_x003E_k__BackingField>
      <d2p1:_x003C_RowHash_x003E_k__BackingField>AA==</d2p1:_x003C_RowHash_x003E_k__BackingField>
      <d2p1:_x003C_Source_x003E_k__BackingField>0</d2p1:_x003C_Source_x003E_k__BackingField>
      <d2p1:_x003C_StartDate_x003E_k__BackingField>0001-01-01T00:00:00</d2p1:_x003C_StartDate_x003E_k__BackingField>
      <d2p1:_x003C_UseQuantityBreak_x003E_k__BackingField>false</d2p1:_x003C_UseQuantityBreak_x003E_k__BackingField>
    </d2p1:IN_DebtorPricingGroupSpecificPrice>
  </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>
</QueryResponseOfIN_DebtorPricingGroupSpecificPrice7kRqkrSv>