[Home] [Help] [Dependency Information]
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.
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$TRANSACTION. Data is removed at the end of this period.
Tablespace: | |
---|---|
PCT Free: | 10 |
PCT Used: | 40 |
Index | Type | Uniqueness | Tablespace | Column |
---|---|---|---|---|
JA_CN_ACCOUNT_BALANCES_GT_N1 | NORMAL | NONUNIQUE |
START_DATE
ACCOUNT_SEGMENT 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 |
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 | |
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 |
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
, 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_GT;
JA.JA_CN_ACCOUNT_BALANCES_GT does not reference any database object
JA.JA_CN_ACCOUNT_BALANCES_GT is referenced by following:
|
|
|