1
.INCLUDE
0
0
Primary Key for CMS_OMS_INS_LNK
2
INS_LNK_GUID
CMS_DTE_OMS_INS_LNK_GUID
SYSUUID
RAW
16
0
Insurance Link GUID
3
.INCLUDE
0
0
Object Reference - Insurance Data
4
OBJ_REF_GUID
CMS_DTE_OMS_INS_LNK_OBJREFGUID
SYSUUID
RAW
16
0
Object reference GUID
5
.INCLUDE
0
0
Insurance Type - Data
6
INS_CATEGORY
CMS_DTE_OMS_OBJ_CAT
CMS_OBJ_CAT
CHAR
6
0
Object Category
*
7
INS_TYP
CMS_DTE_INS_TYPE
CMS_MOV_TYP
CHAR
6
0
Insurance Type
*
8
.INCLUDE
0
0
Insurance Link Data
9
INS_ID
CMS_DTE_OMS_INS_LNK_INS_ID
CMS_OMS_INS_ID
NUMC
4
0
Insurance ID
10
INS_OBJSYSID
CMS_DTE_OBJ_SYSID
CMS_SYS
CHAR
6
0
Object System Reference ID
11
LNK_VALID_FROM
CMS_DTE_INS_LNK_VALID_FROM
CMS_DATE
DATS
8
0
Link Valid From Date
12
LNK_VALID_TO
CMS_DTE_INS_LNK_VALID_TO
CMS_DATE
DATS
8
0
Link Valid To Date
13
.INCLUDE
0
0
Insurance common data
14
INS_DESC
CMS_DTE_INS_DESC
CMS_INS_DESC
CHAR
30
0
Insurance Description
15
.INCLUDE
0
0
Information on Insurance Settlement
16
INSUR_TAX_DB
CMS_DTE_INS_TAX_DB
CMS_INS_FLG
CHAR
1
0
Insurance tax to the debit of the bank
17
SETLMNT_TYPE
CMS_DTE_INS_SETLMNT_TYPE
CMS_ATT_ID_TYP
CHAR
6
0
Type of settlement
TCMS_ATT_ID_TY
18
INSUR_SUM
CMS_DTE_INS_SUM
CMS_AMOUNT
CURR
17
2
Insurance Sum
19
INSUR_CURR
CMS_DTE_INS_CURR
WAERS
CUKY
5
0
Insurance Currency
TCURC
20
PRM_RT
CMS_DTE_INS_PRM_RT
CMS_INS_PRM_RT
DEC
10
7
Premium Rate
21
INSUR_PREMIUM
CMS_DTE_INS_PRM
CMS_AMOUNT
CURR
17
2
Insurance Premium
22
INSUR_PRM_CURR
CMS_DTE_INS_CURR
WAERS
CUKY
5
0
Insurance Currency
TCURC
23
INSUR_TAX_RT
CMS_DTE_INS_TAX_RT
CMS_INS_PRM_RT
DEC
10
7
Insurance tax rate (in %)
24
INSUR_TAX_AMT
CMS_DTE_INS_TAX_AMT
CMS_AMOUNT
CURR
17
2
Insurance tax amount
25
INSUR_TAX_CURR
CMS_DTE_INS_TAX_CURR
WAERS
CUKY
5
0
Tax Currency
TCURC
26
.INCLUDE
0
0
Insurance cover
27
SCOPE_INS_COVER
CMS_DTE_INS_COVER
CMS_INS_COVER
CHAR
6
0
not used -> package has to be changed CMS_OMS_INS
28
.INCLUDE
0
0
Common OMS data
29
EXT_ITM_NO
CMS_DTE_OMS_EXT_ITM_NO
CMS_OMS_ID
CHAR
40
0
Ext. Item no / Number for identification of the objects
30
EXT_REFERENCE
CMS_DTE_OMS_REF_ID
CMS_OMS_REFID
CHAR
32
0
Reference number for the legacy system
31
FOP
CMS_DTE_INS_FOP
CMS_INS_FREQ_OF_PAYMENT
NUMC
4
0
Frequency of Payment
32
FREQ_UNIT
CMS_DTE_INS_FREQ_UNIT
CMS_INS_IND_FREQ_UNIT
CHAR
2
0
Indicator: Units of time for revaluation
33
.INCLUDE
0
0
Other general fields required for a standalone insurance
34
INS_CODE
CMS_DTE_INS_CODE
CMS_INS_CODE
CHAR
6
0
Insurance Product Code
35
ORIG_COUNTRY
CMS_DTE_INS_ORIG_COUNTRY
LAND1
CHAR
3
0
Country where Insurance was purchased
T005
36
ORIG_REGION
CMS_DTE_INS_ORIG_REGION
REGIO
CHAR
3
0
Region where Insurance was purchased
T005S
37
AUTO_CANCEL_DT
CMS_DTE_INS_AUTO_CANCEL_DT
CMS_DATE
DATS
8
0
Auto Cancellation Date for an Insurance Policy
38
PRM_TYPE
CMS_DTE_INS_PRM_TYPE
CMS_INS_PREMIUM_TYPE
CHAR
2
0
Type of Premium
39
PRM_VALID_FROM
CMS_DTE_INS_PRM_VALID_FROM_DT
CMS_DATE
DATS
8
0
Date from when specified Premium is valid
40
PAYMNT_METHOD
CMS_DTE_INS_PAYMENT_METHOD
CMS_INS_PAYMENT_METHOD
CHAR
2
0
Payment method for premiums
41
PAYMNT_INFO
CMS_DTE_INS_PAY_INFO
CMS_PAYMENT_HANDLE
CHAR
30
0
Payment Info for an insurance policy
42
LAST_PAYMENT_DT
CMS_DTE_INS_LAST_PAYMENT_DT
CMS_DATE
DATS
8
0
Date when last premium payment was made
43
NXT_PAYMENT_DT
CMS_DTE_INS_NXT_PAYMENT_DT
CMS_DATE
DATS
8
0
Next Payment Date when insurance premium is due
44
STATEMENT_DT
CMS_DTE_INS_STATEMENT_DT
CMS_DATE
DATS
8
0
Date when statements for Policy was made
45
REBATE_METHOD
CMS_DTE_INS_REBATE_METHOD_ID
CMS_INS_REBATE_METHOD_ID
CHAR
6
0
Identifier for the rebate method used to calculate refunds
TCMS_INS_REB
46
PORTFOLIO
CMS_DTE_INS_PORTFOLIO
CMS_INS_PORTFOLIO
CHAR
6
0
Insurance Portfolio
TCMS_INS_PORT
47
MAX_AGE_LIMIT
CMS_DTE_INS_MAX_AGE_LIMIT
CMS_AGE
INT1
3
0
Maximum age limit for Policy Validity
48
MAX_COVER_AMT
CMS_DTE_INS_MAX_COVER_AMT
CMS_AMOUNT
CURR
17
2
Maximum Coverage Amount
49
MIN_COVER_AMT
CMS_DTE_INS_MIN_COVER_AMT
CMS_AMOUNT
CURR
17
2
Minimum Coverage Amount
50
IND_INSURED_EVNT
CMS_DTE_IND_INSURED_EVENT
CMS_IND_OCCURENCE
CHAR
1
0
Boolean indicator that insured event occured (X = Occured)
51
INSURED_EVENT_DT
CMS_DTE_INSURED_EVENT_DT
CMS_DATE
DATS
8
0
Date when Insured Event Occured
52
IND_FORCE_PLACED
CMS_DTE_INS_IND_FORCE_PLACE
CMS_IND_INS_FORCE_PLACE
CHAR
2
0
Is Insurance Force Placed? (Default = No)
53
IND_TAX_DEDUCT
CMS_DTE_INS_IND_TAX_DEDUCT
CMS_IND_INS_TAX_DEDUCTIBLE
CHAR
2
0
Indicator that Insurance Policy is Tax Deductible
54
INACTIVE_REASON
CMS_DTE_INS_INACTIVE_REASON
CMS_INS_INACTIVE_REASON
CHAR
2
0
Reason for inactivating insurance policy
TCMS_INS_SRSN
55
POLICY_STATUS
CMS_DTE_INS_POLICY_STATUS
CMS_INS_POLICY_STATUS
CHAR
2
0
Insurance Policy Status
56
.INCLUDE
0
0
Insurance for object
57
.INCLUDE
0
0
Information on Insurance Agreement
58
INS_STRT_DAT
CMS_DTE_INS_STRT_DAT
DATUM
DATS
8
0
Start date of insurance
59
INSUR_EXPY_DAT
CMS_DTE_INS_EXPY_DAT
DATUM
DATS
8
0
Date of expiry of insurance
60
REQD_INSUR_CVR
CMS_DTE_INS_REQD_CVR
CMS_AMOUNT
CURR
17
2
Required insurance cover
61
REQD_INSUR_CURR
CMS_DTE_INS_CURR
WAERS
CUKY
5
0
Insurance Currency
TCURC
62
.INCLUDE
0
0
Information on Insurance / Insurance Broker
63
INSURER_NAM
CMS_DTE_INS_INSUR_NAM
CMS_INS_INSURER
CHAR
30
0
Name of the insurer
64
INSURER_INF
CMS_DTE_INS_INSUR_INF
CMS_INS_INSUR_INF
CHAR
30
0
Remarks on insurer
65
COVER_MKT
CMS_DTE_INS_COVER_MKT
LAND1
CHAR
3
0
Cover Market
*
66
SHARE_CVR_MKT
CMS_DTE_INS_SH_CVR_MKT
CMS_AMOUNT
CURR
17
2
Share of cover market
67
SH_CVR_MKT_CUR
CMS_DTE_INS_SH_CVR_MKT_CUR
WAERS
CUKY
5
0
Currency for Share of Cover Market
*
68
CONTACT_FIRM
CMS_DTE_INS_CON_FRM
CMS_INS_CON_FRM
CHAR
30
0
Contact firm
69
CONTACT_PARTNER
CMS_DTE_INS_CON_PRT
CMS_INS_CON_PRT
CHAR
30
0
Contact partner
70
.INCLUDE
0
0
Stucture to record history of changes in all application tab
71
CREATED_BY
CMS_DTE_USER
CMS_USER
CHAR
12
0
Login ID of the User who created the Record
72
CREATED_AT
CMS_DTE_CREATED_AT
TZNTSTMPS
DEC
15
0
Creation Timestamp
73
CHANGED_BY
CMS_DTE_LAST_CHNG_USER
CMS_USER
CHAR
12
0
Last Changed By
74
CHANGED_AT
CMS_DTE_CHANGED_AT
TZNTSTMPS
DEC
15
0
Change Timestamp
75
SOURCEOFENTRY
CMS_DTE_SOURCE_OF_ENTRY
CMS_SOURCE
CHAR
32
0
Source of Entry
76
.INCLUDE
0
0
Insurance screen fields
77
INS_PRM_IND
CMS_DTE_IND_INS_PRM
CMS_IND_INS_PRM
CHAR
2
0
Indicator for insurance premium
78
INS_TAX_IND
CMS_DTE_IND_INS_TAX
CMS_IND_INS_TAX
CHAR
2
0
Indicator for insurance tax
79
MARK
CMS_DTE_ROW_SELECTED
CMS_FLG
CHAR
1
0
Flag: Row Selected on the Screen