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_REC_FSTG

Object Details

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

This staging table holds information on AR receipts. It is used to support Order to Cash portlets.

Storage Details

Tablespace:	APPS_TS_INTERFACE
PCT Free:	10
PCT Used:

Columns

Name	Datatype	Length	Comments
SET_OF_BOOKS_ID	NUMBER		Functional currency of the given set of books
CUSTOMER_FK	VARCHAR2	(85)	Foreign key to customer dimension
ORG_FK	VARCHAR2	(80)	Foreign Key to organization dimension
PERIOD_NAME	VARCHAR2	(15)	Name of accounting period for transaction
CALENDAR_DAY_FK	VARCHAR2	(120)	Foreign key to calender_day dimension
SET_OF_BOOKS_FK	VARCHAR2	(80)	Foreign Key to set_of_books dimension
INSTANCE	VARCHAR2	(30)	Instance where this record is from
BASE_CURRENCY	VARCHAR2	(10)	Functional currency for this transaction
GL_DATE	DATE		Actg. date of this record
REC_B	NUMBER		Amount of cash received in functional currency
REC_G	NUMBER		Amount of cash received in global currency
INV_CREATED_CNT	NUMBER		Number of invoice created

Query Text

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


SELECT SET_OF_BOOKS_ID
,      CUSTOMER_FK
,      ORG_FK
,      PERIOD_NAME
,      CALENDAR_DAY_FK
,      SET_OF_BOOKS_FK
,      INSTANCE
,      BASE_CURRENCY
,      GL_DATE
,      REC_B
,      REC_G
,      INV_CREATED_CNT
FROM FII.FII_AR_REC_FSTG;

Dependencies

[top of page]

FII.FII_AR_REC_FSTG does not reference any database object

FII.FII_AR_REC_FSTG is referenced by following:

APPS: FII_AR_REC_FSTG