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

TABLE: BIS.EDW_SET_OF_BOOKS

Object Details
Object Name: EDW_SET_OF_BOOKS
Object Type: TABLE
Owner: BIS
FND Design Data: TableBIS.EDW_SET_OF_BOOKS
TableFII.EDW_SET_OF_BOOKS
Subobject Name:
Status: VALID


This is the setup table used by accounting flexfield dimensions. This stores information about the sets of books you defined in your source instances. This table corresponds to the Source Set of Books Setup form.


Storage Details
Tablespace: TablespaceAPPS_TS_TX_DATA
PCT Free: 10
PCT Used:
Columns
Name Datatype Length Mandatory Comments
EDW_SET_OF_BOOKS_ID NUMBER (15)
System generated unique key
INSTANCE VARCHAR2 (30)
Source instance identifier
SET_OF_BOOKS_ID NUMBER (15)
Foreign key to GL_SETS_OF_BOOKS in source instance
SET_OF_BOOKS_NAME VARCHAR2 (30)
Accounting books name
CHART_OF_ACCOUNTS_ID NUMBER (15)
Key flexfield structure defining column
DESCRIPTION VARCHAR2 (240)
Accounting books description
CREATION_DATE DATE

Standard who column - date when this row was created.
CREATED_BY NUMBER

Standard who column - user who created this row (foreign key to FND_USER.USER_ID).
LAST_UPDATE_DATE DATE

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

Standard who column - user who last updated this row (foreign key to FND_USER.USER_ID).
LAST_UPDATE_LOGIN NUMBER

Standard who column - operating system login of user who last updated this row (foreign key to FND_LOGINS.LOGIN_ID).
Query Text

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


SELECT EDW_SET_OF_BOOKS_ID
,      INSTANCE
,      SET_OF_BOOKS_ID
,      SET_OF_BOOKS_NAME
,      CHART_OF_ACCOUNTS_ID
,      DESCRIPTION
,      CREATION_DATE
,      CREATED_BY
,      LAST_UPDATE_DATE
,      LAST_UPDATED_BY
,      LAST_UPDATE_LOGIN
FROM BIS.EDW_SET_OF_BOOKS;

Dependencies

[top of page]

BIS.EDW_SET_OF_BOOKS does not reference any database object

BIS.EDW_SET_OF_BOOKS is referenced by following:

SchemaAPPS
SynonymEDW_SET_OF_BOOKS