OEB_HST_GL_CODE_COMBINATIONS_B

Database

SDSNZS01_R12

Schema

CDCPADM_R12

Type

TABLE

Description

 

Columns
# Name Data Type Length
1 CODE_COMBINATION_ID BIGINT 8
2 LAST_UPDATE_DATE TIMESTAMP 8
3 LAST_UPDATED_BY BIGINT 8
4 CHART_OF_ACCOUNTS_ID BIGINT 8
5 DETAIL_POSTING_ALLOWED_FLAG CHARACTER VARYING(1) 1
6 DETAIL_BUDGETING_ALLOWED_FLAG CHARACTER VARYING(1) 1
7 ACCOUNT_TYPE CHARACTER VARYING(1) 1
8 ENABLED_FLAG CHARACTER VARYING(1) 1
9 SUMMARY_FLAG CHARACTER VARYING(1) 1
10 SEGMENT1 CHARACTER VARYING(25) 25
11 SEGMENT2 CHARACTER VARYING(25) 25
12 SEGMENT3 CHARACTER VARYING(25) 25
13 SEGMENT4 CHARACTER VARYING(25) 25
14 SEGMENT5 CHARACTER VARYING(25) 25
15 SEGMENT6 CHARACTER VARYING(25) 25
16 SEGMENT7 CHARACTER VARYING(25) 25
17 SEGMENT8 CHARACTER VARYING(25) 25
18 SEGMENT9 CHARACTER VARYING(25) 25
19 SEGMENT10 CHARACTER VARYING(25) 25
20 SEGMENT11 CHARACTER VARYING(25) 25
21 SEGMENT12 CHARACTER VARYING(25) 25
22 SEGMENT13 CHARACTER VARYING(25) 25
23 SEGMENT14 CHARACTER VARYING(25) 25
24 SEGMENT15 CHARACTER VARYING(25) 25
25 SEGMENT16 CHARACTER VARYING(25) 25
26 SEGMENT17 CHARACTER VARYING(25) 25
27 SEGMENT18 CHARACTER VARYING(25) 25
28 SEGMENT19 CHARACTER VARYING(25) 25
29 SEGMENT20 CHARACTER VARYING(25) 25
30 SEGMENT21 CHARACTER VARYING(25) 25
31 SEGMENT22 CHARACTER VARYING(25) 25
32 SEGMENT23 CHARACTER VARYING(25) 25
33 SEGMENT24 CHARACTER VARYING(25) 25
34 SEGMENT25 CHARACTER VARYING(25) 25
35 SEGMENT26 CHARACTER VARYING(25) 25
36 SEGMENT27 CHARACTER VARYING(25) 25
37 SEGMENT28 CHARACTER VARYING(25) 25
38 SEGMENT29 CHARACTER VARYING(25) 25
39 SEGMENT30 CHARACTER VARYING(25) 25
40 DESCRIPTION CHARACTER VARYING(240) 240
41 TEMPLATE_ID BIGINT 8
42 ALLOCATION_CREATE_FLAG CHARACTER VARYING(1) 1
43 START_DATE_ACTIVE TIMESTAMP 8
44 END_DATE_ACTIVE TIMESTAMP 8
45 ATTRIBUTE1 CHARACTER VARYING(150) 150
46 ATTRIBUTE2 CHARACTER VARYING(150) 150
47 ATTRIBUTE3 CHARACTER VARYING(150) 150
48 ATTRIBUTE4 CHARACTER VARYING(150) 150
49 ATTRIBUTE5 CHARACTER VARYING(150) 150
50 ATTRIBUTE6 CHARACTER VARYING(150) 150
51 ATTRIBUTE7 CHARACTER VARYING(150) 150
52 ATTRIBUTE8 CHARACTER VARYING(150) 150
53 ATTRIBUTE9 CHARACTER VARYING(150) 150
54 ATTRIBUTE10 CHARACTER VARYING(150) 150
55 CONTEXT CHARACTER VARYING(150) 150
56 SEGMENT_ATTRIBUTE1 CHARACTER VARYING(60) 60
57 SEGMENT_ATTRIBUTE2 CHARACTER VARYING(60) 60
58 SEGMENT_ATTRIBUTE3 CHARACTER VARYING(60) 60
59 SEGMENT_ATTRIBUTE4 CHARACTER VARYING(60) 60
60 SEGMENT_ATTRIBUTE5 CHARACTER VARYING(60) 60
61 SEGMENT_ATTRIBUTE6 CHARACTER VARYING(60) 60
62 SEGMENT_ATTRIBUTE7 CHARACTER VARYING(60) 60
63 SEGMENT_ATTRIBUTE8 CHARACTER VARYING(60) 60
64 SEGMENT_ATTRIBUTE9 CHARACTER VARYING(60) 60
65 SEGMENT_ATTRIBUTE10 CHARACTER VARYING(60) 60
66 SEGMENT_ATTRIBUTE11 CHARACTER VARYING(60) 60
67 SEGMENT_ATTRIBUTE12 CHARACTER VARYING(60) 60
68 SEGMENT_ATTRIBUTE13 CHARACTER VARYING(60) 60
69 SEGMENT_ATTRIBUTE14 CHARACTER VARYING(60) 60
70 SEGMENT_ATTRIBUTE15 CHARACTER VARYING(60) 60
71 SEGMENT_ATTRIBUTE16 CHARACTER VARYING(60) 60
72 SEGMENT_ATTRIBUTE17 CHARACTER VARYING(60) 60
73 SEGMENT_ATTRIBUTE18 CHARACTER VARYING(60) 60
74 SEGMENT_ATTRIBUTE19 CHARACTER VARYING(60) 60
75 SEGMENT_ATTRIBUTE20 CHARACTER VARYING(60) 60
76 SEGMENT_ATTRIBUTE21 CHARACTER VARYING(60) 60
77 SEGMENT_ATTRIBUTE22 CHARACTER VARYING(60) 60
78 SEGMENT_ATTRIBUTE23 CHARACTER VARYING(60) 60
79 SEGMENT_ATTRIBUTE24 CHARACTER VARYING(60) 60
80 SEGMENT_ATTRIBUTE25 CHARACTER VARYING(60) 60
81 SEGMENT_ATTRIBUTE26 CHARACTER VARYING(60) 60
82 SEGMENT_ATTRIBUTE27 CHARACTER VARYING(60) 60
83 SEGMENT_ATTRIBUTE28 CHARACTER VARYING(60) 60
84 SEGMENT_ATTRIBUTE29 CHARACTER VARYING(60) 60
85 SEGMENT_ATTRIBUTE30 CHARACTER VARYING(60) 60
86 SEGMENT_ATTRIBUTE31 CHARACTER VARYING(60) 60
87 SEGMENT_ATTRIBUTE32 CHARACTER VARYING(60) 60
88 SEGMENT_ATTRIBUTE33 CHARACTER VARYING(60) 60
89 SEGMENT_ATTRIBUTE34 CHARACTER VARYING(60) 60
90 SEGMENT_ATTRIBUTE35 CHARACTER VARYING(60) 60
91 SEGMENT_ATTRIBUTE36 CHARACTER VARYING(60) 60
92 SEGMENT_ATTRIBUTE37 CHARACTER VARYING(60) 60
93 SEGMENT_ATTRIBUTE38 CHARACTER VARYING(60) 60
94 SEGMENT_ATTRIBUTE39 CHARACTER VARYING(60) 60
95 SEGMENT_ATTRIBUTE40 CHARACTER VARYING(60) 60
96 SEGMENT_ATTRIBUTE41 CHARACTER VARYING(60) 60
97 SEGMENT_ATTRIBUTE42 CHARACTER VARYING(60) 60
98 REFERENCE1 CHARACTER VARYING(1) 1
99 REFERENCE2 CHARACTER VARYING(1) 1
100 REFERENCE3 CHARACTER VARYING(25) 25
101 REFERENCE4 CHARACTER VARYING(1) 1
102 REFERENCE5 CHARACTER VARYING(1) 1
103 JGZZ_RECON_FLAG CHARACTER VARYING(1) 1
104 JGZZ_RECON_CONTEXT CHARACTER VARYING(30) 30
105 PRESERVE_FLAG CHARACTER VARYING(1) 1
106 REFRESH_FLAG CHARACTER VARYING(1) 1
107 IGI_BALANCED_BUDGET_FLAG CHARACTER VARYING(1) 1
108 COMPANY_COST_CENTER_ORG_ID BIGINT 8
109 REVALUATION_ID BIGINT 8
110 LEDGER_SEGMENT CHARACTER VARYING(20) 20
111 LEDGER_TYPE_CODE CHARACTER VARYING(1) 1
112 ALTERNATE_CODE_COMBINATION_ID BIGINT 8
113 CDC_SOURCE_SYSTEM_CODE CHARACTER VARYING(4) 4
114 CDC_RECORD_TYPE CHARACTER VARYING(16) 16
115 CDC_COMMIT_TIMESTAMP TIMESTAMP 8
116 CDC_EXTRACT_TIMESTAMP TIMESTAMP 8