eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

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

TABLE: AX.AX_SETUP_POSTING_BOOKS

Object Details

Object Name:	AX_SETUP_POSTING_BOOKS
Object Type:	TABLE
Owner:	AX
FND Design Data:	AX.AX_SETUP_POSTING_BOOKS
Subobject Name:
Status:	VALID

This table stores information about posting set of books for each main
set of books.
For each main set of books, it contains at least one row having
posting set of books equal to main set of books. If the main set of
books is a Multiple Reporting Currency book, then it also contains a
row for each reporting set of books.
RULE_NAME contains the name of the rules used by the subledger; it
can be null in a development environment where the rules are under
construction.
RULE_NAME is used instead of RULE_ID because this is keeping
historical information while editing rules. Rules could be discarded
losing the ID but this column should always keep track of the rules
that were used at load time.
The column RULE_CHANGED_FLAG is set to 'Y' by the Setup forms when
the user changes the rule set for a posting set of books. It is used
to identify the rule sets that need to be loaded.

Storage Details

Tablespace:	APPS_TS_TX_DATA
PCT Free:	10
PCT Used:

Primary Key: AX_SETUP_POSTING_BOOKS_PK

APPLICATION_ID
MAIN_SET_OF_BOOKS_ID
SOURCE_ORG_ID
POSTING_SET_OF_BOOKS_ID

Indexes

Index	Type	Uniqueness	Tablespace	Column
AX_SETUP_POSTING_BOOKS_U1	NORMAL	UNIQUE	APPS_TS_TX_IDX	APPLICATION_ID MAIN_SET_OF_BOOKS_ID SOURCE_ORG_ID POSTING_SET_OF_BOOKS_ID

Foreign Keys

Table		Foreign Table	Foreign Key Column
AX_SETUP_POSTING_BOOKS		AX_SETUP_SUBLEDGERS	AX_SETUP_POSTING_BOOKS APPLICATION_ID AX_SETUP_POSTING_BOOKS MAIN_SET_OF_BOOKS_ID

Columns

Name	Datatype	Length	Mandatory	Comments
PROGRAM_ID	NUMBER			Standard Who column
APPLICATION_ID	NUMBER		Yes	Application identifier
MAIN_SET_OF_BOOKS_ID	NUMBER		Yes	Main set of books identifier
SOURCE_ORG_ID	NUMBER		Yes	Organization identifier; 0 if no organization. Form displays 'All'
POSTING_SET_OF_BOOKS_ID	NUMBER		Yes	Posting set of books identifier
LAST_UPDATE_DATE	DATE		Yes	Standard Who column
LAST_UPDATED_BY	NUMBER		Yes	Standard Who column
CREATION_DATE	DATE		Yes	Standard Who column
CREATED_BY	NUMBER		Yes	Standard Who column
LAST_UPDATE_LOGIN	NUMBER			Standard Who column
REQUEST_ID	NUMBER			Standard Who column
PROGRAM_APPLICATION_ID	NUMBER			Standard Who column
PROGRAM_UPDATE_DATE	DATE			Standard Who column
RULE_NAME	VARCHAR2	(100)		Rule set used for this posting set of books
TRANSFER_TO_GL	VARCHAR2	(1)	Yes	Default for Submit Posting Manager Form
JE_LINE_TYPE	VARCHAR2	(30)	Yes	Default for Submit Posting Manager Form
EZL_REQUIRED	VARCHAR2	(1)	Yes	Default for Submit Posting Manager Form
ERROR_TO_SUSPENSE_ACCNT	VARCHAR2	(1)	Yes	Default for Submit Posting Manager Form
GL_POST_REQUIRED	VARCHAR2	(1)	Yes	Default for Submit Posting Manager Form
RULE_CHANGED_FLAG	VARCHAR2	(1)	Yes	'Y' if rules have been changed
RULE_SUB_VERSION	VARCHAR2	(30)		Reserved for a future Release
RULE_REVISION	VARCHAR2	(30)		Reserved for a future Release
DUAL_POSTING_CODE	VARCHAR2	(30)		Specify how the accounting combination are handled by the rules.
DUAL_POSTING_FLAG	VARCHAR2	(1)		Identify the type of the set of books (main, reporting, mrc reporting)
RULE_VERSION	VARCHAR2	(30)		Rule Version
PERIOD_FROM	NUMBER			Starting Period
PERIOD_TO	NUMBER			End Period
GL_CONSOLIDATION_ID	NUMBER			GL Consolidation identifier

Query Text

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


SELECT PROGRAM_ID
,      APPLICATION_ID
,      MAIN_SET_OF_BOOKS_ID
,      SOURCE_ORG_ID
,      POSTING_SET_OF_BOOKS_ID
,      LAST_UPDATE_DATE
,      LAST_UPDATED_BY
,      CREATION_DATE
,      CREATED_BY
,      LAST_UPDATE_LOGIN
,      REQUEST_ID
,      PROGRAM_APPLICATION_ID
,      PROGRAM_UPDATE_DATE
,      RULE_NAME
,      TRANSFER_TO_GL
,      JE_LINE_TYPE
,      EZL_REQUIRED
,      ERROR_TO_SUSPENSE_ACCNT
,      GL_POST_REQUIRED
,      RULE_CHANGED_FLAG
,      RULE_SUB_VERSION
,      RULE_REVISION
,      DUAL_POSTING_CODE
,      DUAL_POSTING_FLAG
,      RULE_VERSION
,      PERIOD_FROM
,      PERIOD_TO
,      GL_CONSOLIDATION_ID
FROM AX.AX_SETUP_POSTING_BOOKS;

Dependencies

[top of page]

AX.AX_SETUP_POSTING_BOOKS does not reference any database object

AX.AX_SETUP_POSTING_BOOKS is referenced by following:

APPS: AX_SETUP_POSTING_BOOKS