1 |
WA_CAG_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_SENDER |
|
P1028 |
|
STRU |
0 |
0 |
|
|
81 |
.INCLUDE |
|
|
|
|
0 |
0 |
Key Structure for Infotype Structures PNNNN |
|
82 |
MANDT |
|
MANDT |
MANDT |
CLNT |
3 |
0 |
Client |
|
83 |
PLVAR |
|
PLVAR |
PLVAR |
CHAR |
2 |
0 |
Plan Version |
|
84 |
OTYPE |
|
OTYPE |
OTYPE |
CHAR |
2 |
0 |
Object Type |
|
85 |
OBJID |
|
OBJEKTID |
NUM08 |
NUMC |
8 |
0 |
Object ID |
|
86 |
INFTY |
|
INFOTYP |
INFOTYP |
CHAR |
4 |
0 |
Infotype |
|
87 |
SUBTY |
|
SUBTYP |
SUBTYP |
CHAR |
4 |
0 |
Subtype |
|
88 |
ISTAT |
|
ISTAT_D |
ISTAT |
CHAR |
1 |
0 |
Planning Status |
|
89 |
PRIOX |
|
PRIOX |
CHAR2 |
CHAR |
2 |
0 |
Priority |
|
90 |
BEGDA |
|
BEGDATUM |
DATUM |
DATS |
8 |
0 |
Start Date |
|
91 |
ENDDA |
|
ENDDATUM |
DATUM |
DATS |
8 |
0 |
End Date |
|
92 |
VARYF |
|
VARYF |
CHAR10 |
CHAR |
10 |
0 |
Variation Field for File PLOG |
|
93 |
SEQNR |
|
SEQNR |
NUM03 |
NUMC |
3 |
0 |
Number of Infotype Record With Same Key |
|
94 |
.INCLUDE |
|
|
|
|
0 |
0 |
Infotype Administration Data |
|
95 |
AEDTM |
|
AEDTM |
DATUM |
DATS |
8 |
0 |
Changed on |
|
96 |
UNAME |
|
USRNAME |
CHAR12 |
CHAR |
12 |
0 |
User Name |
|
97 |
REASN |
|
REASN |
CHAR2 |
CHAR |
2 |
0 |
Reason |
|
98 |
HISTO |
|
HISTO |
CHAR1 |
CHAR |
1 |
0 |
Historical Record Flag |
|
99 |
ITXNR |
|
ITXNR |
NUM08 |
NUMC |
8 |
0 |
Text Module for Infotype |
|
100 |
.INCLUDE |
|
|
|
|
0 |
0 |
Infotype 1028 Fields |
|
101 |
CNAME |
|
CNAME |
TEXT25 |
CHAR |
25 |
0 |
Address Supplement (c/o) |
|
102 |
STRAS |
|
PD_STRAS |
TEXT30 |
CHAR |
30 |
0 |
House Number and Street |
|
103 |
ORT01 |
|
KORT |
TEXT40 |
CHAR |
40 |
0 |
City |
|
104 |
PSTLZ |
|
PD_PSTLZ |
PSTLZ |
CHAR |
10 |
0 |
Postal Code |
|
105 |
LAND1 |
|
KLAND |
LAND1 |
CHAR |
3 |
0 |
Country |
|
106 |
TELNR |
|
TELENR |
CHAR25 |
CHAR |
25 |
0 |
Telephone Number |
|
107 |
FAXNR |
|
FAXNR |
CHAR25 |
CHAR |
25 |
0 |
Fax Number |
|
108 |
ENTKM |
|
ENTKM |
DEC3 |
DEC |
3 |
0 |
Distance in Kilometers |
|
109 |
BUILD |
|
BUILD |
BUILD |
CHAR |
8 |
0 |
Building |
|
110 |
ROOM1 |
|
ROOM1 |
CHAR8 |
CHAR |
8 |
0 |
Physical Room Number |
|
111 |
ADRNR |
|
ADRNR |
ADRNR |
CHAR |
10 |
0 |
Address |
|
112 |
REGIO |
|
REGIO |
REGIO |
CHAR |
3 |
0 |
Region (State, Province, County) |
|
113 |
STRS2 |
|
STRAS_GP |
TEXT35 |
CHAR |
35 |
0 |
House number and street |
|
114 |
HAUSN |
|
HAUSN_BAS |
CHAR6 |
CHAR |
6 |
0 |
House number |
|
115 |
.INCLUDE |
|
|
|
|
0 |
0 |
|
|
116 |
WA_CAG_ADMIN |
|
CMS_STR_CAG_ADMIN_DATA_GET_MAP |
|
STRU |
0 |
0 |
|
|
117 |
CAG_GUID |
|
CMS_DTE_CAG_GUID |
SYSUUID |
RAW |
16 |
0 |
GUID for Table CMS_CAG |
|
118 |
CAGMTID |
|
CMS_DTE_CAGID |
CMS_CAGID |
CHAR |
40 |
0 |
Collateral Agreement ID |
|
119 |
CAGMT_TYPE |
|
CMS_DTE_CAG_TYP |
CMS_CAG_TYP |
CHAR |
6 |
0 |
Collateral Agreement Type |
|
120 |
ADMIN_ORG_UNIT |
|
CMS_DTE_ADMINORG |
TEXT12 |
CHAR |
12 |
0 |
Administration Organizational Unit |
|
121 |
BANKAREA |
|
CMS_DTE_BANKAREA |
CMS_BANKAREA |
CHAR |
4 |
0 |
Bank Area in Collateral Management |
|
122 |
ORG_UNIT1 |
|
CMS_DTE_CAG_ORG_UNIT1 |
CMS_ORG_UNIT |
CHAR |
10 |
0 |
Organizational Unit 1: Collateral Agreement |
|
123 |
ORG_UNIT2 |
|
CMS_DTE_CAG_ORG_UNIT2 |
CMS_ORG_UNIT |
CHAR |
10 |
0 |
Organizational Unit 2: Collateral Agreement |
|
124 |
ORG_UNIT3 |
|
CMS_DTE_CAG_ORG_UNIT3 |
CMS_ORG_UNIT |
CHAR |
10 |
0 |
Organizational Unit 3: Collateral Agreement |
|
125 |
ORG_UNIT4 |
|
CMS_DTE_CAG_ORG_UNIT4 |
CMS_ORG_UNIT |
CHAR |
10 |
0 |
Organizational Unit 4: Collateral Agreement |
|
126 |
ORG_UNIT5 |
|
CMS_DTE_CAG_ORG_UNIT5 |
CMS_ORG_UNIT |
CHAR |
10 |
0 |
Organizational Unit 5: Collateral Agreement |
|
127 |
WA_GUAR_DATA |
|
CMS_STR_CAG_GUAR_GET_MAP |
|
STRU |
0 |
0 |
|
|
128 |
CAG_GUID |
|
CMS_DTE_CAG_GUID |
SYSUUID |
RAW |
16 |
0 |
GUID for Table CMS_CAG |
|
129 |
CAGMTID |
|
CMS_DTE_CAGID |
CMS_CAGID |
CHAR |
40 |
0 |
Collateral Agreement ID |
|
130 |
CAGMT_TYPE |
|
CMS_DTE_CAG_TYP |
CMS_CAG_TYP |
CHAR |
6 |
0 |
Collateral Agreement Type |
|
131 |
FLG_COUNTER_GUAR |
|
CMS_DTE_FLG_CAG_CNTR_GUAR |
CMS_FLG_CNTR_GUAR |
CHAR |
1 |
0 |
Flag for Counter Guarantee |
|
132 |
FLG_CO_GUAR |
|
CMS_DTE_FLG_CAG_CO_GUAR |
CMS_FLG_CO_GUAR |
CHAR |
1 |
0 |
Flag for Co-guarantee |
|
133 |
FLG_FIXED_LIABTY |
|
CMS_DTE_FLG_CAG_FIXED_LIABILTY |
CMS_FLG_FIXED_LIABILITY |
CHAR |
1 |
0 |
Flag for Fixed Liability |
|
134 |
FLG_DEF_LIABTY |
|
CMS_DTE_FLG_CAG_DEF_LIABILITY |
CMS_FLG_DEF_LIABILITY |
CHAR |
1 |
0 |
Flag for Default Liability |
|
135 |
PCT_DEF_LIABTY |
|
CMS_DTE_FLG_CAG_PCT_DEF_LIABTY |
CMS_PCT |
DEC |
10 |
6 |
Default Liability in % |
|
136 |
FLG_INCL_CAG_LNK |
|
CMS_DTE_FLG_CAG_INCL_LINKED |
CMS_FLG_CAG_INCL_LINKED |
CHAR |
1 |
0 |
Flag for back-up guarantee to be used in calculations or not |
|
137 |
IND_APPR_AUTH |
|
CMS_DTE_IND_CAG_APPR_AUTH |
CMS_IND_CAG_APPR_AUTH |
CHAR |
2 |
0 |
Approval from authorities |
|
138 |
FLG_ENFORCEABLE |
|
CMS_DTE_FLG_CAG_ENFORCEABLE |
CMS_FLG_DIR_ENFC |
CHAR |
1 |
0 |
Agreement directly enforceable |
|
139 |
LENDING_RATE |
|
CMS_DTE_CAG_LRTE_PCT |
CMS_PCT |
DEC |
10 |
6 |
Lending Rate of a Guarantee |
|
140 |
UNIT_REDU_FREQ |
|
CMS_DTE_IND_CAG_RED_FREQ_UNIT |
CMS_IND_CAG_FREQ_UNIT |
CHAR |
2 |
0 |
Unit for Period of Frequency for Reduction in Guarantee Valu |
|
141 |
PERIOD_REDU_FREQ |
|
CMS_DTE_CAG_RED_FREQ_PERIOD |
CMS_CAG_FREQ_PERIOD |
NUMC |
4 |
0 |
Period for Frequency of Reduction in Value of Guarantee |
|
142 |
REDU_AMT |
|
CMS_DTE_CAG_REDU_AMT |
CMS_AMOUNT |
CURR |
17 |
2 |
Reduction in Amount of Guarantee |
|
143 |
REDU_CURR |
|
CMS_DTE_CAG_REDU_AMT_CURR |
WAERS |
CUKY |
5 |
0 |
Currency of the Reduced Amount of the Guarantee |
|
144 |
REDU_PCT |
|
CMS_DTE_CAG_REDU_PCT |
CMS_PCT |
DEC |
10 |
6 |
Percentage of Reduction in the Value of a Guarantee |
|
145 |
REDU_START_DATE |
|
CMS_DTE_CAG_REDU_START_DATE |
CMS_DATE |
DATS |
8 |
0 |
Date from which Guarantee Value is Reduced |
|
146 |
REDU_END_DATE |
|
CMS_DTE_CAG_REDU_END_DATE |
CMS_DATE |
DATS |
8 |
0 |
End Date for Reduction in Amount of Guarantee |
|
147 |
REDU_LAST_DATE |
|
CMS_DTE_CAG_REDU_LAST_DATE |
CMS_DATE |
DATS |
8 |
0 |
Last date of reduction of value |
|
148 |
WA_TRANS_DATA |
|
CMS_STR_CAG_TRANSFER_GET_MAP |
|
STRU |
0 |
0 |
|
|
149 |
CAG_GUID |
|
CMS_DTE_CAG_GUID |
SYSUUID |
RAW |
16 |
0 |
GUID for Table CMS_CAG |
|
150 |
CAGMTID |
|
CMS_DTE_CAGID |
CMS_CAGID |
CHAR |
40 |
0 |
Collateral Agreement ID |
|
151 |
CAGMT_TYPE |
|
CMS_DTE_CAG_TYP |
CMS_CAG_TYP |
CHAR |
6 |
0 |
Collateral Agreement Type |
|
152 |
FLG_LEASING_TXN |
|
CMS_DTE_FLG_CAG_LEASING_TXN |
CMS_FLG_LEASING_TRANSACTION |
CHAR |
1 |
0 |
Flag: Transfer is part of a leasing transaction |
|
153 |
IND_LESSOR_LIEN |
|
CMS_DTE_IND_CAG_LESSOR_LIEN |
CMS_IND_CAG_LESSOR_LIEN |
CHAR |
2 |
0 |
Indicator for Lessor Lien on Collateral Agreement |
|
154 |
IND_ACC_LIABLE |
|
CMS_DTE_IND_CAG_ACC_LIABLE |
CMS_IND_CAG_ACC_LIABLE |
CHAR |
2 |
0 |
Specifies the applicability of accessories liability |
|
155 |
FLG_ASGMT_AR |
|
CMS_DTE_FLG_CAG_AR_FRM_SALE |
CMS_FLG_ASGMT_RBL_FROM_SALE |
CHAR |
1 |
0 |
Flag for Assignment of Accounts Receivables(AR) from Sale |
|
156 |
WA_LCHG_DATA |
|
CMS_STR_CAG_LCHG_GET_MAP |
|
STRU |
0 |
0 |
|
|
157 |
CAG_GUID |
|
CMS_DTE_CAG_GUID |
SYSUUID |
RAW |
16 |
0 |
GUID for Table CMS_CAG |
|
158 |
CAGMTID |
|
CMS_DTE_CAGID |
CMS_CAGID |
CHAR |
40 |
0 |
Collateral Agreement ID |
|
159 |
CAGMT_TYPE |
|
CMS_DTE_CAG_TYP |
CMS_CAG_TYP |
CHAR |
6 |
0 |
Collateral Agreement Type |
|
160 |
INT_RATE |
|
CMS_DTE_CAG_LCHG_INT_RATE |
CMS_PCT |
DEC |
10 |
6 |
Land Charge Interest Rate |
|
161 |
INCIDENTAL_PAYMT |
|
CMS_DTE_CAG_LCHG_INCD_PAYMT |
CMS_PCT |
DEC |
10 |
6 |
Incidental Payments in Percentage |
|
162 |
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 |
|
163 |
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 |
|
164 |
INT_START_DATE |
|
CMS_DTE_CAG_LCHG_INT_START_DAT |
CMS_DATE |
DATS |
8 |
0 |
Start Date for Land Charge Interest Calculation |
|
165 |
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 |
|
166 |
IND_ENFORCMT_TYP |
|
CMS_DTE_IND_CAG_LCHG_ENFC_TYP |
CMS_IND_CAG_LCHG_ENFC_TYP |
CHAR |
2 |
0 |
Enforcement Type |
|
167 |
ENFORCMT_AMT |
|
CMS_DTE_CAG_LCHG_ENFC_AMT |
CMS_AMOUNT |
CURR |
17 |
2 |
Enforcement Amount |
|
168 |
ENFORCMT_CURR |
|
CMS_DTE_CAG_LCHG_ENFC_AMT_CURR |
WAERS |
CUKY |
5 |
0 |
Currency for Enforcement Amount of Land Charge |
|
169 |
REF_ENFORCMT_AMT |
|
CMS_DTE_CAG_LCHG_ENFC_REF_AMT |
CMS_AMOUNT |
CURR |
17 |
2 |
Reference amount for part (Equal,Secondar) enforcebility |
|
170 |
RANK |
|
CMS_DTE_CAG_LCHG_ENFC_RANK |
CMS_CAG_LCHG_ENFC_RANK |
NUMC |
4 |
0 |
Rank of the Land Charge Enforceable Amount |
|
171 |
ENFORCMT_TITLE |
|
CMS_DTE_IND_CAG_LCHG_ENFC_TITL |
CMS_IND_CAG_LCHG_ENFC_TITLE |
CHAR |
2 |
0 |
Indicator for Enforcement Title |
|
172 |
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 |
|
173 |
PERIOD_INT_FREQ |
|
CMS_DTE_CAG_HBR_INT_PERIOD |
CMS_CAG_FREQ_PERIOD |
NUMC |
4 |
0 |
Payment Frequency Period for HBR interest |
|
174 |
FLG_INTEREST_INC |
|
CMS_DTE_FLG_LCHG_INC_INT |
CMS_FLG_LCHG_INC_INT |
CHAR |
1 |
0 |
Flag for increase in HBR interest |
|
175 |
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 |
|
176 |
PERIOD_INC_FREQ |
|
CMS_DTE_CAG_HBR_INC_PERIOD |
CMS_CAG_FREQ_PERIOD |
NUMC |
4 |
0 |
Frequency Period for Increase in HBR Interest |
|
177 |
INC_PCT |
|
CMS_DTE_CAG_LCHG_INC_PCT |
CMS_PCT |
DEC |
10 |
6 |
Percentage Increase in Heritable Building Rights Amount |
|
178 |
INC_AMT |
|
CMS_DTE_CAG_LCHG_INC_AMT |
CMS_AMOUNT |
CURR |
17 |
2 |
Increase in Heritable Building Rights Amount |
|
179 |
INC_CURR |
|
CMS_DTE_CAG_LCHG_INC_AMT_CURR |
WAERS |
CUKY |
5 |
0 |
Currency for Increase in HBR amount |
|
180 |
INC_START_DATE |
|
CMS_DTE_CAG_LCHG_INC_START_DAT |
CMS_DATE |
DATS |
8 |
0 |
Start date for Increase in Heritable Building Right Interest |
|
181 |
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 |
|
182 |
INC_LAST_DATE |
|
CMS_DTE_CAG_LCHG_INC_LAST_DATE |
CMS_DATE |
DATS |
8 |
0 |
Last date of Increase in Heritable Building Right Interest |
|
183 |
FLG_COLL_LCHG |
|
CMS_DTE_FLG_CAG_LCHG_COLL |
CMS_FLG_CAG_LCHG_COLLECTIVE |
CHAR |
1 |
0 |
Flag: Collective Land Charge |
|
184 |
FLG_CHARGE_CERT |
|
CMS_DTE_FLG_CAG_LCHG_CERT |
CMS_FLG_LCHG_CERT |
CHAR |
1 |
0 |
Flag: Land Charge certificate exists |
|
185 |
CHARGE_CERT_NUM |
|
CMS_DTE_CAG_LCHG_CERT_NUM |
CMS_LCHG_CERT_NUM |
CHAR |
30 |
0 |
Charge Certificate Number |
|
186 |
FILE_NUM |
|
CMS_DTE_CAG_LCHG_FILE_NUM |
CMS_LCHG_FILE_NUM |
CHAR |
30 |
0 |
File Number |
|
187 |
WA_ASGMT_PLDG |
|
CMS_STR_CAG_ASGMT_PLDG_GET_MAP |
|
STRU |
0 |
0 |
|
|
188 |
CAG_GUID |
|
CMS_DTE_CAG_GUID |
SYSUUID |
RAW |
16 |
0 |
GUID for Table CMS_CAG |
|
189 |
CAGMTID |
|
CMS_DTE_CAGID |
CMS_CAGID |
CHAR |
40 |
0 |
Collateral Agreement ID |
|
190 |
CAGMT_TYPE |
|
CMS_DTE_CAG_TYP |
CMS_CAG_TYP |
CHAR |
6 |
0 |
Collateral Agreement Type |
|
191 |
IND_GBC_LIEN |
|
CMS_DTE_IND_CAG_GBC_LIEN |
CMS_IND_CAG_GBC_LIEN |
CHAR |
2 |
0 |
GBC Lien on Agreement |
|
192 |
FLG_DISCL |
|
CMS_DTE_FLG_CAG_DISCL_PLEDGE |
CMS_FLG_DISCL_PLEDGE |
CHAR |
1 |
0 |
Flag to indicator whether the Agreement is disclosed or not |
|
193 |
DISCL_DATE |
|
CMS_DTE_CAG_DISCL_DATE |
CMS_DATE |
DATS |
8 |
0 |
Date of Disclosure to Third-party Debtor |
|
194 |
ASGMT_REASON |
|
CMS_DTE_CAG_ATT_ID_TY_CAG006 |
CMS_ATT_ID_TYP |
CHAR |
6 |
0 |
Reason for Assignment |
|
195 |
WA_CALC_VAL |
|
CMS_STR_CAG_CALC_GET_MAP |
|
STRU |
0 |
0 |
|
|
196 |
CAG_GUID |
|
CMS_DTE_CAG_GUID |
SYSUUID |
RAW |
16 |
0 |
GUID for Table CMS_CAG |
|
197 |
CAGMTID |
|
CMS_DTE_CAGID |
CMS_CAGID |
CHAR |
40 |
0 |
Collateral Agreement ID |
|
198 |
CAGMT_TYPE |
|
CMS_DTE_CAG_TYP |
CMS_CAG_TYP |
CHAR |
6 |
0 |
Collateral Agreement Type |
|
199 |
COLL_VALUE |
|
CMS_DTE_CALC_COLL_VALUE |
CMS_AMOUNT |
CURR |
17 |
2 |
Collateral Value Calculation for CAG |
|
200 |
COV_RATIO |
|
CMS_DTE_CALC_COV_RATIO_PCT |
CMS_PCT |
DEC |
10 |
6 |
Coverage ratio of collateral agreements |
|
201 |
LTOV_CAG_AMT |
|
CMS_DTE_CALC_LTOV_CAG_AMT |
CMS_AMOUNT |
CURR |
17 |
2 |
Loan to value ratio for cag as amount |
|
202 |
LTOV_CAG_PCT |
|
CMS_DTE_CALC_LTOV_CAG_PCT |
CMS_RES_PCT |
DEC |
10 |
2 |
Loan to value ratio for cag as percentage |
|
203 |
RESULT_CURR |
|
CMS_DTE_CALC_RES_CURR |
WAERS |
CUKY |
5 |
0 |
Calculations Result Currency |
|
204 |
IND_RBL_RISK_METHOD |
|
CMS_DTE_IND_RISK_METHOD |
CMS_RISK_METHOD |
CHAR |
1 |
0 |
Indicator for RBL amt : Referring to MaxRisk or CurrRisk |
|
205 |
WA_RECEIVER |
|
CMS_STR_BPID |
|
STRU |
0 |
0 |
|
|
206 |
BU_PARTNERID |
|
CMS_DTE_BPID |
CMS_BPID |
CHAR |
32 |
0 |
Business Partner Identification Number |
|
207 |
BP_DESCRIPTION |
|
CMS_DTE_BP_ADDR_DESC |
CMS_BP_ADDR_DESC |
CHAR |
60 |
0 |
Address description of Business Partner |
|
208 |
WA_CAG_BASIC |
|
CMS_STR_CAG_BASIC_DATA_GET_MAP |
|
STRU |
0 |
0 |
|
|
209 |
CAG_GUID |
|
CMS_DTE_CAG_GUID |
SYSUUID |
RAW |
16 |
0 |
GUID for Table CMS_CAG |
|
210 |
CAGMTID |
|
CMS_DTE_CAGID |
CMS_CAGID |
CHAR |
40 |
0 |
Collateral Agreement ID |
|
211 |
CATEGORYID |
|
CMS_DTE_CAG_CAT |
CMS_CAT |
CHAR |
6 |
0 |
Collateral Agreement Category ID |
|
212 |
CAGMT_TYPE |
|
CMS_DTE_CAG_TYP |
CMS_CAG_TYP |
CHAR |
6 |
0 |
Collateral Agreement Type |
|
213 |
CAGMT_TYP_DESC |
|
CMS_DTE_CAG_TYP_NAME |
CMS_NAME |
CHAR |
40 |
0 |
Name of Collateral Agreement Type |
|
214 |
NOM_VALUE |
|
CMS_DTE_CAG_NOMINAL_VALUE |
CMS_AMOUNT |
CURR |
17 |
2 |
Nominal Value of the Collateral Agreement |
|
215 |
NOM_VALUE_CURR |
|
CMS_DTE_CAG_NOMINAL_CURR |
WAERS |
CUKY |
5 |
0 |
Currency for Nominal Value of the Collateral Agreement |
|
216 |
CAGMT_DATE |
|
CMS_DTE_CAG_DATE |
CMS_DATE |
DATS |
8 |
0 |
Date on which Collateral Agreement was Concluded |
|
217 |
VALID_FROM |
|
CMS_DTE_VALID_FROM |
CMS_DATE |
DATS |
8 |
0 |
Date from when it is valid |
|
218 |
VALID_TO |
|
CMS_DTE_VALID_TO |
CMS_DATE |
DATS |
8 |
0 |
Date until when it is valid |
|
219 |
COUNTRY_KEY |
|
CMS_DTE_COUNTRY_KEY |
LAND1 |
CHAR |
3 |
0 |
Jurisdiction Country |
|
220 |
FLG_GLOBAL |
|
CMS_DTE_FLG_CAG_GLOBAL |
CMS_FLG_GLOBAL_CAGMT |
CHAR |
1 |
0 |
Flag to indicate a Global Collateral Agreement |
|
221 |
PCT_ASSET_VAL |
|
CMS_DTE_PCT_AST_VAL |
CMS_PCT |
DEC |
10 |
6 |
Percentage of the Asset Value used in Collateral Agreement |
|
222 |
GUAR_RATE |
|
CMS_DTE_CAG_GUAR_RATE |
CMS_PCT |
DEC |
10 |
6 |
Guarantee Rate |
|
223 |
SPL_MARKDOWN_PCT |
|
CMS_DTE_CAG_SPL_MARKDOWN_PCT |
CMS_PCT |
DEC |
10 |
6 |
Percentage of Special Markdown |
|
224 |
SPL_MARKDOWN_AMT |
|
CMS_DTE_CAG_SPL_MARKDOWN_AMT |
CMS_AMOUNT |
CURR |
17 |
2 |
Amount of Special Markdown |
|
225 |
SPL_MRKDOWN_CURR |
|
CMS_DTE_CAG_SPL_MRKDWN_CURR |
WAERS |
CUKY |
5 |
0 |
Currency for Amount of Special Markdown |
|
226 |
DESCRIPTION |
|
CMS_DTE_CAG_DESC |
CMS_DSC |
CHAR |
30 |
0 |
Description of Collateral Agreement |
|
227 |
UNIT_REL_FREQ |
|
CMS_DTE_IND_CAG_REL_FREQ_UNIT |
CMS_IND_CAG_FREQ_UNIT |
CHAR |
2 |
0 |
The unit for period of Release Frequency |
|
228 |
PERIOD_REL_FREQ |
|
CMS_DTE_CAG_REL_FREQ_PERIOD |
CMS_CAG_FREQ_PERIOD |
NUMC |
4 |
0 |
Period for Frequency of Release of Collateral Agreement |
|
229 |
OLD_CAGMTID |
|
CMS_DTE_OLD_CAGID |
CMS_OLD_CAGID |
CHAR |
40 |
0 |
External/Old Collateral Agreement ID |
|
230 |
MIN_QL_EXCEP_TYP |
|
CMS_DTE_CAG_MIN_QUAL_EXCEP_TYP |
CMS_CAG_MIN_QUAL_EXCEP_TYP |
CHAR |
6 |
0 |
Exceptions for Minimum Risk Weight |
|
231 |
MIN_QL_REASON |
|
CMS_DTE_CAG_ATT_ID_TY_CAG001 |
CMS_ATT_ID_TYP |
CHAR |
6 |
0 |
Reason for the Minimum Qualitative Criterion |
|
232 |
FLG_MIN_QL_REQMT |
|
CMS_DTE_FLG_CAG_MIN_QUAL_REQMT |
CMS_FLG_MIN_QUAL_REQMT |
CHAR |
1 |
0 |
Flag:Minimum requirements fulfilled for CAG(for Basel II) |
|
233 |
MIN_QL_CRITE |
|
CMS_DTE_CAG_MIN_QUAL_CRITERION |
CMS_CAG_MIN_QUAL_CRITERION |
CHAR |
6 |
0 |
MInimum Qualitative Criterion |
|
234 |
TERM_RIGHT_TYP |
|
CMS_DTE_TERM_RIGHT_TYP |
CMS_CAG_TERM_RIGHT_TYP |
CHAR |
6 |
0 |
Termination Right Type |
|
235 |
UNIT_TERM_FREQ |
|
CMS_DTE_IND_CAG_TERM_FREQ_UNIT |
CMS_IND_CAG_FREQ_UNIT |
CHAR |
2 |
0 |
The Unit for Period of Termination Frequency |
|
236 |
PERIOD_TERM_FREQ |
|
CMS_DTE_CAG_TERM_FREQ_PERIOD |
CMS_CAG_FREQ_PERIOD |
NUMC |
4 |
0 |
Period for Frequency of Termination of Collateral Agreement |
|
237 |
NOTICE_PRD_UNIT |
|
CMS_DTE_IND_CAG_NOTICE_UNIT |
CMS_IND_CAG_TIME_PRD_UNIT |
CHAR |
2 |
0 |
The Unit for the Termination Notice Period |
|
238 |
REQ_NOTICE_PRD |
|
CMS_DTE_CAG_NOTICE_PERIOD |
CMS_CAG_FREQ_PERIOD |
NUMC |
4 |
0 |
Notice Period Required to Terminate Collateral Agreement |
|
239 |
TERM_NOTICE_DATE |
|
CMS_DTE_CAG_TERM_NOTICE_DATE |
CMS_DATE |
DATS |
8 |
0 |
Date on which Termination Notice was Sent |
|
240 |
TERM_REASON |
|
CMS_DTE_CAG_ATT_ID_TY_CAG002 |
CMS_ATT_ID_TYP |
CHAR |
6 |
0 |
Termination Type |
|
241 |
TERM_GUAR_AMT |
|
CMS_DTE_CAG_TERM_VALUE |
CMS_AMOUNT |
CURR |
17 |
2 |
Amount of Guarantee in the event of Termination |
|
242 |
TERMINATION_CURR |
|
CMS_DTE_CAG_TERM_VALUE_CURR |
WAERS |
CUKY |
5 |
0 |
Currency for Amount of Guarantee in the event of Termination |
|
243 |
MIN_STOCK_AMT |
|
CMS_DTE_CAG_MIN_STOCK_AMT |
CMS_AMOUNT |
CURR |
17 |
2 |
Minimum stock Amount agreed in the Collateral Agreement |
|
244 |
MIN_STOCK_CURR |
|
CMS_DTE_CAG_MIN_STOCK_AMT_CURR |
WAERS |
CUKY |
5 |
0 |
Currency of the Minimum Stock Amount |
|
245 |
FLG_ADDNL_RBL |
|
CMS_DTE_FLG_CAG_ADDNL_RBL |
CMS_FLG_ADDNL_RBL |
CHAR |
1 |
0 |
Flag for Additional receivable |
|
246 |
ADDNL_RBL_DATE |
|
CMS_DTE_CAG_DATE_ADDNL_RBL |
CMS_DATE |
DATS |
8 |
0 |
Date on which Additional Receivable was Accepted |
|
247 |
SCOPE_INS_COVER |
|
CMS_DTE_CAG_ATT_ID_TY_CAG004 |
CMS_ATT_ID_TYP |
CHAR |
6 |
0 |
Scope of Cover of Credit Insurance |
|
248 |
LIQD_MODE |
|
CMS_DTE_LIQD_MODE |
CMS_LIQD_MODE |
CHAR |
6 |
0 |
Mode of Liquidation decision for the pool agreement |
|
249 |
REL_THRESHOLD |
|
CMS_DTE_CAG_RELEASE_THRESHOLD |
CMS_PCT |
DEC |
10 |
6 |
Limit above which the Collaterals can be Released from Pool |
|
250 |
COR_ROLE |
|
CMS_DTE_COR_ROLE |
CORR_ROLE_KK |
CHAR |
4 |
0 |
Correspondence role |
|
251 |
T_BUPA |
|
CMS_TAB_COR_CAG_BP |
|
TTYP |
0 |
0 |
|
|
252 |
T_CHARGES |
|
CMS_TAB_COR_CAG_CHG |
|
TTYP |
0 |
0 |
|
|
253 |
T_PORTIONS |
|
CMS_TAB_COR_CAG_POR_DATA |
|
TTYP |
0 |
0 |
|
|
254 |
T_SYS_STAT |
|
CMS_TAB_COR_CAG_SYS_STAT |
|
TTYP |
0 |
0 |
|
|
255 |
T_USR_STAT |
|
CMS_TAB_COR_CAG_USR_STAT |
|
TTYP |
0 |
0 |
|
|
256 |
T_RULES |
|
CMS_TAB_COR_CAG_RULES |
|
TTYP |
0 |
0 |
|
|
257 |
T_CAG_RBL |
|
CMS_TAB_COR_CAG_RBL |
|
TTYP |
0 |
0 |
|
|
258 |
T_CAG_REL_TO |
|
CMS_TAB_COR_CAG_REL_TO |
|
TTYP |
0 |
0 |
|
|
259 |
T_CAG_REL_FR |
|
CMS_TAB_COR_CAG_REL_FROM |
|
TTYP |
0 |
0 |
|
|
260 |
T_CAG_DOC |
|
CMS_TAB_COR_CAG_DOC |
|
TTYP |
0 |
0 |
|
|
261 |
T_PRIO_CHG |
|
CMS_TAB_COR_PRIOR_CHG |
|
TTYP |
0 |
0 |
|
|
262 |
T_ASMT_VAL |
|
CMS_TAB_COR_CAG_ASMT_VAL |
|
TTYP |
0 |
0 |
|
|
263 |
T_LEND_VAL |
|
CMS_TAB_COR_LEND_VAL_GRT |
|
TTYP |
0 |
0 |
|
|
264 |
T_LEND_LMT |
|
CMS_TAB_COR_LEND_LMT_GRT |
|
TTYP |
0 |
0 |
|
|
265 |
T_LTOV_PR |
|
CMS_TAB_COR_LTOV_RATIO_PR |
|
TTYP |
0 |
0 |
|
|
266 |
T_DIST_COL |
|
CMS_TAB_COR_DIST_COL_VAL |
|
TTYP |
0 |
0 |
|
|
267 |
T_FREE_COL |
|
CMS_TAB_COR_FREE_COL_VAL |
|
TTYP |
0 |
0 |
|
|
268 |
T_DIST_CV_TO |
|
CMS_TAB_COR_CAG_DIST_CV_TO_REL |
|
TTYP |
0 |
0 |
|
|
269 |
T_DIST_CV_FR |
|
CMS_TAB_COR_CAG_DIST_CV_FR_REL |
|
TTYP |
0 |
0 |
|
|
270 |
T_CAG_NOTES |
|
CMS_TAB_COR_CAG_NOTES |
|
TTYP |
0 |
0 |
|
|
271 |
T_CAG_SA |
|
CMS_TAB_COR_CAG_SA |
|
TTYP |
0 |
0 |
|
|
272 |
T_CAG_BP_TRM |
|
CMS_TAB_COR_CAG_BP_TRM |
|
TTYP |
0 |
0 |
|
|
273 |
T_CAG_EXP |
|
CMS_TAB_COR_CAG_EXP |
|
TTYP |
0 |
0 |
|
|