FCT_SDW_TSDMF_OF_GL_BALANCE_MSR

Database

SDSNZP05_BANK

Schema

BANKPADM

Type

VIEW

Description

 

Columns
# Name Data Type Length
1 GL_BALANCE_SID BIGINT 8
2 CREATED_DATE TIMESTAMP 8
3 GL_BUDGET_VERSION_SID BIGINT 8
4 COST_CENTRE_SID BIGINT 8
5 ACCOUNT_SID BIGINT 8
6 CATEGORY_SID BIGINT 8
7 PRODUCT_SID BIGINT 8
8 STATE_SID BIGINT 8
9 INTERCOMPANY_SID BIGINT 8
10 ENTITY_SID BIGINT 8
11 SET_OF_BOOKS_SID BIGINT 8
12 SPARE_SID BIGINT 8
13 PROJECT_SID BIGINT 8
14 CLASS_SID BIGINT 8
15 CHANNEL_SID BIGINT 8
16 ALL_TIME_SID BIGINT 8
17 CHANGED_DATE TIMESTAMP 8
18 YEAR_OPENING_BALANCE_AMOUNT DOUBLE PRECISION 8
19 OPENING_BALANCE_AMOUNT DOUBLE PRECISION 8
20 SIGNED_NET_AMOUNT DOUBLE PRECISION 8
21 CLOSING_BALANCE_AMOUNT DOUBLE PRECISION 8
22 YTD_DEBIT_AMOUNT DOUBLE PRECISION 8
23 YTD_CREDIT_AMOUNT DOUBLE PRECISION 8
24 CREDIT_AMOUNT DOUBLE PRECISION 8
25 DEBIT_AMOUNT DOUBLE PRECISION 8
26 STATISTIC_UNITS_OPENING_BALA DOUBLE PRECISION 8
27 STATISTICAL_UNITS_DEBIT_QUAN DOUBLE PRECISION 8
28 STATISTICAL_UNITS_CREDIT_QUA DOUBLE PRECISION 8
29 STATISTICAL_UNITS_SIGNED_NET DOUBLE PRECISION 8
30 STATISTIC_UNITS_CLOSING_BALA DOUBLE PRECISION 8
31 STATISTICAL_UNITS_YTD_DEBIT_ DOUBLE PRECISION 8
32 STATISTICAL_UNITS_YTD_CREDIT DOUBLE PRECISION 8
33 STATISTIC_UNITS_YEAR_OPENING1 DOUBLE PRECISION 8
34 YEAR_END_INDICATOR CHARACTER VARYING(1) 1
35 BUSINESS_LOAD_DATE TIMESTAMP 8
36 CDC_SOURCE_SYSTEM_CODE CHARACTER VARYING(4) 4
37 CDC_RECORD_TYPE CHARACTER VARYING(16) 16
38 CDC_COMMIT_TIMESTAMP TIMESTAMP 8
39 CDC_EXTRACT_TIMESTAMP TIMESTAMP 8