CT bo

From UG

Contents 1 Definition 2 Scope 3 General Fields 3.1 Example 3.1.1 XXXXX Field 3.2 References 3.2.1 CT Num 3.2.2 Export Ref 3.2.3 Import Ref 3.2.4 Customer Ref 3.2.5 Jaguar 3rd Ref 3.3 Dates 3.3.1 Cargo available 3.3.2 Cargo due 3.3.3 Created On Date 3.3.4 Created On 3.3.5 Notification Date 3.3.6 Authorized On 3.3.7 Estimated Export Pick Up Date 3.3.8 Estimated Pick Up Date 3.3.9 Actual Export Pick Up Date 3.3.10 Actual Pick Up Date 3.3.11 Automated Estimated Delivery Date 3.4 Locations 3.4.1 Origin Country 3.4.2 Origin Country Note 3.4.3 Destination Country 3.4.4 Destination Country Note 3.4.5 Shipper 3.4.6 Shipper Address 3.4.7 Consignee 3.4.8 Consignee Address 3.4.9 Notify 3.4.10 Notify Address 3.4.11 Export Pick Up 3.4.11.1 Pick Up 3.4.11.2 Ship from State 3.4.11.3 Ship from Zip 3.4.11.4 Pick Up Company 3.4.12 Export Pick Up Address 3.4.13 Export Delivery To 3.4.14 Delivery To 3.4.14.1 Ship to State 3.4.14.2 Ship to Zip 3.4.15 Export Delivery To Address 3.4.16 Consol Warehouse 3.5 Client and Visibility 3.5.1 E0 Client 3.5.2 E1 3.5.3 E2 3.5.4 E3 3.6 Commodity related fields 3.6.1 Pick Up Comments 3.6.2 Commodity Description 3.6.3 Marks And Numbers 3.6.4 Hazardous Yes No 3.6.5 Hazardous Note 3.7 Authorization related fields 3.7.1 Authorized By 3.7.2 Authorized MOT 3.7.3 Authorization Method 3.8 Vendors 3.8.1 Export Pick Up Trucker 3.8.1.1 Pick Up Trucker 3.9 Misc 3.9.1 Mode Of Transport 3.9.1.1 MOT 3.9.2 Client Mode 3.9.3 Operator Of Last Change 3.9.4 Shipping Terms 3.9.5 Shipping Terms Location 3.9.6 On Customer Hold 3.9.7 Pending Approval 3.9.8 PT Number 3.9.9 DT Number 4 Export Fields 4.1 FedEx carrier ID 4.2 Freight Prepaid Collect 4.3 Arrival Into Warehouse 4.4 Move Type/HBL 4.5 Original House Bill Yes No 4.6 Steamshipline 4.7 Airline 4.8 Co Loaders 4.9 Booking Num 4.10 HAWB 4.11 MBL 4.12 MAWB 4.13 HBL 4.14 AMS Submission Date 4.15 Vessel Name 4.16 Voyage Num 4.17 Flight One 4.18 Feeder Vessel Name 4.19 Feeder Vessel Voyage Num 4.20 Flight Two 4.21 Origin Terminal 4.22 Origin Terminal Estimated Date 4.23 Origin Terminal Actual Date 4.24 Port Of Loading 4.25 Airport Of Departure 4.26 Port Of Loading Estimated Date 4.27 Airport Of Departure Estimated Date 4.28 Port Of Loading Actual Date 4.29 Airport Of Departure Actual Date 4.30 Trans Shipment 4.31 Trans Shipment Estimated Date 4.32 Trans Shipment Actual Date 4.33 Port Of Discharge 4.34 Airport Of Destination 4.35 Port Of Discharge Estimated Date 4.36 Airport Of Destination Estimated Date 4.37 Port Of Discharge Actual Date 4.38 Airport Of Destination Actual Date 4.39 Destination Terminal 4.40 Destination Terminal Estimated Date 4.41 Destination Terminal Actual Date 4.42 Destination Receiving Agent combobox 4.43 Cubic Meter textbox 4.44 Chargeable Weight textbox 4.45 HBL Comment 4.46 HAWB Comment 4.47 Export Customs Information 5 Import Fields 5.1 IT 5.2 IT Date 5.3 IT Location 5.4 Customs Broker 5.5 Customs Broker Address 5.6 Import Delivery To 5.7 Import Delivery To Address 5.7.1 Delivery Address 5.8 Delivery Comments 5.9 Delivery Instructions 5.10 Last Free Day 5.11 Import Pick Up 5.11.1 Cargo location 5.12 Import Pick Up Address 5.13 Delivery Trucker 5.14 Delivery Date Type 5.15 Delivery Comment 5.16 Arrival Notice Comment 5.17 Estimated Delivery Date 5.18 Actual Delivery Date 5.19 Jaguar Delivery Yes No 5.20 Original BL Required Yes No 5.21 Payment Of Charges Required Yes No 5.22 Customs Status 5.23 Customs Status Date 5.24 FDA Status 5.25 FDAStatus Date 6 Containers and Commodities 6.1 Com Table 6.2 Ctnr Table 7 Link to CRUD

