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: JA.JA_CN_ACCOUNT_BALANCES_GT

Object Details

Object Name:	JA_CN_ACCOUNT_BALANCES_GT
Object Type:	TABLE
Owner:	JA
FND Design Data:	JA.JA_CN_ACCOUNT_BALANCES_GT
Subobject Name:
Status:	VALID

JA_CN_ACCOUNT_BALANCES_GT is a session level global temporary table which stores combined account balances before they are exported to flat file.

Temporary Table Details

JA.JA_CN_ACCOUNT_BALANCES_GT is a global temporary table. The current session is able see data that it placed in the table but other sessions cannot. Data in the table is temporary. It has a data duration of SYS$SESSION. Data is removed at the end of this period.

Storage Details

Tablespace:
PCT Free:	10
PCT Used:	40

Indexes

Index	Type	Uniqueness	Tablespace	Column
JA_CN_ACCOUNT_BALANCES_GT_N1	NORMAL	NONUNIQUE		START_DATE ACCOUNT_SEGMENT PROJECT_NUMBER THIRD_PARTY_NUMBER COST_CENTER PERSONNEL_NUMBER

Columns

Name	Datatype	Length	Mandatory	Comments
ACCOUNT_SEGMENT	VARCHAR2	(150)	Yes	Nature account number
CURRENCY_CODE	VARCHAR2	(80)	Yes	Currency
FUNC_BEGIN_BALANCE	NUMBER			Beginning balance, base currency
ORIG_BEGIN_BALANCE	NUMBER			Beginning balance, original currency
FUNC_PERIOD_NET_DR	NUMBER			Period net debit balance, base currency
FUNC_PERIOD_NET_CR	NUMBER			Period net credit balance, base currency
ORIG_PERIOD_NET_DR	NUMBER			Period net debit balance, original currency
ORIG_PERIOD_NET_CR	NUMBER			Period net credit balance, original currency
FUNC_END_BALANCE	NUMBER			Ending balance, base currency
ORIG_END_BALANCE	NUMBER			Ending balance, original currency
PERIOD_MON	NUMBER		Yes	The month of current period in two digits numbering format.
COST_CENTER	VARCHAR2	(100)		Cost center segment
THIRD_PARTY_NUMBER	VARCHAR2	(300)		Number of third party, such as customer name or vender name
PERSONNEL_NUMBER	VARCHAR2	(300)		Personnel number
PROJECT_NUMBER	VARCHAR2	(100)		Number of project. If "Project" is defined as "Chart of account", value of project segment
HAS_THIRD_PARTY	VARCHAR2	(240)		'S'or 'C' indicates whether this natural account has third party subsidiary of supplier or customer.
HAS_COST_CENTER	VARCHAR2	(240)		'Y'or 'N' indicates whether this natural account has cost center subsidiary.
HAS_PERSONNEL	VARCHAR2	(240)		'Y'or 'N' indicates whether this natural account has personnel subsidiary.
HAS_PROJECT	VARCHAR2	(240)		'Y'or 'N' indicates whether this natural account has project subsidiary.
ACCOUNT_TYPE	VARCHAR2	(1)		Account type
IS_FOREIGN	VARCHAR2	(240)		Currency name of the account
BALANCE_SIDE	VARCHAR2	(240)		Balance side
ACCOUNT_LEVEL	VARCHAR2	(240)		Account level
PERIOD_NAME	VARCHAR2	(15)	Yes	Period name
START_DATE	DATE		Yes	Start date

Query Text

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


SELECT ACCOUNT_SEGMENT
,      CURRENCY_CODE
,      FUNC_BEGIN_BALANCE
,      ORIG_BEGIN_BALANCE
,      FUNC_PERIOD_NET_DR
,      FUNC_PERIOD_NET_CR
,      ORIG_PERIOD_NET_DR
,      ORIG_PERIOD_NET_CR
,      FUNC_END_BALANCE
,      ORIG_END_BALANCE
,      PERIOD_MON
,      COST_CENTER
,      THIRD_PARTY_NUMBER
,      PERSONNEL_NUMBER
,      PROJECT_NUMBER
,      HAS_THIRD_PARTY
,      HAS_COST_CENTER
,      HAS_PERSONNEL
,      HAS_PROJECT
,      ACCOUNT_TYPE
,      IS_FOREIGN
,      BALANCE_SIDE
,      ACCOUNT_LEVEL
,      PERIOD_NAME
,      START_DATE
FROM JA.JA_CN_ACCOUNT_BALANCES_GT;

Dependencies

[top of page]

JA.JA_CN_ACCOUNT_BALANCES_GT does not reference any database object

JA.JA_CN_ACCOUNT_BALANCES_GT is referenced by following:

APPS: JA_CN_ACCOUNT_BALANCES_GT