[Home] [Help] [Dependency Information]
Object Name: | FII_PA_REVENUE_F |
---|---|
Object Type: | TABLE |
Owner: | FII |
FND Design Data: | FII.FII_PA_REVENUE_F |
Subobject Name: | |
Status: | VALID |
This is the Project Revenue fact table. The pre-built collect program extracts revenue distribution lines for all of Oracle Projects expenditure items and revenue events for which draft revenue has been generated.
Tablespace: | APPS_TS_SUMMARY |
---|---|
PCT Free: | 10 |
PCT Used: |
Index | Type | Uniqueness | Tablespace | Column |
---|---|---|---|---|
FII_PA_REVENUE_F_U1 | NORMAL | UNIQUE | APPS_TS_SUMMARY | REVENUE_PK |
FII_PA_REVENUE_F_U2 | NORMAL | UNIQUE | APPS_TS_SUMMARY | REVENUE_PK_KEY |
FII_PA_REVENUE_F_N1 | BITMAP | NONUNIQUE | APPS_TS_SUMMARY | INSTANCE_FK_KEY |
FII_PA_REVENUE_F_N10 | BITMAP | NONUNIQUE | APPS_TS_SUMMARY | TRANSACTION_DATE_FK_KEY |
FII_PA_REVENUE_F_N11 | BITMAP | NONUNIQUE | APPS_TS_SUMMARY | GL_ACCT1_FK_KEY |
FII_PA_REVENUE_F_N12 | BITMAP | NONUNIQUE | APPS_TS_SUMMARY | GL_ACCT2_FK_KEY |
FII_PA_REVENUE_F_N13 | BITMAP | NONUNIQUE | APPS_TS_SUMMARY | GL_ACCT3_FK_KEY |
FII_PA_REVENUE_F_N14 | BITMAP | NONUNIQUE | APPS_TS_SUMMARY | GL_ACCT4_FK_KEY |
FII_PA_REVENUE_F_N15 | BITMAP | NONUNIQUE | APPS_TS_SUMMARY | GL_ACCT5_FK_KEY |
FII_PA_REVENUE_F_N16 | BITMAP | NONUNIQUE | APPS_TS_SUMMARY | GL_ACCT6_FK_KEY |
FII_PA_REVENUE_F_N17 | BITMAP | NONUNIQUE | APPS_TS_SUMMARY | GL_ACCT7_FK_KEY |
FII_PA_REVENUE_F_N18 | BITMAP | NONUNIQUE | APPS_TS_SUMMARY | GL_ACCT8_FK_KEY |
FII_PA_REVENUE_F_N19 | BITMAP | NONUNIQUE | APPS_TS_SUMMARY | GL_ACCT9_FK_KEY |
FII_PA_REVENUE_F_N2 | BITMAP | NONUNIQUE | APPS_TS_SUMMARY | SET_OF_BOOKS_FK_KEY |
FII_PA_REVENUE_F_N20 | BITMAP | NONUNIQUE | APPS_TS_SUMMARY | GL_ACCT10_FK_KEY |
FII_PA_REVENUE_F_N3 | BITMAP | NONUNIQUE | APPS_TS_SUMMARY | PROJECT_FK_KEY |
FII_PA_REVENUE_F_N4 | BITMAP | NONUNIQUE | APPS_TS_SUMMARY | PROJECT_ORG_FK_KEY |
FII_PA_REVENUE_F_N5 | BITMAP | NONUNIQUE | APPS_TS_SUMMARY | CUSTOMER_FK_KEY |
FII_PA_REVENUE_F_N6 | BITMAP | NONUNIQUE | APPS_TS_SUMMARY | CURRENCY_GL_FK_KEY |
FII_PA_REVENUE_F_N8 | BITMAP | NONUNIQUE | APPS_TS_SUMMARY | GL_DATE_FK_KEY |
FII_PA_REVENUE_F_N9 | BITMAP | NONUNIQUE | APPS_TS_SUMMARY | PA_DATE_FK_KEY |
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
REVENUE_PK | VARCHAR2 | (120) | Unique Identifier | |
REVENUE_PK_KEY | NUMBER | System generated primary key | ||
INSTANCE_FK_KEY | NUMBER | System generated foreign key for the Instanse dimension | ||
SET_OF_BOOKS_FK_KEY | NUMBER | System generated foreign key for the Set Of Books dimension | ||
PROJECT_FK_KEY | NUMBER | System generated foreign key for the Project dimension | ||
PROJECT_ORG_FK_KEY | NUMBER | System generated foreign key for the Organization dimension (task owning organization) | ||
CUSTOMER_FK_KEY | NUMBER | System generated foreign key for the Trading Partner dimension | ||
CURRENCY_GL_FK_KEY | NUMBER | System generated foreign key for the Currency dimension (functional currency) | ||
GL_DATE_FK_KEY | NUMBER | System generated foreign key for the Time dimension (GL date) | ||
PA_DATE_FK_KEY | NUMBER | System generated foreign key for the Time dimension (PA date) | ||
TRANSACTION_DATE_FK_KEY | NUMBER | System generated foreign key for the Time dimension (transaction date) | ||
GL_ACCT1_FK_KEY | NUMBER | System generated foreign key for the Accounting Flexfield dimension | ||
GL_ACCT2_FK_KEY | NUMBER | System generated foreign key for the Accounting Flexfield dimension | ||
GL_ACCT3_FK_KEY | NUMBER | System generated foreign key for the Accounting Flexfield dimension | ||
GL_ACCT4_FK_KEY | NUMBER | System generated foreign key for the Accounting Flexfield dimension | ||
GL_ACCT5_FK_KEY | NUMBER | System generated foreign key for the Accounting Flexfield dimension | ||
GL_ACCT6_FK_KEY | NUMBER | System generated foreign key for the Accounting Flexfield dimension | ||
GL_ACCT7_FK_KEY | NUMBER | System generated foreign key for the Accounting Flexfield dimension | ||
GL_ACCT8_FK_KEY | NUMBER | System generated foreign key for the Accounting Flexfield dimension | ||
GL_ACCT9_FK_KEY | NUMBER | System generated foreign key for the Accounting Flexfield dimension | ||
GL_ACCT10_FK_KEY | NUMBER | System generated foreign key for the Accounting Flexfield dimension | ||
REVENUE_G | NUMBER | Revenue (global currency) | ||
REVENUE_B | NUMBER | Revenue (functional currency) | ||
USER_MEASURE1 | NUMBER | User defined measure | ||
USER_MEASURE2 | NUMBER | User defined measure | ||
USER_MEASURE3 | NUMBER | User defined measure | ||
USER_MEASURE4 | NUMBER | User defined measure | ||
USER_MEASURE5 | NUMBER | User defined measure | ||
USER_ATTRIBUTE1 | VARCHAR2 | (240) | User defined attribute | |
USER_ATTRIBUTE2 | VARCHAR2 | (240) | User defined attribute | |
USER_ATTRIBUTE3 | VARCHAR2 | (240) | User defined attribute | |
USER_ATTRIBUTE4 | VARCHAR2 | (240) | User defined attribute | |
USER_ATTRIBUTE5 | VARCHAR2 | (240) | User defined attribute | |
USER_ATTRIBUTE6 | VARCHAR2 | (240) | User defined attribute | |
USER_ATTRIBUTE7 | VARCHAR2 | (240) | User defined attribute | |
USER_ATTRIBUTE8 | VARCHAR2 | (240) | User defined attribute | |
USER_ATTRIBUTE9 | VARCHAR2 | (240) | User defined attribute | |
USER_ATTRIBUTE10 | VARCHAR2 | (240) | User defined attribute | |
USER_FK1_KEY | NUMBER | System generated foreign key for a user defined dimension | ||
USER_FK2_KEY | NUMBER | System generated foreign key for a user defined dimension | ||
USER_FK3_KEY | NUMBER | System generated foreign key for a user defined dimension | ||
USER_FK4_KEY | NUMBER | System generated foreign key for a user defined dimension | ||
USER_FK5_KEY | NUMBER | System generated foreign key for a user defined dimension | ||
INSTANCE | VARCHAR2 | (40) | Instance identifier | |
CREATION_DATE | DATE | Standard who column - date when this row was created. | ||
LAST_UPDATE_DATE | DATE | Standard Who column - date when a user last updated this row. |
Cut, paste (and edit) the following text to query this object:
SELECT REVENUE_PK
, REVENUE_PK_KEY
, INSTANCE_FK_KEY
, SET_OF_BOOKS_FK_KEY
, PROJECT_FK_KEY
, PROJECT_ORG_FK_KEY
, CUSTOMER_FK_KEY
, CURRENCY_GL_FK_KEY
, GL_DATE_FK_KEY
, PA_DATE_FK_KEY
, TRANSACTION_DATE_FK_KEY
, GL_ACCT1_FK_KEY
, GL_ACCT2_FK_KEY
, GL_ACCT3_FK_KEY
, GL_ACCT4_FK_KEY
, GL_ACCT5_FK_KEY
, GL_ACCT6_FK_KEY
, GL_ACCT7_FK_KEY
, GL_ACCT8_FK_KEY
, GL_ACCT9_FK_KEY
, GL_ACCT10_FK_KEY
, REVENUE_G
, REVENUE_B
, USER_MEASURE1
, USER_MEASURE2
, USER_MEASURE3
, USER_MEASURE4
, USER_MEASURE5
, USER_ATTRIBUTE1
, USER_ATTRIBUTE2
, USER_ATTRIBUTE3
, USER_ATTRIBUTE4
, USER_ATTRIBUTE5
, USER_ATTRIBUTE6
, USER_ATTRIBUTE7
, USER_ATTRIBUTE8
, USER_ATTRIBUTE9
, USER_ATTRIBUTE10
, USER_FK1_KEY
, USER_FK2_KEY
, USER_FK3_KEY
, USER_FK4_KEY
, USER_FK5_KEY
, INSTANCE
, CREATION_DATE
, LAST_UPDATE_DATE
FROM FII.FII_PA_REVENUE_F;
FII.FII_PA_REVENUE_F does not reference any database object
FII.FII_PA_REVENUE_F is referenced by following:
|
|
|