[Home] [Help] [Dependency Information]
Object Name: | JA_CN_ERROR_ACCOUNTS |
---|---|
Object Type: | TABLE |
Owner: | JA |
FND Design Data: | JA.JA_CN_ERROR_ACCOUNTS |
Subobject Name: | |
Status: | VALID |
JA_CN_ERROR_ACCOUNTS stores error accounts which has abnormal balances. The XML data template will read this table to export the error accounts if any.
Tablespace: | APPS_TS_TX_DATA |
---|---|
PCT Free: | 10 |
PCT Used: |
Index | Type | Uniqueness | Tablespace | Column |
---|---|---|---|---|
JA_CN_ERROR_ACCOUNTS_N1 | NORMAL | NONUNIQUE | APPS_TS_TX_IDX | REQUEST_ID |
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
REQUEST_ID | NUMBER | Yes | Concurrent request id | |
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 debit balance, base currency | ||
ORIG_PERIOD_NET_DR | NUMBER | Period net credit 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) | 'Y'or 'N' indicates whether this natural account has third party subsidiary. | |
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 REQUEST_ID
, 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_ERROR_ACCOUNTS;
JA.JA_CN_ERROR_ACCOUNTS does not reference any database object
JA.JA_CN_ERROR_ACCOUNTS is referenced by following:
|
|
|