CT bo

From UG

Revision as of 14:55, 2 June 2010 (edit) Denise (Talk | contribs) (→Freight Prepaid Collect) ← Older edit		Revision as of 14:56, 2 June 2010 (edit) (undo) Denise (Talk | contribs) (→Arrival Into Warehouse) Newer edit →
Line 608:		Line 608:
	* ''Field's [[Standard Short Label]]:'' Freight PPD CCX		* ''Field's [[Standard Short Label]]:'' Freight PPD CCX
-	=== Arrival Into Warehouse  ===	+	=== Arrival Into Warehouse  ===
		+
		+	'''Labels:'''
		+	* ''Field's [[Standard Long Label]]:'' Arrival Into Warehouse
		+	* ''Field's [[Standard Short Label]]:'' Arrvl Into Whse
		+
	=== Move Type/HBL ===		=== Move Type/HBL ===
	=== Original House Bill Yes No  ===		=== Original House Bill Yes No  ===

---

Revision as of 14:56, 2 June 2010

Contents 1 Definition 2 Scope 3 General Fields 3.1 Example 3.1.1 Acadaff Reference 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 By 3.3.5 Time CT Created 3.3.6 Notification Date 3.3.7 Authorized On 3.3.8 Estimated Export Pick Up Date 3.3.9 Estimated Pick Up Date 3.3.10 Actual Export Pick Up Date 3.3.11 Actual Pick Up Date 3.3.12 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 Pick Up State 3.4.11.3 Pick Up 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

Acadaff Reference Field

Labels:

• Field's Standard Long Label: Acadaff Reference
• Field's Standard Short Label: Aca Ref

BO:

• Field's Meaning: Reference from Acadaff system. Used rarely.
• Field's Format/type: Datatypes#alphanumeric, [one letter] + [3 digits] + [-] + [3 digits]
• Field's Example: C127-987
• Field's MOTs: Air only

CRUD:

• Field's Widget:
• Widget properties:
  • default:
  • read only?

DB:

References

CT Num

Labels:

• Field's Standard Long Label: CT Number
• Field's Standard Short Label: CT #

Export Ref

Labels:

• Field's Standard Long Label: Export Ref #
• Field's Standard Short Label: ExP Ref #

Import Ref

Labels:

• Field's Standard Long Label: Import Ref #
• Field's Standard Short Label: ImP Ref #

Customer Ref

Labels:

• Field's Standard Long Label: Customer Ref #
• Field's Standard Short Label: Client Ref

Jaguar 3rd Ref

Labels:

• Field's Standard Long Label: JFS 3rd Ref #
• Field's Standard Short Label: 3rd Ref #

Dates

Cargo available

Labels:

• Field's Standard Long Label: Cargo Available Date
• Field's Standard Short Label: Available Date

Cargo due

Labels:

• Field's Standard Long Label: Cargo Due Date
• Field's Standard Short Label: Due Date

Created On Date

Labels:

• Standard Long Label: CT created on
• Standard Short Label: CT created on
• Other Labels in use:

Created By

Labels:

• Standard Long Label: CT created by
• Standard Short Label: CT created by
• Other Labels in use:

Time CT Created

Labels:

• Standard Long Label: Time CT created
• Standard Short Label: Time CT created
• Other Labels in use:

Notification Date

Labels:

• Standard Long Label: Notification Date
• Standard Short Label: Notification Dt
• Other Labels in use:

Authorized On

Labels:

• Standard Long Label: Authorization Date
• Standard Short Label: Authorization Dt
• Other Labels in use:

Estimated Export Pick Up Date

Labels:

• Standard Long Label: Estimated Export Pick Up Date
• Standard Short Label: Est Pick Up Dt
• Other Labels in use:

Estimated Pick Up Date

same as #Estimated Export Pick Up Date

Labels:

• Standard Long Label: Estimated Pick Up Date
• Standard Short Label: Est Pick Up Dt
• Other Labels in use:

Actual Export Pick Up Date

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

Labels:

• Standard Long Label: Actual Export Pick Up Date
• Standard Short Label: Act Pick Up Dt
• Other Labels in use:

Actual Pick Up Date

same as #Actual Export Pick Up Date

Labels:

• Standard Long Label: Actual Pick Up Date
• Standard Short Label: Act Pick Up Date
• Other Labels in use:

Automated Estimated Delivery Date

Labels:

• Standard Long Label: Automated Est Delivery Date
• Standard Short Label: Auto Est Del Dt
• Other Labels in use:

Locations

Origin Country

Labels:

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

Origin Country Note

Labels:

• Standard Long Label: Origin Country Note
• Standard Short Label: Origin Country Note
• Other Labels in use:

Destination Country

Labels:

• Standard Long Label: Destination Country
• Standard Short Label: Dest Country
• Other Labels in use:

Destination Country Note

Labels:

• Standard Long Label: Destination Country Note
• Standard Short Label: Dest Country Note
• Other Labels in use:

Shipper

Labels:

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

Shipper Address

textarea below Shipper

Labels:

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

Consignee

Labels:

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

Consignee Address

Labels:

• Standard Long Label: Consignee Address
• Standard Short Label: Cnee Address
• Other Labels in use:

Notify

Labels:

• Standard Long Label: Notify Party
• Standard Short Label: Ntfy Party
• Other Labels in use:

Notify Address

Labels:

• Standard Long Label: Notify Address
• Standard Short Label: Ntfy Address
• Other Labels in use:

Export Pick Up

Labels:

• Standard Long Label: Export Pick Up
• Standard Short Label: Exp Pick Up
• Other Labels in use:

Pick Up

same as #Export Pick Up

Labels:

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

Pick Up State

This is a Derived field

