OCH24_HST_S_PROD_INT

Database

SDSNZS01_OBP

Schema

CDCPADM_OBP

Type

TABLE

Description

 

Columns
# Name Data Type Length
1 ROW_ID CHARACTER VARYING(15) 15
2 CREATED TIMESTAMP 8
3 CREATED_BY CHARACTER VARYING(15) 15
4 LAST_UPD TIMESTAMP 8
5 LAST_UPD_BY CHARACTER VARYING(15) 15
6 DCKING_NUM NUMERIC(22,7) 19
7 MODIFICATION_NUM BIGINT 8
8 CONFLICT_ID CHARACTER VARYING(15) 15
9 ACTIVE_FLG CHARACTER(1) 1
10 ADD_TO_QUOTE_FLG CHARACTER(1) 1
11 APPLY_EC_RULE_FLG CHARACTER(1) 1
12 APPLY_MEM_COMP_FLG CHARACTER(1) 1
13 APPROVAL_FLG CHARACTER(1) 1
14 AUTO_UNGROUP_FLG CHARACTER(1) 1
15 BILLABLE_FLG CHARACTER(1) 1
16 BIL_ON_FST_USG_FLG CHARACTER(1) 1
17 BU_ID CHARACTER VARYING(15) 15
18 CG_COMPETITOR_FLG CHARACTER(1) 1
19 CMPND_FLG CHARACTER(1) 1
20 COMMISIONED_FLG CHARACTER(1) 1
21 COMPENSATABLE_FLG CHARACTER(1) 1
22 CRT_AGREEMENT_FLG CHARACTER(1) 1
23 CRT_AST_REC_FLG CHARACTER(1) 1
24 CRT_INST_FLG CHARACTER(1) 1
25 DESIGN_REG_FLG CHARACTER(1) 1
26 ENTERPRISE_FLG CHARACTER(1) 1
27 FEATURED_FLG CHARACTER(1) 1
28 INCLSV_ELIG_RL_FLG CHARACTER(1) 1
29 INCL_ALL_CRSE_FLG CHARACTER(1) 1
30 LEAF_LEVEL_FLG CHARACTER(1) 1
31 MODEL_PROD_FLG CHARACTER(1) 1
32 NAME CHARACTER VARYING(100) 100
33 NEED_PH_NUM_FLG CHARACTER(1) 1
34 ONDEMAND_SYNC_FLG CHARACTER(1) 1
35 ORDERABLE_FLG CHARACTER(1) 1
36 POSTN_BL_PROD_FLG CHARACTER(1) 1
37 RSLV_AMBIGUITY_FLG CHARACTER(1) 1
38 SALES_PROD_FLG CHARACTER(1) 1
39 SALES_SRVC_FLG CHARACTER(1) 1
40 SERVICE_FLG CHARACTER(1) 1
41 SERV_INST_FLG CHARACTER(1) 1
42 SHIP_FLG CHARACTER(1) 1
43 TARGET_VRSN_FLG CHARACTER(1) 1
44 TAX_SUBCOMP_FLG CHARACTER(1) 1
45 TRANSFERABLE_FLG CHARACTER(1) 1
46 TWOBARCODES_FLG CHARACTER(1) 1
47 UNIQUE_ASSET_FLG CHARACTER(1) 1
48 CTRL_SUBS_FLG CHARACTER(1) 1
49 DPNDNCY_VLDTN_FLG CHARACTER(1) 1
50 REQD_SERVICE_FLG CHARACTER(1) 1
51 ROLLUP_LEVEL BIGINT 8
52 ROLLUP_TRGMKT_FLG CHARACTER(1) 1
53 ACCRUAL_RATE NUMERIC(22,7) 19
54 ALC_BELOW_SFTY_FLG CHARACTER(1) 1
55 ALOC_ASSETS_FLG CHARACTER(1) 1
56 APRX_COST_AMT NUMERIC(22,7) 19
57 APX_CST_EXCH_DT TIMESTAMP 8
58 AUTO_ALLOCATE_FLG CHARACTER(1) 1
59 AUTO_SUBST_FLG CHARACTER(1) 1
60 AVG_CALL_CST NUMERIC(22,7) 19
61 AVG_CALL_CST_DT TIMESTAMP 8
62 AVG_OP_LIFE NUMERIC(22,7) 19
63 AVG_PROFIT NUMERIC(22,7) 19
64 CAPACITY NUMERIC(22,7) 19
65 CARY_COST NUMERIC(22,7) 19
66 CARY_COST_DT TIMESTAMP 8
67 CASE_CONV_FACTOR NUMERIC(22,7) 19
68 CASE_PACK NUMERIC(22,7) 19
69 CONFIGURATION_FLG CHARACTER(1) 1
70 CUTOFF_FLG CHARACTER(1) 1
71 DB_LAST_UPD TIMESTAMP 8
72 DELIV_INTERVAL NUMERIC(22,7) 19
73 DEST_COST NUMERIC(22,7) 19
74 DISP_CMPNT_FLG CHARACTER(1) 1
75 DISP_CMPNT_PRI_FLG CHARACTER(1) 1
76 EFFICIENCY_RATING NUMERIC(22,7) 19
77 EFF_END_DT TIMESTAMP 8
78 EFF_START_DT TIMESTAMP 8
79 EXCH_DT TIMESTAMP 8
80 EXP_LEAD_DAYS BIGINT 8
81 FRU_FLG CHARACTER(1) 1
82 GROSS_MGN NUMERIC(22,7) 19
83 INCL_CRSE_NUM BIGINT 8
84 INVENTORY_FLG CHARACTER(1) 1
85 ITEM_SIZE NUMERIC(22,7) 19
86 LOAD_ADDED NUMERIC(22,7) 19
87 LOCK_FLG CHARACTER(1) 1
88 LOT_ACTIVE_FLG CHARACTER(1) 1
89 LOY_ACTUAL_DIST NUMERIC(22,7) 19
90 LOY_EXP_LEAD_TIME NUMERIC(22,7) 19
91 LOY_NUM_YEAR NUMERIC(22,7) 19
92 LOY_PERIOD_DUR NUMERIC(22,7) 19
93 LOY_SUG_POINTS NUMERIC(22,7) 19
94 LOY_SUG_PRICE NUMERIC(22,7) 19
95 LOY_SUG_R_POINTS NUMERIC(22,7) 19
96 LOY_SUG_R_PRICE NUMERIC(22,7) 19
97 LOY_VCHREXP_PRDDUR NUMERIC(22,7) 19
98 LOY_VCH_NUM_USAGE BIGINT 8
99 MAX_ORDER_UNITS NUMERIC(22,7) 19
100 MIN_ORDER_UNITS NUMERIC(22,7) 19
101 MODEL_YR NUMERIC(22,7) 19
102 MSRP NUMERIC(22,7) 19
103 MTBF NUMERIC(22,7) 19
104 MTTR NUMERIC(22,7) 19
105 NUM_OCCURRENCE BIGINT 8
106 ORDER_CST NUMERIC(22,7) 19
107 ORDER_CST_DT TIMESTAMP 8
108 PRODUCT_LEVEL NUMERIC(22,7) 19
109 PROD_UPD_DT TIMESTAMP 8
110 REQ_APPL_FLG CHARACTER(1) 1
111 REQ_REFERRAL_FLG CHARACTER(1) 1
112 RESERVABLE_FLG CHARACTER(1) 1
113 RTRN_DEFECTIVE_FLG CHARACTER(1) 1
114 RXAVPR_EXCH_DT TIMESTAMP 8
115 RX_AVG_PRICE NUMERIC(22,7) 19
116 SCORE_NUM NUMERIC(22,7) 19
117 SERIALIZED_FLG CHARACTER(1) 1
118 SERVICE_LENGTH BIGINT 8
119 SKIP_FLG CHARACTER(1) 1
120 SPL_RATE_MAX_VAL BIGINT 8
121 SUBSCN_DUR_DAY_NUM BIGINT 8
122 TAXABLE_FLG CHARACTER(1) 1
123 TOOL_FLG CHARACTER(1) 1
124 UNITS_BCKORD NUMERIC(22,7) 19
125 UNITS_BCKORD_AS_OF TIMESTAMP 8
126 UNITS_INVENT NUMERIC(22,7) 19
127 UNITS_INVENT_AS_OF TIMESTAMP 8
128 UNIT_CONV_FACTOR NUMERIC(22,7) 19
129 ADDL_LEAD_TIME CHARACTER VARYING(30) 30
130 AIA_INTEG_ID CHARACTER VARYING(150) 150
131 ALIAS_NAME CHARACTER VARYING(100) 100
132 APX_CST_CURCY_CD CHARACTER VARYING(20) 20
133 ASSET_REF_EXPR CHARACTER VARYING(100) 100
134 ASSOC_LEVEL CHARACTER VARYING(30) 30
135 ATM_TYPE_CD CHARACTER VARYING(30) 30
136 AVGCALLCST_CURCYCD CHARACTER VARYING(20) 20
137 BAR_CODE_NUM CHARACTER VARYING(50) 50
138 BILLING_TYPE_CD CHARACTER VARYING(30) 30
139 BODY_STYLE_CD CHARACTER VARYING(30) 30
140 BOOK_APPR_ID CHARACTER VARYING(15) 15
141 BUILD CHARACTER VARYING(30) 30
142 CARY_COST_CURCY_CD CHARACTER VARYING(20) 20
143 CATEGORY_CD CHARACTER VARYING(30) 30
144 CFG_MODEL_ID CHARACTER VARYING(15) 15
145 CG_PR_CTLG_CAT_ID CHARACTER VARYING(15) 15
146 CLASS_PARTNUM_ID CHARACTER VARYING(15) 15
147 COMMENTS CHARACTER VARYING(250) 250
148 COMPOSN_TYPE_CD CHARACTER VARYING(30) 30
149 CONFIG_RULE_FILE CHARACTER VARYING(220) 220
150 CRITICAL_CD CHARACTER VARYING(30) 30
151 CS_PATH_ID CHARACTER VARYING(15) 15
152 CURCY_CD CHARACTER VARYING(30) 30
153 DATA_SRC CHARACTER VARYING(30) 30
154 DB_LAST_UPD_SRC CHARACTER VARYING(50) 50
155 DEF_MOD_PROD_ID CHARACTER VARYING(15) 15
156 DESC_TEXT CHARACTER VARYING(255) 255
157 DESC_TEXT_LONG CHARACTER VARYING(1999) 1999
158 DETAIL_TYPE_CD CHARACTER VARYING(30) 30
159 DFLT_PROCSYS_ID CHARACTER VARYING(15) 15
160 DIVN_CD CHARACTER VARYING(30) 30
161 DOORS_TYPE_CD CHARACTER VARYING(30) 30
162 DOWN_TIME CHARACTER VARYING(30) 30
163 DRIVE_TRAIN_CD CHARACTER VARYING(30) 30
164 DYN_DISCNT_METH_CD CHARACTER VARYING(30) 30
165 ENGINE_TYPE_CD CHARACTER VARYING(30) 30
166 FABRIC_CD CHARACTER VARYING(30) 30
167 FUEL_TYPE_CD CHARACTER VARYING(30) 30
168 FULFLMNT_CRIT_CD CHARACTER VARYING(30) 30
169 FULFLMNT_ITEM_CODE CHARACTER VARYING(100) 100
170 GENDER_CD CHARACTER VARYING(30) 30
171 GTIN CHARACTER VARYING(20) 20
172 INTEGRATION_ID CHARACTER VARYING(30) 30
173 INTL_BLD_LANG_CD CHARACTER VARYING(30) 30
174 INVNTRY_INTEG_ID CHARACTER VARYING(40) 40
175 INVST_CATG_CD CHARACTER VARYING(50) 50
176 INVST_OBJ_CD CHARACTER VARYING(30) 30
177 LEAD_TM CHARACTER VARYING(30) 30
178 LIFE_CYCLE_CD CHARACTER VARYING(30) 30
179 LOY_DIST_UOM CHARACTER VARYING(30) 30
180 LOY_EXPR_BASIS_CD CHARACTER VARYING(30) 30
181 LOY_EXP_UOM CHARACTER VARYING(30) 30
182 LOY_FROMAPRT_CD CHARACTER VARYING(30) 30
183 LOY_PERIOD_TYPE_CD CHARACTER VARYING(30) 30
184 LOY_SEQ_TYPE_CD CHARACTER VARYING(30) 30
185 LOY_SERIES_PREFIX CHARACTER VARYING(15) 15
186 LOY_SUG_PTTYPE_ID CHARACTER VARYING(15) 15
187 LOY_SUG_RPTTYPE_ID CHARACTER VARYING(15) 15
188 LOY_TOAPRT_CD CHARACTER VARYING(30) 30
189 LOY_VCH_EXP_DAY_CD CHARACTER VARYING(30) 30
190 LOY_VCH_EXP_MTH_CD CHARACTER VARYING(30) 30
191 LOY_VCH_ST_DAY_CD CHARACTER VARYING(30) 30
192 LOY_VCH_ST_MTH_CD CHARACTER VARYING(30) 30
193 LOY_VEXP_PERTYP_CD CHARACTER VARYING(30) 30
194 MAKE_CD CHARACTER VARYING(30) 30
195 MODEL CHARACTER VARYING(30) 30
196 MODEL_CD CHARACTER VARYING(30) 30
197 MOVEMENT_CLASS CHARACTER VARYING(30) 30
198 MTBF_UOM_CD CHARACTER VARYING(30) 30
199 MTTR_UOM_CD CHARACTER VARYING(30) 30
200 NET_ELMT_TYPE_CD CHARACTER VARYING(30) 30
201 OBJECTIVE_DESC CHARACTER VARYING(100) 100
202 ONL_PAGESET_ID CHARACTER VARYING(15) 15
203 ORDER_CST_CURCY_CD CHARACTER VARYING(20) 20
204 PART_NUM CHARACTER VARYING(50) 50
205 PAR_PROD_INT_ID CHARACTER VARYING(15) 15
206 PAYMNT_TYPE_CD CHARACTER VARYING(30) 30
207 PERMITTED_TYPE CHARACTER VARYING(250) 250
208 PG_NOTIFY_ACCNT_CD CHARACTER VARYING(30) 30
209 PG_OWNER_TYPE_CD CHARACTER VARYING(30) 30
210 PLAN_STATUS CHARACTER VARYING(30) 30
211 PM_DEPT_POSTN_ID CHARACTER VARYING(15) 15
212 PREAPPR_STATE_ID CHARACTER VARYING(15) 15
213 PREF_CARRIER_CD CHARACTER VARYING(30) 30
214 PREF_SHIP_METH_CD CHARACTER VARYING(30) 30
215 PRICE_TYPE_CD CHARACTER VARYING(30) 30
216 PRICING_TEXT CHARACTER VARYING(1999) 1999
217 PRI_COMMIT_TYPE_CD CHARACTER VARYING(30) 30
218 PROD_ASSEMBLY_LVL CHARACTER VARYING(50) 50
219 PROD_ATTRIB01_CD CHARACTER VARYING(30) 30
220 PROD_ATTRIB02_CD CHARACTER VARYING(30) 30
221 PROD_ATTRIB03_CD CHARACTER VARYING(30) 30
222 PROD_ATTRIB04_CD CHARACTER VARYING(30) 30
223 PROD_CATG_CD CHARACTER VARYING(30) 30
224 PROD_CD CHARACTER VARYING(30) 30
225 PROD_CLS_NUM CHARACTER VARYING(50) 50
226 PROD_DIST_CD CHARACTER VARYING(30) 30
227 PROD_GLOBAL_UID CHARACTER VARYING(50) 50
228 PROD_IMAGE_ID CHARACTER VARYING(15) 15
229 PROD_LCYCLE_STATUS CHARACTER VARYING(50) 50
230 PROD_MSG_ID CHARACTER VARYING(15) 15
231 PROD_OPT1_MIX_ID CHARACTER VARYING(15) 15
232 PROD_OPT2_MIX_ID CHARACTER VARYING(15) 15
233 PROD_OPTION1_ID CHARACTER VARYING(15) 15
234 PROD_OPTION2_ID CHARACTER VARYING(15) 15
235 PROD_SUPPLY_CHAIN CHARACTER VARYING(50) 50
236 PROD_TYPE_CD CHARACTER VARYING(30) 30
237 PROFIT_RANK_CD CHARACTER VARYING(30) 30
238 PROMO_INSTANCE_CD CHARACTER VARYING(30) 30
239 PROMO_TYPE_CD CHARACTER VARYING(30) 30
240 PR_CON_ID CHARACTER VARYING(15) 15
241 PR_EQUIV_PROD_ID CHARACTER VARYING(15) 15
242 PR_ERNG_ID CHARACTER VARYING(15) 15
243 PR_FULFL_INVLOC_ID CHARACTER VARYING(15) 15
244 PR_INDUST_ID CHARACTER VARYING(15) 15
245 PR_POSTN_ID CHARACTER VARYING(15) 15
246 PR_PROD_LN_ID CHARACTER VARYING(15) 15
247 PR_SEASON_ID CHARACTER VARYING(15) 15
248 PR_SHIP_CARPRIO_ID CHARACTER VARYING(15) 15
249 PR_SRC_ID CHARACTER VARYING(15) 15
250 PR_TRGT_MKT_SEG_ID CHARACTER VARYING(15) 15
251 QUALITY_CD CHARACTER VARYING(30) 30
252 REASON_TXT CHARACTER VARYING(250) 250
253 REFERENCE_TYPE_CD CHARACTER VARYING(30) 30
254 REF_NUMBER_1 CHARACTER VARYING(30) 30
255 REF_NUMBER_2 CHARACTER VARYING(30) 30
256 REF_NUMBER_3 CHARACTER VARYING(30) 30
257 REF_NUMBER_4 CHARACTER VARYING(30) 30
258 REF_NUMBER_5 CHARACTER VARYING(30) 30
259 REGION_ID CHARACTER VARYING(15) 15
260 REQ_DATA_ID CHARACTER VARYING(15) 15
261 RISK CHARACTER VARYING(250) 250
262 ROOT_PROD_ID CHARACTER VARYING(15) 15
263 RULE_ATTRIB1 CHARACTER VARYING(50) 50
264 RULE_ATTRIB2 CHARACTER VARYING(50) 50
265 RXAVPR_CURCY_CD CHARACTER VARYING(20) 20
266 SCHEDULE_NUM_CD CHARACTER VARYING(30) 30
267 SEQ_CD CHARACTER VARYING(30) 30
268 SERVICE_TERMS CHARACTER VARYING(255) 255
269 SERV_LENGTH_UOM_CD CHARACTER VARYING(30) 30
270 SILHOUETTE_CD CHARACTER VARYING(30) 30
271 SPL_RT_LST_TYPE_CD CHARACTER VARYING(30) 30
272 STATUS_CD CHARACTER VARYING(30) 30
273 STRATEGY CHARACTER VARYING(250) 250
274 STRENGTH CHARACTER VARYING(30) 30
275 SUB_TYPE CHARACTER VARYING(30) 30
276 SUB_TYPE_CD CHARACTER VARYING(30) 30
277 TERMS_COND_TEXT CHARACTER VARYING(1999) 1999
278 TGT_CUST_TYPE_CD CHARACTER VARYING(30) 30
279 TGT_REGION_CD CHARACTER VARYING(30) 30
280 THMBNL_IMAGE_ID CHARACTER VARYING(15) 15
281 TNT_FILTER_TYPE_CD CHARACTER VARYING(30) 30
282 TRANSMISSION_CD CHARACTER VARYING(30) 30
283 TRGT_MKT_ID CHARACTER VARYING(15) 15
284 TRIM_CD CHARACTER VARYING(30) 30
285 TYPE CHARACTER VARYING(30) 30
286 UOM_CD CHARACTER VARYING(30) 30
287 VALTN_SYS_ID CHARACTER VARYING(15) 15
288 VALUE_CLASS CHARACTER VARYING(30) 30
289 VENDR_OU_ID CHARACTER VARYING(15) 15
290 VENDR_PART_NUM CHARACTER VARYING(50) 50
291 VERSION CHARACTER VARYING(30) 30
292 XA_CLASS_ID CHARACTER VARYING(15) 15
293 X_TAX_REPORT_FLG CHARACTER(1) 1
294 CDC_SOURCE_SYSTEM_CODE CHARACTER VARYING(4) 4
295 CDC_RECORD_TYPE CHARACTER VARYING(16) 16
296 CDC_COMMIT_TIMESTAMP TIMESTAMP 8
297 CDC_EXTRACT_TIMESTAMP TIMESTAMP 8