OEB_GL_DAILY_RATES

Database

SDSNZS01_R12

Schema

CDCPADM_R12

Type

TABLE

Description

 

Columns
# Name Data Type Length
1 FROM_CURRENCY CHARACTER VARYING(15) 15
2 TO_CURRENCY CHARACTER VARYING(15) 15
3 CONVERSION_DATE TIMESTAMP 8
4 CONVERSION_TYPE CHARACTER VARYING(30) 30
5 CONVERSION_RATE DOUBLE PRECISION 8
6 STATUS_CODE CHARACTER VARYING(1) 1
7 CREATION_DATE TIMESTAMP 8
8 CREATED_BY BIGINT 8
9 LAST_UPDATE_DATE TIMESTAMP 8
10 LAST_UPDATED_BY BIGINT 8
11 LAST_UPDATE_LOGIN BIGINT 8
12 CONTEXT CHARACTER VARYING(150) 150
13 ATTRIBUTE1 CHARACTER VARYING(150) 150
14 ATTRIBUTE2 CHARACTER VARYING(150) 150
15 ATTRIBUTE3 CHARACTER VARYING(150) 150
16 ATTRIBUTE4 CHARACTER VARYING(150) 150
17 ATTRIBUTE5 CHARACTER VARYING(150) 150
18 ATTRIBUTE6 CHARACTER VARYING(150) 150
19 ATTRIBUTE7 CHARACTER VARYING(150) 150
20 ATTRIBUTE8 CHARACTER VARYING(150) 150
21 ATTRIBUTE9 CHARACTER VARYING(150) 150
22 ATTRIBUTE10 CHARACTER VARYING(150) 150
23 ATTRIBUTE11 CHARACTER VARYING(150) 150
24 ATTRIBUTE12 CHARACTER VARYING(150) 150
25 ATTRIBUTE13 CHARACTER VARYING(150) 150
26 ATTRIBUTE14 CHARACTER VARYING(150) 150
27 ATTRIBUTE15 CHARACTER VARYING(150) 150
28 RATE_SOURCE_CODE CHARACTER VARYING(15) 15
29 CDC_SOURCE_SYSTEM_CODE CHARACTER VARYING(4) 4
30 CDC_RECORD_TYPE CHARACTER VARYING(16) 16
31 CDC_COMMIT_TIMESTAMP TIMESTAMP 8
32 CDC_EXTRACT_TIMESTAMP TIMESTAMP 8