[Home] [Help] [Dependency Information]
Object Name: | FII_AR_CASH_FSTG |
---|---|
Object Type: | TABLE |
Owner: | FII |
FND Design Data: | FII.FII_AR_CASH_FSTG |
Subobject Name: | |
Status: | VALID |
Oracle Corporation does not support access to Oracle
applications data using this object, except from standard Oracle Applications programs.
Tablespace: | APPS_TS_INTERFACE |
---|---|
PCT Free: | 10 |
PCT Used: |
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 |
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;
FII.FII_AR_CASH_FSTG does not reference any database object
FII.FII_AR_CASH_FSTG is referenced by following:
|
|
|