CMS_INS - Insurance Application Table

Insurance Application Table information is stored in SAP table CMS_INS.
It is part of development package CMS_OMS_RIG in software component FS-CMS-MD-RIG. This development package consists of objects that can be grouped under "Collateral Management Rights".

Fields for table CMS_INS

Field Name	Description	Is Key	Data Element	Data Type	Length	Check Table
MANDT	Client	X	MANDT	CLNT	6
.INCLUDE	INS_PKY	X		CMS_STR_INS_PKY	0
INS_GUID	Insurance GUID	X	CMS_DTE_INS_GUID	RAW	16
.INCLUDE	INS_SKY			CMS_STR_INS_SKY	0
INS_CATEGORY	Object Category		CMS_DTE_OMS_OBJ_CAT	CHAR	12
INS_TYP	Insurance Type		CMS_DTE_INS_TYPE	CHAR	12	*
INS_ID	Insurance ID		CMS_DTE_INS_ID	CHAR	80
.INCLUDE	INS_COM_DATA			CMS_STR_INS_COMMON_DATA	0
INS_DESC	Insurance Description		CMS_DTE_INS_DESC	CHAR	60
.INCLUDE				CMS_STR_INS_SETTLE	0
INSUR_TAX_DB	Insurance tax to the debit of the bank		CMS_DTE_INS_TAX_DB	CHAR	2
SETLMNT_TYPE	Type of settlement		CMS_DTE_INS_SETLMNT_TYPE	CHAR	12	TCMS_ATT_ID_TY
INSUR_SUM	Insurance Sum		CMS_DTE_INS_SUM	CURR	9
INSUR_CURR	Insurance Currency		CMS_DTE_INS_CURR	CUKY	10	TCURC
PRM_RT	Premium Rate		CMS_DTE_INS_PRM_RT	DEC	6
INSUR_PREMIUM	Insurance Premium		CMS_DTE_INS_PRM	CURR	9
INSUR_PRM_CURR	Insurance Currency		CMS_DTE_INS_CURR	CUKY	10	TCURC
INSUR_TAX_RT	Insurance tax rate (in %)		CMS_DTE_INS_TAX_RT	DEC	6
INSUR_TAX_AMT	Insurance tax amount		CMS_DTE_INS_TAX_AMT	CURR	9
INSUR_TAX_CURR	Tax Currency		CMS_DTE_INS_TAX_CURR	CUKY	10	TCURC
.INCLUDE				CMS_STR_INS_COVER_DATA	0
SCOPE_INS_COVER	not used -> package has to be changed CMS_OMS_INS		CMS_DTE_INS_COVER	CHAR	12
.INCLUDE				CMS_STR_OMS_COMMON_DATA	0
EXT_ITM_NO	Ext. Item no / Number for identification of the objects		CMS_DTE_OMS_EXT_ITM_NO	CHAR	80
EXT_REFERENCE	Reference number for the legacy system		CMS_DTE_OMS_REF_ID	CHAR	64
INS_COMP	Insurance Company		CMS_DTE_INS_COMP	CHAR	64
FOP	Frequency of Payment		CMS_DTE_INS_FOP	NUMC	8
FREQ_UNIT	Indicator: Units of time for revaluation		CMS_DTE_INS_FREQ_UNIT	CHAR	4
.INCLUDE	GENERAL			CMS_STR_INS_GENERAL	0
INS_CODE	Insurance Product Code		CMS_DTE_INS_CODE	CHAR	12
ORIG_COUNTRY	Country/Region of Insurance Purchase		CMS_DTE_INS_ORIG_COUNTRY	CHAR	6	T005
ORIG_REGION	Region where Insurance was purchased		CMS_DTE_INS_ORIG_REGION	CHAR	6	T005S
AUTO_CANCEL_DT	Auto Cancellation Date for an Insurance Policy		CMS_DTE_INS_AUTO_CANCEL_DT	DATS	16
PRM_TYPE	Type of Premium		CMS_DTE_INS_PRM_TYPE	CHAR	4	TCMS_INS_PRM
PRM_VALID_FROM	Date from when specified Premium is valid		CMS_DTE_INS_PRM_VALID_FROM_DT	DATS	16
PAYMNT_METHOD	Payment method for premiums		CMS_DTE_INS_PAYMENT_METHOD	CHAR	4
PAYMNT_INFO	Payment Info for an insurance policy		CMS_DTE_INS_PAY_INFO	CHAR	60
LAST_PAYMENT_DT	Date when last premium payment was made		CMS_DTE_INS_LAST_PAYMENT_DT	DATS	16
NXT_PAYMENT_DT	Next Payment Date when insurance premium is due		CMS_DTE_INS_NXT_PAYMENT_DT	DATS	16
STATEMENT_DT	Date when statements for Policy was made		CMS_DTE_INS_STATEMENT_DT	DATS	16
REBATE_METHOD	Identifier for the rebate method used to calculate refunds		CMS_DTE_INS_REBATE_METHOD_ID	CHAR	12	TCMS_INS_REB
PORTFOLIO	Insurance Portfolio		CMS_DTE_INS_PORTFOLIO	CHAR	12	TCMS_INS_PORT
MAX_AGE_LIMIT	Maximum age limit for Policy Validity		CMS_DTE_INS_MAX_AGE_LIMIT	INT1	1
MAX_COVER_AMT	Maximum Coverage Amount		CMS_DTE_INS_MAX_COVER_AMT	CURR	9
MIN_COVER_AMT	Minimum Coverage Amount		CMS_DTE_INS_MIN_COVER_AMT	CURR	9
IND_INSURED_EVNT	Boolean indicator that insured event occured (X = Occured)		CMS_DTE_IND_INSURED_EVENT	CHAR	2
INSURED_EVENT_DT	Date when Insured Event Occured		CMS_DTE_INSURED_EVENT_DT	DATS	16
IND_FORCE_PLACED	Is Insurance Force Placed? (Default = No)		CMS_DTE_INS_IND_FORCE_PLACE	CHAR	4
IND_TAX_DEDUCT	Indicator that Insurance Policy is Tax Deductible		CMS_DTE_INS_IND_TAX_DEDUCT	CHAR	4
INACTIVE_REASON	Reason for inactivating insurance policy		CMS_DTE_INS_INACTIVE_REASON	CHAR	4	TCMS_INS_SRSN
POLICY_STATUS	Insurance Policy Status		CMS_DTE_INS_POLICY_STATUS	CHAR	4
.INCLUDE	INS_FOR_OBJ_DATA			CMS_STR_INS_FOR_OBJECT	0
.INCLUDE				CMS_STR_INS_AGRE	0
INS_STRT_DAT	Start date of insurance		CMS_DTE_INS_STRT_DAT	DATS	16
INSUR_EXPY_DAT	Date of expiry of insurance		CMS_DTE_INS_EXPY_DAT	DATS	16
REQD_INSUR_CVR	Required insurance cover		CMS_DTE_INS_REQD_CVR	CURR	9
REQD_INSUR_CURR	Insurance Currency		CMS_DTE_INS_CURR	CUKY	10	TCURC
.INCLUDE				CMS_STR_INS_INFO	0
INSURER_NAM	Name of the insurer		CMS_DTE_INS_INSUR_NAM	CHAR	60
INSURER_INF	Remarks on insurer		CMS_DTE_INS_INSUR_INF	CHAR	60
COVER_MKT	Cover Market		CMS_DTE_INS_COVER_MKT	CHAR	6	*
SHARE_CVR_MKT	Share of cover market		CMS_DTE_INS_SH_CVR_MKT	CURR	9
SH_CVR_MKT_CUR	Currency for Share of Cover Market		CMS_DTE_INS_SH_CVR_MKT_CUR	CUKY	10	*
CONTACT_FIRM	Contact firm		CMS_DTE_INS_CON_FRM	CHAR	60
CONTACT_PARTNER	Contact partner		CMS_DTE_INS_CON_PRT	CHAR	60
.INCLUDE	INS_AS_OBJ_DATA			CMS_STR_INS_AS_OBJECT	0
.INCLUDE				CMS_STR_INS_FEATURES	0
TARRIF	Insurance tariff		CMS_DTE_INS_TARRIF	CHAR	60
CALC_BASIS	Calculation basis for Insurance handling		CMS_DTE_CMS_INS_CALC_BASIS	CHAR	20
INT_CALC_METH	Interest calculation method for Insurance		CMS_DTE_INS_INT_CAL_MTD	CHAR	4
CONTRACT_STRT_DT	Contract begin date		CMS_DTE_INS_CNTRT_STRT_DT	DATS	16
CONTRACT_END_DT	Contract end date		CMS_DTE_INS_CNTRT_END_DT	DATS	16
CONTRACT_CON_DT	Date of conclusion of contract		CMS_DTE_INS_CNTRT_CON_DT	DATS	16
INSUR_STATUS	Status of insurance		CMS_DTE_INS_STATUS	CHAR	12	TCMS_ATT_ID_TY
INSUR_STATUS_DT	Status date of insurance		CMS_DTE_INS_STATUS_DT	DATS	16
SUM_ONE_TM_CON	Sum of one time contribution		CMS_DTE_INS_SUM_ONE_TM_CON	CURR	9
ONE_TM_CON_CKY	Currency		CMS_DTE_INS_ONE_TM_CON_CKY	CUKY	10	TCURC
DYNAMICS	Dynamics		CMS_DTE_INS_DYNAMICS	CHAR	2
PER_DYNAMICS	Percentage of the dynamics		CMS_DTE_INS_PER_DYNAMICS	DEC	6
TERMIN_PRD	Termination period		CMS_DTE_INS_TERMIN_PRD	NUMC	8
TERM_PRD_UNIT	Indicator: Units of termination period		CMS_DTE_INS_TERM_PRD_UNIT	CHAR	4
RECALL_PRD	Recall period		CMS_DTE_INS_RECALL_PRD	NUMC	8
RECALL_PRD_UNIT	Indicator: Units of Recall Period		CMS_DTE_INS_RECALL_PRD_UNIT	CHAR	4
INS_SUM_SRVL	Insurance sum incase of survival		CMS_DTE_INS_SUM_IN_SURVIVAL	CURR	9
INS_SUM_SRVL_CKY	Insurance survival Currency		CMS_DTE_INS_SUM_IN_SURVIVL_CKY	CUKY	10	TCURC
INS_SUM_DTH	Insurance sum in case of death		CMS_DTE_INS_SUM_IN_DEATH	CURR	9
INS_SUM_DTH_CKY	Death benefit currency		CMS_DTE_INS_SUM_IN_DEATH_CKY	CUKY	10	TCURC
INS_BENF_EXP	Probable benefit on expiry		CMS_DTE_INS_PROB_BENF	CURR	9
INS_BENF_EXP_CKY	Currency for probable benefit on expiry		CMS_DTE_INS_PROB_BENF_CKY	CUKY	10	TCURC
DT_PROB_BEN_EXP	Date of probable benefit on expiry		CMS_DTE_INS_DT_PRO_BEN_EXP	DATS	16
.INCLUDE	INS_ADMIN_ORGUNIT			CMS_STR_ADMINORG	0
ADMIN_ORG_UNIT	Administration Organizational Unit		CMS_DTE_ADMINORG	CHAR	24
.INCLUDE	INS_BANKAREA			CMS_STR_BANKAREA	0
BANKAREA	Bank Area in Collateral Management		CMS_DTE_BANKAREA	CHAR	8	*
.INCLUDE	CHG_HISTORY			CMS_STR_CHG_HISTORY	0
CREATED_BY	Login ID of the User who created the Record		CMS_DTE_USER	CHAR	24
CREATED_AT	Creation Timestamp		CMS_DTE_CREATED_AT	DEC	8
CHANGED_BY	Last Changed By		CMS_DTE_LAST_CHNG_USER	CHAR	24
CHANGED_AT	Change Timestamp		CMS_DTE_CHANGED_AT	DEC	8
SOURCEOFENTRY	Source of Entry		CMS_DTE_SOURCE_OF_ENTRY	CHAR	64
.INCLUDE	BPCA			CMS_STR_BUSINESS_PROCESS	0
BUPR_ID	Business Process ID		CMS_DTE_BUPR_ID	RAW	16
BUPR_TYPE_CODE	Business Process Type Code		CMS_DTE_BUPR_TYP_CODE	CHAR	12