|
|
Account |
The account associated with the order. |
Adjusted |
Indicates whether or not the transaction has been adjusted. |
Adjusted Transaction |
The original transaction ID from which the adjustment was created. |
Calculation Run |
Name of the calculation run. This field is populated after the calculation engine has run. |
Commission Credit Revenue |
The value in this field is calculated as Order multiplied by Commission. |
Contributor Position |
The position from which the manager is receiving the credit allocation (commission credit) and quota credit allocation (production credit). |
Contributor Territory |
The territory where the Contributor Position first received credit. |
Credit Allocation |
The amount of credit allocated to this employee for the deal. |
Eligible for Payment |
If the check box flag is selected, the compensation from this record is included in the Gross Earnings Eligible total. Regardless of the value of the flag, the compensation amount is included in the Gross Earnings amount. |
First Name |
The first name of the employee being compensated. |
Gross Earnings |
The gross earnings across all plan rules for this given transaction. |
Gross Earnings (Admin Currency) |
The gross earnings, converted to the divisional currency of the compensation administrator currently logged into the application |
Last Name |
The last name of the employee being compensated. |
Modified |
The name of the person who last modified the record. |
Modified Date |
The date the record was last modified. |
Net Cost |
The net cost of the product or order. |
Net Price |
The net price of the product (after the net discount has been applied). |
Opportunity |
The opportunity associated with the order. |
Order |
The ID number of the order itself. |
Order Amount |
The total amount on the order. For order records, this is the total amount for the order. For line-item records, this is the total amount the product is contributing on the order (Net Price multiplied by Quantity Requested). This field is used to determine compensation when the plan rule has a performance measure of Revenue. The order amount is displayed in the currency defined on the order. |
Order Date |
The date the order was placed. |
Order Type |
The type of order (for example, Sales Order). |
Original Sales Team |
This position on the order is treated like a member of the original team for compensation purposes. The flag is set in the Transaction Team field in the Transaction Workbook, and it works in conjunction with the Distribution field in the Earned status. |
Payment |
Indicates payment record. |
Payment Amount |
The payment amount for this transaction. |
% Margin |
The percentage of margin on the product. This field is used for compensation when the plan rule has a performance measure of % Margin. |
% Net Discount |
The net discount percentage used for this line item. This field is used for compensation when the plan rule has a performance measure of % Discount. |
Period |
Indicates which period this record is associated with during import into Calculation Workbook. |
Plan Date |
The date to export transactions. This date is used to determine which calculation run would include the transaction. The default is the Order Creation Date, but with tools configuration, the Plan Date can be mapped to the Status Date of any previous status of a transaction. |
Position |
The position of the employee. |
Product |
For a line-item record, this is the product being sold. This field contains no value for order header and calculation type records. |
Product Line |
For a line-item record, this is the product line for the product. This field contains no value for order header and calculation type records. |
Quantity Requested |
The number of units requested for the product. This field is used for compensation when the plan rule has a performance measure of Units. |
Quantity Shipped |
The number of units of the product shipped. |
Quota Credit Allocation |
The percentage of order amount revenue applied towards the quota attainment calculation. The percentage is defined for each sales team member in the Team field in Orders or in the Transaction Workbook's Team field. |
Quota Credit Revenue |
The value in this field is calculated as Order Amount multiplied by Quota Credit Allocation. |
Record Code |
The code for the record, either Adjusted or Regular. Regular is used for any transaction other than an adjustment. |
Record Type |
The type of record in the Calculation Workbook. The type might be an transaction record (which represents the transaction header record), a line item (which represents a line item on the transaction), or a calculation (which represents a record that has been created to display an aggregated calculated amount). |
Revenue Type |
Describes the type of revenue for the Transaction line (such as product or service). Users can create filters based on this field. For more information on creating filters, see Creating a Filter. |
Sales Team End |
The end date of the position on the sales team. |
Sales Team Start |
The start date of the position in the sales team. |
Site |
For example, Headquarters. |
Status |
The status of the order (for example, Booked, Billed, Shipped, or Paid). |
Status Date |
The date of the transaction. This is the date that was entered for the order when the status was changed. |
Territory |
The territory of the position. |
Transaction ID |
The ID of the transaction that has been imported into the Calculation Workbook. |