TCM Container Yard

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

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

COLUMN_NAME	DATA_TYPE
CREATED_DATETIME	DATE
SIGNATURE	BLOB
SIGNATURE_ID	NUMBER

CY_MOVES

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

JOB_UPDATE_COUNTER	NUMBER
VEHICLE_REGISTRATION	VARCHAR2
JOB_ID	NUMBER

CY_JOB

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

OWNER_UPDATE_COUNTER	NUMBER
OWNER_DESCRIPTION	VARCHAR2
OWNER_CODE	VARCHAR2

CY_CONTAINERS

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

CY_ENABLED	VARCHAR2
CY_CARRIER	VARCHAR2
CY_SERVICE	VARCHAR2
STOCKIST_SUB_CODE	VARCHAR2
STOCKIST_CODE	VARCHAR2

Additional Related WMS Tables

Static:

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:

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.

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'