FUN_ADM_ATTRIBUTES_B
This table stores attributes from target and refeference objects that can be used in attribute derivation rule as both input and target attributtes to derive transaction attributes. For example, derive business unit based on supplier on invoice or derive ledger based on legacy company.
Details
-
Schema: FUSION
-
Object owner: FUN
-
Object type: TABLE
-
Tablespace: REFERENCE
Primary Key
| Name | Columns |
|---|---|
|
FUN_ADM_ATTRIBUTES_B_PK |
ATTRIBUTE_ID |
Columns
| Name | Datatype | Length | Precision | Not-null | Comments |
|---|---|---|---|---|---|
| ATTRIBUTE_ID | NUMBER | 18 | Yes | Unique sequence generated identifier for the attribute entry. | |
| ATTRIBUTE_CODE | VARCHAR2 | 30 | Yes | Short name of the attribute that uniquely identifies an attribute. | |
| ATTRIBUTE_GROUP_CODE | VARCHAR2 | 30 | Target attribute category such as enterprise attributes, tax attributes, project attribute, descriptive flexfield, or global flexfield. | ||
| DATATYPE_CODE | VARCHAR2 | 1 | Yes | Attribute data type. Possible values are C (alphanumeric), N (Numeric), or D (Date). | |
| VALUE_SET_CODE | VARCHAR2 | 30 | Value set associated with the attribute. | ||
| VIEW_APPLICATION_ID | NUMBER | 18 | Identifier of the application associated with the lookup type. | ||
| LOOKUP_TYPE_CODE | VARCHAR2 | 30 | Lookup associated with the attribute. | ||
| KEY_FLEXFIELD_FLAG | VARCHAR2 | 1 | Indicates whether the attribute stores any key flexfield. | ||
| SEGMENT_CODE | VARCHAR2 | 30 | Accounting flexfield segment associated with the attribute. | ||
| CODE_COMBINATION_ID | NUMBER | 18 | Code combination identifier of a key flexfield attribute. | ||
| FLEXFIELD_APPLICATION_ID | NUMBER | 18 | Identifier of the application associated with the key flexfield. | ||
| ID_FLEX_CODE | VARCHAR2 | 30 | Unique identifier of key flexfield. | ||
| CREATION_DATE | TIMESTAMP | Yes | Who column: indicates the date and time of the creation of the row. | ||
| CREATED_BY | VARCHAR2 | 64 | Yes | Who column: indicates the user who created 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. | ||
| LAST_UPDATED_BY | VARCHAR2 | 64 | Yes | Who column: indicates 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. | |
| SEED_DATA_SOURCE | VARCHAR2 | 512 | Source of seed data record. A value of 'BULK_SEED_DATA_SCRIPT' indicates that record was bulk loaded. Otherwise, specifies the name of the seed data file. | ||
| ORA_SEED_SET1 | VARCHAR2 | 1 | Yes | Oracle internal use only. Indicates the edition-based redefinition (EBR) context of the row for SET1. Context values are Y or N. | |
| ORA_SEED_SET2 | VARCHAR2 | 1 | Yes | Oracle internal use only. Indicates the edition-based redefinition (EBR) context of the row for SET2. Context values are Y or N. |
Indexes
| Index | Uniqueness | Tablespace | Columns |
|---|---|---|---|
| FUN_ADM_ATTRIBUTES_B_N1 | Non Unique | Default | ATTRIBUTE_GROUP_CODE |
| FUN_ADM_ATTRIBUTES_B_U1 | Unique | FUSION_TS_SEED | ATTRIBUTE_ID, ORA_SEED_SET1 |
| FUN_ADM_ATTRIBUTES_B_U11 | Unique | FUSION_TS_SEED | ATTRIBUTE_ID, ORA_SEED_SET2 |
| FUN_ADM_ATTRIBUTES_B_U2 | Unique | Default | ATTRIBUTE_CODE, ORA_SEED_SET1 |
| FUN_ADM_ATTRIBUTES_B_U21 | Unique | Default | ATTRIBUTE_CODE, ORA_SEED_SET2 |