CT bo

From UG

Revision as of 04:04, 11 February 2010 (edit) Alex (Talk | contribs) (→Imp Tab View) ← Older edit		Revision as of 04:10, 11 February 2010 (edit) (undo) Alex (Talk | contribs) (→Import Side) Newer edit →
Line 558:		Line 558:
	== Import Side ==		== Import Side ==
-	=== IT Num ===
-	{| border="1"	+	=== IT ===
-	| MOT || CRUD || DB	+
-	|-	+
-	| Undefined, Truck  ||      n/a  ||	+
-	|-	+
-	| Air, LCL, FCL  ||      [[Imp Tab#IT Num]]  ||	+
-	|}	+
-		+
-		+
	=== IT Date ===		=== IT Date ===
-		+
-	{| border="1"	+
-	| MOT || CRUD || DB	+
-	|-	+
-	| Undefined, Truck  ||      n/a  ||	+
-	|-	+
-	| Air, LCL, FCL  ||      [[Imp Tab#IT Date]]  ||	+
-	|}	+
-		+
-		+
	=== IT Location ===		=== IT Location ===
-
-	{| border="1"
-	| MOT  || CRUD || DB
-	|-
-	| Undefined, Truck  ||      n/a  ||
-	|-
-	| Air, LCL, FCL  ||      [[Imp Tab#IT Location]]  ||
-	|}
-
	=== Customs Broker ===		=== Customs Broker ===
		+
		+	=== Customs Broker Address ===
-	{| border="1"	+	=== Import Delivery To ===
-	| MOT || CRUD || DB	+
-	|-	+	=== Import Delivery To Address ===
-	| Undefined, Truck  ||      n/a  ||	+
-	|-	+
-	| Air, LCL, FCL  ||      [[Imp Tab#Customs Broker]]  ||	+
-	|}	+
-	=== Delivery Address ===	+	==== Delivery Address ====
		+	same as [[#Import Delivery To]]
-	{| border="1"	+	=== Delivery Comments ===
-	| MOT || CRUD || DB	+
-	|-	+	=== Last Free Day ===
-	| Undefined, Truck  ||      n/a ||	+	=== Import Pick Up ===
-	|-	+	(#Cargo location)
-	| Air, LCL, FCL  ||      [[Imp Tab#Delivery Address]  ||	+
-	|}	+
		+	=== Import Pick Up Address  ===
		+	=== Delivery Trucker ===
		+	=== Delivery Date Type ===
		+	=== Delivery Comment ===
		+	=== Arrival Notice Comment ===
	=== Estimated Delivery Date ===		=== Estimated Delivery Date ===
-
-
-
-
	=== Actual Delivery Date ===		=== Actual Delivery Date ===
-		+
-	{| border="1"	+	=== Jaguar Delivery Yes No ===
-	| MOT  || CRUD || DB	+
-	|-	+	=== Original BL Required Yes No ===
-	| Undefined  ||      n/a	+
-	|-	+	=== Payment Of Charges Required Yes No ===
-	| Air, LCL  ||      [[Imp Tab#Actual Delivery Date]]	+	=== Customs Status ===
-	|-	+	=== Customs Status Date ===
-	|-	+	=== FDA Status ===
-	| FCL  ||      [[Ctnr CRUD#Actual Delivery Date]]	+	=== FDAStatus Date ===
-	|-	+
-	| Truck-Air  ||      [[Gen Tab#Actual Delivery Date]]	+
-	|-	+
-	| Truck-Ocean  ||    [[Ctnr CRUD#Actual Delivery Date]]	+
-	|-	+
-	| Truck-Dom  ||      [[Gen Tab#Actual Delivery Date]]	+
-	|}	+

---

Revision as of 04:10, 11 February 2010

Contents 1 Definition 2 Scope 3 <Example> 4 Gen Tab View 5 Color Codes 6 Exp Tab View 7 Imp Tab View 8 Objects 8.1 Com Table 8.2 Ctnr Table 9 General Fields 9.1 Origin Door 9.2 Other fields 9.3 CT num 9.4 Export ref 9.5 Import ref 9.6 Customer ref 9.7 Jaguar 3rd ref 9.8 E0 Client 9.9 Mode of Transport 9.10 Client Mode 9.11 Operator Of Last Change 9.12 E1 9.13 E2 9.14 E3 9.15 Operator Of Last Change 9.16 Shipper 9.17 Shipper Address 9.18 Notify 9.19 Notify Address 9.20 Pick up 9.21 Pick up Address 9.22 Delivery to 9.23 Delivery to Address 9.24 Pick up Comments 9.25 Pick up Trucker 9.26 Estimated Pick Up Date 9.27 Actual Export Pick Up Date 9.28 Origin country 9.29 Origin country note 9.30 Destination country 9.31 Destination country note 9.32 Commodity description 9.33 Marks Numbers 9.34 Shipping Terms 9.35 Shipping Terms Location 9.36 Notification Date 9.37 Authorized by 9.38 Authorized MOT 9.39 Automated Estimated Delivery Date 9.40 Authorization Method 9.41 Hazardous Yes No 9.42 Hazardous Note 10 Export Fields 11 Import Side 11.1 IT 11.2 IT Date 11.3 IT Location 11.4 Customs Broker 11.5 Customs Broker Address 11.6 Import Delivery To 11.7 Import Delivery To Address 11.7.1 Delivery Address 11.8 Delivery Comments 11.9 Last Free Day 11.10 Import Pick Up 11.11 Import Pick Up Address 11.12 Delivery Trucker 11.13 Delivery Date Type 11.14 Delivery Comment 11.15 Arrival Notice Comment 11.16 Estimated Delivery Date 11.17 Actual Delivery Date 11.18 Jaguar Delivery Yes No 11.19 Original BL Required Yes No 11.20 Payment Of Charges Required Yes No 11.21 Customs Status 11.22 Customs Status Date 11.23 FDA Status 11.24 FDAStatus Date

Definition

CT is often used as a short name for Shipment.

Scope

This describes CT (Shipment) Business Object

<Example>

• meaning: Airline 2 Letter unique Code
• type/format: Datatypes#alpha; exactly 2 chars; all caps
• example: CA

MOT	CRUD	DB
Undefined:	Gen_Tab#...	Generic tbl#...
Air:	see above
LCL:	see above
FCL:	see above
Truck Ocean:	see above
Truck Air:	see above
Truck Dom:	see above

Gen Tab View

This is just to 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 Pick Up Date #Actual Pick Up Date
#Origin Country #Origin Country Note #Destination Country #Destination Country Note	#Commodity description #Marks 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 datebox #Actual Delivery Date datebox
			#Last Free Day textbox #MAWB textbox #HAWB textbox #Airline textbox

Color Codes

all but FCL/Truck-Ocean

AIR/LCL/FCL

Truck Ocn

Truck Dom / Truck Air

Truck Air

For specific User Interface Implementation see also Gen Tab.

Exp Tab View

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

TBD

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

A	B	C	D
#IT #IT Date #IT Location [File:Textbox.jpg]]	#Customs Broker #Customs Broker Address	#Import Delivery To #Import Delivery To Address (#Delivery Address)	#Delivery Comments
#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

Objects

Com Table

Meaning: Commodity table, see Com Table

Format/type: n/a

Examples: n/a

Ctnr Table

Meaning: Ctnr Table, see Ctnr Table

Format/type: n/a

Examples: n/a

General Fields

Origin Door

Other fields

CT num

Meaning: unique shipment identifier

Format/type:

Examples: 130222

MOT	CRUD	DB
all:

Export ref

Meaning: unique shipment identifier

Format/type:

Examples: 8107657AE

MOT	CRUD	DB
all:	Gen_Tab#Export_ref	Generic tbl#ExportRef

Import ref

Meaning: unique shipment identifier

Format/type:

Examples: AI59212

MOT	CRUD	DB
all:	Gen_Tab#Import_ref	Generic tbl#ImportRef

Customer ref

Meaning: unique shipment identifier

Format/type:

Examples:

MOT	CRUD	DB
all:	[[TBD]	TBD

Jaguar 3rd ref

Meaning: unique shipment identifier

Format/type:

Examples:

MOT	CRUD	DB
all:	[[TBD]	TBD

E0 Client

Meaning: Client Company that ordered this shipment, and probably paying for it

Format/type:

Examples:

MOT	CRUD	DB
all:	[[TBD]	TBD

Mode of Transport

Meaning:

Format/type:

Examples: AIR

MOT	CRUD	DB
all:	[[TBD]	TBD

Client Mode

Meaning: Client specific tag

Format/type:

Examples:

MOT	CRUD	DB
all:	[[TBD]	TBD

Operator Of Last Change

Meaning: Client specific tag

Format/type:

Examples: Graeme Reveley

MOT	CRUD	DB
all:	[[TBD]	TBD

E1

Meaning: Client Company that has a visibility to this record Format/type: Examples:

MOT	CRUD	DB
all:	[[TBD]	TBD

E2

Meaning: Client Company that has a visibility to this record Format/type: Examples:

MOT	CRUD	DB
all:	[[TBD]	TBD

E3

Meaning: Client Company that has a visibility to this record Format/type: Examples:

MOT	CRUD	DB
all:	[[TBD]	TBD

Operator Of Last Change

Meaning: Client Company (name) that can see this Ct through Client App (Client Company Group name)

Format/type:

Examples: EA

MOT	CRUD	DB
all:	[[TBD]	TBD

Shipper

Meaning:

Format/type:

Examples: PETER THOMAS ROTH

MOT	CRUD	DB
all:	[[TBD]	TBD

Shipper Address

Meaning:

Format/type:

Examples:

PETER THOMAS ROTH LABS LLC
460 Park Avenue
6th Floor
New York, NY 10022
United States   

MOT	CRUD	DB
all:	[[TBD]	TBD

Notify

Meaning:

Format/type:

Examples: PETER THOMAS ROTH

MOT	CRUD	DB
all:	[[TBD]	TBD

Notify Address

Meaning:

Format/type:

Examples:

PETER THOMAS ROTH LABS LLC
460 Park Avenue
6th Floor
New York, NY 10022
United States   

MOT	CRUD	DB
all:	[[TBD]	TBD

Pick up

Pick up Address

Delivery to

Delivery to Address

Pick up Comments

Pick up Trucker

Estimated Pick Up Date

MOT	CRUD	DB
FCL, Truck Ocean	n/a, defined not per CT but per CT container - see Ctnr bo#Estimated Pick Up Date
all others:	[[TBD]	TBD

Actual Export Pick Up Date

MOT	CRUD	DB
FCL, Truck Ocean	n/a, defined not per CT but per CT container - see Ctnr bo#Estimated Pick Up Date
all others:	[[TBD]	TBD

Origin country

MOT	CRUD	DB
Truck Modes	n/a
all others:	[[TBD]	TBD

Origin country note

MOT	CRUD	DB
Truck Modes	n/a
all others:	[[TBD]	TBD

Destination country

MOT	CRUD	DB
Truck Modes	n/a
all others:	[[TBD]	TBD

Destination country note

MOT	CRUD	DB
Truck Modes	n/a
all others:	[[TBD]	TBD

Commodity description

Marks Numbers

Shipping Terms

Shipping Terms Location

Notification Date

Authorized by

Authorized MOT

Automated Estimated Delivery Date

Authorization Method

Hazardous Yes No

MOT	CRUD	DB
undefined, truck modes:	n/a
all others:	[[TBD]	TBD

Hazardous Note

MOT	CRUD	DB
undefined, truck modes:	n/a
all others:	[[TBD]	TBD

Export Fields

Import Side

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

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

Jaguar Delivery Yes No

Original BL Required Yes No

Payment Of Charges Required Yes No

Customs Status

Customs Status Date

FDA Status

FDAStatus Date