Definition

CT is often used as a short name for Shipment record in CT2 system.

Scope

This wiki describes CT (Shipment) Business Object

General Fields

For specific User Interface Implementation see also Gen Tab.

Table below gives cross reference current implementation with Business Object Fields defined in this wiki.

A	B	C	D
#Export Ref	#Import Ref	#Customer Ref	#Jaguar 3rd Ref
#E0 Client	#MOT	#Client Mode	#Operator Of Last Change
#E1 #E2 #E3	#Shipper #Shipper Address	#Consignee #Consignee Address	#Notify #Notify Address
#Export Pick Up #Export Pick Up Address	#Export Delivery To #Export Delivery To Address	#Pick Up Comments	#Export Pick Up Trucker
			#Estimated Export Pick Up Date #Actual Export Pick Up Date
#Origin Country Note #Origin Country #Destination Country Note #Destination Country	#Commodity Description #Marks And Numbers #Shipping Terms #Shipping Terms Location	#Notification Date #Authorized By #Authorized On #Authorized MOT #Automated Estimated Delivery Date #Authorization Method	#Hazardous Yes No radio #Hazardous Note textarea
			#MBL textbox #HBL textbox #Steamshipline textbox
			#Estimated Delivery Date #Actual Delivery Date
			#Last Free Day textbox #MAWB textbox #HAWB textbox #Airline textbox

all but FCL/Truck-Ocean

AIR/LCL/FCL

Truck Ocn

Truck Dom / Truck Air

Truck Air

All

Example

XXXXX Field

Labels:

• Standard Long Label:
• Standard Short Label:
• Other Labels in use:

BO:

• Meaning:
• Format/type:
• Examples:
• MOT:

CRUD:

• Widget:
• Widget properties:
  • default:
  • read only?

DB:

References

CT Num

Export Ref

Import Ref

Customer Ref

Jaguar 3rd Ref

Dates

Cargo available

Cargo due

Created On Date

Created On

same as #Created On Date

Notification Date

Authorized On

Estimated Export Pick Up Date

Estimated Pick Up Date

same as above

Actual Export Pick Up Date

!!! Note: for FCL and Truck-Ocean it is Container#Actual Export Pick Up Date

Actual Pick Up Date

same as #Actual Export Pick Up Date

Automated Estimated Delivery Date

Locations

Origin Country

Origin Country Note

Destination Country

Destination Country Note

Shipper

Shipper Address

textarea below Shipper

Consignee

Consignee Address

Notify

Notify Address

Export Pick Up

Pick Up

same as above

Ship from State

• label on xls: Ship from State
• mapping: State from CT#Pick Up

Ship from Zip

• label on xls: Ship from Zip
• mapping: Zip from CT#Pick Up

Pick Up Company

"Company Name" from #Pick Up

