OEB_HST_GL_JE_LINES_B

Database

SDSNZS01_R12

Schema

CDCPADM_R12

Type

TABLE

Description

 

Columns
# Name Data Type Length
1 JE_HEADER_ID BIGINT 8
2 JE_LINE_NUM BIGINT 8
3 LAST_UPDATE_DATE TIMESTAMP 8
4 LAST_UPDATED_BY BIGINT 8
5 LEDGER_ID BIGINT 8
6 CODE_COMBINATION_ID BIGINT 8
7 PERIOD_NAME CHARACTER VARYING(15) 15
8 EFFECTIVE_DATE TIMESTAMP 8
9 STATUS CHARACTER VARYING(1) 1
10 CREATION_DATE TIMESTAMP 8
11 CREATED_BY BIGINT 8
12 LAST_UPDATE_LOGIN BIGINT 8
13 ENTERED_DR NUMERIC(18,2) 19
14 ENTERED_CR NUMERIC(18,2) 19
15 ACCOUNTED_DR NUMERIC(18,2) 19
16 ACCOUNTED_CR NUMERIC(18,2) 19
17 DESCRIPTION CHARACTER VARYING(240) 240
18 REFERENCE_1 CHARACTER VARYING(240) 240
19 REFERENCE_2 CHARACTER VARYING(240) 240
20 REFERENCE_3 CHARACTER VARYING(240) 240
21 REFERENCE_4 CHARACTER VARYING(240) 240
22 REFERENCE_5 CHARACTER VARYING(240) 240
23 ATTRIBUTE1 CHARACTER VARYING(150) 150
24 ATTRIBUTE2 CHARACTER VARYING(150) 150
25 ATTRIBUTE3 CHARACTER VARYING(150) 150
26 ATTRIBUTE4 CHARACTER VARYING(150) 150
27 ATTRIBUTE5 CHARACTER VARYING(150) 150
28 ATTRIBUTE6 CHARACTER VARYING(150) 150
29 ATTRIBUTE7 CHARACTER VARYING(150) 150
30 ATTRIBUTE8 CHARACTER VARYING(150) 150
31 ATTRIBUTE9 CHARACTER VARYING(150) 150
32 ATTRIBUTE10 CHARACTER VARYING(150) 150
33 ATTRIBUTE11 CHARACTER VARYING(150) 150
34 ATTRIBUTE12 CHARACTER VARYING(150) 150
35 ATTRIBUTE13 CHARACTER VARYING(150) 150
36 ATTRIBUTE14 CHARACTER VARYING(150) 150
37 ATTRIBUTE15 CHARACTER VARYING(150) 150
38 ATTRIBUTE16 CHARACTER VARYING(150) 150
39 ATTRIBUTE17 CHARACTER VARYING(150) 150
40 ATTRIBUTE18 CHARACTER VARYING(150) 150
41 ATTRIBUTE19 CHARACTER VARYING(150) 150
42 ATTRIBUTE20 CHARACTER VARYING(150) 150
43 CONTEXT CHARACTER VARYING(150) 150
44 CONTEXT2 CHARACTER VARYING(150) 150
45 INVOICE_DATE TIMESTAMP 8
46 TAX_CODE CHARACTER VARYING(15) 15
47 INVOICE_IDENTIFIER CHARACTER VARYING(20) 20
48 INVOICE_AMOUNT NUMERIC(18,2) 19
49 NO1 CHARACTER VARYING(150) 150
50 STAT_AMOUNT NUMERIC(18,2) 19
51 IGNORE_RATE_FLAG CHARACTER VARYING(1) 1
52 CONTEXT3 CHARACTER VARYING(150) 150
53 USSGL_TRANSACTION_CODE CHARACTER VARYING(30) 30
54 SUBLEDGER_DOC_SEQUENCE_ID BIGINT 8
55 CONTEXT4 CHARACTER VARYING(150) 150
56 SUBLEDGER_DOC_SEQUENCE_VALUE NUMERIC(18,2) 19
57 REFERENCE_6 CHARACTER VARYING(240) 240
58 REFERENCE_7 CHARACTER VARYING(240) 240
59 REFERENCE_8 CHARACTER VARYING(240) 240
60 REFERENCE_9 CHARACTER VARYING(240) 240
61 REFERENCE_10 CHARACTER VARYING(240) 240
62 GLOBAL_ATTRIBUTE_CATEGORY CHARACTER VARYING(30) 30
63 GLOBAL_ATTRIBUTE1 CHARACTER VARYING(150) 150
64 GLOBAL_ATTRIBUTE2 CHARACTER VARYING(150) 150
65 GLOBAL_ATTRIBUTE3 CHARACTER VARYING(150) 150
66 GLOBAL_ATTRIBUTE4 CHARACTER VARYING(150) 150
67 GLOBAL_ATTRIBUTE5 CHARACTER VARYING(150) 150
68 GLOBAL_ATTRIBUTE6 CHARACTER VARYING(150) 150
69 GLOBAL_ATTRIBUTE7 CHARACTER VARYING(150) 150
70 GLOBAL_ATTRIBUTE8 CHARACTER VARYING(150) 150
71 GLOBAL_ATTRIBUTE9 CHARACTER VARYING(150) 150
72 GLOBAL_ATTRIBUTE10 CHARACTER VARYING(150) 150
73 JGZZ_RECON_STATUS_11I CHARACTER VARYING(1) 1
74 JGZZ_RECON_DATE_11I TIMESTAMP 8
75 JGZZ_RECON_ID_11I BIGINT 8
76 JGZZ_RECON_REF_11I CHARACTER VARYING(240) 240
77 JGZZ_RECON_CONTEXT_11I CHARACTER VARYING(30) 30
78 TAXABLE_LINE_FLAG CHARACTER VARYING(1) 1
79 TAX_TYPE_CODE CHARACTER VARYING(1) 1
80 TAX_CODE_ID BIGINT 8
81 TAX_ROUNDING_RULE_CODE CHARACTER VARYING(1) 1
82 AMOUNT_INCLUDES_TAX_FLAG CHARACTER VARYING(1) 1
83 TAX_DOCUMENT_IDENTIFIER CHARACTER VARYING(50) 50
84 TAX_DOCUMENT_DATE TIMESTAMP 8
85 TAX_CUSTOMER_NAME CHARACTER VARYING(240) 240
86 TAX_CUSTOMER_REFERENCE CHARACTER VARYING(240) 240
87 TAX_REGISTRATION_NUMBER CHARACTER VARYING(50) 50
88 TAX_LINE_FLAG CHARACTER VARYING(1) 1
89 TAX_GROUP_ID BIGINT 8
90 LINE_TYPE_CODE CHARACTER VARYING(20) 20
91 GL_SL_LINK_ID BIGINT 8
92 GL_SL_LINK_TABLE CHARACTER VARYING(30) 30
93 CO_THIRD_PARTY CHARACTER VARYING(14) 14
94 CO_PROCESSED_FLAG CHARACTER VARYING(1) 1
95 CDC_SOURCE_SYSTEM_CODE CHARACTER VARYING(4) 4
96 CDC_RECORD_TYPE CHARACTER VARYING(16) 16
97 CDC_COMMIT_TIMESTAMP TIMESTAMP 8
98 CDC_EXTRACT_TIMESTAMP TIMESTAMP 8