CT bo

From UG

Revision as of 19:22, 8 February 2010 (edit) Alex (Talk | contribs) (→Import Side) ← Older edit		Revision as of 19:23, 8 February 2010 (edit) (undo) Alex (Talk | contribs) (→Import Side) Newer edit →
Line 418:		Line 418:
	== Import Side ==		== Import Side ==
-	=== IT num ===	+	=== IT Num ===
	{| border="1"		{| border="1"
	| MOT  || CRUD || DB		| MOT  || CRUD || DB
	|-		|-
-	| Undefined, Truck  ||      n/a	+	| Undefined, Truck  ||      n/a ||
	|-		|-
-	| Air, LCL, FCL  ||      [[Imp Tab#IT num]]	+	| 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 ===

---

Revision as of 19:23, 8 February 2010

Contents 1 Scope 2 Objects 2.1 Com Table 2.2 Ctnr Table 3 General Fields 3.1 <Example> 3.2 CT num 3.3 Export ref 3.4 Import ref 3.5 Customer ref 3.6 Jaguar 3rd ref 3.7 E0 Client 3.8 Mode of Transport 3.9 Client Mode 3.10 Operator Of Last Change 3.11 Operator Of Last Change 3.12 Shipper 3.13 Shipper Address 3.14 Notify 3.15 Notify Address 3.16 Pick up 3.17 Pick up Address 3.18 Delivery to 3.19 Delivery to Address 3.20 Pick up Comments 3.21 Pick up Trucker 3.22 Estimated Pick Up Date 3.23 Actual Export Pick Up Date 3.24 Origin country 3.25 Origin country note 3.26 Destination country 3.27 Destination country note 3.28 Commodity description 3.29 Marks Numbers 3.30 Shipping Terms 3.31 Shipping Terms Location 3.32 Notification Date 3.33 Authorized by 3.34 Authorized MOT 3.35 Automated Estimated Delivery Date 3.36 Authorization Method 3.37 Hazardous Yes No 3.38 Hazardous Note 4 Export Fields 5 Import Side 5.1 IT Num 5.2 IT Date 5.3 IT Location 5.4 Estimated Delivery Date 5.5 Actual Delivery Date

Scope

This describes CT (Shipment) Business Object

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

<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

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

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

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