DIM_ATOCRS_CURRENCY_RATE_REFERENCE_INSIGHT

Database

INSNZP01_BANK

Schema

BANKPADM

Type

VIEW

Description

 

Columns
# Name Data Type Length
1 PERIOD_DIM_ID BIGINT 8
2 EFFDATE TIMESTAMP 8
3 SOURCE_CURRENCY_ID BIGINT 8
4 SOURCE_CURRENCY_CODE CHARACTER VARYING(32) 32
5 SOURCE_CURRENCY_DESCRIPTION CHARACTER VARYING(256) 256
6 INWARD_TT_BUY NUMERIC(12,6) 19
7 TT_DRAFTS_T_CHQS_SELL NUMERIC(12,6) 19
8 FOREIGN_CASH_BUY NUMERIC(12,6) 19
9 FOREIGN_CASH_SELL NUMERIC(12,6) 19
10 MID_RATE NUMERIC(15,8) 19