Export Pick Up Address

Export Delivery To

Delivery To

same as #Export Delivery To

Ship to State

• label on xls: Ship to State
• mapping: State Ct#Delivery_To

Ship to Zip

• label on xls: Ship to Zip
• mapping: State Ct#Delivery_To

Export Delivery To Address

Consol Warehouse

Client and Visibility

E0 Client

E1

E2

E3

Commodity related fields

Pick Up Comments

Commodity Description

Marks And Numbers

Hazardous Yes No

Hazardous Note

Authorization related fields

Authorized By

Authorized MOT

Authorization Method

Vendors

Export Pick Up Trucker

Pick Up Trucker

same as above

Misc

Mode Of Transport

MOT

same as #Mode Of Transport

Client Mode

Operator Of Last Change

Shipping Terms

Shipping Terms Location

On Customer Hold

• Meaning: On hold means on hold in OUR WAREHOUSE meaning the shipment was already "picked up" and is technically "in-transit" but with the ON HOLD differentiation from a "normal" in-transit" shipment.
• Format/type: List of values: {true, false}
• Default: false
• MOT: All
• Edit panel (CRUD): see Gen Tab#On Customer Hold
• DB:

Pending Approval

• Meaning:
• Format/type: List of values: {true, false}
• Default: false
• MOT: All
• Edit panel (CRUD):
• DB:

PT Number

• Pick Up Trailer id - Unique id generated by the system. This is the tag to identify what CTs belong to the given Pick Up Truck Load.
• editable (this is a change - it used to be read only; --Alex 02:03, 17 April 2010 (UTC)))
• located on Gen tab next to CT#Export Pick Up Trucker
• default: blank

see also Update_Fields_for_Virtual_Group#Updating_PT_and_DT_fields

DT Number

• Delivery Trailer id - Unique id generated by the system. This is the tag to identify what CTs belong to the given Delivery Truck Load.
• * editable (this is a change - it used to be read only; --Alex 02:03, 17 April 2010 (UTC)))
• located on Gen tab next to #Delivery Trucker
• default: blank

see also Update_Fields_for_Virtual_Group#Updating_PT_and_DT_fields

Export Fields

See also Exp Tab.

LCL/AIR

AIR - bold

AIR/FCL/LCL - italic

FCL/LCL - regular

This is just to cross reference current implementation with Business Object Fields defined in this wiki.

#Freight Prepaid Collect
#Arrival Into Warehouse
#Move Type/HBL #Original House Bill Yes No	#Steamshipline / #Airline #Co Loaders #Booking Num / #HAWB	#MBL / #MAWB #HBL #AMS Submission Date	#Vessel Name #Voyage Num / #Flight One #Feeder Vessel Name #Feeder Vessel Voyage Num / #Flight Two
#Origin Terminal #Origin Terminal Estimated Date #Origin Terminal Actual Date	#Port Of Loading / #Airport Of Departure #Port Of Loading Estimated Date / #Airport Of Departure Estimated Date #Port Of Loading Actual Date / #Airport Of Departure Actual Date	#Trans Shipment #Trans Shipment Estimated Date #Trans Shipment Actual Date	#Port Of Discharge / #Airport Of Destination #Port Of Discharge Estimated Date / #Airport Of Destination Estimated Date #Port Of Discharge Actual Date / #Airport Of Destination Actual Date
#Destination Terminal #Destination Terminal Estimated Date #Destination Terminal Actual Date	#Destination Receiving Agent combobox #Cubic Meter textbox #Chargeable Weight textbox	#HBL Comment #HAWB Comment	#Export Customs Information

FedEx carrier ID

• Meaning: unique identifier for this CT from Fedex, see also Shipping through Fedex
• Format/type: Datatypes#numeric; 12 characters
• Examples: 793292131303
• MOT: AIR
• Default: blank
• Master field?: Y
• CRUD: Exp Tab#FedEx carrier ID

Freight Prepaid Collect

Arrival Into Warehouse

Move Type/HBL

