| Column Header | Sample Value | Description |
| TRANSACTION_TYPE | MANUAL | Task: Manage Incentive COmpensation Lookups - search on lookup type CN_TP_TRANSACTION_TYPE. User can create new transaction types. Use the lookup code as the value for the data file. |
| TRANSACTION_NUMBER | ImpTrx-1 | Normally, transaction number is unique. However for credited transactions, it can be the same as the next record as long as the credited_participant is not the same. Meaning, you can load multiple credited participants for the same transaction. |
| EVENT_DATE | 01/16/2012 | |
| CREDIT_DATE | 01/16/2012 | |
| ROLLUP_DATE | 01/16/2012 | |
| TRANSCTION_AMOUNT | 150.00 | |
| QUANTITY | 25 | |
| CURRENCY_CODE | USD | |
| CREDIT_CATEGORY | 300000001228758 | Use sql to find out the id value for the credit category:
SELECT eligible_cat_id, name FROM cn_eligible_cats_all_tl ; |
| CREDIT_AMOUNT | 113.25 | |
| CREDIT_SPLIT_PERCENT | 75.50 | Percentage. If this is not 100% then the credit_amount should reflect the transaction_amount X credit_split_percent. Example: 150 X 75.50% = 113.25 |
| CREDIT_REVENUE_TYPE | REVENUE | or NON_REVENUE |
| CREDITED_PARTICIPANT_ID | 10001 | Use sql to find out the id value for the credited_participant :
SELECT participant_id, participant_name FROM cn_srp_participants_all ; |
| PROCESS_CODE | CNREC | The process code will tell the system if the following process in this order (Classify, Credit, Rollup, Eligibility, Calculation) will be process or not.
CCREC = Normal, process all NCREC = Skip classification NCNEC = Skip classification and rollup CNNEC = Skip crediting and rollup CNREC = Skip crediting CCNEC = Skip rollup NNREC = Skip classification and crediting NNNEC = Skip classification, crediting, and rollup
Note: If you want to preserve the credit receivers and credit categories values, then use option to skip crediting (eg. CNREC) |
| BUSINESS_UNIT_ID | 300000001175314 | Use sql to find out value of business_unit_id.
SELECT DISTINCT bu.bu_id, bu.bu_name FROM fun_all_business_units_v bu, fun_business_functions_b bf, fun_bu_usages_v buu WHERE bu.bu_id = buu.business_unit_id AND bf.business_function_code = 'INCENTIVE_COMPENSATION_BF' AND bf.business_function_id = buu.module_id ; |
| SOURCE_BUSINESS_UNIT_ID | 300000001175314 | Use sql to find out value of business_unit_id.
SELECT DISTINCT bu.bu_id, bu.bu_name FROM fun_all_business_units_v bu, fun_business_functions_b bf, fun_bu_usages_v buu WHERE bu.bu_id = buu.business_unit_id AND bf.business_function_code = 'INCENTIVE_COMPENSATION_BF' AND bf.business_function_id = buu.module_id ; |
| SALES_CHANNEL | Epipen | Optional - example of Channel value used in classification or crediting rules. |
| ATTRIBUTE_NUMBER11 | 220.00 | Optional - example of populating a numeric attribute value to be used for calculation. |
No comments:
Post a Comment