FCT_BNK_OSX_RECON_HIST_DETAIL_INSIGHT

Database

INSNZP02_BANK

Schema

BANKPADM

Type

VIEW

Description

 

Columns
# Name Data Type Length
1 REPORTING_MONTH_END DATE 4
2 OSX_EXTRACT_NAME NATIONAL CHARACTER VARYING(40) 40
3 OSX_MEASURE_NAME NATIONAL CHARACTER VARYING(40) 40
4 GL_PRODUCT_CODE NATIONAL CHARACTER VARYING(30) 30
5 GL_ACCOUNT_CODE NATIONAL CHARACTER VARYING(40) 40
6 GL_ENTITY_CODE NATIONAL CHARACTER VARYING(30) 30
7 GL_BALANCE NUMERIC(25,8) 19
8 T_TABLE_BALANCE NUMERIC(25,8) 19
9 DOLLAR_VARIANCE NUMERIC(25,8) 19
10 PERCENTAGE_VARIANCE NUMERIC(25,8) 19
11 INTERNAL_FRC_REFERENCE NATIONAL CHARACTER VARYING(115) 115