[Home] [Help] [Dependency Information]
Object Name: | JA_CN_ACCOUNT_STRUCTURES |
---|---|
Object Type: | TABLE |
Owner: | JA |
FND Design Data: | JA.JA_CN_ACCOUNT_STRUCTURES |
Subobject Name: | |
Status: | VALID |
The table 'JA_CN_ACCOUNT_STRUCTURES' is a combination table to implement Key Flexfield for the field 'ACCOUNT_STRUCTURE' on 'Subsidiary Accounting Sources'. It contains a column 'ACCOUNT_STRUCTURE_ID' to uniquely identify one valid combination of account structures for the Solution for China Accounting Software Data Interface Standard, fifth KFF segment columns and other essential columns for combination table, such as 'ENABLED_FLAG', 'SUMMARY_FLAG', 'START_DATE_ACTIVE' and 'END_DATE_ACTIVE'.
Tablespace: | APPS_TS_TX_DATA |
---|---|
PCT Free: | 10 |
PCT Used: |
Index | Type | Uniqueness | Tablespace | Column |
---|---|---|---|---|
JA_CN_ACCOUNT_STRUCTURES_U1 | NORMAL | UNIQUE | APPS_TS_TX_IDX | ACCOUNT_STRUCTURE_ID |
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
ACCOUNT_STRUCTURE_ID | NUMBER | Yes | Identifier of segment combination for account structure of the Solution for China Accounting Software Data Interface Standard | |
STRUCTURE_ID | NUMBER | Yes | Identifier of structure | |
LAST_UPDATE_DATE | DATE | Yes | Standard WHO column | |
LAST_UPDATED_BY | NUMBER | Yes | Standard WHO column | |
ENABLED_FLAG | VARCHAR2 | (1) | Yes | Enabled flag |
SUMMARY_FLAG | VARCHAR2 | (1) | Yes | Summary flag |
SEGMENT1 | VARCHAR2 | (60) | Key flexfield segment | |
SEGMENT2 | VARCHAR2 | (60) | Key flexfield segment | |
SEGMENT3 | VARCHAR2 | (60) | Key flexfield segment | |
SEGMENT4 | VARCHAR2 | (60) | Key flexfield segment | |
SEGMENT5 | VARCHAR2 | (60) | Key flexfield segment | |
SEGMENT6 | VARCHAR2 | (60) | Key flexfield segment | |
SEGMENT7 | VARCHAR2 | (60) | Key flexfield segment | |
SEGMENT8 | VARCHAR2 | (60) | Key flexfield segment | |
SEGMENT9 | VARCHAR2 | (60) | Key flexfield segment | |
SEGMENT10 | VARCHAR2 | (60) | Key flexfield segment | |
SEGMENT11 | VARCHAR2 | (60) | Key flexfield segment | |
SEGMENT12 | VARCHAR2 | (60) | Key flexfield segment | |
SEGMENT13 | VARCHAR2 | (60) | Key flexfield segment | |
SEGMENT14 | VARCHAR2 | (60) | Key flexfield segment | |
SEGMENT15 | VARCHAR2 | (60) | Key flexfield segment | |
START_DATE_ACTIVE | DATE | Date before which key flexfield combination is invalid | ||
END_DATE_ACTIVE | DATE | Date after which key flexfield combination is invalid | ||
CREATION_DATE | DATE | Standard WHO column | ||
CREATED_BY | NUMBER | Standard WHO column | ||
LAST_UPDATE_LOGIN | NUMBER | Standard WHO column | ||
ACCOUNT_STRUCTURE | VARCHAR2 | (2000) | The column will not be used in R12 |
Cut, paste (and edit) the following text to query this object:
SELECT ACCOUNT_STRUCTURE_ID
, STRUCTURE_ID
, LAST_UPDATE_DATE
, LAST_UPDATED_BY
, ENABLED_FLAG
, SUMMARY_FLAG
, SEGMENT1
, SEGMENT2
, SEGMENT3
, SEGMENT4
, SEGMENT5
, SEGMENT6
, SEGMENT7
, SEGMENT8
, SEGMENT9
, SEGMENT10
, SEGMENT11
, SEGMENT12
, SEGMENT13
, SEGMENT14
, SEGMENT15
, START_DATE_ACTIVE
, END_DATE_ACTIVE
, CREATION_DATE
, CREATED_BY
, LAST_UPDATE_LOGIN
, ACCOUNT_STRUCTURE
FROM JA.JA_CN_ACCOUNT_STRUCTURES;
JA.JA_CN_ACCOUNT_STRUCTURES does not reference any database object
JA.JA_CN_ACCOUNT_STRUCTURES is referenced by following:
|
|
|