Docstoc

Transport Reference Information Model

Document Sample
Transport Reference Information Model Powered By Docstoc
					Conceptual Data Model                      TRIM 5_7




       Transport Reference Information Model



                         Author: TJ
                         Version: 5.7
                        Date: 01-06-22




PowerDesigner                               Page 1
Conceptual Data Model                                TRIM 5_7



Table of Contents
The 'Table of contents' field needs to be updated!




PowerDesigner                                         Page 2
Conceptual Data Model                                              TRIM 5_7




Top Level Model

                  Goods Type    Product Order    Transport Chain
                   Submodel       Submodel          Submodel

                    Package      Goods Item         Service
                   Submodel      Submodel          Submodel

                   Currency    Transport Units     Contract
                   Submodel      Submodel          Submodel

                     Price     Transport Order    Consignment
                   Submodel       Submodel         Submodel


                     Cost        Transport         Location
                   Submodel      Submodel          Submodel

                    Actors     Transport Means     Load Unit
                   Submodel       Submodel         Submodel




PowerDesigner                                                       Page 3
Conceptual Data Model                                                                                                               TRIM 5_7




Actors Submodel 1

                    Country                  City                 Postal Area                Location                   Currency




                                          have          be location be location forbe location for
                                                                    for                                                 Delivery Terms
  Transport Chain Type                                                                                 be used by

                               be used for                be         in
                                                 located in located located in located in
                                                                             be

                                       be consignor in                                       use
                                                                                                          used by
                               be used for                        Company
                                          be consignee in                                     use                         Delivery
          Trip
                                         involved in
                         involving                                                      order org unit
                                     is shipagent for
                         have as shipagent
                                                                                         pay due for                      Stuffed Item
      Consignment                    be consignor for
                                                                                                      be paid due by
                             have as consignor
                                                                                             own           owned by
                                 be consignee for                                                                          Transport Unit
                             have as consignee                                              insure         insured by
                                                                                         ship manager for
                                      be agent for
                             have as agent                                                      ship managed by
                                                                                         crew manager for
      Transport Order          be ordered by
                                                                                                    crew managed by
                             be ordering party for
                                                                                             pay          be paid by        Visit
                                be contracted by
                                                                                         be agent for
                          be contracting party for                                                   be supported by
                               be notified to
                                       be notified for
                                                                                             pay         be paid by       Subdocking
                                      have contact person                              be audited in
                                                                                        buyer of
                                                                                                           concern
                        contact person in employ

                          employed by                                                                                      QA Audit
          Person                              be party in define       identified by                    provided to
                                                                                            offer
                                                          defined by     identify support
                                       involve

                                                                                                                        Service Order
      Contract Company                                  Company Number                                   offered by
                                                                                       supported by




                                                                                                                          Service
         Message Type                                  support
                                                                          Supported Message
                                 supported by


        Physical Message                                support
                                       supported by




Entity List
          Name                                                                              Label
City                                   A town.
Company                                A business organization which may act as: agent, consignee,
                                       forwarder etc.
Company Number                         A number used by a company to identify another company
Consignment                            An identifiable amount of goods transported from one consignor
                                       to one consignee
Contract Company                       A connection between a contract and a company
Country                                A geograhical area with a common government, according to


PowerDesigner                                                                                                                        Page 4
Conceptual Data Model                                                           TRIM 5_7


           Name                                      Label
                        UN/LOCODE.
Currency                Money that is in use in a country
Delivery                A delivery of a part of an order, or the complete order.
Delivery Terms          Terms of delivery. IMO approved.
Location                A geographic place in a country, according to UN/LOCODE
Message Type            Type of conceptual message which trigger a transition or is
                        activated by a transition
Person                  A male or female
Physical Message        A physical message type; ex: IFTMIN, COARRI
Postal Area             A geographical area
QA Audit                QA audit results
Service                 A basic transport operation type, independent of transport chain
Service Order           A service performed to a customer
Stuffed Item            A goods item in a transport unit
Subdocking              A stay of a transport means at a specific place in a port.
Supported Message       A physical message type which is supported by a company
Transport Chain Type    The complete transport chain from consignor to consignee.
Transport Order         A freight transport order
Transport Unit          A transport means or a load unit, or both of them
Trip                    The movement of a transport means from a terminal to the next
                        terminal.
Visit                   A visit of a transport unit in a terminal




PowerDesigner                                                                    Page 5
Conceptual Data Model                                                                         TRIM 5_7




Actors Submodel 2


                  Company                                                        Product Order
                                   supplier party for         supplied by

                                    warehouse for              stored at
                                      invocee for             invoiced to

                                    buyer party for            buyed by

                                                               taxed at
                                     Tax office for
                                                             delivered by
                                   delivery party for
                                                                                      Stock
                                         store                 stored at



                                                                                 Product Invoice
                                    main carrier for          carried by



                                                                                Transport Invoice
                                       release              released by




                                                                                 Customs Declaration
                                                        have as customs agent
                                 be customs agent for




Entity List
          Name                                           Label
Company                     A business organization which may act as: agent, consignee,
                            forwarder etc.
Customs Declaration         A declaration of goods for export/import.
Product Invoice             A request for payment of a product order
Product Order               A request for purchase or quote of goods
Stock                       A storage of products
Transport Invoice           A request for payment of a transport order




PowerDesigner                                                                                      Page 6
Conceptual Data Model                                                                                                                      TRIM 5_7




Consignment Submodel

                                  Consignment                                                              Transport Chain Type
                                                                     use            used in


                     contain                                          consist of
                                                                                                     be part of                 Delivery
                                                                     have as agent
                                                                  have as consignor                 be agent for
                                                                  have as consignee
                                                                                                  be consignor for
                                                                                                                                Company
                                                                         start at
                                                                    transhipped by                be consignee for
                                       contain
                                       include                          end at                         start for

                                                                                                  transshipment for
                                                                                                                                 Location
                                                                                                       end for
                               Consignment Shipment




                                                                                                                                   Visit
                                       include
                                                                                                            start for
                                      be part of
                                                                                start with
                                                                                                            end for
                               Transport Unit Shipment                            end at                                       Coastal Area
                                                                               unloaded in        unloading place of

                                                                                                     loading place of
                                                                                loaded in
                                                                                                                                Cargo Type
                                                                                                            classify
                                                                               classified by

                                                                                                                                 Service
           include                                                                                           classify
                                                                            be classified by

                                                                                                                               Price Header
                                                                            have price in              price for

                                                                            have costs in
                                                                                                           cost for            Actual Cost
                                                                                reference

                                                                           related to                       includes
                                                                                                                                 Contract
                                       contain                              reference
                                                   included in                                related to

                                                                         reference
                                                                                                                      Customs Declaration
                                       include                         use
                                                          contain                               be used in


                                                                                                                      Transport Unit Type

      Consignment Order              TUS Order            Trip Shipment                      be referenced in




                                                                                               be used by               Transport Unit
                                                                 included in
                     include       include

                      contain     contain                         contain


                     Transport Order                              Trip                                                  Unit of Measure




PowerDesigner                                                                                                                               Page 7
Conceptual Data Model                                                            TRIM 5_7


Entity List
          Name                                            Label
Actual Cost               Actual cost for a transport operation which is charged an actor.
Cargo Type                A class of load units; containers, Ro-Ro units, bulk goods (EC
                          Dir., Annex II)
Coastal Area              A geographical area, according to EC Dir., Annex IV.
Company                   A business organization which may act as: agent, consignee,
                          forwarder etc.
Consignment               An identifiable amount of goods transported from one consignor
                          to one consignee
Consignment Order         A connection between a consignment and a transport order
Consignment Shipment      A combination of a consignment and a transport unit shipment
Contract                  An agreement of subcontractor services; transport, storage
                          handling etc.
Customs Declaration       A declaration of goods for export/import.
Delivery                  A delivery of a part of an order, or the complete order.
Location                  A geographic place in a country, according to UN/LOCODE
Price Header              Identifies a valid time period for a set of price elements.
Service                   A basic transport operation type, independent of transport chain
Transport Chain Type      The complete transport chain from consignor to consignee.
Transport Order           A freight transport order
Transport Unit            A transport means or a load unit, or both of them
Transport Unit Shipment   A transport of one transport unit, with cargo or empty.
Transport Unit Type       A class of transport means or load units. Include IMO name
Trip                      The movement of a transport means from a terminal to the next
                          terminal.
Trip Shipment             A transport unit included in a trip
TUS Order                 A connection between a transport order and a transport unit
                          shipment
Unit of Measure           A quantity unit
Visit                     A visit of a transport unit in a terminal




PowerDesigner                                                                      Page 8
Conceptual Data Model                                                                                               TRIM 5_7




Contract Submodel
                     Company



                      be party in

                        involve




            Contract Company               Contract Type


                                                                                                   Service Group
                                           classify
                      be party in
                                       classified by                              included in
                        involve                                                                    Unit of Measure
                                                              include
                                                                                   used in
                                Contract                  use as weight unit
                                                                                   used in
                                                          use as time unit
                                                                                                   Currency
                                                               specify            be used in


                                                              approve
                                                                                                   Transport Unit
                                                                                  approved by
                     be used for       be used forincludes



                    reference                 reference
                                                                 reference



                Transport Order                   Service                Transport Unit Shipment




Entity List
          Name                                                       Label
Company                               A business organization which may act as: agent, consignee,
                                      forwarder etc.
Contract                              An agreement of subcontractor services; transport, storage
                                      handling etc.
Contract Company                      A connection between a contract and a company
Contract Type                         A class of contracts
Currency                              Money that is in use in a country
Service                               A basic transport operation type, independent of transport chain
Service Group                         A class of services; e.g. freight, handling, quay usage.
Transport Order                       A freight transport order
Transport Unit                        A transport means or a load unit, or both of them
Transport Unit Shipment               A transport of one transport unit, with cargo or empty.
Unit of Measure                       A quantity unit




PowerDesigner                                                                                                        Page 9
Conceptual Data Model                                                                           TRIM 5_7




Cost Submodel
                   Transport Unit Shipment




                          have costs in




                            cost for




                         Actual Cost                                          Currency
                                                specify         be used for




                                                                              Freight Cost Element
                                                                 classity
                                             be classified by




Entity List
          Name                                                Label
Actual Cost                    Actual cost for a transport operation which is charged an actor.
Currency                       Money that is in use in a country
Freight Cost Element           A basic unit of freight cost, specified by consignor.
Transport Unit Shipment        A transport of one transport unit, with cargo or empty.




PowerDesigner                                                                                        Page 10
Conceptual Data Model                                                                          TRIM 5_7




Currency Submodel
                           Country               Company


                                                                                Contract


                             has                 use

                                                                  specify
                            used in   be used by                             Transport Order
                                             be used in

                                                                 use
                          Currency           used in


                                            be used for      specify         Price Element

                                            be used for
                            contain     be used for
                                                                 specify
                                                                              Actual Cost
                              of
                                                       specify



                        Currency Value                                 Freight Cost Element




Entity List
          Name                                         Label
Actual Cost             Actual cost for a transport operation which is charged an actor.
Company                 A business organization which may act as: agent, consignee,
                        forwarder etc.
Contract                An agreement of subcontractor services; transport, storage
                        handling etc.
Country                 A geograhical area with a common government, according to
                        UN/LOCODE.
Currency                Money that is in use in a country
Currency Value          Currency values with valid dates
Freight Cost Element    A basic unit of freight cost, specified by consignor.
Price Element           A basic price unit, date specific.
Transport Order         A freight transport order




PowerDesigner                                                                                   Page 11
Conceptual Data Model                                                                                                               TRIM 5_7




Goods Item Submodel
                 Company                 Consignment                 Transport Order                       Transport Unit Type




                       order org unit        consist of           reference                be used in

                                            be part of       be subject for reference
                                                                                                                   Product Order

                                                                                 reference
                                          Delivery                                     be delivered as

                                                                                            be responsible for
                                                                                                                        Person
                                                                                 responsible person



             pay due for                    consist of
                                                                                                           Transport Invoice Line
                                           included in
                                                                                      invoice for
                                                                  invoiced by

                                         Goods Item                                                       Dangerous Goods Info
                                                                                        classify
                                                                     classified by

                                                                     classified by             classify
                                                                                                                   Goods Group

                                                                     classified by
                                                                                                    classify         Goods Type

                                                                     be produced in
                                                                                                    produce            Country
                                                                            part of

                                                                                                     contain
                                                                       use                                               Lot
                                          be stuffed as          be subject for
                                                                                          used for
                                           reference
                                                                 reference                                       Package Type
                                                         use as weight unit             reference

                                         Stuffed Item
                                                                                                                  AEI reading
                be paid due by
                                                                                  be delivered as


                                                                                used in                        Product Order Line
                                          be stuffed in stuffed in
                                         be stuffed with     location for


                                        Transport Unit                 Location                     Unit of Measure




Entity List
          Name                                                          Label
AEI reading                              A registration of an object, e.g. load unit, truck, rail wagon or
                                         driver
Company                                  A business organization which may act as: agent, consignee,
                                         forwarder etc.
Consignment                              An identifiable amount of goods transported from one consignor
                                         to one consignee
Country                                  A geograhical area with a common government, according to
                                         UN/LOCODE.


PowerDesigner                                                                                                                        Page 12
Conceptual Data Model                                                         TRIM 5_7


         Name                                          Label
Dangerous Goods Info     Parameters describing a dangerous goods cathegory.
Delivery                 A delivery of a part of an order, or the complete order.
Goods Group              A class of goods, according to EC Dir., Annex III
Goods Item               A separately identifiable quantity of goods
Goods Type               A class of goods
Location                 A geographic place in a country, according to UN/LOCODE
Lot                      An actual produced quantity of a product
Package Type             A cargo package cathegory, includes IMO codes; e.g. small box,
                         medium box
Person                   A male or female
Product Order            A request for purchase or quote of goods
Product Order Line       A line in a product order.
Stuffed Item             A goods item in a transport unit
Transport Invoice Line   An item in a Transport Invoice
Transport Order          A freight transport order
Transport Unit           A transport means or a load unit, or both of them
Transport Unit Type      A class of transport means or load units. Include IMO name
Unit of Measure          A quantity unit




PowerDesigner                                                                   Page 13
Conceptual Data Model                                                                    TRIM 5_7




Goods Type Submodel
                                                Goods Item




                    classified by           classified by          classified by



                        classify              classify               classify



                  Goods Type             Goods Group         Dangerous Goods Info




Entity List
          Name                                                   Label
Dangerous Goods Info                Parameters describing a dangerous goods cathegory.
Goods Group                         A class of goods, according to EC Dir., Annex III
Goods Item                          A separately identifiable quantity of goods
Goods Type                          A class of goods




PowerDesigner                                                                             Page 14
Conceptual Data Model                                                                                                              TRIM 5_7




Load Units Submodel


                                                Load Unit
                                                                                                                               Country
                                                                                                                   have
                                                                                                                belong to




                          have                             be subject for                 be located at


                                                                                           location for
                       reference                             reference



             Load Unit Condition                          AEI reading                  Load Unit Lane




             specify                                                                   reference

          be damaged in                                                              reference
                           located at         located at reading for reference reference              be subject for

                                                                                                                            Driver Card
      Damaged part
                                                                                                      be subject for
                          location for location for     reference     be subject for       be subject for


                                                                                                                       Goods Item
                          Location             Transport Order                Wagon                  Truck




Entity List
          Name                                                           Label
AEI reading                               A registration of an object, e.g. load unit, truck, rail wagon or
                                          driver
Country                                   A geograhical area with a common government, according to
                                          UN/LOCODE.
Damaged part                              A load unit part which has been damaged.
Driver Card                               Information about a Smart Card issued by the Vehicle
                                          Administration Authorities.
Goods Item                                A separately identifiable quantity of goods
Load Unit                                 A cargo transportation unit which may be oaded on a vessel,
                                          vehicle or train wagon.
Load Unit Condition                       The physical status of a load unit.
Load Unit Lane                            A specific waiting que for a load unit.
Location                                  A geographic place in a country, according to UN/LOCODE
Transport Order                           A freight transport order
Truck                                     A subtype of transport means; truck
Wagon                                     A rail wagon




PowerDesigner                                                                                                                        Page 15
Conceptual Data Model                                                                                                                 TRIM 5_7




