Product Information
Delta Read of Price List and Discount List with Pagination in SAP Business ByDesign Cloud ERP
Partners and Customers who have maintained high volume price list or discounts list master data in SAP Business ByDesign and in case if you would like to Delta read the prices or discounts master data, which are changed after a certain date, we now provide a capability to read Price and Discount master data changes in pages / blocks.
the Video and Blog covers the following aspects:
- Testing the Price List and Discount List Delta Read web-service with pagination options along with live demo.
- Enable the consumption of price list and discount list service with pagination
- Creation of Communication System
- Creation of Communication Scenario
- Creation of Communication Arrangement
- for details of communication setup , please refer to earlier blog : Price List and Discount List Read with Pagination in SAP Business ByDesign Cloud ERP and video guide .
New Capabilities
- Price List read web service enabled for Delta read with pagination (prices changed after certain date / date time )
- Discount List read web service enabled for Delta read with pagination (discounts changed after certain date / date time )
Benefits for Customers
- Changed prices after a certain date, can be extracted out of system
- Changed discounts after a given date, can be extracted out of system
- Pricing and Discount Analytics enabler, analytics could be done outside the system after extraction out of SAP Business ByDesign
Note: This capability has been requested by the improvement request from partners and customers.
Details of the SOAP webservice API:
- Service Name : Manage Price Lists
- Operation Name : Read price list with filter
-
- Note: in the request payload user have to pass the following information for Delta read to work. user have to pass one of the following information :
- LastChangedDateTimeInterval
- LowerBoundaryDateTime
- UpperBoundaryDateTime
- can pass both LowerBoundaryDateTime and UpperBoundaryDateTime to get records changes between the given time frame
- LastChangedDate
- LowerBoundaryDate
- UpperBoundaryDate
- can pass both LowerBoundaryDate and UpperBoundaryDate to get records changes between the given time frame
- Note : for more detailed documentation please refer to webservice documentation.
- LastChangedDateTimeInterval
Sample Initial Request Payload ( with page size 10 records )
<soap:Envelope xmlns:soap="http://www.w3.org/2003/05/soap-envelope" xmlns:glob="http://sap.com/xi/SAPGlobal20/Global">
<soap:Header/>
<soap:Body>
<glob:SalesPriceListFindByIDQuery_flt_sync>
<!--Zero or more repetitions:-->
<SalesPriceList>
<ID>AKRON BASE PRICES</ID>
<SalesPriceSpecificationFilterAttributes>
<LastChangedDateTimeInterval>
<LowerBoundaryDateTime>2022-07-01T00:00:00.1234567Z</LowerBoundaryDateTime>
<UpperBoundaryDateTime>2022-08-01T23:00:00.1234567Z</UpperBoundaryDateTime>
</LastChangedDateTimeInterval>
<LastChangedDate>
<LowerBoundaryDate>2022-07-01</LowerBoundaryDate>
<UpperBoundaryDate>2022-08-01</UpperBoundaryDate>
</LastChangedDate>
</SalesPriceSpecificationFilterAttributes>
<SalesPriceSpecificationProcessingConditions>
<QueryHitsMaximumNumberValue>10</QueryHitsMaximumNumberValue>
<QueryHitsUnlimitedIndicator>false</QueryHitsUnlimitedIndicator>
<LastReturnedObjectID></LastReturnedObjectID>
</SalesPriceSpecificationProcessingConditions>
</SalesPriceList>
</glob:SalesPriceListFindByIDQuery_flt_sync>
</soap:Body>
</soap:Envelope>
Sample Response Payload:
<env:Envelope xmlns:env="http://www.w3.org/2003/05/soap-envelope">
<env:Header/>
<env:Body>
<n0:SalesPriceListFindByIDResponse_flt_sync xmlns:n0="http://sap.com/xi/SAPGlobal20/Global" xmlns:prx="urn:sap.com:proxy:QCH:/1SAI/TAE600CD7F16772F94EA88B:804">
<SalesPriceListFindByIDResponseMessage>
<ID>AKRON BASE PRICES</ID>
<ReleaseStatusCode>3</ReleaseStatusCode>
<ReleaseStatusName languageCode="EN">Released</ReleaseStatusName>
<ApprovalStatusCode>4</ApprovalStatusCode>
<ApprovalStatusName>Approved</ApprovalStatusName>
<TypeCode listID="2">7PL0</TypeCode>
<TypeName languageCode="EN">Price List</TypeName>
<CurrencyCode>USD</CurrencyCode>
<CurrencyName languageCode="EN">US Dollar</CurrencyName>
<ValidityPeriod>
<IntervalBoundaryTypeCode></IntervalBoundaryTypeCode>
<StartTimePoint>
<TypeCode>1</TypeCode>
<Date>2007-01-01</Date>
</StartTimePoint>
<EndTimePoint>
<TypeCode>1</TypeCode>
<Date>9999-12-31</Date>
</EndTimePoint>
</ValidityPeriod>
<Description languageCode="EN">Price List Akron Products</Description>
<PriceSpecification>
<PriceSpecificationElementTypeCode listID="2">7PR1</PriceSpecificationElementTypeCode>
<PriceSpecificationElementTypeName languageCode="EN">List Price</PriceSpecificationElementTypeName>
<PriceSpecificationElementCategoryCode>1</PriceSpecificationElementCategoryCode>
<PriceSpecificationElementCategoryName languageCode="EN">Price</PriceSpecificationElementCategoryName>
<PriceSpecificationElementPurposeCode>1000</PriceSpecificationElementPurposeCode>
<PriceSpecificationElementPurposeName languageCode="EN">General</PriceSpecificationElementPurposeName>
<ConsistencyStatusCode>3</ConsistencyStatusCode>
<ConsistencyStatusName languageCode="EN">Consistent</ConsistencyStatusName>
<ReleaseStatusCode>3</ReleaseStatusCode>
<ReleaseStatusName languageCode="EN">Released</ReleaseStatusName>
<BaseQuantity unitCode="EA">1.0</BaseQuantity>
<BaseQuantityTypeCode>EA</BaseQuantityTypeCode>
<BaseQuantityTypeCodeName languageCode="EN">ea</BaseQuantityTypeCodeName>
<Amount currencyCode="USD">1200.5</Amount>
<PropertyValuation>
<PriceSpecificationElementPropertyValuation>
<IdentifyingIndicator>true</IdentifyingIndicator>
<PriceSpecificationElementPropertyReference>
<PriceSpecificationElementPropertyID>CND_PRODUCT_ID</PriceSpecificationElementPropertyID>
<PriceSpecificationElementPropertyDefinitionClassCode>2</PriceSpecificationElementPropertyDefinitionClassCode>
</PriceSpecificationElementPropertyReference>
<PriceSpecificationElementPropertyValue>
<ID>MCF-0036-SN4</ID>
</PriceSpecificationElementPropertyValue>
</PriceSpecificationElementPropertyValuation>
<Description languageCode="EN">AHT Radiator wall 5 tubes 20" - cream</Description>
</PropertyValuation>
<PropertyValuation>
<PriceSpecificationElementPropertyValuation>
<IdentifyingIndicator>true</IdentifyingIndicator>
<PriceSpecificationElementPropertyReference>
<PriceSpecificationElementPropertyID>CND_PRODUCT_ID_TYPE_CODE</PriceSpecificationElementPropertyID>
<PriceSpecificationElementPropertyDefinitionClassCode>2</PriceSpecificationElementPropertyDefinitionClassCode>
</PriceSpecificationElementPropertyReference>
<PriceSpecificationElementPropertyValue>
<Code listID="CND_PRODUCT_ID_TYPE_CODE">1</Code>
</PriceSpecificationElementPropertyValue>
</PriceSpecificationElementPropertyValuation>
<Description languageCode="EN">AHT Radiator wall 5 tubes 20" - cream</Description>
</PropertyValuation>
<PropertyValuation>
<PriceSpecificationElementPropertyValuation>
<IdentifyingIndicator>true</IdentifyingIndicator>
<PriceSpecificationElementPropertyReference>
<PriceSpecificationElementPropertyID>CND_PRODUCT_TYPE_CODE</PriceSpecificationElementPropertyID>
<PriceSpecificationElementPropertyDefinitionClassCode>2</PriceSpecificationElementPropertyDefinitionClassCode>
</PriceSpecificationElementPropertyReference>
<PriceSpecificationElementPropertyValue>
<Code listID="CND_PRODUCT_TYPE_CODE">1</Code>
</PriceSpecificationElementPropertyValue>
</PriceSpecificationElementPropertyValuation>
<Description languageCode="EN">AHT Radiator wall 5 tubes 20" - cream</Description>
</PropertyValuation>
</PriceSpecification>
<PriceSpecification>
<PriceSpecificationElementTypeCode listID="2">7PR1</PriceSpecificationElementTypeCode>
<PriceSpecificationElementTypeName languageCode="EN">List Price</PriceSpecificationElementTypeName>
<PriceSpecificationElementCategoryCode>1</PriceSpecificationElementCategoryCode>
<PriceSpecificationElementCategoryName languageCode="EN">Price</PriceSpecificationElementCategoryName>
<PriceSpecificationElementPurposeCode>1000</PriceSpecificationElementPurposeCode>
<PriceSpecificationElementPurposeName languageCode="EN">General</PriceSpecificationElementPurposeName>
<ConsistencyStatusCode>3</ConsistencyStatusCode>
<ConsistencyStatusName languageCode="EN">Consistent</ConsistencyStatusName>
<ReleaseStatusCode>3</ReleaseStatusCode>
<ReleaseStatusName languageCode="EN">Released</ReleaseStatusName>
<BaseQuantity unitCode="HUR">1.0</BaseQuantity>
<BaseQuantityTypeCode>TIME</BaseQuantityTypeCode>
<BaseQuantityTypeCodeName languageCode="EN">h</BaseQuantityTypeCodeName>
<Amount currencyCode="USD">500.99</Amount>
<PropertyValuation>
<PriceSpecificationElementPropertyValuation>
<IdentifyingIndicator>true</IdentifyingIndicator>
<PriceSpecificationElementPropertyReference>
<PriceSpecificationElementPropertyID>CND_PRODUCT_ID</PriceSpecificationElementPropertyID>
<PriceSpecificationElementPropertyDefinitionClassCode>2</PriceSpecificationElementPropertyDefinitionClassCode>
</PriceSpecificationElementPropertyReference>
<PriceSpecificationElementPropertyValue>
<ID>MCD-0001</ID>
</PriceSpecificationElementPropertyValue>
</PriceSpecificationElementPropertyValuation>
<Description languageCode="EN">Marketing Strategy Consulting</Description>
</PropertyValuation>
<PropertyValuation>
<PriceSpecificationElementPropertyValuation>
<IdentifyingIndicator>true</IdentifyingIndicator>
<PriceSpecificationElementPropertyReference>
<PriceSpecificationElementPropertyID>CND_PRODUCT_ID_TYPE_CODE</PriceSpecificationElementPropertyID>
<PriceSpecificationElementPropertyDefinitionClassCode>2</PriceSpecificationElementPropertyDefinitionClassCode>
</PriceSpecificationElementPropertyReference>
<PriceSpecificationElementPropertyValue>
<Code listID="CND_PRODUCT_ID_TYPE_CODE">1</Code>
</PriceSpecificationElementPropertyValue>
</PriceSpecificationElementPropertyValuation>
<Description languageCode="EN">Marketing Strategy Consulting</Description>
</PropertyValuation>
<PropertyValuation>
<PriceSpecificationElementPropertyValuation>
<IdentifyingIndicator>true</IdentifyingIndicator>
<PriceSpecificationElementPropertyReference>
<PriceSpecificationElementPropertyID>CND_PRODUCT_TYPE_CODE</PriceSpecificationElementPropertyID>
<PriceSpecificationElementPropertyDefinitionClassCode>2</PriceSpecificationElementPropertyDefinitionClassCode>
</PriceSpecificationElementPropertyReference>
<PriceSpecificationElementPropertyValue>
<Code listID="CND_PRODUCT_TYPE_CODE">2</Code>
</PriceSpecificationElementPropertyValue>
</PriceSpecificationElementPropertyValuation>
<Description languageCode="EN">Marketing Strategy Consulting</Description>
</PropertyValuation>
</PriceSpecification>
<PriceSpecification>
<PriceSpecificationElementTypeCode listID="2">7PR1</PriceSpecificationElementTypeCode>
<PriceSpecificationElementTypeName languageCode="EN">List Price</PriceSpecificationElementTypeName>
<PriceSpecificationElementCategoryCode>1</PriceSpecificationElementCategoryCode>
<PriceSpecificationElementCategoryName languageCode="EN">Price</PriceSpecificationElementCategoryName>
<PriceSpecificationElementPurposeCode>1000</PriceSpecificationElementPurposeCode>
<PriceSpecificationElementPurposeName languageCode="EN">General</PriceSpecificationElementPurposeName>
<ConsistencyStatusCode>3</ConsistencyStatusCode>
<ConsistencyStatusName languageCode="EN">Consistent</ConsistencyStatusName>
<ReleaseStatusCode>3</ReleaseStatusCode>
<ReleaseStatusName languageCode="EN">Released</ReleaseStatusName>
<BaseQuantity unitCode="E49">1.0</BaseQuantity>
<BaseQuantityTypeCode>E49</BaseQuantityTypeCode>
<BaseQuantityTypeCodeName languageCode="EN">wday</BaseQuantityTypeCodeName>
<Amount currencyCode="USD">4500.0</Amount>
<PropertyValuation>
<PriceSpecificationElementPropertyValuation>
<IdentifyingIndicator>true</IdentifyingIndicator>
<PriceSpecificationElementPropertyReference>
<PriceSpecificationElementPropertyID>CND_PRODUCT_ID</PriceSpecificationElementPropertyID>
<PriceSpecificationElementPropertyDefinitionClassCode>2</PriceSpecificationElementPropertyDefinitionClassCode>
</PriceSpecificationElementPropertyReference>
<PriceSpecificationElementPropertyValue>
<ID>MCD-0442</ID>
</PriceSpecificationElementPropertyValue>
</PriceSpecificationElementPropertyValuation>
<Description languageCode="EN">Training - Installation of Gas Boilers</Description>
</PropertyValuation>
<PropertyValuation>
<PriceSpecificationElementPropertyValuation>
<IdentifyingIndicator>true</IdentifyingIndicator>
<PriceSpecificationElementPropertyReference>
<PriceSpecificationElementPropertyID>CND_PRODUCT_ID_TYPE_CODE</PriceSpecificationElementPropertyID>
<PriceSpecificationElementPropertyDefinitionClassCode>2</PriceSpecificationElementPropertyDefinitionClassCode>
</PriceSpecificationElementPropertyReference>
<PriceSpecificationElementPropertyValue>
<Code listID="CND_PRODUCT_ID_TYPE_CODE">1</Code>
</PriceSpecificationElementPropertyValue>
</PriceSpecificationElementPropertyValuation>
<Description languageCode="EN">Training - Installation of Gas Boilers</Description>
</PropertyValuation>
<PropertyValuation>
<PriceSpecificationElementPropertyValuation>
<IdentifyingIndicator>true</IdentifyingIndicator>
<PriceSpecificationElementPropertyReference>
<PriceSpecificationElementPropertyID>CND_PRODUCT_TYPE_CODE</PriceSpecificationElementPropertyID>
<PriceSpecificationElementPropertyDefinitionClassCode>2</PriceSpecificationElementPropertyDefinitionClassCode>
</PriceSpecificationElementPropertyReference>
<PriceSpecificationElementPropertyValue>
<Code listID="CND_PRODUCT_TYPE_CODE">2</Code>
</PriceSpecificationElementPropertyValue>
</PriceSpecificationElementPropertyValuation>
<Description languageCode="EN">Training - Installation of Gas Boilers</Description>
</PropertyValuation>
</PriceSpecification>
<PriceSpecification>
<PriceSpecificationElementTypeCode listID="2">7PR1</PriceSpecificationElementTypeCode>
<PriceSpecificationElementTypeName languageCode="EN">List Price</PriceSpecificationElementTypeName>
<PriceSpecificationElementCategoryCode>1</PriceSpecificationElementCategoryCode>
<PriceSpecificationElementCategoryName languageCode="EN">Price</PriceSpecificationElementCategoryName>
<PriceSpecificationElementPurposeCode>1000</PriceSpecificationElementPurposeCode>
<PriceSpecificationElementPurposeName languageCode="EN">General</PriceSpecificationElementPurposeName>
<ConsistencyStatusCode>3</ConsistencyStatusCode>
<ConsistencyStatusName languageCode="EN">Consistent</ConsistencyStatusName>
<ReleaseStatusCode>3</ReleaseStatusCode>
<ReleaseStatusName languageCode="EN">Released</ReleaseStatusName>
<BaseQuantity unitCode="HUR">1.0</BaseQuantity>
<BaseQuantityTypeCode>TIME</BaseQuantityTypeCode>
<BaseQuantityTypeCodeName languageCode="EN">h</BaseQuantityTypeCodeName>
<Amount currencyCode="USD">480.0</Amount>
<PropertyValuation>
<PriceSpecificationElementPropertyValuation>
<IdentifyingIndicator>true</IdentifyingIndicator>
<PriceSpecificationElementPropertyReference>
<PriceSpecificationElementPropertyID>CND_PRODUCT_ID</PriceSpecificationElementPropertyID>
<PriceSpecificationElementPropertyDefinitionClassCode>2</PriceSpecificationElementPropertyDefinitionClassCode>
</PriceSpecificationElementPropertyReference>
<PriceSpecificationElementPropertyValue>
<ID>MCD-0451</ID>
</PriceSpecificationElementPropertyValue>
</PriceSpecificationElementPropertyValuation>
<Description languageCode="EN">On-Site Installation Audit Boilers</Description>
</PropertyValuation>
<PropertyValuation>
<PriceSpecificationElementPropertyValuation>
<IdentifyingIndicator>true</IdentifyingIndicator>
<PriceSpecificationElementPropertyReference>
<PriceSpecificationElementPropertyID>CND_PRODUCT_ID_TYPE_CODE</PriceSpecificationElementPropertyID>
<PriceSpecificationElementPropertyDefinitionClassCode>2</PriceSpecificationElementPropertyDefinitionClassCode>
</PriceSpecificationElementPropertyReference>
<PriceSpecificationElementPropertyValue>
<Code listID="CND_PRODUCT_ID_TYPE_CODE">1</Code>
</PriceSpecificationElementPropertyValue>
</PriceSpecificationElementPropertyValuation>
<Description languageCode="EN">On-Site Installation Audit Boilers</Description>
</PropertyValuation>
<PropertyValuation>
<PriceSpecificationElementPropertyValuation>
<IdentifyingIndicator>true</IdentifyingIndicator>
<PriceSpecificationElementPropertyReference>
<PriceSpecificationElementPropertyID>CND_PRODUCT_TYPE_CODE</PriceSpecificationElementPropertyID>
<PriceSpecificationElementPropertyDefinitionClassCode>2</PriceSpecificationElementPropertyDefinitionClassCode>
</PriceSpecificationElementPropertyReference>
<PriceSpecificationElementPropertyValue>
<Code listID="CND_PRODUCT_TYPE_CODE">2</Code>
</PriceSpecificationElementPropertyValue>
</PriceSpecificationElementPropertyValuation>
<Description languageCode="EN">On-Site Installation Audit Boilers</Description>
</PropertyValuation>
</PriceSpecification>
<PriceSpecification>
<PriceSpecificationElementTypeCode listID="2">7PR1</PriceSpecificationElementTypeCode>
<PriceSpecificationElementTypeName languageCode="EN">List Price</PriceSpecificationElementTypeName>
<PriceSpecificationElementCategoryCode>1</PriceSpecificationElementCategoryCode>
<PriceSpecificationElementCategoryName languageCode="EN">Price</PriceSpecificationElementCategoryName>
<PriceSpecificationElementPurposeCode>1000</PriceSpecificationElementPurposeCode>
<PriceSpecificationElementPurposeName languageCode="EN">General</PriceSpecificationElementPurposeName>
<ConsistencyStatusCode>3</ConsistencyStatusCode>
<ConsistencyStatusName languageCode="EN">Consistent</ConsistencyStatusName>
<ReleaseStatusCode>3</ReleaseStatusCode>
<ReleaseStatusName languageCode="EN">Released</ReleaseStatusName>
<BaseQuantity unitCode="EA">1.0</BaseQuantity>
<BaseQuantityTypeCode>EA</BaseQuantityTypeCode>
<BaseQuantityTypeCodeName languageCode="EN">ea</BaseQuantityTypeCodeName>
<Amount currencyCode="USD">590.95</Amount>
<PropertyValuation>
<PriceSpecificationElementPropertyValuation>
<IdentifyingIndicator>true</IdentifyingIndicator>
<PriceSpecificationElementPropertyReference>
<PriceSpecificationElementPropertyID>CND_PRODUCT_ID</PriceSpecificationElementPropertyID>
<PriceSpecificationElementPropertyDefinitionClassCode>2</PriceSpecificationElementPropertyDefinitionClassCode>
</PriceSpecificationElementPropertyReference>
<PriceSpecificationElementPropertyValue>
<ID>MCC-0001-SL01</ID>
</PriceSpecificationElementPropertyValue>
</PriceSpecificationElementPropertyValuation>
<Description languageCode="EN">CONTROL & REGULATION UNIT 75</Description>
</PropertyValuation>
<PropertyValuation>
<PriceSpecificationElementPropertyValuation>
<IdentifyingIndicator>true</IdentifyingIndicator>
<PriceSpecificationElementPropertyReference>
<PriceSpecificationElementPropertyID>CND_PRODUCT_ID_TYPE_CODE</PriceSpecificationElementPropertyID>
<PriceSpecificationElementPropertyDefinitionClassCode>2</PriceSpecificationElementPropertyDefinitionClassCode>
</PriceSpecificationElementPropertyReference>
<PriceSpecificationElementPropertyValue>
<Code listID="CND_PRODUCT_ID_TYPE_CODE">1</Code>
</PriceSpecificationElementPropertyValue>
</PriceSpecificationElementPropertyValuation>
<Description languageCode="EN">CONTROL & REGULATION UNIT 75</Description>
</PropertyValuation>
<PropertyValuation>
<PriceSpecificationElementPropertyValuation>
<IdentifyingIndicator>true</IdentifyingIndicator>
<PriceSpecificationElementPropertyReference>
<PriceSpecificationElementPropertyID>CND_PRODUCT_TYPE_CODE</PriceSpecificationElementPropertyID>
<PriceSpecificationElementPropertyDefinitionClassCode>2</PriceSpecificationElementPropertyDefinitionClassCode>
</PriceSpecificationElementPropertyReference>
<PriceSpecificationElementPropertyValue>
<Code listID="CND_PRODUCT_TYPE_CODE">1</Code>
</PriceSpecificationElementPropertyValue>
</PriceSpecificationElementPropertyValuation>
<Description languageCode="EN">CONTROL & REGULATION UNIT 75</Description>
</PropertyValuation>
</PriceSpecification>
<PriceSpecification>
<PriceSpecificationElementTypeCode listID="2">7PR1</PriceSpecificationElementTypeCode>
<PriceSpecificationElementTypeName languageCode="EN">List Price</PriceSpecificationElementTypeName>
<PriceSpecificationElementCategoryCode>1</PriceSpecificationElementCategoryCode>
<PriceSpecificationElementCategoryName languageCode="EN">Price</PriceSpecificationElementCategoryName>
<PriceSpecificationElementPurposeCode>1000</PriceSpecificationElementPurposeCode>
<PriceSpecificationElementPurposeName languageCode="EN">General</PriceSpecificationElementPurposeName>
<ConsistencyStatusCode>3</ConsistencyStatusCode>
<ConsistencyStatusName languageCode="EN">Consistent</ConsistencyStatusName>
<ReleaseStatusCode>3</ReleaseStatusCode>
<ReleaseStatusName languageCode="EN">Released</ReleaseStatusName>
<BaseQuantity unitCode="HUR">1.0</BaseQuantity>
<BaseQuantityTypeCode>TIME</BaseQuantityTypeCode>
<BaseQuantityTypeCodeName languageCode="EN">h</BaseQuantityTypeCodeName>
<Amount currencyCode="USD">330.0</Amount>
<PropertyValuation>
<PriceSpecificationElementPropertyValuation>
<IdentifyingIndicator>true</IdentifyingIndicator>
<PriceSpecificationElementPropertyReference>
<PriceSpecificationElementPropertyID>CND_PRODUCT_ID</PriceSpecificationElementPropertyID>
<PriceSpecificationElementPropertyDefinitionClassCode>2</PriceSpecificationElementPropertyDefinitionClassCode>
</PriceSpecificationElementPropertyReference>
<PriceSpecificationElementPropertyValue>
<ID>MCD-0492</ID>
</PriceSpecificationElementPropertyValue>
</PriceSpecificationElementPropertyValuation>
<Description languageCode="EN">On-Site Maintenance - Gas Boilers</Description>
</PropertyValuation>
<PropertyValuation>
<PriceSpecificationElementPropertyValuation>
<IdentifyingIndicator>true</IdentifyingIndicator>
<PriceSpecificationElementPropertyReference>
<PriceSpecificationElementPropertyID>CND_PRODUCT_ID_TYPE_CODE</PriceSpecificationElementPropertyID>
<PriceSpecificationElementPropertyDefinitionClassCode>2</PriceSpecificationElementPropertyDefinitionClassCode>
</PriceSpecificationElementPropertyReference>
<PriceSpecificationElementPropertyValue>
<Code listID="CND_PRODUCT_ID_TYPE_CODE">1</Code>
</PriceSpecificationElementPropertyValue>
</PriceSpecificationElementPropertyValuation>
<Description languageCode="EN">On-Site Maintenance - Gas Boilers</Description>
</PropertyValuation>
<PropertyValuation>
<PriceSpecificationElementPropertyValuation>
<IdentifyingIndicator>true</IdentifyingIndicator>
<PriceSpecificationElementPropertyReference>
<PriceSpecificationElementPropertyID>CND_PRODUCT_TYPE_CODE</PriceSpecificationElementPropertyID>
<PriceSpecificationElementPropertyDefinitionClassCode>2</PriceSpecificationElementPropertyDefinitionClassCode>
</PriceSpecificationElementPropertyReference>
<PriceSpecificationElementPropertyValue>
<Code listID="CND_PRODUCT_TYPE_CODE">2</Code>
</PriceSpecificationElementPropertyValue>
</PriceSpecificationElementPropertyValuation>
<Description languageCode="EN">On-Site Maintenance - Gas Boilers</Description>
</PropertyValuation>
</PriceSpecification>
<PriceSpecification>
<PriceSpecificationElementTypeCode listID="2">7PR1</PriceSpecificationElementTypeCode>
<PriceSpecificationElementTypeName languageCode="EN">List Price</PriceSpecificationElementTypeName>
<PriceSpecificationElementCategoryCode>1</PriceSpecificationElementCategoryCode>
<PriceSpecificationElementCategoryName languageCode="EN">Price</PriceSpecificationElementCategoryName>
<PriceSpecificationElementPurposeCode>1000</PriceSpecificationElementPurposeCode>
<PriceSpecificationElementPurposeName languageCode="EN">General</PriceSpecificationElementPurposeName>
<ConsistencyStatusCode>3</ConsistencyStatusCode>
<ConsistencyStatusName languageCode="EN">Consistent</ConsistencyStatusName>
<ReleaseStatusCode>3</ReleaseStatusCode>
<ReleaseStatusName languageCode="EN">Released</ReleaseStatusName>
<BaseQuantity unitCode="EA">1.0</BaseQuantity>
<BaseQuantityTypeCode>EA</BaseQuantityTypeCode>
<BaseQuantityTypeCodeName languageCode="EN">ea</BaseQuantityTypeCodeName>
<Amount currencyCode="USD">80.01</Amount>
<PropertyValuation>
<PriceSpecificationElementPropertyValuation>
<IdentifyingIndicator>true</IdentifyingIndicator>
<PriceSpecificationElementPropertyReference>
<PriceSpecificationElementPropertyID>CND_PRODUCT_ID</PriceSpecificationElementPropertyID>
<PriceSpecificationElementPropertyDefinitionClassCode>2</PriceSpecificationElementPropertyDefinitionClassCode>
</PriceSpecificationElementPropertyReference>
<PriceSpecificationElementPropertyValue>
<ID>MCD-0465</ID>
</PriceSpecificationElementPropertyValue>
</PriceSpecificationElementPropertyValuation>
<Description languageCode="EN">Hotel Expense</Description>
</PropertyValuation>
<PropertyValuation>
<PriceSpecificationElementPropertyValuation>
<IdentifyingIndicator>true</IdentifyingIndicator>
<PriceSpecificationElementPropertyReference>
<PriceSpecificationElementPropertyID>CND_PRODUCT_ID_TYPE_CODE</PriceSpecificationElementPropertyID>
<PriceSpecificationElementPropertyDefinitionClassCode>2</PriceSpecificationElementPropertyDefinitionClassCode>
</PriceSpecificationElementPropertyReference>
<PriceSpecificationElementPropertyValue>
<Code listID="CND_PRODUCT_ID_TYPE_CODE">1</Code>
</PriceSpecificationElementPropertyValue>
</PriceSpecificationElementPropertyValuation>
<Description languageCode="EN">Hotel Expense</Description>
</PropertyValuation>
<PropertyValuation>
<PriceSpecificationElementPropertyValuation>
<IdentifyingIndicator>true</IdentifyingIndicator>
<PriceSpecificationElementPropertyReference>
<PriceSpecificationElementPropertyID>CND_PRODUCT_TYPE_CODE</PriceSpecificationElementPropertyID>
<PriceSpecificationElementPropertyDefinitionClassCode>2</PriceSpecificationElementPropertyDefinitionClassCode>
</PriceSpecificationElementPropertyReference>
<PriceSpecificationElementPropertyValue>
<Code listID="CND_PRODUCT_TYPE_CODE">2</Code>
</PriceSpecificationElementPropertyValue>
</PriceSpecificationElementPropertyValuation>
<Description languageCode="EN">Hotel Expense</Description>
</PropertyValuation>
</PriceSpecification>
<PriceSpecification>
<PriceSpecificationElementTypeCode listID="2">7PR1</PriceSpecificationElementTypeCode>
<PriceSpecificationElementTypeName languageCode="EN">List Price</PriceSpecificationElementTypeName>
<PriceSpecificationElementCategoryCode>1</PriceSpecificationElementCategoryCode>
<PriceSpecificationElementCategoryName languageCode="EN">Price</PriceSpecificationElementCategoryName>
<PriceSpecificationElementPurposeCode>1000</PriceSpecificationElementPurposeCode>
<PriceSpecificationElementPurposeName languageCode="EN">General</PriceSpecificationElementPurposeName>
<ConsistencyStatusCode>3</ConsistencyStatusCode>
<ConsistencyStatusName languageCode="EN">Consistent</ConsistencyStatusName>
<ReleaseStatusCode>3</ReleaseStatusCode>
<ReleaseStatusName languageCode="EN">Released</ReleaseStatusName>
<BaseQuantity unitCode="EA">1.0</BaseQuantity>
<BaseQuantityTypeCode>EA</BaseQuantityTypeCode>
<BaseQuantityTypeCodeName languageCode="EN">ea</BaseQuantityTypeCodeName>
<Amount currencyCode="USD">80.01</Amount>
<PropertyValuation>
<PriceSpecificationElementPropertyValuation>
<IdentifyingIndicator>true</IdentifyingIndicator>
<PriceSpecificationElementPropertyReference>
<PriceSpecificationElementPropertyID>CND_PRODUCT_ID</PriceSpecificationElementPropertyID>
<PriceSpecificationElementPropertyDefinitionClassCode>2</PriceSpecificationElementPropertyDefinitionClassCode>
</PriceSpecificationElementPropertyReference>
<PriceSpecificationElementPropertyValue>
<ID>MCD-0466</ID>
</PriceSpecificationElementPropertyValue>
</PriceSpecificationElementPropertyValuation>
<Description languageCode="EN">Hotel Expense (contractually limited)</Description>
</PropertyValuation>
<PropertyValuation>
<PriceSpecificationElementPropertyValuation>
<IdentifyingIndicator>true</IdentifyingIndicator>
<PriceSpecificationElementPropertyReference>
<PriceSpecificationElementPropertyID>CND_PRODUCT_ID_TYPE_CODE</PriceSpecificationElementPropertyID>
<PriceSpecificationElementPropertyDefinitionClassCode>2</PriceSpecificationElementPropertyDefinitionClassCode>
</PriceSpecificationElementPropertyReference>
<PriceSpecificationElementPropertyValue>
<Code listID="CND_PRODUCT_ID_TYPE_CODE">1</Code>
</PriceSpecificationElementPropertyValue>
</PriceSpecificationElementPropertyValuation>
<Description languageCode="EN">Hotel Expense (contractually limited)</Description>
</PropertyValuation>
<PropertyValuation>
<PriceSpecificationElementPropertyValuation>
<IdentifyingIndicator>true</IdentifyingIndicator>
<PriceSpecificationElementPropertyReference>
<PriceSpecificationElementPropertyID>CND_PRODUCT_TYPE_CODE</PriceSpecificationElementPropertyID>
<PriceSpecificationElementPropertyDefinitionClassCode>2</PriceSpecificationElementPropertyDefinitionClassCode>
</PriceSpecificationElementPropertyReference>
<PriceSpecificationElementPropertyValue>
<Code listID="CND_PRODUCT_TYPE_CODE">2</Code>
</PriceSpecificationElementPropertyValue>
</PriceSpecificationElementPropertyValuation>
<Description languageCode="EN">Hotel Expense (contractually limited)</Description>
</PropertyValuation>
</PriceSpecification>
<PriceSpecification>
<PriceSpecificationElementTypeCode listID="2">7PR1</PriceSpecificationElementTypeCode>
<PriceSpecificationElementTypeName languageCode="EN">List Price</PriceSpecificationElementTypeName>
<PriceSpecificationElementCategoryCode>1</PriceSpecificationElementCategoryCode>
<PriceSpecificationElementCategoryName languageCode="EN">Price</PriceSpecificationElementCategoryName>
<PriceSpecificationElementPurposeCode>1000</PriceSpecificationElementPurposeCode>
<PriceSpecificationElementPurposeName languageCode="EN">General</PriceSpecificationElementPurposeName>
<ConsistencyStatusCode>3</ConsistencyStatusCode>
<ConsistencyStatusName languageCode="EN">Consistent</ConsistencyStatusName>
<ReleaseStatusCode>3</ReleaseStatusCode>
<ReleaseStatusName languageCode="EN">Released</ReleaseStatusName>
<BaseQuantity unitCode="EA">1.0</BaseQuantity>
<BaseQuantityTypeCode>EA</BaseQuantityTypeCode>
<BaseQuantityTypeCodeName languageCode="EN">ea</BaseQuantityTypeCodeName>
<Amount currencyCode="USD">19300.0</Amount>
<PropertyValuation>
<PriceSpecificationElementPropertyValuation>
<IdentifyingIndicator>true</IdentifyingIndicator>
<PriceSpecificationElementPropertyReference>
<PriceSpecificationElementPropertyID>CND_PRODUCT_ID</PriceSpecificationElementPropertyID>
<PriceSpecificationElementPropertyDefinitionClassCode>2</PriceSpecificationElementPropertyDefinitionClassCode>
</PriceSpecificationElementPropertyReference>
<PriceSpecificationElementPropertyValue>
<ID>MCF-0004-PAC1</ID>
</PriceSpecificationElementPropertyValue>
</PriceSpecificationElementPropertyValuation>
<Description languageCode="EN">AHT Combi Max</Description>
</PropertyValuation>
<PropertyValuation>
<PriceSpecificationElementPropertyValuation>
<IdentifyingIndicator>true</IdentifyingIndicator>
<PriceSpecificationElementPropertyReference>
<PriceSpecificationElementPropertyID>CND_PRODUCT_ID_TYPE_CODE</PriceSpecificationElementPropertyID>
<PriceSpecificationElementPropertyDefinitionClassCode>2</PriceSpecificationElementPropertyDefinitionClassCode>
</PriceSpecificationElementPropertyReference>
<PriceSpecificationElementPropertyValue>
<Code listID="CND_PRODUCT_ID_TYPE_CODE">1</Code>
</PriceSpecificationElementPropertyValue>
</PriceSpecificationElementPropertyValuation>
<Description languageCode="EN">AHT Combi Max</Description>
</PropertyValuation>
<PropertyValuation>
<PriceSpecificationElementPropertyValuation>
<IdentifyingIndicator>true</IdentifyingIndicator>
<PriceSpecificationElementPropertyReference>
<PriceSpecificationElementPropertyID>CND_PRODUCT_TYPE_CODE</PriceSpecificationElementPropertyID>
<PriceSpecificationElementPropertyDefinitionClassCode>2</PriceSpecificationElementPropertyDefinitionClassCode>
</PriceSpecificationElementPropertyReference>
<PriceSpecificationElementPropertyValue>
<Code listID="CND_PRODUCT_TYPE_CODE">1</Code>
</PriceSpecificationElementPropertyValue>
</PriceSpecificationElementPropertyValuation>
<Description languageCode="EN">AHT Combi Max</Description>
</PropertyValuation>
</PriceSpecification>
<PriceSpecification>
<PriceSpecificationElementTypeCode listID="2">7PR1</PriceSpecificationElementTypeCode>
<PriceSpecificationElementTypeName languageCode="EN">List Price</PriceSpecificationElementTypeName>
<PriceSpecificationElementCategoryCode>1</PriceSpecificationElementCategoryCode>
<PriceSpecificationElementCategoryName languageCode="EN">Price</PriceSpecificationElementCategoryName>
<PriceSpecificationElementPurposeCode>1000</PriceSpecificationElementPurposeCode>
<PriceSpecificationElementPurposeName languageCode="EN">General</PriceSpecificationElementPurposeName>
<ConsistencyStatusCode>3</ConsistencyStatusCode>
<ConsistencyStatusName languageCode="EN">Consistent</ConsistencyStatusName>
<ReleaseStatusCode>3</ReleaseStatusCode>
<ReleaseStatusName languageCode="EN">Released</ReleaseStatusName>
<BaseQuantity unitCode="EA">1.0</BaseQuantity>
<BaseQuantityTypeCode>EA</BaseQuantityTypeCode>
<BaseQuantityTypeCodeName languageCode="EN">ea</BaseQuantityTypeCodeName>
<Amount currencyCode="USD">19300.0</Amount>
<PropertyValuation>
<PriceSpecificationElementPropertyValuation>
<IdentifyingIndicator>true</IdentifyingIndicator>
<PriceSpecificationElementPropertyReference>
<PriceSpecificationElementPropertyID>CND_PRODUCT_ID</PriceSpecificationElementPropertyID>
<PriceSpecificationElementPropertyDefinitionClassCode>2</PriceSpecificationElementPropertyDefinitionClassCode>
</PriceSpecificationElementPropertyReference>
<PriceSpecificationElementPropertyValue>
<ID>MCF-0004-PAC2</ID>
</PriceSpecificationElementPropertyValue>
</PriceSpecificationElementPropertyValuation>
<Description languageCode="EN">AHT Combi Max</Description>
</PropertyValuation>
<PropertyValuation>
<PriceSpecificationElementPropertyValuation>
<IdentifyingIndicator>true</IdentifyingIndicator>
<PriceSpecificationElementPropertyReference>
<PriceSpecificationElementPropertyID>CND_PRODUCT_ID_TYPE_CODE</PriceSpecificationElementPropertyID>
<PriceSpecificationElementPropertyDefinitionClassCode>2</PriceSpecificationElementPropertyDefinitionClassCode>
</PriceSpecificationElementPropertyReference>
<PriceSpecificationElementPropertyValue>
<Code listID="CND_PRODUCT_ID_TYPE_CODE">1</Code>
</PriceSpecificationElementPropertyValue>
</PriceSpecificationElementPropertyValuation>
<Description languageCode="EN">AHT Combi Max</Description>
</PropertyValuation>
<PropertyValuation>
<PriceSpecificationElementPropertyValuation>
<IdentifyingIndicator>true</IdentifyingIndicator>
<PriceSpecificationElementPropertyReference>
<PriceSpecificationElementPropertyID>CND_PRODUCT_TYPE_CODE</PriceSpecificationElementPropertyID>
<PriceSpecificationElementPropertyDefinitionClassCode>2</PriceSpecificationElementPropertyDefinitionClassCode>
</PriceSpecificationElementPropertyReference>
<PriceSpecificationElementPropertyValue>
<Code listID="CND_PRODUCT_TYPE_CODE">1</Code>
</PriceSpecificationElementPropertyValue>
</PriceSpecificationElementPropertyValuation>
<Description languageCode="EN">AHT Combi Max</Description>
</PropertyValuation>
</PriceSpecification>
<SalesPriceSpecificationProcessingConditions>
<ReturnedQueryHitsNumberValue>10</ReturnedQueryHitsNumberValue>
<MoreHitsAvailableIndicator>true</MoreHitsAvailableIndicator>
<LastReturnedObjectID>00163E0126B91EE0ABC55085E40CCB93</LastReturnedObjectID>
</SalesPriceSpecificationProcessingConditions>
</SalesPriceListFindByIDResponseMessage>
<Log>
<Item>
<SeverityCode>I</SeverityCode>
<Note/>
<NoteTemplateText>Price specification retrieved for LastChangedDateTime Interval</NoteTemplateText>
</Item>
</Log>
</n0:SalesPriceListFindByIDResponse_flt_sync>
</env:Body>
</env:Envelope>
Sample Subsequent Request Payload (will return the next page of 100 records)
<SalesPriceList>
<ID>PRICELIST_DC_PC</ID>
<SalesPriceSpecificationProcessingConditions>
<QueryHitsMaximumNumberValue>100</QueryHitsMaximumNumberValue>
<QueryHitsUnlimitedIndicator>false</QueryHitsUnlimitedIndicator>
<LastReturnedObjectID>0000000000011ED19BA19C9A3983CF4D</LastReturnedObjectID>
</SalesPriceSpecificationProcessingConditions>
</SalesPriceList>
Note : repeat the above steps till the response returns <MoreHitsAvailableIndicator>false</MoreHitsAvailableIndicator>
Nice blog. very detailed.