Incentive Compensation Payment Export
The output service data object for the paysheet payment transaction details.
QName: {http://xmlns.oracle.com/apps/incentiveCompensation/cn/paymentSetup/paysheets/paymentTransactionService/}PaymentTransactionExp
Logical Business Objects
-
IC : Incentive Compensation : Incentive Compensation Payment Transaction
Relationships
The following table describes how this service data object is related to other service data objects or business object services.
Relationship Type | Object or Service |
---|---|
Handled by |
Attributes
The following table describes attributes in the service data object.
Name | Type | Description |
---|---|---|
ActiveFlag |
boolean |
The current active value, which indicates whether the participant is marked as active or inactive. |
AdjustComments |
string |
A field for commentary entered (for a payment transaction or manual paysheet adjustment). |
AdjustStatus |
string |
The adjustment status. Not currently used. |
ApExpId |
long |
The plan component payable expense account. Not currently used. |
ApLiabId |
long |
The plan component payable liability account. Not currently used. |
CalculationCurrencyCommAmount |
{http://xmlns.oracle.com/adf/svc/types/}AmountType |
The payment transaction amount in the calculation currency. |
CommissionValue |
decimal |
The incentive rate table amount or rate used to calculate the earning. |
CompensationEndDate |
{http://xmlns.oracle.com/adf/svc/types/}date-Date |
The compensation end date, after which paysheets are no longer generated for the participant. |
CostCenter |
string |
The participant cost center that is in effect as of the source event date for the payment of earnings, or the payment batch period for the payment of manual paysheet adjustments. |
CountryCode |
string |
The participant country code that is in effect as of the source event date for the payment of earnings, or the payment batch period for the payment of manual paysheet adjustments. |
CreatedBy |
string |
The user who created the record. |
CreationDate |
{http://xmlns.oracle.com/adf/svc/types/}dateTime-Timestamp |
The date when the record was created. |
CreditTypeId |
long |
The unique identifier for the earning type record. The earning type, selected for the plan component, is used to classify earnings into monetary and nonmonetary categories. |
CreditedEmployeeNumber |
string |
The worker (employee) number for the participant who received credit for the earning source transaction. |
CreditedParticipantId |
long |
The unique participant record identifier for the participant who received credit from the source transaction. |
EarningId |
long |
The unique identifier for the earning record. |
EarningTypeId |
long |
The unique identifier for the earning type record. The earning type, selected for the plan component, is used to classify earnings into monetary and nonmonetary categories. |
EndDate |
{http://xmlns.oracle.com/adf/svc/types/}date-Date |
Indicates the date till which the entity is active. This date is inclusive and the status of the entity is dependent on this. |
ExpenseCcid |
long |
The payment payable expense code. Not currently used. |
FuncCurrencyPayAmount |
{http://xmlns.oracle.com/adf/svc/types/}AmountType |
The payment (payment transaction or manual paysheet adjustment) amount in the operating currency. |
HRPrimaryWorkerNumber |
string |
The participant worker (employee) number. |
HoldFlag |
boolean |
A flag that indicates whether to keep from paying a payment transaction until the hold is explicitly released. |
HoldPaymentFlag |
boolean |
The current hold payment value, which indicates whether participant payments should be held or not. |
HomeCurrencyCode |
string |
The participant home currency code that is in effect as of the source event date for the payment of earnings, or the payment batch period for the payment of manual paysheet adjustments. |
HomeCurrencyPayAmount |
{http://xmlns.oracle.com/adf/svc/types/}AmountType |
The payment (payment transaction or manual paysheet adjustment) amount in the participant home currency. |
IncentiveTypeCode |
string |
The incentive type (for earnings) is the lookup code that represents whether to calculate earnings per event or per interval. The calculate incentive type is selected when defining the plan component. Where the calculated amount is based on the payment plan minimum and recoverable amounts, the incentive type value is PMTPLN or PMTPLN_REC. For paysheet manual adjustments, the incentive type value is MANUAL_PAY_ADJ. |
LastUpdateDate |
{http://xmlns.oracle.com/adf/svc/types/}dateTime-Timestamp |
The date when the record was last updated. |
LastUpdateLogin |
string |
The login of the user who last updated the record. |
LastUpdatedBy |
string |
The user who last updated the record. |
LiabilityCcid |
long |
The payment payable liability code. Not currently used. |
ObjectStatus |
string |
The code indicating whether the paysheet status has a value of paid. |
ObjectVersionNumber |
int |
The number used to implement locking. This number is incremented every time that the row is updated. The number is compared at the start and end of a transaction to determine whether another session has updated the row. |
OrgId |
long |
The unique identifier of the business unit record. |
ParticipantPayId |
long |
The unique identifier of the payment (payment transaction or paysheet manual adjustment) record.
|
ParticipantType |
string |
The code that represents the participant type as either a participant or compensation administrator. |
PartyId |
long |
The unique identifier of the contact party. |
PartyName |
string |
The name of the party. |
PartyNumber |
string |
The unique identification number for the party. |
PayCurrencyCode |
string |
The processing currency code for the payment (payment transaction or manual paysheet adjustment) amount. |
PayCurrencyPayAmount |
{http://xmlns.oracle.com/adf/svc/types/}AmountType |
The payment (payment transaction or manual paysheet adjustment) amount in the processing currency. |
PayDate |
{http://xmlns.oracle.com/adf/svc/types/}date-Date |
The payment batch pay date. |
PayElementTypeId |
long |
The payment element type. Not currently used. |
PayPeriodId |
long |
The period number representing the period of the payment transaction earning event date or the payment batch period for the manual paysheet adjustment. |
PayToFuncCurrencyCnvrt |
decimal |
The rate used to convert the payment amount from the calculation currency to operating currency. |
PayToHomeCurrencyCnvrt |
decimal |
The rate used to convert the payment amount from the calculation currency to participant's home currency. |
PayeeEmployeeNumber |
string |
The worker (employee number) for the payee participant. |
PayeeOnly |
string |
The current payee-only value, which indicates whether the participant is marked as a payee only. |
PayeeParticipantId |
long |
The unique identifier for the participant record, for the participant payee. |
PaymentGroupCode |
string |
The plan component payment plan category used to apply payment plan adjustments. |
PayrunId |
long |
The unique identifier for the payment batch record. |
PersonNumber |
string |
The generated identifier for the participant person record in Oracle HCM Cloud. |
PlanComponentId |
long |
The unique identifier for the plan component record. |
PlanComponentName |
string |
The plan component name. |
RecoverableFlag |
boolean |
A flag that Indicates whether the payment adjustment (payment transaction adjustment or manual paysheet adjustment) is recoverable. |
ReportGroup |
string |
The lookup code that represents the incentive type, such as bonus or commission. The incentive type is selected when defining the plan component. |
RoleId |
long |
The unique identifier for the role record. Not currently used. |
SourceEarningId |
long |
The unique identifier for the source earning record, from which this earning originated from. |
SourceEventDate |
{http://xmlns.oracle.com/adf/svc/types/}date-Date |
The earning source transaction event date. |
SourceOrgId |
long |
The unique identifier of the source business unit for the earning source transaction. |
SourceSystem |
string |
The source system name where the record originated. |
SourceSystemId |
string |
The generated identifier for the participant party record in the Trading Community Model. |
SourceTrxNumber |
string |
The earning source transaction number. |
SourceType |
string |
The lookup code that represents whether the earning source transaction was collected or entered manually. Not currently used. |
SrpPlanAssignId |
long |
The unique identifier for the participant plan assignment record. |
StartDate |
{http://xmlns.oracle.com/adf/svc/types/}date-Date |
Indicates the date from which this entity is active. This date is inclusive and the status of an entity is dependent on this. |
TransactionType |
string |
The lookup code that represents the earning's source transaction type. For example, INVOICE (Invoice) or GRP (Grouped by calculation). |
WaiveFlag |
boolean |
A paysheet indicator for whether to waive payment recovery. |