OEB_RA_CUST_TRX_LINE_GL_DIST_ALL

Database

SDSNZS01_R12

Schema

CDCPADM_R12

Type

TABLE

Description

 

Columns
# Name Data Type Length
1 CUST_TRX_LINE_GL_DIST_ID BIGINT 8
2 CUSTOMER_TRX_LINE_ID BIGINT 8
3 CODE_COMBINATION_ID BIGINT 8
4 SET_OF_BOOKS_ID BIGINT 8
5 LAST_UPDATE_DATE TIMESTAMP 8
6 LAST_UPDATED_BY BIGINT 8
7 CREATION_DATE TIMESTAMP 8
8 CREATED_BY BIGINT 8
9 LAST_UPDATE_LOGIN BIGINT 8
10 PERCENT BIGINT 8
11 AMOUNT BIGINT 8
12 GL_DATE TIMESTAMP 8
13 GL_POSTED_DATE TIMESTAMP 8
14 CUST_TRX_LINE_SALESREP_ID BIGINT 8
15 COMMENTS CHARACTER VARYING(240) 240
16 ATTRIBUTE_CATEGORY CHARACTER VARYING(30) 30
17 ATTRIBUTE1 CHARACTER VARYING(150) 150
18 ATTRIBUTE2 CHARACTER VARYING(150) 150
19 ATTRIBUTE3 CHARACTER VARYING(150) 150
20 ATTRIBUTE4 CHARACTER VARYING(150) 150
21 ATTRIBUTE5 CHARACTER VARYING(150) 150
22 ATTRIBUTE6 CHARACTER VARYING(150) 150
23 ATTRIBUTE7 CHARACTER VARYING(150) 150
24 ATTRIBUTE8 CHARACTER VARYING(150) 150
25 ATTRIBUTE9 CHARACTER VARYING(150) 150
26 ATTRIBUTE10 CHARACTER VARYING(150) 150
27 REQUEST_ID BIGINT 8
28 PROGRAM_APPLICATION_ID BIGINT 8
29 PROGRAM_ID BIGINT 8
30 PROGRAM_UPDATE_DATE TIMESTAMP 8
31 CONCATENATED_SEGMENTS CHARACTER VARYING(240) 240
32 ORIGINAL_GL_DATE TIMESTAMP 8
33 POST_REQUEST_ID BIGINT 8
34 POSTING_CONTROL_ID BIGINT 8
35 ACCOUNT_CLASS CHARACTER VARYING(20) 20
36 RA_POST_LOOP_NUMBER BIGINT 8
37 CUSTOMER_TRX_ID BIGINT 8
38 ACCOUNT_SET_FLAG CHARACTER VARYING(1) 1
39 ACCTD_AMOUNT BIGINT 8
40 USSGL_TRANSACTION_CODE CHARACTER VARYING(30) 30
41 USSGL_TRANSACTION_CODE_CONTEXT CHARACTER VARYING(30) 30
42 ATTRIBUTE11 CHARACTER VARYING(150) 150
43 ATTRIBUTE12 CHARACTER VARYING(150) 150
44 ATTRIBUTE13 CHARACTER VARYING(150) 150
45 ATTRIBUTE14 CHARACTER VARYING(150) 150
46 ATTRIBUTE15 CHARACTER VARYING(150) 150
47 LATEST_REC_FLAG CHARACTER VARYING(1) 1
48 ORG_ID BIGINT 8
49 MRC_GL_POSTED_DATE CHARACTER VARYING(2000) 2000
50 MRC_POSTING_CONTROL_ID CHARACTER VARYING(2000) 2000
51 MRC_ACCTD_AMOUNT CHARACTER VARYING(2000) 2000
52 MRC_ACCOUNT_CLASS CHARACTER VARYING(2000) 2000
53 MRC_CUSTOMER_TRX_ID CHARACTER VARYING(2000) 2000
54 MRC_AMOUNT CHARACTER VARYING(2000) 2000
55 COLLECTED_TAX_CCID BIGINT 8
56 COLLECTED_TAX_CONCAT_SEG CHARACTER VARYING(240) 240
57 REVENUE_ADJUSTMENT_ID BIGINT 8
58 REV_ADJ_CLASS_TEMP CHARACTER VARYING(30) 30
59 REC_OFFSET_FLAG CHARACTER VARYING(1) 1
60 EVENT_ID BIGINT 8
61 USER_GENERATED_FLAG CHARACTER VARYING(1) 1
62 ROUNDING_CORRECTION_FLAG CHARACTER VARYING(1) 1
63 COGS_REQUEST_ID BIGINT 8
64 CCID_CHANGE_FLAG CHARACTER VARYING(1) 1
65 GLOBAL_ATTRIBUTE1 CHARACTER VARYING(150) 150
66 GLOBAL_ATTRIBUTE2 CHARACTER VARYING(150) 150
67 GLOBAL_ATTRIBUTE3 CHARACTER VARYING(150) 150
68 GLOBAL_ATTRIBUTE4 CHARACTER VARYING(150) 150
69 GLOBAL_ATTRIBUTE5 CHARACTER VARYING(150) 150
70 GLOBAL_ATTRIBUTE6 CHARACTER VARYING(150) 150
71 GLOBAL_ATTRIBUTE7 CHARACTER VARYING(150) 150
72 GLOBAL_ATTRIBUTE8 CHARACTER VARYING(150) 150
73 GLOBAL_ATTRIBUTE9 CHARACTER VARYING(150) 150
74 GLOBAL_ATTRIBUTE10 CHARACTER VARYING(150) 150
75 GLOBAL_ATTRIBUTE11 CHARACTER VARYING(150) 150
76 GLOBAL_ATTRIBUTE12 CHARACTER VARYING(150) 150
77 GLOBAL_ATTRIBUTE13 CHARACTER VARYING(150) 150
78 GLOBAL_ATTRIBUTE14 CHARACTER VARYING(150) 150
79 GLOBAL_ATTRIBUTE15 CHARACTER VARYING(150) 150
80 GLOBAL_ATTRIBUTE16 CHARACTER VARYING(150) 150
81 GLOBAL_ATTRIBUTE17 CHARACTER VARYING(150) 150
82 GLOBAL_ATTRIBUTE18 CHARACTER VARYING(150) 150
83 GLOBAL_ATTRIBUTE19 CHARACTER VARYING(150) 150
84 GLOBAL_ATTRIBUTE20 CHARACTER VARYING(150) 150
85 GLOBAL_ATTRIBUTE21 CHARACTER VARYING(150) 150
86 GLOBAL_ATTRIBUTE22 CHARACTER VARYING(150) 150
87 GLOBAL_ATTRIBUTE23 CHARACTER VARYING(150) 150
88 GLOBAL_ATTRIBUTE24 CHARACTER VARYING(150) 150
89 GLOBAL_ATTRIBUTE25 CHARACTER VARYING(150) 150
90 GLOBAL_ATTRIBUTE26 CHARACTER VARYING(150) 150
91 GLOBAL_ATTRIBUTE27 CHARACTER VARYING(150) 150
92 GLOBAL_ATTRIBUTE28 CHARACTER VARYING(150) 150
93 GLOBAL_ATTRIBUTE29 CHARACTER VARYING(150) 150
94 GLOBAL_ATTRIBUTE30 CHARACTER VARYING(150) 150
95 GLOBAL_ATTRIBUTE_CATEGORY CHARACTER VARYING(30) 30
96 CDC_SOURCE_SYSTEM_CODE CHARACTER VARYING(4) 4
97 CDC_RECORD_TYPE CHARACTER VARYING(16) 16
98 CDC_COMMIT_TIMESTAMP TIMESTAMP 8
99 CDC_EXTRACT_TIMESTAMP TIMESTAMP 8