DBA Data[Home] [Help] [Dependency Information]

TABLE: FII.FII_E_REVENUE_F

Object Details
Object Name: FII_E_REVENUE_F
Object Type: TABLE
Owner: FII
FND Design Data: TableFII.FII_E_REVENUE_F
Subobject Name:
Status: VALID

***** Warning: Oracle Internal Use Only *****

Oracle Corporation does not support access to Oracle
applications data using this object, except from standard Oracle Applications programs.

Storage Details
Tablespace: TablespaceAPPS_TS_SUMMARY
PCT Free: 10
PCT Used:
Indexes
Index Type Uniqueness Tablespace Column
FII_E_REVENUE_F_U1 NORMAL UNIQUE TablespaceAPPS_TS_SUMMARY ColumnREVENUE_PK
Columns
Name Datatype Length Mandatory Comments
AGREEMENT_ID NUMBER

Agreement identifier
BATCH_ID NUMBER

Batch identifier
CCID NUMBER

Account identifier
CUST_TRX_LINE_ID NUMBER

Invoice line identifier
DOC_LINE_NUM NUMBER

Line number of the invoice
EXCHANGE_RATE NUMBER

Exchange rate
REVENUE_PK_KEY NUMBER

System generated unique identifier of the revenue fact record
UNIT_SELLING_PRICE NUMBER

Selling price per unit for a transaction line
UNIT_STAN_PRICE NUMBER

List price per unit. Price is gross of inclusive taxes. There is no seperate gross standard price.
USER_FK1_KEY NUMBER

System generated user defined foreign key
USER_FK2_KEY NUMBER

System generated user defined foreign key
USER_FK3_KEY NUMBER

System generated user defined foreign key
USER_FK4_KEY NUMBER

System generated user defined foreign key
USER_FK5_KEY NUMBER

System generated user defined foreign key
USER_MEASURE1 NUMBER

User measure identifier
USER_MEASURE2 NUMBER

User measure identifier
USER_MEASURE3 NUMBER

User measure identifier
USER_MEASURE4 NUMBER

User measure identifier
USER_MEASURE5 NUMBER

User measure identifier
PAYMENT_TERM_FK_KEY NUMBER

System generated foreign key to payment terms dimension
AR_DOC_NUM_FK_KEY NUMBER

System generated foreign key to Receivables Document Number dimension
AR_TRX_TYPE_FK_KEY NUMBER

System generated foreign key to Receivables Transaction type dimension
CAMPAIGN_ACTL_FK_KEY NUMBER

System generated foreign key to Campaign dimension
CELL_ACTL_FK_KEY NUMBER

System generated foreign key to Target Segment dimension
EVENT_OFFER_ACTL_FK_KEY NUMBER

System generated foreign key to Event dimension
EVENT_OFFER_REG_FK_KEY NUMBER

System generated foreign key to Event dimension
SOURCE_LIST_FK_KEY NUMBER

System generated foreign key to Source List dimension
MEDIA_ACTL_FK_KEY NUMBER

System generated foreign key to Media Channel dimension
MARKET_SEGMENT_FK_KEY NUMBER

System generated foreign key to Market Segment dimension
OFFER_ACTL_FK_KEY NUMBER

System generated foreign key to Offer dimension
SALESCHANNEL_FK_KEY NUMBER

System generated foreign key to Sales Channel dimension
BASE_CURRENCY_FK_KEY NUMBER

System generated foreign key to Currency dimension
TRX_CURRENCY_FK_KEY NUMBER

System generated foreign key to Currency dimension
BILL_TO_SITE_FK_KEY NUMBER

System generated foreign key to Geography dimension
SHIP_TO_SITE_FK_KEY NUMBER

System generated foreign key to Geography dimension
GL_SET_OF_BOOKS_FK_KEY NUMBER

System generated foreign key to Set of Books dimension
GL_ACCT10_FK_KEY NUMBER

Foreign key to Accounting Flexfield Dimension
GL_ACCT1_FK_KEY NUMBER

Foreign key to Accounting Flexfield Dimension
GL_ACCT2_FK_KEY NUMBER

Foreign key to Accounting Flexfield Dimension
GL_ACCT3_FK_KEY NUMBER

