Oakland B58 ============================================================================= :Provider Information: +-----------------+-----------------------+ | **Id** | oakland_b58 | +-----------------+-----------------------+ | **Type** | terminal | +-----------------+-----------------------+ | **Trace Type** | Scrape | +-----------------+-----------------------+ | **Credentials** | customer | +-----------------+-----------------------+ | **Limits** | 50 | +-----------------+-----------------------+ | **Status** | completed | +-----------------+-----------------------+ | **Doc Status** | draft | +-----------------+-----------------------+ | **Doc Version** | 1 | +-----------------+-----------------------+ :URLs: +------+---------------------------------------------+-------------+ | Type | URL | Environment | +======+=============================================+=============+ | Page | https://b58.tideworks.com/fc-OICT | DEV/STG/PRD | +------+---------------------------------------------+-------------+ :Sites: +------+---------+-----------------+ | Name | Site Id | Description | +======+=========+=================+ | name | ern | the description | +------+---------+-----------------+ Pages ----------------------------------------------------------------------------- Open home page and enter the username and password. .. image:: /_static/providers/rt/oakland-b58/01-login.png On the top menu select **Import** .. image:: /_static/providers/rt/oakland-b58/02-availability.png On the page that is opened, enter container numbers separated by a comma or container per line. .. image:: /_static/providers/rt/oakland-b58/03-search-containers.png Click on the **search** button and then there will be a table with containers information. .. image:: /_static/providers/rt/oakland-b58/04-container-results.png :Data Mapping: +-----------------------+--------------------+-----------------------------------------+ | Property | Source Property | Description | +=======================+====================+=========================================+ | container_number | Equipnumber | Container number | +-----------------------+--------------------+-----------------------------------------+ | carrier.steamshipLine | Trucker | The SCAC for the carrier. | +-----------------------+--------------------+-----------------------------------------+ | carrier.vessel | Vesselname | Id of the vessel | +-----------------------+--------------------+-----------------------------------------+ | carrier.voyage | Termvoyage | Voyage id for the vessel | +-----------------------+--------------------+-----------------------------------------+ || Outgate event || Unloadeddatetime || Event will be created if | || || || unloadeddatetime column has data value | +-----------------------+--------------------+-----------------------------------------+ || Arrived event || Available || Event will be created if | || || || yes in available column | +-----------------------+--------------------+-----------------------------------------+ || Released event || Satisfiedthrough || Event will be created if | || || || satisfiedthrough column has data value | +-----------------------+--------------------+-----------------------------------------+ || Customs hold event || Customsstatustime || Event will be created if | || || || date in customsstatustime column | +-----------------------+--------------------+-----------------------------------------+ || Line hold event || Linereleasestatus || Event will be created if | || || || date in linereleasestatus column | +-----------------------+--------------------+-----------------------------------------+ || CTF hold event || Holds || Event will be created if | || || || 'CTF' in holds column | +-----------------------+--------------------+-----------------------------------------+ || Demurrage hold event || Holds || Event will be created if | || || || 'DF' in holds column | +-----------------------+--------------------+-----------------------------------------+ :Arrived Event: +--------------------------+-----------------+-------------------------------------------+ | Property | Source Property | Description | +==========================+=================+===========================================+ | event[n].code | Arrived | If yes in available column | +--------------------------+-----------------+-------------------------------------------+ | event[n].date | Default | Today date is the default date value | +--------------------------+-----------------+-------------------------------------------+ | event[n].location.name | Location | Location could be YARD or VESSEL. | +--------------------------+-----------------+-------------------------------------------+ | event[n].location.type | Default | Terminal is the default type for location | +--------------------------+-----------------+-------------------------------------------+ | event[n].location.siteId | Yardposition | URN's site identifying the location | +--------------------------+-----------------+-------------------------------------------+ | event[n].data.arrived | Default | ISO date of the arrival date | +--------------------------+-----------------+-------------------------------------------+ :Lfd Event: +--------------------------+---------------------------+-------------------------------------------+ | Property | Source Property | Description | +==========================+===========================+===========================================+ || event[n].code || Lfd || Lfd event will be created | || || || If date in satisfiedthrough column | +--------------------------+---------------------------+-------------------------------------------+ | event[n].date | Default | Today date is the default date value | +--------------------------+---------------------------+-------------------------------------------+ | event[n].location.name | Location | Location could be YARD or VESSEL. | +--------------------------+---------------------------+-------------------------------------------+ | event[n].location.type | Default | Terminal is the default type for location | +--------------------------+---------------------------+-------------------------------------------+ | event[n].location.siteId | Yardposition | URN's site identifying the location | +--------------------------+---------------------------+-------------------------------------------+ || event[n].data.lfd || Date in satisfiedthrough || ISO date representing the last | || || column || Date for the container | +--------------------------+---------------------------+-------------------------------------------+ :Released Event: +--------------------------+---------------------------+-------------------------------------------+ | Property | Source Property | Description | +==========================+===========================+===========================================+ || event[n].code || Released || Released event will be created | || || || If date in satisfiedthrough column | +--------------------------+---------------------------+-------------------------------------------+ | event[n].date | Default | Today date is the default date value | +--------------------------+---------------------------+-------------------------------------------+ | event[n].location.name | Location | Location could be YARD or VESSEL. | +--------------------------+---------------------------+-------------------------------------------+ | event[n].location.type | Default | Terminal is the default type for location | +--------------------------+---------------------------+-------------------------------------------+ | event[n].location.siteId | Yardposition | URN's site identifying the location | +--------------------------+---------------------------+-------------------------------------------+ | event[n].data.released | Default | ISO date of release date | +--------------------------+---------------------------+-------------------------------------------+ :Outgated Event: +----------------------------------+------------------+-------------------------------------------+ | Property | Source Property | Description | +==================================+==================+===========================================+ || event[n].code || Outgated || Code = outgated only if Unloadeddatetime | || || || column has date value | +----------------------------------+------------------+-------------------------------------------+ | event[n].date | Default | Today date is the default date value | +----------------------------------+------------------+-------------------------------------------+ | event[n].location.name | Default | Location value is defaulted to OFFDOCK | +----------------------------------+------------------+-------------------------------------------+ | event[n].location.type | Default | Terminal is the default type for location | +----------------------------------+------------------+-------------------------------------------+ | event[n].data.outgate_scac | Trucker | SCAC of the trucking company | +----------------------------------+------------------+-------------------------------------------+ || event[n].data.outgate_confirmed || Default || Represents whether the | || || || Event is confirmed or not | +----------------------------------+------------------+-------------------------------------------+ | event[n].data.outgated | Unloadeddatetime | ISO date if the container was out gated | +----------------------------------+------------------+-------------------------------------------+ :Hold Events: +-------------------------+-----------------+-------------------------------------------+ | Property | Source Property | Description | +=========================+=================+===========================================+ | event[n].code | Hold | Hold is the default value for the event | +-------------------------+-----------------+-------------------------------------------+ | event[n].date | Default | Today date is the default date value | +-------------------------+-----------------+-------------------------------------------+ | event[n].location.name | Location | Location could be YARD or VESSEL. | +-------------------------+-----------------+-------------------------------------------+ | event[n].location.type | Default | Terminal is the default type for location | +-------------------------+-----------------+-------------------------------------------+ || event[n].data.holdType || Customs || Customsstatustime column has date value | || || Line || Linereleasestatus column has date value | || || Ctf || If 'CTF' in holds column | || || Demurrage || If 'DF' in holds column | +-------------------------+-----------------+-------------------------------------------+ | event[n].data.code | HOLD | Provider dependent code | +-------------------------+-----------------+-------------------------------------------+