och24_hst_s_org_ext

Database

prod_bank_wealth

Schema

sor_obp

Type

BASE TABLE

Description

 

Columns
# Name Data Type Length
1 row_id character varying 45
2 created timestamp without time zone
3 created_by character varying 45
4 last_upd timestamp without time zone
5 last_upd_by character varying 45
6 dcking_num numeric 22
7 modification_num bigint 64
8 conflict_id character varying 45
9 par_row_id character varying 45
10 accnt_flg character varying 3
11 active_flg character varying 3
12 buying_group_flg character varying 3
13 bu_id character varying 45
14 cg_dedn_auth_flg character varying 3
15 cg_svp_a_lock_flg character varying 3
16 cg_svp_lock_flg character varying 3
17 cg_svp_skip_flg character varying 3
18 cl_site_flg character varying 3
19 contract_vis_flg character varying 3
20 court_pay_flg character varying 3
21 disa_cleanse_flg character varying 3
22 evt_loc_flg character varying 3
23 external_host_flg character varying 3
24 fcst_org_flg character varying 3
25 fund_elig_flg character varying 3
26 good_standing_flg character varying 3
27 incl_flg character varying 3
28 int_org_flg character varying 3
29 name character varying 300
30 ondemand_sync_flg character varying 3
31 plan_group_flg character varying 3
32 prospect_flg character varying 3
33 prtnr_flg character varying 3
34 prtnr_publish_flg character varying 3
35 rplcd_wth_cmpt_flg character varying 3
36 skip_po_crdchk_flg character varying 3
37 agency_flg character varying 3
38 branch_flg character varying 3
39 briefing_layout character varying 90
40 client_flg character varying 3
41 enterprise_flag character varying 3
42 facility_flg character varying 3
43 invstr_flg character varying 3
44 lang_id character varying 45
45 pr_rep_dnrm_flg character varying 3
46 pr_rep_manl_flg character varying 3
47 pr_rep_sys_flg character varying 3
48 agency_inactive_dt timestamp without time zone
49 asgn_dt timestamp without time zone
50 asgn_usr_excld_flg character varying 3
51 asset_amt numeric 22
52 atm_count bigint 64
53 avail_credit_amt numeric 22
54 bill_pblshr_flg character varying 3
55 bo_ordqry_end_dt timestamp without time zone
56 bo_ordqry_start_dt timestamp without time zone
57 cg_cons_end_offset numeric 22
58 cg_cons_strtoffset numeric 22
59 cg_prmo_end_offset numeric 22
60 cg_ship_end_offset numeric 22
61 cg_ship_strtoffset numeric 22
62 cg_svp_upper_lock bigint 64
63 chnl_annl_sales numeric 22
64 chnl_qtr_sales numeric 22
65 chnl_sales_growth numeric 22
66 close_dt timestamp without time zone
67 cmpt_flg character varying 3
68 credit_days bigint 64
69 credit_score numeric 22
70 cur_yr_bk numeric 22
71 cur_yr_bl numeric 22
72 cust_end_dt timestamp without time zone
73 cust_since_dt timestamp without time zone
74 db_last_upd timestamp without time zone
75 dedup_dataclnsd_dt timestamp without time zone
76 dedup_key_upd_dt timestamp without time zone
77 dedup_last_mtch_dt timestamp without time zone
78 disa_all_mails_flg character varying 3
79 division_count numeric 22
80 eai_sync_dt timestamp without time zone
81 emp_count numeric 22
82 evt_hotel_std_rt numeric 22
83 exch_dt timestamp without time zone
84 ful_center_flg character varying 3
85 gsa_flg character varying 3
86 hard_to_reach character varying 3
87 hist_sls_exch_dt timestamp without time zone
88 hist_sls_vol numeric 22
89 hshldhd_age numeric 22
90 hshld_inc numeric 22
91 hshld_kidage numeric 22
92 hshld_kids numeric 22
93 hshld_size numeric 22
94 last_call_dt timestamp without time zone
95 last_mgr_revw_dt timestamp without time zone
96 latitude numeric 22
97 longitude numeric 22
98 misc_flg character varying 3
99 num_hshlds numeric 22
100 num_of_beds numeric 22
101 num_regs numeric 22
102 ori_ts timestamp without time zone
103 partner_flg character varying 3
104 po_crdchk_thrsh numeric 22
105 po_crdchk_thrsh_dt timestamp without time zone
106 po_pay_exch_dt timestamp without time zone
107 po_pay_flg character varying 3
108 po_pay_max_amt numeric 22
109 pri_yr_bk numeric 22
110 pri_yr_bl numeric 22
111 proced_flg character varying 3
112 prtnrshp_start_dt timestamp without time zone
113 prtnr_sales_rank numeric 22
114 ptntl_sls_exch_dt timestamp without time zone
115 ptntl_sls_vol numeric 22
116 reference_cust_flg character varying 3
117 reference_start_dt timestamp without time zone
118 sales_emp_cnt bigint 64
119 service_emp_cnt bigint 64
120 srv_provdr_flg character varying 3
121 stat_chg_dt timestamp without time zone
122 store_size numeric 22
123 suppress_share_flg character varying 3
124 supress_call_flg character varying 3
125 tax_exempt_flg character varying 3
126 trgt_impl_dt timestamp without time zone
127 visit_frequency bigint 64
128 weekly_acv numeric 22
129 aba_number character varying 150
130 accnt_pr_cmpt_id character varying 45
131 accnt_type_cd character varying 90
132 adl_status character varying 90
133 agency_indicator character varying 90
134 agency_nibrs_ind character varying 90
135 aia_integ1_id character varying 1500
136 aia_integ_id character varying 450
137 alias_name character varying 300
138 alt_email_addr character varying 150
139 alt_email_loc_cd character varying 90
140 ans_srvc_ph_num character varying 120
141 approval_status_cd character varying 90
142 asgn_ph_ac character varying 15
143 asgn_ph_cc character varying 15
144 base_curcy_cd character varying 60
145 bo_cust_grp_cd character varying 90
146 branch_type_cd character varying 90
147 call_frequency character varying 90
148 cc_txnproc_ac_num character varying 90
149 cc_txnproc_vndr_id character varying 45
150 cg_prmo_strt_day character varying 45
151 cg_svp_status character varying 90
152 channel_type character varying 150
153 cmpny_name character varying 150
154 core_city_cd character varying 90
155 corp_cmpny_name character varying 150
156 corp_stock_symbol character varying 60
157 country_division character varying 90
158 country_region character varying 90
159 country_template character varying 45
160 covered_by character varying 45
161 creator_login character varying 150
162 cross_street character varying 120
163 curr_pri_lst_id character varying 45
164 curr_rate_lst_id character varying 45
165 cur_srv_addr_id character varying 45
166 cur_yr_bk_curcy_cd character varying 60
167 cur_yr_bl_curcy_cd character varying 60
168 cust_stat_cd character varying 90
169 db_last_upd_src character varying 150
170 dedup_token character varying 300
171 dept_num character varying 90
172 desc_text character varying 765
173 dflt_ship_prio_cd character varying 90
174 dist_channel_cd character varying 90
175 division character varying 75
176 divn_cd character varying 90
177 divn_terr_hier_id character varying 45
178 divn_type_cd character varying 90
179 dom_ult_duns_num character varying 45
180 duns_num character varying 45
181 eai_error_text character varying 6000
182 eai_exprt_stat_cd character varying 90
183 email_addr character varying 150
184 email_loc_cd character varying 90
185 evt_loc_cd character varying 90
186 exec_spnsr_pstn_id character varying 45
187 expertise_cd character varying 90
188 fbi_field_off_id character varying 45
189 fin_resp_con_id character varying 45
190 frd_owner_emp_id character varying 45
191 frght_terms_cd character varying 90
192 frght_terms_info character varying 300
193 furi_cmpny_name character varying 150
194 general_ledger character varying 150
195 glblult_duns_num character varying 45
196 grwth_strtgy_desc character varying 3003
197 hist_sls_curcy_cd character varying 60
198 hshldhd_gen_cd character varying 90
199 hshldhd_occ_cd character varying 90
200 hshld_ethn_cd character varying 90
201 hshld_loc_cd character varying 90
202 impl_desc character varying 3000
203 impl_stage_cd character varying 90
204 integration_id character varying 90
205 judicial_district character varying 90
206 last_revw_mgr_id character varying 45
207 legal_form_cd character varying 90
208 loc character varying 150
209 location_level character varying 90
210 loy_partner_cd character varying 90
211 main_email_addr character varying 150
212 main_fax_ph_num character varying 120
213 main_ph_num character varying 120
214 manager_name character varying 120
215 market_class_cd character varying 90
216 market_type_cd character varying 90
217 master_ou_id character varying 45
218 name_1 character varying 300
219 od_last_upd_by character varying 375
220 ori_cd character varying 90
221 ou_num character varying 90
222 ou_num_1 character varying 90
223 ou_type_cd character varying 90
224 ownership_type_cd character varying 90
225 par_bu_id character varying 45
226 par_divn_id character varying 45
227 par_duns_num character varying 45
228 par_ou_id character varying 45
229 password character varying 60
230 payment_term_id character varying 45
231 pay_type_cd character varying 90
232 population_grp_cd character varying 90
233 po_pay_curcy_cd character varying 60
234 pref_carr_prio_cd character varying 90
235 pref_comm_meth_cd character varying 90
236 pref_ship_carr_cd character varying 90
237 privacy_cd character varying 90
238 pri_grp_cd character varying 90
239 pri_yr_bk_curcy_cd character varying 60
240 pri_yr_bl_curcy_cd character varying 60
241 prod_dist_cd character varying 90
242 prtnr_cert_cd character varying 90
243 prtnr_ctgry_cd character varying 90
244 prtnr_org_int_id character varying 45
245 prtnr_type_cd character varying 90
246 pr_addr_id character varying 45
247 pr_addr_per_id character varying 45
248 pr_agree_id character varying 45
249 pr_bill_prfl_id character varying 45
250 pr_bl_addr_id character varying 45
251 pr_bl_ou_id character varying 45
252 pr_bl_per_id character varying 45
253 pr_competitor_id character varying 45
254 pr_con_id character varying 45
255 pr_co_mstr_id character varying 45
256 pr_crdt_area_id character varying 45
257 pr_discnt_id character varying 45
258 pr_eai_sls_area_id character varying 45
259 pr_emp_rel_id character varying 45
260 pr_emp_terr_id character varying 45
261 pr_fulfl_invloc_id character varying 45
262 pr_geo_id character varying 45
263 pr_implsvc_vndr_id character varying 45
264 pr_indust_id character varying 45
265 pr_labor_rate_id character varying 45
266 pr_logo_id character varying 45
267 pr_med_proc_id character varying 45
268 pr_mgr_postn_id character varying 45
269 pr_mkt_seg_id character varying 45
270 pr_org_pay_prfl_id character varying 45
271 pr_org_trgt_mkt_id character varying 45
272 pr_ou_type_id character varying 45
273 pr_pay_ou_id character varying 45
274 pr_phone_id character varying 45
275 pr_postn_id character varying 45
276 pr_prfl_id character varying 45
277 pr_pri_lst_id character varying 45
278 pr_prod_id character varying 45
279 pr_prod_ln_id character varying 45
280 pr_prtnr_ou_id character varying 45
281 pr_prtnr_prog_id character varying 45
282 pr_prtnr_tier_id character varying 45
283 pr_prtnr_type_id character varying 45
284 pr_ptshp_mktseg_id character varying 45
285 pr_rep_asgn_type character varying 90
286 pr_security_id character varying 45
287 pr_ship_addr_id character varying 45
288 pr_ship_ou_id character varying 45
289 pr_ship_per_id character varying 45
290 pr_situ_id character varying 45
291 pr_specialty_id character varying 45
292 pr_spec_id character varying 45
293 pr_spl_rate_lst_id character varying 45
294 pr_srv_agree_id character varying 45
295 pr_svc_postn_id character varying 45
296 pr_syn_id character varying 45
297 pr_territory_id character varying 45
298 pr_terr_id character varying 45
299 pr_vehicle_id character varying 45
300 ptntl_sls_curcy_cd character varying 60
301 rating character varying 90
302 region character varying 75
303 region_id character varying 45
304 rel_id character varying 45
305 rel_name character varying 300
306 revenue_class_cd character varying 90
307 rlzd_roi_desc character varying 750
308 route character varying 90
309 rte_to_mkt_desc character varying 1500
310 rule_attrib1 character varying 150
311 rule_attrib2 character varying 150
312 sales_org_cd character varying 90
313 sls_dist_cd character varying 90
314 staff character varying 750
315 state_abbre_cd character varying 90
316 status_cd character varying 90
317 stat_reason_cd character varying 90
318 survey_type_cd character varying 90
319 svc_cvrg_stat_cd character varying 90
320 tax_exempt_num character varying 90
321 tax_iden_num character varying 150
322 tax_list_id character varying 45
323 ticker_sym character varying 30
324 tlr_intg_msg character varying 750
325 tlr_intg_ret_cd character varying 90
326 url character varying 300
327 vat_regn_num character varying 90
328 visit_period character varying 90
329 directions character varying 2048
330 x_ccn character varying 90
331 x_cell_ph_num character varying 120
332 x_constitution character varying 90
333 x_domicile_branch character varying 30
334 x_incorp_country_cd character varying 90
335 x_kyc_status_cd character varying 90
336 x_kyc_ts timestamp without time zone
337 x_kyc_ver_stage character varying 90
338 x_legacy_id character varying 90
339 x_legal_name character varying 765
340 x_link_error_msg character varying 1500
341 x_linked character varying 3
342 x_match_call character varying 3
343 x_message_id_pub character varying 300
344 x_message_id_sync character varying 300
345 x_segment_cd character varying 150
346 x_shared_info character varying 3
347 x_sys_of_origin character varying 150
348 x_tax_exempt_cd character varying 90
349 x_tax_iden_num character varying 300
350 x_tfn_exempt_dt timestamp without time zone
351 x_use_count bigint 64
352 x_work_ph_num character varying 120
353 cdc_source_system_code character varying 12
354 cdc_record_type character varying 48
355 cdc_commit_timestamp timestamp without time zone
356 cdc_extract_timestamp timestamp without time zone
357 x_last_upd_dt timestamp without time zone
358 x_domicile character varying 300