Foreign key to Accounting Flexfield Dimension
GL_ACCT4_FK_KEY NUMBER

Foreign key to Accounting Flexfield Dimension
GL_ACCT5_FK_KEY NUMBER

Foreign key to Accounting Flexfield Dimension
GL_ACCT6_FK_KEY NUMBER

Foreign key to Accounting Flexfield Dimension
GL_ACCT7_FK_KEY NUMBER

Foreign key to Accounting Flexfield Dimension
GL_ACCT8_FK_KEY NUMBER

Foreign key to Accounting Flexfield Dimension
GL_ACCT9_FK_KEY NUMBER

Foreign key to Accounting Flexfield Dimension
SALESREP_FK_KEY NUMBER

System generated foreign key to Person dimension
INSTANCE_FK_KEY NUMBER

System generated foreign key to Instance dimension
ITEM_FK_KEY NUMBER

System generated foreign key to Item dimension
PARENT_ITEM_FK_KEY NUMBER

System generated foreign key to Item dimension
UOM_FK_KEY NUMBER

System generated foreign key to Unit of Measure dimension
ORGANIZATION_FK_KEY NUMBER

System generated foreign key to Internal Organization dimension
PROJECT_FK_KEY NUMBER

System generated foreign key to Project dimension
REVENUE_SOURCE_FK_KEY NUMBER

System generated foreign key to Consolidated Revenue Source dimension
SIC_CODE_FK_KEY NUMBER

System generated foreign key to Standard Industry Code dimension
GL_PERIOD_FK_KEY NUMBER

System generated foreign key to Time dimension
BILL_TO_CUSTOMER_FK_KEY NUMBER

System generated foreign key to Trading Partner dimension
SHIP_TO_CUSTOMER_FK_KEY NUMBER

System generated foreign key to Trading Partner dimension
SOLD_TO_CUSTOMER_FK_KEY NUMBER

System generated foreign key to Trading Partner dimension
CAMPAIGN_INIT_FK_KEY NUMBER

System generated foreign key to Campaign dimension
CELL_INIT_FK_KEY NUMBER

System generated foreign key to Target Segment dimension
EVENT_OFFER_INIT_FK_KEY NUMBER

System generated foreign key to Event dimension
MEDIA_INIT_FK_KEY NUMBER

System generated foreign key to Media Channel dimension
OFFER_INIT_FK_KEY NUMBER

System generated foreign key to Offer dimension
LINE_QTY_CREDITED NUMBER

Quantity credited
LINE_QTY_INVOICED NUMBER

Quantity of invoice line
LINE_QTY_ORDERED NUMBER

Quantity of an order
PROD_LINE_QTY_CREDITED NUMBER

Product line credited quantity
PROD_LINE_QTY_INVOICED NUMBER

Product line invoiced quantity
AMT_B NUMBER

Amount of this record in the functional currency
AMT_G NUMBER

Amount of this record in the warehouse global currency
AMT_T NUMBER

Amount of this record in the foreign currency
PROD_AMT_B NUMBER

Product amount of this record in the functional currency
PROD_AMT_G NUMBER

Product amount of this record in the warehouse global currency
PROD_AMT_T NUMBER

