JA_CN_FD_DFF_ASSIGNMENTS
This table contains context codes and column names for all descriptive flexfield used by programs of the solution for China Accounting Software Data Interface Standard. Each row includes the application ID and descriptive flexfield name, which can identify one descriptive flexfield. There is another column ''DESCRIPTIVE_FLEXFIELD_TITLE_CODE'' in this table, which contains codes that is used to define translatable description for descriptive flexfield shown in this table. ''DESCRIPTIVE_FLEXFIELD_TITLE_CODE'' column has one-to-one relationship with the combination of ''APPLICATION_ID'' and ''DESCRIPTIVE_FLEXFIELD_NAME''.
Details
-
Schema: FUSION
-
Object owner: JA
-
Object type: TABLE
-
Tablespace: FUSION_TS_TX_DATA
Primary Key
Name | Columns |
---|---|
JA_CN_FD_DFF_ASSIGNMENTS_PK |
DFF_ASSIGNMENT_ID |
Columns
Name | Datatype | Length | Precision | Not-null | Comments |
---|---|---|---|---|---|
DFF_ASSIGNMENT_ID | NUMBER | 18 | Yes | An identifier that uniquely identifies the descriptive flexfield assignment row. | |
CHART_OF_ACCOUNTS_ID | NUMBER | 18 | Yes | Chart of Accounts identifier for accounting key flexfield structure instance number. | |
APPLICATION_ID | NUMBER | 18 | Yes | An identifier that uniquely identifies the application. | |
DESCRIPTIVE_FLEXFIELD_NAME | VARCHAR2 | 40 | Yes | Name of the descriptive flexfield. | |
DFF_TITLE_CODE | VARCHAR2 | 30 | Yes | Descriptive flexfield title code defined. | |
CONTEXT_CODE | VARCHAR2 | 30 | Context code of the descriptive flexfield. | ||
ATTRIBUTE_COLUMN | VARCHAR2 | 30 | Attribute column that is defined for the context of descriptive flexfield. | ||
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_FD_DFF_ASSIGNMENTS | ja_cn_sub_acc_sources | CHART_OF_ACCOUNTS_ID |
Indexes
Index | Uniqueness | Tablespace | Columns |
---|---|---|---|
JA_CN_FD_DFF_ASSIGNMENTS_U1 | Unique | FUSION_TS_TX_DATA | CHART_OF_ACCOUNTS_ID, DFF_TITLE_CODE |
JA_CN_FD_DFF_ASSIGNMENTS_U2 | Unique | FUSION_TS_TX_DATA | DFF_ASSIGNMENT_ID |