I_ShipObjectData

Ship Object Details | view: ISHIPOBJDATA | ATTR | Extraction: Full or Incremental | Component: Collateral Management System
Tables used: CMS_SHP
Column Name Description
ShipObjectUUID Globally Unique Identifier
Column Name Description
💲 Currency for purchase price (ShipObjectPurchaseCurrency):
ShipObjectPurchaseAmount Purchase Price
💲 Currency for construction price (ShipObjectConstructionCurrency):
ShipObjectConstructionAmount Cost incurred in Building the Ship
💲 Currency for insurance premium (ShipObjectInsurancePremiumCrcy):
ShipObjectInsurancePremiumAmt Insurance Premium
💲 Insurance Policy Amount Currency (ShipObjectInsurancePolicyCrcy):
ShipObjectInsurancePolicyAmt Insurance Policy Amount
💲 Required Insurance Cover Currency (ShipObjRqdInsuranceCoverCrcy):
ShipObjRqdInsuranceCoverAmt Required Amount of Insurance Cover
Column Name Description
📏 Unit of measure for the ship length (ShipObjectLengthUnitMeasure):
ShipObjectLength Ship length
📏 Unit of measure for the breadth (ShipObjectBreadthUnitMeasure):
ShipObjectBreadthQty Ship Beam
📏 Unit of measure for the depth (ShipObjectDepthUnitMeasure):
ShipObjectDepthQty Ship Draught
📏 Unit of Measure for the Ship Volume (ShipObjectVolumeUnitMeasure):
ShipObjectVolume Volume of Ship
📏 Unit of measure for the dead weight tonnage (ShipObjDeadWgtCarryCapUnitMsr):
ShipObjDeadWgtCarryingCapacity Weight of the Ship excluding the weight of Cargo
📏 Unit of measure for the gross tonnage (ShipObjectGrossTonnageUnitMsr):
ShipObjectGrossTonnageQuantity Volume of the Interiors of a Ship
📏 Unit of Measure for the Track Length in a Ship (ShipObjectTrackLengthUnitMsr):
ShipObjectTrackLength Length of the Track in a Ship
📏 Unit of measure for the horse power (ShipObjectEnginePowerUnitMsr):
ShipObjectEnginePowerQty Engine power
📏 Unit of measure for the speed (ShipObjectSpeedUnitMeasure):
ShipObjectSpeedQty Speed
📏 Unit of measure for the fuel consumption (ShipObjFuelConsumptionUnitMsr):
ShipObjectFuelConsumptionQty Fuel Consumption
Column Name Description
ShipObjectRegistrationDate Registration date
ShipObjIntlSftyMgmtValdFrmDte Date from which ISM Certificate Stands Valid
ShipObjIntlSftyMgmtValdToDte Date until which ISM Certificate Stands Valid
ShipObjectRatingDate Rating date
ShipObjectPurchaseDate Purchase date
ShipObjectDeliveryDate Date of Delivery of the ship
ShipObjectInsuranceExpiryDate Date of Expiry of the Insurance Policy
Column Name Description
ShipObjectClass Specifies whether the Ship is Sea Ship or Inland Ship Show values
ShipObjOversizeCtnIsAllowed Indicator for Oversize Container Transportable in the Ship Show values
Column Name Description Domain name
ShipObjectName Ship name CMS_SHP_NAME
ShipObjectCharteredName Charter Name used to Lease the Ship CMS_SHP_NAME
ShipObjectIntlMaritimeOrgNmbr IMO Number CMS_SHP_NUMBER
ShipObjectRegistrationNumber Registration Number CMS_SHP_NUMBER
ShipObjectRegistrationPlace Registration place CMS_SHP_NAME
ShipObjectExternalRefNumber External reference ID for the Ship CMS_SHP_NAME
ShipObjectFleetName Fleet Name CMS_SHP_NAME
ShipObjectID Ship ID CMS_SHP_ID
ShipObjectRatingClass Rating Class CMS_SHP_RATING_CLS
ShipObjectDescription Description CMS_SHP_NAME
ShipObjectBuiltShipyard Shipyard where the Ship was Built CMS_SHP_NAME
ShipObjNrOfRefrigeratedCtns Number of refrigerated containers CMS_SHP_INT
ShipObjNrOfCapacityContainers Container Capacity CMS_SHP_INT
ShipObjectNumberOfCabinRooms Number of Cabin Rooms CMS_SHP_INT
ShipObjectNumberOfParking Number of Parking Units in the Vehicle Parking Bay CMS_SHP_INT
ShipObjectNumberOfPassenger Passenger Capacity of the Ship CMS_SHP_INT
ShipObjectMachineMfrName Manufacturer of the Machine CMS_SHP_NAME
ShipObjectMachineModelName Name of the Engine Model CMS_SHP_NAME
ShipObjectNumberOfMainMachines Number of Main Machines Fitted in the Ship CMS_SHP_INT
ShipObjectCraneEquipment Crane Equipment fitted in the Ship CMS_SHP_NAME
ShipObjAnnualDepreciationPct Annual depreciation in percentage CMS_SHP_PCT
ShipObjectInsuranceContactFirm Contact Firm CMS_SHP_NAME
ShipObjInsuranceContactPerson Contact Person CMS_SHP_NAME
CollateralAdminOrgUnit Administration Organizational Unit TEXT12
ShipObjectEnteredDateTime Creation Timestamp TZNTSTMPS
ShipObjectLastChangedDateTime Change Timestamp TZNTSTMPS
Master Data Relations Join Conditions
Classification Company
  • Classification Company
  • Client
  • ?
  • I_SHIPOBJECTDATA.SHIPOBJCOMPANYCLASSIFICATION == TCMS_ATT_ID_TY.INDICATOR_TYPE
  • I_SHIPOBJECTDATA.MANDT == TCMS_ATT_ID_TY.MANDT
  • I_SHIPOBJECTDATA.[column in domain "CMS_DTE_ATT_IND_CAT"] == TCMS_ATT_ID_TY.INDICATOR_ID
