DIM_OPC_GL_ACCT_PRD_MAP_INSIGHT

Database

INSNZP01_BANK

Schema

BANKPADM

Type

VIEW

Description

 

Columns
# Name Data Type Length
1 PRODUCT_CODE CHARACTER VARYING(6) 6
2 PRODUCT_TYPE CHARACTER VARYING(3) 3
3 TENOR CHARACTER VARYING(2) 2
4 SEQ CHARACTER VARYING(4) 4
5 OF_INTERFACE CHARACTER VARYING(1) 1
6 ACCT_TYPE CHARACTER VARYING(35) 35
7 GL_MAP_CODE CHARACTER VARYING(16) 16
8 PS_ACCT_NO CHARACTER VARYING(5) 5
9 PS_GL_PROD CHARACTER VARYING(4) 4
10 PS_INTERCOMP CHARACTER VARYING(4) 4
11 OF_ACCOUNT_CODE CHARACTER VARYING(240) 240
12 OF_CATEGORY_CODE CHARACTER VARYING(240) 240
13 OF_PRODUCT_CODE CHARACTER VARYING(240) 240
14 OF_INTERCOMPANY_CODE CHARACTER VARYING(240) 240
15 EFFECTIVE_START_DATE TIMESTAMP 8
17 IS_CURRENT CHARACTER VARYING(1) 1