Power BI Connector for Bullhorn CRM

Build 24.0.9062

PlacementRateCardLine

Create, update, delete and query data of 'PlacementRateCardLine' entity in BullhornCRM system.

Table Specific Information

This table comes with the limitations below since it is exposed from its parent entity PlacementRateCardLineGroup endpoint.

  • No more than a maximum of 15 PlacementRateCardLine records are returned for every parent PlacementRateCardLineGroup record. This means that if a parent PlacementRateCardLineGroup record contains more than 15 related PlacementRateCardLine records, ex. 17, only the top 15 related records are returned. This is due to Bullhorn CRM API limitations, as stated in the BullhornCRM API Reference Documentation.
  • The ORDER BY clause is processed server side only for the parent identifier column PlacementRateCardLineGroupId, as in the example below. For every other column or columns set, the ORDER BY clause is processed client side.
    SELECT * FROM PlacementRateCardLine ORDER BY PlacementRateCardLineGroupId DESC

Columns

Name Type ReadOnly Description
id [KEY] Int False

Alias String False

BillCurrencyUnitId Int False

BillMultiplier Decimal False

BillRate Decimal False

EarnCodeId Int False

MarkupPercent Decimal False

MarkupValue Decimal False

PayCurrencyUnitId Int False

PayMultiplier Decimal False

PayRate Decimal False

PlacementRateCardLineGroupId Int False

Copyright (c) 2024 CData Software, Inc. - All rights reserved.
Build 24.0.9062