OEB_GL_PERIOD_TYPES

Database

SDSNZS01_R12

Schema

CDCPADM_R12

Type

TABLE

Description

 

Columns
# Name Data Type Length
1 PERIOD_TYPE CHARACTER VARYING(15) 15
2 LAST_UPDATE_DATE TIMESTAMP 8
3 LAST_UPDATED_BY BIGINT 8
4 NUMBER_PER_FISCAL_YEAR BIGINT 8
5 YEAR_TYPE_IN_NAME CHARACTER VARYING(1) 1
6 USER_PERIOD_TYPE CHARACTER VARYING(15) 15
7 CREATION_DATE TIMESTAMP 8
8 CREATED_BY BIGINT 8
9 LAST_UPDATE_LOGIN BIGINT 8
10 DESCRIPTION CHARACTER VARYING(240) 240
11 ATTRIBUTE1 CHARACTER VARYING(150) 150
12 ATTRIBUTE2 CHARACTER VARYING(150) 150
13 ATTRIBUTE3 CHARACTER VARYING(150) 150
14 ATTRIBUTE4 CHARACTER VARYING(150) 150
15 ATTRIBUTE5 CHARACTER VARYING(150) 150
16 CONTEXT CHARACTER VARYING(150) 150
17 PERIOD_TYPE_ID BIGINT 8
18 CDC_SOURCE_SYSTEM_CODE CHARACTER VARYING(4) 4
19 CDC_RECORD_TYPE CHARACTER VARYING(16) 16
20 CDC_COMMIT_TIMESTAMP TIMESTAMP 8
21 CDC_EXTRACT_TIMESTAMP TIMESTAMP 8