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_BALANCES

Object Details

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

This table stores accounting subledger balance information for
control accounts.
For every application and set of books, it includes a row for every
period, control account and third party suborganization.
UPDATED_FLAG is set to 'Y' to mark the balance information when the
period net amounts are modified; this means that the period end
amounts in the following periods need to be recalculated. No row in
AX_BALANCES should contain a 'Y' after the balance calculation
completes successfully.
HISTORIC_BALANCE is set to 'H' for a historic balance, 'P' for a purged
balance, and 'N' for other balances. Historic balances are balances
entered initially before using the Global Accounting Engine. Such
balances are not modified or deleted by Global Accounting Engine.
Purged balances are balances within a period for which the accounting
entries have been purged. They are marked with a 'P' so that they will
not be deleted by the Balance Synchronization program when the accounting
entries no longer exist.
BALANCE_SEGMENT and ACCOUNT_SEGMENT are a denormalization of the
column CODE_COMBINATION_ID containing respectively the balancing
and accounting segment of the key flexfield. The denormalization is
used as most of the reports group their result using these values.
For a balance calculation that includes year-end periods, a carry
forward balance is automatically created with the special period name
'NET-XXXX', where XXXX is the fiscal year. This NET balance is the
difference between the year's total debits and credits. The balance
is stored as a positive amount in either the END_BALANCE_DR or
END_BALANCE_CR column, but not both.
Note that this is not a partitioned table and that the column ORG_ID
is not used.

Storage Details

Tablespace:	APPS_TS_TX_DATA
PCT Free:	10
PCT Used:

Primary Key: AX_BALANCES_PK

SET_OF_BOOKS_ID
APPLICATION_ID
CODE_COMBINATION_ID
PERIOD_NAME
THIRD_PARTY_ID
SUB_ID

Indexes

Index	Type	Uniqueness	Tablespace	Column
AX_BALANCES_U1	NORMAL	UNIQUE	APPS_TS_TX_IDX	SET_OF_BOOKS_ID APPLICATION_ID CODE_COMBINATION_ID PERIOD_NAME THIRD_PARTY_ID SUB_ID
AX_BALANCES_N2	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	THIRD_PARTY_ID CODE_COMBINATION_ID SET_OF_BOOKS_ID
AX_BALANCES_N3	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	APPLICATION_ID SET_OF_BOOKS_ID PERIOD_NAME THIRD_PARTY_ID SUB_ID BALANCE_SEGMENT ACCOUNT_SEGMENT
AX_BALANCES_N4	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	SET_OF_BOOKS_ID APPLICATION_ID BALANCE_SEGMENT ACCOUNT_SEGMENT THIRD_PARTY_ID SUB_ID CODE_COMBINATION_ID

Columns

Name	Datatype	Length	Mandatory	Comments
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_ID	NUMBER			Standard Who column
PROGRAM_UPDATE_DATE	DATE			Standard Who column
SET_OF_BOOKS_ID	NUMBER		Yes	Posting set of books identifier
APPLICATION_ID	NUMBER		Yes	Application identifier
CODE_COMBINATION_ID	NUMBER		Yes	Code combination identifier
THIRD_PARTY_ID	NUMBER		Yes	Third party identifier
SUB_ID	NUMBER		Yes	Third party suborganization identifier
PERIOD_NAME	VARCHAR2	(30)	Yes	Period name
PERIOD_NET_DR	NUMBER			Debit activity for the period
PERIOD_NET_CR	NUMBER			Credit activity for the period
END_BALANCE_DR	NUMBER			Running debit balance for the fiscal year up to the end of the period. If period name starts with 'NET-', then it is the carry forward debit amount to the next fiscal year
END_BALANCE_CR	NUMBER			Running credit balance for the fiscal year up to the end of the period. If period name starts with 'NET-', then it is the carry forward credit amount to the next fiscal year
ORG_ID	NUMBER			Not used
PERIOD_HISTORY_NUM	NUMBER			The period status history number at the balance creation (no longer used)
UPDATED_FLAG	VARCHAR2	(1)		Updated flag
HISTORIC_BALANCE	VARCHAR2	(1)		Balance classification (P for purged, H for historic balance)
BALANCE_SEGMENT	VARCHAR2	(25)		Balancing segment value
ACCOUNT_SEGMENT	VARCHAR2	(25)		Balancing segment value

Query Text

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


SELECT LAST_UPDATE_DATE
,      LAST_UPDATED_BY
,      CREATION_DATE
,      CREATED_BY
,      LAST_UPDATE_LOGIN
,      REQUEST_ID
,      PROGRAM_APPLICATION_ID
,      PROGRAM_ID
,      PROGRAM_UPDATE_DATE
,      SET_OF_BOOKS_ID
,      APPLICATION_ID
,      CODE_COMBINATION_ID
,      THIRD_PARTY_ID
,      SUB_ID
,      PERIOD_NAME
,      PERIOD_NET_DR
,      PERIOD_NET_CR
,      END_BALANCE_DR
,      END_BALANCE_CR
,      ORG_ID
,      PERIOD_HISTORY_NUM
,      UPDATED_FLAG
,      HISTORIC_BALANCE
,      BALANCE_SEGMENT
,      ACCOUNT_SEGMENT
FROM AX.AX_BALANCES;

Dependencies

[top of page]

AX.AX_BALANCES does not reference any database object

AX.AX_BALANCES is referenced by following:

APPS: AX_BALANCES