No Columns available in CN_TP_EARNINGS to enable for Calcluation
Summary:
Trying to enable the SOURCE_TRX_NUMBER for calculation in the CN_TP_EARNINGS table through the Configure Tables and Columns Task in Setup and Maintenance.
The use case is we would like to refer to the COMMISSION_VALUE field for a previous earning transaction record if the credit transaction fits certain criteria.
However, when I navigate to the table, no column is available for the CN_TP_EARNINGS table.
- Is this table not available for any types of calculation?
- If this table is available for calculation, how can I add more columns in?
- If this is a security issue (I am able to see columns for other table), any security role/data role I should be granting for my role? I can access earnings transaction records with no issue.
Tagged:
0