OEB_GL_LEDGERS

Database

SDSNZS01_R12

Schema

CDCPADM_R12

Type

TABLE

Description

 

Columns
# Name Data Type Length
1 LEDGER_ID BIGINT 8
2 NAME CHARACTER VARYING(30) 30
3 SHORT_NAME CHARACTER VARYING(20) 20
4 DESCRIPTION CHARACTER VARYING(240) 240
5 LEDGER_CATEGORY_CODE CHARACTER VARYING(30) 30
6 ALC_LEDGER_TYPE_CODE CHARACTER VARYING(30) 30
7 OBJECT_TYPE_CODE CHARACTER VARYING(1) 1
8 LE_LEDGER_TYPE_CODE CHARACTER VARYING(1) 1
9 COMPLETION_STATUS_CODE CHARACTER VARYING(30) 30
10 CONFIGURATION_ID BIGINT 8
11 CHART_OF_ACCOUNTS_ID BIGINT 8
12 CURRENCY_CODE CHARACTER VARYING(15) 15
13 PERIOD_SET_NAME CHARACTER VARYING(15) 15
14 ACCOUNTED_PERIOD_TYPE CHARACTER VARYING(15) 15
15 FIRST_LEDGER_PERIOD_NAME CHARACTER VARYING(15) 15
16 RET_EARN_CODE_COMBINATION_ID BIGINT 8
17 SUSPENSE_ALLOWED_FLAG CHARACTER VARYING(1) 1
18 ALLOW_INTERCOMPANY_POST_FLAG CHARACTER VARYING(1) 1
19 TRACK_ROUNDING_IMBALANCE_FLAG CHARACTER VARYING(1) 1
20 ENABLE_AVERAGE_BALANCES_FLAG CHARACTER VARYING(1) 1
21 CUM_TRANS_CODE_COMBINATION_ID BIGINT 8
22 RES_ENCUMB_CODE_COMBINATION_ID BIGINT 8
23 NET_INCOME_CODE_COMBINATION_ID BIGINT 8
24 ROUNDING_CODE_COMBINATION_ID BIGINT 8
25 ENABLE_BUDGETARY_CONTROL_FLAG CHARACTER VARYING(1) 1
26 REQUIRE_BUDGET_JOURNALS_FLAG CHARACTER VARYING(1) 1
27 ENABLE_JE_APPROVAL_FLAG CHARACTER VARYING(1) 1
28 ENABLE_AUTOMATIC_TAX_FLAG CHARACTER VARYING(1) 1
29 CONSOLIDATION_LEDGER_FLAG CHARACTER VARYING(1) 1
30 TRANSLATE_EOD_FLAG CHARACTER VARYING(1) 1
31 TRANSLATE_QATD_FLAG CHARACTER VARYING(1) 1
32 TRANSLATE_YATD_FLAG CHARACTER VARYING(1) 1
33 TRANSACTION_CALENDAR_ID BIGINT 8
34 DAILY_TRANSLATION_RATE_TYPE CHARACTER VARYING(30) 30
35 AUTOMATICALLY_CREATED_FLAG CHARACTER VARYING(1) 1
36 BAL_SEG_VALUE_OPTION_CODE CHARACTER VARYING(1) 1
37 BAL_SEG_COLUMN_NAME CHARACTER VARYING(25) 25
38 MGT_SEG_VALUE_OPTION_CODE CHARACTER VARYING(1) 1
39 MGT_SEG_COLUMN_NAME CHARACTER VARYING(25) 25
40 BAL_SEG_VALUE_SET_ID BIGINT 8
41 MGT_SEG_VALUE_SET_ID BIGINT 8
42 IMPLICIT_ACCESS_SET_ID BIGINT 8
43 CRITERIA_SET_ID BIGINT 8
44 FUTURE_ENTERABLE_PERIODS_LIMIT BIGINT 8
45 LEDGER_ATTRIBUTES CHARACTER VARYING(1000) 1000
46 IMPLICIT_LEDGER_SET_ID BIGINT 8
47 LATEST_OPENED_PERIOD_NAME CHARACTER VARYING(15) 15
48 LATEST_ENCUMBRANCE_YEAR BIGINT 8
49 PERIOD_AVERAGE_RATE_TYPE CHARACTER VARYING(30) 30
50 PERIOD_END_RATE_TYPE CHARACTER VARYING(30) 30
51 BUDGET_PERIOD_AVG_RATE_TYPE CHARACTER VARYING(30) 30
52 BUDGET_PERIOD_END_RATE_TYPE CHARACTER VARYING(30) 30
53 SLA_ACCOUNTING_METHOD_CODE CHARACTER VARYING(30) 30
54 SLA_ACCOUNTING_METHOD_TYPE CHARACTER VARYING(1) 1
55 SLA_DESCRIPTION_LANGUAGE CHARACTER VARYING(15) 15
56 SLA_ENTERED_CUR_BAL_SUS_CCID BIGINT 8
57 SLA_SEQUENCING_FLAG CHARACTER VARYING(1) 1
58 SLA_BAL_BY_LEDGER_CURR_FLAG CHARACTER VARYING(1) 1
59 SLA_LEDGER_CUR_BAL_SUS_CCID BIGINT 8
60 ENABLE_SECONDARY_TRACK_FLAG CHARACTER VARYING(1) 1
61 ENABLE_REVAL_SS_TRACK_FLAG CHARACTER VARYING(1) 1
62 LAST_UPDATE_DATE TIMESTAMP 8
63 LAST_UPDATED_BY BIGINT 8
64 CREATION_DATE TIMESTAMP 8
65 CREATED_BY BIGINT 8
66 LAST_UPDATE_LOGIN BIGINT 8
67 CONTEXT CHARACTER VARYING(150) 150
68 ATTRIBUTE1 CHARACTER VARYING(150) 150
69 ATTRIBUTE2 CHARACTER VARYING(150) 150
70 ATTRIBUTE3 CHARACTER VARYING(150) 150
71 ATTRIBUTE4 CHARACTER VARYING(150) 150
72 ATTRIBUTE5 CHARACTER VARYING(150) 150
73 ATTRIBUTE6 CHARACTER VARYING(150) 150
74 ATTRIBUTE7 CHARACTER VARYING(150) 150
75 ATTRIBUTE8 CHARACTER VARYING(150) 150
76 ATTRIBUTE9 CHARACTER VARYING(150) 150
77 ATTRIBUTE10 CHARACTER VARYING(150) 150
78 ATTRIBUTE11 CHARACTER VARYING(150) 150
79 ATTRIBUTE12 CHARACTER VARYING(150) 150
80 ATTRIBUTE13 CHARACTER VARYING(150) 150
81 ATTRIBUTE14 CHARACTER VARYING(150) 150
82 ATTRIBUTE15 CHARACTER VARYING(150) 150
83 ENABLE_RECONCILIATION_FLAG CHARACTER VARYING(1) 1
84 CREATE_JE_FLAG CHARACTER VARYING(1) 1
85 SLA_LEDGER_CASH_BASIS_FLAG CHARACTER VARYING(1) 1
86 COMPLETE_FLAG CHARACTER VARYING(1) 1
87 COMMITMENT_BUDGET_FLAG CHARACTER VARYING(1) 1
88 NET_CLOSING_BAL_FLAG CHARACTER VARYING(1) 1
89 AUTOMATE_SEC_JRNL_REV_FLAG CHARACTER VARYING(1) 1
90 CDC_SOURCE_SYSTEM_CODE CHARACTER VARYING(4) 4
91 CDC_RECORD_TYPE CHARACTER VARYING(16) 16
92 CDC_COMMIT_TIMESTAMP TIMESTAMP 8
93 CDC_EXTRACT_TIMESTAMP TIMESTAMP 8