[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$SESSION. 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 PROJECT_NUMBER THIRD_PARTY_NUMBER COST_CENTER PERSONNEL_NUMBER |
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 |
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;
JA.JA_CN_ACCOUNT_BALANCES_GT does not reference any database object
JA.JA_CN_ACCOUNT_BALANCES_GT is referenced by following:
|
|
|