1 |
CAG_GUID |
|
CMS_DTE_CAG_GUID |
SYSUUID |
RAW |
16 |
0 |
GUID for Table CMS_CAG |
|
2 |
CAGMTID |
|
CMS_DTE_CAGID |
CMS_CAGID |
CHAR |
40 |
0 |
Collateral Agreement ID |
|
3 |
CAGMT_TYPE |
|
CMS_DTE_CAG_TYP |
CMS_CAG_TYP |
CHAR |
6 |
0 |
Collateral Agreement Type |
* |
4 |
INT_RATE |
|
CMS_DTE_CAG_LCHG_INT_RATE |
CMS_PCT |
DEC |
10 |
6 |
Land Charge Interest Rate |
|
5 |
INCIDENTAL_PAYMT |
|
CMS_DTE_CAG_LCHG_INCD_PAYMT |
CMS_PCT |
DEC |
10 |
6 |
Incidental Payments in Percentage |
|
6 |
UNIT_PMT_FREQ |
|
CMS_DTE_IND_CAG_PYMT_FREQ_UNIT |
CMS_IND_CAG_FREQ_UNIT |
CHAR |
2 |
0 |
The unit for period of payment frequency |
|
7 |
PERIOD_PMT_FREQ |
|
CMS_DTE_CAG_PYMT_FREQ_PERIOD |
CMS_CAG_FREQ_PERIOD |
NUMC |
4 |
0 |
Period for Frequency of Payment of Land Charge Interest |
|
8 |
INT_START_DATE |
|
CMS_DTE_CAG_LCHG_INT_START_DAT |
CMS_DATE |
DATS |
8 |
0 |
Start Date for Land Charge Interest Calculation |
|
9 |
NUM_YR_LCHG_INT |
|
CMS_DTE_CAG_LCHG_INT_YR |
CMS_CAG_LCHG_INT_YR |
NUMC |
4 |
0 |
Number of Years the Land Charge Interest can be Capitalized |
|
10 |
IND_ENFORCMT_TYP |
|
CMS_DTE_IND_CAG_LCHG_ENFC_TYP |
CMS_IND_CAG_LCHG_ENFC_TYP |
CHAR |
2 |
0 |
Enforcement Type |
|
11 |
ENFORCMT_AMT |
|
CMS_DTE_CAG_LCHG_ENFC_AMT |
CMS_AMOUNT |
CURR |
17 |
2 |
Enforcement Amount |
|
12 |
ENFORCMT_CURR |
|
CMS_DTE_CAG_LCHG_ENFC_AMT_CURR |
WAERS |
CUKY |
5 |
0 |
Currency for Enforcement Amount of Land Charge |
* |
13 |
REF_ENFORCMT_AMT |
|
CMS_DTE_CAG_LCHG_ENFC_REF_AMT |
CMS_AMOUNT |
CURR |
17 |
2 |
Reference amount for part (Equal,Secondar) enforcebility |
|
14 |
RANK |
|
CMS_DTE_CAG_LCHG_ENFC_RANK |
CMS_CAG_LCHG_ENFC_RANK |
NUMC |
4 |
0 |
Rank of the Land Charge Enforceable Amount |
|
15 |
ENFORCMT_TITLE |
|
CMS_DTE_IND_CAG_LCHG_ENFC_TITL |
CMS_IND_CAG_LCHG_ENFC_TITLE |
CHAR |
2 |
0 |
Indicator for Enforcement Title |
|
16 |
UNIT_INT_FREQ |
|
CMS_DTE_IND_CAG_HBR_INT_UNIT |
CMS_IND_CAG_FREQ_UNIT |
CHAR |
2 |
0 |
Unit for period of Payment Frequency of HBR interest |
|
17 |
PERIOD_INT_FREQ |
|
CMS_DTE_CAG_HBR_INT_PERIOD |
CMS_CAG_FREQ_PERIOD |
NUMC |
4 |
0 |
Payment Frequency Period for HBR interest |
|
18 |
FLG_INTEREST_INC |
|
CMS_DTE_FLG_LCHG_INC_INT |
CMS_FLG_LCHG_INC_INT |
CHAR |
1 |
0 |
Flag for increase in HBR interest |
|
19 |
UNIT_INC_FREQ |
|
CMS_DTE_IND_CAG_HBR_INC_UNIT |
CMS_IND_CAG_FREQ_UNIT |
CHAR |
2 |
0 |
Unit for Frequency Period of Increase in HBR Interest |
|
20 |
PERIOD_INC_FREQ |
|
CMS_DTE_CAG_HBR_INC_PERIOD |
CMS_CAG_FREQ_PERIOD |
NUMC |
4 |
0 |
Frequency Period for Increase in HBR Interest |
|
21 |
INC_PCT |
|
CMS_DTE_CAG_LCHG_INC_PCT |
CMS_PCT |
DEC |
10 |
6 |
Percentage Increase in Heritable Building Rights Amount |
|
22 |
INC_AMT |
|
CMS_DTE_CAG_LCHG_INC_AMT |
CMS_AMOUNT |
CURR |
17 |
2 |
Increase in Heritable Building Rights Amount |
|
23 |
INC_CURR |
|
CMS_DTE_CAG_LCHG_INC_AMT_CURR |
WAERS |
CUKY |
5 |
0 |
Currency for Increase in HBR amount |
* |
24 |
INC_START_DATE |
|
CMS_DTE_CAG_LCHG_INC_START_DAT |
CMS_DATE |
DATS |
8 |
0 |
Start date for Increase in Heritable Building Right Interest |
|
25 |
IND_HBR_WAIVER |
|
CMS_DTE_IND_CAG_LCHG_HBR_WAIVE |
CMS_IND_CAG_LCHG_HBR_WAIVER |
CHAR |
2 |
0 |
Indicator for Waiver of HBR Enforcement |
|
26 |
INC_LAST_DATE |
|
CMS_DTE_CAG_LCHG_INC_LAST_DATE |
CMS_DATE |
DATS |
8 |
0 |
Last date of Increase in Heritable Building Right Interest |
|
27 |
FLG_COLL_LCHG |
|
CMS_DTE_FLG_CAG_LCHG_COLL |
CMS_FLG_CAG_LCHG_COLLECTIVE |
CHAR |
1 |
0 |
Flag: Collective Land Charge |
|
28 |
FLG_CHARGE_CERT |
|
CMS_DTE_FLG_CAG_LCHG_CERT |
CMS_FLG_LCHG_CERT |
CHAR |
1 |
0 |
Flag: Land Charge certificate exists |
|
29 |
CHARGE_CERT_NUM |
|
CMS_DTE_CAG_LCHG_CERT_NUM |
CMS_LCHG_CERT_NUM |
CHAR |
30 |
0 |
Charge Certificate Number |
|
30 |
FILE_NUM |
|
CMS_DTE_CAG_LCHG_FILE_NUM |
CMS_LCHG_FILE_NUM |
CHAR |
30 |
0 |
File Number |
|