CT bo

From UG

Revision as of 18:23, 19 May 2010 (edit) Alex (Talk | contribs) (→Export Fields) ← Older edit		Revision as of 18:25, 19 May 2010 (edit) (undo) Alex (Talk | contribs) Newer edit →
Line 9:		Line 9:
	This wiki describes CT (Shipment) Business Object		This wiki describes CT (Shipment) Business Object
-	== Visual Representation Of Tabs with links to fields ==
-
-
-	=== Imp Tab View ===
-
-	This is just 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 '''
-
-	{| border="1" cellpadding="2"
-	! A || B || C  || D
-	|-
-	| [[#IT]] <br/> [[File:Textbox.jpg]]  <br/> [[#IT Date]] <br/> [[File:Datebox.JPG]] <br/> [[#IT Location]] <br/> [[File:Textbox.jpg]]
-	| [[#Customs Broker]] <br/> [[File:Textbox.jpg]] <br/>  [[#Customs Broker Address]] <br/> [[File:Textarea.JPG]]
-	| [[#Import Delivery To]] <br/> [[File:Textbox.jpg]] <br/>  [[#Import Delivery To Address]] <br/> ([[#Delivery Address]])<br/> [[File:Textarea.JPG]]
-	| ''[[#Delivery Comments]]'' - old name <br/> [[#Delivery Instructions]] - new name <br/> [[File:Textarea.JPG]]
-	|-
-	| [[#Last Free Day]] <br/> [[#Import Pick Up]]  ([[#Cargo location]]) <br/> [[#Import Pick Up Address]]
-	| [[#Delivery Trucker]] <br/> [[#Delivery Date Type]]  <br/> [[#Delivery Comment]]
-	|
-	| [[#Arrival Notice Comment]]
-	|-
-	|
-	| style="background:gray" | [[#Estimated Delivery Date]] <br>[[#Actual Delivery Date]] <br/> '''LCL/AIR only!'''
-	|
-	|
-	|-
-	|
-	| style="background:gray" | [[#Jaguar Delivery Yes No]] <br/> '''! FCL only !'''
-	|
-	|
-	|-
-	| style="background:gray" | [[#Original BL Required Yes No]] <br/> '''! LCL/FCL only !'''
-	|
-	|
-	|
-	|-
-	| [[#Payment Of Charges Required Yes No]]
-	| [[#Customs Status]] <br/> [[#Customs Status Date]]
-	| [[#FDA Status]] <br/> [[#FDAStatus Date]]
-	|}
	== General Fields ==		== General Fields ==
Line 381:		Line 340:
		+	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 '''
		+
		+	{| border="1" cellpadding="2"
		+	! A || B || C  || D
		+	|-
		+	| [[#IT]] <br/> [[File:Textbox.jpg]]  <br/> [[#IT Date]] <br/> [[File:Datebox.JPG]] <br/> [[#IT Location]] <br/> [[File:Textbox.jpg]]
		+	| [[#Customs Broker]] <br/> [[File:Textbox.jpg]] <br/>  [[#Customs Broker Address]] <br/> [[File:Textarea.JPG]]
		+	| [[#Import Delivery To]] <br/> [[File:Textbox.jpg]] <br/>  [[#Import Delivery To Address]] <br/> ([[#Delivery Address]])<br/> [[File:Textarea.JPG]]
		+	| ''[[#Delivery Comments]]'' - old name <br/> [[#Delivery Instructions]] - new name <br/> [[File:Textarea.JPG]]
		+	|-
		+	| [[#Last Free Day]] <br/> [[#Import Pick Up]]  ([[#Cargo location]]) <br/> [[#Import Pick Up Address]]
		+	| [[#Delivery Trucker]] <br/> [[#Delivery Date Type]]  <br/> [[#Delivery Comment]]
		+	|
		+	| [[#Arrival Notice Comment]]
		+	|-
		+	|
		+	| style="background:gray" | [[#Estimated Delivery Date]] <br>[[#Actual Delivery Date]] <br/> '''LCL/AIR only!'''
		+	|
		+	|
		+	|-
		+	|
		+	| style="background:gray" | [[#Jaguar Delivery Yes No]] <br/> '''! FCL only !'''
		+	|
		+	|
		+	|-
		+	| style="background:gray" | [[#Original BL Required Yes No]] <br/> '''! LCL/FCL only !'''
		+	|
		+	|
		+	|
		+	|-
		+	| [[#Payment Of Charges Required Yes No]]
		+	| [[#Customs Status]] <br/> [[#Customs Status Date]]
		+	| [[#FDA Status]] <br/> [[#FDAStatus Date]]
		+	|}
	=== IT ===		=== IT ===

---

Revision as of 18:25, 19 May 2010

Contents 1 Definition 2 Scope 3 General Fields 3.1 Cargo available 3.2 Cargo due 3.3 CT Num 3.4 Created On Date 3.5 Created On 3.6 Export Ref 3.7 Import Ref 3.8 Customer Ref 3.9 Jaguar 3rd Ref 3.10 E0 Client 3.11 Mode Of Transport 3.11.1 MOT 3.12 Client Mode 3.13 Operator Of Last Change 3.14 E1 3.15 E2 3.16 E3 3.17 Operator Of Last Change 3.18 Shipper 3.19 Shipper Address 3.20 Consignee 3.21 Consignee Address 3.22 Notify 3.23 Notify Address 3.24 Export Pick Up 3.24.1 Pick Up 3.25 Export Pick Up Address 3.26 Export Delivery To 3.27 Delivery To 3.28 Export Delivery To Address 3.29 Pick Up Comments 3.30 Export Pick Up Trucker 3.30.1 Pick Up Trucker 3.31 Estimated Export Pick Up Date 3.31.1 Estimated Pick Up Date 3.32 Actual Export Pick Up Date 3.32.1 Actual Pick Up Date 3.33 Origin Country 3.34 Origin Country Note 3.35 Destination Country 3.36 Destination Country Note 3.37 Commodity Description 3.38 Marks And Numbers 3.39 Shipping Terms 3.40 Shipping Terms Location 3.41 Notification Date 3.42 Authorized By 3.43 Authorized On 3.44 Authorized MOT 3.45 Automated Estimated Delivery Date 3.46 Authorization Method 3.47 Hazardous Yes No 3.48 Hazardous Note 3.49 On Customer Hold 3.50 Pending Approval 3.51 PT Number 3.52 DT Number 3.53 Consol Warehouse 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

Cargo available

Cargo due

CT Num

Created On Date

Date that CT has been created. Currently not displayed on tabs.

Created On

same as #Created On Date

Export Ref

• Meaning: unique shipment identifier
• Format/type: Datatypes#alphanumeric
• Examples: 130222
• MOT: All
• DB: Generic tbl#ExportRef
• CRUD: Gen Tab#Export Ref

Import Ref

Customer Ref

Jaguar 3rd Ref

E0 Client

Mode Of Transport

MOT

same as #Mode Of Transport

Client Mode

Operator Of Last Change

E1

E2

E3

Operator Of Last Change

Shipper

Shipper Address

Consignee

Consignee Address

Notify

Notify Address

Export Pick Up

Pick Up

same as above

Export Pick Up Address

Export Delivery To

Delivery To

same as #Export Delivery To

Export Delivery To Address

Pick Up Comments

Export Pick Up Trucker

Pick Up Trucker

same as above

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

Origin Country

Origin Country Note

Destination Country

Destination Country Note

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

Hazardous Note

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

Consol Warehouse

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

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

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