1 |
.INCLUDE |
|
|
|
|
0 |
0 |
Primary key for Ship |
|
2 |
SHP_GUID |
|
OS_GUID |
SYSUUID |
RAW |
16 |
0 |
Globally Unique Identifier |
|
3 |
.INCLUDE |
|
|
|
|
0 |
0 |
Asset Guid - Link key to Ship |
|
4 |
AST_GUID |
|
CMS_DTE_AST_GUID |
SYSUUID |
RAW |
16 |
0 |
GUID for Table CMS_AST |
|
5 |
.INCLUDE |
|
|
|
|
0 |
0 |
Identification of Ship |
|
6 |
SHP_TYPE |
|
CMS_DTE_SHP_TYP |
CMS_SHP_TYP |
CHAR |
6 |
0 |
Ship Type |
TCMS_SHP_TYP |
7 |
NAME |
|
CMS_DTE_SHP_NAME |
CMS_SHP_NAME |
CHAR |
40 |
0 |
Ship name |
|
8 |
CHARTER_NAME |
|
CMS_DTE_SHP_CH_NAME |
CMS_SHP_NAME |
CHAR |
40 |
0 |
Charter Name used to Lease the Ship |
|
9 |
CALL_SIGN |
|
CMS_DTE_SHP_CALL_SIGN |
CMS_SHP_NUMBER |
CHAR |
20 |
0 |
IMO Number |
|
10 |
SHP_CLASS |
|
CMS_DTE_SHP_CLASS |
CMS_SHP_CLASS |
CHAR |
2 |
0 |
Specifies whether the Ship is Sea Ship or Inland Ship |
|
11 |
REG_NUMBER |
|
CMS_DTE_SHP_REG_NUM |
CMS_SHP_NUMBER |
CHAR |
20 |
0 |
Registration Number |
|
12 |
REG_DATE |
|
CMS_DTE_SHP_REG_DATE |
CMS_SHP_DATE |
DATS |
8 |
0 |
Registration date |
|
13 |
REG_PLACE |
|
CMS_DTE_SHP_REG_PLACE |
CMS_SHP_NAME |
CHAR |
40 |
0 |
Registration place |
|
14 |
REG_COUNTRY |
|
CMS_DTE_SHP_REG_COUNTRY |
LAND1 |
CHAR |
3 |
0 |
Registration country |
* |
15 |
EXTN_REF_ID |
|
CMS_DTE_SHP_OBJ_REFID |
CMS_SHP_NAME |
CHAR |
40 |
0 |
External reference ID for the Ship |
|
16 |
FLEET_NAME |
|
CMS_DTE_SHP_FLEET_NAME |
CMS_SHP_NAME |
CHAR |
40 |
0 |
Fleet Name |
|
17 |
SHIP_ID |
|
CMS_DTE_SHP_ID |
CMS_SHP_ID |
CHAR |
40 |
0 |
Ship ID |
|
18 |
.INCLUDE |
|
|
|
|
0 |
0 |
General Description of Ship |
|
19 |
ISM_VALID_FROM |
|
CMS_DTE_SHP_ISM_FROM |
CMS_SHP_DATE |
DATS |
8 |
0 |
Date from which ISM Certificate Stands Valid |
|
20 |
ISM_VALID_TO |
|
CMS_DTE_SHP_ISM_TO |
CMS_SHP_DATE |
DATS |
8 |
0 |
Date until which ISM Certificate Stands Valid |
|
21 |
RATING_DATE |
|
CMS_DTE_SHP_RATE_DATE |
CMS_SHP_DATE |
DATS |
8 |
0 |
Rating date |
|
22 |
RATING_CLS |
|
CMS_DTE_SHP_RATING_CLS |
CMS_SHP_RATING_CLS |
CHAR |
20 |
0 |
Rating Class |
|
23 |
CLASSIFICATION |
|
CMS_DTE_SHP_CLASSIFICATION |
CMS_SHP_NAME |
CHAR |
40 |
0 |
Classification of a Ship |
|
24 |
CLASSIFI_COMPANY |
|
CMS_DTE_SHP_ATT_ID_TY_SHP002 |
CMS_ATT_ID_TYP |
CHAR |
6 |
0 |
Classification Company |
TCMS_ATT_ID_TY |
25 |
COMMENTS |
|
CMS_DTE_SHP_COMMENTS |
CMS_SHP_NAME |
CHAR |
40 |
0 |
Description |
|
26 |
.INCLUDE |
|
|
|
|
0 |
0 |
Purchase Details of Ship |
|
27 |
PURCH_PRICE |
|
CMS_DTE_SHP_PUR_PRI |
CMS_SHP_AMOUNT |
CURR |
17 |
2 |
Purchase Price |
|
28 |
PURCH_CURR |
|
CMS_DTE_SHP_PUR_CURR |
WAERS |
CUKY |
5 |
0 |
Currency for purchase price |
* |
29 |
PURCH_PRICE_DATE |
|
CMS_DTE_SHP_PUR_DATE |
CMS_SHP_DATE |
DATS |
8 |
0 |
Purchase date |
|
30 |
.INCLUDE |
|
|
|
|
0 |
0 |
Construction Details of Ship |
|
31 |
CONS_COUNTRY |
|
CMS_DTE_SHP_CONS_COUNTRY |
LAND1 |
CHAR |
3 |
0 |
Country where the Ship was Built |
* |
32 |
CONS_PRICE |
|
CMS_DTE_SHP_CONS_PRICE |
CMS_SHP_AMOUNT |
CURR |
17 |
2 |
Cost incurred in Building the Ship |
|
33 |
CONS_CURR |
|
CMS_DTE_SHP_CONS_CURR |
WAERS |
CUKY |
5 |
0 |
Currency for construction price |
* |
34 |
DELIVERY_DATE |
|
CMS_DTE_SHP_DELIVERY_DATE |
CMS_SHP_DATE |
DATS |
8 |
0 |
Date of Delivery of the ship |
|
35 |
DOCK |
|
CMS_DTE_SHP_DOCK |
CMS_SHP_NAME |
CHAR |
40 |
0 |
Shipyard where the Ship was Built |
|
36 |
.INCLUDE |
|
|
|
|
0 |
0 |
Size Details of Ship |
|
37 |
LENGTH |
|
CMS_DTE_SHP_LENGTH |
CMS_SHP_SIZE |
QUAN |
13 |
3 |
Ship length |
|
38 |
LENGTH_UOM |
|
CMS_DTE_SHP_LENGTH_UOM |
MEINS |
UNIT |
3 |
0 |
Unit of measure for the ship length |
* |
39 |
BREADTH |
|
CMS_DTE_SHP_BREADTH |
CMS_SHP_SIZE |
QUAN |
13 |
3 |
Ship Beam |
|
40 |
BREADTH_UOM |
|
CMS_DTE_SHP_BREADTH_UOM |
MEINS |
UNIT |
3 |
0 |
Unit of measure for the breadth |
* |
41 |
DEPTH |
|
CMS_DTE_SHP_DEPTH |
CMS_SHP_SIZE |
QUAN |
13 |
3 |
Ship Draught |
|
42 |
DEPTH_UOM |
|
CMS_DTE_SHP_DEPTH_UOM |
MEINS |
UNIT |
3 |
0 |
Unit of measure for the depth |
* |
43 |
VOLUME |
|
CMS_DTE_SHP_VOLUME |
CMS_SHP_SIZE |
QUAN |
13 |
3 |
Volume of Ship |
|
44 |
VOLUME_UOM |
|
CMS_DTE_SHP_VOLUME_UOM |
MEINS |
UNIT |
3 |
0 |
Unit of Measure for the Ship Volume |
* |
45 |
DWT |
|
CMS_DTE_SHP_DWT |
CMS_SHP_SIZE |
QUAN |
13 |
3 |
Weight of the Ship excluding the weight of Cargo |
|
46 |
DWT_UOM |
|
CMS_DTE_SHP_DWT_UOM |
MEINS |
UNIT |
3 |
0 |
Unit of measure for the dead weight tonnage |
* |
47 |
GROSST |
|
CMS_DTE_SHP_GROSST |
CMS_SHP_SIZE |
QUAN |
13 |
3 |
Volume of the Interiors of a Ship |
|
48 |
GROSST_UOM |
|
CMS_DTE_SHP_GROSST_UOM |
MEINS |
UNIT |
3 |
0 |
Unit of measure for the gross tonnage |
* |
49 |
TRACK_LENGTH |
|
CMS_DTE_SHP_TRK_LEN |
CMS_SHP_SIZE |
QUAN |
13 |
3 |
Length of the Track in a Ship |
|
50 |
TRACK_LENGTH_UOM |
|
CMS_DTE_SHP_TRK_LEN_UOM |
MEINS |
UNIT |
3 |
0 |
Unit of Measure for the Track Length in a Ship |
* |
51 |
NUM_REF_CONT |
|
CMS_DTE_SHP_NO_REF_CONT |
CMS_SHP_INT |
DEC |
10 |
0 |
Number of refrigerated containers |
|
52 |
NUM_CONT_CAP |
|
CMS_DTE_SHP_CONT_CAP |
CMS_SHP_INT |
DEC |
10 |
0 |
Container Capacity |
|
53 |
NUM_CABIN_ROOM |
|
CMS_DTE_SHP_CAB_ROOM |
CMS_SHP_INT |
DEC |
10 |
0 |
Number of Cabin Rooms |
|
54 |
NUM_VEH_PARK |
|
CMS_DTE_SHP_NO_PARK |
CMS_SHP_INT |
DEC |
10 |
0 |
Number of Parking Units in the Vehicle Parking Bay |
|
55 |
NUM_OF_PAX |
|
CMS_DTE_SHP_NO_PAX |
CMS_SHP_INT |
DEC |
10 |
0 |
Passenger Capacity of the Ship |
|
56 |
ISOVR_CONTAINER |
|
CMS_DTE_SHP_OVERSIZE_CONTAINER |
CMS_SHP_FLG |
CHAR |
1 |
0 |
Indicator for Oversize Container Transportable in the Ship |
|
57 |
.INCLUDE |
|
|
|
|
0 |
0 |
Technical Details of Ship |
|
58 |
HULL_TYP |
|
CMS_DTE_SHP_ATT_ID_TY_SHP001 |
CMS_ATT_ID_TYP |
CHAR |
6 |
0 |
Hull Type |
TCMS_ATT_ID_TY |
59 |
MANUFR_MACHINE |
|
CMS_DTE_SHP_MANUFR_MACHINE |
CMS_SHP_NAME |
CHAR |
40 |
0 |
Manufacturer of the Machine |
|
60 |
MACHINE_TYP |
|
CMS_DTE_SHP_MAC_TYP |
CMS_SHP_NAME |
CHAR |
40 |
0 |
Name of the Engine Model |
|
61 |
NUM_MACHINES |
|
CMS_DTE_SHP_NO_MACHINES |
CMS_SHP_INT |
DEC |
10 |
0 |
Number of Main Machines Fitted in the Ship |
|
62 |
CRANE_EQUIP |
|
CMS_DTE_SHP_CRANE_EQUIP |
CMS_SHP_NAME |
CHAR |
40 |
0 |
Crane Equipment fitted in the Ship |
|
63 |
POWER |
|
CMS_DTE_SHP_POWER |
CMS_SHP_SIZE |
QUAN |
13 |
3 |
Engine power |
|
64 |
POWER_UOM |
|
CMS_DTE_SHP_POWER_UOM |
MEINS |
UNIT |
3 |
0 |
Unit of measure for the horse power |
* |
65 |
SPEED |
|
CMS_DTE_SHP_SPEED |
CMS_SHP_SIZE |
QUAN |
13 |
3 |
Speed |
|
66 |
SPEED_UOM |
|
CMS_DTE_SHP_SPEED_UOM |
MEINS |
UNIT |
3 |
0 |
Unit of measure for the speed |
* |
67 |
FUEL_CONSUM |
|
CMS_DTE_SHP_FUEL_CONSUM |
CMS_SHP_SIZE |
QUAN |
13 |
3 |
Fuel Consumption |
|
68 |
FUEL_CONSUM_UOM |
|
CMS_DTE_SHP_FUEL_CONSUM_UOM |
MEINS |
UNIT |
3 |
0 |
Unit of measure for the fuel consumption |
* |
69 |
.INCLUDE |
|
|
|
|
0 |
0 |
Insurance Details of Ship |
|
70 |
INSUR_PREMIUM |
|
CMS_DTE_SHP_INSUR_PREMIUM |
CMS_SHP_AMOUNT |
CURR |
17 |
2 |
Insurance Premium |
|
71 |
INSUR_PRE_CURR |
|
CMS_DTE_SHP_INSUR_PREMIUM_CURR |
WAERS |
CUKY |
5 |
0 |
Currency for insurance premium |
* |
72 |
INSUR_TYPE |
|
CMS_DTE_SHP_ATT_ID_TY_SHP003 |
CMS_ATT_ID_TYP |
CHAR |
6 |
0 |
Insurance Type |
TCMS_ATT_ID_TY |
73 |
ANNUAL_DEP |
|
CMS_DTE_SHP_ANNUAL_DEP |
CMS_SHP_PCT |
DEC |
10 |
6 |
Annual depreciation in percentage |
|
74 |
INSUR_VALID_TILL |
|
CMS_DTE_SHP_INSUR_VALID_TILL |
CMS_SHP_DATE |
DATS |
8 |
0 |
Date of Expiry of the Insurance Policy |
|
75 |
POLICY_AMOUNT |
|
CMS_DTE_SHP_POLICY_AMOUNT |
CMS_SHP_AMOUNT |
CURR |
17 |
2 |
Insurance Policy Amount |
|
76 |
POLICY_CURR |
|
CMS_DTE_SHP_POLICY_CURR |
WAERS |
CUKY |
5 |
0 |
Insurance Policy Amount Currency |
* |
77 |
REQD_INSUR_COVER |
|
CMS_DTE_SHP_REQD_INSUR_COVER |
CMS_SHP_AMOUNT |
CURR |
17 |
2 |
Required Amount of Insurance Cover |
|
78 |
REQD_INSUR_CURR |
|
CMS_DTE_SHP_REQD_INSUR_CURR |
WAERS |
CUKY |
5 |
0 |
Required Insurance Cover Currency |
* |
79 |
INSURER |
|
CMS_DTE_SHP_ATT_ID_TY_SHP004 |
CMS_ATT_ID_TYP |
CHAR |
6 |
0 |
Insurer |
TCMS_ATT_ID_TY |
80 |
CONTACT_FIRM |
|
CMS_DTE_SHP_CONTACT_FIRM |
CMS_SHP_NAME |
CHAR |
40 |
0 |
Contact Firm |
|
81 |
CONTACT_PERSON |
|
CMS_DTE_SHP_CONTACT_PERSON |
CMS_SHP_NAME |
CHAR |
40 |
0 |
Contact Person |
|
82 |
.INCLUDE |
|
|
|
|
0 |
0 |
MAPI : GET : Asset details |
|
83 |
CATEGORY |
|
CMS_DTE_OMS_OBJ_CAT |
CMS_OBJ_CAT |
CHAR |
6 |
0 |
Object Category |
* |
84 |
CATEGORY_NAME |
|
CMS_DTE_OMS_CAT_NAME |
CMS_OMS_CAT_NAME |
CHAR |
40 |
0 |
Object Category Name |
|
85 |
TYPE |
|
CMS_DTE_MOV_TYP |
CMS_MOV_TYP |
CHAR |
6 |
0 |
Movable types |
* |
86 |
TYPE_NAME |
|
CMS_DTE_MOV_TYP_NAME |
CMS_MOV_NAME |
CHAR |
40 |
0 |
Name in a specified language |
|
87 |
IDENTIFICATION |
|
CMS_DTE_MOV_ID |
CMS_MOV_ID |
CHAR |
40 |
0 |
Identification Number |
|
88 |
MOV_DESCRIPTION |
|
CMS_DTE_MOV_DESC |
CMS_MOV_DESC |
CHAR |
30 |
0 |
Description of the object |
|
89 |
.INCLUDE |
|
|
|
|
0 |
0 |
Structure with Asset Details for Table CMS_AST |
|
90 |
.INCLUDE |
|
|
|
|
0 |
0 |
Basic Asset data |
|
91 |
DESCRIPTION |
|
CMS_DTE_AST_DESC |
CMS_DSC |
CHAR |
30 |
0 |
Description |
|
92 |
OBJECT_REF_ID |
|
CMS_DTE_OBJ_REFID |
CMS_OBJ_REFID |
CHAR |
40 |
0 |
Reference ID for the object |
|
93 |
OBJECT_TYP |
|
CMS_DTE_OBJ_TYP |
CMS_OBJ_TYP |
CHAR |
32 |
0 |
Not used |
|
94 |
COUNTRY_KEY |
|
CMS_DTE_AST_COUNTRY_KEY |
LAND1 |
CHAR |
3 |
0 |
Identification Key for Country |
* |
95 |
RISK_CODE |
|
CMS_DTE_RISK_CODE |
CMS_RISK_CODE |
CHAR |
6 |
0 |
Risk Code |
* |
96 |
SFTY_IND |
|
CMS_DTE_IND_SFTY_DISC |
CMS_IND_SFTY |
CHAR |
2 |
0 |
Indicates if the Asset has a Default Safety Discount |
|
97 |
SFTY_DSCNT |
|
CMS_DTE_SAFETY_DSCNT |
CMS_SFTY_PCT |
DEC |
10 |
6 |
Percentage of Safety Discount |
|
98 |
SFTY_AMOUNT |
|
CMS_DTE_SAFETY_AMT |
CMS_AMOUNT |
CURR |
17 |
2 |
Amount of Safety Discount |
|
99 |
SFTY_AMT_CURR |
|
CMS_DTE_SAFETY_AMT_CURR |
WAERS |
CUKY |
5 |
0 |
Currency of the Safety Discount Amount |
TCURC |
100 |
OBJSYSID |
|
CMS_DTE_OBJ_SYSID |
CMS_SYS |
CHAR |
6 |
0 |
Object System Reference ID |
|
101 |
.INCLUDE |
|
|
|
|
0 |
0 |
Valuation data |
|
102 |
VALUATION_TYP |
|
CMS_DTE_IND_VALN_TYP |
CMS_VALN_TYP |
CHAR |
2 |
0 |
Type of Valuation Check performed on Collateral Object |
|
103 |
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 |
|
104 |
PERIOD_VALN_FREQ |
|
CMS_DTE_AST_VALN_FREQ_PERIOD |
CMS_AST_VALN_FREQ_PERIOD |
NUMC |
4 |
0 |
Revaluation Period for an Asset |
|
105 |
PAST_VALUED_DATE |
|
CMS_DTE_VALN_DATE |
CMS_DATE |
DATS |
8 |
0 |
Last Date on which the Asset was Valued |
|
106 |
START_DATE |
|
CMS_DTE_START_DATE |
CMS_DATE |
DATS |
8 |
0 |
Date on which the First Valuation is Performed on the Asset |
|
107 |
END_DATE |
|
CMS_DTE_END_DATE |
CMS_DATE |
DATS |
8 |
0 |
Date on which the Last Valuation is Performed on the Asset |
|
108 |
.INCLUDE |
|
|
|
|
0 |
0 |
Lending rate data |
|
109 |
LENDING_RATE_IND |
|
CMS_DTE_IND_LND_RTE |
CMS_IND_LRTE |
CHAR |
2 |
0 |
Indicator to specify if Asset has a Default Lending Rate |
|
110 |
.INCLUDE |
|
|
|
|
0 |
0 |
Lending rates structure |
|
111 |
LENDING_RATE1 |
|
CMS_DTE_LRTE_PCT1 |
CMS_PCT |
DEC |
10 |
6 |
Lending Rate 1 |
|
112 |
LENDING_RATE2 |
|
CMS_DTE_LRTE_PCT2 |
CMS_PCT |
DEC |
10 |
6 |
Lending Rate 2 |
|
113 |
LENDING_RATE3 |
|
CMS_DTE_LRTE_PCT3 |
CMS_PCT |
DEC |
10 |
6 |
Lending Rate 3 |
|
114 |
LENDING_RATE4 |
|
CMS_DTE_LRTE_PCT4 |
CMS_PCT |
DEC |
10 |
6 |
Lending Rate 4 |
|
115 |
LENDING_RATE5 |
|
CMS_DTE_LRTE_PCT5 |
CMS_PCT |
DEC |
10 |
6 |
Lending Rate 5 |
|
116 |
.INCLUDE |
|
|
|
|
0 |
0 |
Liquidation rights data |
|
117 |
LIQD_TYP |
|
CMS_DTE_LIQD_TYP |
CMS_TYP |
CHAR |
6 |
0 |
Liquidation Type |
|
118 |
LIQD_REASON |
|
CMS_DTE_ATT_ID_TY_AST004 |
CMS_ATT_ID_TYP |
CHAR |
6 |
0 |
Liquidation Reason |
TCMS_ATT_ID_TY |
119 |
LIQD_DATE |
|
CMS_DTE_LIQD_DATE |
CMS_DATE |
DATS |
8 |
0 |
Date on which the Collateral was Liquidated |
|
120 |
LIQD_AMT |
|
CMS_DTE_LIQD_VALUE |
CMS_AMOUNT |
CURR |
17 |
2 |
Returns from the Liquidation of Collateral |
|
121 |
LIQD_CURR |
|
CMS_DTE_LIQD_CURR |
WAERS |
CUKY |
5 |
0 |
Currency of Liquidation Value |
TCURC |
122 |
EXP_PRCD_AMNT |
|
CMS_DTE_LIQ_EXP_PRCD_AMOUNT |
CMS_AMOUNT |
CURR |
17 |
2 |
Expected Proceed Amount |
|
123 |
EXP_PRCD_CURR |
|
CMS_DTE_LIQ_EXP_PRCD_CURR |
WAERS |
CUKY |
5 |
0 |
Currency: Expected Proceed |
TCURC |
124 |
EXP_ACC_DATE |
|
CMS_DTE_LIQ_EXP_ACCRUAL_DATE |
CMS_DATE |
DATS |
8 |
0 |
Expected accrual date |
|
125 |
.INCLUDE |
|
|
|
|
0 |
0 |
Account for liquidation proceeds |
|
126 |
ACC_NUMBER_LIQ |
|
CMS_DTE_LIQ_ACC_NUMBER |
BANKN35 |
CHAR |
35 |
0 |
Account number for liquidation proceeds |
|
127 |
BANK_CNTRY_LIQ |
|
CMS_DTE_LIQ_BNK_CTRY_KY |
LAND1 |
CHAR |
3 |
0 |
Bank country key |
T005 |
128 |
BANK_KEY_LIQ |
|
CMS_DTE_LIQ_BNK_KEY |
BANKK |
CHAR |
15 |
0 |
Bank Key |
|
129 |
BANK_CTRLKEY_LIQ |
|
BKONT |
BKONT |
CHAR |
2 |
0 |
Bank Control Key |
|
130 |
.INCLUDE |
|
|
|
|
0 |
0 |
Verfication Data |
|
131 |
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 |
|
132 |
PERIOD_VERF_FREQ |
|
CMS_DTE_AST_VERF_FREQ_PERIOD |
CMS_AST_VERF_FREQ_PERIOD |
NUMC |
4 |
0 |
Statement Period for an Asset |
|
133 |
LAST_VERF_DATE |
|
CMS_DTE_AST_VERF_DATE |
CMS_DATE |
DATS |
8 |
0 |
Last Verification Date |
|
134 |
.INCLUDE |
|
|
|
|
0 |
0 |
Structure for Asset values |
|
135 |
NOM_VALUE |
|
CMS_DTE_AST_NOMINAL_VALUE |
CMS_AMOUNT |
CURR |
17 |
2 |
Nominal Value of the Asset |
|
136 |
NOM_VALUE_CURR |
|
CMS_DTE_AST_NOMINAL_VALUE_CURR |
WAERS |
CUKY |
5 |
0 |
Currency of Nominal value |
TCURC |
137 |
AST_VALUE |
|
CMS_DTE_AST_VALUE |
CMS_AMOUNT |
CURR |
17 |
2 |
Final Asset Value |
|
138 |
AST_VALUE_CURR |
|
CMS_DTE_AST_VALUE_CURR |
WAERS |
CUKY |
5 |
0 |
Currency of the Final Asset Value |
TCURC |
139 |
QUANTITY |
|
CMS_DTE_QTY |
CMS_QTY |
QUAN |
13 |
3 |
Quantity |
|
140 |
UNIT_OF_MEASURE |
|
CMS_DTE_UNIT |
MEINS |
UNIT |
3 |
0 |
Unit of Measure of Quantity |
T006 |
141 |
REC_AT |
|
CMS_DTE_REC_AT |
TZNTSTMPS |
DEC |
15 |
0 |
Asset Value Recording Timestamp |
|
142 |
.INCLUDE |
|
|
|
|
0 |
0 |
Purchase price data |
|
143 |
PUR_PRICE |
|
CMS_DTE_AST_PURCHASE_PRICE |
CMS_AMOUNT |
CURR |
17 |
2 |
Purchase Price of the Asset |
|
144 |
PUR_PRICE_CURR |
|
CMS_DTE_AST_PUR_PRICE_CURR |
WAERS |
CUKY |
5 |
0 |
Currency of Purchase Price |
TCURC |
145 |
PUR_DATE |
|
CMS_DTE_AST_PUR_PRICE_DATE |
CMS_DATE |
DATS |
8 |
0 |
Date of Purchase |
|
146 |
.INCLUDE |
|
|
|
|
0 |
0 |
Administrative organization unit |
|
147 |
ADMIN_ORG_UNIT |
|
CMS_DTE_ADMINORG |
TEXT12 |
CHAR |
12 |
0 |
Administration Organizational Unit |
|
148 |
.INCLUDE |
|
|
|
|
0 |
0 |
Bank area |
|
149 |
BANKAREA |
|
CMS_DTE_BANKAREA |
CMS_BANKAREA |
CHAR |
4 |
0 |
Bank Area in Collateral Management |
* |
150 |
.INCLUDE |
|
|
|
|
0 |
0 |
Organization unit structure |
|
151 |
ORG_UNIT1 |
|
CMS_DTE_ORG_UNIT1 |
CMS_ORG_UNIT |
CHAR |
10 |
0 |
Organizational Unit 1 |
* |
152 |
ORG_UNIT2 |
|
CMS_DTE_ORG_UNIT2 |
CMS_ORG_UNIT |
CHAR |
10 |
0 |
Organizational Unit 2 |
* |
153 |
ORG_UNIT3 |
|
CMS_DTE_ORG_UNIT3 |
CMS_ORG_UNIT |
CHAR |
10 |
0 |
Organizational Unit 3 |
* |
154 |
ORG_UNIT4 |
|
CMS_DTE_ORG_UNIT4 |
CMS_ORG_UNIT |
CHAR |
10 |
0 |
Organizational Unit 4 |
* |
155 |
ORG_UNIT5 |
|
CMS_DTE_ORG_UNIT5 |
CMS_ORG_UNIT |
CHAR |
10 |
0 |
Organizational Unit 5 |
* |
156 |
.INCLUDE |
|
|
|
|
0 |
0 |
Stucture to record history of changes in all application tab |
|
157 |
CREATED_BY |
|
CMS_DTE_USER |
CMS_USER |
CHAR |
12 |
0 |
Login ID of the User who created the Record |
|
158 |
CREATED_AT |
|
CMS_DTE_CREATED_AT |
TZNTSTMPS |
DEC |
15 |
0 |
Creation Timestamp |
|
159 |
CHANGED_BY |
|
CMS_DTE_LAST_CHNG_USER |
CMS_USER |
CHAR |
12 |
0 |
Last Changed By |
|
160 |
CHANGED_AT |
|
CMS_DTE_CHANGED_AT |
TZNTSTMPS |
DEC |
15 |
0 |
Change Timestamp |
|
161 |
SOURCEOFENTRY |
|
CMS_DTE_SOURCE_OF_ENTRY |
CMS_SOURCE |
CHAR |
32 |
0 |
Source of Entry |
|