OEB_FND_ID_FLEX_SEGMENTS

Database

SDSNZS01_R12

Schema

CDCPADM_R12

Type

TABLE

Description

 

Columns
# Name Data Type Length
1 APPLICATION_ID BIGINT 8
2 ID_FLEX_CODE CHARACTER VARYING(4) 4
3 ID_FLEX_NUM BIGINT 8
4 APPLICATION_COLUMN_NAME CHARACTER VARYING(30) 30
5 SEGMENT_NAME CHARACTER VARYING(30) 30
6 LAST_UPDATE_DATE TIMESTAMP 8
7 LAST_UPDATED_BY BIGINT 8
8 CREATION_DATE TIMESTAMP 8
9 CREATED_BY BIGINT 8
10 LAST_UPDATE_LOGIN BIGINT 8
11 SEGMENT_NUM BIGINT 8
12 APPLICATION_COLUMN_INDEX_FLAG CHARACTER VARYING(1) 1
13 ENABLED_FLAG CHARACTER VARYING(1) 1
14 REQUIRED_FLAG CHARACTER VARYING(1) 1
15 DISPLAY_FLAG CHARACTER VARYING(1) 1
16 DISPLAY_SIZE BIGINT 8
17 SECURITY_ENABLED_FLAG CHARACTER VARYING(1) 1
18 MAXIMUM_DESCRIPTION_LEN BIGINT 8
19 CONCATENATION_DESCRIPTION_LEN BIGINT 8
20 FLEX_VALUE_SET_ID BIGINT 8
21 RANGE_CODE CHARACTER VARYING(1) 1
22 DEFAULT_TYPE CHARACTER VARYING(1) 1
23 DEFAULT_VALUE CHARACTER VARYING(1000) 1000
24 RUNTIME_PROPERTY_FUNCTION CHARACTER VARYING(1000) 1000
25 ADDITIONAL_WHERE_CLAUSE CHARACTER VARYING(4000) 4000
26 CDC_SOURCE_SYSTEM_CODE CHARACTER VARYING(4) 4
27 CDC_RECORD_TYPE CHARACTER VARYING(16) 16
28 CDC_COMMIT_TIMESTAMP TIMESTAMP 8
29 CDC_EXTRACT_TIMESTAMP TIMESTAMP 8