Location Submodel
          Company                               Currency



                             located in           used in                                                          Vessel
                                                   has
                                    have
                                                                                         registered in
                                               Country                  register
                  be located in                                                                                   Load Unit
                                                                          have              belong to
                                                                        produce
                                                                                       be produced in
                                                                                                                Goods Item

                                                  has
                                                            Location Type
                                                                                                                  Stuffed Item

                 in
      be locatedlocated in
                             be location for
                                                                                            stuffed in          Transport Chain Type
                                               belongs to classify
                                                     be classified by location for            end at

                                                                                              start at
                                                                                                                       Service
                                                                 be final destination for
                                               Location                                            start at
                                                                      be origin for                 end at
                                                                                                                     Price Header
                                 contain                                   start of
                                                                                                  price for
                                                                           end of
                                                                                                                      AEI reading
                                                                       have a price in
                                                                                                 located at
                                                                        location for
                                                                                                   start at
                                                                                                                            Leg
                               be part of
                                                                         be start of
                                                                                                    end at
                                                                          be end of                                  Consignment
                                                                                              start at
                                                                          start for
                                                                                          transhipped by
                                                                      transshipment for       end at
                                                                          end for                                  Object Location
                                                                                        located at
                                                                        place for

                                                                        be place for               arrive at            Arrival

                                                                        be place for            depart from           Departure

                                                                        be used for              occupy              Quay Usage

                                                                      location for       located at             Load Unit Condition
        be location forbe location for
                                                                                       be loaded at
                                                                                                               Transport Unit Loaded
                                                                      be place for

                                                                      main destination for
                                                                                                 destination at         Product Order

                                                                      payment place for           payed at
                                                                                                                      Product Invoice
                                                                      payment place for
                                                                                               payed at
                                                                                                                    Transport Invoice
                                                                 Coastal Area

                                                                                  unloading place of
                                                                       loading place of    unloaded in


              City                                                                      loaded in             Transport Unit Shipment
                                  Postal Area               Terminal




PowerDesigner                                                                                                                           Page 16
Conceptual Data Model                                                             TRIM 5_7


Entity List
          Name                                           Label
AEI reading               A registration of an object, e.g. load unit, truck, rail wagon or
                          driver
Arrival                   The end of a trip
City                      A town.
Coastal Area              A geographical area, according to EC Dir., Annex IV.
Company                   A business organization which may act as: agent, consignee,
                          forwarder etc.
Consignment               An identifiable amount of goods transported from one consignor
                          to one consignee
Country                   A geograhical area with a common government, according to
                          UN/LOCODE.
Currency                  Money that is in use in a country
Departure                 The start of a trip
Goods Item                A separately identifiable quantity of goods
Leg                       The distance between two locations
Load Unit                 A cargo transportation unit which may be oaded on a vessel,
                          vehicle or train wagon.
Load Unit Condition       The physical status of a load unit.
Location                  A geographic place in a country, according to UN/LOCODE
Location Type             A class of locations; regions, cities, terminals, etc.
Object Location           A location for an object.
Postal Area               A geographical area
Price Header              Identifies a valid time period for a set of price elements.
Product Invoice           A request for payment of a product order
Product Order             A request for purchase or quote of goods
Quay Usage                An occupation of a quay for a docking.
Service                   A basic transport operation type, independent of transport chain
Stuffed Item              A goods item in a transport unit
Terminal                  A port, railway station or freight terminal.
Transport Chain Type      The complete transport chain from consignor to consignee.
Transport Invoice         A request for payment of a transport order
Transport Unit Loaded     A load unit or a transport means placed on a transport means.
Transport Unit Shipment   A transport of one transport unit, with cargo or empty.
Vessel                    A subtype of transport means.




PowerDesigner                                                                       Page 17
Conceptual Data Model                                                                                                                                     TRIM 5_7




Main Entities Submodel
                                                    Transport Unit                                                                              Goods Item
                     Transport Means                                                  Load Unit



                                                                                                                                      be stuffed as     included in
                                          contain                           be placed on be referenced in be stuffed with
                                                                                                                                       reference        consist of
                                         placed on                               concern                   be stuffed in


                                                                                                                                                        Delivery
                 perform                       Transport Unit Loaded                                                 Stuffed Item



                                                                                               reference
                                                                                                                                                        be part of
                                                                                                                                                        consist of


                                                                                 Transport Unit Shipment                                              Consignment

          be performed by


                                                                                                contain        be part of                                 contain
                                                                                                include                                                   include
                                                                                                                            include




                 Tour                                                                        TUS Order                                  Consignment Shipment




        consist of     consist of

                                                                                                include
    be part of             be part of
                                                                                                contain


   Trip                          Visit                              start with             Transport Order
                                                     be start for

                                                     be end of       end at



  has            has has                 has

  end            start start            end


  Arrival                      Departure




Entity List
          Name                                                                                              Label
Arrival                                                The end of a trip
Consignment                                            An identifiable amount of goods transported from one consignor
                                                       to one consignee
Consignment Shipment                                   A combination of a consignment and a transport unit shipment
Delivery                                               A delivery of a part of an order, or the complete order.
Departure                                              The start of a trip
Goods Item                                             A separately identifiable quantity of goods
Load Unit                                              A cargo transportation unit which may be oaded on a vessel,
                                                       vehicle or train wagon.


PowerDesigner                                                                                                                                                 Page 18
Conceptual Data Model                                                              TRIM 5_7


           Name                                           Label
Stuffed Item              A goods item in a transport unit
Tour                      The totality of trips made by a transport means in one
                          assignment.
Transport Means            A vehicle used for the transport of goods, e.g. truck, vessel or
                          train
Transport Order           A freight transport order
Transport Unit            A transport means or a load unit, or both of them
Transport Unit Loaded     A load unit or a transport means placed on a transport means.
Transport Unit Shipment   A transport of one transport unit, with cargo or empty.
Trip                      The movement of a transport means from a terminal to the next
                          terminal.
TUS Order                 A connection between a transport order and a transport unit
                          shipment
Visit                     A visit of a transport unit in a terminal




PowerDesigner                                                                        Page 19
Conceptual Data Model                                                                                                        TRIM 5_7




Main Entities Submodel 2
      Transport Chain Type                                                                                  Transport Order
                                                              used in                  use




                     consist of

                  is component of


                                                                                                                 reference
      Chain Operation Type




                  be classified by

                                                                                                                be used in
                                                                         Company
                      classify

                                                              offer
                                                 offered by
                   Service                                              Service Unit                       Transport Unit Type
                                                    incude                                   be used by
                                                  use                                            include

                                              have a price in
                                                         price for
                                                                        Price Header
       start at                      end at



       start of                      end of



                   Location




Entity List
          Name                                                                Label
Chain Operation Type                           A service in a specific transport chain type.
Company                                        A business organization which may act as: agent, consignee,
                                               forwarder etc.
Location                                       A geographic place in a country, according to UN/LOCODE
Price Header                                   Identifies a valid time period for a set of price elements.
Service                                        A basic transport operation type, independent of transport chain
Service Unit                                   A combination of a service and a transport unit type
Transport Chain Type                           The complete transport chain from consignor to consignee.
Transport Order                                A freight transport order
Transport Unit Type                            A class of transport means or load units. Include IMO name




PowerDesigner                                                                                                                 Page 20
Conceptual Data Model                                                                                         TRIM 5_7




Package Submodel



     Packaging Material
                                                          be used by



                                                  Package Group Type                                    use




                                                                                                     Service
                                                              consist of
          be used in
                       be used in
                                                                 be of


                                                                                                       use
                                                          Package Type
                                                                                   be used by
                                                                             used for
                                                                                          use      Goods Item

                                                                classify

                                             be used in        reference

             use
                                                          Package Code                           Product Order Line
                                    be made of                               be used by
                                                                                    reference
                                       use



                                                              be used by

                                                                           use
                                                                                          Transport Unit Type
                Transport Chain Type




Entity List
          Name                                                    Label
Goods Item                          A separately identifiable quantity of goods
Package Code                        A detailed cargo package cathegory
Package Group Type                  A set of packages, includes IMO codes; e.g. box, drum, bag,
                                    bulk
Package Type                        A cargo package cathegory, includes IMO codes; e.g. small box,
                                    medium box
Packaging Material                  A packaging material code according to IMO; e.g. wood, metal,
                                    plastic, paper
Product Order Line                  A line in a product order.
Service                             A basic transport operation type, independent of transport chain
Transport Chain Type                The complete transport chain from consignor to consignee.
Transport Unit Type                 A class of transport means or load units. Include IMO name




PowerDesigner                                                                                                   Page 21
Conceptual Data Model                                                                                                                        TRIM 5_7




Price Submodel
  Service Group            Unit of Measure              Currency                Transport Unit Shipment                               Service




                                                                               have price in                      have a price in
                                                                                                                                      Service Order

    refer to                used for          be used for be used for            price for          price for
                                                                                                                   have a price in

                                                                                                        price for

                                                                          Price Header                                       Chain Operation Type
                                                                                                          price for
                                                                                                   have a price in



                                                                                                        price for
                                                                                 contain
  be used by     use as cost unit   specify                                                        price for
                                                                 use specify                                       have a price in    Location

                                                                               be member of


                                                                                                                  have a price in


    Freight Cost Element                                                                                                               Object
                                                                          Price Element
                                              be classified by
                                          classify


                                                        classity

                                                                                  contain
               contain                 contain
                                                                                               be classified by
                                                                               be member of                                          Actual Cost
               adjust
                                                      adjust



    Freight Cost Adjustment                                          Price Adjustment Factor




Entity List
          Name                                                               Label
Actual Cost                                   Actual cost for a transport operation which is charged an actor.
Chain Operation Type                          A service in a specific transport chain type.
Currency                                      Money that is in use in a country
Freight Cost Adjustment                       A freight cost addition/reduction, in percent.
Freight Cost Element                          A basic unit of freight cost, specified by consignor.
Location                                      A geographic place in a country, according to UN/LOCODE
Object                                        A physical thing; Building, equipment, lighthouse
Price Adjustment Factor                       A price addition/reduction, in percent.
Price Element                                 A basic price unit, date specific.
Price Header                                  Identifies a valid time period for a set of price elements.
Service                                       A basic transport operation type, independent of transport chain


PowerDesigner                                                                                                                                    Page 22
Conceptual Data Model                                                                TRIM 5_7


          Name                                           Label
Service Group             A class of services; e.g. freight, handling, quay usage.
Service Order             A service performed to a customer
Transport Unit Shipment   A transport of one transport unit, with cargo or empty.
Unit of Measure           A quantity unit




PowerDesigner                                                                         Page 23
Conceptual Data Model                                                                                                                                TRIM 5_7




Product Order Submodel
 Transport Unit Type

                                                                      Location

                                          payment place for
 main transport means for

                                                                  main destination for

     transport means    payed at
                                                                      destination at
                             carried by                                                                                                  main carrier for
                                                            contain


            Product Invoice                                   Product Order                   delivered by                                Company
                                                                                                               delivery party for
                                            reference                                          supplied by
                                                                                                               supplier party for
                                                                                                buyed by
                                                                                                                  buyer party for
                                          invoice for
                                                                                                stored at         warehouse for
                                                                                                                                                            store
                                                                                               invoiced to            invocee for
                                           invoiced by                                          taxed at           Tax office for


                                                                                                                contact for                Person
                                                                                             have contact person


                                                                                            reference used for
                                                                                                    be
                                                                                    be delivered as
                                                                                                                          Transport Chain Type
                    contain                                             contain

                                                                                                      reference
                   include in                                         included in                                                    Delivery


         Product Invoice Line               invoice for         Product Order Line

                                             invoiced by                                                use       quantify          Unit of Measure
                                                    order
                                                                                                      reference
                                                                                              be delivered as
                                                                                                                  be used by        Package Code
                                    be ordered in
                                                                                                               reference
                                                                                                                                     Goods Item
                                  Product               produced as
                                                                                         Lot                contain
                                                                                                                  part of
                                                                 version of



                                      stored at
                                                                                         Stock
                                                                                                                             stored at
                                                              contain




Entity List
          Name                                                            Label
Company                                     A business organization which may act as: agent, consignee,
                                            forwarder etc.
Delivery                                    A delivery of a part of an order, or the complete order.
Goods Item                                  A separately identifiable quantity of goods
Location                                    A geographic place in a country, according to UN/LOCODE


PowerDesigner                                                                                                                                           Page 24
Conceptual Data Model                                                        TRIM 5_7


           Name                                        Label
Lot                     An actual produced quantity of a product
Package Code            A detailed cargo package cathegory
Person                  A male or female
Product                 A class of articles, materials or natural substances.
Product Invoice         A request for payment of a product order
Product Invoice Line    An item in a product invoice
Product Order           A request for purchase or quote of goods
Product Order Line      A line in a product order.
Stock                   A storage of products
Transport Chain Type    The complete transport chain from consignor to consignee.
Transport Unit Type     A class of transport means or load units. Include IMO name
Unit of Measure         A quantity unit




PowerDesigner                                                                  Page 25
Conceptual Data Model                                                                                                                           TRIM 5_7




Service Submodel

Mode of Transport                                             Service Group                                                    Freight Cost Element
                                                                                               refer to
                                                                                                       be used by



             be used by                   Service Mode                             Service Unit                      include
                                                                     classify                                                     be used by
                    include


                                                                   classified by
                                                                                                                                  Transport Unit Type
                                                            include                 incude
                                                                 use                 use


     Visit                                                         Service                                                           Contract
                          start for         start with
                                                                                                                 be used for
                                                                                                reference
                          end of             end at

                                                                                                                                  Chain Operation Type
   Location               end of            end at
                                                                                              classify
                                                                                                         be classified by
                          start of          start at


  Package Type                 be used by
                                               use                                                                          Transport Unit Shipment
                                                                                             classify
                                                 use                                          be classified by
 Packaging Material                be used by


                                      use as quantity unit
                                                                                                                                     Quay Usage
                               be used by
  Unit of Measure                                                                               offered by
                                          have a price in        be ordered by
                                                                                                                       use
                                                                    order for
                              price for                                                                                offer
                                                                                                provided to


   Price Header                  have a price in
                                                              Service Order                                                            Company
                                                                                                 provided to         buyer of
                                price for
                                                                                                   part of
                                                                                                                     include
                                                                                                                                     Transport Order




Entity List
          Name                                                                 Label
Chain Operation Type                            A service in a specific transport chain type.
Company                                         A business organization which may act as: agent, consignee,
                                                forwarder etc.
Contract                                        An agreement of subcontractor services; transport, storage
                                                handling etc.
Freight Cost Element                            A basic unit of freight cost, specified by consignor.
Location                                        A geographic place in a country, according to UN/LOCODE
Mode of Transport                               An IMO transport method
Package Type                                    A cargo package cathegory, includes IMO codes; e.g. small box,
                                                medium box
Packaging Material                              A packaging material code according to IMO; e.g. wood, metal,
                                                plastic, paper
Price Header                                    Identifies a valid time period for a set of price elements.
Quay Usage                                      An occupation of a quay for a docking.
Service                                         A basic transport operation type, independent of transport chain


PowerDesigner                                                                                                                                    Page 26
Conceptual Data Model                                                          TRIM 5_7


          Name                                            Label
Service Group             A class of services; e.g. freight, handling, quay usage.
Service Mode              A combination of a service and a transport mode
Service Order             A service performed to a customer
Service Unit              A combination of a service and a transport unit type
Transport Order           A freight transport order
Transport Unit Shipment   A transport of one transport unit, with cargo or empty.
Transport Unit Type       A class of transport means or load units. Include IMO name
Unit of Measure           A quantity unit
Visit                     A visit of a transport unit in a terminal




PowerDesigner                                                                    Page 27
Conceptual Data Model                                                                                                                                    TRIM 5_7




Transport Chain Submodel

     Package Type                  Packaging Material                         Location                 Transport Unit Type                        Product


                                                                                                                        be transported by
Route Plan                                                                                         be used in
                      be used in        be used in                                                                                           Product Order
                                                           be final destination for   be origin for

                             use            use                                                    use      transport       reference
                                                                   end at               start at
                                                                                                                                           Delivery Terms
  schedule                                                                                                    be used for
                                                                                                                          be used in

       scheduled by
                                                     Transport Chain Type                                         refer to
                                                                                                                                           Transport Order
                                                                                                                 used in
                                                                                                                              use
    Service
                                                                                                                 used in       use
                                                                                                                                                Consignment
                                                                                                           use as quantity unit

                                                                                                                           used by
                                                                                                               be used for
                                           consist of                           described by          be used for
                                                                                                                                            Unit of Measure
                                                                                                                     be consignee in
      classify
                                        is component of                           describe
                                                                                                                   be consignor in                Company

                                                                                                        triggered by
                             Chain Operation Type                             Transition                                   trigger


   be classified by                                                                                     triggered by

                                                                                                             trigger

                                                                                  trigger
                                                              have                                 Message Type                                 triggered by
                                            be estimated by                                                                                                    specfy
                                                                               triggered by                                          supported by
                                                                  reference
                      have a price in

                                               reference
                                                                                Action                   triggered by

                                                                                                       trigger
                                     Transport Forecast                                                          trigger
                                                                                                                                      support
                         price for
                                                                                               specified by




                                                                                                                                     Supported Message
                        Price Header




Entity List
          Name                                                                  Label
Action                                            A single action in a row of a state/transition table
Chain Operation Type                              A service in a specific transport chain type.
Company                                           A business organization which may act as: agent, consignee,
                                                  forwarder etc.
Consignment                                       An identifiable amount of goods transported from one consignor
                                                  to one consignee
Delivery Terms                                    Terms of delivery. IMO approved.
Location                                          A geographic place in a country, according to UN/LOCODE
Message Type                                      Type of conceptual message which trigger a transition or is
                                                  activated by a transition


PowerDesigner                                                                                                                                                  Page 28
Conceptual Data Model                                                          TRIM 5_7


         Name                                          Label
Package Type            A cargo package cathegory, includes IMO codes; e.g. small box,
                        medium box
Packaging Material      A packaging material code according to IMO; e.g. wood, metal,
                        plastic, paper
