Anw: Initial Creation

2025-10-31T15:30:02Z

Initial Creation

New page

This page is intended to show some of the technical details for TCM/Terminal Container Management/Container Yard and related WMS tables.

== Container Yard Tables ==
{| class="wikitable"
!TABLE_NAME
!DESCRIPTION
|-
|CY_CONTAINER_OWNER
|Links to WMS Owner
|-
|CY_JOB
|Jobs
|-
|CY_JOB_VEHICLE
|Vehicles doing a job
|-
|CY_ACCOUNT
|Accounts
|-
|CY_CONTAINERS
|The actual containers
|-
|CY_MOVES
|Every move of containers that has ever taken place
|-
|CY_SIGNATURES
|Driver/haulier signatures (ToC)
|}

CY_SIGNATURES
{| class="wikitable"
!COLUMN_NAME
!DATA_TYPE
|-
|CREATED_DATETIME
|DATE
|-
|SIGNATURE
|BLOB
|-
|SIGNATURE_ID
|NUMBER
|}
CY_MOVES
{| class="wikitable"
!COLUMN_NAME
!DATA_TYPE
|-
|ORDER_NO
|VARCHAR2
|-
|SERVICE
|VARCHAR2
|-
|CARRIER
|VARCHAR2
|-
|HAULIER_CODE
|VARCHAR2
|-
|REGISTRATION
|VARCHAR2
|-
|TYPE_CODE
|VARCHAR2
|-
|MOVEMENT_TYPE
|VARCHAR2
|-
|ACCOUNT_ID
|VARCHAR2
|-
|CONTAINER_ID
|VARCHAR2
|-
|WAREHOUSE_ID
|VARCHAR2
|-
|COMPANY_CODE
|VARCHAR2
|-
|MOVEMENT_ID
|NUMBER
|-
|EDI_SENT_DATE
|DATE
|-
|WEIGHT
|NUMBER
|-
|SEAL
|VARCHAR2
|-
|MOVEMENT_BY
|VARCHAR2
|-
|UPDATE_COUNTER
|NUMBER
|-
|WEIGHT_CODE
|VARCHAR2
|-
|POSITION_CODE
|NUMBER
|-
|SIGNATURE_ID
|NUMBER
|-
|USER_ID
|VARCHAR2
|-
|LINKED_REGISTRATION
|VARCHAR2
|-
|TO_LOCATION
|VARCHAR2
|-
|FROM_LOCATION
|VARCHAR2
|-
|ENTERED_DATETIME
|DATE
|-
|DUE_DATETIME
|DATE
|-
|CREATED_DATETIME
|DATE
|-
|MOVEMENT_DATETIME
|DATE
|-
|CONTAINER_STATUS
|VARCHAR2
|-
|UN_NUMBER
|VARCHAR2
|-
|FULL_DAMAGED_EMPTY
|VARCHAR2
|-
|HAZARDOUS_IND
|NUMBER
|-
|STATUS
|NUMBER
|-
|OWNER_CODE
|VARCHAR2
|-
|JOB_REFERENCE
|VARCHAR2
|-
|JOB_ID
|NUMBER
|-
|BD_PROCESSED_IND
|NUMBER
|-
|QUANTITY
|NUMBER
|}
CY_JOB_VEHICLE
{| class="wikitable"
|JOB_UPDATE_COUNTER
|NUMBER
|-
|VEHICLE_REGISTRATION
|VARCHAR2
|-
|JOB_ID
|NUMBER
|}
CY_JOB
{| class="wikitable"
|JOB_UPDATE_COUNTER
|NUMBER
|-
|CREATED
|DATE
|-
|ACCOUNT_ID
|VARCHAR2
|-
|WAREHOUSE_ID
|VARCHAR2
|-
|COMPANY_CODE
|VARCHAR2
|-
|BAY_DIARY_BOOKING_REF
|VARCHAR2
|-
|JOB_REFERENCE
|VARCHAR2
|-
|JOB_ID
|NUMBER
|}
CY_CONTAINER_OWNER
{| class="wikitable"
|OWNER_UPDATE_COUNTER
|NUMBER
|-
|OWNER_DESCRIPTION
|VARCHAR2
|-
|OWNER_CODE
|VARCHAR2
|}
CY_CONTAINERS
{| class="wikitable"
|INBOUND_METHOD
|VARCHAR2
|-
|HOLD_STATUS
|VARCHAR2
|-
|UPDATE_COUNTER
|NUMBER
|-
|LAST_ORDER_NO
|VARCHAR2
|-
|ONSITE_DATETIME
|DATE
|-
|LOCATION_DATETIME
|DATE
|-
|AMENDED_DATETIME
|DATE
|-
|CREATED_DATETIME
|DATE
|-
|UN_NUMBER
|VARCHAR2
|-
|FULL_DAMAGED_EMPTY
|VARCHAR2
|-
|HAZARDOUS_IND
|NUMBER
|-
|STATUS_CODE
|VARCHAR2
|-
|LOCATION_SEQ
|NUMBER
|-
|LOCATION_CODE
|VARCHAR2
|-
|WEIGHT_CODE
|VARCHAR2
|-
|TYPE_CODE
|VARCHAR2
|-
|ACCOUNT_ID
|VARCHAR2
|-
|CONTAINER_ID
|VARCHAR2
|-
|WAREHOUSE_ID
|VARCHAR2
|-
|COMPANY_CODE
|VARCHAR2
|-
|OWNER_CODE
|VARCHAR2
|-
|WEIGHT
|NUMBER
|-
|SEAL
|VARCHAR2
|}
CY_ACCOUNT
{| class="wikitable"
|CY_ENABLED
|VARCHAR2
|-
|CY_CARRIER
|VARCHAR2
|-
|CY_SERVICE
|VARCHAR2
|-
|STOCKIST_SUB_CODE
|VARCHAR2
|-
|STOCKIST_CODE
|VARCHAR2
|}

