JA_CN_ACCOUNT_STRUCTURES
This table contains a column 'CODE_COMBINATION_ID' to uniquely identify one valid combination of account structures for the solution for China Accounting Software Data Interface Standard, fifth key flexfield segment columns, and other essential columns for combination table, such as 'ENABLED_FLAG', 'SUMMARY_FLAG', 'START_DATE_ACTIVE', and 'END_DATE_ACTIVE'. It is a combination table to implement key flexfield for the field 'ACCOUNT_STRUCTURE' on 'Subsidiary Accounting Sources'.
Details
-
Schema: FUSION
-
Object owner: JA
-
Object type: TABLE
-
Tablespace: FUSION_TS_TX_DATA
Primary Key
| Name | Columns |
|---|---|
|
JA_CN_ACCOUNT_STRUCTURES_PK |
CODE_COMBINATION_ID |
Columns
| Name | Datatype | Length | Precision | Not-null | Comments |
|---|---|---|---|---|---|
| CODE_COMBINATION_ID | NUMBER | 18 | Yes | Account combination for account structure key flexfield of the Solution for China Accounting Software Data Interface Standard identifier that is individual key flexfield account combination. | |
| STRUCTURE_SIN_ID | NUMBER | 18 | Yes | An identifier that uniquely identifies the structure instance of an account structure key flexfield. | |
| ENABLED_FLAG | VARCHAR2 | 1 | Yes | Enabled flag of account structure. | |
| SUMMARY_FLAG | VARCHAR2 | 1 | Yes | Summary flag of account structure. | |
| SEGMENT1 | VARCHAR2 | 60 | Key Flexfield: segment of the key flexfield. | ||
| SEGMENT2 | VARCHAR2 | 60 | Key Flexfield: segment of the key flexfield. | ||
| SEGMENT3 | VARCHAR2 | 60 | Key Flexfield: segment of the key flexfield. | ||
| SEGMENT4 | VARCHAR2 | 60 | Key Flexfield: segment of the key flexfield. | ||
| SEGMENT5 | VARCHAR2 | 60 | Key Flexfield: segment of the key flexfield. | ||
| SEGMENT6 | VARCHAR2 | 60 | Key Flexfield: segment of the key flexfield. | ||
| SEGMENT7 | VARCHAR2 | 60 | Key Flexfield: segment of the key flexfield. | ||
| SEGMENT8 | VARCHAR2 | 60 | Key Flexfield: segment of the key flexfield. | ||
| SEGMENT9 | VARCHAR2 | 60 | Key Flexfield: segment of the key flexfield. | ||
| SEGMENT10 | VARCHAR2 | 60 | Key Flexfield: segment of the key flexfield. | ||
| SEGMENT11 | VARCHAR2 | 60 | Key Flexfield: segment of the key flexfield. | ||
| SEGMENT12 | VARCHAR2 | 60 | Key Flexfield: segment of the key flexfield. | ||
| SEGMENT13 | VARCHAR2 | 60 | Key Flexfield: segment of the key flexfield. | ||
| SEGMENT14 | VARCHAR2 | 60 | Key Flexfield: segment of the key flexfield. | ||
| SEGMENT15 | VARCHAR2 | 60 | Key Flexfield: segment of the key flexfield. | ||
| START_DATE_ACTIVE | DATE | Start date in a date range that indicates the date from when the key flexfield combination is valid. | |||
| END_DATE_ACTIVE | DATE | End date in a date range that indicates the date from when the key flexfield combination is invalid. | |||
| ACCOUNT_STRUCTURE | VARCHAR2 | 2000 | Account structure value that is concatenated with the structure. | ||
| CREATED_BY | VARCHAR2 | 64 | Yes | Who column: indicates the user who created the row. | |
| CREATION_DATE | TIMESTAMP | Yes | Who column: indicates the date and time of the creation of the row. | ||
| LAST_UPDATED_BY | VARCHAR2 | 64 | Yes | Who column: indicates the user who last updated the row. | |
| LAST_UPDATE_LOGIN | VARCHAR2 | 32 | Who column: indicates the session login associated to the user who last updated the row. | ||
| LAST_UPDATE_DATE | TIMESTAMP | Yes | Who column: indicates the date and time of the last update of the row. | ||
| OBJECT_VERSION_NUMBER | NUMBER | 9 | Yes | Used to implement optimistic locking. This number is incremented every time that the row is updated. The number is compared at the start and end of a transaction to detect whether another session has updated the row since it was queried. |
Indexes
| Index | Uniqueness | Tablespace | Columns |
|---|---|---|---|
| JA_CN_ACCOUNT_STRUCTURES_U1 | Unique | FUSION_TS_TX_DATA | CODE_COMBINATION_ID |