SAP ABAP Table CMS_STR_COR_RIG_REQ (OMS:Rights general)

Hierarchy

☛

EA-FINSERV (Software Component) SAP Enterprise Extension Financial Services
⤷

FS-CMS (Application Component) Collateral Management System
⤷

CMS_COR (Package) Correspondence serivce for CMS

Basic Data

Table Category	INTTAB	Structure
Structure	CMS_STR_COR_RIG_REQ	Table Relationship Diagram
Short Description	OMS:Rights general

Delivery and Maintenance

Pool/cluster
Delivery Class
Data Browser/Table View Maintenance		Display/Maintenance Allowed with Restrictions

Components


	Field	Data Element	Domain	Data Type	Length	Decimal Places	Short Description
1	WA_RIG_GEN	DFKKCOH		STRU	0	0
2	MANDT	MANDT	MANDT	CLNT	3	0	Client
3	COTYP	COTYP_KK	COTYP_KK	CHAR	4	0	Correspondence Type
4	COKEY	COKEY_KK	COKEY_KK	CHAR	36	0	Correspondence key
5	UNAME	SYUNAME	SYCHAR12	CHAR	12	0	User Name
6	CDATE	COCDT_KK	SYDATS	DATS	8	0	Created On
7	CTIME	COCTM_KK	SYTIME	TIMS	6	0	Time of Creation (to the Second)
8	GPART	CREC_GP_KK	BU_PARTNER	CHAR	10	0	Correspondence Recipient
9	GPART_GUID	CREC_GP_GUID_KK	SYSUUID_C	CHAR	32	0	Correspondence Recipient (GUID)
10	GPART_ADR_KIND	CORR_ADR_KIND_KK	BU_ADRKIND	CHAR	10	0	Address Type Of Correspondence Recipient
11	ORG_GPART	CREC_ORG_GP_KK	BU_PARTNER	CHAR	10	0	Original Correspondence Recipient
12	ORG_GPART_GUID	CREC_ORG_GP_GUID_KK	SYSUUID_C	CHAR	32	0	Original Correspondence Recipient (GUID)
13	ADD_GPART	CREC_GP_ADD_KK	BU_PARTNER	CHAR	10	0	Additional Business Partner for Correspondence Recipient
14	ADD_GPART_GUID	CREC_GP_ADD_GUID_KK	SYSUUID_C	CHAR	32	0	Addit. Business Partner for Correspondence Recipient GUID
15	ADD_GPART_CAT	CREC_GP_ADD_CAT_KK	CORR_CREC_ADD_CAT_KK	CHAR	1	0	Type of Additional Correspondence Recipient
16	VKONT	CORR_VKONT_KK	CORR_VKONT_KK	CHAR	12	0	Contract Account Number
17	VTREF	CORR_VTREF_KK	CORR_VTREF_KK	CHAR	20	0	Reference Specifications from Contract
18	ADR_VALID_ON	CREC_AD_VALID_ON_KK	TZNTSTMPS	DEC	15	0	Address of Correspondence Recipient Valid On
19	ADRNR	CREC_AD_KK	AD_ADDRNUM	CHAR	10	0	Address Number of Correspondence Recipient
20	ADR_GUID	CREC_AD_GUID_KK	SYSUUID_C	CHAR	32	0	Address GUID of Correspondence Recipient
21	ADRNR_INDEP_COMM	CREC_AD_INDEP_COMM_KK	AD_ADDRNUM	CHAR	10	0	Address Number for Address-Independent Communication
22	AGPART	CSEN_GP_KK	BU_PARTNER	CHAR	10	0	Sending Business Partner
23	AGPART_GUID	CSEN_GP_GUID_KK	SYSUUID_C	CHAR	32	0	Sender (GUID)
24	AGPART_ADR_KIND	CORR_ADR_KIND_KK	BU_ADRKIND	CHAR	10	0	Address Type Of Correspondence Recipient
25	AADRNR	CSEN_AD_KK	AD_ADDRNUM	CHAR	10	0	Address Number of Correspondence Sender
26	AADR_GUID	CSEN_AD_GUID_KK	SYSUUID_C	CHAR	32	0	Address GUID of Correspondence Sender
27	FORMKEY	FORMKEY	FORMKEY	CHAR	30	0	Application form
28	FORMKEY_RDI	FORMKEY	FORMKEY	CHAR	30	0	Application form
29	ENTID1	ENTID_KK	ENTID_KK	CHAR	4	0	Correspondence data
30	DATA1	CDATA_KK	CDATA_KK	CHAR	32	0	Correspondence Data Field
31	ENTID2	ENTID_KK	ENTID_KK	CHAR	4	0	Correspondence data
32	DATA2	CDATA_KK	CDATA_KK	CHAR	32	0	Correspondence Data Field
33	ENTID3	ENTID_KK	ENTID_KK	CHAR	4	0	Correspondence data
34	DATA3	CDATA_KK	CDATA_KK	CHAR	32	0	Correspondence Data Field
35	ENTID4	ENTID_KK	ENTID_KK	CHAR	4	0	Correspondence data
36	DATA4	CDATA_KK	CDATA_KK	CHAR	32	0	Correspondence Data Field
37	CSORT	CSORT_KK	CORR_TXT50	CHAR	50	0	Correspondence Sort Field
38	XCODT	XCODT_KK	XFELD	CHAR	1	0	Data Part Is Used
39	XCODT_CLUST	XCODT_CLUST_KK	XFELD	CHAR	1	0	Cluster Data Part is Used
40	LAUFD	CORR_LAUFD_KK	DATUM	DATS	8	0	Date ID for Creation Run
41	LAUFI	CORR_LAUFI_KK	CORR_LAUFI_KK	CHAR	6	0	Additional ID Characteristic for Creation Run
42	XTEST	XTEST_KK	XFELD	CHAR	1	0	Correspondence is Result of Test
43	COPRI	COPRI_KK	SYDATS	DATS	8	0	Print Date
44	COIDT	COIDT_KK	SYDATS	DATS	8	0	Date of Issue
45	COITM	COITM_KK	SYTIME	TIMS	6	0	Issue Time to the Second
46	SPRAS	SPRAS	SPRAS	LANG	1	0	Language Key
47	SALWA	CORR_BLWAE_KK	WAERS	CUKY	5	0	Transaction Currency
48	SALBE	CORR_BETRH_KK	WRTV7	CURR	13	2	Amount in Local Currency with +/- Signs
49	SENDCONTROL	SENDCONTROL	ESENDCONTROL	CHAR	4	0	Dispatch Control
50	PERSNUMBER	AD_PERSNUM	AD_PERSNUM	CHAR	10	0	Person number
51	APERSNUMBER	AD_PERSNUM	AD_PERSNUM	CHAR	10	0	Person number
52	BUKRS	CORR_BUKRS	CORR_BUKRS	CHAR	4	0	Company Code in Correspondence
53	CORR_ROLE	CORR_ROLE_KK	CORR_ROLE_KK	CHAR	4	0	Correspondence Roles
54	COPRI_LAUFD	COPRI_LAUFD_KK	DATUM	DATS	8	0	Date ID for Print Run
55	COPRI_LAUFI	COPRI_LAUFID_KK	COPRI_LAUFID_KK	CHAR	6	0	ID Characteristic for Run
56	PROCESS_ID_	CORR_PROCESS_ID_KK		CHAR	36	0	Business Process ID
57	NO_DOCPARTS	CORR_NO_DOCPARTS_KK		NUMC	4	0	Number of Document Parts
58	DOCPART_ROLE	CORR_DOCPART_ROLE_KK	CORR_DOCPART_ROLE_KK	CHAR	1	0	Document Part Role
59	XTRIAL	XTRIAL_KK	XFELD	CHAR	1	0	Correspondence Request is Test
60	XREPRINT	XREPRINT_KK	XFELD	CHAR	1	0	Recreate Correspondence
61	.INCLUDE				0	0
62	SUBAP	CORR_SUBAP_KK	CORR_SUBAP_KK	CHAR	1	0	Subapplication Indicator in Correspondence
63	XDELETE	X_CORR_DELETE_KK	XFELD	CHAR	1	0	Correspondence Is Logically Deleted
64	PRINT_MODE	PRINT_MODE_KK	BU_PRINT_MODE	CHAR	1	0	Business Partner Print Format
65	X_NO_ARC	X_NO_ARC_KK	XFELD	CHAR	1	0	SAP ArchiveLink Object ID Part Is Not Used
66	X_DOCPART_LIST	X_DOCPART_LIST_KK	XFELD	CHAR	1	0	Document Part List Is Used
67	.INCLU--AP				0	0	CMS appends for DFKKCOH
68	.INCLU-CMS				0	0	CMS include for DFKKCOH
69	OBJECT_IDCMS	CMS_DTE_OBJECT_ID	SYSUUID	RAW	16	0	Object Identification Number
70	FLG_ORIGINALCMS	CMS_DTE_FLG_ORIG	CMS_FLG	CHAR	1	0	Flag to indicate if the document is original or duplicate
71	SENDCONTROLCMS	SENDCONTROL	ESENDCONTROL	CHAR	4	0	Dispatch Control
72	.INCLU--AP				0	0	Loans Append for DFKKCOH
73	.INCLU-FVD				0	0	Loans Include for DFKKCOH
74	PRODUCTTYPEFVD	VVSART	VVSART	CHAR	3	0	Product Type
75	BP_ROLEFVD	BU_PARTNERROLE	BU_ROLE	CHAR	6	0	BP Role
76	BP_ROLETYPEFVD	BP_ROLE	BP_ROLE	CHAR	4	0	Business Partner Role Type
77	SOBJECTFVD	VVKEYOBJ	VVKEY	CHAR	10	0	Internal key for object
78	CORR_ACTIVITYFVD	KORRVORF	KORRVORF	NUMC	4	0	Correspondence activity
79	REFERENCEDATEFVD	TB_CORR_REFERENCE_DATE	DATUM	DATS	8	0	Reference Date for Creating Correspondence
80	WA_RECEIVER	CMS_STR_BPID		STRU	0	0
81	BU_PARTNERID	CMS_DTE_BPID	CMS_BPID	CHAR	32	0	Business Partner Identification Number
82	BP_DESCRIPTION	CMS_DTE_BP_ADDR_DESC	CMS_BP_ADDR_DESC	CHAR	60	0	Address description of Business Partner
83	WA_CLAIM_ADDR	CMS_STR_RIG_ADDR_MAP_GET_MLT		STRU	0	0
84	.INCLUDE				0	0	Rights primary key
85	RIG_GUID	CMS_DTE_RIG_GUID	SYSUUID	RAW	16	0	Rights GUID
86	.INCLUDE				0	0	Semantic Key for insurance
87	RIG_CATEGORY	CMS_DTE_OMS_OBJ_CAT	CMS_OBJ_CAT	CHAR	6	0	Object Category
88	RIG_TYP	CMS_DTE_RIG_TYP	CMS_RIG_TYP	CHAR	6	0	Right Type
89	RIG_ID	CMS_DTE_RIG_ID	CMS_MOV_ID	CHAR	40	0	Rights ID
90	.INCLUDE				0	0	Address details
91	.INCLUDE				0	0	Address return structure
92	.INCLUDE				0	0	Address selection parameter
93	ADDRNUMBER	AD_ADDRNUM	AD_ADDRNUM	CHAR	10	0	Address number
94	ADDRHANDLE	AD_HANDLE	TEXT140	CHAR	140	0	Handle for Creating Addresses/Persons (Bus. Addr. Services)
95	NATION	AD_NATION	AD_NATION	CHAR	1	0	Version ID for International Addresses
96	DATE	AD_DATE	DATUM	DATS	8	0	Date referred to
97	.INCLUDE				0	0	Address transfer structure
98	DATE_FROM	AD_DATE_FR	DATUM	DATS	8	0	Valid-from date - in current Release only 00010101 possible
99	DATE_TO	AD_DATE_TO	DATUM	DATS	8	0	Valid-to date in current Release only 99991231 possible
100	.INCLUDE				0	0	Include structure with name attributes of the ADRC address
101	TITLE	AD_TITLE	AD_TITLE	CHAR	4	0	Form-of-Address Key
102	NAME1	AD_NAME1	TEXT40	CHAR	40	0	Name 1
103	NAME2	AD_NAME2	TEXT40	CHAR	40	0	Name 2
104	NAME3	AD_NAME3	TEXT40	CHAR	40	0	Name 3
105	NAME4	AD_NAME4	TEXT40	CHAR	40	0	Name 4
106	NAME_TXT	AD_NAMETXT	TEXT50	CHAR	50	0	Converted name field (with form of address)
107	.INCLUDE				0	0	Include structure with ADRC attributes without name fields
108	NAME_CO	AD_NAME_CO	TEXT40	CHAR	40	0	c/o name
109	CITY1	AD_CITY1	TEXT40	CHAR	40	0	City
110	CITY2	AD_CITY2	TEXT40	CHAR	40	0	District
111	CITY_CODE	AD_CITYNUM	CITY_CODE	CHAR	12	0	City code for city/street file
112	CITYP_CODE	AD_CITYPNM	CITYP_CODE	CHAR	8	0	District code for City and Street file
113	HOME_CITY	AD_CITY3	TEXT40	CHAR	40	0	City (different from postal city)
114	CITYH_CODE	AD_CITYHNM	CITY_CODE	CHAR	12	0	Different city for city/street file
115	CHCKSTATUS	AD_CHECKST	AD_CHECKST	CHAR	1	0	City file test status
116	REGIOGROUP	REGIOGROUP	REGIOGROUP	CHAR	8	0	Regional structure grouping
117	POST_CODE1	AD_PSTCD1	CHAR10	CHAR	10	0	City postal code
118	POST_CODE2	AD_PSTCD2	CHAR10	CHAR	10	0	PO Box postal code
119	POST_CODE3	AD_PSTCD3	CHAR10	CHAR	10	0	Company postal code (for large customers)
120	PCODE1_EXT	AD_PST1XT	CHAR10	CHAR	10	0	(Not Supported)City Postal Code Extension, e.g. ZIP+4+2 Code
121	PCODE2_EXT	AD_PST2XT	CHAR10	CHAR	10	0	(Not Supported) PO Box Postal Code Extension
122	PCODE3_EXT	AD_PST3XT	CHAR10	CHAR	10	0	(Not Supported) Major Customer Postal Code Extension
123	PO_BOX	AD_POBX	CHAR10	CHAR	10	0	PO Box
124	DONT_USE_P	AD_NO_USEP	AD_NO_USE	CHAR	4	0	PO Box Address Undeliverable Flag
125	PO_BOX_NUM	AD_POBXNUM	XFELD	CHAR	1	0	Flag: PO Box without number
126	PO_BOX_LOC	AD_POBXLOC	TEXT40	CHAR	40	0	PO Box city
127	CITY_CODE2	AD_CIT2NUM	CITY_CODE	CHAR	12	0	City PO box code (City file)
128	PO_BOX_REG	AD_POBXREG	REGIO	CHAR	3	0	Region for PO Box (Country, State, Province, ...)
129	PO_BOX_CTY	AD_POBXCTY	LAND1	CHAR	3	0	PO box country
130	POSTALAREA	AD_PSTLAR	TEXT15	CHAR	15	0	(Not Supported) Post Delivery District
131	TRANSPZONE	LZONE	ZONE	CHAR	10	0	Transportation zone to or from which the goods are delivered
132	STREET	AD_STREET	TEXT60	CHAR	60	0	Street
133	DONT_USE_S	AD_NO_USES	AD_NO_USE	CHAR	4	0	Street Address Undeliverable Flag
134	STREETCODE	AD_STRNUM	STRT_CODE	CHAR	12	0	Street Number for City/Street File
135	STREETABBR	AD_STRABBR	STRTYPEAB	CHAR	2	0	(Not Supported) Abbreviation of Street Name
136	HOUSE_NUM1	AD_HSNM1	TEXT10	CHAR	10	0	House Number
137	HOUSE_NUM2	AD_HSNM2	TEXT10	CHAR	10	0	House number supplement
138	HOUSE_NUM3	AD_HSNM3	TEXT10	CHAR	10	0	(Not supported) House Number Range
139	STR_SUPPL1	AD_STRSPP1	TEXT40	CHAR	40	0	Street 2
140	STR_SUPPL2	AD_STRSPP2	TEXT40	CHAR	40	0	Street 3
141	STR_SUPPL3	AD_STRSPP3	TEXT40	CHAR	40	0	Street 4
142	LOCATION	AD_LCTN	TEXT40	CHAR	40	0	Street 5
143	BUILDING	AD_BLDNG	TEXT20	CHAR	20	0	Building (Number or Code)
144	FLOOR	AD_FLOOR	TEXT10	CHAR	10	0	Floor in building
145	ROOMNUMBER	AD_ROOMNUM	TEXT10	CHAR	10	0	Room or Appartment Number
146	COUNTRY	LAND1	LAND1	CHAR	3	0	Country Key
147	LANGU	SPRAS	SPRAS	LANG	1	0	Language Key
148	REGION	REGIO	REGIO	CHAR	3	0	Region (State, Province, County)
149	SORT1	AD_SORT1UL	TEXT20	CHAR	20	0	Search Term 1
150	SORT2	AD_SORT2UL	TEXT20	CHAR	20	0	Search Term 2
151	SORT_PHN	AD_SRTPHN	CHAR20	CHAR	20	0	(Not Supported) Phonetic Search Sort Field
152	ADDRORIGIN	AD_ORIGINA	AD_ORIGIN	CHAR	4	0	(Not Supported) Address Data Source (Key)
153	EXTENSION1	AD_EXTENS1	TEXT40	CHAR	40	0	Extension (only for data conversion) (e.g. data line)
154	EXTENSION2	AD_EXTENS2	TEXT40	CHAR	40	0	Extension (only for data conversion) (e.g. telebox)
155	TIME_ZONE	AD_TZONE	TZNZONE	CHAR	6	0	Address time zone
156	TAXJURCODE	AD_TXJCD	AD_TXJCD	CHAR	15	0	Tax Jurisdiction
157	ADDRESS_ID	AD_ADDR_ID	AD_ADDR_ID	CHAR	10	0	(Not supported) Physical address ID
158	REMARK	AD_REMARK1	TEXT50	CHAR	50	0	Address notes
159	LANGU_CREA	AD_LANGUCR	SPRAS	LANG	1	0	Address record creation original language
160	PO_BOX_LOBBY	AD_PO_BOX_LBY	TEXT40	CHAR	40	0	PO Box Lobby
161	DELI_SERV_TYPE	AD_DELIVERY_SERVICE_TYPE	AD_DELIVERY_SERVICE_TYPE	CHAR	4	0	Type of Delivery Service
162	DELI_SERV_NUMBER	AD_DELIVERY_SERVICE_NUMBER	CHAR10	CHAR	10	0	Number of Delivery Service
163	COUNTY_CODE	AD_CNTYNUM	CNTY_CODE	CHAR	8	0	County code for county
164	COUNTY	AD_COUNTY	TEXT40	CHAR	40	0	County
165	TOWNSHIP_CODE	AD_TWSHPNUM	TWSHP_CODE	CHAR	8	0	Township code for Township
166	TOWNSHIP	AD_TOWNSHIP	TEXT40	CHAR	40	0	Township
167	DEFLT_COMM	AD_COMM	AD_COMM	CHAR	3	0	Communication Method (Key) (Business Address Services)
168	TEL_NUMBER	AD_TLNMBR1	CHAR30	CHAR	30	0	First telephone no.: dialling code+number
169	TEL_EXTENS	AD_TLXTNS1	CHAR10	CHAR	10	0	First Telephone No.: Extension
170	FAX_NUMBER	AD_FXNMBR1	CHAR30	CHAR	30	0	First fax no.: dialling code+number
171	FAX_EXTENS	AD_FXXTNS1	CHAR10	CHAR	10	0	First fax no.: extension
172	ADDR_GROUP	AD_GROUP	AD_GROUP	CHAR	4	0	Address Group (Key) (Business Address Services)
173	WA_SENDER	P1028		STRU	0	0
174	.INCLUDE				0	0	Key Structure for Infotype Structures PNNNN
175	MANDT	MANDT	MANDT	CLNT	3	0	Client
176	PLVAR	PLVAR	PLVAR	CHAR	2	0	Plan Version
177	OTYPE	OTYPE	OTYPE	CHAR	2	0	Object Type
178	OBJID	OBJEKTID	NUM08	NUMC	8	0	Object ID
179	INFTY	INFOTYP	INFOTYP	CHAR	4	0	Infotype
180	SUBTY	SUBTYP	SUBTYP	CHAR	4	0	Subtype
181	ISTAT	ISTAT_D	ISTAT	CHAR	1	0	Planning Status
182	PRIOX	PRIOX	CHAR2	CHAR	2	0	Priority
183	BEGDA	BEGDATUM	DATUM	DATS	8	0	Start Date
184	ENDDA	ENDDATUM	DATUM	DATS	8	0	End Date
185	VARYF	VARYF	CHAR10	CHAR	10	0	Variation Field for File PLOG
186	SEQNR	SEQNR	NUM03	NUMC	3	0	Number of Infotype Record With Same Key
187	.INCLUDE				0	0	Infotype Administration Data
188	AEDTM	AEDTM	DATUM	DATS	8	0	Changed on
189	UNAME	USRNAME	CHAR12	CHAR	12	0	User Name
190	REASN	REASN	CHAR2	CHAR	2	0	Reason
191	HISTO	HISTO	CHAR1	CHAR	1	0	Historical Record Flag
192	ITXNR	ITXNR	NUM08	NUMC	8	0	Text Module for Infotype
193	.INCLUDE				0	0	Infotype 1028 Fields
194	CNAME	CNAME	TEXT25	CHAR	25	0	Address Supplement (c/o)
195	STRAS	PD_STRAS	TEXT30	CHAR	30	0	House Number and Street
196	ORT01	KORT	TEXT40	CHAR	40	0	City
197	PSTLZ	PD_PSTLZ	PSTLZ	CHAR	10	0	Postal Code
198	LAND1	KLAND	LAND1	CHAR	3	0	Country
199	TELNR	TELENR	CHAR25	CHAR	25	0	Telephone Number
200	FAXNR	FAXNR	CHAR25	CHAR	25	0	Fax Number
201	ENTKM	ENTKM	DEC3	DEC	3	0	Distance in Kilometers
202	BUILD	BUILD	BUILD	CHAR	8	0	Building
203	ROOM1	ROOM1	CHAR8	CHAR	8	0	Physical Room Number
204	ADRNR	ADRNR	ADRNR	CHAR	10	0	Address
205	REGIO	REGIO	REGIO	CHAR	3	0	Region (State, Province, County)
206	STRS2	STRAS_GP	TEXT35	CHAR	35	0	House number and street
207	HAUSN	HAUSN_BAS	CHAR6	CHAR	6	0	House number
208	.INCLUDE				0	0
209	WA_PAT_HDR	CMS_STR_PAT_DATA_MAP_GET_MLT		STRU	0	0
210	.INCLUDE				0	0	Rights primary key
211	RIG_GUID	CMS_DTE_RIG_GUID	SYSUUID	RAW	16	0	Rights GUID
212	.INCLUDE				0	0	Semantic Key for insurance
213	RIG_CATEGORY	CMS_DTE_OMS_OBJ_CAT	CMS_OBJ_CAT	CHAR	6	0	Object Category
214	RIG_TYP	CMS_DTE_RIG_TYP	CMS_RIG_TYP	CHAR	6	0	Right Type
215	RIG_ID	CMS_DTE_RIG_ID	CMS_MOV_ID	CHAR	40	0	Rights ID
216	RIG_CAT_NAME	CMS_DTE_OMS_CAT_NAME	CMS_OMS_CAT_NAME	CHAR	40	0	Object Category Name
217	RIG_TYP_NAME	CMS_DTE_RIG_TYP_NAME	CMS_RIG_NAME	CHAR	40	0	Right Type Name
218	.INCLUDE				0	0	Rights Common data
219	ADD_DESCR	CMS_DTE_CLM_DESC	CMS_DSC	CHAR	30	0	Additional description of the right
220	DURATION_BEGIN	CMS_DTE_RIG_BEGIN	CMS_DATE	DATS	8	0	Start date of the right
221	DURATION_END	CMS_DTE_RIG_END	CMS_DATE	DATS	8	0	Validity End Date of the Right or Patent
222	CLASSIFICATION	CMS_DTE_MOV_TYPE_FEAT	CMS_MOV_TYPE_FEAT	CHAR	6	0	Classification
223	.INCLUDE				0	0	Common OMS data
224	EXT_ITM_NO	CMS_DTE_OMS_EXT_ITM_NO	CMS_OMS_ID	CHAR	40	0	Ext. Item no / Number for identification of the objects
225	EXT_REFERENCE	CMS_DTE_OMS_REF_ID	CMS_OMS_REFID	CHAR	32	0	Reference number for the legacy system
226	.INCLUDE				0	0	Right Specific data
227	NOTAR_DATE	CMS_DTE_RIG_NOT_DAT	DATUM	DATS	8	0	Notarization Date
228	REGIS_DATE	CMS_DTE_RIG_REG_DAT	DATUM	DATS	8	0	Date of Patent Registration
229	PATENT_NO	CMS_DTE_RIG_PATENT_NO	CMS_OMS_ID	CHAR	40	0	Patent Number
230	REGISTRY_NO	CMS_DTE_RIG_REG_NO	CMS_RIG_REG_NO	CHAR	20	0	No. of the Register in the Patent Office
231	PATENT_OFFICE	CMS_DTE_RIG_PT_OFF	CMS_DSC	CHAR	30	0	Patent Office
232	ADD_PPTY_RIG	CMS_DTE_RIG_AV_PTY	CMS_ATT_ID_TYP	CHAR	6	0	Additional Property Rights that are Available
233	.INCLUDE				0	0	Link to rights primary key
234	PAT_PARENT_GUID	CMS_DTE_PARENT_GUID	SYSUUID	RAW	16	0	Links to Parent Patent - GUID of the Parent
235	.INCLUDE				0	0	Structure with Asset Details for Table CMS_AST
236	.INCLUDE				0	0	Basic Asset data
237	DESCRIPTION	CMS_DTE_AST_DESC	CMS_DSC	CHAR	30	0	Description
238	OBJECT_REF_ID	CMS_DTE_OBJ_REFID	CMS_OBJ_REFID	CHAR	40	0	Reference ID for the object
239	OBJECT_TYP	CMS_DTE_OBJ_TYP	CMS_OBJ_TYP	CHAR	32	0	Not used
240	COUNTRY_KEY	CMS_DTE_AST_COUNTRY_KEY	LAND1	CHAR	3	0	Identification Key for Country
241	RISK_CODE	CMS_DTE_RISK_CODE	CMS_RISK_CODE	CHAR	6	0	Risk Code
242	SFTY_IND	CMS_DTE_IND_SFTY_DISC	CMS_IND_SFTY	CHAR	2	0	Indicates if the Asset has a Default Safety Discount
243	SFTY_DSCNT	CMS_DTE_SAFETY_DSCNT	CMS_SFTY_PCT	DEC	10	6	Percentage of Safety Discount
244	SFTY_AMOUNT	CMS_DTE_SAFETY_AMT	CMS_AMOUNT	CURR	17	2	Amount of Safety Discount
245	SFTY_AMT_CURR	CMS_DTE_SAFETY_AMT_CURR	WAERS	CUKY	5	0	Currency of the Safety Discount Amount
246	OBJSYSID	CMS_DTE_OBJ_SYSID	CMS_SYS	CHAR	6	0	Object System Reference ID
247	.INCLUDE				0	0	Valuation data
248	VALUATION_TYP	CMS_DTE_IND_VALN_TYP	CMS_VALN_TYP	CHAR	2	0	Type of Valuation Check performed on Collateral Object
249	UNIT_VALN_FREQ	CMS_DTE_IND_AST_VALN_FREQ_UNIT	CMS_IND_AST_VALN_FREQ_UNIT	CHAR	2	0	Indicator: Units of time for revaluation of an asset
250	PERIOD_VALN_FREQ	CMS_DTE_AST_VALN_FREQ_PERIOD	CMS_AST_VALN_FREQ_PERIOD	NUMC	4	0	Revaluation Period for an Asset
251	PAST_VALUED_DATE	CMS_DTE_VALN_DATE	CMS_DATE	DATS	8	0	Last Date on which the Asset was Valued
252	START_DATE	CMS_DTE_START_DATE	CMS_DATE	DATS	8	0	Date on which the First Valuation is Performed on the Asset
253	END_DATE	CMS_DTE_END_DATE	CMS_DATE	DATS	8	0	Date on which the Last Valuation is Performed on the Asset
254	.INCLUDE				0	0	Lending rate data
255	LENDING_RATE_IND	CMS_DTE_IND_LND_RTE	CMS_IND_LRTE	CHAR	2	0	Indicator to specify if Asset has a Default Lending Rate
256	.INCLUDE				0	0	Lending rates structure
257	LENDING_RATE1	CMS_DTE_LRTE_PCT1	CMS_PCT	DEC	10	6	Lending Rate 1
258	LENDING_RATE2	CMS_DTE_LRTE_PCT2	CMS_PCT	DEC	10	6	Lending Rate 2
259	LENDING_RATE3	CMS_DTE_LRTE_PCT3	CMS_PCT	DEC	10	6	Lending Rate 3
260	LENDING_RATE4	CMS_DTE_LRTE_PCT4	CMS_PCT	DEC	10	6	Lending Rate 4
261	LENDING_RATE5	CMS_DTE_LRTE_PCT5	CMS_PCT	DEC	10	6	Lending Rate 5
262	.INCLUDE				0	0	Liquidation rights data
263	LIQD_TYP	CMS_DTE_LIQD_TYP	CMS_TYP	CHAR	6	0	Liquidation Type
264	LIQD_REASON	CMS_DTE_ATT_ID_TY_AST004	CMS_ATT_ID_TYP	CHAR	6	0	Liquidation Reason
265	LIQD_DATE	CMS_DTE_LIQD_DATE	CMS_DATE	DATS	8	0	Date on which the Collateral was Liquidated
266	LIQD_AMT	CMS_DTE_LIQD_VALUE	CMS_AMOUNT	CURR	17	2	Returns from the Liquidation of Collateral
267	LIQD_CURR	CMS_DTE_LIQD_CURR	WAERS	CUKY	5	0	Currency of Liquidation Value
268	EXP_PRCD_AMNT	CMS_DTE_LIQ_EXP_PRCD_AMOUNT	CMS_AMOUNT	CURR	17	2	Expected Proceed Amount
269	EXP_PRCD_CURR	CMS_DTE_LIQ_EXP_PRCD_CURR	WAERS	CUKY	5	0	Currency: Expected Proceed
270	EXP_ACC_DATE	CMS_DTE_LIQ_EXP_ACCRUAL_DATE	CMS_DATE	DATS	8	0	Expected accrual date
271	.INCLUDE				0	0	Account for liquidation proceeds
272	ACC_NUMBER_LIQ	CMS_DTE_LIQ_ACC_NUMBER	BANKN35	CHAR	35	0	Account number for liquidation proceeds
273	BANK_CNTRY_LIQ	CMS_DTE_LIQ_BNK_CTRY_KY	LAND1	CHAR	3	0	Bank country key
274	BANK_KEY_LIQ	CMS_DTE_LIQ_BNK_KEY	BANKK	CHAR	15	0	Bank Key
275	BANK_CTRLKEY_LIQ	BKONT	BKONT	CHAR	2	0	Bank Control Key
276	.INCLUDE				0	0	Verfication Data
277	UNIT_VERF_FREQ	CMS_DTE_IND_AST_VERF_FREQ_UNIT	CMS_IND_AST_VERF_FREQ_UNIT	CHAR	2	0	Indicator: Units of time for verification of an asset
278	PERIOD_VERF_FREQ	CMS_DTE_AST_VERF_FREQ_PERIOD	CMS_AST_VERF_FREQ_PERIOD	NUMC	4	0	Statement Period for an Asset
279	LAST_VERF_DATE	CMS_DTE_AST_VERF_DATE	CMS_DATE	DATS	8	0	Last Verification Date
280	.INCLUDE				0	0	AST PKy and Type and Parent GUID
281	AST_GUID	CMS_DTE_AST_GUID	SYSUUID	RAW	16	0	GUID for Table CMS_AST
282	AST_TYP	CMS_DTE_AST_TYP	CMS_AST_TYP	CHAR	6	0	Asset Type
283	PARENT_GUID	CMS_DTE_SAS_PAR_GUID	SYSUUID	RAW	16	0	Asset Guid as a parent GUID for a sub-asset
284	.INCLUDE				0	0	Structure for Asset values
285	NOM_VALUE	CMS_DTE_AST_NOMINAL_VALUE	CMS_AMOUNT	CURR	17	2	Nominal Value of the Asset
286	NOM_VALUE_CURR	CMS_DTE_AST_NOMINAL_VALUE_CURR	WAERS	CUKY	5	0	Currency of Nominal value
287	AST_VALUE	CMS_DTE_AST_VALUE	CMS_AMOUNT	CURR	17	2	Final Asset Value
288	AST_VALUE_CURR	CMS_DTE_AST_VALUE_CURR	WAERS	CUKY	5	0	Currency of the Final Asset Value
289	QUANTITY	CMS_DTE_QTY	CMS_QTY	QUAN	13	3	Quantity
290	UNIT_OF_MEASURE	CMS_DTE_UNIT	MEINS	UNIT	3	0	Unit of Measure of Quantity
291	REC_AT	CMS_DTE_REC_AT	TZNTSTMPS	DEC	15	0	Asset Value Recording Timestamp
292	.INCLUDE				0	0	Purchase price data
293	PUR_PRICE	CMS_DTE_AST_PURCHASE_PRICE	CMS_AMOUNT	CURR	17	2	Purchase Price of the Asset
294	PUR_PRICE_CURR	CMS_DTE_AST_PUR_PRICE_CURR	WAERS	CUKY	5	0	Currency of Purchase Price
295	PUR_DATE	CMS_DTE_AST_PUR_PRICE_DATE	CMS_DATE	DATS	8	0	Date of Purchase
296	.INCLUDE				0	0	Administrative organization unit
297	ADMIN_ORG_UNIT	CMS_DTE_ADMINORG	TEXT12	CHAR	12	0	Administration Organizational Unit
298	.INCLUDE				0	0	Bank area
299	BANKAREA	CMS_DTE_BANKAREA	CMS_BANKAREA	CHAR	4	0	Bank Area in Collateral Management
300	.INCLUDE				0	0	Organization unit structure
301	ORG_UNIT1	CMS_DTE_ORG_UNIT1	CMS_ORG_UNIT	CHAR	10	0	Organizational Unit 1
302	ORG_UNIT2	CMS_DTE_ORG_UNIT2	CMS_ORG_UNIT	CHAR	10	0	Organizational Unit 2
303	ORG_UNIT3	CMS_DTE_ORG_UNIT3	CMS_ORG_UNIT	CHAR	10	0	Organizational Unit 3
304	ORG_UNIT4	CMS_DTE_ORG_UNIT4	CMS_ORG_UNIT	CHAR	10	0	Organizational Unit 4
305	ORG_UNIT5	CMS_DTE_ORG_UNIT5	CMS_ORG_UNIT	CHAR	10	0	Organizational Unit 5
306	.INCLUDE				0	0	Stucture to record history of changes in all application tab
307	CREATED_BY	CMS_DTE_USER	CMS_USER	CHAR	12	0	Login ID of the User who created the Record
308	CREATED_AT	CMS_DTE_CREATED_AT	TZNTSTMPS	DEC	15	0	Creation Timestamp
309	CHANGED_BY	CMS_DTE_LAST_CHNG_USER	CMS_USER	CHAR	12	0	Last Changed By
310	CHANGED_AT	CMS_DTE_CHANGED_AT	TZNTSTMPS	DEC	15	0	Change Timestamp
311	SOURCEOFENTRY	CMS_DTE_SOURCE_OF_ENTRY	CMS_SOURCE	CHAR	32	0	Source of Entry
312	WA_INS_HDR	CMS_STR_LIF_INS_DATA_GET_MAP		STRU	0	0
313	.INCLUDE				0	0	Rights primary key
314	RIG_GUID	CMS_DTE_RIG_GUID	SYSUUID	RAW	16	0	Rights GUID
315	.INCLUDE				0	0	Semantic Key for insurance
316	RIG_CATEGORY	CMS_DTE_OMS_OBJ_CAT	CMS_OBJ_CAT	CHAR	6	0	Object Category
317	RIG_TYP	CMS_DTE_RIG_TYP	CMS_RIG_TYP	CHAR	6	0	Right Type
318	RIG_ID	CMS_DTE_RIG_ID	CMS_MOV_ID	CHAR	40	0	Rights ID
319	RIG_CAT_NAME	CMS_DTE_OMS_CAT_NAME	CMS_OMS_CAT_NAME	CHAR	40	0	Object Category Name
320	RIG_TYP_NAME	CMS_DTE_RIG_TYP_NAME	CMS_RIG_NAME	CHAR	40	0	Right Type Name
321	.INCLUDE				0	0	Insurance common data
322	INS_DESC	CMS_DTE_INS_DESC	CMS_INS_DESC	CHAR	30	0	Insurance Description
323	.INCLUDE				0	0	Information on Insurance Settlement
324	INSUR_TAX_DB	CMS_DTE_INS_TAX_DB	CMS_INS_FLG	CHAR	1	0	Insurance tax to the debit of the bank
325	SETLMNT_TYPE	CMS_DTE_INS_SETLMNT_TYPE	CMS_ATT_ID_TYP	CHAR	6	0	Type of settlement
326	INSUR_SUM	CMS_DTE_INS_SUM	CMS_AMOUNT	CURR	17	2	Insurance Sum
327	INSUR_CURR	CMS_DTE_INS_CURR	WAERS	CUKY	5	0	Insurance Currency
328	PRM_RT	CMS_DTE_INS_PRM_RT	CMS_INS_PRM_RT	DEC	10	7	Premium Rate
329	INSUR_PREMIUM	CMS_DTE_INS_PRM	CMS_AMOUNT	CURR	17	2	Insurance Premium
330	INSUR_PRM_CURR	CMS_DTE_INS_CURR	WAERS	CUKY	5	0	Insurance Currency
331	INSUR_TAX_RT	CMS_DTE_INS_TAX_RT	CMS_INS_PRM_RT	DEC	10	7	Insurance tax rate (in %)
332	INSUR_TAX_AMT	CMS_DTE_INS_TAX_AMT	CMS_AMOUNT	CURR	17	2	Insurance tax amount
333	INSUR_TAX_CURR	CMS_DTE_INS_TAX_CURR	WAERS	CUKY	5	0	Tax Currency
334	.INCLUDE				0	0	Insurance cover
335	SCOPE_INS_COVER	CMS_DTE_INS_COVER	CMS_INS_COVER	CHAR	6	0	not used -> package has to be changed CMS_OMS_INS
336	.INCLUDE				0	0	Common OMS data
337	EXT_ITM_NO	CMS_DTE_OMS_EXT_ITM_NO	CMS_OMS_ID	CHAR	40	0	Ext. Item no / Number for identification of the objects
338	EXT_REFERENCE	CMS_DTE_OMS_REF_ID	CMS_OMS_REFID	CHAR	32	0	Reference number for the legacy system
339	FOP	CMS_DTE_INS_FOP	CMS_INS_FREQ_OF_PAYMENT	NUMC	4	0	Frequency of Payment
340	FREQ_UNIT	CMS_DTE_INS_FREQ_UNIT	CMS_INS_IND_FREQ_UNIT	CHAR	2	0	Indicator: Units of time for revaluation
341	.INCLUDE				0	0	Other general fields required for a standalone insurance
342	INS_CODE	CMS_DTE_INS_CODE	CMS_INS_CODE	CHAR	6	0	Insurance Product Code
343	ORIG_COUNTRY	CMS_DTE_INS_ORIG_COUNTRY	LAND1	CHAR	3	0	Country where Insurance was purchased
344	ORIG_REGION	CMS_DTE_INS_ORIG_REGION	REGIO	CHAR	3	0	Region where Insurance was purchased
345	AUTO_CANCEL_DT	CMS_DTE_INS_AUTO_CANCEL_DT	CMS_DATE	DATS	8	0	Auto Cancellation Date for an Insurance Policy
346	PRM_TYPE	CMS_DTE_INS_PRM_TYPE	CMS_INS_PREMIUM_TYPE	CHAR	2	0	Type of Premium
347	PRM_VALID_FROM	CMS_DTE_INS_PRM_VALID_FROM_DT	CMS_DATE	DATS	8	0	Date from when specified Premium is valid
348	PAYMNT_METHOD	CMS_DTE_INS_PAYMENT_METHOD	CMS_INS_PAYMENT_METHOD	CHAR	2	0	Payment method for premiums
349	PAYMNT_INFO	CMS_DTE_INS_PAY_INFO	CMS_PAYMENT_HANDLE	CHAR	30	0	Payment Info for an insurance policy
350	LAST_PAYMENT_DT	CMS_DTE_INS_LAST_PAYMENT_DT	CMS_DATE	DATS	8	0	Date when last premium payment was made
351	NXT_PAYMENT_DT	CMS_DTE_INS_NXT_PAYMENT_DT	CMS_DATE	DATS	8	0	Next Payment Date when insurance premium is due
352	STATEMENT_DT	CMS_DTE_INS_STATEMENT_DT	CMS_DATE	DATS	8	0	Date when statements for Policy was made
353	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
354	PORTFOLIO	CMS_DTE_INS_PORTFOLIO	CMS_INS_PORTFOLIO	CHAR	6	0	Insurance Portfolio
355	MAX_AGE_LIMIT	CMS_DTE_INS_MAX_AGE_LIMIT	CMS_AGE	INT1	3	0	Maximum age limit for Policy Validity
356	MAX_COVER_AMT	CMS_DTE_INS_MAX_COVER_AMT	CMS_AMOUNT	CURR	17	2	Maximum Coverage Amount
357	MIN_COVER_AMT	CMS_DTE_INS_MIN_COVER_AMT	CMS_AMOUNT	CURR	17	2	Minimum Coverage Amount
358	IND_INSURED_EVNT	CMS_DTE_IND_INSURED_EVENT	CMS_IND_OCCURENCE	CHAR	1	0	Boolean indicator that insured event occured (X = Occured)
359	INSURED_EVENT_DT	CMS_DTE_INSURED_EVENT_DT	CMS_DATE	DATS	8	0	Date when Insured Event Occured
360	IND_FORCE_PLACED	CMS_DTE_INS_IND_FORCE_PLACE	CMS_IND_INS_FORCE_PLACE	CHAR	2	0	Is Insurance Force Placed? (Default = No)
361	IND_TAX_DEDUCT	CMS_DTE_INS_IND_TAX_DEDUCT	CMS_IND_INS_TAX_DEDUCTIBLE	CHAR	2	0	Indicator that Insurance Policy is Tax Deductible
362	INACTIVE_REASON	CMS_DTE_INS_INACTIVE_REASON	CMS_INS_INACTIVE_REASON	CHAR	2	0	Reason for inactivating insurance policy
363	POLICY_STATUS	CMS_DTE_INS_POLICY_STATUS	CMS_INS_POLICY_STATUS	CHAR	2	0	Insurance Policy Status
364	.INCLUDE				0	0	Insurance as object
365	.INCLUDE				0	0	Special features for description of insurances
366	TARRIF	CMS_DTE_INS_TARRIF	CMS_INS_TARRIF	CHAR	30	0	Insurance tariff
367	CONTRACT_STRT_DT	CMS_DTE_INS_CNTRT_STRT_DT	DATUM	DATS	8	0	Contract begin date
368	CONTRACT_END_DT	CMS_DTE_INS_CNTRT_END_DT	DATUM	DATS	8	0	Contract end date
369	CONTRACT_CON_DT	CMS_DTE_INS_CNTRT_CON_DT	DATUM	DATS	8	0	Date of conclusion of contract
370	INSUR_STATUS	CMS_DTE_INS_STATUS	CMS_ATT_ID_TYP	CHAR	6	0	Status of insurance
371	INSUR_STATUS_DT	CMS_DTE_INS_STATUS_DT	DATUM	DATS	8	0	Status date of insurance
372	SUM_ONE_TM_CON	CMS_DTE_INS_SUM_ONE_TM_CON	CMS_AMOUNT	CURR	17	2	Sum of one time contribution
373	ONE_TM_CON_CKY	CMS_DTE_INS_ONE_TM_CON_CKY	WAERS	CUKY	5	0	Currency
374	DYNAMICS	CMS_DTE_INS_DYNAMICS	CMS_INS_FLG	CHAR	1	0	Dynamics
375	PER_DYNAMICS	CMS_DTE_INS_PER_DYNAMICS	CMS_SEC_PCT	DEC	10	6	Percentage of the dynamics
376	TERMIN_PRD	CMS_DTE_INS_TERMIN_PRD	CMS_INS_FREQ_OF_PAYMENT	NUMC	4	0	Termination period
377	TERM_PRD_UNIT	CMS_DTE_INS_TERM_PRD_UNIT	CMS_INS_IND_FREQ_UNT	CHAR	2	0	Indicator: Units of termination period
378	RECALL_PRD	CMS_DTE_INS_RECALL_PRD	CMS_INS_FREQ_OF_PAYMENT	NUMC	4	0	Recall period
379	RECALL_PRD_UNIT	CMS_DTE_INS_RECALL_PRD_UNIT	CMS_INS_IND_FREQ_UNT	CHAR	2	0	Indicator: Units of Recall Period
380	INS_SUM_SRVL	CMS_DTE_INS_SUM_IN_SURVIVAL	CMS_AMOUNT	CURR	17	2	Insurance sum incase of survival
381	INS_SUM_SRVL_CKY	CMS_DTE_INS_SUM_IN_SURVIVL_CKY	WAERS	CUKY	5	0	Insurance survival Currency
382	INS_SUM_DTH	CMS_DTE_INS_SUM_IN_DEATH	CMS_AMOUNT	CURR	17	2	Insurance sum in case of death
383	INS_SUM_DTH_CKY	CMS_DTE_INS_SUM_IN_DEATH_CKY	WAERS	CUKY	5	0	Death benefit currency
384	INS_BENF_EXP	CMS_DTE_INS_PROB_BENF	CMS_AMOUNT	CURR	17	2	Probable benefit on expiry
385	INS_BENF_EXP_CKY	CMS_DTE_INS_PROB_BENF_CKY	WAERS	CUKY	5	0	Currency for probable benefit on expiry
386	DT_PROB_BEN_EXP	CMS_DTE_INS_DT_PRO_BEN_EXP	DATUM	DATS	8	0	Date of probable benefit on expiry
387	.INCLUDE				0	0	Structure with Asset Details for Table CMS_AST
388	.INCLUDE				0	0	Basic Asset data
389	DESCRIPTION	CMS_DTE_AST_DESC	CMS_DSC	CHAR	30	0	Description
390	OBJECT_REF_ID	CMS_DTE_OBJ_REFID	CMS_OBJ_REFID	CHAR	40	0	Reference ID for the object
391	OBJECT_TYP	CMS_DTE_OBJ_TYP	CMS_OBJ_TYP	CHAR	32	0	Not used
392	COUNTRY_KEY	CMS_DTE_AST_COUNTRY_KEY	LAND1	CHAR	3	0	Identification Key for Country
393	RISK_CODE	CMS_DTE_RISK_CODE	CMS_RISK_CODE	CHAR	6	0	Risk Code
394	SFTY_IND	CMS_DTE_IND_SFTY_DISC	CMS_IND_SFTY	CHAR	2	0	Indicates if the Asset has a Default Safety Discount
395	SFTY_DSCNT	CMS_DTE_SAFETY_DSCNT	CMS_SFTY_PCT	DEC	10	6	Percentage of Safety Discount
396	SFTY_AMOUNT	CMS_DTE_SAFETY_AMT	CMS_AMOUNT	CURR	17	2	Amount of Safety Discount
397	SFTY_AMT_CURR	CMS_DTE_SAFETY_AMT_CURR	WAERS	CUKY	5	0	Currency of the Safety Discount Amount
398	OBJSYSID	CMS_DTE_OBJ_SYSID	CMS_SYS	CHAR	6	0	Object System Reference ID
399	.INCLUDE				0	0	Valuation data
400	VALUATION_TYP	CMS_DTE_IND_VALN_TYP	CMS_VALN_TYP	CHAR	2	0	Type of Valuation Check performed on Collateral Object
401	UNIT_VALN_FREQ	CMS_DTE_IND_AST_VALN_FREQ_UNIT	CMS_IND_AST_VALN_FREQ_UNIT	CHAR	2	0	Indicator: Units of time for revaluation of an asset
402	PERIOD_VALN_FREQ	CMS_DTE_AST_VALN_FREQ_PERIOD	CMS_AST_VALN_FREQ_PERIOD	NUMC	4	0	Revaluation Period for an Asset
403	PAST_VALUED_DATE	CMS_DTE_VALN_DATE	CMS_DATE	DATS	8	0	Last Date on which the Asset was Valued
404	START_DATE	CMS_DTE_START_DATE	CMS_DATE	DATS	8	0	Date on which the First Valuation is Performed on the Asset
405	END_DATE	CMS_DTE_END_DATE	CMS_DATE	DATS	8	0	Date on which the Last Valuation is Performed on the Asset
406	.INCLUDE				0	0	Lending rate data
407	LENDING_RATE_IND	CMS_DTE_IND_LND_RTE	CMS_IND_LRTE	CHAR	2	0	Indicator to specify if Asset has a Default Lending Rate
408	.INCLUDE				0	0	Lending rates structure
409	LENDING_RATE1	CMS_DTE_LRTE_PCT1	CMS_PCT	DEC	10	6	Lending Rate 1
410	LENDING_RATE2	CMS_DTE_LRTE_PCT2	CMS_PCT	DEC	10	6	Lending Rate 2
411	LENDING_RATE3	CMS_DTE_LRTE_PCT3	CMS_PCT	DEC	10	6	Lending Rate 3
412	LENDING_RATE4	CMS_DTE_LRTE_PCT4	CMS_PCT	DEC	10	6	Lending Rate 4
413	LENDING_RATE5	CMS_DTE_LRTE_PCT5	CMS_PCT	DEC	10	6	Lending Rate 5
414	.INCLUDE				0	0	Liquidation rights data
415	LIQD_TYP	CMS_DTE_LIQD_TYP	CMS_TYP	CHAR	6	0	Liquidation Type
416	LIQD_REASON	CMS_DTE_ATT_ID_TY_AST004	CMS_ATT_ID_TYP	CHAR	6	0	Liquidation Reason
417	LIQD_DATE	CMS_DTE_LIQD_DATE	CMS_DATE	DATS	8	0	Date on which the Collateral was Liquidated
418	LIQD_AMT	CMS_DTE_LIQD_VALUE	CMS_AMOUNT	CURR	17	2	Returns from the Liquidation of Collateral
419	LIQD_CURR	CMS_DTE_LIQD_CURR	WAERS	CUKY	5	0	Currency of Liquidation Value
420	EXP_PRCD_AMNT	CMS_DTE_LIQ_EXP_PRCD_AMOUNT	CMS_AMOUNT	CURR	17	2	Expected Proceed Amount
421	EXP_PRCD_CURR	CMS_DTE_LIQ_EXP_PRCD_CURR	WAERS	CUKY	5	0	Currency: Expected Proceed
422	EXP_ACC_DATE	CMS_DTE_LIQ_EXP_ACCRUAL_DATE	CMS_DATE	DATS	8	0	Expected accrual date
423	.INCLUDE				0	0	Account for liquidation proceeds
424	ACC_NUMBER_LIQ	CMS_DTE_LIQ_ACC_NUMBER	BANKN35	CHAR	35	0	Account number for liquidation proceeds
425	BANK_CNTRY_LIQ	CMS_DTE_LIQ_BNK_CTRY_KY	LAND1	CHAR	3	0	Bank country key
426	BANK_KEY_LIQ	CMS_DTE_LIQ_BNK_KEY	BANKK	CHAR	15	0	Bank Key
427	BANK_CTRLKEY_LIQ	BKONT	BKONT	CHAR	2	0	Bank Control Key
428	.INCLUDE				0	0	Verfication Data
429	UNIT_VERF_FREQ	CMS_DTE_IND_AST_VERF_FREQ_UNIT	CMS_IND_AST_VERF_FREQ_UNIT	CHAR	2	0	Indicator: Units of time for verification of an asset
430	PERIOD_VERF_FREQ	CMS_DTE_AST_VERF_FREQ_PERIOD	CMS_AST_VERF_FREQ_PERIOD	NUMC	4	0	Statement Period for an Asset
431	LAST_VERF_DATE	CMS_DTE_AST_VERF_DATE	CMS_DATE	DATS	8	0	Last Verification Date
432	.INCLUDE				0	0	AST PKy and Type and Parent GUID
433	AST_GUID	CMS_DTE_AST_GUID	SYSUUID	RAW	16	0	GUID for Table CMS_AST
434	AST_TYP	CMS_DTE_AST_TYP	CMS_AST_TYP	CHAR	6	0	Asset Type
435	PARENT_GUID	CMS_DTE_SAS_PAR_GUID	SYSUUID	RAW	16	0	Asset Guid as a parent GUID for a sub-asset
436	.INCLUDE				0	0	Structure for Asset values
437	NOM_VALUE	CMS_DTE_AST_NOMINAL_VALUE	CMS_AMOUNT	CURR	17	2	Nominal Value of the Asset
438	NOM_VALUE_CURR	CMS_DTE_AST_NOMINAL_VALUE_CURR	WAERS	CUKY	5	0	Currency of Nominal value
439	AST_VALUE	CMS_DTE_AST_VALUE	CMS_AMOUNT	CURR	17	2	Final Asset Value
440	AST_VALUE_CURR	CMS_DTE_AST_VALUE_CURR	WAERS	CUKY	5	0	Currency of the Final Asset Value
441	QUANTITY	CMS_DTE_QTY	CMS_QTY	QUAN	13	3	Quantity
442	UNIT_OF_MEASURE	CMS_DTE_UNIT	MEINS	UNIT	3	0	Unit of Measure of Quantity
443	REC_AT	CMS_DTE_REC_AT	TZNTSTMPS	DEC	15	0	Asset Value Recording Timestamp
444	.INCLUDE				0	0	Purchase price data
445	PUR_PRICE	CMS_DTE_AST_PURCHASE_PRICE	CMS_AMOUNT	CURR	17	2	Purchase Price of the Asset
446	PUR_PRICE_CURR	CMS_DTE_AST_PUR_PRICE_CURR	WAERS	CUKY	5	0	Currency of Purchase Price
447	PUR_DATE	CMS_DTE_AST_PUR_PRICE_DATE	CMS_DATE	DATS	8	0	Date of Purchase
448	.INCLUDE				0	0	Administrative organization unit
449	ADMIN_ORG_UNIT	CMS_DTE_ADMINORG	TEXT12	CHAR	12	0	Administration Organizational Unit
450	.INCLUDE				0	0	Bank area
451	BANKAREA	CMS_DTE_BANKAREA	CMS_BANKAREA	CHAR	4	0	Bank Area in Collateral Management
452	.INCLUDE				0	0	Organization unit structure
453	ORG_UNIT1	CMS_DTE_ORG_UNIT1	CMS_ORG_UNIT	CHAR	10	0	Organizational Unit 1
454	ORG_UNIT2	CMS_DTE_ORG_UNIT2	CMS_ORG_UNIT	CHAR	10	0	Organizational Unit 2
455	ORG_UNIT3	CMS_DTE_ORG_UNIT3	CMS_ORG_UNIT	CHAR	10	0	Organizational Unit 3
456	ORG_UNIT4	CMS_DTE_ORG_UNIT4	CMS_ORG_UNIT	CHAR	10	0	Organizational Unit 4
457	ORG_UNIT5	CMS_DTE_ORG_UNIT5	CMS_ORG_UNIT	CHAR	10	0	Organizational Unit 5
458	.INCLUDE				0	0	Stucture to record history of changes in all application tab
459	CREATED_BY	CMS_DTE_USER	CMS_USER	CHAR	12	0	Login ID of the User who created the Record
460	CREATED_AT	CMS_DTE_CREATED_AT	TZNTSTMPS	DEC	15	0	Creation Timestamp
461	CHANGED_BY	CMS_DTE_LAST_CHNG_USER	CMS_USER	CHAR	12	0	Last Changed By
462	CHANGED_AT	CMS_DTE_CHANGED_AT	TZNTSTMPS	DEC	15	0	Change Timestamp
463	SOURCEOFENTRY	CMS_DTE_SOURCE_OF_ENTRY	CMS_SOURCE	CHAR	32	0	Source of Entry
464	WA_CLAIM_HDR	CMS_STR_CLM_DATA_GET_MAP		STRU	0	0
465	.INCLUDE				0	0	Rights primary key
466	RIG_GUID	CMS_DTE_RIG_GUID	SYSUUID	RAW	16	0	Rights GUID
467	.INCLUDE				0	0	Semantic Key for insurance
468	RIG_CATEGORY	CMS_DTE_OMS_OBJ_CAT	CMS_OBJ_CAT	CHAR	6	0	Object Category
469	RIG_TYP	CMS_DTE_RIG_TYP	CMS_RIG_TYP	CHAR	6	0	Right Type
470	RIG_ID	CMS_DTE_RIG_ID	CMS_MOV_ID	CHAR	40	0	Rights ID
471	RIG_CAT_NAME	CMS_DTE_OMS_CAT_NAME	CMS_OMS_CAT_NAME	CHAR	40	0	Object Category Name
472	RIG_TYP_NAME	CMS_DTE_RIG_TYP_NAME	CMS_RIG_NAME	CHAR	40	0	Right Type Name
473	.INCLUDE				0	0	Rights Common data
474	ADD_DESCR	CMS_DTE_CLM_DESC	CMS_DSC	CHAR	30	0	Additional description of the right
475	DURATION_BEGIN	CMS_DTE_RIG_BEGIN	CMS_DATE	DATS	8	0	Start date of the right
476	DURATION_END	CMS_DTE_RIG_END	CMS_DATE	DATS	8	0	Validity End Date of the Right or Patent
477	CLASSIFICATION	CMS_DTE_MOV_TYPE_FEAT	CMS_MOV_TYPE_FEAT	CHAR	6	0	Classification
478	.INCLUDE				0	0	Common OMS data
479	EXT_ITM_NO	CMS_DTE_OMS_EXT_ITM_NO	CMS_OMS_ID	CHAR	40	0	Ext. Item no / Number for identification of the objects
480	EXT_REFERENCE	CMS_DTE_OMS_REF_ID	CMS_OMS_REFID	CHAR	32	0	Reference number for the legacy system
481	.INCLUDE				0	0	Claim data
482	DUE_DATE	CMS_DTE_CLM_DUE_DATE	DATUM	DATS	8	0	Due date of a claim
483	COMPOSITION	CMS_DTE_CLM_COMP	CMS_DSC	CHAR	30	0	Composition of the claim
484	SAV_SUM	CMS_DTE_CLM_SAV_SUM	CMS_SEC_PCT	DEC	10	6	Savings sum in Percentage (In building savings contracts)
485	PROVBADDEBT_AMT	CMS_DTE_CLM_DBTDBT_AMT	CMS_AMOUNT	CURR	17	2	Provision doubtful debt amount
486	PROVBADDEBT_CURR	CMS_DTE_CLM_DBTDBT_CURR	WAERS	CUKY	5	0	Currency of Provision of doubfull debt
487	.INCLUDE				0	0	Address ID
488	ADDR_ID	CMS_DTE_CLM_ADDRESS	AD_ADDRNUM	CHAR	10	0	Address of the object (for build.sav.contr./rental claim)
489	.INCLUDE				0	0	Account Details
490	ACC_NUMBER	CMS_DTE_CLM_ACC_NUMBER	BANKN35	CHAR	35	0	Account number
491	BANK_COUNTRY_KEY	CMS_DTE_CLM_BNK_CTRY_KY	LAND1	CHAR	3	0	Bank country key
492	BANK_KEY	CMS_DTE_CLM_BNK_KEY	BANKK	CHAR	15	0	Bank Key
493	BANK_CTRL_KEY	BKONT	BKONT	CHAR	2	0	Bank Control Key
494	.INCLUDE				0	0	Structure with Asset Details for Table CMS_AST
495	.INCLUDE				0	0	Basic Asset data
496	DESCRIPTION	CMS_DTE_AST_DESC	CMS_DSC	CHAR	30	0	Description
497	OBJECT_REF_ID	CMS_DTE_OBJ_REFID	CMS_OBJ_REFID	CHAR	40	0	Reference ID for the object
498	OBJECT_TYP	CMS_DTE_OBJ_TYP	CMS_OBJ_TYP	CHAR	32	0	Not used
499	COUNTRY_KEY	CMS_DTE_AST_COUNTRY_KEY	LAND1	CHAR	3	0	Identification Key for Country
500	RISK_CODE	CMS_DTE_RISK_CODE	CMS_RISK_CODE	CHAR	6	0	Risk Code
501	SFTY_IND	CMS_DTE_IND_SFTY_DISC	CMS_IND_SFTY	CHAR	2	0	Indicates if the Asset has a Default Safety Discount
502	SFTY_DSCNT	CMS_DTE_SAFETY_DSCNT	CMS_SFTY_PCT	DEC	10	6	Percentage of Safety Discount
503	SFTY_AMOUNT	CMS_DTE_SAFETY_AMT	CMS_AMOUNT	CURR	17	2	Amount of Safety Discount
504	SFTY_AMT_CURR	CMS_DTE_SAFETY_AMT_CURR	WAERS	CUKY	5	0	Currency of the Safety Discount Amount
505	OBJSYSID	CMS_DTE_OBJ_SYSID	CMS_SYS	CHAR	6	0	Object System Reference ID
506	.INCLUDE				0	0	Valuation data
507	VALUATION_TYP	CMS_DTE_IND_VALN_TYP	CMS_VALN_TYP	CHAR	2	0	Type of Valuation Check performed on Collateral Object
508	UNIT_VALN_FREQ	CMS_DTE_IND_AST_VALN_FREQ_UNIT	CMS_IND_AST_VALN_FREQ_UNIT	CHAR	2	0	Indicator: Units of time for revaluation of an asset
509	PERIOD_VALN_FREQ	CMS_DTE_AST_VALN_FREQ_PERIOD	CMS_AST_VALN_FREQ_PERIOD	NUMC	4	0	Revaluation Period for an Asset
510	PAST_VALUED_DATE	CMS_DTE_VALN_DATE	CMS_DATE	DATS	8	0	Last Date on which the Asset was Valued
511	START_DATE	CMS_DTE_START_DATE	CMS_DATE	DATS	8	0	Date on which the First Valuation is Performed on the Asset
512	END_DATE	CMS_DTE_END_DATE	CMS_DATE	DATS	8	0	Date on which the Last Valuation is Performed on the Asset
513	.INCLUDE				0	0	Lending rate data
514	LENDING_RATE_IND	CMS_DTE_IND_LND_RTE	CMS_IND_LRTE	CHAR	2	0	Indicator to specify if Asset has a Default Lending Rate
515	.INCLUDE				0	0	Lending rates structure
516	LENDING_RATE1	CMS_DTE_LRTE_PCT1	CMS_PCT	DEC	10	6	Lending Rate 1
517	LENDING_RATE2	CMS_DTE_LRTE_PCT2	CMS_PCT	DEC	10	6	Lending Rate 2
518	LENDING_RATE3	CMS_DTE_LRTE_PCT3	CMS_PCT	DEC	10	6	Lending Rate 3
519	LENDING_RATE4	CMS_DTE_LRTE_PCT4	CMS_PCT	DEC	10	6	Lending Rate 4
520	LENDING_RATE5	CMS_DTE_LRTE_PCT5	CMS_PCT	DEC	10	6	Lending Rate 5
521	.INCLUDE				0	0	Liquidation rights data
522	LIQD_TYP	CMS_DTE_LIQD_TYP	CMS_TYP	CHAR	6	0	Liquidation Type
523	LIQD_REASON	CMS_DTE_ATT_ID_TY_AST004	CMS_ATT_ID_TYP	CHAR	6	0	Liquidation Reason
524	LIQD_DATE	CMS_DTE_LIQD_DATE	CMS_DATE	DATS	8	0	Date on which the Collateral was Liquidated
525	LIQD_AMT	CMS_DTE_LIQD_VALUE	CMS_AMOUNT	CURR	17	2	Returns from the Liquidation of Collateral
526	LIQD_CURR	CMS_DTE_LIQD_CURR	WAERS	CUKY	5	0	Currency of Liquidation Value
527	EXP_PRCD_AMNT	CMS_DTE_LIQ_EXP_PRCD_AMOUNT	CMS_AMOUNT	CURR	17	2	Expected Proceed Amount
528	EXP_PRCD_CURR	CMS_DTE_LIQ_EXP_PRCD_CURR	WAERS	CUKY	5	0	Currency: Expected Proceed
529	EXP_ACC_DATE	CMS_DTE_LIQ_EXP_ACCRUAL_DATE	CMS_DATE	DATS	8	0	Expected accrual date
530	.INCLUDE				0	0	Account for liquidation proceeds
531	ACC_NUMBER_LIQ	CMS_DTE_LIQ_ACC_NUMBER	BANKN35	CHAR	35	0	Account number for liquidation proceeds
532	BANK_CNTRY_LIQ	CMS_DTE_LIQ_BNK_CTRY_KY	LAND1	CHAR	3	0	Bank country key
533	BANK_KEY_LIQ	CMS_DTE_LIQ_BNK_KEY	BANKK	CHAR	15	0	Bank Key
534	BANK_CTRLKEY_LIQ	BKONT	BKONT	CHAR	2	0	Bank Control Key
535	.INCLUDE				0	0	Verfication Data
536	UNIT_VERF_FREQ	CMS_DTE_IND_AST_VERF_FREQ_UNIT	CMS_IND_AST_VERF_FREQ_UNIT	CHAR	2	0	Indicator: Units of time for verification of an asset
537	PERIOD_VERF_FREQ	CMS_DTE_AST_VERF_FREQ_PERIOD	CMS_AST_VERF_FREQ_PERIOD	NUMC	4	0	Statement Period for an Asset
538	LAST_VERF_DATE	CMS_DTE_AST_VERF_DATE	CMS_DATE	DATS	8	0	Last Verification Date
539	.INCLUDE				0	0	AST PKy and Type and Parent GUID
540	AST_GUID	CMS_DTE_AST_GUID	SYSUUID	RAW	16	0	GUID for Table CMS_AST
541	AST_TYP	CMS_DTE_AST_TYP	CMS_AST_TYP	CHAR	6	0	Asset Type
542	PARENT_GUID	CMS_DTE_SAS_PAR_GUID	SYSUUID	RAW	16	0	Asset Guid as a parent GUID for a sub-asset
543	.INCLUDE				0	0	Structure for Asset values
544	NOM_VALUE	CMS_DTE_AST_NOMINAL_VALUE	CMS_AMOUNT	CURR	17	2	Nominal Value of the Asset
545	NOM_VALUE_CURR	CMS_DTE_AST_NOMINAL_VALUE_CURR	WAERS	CUKY	5	0	Currency of Nominal value
546	AST_VALUE	CMS_DTE_AST_VALUE	CMS_AMOUNT	CURR	17	2	Final Asset Value
547	AST_VALUE_CURR	CMS_DTE_AST_VALUE_CURR	WAERS	CUKY	5	0	Currency of the Final Asset Value
548	QUANTITY	CMS_DTE_QTY	CMS_QTY	QUAN	13	3	Quantity
549	UNIT_OF_MEASURE	CMS_DTE_UNIT	MEINS	UNIT	3	0	Unit of Measure of Quantity
550	REC_AT	CMS_DTE_REC_AT	TZNTSTMPS	DEC	15	0	Asset Value Recording Timestamp
551	.INCLUDE				0	0	Purchase price data
552	PUR_PRICE	CMS_DTE_AST_PURCHASE_PRICE	CMS_AMOUNT	CURR	17	2	Purchase Price of the Asset
553	PUR_PRICE_CURR	CMS_DTE_AST_PUR_PRICE_CURR	WAERS	CUKY	5	0	Currency of Purchase Price
554	PUR_DATE	CMS_DTE_AST_PUR_PRICE_DATE	CMS_DATE	DATS	8	0	Date of Purchase
555	.INCLUDE				0	0	Administrative organization unit
556	ADMIN_ORG_UNIT	CMS_DTE_ADMINORG	TEXT12	CHAR	12	0	Administration Organizational Unit
557	.INCLUDE				0	0	Bank area
558	BANKAREA	CMS_DTE_BANKAREA	CMS_BANKAREA	CHAR	4	0	Bank Area in Collateral Management
559	.INCLUDE				0	0	Organization unit structure
560	ORG_UNIT1	CMS_DTE_ORG_UNIT1	CMS_ORG_UNIT	CHAR	10	0	Organizational Unit 1
561	ORG_UNIT2	CMS_DTE_ORG_UNIT2	CMS_ORG_UNIT	CHAR	10	0	Organizational Unit 2
562	ORG_UNIT3	CMS_DTE_ORG_UNIT3	CMS_ORG_UNIT	CHAR	10	0	Organizational Unit 3
563	ORG_UNIT4	CMS_DTE_ORG_UNIT4	CMS_ORG_UNIT	CHAR	10	0	Organizational Unit 4
564	ORG_UNIT5	CMS_DTE_ORG_UNIT5	CMS_ORG_UNIT	CHAR	10	0	Organizational Unit 5
565	.INCLUDE				0	0	Stucture to record history of changes in all application tab
566	CREATED_BY	CMS_DTE_USER	CMS_USER	CHAR	12	0	Login ID of the User who created the Record
567	CREATED_AT	CMS_DTE_CREATED_AT	TZNTSTMPS	DEC	15	0	Creation Timestamp
568	CHANGED_BY	CMS_DTE_LAST_CHNG_USER	CMS_USER	CHAR	12	0	Last Changed By
569	CHANGED_AT	CMS_DTE_CHANGED_AT	TZNTSTMPS	DEC	15	0	Change Timestamp
570	SOURCEOFENTRY	CMS_DTE_SOURCE_OF_ENTRY	CMS_SOURCE	CHAR	32	0	Source of Entry
571	T_SYS_STAT	CMS_TAB_COR_RIG_SYS_STAT		TTYP	0	0
572	T_USR_STAT	CMS_TAB_COR_RIG_USR_STAT		TTYP	0	0
573	T_INS_DOC	CMS_TAB_COR_RIG_INS_DOC		TTYP	0	0
574	T_INS_BP	CMS_TAB_COR_RIG_INS_BP		TTYP	0	0
575	T_INS_DATA	CMS_TAB_COR_RIG_INS_DATA		TTYP	0	0
576	T_VAL_DATA	CMS_TAB_COR_RIG_VAL		TTYP	0	0
577	T_DOCU	CMS_TAB_COR_RIG_DOC		TTYP	0	0
578	T_BUPA	CMS_TAB_COR_RIG_BP		TTYP	0	0