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

TABLE: JA.JA_CN_ACCOUNT_BALANCES_POST_GT

Object Details
Object Name: JA_CN_ACCOUNT_BALANCES_POST_GT
Object Type: TABLE
Owner: JA
FND Design Data: TableJA.JA_CN_ACCOUNT_BALANCES_POST_GT
Subobject Name:
Status: VALID

The table 'JA_CN_ACCOUNT_BALANCES' stores beginning balance, period net DR amount, period net CR amount and ending balance for nature account and subsidiary segments by period and currency.

Temporary Table Details

JA.JA_CN_ACCOUNT_BALANCES_POST_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$TRANSACTION. Data is removed at the end of this period.

Storage Details
Tablespace: Tablespace
PCT Free: 10
PCT Used: 40
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'
PERIOD_NUM NUMBER (15) Yes Period num in GL_periods
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
,      PERIOD_NUM
,      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_POST_GT;

Dependencies

[top of page]

JA.JA_CN_ACCOUNT_BALANCES_POST_GT does not reference any database object

JA.JA_CN_ACCOUNT_BALANCES_POST_GT is referenced by following:

SchemaAPPS
SynonymJA_CN_ACCOUNT_BALANCES_POST_GT