Incentive Compensation Staging Transaction

The input payload service data object to create and manage transactions and credits in the staging table.

QName: {http://xmlns.oracle.com/apps/incentiveCompensation/cn/transactionProcessing/transactionManagement/publicService/}TransactionStaging

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

Incentive Compensation Transaction

Attributes

The following table describes attributes in the service data object.

Name Type Description

AdjustmentComments

string

The commentary for an adjustment to the transaction.

AdjustmentStatus

string

The lookup code that represents the adjustment state of the transaction.

AreaCode

string

The geographic transaction attribute for the area code. The area code is a component of a phone number and is usually a 3-digit number that identifies each telephone service area in a country.

Attribute1

string

The user-definable descriptive flex field for a character data type value.

Attribute10

string

The user-definable descriptive flex field for a character data type value.

Attribute100

string

The user-definable descriptive flex field for a character data type value.

Attribute101

string

The user-definable descriptive flex field for a character data type value.

Attribute102

string

The user-definable descriptive flex field for a character data type value.

Attribute103

string

The user-definable descriptive flex field for a character data type value.

Attribute104

string

The user-definable descriptive flex field for a character data type value.

Attribute105

string

The user-definable descriptive flex field for a character data type value.

Attribute106

string

The user-definable descriptive flex field for a character data type value.

Attribute107

string

The user-definable descriptive flex field for a character data type value.

Attribute108

string

The user-definable descriptive flex field for a character data type value.

Attribute109

string

The user-definable descriptive flex field for a character data type value.

Attribute11

string

The user-definable descriptive flex field for a character data type value.

Attribute110

string

The user-definable descriptive flex field for a character data type value.

Attribute111

string

The user-definable descriptive flex field for a character data type value.

Attribute112

string

The user-definable descriptive flex field for a character data type value.

Attribute113

string

The user-definable descriptive flex field for a character data type value.

Attribute114

string

The user-definable descriptive flex field for a character data type value.

Attribute115

string

The user-definable descriptive flex field for a character data type value.

Attribute116

string

The user-definable descriptive flex field for a character data type value.

Attribute117

string

The user-definable descriptive flex field for a character data type value.

Attribute118

string

The user-definable descriptive flex field for a character data type value.

Attribute119

string

The user-definable descriptive flex field for a character data type value.

Attribute12

string

The user-definable descriptive flex field for a character data type value.

Attribute120

string

The user-definable descriptive flex field for a character data type value.

Attribute121

string

The user-definable descriptive flex field for a character data type value.

Attribute122

string

The user-definable descriptive flex field for a character data type value.

Attribute123

string

The user-definable descriptive flex field for a character data type value.

Attribute124

string

The user-definable descriptive flex field for a character data type value.

Attribute125

string

The user-definable descriptive flex field for a character data type value.

Attribute126

string

The user-definable descriptive flex field for a character data type value.

Attribute127

string

The user-definable descriptive flex field for a character data type value.

Attribute128

string

The user-definable descriptive flex field for a character data type value.

Attribute129

string

The user-definable descriptive flex field for a character data type value.

Attribute13

string

The user-definable descriptive flex field for a character data type value.

Attribute130

string

The user-definable descriptive flex field for a character data type value.

Attribute131

string

The user-definable descriptive flex field for a character data type value.

Attribute132

string

The user-definable descriptive flex field for a character data type value.

Attribute133

string

The user-definable descriptive flex field for a character data type value.

Attribute134

string

The user-definable descriptive flex field for a character data type value.

Attribute135

string

The user-definable descriptive flex field for a character data type value.

Attribute136

string

The user-definable descriptive flex field for a character data type value.

Attribute137

string

The user-definable descriptive flex field for a character data type value.

Attribute138

string

The user-definable descriptive flex field for a character data type value.

Attribute139

string

The user-definable descriptive flex field for a character data type value.

Attribute14

string

The user-definable descriptive flex field for a character data type value.

Attribute140

string

The user-definable descriptive flex field for a character data type value.

Attribute141

string

The user-definable descriptive flex field for a character data type value.

Attribute142

string

The user-definable descriptive flex field for a character data type value.

Attribute143

string

The user-definable descriptive flex field for a character data type value.

Attribute144

string

The user-definable descriptive flex field for a character data type value.

Attribute145

string

The user-definable descriptive flex field for a character data type value.

Attribute146

string

The user-definable descriptive flex field for a character data type value.

Attribute147

string

The user-definable descriptive flex field for a character data type value.

Attribute148

string

The user-definable descriptive flex field for a character data type value.

Attribute149

string

The user-definable descriptive flex field for a character data type value.

Attribute15

string

The user-definable descriptive flex field for a character data type value.

Attribute150

string

The user-definable descriptive flex field for a character data type value.

Attribute16

string

The user-definable descriptive flex field for a character data type value.

Attribute17

string

The user-definable descriptive flex field for a character data type value.

Attribute18

string

The user-definable descriptive flex field for a character data type value.

Attribute19

string

The user-definable descriptive flex field for a character data type value.

Attribute2

string

The user-definable descriptive flex field for a character data type value.

Attribute20

string

The user-definable descriptive flex field for a character data type value.

Attribute21

string

The user-definable descriptive flex field for a character data type value.

Attribute22

string

The user-definable descriptive flex field for a character data type value.

Attribute23

string

The user-definable descriptive flex field for a character data type value.

Attribute24

string

The user-definable descriptive flex field for a character data type value.

Attribute25

string

The user-definable descriptive flex field for a character data type value.

Attribute26

string

The user-definable descriptive flex field for a character data type value.

Attribute27

string

The user-definable descriptive flex field for a character data type value.

Attribute28

string

The user-definable descriptive flex field for a character data type value.

Attribute29

string

The user-definable descriptive flex field for a character data type value.

Attribute3

string

The user-definable descriptive flex field for a character data type value.

Attribute30

string

The user-definable descriptive flex field for a character data type value.

Attribute31

string

The user-definable descriptive flex field for a character data type value.

Attribute32

string

The user-definable descriptive flex field for a character data type value.

Attribute33

string

The user-definable descriptive flex field for a character data type value.

Attribute34

string

The user-definable descriptive flex field for a character data type value.

Attribute35

string

The user-definable descriptive flex field for a character data type value.

Attribute36

string

The user-definable descriptive flex field for a character data type value.

Attribute37

string

The user-definable descriptive flex field for a character data type value.

Attribute38

string

The user-definable descriptive flex field for a character data type value.

Attribute39

string

The user-definable descriptive flex field for a character data type value.

Attribute4

string

The user-definable descriptive flex field for a character data type value.

Attribute40

string

The user-definable descriptive flex field for a character data type value.

Attribute41

string

The user-definable descriptive flex field for a character data type value.

Attribute42

string

The user-definable descriptive flex field for a character data type value.

Attribute43

string

The user-definable descriptive flex field for a character data type value.

Attribute44

string

The user-definable descriptive flex field for a character data type value.

Attribute45

string

The user-definable descriptive flex field for a character data type value.

Attribute46

string

The user-definable descriptive flex field for a character data type value.

Attribute47

string

The user-definable descriptive flex field for a character data type value.

Attribute48

string

The user-definable descriptive flex field for a character data type value.

Attribute49

string

The user-definable descriptive flex field for a character data type value.

Attribute5

string

The user-definable descriptive flex field for a character data type value.

Attribute50

string

The user-definable descriptive flex field for a character data type value.

Attribute51

string

The user-definable descriptive flex field for a character data type value.

Attribute52

string

The user-definable descriptive flex field for a character data type value.

Attribute53

string

The user-definable descriptive flex field for a character data type value.

Attribute54

string

The user-definable descriptive flex field for a character data type value.

Attribute55

string

The user-definable descriptive flex field for a character data type value.

Attribute56

string

The user-definable descriptive flex field for a character data type value.

Attribute57

string

The user-definable descriptive flex field for a character data type value.

Attribute58

string

The user-definable descriptive flex field for a character data type value.

Attribute59

string

The user-definable descriptive flex field for a character data type value.

Attribute6

string

The user-definable descriptive flex field for a character data type value.

Attribute60

string

The user-definable descriptive flex field for a character data type value.

Attribute61

string

The user-definable descriptive flex field for a character data type value.

Attribute62

string

The user-definable descriptive flex field for a character data type value.

Attribute63

string

The user-definable descriptive flex field for a character data type value.

Attribute64

string

The user-definable descriptive flex field for a character data type value.

Attribute65

string

The user-definable descriptive flex field for a character data type value.

Attribute66

string

The user-definable descriptive flex field for a character data type value.

Attribute67

string

The user-definable descriptive flex field for a character data type value.

Attribute68

string

The user-definable descriptive flex field for a character data type value.

Attribute69

string

The user-definable descriptive flex field for a character data type value.

Attribute7

string

The user-definable descriptive flex field for a character data type value.

Attribute70

string

The user-definable descriptive flex field for a character data type value.

Attribute71

string

The user-definable descriptive flex field for a character data type value.

Attribute72

string

The user-definable descriptive flex field for a character data type value.

Attribute73

string

The user-definable descriptive flex field for a character data type value.

Attribute74

string

The user-definable descriptive flex field for a character data type value.

Attribute75

string

The user-definable descriptive flex field for a character data type value.

Attribute76

string

The user-definable descriptive flex field for a character data type value.

Attribute77

string

The user-definable descriptive flex field for a character data type value.

Attribute78

string

The user-definable descriptive flex field for a character data type value.

Attribute79

string

The user-definable descriptive flex field for a character data type value.

Attribute8

string

The user-definable descriptive flex field for a character data type value.

Attribute80

string

The user-definable descriptive flex field for a character data type value.

Attribute81

string

The user-definable descriptive flex field for a character data type value.

Attribute82

string

The user-definable descriptive flex field for a character data type value.

Attribute83

string

The user-definable descriptive flex field for a character data type value.

Attribute84

string

The user-definable descriptive flex field for a character data type value.

Attribute85

string

The user-definable descriptive flex field for a character data type value.

Attribute86

string

The user-definable descriptive flex field for a character data type value.

Attribute87

string

The user-definable descriptive flex field for a character data type value.

Attribute88

string

The user-definable descriptive flex field for a character data type value.

Attribute89

string

The user-definable descriptive flex field for a character data type value.

Attribute9

string

The user-definable descriptive flex field for a character data type value.

Attribute90

string

The user-definable descriptive flex field for a character data type value.

Attribute91

string

The user-definable descriptive flex field for a character data type value.

Attribute92

string

The user-definable descriptive flex field for a character data type value.

Attribute93

string

The user-definable descriptive flex field for a character data type value.

Attribute94

string

The user-definable descriptive flex field for a character data type value.

Attribute95

string

The user-definable descriptive flex field for a character data type value.

Attribute96

string

The user-definable descriptive flex field for a character data type value.

Attribute97

string

The user-definable descriptive flex field for a character data type value.

Attribute98

string

The user-definable descriptive flex field for a character data type value.

Attribute99

string

The user-definable descriptive flex field for a character data type value.

AttributeCategory

string

The context segment for the descriptive flex field.

AttributeNumber1

decimal

The user-definable descriptive flex field for a numeric data type value.

AttributeNumber10

decimal

The user-definable descriptive flex field for a numeric data type value.

AttributeNumber11

decimal

The user-definable descriptive flex field for a numeric data type value.

AttributeNumber12

decimal

The user-definable descriptive flex field for a numeric data type value.

AttributeNumber13

decimal

The user-definable descriptive flex field for a numeric data type value.

AttributeNumber14

decimal

The user-definable descriptive flex field for a numeric data type value.

AttributeNumber15

decimal

The user-definable descriptive flex field for a numeric data type value.

AttributeNumber16

decimal

The user-definable descriptive flex field for a numeric data type value.

AttributeNumber17

decimal

The user-definable descriptive flex field for a numeric data type value.

AttributeNumber18

decimal

The user-definable descriptive flex field for a numeric data type value.

AttributeNumber19

decimal

The user-definable descriptive flex field for a numeric data type value.

AttributeNumber2

decimal

The user-definable descriptive flex field for a numeric data type value.

AttributeNumber20

decimal

The user-definable descriptive flex field for a numeric data type value.

AttributeNumber21

decimal

The user-definable descriptive flex field for a numeric data type value.

AttributeNumber22

decimal

The user-definable descriptive flex field for a numeric data type value.

AttributeNumber23

decimal

The user-definable descriptive flex field for a numeric data type value.

AttributeNumber24

decimal

The user-definable descriptive flex field for a numeric data type value.

AttributeNumber25

decimal

The user-definable descriptive flex field for a numeric data type value.

AttributeNumber26

decimal

The user-definable descriptive flex field for a numeric data type value.

AttributeNumber27

decimal

The user-definable descriptive flex field for a numeric data type value.

AttributeNumber28

decimal

The user-definable descriptive flex field for a numeric data type value.

AttributeNumber29

decimal

The user-definable descriptive flex field for a numeric data type value.

AttributeNumber3

decimal

The user-definable descriptive flex field for a numeric data type value.

AttributeNumber30

decimal

The user-definable descriptive flex field for a numeric data type value.

AttributeNumber31

decimal

The user-definable descriptive flex field for a numeric data type value.

AttributeNumber32

decimal

The user-definable descriptive flex field for a numeric data type value.

AttributeNumber33

decimal

The user-definable descriptive flex field for a numeric data type value.

AttributeNumber34

decimal

The user-definable descriptive flex field for a numeric data type value.

AttributeNumber35

decimal

The user-definable descriptive flex field for a numeric data type value.

AttributeNumber36

decimal

The user-definable descriptive flex field for a numeric data type value.

AttributeNumber37

decimal

The user-definable descriptive flex field for a numeric data type value.

AttributeNumber38

decimal

The user-definable descriptive flex field for a numeric data type value.

AttributeNumber39

decimal

The user-definable descriptive flex field for a numeric data type value.

AttributeNumber4

decimal

The user-definable descriptive flex field for a numeric data type value.

AttributeNumber40

decimal

The user-definable descriptive flex field for a numeric data type value.

AttributeNumber41

decimal

The user-definable descriptive flex field for a numeric data type value.

AttributeNumber42

decimal

The user-definable descriptive flex field for a numeric data type value.

AttributeNumber43

decimal

The user-definable descriptive flex field for a numeric data type value.

AttributeNumber44

decimal

The user-definable descriptive flex field for a numeric data type value.

AttributeNumber45

decimal

The user-definable descriptive flex field for a numeric data type value.

AttributeNumber46

decimal

The user-definable descriptive flex field for a numeric data type value.

AttributeNumber47

decimal

The user-definable descriptive flex field for a numeric data type value.

AttributeNumber48

decimal

The user-definable descriptive flex field for a numeric data type value.

AttributeNumber49

decimal

The user-definable descriptive flex field for a numeric data type value.

AttributeNumber5

decimal

The user-definable descriptive flex field for a numeric data type value.

AttributeNumber50

decimal

The user-definable descriptive flex field for a numeric data type value.

AttributeNumber6

decimal

The user-definable descriptive flex field for a numeric data type value.

AttributeNumber7

decimal

The user-definable descriptive flex field for a numeric data type value.

AttributeNumber8

decimal

The user-definable descriptive flex field for a numeric data type value.

AttributeNumber9

decimal

The user-definable descriptive flex field for a numeric data type value.

BillToAddressId

long

The unique identifier for the customer billing location.

BillToContactId

long

The unique identifier for the contact person at the bill-to location.

BookedDate

{http://xmlns.oracle.com/adf/svc/types/}date-Date

The date when the sales order was booked in the order management application.

BusinessUnitId

long

The unique identifier of the business unit record. You can view the business unit identifier for a business unit from the Setup and Maintenance, Define Business Units task. (In the search results region, click the View menu to add the Business Unit ID column.) The Incentive Compensation parameters must be defined for the business unit. You can define the parameters for the business unit scope using the Setup and Maintenance, Manage Parameters task.

ChangedTrxFlag

boolean

A flag that indicates if the transaction is a new transaction or modified.

City

string

The name of the city.

ClsfnRuleId

long

The unique record identifier for the classification rule to use when classifying the transaction or credit.

CollectionStatus

string

The lookup code that represents the reason for a collection error.

Country

string

The name of the country.

CreditDate

{http://xmlns.oracle.com/adf/svc/types/}date-Date

The date the credit receiver received credit. The date is used to determine the credit receivers when processing the credit rules against transactions.

CreditHoldFlag

boolean

Indicates whether the application must exclude the credit from processing further

CreditRuleId

long

The unique identifier for the credit rule record.

CreditedParticipantId

long

The unique record identifier of the active participant receiving credit. You can view the participant identifier from the Participant Snapshot work area, Select Participant search results. Select the participant to navigate to the Manage Participant Details page to view the Active indicator. You can also use the participant export web service. If you are importing credits, this is a required attribute.
  • Primary Key

CustomerId

long

The unique identifier for customer who purchased the items or services listed on the transaction.

DiscountPercentage

decimal

The percentage of the transaction amount that depicts the net amount to be paid by the buyer.

EligibleCatId

long

The unique record identifier for the credit category to use when overriding the classification process. The credit category is a user-defined business category used to classify a transaction for compensation purposes.

HoldFlag

boolean

The transaction hold indicator. The hold excludes an uncredited transaction from processing. If providing a value, valid values are: Y, N.

InventoryItemId

long

The unique record identifier for the inventory item.

InvoiceDate

{http://xmlns.oracle.com/adf/svc/types/}date-Date

The invoice date for the transaction in the source application.

InvoiceNumber

string

The invoice number entered in the source application.

MarginPercentage

decimal

The percentage of the transaction amount that depicts the profit of the sale.

ObjectStatus

string

The lookup code that represents the current state of the transaction such as New, Obsolete, or Collection Error.

OrderNumber

string

The sales order number entered in the source application.

ParticipantId

long

The unique record identifier for the active direct participant. You can view the participant identifier from the Participant Snapshot work area, Select Participant search results. Select the participant to navigate to the Manage Participant Details page to view the Active indicator. You can also use the participant export web service.

PostalCode

string

The postal code element of the address.

ProcessCode

string

The process code is a five letter code that determines the combination of Override Classification, Preserve Credits, Do Not Roll Up, and Do Not Calculate values for the transaction. For example, the process code CCREC indicates that the Override Classification, Preserve Credits, and Do Not Roll Up check boxes are not checked and the normal calculation processing will occur. Override Classification - The first letter determines the Override Classification setting. Valid values are N and C. Enter a code starting with N to check the Override Classification checkbox. You must also provide a credit category to avoid the collection error status. For regular classification processing, enter a code starting with C. Preserve Credits - The second letter determines the Preserve Credits setting. Valid values are N and C. Enter a code with N as the second letter to check the Preserve Credits checkbox. For regular credit processing, enter C. Do Not Rollup - The third letter determines the Do Not Rollup setting. Valid values are N and R. Enter a code with N as the third letter to check the Do Not Rollup checkbox. To allow rollup credit processing, enter R. Eligibility and Calculation - The last two letters indicate earnings edibility and calculation. Valid values are EC, EN,NN, and NC. Enter a code with the value of N in either or both of the fourth and fifth position to exclude the credit from calculation. For regular calculation processing, enter EC.

Province

string

The name of the province.

ReasonCode

string

The lookup code that represents the reason for adjusting a transaction. If providing a value, then the value must be a valid lookup code for lookup type CN_TP_ADJUSTMENT_REASON. You can view the CN_TP_ADJUSTMENT_REASON lookup from the Setup and Maintenance, Manage Incentive Compensation Lookups task.

RevenueType

string

The lookup code that represents the revenue type, such as REVENUE or NONREVENUE. If you are importing credits, this is a required attribute.

RoleId

long

The unique record identifier for the compensation role assigned to incentive compensation participants. Not currently used.

RollupDate

{http://xmlns.oracle.com/adf/svc/types/}date-Date

The date used to determine the roll up credit receivers when processing the roll up rules against transactions.

SalesChannel

string

The sales channel represents how the transaction was sold. For example, indirect or direct.

ShipToAddressId

long

The unique identifier for the customer ship-to location.

ShipToContactId

long

The unique identifier for the contact person at the ship-to location.

SourceBusinessUnitId

long

The unique identifier of the source transaction business unit record. You can view business unit identifier for a business unit from the Setup and Maintenance, Define Business Units task. (In the search results region, click the View menu to add the Business Unit ID column.)

SourceCurrencyCode

string

The currency code that represents the currency of the monetary transaction amount in the source application.

SourceCurrencyCreditAmount

{http://xmlns.oracle.com/adf/svc/types/}AmountType

The amount of the credit in the source application currency. If you are importing credits, this is a required attribute.

SourceCurrencyTransactionAmount

{http://xmlns.oracle.com/adf/svc/types/}AmountType

The amount of the transaction in the source application currency. This is a required attribute.

SourceEventDate

{http://xmlns.oracle.com/adf/svc/types/}date-Date

The incentive event date. The event date is used to determine the effective currency conversion rate when the participant's home currency is used as the processing currency. The date must be within a defined Incentive Compensation calendar period where the period has an Open status and the calendar is defined for the same business unit as the transaction's business unit. If the value does not meet these requirements, the transaction process status is updated to a value of Collection Error. This is a required attribute.

SourceTrxId

long

The unique number for the transaction in the source application.

SourceTrxLineId

long

The number for the transaction line in the source application.

SourceTrxNumber

string

The transaction number. Use an identifier that participants recognize and can search with, for example, an invoice number or order number. If adjusting a transaction, the combination of the business unit, transaction number, and the transaction type uniquely identify an existing transaction. This is a required attribute.
  • Primary Key

SourceTrxSalesLineId

long

The number for the transaction sales credit line in the source application.

SplitPct

decimal

The percent of the transaction amount that the credit receiver received. If you are importing credits, this is a required attribute.

State

string

The name of the state.

TerrId

long

The unique identifier for the territory in the source application.

TerrName

string

The territory name in the source application.

TransactionId

long

The unique identifier for the transaction record.

TransactionQuantity

{http://xmlns.oracle.com/adf/svc/types/}MeasureType

The quantity for the transaction line item.

TransactionSubType

string

The lookup code that represents the additional categorization of the transaction type. If providing a value, then the value must be a valid lookup code for lookup type CN_TP_TRANSACTION_SUB_TYPE. You can view lookup CN_TP_TRANSACTION_SUB_TYPE from the Setup and Maintenance, Manage Incentive Compensation Lookups task.

TransactionType

string

The lookup code that represents the type of transaction, such as INVOICE or ORDER. If adjusting a transaction, the combination of the business unit, transaction number, and the transaction type uniquely identify an existing transaction. The value must be a valid lookup code for lookup type CN_TP_TRANSACTION_TYPE. You can view lookup CN_TP_TRANSACTION_TYPE from the Setup and Maintenance, Manage Incentive Compensation Lookups task. This is a required attribute.
  • Primary Key

UOMCode

string

The unit of measure for the transaction line item.

WorkerId

long

The worker used internally to group transactions into batches.