[Home] [Help] [Dependency Information]
Object Name: | JA_CN_SYSTEM_PARAMETERS_ALL# |
---|---|
Object Type: | VIEW |
Owner: | JA |
Subobject Name: | |
Status: | VALID |
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
LEGAL_ENTITY_ID | NUMBER | (15) | Yes | |
BOOK_NAME | VARCHAR2 | (50) | Yes | |
COMPANY_NAME | VARCHAR2 | (100) | Yes | |
BOOK_NUM | VARCHAR2 | (50) | Yes | |
ENT_QUALITY | VARCHAR2 | (30) | Yes | |
ORGANIZATION_ID | VARCHAR2 | (20) | Yes | |
ENT_INDUSTRY | VARCHAR2 | (100) | Yes | |
ROUNDING_RULE | VARCHAR2 | (30) | ||
CREATED_BY | NUMBER | (15) | Yes | |
CREATION_DATE | DATE | Yes | ||
LAST_UPDATED_BY | NUMBER | (15) | Yes | |
LAST_UPDATE_DATE | DATE | Yes | ||
LAST_UPDATE_LOGIN | NUMBER | (15) | ||
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) | ||
CNAO_STAND_VER | VARCHAR2 | (60) | ||
ADMIN_DIVISION_CODE | VARCHAR2 | (50) | ||
BUDGET_MGMT_LEVEL | VARCHAR2 | (50) | ||
FUND_SOURCE | VARCHAR2 | (50) |
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
, CNAO_STAND_VER
, ADMIN_DIVISION_CODE
, BUDGET_MGMT_LEVEL
, FUND_SOURCE
FROM JA.JA_CN_SYSTEM_PARAMETERS_ALL#;
|
|
|