FCT_OEB_BANK_GL_BALANCE_MEASURES_BDW

Database

INSNZP01_R12

Schema

R12PADM

Type

TABLE

Description

 

Columns
# Name Data Type Length
1 GL_BUDGET_VERSION_SID INTEGER 4
2 COST_CENTRE_SID BIGINT 8
3 ACCOUNT_SID BIGINT 8
4 CATEGORY_SID BIGINT 8
5 PRODUCT_SID BIGINT 8
6 STATE_SID BIGINT 8
7 INTERCOMPANY_SID BIGINT 8
8 ENTITY_SID BIGINT 8
9 SET_OF_BOOKS_SID INTEGER 4
10 SPARE_SID BIGINT 8
11 PROJECT_SID BIGINT 8
12 CLASS_SID BIGINT 8
13 CHANNEL_SID BIGINT 8
14 ALL_TIME_SID BIGINT 8
15 GL_BALANCE_SID BIGINT 8
16 CREATED_DATE TIMESTAMP 8
17 CHANGED_DATE TIMESTAMP 8
18 YEAR_OPENING_BALANCE_AMOUNT INTEGER 4
19 OPENING_BALANCE_AMOUNT NUMERIC(25,2) 19
20 SIGNED_NET_AMOUNT NUMERIC(38,2) 19
21 CLOSING_BALANCE_AMOUNT NUMERIC(38,2) 19
22 YTD_DEBIT_AMOUNT NUMERIC(38,2) 19
23 YTD_CREDIT_AMOUNT NUMERIC(38,2) 19
24 CREDIT_AMOUNT NUMERIC(38,2) 19
25 DEBIT_AMOUNT NUMERIC(38,2) 19
26 STATISTIC_UNITS_OPENING_BALANCE NUMERIC(25,2) 19
27 STATISTICAL_UNITS_DEBIT_QUANTITY NUMERIC(24,2) 19
28 STATISTICAL_UNITS_CREDIT_QUANTITY NUMERIC(24,2) 19
29 STATISTICAL_UNITS_SIGNED_NET NUMERIC(25,2) 19
30 STATISTIC_UNITS_CLOSING_BALANCE NUMERIC(26,2) 19
31 STATISTICAL_UNITS_YTD_DEBIT NUMERIC(25,2) 19
32 STATISTICAL_UNITS_YTD_CREDIT NUMERIC(25,2) 19
33 STATISTIC_UNITS_YEAR_OPENING NUMERIC(25,2) 19
34 YEAR_END_INDICATOR INTEGER 4