Price Header            Identifies a valid time period for a set of price elements.
Product                 A class of articles, materials or natural substances.
Product Order           A request for purchase or quote of goods
Route Plan              A schedule for transport chains.
Service                 A basic transport operation type, independent of transport chain
Supported Message       A physical message type which is supported by a company
Transition              A row in a state/transition table
Transport Chain Type    The complete transport chain from consignor to consignee.
Transport Forecast      An estimat of cargo weight per period
Transport Order         A freight transport order
Transport Unit Type     A class of transport means or load units. Include IMO name
Unit of Measure         A quantity unit




PowerDesigner                                                                    Page 29
Conceptual Data Model                                                                                                                        TRIM 5_7




Transport Means Submodel
       Transport Order                      Tour                Person



                                                             main driver
                           use          be performed by
                                                       have as main driver
                          be used in        perform


                                    Transport Means




            Truck                                   Vessel                              Train                                    Train wagon
                                                                                                              consists of
                                                                                                              included in




                                                                           located at
                                 be classified by       be classified by                                                                reference

                                                                                       position for                                      used as
                        registered in
 be subject for                                              classify
                                 classify
                                                                                            Vessel Position                           Wagon
                                                      Vessel Size Class
                          Vessel Type

             register                                                             use        uses      uses         concern
                                                                                                                                       be subject for


                                                                             FO unit     DO unit      FW unit        reference            reference
                                                                                                                                 reference
   Country
                                                                             Unit of Measure                           Visit          AEI reading




Entity List
          Name                                                                     Label
AEI reading                                         A registration of an object, e.g. load unit, truck, rail wagon or
                                                    driver
Country                                             A geograhical area with a common government, according to
                                                    UN/LOCODE.
Person                                              A male or female
Tour                                                The totality of trips made by a transport means in one
                                                    assignment.
Train                                               A set of wagons which are included in a specific instance of a
                                                    train
Train wagon                                         A wagon in a specific train


PowerDesigner                                                                                                                                   Page 30
Conceptual Data Model                                                            TRIM 5_7


          Name                                          Label
Transport Means          A vehicle used for the transport of goods, e.g. truck, vessel or
                        train
Transport Order         A freight transport order
Truck                   A subtype of transport means; truck
Unit of Measure         A quantity unit
Vessel                  A subtype of transport means.
Vessel Position         Speed and position of a vessel.
Vessel Size Class       A cathegory of vessel sizes, according to EC Dir., Annex VIII.
Vessel Type             A class of vessels., according to EC Dir., Annex VI.
Visit                   A visit of a transport unit in a terminal
Wagon                   A rail wagon




PowerDesigner                                                                      Page 31
Conceptual Data Model                                                                                                                              TRIM 5_7




Transport Order Submodel

  Transport Unit Type               Transport Means              Transport Chain Type                               Visit                 AEI reading




   Route Plan Line                          be used in          be used in                   used in      be start for       be end of
                                                                                                                                         reading for

                                         schedule                                                     use start with          end at
     Delivery                                                                             use                                          reference
                                                                             reference
                                                                                                                                             contain
                                    be subject for                       scheduled by                      Transport Order
     Contract
                                 be used for                               reference

    Freight Cost Element                                                  reference

                                                 be used by
                                                                              reference

    Currency                         used in                                 use


    Company                 be ordering party for                   be ordered by
                           be contracting party for                be contracted by
                               be notified for                          be notified to
                              be charterer for                     be chartered by

                                                                                   invoiced by
                                                          invoice for


                      release
                             released by
                                                     Transport Invoice
                              payed at

       payment place for

                                                            contain
      Location                                            included in



                                                                                                                                              be part of
                           invoice for          Transport Invoice Line                      contain
     Goods Item
                           invoiced by                                                                                          have
                                                                            be included in                contain contain


        Person             act as
                                                     Booked Driver                        include                                belong to
                                    reference

                                                                                                     include     include

                                                                                                                         Transport Order State



                                                                                         TUS Order             Consignment Order

                                                              part of



                                                                                                include                    include

                                                                                                contain                    contain


                                      Service Order            Transport Unit Shipment                           Consignment




PowerDesigner                                                                                                                                          Page 32
Conceptual Data Model                                                             TRIM 5_7


Entity List
          Name                                            Label
AEI reading               A registration of an object, e.g. load unit, truck, rail wagon or
                          driver
Booked Driver             A driver which is included in a booking
Company                   A business organization which may act as: agent, consignee,
                          forwarder etc.
Consignment               An identifiable amount of goods transported from one consignor
                          to one consignee
Consignment Order         A connection between a consignment and a transport order
Contract                  An agreement of subcontractor services; transport, storage
                          handling etc.
Currency                  Money that is in use in a country
Delivery                  A delivery of a part of an order, or the complete order.
Freight Cost Element      A basic unit of freight cost, specified by consignor.
Goods Item                A separately identifiable quantity of goods
Location                  A geographic place in a country, according to UN/LOCODE
Person                    A male or female
Route Plan Line           A line in a schedule for transport chains
Service Order             A service performed to a customer
Transport Chain Type      The complete transport chain from consignor to consignee.
Transport Invoice         A request for payment of a transport order
Transport Invoice Line    An item in a Transport Invoice
Transport Means            A vehicle used for the transport of goods, e.g. truck, vessel or
                          train
Transport Order           A freight transport order
Transport Order State     The condition of a transport order at a specified time
Transport Unit Shipment   A transport of one transport unit, with cargo or empty.
Transport Unit Type       A class of transport means or load units. Include IMO name
TUS Order                 A connection between a transport order and a transport unit
                          shipment
Visit                     A visit of a transport unit in a terminal




PowerDesigner                                                                       Page 33
Conceptual Data Model                                                                                                                                       TRIM 5_7




Transport Submodel
       Transport Means                     Person



                     perform                                                                                                          Transport Chain Type
                                                                         Route Plan
                 be performed by                                                                           scheduled
                                                                                                          schedule by
                                         be driver for
                        Tour                                                     contain
                                                                                  part of


                                                                        Route Plan Line
                                  consist of                                                                                  schedule
                     consist of

                                                                                                                            Company
                    be part of                                                   contain       involved in
                                      have as driver
                                                                                             is shipagent for
                                                                    involving                            be agent for
                                                                                                                                                            scheduled by
                                                              have as shipagent                                       pay
                               Trip                                         part of                                                         Vessel Position
                                                                                            be supported by
                                                               be part of                          be paid by
                                                                                                                            concern
     contain                                                                                             reference
                                                                                 Visit                                        start with        Transport Order
                                                                                                         be start for

                                                                                                          be end of             end at
                                                                                                                                pay



                                                    has                                                  start for      start with
                  has                       has                                                                                            Transport Unit Shipment
                                                                                                         end for
                                                              has                                                        end at
                  start   end               end
                                                     start                                                start for
                                                                                consist of
                                                                                                         end of
                 Departure                     Arrival                    component of                                   start with

                                                                                                                            end at
                                                                                                                                            Service
                                                                         Subdocking

                                                                                                            be paid by
                                                         occasion for
                          occasion for

   included in
                                                                                  use                                                      Transport Unit Loaded
                                                                                                    unloaded at
                  depart from                     arrive at
                                                                                             loaded at
                                                                            be used for


                                                                                                                                            Service Order
                                                                        Quay Usage                                    provided to
                                                                                                             use

                  be place for                 be place for

                                                                        occupy                use
                                                                     be used for             used by


 Trip Shipment                            Location                                            Quay




Entity List
          Name                                                                                                Label
Arrival                                        The end of a trip


PowerDesigner                                                                                                                                                 Page 34
Conceptual Data Model                                                             TRIM 5_7


           Name                                           Label
Company                   A business organization which may act as: agent, consignee,
                          forwarder etc.
Departure                 The start of a trip
Location                  A geographic place in a country, according to UN/LOCODE
Person                    A male or female
Quay                      A docking area in a port/terminal
Quay Usage                An occupation of a quay for a docking.
Route Plan                A schedule for transport chains.
Route Plan Line           A line in a schedule for transport chains
Service                   A basic transport operation type, independent of transport chain
Service Order             A service performed to a customer
Subdocking                A stay of a transport means at a specific place in a port.
Tour                      The totality of trips made by a transport means in one
                          assignment.
Transport Chain Type      The complete transport chain from consignor to consignee.
Transport Means            A vehicle used for the transport of goods, e.g. truck, vessel or
                          train
Transport Order           A freight transport order
Transport Unit Loaded     A load unit or a transport means placed on a transport means.
Transport Unit Shipment   A transport of one transport unit, with cargo or empty.
Trip                      The movement of a transport means from a terminal to the next
                          terminal.
Trip Shipment             A transport unit included in a trip
Vessel Position           Speed and position of a vessel.
Visit                     A visit of a transport unit in a terminal




PowerDesigner                                                                       Page 35
Conceptual Data Model                                                                                              TRIM 5_7




Transport Unit Submodel
                                                                                                 Service Mode
                        Mode of Transport                                     include
                                                        be used by
                                                                                                 Service Unit


                             composed of                                     include             Product Invoice

                               reference                                     transport means
                                                   be used by
                                                                                                Transport Chain Type
                                                 main transport means for
                        Transport Unit Type                                       use
                                                         be used in
                                                                                reference
                                                                                                Transport Order
                                                         be used in

                                                         be used in              reference         Delivery
                                                            use
                                                                               be used by
                                                                                                 Package Code


                                                        be used in

                                                                               reference
                            be referenced by                                                   Transport Unit Shipment
                                                Cargo Type
                                                                      classify
                                                                              classified by
                               reference
                                                                              reference

                                                   be referenced in
            part of                                                              own               Company
                          Transport Unit                 owned by
                                                                                insure
                                                        insured by

                                                   crew managed by
                                                                         crew manager for

                                                   ship managed by          ship manager for



                                                        contain              placed on         Transport Unit Loaded
                                                    be placed on
                                                                              concern
                                                   be stuffed with
           consist of
                                                           use              be stuffed in
                                                                                                   Stuffed Item
                                                   approved by
                                                                               be used by

                                                                                                 Unit of Measure
                                                                              approve


                                                                                                Contract
           Transport Means                  Load Unit




Entity List
          Name                                                           Label
Cargo Type                                 A class of load units; containers, Ro-Ro units, bulk goods (EC
                                           Dir., Annex II)
Company                                    A business organization which may act as: agent, consignee,
                                           forwarder etc.
Contract                                   An agreement of subcontractor services; transport, storage
                                           handling etc.


PowerDesigner                                                                                                          Page 36
Conceptual Data Model                                                               TRIM 5_7


            Name                                        Label
Delivery                  A delivery of a part of an order, or the complete order.
Load Unit                 A cargo transportation unit which may be oaded on a vessel,
                          vehicle or train wagon.
Mode of Transport         An IMO transport method
Package Code              A detailed cargo package cathegory
Product Invoice           A request for payment of a product order
Service Mode              A combination of a service and a transport mode
Service Unit              A combination of a service and a transport unit type
Stuffed Item              A goods item in a transport unit
Transport Chain Type      The complete transport chain from consignor to consignee.
Transport Means            A vehicle used for the transport of goods, e.g. truck, vessel or
                          train
Transport Order           A freight transport order
Transport Unit            A transport means or a load unit, or both of them
Transport Unit Loaded     A load unit or a transport means placed on a transport means.
Transport Unit Shipment   A transport of one transport unit, with cargo or empty.
Transport Unit Type       A class of transport means or load units. Include IMO name
Unit of Measure           A quantity unit




PowerDesigner                                                                         Page 37
Conceptual Data Model                                                                       TRIM 5_7




Entity Descriptions

Entity: Action
   Name:         Action
   Code:         ACTION
   Label:        A single action in a row of a state/transition table
   Number:                             Generate Table:        Yes


Attribute List
          Name                                   Label                          Type    I       M
Action id                                                                      NO      Yes     Yes
Timer stop time                Time when a timer expire                        DT      No      No
Action type                    M=Message sending,                              A1      No      No


Reference List
                         Entity                                               Card          Dep.
Chain Operation Type(CHAIN_OPERATION_TYPE)                              0,1            No
Company(COMPANY)                                                        0,1            No
Message Type(MESSAGE_TYPE)                                              0,1            No
Transition(TRANSITION)                                                  1,1            No


Entity: Actual Cost
   Name:         Actual Cost
   Code:         ACTUAL_COST
   Label:        Actual cost for a transport operation which is charged an actor.
   Number:                             Generate Table:      Yes


Attribute List
          Name                                   Label                          Type    I       M
AC id                                                                          NO      Yes     Yes
AC date                                                                        DT      No      No
AC value                                                                       MN15    No      No


Reference List
                          Entity                                              Card          Dep.
Freight Cost Element(FREIGHT_COST_ELEMENT)                              0,1            No
Transport Unit Shipment(TRANSPORT_UNIT_SHIPMENT)                        0,1            No
Currency(CURRENCY)                                                      0,1            No


Entity: AEI reading
   Name:         AEI reading


PowerDesigner                                                                                Page 38
Conceptual Data Model                                                                       TRIM 5_7


   Code:         AEI_READING
   Label:        A registration of an object, e.g. load unit, truck, rail wagon or driver
   Number:                             Generate Table:          Yes


Description
A registration of identity, time, location and monitor type for an object.
The object may be a:
 - load unit,
 - goods item,
 - truck,
 - rail wagon , or
 - driver id,
but only one of this object in the same entity occurence.

Monitor types are:
 0 Entry
 1 Exit
 2 Loading
 3 Unloading
 4 Stacking
 5 Unstacking
 6 Stuffing
 7 Stripping
 8 Registration
 9 Reader status message

Attribute List
          Name                                   Label                         Type    I        M
Reading id                    Sequence number of reading message             NO       Yes      Yes
Reader id                     Local identity of the reader                   I        No       No
Time                          Data and time for the reading                  DT       No       No
Monitor type                  See code list above.                           A1       No       No
Transport object type         Codes: 0-Goods item, 1-Load unit, 2-           A1       No       No
                              Truck, 3-Rail wagon, 4-Driver card
Battery status                Codes: 0-OK, 1-Battery low, 2-Battery          A1       No       No
                              malfunction
Reader status                 Status code from the AEI reader when           A20      No       No
                              monitor type=9


Reference List
                        Entity                                              Card            Dep.
Location(LOCATION)                                                    0,1             No
Load Unit(LOAD_UNIT)                                                  0,1             No
Truck(TRUCK)                                                          0,1             No
Wagon(WAGON)                                                          0,1             No
Driver Card(DRIVER_CARD)                                              0,1             No
Transport Order(TRANSPORT_ORDER)                                      0,1             No
Goods Item(GOODS_ITEM)                                                0,1             No


PowerDesigner                                                                                Page 39
Conceptual Data Model                                                                 TRIM 5_7




Entity: Arrival
   Name:         Arrival
   Code:         ARRIVAL
   Label:        The end of a trip
   Number:                             Generate Table:      Yes


Attribute List
           Name                                Label                      Type    I       M
Arrival id                                                               LI      Yes     Yes
Arrival time planned                                                     DT      No      No
Arrival time estimate                                                    DT      No      No
Arrival time actual                                                      DT      No      No
Unloading time                                                           DT      No      No
Working labour required                                                  A10     No      No
Cranes required                                                          A10     No      No
Equipment required                                                       A10     No      No
Last updated ETA                                                         DT      No      No
Reports sent                                                             A1      No      No
Remarks                                                                  A200    No      No


Reference List
                              Entity                                    Card          Dep.
Location(LOCATION)                                                0,1            No
Trip(TRIP)                                                        1,1            No
Visit(VISIT)                                                      0,1            No
Transport Unit Loaded(TRANSPORT_UNIT_LOADED)                      0,n            No


Entity: Booked Driver
   Name:         Booked Driver
   Code:         BOOKED_DRIVER
   Label:        A driver which is included in a booking
   Number:                             Generate Table:      Yes


Description
A driver which is included in a booking.

Attribute List
          Name                                 Label                      Type    I       M
BD id                                                                    NO      Yes     Yes
Cabin no                                                                 A10     No      No
BD Status                     Values: Booked, Arrived, ..                A3      No      No




PowerDesigner                                                                          Page 40
Conceptual Data Model                                                                  TRIM 5_7


Reference List
                        Entity                                           Card          Dep.
Transport Order(TRANSPORT_ORDER)                                   1,1            No
Person(PERSON)                                                     1,1            No


Entity: Cargo Type
   Name:         Cargo Type
   Code:         CARGO_TYPE
   Label:        A class of load units; containers, Ro-Ro units, bulk goods (EC Dir., Annex II)
   Number:                              Generate Table:     Yes


Description
The code values are defined in Annex II.

Attribute List
          Name                                  Label                      Type    I       M
CT Code                                                                   A2      Yes     Yes
CT name                                                                   A200    No      No


Reference List
                          Entity                                         Card          Dep.
Transport Unit Shipment(TRANSPORT_UNIT_SHIPMENT)                   0,n            No


Entity: Chain Operation Type
   Name:         Chain Operation Type
   Code:         CHAIN_OPERATION_TYPE
   Label:        A service in a specific transport chain type.
   Number:                             Generate Table:       Yes


Attribute List
          Name                                Label                        Type    I       M
COT code                      System generated unique identifier          LI      Yes     Yes


