Previous	Next		Contents	Index	Navigation		Library

By associating each column in your compensation transaction with its source column in an Oracle Receivables transaction table, you provide a "map" that tells Oracle Sales Compensation where to look for the information you need.

You can map transaction data at three levels--the Header table level, which gives you customer information, at the Line table level, which gives you product or item information, and at the Sales Lines table level, which gives you salesperson information.

To define how you want to bring transaction information into Oracle Sales Compensation from Oracle Receivables, you can use either the defaults that Oracle Sales Compensation gives you, or add attributes to the default mappings by defining mappings directly or indirectly. Your choices are as follows:

• Use the default mapping defined by Oracle Sales Compensation

• Add new attribute columns to the default mapping

• Define direct mapping between Oracle Receivables and Oracle Sales Compensation tables and columns at any of the three table levels: Header, Line, or Sales Lines

• Define direct mapping using an expression between Oracle Receivables and Oracle Sales Compensation tables and columns at any of the three table levels: Header, Line, or Sales Lines

Note: Using an expression requires understanding of the underlying database and should be done by a system administrator. Contact your system administrator to help you define an expression.

• Define indirect mapping using a foreign key between Oracle Receivables and Oracle Sales Compensation tables and columns at any of the three table levels: Header, Line, or Sales Lines