[Home] [Help] [Dependency Information]
Object Name: | JA_CN_SYSTEM_PARAMETERS_ALL |
---|---|
Object Type: | TABLE |
Owner: | JA |
FND Design Data: | JA.JA_CN_SYSTEM_PARAMETERS_ALL |
Subobject Name: | |
Status: | VALID |
The 'JA_CN_SYSTEM_PARAMETERS_ALL' table stores information defined by 'System Options' form, 'Electronic Accounting Book Export' program will get most data from data in the table. A legal entity can only have one record in the table.
Tablespace: | APPS_TS_TX_DATA |
---|---|
PCT Free: | 10 |
PCT Used: |
Index | Type | Uniqueness | Tablespace | Column |
---|---|---|---|---|
JA_CN_SYSTEM_PARAMETERS_U1 | NORMAL | UNIQUE | APPS_TS_TX_IDX | LEGAL_ENTITY_ID |
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
LEGAL_ENTITY_ID | NUMBER | (15) | Yes | Identifier of Legal Entity |
BOOK_NAME | VARCHAR2 | (50) | Yes | Name of 'Electronic Accounting Book' |
COMPANY_NAME | VARCHAR2 | (100) | Yes | Company name |
BOOK_NUM | VARCHAR2 | (50) | Yes | Number of 'Electronic Accounting Book' |
ENT_QUALITY | VARCHAR2 | (30) | Yes | Quality of current company |
ORGANIZATION_ID | VARCHAR2 | (20) | Yes | Identifier of company |
ENT_INDUSTRY | VARCHAR2 | (100) | Yes | Industry that the company belongs to |
ROUNDING_RULE | VARCHAR2 | (30) | Rounding rule for amount calculation, defined in the System Options window. Amount can be rounded up, down, or nearest. | |
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 | |
SET_OF_BOOKS_ID | NUMBER | (15) | ||
DEFAULT_CFS_ITEM | VARCHAR2 | (150) | ||
PARENT_LEGAL_ENTITY_ID | NUMBER | (15) | ||
ACCOUNT_STRUCTURE_ID | NUMBER | (15) | ||
ACCOUNT_STRUCTURE | VARCHAR2 | (2000) |
Cut, paste (and edit) the following text to query this object:
SELECT LEGAL_ENTITY_ID
, BOOK_NAME
, COMPANY_NAME
, BOOK_NUM
, ENT_QUALITY
, ORGANIZATION_ID
, ENT_INDUSTRY
, ROUNDING_RULE
, CREATED_BY
, CREATION_DATE
, LAST_UPDATED_BY
, LAST_UPDATE_DATE
, LAST_UPDATE_LOGIN
, SET_OF_BOOKS_ID
, DEFAULT_CFS_ITEM
, PARENT_LEGAL_ENTITY_ID
, ACCOUNT_STRUCTURE_ID
, ACCOUNT_STRUCTURE
FROM JA.JA_CN_SYSTEM_PARAMETERS_ALL;
JA.JA_CN_SYSTEM_PARAMETERS_ALL does not reference any database object
JA.JA_CN_SYSTEM_PARAMETERS_ALL is referenced by following:
|
|
|