eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

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

TABLE: FII.FII_AR_REVENUE_B

Object Details

Object Name:	FII_AR_REVENUE_B
Object Type:	TABLE
Owner:	FII
FND Design Data:	FII.FII_AR_REVENUE_B
Subobject Name:
Status:	VALID

Base table that contains revenue information from Oracle Receivables for the Profit and Loss Pages.

Storage Details

Tablespace:	APPS_TS_SUMMARY
PCT Free:	10
PCT Used:

Indexes

Index	Type	Uniqueness	Tablespace	Column
FII_AR_REVENUE_B_U1	NORMAL	UNIQUE	APPS_TS_SUMMARY	REVENUE_PK
FII_AR_REVENUE_B_N1	NORMAL	NONUNIQUE	APPS_TS_SUMMARY	COST_CENTER_ID COMPANY_ID GL_DATE
FII_AR_REVENUE_B_N2	NORMAL	NONUNIQUE	APPS_TS_SUMMARY	CHILD_ORDER_LINE_ID

Columns

Name	Datatype	Length	Comments
REVENUE_PK	VARCHAR2	(80)	Developer primary key
SET_OF_BOOKS_ID	NUMBER	(10)	No longer used.
OPERATING_UNIT_ID	NUMBER	(15)	Operating Unit (Org) identifier
PROD_CATEGORY_ID	NUMBER		Product Category identifier
COMPANY_COST_CENTER_ORG_ID	NUMBER	(15)	No longer used - Cost Center Org identifier
CHART_OF_ACCOUNTS_ID	NUMBER	(15)	Key flexfield structure defining column
ORGANIZATION_ID	NUMBER		Manufacturing warehouse identifier
INVOICE_ID	NUMBER		Invoice identifier
INVOICE_LINE_ID	NUMBER		Invoice line identifier
TOP_MODEL_ITEM_ID	NUMBER		Top model item identifier
INVENTORY_ITEM_ID	NUMBER		Item identifier
ORDER_LINE_ID	NUMBER		Order line identifier
BILL_TO_PARTY_ID	NUMBER		Bill to customer identifier
GL_DATE_ID	NUMBER		Foreign key to time dimension. Julian representation of the date revenue was recognized in General Ledger
GL_DATE	DATE		General ledger date
SALES_CHANNEL	VARCHAR2	(30)	Sales channel
INVOICE_NUMBER	VARCHAR2	(30)	Invoice number. Populated only for revenue billed through the receivable system
ORDER_NUMBER	VARCHAR2	(30)	Sales order number. Populated only for revenue which originated from the order entry system
TRANSACTION_CLASS	VARCHAR2	(3)	Type of Invoice like Standard Invoice, Credit Memo, Debit Memo, ... etc
FUNCTIONAL_CURRENCY	VARCHAR2	(15)	Functional currency code
TRANSACTION_CURRENCY	VARCHAR2	(15)	Transaction currency code
AMOUNT_T	NUMBER		Revenue amount in transaction currecny
AMOUNT_B	NUMBER		Revenue amount in functional currency
PRIM_AMOUNT_G	NUMBER		Revenue amount in primary global currency
SEC_AMOUNT_G	NUMBER		Revenue amount in secondary global currency
POSTED_FLAG	VARCHAR2	(1)	Indicate if the revenue has been posted to the general ledger
LAST_UPDATE_DATE	DATE		Standard Who column - date when a user last updated this row.
LAST_UPDATED_BY	NUMBER	(15)	Standard who column - user who last updated this row (foreign key to FND_USER.USER_ID).
CREATION_DATE	DATE		Standard who column - date when this row was created.
CREATED_BY	NUMBER	(15)	Standard who column - user who created this row (foreign key to FND_USER.USER_ID).
LAST_UPDATE_LOGIN	NUMBER	(15)	Standard who column - operating system login of user who last updated this row (foreign key to FND_LOGINS.LOGIN_ID).
UPDATE_SEQUENCE	NUMBER		Sequence to identify duplicate invoices
INVOICE_DATE	DATE		Invoice Date
FIN_CATEGORY_ID	NUMBER	(15)	Financial Category Identifier
COMPANY_ID	NUMBER	(15)	Company Identifier
COST_CENTER_ID	NUMBER	(15)	Cost Center Identifier
FIN_CAT_TYPE_CODE	VARCHAR2	(30)	Financial Category Type Code
ITEM_ORGANIZATION_ID	NUMBER	(15)	Item Organization ID
OM_PRODUCT_REVENUE_FLAG	VARCHAR2	(1)	OM product revenue flag
REV_BOOKED_DATE	DATE		Revenue Booked Date
CHILD_ORDER_LINE_ID	VARCHAR2	(30)	Child Order Line Identifier
LEDGER_ID	NUMBER	(10)	Ledger Identifier

Query Text

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


SELECT REVENUE_PK
,      SET_OF_BOOKS_ID
,      OPERATING_UNIT_ID
,      PROD_CATEGORY_ID
,      COMPANY_COST_CENTER_ORG_ID
,      CHART_OF_ACCOUNTS_ID
,      ORGANIZATION_ID
,      INVOICE_ID
,      INVOICE_LINE_ID
,      TOP_MODEL_ITEM_ID
,      INVENTORY_ITEM_ID
,      ORDER_LINE_ID
,      BILL_TO_PARTY_ID
,      GL_DATE_ID
,      GL_DATE
,      SALES_CHANNEL
,      INVOICE_NUMBER
,      ORDER_NUMBER
,      TRANSACTION_CLASS
,      FUNCTIONAL_CURRENCY
,      TRANSACTION_CURRENCY
,      AMOUNT_T
,      AMOUNT_B
,      PRIM_AMOUNT_G
,      SEC_AMOUNT_G
,      POSTED_FLAG
,      LAST_UPDATE_DATE
,      LAST_UPDATED_BY
,      CREATION_DATE
,      CREATED_BY
,      LAST_UPDATE_LOGIN
,      UPDATE_SEQUENCE
,      INVOICE_DATE
,      FIN_CATEGORY_ID
,      COMPANY_ID
,      COST_CENTER_ID
,      FIN_CAT_TYPE_CODE
,      ITEM_ORGANIZATION_ID
,      OM_PRODUCT_REVENUE_FLAG
,      REV_BOOKED_DATE
,      CHILD_ORDER_LINE_ID
,      LEDGER_ID
FROM FII.FII_AR_REVENUE_B;

Dependencies

[top of page]

FII.FII_AR_REVENUE_B does not reference any database object

FII.FII_AR_REVENUE_B is referenced by following:

APPS: BIM_SGMT_VAL_B_MV; ENI_DBI_AR_BASE_MV; FII_AR_REVENUE_B; FII_AR_REV_SUM_MV; ISC_DBI_SCR_000_MV