Get all earnings

get

/fscmRestApi/resources/11.13.18.05/incentiveCompensationEarnings

Request

Query Parameters
  • When this parameter is provided, the specified children are included in the resource payload (instead of just a link). The value of this query parameter is "all" or "". More than one child can be specified using comma as a separator. Example: ?expand=Employees,Localizations. Nested children can also be provided following the format "Child.NestedChild" (Example: ?expand=Employees.Managers). If a nested child is provided (Example: Employees.Managers), the missing children will be processed implicitly. For example, "?expand=Employees.Managers" is the same as "?expand=Employees,Employees.Managers" (which will expand Employees and Managers).
  • This parameter filters the resource fields. Only the specified fields are returned, which means that if no fields are specified, no fields are returned (useful to get only the links). If an indirect child resource is provided (Example: Employees.Managers), the missing children will be processed implicitly. For example, "?fields=Employees.Managers:Empname" is the same as "?fields=;Employees:;Employees.Managers:Empname" (which will only return the "Empname" field for Managers). the value of this query parameter is a list of resource fields. The attribute can be a direct (Example: Employees) or indirect (Example: Employees.Managers) child. It cannot be combined with expand query parameter. If both are provided, only fields will be considered.

    Format: ?fields=Attribute1,Attribute2

    Format for fields in child resource: ?fields=Accessor1:Attribute1,Attribute2
  • Used as a predefined finder to search the collection.

    Format: ?finder=<finderName>;<variableName>=<variableValue>,<variableName2>=<variableValue2>

    The following are the available finder names and corresponding finder variables:

    • EarningsSearchFinder: Finds the earnings within the specified date range for a plan component and a credit receiver.
      Finder Variables:
      • bCreditReceiver; string; The name of the incentive compensation credit receiver.
      • bFromDate; string; The date when an earning period starts.
      • bPlanComponent; string; The name of the plan component for which the earnings are calculated.
      • bToDate; string; The date when an earning period ends.
      • bTransactionNumber; string; The transaction number which resulted in the incentive earnings.
    • PrimaryKey: Finds an earning with the specified identifier.
      Finder Variables:
      • EarningId; integer; The unique identifier of the earnings.
  • This parameter restricts the number of resources returned inside the resource collection. If the limit exceeds the resource count then the framework will only return the available resources.
  • This parameter can be used to show only certain links while accessing a singular resource or a resource collection. The parameter value format is a comma-separated list of : <link_relation>

    Example:
    self,canonical
  • Used to define the starting position of the resource collection. If offset exceeds the resource count then no resources are returned. Default value is 0.
  • The resource item payload will be filtered in order to contain only data (no links section, for example).
  • This parameter orders a resource collection based on the specified fields. The parameter value is a comma-separated string of attribute names, each optionally followed by a colon and "asc" or "desc". Specify "asc" for ascending and "desc" for descending. The default value is "asc". For example, ?orderBy=field1:asc,field2:desc
  • This query parameter defines the where clause. The resource collection will be queried using the provided expressions. The value of this query parameter is one or more expressions. Example: ?q=Deptno>=10 and <= 30;Loc!=NY

    Format: ?q=expression1;expression2

    You can use these queryable attributes to filter this collection resource using the q query parameter:
    • CalculationCurrency; string; The code indicating the processing currency for the earning amounts. The processing currency is selected as either the operating currency or the participant home currency for the business unit. Review the processing currency parameter using the Setup and Maintenance work area, Manage Parameters task.
    • CommissionValue; number; The incentive rate table amount, or percent, that was used to calculate the earning amount.
    • CompensationPlanId; integer; The unique identifier of the compensation plan.
    • CompensationPlanName; string; The name of the compensation plan for which the earnings are calculated.
    • ConversionRate; number; The exchange rate to convert the processing currency into operating currency.
    • CreatedBy; string; The user who created the incentive compensation earning.
    • CreatedDuring; string; The lookup code indicating when this earning record was created. The possible values include ELIGIBLE and CALCULATION. A list of acceptable values is defined in the lookup CN_TP_EARNING_CREATED_DURING.
    • CreationDate; string; The date when the earning was created.
    • CreditAmount; number; The credit amount expressed in processing currency.
    • CreditedParticipantId; integer; The unique identifier of the participant.
    • EarningAmount; number; The amount earned expressed in processing currency.
    • EarningId; integer; The unique identifier of the earnings.
    • EarningType; string; The name of the earning type for the plan component. This values is used to classify earnings into monetary and nonmonetary categories.
    • EarningTypeId; integer; The unique identifier of the type of earning.
    • EligibleCatId; integer; The unique identifier of the credit category.
    • ErrorReason; string; The reason explaining why the earning is in error status.
    • FormulaEcatId; integer; The unique identifier representing the credit category for a plan component.
    • FormulaId; integer; The unique identifier for the incentive formula.
    • FormulaWeight; number; The percentage of influence a plan component has on the compensation plan. It is also called target incentive percent.
    • HomeCurrencyCode; string; The participant home currency code that is in effect as of the source event date of the payment transaction. Review the effective participant attributes using the Participant Snapshot work area, Manage Participant Detail page.
    • HomeCurrencyConversionRate; number; The exchange rate to convert the processing currency into home currency.
    • HomeEarningAmount; number; The amount earned expressed in participant home currency.
    • InputAchieved; number; The amount passed to the rate table to calculate the earnings based on the input expression defined in the plan component.
    • LastUpdatedBy; string; The user who last updated the earning.
    • ObjectStatus; string; The lookup code indicating the current status of the earnings record, such as calculated, calculation error, eligible, or reversed. Review the available lookup codes for the lookup type CN_TP_EARNING_OBJECT_STATUS using the Setup and Maintenance, Manage Incentive Compensation Lookups task.
    • OperatingEarningAmount; number; The amount earned expressed in business unit operating currency.
    • OrgId; integer; The unique identifier of the business unit.
    • OutputAchieved; number; The amount calculated by the earnings expression of an incentive formula.
    • ParticipantId; integer; The unique identifier of the incentive compensation participant who received direct credit for the source transaction.
    • ParticipantName; string; The name of the incentive compensation credit receiver.
    • PayPeriodId; integer; The unique identifier of the pay period. The period number represents the calendar period the paysheet and payment batch is for. The period numbers are generated when you define your incentive compensation calendar using the Setup and Maintenance work area, Manage Calendars task. For example, the period number 2018001 represents the first period in the year 2018.
    • PlanComponentId; integer; The unique identifier of the plan component.
    • PlanComponentName; string; The name of the plan component for which the earnings are calculated.
    • PostingStatus; string; The status code indicating if the earning was included in the payment process. If true then the earning was included in the payment. Possible values include false and true.
    • ProcessCode; string; The process code provided in the source transaction to override classification, crediting, and rollup processing.
    • SourceEventDate; string; The date of the earning event. The event date is either the source transaction event date or the calculation grouping event date which resulted in the incentive earning.
    • SourceEventPeriodId; integer; The unique identifier of the calendar period in which the transaction event date falls.
    • SourceOrgId; integer; The unique identifier of the source business unit of the transaction.
    • SourceTrxNumber; string; The transaction number which resulted in the incentive earnings.
    • SplitPct; number; The percentage number applied against the transaction amount to calculate the credit amount.
    • SrpAlternatePayeeId; integer; The unique identifier of the alternate person who is eligible to receive payment for this earnings.
    • SrpCompensationPlanId; integer; The unique identifier of the assignment of the compensation plan to the participant.
    • TierSplits; integer; The number of rate tiers used to calculate the earning rate.
    • TransactionAmount; number; The transaction amount expressed in processing currency.
    • TransactionId; integer; The unique identifier of the transaction.
    • TransactionType; string; The type of the transaction. This value indicates the source of the transaction, such as order, invoice, or credit memo. Review the available lookup codes for the lookup type CN_TP_TRANSACTION_TYPE using the Setup and Maintenance, Manage Incentive Compensation Lookups task.
  • The resource collection representation will include the "estimated row count" when "?totalResults=true", otherwise the count is not included. The default value is "false".
