OEB_XLA_AE_HEADERS

Database

SDSNZS01_R12

Schema

CDCPADM_R12

Type

TABLE

Description

 

Columns
# Name Data Type Length
1 AE_HEADER_ID BIGINT 8
2 APPLICATION_ID BIGINT 8
3 LEDGER_ID BIGINT 8
4 ENTITY_ID BIGINT 8
5 EVENT_ID BIGINT 8
6 EVENT_TYPE_CODE CHARACTER VARYING(30) 30
7 ACCOUNTING_DATE TIMESTAMP 8
8 GL_TRANSFER_STATUS_CODE CHARACTER VARYING(30) 30
9 GL_TRANSFER_DATE TIMESTAMP 8
10 JE_CATEGORY_NAME CHARACTER VARYING(30) 30
11 ACCOUNTING_ENTRY_STATUS_CODE CHARACTER VARYING(30) 30
12 ACCOUNTING_ENTRY_TYPE_CODE CHARACTER VARYING(30) 30
13 AMB_CONTEXT_CODE CHARACTER VARYING(30) 30
14 PRODUCT_RULE_TYPE_CODE CHARACTER VARYING(1) 1
15 PRODUCT_RULE_CODE CHARACTER VARYING(30) 30
16 PRODUCT_RULE_VERSION CHARACTER VARYING(30) 30
17 DESCRIPTION CHARACTER VARYING(1996) 1996
18 DOC_SEQUENCE_ID DOUBLE PRECISION 8
19 DOC_SEQUENCE_VALUE DOUBLE PRECISION 8
20 ACCOUNTING_BATCH_ID BIGINT 8
21 COMPLETION_ACCT_SEQ_VERSION_ID BIGINT 8
22 CLOSE_ACCT_SEQ_VERSION_ID BIGINT 8
23 COMPLETION_ACCT_SEQ_VALUE DOUBLE PRECISION 8
24 CLOSE_ACCT_SEQ_VALUE DOUBLE PRECISION 8
25 BUDGET_VERSION_ID BIGINT 8
26 FUNDS_STATUS_CODE CHARACTER VARYING(30) 30
27 ENCUMBRANCE_TYPE_ID BIGINT 8
28 BALANCE_TYPE_CODE CHARACTER VARYING(1) 1
29 REFERENCE_DATE TIMESTAMP 8
30 COMPLETED_DATE TIMESTAMP 8
31 PERIOD_NAME CHARACTER VARYING(15) 15
32 PACKET_ID BIGINT 8
33 COMPLETION_ACCT_SEQ_ASSIGN_ID BIGINT 8
34 CLOSE_ACCT_SEQ_ASSIGN_ID BIGINT 8
35 DOC_CATEGORY_CODE CHARACTER VARYING(30) 30
36 ATTRIBUTE_CATEGORY CHARACTER VARYING(30) 30
37 ATTRIBUTE1 CHARACTER VARYING(150) 150
38 ATTRIBUTE2 CHARACTER VARYING(150) 150
39 ATTRIBUTE3 CHARACTER VARYING(150) 150
40 ATTRIBUTE4 CHARACTER VARYING(150) 150
41 ATTRIBUTE5 CHARACTER VARYING(150) 150
42 ATTRIBUTE6 CHARACTER VARYING(150) 150
43 ATTRIBUTE7 CHARACTER VARYING(150) 150
44 ATTRIBUTE8 CHARACTER VARYING(150) 150
45 ATTRIBUTE9 CHARACTER VARYING(150) 150
46 ATTRIBUTE10 CHARACTER VARYING(150) 150
47 ATTRIBUTE11 CHARACTER VARYING(150) 150
48 ATTRIBUTE12 CHARACTER VARYING(150) 150
49 ATTRIBUTE13 CHARACTER VARYING(150) 150
50 ATTRIBUTE14 CHARACTER VARYING(150) 150
51 ATTRIBUTE15 CHARACTER VARYING(150) 150
52 GROUP_ID BIGINT 8
53 DOC_SEQUENCE_VERSION_ID BIGINT 8
54 DOC_SEQUENCE_ASSIGN_ID BIGINT 8
55 CREATION_DATE TIMESTAMP 8
56 CREATED_BY BIGINT 8
57 LAST_UPDATE_DATE TIMESTAMP 8
58 LAST_UPDATED_BY BIGINT 8
59 LAST_UPDATE_LOGIN BIGINT 8
60 PROGRAM_UPDATE_DATE TIMESTAMP 8
61 PROGRAM_APPLICATION_ID BIGINT 8
62 PROGRAM_ID BIGINT 8
63 REQUEST_ID BIGINT 8
64 UPG_BATCH_ID BIGINT 8
65 UPG_SOURCE_APPLICATION_ID BIGINT 8
66 UPG_VALID_FLAG CHARACTER VARYING(1) 1
67 ZERO_AMOUNT_FLAG CHARACTER VARYING(1) 1
68 PARENT_AE_HEADER_ID BIGINT 8
69 PARENT_AE_LINE_NUM BIGINT 8
70 ACCRUAL_REVERSAL_FLAG CHARACTER VARYING(1) 1
71 MERGE_EVENT_ID BIGINT 8
72 NEED_BAL_FLAG CHARACTER VARYING(1) 1
73 CDC_SOURCE_SYSTEM_CODE CHARACTER VARYING(4) 4
74 CDC_RECORD_TYPE CHARACTER VARYING(16) 16
75 CDC_COMMIT_TIMESTAMP TIMESTAMP 8
76 CDC_EXTRACT_TIMESTAMP TIMESTAMP 8