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

Object Details

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

The table 'JA_CN_ACCOUNT_BALANCES_GT' is a global temporary table used by posting journal to balance.

Storage Details

Tablespace:	APPS_TS_TX_DATA
PCT Free:	10
PCT Used:

Indexes

Index	Type	Uniqueness	Tablespace	Column
JA_CN_ACCOUNT_BALANCES_U1	NORMAL	UNIQUE	APPS_TS_TX_IDX	LEDGER_ID LEGAL_ENTITY_ID COMPANY_SEGMENT PERIOD_NAME CURRENCY_CODE COST_CENTER PROJECT_NUMBER PROJECT_SOURCE ACCOUNT_SEGMENT PERSONNEL_NUMBER THIRD_PARTY_TYPE THIRD_PARTY_ID SEGMENT1 SEGMENT2 SEGMENT3 SEGMENT4 SEGMENT5 SEGMENT6 SEGMENT7 SEGMENT8 SEGMENT9 SEGMENT10 SEGMENT11 SEGMENT12 SEGMENT13 SEGMENT14 SEGMENT15 SEGMENT16 SEGMENT17 SEGMENT18 SEGMENT19 SEGMENT20

Columns

Name	Datatype	Length	Mandatory	Comments
LEDGER_ID	NUMBER	(15)	Yes	Identifier of Ledger
LEGAL_ENTITY_ID	NUMBER	(15)	Yes	Identifier of Legal Entity
COMPANY_SEGMENT	VARCHAR2	(100)	Yes	Balance segment
PERIOD_NAME	VARCHAR2	(15)	Yes	Accounting period
CURRENCY_CODE	VARCHAR2	(15)	Yes	Currency
COST_CENTER	VARCHAR2	(100)		Cost center segment
THIRD_PARTY_TYPE	VARCHAR2	(1)		Source to indicate what type of the third party is, 'C' means 'Customer' and 'S' means 'Supplier'
THIRD_PARTY_ID	NUMBER			Identifier of third party, such as customer_id or vendor_id
THIRD_PARTY_NUMBER	VARCHAR2	(300)		Number of third party, such as customer name or vendor name
PROJECT_ID	NUMBER			Identifier of project
PROJECT_NUMBER	VARCHAR2	(150)		Number of project
PROJECT_SOURCE	VARCHAR2	(3)		Source of project. If "Project" is defined as "Chart of account", "COA". If "Project" is defined as "Project module", "PA"."
ACCOUNT_SEGMENT	VARCHAR2	(100)	Yes	Nature account number
PERSONNEL_ID	NUMBER			Identifier of personnel
PERSONNEL_NUMBER	VARCHAR2	(300)		Personnel number
FUNC_BEGIN_BALANCE_DR	NUMBER			Beginning debit balance, base currency
FUNC_BEGIN_BALANCE_CR	NUMBER			Beginning credit balance, base currency
ORIG_BEGIN_BALANCE_DR	NUMBER			Beginning debit balance, original currency
ORIG_BEGIN_BALANCE_CR	NUMBER			Beginning credit 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
PERIOD_MON	NUMBER		Yes	The month of current period in two digits numbering format.
CREATED_BY	NUMBER	(15)	Yes	Standard WHO column
CREATION_DATE	DATE		Yes	Standard WHO column
LAST_UPDATED_BY	NUMBER	(15)	Yes	Standard WHO column
LAST_UPDATE_DATE	DATE		Yes	Standard WHO column
LAST_UPDATE_LOGIN	NUMBER	(15)		Standard WHO column
ACCOUNT_TYPE	VARCHAR2	(1)		Nature account type, 'A' for 'Asset', 'C' for 'Budgetary (CR)', 'D' for 'Budgetary (DR)','E' for 'Expense', 'L' for 'Liability', 'O' for 'Ownership/Stockholder's Equity/Fund Balance' and 'R' for 'Revenue'
SET_OF_BOOKS_ID	NUMBER			Identifier of GL set of book
SEGMENT1	VARCHAR2	(25)		Segment to store extra information
SEGMENT2	VARCHAR2	(25)		Segment to store extra information
SEGMENT3	VARCHAR2	(25)		Segment to store extra information
SEGMENT4	VARCHAR2	(25)		Segment to store extra information
SEGMENT5	VARCHAR2	(25)		Segment to store extra information
SEGMENT6	VARCHAR2	(25)		Segment to store extra information
SEGMENT7	VARCHAR2	(25)		Segment to store extra information
SEGMENT8	VARCHAR2	(25)		Segment to store extra information
SEGMENT9	VARCHAR2	(25)		Segment to store extra information
SEGMENT10	VARCHAR2	(25)		Segment to store extra information
SEGMENT11	VARCHAR2	(25)		Segment to store extra information
SEGMENT12	VARCHAR2	(25)		Segment to store extra information
SEGMENT13	VARCHAR2	(25)		Segment to store extra information
SEGMENT14	VARCHAR2	(25)		Segment to store extra information
SEGMENT15	VARCHAR2	(25)		Segment to store extra information
SEGMENT16	VARCHAR2	(25)		Segment to store extra information
SEGMENT17	VARCHAR2	(25)		Segment to store extra information
SEGMENT18	VARCHAR2	(25)		Segment to store extra information
SEGMENT19	VARCHAR2	(25)		Segment to store extra information
SEGMENT20	VARCHAR2	(25)		Segment to store extra information
SEGMENT21	VARCHAR2	(25)		Segment to store extra information
SEGMENT22	VARCHAR2	(25)		Segment to store extra information
SEGMENT23	VARCHAR2	(25)		Segment to store extra information
SEGMENT24	VARCHAR2	(25)		Segment to store extra information
SEGMENT25	VARCHAR2	(25)		Segment to store extra information
SEGMENT26	VARCHAR2	(25)		Segment to store extra information
SEGMENT27	VARCHAR2	(25)		Segment to store extra information
SEGMENT28	VARCHAR2	(25)		Segment to store extra information
SEGMENT29	VARCHAR2	(25)		Segment to store extra information
SEGMENT30	VARCHAR2	(25)		Segment to store extra information

