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 |