What is the difference between the S_REVN table and the S_OPTY_POSTN table

S_REVN table was introduced in Siebel version 7.0 which is used to store Revenue data. For example Revenue by an employee on an Opportunity, an Agreement, a Service Request, etc.

S_REVN table replaces S_OPTY_PROD and S_OPTY_POSTN table in Siebel version 6.0.

As of Siebel version 7.0, S_OPTY_PROD is obsolete and S_OPTY_POSTN is no longer used to store revenue records.

S_OPTY_POSTN, just like other similar tables (such as S_ORDER_POSTN), is used to store only the Positions (sales team) on opportunities. For example, an Opportunity may have one or more employees with varying roles working on closing the opportunity. Each employee may be affiliated with a different internal organization. Employees have differing roles on an Opportunities (Primary Sales Representative, Technical Sales Consultant, etc.,) and S_OPTY_POSTN is used to store such data.

The data in S_OPTY_PROD and the relevant data in S_OPTY_POSTN tables from Siebel version 6.0 will be systematically migrated into S_REVN during the Upgrade process . Data Migration will occur as follows:

1. Migrate all primary sales representative records from S_OPTY_POSTN to S_REVN. 

2. Migrate all non-primary sales representative records from S_OPTY_POSTN to S_REVN when the revenue is committed with amount > 0.

 3. Migrate all primary sales representative records from S_OPTY_PROD to S_REVN.