Reference List
                         Entity                                          Card          Dep.
Action(ACTION)                                                     0,n            No
Service(SERVICE)                                                   0,1            No
Transport Chain Type(TRANSPORT_CHAIN_TYPE)                         1,1            No
Price Header(PRICE_HEADER)                                         0,n            No
Transport Forecast(TRANSPORT_FORECAST)                             0,n            No




PowerDesigner                                                                           Page 41
Conceptual Data Model                                                                 TRIM 5_7


Entity: City
   Name:         City
   Code:         CITY
   Label:        A town.
   Number:                             Generate Table:     Yes


Reference List
                              Entity                                    Card          Dep.
Company(COMPANY)                                                  0,n            No


Entity: Coastal Area
   Name:         Coastal Area
   Code:         COASTAL_AREA
   Label:        A geographical area, according to EC Dir., Annex IV.
   Number:                            Generate Table:      Yes


Attribute List
          Name                                 Label                      Type    I       M
CA code id                                                               NO      Yes     Yes
CA code                                                                  A4      No      No
CA name                                                                  A200    No      No


Reference List
                          Entity                                        Card          Dep.
Transport Unit Shipment(TRANSPORT_UNIT_SHIPMENT)                  0,n            No
Transport Unit Shipment(TRANSPORT_UNIT_SHIPMENT)                  0,n            No


Entity: Company
   Name:         Company
   Code:         COMPANY
   Label:        A business organization which may act as: agent, consignee, forwarder etc.
   Number:                            Generate Table:      Yes


Description
A business organization.

Attribute List
          Name                                Label                   Type        I       M
Company id                   System generated unique identifier      LI          Yes     Yes
Company type                 Provider/Customer/Consignee/Mycompa A3              No      No
                             ny/etc.
Company code                 User specified Unique business id, e.g. A17         No      No


PowerDesigner                                                                          Page 42
Conceptual Data Model                                                              TRIM 5_7


           Name                              Label                    Type     I          M
                        enterprise no, etc
Name                                                                 A175    No       Yes
Address                                                              A175    No       No
Terms of payment                                                     A4      No       No
Phone no                                                             A20     No       No
Fax no                                                               A20     No       No
Email address                                                        A50     No       No
URL address             Web address                                  A100    No       No
Telex no                                                             A20     No       No
Customs procedure no    A reference to an agreed simplified          A10     No       No
                        customs handling procedure
Bank account no                                                      A12     No       No
Post account no                                                      A12     No       No


Reference List
                         Entity                                     Card           Dep.
Action(ACTION)                                                0,n            No
Consignment(CONSIGNMENT)                                      0,n            No
Consignment(CONSIGNMENT)                                      0,n            No
Consignment(CONSIGNMENT)                                      0,n            No
City(CITY)                                                    0,1            No
Country(COUNTRY)                                              0,1            No
Location(LOCATION)                                            0,1            No
Postal Area(POSTAL_AREA)                                      0,1            No
Currency(CURRENCY)                                            0,1            No
Delivery Terms(DELIVERY_TERMS)                                0,1            No
Contract Company(CONTRACT_COMPANY)                            0,n            Yes
Company Number(COMPANY_NUMBER)                                0,n            Yes
Company Number(COMPANY_NUMBER)                                0,n            Yes
Delivery(DELIVERY)                                            0,n            No
Person(PERSON)                                                0,n            No
Person(PERSON)                                                0,n            No
Product Invoice(PRODUCT_INVOICE)                              0,n            No
Product Order(PRODUCT_ORDER)                                  0,n            No
Product Order(PRODUCT_ORDER)                                  0,n            No
Product Order(PRODUCT_ORDER)                                  0,n            No
Product Order(PRODUCT_ORDER)                                  0,n            No
Product Order(PRODUCT_ORDER)                                  0,n            No
Product Order(PRODUCT_ORDER)                                  0,n            No
QA Audit(QA_AUDIT)                                            0,n            Yes
Trip(TRIP)                                                    0,n            No
Visit(VISIT)                                                  0,n            No
Customs Declaration(CUSTOMS_DECLARATION)                      0,n            No
Service(SERVICE)                                              0,n            No
Subdocking(SUBDOCKING)                                        0,n            No
Stuffed Item(STUFFED_ITEM)                                    0,n            No
Supported Message(SUPPORTED_MESSAGE)                          0,n            No
Service Order(SERVICE_ORDER)                                  0,n            No


PowerDesigner                                                                       Page 43
Conceptual Data Model                                                                  TRIM 5_7


                             Entity                                     Card           Dep.
Stock(STOCK)                                                      0,n            No
Trip(TRIP)                                                        0,n            No
Transition(TRANSITION)                                            0,n            No
Transport Chain Type(TRANSPORT_CHAIN_TYPE)                        0,n            No
Transport Chain Type(TRANSPORT_CHAIN_TYPE)                        0,n            No
Transport Forecast(TRANSPORT_FORECAST)                            0,n            No
Transport Invoice(TRANSPORT_INVOICE)                              0,n            No
Transport Order(TRANSPORT_ORDER)                                  0,n            No
Transport Order(TRANSPORT_ORDER)                                  0,n            No
Transport Order(TRANSPORT_ORDER)                                  0,n            No
Transport Order(TRANSPORT_ORDER)                                  0,n            No
Transport Unit(TRANSPORT_UNIT)                                    0,n            No
Transport Unit(TRANSPORT_UNIT)                                    0,n            No
Transport Unit(TRANSPORT_UNIT)                                    0,n            No
Transport Unit(TRANSPORT_UNIT)                                    0,n            No
Visit(VISIT)                                                      0,n            No


Entity: Company Number
   Name:         Company Number
   Code:         COMPANY_NUMBER
   Label:        A number used by a company to identify another company
   Number:                           Generate Table:     Yes


Description
May be used by a company to have local customer numbers, supplier numbers etc.

Attribute List
          Name                               Label                        Type    I        M
Company no                   Customer no, Supplier no, etc.              A20     No       Yes


Reference List
                             Entity                                     Card           Dep.
Company(COMPANY)                                                  1,1            Yes
Company(COMPANY)                                                  1,1            Yes


Entity: Consignment
   Name:         Consignment
   Code:         CONSIGNMENT
   Label:        An identifiable amount of goods transported from one consignor to one
consignee
   Number:                            Generate Table:     Yes


Description


PowerDesigner                                                                           Page 44
Conceptual Data Model                                                                  TRIM 5_7


Transported via one or more modes of transport and specified in one single transport
document.

Synonym: Bill of lading, Waybill

Attribute List
           Name                               Label                       Type    I        M
Consignment_Id                                                           NO      Yes      Yes
Consignment_Ref_No          User defined reference number                A50     No       No
C_Priority                  User specified priority                      A10     No       No
Delivery note                                                            A50     No       No
Delivery requirements                                                    A50     No       No
Created date                                                             DT      No       No
Consignee reference                                                      A10     No       No
Full Container Load         F=Full, L= Less than full                    A1      No       No
Gross weight                                                             N10     No       No
Terms of payment                                                         A4      No       No
Insurance value                                                          A10     No       No
Notifier reference                                                       A10     No       No
Comments                                                                 A50     No       No
Forwarder remarks                                                        A50     No       No
Receipt control                                                          A10     No       No
Delivery control                                                         A10     No       No
Declaration responsible     Initials for person responsible for          A4      No       No
                            dangerous goods declaration
Payment status                                                           A10     No       No
Req_Arr_Time                Required arrival data and time               DT      No       No
C_First_Unloading_Time      Start of required unloading time window      DT      No       No
C_Last_Unloading_Time       End of required unloading time window        DT      No       No
C_First_Loading_Time        Start of required loading time window        DT      No       No
C_Last_Loading_Time         End of required loading time window          DT      No       No
Delivered date              Actual delivered date                        DT      No       No
Total price                                                              MN      No       No
SCAC code                                                                A20     No       No
No Of BSL signed                                                         I       No       No
No Of BSL copies                                                         I       No       No
Last updated                                                             DT      No       No
Last updated by                                                          A20     No       No


Reference List
                             Entity                                     Card           Dep.
Company(COMPANY)                                                  0,1            No
Company(COMPANY)                                                  0,1            No
Company(COMPANY)                                                  0,1            No
Transport Chain Type(TRANSPORT_CHAIN_TYPE)                        0,1            No
Location(LOCATION)                                                0,1            No
Location(LOCATION)                                                0,1            No
Location(LOCATION)                                                0,1            No
Consignment Order(CONSIGNMENT_ORDER)                              0,n            Yes


PowerDesigner                                                                           Page 45
Conceptual Data Model                                                                    TRIM 5_7


                        Entity                                           Card            Dep.
Consignment Shipment(CONSIGNMENT_SHIPMENT)                         0,n             Yes
Delivery(DELIVERY)                                                 0,n             No


Entity: Consignment Order
   Name:         Consignment Order
   Code:         CONSIGNMENT_ORDER
   Label:        A connection between a consignment and a transport order
   Number:                          Generate Table:      Yes


Reference List
                        Entity                                           Card            Dep.
Consignment(CONSIGNMENT)                                           1,1             Yes
Transport Order(TRANSPORT_ORDER)                                   1,1             Yes


Entity: Consignment Shipment
   Name:         Consignment Shipment
   Code:         CONSIGNMENT_SHIPMENT
   Label:        A combination of a consignment and a transport unit shipment
   Number:                           Generate Table:      Yes


Reference List
                          Entity                                         Card          Dep.
Consignment(CONSIGNMENT)                                           1,1             Yes
Transport Unit Shipment(TRANSPORT_UNIT_SHIPMENT)                   1,1             Yes


Entity: Contract
   Name:         Contract
   Code:         CONTRACT
   Label:        An agreement of subcontractor services; transport, storage handling etc.
   Number:                           Generate Table:       Yes


Attribute List
           Name                                Label                       Type     I        M
Contract id                                                               NO       Yes      Yes
Contract name                                                             A25      No       No
Option date                                                               D        No       No
Declaration date                                                          D        No       No
Contract expire date                                                      D        No       No
Contract min quantity                                                     DC15,7   No       No
Contract max quantity                                                     DC15,7   No       No
Contract min lot size                                                     DC15,7   No       No


PowerDesigner                                                                             Page 46
Conceptual Data Model                                                                  TRIM 5_7


          Name                                  Label                     Type   I         M
Contract max lot size                                                    DC15,7 No        No
Nomination time                                                          DC5,2 No         No
Remark                                                                   A255   No        No


Reference List
                          Entity                                        Card           Dep.
Service Group(SERVICE_GROUP)                                      0,1            No
Currency(CURRENCY)                                                0,1            No
Unit of Measure(UNIT_OF_MEASURE)                                  0,1            No
Unit of Measure(UNIT_OF_MEASURE)                                  0,1            No
Contract Company(CONTRACT_COMPANY)                                0,n            Yes
Transport Unit Shipment(TRANSPORT_UNIT_SHIPMENT)                  0,n            No
Contract Type(CONTRACT_TYPE)                                      0,1            No
Transport Unit(TRANSPORT_UNIT)                                    0,1            No
Service(SERVICE)                                                  0,n            No
Transport Order(TRANSPORT_ORDER)                                  0,n            No


Entity: Contract Company
   Name:         Contract Company
   Code:         CONTRACT_COMPANY
   Label:        A connection between a contract and a company
   Number:                          Generate Table:       Yes


Reference List
                             Entity                                     Card           Dep.
Contract(CONTRACT)                                                1,1            Yes
Company(COMPANY)                                                  1,1            Yes


Entity: Contract Type
   Name:         Contract Type
   Code:         CONTRACT_TYPE
   Label:        A class of contracts
   Number:                              Generate Table:   Yes


Attribute List
          Name                                 Label                      Type    I        M
C_T_Id                       System generated unique identifier          LI      Yes      Yes
C_T_Name                     User specified unique name                  A50     No       Yes
C_T_Description                                                          A200    No       No


Reference List
                             Entity                                     Card           Dep.


PowerDesigner                                                                           Page 47
Conceptual Data Model                                                               TRIM 5_7


                             Entity                                  Card           Dep.
Contract(CONTRACT)                                             0,n            No


Entity: Country
   Name:         Country
   Code:         COUNTRY
   Label:        A geograhical area with a common government, according to UN/LOCODE.
   Number:                           Generate Table:    Yes


Attribute List
          Name                                Label                    Type    I        M
Country code                                                          A2      Yes      Yes
Country name                                                          A25     No       No
NATO code                                                             A10     No       No
Customs code                                                          A10     No       No


Reference List
                             Entity                                  Card           Dep.
Currency(CURRENCY)                                             0,1            No
Company(COMPANY)                                               0,n            No
Goods Item(GOODS_ITEM)                                         0,n            No
Location(LOCATION)                                             0,n            No
Load Unit(LOAD_UNIT)                                           0,n            No
Vessel(VESSEL)                                                 0,n            No


Entity: Currency
   Name:         Currency
   Code:         CURRENCY
   Label:        Money that is in use in a country
   Number:                             Generate Table:   Yes


Attribute List
          Name                                Label                    Type    I        M
Currency code                                                         A3      Yes      Yes
Currency name                                                         A35     No       No


Reference List
                      Entity                                         Card           Dep.
Actual Cost(ACTUAL_COST)                                       0,n            No
Country(COUNTRY)                                               0,n            No
Contract(CONTRACT)                                             0,n            No
Company(COMPANY)                                               0,n            No
Currency Value(CURRENCY_VALUE)                                 0,n            Yes


PowerDesigner                                                                        Page 48
Conceptual Data Model                                                                 TRIM 5_7


                          Entity                                       Card           Dep.
Freight Cost Element(FREIGHT_COST_ELEMENT)                       0,n            No
Price Element(PRICE_ELEMENT)                                     0,n            No
Transport Order(TRANSPORT_ORDER)                                 0,n            No


Entity: Currency Value
   Name:         Currency Value
   Code:         CURRENCY_VALUE
   Label:        Currency values with valid dates
   Number:                           Generate Table:      Yes


Attribute List
          Name                                Label                      Type   I         M
CV valid from date                                                      D      Yes       Yes
Exchange rate                                                           DC15,7 No        No


Reference List
                             Entity                                    Card           Dep.
Currency(CURRENCY)                                               1,1            Yes


Entity: Customs Declaration
   Name:         Customs Declaration
   Code:         CUSTOMS_DECLARATION
   Label:        A declaration of goods for export/import.
   Number:                            Generate Table:      Yes


Description
Information related to customs.

Attribute List
          Name                                Label                      Type    I        M
Customs decl no                                                         A10     Yes      Yes
Community code                                                          A2      No       No
Customs approval no                                                     N10     No       No
Approval date                                                           DT      No       No
Agent ref no                                                            A40     No       No


Reference List
                          Entity                                       Card           Dep.
Transport Unit Shipment(TRANSPORT_UNIT_SHIPMENT)                 0,n            No
Company(COMPANY)                                                 0,1            No




PowerDesigner                                                                          Page 49
Conceptual Data Model                                                                TRIM 5_7


Entity: Damaged part
   Name:         Damaged part
   Code:         DAMAGED_PART
   Label:        A load unit part which has been damaged.
   Number:                            Generate Table:     Yes


Attribute List
          Name                                Label                      Type    I       M
Damaged part id                                                         A10     Yes     Yes


Reference List
                         Entity                                        Card          Dep.
Load Unit Condition(LOAD_UNIT_CONDITION)                         0,1            No


Entity: Dangerous Goods Info
   Name:         Dangerous Goods Info
   Code:         DANGEROUS_GOODS_INFO
   Label:        Parameters describing a dangerous goods cathegory.
   Number:                           Generate Table:      Yes


Attribute List
          Name                                  Label                    Type    I       M
DG id                        Identifies a cathegory of dangerous        NO      Yes     Yes
                             goods. System generated.
DG name                      User-defined name of dangerous goods       A30     No      No
                             cathegory
UN no                                                                   A4      No      No
IMDG PSN                                                                A200    No      No
ADR national PSN                                                        A200    No      No
ADR internat PSN                                                        A200    No      No
RID PSN                                                                 A200    No      No
IMDG chemtech name                                                      A200    No      No
ADR national chemtech                                                   A200    No      No
name
ADR internat chemtech                                                   A200    No      No
name
RID chemtech name                                                       A200    No      No
IMDG class                                                              A5      No      No
ADR class                                                               A13     No      No
Package group                                                           A3      No      No
Subs hazard                                                             A13     No      No
Flash point                                                             A13     No      No
Marine pollutant                                                        BL      No      No
Emergency proc                                                          A6      No      No
Medical first aid                                                       A100    No      No


PowerDesigner                                                                         Page 50
Conceptual Data Model                                                                    TRIM 5_7


          Name                                   Label                       Type    I       M
Stowage arrangement                                                         A30     No      No
Info PSN                      Additional information to PSN                 A50     No      No
Control temperature                                                         F       No      No
Emergency temperature                                                       F       No      No
Temerature type               Control and emergency temperatures            A1      No      No
                              given in: C = Celsius or F= Fahrenheit
Spesial info                  Info about temperatures and radioactivity A200        No      No
Spesial info declaration      Info about goods item in a appropiate     A200        No      No
                              language
