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

TABLE: AX.AX_SETUP_BOOKS

Object Details
Object Name: AX_SETUP_BOOKS
Object Type: TABLE
Owner: AX
FND Design Data: TableAX.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.


Storage Details
Tablespace: TablespaceAPPS_TS_TX_DATA
PCT Free: 10
PCT Used:
Primary Key: AX_SETUP_BOOKS_PK
  1. ColumnSET_OF_BOOKS_ID
Indexes
Index Type Uniqueness Tablespace Column
AX_SETUP_BOOKS_U1 NORMAL UNIQUE TablespaceAPPS_TS_TX_IDX ColumnSET_OF_BOOKS_ID
Foreign Keys
Table
Foreign Table Foreign Key Column
TableAX_SETUP_SUBLEDGERS AX_SETUP_SUBLEDGERS_FK1 AX_SETUP_BOOKS AX_SETUP_SUBLEDGERS MAIN_SET_OF_BOOKS_ID
Columns
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.
Query Text

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;

Dependencies

[top of page]

AX.AX_SETUP_BOOKS does not reference any database object

AX.AX_SETUP_BOOKS is referenced by following:

SchemaAX
ViewAX_SETUP_BOOKS#