FCT_OPC_EFS_OPICS_GENERAL_LEDGER_INSIGHT

Database

INSNZP02_BANK

Schema

BANKPADM

Type

VIEW

Description

 

Columns
# Name Data Type Length
1 PERIOD_DATE TIMESTAMP 8
2 PERIOD_DIM_ID BIGINT 8
3 GLNO CHARACTER VARYING(15) 15
4 DESCR CHARACTER VARYING(60) 60
5 OF_ACCOUNT_CODE CHARACTER VARYING(240) 240
6 ACCOUNT_NAME CHARACTER VARYING(240) 240
7 OF_CATEGORY_CODE CHARACTER VARYING(240) 240
8 OF_PRODUCT_CODE CHARACTER VARYING(240) 240
9 OF_INTERCOMPANY_CODE CHARACTER VARYING(240) 240
10 COSTCENT CHARACTER VARYING(10) 10
11 CCY CHARACTER VARYING(3) 3
12 RESIDENCY CHARACTER VARYING(7) 7
13 CCY_AMOUNT NUMERIC(38,4) 19
14 SPOTRATE_8 NUMERIC(18,8) 19
15 AUD_BASE_AMOUNT NUMERIC(26,2) 19