CT bo

From UG

Revision as of 05:12, 11 February 2010 (edit) Alex (Talk | contribs) (→Exp Tab View) ← Older edit		Revision as of 05:18, 11 February 2010 (edit) (undo) Alex (Talk | contribs) (→Exp Tab View) Newer edit →
Line 95:		Line 95:
	This is just to cross reference current implementation with Business Object Fields defined in this wiki.		This is just to cross reference current implementation with Business Object Fields defined in this wiki.
		+
		+
	<TABLE border="1">		<TABLE border="1">
	<TR>		<TR>
Line 110:		Line 112:
	<TR>		<TR>
	<TD>[[#Move Type/HBL]]  <br/> [[#Original House Bill Yes No]] </TD>		<TD>[[#Move Type/HBL]]  <br/> [[#Original House Bill Yes No]] </TD>
-	<TD>[[#Steamshipline]] / <span style="background-color:peru">[[#Airline]]</span> <br/> [[#Co Loaders]] <br/> [[#Booking Num]] / <span style="background-color:peru">[[#HAWB]] </span> </TD>	+	<TD>[[#Steamshipline]] / <B>[[#Airline]]</B> <br/> [[#Co Loaders]] <br/> [[#Booking Num]] / <B>[[#HAWB]] </B> </TD>
-	<TD>[[#MBL]] / [[#MAWB]] <br/> [[#HBL]] <br/> [[#AMS Submission Date]] </TD>	+	<TD>[[#MBL]] / <B>[[#MAWB]]</B> <br/> [[#HBL]] <br/> [[#AMS Submission Date]] </TD>
-	<TD>[[#Vessel Name]]<br/> [[#Voyage Num]] / [[#Flight One]] <br> [[#Feeder Vessel Name]] <br> [[#Feeder Vessel Voyage Num]] / [[#Flight Two]]   </TD>	+	<TD>[[#Vessel Name]]<br/> [[#Voyage Num]] / <B>[[#Flight One]] </B> <br> [[#Feeder Vessel Name]] <br> [[#Feeder Vessel Voyage Num]] / <B>[[#Flight Two]] </B>  </TD>
	</TR>		</TR>
		+
		+	<TR>
		+	<TD>[[#Origin Terminal]] <br> [[#Origin Terminal Estimated]] <br> [[#Origin Terminal Actual]] </TD>
		+	<TD>[[#Port Of Loading]] / <b>[[#Airport Of Departure]] </b> <br> [[#Port Of Loading Estimated]] / <b>[[#Airport Of Departure Estimated]] </b> <br> [[#Port Of Loading Actual]] / <b>[[#Airport Of Departure Actual]] </b></TD>
		+	<TD></TD>
		+	<TD></TD>
		+	</TR>
		+
	</TABLE>		</TABLE>

---

Revision as of 05:18, 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 Consignee 9.19 Consignee Address 9.20 Notify 9.21 Notify Address 9.22 Pick up 9.23 Pick up Address 9.24 Delivery to 9.25 Delivery to Address 9.26 Pick up Comments 9.27 Pick up Trucker 9.28 Estimated Pick Up Date 9.29 Actual Export Pick Up Date 9.30 Origin country 9.31 Origin country note 9.32 Destination country 9.33 Destination country note 9.34 Commodity description 9.35 Marks Numbers 9.36 Shipping Terms 9.37 Shipping Terms Location 9.38 Notification Date 9.39 Authorized by 9.40 Authorized MOT 9.41 Automated Estimated Delivery Date 9.42 Authorization Method 9.43 Hazardous Yes No 9.44 Hazardous Note 10 Export Fields 10.1 Freight P C 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.10.1 Cargo location 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

LCL/AIR

AIR - bold

AIR/FCL/LCL - italic

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

#Freight P/C
#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 #Origin Terminal Actual	#Port Of Loading / #Airport Of Departure #Port Of Loading Estimated / #Airport Of Departure Estimated #Port Of Loading Actual / #Airport Of Departure Actual

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

Consignee

Consignee Address

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

Freight P C

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

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

Jaguar Delivery Yes No

Original BL Required Yes No

Payment Of Charges Required Yes No

Customs Status

Customs Status Date

FDA Status

FDAStatus Date