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

TABLE: FII.FII_AR_CASH_FSTG

Object Details
Object Name: FII_AR_CASH_FSTG
Object Type: TABLE
Owner: FII
FND Design Data: TableFII.FII_AR_CASH_FSTG
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_INTERFACE
PCT Free: 10
PCT Used:
Columns
Name Datatype Length Mandatory 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
CASH_B NUMBER

Amount of cash received in functional currency
CASH_G NUMBER

Amount of cash received in global currency
RECEIPT_CNT NUMBER

Number of cash receipts
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
,      CASH_B
,      CASH_G
,      RECEIPT_CNT
FROM FII.FII_AR_CASH_FSTG;

Dependencies

[top of page]

FII.FII_AR_CASH_FSTG does not reference any database object

FII.FII_AR_CASH_FSTG is referenced by following:

SchemaAPPS
SynonymFII_AR_CASH_FSTG