Header Parameters
  • If the REST API supports runtime customizations, the shape of the service may change during runtime. The REST client may isolate itself from these changes or choose to interact with the latest version of the API by specifying this header. For example: Metadata-Context:sandbox="TrackEmployeeFeature".
  • The protocol version between a REST client and service. If the client does not specify this header in the request the server will pick a default version for the API.

There's no request body for this operation.

Back to Top

Response

Supported Media Types

Default Response

The following table describes the default response for this task.
Headers
  • If the REST API supports runtime customizations, the shape of the service may change during runtime. The REST client may isolate itself from these changes or choose to interact with the latest version of the API by specifying this header. For example: Metadata-Context:sandbox="TrackEmployeeFeature".
  • The protocol version between a REST client and service. If the client does not specify this header in the request the server will pick a default version for the API.
Body ()
Root Schema : incentiveCompensationEarnings
Type: object
Show Source
Nested Schema : Items
Type: array
Title: Items
The items in the collection.
Show Source
Nested Schema : incentiveCompensationEarnings-item-response
Type: object
Show Source
  • Title: Currency
    Read Only: true
    Maximum Length: 15
    The code indicating the processing currency for the earning amounts. The processing currency is selected as either the operating currency or the participant home currency for the business unit. Review the processing currency parameter using the Setup and Maintenance work area, Manage Parameters task.
  • Title: Earning Rate
    Read Only: true
    The incentive rate table amount, or percent, that was used to calculate the earning amount.
  • Read Only: true
    The unique identifier of the compensation plan.
  • Title: Compensation Plan
    Read Only: true
    Maximum Length: 80
    The name of the compensation plan for which the earnings are calculated.
  • Title: Conversion Rate
    Read Only: true
    The exchange rate to convert the processing currency into operating currency.
  • Read Only: true
    Maximum Length: 64
    The user who created the incentive compensation earning.
  • Title: Earning Process Type
    Read Only: true
    Maximum Length: 30
    The lookup code indicating when this earning record was created. The possible values include ELIGIBLE and CALCULATION. A list of acceptable values is defined in the lookup CN_TP_EARNING_CREATED_DURING.
  • Read Only: true
    The date when the earning was created.
  • Title: Calculation Currency Credit Amount
    Read Only: true
    The credit amount expressed in processing currency.
  • Title: Credit Receiver
    Read Only: true
    The unique identifier of the participant.
  • Title: Earning Amount
    Read Only: true
    The amount earned expressed in processing currency.
  • Title: Earning ID
    Read Only: true
    The unique identifier of the earnings.
  • Title: Earning Type
    Read Only: true
    Maximum Length: 30
    The name of the earning type for the plan component. This values is used to classify earnings into monetary and nonmonetary categories.
  • Read Only: true
    The unique identifier of the type of earning.
  • Title: Credit Category
    Read Only: true
    The unique identifier of the credit category.
  • Title: Error Reason
    Read Only: true
    Maximum Length: 150
    The reason explaining why the earning is in error status.
  • Title: Plan Component Category
    Read Only: true
    The unique identifier representing the credit category for a plan component.
  • Read Only: true
    The unique identifier for the incentive formula.
  • Title: Weight
    Read Only: true
    The percentage of influence a plan component has on the compensation plan. It is also called target incentive percent.
  • Title: Home Currency
    Read Only: true
    Maximum Length: 15
    The participant home currency code that is in effect as of the source event date of the payment transaction. Review the effective participant attributes using the Participant Snapshot work area, Manage Participant Detail page.
  • Title: Home Currency Conversion Rate
    Read Only: true
    The exchange rate to convert the processing currency into home currency.
  • Title: Home Earning Amount
    Read Only: true
    The amount earned expressed in participant home currency.
  • Title: Input Achieved
    Read Only: true
    The amount passed to the rate table to calculate the earnings based on the input expression defined in the plan component.
  • Title: Last Updated By
    Read Only: true
    Maximum Length: 64
    The user who last updated the earning.
  • Links
  • Title: Process Status
    Read Only: true
    Maximum Length: 30
    The lookup code indicating the current status of the earnings record, such as calculated, calculation error, eligible, or reversed. Review the available lookup codes for the lookup type CN_TP_EARNING_OBJECT_STATUS using the Setup and Maintenance, Manage Incentive Compensation Lookups task.
  • Title: Operating Earning Amount
    Read Only: true
    The amount earned expressed in business unit operating currency.
  • Title: Business Unit
    Read Only: true
    The unique identifier of the business unit.
  • Title: Output Achieved
    Read Only: true
    The amount calculated by the earnings expression of an incentive formula.
  • Title: Direct Participant
    Read Only: true
    The unique identifier of the incentive compensation participant who received direct credit for the source transaction.
  • Title: Participant Name
    Read Only: true
    Maximum Length: 360
    The name of the incentive compensation credit receiver.
  • Title: Period
    Read Only: true
    The unique identifier of the pay period. The period number represents the calendar period the paysheet and payment batch is for. The period numbers are generated when you define your incentive compensation calendar using the Setup and Maintenance work area, Manage Calendars task. For example, the period number 2018001 represents the first period in the year 2018.
  • Read Only: true
    The unique identifier of the plan component.
  • Title: Plan Component
    Read Only: true
    Maximum Length: 80
    The name of the plan component for which the earnings are calculated.
  • Title: Posted
    Read Only: true
    Maximum Length: 1
    The status code indicating if the earning was included in the payment process. If true then the earning was included in the payment. Possible values include false and true.
  • Title: Override
    Read Only: true
    Maximum Length: 30
    The process code provided in the source transaction to override classification, crediting, and rollup processing.
  • Title: Event Date
    Read Only: true
    The date of the earning event. The event date is either the source transaction event date or the calculation grouping event date which resulted in the incentive earning.
  • Title: Event Period
    Read Only: true
    The unique identifier of the calendar period in which the transaction event date falls.
  • Title: Source BU
    Read Only: true
    The unique identifier of the source business unit of the transaction.
  • Title: Transaction Number
    Read Only: true
    Maximum Length: 30
    The transaction number which resulted in the incentive earnings.
  • Title: Split Percent
    Read Only: true
    The percentage number applied against the transaction amount to calculate the credit amount.
  • Read Only: true
    The unique identifier of the alternate person who is eligible to receive payment for this earnings.
  • Read Only: true
    The unique identifier of the assignment of the compensation plan to the participant.
  • Read Only: true
    The number of rate tiers used to calculate the earning rate.
  • Title: Transaction Amount
    Read Only: true
    The transaction amount expressed in processing currency.
  • Title: Transaction ID
    Read Only: true
    The unique identifier of the transaction.
  • Title: Transaction Type
    Read Only: true
    Maximum Length: 30
    The type of the transaction. This value indicates the source of the transaction, such as order, invoice, or credit memo. Review the available lookup codes for the lookup type CN_TP_TRANSACTION_TYPE using the Setup and Maintenance, Manage Incentive Compensation Lookups task.
Back to Top