Product amount of this record in the foreign currency
ACCOUNT_CLASS VARCHAR2 (40)
Account type
AGREEMENT_TYPE VARCHAR2 (40)
Code used to group agreements for reporting
CREATED_FROM VARCHAR2 (30)
This column indicates where this record was created. It could have values like RAXTRX (AutoInvoice), RAXMATRX (Transactions window), ARXMAECM (Credit Memos window), EARLY_REL10 (pre-production version of r10), FORM_REL9 (r9 form) etc.
DOC_REASON_CODE VARCHAR2 (40)
Reason code identifier
EDI_PROC_FLAG VARCHAR2 (20)
Y or N indicates whether this invoice was processed by EDI
EX_RATE_TYPE VARCHAR2 (40)
Exchange rate type
INSTANCE VARCHAR2 (40)
Instance identifier
INV_COMMENT VARCHAR2 (240)
Not currently used
JE_DESCRIPTION VARCHAR2 (240)
Journal Entry Description
JE_LINE_DESC VARCHAR2 (240)
Journal entry line description
JE_NAME VARCHAR2 (120)
Journal entry header name
LINE_TYPE VARCHAR2 (40)
Receivables lookup code for STD_LINE_TYPE
ORDER_LINE_ID VARCHAR2 (40)
Sales order line
ORDER_NUMBER VARCHAR2 (40)
Sales Order
REASON_CODE VARCHAR2 (40)
Reason code identifier
REVENUE_PK VARCHAR2 (120)
Revenue identifier
TRX_NUMBER VARCHAR2 (40)
Transaction number
USER_ATTRIBUTE1 VARCHAR2 (240)
User attribute value
USER_ATTRIBUTE2 VARCHAR2 (240)
User attribute value
USER_ATTRIBUTE3 VARCHAR2 (240)
User attribute value
USER_ATTRIBUTE4 VARCHAR2 (240)
User attribute value
USER_ATTRIBUTE5 VARCHAR2 (240)
User attribute value
SOLD_TO_SITE_FK_KEY NUMBER

System generated foreign key to Geography dimension
USER_ATTRIBUTE10 VARCHAR2 (240)
User attribute value
USER_ATTRIBUTE11 VARCHAR2 (240)
User attribute value
USER_ATTRIBUTE12 VARCHAR2 (240)
User attribute value
USER_ATTRIBUTE13 VARCHAR2 (240)
User attribute value
USER_ATTRIBUTE14 VARCHAR2 (240)
User attribute value
USER_ATTRIBUTE15 VARCHAR2 (240)
User attribute value
USER_ATTRIBUTE6 VARCHAR2 (240)
User attribute value
USER_ATTRIBUTE7 VARCHAR2 (240)
User attribute value
USER_ATTRIBUTE8 VARCHAR2 (240)
User attribute value
USER_ATTRIBUTE9 VARCHAR2 (240)
User attribute value
USER_ATTRIBUTE16 VARCHAR2 (240)
User defined attribute
USER_ATTRIBUTE17 VARCHAR2 (240)
User defined attribute
USER_ATTRIBUTE18 VARCHAR2 (240)
User defined attribute
USER_ATTRIBUTE19 VARCHAR2 (240)
User defined attribute
USER_ATTRIBUTE20 VARCHAR2 (240)
User defined attribute
USER_ATTRIBUTE21 VARCHAR2 (240)
User defined attribute
USER_ATTRIBUTE22 VARCHAR2 (240)
User defined attribute
USER_ATTRIBUTE23 VARCHAR2 (240)
User defined attribute
USER_ATTRIBUTE24 VARCHAR2 (240)
User defined attribute
USER_ATTRIBUTE25 VARCHAR2 (240)
User defined attribute
CREATION_DATE DATE

Standard who column - date when this row was created.
EXCHANGE_DATE DATE

Date of the exchange rate
GL_POSTED_DATE DATE

Date posted
INVOICE_DATE DATE

Invoice date
LAST_UPDATE_DATE DATE

Standard Who column - date when a user last updated this row.
PRIM_SALESREP_FK_KEY NUMBER

System generated key for Primary sales
CAMPAIGN_STATUS_ACTL_FK_KEY NUMBER

System generated foreign key to campaign status
CAMPAIGN_STATUS_INIT_FK_KEY NUMBER

System generated foreign key to campaign status
Query Text

Cut, paste (and edit) the following text to query this object:


