CT bo

From UG

Contents 1 Scope 2 <Example> 3 Color Codes 4 Gen Tab View 5 Imp Tab View 6 Exp Tab View 7 Objects 7.1 Com Table 7.2 Ctnr Table 8 General Fields 8.1 Origin Door 8.2 Other fields 8.3 CT num 8.4 Export ref 8.5 Import ref 8.6 Customer ref 8.7 Jaguar 3rd ref 8.8 E0 Client 8.9 Mode of Transport 8.10 Client Mode 8.11 Operator Of Last Change 8.12 E1 8.13 E2 8.14 E3 8.15 Operator Of Last Change 8.16 Shipper 8.17 Shipper Address 8.18 Notify 8.19 Notify Address 8.20 Pick up 8.21 Pick up Address 8.22 Delivery to 8.23 Delivery to Address 8.24 Pick up Comments 8.25 Pick up Trucker 8.26 Estimated Pick Up Date 8.27 Actual Export Pick Up Date 8.28 Origin country 8.29 Origin country note 8.30 Destination country 8.31 Destination country note 8.32 Commodity description 8.33 Marks Numbers 8.34 Shipping Terms 8.35 Shipping Terms Location 8.36 Notification Date 8.37 Authorized by 8.38 Authorized MOT 8.39 Automated Estimated Delivery Date 8.40 Authorization Method 8.41 Hazardous Yes No 8.42 Hazardous Note 9 Export Fields 10 Import Side 10.1 IT Num 10.2 IT Date 10.3 IT Location 10.4 Customs Broker 10.5 Delivery Address 10.6 Estimated Delivery Date 10.7 Actual Delivery Date

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

Color Codes

all but FCL/Truck-Ocean

AIR/LCL/FCL

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	xxx

For specific User Interface Implementation see also Gen Tab.

Imp Tab View

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

TBD

Exp Tab View

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

TBD

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 Num

MOT	CRUD	DB
Undefined, Truck	n/a
Air, LCL, FCL	Imp Tab#IT Num

IT Date

MOT	CRUD	DB
Undefined, Truck	n/a
Air, LCL, FCL	Imp Tab#IT Date

IT Location

MOT	CRUD	DB
Undefined, Truck	n/a
Air, LCL, FCL	Imp Tab#IT Location

Customs Broker

MOT	CRUD	DB
Undefined, Truck	n/a
Air, LCL, FCL	Imp Tab#Customs Broker

Delivery Address

MOT	CRUD	DB
Undefined, Truck	n/a
Air, LCL, FCL	[[Imp Tab#Delivery Address]

Estimated Delivery Date

Actual Delivery Date

MOT	CRUD	DB
Undefined	n/a
Air, LCL	Imp Tab#Actual Delivery Date
FCL	Ctnr CRUD#Actual Delivery Date
Truck-Air	Gen Tab#Actual Delivery Date
Truck-Ocean	Ctnr CRUD#Actual Delivery Date
Truck-Dom	Gen Tab#Actual Delivery Date