[Home] [Help] [Dependency Information]
Object Name: | AX_SETUP_BOOKS |
---|---|
Object Type: | TABLE |
Owner: | AX |
FND Design Data: | AX.AX_SETUP_BOOKS |
Subobject Name: | |
Status: | VALID |
This table stores setup parameters at the set of books level. The information is stored through the Subledger Setup screen.
Tablespace: | APPS_TS_TX_DATA |
---|---|
PCT Free: | 10 |
PCT Used: |
Index | Type | Uniqueness | Tablespace | Column |
---|---|---|---|---|
AX_SETUP_BOOKS_U1 | NORMAL | UNIQUE | APPS_TS_TX_IDX | SET_OF_BOOKS_ID |
Table | |
Foreign Table | Foreign Key Column | AX_SETUP_SUBLEDGERS | AX_SETUP_BOOKS | AX_SETUP_SUBLEDGERS MAIN_SET_OF_BOOKS_ID |
---|
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
SET_OF_BOOKS_ID | NUMBER | Yes | Set of Books ID | |
GL_SEQUENCING_FLAG | VARCHAR2 | (1) | GL Sequencing Flag | |
LEGAL_SEQUENCING_MODE | VARCHAR2 | (30) | Legal Sequencing Mode | |
CREATION_DATE | DATE | Standard Who column | ||
CREATED_BY | NUMBER | Standard Who column | ||
LAST_UPDATE_DATE | DATE | Standard Who column | ||
LAST_UPDATED_BY | NUMBER | Standard Who column | ||
LAST_UPDATE_LOGIN | NUMBER | Standard Who column | ||
CATEGORY_CODE | VARCHAR2 | (30) | Category Code used by the Journal Sequencing Program. | |
FISCAL_SEGMENT_VALUE_LOW | VARCHAR2 | (25) | Lowest balancing segment value considered by the Journal Sequencing Program. | |
FISCAL_SEGMENT_VALUE_HIGH | VARCHAR2 | (25) | Highest balancing segment value considered by the Journal Sequencing Program. |
Cut, paste (and edit) the following text to query this object:
SELECT SET_OF_BOOKS_ID
, GL_SEQUENCING_FLAG
, LEGAL_SEQUENCING_MODE
, CREATION_DATE
, CREATED_BY
, LAST_UPDATE_DATE
, LAST_UPDATED_BY
, LAST_UPDATE_LOGIN
, CATEGORY_CODE
, FISCAL_SEGMENT_VALUE_LOW
, FISCAL_SEGMENT_VALUE_HIGH
FROM AX.AX_SETUP_BOOKS;
AX.AX_SETUP_BOOKS does not reference any database object
AX.AX_SETUP_BOOKS is referenced by following:
|
|
|