DIM_RDM_CHECK_BANK_EFS_OPIC_GL_ACCOUNT_MAP_FX_INSIGHT

Database

INSNZP01_BANK

Schema

BANKPADM

Type

VIEW

Description

 

Columns
# Name Data Type Length
1 COA_SOURCE_SYSTEM NATIONAL CHARACTER VARYING(250) 250
2 RDM_OPICS_GL_REPORT_FROM_SOURCE NATIONAL CHARACTER VARYING(10) 10
3 OF_ENTITY NATIONAL CHARACTER VARYING(24) 24
4 DEAL_ID NATIONAL CHARACTER VARYING(100) 100
5 OF_ACCOUNT_CODE NATIONAL CHARACTER VARYING(40) 40
6 OPICS_GLNO CHARACTER VARYING(15) 15
7 OPICS_GLNO_DESCRIPTION NATIONAL CHARACTER VARYING(319) 319
8 RV_COA NATIONAL CHARACTER VARYING(100) 100
9 GL_ACCOUNT_TYPE NATIONAL CHARACTER VARYING(40) 40
10 FX_OPICS_GL_BALANCE NUMERIC(38,8) 19
11 FX_OPICS_GL_BALANCE_TOTAL NUMERIC(38,8) 19
12 OF_LEDGER_BALANCE NUMERIC(38,2) 19
13 GL_TOTAL_DIFF NUMERIC(38,8) 19