Foreign key for Unit of measure
  • Client
  • Unit of measure for the dead weight tonnage
  • I_SHIPOBJECTDATA.MANDT == T006.MANDT
  • I_SHIPOBJECTDATA.SHIPOBJDEADWGTCARRYCAPUNITMSR == T006.MSEHI
Foreign key for Unit of measure
  • Client
  • Unit of measure for the breadth
  • I_SHIPOBJECTDATA.MANDT == T006.MANDT
  • I_SHIPOBJECTDATA.SHIPOBJECTBREADTHUNITMEASURE == T006.MSEHI
Country/Region where the Ship was Built
  • Country/Region where the Ship was Built
  • Client
  • I_SHIPOBJECTDATA.SHIPOBJECTCONSTRUCTIONCOUNTRY == T005.LAND1
  • I_SHIPOBJECTDATA.MANDT == T005.MANDT
Foreign key for Currency
  • Currency for construction price
  • Client
  • I_SHIPOBJECTDATA.SHIPOBJECTCONSTRUCTIONCURRENCY == TCURC.WAERS
  • I_SHIPOBJECTDATA.MANDT == TCURC.MANDT
Foreign key for Unit of measure
  • Unit of measure for the depth
  • Client
  • I_SHIPOBJECTDATA.SHIPOBJECTDEPTHUNITMEASURE == T006.MSEHI
  • I_SHIPOBJECTDATA.MANDT == T006.MANDT
Foreign key for Unit of measure
  • Client
  • Unit of measure for the horse power
  • I_SHIPOBJECTDATA.MANDT == T006.MANDT
  • I_SHIPOBJECTDATA.SHIPOBJECTENGINEPOWERUNITMSR == T006.MSEHI
Unit of measure for the gross tonnage
  • Unit of measure for the gross tonnage
  • Client
  • I_SHIPOBJECTDATA.SHIPOBJECTGROSSTONNAGEUNITMSR == T006.MSEHI
  • I_SHIPOBJECTDATA.MANDT == T006.MANDT
Hull Type
  • Client
  • ?
  • Hull Type
Foreign key for Currency
  • Currency for insurance premium
  • Client
  • I_SHIPOBJECTDATA.SHIPOBJECTINSURANCEPREMIUMCRCY == TCURC.WAERS
  • I_SHIPOBJECTDATA.MANDT == TCURC.MANDT
Insurance Type
  • Client
  • ?
  • Insurance Type
  • I_SHIPOBJECTDATA.MANDT == TCMS_ATT_ID_TY.MANDT
  • I_SHIPOBJECTDATA.[column in domain "CMS_DTE_ATT_IND_CAT"] == TCMS_ATT_ID_TY.INDICATOR_ID
  • I_SHIPOBJECTDATA.SHIPOBJECTINSURANCETYPE == TCMS_ATT_ID_TY.INDICATOR_TYPE
Insurer
  • Client
  • ?
  • Insurer
Foreign key for Unit of measure
  • Client
  • Unit of measure for the ship length
  • I_SHIPOBJECTDATA.MANDT == T006.MANDT
  • I_SHIPOBJECTDATA.SHIPOBJECTLENGTHUNITMEASURE == T006.MSEHI
Foreign key for Currency
  • Client
  • Currency for purchase price
  • I_SHIPOBJECTDATA.MANDT == TCURC.MANDT
  • I_SHIPOBJECTDATA.SHIPOBJECTPURCHASECURRENCY == TCURC.WAERS
Registration Country/Region
  • Client
  • Registration Country/Region
  • I_SHIPOBJECTDATA.MANDT == T005.MANDT
  • I_SHIPOBJECTDATA.SHIPOBJECTREGISTRATIONCOUNTRY == T005.LAND1
Foreign key for Unit of measure
  • Client
  • Unit of Measure for the Track Length in a Ship
  • I_SHIPOBJECTDATA.MANDT == T006.MANDT
  • I_SHIPOBJECTDATA.SHIPOBJECTTRACKLENGTHUNITMSR == T006.MSEHI
Foreign key for Ship Type I_SHIPOBJECTDATA.MANDT == TCMS_SHP_TYP.MANDT
Unit of Measure for the Ship Volume
  • Client
  • Unit of Measure for the Ship Volume
  • I_SHIPOBJECTDATA.MANDT == T006.MANDT
  • I_SHIPOBJECTDATA.SHIPOBJECTVOLUMEUNITMEASURE == T006.MSEHI