SELECT AGREEMENT_ID
,      BATCH_ID
,      CCID
,      CUST_TRX_LINE_ID
,      DOC_LINE_NUM
,      EXCHANGE_RATE
,      REVENUE_PK_KEY
,      UNIT_SELLING_PRICE
,      UNIT_STAN_PRICE
,      USER_FK1_KEY
,      USER_FK2_KEY
,      USER_FK3_KEY
,      USER_FK4_KEY
,      USER_FK5_KEY
,      USER_MEASURE1
,      USER_MEASURE2
,      USER_MEASURE3
,      USER_MEASURE4
,      USER_MEASURE5
,      PAYMENT_TERM_FK_KEY
,      AR_DOC_NUM_FK_KEY
,      AR_TRX_TYPE_FK_KEY
,      CAMPAIGN_ACTL_FK_KEY
,      CELL_ACTL_FK_KEY
,      EVENT_OFFER_ACTL_FK_KEY
,      EVENT_OFFER_REG_FK_KEY
,      SOURCE_LIST_FK_KEY
,      MEDIA_ACTL_FK_KEY
,      MARKET_SEGMENT_FK_KEY
,      OFFER_ACTL_FK_KEY
,      SALESCHANNEL_FK_KEY
,      BASE_CURRENCY_FK_KEY
,      TRX_CURRENCY_FK_KEY
,      BILL_TO_SITE_FK_KEY
,      SHIP_TO_SITE_FK_KEY
,      GL_SET_OF_BOOKS_FK_KEY
,      GL_ACCT10_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
,      SALESREP_FK_KEY
,      INSTANCE_FK_KEY
,      ITEM_FK_KEY
,      PARENT_ITEM_FK_KEY
,      UOM_FK_KEY
,      ORGANIZATION_FK_KEY
,      PROJECT_FK_KEY
,      REVENUE_SOURCE_FK_KEY
,      SIC_CODE_FK_KEY
,      GL_PERIOD_FK_KEY
,      BILL_TO_CUSTOMER_FK_KEY
,      SHIP_TO_CUSTOMER_FK_KEY
,      SOLD_TO_CUSTOMER_FK_KEY
,      CAMPAIGN_INIT_FK_KEY
,      CELL_INIT_FK_KEY
,      EVENT_OFFER_INIT_FK_KEY
,      MEDIA_INIT_FK_KEY
,      OFFER_INIT_FK_KEY
,      LINE_QTY_CREDITED
,      LINE_QTY_INVOICED
,      LINE_QTY_ORDERED
,      PROD_LINE_QTY_CREDITED
,      PROD_LINE_QTY_INVOICED
,      AMT_B
,      AMT_G
,      AMT_T
,      PROD_AMT_B
,      PROD_AMT_G
,      PROD_AMT_T
,      ACCOUNT_CLASS
,      AGREEMENT_TYPE
,      CREATED_FROM
,      DOC_REASON_CODE
,      EDI_PROC_FLAG
,      EX_RATE_TYPE
,      INSTANCE
,      INV_COMMENT
,      JE_DESCRIPTION
,      JE_LINE_DESC
,      JE_NAME
,      LINE_TYPE
,      ORDER_LINE_ID
,      ORDER_NUMBER
,      REASON_CODE
,      REVENUE_PK
,      TRX_NUMBER
,      USER_ATTRIBUTE1
,      USER_ATTRIBUTE2
,      USER_ATTRIBUTE3
,      USER_ATTRIBUTE4
,      USER_ATTRIBUTE5
,      SOLD_TO_SITE_FK_KEY
,      USER_ATTRIBUTE10
,      USER_ATTRIBUTE11
,      USER_ATTRIBUTE12
,      USER_ATTRIBUTE13
,      USER_ATTRIBUTE14
,      USER_ATTRIBUTE15
,      USER_ATTRIBUTE6
,      USER_ATTRIBUTE7
,      USER_ATTRIBUTE8
,      USER_ATTRIBUTE9
,      USER_ATTRIBUTE16
,      USER_ATTRIBUTE17
,      USER_ATTRIBUTE18
,      USER_ATTRIBUTE19
,      USER_ATTRIBUTE20
,      USER_ATTRIBUTE21
,      USER_ATTRIBUTE22
,      USER_ATTRIBUTE23
,      USER_ATTRIBUTE24
,      USER_ATTRIBUTE25
,      CREATION_DATE
,      EXCHANGE_DATE
,      GL_POSTED_DATE
,      INVOICE_DATE
,      LAST_UPDATE_DATE
,      PRIM_SALESREP_FK_KEY
,      CAMPAIGN_STATUS_ACTL_FK_KEY
,      CAMPAIGN_STATUS_INIT_FK_KEY
FROM FII.FII_E_REVENUE_F;

Dependencies

[top of page]

FII.FII_E_REVENUE_F does not reference any database object

FII.FII_E_REVENUE_F is referenced by following:

SchemaAPPS
SynonymFII_E_REVENUE_F