Original House Bill Yes No

Steamshipline

Airline

Co Loaders

Booking Num

HAWB

MBL

MAWB

HBL

AMS Submission Date

Vessel Name

Voyage Num

Flight One

Feeder Vessel Name

Feeder Vessel Voyage Num

Flight Two

Origin Terminal

• Meaning: Is the FIRST port of loading
• Format/type: ComboBox & Radio Button
• Examples: Shanghai, China
• MOT: Ocean FCL & LCL
• Default: The same as Port of Loading
• Master field?: N
• CRUD: Terminals#_Origin_Terminals

Origin Terminal Estimated Date

Origin Terminal Actual Date

Port Of Loading

Airport Of Departure

Port Of Loading Estimated Date

Airport Of Departure Estimated Date

Port Of Loading Actual Date

Airport Of Departure Actual Date

Trans Shipment

Trans Shipment Estimated Date

Trans Shipment Actual Date

Port Of Discharge

Airport Of Destination

Port Of Discharge Estimated Date

Airport Of Destination Estimated Date

Port Of Discharge Actual Date

Airport Of Destination Actual Date

Destination Terminal

• Meaning: Is the LAST port of discharge
• Format/type: ComboBox & Radio Button
• Examples: New York, United States
• MOT: Ocean FCL & LCL
• Default: The same as Port of Discharge
• Master field?: N
• CRUD: Terminals#_Destination_Terminals

Destination Terminal Estimated Date

Destination Terminal Actual Date

Destination Receiving Agent combobox

Cubic Meter textbox

Chargeable Weight textbox

HBL Comment

HAWB Comment

Export Customs Information

Import Fields

Table below is to cross reference current implementation with Business Object Fields defined in this wiki.

Not colored fields are fields that are used for all 3 modes: Air, LCL, FCL

A	B	C	D
#IT #IT Date #IT Location	#Customs Broker #Customs Broker Address	#Import Delivery To #Import Delivery To Address (#Delivery Address)	#Delivery Comments - old name #Delivery Instructions - new name
#Last Free Day #Import Pick Up (#Cargo location) #Import Pick Up Address	#Delivery Trucker #Delivery Date Type #Delivery Comment		#Arrival Notice Comment
	#Estimated Delivery Date #Actual Delivery Date LCL/AIR only!
	#Jaguar Delivery Yes No ! FCL only !
#Original BL Required Yes No ! LCL/FCL only !
#Payment Of Charges Required Yes No	#Customs Status #Customs Status Date	#FDA Status #FDAStatus Date

IT

IT Date

IT Location

Customs Broker

Customs Broker Address

Import Delivery To

Import Delivery To Address

Delivery Address

same as #Import Delivery To

Delivery Comments

This field is to be re-named into #Delivery Instructions in coming release. See http://mantis.jaguarfreight.com/mantis/view.php?id=1719 for details. --Alex 00:06, 22 February 2010 (UTC)

Delivery Instructions

• Meaning: Additional information regarding delivery of goods for trucker
• Format/type: Datatypes#ascii
• Examples: TBD
• MOT: Air, LCL, FCL
• DB: Air_tbl#DeliveryInstructions, Ocean_tbl#DeliveryInstructions
• CRUD: Imp Tab#Delivery Instructions

Notes:

Last Free Day

Import Pick Up

Cargo location

same as #Import Pick Up

Import Pick Up Address

Delivery Trucker

Delivery Date Type

Delivery Comment

Arrival Notice Comment

Estimated Delivery Date

Actual Delivery Date

!!! Note: for FCL and Truck-Ocean it is Container#Actual Delivery Date

Jaguar Delivery Yes No

Original BL Required Yes No

Payment Of Charges Required Yes No

Customs Status

Customs Status Date

FDA Status

FDAStatus Date

Containers and Commodities

Com Table

See Com Table

Ctnr Table

See Ctnr Table

Link to CRUD

See:

• Gen Tab
• Exp Tab
• Imp Tab