OEB_GL_JE_BATCHES_B

Database

SDSNZS01_R12

Schema

CDCPADM_R12

Type

TABLE

Description

 

Columns
# Name Data Type Length
1 JE_BATCH_ID BIGINT 8
2 LAST_UPDATE_DATE TIMESTAMP 8
3 LAST_UPDATED_BY BIGINT 8
4 SET_OF_BOOKS_ID_11I BIGINT 8
5 NAME CHARACTER VARYING(100) 100
6 STATUS CHARACTER VARYING(1) 1
7 STATUS_VERIFIED CHARACTER VARYING(1) 1
8 ACTUAL_FLAG CHARACTER VARYING(1) 1
9 DEFAULT_EFFECTIVE_DATE TIMESTAMP 8
10 AVERAGE_JOURNAL_FLAG CHARACTER VARYING(1) 1
11 BUDGETARY_CONTROL_STATUS CHARACTER VARYING(1) 1
12 APPROVAL_STATUS_CODE CHARACTER VARYING(1) 1
13 CREATION_DATE TIMESTAMP 8
14 CREATED_BY BIGINT 8
15 LAST_UPDATE_LOGIN BIGINT 8
16 STATUS_RESET_FLAG CHARACTER VARYING(1) 1
17 DEFAULT_PERIOD_NAME CHARACTER VARYING(15) 15
18 UNIQUE_DATE CHARACTER VARYING(30) 30
19 EARLIEST_POSTABLE_DATE TIMESTAMP 8
20 POSTED_DATE TIMESTAMP 8
21 DATE_CREATED TIMESTAMP 8
22 DESCRIPTION CHARACTER VARYING(240) 240
23 CONTROL_TOTAL NUMERIC(24,2) 19
24 RUNNING_TOTAL_DR NUMERIC(24,2) 19
25 RUNNING_TOTAL_CR NUMERIC(24,2) 19
26 RUNNING_TOTAL_ACCOUNTED_DR NUMERIC(24,2) 19
27 RUNNING_TOTAL_ACCOUNTED_CR NUMERIC(24,2) 19
28 PARENT_JE_BATCH_ID BIGINT 8
29 ATTRIBUTE1 CHARACTER VARYING(150) 150
30 ATTRIBUTE2 CHARACTER VARYING(150) 150
31 ATTRIBUTE3 CHARACTER VARYING(150) 150
32 ATTRIBUTE4 CHARACTER VARYING(150) 150
33 ATTRIBUTE5 CHARACTER VARYING(150) 150
34 ATTRIBUTE6 CHARACTER VARYING(150) 150
35 ATTRIBUTE7 CHARACTER VARYING(150) 150
36 ATTRIBUTE8 CHARACTER VARYING(150) 150
37 ATTRIBUTE9 CHARACTER VARYING(150) 150
38 ATTRIBUTE10 CHARACTER VARYING(150) 150
39 CONTEXT CHARACTER VARYING(150) 150
40 PACKET_ID BIGINT 8
41 USSGL_TRANSACTION_CODE CHARACTER VARYING(30) 30
42 CONTEXT2 CHARACTER VARYING(150) 150
43 POSTING_RUN_ID BIGINT 8
44 REQUEST_ID BIGINT 8
45 UNRESERVATION_PACKET_ID BIGINT 8
46 ORG_ID BIGINT 8
47 POSTED_BY BIGINT 8
48 CHART_OF_ACCOUNTS_ID BIGINT 8
49 PERIOD_SET_NAME CHARACTER VARYING(15) 15
50 ACCOUNTED_PERIOD_TYPE CHARACTER VARYING(15) 15
51 GROUP_ID BIGINT 8
52 APPROVER_EMPLOYEE_ID BIGINT 8
53 GLOBAL_ATTRIBUTE_CATEGORY CHARACTER VARYING(150) 150
54 GLOBAL_ATTRIBUTE1 CHARACTER VARYING(150) 150
55 GLOBAL_ATTRIBUTE2 CHARACTER VARYING(150) 150
56 GLOBAL_ATTRIBUTE3 CHARACTER VARYING(150) 150
57 GLOBAL_ATTRIBUTE4 CHARACTER VARYING(150) 150
58 GLOBAL_ATTRIBUTE5 CHARACTER VARYING(150) 150
59 GLOBAL_ATTRIBUTE6 CHARACTER VARYING(150) 150
60 GLOBAL_ATTRIBUTE7 CHARACTER VARYING(150) 150
61 GLOBAL_ATTRIBUTE8 CHARACTER VARYING(150) 150
62 GLOBAL_ATTRIBUTE9 CHARACTER VARYING(150) 150
63 GLOBAL_ATTRIBUTE10 CHARACTER VARYING(150) 150
64 GLOBAL_ATTRIBUTE11 CHARACTER VARYING(150) 150
65 GLOBAL_ATTRIBUTE12 CHARACTER VARYING(150) 150
66 GLOBAL_ATTRIBUTE13 CHARACTER VARYING(150) 150
67 GLOBAL_ATTRIBUTE14 CHARACTER VARYING(150) 150
68 GLOBAL_ATTRIBUTE15 CHARACTER VARYING(150) 150
69 GLOBAL_ATTRIBUTE16 CHARACTER VARYING(150) 150
70 GLOBAL_ATTRIBUTE17 CHARACTER VARYING(150) 150
71 GLOBAL_ATTRIBUTE18 CHARACTER VARYING(150) 150
72 GLOBAL_ATTRIBUTE19 CHARACTER VARYING(150) 150
73 GLOBAL_ATTRIBUTE20 CHARACTER VARYING(150) 150
74 CDC_SOURCE_SYSTEM_CODE CHARACTER VARYING(4) 4
75 CDC_RECORD_TYPE CHARACTER VARYING(16) 16
76 CDC_COMMIT_TIMESTAMP TIMESTAMP 8
77 CDC_EXTRACT_TIMESTAMP TIMESTAMP 8