Radionuklide name                                                       A50         No      No
Radiation activity                                                      A20         No      No
Colli cathegory                                                         A3          No      No
Transport index                                                         I           No      No
IMDG text                     Complete IMDG dangerous goods text        A500        No      No
                              string
ADR national text             Complete ADR national text string         A500        No      No
ADR internat text             Complete ADR international text string    A500        No      No
RID text                      Complete RID text string                  A500        No      No


Reference List
                              Entity                                       Card          Dep.
Goods Item(GOODS_ITEM)                                               0,n            No


Entity: Delivery
   Name:         Delivery
   Code:         DELIVERY
   Label:        A delivery of a part of an order, or the complete order.
   Number:                             Generate Table:       Yes


Description
A part delivery gives reference to the goods which should be delivered to a customer.

Attribute List
          Name                                   Label                   Type        I       M
Delivery_No                   Identifies a part delivery                LI          Yes     Yes
Delivery_Ref_No                                                         A20         No      No
Delivery_Status               Status of the part delivery               A1          No      No
Required_Delivery_Time        Required or planned time for the delivery DT          No      No
Invoice_No                    Goods invoice no                          A20         No      No


Reference List
                              Entity                                       Card          Dep.
Company(COMPANY)                                                     1,1            No
Consignment(CONSIGNMENT)                                             0,1            No


PowerDesigner                                                                             Page 51
Conceptual Data Model                                                               TRIM 5_7


                         Entity                                       Card          Dep.
Product Order(PRODUCT_ORDER)                                    0,1            No
Transport Unit Type(TRANSPORT_UNIT_TYPE)                        0,1            No
Person(PERSON)                                                  0,1            No
Transport Order(TRANSPORT_ORDER)                                0,1            No
Goods Item(GOODS_ITEM)                                          0,n            No


Entity: Delivery Terms
   Name:         Delivery Terms
   Code:         DELIVERY_TERMS
   Label:        Terms of delivery. IMO approved.
   Number:                            Generate Table:     Yes


Attribute List
          Name                                  Label                   Type    I       M
DT code                                                                A3      Yes     Yes
DT name                                                                A25     No      No
IMO approved                                                           A1      No      No


Reference List
                         Entity                                       Card          Dep.
Company(COMPANY)                                                0,n            No
Transport Chain Type(TRANSPORT_CHAIN_TYPE)                      0,n            No


Entity: Departure
   Name:         Departure
   Code:         DEPARTURE
   Label:        The start of a trip
   Number:                              Generate Table:   Yes


Attribute List
          Name                                  Label                   Type    I       M
Departure id                                                           LI      Yes     Yes
Departure time planned                                                 DT      No      No
Departure time estimate                                                DT      No      No
Departure time actual                                                  DT      No      No
Loading time                                                           DT      No      No
Working labour required                                                A10     No      No
Cranes required                                                        A10     No      No
Equipment required                                                     A10     No      No


Reference List
                               Entity                                 Card          Dep.


PowerDesigner                                                                        Page 52
Conceptual Data Model                                                                   TRIM 5_7


                              Entity                                     Card           Dep.
Location(LOCATION)                                                 0,1             No
Visit(VISIT)                                                       0,1             No
Trip(TRIP)                                                         1,1             No
Transport Unit Loaded(TRANSPORT_UNIT_LOADED)                       0,n             No


Entity: Driver Card
  Name:          Driver Card
  Code:          DRIVER_CARD
  Label:         Information about a Smart Card issued by the Vehicle Administration
Authorities.
  Number:                              Generate Table:      Yes


Attribute List
          Name                                Label                         Type    I       M
Card no                      A unique card number                         I        Yes     Yes
Holders name                 The holders name when the card was           A30      No      No
                             created
Card status                  Values: Active, Closed                   A10          No      No
Authorized                                                            A1           No      No
Creation date                Date and time when the card was created. DT           No      No
Closing date                 Date and time when the card was closed. DT            No      No
Closing reason               Values: Lost, stolen, damaged, etc.      A30          No      No
Unauthorizing date           Date and time when the card was          A10          No      No
                             unauthorized.


Reference List
                       Entity                                            Card           Dep.
AEI reading(AEI_READING)                                           0,n             No
Person(PERSON)                                                     1,1             No


Entity: Freight Cost Adjustment
   Name:         Freight Cost Adjustment
   Code:         FREIGHT_COST_ADJUSTMENT
   Label:        A freight cost addition/reduction, in percent.
   Number:                             Generate Table:       Yes


Attribute List
          Name                                  Label                      Type   I         M
FCA id                                                                    NO     Yes       Yes
FCA valid date                                                            D      No        No
FCA percent value                                                         DC15,7 No        No




PowerDesigner                                                                            Page 53
Conceptual Data Model                                                                    TRIM 5_7


Reference List
                          Entity                                           Card          Dep.
Freight Cost Element(FREIGHT_COST_ELEMENT)                           0,1            No


Entity: Freight Cost Element
   Name:         Freight Cost Element
   Code:         FREIGHT_COST_ELEMENT
   Label:        A basic unit of freight cost, specified by consignor.
   Number:                             Generate Table:        Yes


Attribute List
          Name                                  Label                        Type    I       M
FCE no                                                                      LI      Yes     Yes
FCE name                                                                    A25     No      No


Reference List
                           Entity                                          Card          Dep.
Actual Cost(ACTUAL_COST)                                             0,n            No
Freight Cost Adjustment(FREIGHT_COST_ADJUSTMENT)                     0,n            No
Currency(CURRENCY)                                                   0,1            No
Unit of Measure(UNIT_OF_MEASURE)                                     0,1            No
Service Group(SERVICE_GROUP)                                         0,1            No
Price Adjustment Factor(PRICE_ADJUSTMENT_FACTOR)                     0,n            No
Price Element(PRICE_ELEMENT)                                         0,n            No
Transport Order(TRANSPORT_ORDER)                                     0,n            No


Entity: Goods Group
   Name:         Goods Group
   Code:         GOODS_GROUP
   Label:        A class of goods, according to EC Dir., Annex III
   Number:                            Generate Table:      Yes


Attribute List
          Name                                  Label                        Type    I       M
GG code                                                                     A2      Yes     Yes
GG description                                                              A30     No      No


Reference List
                              Entity                                       Card          Dep.
Goods Item(GOODS_ITEM)                                               0,n            No


Entity: Goods Item

PowerDesigner                                                                             Page 54
Conceptual Data Model                                                                   TRIM 5_7


   Name:         Goods Item
   Code:         GOODS_ITEM
   Label:        A separately identifiable quantity of goods
   Number:                             Generate Table:       Yes


Description
A goods item may be a single package, or a number of packages with the same characteristics.

Attribute List
          Name                                  Label                       Type    I       M
Goods item id                                                             A20      Yes     Yes
Description                                                               A50      No      No
Goods weight                 Quantity despatched by seller                I        No      No
Delivery gross weight        Quantity required by buyer                   I        No      No
Net weight                                                                A20      No      No
No of packages                                                            A10      No      No
Volume                                                                    A10      No      No
Length                                                                    I        No      No
Width                                                                     I        No      No
Height                                                                    DC10     No      No
Dimension info                                                            A100     No      No
Mark                                                                      A50      No      No
Quality certificate                                                       A100     No      No
Grade                                                                     A50      No      No
Heat no                                                                   A50      No      No


Reference List
                          Entity                                         Card           Dep.
AEI reading(AEI_READING)                                           0,n             No
Goods Group(GOODS_GROUP)                                           0,1             No
Dangerous Goods Info(DANGEROUS_GOODS_INFO)                         0,1             No
Goods Type(GOODS_TYPE)                                             0,1             No
Delivery(DELIVERY)                                                 0,1             No
Lot(LOT)                                                           0,1             No
Country(COUNTRY)                                                   0,1             No
Product Order Line(PRODUCT_ORDER_LINE)                             0,1             No
Package Type(PACKAGE_TYPE)                                         0,1             No
Unit of Measure(UNIT_OF_MEASURE)                                   0,1             No
Stuffed Item(STUFFED_ITEM)                                         0,n             No
Transport Invoice Line(TRANSPORT_INVOICE_LINE)                     0,n             No


Entity: Goods Type
   Name:         Goods Type
   Code:         GOODS_TYPE
   Label:        A class of goods
   Number:                            Generate Table:        Yes


PowerDesigner                                                                            Page 55
Conceptual Data Model                                                                   TRIM 5_7




Attribute List
          Name                                 Label                       Type     I       M
GT id                                                                     A10      Yes     Yes
GT name                                                                   A30      No      No
Cargo due per ton                                                         MN10     No      No
Customs quategory                                                         A10      No      No


Reference List
                              Entity                                     Card           Dep.
Goods Item(GOODS_ITEM)                                             0,n             No


Entity: Leg
   Name:         Leg
   Code:         LEG
   Label:        The distance between two locations
   Number:                           Generate Table:       Yes


Attribute List
          Name                                 Label                       Type     I       M
Leg_Id                                                                    NO       Yes     Yes
Distance_km                  Measured distance                            DC10,2   No      No
Manuel_Distance              Manuel estimated distance in km              DC10,2   No      No
Max_Speed                    Maximum speed limit for the leg              A20      No      No


Reference List
                              Entity                                     Card           Dep.
Location(LOCATION)                                                 1,1             No
Location(LOCATION)                                                 1,1             No


Entity: Load Unit
  Name:          Load Unit
  Code:          LOAD_UNIT
  Label:         A cargo transportation unit which may be oaded on a vessel, vehicle or train
wagon.
  Number:                              Generate Table:     No


Attribute List
          Name                                 Label                       Type     I       M
Customs warning flag         An indicator for customs inspection          A3       No      No




PowerDesigner                                                                            Page 56
Conceptual Data Model                                                                   TRIM 5_7


Reference List
                         Entity                                          Card           Dep.
AEI reading(AEI_READING)                                           0,n            No
Country(COUNTRY)                                                   0,1            No
Load Unit Condition(LOAD_UNIT_CONDITION)                           0,n            No
Load Unit Lane(LOAD_UNIT_LANE)                                     0,n            Yes


Entity: Load Unit Condition
   Name:         Load Unit Condition
   Code:         LOAD_UNIT_CONDITION
   Label:        The physical status of a load unit.
   Number:                             Generate Table:     Yes


Description
The physical status of a load unit.

Attribute List
          Name                                Label                   Type         I        M
LUC id                        System generated unique identifier     NO           Yes      Yes
LUC Time                                                             DT           No       No
Description                                                          A50          No       No
Created by                    Person/Company which created condition A40          No       No
                              information


Reference List
                     Entity                                              Card           Dep.
Damaged part(DAMAGED_PART)                                         0,n            No
Location(LOCATION)                                                 0,1            No
Load Unit(LOAD_UNIT)                                               1,1            No


Entity: Load Unit Lane
   Name:         Load Unit Lane
   Code:         LOAD_UNIT_LANE
   Label:        A specific waiting que for a load unit.
   Number:                            Generate Table:      Yes


Description
A specific waiting que for a load unit.

Attribute List
          Name                                 Label                       Type    I        M
LUL Time                                                                  DT      Yes      Yes
Lane no                                                                   A10     No       No


PowerDesigner                                                                            Page 57
Conceptual Data Model                                                                 TRIM 5_7




Reference List
                             Entity                                    Card           Dep.
Load Unit(LOAD_UNIT)                                             1,1            Yes


Entity: Location
   Name:         Location
   Code:         LOCATION
   Label:        A geographic place in a country, according to UN/LOCODE
   Number:                            Generate Table:      Yes


Attribute List
          Name                                Label                      Type    I        M
Location id                 System generated unique identifier          LI      Yes      Yes
Location code               According to UN/LOCODE with 5               A17     No       No
                            location levels
Location alt code           Alternative numeric code ; e.g. account     A15     No       No
                            number for this location
Location name                                                           A25     No       No
Longitude                   code:degrees:minutes:seconds                A50     No       No
Lattitude                   code:degrees:minutes:seconds                A50     No       No
Altitude                    In meters                                   A20     No       No
Perimeter                   code:degrees:minutes:seconds                A50     No       No
Wait_Time                   Mean waiting time for transport means.      DT      No       No
                            Ex.: Anchorage areas, terminals etc.


Reference List
                         Entity                                        Card           Dep.
Arrival(ARRIVAL)                                                 0,n            No
AEI reading(AEI_READING)                                         0,n            No
Company(COMPANY)                                                 0,n            No
Consignment(CONSIGNMENT)                                         0,n            No
Consignment(CONSIGNMENT)                                         0,n            No
Consignment(CONSIGNMENT)                                         0,n            No
Departure(DEPARTURE)                                             0,n            No
Location(LOCATION)                                               0,1            No
Country(COUNTRY)                                                 0,1            No
Location Type(LOCATION_TYPE)                                     0,n            No
Leg(LEG)                                                         0,n            No
Price Header(PRICE_HEADER)                                       0,1            No
Leg(LEG)                                                         0,n            No
Load Unit Condition(LOAD_UNIT_CONDITION)                         0,n            No
Object Location(OBJECT_LOCATION)                                 0,n            No
Product Invoice(PRODUCT_INVOICE)                                 0,n            No
Product Order(PRODUCT_ORDER)                                     0,n            No
Quay Usage(QUAY_USAGE)                                           0,n            No


PowerDesigner                                                                          Page 58
Conceptual Data Model                                                                         TRIM 5_7


                               Entity                                           Card          Dep.
Service(SERVICE)                                                          0,n            No
Service(SERVICE)                                                          0,n            No
Stuffed Item(STUFFED_ITEM)                                                0,n            No
Transport Chain Type(TRANSPORT_CHAIN_TYPE)                                0,n            No
Transport Chain Type(TRANSPORT_CHAIN_TYPE)                                0,n            No
Transport Invoice(TRANSPORT_INVOICE)                                      0,n            No
Transport Unit Loaded(TRANSPORT_UNIT_LOADED)                              0,n            No


Entity: Location Type
   Name:         Location Type
   Code:         LOCATION_TYPE
   Label:        A class of locations; regions, cities, terminals, etc.
   Number:                              Generate Table:       Yes


Attribute List
          Name                                    Label                           Type    I       M
Location type code                                                               A3      Yes     Yes
Location type name                                                               A25     No      No


Reference List
                               Entity                                           Card          Dep.
Location(LOCATION)                                                        0,n            No


Entity: Lot
   Name:         Lot
   Code:         LOT
   Label:        An actual produced quantity of a product
   Number:                           Generate Table:      Yes


Attribute List
          Name                                    Label                           Type    I       M
Lot id                                                                           A10     Yes     Yes


Reference List
                               Entity                                           Card          Dep.
Goods Item(GOODS_ITEM)                                                    0,n            No
Product(PRODUCT)                                                          0,1            No


Entity: Message Type
   Name:         Message Type


PowerDesigner                                                                                  Page 59
Conceptual Data Model                                                                     TRIM 5_7


   Code:         MESSAGE_TYPE
   Label:        Type of conceptual message which trigger a transition or is activated by a
transition
   Number:                             Generate Table:      Yes


Attribute List
          Name                                  Label                        Type    I        M
MT id                         Identifies an conceptual message type         LI      Yes      Yes
MT name                                                                     A30     No       No


Reference List
                              Entity                                       Card           Dep.
Action(ACTION)                                                       0,n            No
Supported Message(SUPPORTED_MESSAGE)                                 0,n            No
Transition(TRANSITION)                                               0,n            No


Entity: Mode of Transport
   Name:         Mode of Transport
   Code:         MODE_OF_TRANSPORT
   Label:        An IMO transport method
   Number:                          Generate Table:         Yes


Attribute List
          Name                                  Label                        Type    I        M
Mode code                                                                   N3      Yes      Yes
Mode name                                                                   A25     No       No


Reference List
                         Entity                                            Card           Dep.
Service Mode(SERVICE_MODE)                                           0,n            Yes
Transport Unit Type(TRANSPORT_UNIT_TYPE)                             0,n            No


Entity: Object
   Name:         Object
   Code:         OBJECT
   Label:        A physical thing; Building, equipment, lighthouse
   Number:                            Generate Table:       Yes


Attribute List
          Name                                  Label                        Type    I        M
Object no                                                                   LI      Yes      Yes
Object name                                                                 A15     No       No


PowerDesigner                                                                              Page 60
Conceptual Data Model                                                               TRIM 5_7


          Name                                Label                    Type     I       M
Description                                                           A50      No      No
GB no                                                                 A20      No      No
Object type                                                           A10      No      No


Reference List
                        Entity                                       Card           Dep.
Price Header(PRICE_HEADER)                                     0,1             No
Object Location(OBJECT_LOCATION)                               0,n             No


Entity: Object Location
   Name:         Object Location
   Code:         OBJECT_LOCATION
   Label:        A location for an object.
   Number:                             Generate Table:   Yes


Attribute List
          Name                                Label                    Type     I       M
OL no                                                                 NO       Yes     Yes


Reference List
                             Entity                                  Card           Dep.
Location(LOCATION)                                             1,1             No
Object(OBJECT)                                                 1,1             No


Entity: Package Code
   Name:         Package Code
   Code:         PACKAGE_CODE
   Label:        A detailed cargo package cathegory
   Number:                            Generate Table:    Yes


