OEB_XLA_DISTRIBUTION_LINKS

Database

SDSNZS01_R12

Schema

CDCPADM_R12

Type

TABLE

Description

 

Columns
# Name Data Type Length
1 APPLICATION_ID BIGINT 8
2 EVENT_ID BIGINT 8
3 AE_HEADER_ID BIGINT 8
4 AE_LINE_NUM BIGINT 8
5 SOURCE_DISTRIBUTION_TYPE CHARACTER VARYING(30) 30
6 SOURCE_DISTRIBUTION_ID_CHAR_1 CHARACTER VARYING(240) 240
7 SOURCE_DISTRIBUTION_ID_CHAR_2 CHARACTER VARYING(240) 240
8 SOURCE_DISTRIBUTION_ID_CHAR_3 CHARACTER VARYING(240) 240
9 SOURCE_DISTRIBUTION_ID_CHAR_4 CHARACTER VARYING(240) 240
10 SOURCE_DISTRIBUTION_ID_CHAR_5 CHARACTER VARYING(240) 240
11 SOURCE_DISTRIBUTION_ID_NUM_1 BIGINT 8
12 SOURCE_DISTRIBUTION_ID_NUM_2 BIGINT 8
13 SOURCE_DISTRIBUTION_ID_NUM_3 BIGINT 8
14 SOURCE_DISTRIBUTION_ID_NUM_4 BIGINT 8
15 SOURCE_DISTRIBUTION_ID_NUM_5 BIGINT 8
16 TAX_LINE_REF_ID BIGINT 8
17 TAX_SUMMARY_LINE_REF_ID BIGINT 8
18 TAX_REC_NREC_DIST_REF_ID BIGINT 8
19 STATISTICAL_AMOUNT NUMERIC(18,2) 19
20 REF_AE_HEADER_ID BIGINT 8
21 REF_TEMP_LINE_NUM BIGINT 8
22 ACCOUNTING_LINE_CODE CHARACTER VARYING(30) 30
23 ACCOUNTING_LINE_TYPE_CODE CHARACTER VARYING(1) 1
24 MERGE_DUPLICATE_CODE CHARACTER VARYING(1) 1
25 TEMP_LINE_NUM BIGINT 8
26 REF_EVENT_ID BIGINT 8
27 LINE_DEFINITION_OWNER_CODE CHARACTER VARYING(30) 30
28 LINE_DEFINITION_CODE CHARACTER VARYING(30) 30
29 EVENT_CLASS_CODE CHARACTER VARYING(30) 30
30 EVENT_TYPE_CODE CHARACTER VARYING(30) 30
31 UPG_BATCH_ID BIGINT 8
32 CALCULATE_ACCTD_AMTS_FLAG CHARACTER VARYING(1) 1
33 CALCULATE_G_L_AMTS_FLAG CHARACTER VARYING(1) 1
34 ROUNDING_CLASS_CODE CHARACTER VARYING(30) 30
35 DOCUMENT_ROUNDING_LEVEL CHARACTER VARYING(30) 30
36 UNROUNDED_ENTERED_DR NUMERIC(18,2) 19
37 UNROUNDED_ENTERED_CR NUMERIC(18,2) 19
38 DOC_ROUNDING_ENTERED_AMT NUMERIC(18,2) 19
39 DOC_ROUNDING_ACCTD_AMT NUMERIC(18,2) 19
40 UNROUNDED_ACCOUNTED_CR NUMERIC(18,2) 19
41 UNROUNDED_ACCOUNTED_DR NUMERIC(18,2) 19
42 APPLIED_TO_APPLICATION_ID BIGINT 8
43 APPLIED_TO_ENTITY_CODE CHARACTER VARYING(30) 30
44 APPLIED_TO_ENTITY_ID BIGINT 8
45 APPLIED_TO_SOURCE_ID_NUM_1 BIGINT 8
46 APPLIED_TO_SOURCE_ID_NUM_2 BIGINT 8
47 APPLIED_TO_SOURCE_ID_NUM_3 BIGINT 8
48 APPLIED_TO_SOURCE_ID_NUM_4 BIGINT 8
49 APPLIED_TO_SOURCE_ID_CHAR_1 CHARACTER VARYING(30) 30
50 APPLIED_TO_SOURCE_ID_CHAR_2 CHARACTER VARYING(30) 30
51 APPLIED_TO_SOURCE_ID_CHAR_3 CHARACTER VARYING(30) 30
52 APPLIED_TO_SOURCE_ID_CHAR_4 CHARACTER VARYING(30) 30
53 APPLIED_TO_DISTRIBUTION_TYPE CHARACTER VARYING(30) 30
54 APPLIED_TO_DIST_ID_NUM_1 BIGINT 8
55 APPLIED_TO_DIST_ID_NUM_2 BIGINT 8
56 APPLIED_TO_DIST_ID_NUM_3 BIGINT 8
57 APPLIED_TO_DIST_ID_NUM_4 BIGINT 8
58 APPLIED_TO_DIST_ID_NUM_5 BIGINT 8
59 APPLIED_TO_DIST_ID_CHAR_1 CHARACTER VARYING(30) 30
60 APPLIED_TO_DIST_ID_CHAR_2 CHARACTER VARYING(30) 30
61 APPLIED_TO_DIST_ID_CHAR_3 CHARACTER VARYING(30) 30
62 APPLIED_TO_DIST_ID_CHAR_4 CHARACTER VARYING(30) 30
63 APPLIED_TO_DIST_ID_CHAR_5 CHARACTER VARYING(30) 30
64 ALLOC_TO_APPLICATION_ID BIGINT 8
65 ALLOC_TO_ENTITY_CODE CHARACTER VARYING(30) 30
66 ALLOC_TO_SOURCE_ID_NUM_1 BIGINT 8
67 ALLOC_TO_SOURCE_ID_NUM_2 BIGINT 8
68 ALLOC_TO_SOURCE_ID_NUM_3 BIGINT 8
69 ALLOC_TO_SOURCE_ID_NUM_4 BIGINT 8
70 ALLOC_TO_SOURCE_ID_CHAR_1 CHARACTER VARYING(30) 30
71 ALLOC_TO_SOURCE_ID_CHAR_2 CHARACTER VARYING(30) 30
72 ALLOC_TO_SOURCE_ID_CHAR_3 CHARACTER VARYING(30) 30
73 ALLOC_TO_SOURCE_ID_CHAR_4 CHARACTER VARYING(30) 30
74 ALLOC_TO_DISTRIBUTION_TYPE CHARACTER VARYING(30) 30
75 ALLOC_TO_DIST_ID_NUM_1 BIGINT 8
76 ALLOC_TO_DIST_ID_NUM_2 BIGINT 8
77 ALLOC_TO_DIST_ID_NUM_3 BIGINT 8
78 ALLOC_TO_DIST_ID_NUM_4 BIGINT 8
79 ALLOC_TO_DIST_ID_NUM_5 BIGINT 8
80 ALLOC_TO_DIST_ID_CHAR_1 CHARACTER VARYING(30) 30
81 ALLOC_TO_DIST_ID_CHAR_2 CHARACTER VARYING(30) 30
82 ALLOC_TO_DIST_ID_CHAR_3 CHARACTER VARYING(30) 30
83 ALLOC_TO_DIST_ID_CHAR_4 CHARACTER VARYING(30) 30
84 ALLOC_TO_DIST_ID_CHAR_5 CHARACTER VARYING(30) 30
85 GAIN_OR_LOSS_REF CHARACTER VARYING(30) 30
86 CDC_SOURCE_SYSTEM_CODE CHARACTER(4) 4
87 CDC_RECORD_TYPE CHARACTER(16) 16
88 CDC_COMMIT_TIMESTAMP TIMESTAMP 8
89 CDC_EXTRACT_TIMESTAMP TIMESTAMP 8
90 LAST_UPDATE_DATE TIMESTAMP 8