CFD_TCFDD_CMPGN_OPPRTNTY

Database

SDSNZS01_CFDM

Schema

CDCPADM_CFDM

Type

TABLE

Description

 

Columns
# Name Data Type Length
1 CMPGN_OPPRTNTY_ID BIGINT 8
2 OPPRTNTY_ID CHARACTER VARYING(30) 30
3 CMPGN_CODE CHARACTER VARYING(30) 30
4 ASSC_CNTCT_ID CHARACTER VARYING(30) 30
5 CNTCT_ID CHARACTER VARYING(30) 30
6 PRDT_DESC CHARACTER VARYING(50) 50
7 PRICE_APPROVED_IND CHARACTER VARYING(3) 3
8 PRICE_APPROVER_DESC CHARACTER VARYING(30) 30
9 BUS_CUST_DESC CHARACTER VARYING(30) 30
10 CUST_SGMNT_DESC CHARACTER VARYING(30) 30
11 REASSIGN_CONSNT_IND CHARACTER VARYING(5) 5
12 OPPRTNTY_DESC CHARACTER VARYING(4000) 4000
13 ENTERPRISE_OWNR_ID CHARACTER VARYING(40) 40
14 ENTERPRISE_OWNR_NAM CHARACTER VARYING(40) 40
15 EXPECTED_CLOSE_DATE TIMESTAMP 8
16 FEE_QUOTE_AMT NUMERIC(18,6) 19
17 LEAD_SRC_DESC CHARACTER VARYING(30) 30
18 NXT_STEP_DESC CHARACTER VARYING(4000) 4000
19 OPPRTNTY_NAM CHARACTER VARYING(100) 100
20 OPPRTNTY_TYP CHARACTER VARYING(30) 30
21 OWNR_DESC CHARACTER VARYING(30) 30
22 CNTCT_LST_NAM CHARACTER VARYING(50) 50
23 PRTY_DESC CHARACTER VARYING(30) 30
24 PROB_AMT NUMERIC(18,6) 19
25 RSN_WON_LOST_1_DESC CHARACTER VARYING(30) 30
26 RSN_WON_LOST_2_DESC CHARACTER VARYING(30) 30
27 RT_QUOTE_AMT NUMERIC(18,6) 19
28 SUBMIT_APRVL_IND CHARACTER VARYING(3) 3
29 TAKE_OSHIP_IND CHARACTER VARYING(3) 3
30 SALES_AMT NUMERIC(18,6) 19
31 SALES_STAGE_DESC CHARACTER VARYING(30) 30
32 CREATED_BY_NAM CHARACTER VARYING(100) 100
33 CREATE_UID CHARACTER VARYING(10) 10
34 CREATE_TS TIMESTAMP 8
35 MOD_UID CHARACTER VARYING(10) 10
36 MOD_TS TIMESTAMP 8
37 EFF_STRT_DATE TIMESTAMP 8
38 EFF_END_DATE TIMESTAMP 8
39 DATA_LOAD_DATE TIMESTAMP 8
40 SNPSHT_DATE TIMESTAMP 8
41 SRC_SYS_ID CHARACTER VARYING(5) 5
42 LOAD_ID BIGINT 8
43 CDC_SOURCE_SYSTEM_CODE CHARACTER VARYING(4) 4
44 CDC_RECORD_TYPE CHARACTER VARYING(16) 16
45 CDC_COMMIT_TIMESTAMP TIMESTAMP 8
46 CDC_EXTRACT_TIMESTAMP TIMESTAMP 8