Attribute List
          Name                                Label                    Type     I       M
Package code                                                          A10      Yes     Yes
Package name                                                          A35      No      No
Length overall                                                        DC15,7   No      No
Package draft                                                         DC15,7   No      No
Breadth                                                               DC15,7   No      No
Volume capacity                                                       DC15,7   No      No
Weight capacity                                                       DC15,7   No      No
Quantum capacity                                                      DC15,7   No      No




PowerDesigner                                                                        Page 61
Conceptual Data Model                                                                 TRIM 5_7


Reference List
                         Entity                                         Card          Dep.
Packaging Material(PACKAGING_MATERIAL)                            0,1            No
Package Type(PACKAGE_TYPE)                                        0,1            No
Transport Unit Type(TRANSPORT_UNIT_TYPE)                          0,1            No
Product Order Line(PRODUCT_ORDER_LINE)                            0,n            No


Entity: Package Group Type
   Name:         Package Group Type
   Code:         PACKAGE_GROUP_TYPE
   Label:        A set of packages, includes IMO codes; e.g. box, drum, bag, bulk
   Number:                             Generate Table:     Yes


Attribute List
          Name                                 Label                      Type       I      M
PGT code                                                                 N1         Yes    Yes
PGT alpha code                                                           A2         No     No
PGT name                                                                 A25        No     No
PGT description                                                          A255       No     No


Reference List
                      Entity                                            Card          Dep.
Package Type(PACKAGE_TYPE)                                        0,n            No


Entity: Package Type
   Name:         Package Type
   Code:         PACKAGE_TYPE
   Label:        A cargo package cathegory, includes IMO codes; e.g. small box, medium box
   Number:                           Generate Table:     Yes


Attribute List
          Name                               Label                        Type       I      M
PT id                        System generated iunique dentifier          LI         Yes    Yes
PT Code                                                                  N1         No     No
PT alpha code                                                            A2         No     No
PT name                                                                  A25        No     No


Reference List
                             Entity                                     Card          Dep.
Goods Item(GOODS_ITEM)                                            0,n            No
Package Code(PACKAGE_CODE)                                        0,n            No
Package Group Type(PACKAGE_GROUP_TYPE)                            1,1            No
Service(SERVICE)                                                  0,n            No


PowerDesigner                                                                             Page 62
Conceptual Data Model                                                                 TRIM 5_7


                         Entity                                         Card          Dep.
Transport Chain Type(TRANSPORT_CHAIN_TYPE)                        0,n            No


Entity: Packaging Material
   Name:         Packaging Material
   Code:         PACKAGING_MATERIAL
   Label:        A packaging material code according to IMO; e.g. wood, metal, plastic, paper
   Number:                           Generate Table:      Yes


Attribute List
          Name                                 Label                      Type    I       M
PM code                                                                  N1      Yes     Yes
PM name                                                                  A25     No      No
PM description                                                           A255    No      No


Reference List
                         Entity                                         Card          Dep.
Package Code(PACKAGE_CODE)                                        0,n            No
Service(SERVICE)                                                  0,n            No
Transport Chain Type(TRANSPORT_CHAIN_TYPE)                        0,n            No


Entity: Person
   Name:         Person
   Code:         PERSON
   Label:        A male or female
   Number:                           Generate Table:      Yes


Attribute List
           Name                                Label                      Type    I       M
Person id                                                                A20     Yes     Yes
Person name                                                              A175    No      No
Birth year                                                               A10     No      No
Sex code                                                                 A1      No      No
Phone no                                                                 A20     No      No


Reference List
                       Entity                                           Card          Dep.
Booked Driver(BOOKED_DRIVER)                                      0,n            No
Delivery(DELIVERY)                                                0,n            No
Driver Card(DRIVER_CARD)                                          0,n            No
Company(COMPANY)                                                  0,1            No
Company(COMPANY)                                                  0,1            No
Product Order(PRODUCT_ORDER)                                      0,n            No


PowerDesigner                                                                          Page 63
Conceptual Data Model                                                                TRIM 5_7


                       Entity                                          Card          Dep.
Transport Means(TRANSPORT_MEANS)                                 0,n            No
Trip(TRIP)                                                       0,n            No


Entity: Physical Message
   Name:         Physical Message
   Code:         PHYSICAL_MESSAGE
   Label:        A physical message type; ex: IFTMIN, COARRI
   Number:                           Generate Table:    Yes


Attribute List
          Name                                 Label                     Type    I       M
Phy m id                                                                NO      Yes     Yes
Phy m name                                                              A40     No      No
Phy m version                                                           A10     No      No


Reference List
                        Entity                                         Card          Dep.
Supported Message(SUPPORTED_MESSAGE)                             0,n            No


Entity: Postal Area
   Name:         Postal Area
   Code:         POSTAL_AREA
   Label:        A geographical area
   Number:                             Generate Table:     Yes


Attribute List
          Name                                 Label                     Type    I       M
Postal Code                                                             A10     No      No


Reference List
                              Entity                                   Card          Dep.
Company(COMPANY)                                                 0,n            No


Entity: Price Adjustment Factor
   Name:         Price Adjustment Factor
   Code:         PRICE_ADJUSTMENT_FACTOR
   Label:        A price addition/reduction, in percent.
   Number:                            Generate Table:      Yes




PowerDesigner                                                                         Page 64
Conceptual Data Model                                                                        TRIM 5_7


Attribute List
          Name                                   Label                         Type     I        M
PAF seq no                                                                     I       Yes      Yes
Adjustment type                                                                A20     No       No
Percent                                                                        DC4,2   No       No


Reference List
                          Entity                                            Card             Dep.
Freight Cost Element(FREIGHT_COST_ELEMENT)                            0,1              No
Price Element(PRICE_ELEMENT)                                          1,1              Yes


Entity: Price Element
   Name:         Price Element
   Code:         PRICE_ELEMENT
   Label:        A basic price unit, date specific.
   Number:                             Generate Table:        Yes


Attribute List
           Name                                  Label                           Type  I         M
PE seq no                     Sequence number                                  I      Yes       Yes
Price value                                                                    DC15,7 No        No


Reference List
                           Entity                                           Card             Dep.
Price Adjustment Factor(PRICE_ADJUSTMENT_FACTOR)                      0,n              Yes
Freight Cost Element(FREIGHT_COST_ELEMENT)                            0,1              No
Price Header(PRICE_HEADER)                                            1,1              Yes
Currency(CURRENCY)                                                    0,1              No
Unit of Measure(UNIT_OF_MEASURE)                                      0,1              No


Entity: Price Header
   Name:         Price Header
   Code:         PRICE_HEADER
   Label:        Identifies a valid time period for a set of price elements.
   Number:                              Generate Table:        Yes


Attribute List
          Name                                   Label                          Type    I        M
PH id                                                                          NO      Yes      Yes
PH valid from date                                                             DT      No       No
Expire date                                                                    DT      No       No




PowerDesigner                                                                                 Page 65
Conceptual Data Model                                                                          TRIM 5_7


Reference List
                              Entity                                           Card            Dep.
Location(LOCATION)                                                       0,n             No
Object(OBJECT)                                                           0,n             No
Price Element(PRICE_ELEMENT)                                             0,n             Yes
Chain Operation Type(CHAIN_OPERATION_TYPE)                               0,1             No
Service(SERVICE)                                                         0,1             No
Transport Unit Shipment(TRANSPORT_UNIT_SHIPMENT)                         0,1             No
Service Order(SERVICE_ORDER)                                             0,n             No


Entity: Product
   Name:         Product
   Code:         PRODUCT
   Label:        A class of articles, materials or natural substances.
   Number:                             Generate Table:        Yes


Attribute List
           Name                                  Label                           Type     I        M
Product id                                                                      A10      Yes      Yes
P EAN item no                                                                   A35      No       No
P Suppliers article no                                                          A35      No       No
P Item description                                                              A100     No       No


Reference List
                              Entity                                           Card            Dep.
Lot(LOT)                                                                 0,n             No
Product Order Line(PRODUCT_ORDER_LINE)                                   0,n             No
Stock(STOCK)                                                             0,n             No
Transport Chain Type(TRANSPORT_CHAIN_TYPE)                               0,n             No


Entity: Product Invoice
   Name:         Product Invoice
   Code:         PRODUCT_INVOICE
   Label:        A request for payment of a product order
   Number:                           Generate Table:      Yes


Attribute List
           Name                                  Label                            Type    I        M
PI id                                                                           I        Yes      Yes
PI invoice date                                                                 DT       No       No
PI payment date                                                                 DT       No       No
PI text                                                                         A100     No       No
PI total charges                                                                MN       No       No



PowerDesigner                                                                                   Page 66
Conceptual Data Model                                                                  TRIM 5_7


Reference List
                             Entity                                     Card           Dep.
Company(COMPANY)                                                  0,1            No
Product Order(PRODUCT_ORDER)                                      0,1            No
Location(LOCATION)                                                0,1            No
Transport Unit Type(TRANSPORT_UNIT_TYPE)                          0,1            No
Product Invoice Line(PRODUCT_INVOICE_LINE)                        0,n            No


Entity: Product Invoice Line
   Name:         Product Invoice Line
   Code:         PRODUCT_INVOICE_LINE
   Label:        An item in a product invoice
   Number:                            Generate Table:     Yes


Attribute List
           Name                               Label                       Type    I        M
PIL id                                                                   I       Yes      Yes
PIL Invoiced quantity                                                    I       No       No
PIL Quantity difference                                                  I       No       No
PIL Change reason                                                        A35     No       No
PIL Monetary amount                                                      I       No       No
PIL No of packages                                                       I       No       No
PIL Taxable amount                                                       I       No       No
PIL Total line amount                                                    I       No       No


Reference List
                        Entity                                          Card           Dep.
Product Invoice(PRODUCT_INVOICE)                                  0,1            No
Product Order Line(PRODUCT_ORDER_LINE)                            0,1            No


Entity: Product Order
   Name:         Product Order
   Code:         PRODUCT_ORDER
   Label:        A request for purchase or quote of goods
   Number:                            Generate Table:     Yes


Description
Subtypes are: Quote, Quote request, product order, delivery order, delivery schedule

Attribute List
          Name                                Label                       Type    I        M
PO id                                                                    LI      Yes      Yes
PO subtype                   Subtypes are: Quote, Quote requeste etc.    A10     No       No


PowerDesigner                                                                           Page 67
Conceptual Data Model                                                              TRIM 5_7


           Name                               Label                    Type    I       M
Order date                                                            DT      No      No
PO Expire date                                                        DT      No      No
PO shipping date                                                      DT      No      No
PO effective date                                                     DT      No      No
PO Invoice date                                                       DT      No      No
PO Requested delivery                                                 DT      No      No
date
PO Actual delivery date                                              DT       No      No
PO Consignor order no                                                A20      No      No
PO Consignee order no                                                A20      No      No
PO Consignee order date                                              DT       No      No
PO text                                                              A100     No      No
VAT registration no                                                  A20      No      No
PO Payment condition         Codes: Direct payment, payment to bank, A3       No      No
                             etc.
PO payment means code        Codes: Cash, bank account, cheque, etc. A3       No      No
PO payment terms                                                     A100     No      No
PO Payment due date                                                  DT       No      No


Reference List
                             Entity                                  Card          Dep.
Delivery(DELIVERY)                                             0,n            No
Product Invoice(PRODUCT_INVOICE)                               0,n            No
Company(COMPANY)                                               0,1            No
Person(PERSON)                                                 0,1            No
Company(COMPANY)                                               0,1            No
Location(LOCATION)                                             0,1            No
Company(COMPANY)                                               0,1            No
Product Order(PRODUCT_ORDER)                                   0,1            No
Transport Chain Type(TRANSPORT_CHAIN_TYPE)                     0,1            No
Company(COMPANY)                                               0,1            No
Company(COMPANY)                                               0,1            No
Company(COMPANY)                                               0,1            No
Product Order Line(PRODUCT_ORDER_LINE)                         0,n            No


Entity: Product Order Line
   Name:         Product Order Line
   Code:         PRODUCT_ORDER_LINE
   Label:        A line in a product order.
   Number:                             Generate Table:   Yes


Attribute List
          Name                                Label                    Type    I       M
POL id                                                                I       Yes     Yes
Measurement unit                                                      A3      No      No



PowerDesigner                                                                       Page 68
Conceptual Data Model                                                              TRIM 5_7


           Name                               Label                   Type    I        M
Ordered quantity                                                     N15     No       No
POL Delivered quantity                                               N15     No       No
Price type                                                           A3      No       No
Net unit price                                                       MN15    No       No
Gross unit price                                                     MN15    No       No
Discount price                                                       MN15    No       No
Cash amount                  Cash on delivery amount                 MN15    No       No
Customs value                                                        MN15    No       No


Reference List
                             Entity                                 Card           Dep.
Goods Item(GOODS_ITEM)                                        0,n            No
Product Invoice Line(PRODUCT_INVOICE_LINE)                    0,n            No
Product Order(PRODUCT_ORDER)                                  1,1            No
Product(PRODUCT)                                              0,1            No
Package Code(PACKAGE_CODE)                                    0,1            No
Unit of Measure(UNIT_OF_MEASURE)                              0,1            No


Entity: QA Audit
   Name:         QA Audit
   Code:         QA_AUDIT
   Label:        QA audit results
   Number:                            Generate Table:   Yes


Attribute List
           Name                               Label                   Type    I        M
QA id                                                                A10     Yes      Yes
Audit date                                                           D       No       No
Audit remarks                                                        A255    No       No


Reference List
                             Entity                                 Card           Dep.
Company(COMPANY)                                              1,1            Yes


Entity: Quay
   Name:         Quay
   Code:         QUAY
   Label:        A docking area in a port/terminal
   Number:                            Generate Table:   Yes


Attribute List
          Name                                Label                   Type     I          M


PowerDesigner                                                                       Page 69
Conceptual Data Model                                                                TRIM 5_7


           Name                               Label                      Type    I       M
Q_Id                                                                   LI       Yes     Yes
Q_Name                                                                 A50      No      No
Q_No_of_Spaces                                                         I        No      No
Q_Average_Docking_Tim                                                  DT       No      No
e
Q_Opening_Hours                                                        A50      No      No


Reference List
                     Entity                                           Card           Dep.
Quay Usage(QUAY_USAGE)                                          0,n             No


Entity: Quay Usage
   Name:         Quay Usage
   Code:         QUAY_USAGE
   Label:        An occupation of a quay for a docking.
   Number:                           Generate Table:      Yes


Attribute List
          Name                                Label                     Type     I       M
QU id                                                                  LI       Yes     Yes


Reference List
                             Entity                                   Card           Dep.
Location(LOCATION)                                              1,1             No
Subdocking(SUBDOCKING)                                          1,1             No
Quay(QUAY)                                                      0,1             No
Service Order(SERVICE_ORDER)                                    0,n             No


Entity: Route Plan
   Name:         Route Plan
   Code:         ROUTE_PLAN
   Label:        A schedule for transport chains.
   Number:                            Generate Table:     Yes


Attribute List
           Name                               Label                     Type     I       M
RP id                                                                  NO       Yes     Yes
Valid from date                                                        DT       No      No
Valid to date                                                          DT       No      No


Reference List


PowerDesigner                                                                         Page 70
Conceptual Data Model                                                                       TRIM 5_7


                         Entity                                            Card             Dep.
Route Plan Line(ROUTE_PLAN_LINE)                                     0,n               No
Transport Chain Type(TRANSPORT_CHAIN_TYPE)                           0,n               No


Entity: Route Plan Line
   Name:         Route Plan Line
   Code:         ROUTE_PLAN_LINE
   Label:        A line in a schedule for transport chains
   Number:                             Generate Table:       Yes


Attribute List
          Name                                  Label                           Type    I       M
RPL id                                                                      I          Yes     Yes


Reference List
                        Entity                                             Card             Dep.
Route Plan(ROUTE_PLAN)                                               1,1               No
Transport Order(TRANSPORT_ORDER)                                     0,n               No
Visit(VISIT)                                                         0,n               No


Entity: Service
   Name:         Service
   Code:         SERVICE
   Label:        A basic transport operation type, independent of transport chain
   Number:                            Generate Table:      Yes


Attribute List
           Name                                 Label                        Type       I       M
Service id                                                                  LI         Yes     Yes
Service name                                                                A15        No      No
Service description                                                         A300       No      No
Booking type                  Service is booked for: L=load units,          A1         No      No
                              C=consignments,


Reference List
                         Entity                                            Card             Dep.
Chain Operation Type(CHAIN_OPERATION_TYPE)                           0,n               No
Price Header(PRICE_HEADER)                                           0,n               No
Packaging Material(PACKAGING_MATERIAL)                               0,n               No
Package Type(PACKAGE_TYPE)                                           0,n               No
Service Group(SERVICE_GROUP)                                         0,1               No
Location(LOCATION)                                                   0,1               No
Company(COMPANY)                                                     0,1               No


PowerDesigner                                                                                Page 71
Conceptual Data Model                                                                      TRIM 5_7


                              Entity                                        Card           Dep.