== Additional Related WMS Tables ==
Static:
{| class="wikitable"
!TABLE_NAME
!DESCRIPTION
|-
|WARE_LOCATION
|Locations in the yard WHERE LOC_TYPE = 'Y'
|-
|CONTAINER_TYPE
|Types of containers
|-
|STK_STOCKIST
|Links to Account
|-
|HAULIERS
|Hauliers for movements into and out of the yard.
|-
|CONTAINER_STATUS
|lookup of statuses
|-
|TRANSLATION_TABLE
|CWGHT, store weights of 20ft containers
|-
|FXM_USERS/
FXM_USER_COMP_WAREHOUSES
FLEX_USER_COMP_OWNERS
|For logon purposes
|-
|VOYAGES
|
|-
|VESSELS
|
|-
|CARRIERS
|
|-
|HAZARDS
|
|-
|WAREHOUSE_RULES
|
|-
|WARE_PARAMS
|
|}
Standard Transactional WMS tables:
{| class="wikitable"
!TABLE_NAME
!DESCRIPTION
|-
|WARE_GOODS_ENTRY_HEADERS
|CONTAINER_ID
|-
|MANIFEST_CONTAINER_HEADER
|CONTAINER_NO
|-
|ORDER_HEADER
|CONTAINER_NO
|}

== Views ==
These views broadly contain all of the cross-reference data from other related tables such as those listed above from standard WMS and CY tables.
{| class="wikitable"
!VIEW_NAME
!Notes
|-
|V_CY_CONTAINERS_DETAILED
|
|-
|V_CY_JOB_BOOKING_REF
|This links to data from Bay Diary (WARE_DIARY_HEADERS) to get the booking reference.
Used in V_CY_WORK_IN_PROGRESS below
|-
|V_CY_MOVES_DETAILED
|
|-
|V_CY_WORK_IN_PROGRESS
|
|-
|V_CY_WORK_IN_PROGRESS_DET
|Used in V_CY_WORK_IN_PROGRESS above - Links CY_MOVES to Booking Reference, and unions on all types of movements (inbound/outbound gate, vehicle, vessel, etc).
|}

== Example Queries ==
select * from cy_moves cm
where registration = 'EXP1503271200'

select * from cy_moves cm
where registration = 'EXP1802021102'

select * from cy_moves cm
where movement_type = 'OR'
and company_code = '997'

select * from cy_containers c
--where container_id like 'MSCU%'
where container_id = 'MSCU3951530'
for update

Select * from cy_account

SELECT * FROM WARE_LOCATION
WHERE LOC_TYPE = 'Y'

[[Category:Technical Guides]]
[[Category:WMS]]
[[Category:TCM]]
[[Category:TOC]]

TCM Container Yard - Revision history

Anw: Initial Creation