Previous  Next          Contents  Index  Navigation    Library

About the Payment Interface Table

Oracle Sales Compensation provides a payment interface table, CN_PAYMENTS_API, that allows you to export payment information to your payroll application.

After you choose Pay to from the Submit payment window, Oracle Sales Compensation writes one record for each payment to each salesperson in the payrun to the payment interface table. The information written includes: SalesrepID, PeriodID, PaymentDate, Payment Type, Payment Amount, and CostCenter. For example, if the salesperson was paid $2500 in commission and $500 in bonus, two records are written to the payment API table--one for the commission and one for the bonus.

Using Oracle Sales Compensation's API for payment processing, you can copy the payment request from the payment interface table into the payment processing application of your choice, such as Oracle Payroll or Oracle Payables (Figure 10 - 3).


         Previous  Next          Contents  Index  Navigation    Library