DIM_OEB_PROCUREMENT_PERIOD

Database

INSNZP01_R12

Schema

R12PADM

Type

TABLE

Description

 

Columns
# Name Data Type Length
1 DAY TIMESTAMP 8
2 DAY_NAME CHARACTER VARYING(15) 15
3 DAY_NUMBER BIGINT 8
4 CAL_QUARTER_NUM BIGINT 8
5 FIN_QUARTER_NUM BIGINT 8
6 CAL_YEAR INTEGER 4
7 FIN_YEAR INTEGER 4
8 FIN_QUARTER_CODE INTEGER 4
9 CAL_QUARTER_CODE CHARACTER VARYING(35) 35
10 CAL_MONTH BIGINT 8
11 FIN_MONTH BIGINT 8
12 FIN_YEAR_MONTH CHARACTER VARYING(15) 15
13 CAL_YEAR_MONTH INTEGER 4
14 FIN_YEAR_LABEL CHARACTER VARYING(14) 14
15 PERIOD_NAME CHARACTER VARYING(200) 200