OEB_RA_CUSTOMER_TRX_ALL

Database

SDSNZS01_R12

Schema

CDCPADM_R12

Type

TABLE

Description

 

Columns
# Name Data Type Length
1 CUSTOMER_TRX_ID BIGINT 8
2 LAST_UPDATE_DATE TIMESTAMP 8
3 LAST_UPDATED_BY BIGINT 8
4 CREATION_DATE TIMESTAMP 8
5 CREATED_BY BIGINT 8
6 LAST_UPDATE_LOGIN BIGINT 8
7 TRX_NUMBER CHARACTER VARYING(20) 20
8 CUST_TRX_TYPE_ID BIGINT 8
9 TRX_DATE TIMESTAMP 8
10 SET_OF_BOOKS_ID BIGINT 8
11 BILL_TO_CONTACT_ID BIGINT 8
12 BATCH_ID BIGINT 8
13 BATCH_SOURCE_ID BIGINT 8
14 REASON_CODE CHARACTER VARYING(30) 30
15 SOLD_TO_CUSTOMER_ID BIGINT 8
16 SOLD_TO_CONTACT_ID BIGINT 8
17 SOLD_TO_SITE_USE_ID BIGINT 8
18 BILL_TO_CUSTOMER_ID BIGINT 8
19 BILL_TO_SITE_USE_ID BIGINT 8
20 SHIP_TO_CUSTOMER_ID BIGINT 8
21 SHIP_TO_CONTACT_ID BIGINT 8
22 SHIP_TO_SITE_USE_ID BIGINT 8
23 SHIPMENT_ID BIGINT 8
24 REMIT_TO_ADDRESS_ID BIGINT 8
25 TERM_ID BIGINT 8
26 TERM_DUE_DATE TIMESTAMP 8
27 PREVIOUS_CUSTOMER_TRX_ID BIGINT 8
28 PRIMARY_SALESREP_ID BIGINT 8
29 PRINTING_ORIGINAL_DATE TIMESTAMP 8
30 PRINTING_LAST_PRINTED TIMESTAMP 8
31 PRINTING_OPTION CHARACTER VARYING(20) 20
32 PRINTING_COUNT BIGINT 8
33 PRINTING_PENDING CHARACTER VARYING(1) 1
34 PURCHASE_ORDER CHARACTER VARYING(50) 50
35 PURCHASE_ORDER_REVISION CHARACTER VARYING(50) 50
36 PURCHASE_ORDER_DATE TIMESTAMP 8
37 CUSTOMER_REFERENCE CHARACTER VARYING(30) 30
38 CUSTOMER_REFERENCE_DATE TIMESTAMP 8
39 COMMENTS CHARACTER VARYING(1760) 1760
40 INTERNAL_NOTES CHARACTER VARYING(240) 240
41 EXCHANGE_RATE_TYPE CHARACTER VARYING(30) 30
42 EXCHANGE_DATE TIMESTAMP 8
43 EXCHANGE_RATE BIGINT 8
44 TERRITORY_ID BIGINT 8
45 INVOICE_CURRENCY_CODE CHARACTER VARYING(15) 15
46 INITIAL_CUSTOMER_TRX_ID BIGINT 8
47 AGREEMENT_ID BIGINT 8
48 END_DATE_COMMITMENT TIMESTAMP 8
49 START_DATE_COMMITMENT TIMESTAMP 8
50 LAST_PRINTED_SEQUENCE_NUM BIGINT 8
51 ATTRIBUTE_CATEGORY CHARACTER VARYING(30) 30
52 ATTRIBUTE1 CHARACTER VARYING(150) 150
53 ATTRIBUTE2 CHARACTER VARYING(150) 150
54 ATTRIBUTE3 CHARACTER VARYING(150) 150
55 ATTRIBUTE4 CHARACTER VARYING(150) 150
56 ATTRIBUTE5 CHARACTER VARYING(150) 150
57 ATTRIBUTE6 CHARACTER VARYING(150) 150
58 ATTRIBUTE7 CHARACTER VARYING(150) 150
59 ATTRIBUTE8 CHARACTER VARYING(150) 150
60 ATTRIBUTE9 CHARACTER VARYING(150) 150
61 ATTRIBUTE10 CHARACTER VARYING(150) 150
62 ORIG_SYSTEM_BATCH_NAME CHARACTER VARYING(40) 40
63 POST_REQUEST_ID BIGINT 8
64 REQUEST_ID BIGINT 8
65 PROGRAM_APPLICATION_ID BIGINT 8
66 PROGRAM_ID BIGINT 8
67 PROGRAM_UPDATE_DATE TIMESTAMP 8
68 FINANCE_CHARGES CHARACTER VARYING(1) 1
69 COMPLETE_FLAG CHARACTER VARYING(1) 1
70 POSTING_CONTROL_ID BIGINT 8
71 BILL_TO_ADDRESS_ID BIGINT 8
72 RA_POST_LOOP_NUMBER BIGINT 8
73 SHIP_TO_ADDRESS_ID BIGINT 8
74 CREDIT_METHOD_FOR_RULES CHARACTER VARYING(30) 30
75 CREDIT_METHOD_FOR_INSTALLMENTS CHARACTER VARYING(30) 30
76 RECEIPT_METHOD_ID BIGINT 8
77 ATTRIBUTE11 CHARACTER VARYING(150) 150
78 ATTRIBUTE12 CHARACTER VARYING(150) 150
79 ATTRIBUTE13 CHARACTER VARYING(150) 150
80 ATTRIBUTE14 CHARACTER VARYING(150) 150
81 ATTRIBUTE15 CHARACTER VARYING(150) 150
82 RELATED_CUSTOMER_TRX_ID BIGINT 8
83 INVOICING_RULE_ID BIGINT 8
84 SHIP_VIA CHARACTER VARYING(30) 30
85 SHIP_DATE_ACTUAL TIMESTAMP 8
86 WAYBILL_NUMBER CHARACTER VARYING(50) 50
87 FOB_POINT CHARACTER VARYING(30) 30
88 CUSTOMER_BANK_ACCOUNT_ID BIGINT 8
89 INTERFACE_HEADER_ATTRIBUTE1 CHARACTER VARYING(150) 150
90 INTERFACE_HEADER_ATTRIBUTE2 CHARACTER VARYING(150) 150
91 INTERFACE_HEADER_ATTRIBUTE3 CHARACTER VARYING(150) 150
92 INTERFACE_HEADER_ATTRIBUTE4 CHARACTER VARYING(150) 150
93 INTERFACE_HEADER_ATTRIBUTE5 CHARACTER VARYING(150) 150
94 INTERFACE_HEADER_ATTRIBUTE6 CHARACTER VARYING(150) 150
95 INTERFACE_HEADER_ATTRIBUTE7 CHARACTER VARYING(150) 150
96 INTERFACE_HEADER_ATTRIBUTE8 CHARACTER VARYING(150) 150
97 INTERFACE_HEADER_CONTEXT CHARACTER VARYING(30) 30
98 DEFAULT_USSGL_TRX_CODE_CONTEXT CHARACTER VARYING(30) 30
99 INTERFACE_HEADER_ATTRIBUTE10 CHARACTER VARYING(150) 150
100 INTERFACE_HEADER_ATTRIBUTE11 CHARACTER VARYING(150) 150
101 INTERFACE_HEADER_ATTRIBUTE12 CHARACTER VARYING(150) 150
102 INTERFACE_HEADER_ATTRIBUTE13 CHARACTER VARYING(150) 150
103 INTERFACE_HEADER_ATTRIBUTE14 CHARACTER VARYING(150) 150
104 INTERFACE_HEADER_ATTRIBUTE15 CHARACTER VARYING(150) 150
105 INTERFACE_HEADER_ATTRIBUTE9 CHARACTER VARYING(150) 150
106 DEFAULT_USSGL_TRANSACTION_CODE CHARACTER VARYING(30) 30
107 RECURRED_FROM_TRX_NUMBER CHARACTER VARYING(20) 20
108 STATUS_TRX CHARACTER VARYING(30) 30
109 DOC_SEQUENCE_ID BIGINT 8
110 DOC_SEQUENCE_VALUE BIGINT 8
111 PAYING_CUSTOMER_ID BIGINT 8
112 PAYING_SITE_USE_ID BIGINT 8
113 RELATED_BATCH_SOURCE_ID BIGINT 8
114 DEFAULT_TAX_EXEMPT_FLAG CHARACTER VARYING(1) 1
115 CREATED_FROM CHARACTER VARYING(30) 30
116 ORG_ID BIGINT 8
117 WH_UPDATE_DATE TIMESTAMP 8
118 GLOBAL_ATTRIBUTE1 CHARACTER VARYING(150) 150
119 GLOBAL_ATTRIBUTE2 CHARACTER VARYING(150) 150
120 GLOBAL_ATTRIBUTE3 CHARACTER VARYING(150) 150
121 GLOBAL_ATTRIBUTE4 CHARACTER VARYING(150) 150
122 GLOBAL_ATTRIBUTE5 CHARACTER VARYING(150) 150
123 GLOBAL_ATTRIBUTE6 CHARACTER VARYING(150) 150
124 GLOBAL_ATTRIBUTE7 CHARACTER VARYING(150) 150
125 GLOBAL_ATTRIBUTE8 CHARACTER VARYING(150) 150
126 GLOBAL_ATTRIBUTE9 CHARACTER VARYING(150) 150
127 GLOBAL_ATTRIBUTE10 CHARACTER VARYING(150) 150
128 GLOBAL_ATTRIBUTE11 CHARACTER VARYING(150) 150
129 GLOBAL_ATTRIBUTE12 CHARACTER VARYING(150) 150
130 GLOBAL_ATTRIBUTE13 CHARACTER VARYING(150) 150
131 GLOBAL_ATTRIBUTE14 CHARACTER VARYING(150) 150
132 GLOBAL_ATTRIBUTE15 CHARACTER VARYING(150) 150
133 GLOBAL_ATTRIBUTE16 CHARACTER VARYING(150) 150
134 GLOBAL_ATTRIBUTE17 CHARACTER VARYING(150) 150
135 GLOBAL_ATTRIBUTE18 CHARACTER VARYING(150) 150
136 GLOBAL_ATTRIBUTE19 CHARACTER VARYING(150) 150
137 GLOBAL_ATTRIBUTE20 CHARACTER VARYING(150) 150
138 GLOBAL_ATTRIBUTE21 CHARACTER VARYING(150) 150
139 GLOBAL_ATTRIBUTE22 CHARACTER VARYING(150) 150
140 GLOBAL_ATTRIBUTE23 CHARACTER VARYING(150) 150
141 GLOBAL_ATTRIBUTE24 CHARACTER VARYING(150) 150
142 GLOBAL_ATTRIBUTE25 CHARACTER VARYING(150) 150
143 GLOBAL_ATTRIBUTE26 CHARACTER VARYING(150) 150
144 GLOBAL_ATTRIBUTE27 CHARACTER VARYING(150) 150
145 GLOBAL_ATTRIBUTE28 CHARACTER VARYING(150) 150
146 GLOBAL_ATTRIBUTE29 CHARACTER VARYING(150) 150
147 GLOBAL_ATTRIBUTE30 CHARACTER VARYING(150) 150
148 GLOBAL_ATTRIBUTE_CATEGORY CHARACTER VARYING(30) 30
149 EDI_PROCESSED_FLAG CHARACTER VARYING(1) 1
150 EDI_PROCESSED_STATUS CHARACTER VARYING(10) 10
151 MRC_EXCHANGE_RATE_TYPE CHARACTER VARYING(2000) 2000
152 MRC_EXCHANGE_DATE CHARACTER VARYING(2000) 2000
153 MRC_EXCHANGE_RATE CHARACTER VARYING(2000) 2000
154 PAYMENT_SERVER_ORDER_NUM CHARACTER VARYING(80) 80
155 APPROVAL_CODE CHARACTER VARYING(80) 80
156 ADDRESS_VERIFICATION_CODE CHARACTER VARYING(80) 80
157 OLD_TRX_NUMBER CHARACTER VARYING(20) 20
158 BR_AMOUNT BIGINT 8
159 BR_UNPAID_FLAG CHARACTER VARYING(1) 1
160 BR_ON_HOLD_FLAG CHARACTER VARYING(1) 1
161 DRAWEE_ID BIGINT 8
162 DRAWEE_CONTACT_ID BIGINT 8
163 DRAWEE_SITE_USE_ID BIGINT 8
164 REMITTANCE_BANK_ACCOUNT_ID BIGINT 8
165 OVERRIDE_REMIT_ACCOUNT_FLAG CHARACTER VARYING(1) 1
166 DRAWEE_BANK_ACCOUNT_ID BIGINT 8
167 SPECIAL_INSTRUCTIONS CHARACTER VARYING(240) 240
168 REMITTANCE_BATCH_ID BIGINT 8
169 PREPAYMENT_FLAG CHARACTER VARYING(1) 1
170 CT_REFERENCE CHARACTER VARYING(150) 150
171 CONTRACT_ID BIGINT 8
172 BILL_TEMPLATE_ID BIGINT 8
173 REVERSED_CASH_RECEIPT_ID BIGINT 8
174 CC_ERROR_CODE CHARACTER VARYING(80) 80
175 CC_ERROR_TEXT CHARACTER VARYING(255) 255
176 CC_ERROR_FLAG CHARACTER VARYING(1) 1
177 UPGRADE_METHOD CHARACTER VARYING(30) 30
178 LEGAL_ENTITY_ID BIGINT 8
179 REMIT_BANK_ACCT_USE_ID BIGINT 8
180 PAYMENT_TRXN_EXTENSION_ID BIGINT 8
181 AX_ACCOUNTED_FLAG CHARACTER VARYING(1) 1
182 APPLICATION_ID BIGINT 8
183 PAYMENT_ATTRIBUTES CHARACTER VARYING(1000) 1000
184 BILLING_DATE TIMESTAMP 8
185 INTEREST_HEADER_ID BIGINT 8
186 LATE_CHARGES_ASSESSED CHARACTER VARYING(30) 30
187 TRAILER_NUMBER CHARACTER VARYING(50) 50
188 REV_REC_APPLICATION CHARACTER VARYING(30) 30
189 DOCUMENT_TYPE_ID BIGINT 8
190 DOCUMENT_CREATION_DATE TIMESTAMP 8
191 SRC_INVOICING_RULE_ID BIGINT 8
192 BILLING_EXT_REQUEST BIGINT 8
193 CDC_SOURCE_SYSTEM_CODE CHARACTER VARYING(4) 4
194 CDC_RECORD_TYPE CHARACTER VARYING(16) 16
195 CDC_COMMIT_TIMESTAMP TIMESTAMP 8
196 CDC_EXTRACT_TIMESTAMP TIMESTAMP 8