ZX_API_CODE_COMBINATIONS
This table stores valid context combinations for each context key flexfield structure, using third party or custom APIs that have been registered in Fusion Tax.
Details
-
Schema: FUSION
-
Object owner: ZX
-
Object type: TABLE
-
Tablespace: APPS_TS_TX_DATA
Primary Key
| Name | Columns |
|---|---|
|
ZX_API_CODE_COMBINATIONS_PK |
CODE_COMBINATION_ID |
Columns
| Name | Datatype | Length | Precision | Not-null | Comments |
|---|---|---|---|---|---|
| CONTEXT_FLEX_STRUCTURE_ID | NUMBER | 18 | Yes | Key flexfield structure defining column | |
| CODE_COMBINATION_ID | NUMBER | 18 | Yes | Key flexfield combination defining column | |
| ENABLED_FLAG | VARCHAR2 | 1 | Yes | Key flexfield enabled flag | |
| DESCRIPTION | VARCHAR2 | 240 | Key flexfield Description | ||
| START_DATE_ACTIVE | DATE | Date before which key flexfield combination is invalid | |||
| END_DATE_ACTIVE | DATE | Date after which key flexfield combination is invalid | |||
| LAST_UPDATE_LOGIN | VARCHAR2 | 32 | Who column: indicates the session login associated to the user who last updated the row. | ||
| SEGMENT_ATTRIBUTE1 | VARCHAR2 | 60 | Key flexfield segment | ||
| SEGMENT_ATTRIBUTE2 | VARCHAR2 | 60 | Key flexfield segment | ||
| SEGMENT_ATTRIBUTE3 | VARCHAR2 | 60 | Key flexfield segment | ||
| SEGMENT_ATTRIBUTE4 | VARCHAR2 | 60 | Key flexfield segment | ||
| SEGMENT_ATTRIBUTE5 | VARCHAR2 | 60 | Key flexfield segment | ||
| SEGMENT_ATTRIBUTE6 | VARCHAR2 | 60 | Key flexfield segment | ||
| SEGMENT_ATTRIBUTE7 | VARCHAR2 | 60 | Key flexfield segment | ||
| SEGMENT_ATTRIBUTE8 | VARCHAR2 | 60 | Key flexfield segment | ||
| SEGMENT_ATTRIBUTE9 | VARCHAR2 | 60 | Key flexfield segment | ||
| SEGMENT_ATTRIBUTE10 | VARCHAR2 | 60 | Key flexfield segment | ||
| SEGMENT_ATTRIBUTE11 | VARCHAR2 | 60 | Key flexfield segment | ||
| SEGMENT_ATTRIBUTE12 | VARCHAR2 | 60 | Key flexfield segment | ||
| SEGMENT_ATTRIBUTE13 | VARCHAR2 | 60 | Key flexfield segment | ||
| SEGMENT_ATTRIBUTE14 | VARCHAR2 | 60 | Key flexfield segment | ||
| SEGMENT_ATTRIBUTE15 | VARCHAR2 | 60 | Key flexfield segment | ||
| SUMMARY_FLAG | VARCHAR2 | 1 | Yes | Not currently used | |
| 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_UPDATE_DATE | TIMESTAMP | Yes | Who column: indicates the date and time of the last update of the row. | ||
| LAST_UPDATED_BY | VARCHAR2 | 64 | Yes | Who column: indicates the user who last updated the row. | |
| RECORD_TYPE_CODE | VARCHAR2 | 30 | Lookup code to indicate whether the record is migrated, seeded or defined by the user |
Foreign Keys
| Table | Foreign Table | Foreign Key Column |
|---|---|---|
| zx_api_registrations | zx_api_code_combinations | CONTEXT_CCID |
Indexes
| Index | Uniqueness | Columns |
|---|---|---|
| ZX_API_CODE_COMBINATIONS_U1 | Unique | CODE_COMBINATION_ID |