OBP24_HST_CZ_SC_OR_CTR_ANN_FIN

Database

SDSNZS01_OBP

Schema

CDCPADM_OBP

Type

TABLE

Description

 

Synonyms

SDSNZP05_BANK..CBP_OBP_HST_CZ_SC_OR_CTR_ANN_FIN

Columns
# Name Data Type Length
1 ANN_FIN_ID CHARACTER VARYING(100) 100
2 AUTO_ORG_ID CHARACTER VARYING(50) 50
3 APPLICATION_ID CHARACTER VARYING(100) 100
4 A_FIN_YEAR CHARACTER VARYING(50) 50
5 A_BAL_SHT_CUR_AST_CABA DOUBLE PRECISION 8
6 A_BAL_SHT_CUR_AST_TDA DOUBLE PRECISION 8
7 A_BAL_SHT_CUR_AST_SAIA DOUBLE PRECISION 8
8 A_BAL_SHT_CUR_AST_OCAA DOUBLE PRECISION 8
9 A_BAL_SHT_CUR_AST_TCAA DOUBLE PRECISION 8
10 A_BAL_SHT_NCUR_AST_OAA DOUBLE PRECISION 8
11 A_BAL_SHT_NCUR_AST_PAEA DOUBLE PRECISION 8
12 A_BAL_SHT_NCUR_AST_LTREA DOUBLE PRECISION 8
13 A_BAL_SHT_NCUR_AST_IAA DOUBLE PRECISION 8
14 A_BAL_SHT_NCUR_AST_OFAA DOUBLE PRECISION 8
15 A_BAL_SHT_NCUR_AST_TNCAA DOUBLE PRECISION 8
16 A_BAL_SHT_CLT_TPA DOUBLE PRECISION 8
17 A_BAL_SHT_CLT_TCA DOUBLE PRECISION 8
18 A_BAL_SHT_CLT_OLA DOUBLE PRECISION 8
19 A_BAL_SHT_CLT_GSTPA DOUBLE PRECISION 8
20 A_BAL_SHT_CLT_BODA DOUBLE PRECISION 8
21 A_BAL_SHT_CLT_TCLA DOUBLE PRECISION 8
22 A_BAL_SHT_NCLT_EFLA DOUBLE PRECISION 8
23 A_BAL_SHT_NCLT_LFREA DOUBLE PRECISION 8
24 A_BAL_SHT_NCLT_ONCLA DOUBLE PRECISION 8
25 A_BAL_SHT_NCLT_TNCLA DOUBLE PRECISION 8
26 A_BAL_SHT_ARRA DOUBLE PRECISION 8
27 A_BAL_SHT_OEIA DOUBLE PRECISION 8
28 A_BAL_SHT_TAA DOUBLE PRECISION 8
29 A_BAL_SHT_TLA DOUBLE PRECISION 8
30 A_BAL_SHT_PSFA DOUBLE PRECISION 8
31 A_BAL_SHT_TEA DOUBLE PRECISION 8
32 A_BAL_SHT_NWA DOUBLE PRECISION 8
33 A_PALT_GPTT_SALES DOUBLE PRECISION 8
34 A_PALT_GPTT_OS DOUBLE PRECISION 8
35 A_PALT_GPTT_PURCHASES DOUBLE PRECISION 8
36 A_PALT_GPTT_OCOS DOUBLE PRECISION 8
37 A_PALT_GPTT_CS DOUBLE PRECISION 8
38 A_PALT_GPTT_COGS DOUBLE PRECISION 8
39 A_PALT_GPTT_TGPT DOUBLE PRECISION 8
40 A_PALT_NPBTT_OBI DOUBLE PRECISION 8
41 A_PALT_NPBTT_EXP DOUBLE PRECISION 8
42 A_PALT_NPBTT_LSFA DOUBLE PRECISION 8
43 A_PALT_NPBTT_PSFA DOUBLE PRECISION 8
44 A_PALT_NPBTT_TNPBT DOUBLE PRECISION 8
45 A_PALT_COST_INT_EXP DOUBLE PRECISION 8
46 A_PALT_COST_FIN_LEASING DOUBLE PRECISION 8
47 A_PALT_COST_DEP DOUBLE PRECISION 8
48 A_PALT_COST_AMORTISATION DOUBLE PRECISION 8
49 A_PALT_COST_SWPO DOUBLE PRECISION 8
50 A_PALT_COST_OBIE DOUBLE PRECISION 8
51 A_PALT_COST_OBIE2 DOUBLE PRECISION 8
52 A_PALT_COST_TCOS DOUBLE PRECISION 8
53 A_PALT_OBIED CHARACTER VARYING(50) 50
54 A_PALT_OBIED2 CHARACTER VARYING(50) 50
55 A_PALT_COMP_TAX_EXP DOUBLE PRECISION 8
56 A_PALT_NET_ANN_INC DOUBLE PRECISION 8
57 CDC_SOURCE_SYSTEM_CODE CHARACTER VARYING(4) 4
58 CDC_RECORD_TYPE CHARACTER VARYING(16) 16
59 CDC_COMMIT_TIMESTAMP TIMESTAMP 8
60 CDC_EXTRACT_TIMESTAMP TIMESTAMP 8