Contract(CONTRACT)                                                   0,1             No
Location(LOCATION)                                                   0,1             No
Unit of Measure(UNIT_OF_MEASURE)                                     0,1             No
Service Mode(SERVICE_MODE)                                           0,n             Yes
Service Order(SERVICE_ORDER)                                         0,n             No
Service Unit(SERVICE_UNIT)                                           0,n             Yes
Transport Unit Shipment(TRANSPORT_UNIT_SHIPMENT)                     0,n             No
Visit(VISIT)                                                         0,n             No
Visit(VISIT)                                                         0,n             No


Entity: Service Group
   Name:         Service Group
   Code:         SERVICE_GROUP
   Label:        A class of services; e.g. freight, handling, quay usage.
   Number:                              Generate Table:        Yes


Attribute List
          Name                                   Label                        Type    I        M
SG code                                                                      A2      Yes      Yes
SG name                                                                      A25     No       No


Reference List
                              Entity                                        Card           Dep.
Contract(CONTRACT)                                                   0,n             No
Freight Cost Element(FREIGHT_COST_ELEMENT)                           0,n             No
Service(SERVICE)                                                     0,n             No


Entity: Service Mode
   Name:         Service Mode
   Code:         SERVICE_MODE
   Label:        A combination of a service and a transport mode
   Number:                           Generate Table:        Yes


Reference List
                        Entity                                              Card           Dep.
Mode of Transport(MODE_OF_TRANSPORT)                                 1,1             Yes
Service(SERVICE)                                                     1,1             Yes


Entity: Service Order
   Name:         Service Order
   Code:         SERVICE_ORDER


PowerDesigner                                                                               Page 72
Conceptual Data Model                                                                   TRIM 5_7


   Label:        A service performed to a customer
   Number:                           Generate Table:       Yes


Attribute List
           Name                                Label                       Type    I        M
SO id                                                                     LI      Yes      Yes
SO start time                                                             DT      No       No
SO delays                                                                 DT      No       No
SO remarks                                                                A100    No       No


Reference List
                        Entity                                           Card           Dep.
Quay Usage(QUAY_USAGE)                                             1,1            No
Transport Order(TRANSPORT_ORDER)                                   1,1            No
Price Header(PRICE_HEADER)                                         0,1            No
Service(SERVICE)                                                   1,1            No
Company(COMPANY)                                                   0,1            No


Entity: Service Unit
   Name:         Service Unit
   Code:         SERVICE_UNIT
   Label:        A combination of a service and a transport unit type
   Number:                           Generate Table:        Yes


Reference List
                              Entity                                     Card           Dep.
Service(SERVICE)                                                   1,1            Yes
Transport Unit Type(TRANSPORT_UNIT_TYPE)                           1,1            Yes


Entity: Stock
   Name:         Stock
   Code:         STOCK
   Label:        A storage of products
   Number:                            Generate Table:      Yes


Attribute List
           Name                                Label                       Type    I        M
Stock id                                                                  I       Yes      Yes
S Actual stock                                                            I       No       No
S Damaged stock                                                           I       No       No
S Arrival date                                                            DT      No       No




PowerDesigner                                                                            Page 73
Conceptual Data Model                                                                      TRIM 5_7


Reference List
                              Entity                                        Card           Dep.
Product(PRODUCT)                                                      0,1             No
Company(COMPANY)                                                      0,1             No


Entity: Stuffed Item
   Name:         Stuffed Item
   Code:         STUFFED_ITEM
   Label:        A goods item in a transport unit
   Number:                            Generate Table:        Yes


Attribute List
           Name                                  Label                         Type    I       M
Stuffed item id                                                               NO      Yes     Yes
Weight                                                                        A10     No      No
No of packages                                                                A10     No      No
Volume                                                                        A10     No      No
Customs tarif no                                                              A10     No      No
Stuffing date time                                                            DT      No      No
Stripping date time                                                           DT      No      No
Movement type                 Types: Breakbulk, LCL, FCL                      A3      No      No
Net explosive mass kg                                                         F       No      No
Gros explosiv mass kg                                                         F       No      No


Reference List
                       Entity                                               Card           Dep.
Company(COMPANY)                                                      0,1             No
Goods Item(GOODS_ITEM)                                                0,1             No
Location(LOCATION)                                                    0,1             No
Transport Unit(TRANSPORT_UNIT)                                        1,1             No


Entity: Subdocking
   Name:         Subdocking
   Code:         SUBDOCKING
   Label:        A stay of a transport means at a specific place in a port.
   Number:                             Generate Table:       Yes


Attribute List
           Name                                  Label                        Type     I       M
Subdocking id                                                                 I       Yes     Yes
Start time                                                                    DT      No      No
End time                                                                      DT      No      No




PowerDesigner                                                                               Page 74
Conceptual Data Model                                                                   TRIM 5_7


Reference List
                     Entity                                               Card          Dep.
Quay Usage(QUAY_USAGE)                                              0,n            No
Visit(VISIT)                                                        0,1            No
Company(COMPANY)                                                    0,1            No


Entity: Supported Message
   Name:         Supported Message
   Code:         SUPPORTED_MESSAGE
   Label:        A physical message type which is supported by a company
   Number:                           Generate Table:      Yes


Attribute List
          Name                                  Label                       Type    I       M
SM id                                                                      LI      Yes     Yes
EDI address                                                                A100    No      No


Reference List
                        Entity                                            Card          Dep.
Message Type(MESSAGE_TYPE)                                          1,1            No
Physical Message(PHYSICAL_MESSAGE)                                  1,1            No
Company(COMPANY)                                                    1,1            No


Entity: Terminal
   Name:         Terminal
   Code:         TERMINAL
   Label:        A port, railway station or freight terminal.
   Number:                             Generate Table:        Yes


Entity: Tour
   Name:         Tour
   Code:         TOUR
   Label:        The totality of trips made by a transport means in one assignment.
   Number:                              Generate Table:      Yes


Description
A tour is seen from the drivers viewpoint, and will normally end at the point of departure

Attribute List
          Name                                  Label                       Type    I       M
Tour id                                                                    A10     Yes     Yes



PowerDesigner                                                                            Page 75
Conceptual Data Model                                                                    TRIM 5_7


Reference List
                              Entity                                      Card           Dep.
Trip(TRIP)                                                          0,n            No
Transport Means(TRANSPORT_MEANS)                                    0,1            No
Visit(VISIT)                                                        0,n            No


Entity: Train
   Name:         Train
   Code:         TRAIN
   Label:        A set of wagons which are included in a specific instance of a train
   Number:                           Generate Table:       No


Reference List
                      Entity                                              Card           Dep.
Train wagon(TRAIN_WAGON)                                            0,n            Yes


Entity: Train wagon
   Name:         Train wagon
   Code:         TRAIN_WAGON
   Label:        A wagon in a specific train
   Number:                            Generate Table:       Yes


Reference List
                              Entity                                      Card           Dep.
Train(TRAIN)                                                        1,1            Yes
Wagon(WAGON)                                                        1,1            Yes


Entity: Transition
   Name:         Transition
   Code:         TRANSITION
   Label:        A row in a state/transition table
   Number:                             Generate Table:      Yes


Attribute List
           Name                               Label                         Type    I        M
Row no                        Row number in a state/transition table       I       Yes      Yes
Current state                                                              A30     No       No
Next state                                                                 A30     No       No


Reference List
                              Entity                                      Card           Dep.


PowerDesigner                                                                             Page 76
Conceptual Data Model                                                                  TRIM 5_7


                             Entity                                     Card           Dep.
Action(ACTION)                                                    0,n             No
Transport Chain Type(TRANSPORT_CHAIN_TYPE)                        1,1             No
Company(COMPANY)                                                  0,1             No
Message Type(MESSAGE_TYPE)                                        1,1             No


Entity: Transport Chain Type
   Name:         Transport Chain Type
   Code:         TRANSPORT_CHAIN_TYPE
   Label:        The complete transport chain from consignor to consignee.
   Number:                           Generate Table:      Yes


Attribute List
          Name                                Label                       Type     I       M
TCT id                                                                   LI       Yes     Yes
Chain name                                                               A25      No      No
Chain priority               Recommended priority for alternative        A1       No      No
                             consignor/consignee chains
TCT weight                   Preferred weight of goods                   DC15,7   No      No
TCT lot size                 Preferred lot size                          DC15,7   No      No
TCT max weight               Max weight for transport unit               DC15,7   No      No
Remark                                                                   A255     No      No
TC class                     Class of TC. Values: Main/Sub               A1       No      No


Reference List
                         Entity                                         Card           Dep.
Consignment(CONSIGNMENT)                                         0,n              No
Chain Operation Type(CHAIN_OPERATION_TYPE)                       0,n              No
Product Order(PRODUCT_ORDER)                                     0,n              No
Transition(TRANSITION)                                           0,n              No
Company(COMPANY)                                                 0,1              No
Company(COMPANY)                                                 0,1              No
Location(LOCATION)                                               0,1              No
Delivery Terms(DELIVERY_TERMS)                                   0,1              No
Route Plan(ROUTE_PLAN)                                           0,1              No
Location(LOCATION)                                               0,1              No
Product(PRODUCT)                                                 0,1              No
Packaging Material(PACKAGING_MATERIAL)                           0,1              No
Package Type(PACKAGE_TYPE)                                       0,1              No
Unit of Measure(UNIT_OF_MEASURE)                                 0,1              No
Transport Unit Type(TRANSPORT_UNIT_TYPE)                         0,1              No
Transport Order(TRANSPORT_ORDER)                                 0,n              No


Entity: Transport Forecast
   Name:         Transport Forecast


PowerDesigner                                                                           Page 77
Conceptual Data Model                                                                    TRIM 5_7


   Code:         TRANSPORT_FORECAST
   Label:        An estimat of cargo weight per period
   Number:                            Generate Table:      Yes


Attribute List
           Name                                Label                        Type    I        M
TF id                                                                     NO       Yes      Yes
TF date from                                                              DT       No       No
TF date to                                                                DT       No       No
Cargo weight                 Weight in tons                               I        No       No


Reference List
                         Entity                                          Card            Dep.
Chain Operation Type(CHAIN_OPERATION_TYPE)                         1,1             No
Company(COMPANY)                                                   0,1             No


Entity: Transport Invoice
   Name:         Transport Invoice
   Code:         TRANSPORT_INVOICE
   Label:        A request for payment of a transport order
   Number:                           Generate Table:        Yes


Attribute List
          Name                                 Label                       Type     I        M
TI id                                                                     I        Yes      Yes
TI subtype                   Subtypes: Bill of lading, Transport          A10      No       No
                             Invoice, ...
TI Customs charge                                                         MN18     No       No
TI Charge cathegory                                                       A3       No       No


Reference List
                          Entity                                         Card            Dep.
Transport Order(TRANSPORT_ORDER)                                   0,1             No
Location(LOCATION)                                                 0,1             No
Company(COMPANY)                                                   0,1             No
Transport Invoice Line(TRANSPORT_INVOICE_LINE)                     0,n             Yes


Entity: Transport Invoice Line
   Name:         Transport Invoice Line
   Code:         TRANSPORT_INVOICE_LINE
   Label:        An item in a Transport Invoice
   Number:                            Generate Table:      Yes



PowerDesigner                                                                             Page 78
Conceptual Data Model                                                                     TRIM 5_7


Attribute List
          Name                                   Label                       Type     I       M
TIL id                                                                      I        Yes     Yes
Freight charge id                                                           A17      No      No
Freight charge                                                              I        No      No
Chargeable weight                                                           I        No      No
Chargeable units                                                            I        No      No


Reference List
                         Entity                                            Card           Dep.
Transport Invoice(TRANSPORT_INVOICE)                                 1,1            Yes
Goods Item(GOODS_ITEM)                                               0,1            No


Entity: Transport Means
   Name:         Transport Means
   Code:         TRANSPORT_MEANS
   Label:        A vehicle used for the transport of goods, e.g. truck, vessel or train
   Number:                            Generate Table:       No


Reference List
                        Entity                                             Card           Dep.
Tour(TOUR)                                                           0,n            No
Person(PERSON)                                                       0,1            No
Transport Order(TRANSPORT_ORDER)                                     0,n            No


Entity: Transport Order
   Name:         Transport Order
   Code:         TRANSPORT_ORDER
   Label:        A freight transport order
   Number:                             Generate Table:       Yes


Description
A Transport Order may have subtypes:
PB    Preliminary booking
FBC Firm booking of consignments
FBL Firm booking of load units
FBLC Firm booking of load units and consignments

Attribute List
          Name                                   Label                       Type     I       M
Order id                                                                    LI       Yes     Yes
TO Subtype                    Preliminary booking, firm booking etc.        A4       No      No
TO Status                                                                   A4       No      No


PowerDesigner                                                                              Page 79
Conceptual Data Model                                                             TRIM 5_7


         Name                            Label                       Type    I        M
Booking no                                                         A20      No       No
Booking date                                                       DT       No       No
Customer booking no                                                A20      No       No
Priority                Priority of transport order                A20      No       No
ETA LP                  Estimated time of arrival for loading port DT       No       No
ETA FD                  Estimated time of arrival for final        DT       No       No
                        destination
Required arrival time   Required or planned arrival time for the DT         No       No
                        transport order
First_Unloading_Time    Start of required unloading time window DT          No       No
Last_Unloading_Time     End of required unloading time window DT            No       No
First_Loading_Time      Start of required loading time window      DT       No       No
Last_Loading_Time       End of required loading time window        DT       No       No
Laytime                 No of hours at quay                        A50      No       No
No of transport means   Ex: Number of rail wagons                  I        No       No
TO Carriage condition                                              A3       No       No
Driver message                                                     A50      No       No
TO dangerous goods      Summary of dangerous goods info at         A100     No       No
                        transport order level
Prize                                                              MN15     No       No
Prepaid charge                                                     MN18     No       No
Terms of payment                                                   A4       No       No
Terms of delivery                                                  A4       No       No
Release ref no                                                     A10      No       No
Acceptance ref no                                                  A10      No       No
Charterers agent                                                   A50      No       No
Owners agent                                                       A50      No       No
Created time                                                       DT       No       No
Reply time                                                         DT       No       No
Reply time location                                                A50      No       No
Behalf of                                                          A50      No       No
Demurrage                                                          A50      No       No
Commission                                                         A50      No       No
Inerting instructions                                              A200     No       No
Cleaning instructions                                              A200     No       No
Cargo_1st               First previous cargo on transport means    A50      No       No
Cargo_2nd               Second previous cargo on transport         A50      No       No
                        means
Cargo_3rd               Third previous cargo on transport means A50         No       No
Remarks                                                            A200     No       No
Last updated                                                       DT       No       No
Last userid                                                        A20      No       No


Reference List
                        Entity                                    Card            Dep.
AEI reading(AEI_READING)                                    0,n             No
Booked Driver(BOOKED_DRIVER)                                0,n             No
Consignment Order(CONSIGNMENT_ORDER)                        0,n             Yes


PowerDesigner                                                                      Page 80
Conceptual Data Model                                                                   TRIM 5_7


                              Entity                                       Card         Dep.
Delivery(DELIVERY)                                                   0,n          No
Freight Cost Element(FREIGHT_COST_ELEMENT)                           0,1          No
Service Order(SERVICE_ORDER)                                         0,n          No
Transport Invoice(TRANSPORT_INVOICE)                                 0,n          No
Company(COMPANY)                                                     0,1          No
Company(COMPANY)                                                     0,1          No
Visit(VISIT)                                                         0,1          No
Company(COMPANY)                                                     0,1          No
Company(COMPANY)                                                     0,1          No
Transport Order(TRANSPORT_ORDER)                                     0,1          No
Contract(CONTRACT)                                                   0,1          No
Transport Unit Type(TRANSPORT_UNIT_TYPE)                             0,1          No
Route Plan Line(ROUTE_PLAN_LINE)                                     0,1          No
Visit(VISIT)                                                         0,1          No
Currency(CURRENCY)                                                   0,1          No
Transport Chain Type(TRANSPORT_CHAIN_TYPE)                           0,1          No
Transport Means(TRANSPORT_MEANS)                                     0,1          No
Transport Order State(TRANSPORT_ORDER_STATE)                         0,n          No
TUS Order(TUS_ORDER)                                                 0,n          Yes


Entity: Transport Order State
   Name:         Transport Order State
   Code:         TRANSPORT_ORDER_STATE
   Label:        The condition of a transport order at a specified time
   Number:                             Generate Table:       Yes


Attribute List
          Name                                  Label                      Type    I        M
TOS id                                                                    NO      Yes      Yes
TOS time                      Time when the state was created             DT      No       Yes
TOS state                     May be defined in a state/transition table, A30     No       Yes
                              see entity: Transition


Reference List
                        Entity                                             Card         Dep.
Transport Order(TRANSPORT_ORDER)                                     1,1          No


Entity: Transport Unit
   Name:         Transport Unit
   Code:         TRANSPORT_UNIT
   Label:        A transport means or a load unit, or both of them
   Number:                            Generate Table:        Yes




PowerDesigner                                                                            Page 81
Conceptual Data Model                                                                   TRIM 5_7


Attribute List
          Name                                 Label                        Type    I       M