• mapping: Address#State from CT#Pick Up
• Standard Long Label: Pick Up State
• Standard Short Label: Pick Up State

Labels:

Pick Up Zip

This is a Derived field

• mapping: Address#Zip from CT#Pick Up
• Standard Long Label: Pick Up Zip
• Standard Short Label: Pick Up Zip

Pick Up Company

"Company Name" from #Pick Up

Labels:

• Standard Long Label: Pick Up Company
• Standard Short Label: Pick Up Comp
• Other Labels in use:

Export Pick Up Address

Labels:

• Standard Long Label: Export Pick Up Address
• Standard Short Label: Exp Pick Up Address
• Other Labels in use:

Export Delivery To

Labels:

• Standard Long Label: Export Delivery To
• Standard Short Label: Exp Delivery To
• Other Labels in use:

Delivery To

same as #Export Delivery To

Labels:

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

Ship to State

• mapping: Address#State for Ct#Delivery_To

• label on xls: Ship to State

Labels:

• Standard Long Label: Ship to State
• Standard Short Label: Ship to State
• Other Labels in use:

Ship to Zip

• mapping: Address#State for Ct#Delivery_To

• label on xls: Ship to Zip

Labels:

• Standard Long Label: Ship to Zip
• Standard Short Label: Ship to Zip
• Other Labels in use:

Export Delivery To Address

Labels:

• Standard Long Label: Export Delivery To Address
• Standard Short Label: Exp Del to Address
• Other Labels in use:

Consol Warehouse

Labels:

• Standard Long Label: Consol Warehouse
• Standard Short Label: Consol Whse
• Other Labels in use:

Client and Visibility

E0 Client

Labels:

• Standard Long Label: E0 Client Company
• Standard Short Label: E0 Client
• Other Labels in use:

E1

Labels:

• Standard Long Label: Visibility 1
• Standard Short Label: Vis 1
• Other Labels in use:

E2

Labels:

• Standard Long Label: Visibility 2
• Standard Short Label: Vis 2
• Other Labels in use:

E3

Labels:

• Standard Long Label: Visibility 3
• Standard Short Label: Vis 3
• Other Labels in use:

Commodity related fields

Pick Up Comments

Labels:

• Standard Long Label: Pick Up Comments
• Standard Short Label: Pick Up Comments
• Other Labels in use:

Commodity Description

Labels:

• Standard Long Label: Commodity Description
• Standard Short Label: Commodity Desc
• Other Labels in use:

Marks And Numbers

Labels:

• Standard Long Label: Marks and Numbers
• Standard Short Label: Marks & Numbers
• Other Labels in use:

Hazardous Yes No

Labels:

• Standard Long Label: Hazardous Yes No
• Standard Short Label: Haz Y N
• Other Labels in use:

Hazardous Note

Labels:

• Standard Long Label: Hazardous Note
• Standard Short Label: Haz Note
• Other Labels in use:

Authorization related fields

Authorized By

Labels:

• Field's Standard Long Label: Authorized By
• Field's Standard Short Label: Autho By

Authorized MOT

Labels:

• Field's Standard Long Label: Authorized MOT
• Field's Standard Short Label: Autho MOT

Authorization Method

Labels:

• Field's Standard Long Label: Authorization Method
• Field's Standard Short Label: Autho Method

Vendors

Export Pick Up Trucker

Labels:

• Field's Standard Long Label: Export Pick Up Trucker
• Field's Standard Short Label: Ex Pick Up Trucker

Pick Up Trucker

same as above

Misc

Mode Of Transport

Labels:

• Field's Standard Long Label: Mode of Transport
• Field's Standard Short Label: MOT

MOT

same as #Mode Of Transport

Labels:

• Field's Standard Long Label: MOT
• Field's Standard Short Label: MOT

Client Mode

Labels:

• Field's Standard Long Label: Client Mode
• Field's Standard Short Label: Client Mode

Operator Of Last Change

Labels:

• Field's Standard Long Label: Operator of Last Change
• Field's Standard Short Label: Op of Last Change

Shipping Terms

Labels:

• Field's Standard Long Label: Shipping Terms
• Field's Standard Short Label: Ship Terms

Shipping Terms Location

Labels:

• Field's Standard Long Label: Shipping Terms Location
• Field's Standard Short Label: Ship Terms Loc

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:

Labels:

• Field's Standard Long Label: On Customer Hold
• Field's Standard Short Label: On Cust Hold

Pending Approval

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

Labels:

• Field's Standard Long Label: Pending Approval
• Field's Standard Short Label: Pndg Apprv

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

Labels:

• Field's Standard Long Label: PT Number
• Field's Standard Short Label: PT #

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

Labels:

• Field's Standard Long Label: DT Number
• Field's Standard Short Label: DT #

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

Labels:

• Field's Standard Long Label: FedEx ID #
• Field's Standard Short Label: FedEx ID #

Freight Prepaid Collect

Labels:

• Field's Standard Long Label: Freight Prepaid Collect
• Field's Standard Short Label: Freight PPD CCX

Arrival Into Warehouse

Labels:

• Field's Standard Long Label: Arrival Into Warehouse
• Field's Standard Short Label: Arrvl Into Whse

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

• Meaning: Is the FIRST airport of loading
• Format/type: ComboBox & Radio Button
• Examples: Shanghai, China
• MOT: Air
• Default: The same as Airport of Departure
• Master field?: N

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

• Meaning: Is the LAST airport of discharge at destination
• Format/type: ComboBox & Radio Button
• Examples: JFK, New York
• MOT: Air
• Default: The same as Airport of Destination
• Master field?: N

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 Commodity

Ctnr Table

See Container

Link to CRUD

See:

• Gen Tab
• Exp Tab
• Imp Tab