JA_CN_SUB_ACC_SOURCES
This table contains subsidiary source information about project, third party and personnel, and the ledger to which the 'Account Structure' key flexfield is assigned. The subsidiary source information is used to extract subsidiary information by 'Account and Journal Itemization Program' program, and the key flexfield is used to define the account structure.
Details
-
Schema: FUSION
-
Object owner: JA
-
Object type: TABLE
-
Tablespace: FUSION_TS_TX_DATA
Primary Key
| Name | Columns |
|---|---|
|
JA_CN_SUB_ACC_SOURCES_PK |
CHART_OF_ACCOUNTS_ID |
Columns
| Name | Datatype | Length | Precision | Not-null | Comments |
|---|---|---|---|---|---|
| CHART_OF_ACCOUNTS_ID | NUMBER | 18 | Yes | Chart of Accounts identifier. It is the structure instance number of the accounting key flexfield. | |
| ACCOUNT_STRUCTURE_CCID | NUMBER | 18 | Code combination of the account structure identifier. It is defined as key flexfield for the application. | ||
| STRUCTURE_SIN_ID | NUMBER | 18 | An identifier that uniquely identifies the structure instance of an account structure key flexfield. | ||
| ACCOUNT_STRUCTURE | VARCHAR2 | 20 | Yes | The structure of the account used in financial data export. | |
| CFS_ITEM_RULE | NUMBER | 18 | Yes | Stores the length of the cash flow statement item. | |
| 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_DATE | TIMESTAMP | Yes | Who column: indicates the date and time of the last update of the row. | ||
| LAST_UPDATE_LOGIN | VARCHAR2 | 32 | Who column: indicates the session login associated to the user who last updated 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. |
Foreign Keys
| Table | Foreign Table | Foreign Key Column |
|---|---|---|
| ja_cn_sub_acc_mappings | ja_cn_sub_acc_sources | CHART_OF_ACCOUNTS_ID |
| ja_cn_cfs_assign_sups | ja_cn_sub_acc_sources | CHART_OF_ACCOUNTS_ID |
| ja_cn_fd_dff_assignments | ja_cn_sub_acc_sources | CHART_OF_ACCOUNTS_ID |
Indexes
| Index | Uniqueness | Tablespace | Columns |
|---|---|---|---|
| JA_CN_SUB_ACC_SOURCES_U1 | Unique | Default | CHART_OF_ACCOUNTS_ID |