Transport unit id                                                         LI       Yes     Yes
TU_Ref_No                    User defined reference number                A50      No      No
Name                                                                      A175     No      No
TU length                    Length in centimeters                        I        No      No
TU width                     Width in centimeters                         I        No      No
TU height                    Height in centimeters                        I        No      No
TU weight empty                                                           I        No      No
TU loading capacity          Max loading capacity                         I        No      No
TU_Speed                     Service (normal) speed                       I        No      No
Mobile phone no                                                           A50      No      No
Email address                                                             A50      No      No
SatcomAB                                                                  A50      No      No
SatcomC                                                                   A50      No      No
Building date                                                             D        No      No
Remarks                                                                   A200     No      No


Reference List
                          Entity                                         Card           Dep.
Contract(CONTRACT)                                                 0,n             No
Transport Unit(TRANSPORT_UNIT)                                     0,1             No
Stuffed Item(STUFFED_ITEM)                                         0,n             No
Company(COMPANY)                                                   0,1             No
Company(COMPANY)                                                   0,1             No
Company(COMPANY)                                                   0,1             No
Transport Unit Type(TRANSPORT_UNIT_TYPE)                           0,1             No
Company(COMPANY)                                                   0,1             No
Unit of Measure(UNIT_OF_MEASURE)                                   0,1             No
Transport Unit Loaded(TRANSPORT_UNIT_LOADED)                       0,n             No
Transport Unit Loaded(TRANSPORT_UNIT_LOADED)                       0,n             No
Transport Unit Shipment(TRANSPORT_UNIT_SHIPMENT)                   0,n             No


Entity: Transport Unit Loaded
   Name:         Transport Unit Loaded
   Code:         TRANSPORT_UNIT_LOADED
   Label:        A load unit or a transport means placed on a transport means.
   Number:                             Generate Table:      Yes


Attribute List
          Name                                 Label                       Type     I       M
TU loaded id                                                              NO       Yes     Yes
Loading date time                                                         DT       No      No
Unloading date time                                                       DT       No      No


Reference List


PowerDesigner                                                                            Page 82
Conceptual Data Model                                                                      TRIM 5_7


                             Entity                                          Card          Dep.
Arrival(ARRIVAL)                                                       0,1            No
Departure(DEPARTURE)                                                   0,1            No
Transport Unit(TRANSPORT_UNIT)                                         1,1            No
Location(LOCATION)                                                     0,1            No
Transport Unit(TRANSPORT_UNIT)                                         1,1            No


Entity: Transport Unit Shipment
   Name:        Transport Unit Shipment
   Code:        TRANSPORT_UNIT_SHIPMENT
   Label:       A transport of one transport unit, with cargo or empty.
   Number:                            Generate Table:       Yes


Description
A cargo unit which is included in a transport order.

Attribute List
           Name                                Label                           Type    I       M
TU Shipment id                                                                LI      Yes     Yes
Arrival time landside        Arrival to the landside of the terminal          DT      No      No
Departure time landside      Exit from the landside of the terminal           DT      No      No
Weight cargo                                                                  DC10    No      No
Free loading capacity        Estimated weigth of capacity for                 DC10    No      No
                             additional cargo
TU status                                                                     A1      No      No
Manifest position no                                                          A5      No      No
Closing time                                                                  DT      No      No
Full Container Load          F=Full, L= Less than full                        A1      No      No
Less Container Load                                                           A1      No      No
INCOTERM                                                                      A1      No      No
Pickup date                  Date and time for pickup                         DT      No      No
Reference                    Reference code for the forwarder                 A30     No      No
Quantity                                                                      A10     No      No
TUS stowage cell                                                              A25     No      No
Transport temperature                                                         A10     No      No
Transport temperature                                                         A10     No      No
range
Power outlet                 True if transport unit needs power               A1      No      No
With driver                  True if the transport unit is accompanied        A1      No      No
                             with a driver
TUS dangerous goods          Summary of dangerous goods info on               A100    No      No
                             transport unit level
Packing responsible          Person initials                                  A4      No      No
Segregation controlled       Yes/No                                           A1      No      No
Stamp no                                                                      A10     No      No
Cargo Area                   Required storing area for cargo, (m2)            I       No      No
Cargo Volume                 Required volume for cargo in cubic               I       No      No


PowerDesigner                                                                               Page 83
Conceptual Data Model                                                                  TRIM 5_7


           Name                                Label                      Type     I          M
                             meters
Seal no                                                                  A10     No       No


Reference List
                         Entity                                         Card           Dep.
Actual Cost(ACTUAL_COST)                                          0,n            No
Consignment Shipment(CONSIGNMENT_SHIPMENT)                        0,n            Yes
Price Header(PRICE_HEADER)                                        0,n            No
Customs Declaration(CUSTOMS_DECLARATION)                          0,n            No
Contract(CONTRACT)                                                0,1            No
Trip Shipment(TRIP_SHIPMENT)                                      0,n            No
Service(SERVICE)                                                  0,1            No
Cargo Type(CARGO_TYPE)                                            0,1            No
Visit(VISIT)                                                      0,1            No
Coastal Area(COASTAL_AREA)                                        0,1            No
Transport Unit(TRANSPORT_UNIT)                                    0,1            No
Transport Unit Type(TRANSPORT_UNIT_TYPE)                          0,1            No
Visit(VISIT)                                                      0,1            No
Coastal Area(COASTAL_AREA)                                        0,1            No
Unit of Measure(UNIT_OF_MEASURE)                                  0,1            No
TUS Order(TUS_ORDER)                                              0,n            Yes


Entity: Transport Unit Type
   Name:         Transport Unit Type
   Code:         TRANSPORT_UNIT_TYPE
   Label:        A class of transport means or load units. Include IMO name
   Number:                            Generate Table:       Yes


Description
Examples: Container 2D, container 4D, trailer, truck, swopbody, vessel, rail

Attribute List
          Name                                 Label                      Type    I        M
Transport unit type id                                                   A10     Yes      Yes
Name                                                                     A175    No       No
IMO                                                                      A10     No       No


Reference List
                         Entity                                         Card           Dep.
Delivery(DELIVERY)                                                0,n            No
Package Code(PACKAGE_CODE)                                        0,n            No
Product Invoice(PRODUCT_INVOICE)                                  0,n            No
Service Unit(SERVICE_UNIT)                                        0,n            Yes
Transport Chain Type(TRANSPORT_CHAIN_TYPE)                        0,n            No


PowerDesigner                                                                           Page 84
Conceptual Data Model                                                                  TRIM 5_7


                          Entity                                        Card           Dep.
Transport Order(TRANSPORT_ORDER)                                  0,n             No
Transport Unit(TRANSPORT_UNIT)                                    0,n             No
Transport Unit Shipment(TRANSPORT_UNIT_SHIPMENT)                  0,n             No
Mode of Transport(MODE_OF_TRANSPORT)                              0,1             No


Entity: Trip
   Name:         Trip
   Code:         TRIP
   Label:        The movement of a transport means from a terminal to the next terminal.
   Number:                           Generate Table:     Yes


Attribute List
          Name                                 Label                       Type    I       M
Trip no                                                                  A17      Yes     Yes
Draft                                                                    A10      No      No
Sequence no                                                              I        No      No
total monetary amount                                                    I        No      No
Carriage condition                                                       A100     No      No


Reference List
                             Entity                                     Card           Dep.
Arrival(ARRIVAL)                                                  0,1             No
Departure(DEPARTURE)                                              0,1             No
Company(COMPANY)                                                  0,n             No
Tour(TOUR)                                                        0,1             No
Company(COMPANY)                                                  0,1             No
Person(PERSON)                                                    0,1             No
Trip Shipment(TRIP_SHIPMENT)                                      0,n             No


Entity: Trip Shipment
   Name:         Trip Shipment
   Code:         TRIP_SHIPMENT
   Label:        A transport unit included in a trip
   Number:                             Generate Table:    Yes


Attribute List
          Name                                 Label                      Type     I       M
TS id                                                                    NO       Yes     Yes


Reference List
                          Entity                                        Card           Dep.
Transport Unit Shipment(TRANSPORT_UNIT_SHIPMENT)                  1,1             No


PowerDesigner                                                                           Page 85
Conceptual Data Model                                                                  TRIM 5_7


                              Entity                                    Card          Dep.
Trip(TRIP)                                                        1,1            No


Entity: Truck
   Name:         Truck
   Code:         TRUCK
   Label:        A subtype of transport means; truck
   Number:                            Generate Table:      No


Reference List
                       Entity                                           Card          Dep.
AEI reading(AEI_READING)                                          0,n            No


Entity: TUS Order
   Name:         TUS Order
   Code:         TUS_ORDER
   Label:        A connection between a transport order and a transport unit shipment
   Number:                          Generate Table:       Yes


Reference List
                          Entity                                        Card          Dep.
Transport Order(TRANSPORT_ORDER)                                  1,1            Yes
Transport Unit Shipment(TRANSPORT_UNIT_SHIPMENT)                  1,1            Yes


Entity: Unit of Measure
   Name:         Unit of Measure
   Code:         UNIT_OF_MEASURE
   Label:        A quantity unit
   Number:                       Generate Table:           Yes


Attribute List
           Name                                Label                      Type    I        M
Unit code                                                                A3      Yes      Yes
Unit name                                                                A35     No       No
Unit precision                                                           N5      No       No


Reference List
                              Entity                                    Card          Dep.
Contract(CONTRACT)                                                0,n            No
Contract(CONTRACT)                                                0,n            No
Freight Cost Element(FREIGHT_COST_ELEMENT)                        0,n            No


PowerDesigner                                                                           Page 86
Conceptual Data Model                                                            TRIM 5_7


                          Entity                                  Card           Dep.
Price Element(PRICE_ELEMENT)                                0,n             No
Product Order Line(PRODUCT_ORDER_LINE)                      0,n             No
Goods Item(GOODS_ITEM)                                      0,n             No
Service(SERVICE)                                            0,n             No
Transport Chain Type(TRANSPORT_CHAIN_TYPE)                  0,n             No
Transport Unit(TRANSPORT_UNIT)                              0,n             No
Transport Unit Shipment(TRANSPORT_UNIT_SHIPMENT)            0,n             No
Vessel Position(VESSEL_POSITION)                            0,n             No
Vessel Position(VESSEL_POSITION)                            0,n             No
Vessel Position(VESSEL_POSITION)                            0,n             No


Entity: Vessel
   Name:        Vessel
   Code:        VESSEL
   Label:       A subtype of transport means.
   Number:                           Generate Table:   No


Description
A ship used for cargo transport.

Attribute List
           Name                              Label                   Type    I       M
Net capacity                                                       A20      No      No
Gross capacity                                                     A10      No      No
Call sign                                                          A10      No      No
Lloyd                                                              A10      No      No
Flag                         Vessel flag                           A10      No      No
Category                     Vessel cathegory                      A10      No      No
Registry no                  Registry number id                    I        No      No
IMO no                                                             A10      No      No
Trafic type                                                        A10      No      No
Dead weight                                                        I        No      No
MDWT                                                               A10      No      No
Gros register ton                                                  A20      No      No
Suez NRT                                                           A20      No      No
Panama NRT                                                         A20      No      No
Vessel draft                                                       I        No      No
Crew nationality                                                   A100     No      No
Domene                                                             A50      No      No
TPC                                                                A20      No      No
Hull                                                               A50      No      No
Bow chain stopper            Yes/No                                A3       No      No
Beam                                                               A20      No      No
Inert gas system             Yes/no                                A3       No      No
Cargo segregation                                                  A20      No      No
T coating                                                          A50      No      No


PowerDesigner                                                                     Page 87
Conceptual Data Model                                                             TRIM 5_7


           Name                            Label                      Type    I       M
Cargo pumps capacity        Number and m3/h                          A100    No      No
Manifold connections                                                 A100    No      No
Sternline                   Yes/No                                   A3      No      No
Crude oil washed            Yes/No                                   A3      No      No
Coiled                                                               A50     No      No
Derriks                                                              A50     No      No
Manifold crane                                                       A50     No      No
Vapout Return System        Yes/No                                   A3      No      No
Ballast arrangement                                                  A50     No      No
Slops capacity                                                       A20     No      No
SPM                         Yes/No                                   A3      No      No


Reference List
                         Entity                                     Card          Dep.
Vessel Size Class(VESSEL_SIZE_CLASS)                          0,1            No
Vessel Type(VESSEL_TYPE)                                      0,1            No
Country(COUNTRY)                                              0,1            No
Vessel Position(VESSEL_POSITION)                              0,n            No


Entity: Vessel Position
   Name:         Vessel Position
   Code:         VESSEL_POSITION
   Label:        Speed and position of a vessel.
   Number:                            Generate Table:   Yes


Attribute List
           Name                              Label                    Type    I       M
VP Id                                                                NO      Yes     Yes
VP time                                                              DT      No      No
Position                                                             A10     No      No
Speed                                                                A10     No      No
Direction ETA                                                        A10     No      No
Condition                                                            A30     No      No
Distance run                                                         A50     No      No
Distance to go                                                       A50     No      No
Wind                                                                 A50     No      No
Sea                                                                  A50     No      No
Fuel oil arrival                                                     A20     No      No
Fuel oil departure                                                   A20     No      No
Diesel oil arrival                                                   A20     No      No
Diesel oil departure                                                 A20     No      No
Fresh water arrival                                                  A20     No      No
Fresh water departure                                                A20     No      No
Draft fwd                                                            A20     No      No
Draft aft                                                            A20     No      No



PowerDesigner                                                                      Page 88
Conceptual Data Model                                                                   TRIM 5_7


           Name                                Label                       Type     I       M
Tug fwd                                                                   A50      No      No
Tug aft                                                                   A50      No      No
Remarks                                                                   A200     No      No
Last updated sign                                                         A20      No      No


Reference List
                        Entity                                           Card           Dep.
Visit(VISIT)                                                       0,1             No
Unit of Measure(UNIT_OF_MEASURE)                                   0,1             No
Unit of Measure(UNIT_OF_MEASURE)                                   0,1             No
Unit of Measure(UNIT_OF_MEASURE)                                   0,1             No
Vessel(VESSEL)                                                     1,1             No


Entity: Vessel Size Class
   Name:         Vessel Size Class
   Code:         VESSEL_SIZE_CLASS
   Label:        A cathegory of vessel sizes, according to EC Dir., Annex VIII.
   Number:                            Generate Table:       Yes


Attribute List
          Name                                 Label                        Type    I       M
VS code                                                                   A2       Yes     Yes
Lower limit DWT                                                           I        No      No
Upper limit DWT                                                           I        No      No


Reference List
                              Entity                                     Card           Dep.
Vessel(VESSEL)                                                     0,n             No


Entity: Vessel Type
   Name:         Vessel Type
   Code:         VESSEL_TYPE
   Label:        A class of vessels., according to EC Dir., Annex VI.
   Number:                              Generate Table:      Yes


Attribute List
          Name                                 Label                       Type     I       M
VT code                                                                   A2       Yes     Yes
VT name                                                                   A10      No      No
VT description                                                            A30      No      No




PowerDesigner                                                                            Page 89
Conceptual Data Model                                                                   TRIM 5_7


Reference List
                                Entity                                   Card           Dep.
Vessel(VESSEL)                                                     0,n             No


Entity: Visit
   Name:         Visit
   Code:         VISIT
   Label:        A visit of a transport unit in a terminal
   Number:                              Generate Table:      Yes


Attribute List
          Name                                   Label                      Type    I       M
Visit id                      System generated unique identifier          LI       Yes     Yes
Year                          User specified year for the visit           A4       No      No
Visit no                      User specified or system generated visit    I        No      No
                              number within the year.
Visit vessel name             The vessel name at the visit date.          A15      No      No
Visit call sign               The call sign at the visit date.            A10      No      No
Visit status                                                              A10      No      No
Cargo on board                                                            A30      No      No
Last updated                                                              DT       No      No
Updated by                                                                A20      No      No


Reference List
                                Entity                                   Card           Dep.
Arrival(ARRIVAL)                                                   0,1             No
Departure(DEPARTURE)                                               0,1             No
Company(COMPANY)                                                   0,1             No
Subdocking(SUBDOCKING)                                             0,n             No
Transport Order(TRANSPORT_ORDER)                                   0,n             No
Transport Order(TRANSPORT_ORDER)                                   0,n             No
Transport Unit Shipment(TRANSPORT_UNIT_SHIPMENT)                   0,n             No
Transport Unit Shipment(TRANSPORT_UNIT_SHIPMENT)                   0,n             No
Service(SERVICE)                                                   0,1             No
Company(COMPANY)                                                   0,1             No
Route Plan Line(ROUTE_PLAN_LINE)                                   0,1             No
Tour(TOUR)                                                         0,1             No
Service(SERVICE)                                                   0,1             No
Vessel Position(VESSEL_POSITION)                                   0,n             No


Entity: Wagon
   Name:         Wagon
   Code:         WAGON
   Label:        A rail wagon
   Number:                               Generate Table:     No


PowerDesigner                                                                            Page 90
Conceptual Data Model                              TRIM 5_7




Reference List
                       Entity         Card         Dep.
AEI reading(AEI_READING)        0,n          No
Train wagon(TRAIN_WAGON)        0,n          Yes




PowerDesigner                                       Page 91

				
DOCUMENT INFO
Shared By:
Categories:
Tags:
Stats:
views:4
posted:11/14/2011
language:English
pages:91