OEB_GL_JE_HEADERS_B

Database

INSNZP01_R12

Schema

R12PADM

Type

VIEW

Description

 

Columns
# Name Data Type Length
1 JE_HEADER_ID BIGINT 8
2 LAST_UPDATE_DATE TIMESTAMP 8
3 LAST_UPDATED_BY BIGINT 8
4 LEDGER_ID BIGINT 8
5 JE_CATEGORY CHARACTER VARYING(25) 25
6 JE_SOURCE CHARACTER VARYING(25) 25
7 PERIOD_NAME CHARACTER VARYING(15) 15
8 NAME CHARACTER VARYING(100) 100
9 CURRENCY_CODE CHARACTER VARYING(15) 15
10 STATUS CHARACTER VARYING(1) 1
11 DATE_CREATED TIMESTAMP 8
12 ACCRUAL_REV_FLAG CHARACTER VARYING(1) 1
13 MULTI_BAL_SEG_FLAG CHARACTER VARYING(1) 1
14 ACTUAL_FLAG CHARACTER VARYING(1) 1
15 DEFAULT_EFFECTIVE_DATE TIMESTAMP 8
16 TAX_STATUS_CODE CHARACTER VARYING(1) 1
17 CONVERSION_FLAG CHARACTER VARYING(1) 1
18 CREATION_DATE TIMESTAMP 8
19 CREATED_BY BIGINT 8
20 LAST_UPDATE_LOGIN BIGINT 8
21 ENCUMBRANCE_TYPE_ID BIGINT 8
22 BUDGET_VERSION_ID BIGINT 8
23 BALANCED_JE_FLAG CHARACTER VARYING(1) 1
24 BALANCING_SEGMENT_VALUE CHARACTER VARYING(25) 25
25 JE_BATCH_ID BIGINT 8
26 FROM_RECURRING_HEADER_ID BIGINT 8
27 UNIQUE_DATE CHARACTER VARYING(30) 30
28 EARLIEST_POSTABLE_DATE TIMESTAMP 8
29 POSTED_DATE TIMESTAMP 8
30 ACCRUAL_REV_EFFECTIVE_DATE TIMESTAMP 8
31 ACCRUAL_REV_PERIOD_NAME CHARACTER VARYING(15) 15
32 ACCRUAL_REV_STATUS CHARACTER VARYING(1) 1
33 ACCRUAL_REV_JE_HEADER_ID BIGINT 8
34 ACCRUAL_REV_CHANGE_SIGN_FLAG CHARACTER VARYING(1) 1
35 DESCRIPTION CHARACTER VARYING(240) 240
36 CONTROL_TOTAL NUMERIC(24,2) 19
37 RUNNING_TOTAL_DR NUMERIC(24,2) 19
38 RUNNING_TOTAL_CR NUMERIC(24,2) 19
39 RUNNING_TOTAL_ACCOUNTED_DR NUMERIC(24,2) 19
40 RUNNING_TOTAL_ACCOUNTED_CR NUMERIC(24,2) 19
41 CURRENCY_CONVERSION_RATE NUMERIC(18,2) 19
42 CURRENCY_CONVERSION_TYPE CHARACTER VARYING(30) 30
43 CURRENCY_CONVERSION_DATE TIMESTAMP 8
44 EXTERNAL_REFERENCE CHARACTER VARYING(80) 80
45 PARENT_JE_HEADER_ID BIGINT 8
46 REVERSED_JE_HEADER_ID BIGINT 8
47 ATTRIBUTE1 CHARACTER VARYING(150) 150
48 ATTRIBUTE2 CHARACTER VARYING(150) 150
49 ATTRIBUTE3 CHARACTER VARYING(150) 150
50 ATTRIBUTE4 CHARACTER VARYING(150) 150
51 ATTRIBUTE5 CHARACTER VARYING(150) 150
52 ATTRIBUTE6 CHARACTER VARYING(150) 150
53 ATTRIBUTE7 CHARACTER VARYING(150) 150
54 ATTRIBUTE8 CHARACTER VARYING(150) 150
55 ATTRIBUTE9 CHARACTER VARYING(150) 150
56 ATTRIBUTE10 CHARACTER VARYING(150) 150
57 CONTEXT CHARACTER VARYING(150) 150
58 GLOBAL_ATTRIBUTE_CATEGORY CHARACTER VARYING(30) 30
59 GLOBAL_ATTRIBUTE1 CHARACTER VARYING(150) 150
60 GLOBAL_ATTRIBUTE2 CHARACTER VARYING(150) 150
61 GLOBAL_ATTRIBUTE3 CHARACTER VARYING(150) 150
62 GLOBAL_ATTRIBUTE4 CHARACTER VARYING(150) 150
63 GLOBAL_ATTRIBUTE5 CHARACTER VARYING(150) 150
64 GLOBAL_ATTRIBUTE6 CHARACTER VARYING(150) 150
65 GLOBAL_ATTRIBUTE7 CHARACTER VARYING(150) 150
66 GLOBAL_ATTRIBUTE8 CHARACTER VARYING(150) 150
67 GLOBAL_ATTRIBUTE9 CHARACTER VARYING(150) 150
68 GLOBAL_ATTRIBUTE10 CHARACTER VARYING(150) 150
69 USSGL_TRANSACTION_CODE CHARACTER VARYING(30) 30
70 CONTEXT2 CHARACTER VARYING(150) 150
71 DOC_SEQUENCE_ID BIGINT 8
72 DOC_SEQUENCE_VALUE NUMERIC(18,2) 19
73 JGZZ_RECON_CONTEXT CHARACTER VARYING(30) 30
74 JGZZ_RECON_REF CHARACTER VARYING(240) 240
75 ORIGINATING_BAL_SEG_VALUE CHARACTER VARYING(25) 25
76 INTERCOMPANY_MODE BIGINT 8
77 DR_BAL_SEG_VALUE CHARACTER VARYING(25) 25
78 CR_BAL_SEG_VALUE CHARACTER VARYING(25) 25
79 REFERENCE_DATE TIMESTAMP 8
80 LOCAL_DOC_SEQUENCE_ID BIGINT 8
81 LOCAL_DOC_SEQUENCE_VALUE NUMERIC(18,2) 19
82 DISPLAY_ALC_JOURNAL_FLAG CHARACTER VARYING(1) 1
83 JE_FROM_SLA_FLAG CHARACTER VARYING(1) 1
84 POSTING_ACCT_SEQ_VERSION_ID BIGINT 8
85 POSTING_ACCT_SEQ_ASSIGN_ID BIGINT 8
86 POSTING_ACCT_SEQ_VALUE NUMERIC(18,2) 19
87 CLOSE_ACCT_SEQ_VERSION_ID BIGINT 8
88 CLOSE_ACCT_SEQ_ASSIGN_ID BIGINT 8
89 CLOSE_ACCT_SEQ_VALUE NUMERIC(18,2) 19
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