OBP24_HST_FLX_AG_ARRANGEMENT_LNKGE_H

Database

SDSNZS01_OBP

Schema

CDCPADM_OBP

Type

TABLE

Description

 

Columns
# Name Data Type Length
1 ARRANGEMENT_ID CHARACTER VARYING(40) 40
2 AGENT_ARRANGEMENT_TYPE CHARACTER VARYING(40) 40
3 SERIAL_NO DOUBLE PRECISION 8
4 OBJECT_VERSION_NUMBER CHARACTER VARYING(20) 20
5 CREATED_BY CHARACTER VARYING(254) 254
6 LAST_UPDATED_BY CHARACTER VARYING(254) 254
7 CREATION_DATE TIMESTAMP 8
8 LAST_UPDATE_DATE TIMESTAMP 8
9 OBJECT_STATUS CHARACTER VARYING(20) 20
10 EVENT_NAME CHARACTER VARYING(40) 40
11 REFERENCE_ID CHARACTER VARYING(20) 20
12 OFFER_ID CHARACTER VARYING(30) 30
13 POSTING_DATE TIMESTAMP 8
14 EVENT_VALUE_DATE TIMESTAMP 8
15 EXISTING_COMMISSION_BASIS CHARACTER VARYING(20) 20
16 COMMISSION_BASIS CHARACTER VARYING(20) 20
17 EXISTING_TERM_YEARS DOUBLE PRECISION 8
18 EXISTING_TERM_MONTHS DOUBLE PRECISION 8
19 EXISTING_TERM_DAYS DOUBLE PRECISION 8
20 NEW_TERM_TERM_YEARS DOUBLE PRECISION 8
21 NEW_TERM_TERM_MONTHS DOUBLE PRECISION 8
22 NEW_TERM_TERM_DAYS DOUBLE PRECISION 8
23 AGENT_PARTY_ID CHARACTER VARYING(20) 20
24 AGENT_ID CHARACTER VARYING(20) 20
25 COMMISSION_RECIPIENT_ID CHARACTER VARYING(20) 20
26 AGENT_TYPE CHARACTER VARYING(20) 20
27 BUSINESS_UNIT CHARACTER VARYING(20) 20
28 NEW_AMOUNT DOUBLE PRECISION 8
29 EXISTING_AMOUNT DOUBLE PRECISION 8
30 COMMISSION_BEHAVIOUR_TYPE CHARACTER VARYING(20) 20
31 IS_OVERRIDEN CHARACTER VARYING(1) 1
32 IS_AUTO_COMMISSION_PRESENT CHARACTER VARYING(1) 1
33 COMMISSION_CATEGORY CHARACTER VARYING(20) 20
34 CCY_CODE CHARACTER VARYING(20) 20
35 EXISTING_AUTO_COM_COMMENT CHARACTER VARYING(254) 254
36 EXISTING_AUTO_REB_MARGIN DOUBLE PRECISION 8
37 EXISTING_AUTO_REB_APPL CHARACTER VARYING(1) 1
38 EXISTING_AUTO_COM_REB_RATE DOUBLE PRECISION 8
39 EXISTING_AUTO_COM_TYPE CHARACTER VARYING(20) 20
40 EXISTING_AUTO_COM_RATE DOUBLE PRECISION 8
41 EXISTING_AUTO_NET_PRED_AMT DOUBLE PRECISION 8
42 EXISTING_AUTO_GROSS_PRED_AMT DOUBLE PRECISION 8
43 EXISTING_AUTO_GROSS_C_AMT DOUBLE PRECISION 8
44 EXISTING_AUTO_COM_TRL_REB_RATE DOUBLE PRECISION 8
45 EXISTING_AUTO_COM_TRL_TYPE CHARACTER VARYING(20) 20
46 EXISTING_AUTO_COM_TRL_RATE DOUBLE PRECISION 8
47 EXISTING_AUTO_NET_PRED_TRL_AMT DOUBLE PRECISION 8
48 EXISTING_AUTO_GROS_PRD_TRL_AMT DOUBLE PRECISION 8
49 EXISTING_AUTO_GROS_C_TRL_AMT DOUBLE PRECISION 8
50 ORIGINAL_AUTO_COM_COMMENT CHARACTER VARYING(254) 254
51 ORIGINAL_AUTO_REB_MARGIN DOUBLE PRECISION 8
52 ORIGINAL_AUTO_REB_APPL CHARACTER VARYING(20) 20
53 ORIGINAL_AUTO_COM_REB_RATE DOUBLE PRECISION 8
54 ORIGINAL_AUTO_COM_TYPE CHARACTER VARYING(20) 20
55 ORIGINAL_AUTO_COM_RATE DOUBLE PRECISION 8
56 ORIGINAL_AUTO_NET_PRED_AMT DOUBLE PRECISION 8
57 ORIGINAL_AUTO_GROSS_PRED_AMT DOUBLE PRECISION 8
58 ORIGINAL_AUTO_GROSS_C_AMT DOUBLE PRECISION 8
59 ORIGINAL_AUTO_COM_REB_TRL_RATE DOUBLE PRECISION 8
60 ORIGINAL_AUTO_COM_TRL_TYPE CHARACTER VARYING(20) 20
61 ORIGINAL_AUTO_COM_TRL_RATE DOUBLE PRECISION 8
62 ORIGINAL_AUTO_NET_PRED_TRL_AMT DOUBLE PRECISION 8
63 ORIGINAL_AUTO_GROS_PRD_TRL_AMT DOUBLE PRECISION 8
64 ORIGINAL_AUTO_GROSS_C_TRL_AMT DOUBLE PRECISION 8
65 DISCRETIONARY_COM_COMMENT CHARACTER VARYING(254) 254
66 DISCRETIONARY_REB_MARGIN DOUBLE PRECISION 8
67 DISCRETIONARY_REB_APPL CHARACTER VARYING(20) 20
68 DISCRETIONARY_COM_REB_RATE DOUBLE PRECISION 8
69 DISCRETIONARY_COM_TYPE CHARACTER VARYING(20) 20
70 DISCRETIONARY_COM_RATE DOUBLE PRECISION 8
71 DISCRETIONARY_NET_PRED_AMT DOUBLE PRECISION 8
72 DISCRETIONARY_GROSS_PRED_AMT DOUBLE PRECISION 8
73 DISCRETIONARY_GROSS_C_AMT DOUBLE PRECISION 8
74 DISCRETIONARY_COM_REB_TRL_RATE DOUBLE PRECISION 8
75 DISCRETIONARY_COM_TRL_TYPE CHARACTER VARYING(20) 20
76 DISCRETIONARY_COM_TRL_RATE DOUBLE PRECISION 8
77 DISCRETIONARY_NET_PRED_TRL_AMT DOUBLE PRECISION 8
78 DISCRETIONARY_GROS_PRD_TRL_AMT DOUBLE PRECISION 8
79 DISCRETIONARY_GROSS_C_TRL_AMT DOUBLE PRECISION 8
80 TEXT_1 CHARACTER VARYING(20) 20
81 TEXT_2 CHARACTER VARYING(20) 20
82 TEXT_3 CHARACTER VARYING(20) 20
83 TEXT_4 CHARACTER VARYING(20) 20
84 TEXT_5 CHARACTER VARYING(20) 20
85 TEXT_6 CHARACTER VARYING(20) 20
86 TEXT_7 CHARACTER VARYING(20) 20
87 TEXT_8 CHARACTER VARYING(20) 20
88 TEXT_9 CHARACTER VARYING(20) 20
89 TEXT_10 CHARACTER VARYING(20) 20
90 NUMBER_1 DOUBLE PRECISION 8
91 NUMBER_2 DOUBLE PRECISION 8
92 NUMBER_3 DOUBLE PRECISION 8
93 NUMBER_4 DOUBLE PRECISION 8
94 NUMBER_5 DOUBLE PRECISION 8
95 NUMBER_6 DOUBLE PRECISION 8
96 NUMBER_7 DOUBLE PRECISION 8
97 NUMBER_8 DOUBLE PRECISION 8
98 NUMBER_9 DOUBLE PRECISION 8
99 NUMBER_10 DOUBLE PRECISION 8
100 DATE_1 TIMESTAMP 8
101 DATE_2 TIMESTAMP 8
102 DATE_3 TIMESTAMP 8
103 DATE_4 TIMESTAMP 8
104 DATE_5 TIMESTAMP 8
105 BUSINESS_GROUP_CODE CHARACTER VARYING(40) 40
106 MANAGER_CODE CHARACTER VARYING(120) 120
107 SOURCING_AGENT_ID CHARACTER VARYING(20) 20
108 SOURCING_PARTY_ID CHARACTER VARYING(20) 20
109 SOURCING_AGENT_TYPE CHARACTER VARYING(20) 20
110 PRODUCT_GROUP_CODE CHARACTER VARYING(20) 20
111 CDC_SOURCE_SYSTEM_CODE CHARACTER VARYING(4) 4
112 CDC_RECORD_TYPE CHARACTER VARYING(16) 16
113 CDC_COMMIT_TIMESTAMP TIMESTAMP 8
114 CDC_EXTRACT_TIMESTAMP TIMESTAMP 8