Query Text

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


SELECT LEDGER_ID
,      LEGAL_ENTITY_ID
,      COMPANY_SEGMENT
,      PERIOD_NAME
,      CURRENCY_CODE
,      COST_CENTER
,      THIRD_PARTY_TYPE
,      THIRD_PARTY_ID
,      THIRD_PARTY_NUMBER
,      PROJECT_ID
,      PROJECT_NUMBER
,      PROJECT_SOURCE
,      ACCOUNT_SEGMENT
,      PERSONNEL_ID
,      PERSONNEL_NUMBER
,      FUNC_BEGIN_BALANCE_DR
,      FUNC_BEGIN_BALANCE_CR
,      ORIG_BEGIN_BALANCE_DR
,      ORIG_BEGIN_BALANCE_CR
,      FUNC_PERIOD_NET_DR
,      FUNC_PERIOD_NET_CR
,      ORIG_PERIOD_NET_DR
,      ORIG_PERIOD_NET_CR
,      PERIOD_MON
,      CREATED_BY
,      CREATION_DATE
,      LAST_UPDATED_BY
,      LAST_UPDATE_DATE
,      LAST_UPDATE_LOGIN
,      ACCOUNT_TYPE
,      SET_OF_BOOKS_ID
,      SEGMENT1
,      SEGMENT2
,      SEGMENT3
,      SEGMENT4
,      SEGMENT5
,      SEGMENT6
,      SEGMENT7
,      SEGMENT8
,      SEGMENT9
,      SEGMENT10
,      SEGMENT11
,      SEGMENT12
,      SEGMENT13
,      SEGMENT14
,      SEGMENT15
,      SEGMENT16
,      SEGMENT17
,      SEGMENT18
,      SEGMENT19
,      SEGMENT20
,      SEGMENT21
,      SEGMENT22
,      SEGMENT23
,      SEGMENT24
,      SEGMENT25
,      SEGMENT26
,      SEGMENT27
,      SEGMENT28
,      SEGMENT29
,      SEGMENT30
FROM JA.JA_CN_ACCOUNT_BALANCES;

Dependencies

[top of page]

JA.JA_CN_ACCOUNT_BALANCES does not reference any database object

JA.JA_CN_ACCOUNT_BALANCES is referenced by following:

JA: JA_CN_ACCOUNT_BALANCES#