CT bo

From UG

Revision as of 21:10, 27 May 2010 (edit) Denise (Talk | contribs) (→Dates) ← Older edit		Current revision as of 05:07, 15 November 2013 (edit) (undo) Alex (Talk | contribs) (→Created On Date)
(218 intermediate revisions not shown)
Line 1:		Line 1:
	[[Category:CT Profile]]		[[Category:CT Profile]]
-
-	== Definition ==
-
-	CT is often used as a short name for [[Shipment]] record in CT2 system.
	== Scope ==		== Scope ==
Line 9:		Line 5:
	This wiki describes CT (Shipment) Business Object		This wiki describes CT (Shipment) Business Object
		+	== Additional ASN fields ==
		+	=== Approved by Planner ===
-	== General Fields ==	+	// name, ASN only
-	For specific User Interface Implementation see also [[Gen Tab]].	+	=== Approved by Super Planner ===
-	Table below gives cross reference current implementation with Business Object Fields defined in this wiki.	+	// name, ASN only
-	{| border="1" cellpadding="2"	+	== Derived Fields ==
-	! A || B || C  || D	+
-	|-	+
-	|  [[#Export Ref]] <br/> [[File:Textbox.jpg]] ||  [[#Import Ref]] <br/> [[File:Textbox.jpg]] ||  [[#Customer Ref]] <br/> [[File:Textbox.jpg]] ||  [[#Jaguar 3rd Ref]]  <br/> [[File:Textbox.jpg]]	+
-	|-	+
-	|  [[#E0 Client]] <br/> [[File:Combobox.JPG]]  ||  [[#MOT]] <br/> [[File:Combobox.JPG]] ||  [[#Client Mode]] <br/> [[File:Dropdown.JPG]]  ||  [[#Operator Of Last Change]]  <br/> [[File:Textbox.jpg]]	+
-	|-	+
-	|  [[#E1]]  [[File:Combobox.JPG]] <br/>  [[#E2]]  [[File:Combobox.JPG]] <br/> [[#E3]]  [[File:Combobox.JPG]] <br/> ||  [[#Shipper]] <br/> [[File:Combobox.JPG]] <br/> [[#Shipper Address]] <br/> [[File:Textarea.JPG]] ||  [[#Consignee]] <br/> [[File:Combobox.JPG]] <br/> [[#Consignee Address]] <br/> [[File:Textarea.JPG]] ||  [[#Notify]] <br/> [[File:Combobox.JPG]] <br/> [[#Notify Address]] <br/> [[File:Textarea.JPG]]	+
-	|-	+
-	|  [[#Export Pick Up]] <br/> [[File:Combobox.JPG]] <br/> [[#Export Pick Up Address]] <br/> [[File:Textarea.JPG]] ||  [[#Export Delivery To]] <br/> [[File:Combobox.JPG]] <br/> [[#Export Delivery To Address]] <br/> [[File:Textarea.JPG]]    ||  [[#Pick Up Comments]]  <br/> [[File:Textarea.JPG]] || [[#Export Pick Up Trucker]] <br/> [[File:Combobox.JPG]]	+
-	|-	+
-	|  || ||  || style="background:olive" |  [[#Estimated Export Pick Up Date]] <br/> [[File:Datebox.JPG]] <br/> [[#Actual Export Pick Up Date]] <br/> [[File:Datebox.JPG]]	+
-	|-	+
-	|  [[#Origin Country Note]]  <br/>  [[File:Textbox.jpg]]  <br/>  [[#Origin Country]]  <br/>  [[File:Combobox.JPG]]  <br/>  [[#Destination Country Note]]  <br/>  [[File:Textbox.jpg]]<br/> [[#Destination Country]]  <br/>  [[File:Combobox.JPG]]	+
-	| [[#Commodity Description]] <br> [[File:Textarea.JPG]] <br/>  [[#Marks And Numbers]] <br> [[File:Textarea.JPG]] <br/> [[#Shipping Terms]]  <br> [[File:Dropdown.JPG]] <br/> [[#Shipping Terms Location]] <br/> [[File:Textbox.jpg]]	+
-	| [[#Notification Date]] <br/> [[#Authorized By]] <br/> [[#Authorized On]] <br/> [[#Authorized MOT]] <br/> [[#Automated Estimated Delivery Date]] <br/> [[#Authorization Method]]	+
-	| style="background:yellow" | [[#Hazardous Yes No]] radio <br/>  [[#Hazardous Note]] textarea <br/>	+
-	|-	+
-	|	+
-	|	+
-	|	+
-	| style="background:aquamarine" | [[#MBL]] textbox <br/> [[#HBL]] textbox <br/>  [[#Steamshipline]] textbox	+
-	|-	+
-	|	+
-	|	+
-	|	+
-	| style="background:orange" | [[#Estimated Delivery Date]]<br/>[[File:Datebox.JPG]] <br/> [[#Actual Delivery Date]] <br/>[[File:Datebox.JPG]]	+
-	|-	+
-	|	+
-	|	+
-	|	+
-	| style="background:wheat" | [[#Last Free Day]] textbox <br/> [[#MAWB]] textbox  <br/> [[#HAWB]] textbox  <br/> [[#Airline]] textbox	+
-	|}	+
		+	=== Carrier ===
		+	* Ocean: [[#Steamshipline]]
		+	* Air: [[#Airline]]
		+	* Truck modes: [[#Pick Up Trucker]]
-	{| border="1" cellpadding="2"	+	=== Derived Locations ===
-	| style="background:olive" | all but FCL/Truck-Ocean	+
-	| style="background:yellow" | AIR/LCL/FCL	+
-	| style="background:aquamarine" | Truck Ocn	+
-	| style="background:orange" | Truck Dom / Truck Air	+
-	| style="background:wheat" | Truck Air	+
-	| All	+
-	|}	+
		+	==== Origin Door ====
		+
		+	* in CT2 called [[#Export Pick Up]]
		+
		+	==== Destination Door ====
		+
		+	* truck ocean / tr dom / tr air : Gen Tab > Export Delivery To (T5)
		+	* Ocean / Air : Imp Tab > Delivery Address (Import Delivery Location)(T7):
		+
		+	==== Origin Port ====
		+
		+	==== Destination Port ====
		+
		+	=== Derived Dates ===
		+
		+	==== Origin Door Actual Pick Up Date ====
		+
		+	* '''Air / Ocean LCL / Ocean Client Consol / Truck Air / Truck Dom''': Gen Tab: 10. Actual Export Pick-Up Date
		+
		+	* '''Ocean FCL / Truck Ocean''' :  Cont Tab. Actual Collection (Latest across all containers)
		+
		+	==== Origin Port Actual Departure Date ====
		+
		+	* '''Air''': Exp Tab: 11c. ATD - Actual Time of Dept
		+	* '''Ocean Client Consol / Ocean LCL / Ocean FCL''': Exp Tab:  11c. ATD: (Origin Terminal)
		+	* '''Truck modes:''' same as in [[#Origin Door Actual Pick Up Date]]
		+
		+	==== Destination Port Actual Arrival Date ====
		+
		+	* '''Air''': Exp Tab: 14c. ATA - Actual Time of Arrival:
		+	* '''Ocean Client Consol / Ocean LCL / Ocean FCL''': Exp Tab:  15c. ATA (Destination Terminal)
		+	* '''Truck modes:''' same as in [[#Destination Door Actual Delivery Date]]
		+
		+	==== Destination Door Actual Delivery Date ====
		+
		+	* '''Air''': Imp Tab: Actual Delivery Date:
		+	* '''Truck Air; Truck Dom''': Gen Tab: y. Actual Delivery
		+	* '''Ocean FCL / Truck Ocean''' :  Cont Tab. Actual Delivery (Latest across all containers)
		+
		+	== General Fields ==
		+
		+	For specific User Interface Implementation see also [[Gen Tab]].
	=== Example ===		=== Example ===
-	==== Acadaff Reference Field ====	+	==== Abc Reference Field ====
		+
		+	<section begin=Abc />
	'''Labels:'''		'''Labels:'''
-	* ''Field's [[Standard Long Label]]:'' Acadaff Reference	+	* ''[[Standard Long Label]]:'' Abc Reference
-	* ''Field's [[Standard Short Label]]:'' Aca Ref	+	* ''[[Standard Short Label]]:'' Abc Ref
-	'''BO:'''	+	'''Business Object:'''
-	* ''Field's Meaning:''  Reference from Acadaff system. Used rarely.	+	* ''Meaning:''  Reference from Acadaff system. Used rarely.
-	* ''Field's Format/type:''  [[Datatypes#alphanumeric]], [one letter] + [3 digits] + [-] + [3 digits]	+	* ''Format/type:''  [[Datatypes#alphanumeric]], [one letter] + [3 digits] + [-] + [3 digits]
-	* ''Field's Example:''  C127-987	+	* ''Example:''  C127-987
-	* ''Field's MOTs:'' Air only	+	* ''Mode Of Transport:'' Air only
-	'''CRUD:'''	+	'''Core Add/Edit interface properties:'''
-	* ''Field's Widget:''	+	* ''Widget:''
-	* '' Widget properties: ''	+	* '''CyberTrax Internal:'''
-	** '' default: ''	+	** ''Default value:'' Shippers Address
-	** '' read only? ''	+	** ''Required field?'' Y
-	'''DB:'''	+	* '''CyberTrax Client:'''
-	*	+	** ''Default value:'' Shippers Address
		+	** ''Required field?'' Y
-	=== References ===  <!-------------------------------- refs ---------------------------------->	+	<section end=Abc />
		+
		+	<section begin=aaa/>
		+	* ''Meaning:''  This is the company who placed the PO with the supplier.
		+	* ''Standard Long Label:'' PO Issued by
		+	* ''Standard Short Label:'' PO by
		+	* ''Format/type:''  list of values, [[Datatypes#alphanumeric]]
		+	* ''Min/max:'' from 0 to 30 chars
		+	* ''Possible Values:'' Kik, CEI Holmdel, EA Stamford, CEI Roanoke, Kolmar, Kik, Evergreen (must be managed through admin)
		+	* ''Widget:'' textbox
		+	* ''Default value:'' blank
		+	* ''Required field?'' Y
		+	* ''User Read Access:'' internal, client, planner
		+	* ''User Write Access:'' shipper
		+	* ''Mode Of Transport:'' Truck-Domestic only
		+	<section end=aaa/>
		+
		+	=== Misc ===
		+
		+	==== GRP ====
		+
		+	GRP number that holds this CT.
		+
		+	==== Smallest CT ====
		+
		+	Smallest CT in GRP that holds this CT.
		+
		+	=== References ===
	==== CT Num ====		==== CT Num ====
-	'''Labels:'''
-	* ''Field's [[Standard Long Label]]:''
-	* ''Field's [[Standard Short Label]]:''
-	'''BO:'''	+	===== Number =====
-	* ''Field's Meaning:''	+
-	* ''Field's Format/type:''	+
-	* ''Field's Example:''	+	'''Labels:'''
-	* ''Field's MOTs:''	+	* ''Field's [[Standard Long Label]]:'' CT Number
		+	* ''Field's [[Standard Short Label]]:'' CT #
	==== Export Ref ====		==== Export Ref ====
	'''Labels:'''		'''Labels:'''
-	* ''Field's [[Standard Long Label]]:''	+	* ''Field's [[Standard Long Label]]:'' Export Ref #
-	* ''Field's [[Standard Short Label]]:''	+	* ''Field's [[Standard Short Label]]:'' ExP Ref #
-		+
-	'''BO:'''	+
-	* ''Field's Meaning:''	+
-	* ''Field's Format/type:''	+
-	* ''Field's Example:''	+
-	* ''Field's MOTs:''	+
	==== Import Ref ====		==== Import Ref ====
	'''Labels:'''		'''Labels:'''
-	* ''Field's [[Standard Long Label]]:''	+	* ''Field's [[Standard Long Label]]:'' Import Ref #
-	* ''Field's [[Standard Short Label]]:''	+	* ''Field's [[Standard Short Label]]:'' ImP Ref #
-		+
-	'''BO:'''	+
-	* ''Field's Meaning:''	+
-	* ''Field's Format/type:''	+
-	* ''Field's Example:''	+
-	* ''Field's MOTs:''	+
	==== Customer Ref ====		==== Customer Ref ====
	'''Labels:'''		'''Labels:'''
-	* ''Field's [[Standard Long Label]]:''	+	* ''Field's [[Standard Long Label]]:'' Customer Ref #
-	* ''Field's [[Standard Short Label]]:''	+	* ''Field's [[Standard Short Label]]:'' Client Ref
-		+
-	'''BO:'''	+
-	* ''Field's Meaning:''	+
-	* ''Field's Format/type:''	+
-	* ''Field's Example:''	+
-	* ''Field's MOTs:''	+
	==== Jaguar 3rd Ref ====		==== Jaguar 3rd Ref ====
	'''Labels:'''		'''Labels:'''
-	* ''Field's [[Standard Long Label]]:''	+	* ''Field's [[Standard Long Label]]:'' JFS 3rd Ref #
-	* ''Field's [[Standard Short Label]]:''	+	* ''Field's [[Standard Short Label]]:'' 3rd Ref #
-		+
-	'''BO:'''	+
-	* ''Field's Meaning:''	+
-	* ''Field's Format/type:''	+
-	* ''Field's Example:''	+
-	* ''Field's MOTs:''	+
	=== Dates ===  <!-------------------------------- dates ---------------------------------->		=== Dates ===  <!-------------------------------- dates ---------------------------------->
-	==== Cargo available ====	+	==== Approved On====
-	'''Labels:'''	+	a.k.a. [[CT#Authorized On]]
-	* ''Field's [[Standard Long Label]]:''	+
-	* ''Field's [[Standard Short Label]]:''	+
-	'''BO:'''	+	(with name of person who approved, including the date & time)
-	* ''Field's Meaning:''	+
-	* ''Field's Format/type:''	+	* ''Meaning:'' Shipment was approved for transportation by whom and when.
-	* ''Field's Example:''	+	* ''[[Standard Long Label]]:'' Authorization Date
-	* ''Field's MOTs:''	+	* ''[[Standard Short Label]]:'' Auth Date
		+	* ''Other Labels in use:''
		+	* ''Format/type:'' Read only [[Textarea]]
		+	* ''Min/max:'' [TBD]
		+	* ''Possible Values:'' [TBD]
		+	* ''Widget:'' datebox
		+	* ''Default value:'' Read only - First and last name of the approval user(planner) and date timestamps with (EST) calculated time zone.
		+	* ''Required field?'' Y - when status is approved
		+	* ''User Read Access:'' client, shipper, planner, and Internal
		+	* ''User Write Access:'' internal, and for planner the system automatically pulls current planner's name who approved the shipment
		+	* ''Mode Of Transport:'' All
		+
		+
		+
		+	==== Last Modified DateTime ====
		+	<section begin=LastModifiedDateTime/>
		+	* ''Meaning:'' This is string representation of datetime stamp (with Time Zone) of CT's update.
		+	* ''Standard Long Label:'' Last Modified DateTime
		+	* ''Standard Short Label:'' Last Update On
		+	* ''Format/type:'' textlabel, [[Datatypes#alphanumeric]]
		+	* ''Min/max:'' [[TBD]]
		+	* ''Possible Values:'' Jun 24, 2010 7:18:59 AM (EST)
		+	* ''Widget:'' textlabel
		+	* ''Default value:'' blank
		+	* ''Required field?'' Y
		+	* ''User Read Access:'' internal, client, planner, shipper
		+	* ''User Write Access:'' system (read-only field)
		+	* ''Mode Of Transport:'' All
		+	<section end=LastModifiedDateTime/>
		+
		+	==== Cargo available ====
		+	<section begin=CargoAvailable/>
		+	* ''Meaning:'' This is the date that the goods are available for pick up ''(from Origin Door)''.
		+	* ''[[Standard Long Label]]:'' Cargo Available Date
		+	* ''[[Standard Short Label]]:'' Available Date
		+	* ''Format/type:'' [TBD]
		+	* ''Min/max:'' [TBD]
		+	* ''Possible Values:'' [TBD]
		+	* ''Widget:'' datebox
		+	* ''Default value:'' The date that the record is created
		+	* ''Required field?''
		+	** Internal: N
		+	** Shipper: Y
		+	* ''User Read Access:'' all
		+	* ''User Write Access:'' internal, shipper (unless [[Cybertrax_2.1_Client_(requirements)#What_CTs_Shipper_may_edit_RULE]] is TRUE)
		+	* ''Mode Of Transport:'' All
		+	<section end=CargoAvailable/>
	==== Cargo due ====		==== Cargo due ====
	'''Labels:'''		'''Labels:'''
-	* ''Field's [[Standard Long Label]]:''	+	* ''Meaning:'' This is the date that the goods should be delivered ''(to Destination Door)''.
-	* ''Field's [[Standard Short Label]]:''	+	:* See the first definition [http://mantis.jaguarfreight.com/wiki/Trucking_Optimization_Report#Cargo_due here].
		+	* ''Field's [[Standard Long Label]]:'' Cargo Due Date
		+	* ''Field's [[Standard Short Label]]:'' Due Date
-	'''BO:'''	+	See [[Due_Date_Feature]]
-	* ''Field's Meaning:''	+
-	* ''Field's Format/type:''	+
-	* ''Field's Example:''	+
-	* ''Field's MOTs:''	+
	==== Created On Date ====		==== Created On Date ====
-	'''Labels:'''	+	* ''Meaning:'' This is the date that the CT record was created.
		+
		+	* DB: tblGenericShipment.CreateOnDate
		+
	* ''[[Standard Long Label]]:'' CT created on		* ''[[Standard Long Label]]:'' CT created on
	* ''[[Standard Short Label]]:'' CT created on		* ''[[Standard Short Label]]:'' CT created on
-	* ''Other Labels in use:''	+	* ''Other Labels in use:'' See [[CT_bo#Created_By]] for IE
		+	* ''Format/type:'' [TBD]
		+	* ''Min/max:'' [TBD]
		+	* ''Possible Values:'' [TBD]
		+	* ''Default value:'' The date that the record is created in CT.
		+	* ''Required field?''
		+	** Internal: Y
		+	** Shipper: Y
		+	* ''User Read Access:'' All
		+	* ''User Write Access:'' None
		+	* ''Mode Of Transport:'' All
-	'''BO:'''
-	* ''Field's Meaning:''
-	* ''Field's Format/type:''
-	* ''Field's Example:''
-	* ''Field's MOTs:''
	==== Created By ====		==== Created By ====
Line 186:		Line 245:
	* ''Other Labels in use:''		* ''Other Labels in use:''
-	'''BO:'''	+	==== Time CT Created ====
-	* ''Field's Meaning:''	+
-	* ''Field's Format/type:''	+	'''Labels:'''
-	* ''Field's Example:''	+	* ''[[Standard Long Label]]:'' Time CT created
-	* ''Field's MOTs:''	+	* ''[[Standard Short Label]]:'' Time CT created
		+	* ''Other Labels in use:''
	==== Notification Date  ====		==== Notification Date  ====
	'''Labels:'''		'''Labels:'''
-	* ''[[Standard Long Label]]:'' CT created by	+	* ''[[Standard Long Label]]:'' Notification Date
-	* ''[[Standard Short Label]]:'' CT created by	+	* ''[[Standard Short Label]]:'' Notification Dt
	* ''Other Labels in use:''		* ''Other Labels in use:''
-
-	'''BO:'''
-	* ''Field's Meaning:''
-	* ''Field's Format/type:''
-	* ''Field's Example:''
-	* ''Field's MOTs:''
	==== Authorized On  ====		==== Authorized On  ====
	'''Labels:'''		'''Labels:'''
-	* ''[[Standard Long Label]]:'' CT created by	+	* ''[[Standard Long Label]]:'' Authorization Date
-	* ''[[Standard Short Label]]:'' CT created by	+	* ''[[Standard Short Label]]:'' Authorization Dt
	* ''Other Labels in use:''		* ''Other Labels in use:''
-
-	'''BO:'''
-	* ''Field's Meaning:''
-	* ''Field's Format/type:''
-	* ''Field's Example:''
-	* ''Field's MOTs:''
	==== Estimated Export Pick Up Date ====		==== Estimated Export Pick Up Date ====
	'''Labels:'''		'''Labels:'''
-	* ''[[Standard Long Label]]:'' CT created by	+	* ''[[Standard Long Label]]:'' Estimated Export Pick Up Date
-	* ''[[Standard Short Label]]:'' CT created by	+	* ''[[Standard Short Label]]:'' Est Pick Up Dt
	* ''Other Labels in use:''		* ''Other Labels in use:''
-
-	'''BO:'''
-	* ''Field's Meaning:''
-	* ''Field's Format/type:''
-	* ''Field's Example:''
-	* ''Field's MOTs:''
	==== Estimated Pick Up Date ====		==== Estimated Pick Up Date ====
-	same as above	+	same as [[#Estimated Export Pick Up Date]]
		+
		+	* ''Meaning:''  This is an estimated date of when the pick up trucker is going to pick up the product from the shipper or pick up location.  This is an existing CT2 field, see [[CT#Estimated Pick Up]]
		+	* ''Default value:'' Blank
		+	* ''Required field?'' N
		+	* ''Format/Datatype:'' [[Datebox]],
		+	*  User Read Access: all
		+	* User Write Access: internal
		+	* MOT: all
	==== Actual Export Pick Up Date ====		==== Actual Export Pick Up Date ====
Line 235:		Line 285:
	'''Labels:'''		'''Labels:'''
-	* ''[[Standard Long Label]]:'' CT created by	+	* ''[[Standard Long Label]]:'' Actual Export Pick Up Date
-	* ''[[Standard Short Label]]:'' CT created by	+	* ''[[Standard Short Label]]:'' Act Pick Up Dt
	* ''Other Labels in use:''		* ''Other Labels in use:''
-
-	'''BO:'''
-	* ''Field's Meaning:''
-	* ''Field's Format/type:''
-	* ''Field's Example:''
-	* ''Field's MOTs:''
	====  Actual Pick Up Date ====		====  Actual Pick Up Date ====
	same as [[#Actual Export Pick Up Date]]		same as [[#Actual Export Pick Up Date]]
-	'''Labels:'''	+	'* ''Meaning:'' This is actual date of when the pick up trucker picked up the product from the [[CT#Shipper]] or [[CT#Pick Up]] location.  This is an existing CT2 field, see [[CT#Actual Pick Up]]
-	* ''[[Standard Long Label]]:'' CT created by	+	* ''Default value:'' Blank
-	* ''[[Standard Short Label]]:'' CT created by	+	* ''Required field?'' N
-	* ''Other Labels in use:''	+	* ''Format/Datatype:'' [[Datebox]],
-		+	* User Read Access: all
-	'''BO:'''	+	* User Write Access: internal
-	* ''Field's Meaning:''	+	* MOT: all
-	* ''Field's Format/type:''	+
-	* ''Field's Example:''	+
-	* ''Field's MOTs:''	+
	==== Automated Estimated Delivery Date ====		==== Automated Estimated Delivery Date ====
	'''Labels:'''		'''Labels:'''
-	* ''[[Standard Long Label]]:'' CT created by	+	* ''[[Standard Long Label]]:'' Automated Est Delivery Date
-	* ''[[Standard Short Label]]:'' CT created by	+	* ''[[Standard Short Label]]:'' Auto Est Del Dt
	* ''Other Labels in use:''		* ''Other Labels in use:''
-
-	'''BO:'''
-	* ''Field's Meaning:''
-	* ''Field's Format/type:''
-	* ''Field's Example:''
-	* ''Field's MOTs:''
	=== Locations ===  <!-------------------------------- locat ---------------------------------->		=== Locations ===  <!-------------------------------- locat ---------------------------------->
	==== Origin Country  ====		==== Origin Country  ====
		+	'''Labels:'''
		+	* ''[[Standard Long Label]]:'' Origin Country
		+	* ''[[Standard Short Label]]:'' Origin Country
		+	* ''Other Labels in use:''
		+
		+	Defines country of origin door and related note.
		+
		+	'''Origin Country selector''':
		+
		+	* [[Combobox]] with a list of countries
		+	* UI: Gen Tab > 11. Origin country
		+	* DB: tblGenericShipment.OriginPointCountryId (join with tblCountry)
		+	* Required? No
	==== Origin Country Note ====		==== Origin Country Note ====
		+	'''Labels:'''
		+	* ''[[Standard Long Label]]:'' Origin Country Note
		+	* ''[[Standard Short Label]]:'' Origin Country Note
		+	* ''Other Labels in use:''
	==== Destination Country  ====		==== Destination Country  ====
		+	'''Labels:'''
		+	* ''[[Standard Long Label]]:'' Destination Country
		+	* ''[[Standard Short Label]]:'' Dest Country
		+	* ''Other Labels in use:''
		+
		+	Defines country of destination door and related note.
		+
		+	* [[Combobox]] with a list of countries
		+	* UI: Gen Tab > 12. Destination country
		+	* DB: tblGenericShipment.DestinationPointCountryId (join with tblCountry)
		+	* Required? No
		+
		+	'''Destination Country selector''':
	==== Destination Country Note ====		==== Destination Country Note ====
		+	'''Labels:'''
		+	* ''[[Standard Long Label]]:'' Destination Country Note
		+	* ''[[Standard Short Label]]:'' Dest Country Note
		+	* ''Other Labels in use:''
	==== Shipper  ====		==== Shipper  ====
		+	<section begin=Shipper/>
		+	* ''Meaning:'' This is the company's name & address of who is placing the shipping request.  This company name and address can also be the pick up location.
		+	* Gen Tab > 2. Shipper (T1):
		+	* ''Standard Long Label:'' Shipper
		+	* ''Standard Short Label:'' Shipper
		+	* ''Format/type:''  list of values, [[Datatypes#alphanumeric]]
		+	* ''Min/max:''
		+	* ''Possible Values:''
		+	* ''Widget:'' listbox
		+	* ''Default value:''
		+	** Internal: blank
		+	** Shipper: Shipper(T1)" from "Shipper profile" - Enable Shipper/Supplier Role
		+	* ''Required field?''
		+	** Internal: N
		+	** Shipper: Y
		+	* ''User Read Access:'' all
		+	* ''User Write Access:'' internal
		+	* ''Mode Of Transport:'' All
		+	<section end=Shipper/>
		+	===== Shipper State =====
		+	This is a [[Derived field]]
		+	* ''mapping:'' [[Address#State]] for [[CT#Shipper]]
		+	* ''label on xls:''  Shipper State
		+	'''Labels:'''
		+	* ''[[Standard Long Label]]:'' Shipper State
		+	* ''[[Standard Short Label]]:'' Shipper State
		+	* ''Other Labels in use:''
		+	===== Shipper ZIP =====
		+	This is a [[Derived field]]
		+	* ''mapping:'' [[Address#Zip]] for [[CT#Shipper]]
		+	* ''label on xls:''  Shipper ZIP
		+	'''Labels:'''
		+	* ''[[Standard Long Label]]:'' Shipper ZIP
		+	* ''[[Standard Short Label]]:'' Shipper ZIP
		+	* ''Other Labels in use:''
	==== Shipper Address ====		==== Shipper Address ====
	textarea below [[Shipper]]		textarea below [[Shipper]]
		+
		+	'''Labels:'''
		+	* ''[[Standard Long Label]]:'' Shipper Address
		+	* ''[[Standard Short Label]]:'' Shipper Address
		+	* ''Other Labels in use:''
	==== Consignee ====		==== Consignee ====
		+	* Gen Tab > 3. Consignee (T2):
		+	'''Labels:'''
		+	* ''[[Standard Long Label]]:'' Consignee
		+	* ''[[Standard Short Label]]:'' Cnee
		+	* ''Other Labels in use:''
		+	===== Consignee State =====
		+	This is a [[Derived field]]
		+	* ''mapping:'' [[Address#State]] for [[CT#Consignee]]
		+	* ''label on xls:''  Consignee State
		+	'''Labels:'''
		+	* ''[[Standard Long Label]]:'' Consignee State
		+	* ''[[Standard Short Label]]:'' Consignee State
		+	* ''Other Labels in use:''
		+	===== Consignee ZIP =====
		+	This is a [[Derived field]]
		+	* ''mapping:'' [[Address#Zip]] for [[CT#Consignee]]
		+	* ''label on xls:''  Consignee ZIP
		+	'''Labels:'''
		+	* ''[[Standard Long Label]]:'' Consignee ZIP
		+	* ''[[Standard Short Label]]:'' Consignee ZIP
		+	* ''Other Labels in use:''
	==== Consignee Address ====		==== Consignee Address ====
		+	'''Labels:'''
		+	* ''[[Standard Long Label]]:'' Consignee Address
		+	* ''[[Standard Short Label]]:'' Cnee Address
		+	* ''Other Labels in use:''
	==== Notify ====		==== Notify ====
		+	'''Labels:'''
		+	* ''[[Standard Long Label]]:'' Notify Party
		+	* ''[[Standard Short Label]]:'' Ntfy Party
		+	* ''Other Labels in use:''
	==== Notify Address ====		==== Notify Address ====
		+	'''Labels:'''
		+	* ''[[Standard Long Label]]:'' Notify Address
		+	* ''[[Standard Short Label]]:'' Ntfy Address
		+	* ''Other Labels in use:''
	==== Export Pick Up ====		==== Export Pick Up ====
		+	<section begin=ExportPickUp/>
		+	* ''Meaning:'' This is the location of where the goods are actually located and shipping from.
		+	* ''[[Standard Long Label]]:'' Export Pick Up
		+	* ''[[Standard Short Label]]:'' Exp Pick Up
		+	* ''Other Labels in use:''
		+	* ''Format/type:'' This field contains Company-City-Note
		+	* ''Min/max:'' [TBD]
		+	* ''Possible Values:'' [TBD]
		+	* ''Widget:'' searchbox
		+	* ''Default value:''
		+	** Internal: blank
		+	** Shipper: "Copy from Shipper:" is checked (Yes) and "Pick up Location" is filled from "Shipper"
		+	* ''Required field?''
		+	** Internal: N
		+	** Shipper: Y
		+	* ''User Read Access:'' all
		+	* ''User Write Access:'' internal, shipper unless [[Cybertrax_2.1_Client_(requirements)#What_CTs_Shipper_may_edit_RULE]] is true
		+	* ''Mode Of Transport:'' All
		+	<section end=ExportPickUp/>
	===== Pick Up =====		===== Pick Up =====
	same as [[#Export Pick Up]]		same as [[#Export Pick Up]]
		+
		+	'''Labels:'''
		+	* ''[[Standard Long Label]]:'' Pick Up
		+	* ''[[Standard Short Label]]:'' Pick Up
		+	* ''Other Labels in use:''
	===== Pick Up State =====		===== Pick Up State =====
Line 305:		Line 471:
	* ''mapping:'' [[Address#State]] from [[CT#Pick Up]]		* ''mapping:'' [[Address#State]] from [[CT#Pick Up]]
	* ''Standard Long Label:'' Pick Up State		* ''Standard Long Label:'' Pick Up State
-	* ''Standard Short Label:''	+	* ''Standard Short Label:'' Pick Up State
		+	'''Labels:'''
	===== Pick Up Zip =====		===== Pick Up Zip =====
Line 312:		Line 479:
	* ''mapping:'' [[Address#Zip]] from [[CT#Pick Up]]		* ''mapping:'' [[Address#Zip]] from [[CT#Pick Up]]
	* ''Standard Long Label:'' Pick Up Zip		* ''Standard Long Label:'' Pick Up Zip
-	* ''Standard Short Label:''	+	* ''Standard Short Label:'' Pick Up Zip
-		+
	===== Pick Up Company =====		===== Pick Up Company =====
Line 319:		Line 485:
	"Company Name" from [[#Pick Up]]		"Company Name" from [[#Pick Up]]
-	==== Export Pick Up Address ====	+	'''Labels:'''
		+	* ''[[Standard Long Label]]:'' Pick Up Company
		+	* ''[[Standard Short Label]]:'' Pick Up Comp
		+	* ''Other Labels in use:''
		+
		+	==== Pick Up Address ====
		+	'''Labels:'''
		+	* ''[[Standard Long Label]]:'' Export Pick Up Address
		+	* ''[[Standard Short Label]]:'' Exp Pick Up Address
		+	* ''Other Labels in use:''
		+
		+	===== Export Pick Up Address =====
		+	same as [[#Pick Up Address]]
	==== Export Delivery To   ====		==== Export Delivery To   ====
		+	'''Labels:'''
		+	* ''[[Standard Long Label]]:'' Export Delivery To
		+	* ''[[Standard Short Label]]:'' Exp Delivery To
		+	* ''Other Labels in use:''
	==== Delivery To ====		==== Delivery To ====
-
	same as [[#Export Delivery To]]		same as [[#Export Delivery To]]
		+	<section begin=DeliveryTo/>
		+	* ''Meaning:'' This is the location of where the goods are shipping to.
		+	* ''[[Standard Long Label]]:'' Delivery To
		+	* ''[[Standard Short Label]]:'' Delivery To
		+	* ''Other Labels in use:''
		+	* ''Format/type:'' This field contains Company-City-Note
		+	* ''Min/max:'' [TBD]
		+	* ''Possible Values:'' [TBD]
		+	* ''Widget:'' searchbox
		+	* ''Default value:'' blank
		+	* ''Required field?''
		+	** Internal: N
		+	** Shipper: Y (NOTE: Ship To location from portal should map to Delivery To(T5) on Internal App as well as and Consignee (T2) field on the Internal App)
		+	* ''User Read Access:'' all
		+	* ''User Write Access:'' internal, shipper unless [[Cybertrax_2.1_Client_(requirements)#What_CTs_Shipper_may_edit_RULE]] is true
		+	* ''Mode Of Transport:'' All
		+	<section end=DeliveryTo/>
	===== Ship to State =====		===== Ship to State =====
-	* ''label on xls:''  Ship to State
	* ''mapping:'' [[Address#State]] for [[Ct#Delivery_To]]		* ''mapping:'' [[Address#State]] for [[Ct#Delivery_To]]
		+
		+	* ''label on xls:''  Ship to State
		+	'''Labels:'''
		+	* ''[[Standard Long Label]]:'' Ship to State
		+	* ''[[Standard Short Label]]:'' Ship to State
		+	* ''Other Labels in use:''
	===== Ship to Zip =====		===== Ship to Zip =====
-	* ''label on xls:''  Ship to Zip
	* ''mapping:'' [[Address#State]] for [[Ct#Delivery_To]]		* ''mapping:'' [[Address#State]] for [[Ct#Delivery_To]]
		+
		+	* ''label on xls:''  Ship to Zip
		+	'''Labels:'''
		+	* ''[[Standard Long Label]]:'' Ship to Zip
		+	* ''[[Standard Short Label]]:'' Ship to Zip
		+	* ''Other Labels in use:''
	==== Export Delivery To Address  ====		==== Export Delivery To Address  ====
		+	'''Labels:'''
		+	* ''[[Standard Long Label]]:'' Export Delivery To Address
		+	* ''[[Standard Short Label]]:'' Exp Del to Address
		+	* ''Other Labels in use:''
	==== Consol Warehouse ====		==== Consol Warehouse ====
		+	'''Labels:'''
		+	* ''[[Standard Long Label]]:'' Consol Warehouse
		+	* ''[[Standard Short Label]]:'' Consol Whse
		+	* ''Other Labels in use:''
	=== Client and Visibility  ===  <!-------------------------------- client / vizi ------------------>		=== Client and Visibility  ===  <!-------------------------------- client / vizi ------------------>
Line 344:		Line 560:
	'''Labels:'''		'''Labels:'''
-	* ''[[Standard Long Label]]:'' E0 Client Company	+	* ''[[Standard Long Label]]:'' Client Company
	* ''[[Standard Short Label]]:'' E0 Client		* ''[[Standard Short Label]]:'' E0 Client
	* ''Other Labels in use:''		* ''Other Labels in use:''
	==== E1 ====		==== E1 ====
		+
		+	'''Labels:'''
		+	* ''[[Standard Long Label]]:'' Visibility 1
		+	* ''[[Standard Short Label]]:'' Vis 1
		+	* ''Other Labels in use:''
	==== E2 ====		==== E2 ====
		+
		+	'''Labels:'''
		+	* ''[[Standard Long Label]]:'' Visibility 2
		+	* ''[[Standard Short Label]]:'' Vis 2
		+	* ''Other Labels in use:''
	==== E3 ====		==== E3 ====
-		+	'''Labels:'''
-		+	* ''[[Standard Long Label]]:'' Visibility 3
		+	* ''[[Standard Short Label]]:'' Vis 3
		+	* ''Other Labels in use:''
	=== Commodity related fields ===  <!--------------------- commod ----------------------->		=== Commodity related fields ===  <!--------------------- commod ----------------------->
	==== Pick Up Comments ====		==== Pick Up Comments ====
		+
		+	'''MO (Marc) advised Field should be renamed (instructions instead of comments)'''
		+	<section begin=PickUpInstructions/>
		+	* ''Meaning:'' This field is for the user to list any specific pick up instructions for the trucking company.
		+	* ''[[Standard Long Label]]:'' Pick Up Comments
		+	* ''[[Standard Short Label]]:'' Pick Up Instr.
		+	* ''Other Labels in use:''
		+	* ''Format/type:'' alphanumeric
		+	* ''Min/max:'' [[TBD]]
		+	* ''Possible Values:'' [[TBD]]
		+	* ''Widget:'' textbox
		+	* ''Default value:'' blank
		+	* ''Required field?''
		+	** Internal: N
		+	** Shipper: N
		+	* ''User Read Access:'' all
		+	* ''User Write Access:'' internal, shipper unless [[Cybertrax_2.1_Client_(requirements)#What_CTs_Shipper_may_edit_RULE]] is true
		+	* ''Mode Of Transport:'' All
		+	<section end=PickUpInstructions/>
	==== Commodity Description ====		==== Commodity Description ====
		+	<section begin=CommodityDescription/>
		+	* ''Meaning:'' This field is for the user to list a general description of the contents being shipped.
		+	* ''[[Standard Long Label]]:'' Commodity Description
		+	* ''[[Standard Short Label]]:'' Goods Shipped:
		+	* ''Other Labels in use:''
		+	* ''Format/type:'' [[TBD]]
		+	* ''Min/max:'' [[TBD]]
		+	* ''Possible Values:'' [[TBD]]
		+	* ''Widget:'' textarea
		+	* ''Default value:'' blank
		+	* ''Required field?''
		+	** Internal: N
		+	** Shipper: N
		+	* ''User Read Access:'' All
		+	* ''User Write Access:'' internal, shipper unless [[Cybertrax_2.1_Client_(requirements)#What_CTs_Shipper_may_edit_RULE is true]]
		+	* ''Mode Of Transport:'' All
		+	<section end=CommodityDescription/>
	==== Marks And Numbers ====		==== Marks And Numbers ====
		+	<section begin=MarksAndNumbers/>
		+	* ''Meaning:''
		+	* ''[[Standard Long Label]]:'' Marks and Numbers
		+	* ''[[Standard Short Label]]:'' Marks & Numbers
		+	* ''Other Labels in use:''
		+	* ''Format/type:''
		+	* ''Min/max:'' [TBD]
		+	* ''Possible Values:'' [TBD]
		+	* ''Widget:'' textbox
		+	* ''Default value:'' No
		+	* ''Required field?'' Y
		+	* ''User Read Access:'' client, planner
		+	* ''User Write Access:'' internal, shipper
		+	* ''Mode Of Transport:'' All
		+	<section end=MarksAndNumbers/>
	==== Hazardous Yes No ====		==== Hazardous Yes No ====
		+	<section begin=HazardousYesNo/>
-	==== Hazardous Note ====	+	* ''Meaning:'' This is to advise if the product shipping is hazardous or not.
		+	* ''Location:'' Gen Tab
		+	* ''Mode Of Transport:'' All but Truck modes
		+	* ''[[Standard Long Label]]:'' Hazardous Yes No
		+	* ''[[Standard Short Label]]:'' Haz Y N
		+	* ''Other Labels in use:''
		+	* ''Format/type:'' [[Radio]] option [Yes][No]
		+	* ''Min/max:'' n/a
		+	* ''Possible Values:'' Yes, No
		+	* ''Widget:'' radiogroup
		+	* ''Default value:'' No
		+	* ''Required field?'' N
		+	* ''User Read Access:'' client
		+	* ''User Write Access:'' internal
		+	<section end=HazardousYesNo/>
		+	==== Hazardous Note ====
		+	'''Labels:'''
		+	* ''[[Standard Long Label]]:'' Hazardous Note
		+	* ''[[Standard Short Label]]:'' Haz Note
		+	* ''Other Labels in use:''
	=== Authorization related fields ===  <!--------------------- auth ----------------------->		=== Authorization related fields ===  <!--------------------- auth ----------------------->
	==== Authorized By ====		==== Authorized By ====
		+	<section begin=AuthorizedBy/>
		+	* ''Meaning:'' [[TBD]]
		+	* ''[[Standard Long Label]]:'' Authorized By
		+	* ''[[Standard Short Label]]:'' Auth By
		+	* ''Other Labels in use:''
		+	* ''Format/type:'' [[TBD]]
		+	* ''Min/max:'' n/a
		+	* ''Possible Values:'' [[TBD]]
		+	* ''Widget:'' [[TBD]]
		+	* ''Default value:'' [[TBD]]
		+	* ''Required field?'' Y for approved shipment
		+	* ''User Read Access:'' client, planner, shipper, and Internal
		+	* ''User Write Access:'' Internal, and for planner the system automatically pulls current planner's name who approved the shipment
		+	* ''Mode Of Transport:'' All
		+	<section end=AuthorizedBy/>
	==== Authorized MOT ====		==== Authorized MOT ====
		+
		+	'''Labels:'''
		+	* ''Field's [[Standard Long Label]]:'' Authorized MOT
		+	* ''Field's [[Standard Short Label]]:'' Authzd MOT
	==== Authorization Method ====		==== Authorization Method ====
-		+	'''Labels:'''
-		+	* ''Field's [[Standard Long Label]]:'' Authorization Method
		+	* ''Field's [[Standard Short Label]]:'' Auth via
	=== Vendors ===  <!--------------------- vend----------------------->		=== Vendors ===  <!--------------------- vend----------------------->
	==== Export Pick Up Trucker ====		==== Export Pick Up Trucker ====
		+
		+	'''MO (Marc), feels these 2 fields should be labeled the same'''
		+
		+	'''Labels:'''
		+	* ''Field's [[Standard Long Label]]:'' Pick Up Trucker
		+	* ''Field's [[Standard Short Label]]:'' Pick Up Trucker
	===== Pick Up Trucker =====		===== Pick Up Trucker =====
	same as above		same as above
		+	* ''Meaning:'' This is the name of the trucker who will pick up the product once it is approved to ship.
		+	* ''Default value:'' Blank
		+	* ''Required field?'' N
		+	* ''Format/Datatype:'' [[CT_profile#ComboBox]], see [[CT#Pick Up Trucker]]
		+	*  User Read Access: all
		+	* User Write Access: internal
		+	* MOT: all
		+	===== Routed Date =====
		+	<section begin=RoutedDate/>
		+	* ''Meaning:'' It is a date that a pick up trucker was assigned.
		+	* ''[[Standard Long Label]]:'' Routed on Date
		+	* ''[[Standard Short Label]]:'' Routed on Dt
		+	* ''Other Labels in use:''
		+	* ''Format/type:'' read only [[Datebox]] with out clear function
		+	* ''Min/max:'' n/a
		+	* ''Possible Values:'' [[TBD]]
		+	* ''Widget:'' [[TBD]]
		+	* ''Default value:'' same date as a pick up trucker is assigned
		+	* ''Required field?'' Y - when [[#Pick Up Trucker]] is assigned
		+	* ''User Read Access:'' Internal
		+	* ''User Write Access:'' System automatically set this date when a pick up trucker is assigned
		+	* ''Mode Of Transport:'' Truck-Domestic Only
		+	<section end=RoutedDate/>
	=== Misc ===  <!-------------------------------- misc ---------------------------------->		=== Misc ===  <!-------------------------------- misc ---------------------------------->
-	==== Mode Of Transport ====	+	==== CT Number ====
		+
		+	==== PO Issued by ====
		+	<section begin=POIssuedby/>
		+	* ''Meaning:''  This is the company who placed the PO with the supplier.
		+	* ''Standard Long Label:'' PO Issued by
		+	* ''Standard Short Label:'' PO by
		+	* ''Format/type:''  list of values, [[Datatypes#alphanumeric]]
		+	* ''Min/max:'' from 0 to 30 chars
		+	* ''Possible Values:'' see [[Cybertrax_2.1_Client_(requirements)#Admin_for_PO_issued_by_CT_field]]
		+	* ''Widget:'' listbox
		+	* ''Default value:'' blank
		+	* ''Required field?''
		+	** internal: N
		+	** shipper: Y
		+	* ''User Read Access:'' all
		+	* ''User Write Access:'' internal, shipper unless [[Cybertrax_2.1_Client_(requirements)#What_CTs_Shipper_may_edit_RULE]] is true
		+	* ''Mode Of Transport:'' Truck-Domestic only
		+	<section end=POIssuedby/>
		+
		+	==== CT Authorization status ====
		+	<section begin=CTAuthorizationStatus/>
		+	* ''Meaning:'' It allows a planner to set a status (approve, reject, or hold) to any shipments created by a supplier.
		+	* ''Standard Long Label:'' CT Authorization Status
		+	* ''Standard Short Label:'' Authorization Status
		+	* ''Format/type:'' [[Listbox]] with option to choose one of three choices
		+	* ''Min/max:'' [[TBD]]
		+	* ''Possible Values:'' Approve, Reject, Hold
		+	* ''Widget:'' listbox
		+	* ''Default value:'' blank
		+	* ''Required field?''
		+	** Internal: N/A
		+	** Shipper: N/A
		+	** Planner: N unless they want to set the authorization status (Approve, Reject, Hold)
		+	* ''User Read Access:'' client, shipper, planner, and Internal only if the status is approved
		+	* ''User Write Access:'' planner
		+	* ''Mode Of Transport:'' Truck-Domestic only
		+	<section end=CTAuthorizationStatus/>
		+
		+	==== Approved For Delivery By Date ====
		+	<section begin=ApprovedForDate/>
		+	"Approved for" date feature acts as a ‘hold to ship date’ – meaning hold until (IE 05/24/10) before scheduling the pick up.
		+	* ''Meaning:'' It allows a planner to place a shipment on hold until a particular date. System will automatically approve on the date selected at 12:01 AM. This field can be updated anytime until 3 days before the date selected
		+	* ''Standard Long Label:'' Approved For Delivery By
		+	* ''Standard Short Label:'' Approved For Delivery By
		+	* ''Format/type:'' [[Datebox]] with a clear button
		+	* ''Min/max:'' [[TBD]]
		+	* ''Possible Values:'' [[TBD]]
		+	* ''Widget:'' datebox
		+	* ''Default value:'' blank
		+	* ''Required field?''
		+	** Internal: N/A
		+	** Shipper: N/A
		+	** Planner: N unless they want to set the authorization status to Hold with Date
		+	* ''User Read Access:'' shipper, planner, and client and Internal will only see when system automatically approves on the date selected by planner.
		+	* ''User Write Access:'' planner
		+	* ''Mode Of Transport:'' Truck-Domestic only
		+	<section end=ApprovedForDate/>
		+
		+	==== Authorization Comment ====
		+	<section begin=AuthorizationComment/>
		+	Reason for placing a shipment on hold or rejecting a shipment.
		+	* ''Meaning:'' It allows a planner to note to the supplier why they are holding or rejecting a shipment.
		+	* ''Standard Long Label:'' Authorization Comment
		+	* ''Standard Short Label:'' Auth. Comment
		+	* ''Format/type:'' [[Textarea]]
		+	* ''Min/max:'' [[TBD]]
		+	* ''Possible Values:'' [[TBD]]
		+	* ''Widget:'' [[Textarea]]
		+	* ''Default value:'' blank
		+	* ''Required field?'' N
		+	* ''User Read Access:'' shipper, planner
		+	* ''User Write Access:'' planner
		+	* ''Mode Of Transport:'' Truck-Domestic only
		+	* ''Addition Info:'' It is a field on a shipment record that records status, reason, by whom and when. Last updated info will be on the top.
		+	<section end=AuthorizationComment/>
		+
		+	==== Transport Mode ====
		+
		+	'''Labels:'''
		+	* ''Field's [[Standard Long Label]]:'' Transport Mode
		+	* ''Field's [[Standard Short Label]]:'' MOT
	===== MOT =====		===== MOT =====
	same as [[#Mode Of Transport]]		same as [[#Mode Of Transport]]
		+
		+	'''Labels:'''
		+	* ''Field's [[Standard Long Label]]:'' MOT
		+	* ''Field's [[Standard Short Label]]:'' MOT
		+
		+	==== Transport Mode Type ====
		+
		+	See [[MOT#Type]]
	==== Client Mode ====		==== Client Mode ====
-	==== Operator Of Last Change ====	+	'''Labels:'''
		+	* ''Field's [[Standard Long Label]]:'' Client Mode
		+	* ''Field's [[Standard Short Label]]:'' Client Mode
		+
		+	==== Operator Of Last Change ====
		+
		+	<section begin=LastUpdateBy/>
		+
		+	* DB: tblGenericShipment.LastModifiedUserId
		+
		+	* ''Meaning:'' [[TBD]]
		+	* ''[[Standard Long Label]]:'' Operator of Last Change
		+	* ''[[Standard Short Label]]:'' Last update by
		+	* ''Format/type:'' read-only [[Textarea]]
		+	* ''Min/max:'' [[TBD]]
		+	* ''Possible Values:'' [[TBD]]
		+	* ''Widget:'' [[Textarea]]
		+	* ''Default value:'' blank
		+	* ''Required field?'' Y
		+	* ''User Read Access:'' internal, client, shipper, planner
		+	* ''User Write Access:'' read-only field
		+	* ''Mode Of Transport:'' All
		+	<section end=LastUpdateBy/>
	==== Shipping Terms  ====		==== Shipping Terms  ====
		+
		+	'''Labels:'''
		+	* ''Field's [[Standard Long Label]]:'' Shipping Terms
		+	* ''Field's [[Standard Short Label]]:'' Ship Terms
	==== Shipping Terms Location ====		==== Shipping Terms Location ====
		+	'''Labels:'''
		+	* ''Field's [[Standard Long Label]]:'' Shipping Terms Location
		+	* ''Field's [[Standard Short Label]]:'' Ship Terms Loc
		+
	==== On Customer Hold ====		==== On Customer Hold ====
Line 417:		Line 884:
	* ''Edit panel (CRUD):'' see [[Gen Tab#On Customer Hold]]		* ''Edit panel (CRUD):'' see [[Gen Tab#On Customer Hold]]
	* ''DB:''		* ''DB:''
		+
		+	'''Labels:'''
		+	* ''Field's [[Standard Long Label]]:'' On Customer Hold
		+	* ''Field's [[Standard Short Label]]:'' On Cust Hold
	==== Pending Approval ====		==== Pending Approval ====
-	* ''Meaning:''	+	* ''Meaning:'' A CT record is awaiting authorization from a planner or EM before the product can ship from a supplier's facility.
	* ''Format/type:'' List of values: {true, false}		* ''Format/type:'' List of values: {true, false}
	* ''Default: ''  false		* ''Default: ''  false
Line 426:		Line 897:
	* ''Edit panel (CRUD):''		* ''Edit panel (CRUD):''
	* ''DB:''		* ''DB:''
		+
		+	'''Labels:'''
		+	* ''Field's [[Standard Long Label]]:'' Pending Approval
		+	* ''Field's [[Standard Short Label]]:'' Pndg Apprv
	==== PT Number ====		==== 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.	+	* 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.
		+
		+	* This ID will pass through CT2 through TMS - this is a change - re-architect field to alphanumeric (text field) -- as this info will be pass through Cybertrax by Descartes. It is editable field. -- [[User: Tira|Tira]] 10.30 AM, 24 Aug 2012 (UTC)
	* editable (this is a change - it used to be read only; --[[User:Alex|Alex]] 02:03, 17 April 2010 (UTC)))		* editable (this is a change - it used to be read only; --[[User:Alex|Alex]] 02:03, 17 April 2010 (UTC)))
	* located on Gen tab next to [[CT#Export Pick Up Trucker]]		* located on Gen tab next to [[CT#Export Pick Up Trucker]]
Line 434:		Line 911:
	see also [[Update_Fields_for_Virtual_Group#Updating_PT_and_DT_fields]]		see also [[Update_Fields_for_Virtual_Group#Updating_PT_and_DT_fields]]
		+
		+	'''Labels:'''
		+	* ''Field's [[Standard Long Label]]:'' PT Number
		+	* ''Field's [[Standard Short Label]]:'' PT #
		+
		+
		+	* * editable
		+	* located on Gen tab below [[#Cargo_due]]
		+	* default: blank
		+	* NOTE:
		+
		+	see also [[Update_Fields_for_Virtual_Group#Updating_Trailer_ID_field]]
		+
		+	'''Labels:'''
		+	* ''Field's [[Standard Long Label]]:'' Trailer ID
		+	* ''Field's [[Standard Short Label]]:'' Trailer #
	==== DT Number ====		==== 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.		* 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; --[[User:Alex|Alex]] 02:03, 17 April 2010 (UTC)))	+	* This ID will pass through CT2 through TMS - this is a change - re-architect field to alphanumeric (text field) -- as this info will be pass through Cybertrax by Descartes. It is editable field. -- [[User: Tira|Tira]] 10.30 AM, 24 Aug 2012 (UTC)
		+	* editable (this is a change - it used to be read only; --[[User:Alex|Alex]] 02:03, 17 April 2010 (UTC)))
	* located on Gen tab next to [[#Delivery Trucker]]		* located on Gen tab next to [[#Delivery Trucker]]
	* default: blank		* default: blank
Line 444:		Line 938:
	see also [[Update_Fields_for_Virtual_Group#Updating_PT_and_DT_fields]]		see also [[Update_Fields_for_Virtual_Group#Updating_PT_and_DT_fields]]
-	== Export Fields ==	+	'''Labels:'''
		+	* ''Field's [[Standard Long Label]]:'' DT Number
		+	* ''Field's [[Standard Short Label]]:'' DT #
-	See also [[Exp Tab]].	+	==== TMSS field ====
-	<TABLE border="1">	+	*Meaning: This is a header displayed on edit of CT record with values and updates after events between CT2 & the TM system.
-	<TR>	+	*Format/type: Alphanumeric ?
-	<TD bgcolor="tomato">LCL/AIR</TD>	+	*Examples:
-	<TD><b>AIR - bold</b></TD>	+	** ''yet = CT was never imported yet (default value)
-	<TD><i>AIR/FCL/LCL - italic</i></TD>	+	** ''importX = CT was Imported into TMS X times (Example: import1, import2)''
-	<TD>FCL/LCL - regular</TD>	+	** ''loadX = shipment received Load Plan X times''
-	</TR>	+	** ''statusX = shipment received Status Message X times''
-	</TABLE>	+	** ''post updates to CT updates log''
		+	*MOT: Truck domesitc
		+	*Default: ?
		+	*Master field?: N
		+	*CRUD:
-	This is just to cross reference current implementation with Business Object Fields defined in this wiki.	+	==== Pro Number ====
		+	* Pro Number is a unique id number that is generated directly by a trucker when they receive a tender request that is automatically sent to them via the TMS.  It is a tag that a trucker assigns to our CT record for the truckers easy tracking reference.
-	<TABLE border="1">	+	* Change: field should be editable by JFS users
-	<TR>	+	* location?
-	<TD>[[#Freight Prepaid Collect]]</TD>	+	* default: blank
-	<TD></TD>	+	* format: Alphanumeric - allowing for 25 characters
-	<TD></TD>	+
-	<TD></TD>	+
-	</TR>	+
-	<TR >	+
-	<TD bgcolor="tomato">[[#Arrival Into Warehouse]]</TD>	+
-	<TD></TD>	+
-	<TD></TD>	+
-	<TD></TD>	+
-	</TR>	+
-	<TR>	+
-	<TD>[[#Move Type/HBL]]  <br/> [[#Original House Bill Yes No]] </TD>	+
-	<TD>[[#Steamshipline]] /  <B>[[#Airline]]</B>  <br/> [[#Co Loaders]] <br/> [[#Booking Num]] /  <B>[[#HAWB]] </B> </TD>	+
-	<TD>[[#MBL]] / <B>[[#MAWB]]</B> <br/> [[#HBL]] <br/> [[#AMS Submission Date]] </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>	+	'''Labels:'''
-	<TD>[[#Origin Terminal]] <br> [[#Origin Terminal Estimated Date]] <br> [[#Origin Terminal Actual Date]] </TD>	+	* ''Field's [[Standard Long Label]]:'' Pro Number
-	<TD>[[#Port Of Loading]] / <b>[[#Airport Of Departure]] </b> <br> [[#Port Of Loading Estimated Date]] / <b>[[#Airport Of Departure Estimated Date]] </b> <br> [[#Port Of Loading Actual Date]] / <b>[[#Airport Of Departure Actual Date]] </b></TD>	+	* ''Field's [[Standard Short Label]]:'' Pro #
-	<TD> [[#Trans Shipment]] <br> [[#Trans Shipment Estimated Date]] <br> [[#Trans Shipment Actual Date]]  </TD>	+
-	<TD>[[#Port Of Discharge]] / <b>[[#Airport Of Destination]] </b> <br> [[#Port Of Discharge Estimated Date]] / <b>[[#Airport Of Destination Estimated Date]] </b> <br> [[#Port Of Discharge Actual Date]] / <b>[[#Airport Of Destination Actual Date]] </b></TD>	+
-	</TR>	+
-	<TR>	+	==== Load Number ====
-	<TD>[[#Destination Terminal]] <br> [[#Destination Terminal Estimated Date]] <br> [[#Destination Terminal Actual Date]] </TD>	+
-	<TD>''[[#Destination Receiving Agent]] combobox <br> [[#Cubic Meter]] textbox <br>'' '''[[#Chargeable Weight]]''' textbox </TD>	+
-	<TD> [[#HBL Comment]] <br>  '''[[#HAWB Comment]]''' </TD>	+
-	<TD>''[[#Export Customs Information]]''</TD>	+
-	</TR>	+
-	</TABLE>	+	* Load Number is a unique id number that is generated directly inside of the TMS when Jag operator sends a tender request.  It is a tag used when a user sends a pickup & delivery request to a trucker.
		+
		+	* Change: field should be editable by JFS users
		+	* location?
		+	* default: blank
		+	* format: Alphanumeric - allowing for 25 characters
		+
		+	'''Labels:'''
		+	* ''Field's [[Standard Long Label]]:'' Load Number
		+	* ''Field's [[Standard Short Label]]:'' LD #
		+
		+	See also [[Load#Number]]
		+
		+	==== Trailer ID ====
		+
		+	<s>* Pick up/Delivery Trailer id - Unique id generated by trucker company. This ID will pass through CT2 through TMS. This is the tag to identify what CTs belong to the given  Truck Load.
		+	* * editable
		+	* located on Gen tab below [[#Cargo_due]]
		+	* default: blank
		+
		+	see also [[Update_Fields_for_Virtual_Group#Updating_Trailer_ID_field]]
		+
		+	'''Labels:'''
		+	* ''Field's [[Standard Long Label]]:'' Trailer ID
		+	* ''Field's [[Standard Short Label]]:'' Trailer #
		+	</s> --> reuse [[CT_bo#PT_Number]] and [[CT_bo#DT_Number]]
		+
		+	== Export Fields ==
	=== FedEx carrier ID ===		=== FedEx carrier ID ===
Line 506:		Line 1,011:
	* ''CRUD:'' [[Exp Tab#FedEx carrier ID]]		* ''CRUD:'' [[Exp Tab#FedEx carrier ID]]
-	=== Freight Prepaid Collect ===	+	'''Labels:'''
-	=== Arrival Into Warehouse  ===	+	* ''Field's [[Standard Long Label]]:'' FedEx ID #
		+	* ''Field's [[Standard Short Label]]:'' FedEx ID #
		+
		+	=== Freight Prepaid Collect ===
		+
		+	'''Labels:'''
		+	* ''Field's [[Standard Long Label]]:'' Freight Prepaid Collect
		+	* ''Field's [[Standard Short Label]]:'' Freight PP/CC
		+
		+	=== Arrival Into Warehouse  ===
		+
		+	'''Labels:'''
		+	* ''Field's [[Standard Long Label]]:'' Arrival Into Warehouse
		+	* ''Field's [[Standard Short Label]]:'' Arrvl Into Whse
		+
	=== Move Type/HBL ===		=== Move Type/HBL ===
		+
		+	'''Labels:'''
		+	* ''Field's [[Standard Long Label]]:'' Move Type/HBL
		+	* ''Field's [[Standard Short Label]]:'' Move Type/HBL
		+
	=== Original House Bill Yes No  ===		=== Original House Bill Yes No  ===
-	=== Steamshipline  ===	+
		+	'''Labels:'''
		+	* ''Field's [[Standard Long Label]]:'' Original House Bill Yes No
		+	* ''Field's [[Standard Short Label]]:'' Original HBL Y N
		+
		+	=== Steamshipline  ===
		+
		+	'''Labels:'''
		+	* ''Field's [[Standard Long Label]]:'' Steamship Line
		+	* ''Field's [[Standard Short Label]]:'' SSLine
		+
	=== Airline ===		=== Airline ===
-	=== Co Loaders ===	+
-	=== Booking Num ===	+	'''Labels:'''
-	=== HAWB ===	+	* ''Field's [[Standard Long Label]]:'' Airline
-	=== MBL ===	+	* ''Field's [[Standard Short Label]]:'' Airline
-	=== MAWB ===	+
		+	=== Co Loaders ===
		+
		+	'''Labels:'''
		+	* ''Field's [[Standard Long Label]]:'' Co Loaders
		+	* ''Field's [[Standard Short Label]]:'' Coloader
		+
		+	=== Booking Num ===
		+
		+	'''Labels:'''
		+	* ''Field's [[Standard Long Label]]:'' Booking Num
		+	* ''Field's [[Standard Short Label]]:'' Booking#
		+
		+	=== HAWB ===
		+
		+	'''Labels:'''
		+	* ''Field's [[Standard Long Label]]:'' HAWB
		+	* ''Field's [[Standard Short Label]]:'' HAWB
		+
		+	=== MBL ===
		+
		+	'''Labels:'''
		+	* ''Field's [[Standard Long Label]]:'' MBL
		+	* ''Field's [[Standard Short Label]]:'' MBL
		+
		+	=== MAWB ===
		+
		+	'''Labels:'''
		+	* ''Field's [[Standard Long Label]]:'' MAWB
		+	* ''Field's [[Standard Short Label]]:'' MAWB
		+
	=== HBL ===		=== HBL ===
-	=== AMS Submission Date  ===	+
		+	'''Labels:'''
		+	* ''Field's [[Standard Long Label]]:'' HBL
		+	* ''Field's [[Standard Short Label]]:'' HBL
		+
		+	=== AMS Submission Date  ===
		+
		+	'''Labels:'''
		+	* ''Field's [[Standard Long Label]]:'' AMS Submission Date
		+	* ''Field's [[Standard Short Label]]:'' AMS Sub Dt
		+
	=== Vessel Name ===		=== Vessel Name ===
		+
		+	'''Labels:'''
		+	* ''Field's [[Standard Long Label]]:'' Vessel Name
		+	* ''Field's [[Standard Short Label]]:'' Vessel
		+
	=== Voyage Num  ===		=== Voyage Num  ===
-	=== Flight One ===	+
-	=== Feeder Vessel Name ===	+	'''Labels:'''
		+	* ''Field's [[Standard Long Label]]:'' Voyage Num
		+	* ''Field's [[Standard Short Label]]:'' Voy#
		+
		+	=== Flight One ===
		+
		+	'''Labels:'''
		+	* ''Field's [[Standard Long Label]]:'' Flight One
		+	* ''Field's [[Standard Short Label]]:'' Flight1
		+
		+	=== Feeder Vessel Name ===
		+
		+	'''Labels:'''
		+	* ''Field's [[Standard Long Label]]:'' Feeder Vessel Name
		+	* ''Field's [[Standard Short Label]]:'' Feeder Vssl
		+
	=== Feeder Vessel Voyage Num  ===		=== Feeder Vessel Voyage Num  ===
-	=== Flight Two ===	+
		+	'''Labels:'''
		+	* ''Field's [[Standard Long Label]]:'' Feeder Vessel Voyage Num
		+	* ''Field's [[Standard Short Label]]:'' Feeder Voy#
		+
		+	=== Flight Two ===
		+
		+	'''Labels:'''
		+	* ''Field's [[Standard Long Label]]:'' Flight Two
		+	* ''Field's [[Standard Short Label]]:'' Flight2
		+
	=== Origin Terminal ===		=== Origin Terminal ===
Line 534:		Line 1,138:
	* ''[[Master field]]?'': N		* ''[[Master field]]?'': N
	* ''CRUD:'' [[Terminals#_Origin_Terminals]]		* ''CRUD:'' [[Terminals#_Origin_Terminals]]
		+
		+	'''Labels:'''
		+	* ''Field's [[Standard Long Label]]:'' Origin Terminal
		+	* ''Field's [[Standard Short Label]]:'' Origin CY
		+
	=== Origin Terminal Estimated Date ===		=== Origin Terminal Estimated Date ===
-	=== Origin Terminal Actual Date  ===	+
		+	'''Labels:'''
		+	* ''Field's [[Standard Long Label]]:'' Original Terminal Estimated Date
		+	* ''Field's [[Standard Short Label]]:'' ETD Origin CY
		+
		+	=== Origin Terminal Actual Date  ===
		+
		+	'''Labels:'''
		+	* ''Field's [[Standard Long Label]]:'' Origin Terminal Actual Date
		+	* ''Field's [[Standard Short Label]]:'' ATD Origin CY
		+
	=== Port Of Loading  ===		=== Port Of Loading  ===
-	=== Airport Of Departure ===	+
-	=== Port Of Loading Estimated Date  ===	+	'''Labels:'''
-	=== Airport Of Departure Estimated Date ===	+	* ''Field's [[Standard Long Label]]:'' Port Of Loading
-	=== Port Of Loading Actual Date  ===	+	* ''Field's [[Standard Short Label]]:'' Port Of Load
-	=== Airport Of Departure Actual Date  ===	+
		+	=== Airport Of Departure ===
		+
		+	* ''Meaning:''  Is the FIRST airport of loading
		+	* ''Format/type:'' ComboBox & Radio Button
		+	* ''Examples:''  Shanghai, China
		+	* ''MOT:'' Air
		+	* ''Default:'' The same as Airport of Departure
		+	* ''[[Master field]]?'': N
		+
		+	'''Labels:'''
		+	* ''Field's [[Standard Long Label]]:'' Airport Of Departure
		+	* ''Field's [[Standard Short Label]]:'' Origin Aiport
		+
		+	=== Port Of Loading Estimated Date  ===
		+
		+	'''Labels:'''
		+	* ''Field's [[Standard Long Label]]:'' Port Of Loading Estimated Date
		+	* ''Field's [[Standard Short Label]]:'' ETD Port Of Laod
		+
		+	=== Airport Of Departure Estimated Date ===
		+
		+	'''Labels:'''
		+	* ''Field's [[Standard Long Label]]:'' Airport Of Departure Estimated Date
		+	* ''Field's [[Standard Short Label]]:'' ETD Origin Airport
		+
		+	=== Port Of Loading Actual Date  ===
		+
		+	'''Labels:'''
		+	* ''Field's [[Standard Long Label]]:'' Port Of Loading Actual Date
		+	* ''Field's [[Standard Short Label]]:'' ATD Port of Load
		+
		+
		+	=== Airport Of Departure Actual Date  ===
		+
		+	'''Labels:'''
		+	* ''Field's [[Standard Long Label]]:'' Airport Of Departure Actual Date
		+	* ''Field's [[Standard Short Label]]:'' ATD Origin Airport
		+
	=== Trans Shipment ===		=== Trans Shipment ===
		+
		+	'''Labels:'''
		+	* ''Field's [[Standard Long Label]]:'' Trans Shipment
		+	* ''Field's [[Standard Short Label]]:'' TransShip Port
		+
	=== Trans Shipment Estimated Date ===		=== Trans Shipment Estimated Date ===
-	=== Trans Shipment Actual Date  ===	+
-	=== Port Of Discharge  ===	+	'''Labels:'''
-	=== Airport Of Destination ===	+	* ''Field's [[Standard Long Label]]:'' Trans Shipment Estimated Date
-	=== Port Of Discharge Estimated Date  ===	+	* ''Field's [[Standard Short Label]]:'' ETD TransShip Port
-	=== Airport Of Destination Estimated Date ===	+
-	=== Port Of Discharge Actual Date  ===	+	=== Trans Shipment Actual Date  ===
		+
		+	'''Labels:'''
		+	* ''Field's [[Standard Long Label]]:'' Trans Shipment Actual Date
		+	* ''Field's [[Standard Short Label]]:'' ATD TransShip Port
		+
		+	=== Port Of Discharge  ===
		+
		+	'''Labels:'''
		+	* ''Field's [[Standard Long Label]]:'' Port Of Discharge
		+	* ''Field's [[Standard Short Label]]:'' Port Of Dischg
		+
		+	=== Airport Of Destination ===
		+
		+	* ''Meaning:''  Is the LAST airport of discharge at destination
		+	* ''Format/type:'' ComboBox & Radio Button
		+	* ''Examples:''  JFK, New York
		+	* ''MOT:'' Air
		+	* ''Default:'' The same as Airport of Destination
		+	* ''[[Master field]]?'': N
		+
		+	'''Labels:'''
		+	* ''Field's [[Standard Long Label]]:'' Airport Of Destination
		+	* ''Field's [[Standard Short Label]]:'' Dest. Airport
		+
		+	=== Port Of Discharge Estimated Date  ===
		+
		+	'''Labels:'''
		+	* ''Field's [[Standard Long Label]]:'' Port Of Discharge Estimated Date
		+	* ''Field's [[Standard Short Label]]:'' ETA Port of Dischg
		+
		+	=== Airport Of Destination Estimated Date ===
		+
		+	'''Labels:'''
		+	* ''Field's [[Standard Long Label]]:'' Airport Of Destination Estimated Date
		+	* ''Field's [[Standard Short Label]]:'' ETA Dest. Airport
		+
		+	=== Port Of Discharge Actual Date  ===
		+
		+	'''Labels:'''
		+	* ''Field's [[Standard Long Label]]:'' Port Of Discharge Actual Date
		+	* ''Field's [[Standard Short Label]]:'' ATA Port Of Dischg
		+
	=== Airport Of Destination Actual Date ===		=== Airport Of Destination Actual Date ===
		+
		+	'''Labels:'''
		+	* ''Field's [[Standard Long Label]]:'' Airport Of Destination Actual Date
		+	* ''Field's [[Standard Short Label]]:'' ATA Dest. Airport
		+
	=== Destination Terminal ===		=== Destination Terminal ===
Line 562:		Line 1,271:
	* ''CRUD:'' [[Terminals#_Destination_Terminals]]		* ''CRUD:'' [[Terminals#_Destination_Terminals]]
-	=== Destination Terminal Estimated Date ===	+	'''Labels:'''
-	=== Destination Terminal Actual Date  ===	+	* ''Field's [[Standard Long Label]]:'' Destination Terminal
		+	* ''Field's [[Standard Short Label]]:'' Dest. CY
		+
		+	=== Destination Terminal Estimated Date ===
		+
		+	'''Labels:'''
		+	* ''Field's [[Standard Long Label]]:'' Destination Terminal Estimated Date
		+	* ''Field's [[Standard Short Label]]:'' ETA Dest. CY
		+
		+	=== Destination Terminal Actual Date  ===
		+
		+	'''Labels:'''
		+	* ''Field's [[Standard Long Label]]:'' Destination Terminal Actual Date
		+	* ''Field's [[Standard Short Label]]:'' ATA Dest. CY
		+
	=== Destination Receiving Agent combobox ===		=== Destination Receiving Agent combobox ===
-	=== Cubic Meter textbox ===	+
		+	'''Labels:'''
		+	* ''Field's [[Standard Long Label]]:'' Destination Receiving Agent
		+	* ''Field's [[Standard Short Label]]:'' Dest. Agent
		+
		+	=== Cubic Meter textbox ===
		+
		+	'''Labels:'''
		+	* ''Field's [[Standard Long Label]]:'' Cubic Meter
		+	* ''Field's [[Standard Short Label]]:'' CBM
		+
	=== Chargeable Weight textbox ===		=== Chargeable Weight textbox ===
-	=== HBL Comment ===
-	=== HAWB Comment ===
-	=== Export Customs Information ===
-	== Import Fields ==	+	==== Chargeable Weight ====
		+	'''Labels:'''
		+	* ''Field's [[Standard Long Label]]:'' Chargeable Weight
		+	* ''Field's [[Standard Short Label]]:'' Chrgbl kg
-	Table below is to cross reference current implementation with Business Object Fields defined in this wiki.	+	=== HBL Comment ===
-	''' Not colored fields are fields that are used for all 3 modes: Air, LCL, FCL '''	+	'''Labels:'''
		+	* ''Field's [[Standard Long Label]]:'' HBL Comment
		+	* ''Field's [[Standard Short Label]]:'' HBL Comment
		+
		+	=== HAWB Comment ===
		+
		+	'''Labels:'''
		+	* ''Field's [[Standard Long Label]]:'' HAWB Comment
		+	* ''Field's [[Standard Short Label]]:'' HAWB Comment
		+
		+	=== Export Customs Information ===
		+
		+	'''Labels:'''
		+	* ''Field's [[Standard Long Label]]:'' Export Customs Information
		+	* ''Field's [[Standard Short Label]]:'' Exp Customs
		+
		+	== Import Fields ==
-	{| 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 ===
		+
		+	'''Labels:'''
		+	* ''Field's [[Standard Long Label]]:'' IT Number
		+	* ''Field's [[Standard Short Label]]:'' IT #
	=== IT Date ===		=== IT Date ===
		+	'''Labels:'''
		+	* ''Field's [[Standard Long Label]]:'' IT Date
		+	* ''Field's [[Standard Short Label]]:'' IT Dt
		+
	=== IT Location ===		=== IT Location ===
		+
		+	'''Labels:'''
		+	* ''Field's [[Standard Long Label]]:'' IT Location
		+	* ''Field's [[Standard Short Label]]:'' IT Loc
	=== Customs Broker ===		=== Customs Broker ===
		+	'''Labels:'''
		+	* ''Field's [[Standard Long Label]]:'' Customs Broker
		+	* ''Field's [[Standard Short Label]]:'' Cust Broker
		+
	=== Customs Broker Address ===		=== Customs Broker Address ===
		+
		+	'''Labels:'''
		+	* ''Field's [[Standard Long Label]]:'' Customs Broker Address
		+	* ''Field's [[Standard Short Label]]:'' Cust Broker Addr
	=== Import Delivery To ===		=== Import Delivery To ===
		+
		+	'''Labels:'''
		+	* ''Field's [[Standard Long Label]]:'' Import Delivery To
		+	* ''Field's [[Standard Short Label]]:'' Imp Del To
	=== Import Delivery To Address ===		=== Import Delivery To Address ===
		+
		+	'''Labels:'''
		+	* ''Field's [[Standard Long Label]]:'' Import Delivery To Address
		+	* ''Field's [[Standard Short Label]]:'' Imp Del To Address
	==== Delivery Address ====		==== Delivery Address ====
	same as [[#Import Delivery To]]		same as [[#Import Delivery To]]
		+
		+	'''Labels:'''
		+	* ''Field's [[Standard Long Label]]:'' Delivery Address
		+	* ''Field's [[Standard Short Label]]:'' Del Address
	=== Delivery Comments ===		=== 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. --[[User:Alex|Alex]] 00:06, 22 February 2010 (UTC)		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. --[[User:Alex|Alex]] 00:06, 22 February 2010 (UTC)
		+
		+	'''Labels:'''
		+	* ''Field's [[Standard Long Label]]:'' Delivery Instructions
		+	* ''Field's [[Standard Short Label]]:'' Del Instr
	=== Delivery Instructions ===		=== Delivery Instructions ===
Line 646:		Line 1,396:
	'''Notes:'''		'''Notes:'''
		+	'''Labels:'''
		+	* ''Field's [[Standard Long Label]]:'' Delivery Instructions
		+	* ''Field's [[Standard Short Label]]:'' Del Instr
	=== Last Free Day ===		=== Last Free Day ===
		+
		+	'''Labels:'''
		+	* ''Field's [[Standard Long Label]]:'' Last Free Day
		+	* ''Field's [[Standard Short Label]]:'' Last Free Day
		+
	=== Import Pick Up  ===		=== Import Pick Up  ===
		+
		+	'''Labels:'''
		+	* ''Field's [[Standard Long Label]]:'' Import Pick Up
		+	* ''Field's [[Standard Short Label]]:'' Imp Pick Up
	==== Cargo location ====		==== Cargo location ====
	same as [[#Import Pick Up]]		same as [[#Import Pick Up]]
		+
		+	'''Labels:'''
		+	* ''Field's [[Standard Long Label]]:'' Cargo Location
		+	* ''Field's [[Standard Short Label]]:'' Cargo Loc
	=== Import Pick Up Address  ===		=== Import Pick Up Address  ===
		+
		+	'''Labels:'''
		+	* ''Field's [[Standard Long Label]]:'' Import Pick Up Address
		+	* ''Field's [[Standard Short Label]]:'' Imp P.U. Addr
		+
	=== Delivery Trucker ===		=== Delivery Trucker ===
		+
		+	* ''Meaning:'' This is the trucker who will deliver the product to the [[CT#Delivery To]] party.
		+	* ''Default value:'' Blank
		+	* ''Required field?'' N
		+	* ''Format/Datatype:'' [[CT_profile#ComboBox]],
		+	*  User Read Access: all
		+	* User Write Access: internal
		+	* MOT: Air, Ocean
		+
	=== Delivery Date Type ===		=== Delivery Date Type ===
		+
		+	'''Labels:'''
		+	* ''Field's [[Standard Long Label]]:'' Delivery Date Type
		+	* ''Field's [[Standard Short Label]]:'' Del Date Type
		+
	=== Delivery Comment ===		=== Delivery Comment ===
-	=== Arrival Notice Comment ===	+
		+	'''Labels:'''
		+	* ''Field's [[Standard Long Label]]:'' Delivery Comment
		+	* ''Field's [[Standard Short Label]]:'' Del Comment
		+
		+	=== ===
		+
		+	'''Labels:'''
		+	* ''Field's [[Standard Long Label]]:'' Arrival Notice Comment
		+	* ''Field's [[Standard Short Label]]:'' AN Comment
		+
	=== Estimated Delivery Date ===		=== Estimated Delivery Date ===
		+
		+	* ''Meaning:''  This is an estimated date of when the delivery trucker is going to deliver the product to the [[CT#Delivery To]] location.  This is an existing CT2 field, see [[#Estimated_Delivery_Date]]
		+	* ''Default value:'' Blank
		+	* ''Required field?'' N
		+	* ''Format/Datatype:'' [[Datebox]],
		+	*  User Read Access: all
		+	* User Write Access: internal
		+	* MOT: all
		+
		+	'''Location''':
		+	* Air, Client Consol, LCL: Imp Tab
		+	* FCL and Truck-Ocean: [[Container#Estimated Delivery Date]] - Dates Tab
		+	* Truck Dom, Truck Air: Gen Tab
		+
	=== Actual Delivery Date ===		=== Actual Delivery Date ===
-	'''!!! Note: for FCL and Truck-Ocean it is [[Container#Actual Delivery Date]]'''	+	* ''Meaning:'' This is actual date of when the delivery trucker delivered the product to the  location.  This is an existing CT2 field, see [[#Actual_Delivery_Date]]
		+	* ''Default value:'' Blank
		+	* ''Required field?'' N
		+	* ''Format/Datatype:'' [[Datebox]],
		+	*  User Read Access: all
		+	* User Write Access: internal
		+	* MOT: all
-	=== Jaguar Delivery Yes No ===	+	Location:
-	=== Original BL Required Yes No ===	+	* Air, Client Consol, LCL: Imp Tab
		+	* FCL and Truck-Ocean: [[Container#Actual Delivery Date]] - Dates Tab
		+	* Truck Dom, Truck Air: Gen Tab
		+
		+	=== Jaguar Delivery Yes No ===
		+
		+	'''Labels:'''
		+	* ''Field's [[Standard Long Label]]:'' Jaguar Delivery Yes No
		+	* ''Field's [[Standard Short Label]]:'' Jaguar Del Y N
		+
		+	=== Original BL Required Yes No ===
		+
		+	'''Labels:'''
		+	* ''Field's [[Standard Long Label]]:'' Original BL Required Yes No
		+	* ''Field's [[Standard Short Label]]:'' Original BL Req Y N
		+
	=== Payment Of Charges Required Yes No ===		=== Payment Of Charges Required Yes No ===
		+
		+	'''Labels:'''
		+	* ''Field's [[Standard Long Label]]:'' Payment Of Charges Required Yes No
		+	* ''Field's [[Standard Short Label]]:'' Pymnt Required Y N
		+
	=== Customs Status ===		=== Customs Status ===
		+
		+	'''Labels:'''
		+	* ''Field's [[Standard Long Label]]:'' Customs Status
		+	* ''Field's [[Standard Short Label]]:'' Customs Status
		+
	=== Customs Status Date  ===		=== Customs Status Date  ===
		+
		+	'''Labels:'''
		+	* ''Field's [[Standard Long Label]]:'' Customs Status Date
		+	* ''Field's [[Standard Short Label]]:'' Customs Status Date
		+
	=== FDA Status ===		=== FDA Status ===
-	=== FDAStatus Date ===
		+	'''Labels:'''
		+	* ''Field's [[Standard Long Label]]:'' FDA Status
		+	* ''Field's [[Standard Short Label]]:'' FDA Status
		+	=== FDA Status Date ===
		+
		+	'''Labels:'''
		+	* ''Field's [[Standard Long Label]]:'' FDA Status Date
		+	* ''Field's [[Standard Short Label]]:'' FDA Status Date
	== Containers and Commodities ==		== Containers and Commodities ==
		+	=== Plts ===
		+	* see [[Commodity#Grand Total: Plts]]
		+
		+	=== Pkgs On Plts ===
		+
		+	* see [[Commodity#Grand Total: Pkgs On Plts]]
		+
		+	=== Loose ===
		+
		+	* see [[Commodity#Grand Total: Loose Pkgs]]
		+
		+	=== Gross Kg ===
		+
		+	* see [[Commodity#Grand Total: Gross Kg]]
		+
		+	=== Gross Lb ===
		+
		+	* see [[Commodity#Grand Total: Gross Lb]]
		+
		+	=== HU ===
		+
		+	* see [[Commodity#Grand Total: HU]]
		+
		+	=== CBM ===
		+
		+	* see [[Commodity#Grand Total: cbm]]
	=== Com Table ===		=== Com Table ===
		+
	See [[Commodity]]		See [[Commodity]]
	=== Ctnr Table ===		=== Ctnr Table ===
		+
	See [[Container]]		See [[Container]]
Line 691:		Line 1,571:
	* [[Exp Tab]]		* [[Exp Tab]]
	* [[Imp Tab]]		* [[Imp Tab]]
		+
		+	== History ==
		+	=== 002465: [EDI to TMS] (Misc) Add new TMSS field ===

---

Current revision as of 05:07, 15 November 2013

Contents 1 Scope 2 Additional ASN fields 2.1 Approved by Planner 2.2 Approved by Super Planner 3 Derived Fields 3.1 Carrier 3.2 Derived Locations 3.2.1 Origin Door 3.2.2 Destination Door 3.2.3 Origin Port 3.2.4 Destination Port 3.3 Derived Dates 3.3.1 Origin Door Actual Pick Up Date 3.3.2 Origin Port Actual Departure Date 3.3.3 Destination Port Actual Arrival Date 3.3.4 Destination Door Actual Delivery Date 4 General Fields 4.1 Example 4.1.1 Abc Reference Field 4.2 Misc 4.2.1 GRP 4.2.2 Smallest CT 4.3 References 4.3.1 CT Num 4.3.1.1 Number 4.3.2 Export Ref 4.3.3 Import Ref 4.3.4 Customer Ref 4.3.5 Jaguar 3rd Ref 4.4 Dates 4.4.1 Approved On 4.4.2 Last Modified DateTime 4.4.3 Cargo available 4.4.4 Cargo due 4.4.5 Created On Date 4.4.6 Created By 4.4.7 Time CT Created 4.4.8 Notification Date 4.4.9 Authorized On 4.4.10 Estimated Export Pick Up Date 4.4.11 Estimated Pick Up Date 4.4.12 Actual Export Pick Up Date 4.4.13 Actual Pick Up Date 4.4.14 Automated Estimated Delivery Date 4.5 Locations 4.5.1 Origin Country 4.5.2 Origin Country Note 4.5.3 Destination Country 4.5.4 Destination Country Note 4.5.5 Shipper 4.5.5.1 Shipper State 4.5.5.2 Shipper ZIP 4.5.6 Shipper Address 4.5.7 Consignee 4.5.7.1 Consignee State 4.5.7.2 Consignee ZIP 4.5.8 Consignee Address 4.5.9 Notify 4.5.10 Notify Address 4.5.11 Export Pick Up 4.5.11.1 Pick Up 4.5.11.2 Pick Up State 4.5.11.3 Pick Up Zip 4.5.11.4 Pick Up Company 4.5.12 Pick Up Address 4.5.12.1 Export Pick Up Address 4.5.13 Export Delivery To 4.5.14 Delivery To 4.5.14.1 Ship to State 4.5.14.2 Ship to Zip 4.5.15 Export Delivery To Address 4.5.16 Consol Warehouse 4.6 Client and Visibility 4.6.1 E0 Client 4.6.2 E1 4.6.3 E2 4.6.4 E3 4.7 Commodity related fields 4.7.1 Pick Up Comments 4.7.2 Commodity Description 4.7.3 Marks And Numbers 4.7.4 Hazardous Yes No 4.7.5 Hazardous Note 4.8 Authorization related fields 4.8.1 Authorized By 4.8.2 Authorized MOT 4.8.3 Authorization Method 4.9 Vendors 4.9.1 Export Pick Up Trucker 4.9.1.1 Pick Up Trucker 4.9.1.2 Routed Date 4.10 Misc 4.10.1 CT Number 4.10.2 PO Issued by 4.10.3 CT Authorization status 4.10.4 Approved For Delivery By Date 4.10.5 Authorization Comment 4.10.6 Transport Mode 4.10.6.1 MOT 4.10.7 Transport Mode Type 4.10.8 Client Mode 4.10.9 Operator Of Last Change 4.10.10 Shipping Terms 4.10.11 Shipping Terms Location 4.10.12 On Customer Hold 4.10.13 Pending Approval 4.10.14 PT Number 4.10.15 DT Number 4.10.16 TMSS field 4.10.17 Pro Number 4.10.18 Load Number 4.10.19 Trailer ID 5 Export Fields 5.1 FedEx carrier ID 5.2 Freight Prepaid Collect 5.3 Arrival Into Warehouse 5.4 Move Type/HBL 5.5 Original House Bill Yes No 5.6 Steamshipline 5.7 Airline 5.8 Co Loaders 5.9 Booking Num 5.10 HAWB 5.11 MBL 5.12 MAWB 5.13 HBL 5.14 AMS Submission Date 5.15 Vessel Name 5.16 Voyage Num 5.17 Flight One 5.18 Feeder Vessel Name 5.19 Feeder Vessel Voyage Num 5.20 Flight Two 5.21 Origin Terminal 5.22 Origin Terminal Estimated Date 5.23 Origin Terminal Actual Date 5.24 Port Of Loading 5.25 Airport Of Departure 5.26 Port Of Loading Estimated Date 5.27 Airport Of Departure Estimated Date 5.28 Port Of Loading Actual Date 5.29 Airport Of Departure Actual Date 5.30 Trans Shipment 5.31 Trans Shipment Estimated Date 5.32 Trans Shipment Actual Date 5.33 Port Of Discharge 5.34 Airport Of Destination 5.35 Port Of Discharge Estimated Date 5.36 Airport Of Destination Estimated Date 5.37 Port Of Discharge Actual Date 5.38 Airport Of Destination Actual Date 5.39 Destination Terminal 5.40 Destination Terminal Estimated Date 5.41 Destination Terminal Actual Date 5.42 Destination Receiving Agent combobox 5.43 Cubic Meter textbox 5.44 Chargeable Weight textbox 5.44.1 Chargeable Weight 5.45 HBL Comment 5.46 HAWB Comment 5.47 Export Customs Information 6 Import Fields 6.1 IT 6.2 IT Date 6.3 IT Location 6.4 Customs Broker 6.5 Customs Broker Address 6.6 Import Delivery To 6.7 Import Delivery To Address 6.7.1 Delivery Address 6.8 Delivery Comments 6.9 Delivery Instructions 6.10 Last Free Day 6.11 Import Pick Up 6.11.1 Cargo location 6.12 Import Pick Up Address 6.13 Delivery Trucker 6.14 Delivery Date Type 6.15 Delivery Comment 6.16 6.17 Estimated Delivery Date 6.18 Actual Delivery Date 6.19 Jaguar Delivery Yes No 6.20 Original BL Required Yes No 6.21 Payment Of Charges Required Yes No 6.22 Customs Status 6.23 Customs Status Date 6.24 FDA Status 6.25 FDA Status Date 7 Containers and Commodities 7.1 Plts 7.2 Pkgs On Plts 7.3 Loose 7.4 Gross Kg 7.5 Gross Lb 7.6 HU 7.7 CBM 7.8 Com Table 7.9 Ctnr Table 8 Link to CRUD 9 History 9.1 002465: [EDI to TMS] (Misc) Add new TMSS field

[edit] Scope

This wiki describes CT (Shipment) Business Object

[edit] Additional ASN fields

[edit] Approved by Planner

// name, ASN only

[edit] Approved by Super Planner

// name, ASN only

[edit] Derived Fields

[edit] Carrier

• Ocean: #Steamshipline
• Air: #Airline
• Truck modes: #Pick Up Trucker

[edit] Derived Locations

[edit] Origin Door

• in CT2 called #Export Pick Up

[edit] Destination Door

• truck ocean / tr dom / tr air : Gen Tab > Export Delivery To (T5)
• Ocean / Air : Imp Tab > Delivery Address (Import Delivery Location)(T7):

[edit] Origin Port

[edit] Destination Port

[edit] Derived Dates

[edit] Origin Door Actual Pick Up Date

• Air / Ocean LCL / Ocean Client Consol / Truck Air / Truck Dom: Gen Tab: 10. Actual Export Pick-Up Date

• Ocean FCL / Truck Ocean : Cont Tab. Actual Collection (Latest across all containers)

[edit] Origin Port Actual Departure Date

• Air: Exp Tab: 11c. ATD - Actual Time of Dept
• Ocean Client Consol / Ocean LCL / Ocean FCL: Exp Tab: 11c. ATD: (Origin Terminal)
• Truck modes: same as in #Origin Door Actual Pick Up Date

[edit] Destination Port Actual Arrival Date

• Air: Exp Tab: 14c. ATA - Actual Time of Arrival:
• Ocean Client Consol / Ocean LCL / Ocean FCL: Exp Tab: 15c. ATA (Destination Terminal)
• Truck modes: same as in #Destination Door Actual Delivery Date

[edit] Destination Door Actual Delivery Date

• Air: Imp Tab: Actual Delivery Date:
• Truck Air; Truck Dom: Gen Tab: y. Actual Delivery
• Ocean FCL / Truck Ocean : Cont Tab. Actual Delivery (Latest across all containers)

[edit] General Fields

For specific User Interface Implementation see also Gen Tab.

[edit] Example

[edit] Abc Reference Field

Labels:

• Standard Long Label: Abc Reference
• Standard Short Label: Abc Ref

Business Object:

• Meaning: Reference from Acadaff system. Used rarely.
• Format/type: Datatypes#alphanumeric, [one letter] + [3 digits] + [-] + [3 digits]
• Example: C127-987
• Mode Of Transport: Air only

Core Add/Edit interface properties:

• Widget:
• CyberTrax Internal:
  • Default value: Shippers Address
  • Required field? Y

• CyberTrax Client:
  • Default value: Shippers Address
  • Required field? Y

• Meaning: This is the company who placed the PO with the supplier.
• Standard Long Label: PO Issued by
• Standard Short Label: PO by
• Format/type: list of values, Datatypes#alphanumeric
• Min/max: from 0 to 30 chars
• Possible Values: Kik, CEI Holmdel, EA Stamford, CEI Roanoke, Kolmar, Kik, Evergreen (must be managed through admin)
• Widget: textbox
• Default value: blank
• Required field? Y
• User Read Access: internal, client, planner
• User Write Access: shipper
• Mode Of Transport: Truck-Domestic only

[edit] Misc

[edit] GRP

GRP number that holds this CT.

[edit] Smallest CT

Smallest CT in GRP that holds this CT.

[edit] References

[edit] CT Num

[edit] Number

Labels:

• Field's Standard Long Label: CT Number
• Field's Standard Short Label: CT #

[edit] Export Ref

Labels:

• Field's Standard Long Label: Export Ref #
• Field's Standard Short Label: ExP Ref #

[edit] Import Ref

Labels:

• Field's Standard Long Label: Import Ref #
• Field's Standard Short Label: ImP Ref #

[edit] Customer Ref

Labels:

• Field's Standard Long Label: Customer Ref #
• Field's Standard Short Label: Client Ref

[edit] Jaguar 3rd Ref

Labels:

• Field's Standard Long Label: JFS 3rd Ref #
• Field's Standard Short Label: 3rd Ref #

[edit] Dates

[edit] Approved On

a.k.a. CT#Authorized On

(with name of person who approved, including the date & time)

• Meaning: Shipment was approved for transportation by whom and when.
• Standard Long Label: Authorization Date
• Standard Short Label: Auth Date
• Other Labels in use:
• Format/type: Read only Textarea
• Min/max: [TBD]
• Possible Values: [TBD]
• Widget: datebox
• Default value: Read only - First and last name of the approval user(planner) and date timestamps with (EST) calculated time zone.
• Required field? Y - when status is approved
• User Read Access: client, shipper, planner, and Internal
• User Write Access: internal, and for planner the system automatically pulls current planner's name who approved the shipment
• Mode Of Transport: All

[edit] Last Modified DateTime

• Meaning: This is string representation of datetime stamp (with Time Zone) of CT's update.
• Standard Long Label: Last Modified DateTime
• Standard Short Label: Last Update On
• Format/type: textlabel, Datatypes#alphanumeric
• Min/max: TBD
• Possible Values: Jun 24, 2010 7:18:59 AM (EST)
• Widget: textlabel
• Default value: blank
• Required field? Y
• User Read Access: internal, client, planner, shipper
• User Write Access: system (read-only field)
• Mode Of Transport: All

[edit] Cargo available

• Meaning: This is the date that the goods are available for pick up (from Origin Door).
• Standard Long Label: Cargo Available Date
• Standard Short Label: Available Date
• Format/type: [TBD]
• Min/max: [TBD]
• Possible Values: [TBD]
• Widget: datebox
• Default value: The date that the record is created
• Required field?
  • Internal: N
  • Shipper: Y
• User Read Access: all
• User Write Access: internal, shipper (unless Cybertrax_2.1_Client_(requirements)#What_CTs_Shipper_may_edit_RULE is TRUE)
• Mode Of Transport: All

[edit] Cargo due

Labels:

• Meaning: This is the date that the goods should be delivered (to Destination Door).

• See the first definition here.

• Field's Standard Long Label: Cargo Due Date
• Field's Standard Short Label: Due Date

See Due_Date_Feature

[edit] Created On Date

• Meaning: This is the date that the CT record was created.

• DB: tblGenericShipment.CreateOnDate

• Standard Long Label: CT created on
• Standard Short Label: CT created on
• Other Labels in use: See CT_bo#Created_By for IE
• Format/type: [TBD]
• Min/max: [TBD]
• Possible Values: [TBD]
• Default value: The date that the record is created in CT.
• Required field?
  • Internal: Y
  • Shipper: Y
• User Read Access: All
• User Write Access: None
• Mode Of Transport: All

[edit] Created By

Labels:

• Standard Long Label: CT created by
• Standard Short Label: CT created by
• Other Labels in use:

[edit] Time CT Created

Labels:

• Standard Long Label: Time CT created
• Standard Short Label: Time CT created
• Other Labels in use:

[edit] Notification Date

Labels:

• Standard Long Label: Notification Date
• Standard Short Label: Notification Dt
• Other Labels in use:

[edit] Authorized On

Labels:

• Standard Long Label: Authorization Date
• Standard Short Label: Authorization Dt
• Other Labels in use:

[edit] Estimated Export Pick Up Date

Labels:

• Standard Long Label: Estimated Export Pick Up Date
• Standard Short Label: Est Pick Up Dt
• Other Labels in use:

[edit] Estimated Pick Up Date

same as #Estimated Export Pick Up Date

• Meaning: This is an estimated date of when the pick up trucker is going to pick up the product from the shipper or pick up location. This is an existing CT2 field, see CT#Estimated Pick Up
• Default value: Blank
• Required field? N
• Format/Datatype: Datebox,
• User Read Access: all
• User Write Access: internal
• MOT: all

[edit] Actual Export Pick Up Date

!!! Note: for FCL and Truck-Ocean it is Container#Actual Export Pick Up Date

Labels:

• Standard Long Label: Actual Export Pick Up Date
• Standard Short Label: Act Pick Up Dt
• Other Labels in use:

[edit] Actual Pick Up Date

same as #Actual Export Pick Up Date

'* Meaning: This is actual date of when the pick up trucker picked up the product from the CT#Shipper or CT#Pick Up location. This is an existing CT2 field, see CT#Actual Pick Up

• Default value: Blank
• Required field? N
• Format/Datatype: Datebox,
• User Read Access: all
• User Write Access: internal
• MOT: all

[edit] Automated Estimated Delivery Date

Labels:

• Standard Long Label: Automated Est Delivery Date
• Standard Short Label: Auto Est Del Dt
• Other Labels in use:

[edit] Locations

[edit] Origin Country

Labels:

• Standard Long Label: Origin Country
• Standard Short Label: Origin Country
• Other Labels in use:

Defines country of origin door and related note.

Origin Country selector:

• Combobox with a list of countries
• UI: Gen Tab > 11. Origin country
• DB: tblGenericShipment.OriginPointCountryId (join with tblCountry)
• Required? No

[edit] Origin Country Note

Labels:

• Standard Long Label: Origin Country Note
• Standard Short Label: Origin Country Note
• Other Labels in use:

[edit] Destination Country

Labels:

• Standard Long Label: Destination Country
• Standard Short Label: Dest Country
• Other Labels in use:

Defines country of destination door and related note.

• Combobox with a list of countries
• UI: Gen Tab > 12. Destination country
• DB: tblGenericShipment.DestinationPointCountryId (join with tblCountry)
• Required? No

Destination Country selector:

[edit] Destination Country Note

Labels:

• Standard Long Label: Destination Country Note
• Standard Short Label: Dest Country Note
• Other Labels in use:

[edit] Shipper

• Meaning: This is the company's name & address of who is placing the shipping request. This company name and address can also be the pick up location.
• Gen Tab > 2. Shipper (T1):
• Standard Long Label: Shipper
• Standard Short Label: Shipper
• Format/type: list of values, Datatypes#alphanumeric
• Min/max:
• Possible Values:
• Widget: listbox
• Default value:
  • Internal: blank
  • Shipper: Shipper(T1)" from "Shipper profile" - Enable Shipper/Supplier Role
• Required field?
  • Internal: N
  • Shipper: Y
• User Read Access: all
• User Write Access: internal
• Mode Of Transport: All

[edit] Shipper State

This is a Derived field

• mapping: Address#State for CT#Shipper
• label on xls: Shipper State

Labels:

• Standard Long Label: Shipper State
• Standard Short Label: Shipper State
• Other Labels in use:

[edit] Shipper ZIP

This is a Derived field

• mapping: Address#Zip for CT#Shipper
• label on xls: Shipper ZIP

Labels:

• Standard Long Label: Shipper ZIP
• Standard Short Label: Shipper ZIP
• Other Labels in use:

[edit] Shipper Address

textarea below Shipper

Labels:

• Standard Long Label: Shipper Address
• Standard Short Label: Shipper Address
• Other Labels in use:

[edit] Consignee

• Gen Tab > 3. Consignee (T2):

Labels:

• Standard Long Label: Consignee
• Standard Short Label: Cnee
• Other Labels in use:

[edit] Consignee State

This is a Derived field

• mapping: Address#State for CT#Consignee
• label on xls: Consignee State

Labels:

• Standard Long Label: Consignee State
• Standard Short Label: Consignee State
• Other Labels in use:

[edit] Consignee ZIP

This is a Derived field

• mapping: Address#Zip for CT#Consignee
• label on xls: Consignee ZIP

Labels:

• Standard Long Label: Consignee ZIP
• Standard Short Label: Consignee ZIP
• Other Labels in use:

[edit] Consignee Address

Labels:

• Standard Long Label: Consignee Address
• Standard Short Label: Cnee Address
• Other Labels in use:

[edit] Notify

Labels:

• Standard Long Label: Notify Party
• Standard Short Label: Ntfy Party
• Other Labels in use:

[edit] Notify Address

Labels:

• Standard Long Label: Notify Address
• Standard Short Label: Ntfy Address
• Other Labels in use:

[edit] Export Pick Up

• Meaning: This is the location of where the goods are actually located and shipping from.
• Standard Long Label: Export Pick Up
• Standard Short Label: Exp Pick Up
• Other Labels in use:
• Format/type: This field contains Company-City-Note
• Min/max: [TBD]
• Possible Values: [TBD]
• Widget: searchbox
• Default value:
  • Internal: blank
  • Shipper: "Copy from Shipper:" is checked (Yes) and "Pick up Location" is filled from "Shipper"
• Required field?
  • Internal: N
  • Shipper: Y
• User Read Access: all
• User Write Access: internal, shipper unless Cybertrax_2.1_Client_(requirements)#What_CTs_Shipper_may_edit_RULE is true
• Mode Of Transport: All

[edit] Pick Up

same as #Export Pick Up

Labels:

• Standard Long Label: Pick Up
• Standard Short Label: Pick Up
• Other Labels in use:

[edit] Pick Up State

This is a Derived field

• mapping: Address#State from CT#Pick Up
• Standard Long Label: Pick Up State
• Standard Short Label: Pick Up State

Labels:

[edit] Pick Up Zip

This is a Derived field

• mapping: Address#Zip from CT#Pick Up
• Standard Long Label: Pick Up Zip
• Standard Short Label: Pick Up Zip

[edit] Pick Up Company

"Company Name" from #Pick Up

Labels:

• Standard Long Label: Pick Up Company
• Standard Short Label: Pick Up Comp
• Other Labels in use:

[edit] Pick Up Address

Labels:

• Standard Long Label: Export Pick Up Address
• Standard Short Label: Exp Pick Up Address
• Other Labels in use:

[edit] Export Pick Up Address

same as #Pick Up Address

[edit] Export Delivery To

Labels:

• Standard Long Label: Export Delivery To
• Standard Short Label: Exp Delivery To
• Other Labels in use:

[edit] Delivery To

same as #Export Delivery To

• Meaning: This is the location of where the goods are shipping to.
• Standard Long Label: Delivery To
• Standard Short Label: Delivery To
• Other Labels in use:
• Format/type: This field contains Company-City-Note
• Min/max: [TBD]
• Possible Values: [TBD]
• Widget: searchbox
• Default value: blank
• Required field?
  • Internal: N
  • Shipper: Y (NOTE: Ship To location from portal should map to Delivery To(T5) on Internal App as well as and Consignee (T2) field on the Internal App)
• User Read Access: all
• User Write Access: internal, shipper unless Cybertrax_2.1_Client_(requirements)#What_CTs_Shipper_may_edit_RULE is true
• Mode Of Transport: All

[edit] Ship to State

• mapping: Address#State for Ct#Delivery_To

• label on xls: Ship to State

Labels:

• Standard Long Label: Ship to State
• Standard Short Label: Ship to State
• Other Labels in use:

[edit] Ship to Zip

• mapping: Address#State for Ct#Delivery_To

• label on xls: Ship to Zip

Labels:

• Standard Long Label: Ship to Zip
• Standard Short Label: Ship to Zip
• Other Labels in use:

[edit] Export Delivery To Address

Labels:

• Standard Long Label: Export Delivery To Address
• Standard Short Label: Exp Del to Address
• Other Labels in use:

[edit] Consol Warehouse

Labels:

• Standard Long Label: Consol Warehouse
• Standard Short Label: Consol Whse
• Other Labels in use:

[edit] Client and Visibility

[edit] E0 Client

Labels:

• Standard Long Label: Client Company
• Standard Short Label: E0 Client
• Other Labels in use:

[edit] E1

Labels:

• Standard Long Label: Visibility 1
• Standard Short Label: Vis 1
• Other Labels in use:

[edit] E2

Labels:

• Standard Long Label: Visibility 2
• Standard Short Label: Vis 2
• Other Labels in use:

[edit] E3

Labels:

• Standard Long Label: Visibility 3
• Standard Short Label: Vis 3
• Other Labels in use:

[edit] Commodity related fields

[edit] Pick Up Comments

MO (Marc) advised Field should be renamed (instructions instead of comments)

• Meaning: This field is for the user to list any specific pick up instructions for the trucking company.
• Standard Long Label: Pick Up Comments
• Standard Short Label: Pick Up Instr.
• Other Labels in use:
• Format/type: alphanumeric
• Min/max: TBD
• Possible Values: TBD
• Widget: textbox
• Default value: blank
• Required field?
  • Internal: N
  • Shipper: N
• User Read Access: all
• User Write Access: internal, shipper unless Cybertrax_2.1_Client_(requirements)#What_CTs_Shipper_may_edit_RULE is true
• Mode Of Transport: All

[edit] Commodity Description

• Meaning: This field is for the user to list a general description of the contents being shipped.
• Standard Long Label: Commodity Description
• Standard Short Label: Goods Shipped:
• Other Labels in use:
• Format/type: TBD
• Min/max: TBD
• Possible Values: TBD
• Widget: textarea
• Default value: blank
• Required field?
  • Internal: N
  • Shipper: N
• User Read Access: All
• User Write Access: internal, shipper unless Cybertrax_2.1_Client_(requirements)#What_CTs_Shipper_may_edit_RULE is true
• Mode Of Transport: All

[edit] Marks And Numbers

• Meaning:
• Standard Long Label: Marks and Numbers
• Standard Short Label: Marks & Numbers
• Other Labels in use:
• Format/type:
• Min/max: [TBD]
• Possible Values: [TBD]
• Widget: textbox
• Default value: No
• Required field? Y
• User Read Access: client, planner
• User Write Access: internal, shipper
• Mode Of Transport: All

[edit] Hazardous Yes No

• Meaning: This is to advise if the product shipping is hazardous or not.
• Location: Gen Tab
• Mode Of Transport: All but Truck modes

• Standard Long Label: Hazardous Yes No
• Standard Short Label: Haz Y N
• Other Labels in use:
• Format/type: Radio option [Yes][No]
• Min/max: n/a
• Possible Values: Yes, No
• Widget: radiogroup
• Default value: No
• Required field? N
• User Read Access: client
• User Write Access: internal

[edit] Hazardous Note

Labels:

• Standard Long Label: Hazardous Note
• Standard Short Label: Haz Note
• Other Labels in use:

[edit] Authorization related fields

[edit] Authorized By

• Meaning: TBD
• Standard Long Label: Authorized By
• Standard Short Label: Auth By
• Other Labels in use:
• Format/type: TBD
• Min/max: n/a
• Possible Values: TBD
• Widget: TBD
• Default value: TBD
• Required field? Y for approved shipment
• User Read Access: client, planner, shipper, and Internal
• User Write Access: Internal, and for planner the system automatically pulls current planner's name who approved the shipment
• Mode Of Transport: All

[edit] Authorized MOT

Labels:

• Field's Standard Long Label: Authorized MOT
• Field's Standard Short Label: Authzd MOT

[edit] Authorization Method

Labels:

• Field's Standard Long Label: Authorization Method
• Field's Standard Short Label: Auth via

[edit] Vendors

[edit] Export Pick Up Trucker

MO (Marc), feels these 2 fields should be labeled the same

Labels:

• Field's Standard Long Label: Pick Up Trucker
• Field's Standard Short Label: Pick Up Trucker

[edit] Pick Up Trucker

same as above

• Meaning: This is the name of the trucker who will pick up the product once it is approved to ship.
• Default value: Blank
• Required field? N
• Format/Datatype: CT_profile#ComboBox, see CT#Pick Up Trucker
• User Read Access: all
• User Write Access: internal
• MOT: all

[edit] Routed Date

• Meaning: It is a date that a pick up trucker was assigned.
• Standard Long Label: Routed on Date
• Standard Short Label: Routed on Dt
• Other Labels in use:
• Format/type: read only Datebox with out clear function
• Min/max: n/a
• Possible Values: TBD
• Widget: TBD
• Default value: same date as a pick up trucker is assigned
• Required field? Y - when #Pick Up Trucker is assigned
• User Read Access: Internal
• User Write Access: System automatically set this date when a pick up trucker is assigned
• Mode Of Transport: Truck-Domestic Only

[edit] Misc

[edit] CT Number

[edit] PO Issued by

• Meaning: This is the company who placed the PO with the supplier.
• Standard Long Label: PO Issued by
• Standard Short Label: PO by
• Format/type: list of values, Datatypes#alphanumeric
• Min/max: from 0 to 30 chars
• Possible Values: see Cybertrax_2.1_Client_(requirements)#Admin_for_PO_issued_by_CT_field
• Widget: listbox
• Default value: blank
• Required field?
  • internal: N
  • shipper: Y
• User Read Access: all
• User Write Access: internal, shipper unless Cybertrax_2.1_Client_(requirements)#What_CTs_Shipper_may_edit_RULE is true
• Mode Of Transport: Truck-Domestic only

[edit] CT Authorization status

• Meaning: It allows a planner to set a status (approve, reject, or hold) to any shipments created by a supplier.
• Standard Long Label: CT Authorization Status
• Standard Short Label: Authorization Status
• Format/type: Listbox with option to choose one of three choices
• Min/max: TBD
• Possible Values: Approve, Reject, Hold
• Widget: listbox
• Default value: blank
• Required field?
  • Internal: N/A
  • Shipper: N/A
  • Planner: N unless they want to set the authorization status (Approve, Reject, Hold)
• User Read Access: client, shipper, planner, and Internal only if the status is approved
• User Write Access: planner
• Mode Of Transport: Truck-Domestic only

[edit] Approved For Delivery By Date

"Approved for" date feature acts as a ‘hold to ship date’ – meaning hold until (IE 05/24/10) before scheduling the pick up.

• Meaning: It allows a planner to place a shipment on hold until a particular date. System will automatically approve on the date selected at 12:01 AM. This field can be updated anytime until 3 days before the date selected
• Standard Long Label: Approved For Delivery By
• Standard Short Label: Approved For Delivery By
• Format/type: Datebox with a clear button
• Min/max: TBD
• Possible Values: TBD
• Widget: datebox
• Default value: blank
• Required field?
  • Internal: N/A
  • Shipper: N/A
  • Planner: N unless they want to set the authorization status to Hold with Date
• User Read Access: shipper, planner, and client and Internal will only see when system automatically approves on the date selected by planner.
• User Write Access: planner
• Mode Of Transport: Truck-Domestic only

[edit] Authorization Comment

Reason for placing a shipment on hold or rejecting a shipment.

• Meaning: It allows a planner to note to the supplier why they are holding or rejecting a shipment.
• Standard Long Label: Authorization Comment
• Standard Short Label: Auth. Comment
• Format/type: Textarea
• Min/max: TBD
• Possible Values: TBD
• Widget: Textarea
• Default value: blank
• Required field? N
• User Read Access: shipper, planner
• User Write Access: planner
• Mode Of Transport: Truck-Domestic only
• Addition Info: It is a field on a shipment record that records status, reason, by whom and when. Last updated info will be on the top.

[edit] Transport Mode

Labels:

• Field's Standard Long Label: Transport Mode
• Field's Standard Short Label: MOT

[edit] MOT

same as #Mode Of Transport

Labels:

• Field's Standard Long Label: MOT
• Field's Standard Short Label: MOT

[edit] Transport Mode Type

See MOT#Type

[edit] Client Mode

Labels:

• Field's Standard Long Label: Client Mode
• Field's Standard Short Label: Client Mode

[edit] Operator Of Last Change

• DB: tblGenericShipment.LastModifiedUserId

• Meaning: TBD
• Standard Long Label: Operator of Last Change
• Standard Short Label: Last update by
• Format/type: read-only Textarea
• Min/max: TBD
• Possible Values: TBD
• Widget: Textarea
• Default value: blank
• Required field? Y
• User Read Access: internal, client, shipper, planner
• User Write Access: read-only field
• Mode Of Transport: All

[edit] Shipping Terms

Labels:

• Field's Standard Long Label: Shipping Terms
• Field's Standard Short Label: Ship Terms

[edit] Shipping Terms Location

Labels:

• Field's Standard Long Label: Shipping Terms Location
• Field's Standard Short Label: Ship Terms Loc

[edit] 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:

Labels:

• Field's Standard Long Label: On Customer Hold
• Field's Standard Short Label: On Cust Hold

[edit] Pending Approval

• Meaning: A CT record is awaiting authorization from a planner or EM before the product can ship from a supplier's facility.
• Format/type: List of values: {true, false}
• Default: false
• MOT: All
• Edit panel (CRUD):
• DB:

Labels:

• Field's Standard Long Label: Pending Approval
• Field's Standard Short Label: Pndg Apprv

[edit] 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.

• This ID will pass through CT2 through TMS - this is a change - re-architect field to alphanumeric (text field) -- as this info will be pass through Cybertrax by Descartes. It is editable field. -- Tira 10.30 AM, 24 Aug 2012 (UTC)
• 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

Labels:

• Field's Standard Long Label: PT Number
• Field's Standard Short Label: PT #

• * editable
• located on Gen tab below #Cargo_due
• default: blank
• NOTE:

see also Update_Fields_for_Virtual_Group#Updating_Trailer_ID_field

Labels:

• Field's Standard Long Label: Trailer ID
• Field's Standard Short Label: Trailer #

[edit] 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.
• This ID will pass through CT2 through TMS - this is a change - re-architect field to alphanumeric (text field) -- as this info will be pass through Cybertrax by Descartes. It is editable field. -- Tira 10.30 AM, 24 Aug 2012 (UTC)
• 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

Labels:

• Field's Standard Long Label: DT Number
• Field's Standard Short Label: DT #

[edit] TMSS field

• Meaning: This is a header displayed on edit of CT record with values and updates after events between CT2 & the TM system.
• Format/type: Alphanumeric ?
• Examples:
  • yet = CT was never imported yet (default value)
  • importX = CT was Imported into TMS X times (Example: import1, import2)
  • loadX = shipment received Load Plan X times
  • statusX = shipment received Status Message X times
  • post updates to CT updates log
• MOT: Truck domesitc
• Default: ?
• Master field?: N
• CRUD:

[edit] Pro Number

• Pro Number is a unique id number that is generated directly by a trucker when they receive a tender request that is automatically sent to them via the TMS. It is a tag that a trucker assigns to our CT record for the truckers easy tracking reference.

• Change: field should be editable by JFS users
• location?
• default: blank
• format: Alphanumeric - allowing for 25 characters

Labels:

• Field's Standard Long Label: Pro Number
• Field's Standard Short Label: Pro #

[edit] Load Number

• Load Number is a unique id number that is generated directly inside of the TMS when Jag operator sends a tender request. It is a tag used when a user sends a pickup & delivery request to a trucker.

• Change: field should be editable by JFS users
• location?
• default: blank
• format: Alphanumeric - allowing for 25 characters

Labels:

• Field's Standard Long Label: Load Number
• Field's Standard Short Label: LD #

See also Load#Number

[edit] Trailer ID

* Pick up/Delivery Trailer id - Unique id generated by trucker company. This ID will pass through CT2 through TMS. This is the tag to identify what CTs belong to the given Truck Load.

• * editable
• located on Gen tab below #Cargo_due
• default: blank

see also Update_Fields_for_Virtual_Group#Updating_Trailer_ID_field

Labels:

• Field's Standard Long Label: Trailer ID
• Field's Standard Short Label: Trailer #

--> reuse CT_bo#PT_Number and CT_bo#DT_Number

[edit] Export Fields

[edit] 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

Labels:

• Field's Standard Long Label: FedEx ID #
• Field's Standard Short Label: FedEx ID #

[edit] Freight Prepaid Collect

Labels:

• Field's Standard Long Label: Freight Prepaid Collect
• Field's Standard Short Label: Freight PP/CC

[edit] Arrival Into Warehouse

Labels:

• Field's Standard Long Label: Arrival Into Warehouse
• Field's Standard Short Label: Arrvl Into Whse

[edit] Move Type/HBL

Labels:

• Field's Standard Long Label: Move Type/HBL
• Field's Standard Short Label: Move Type/HBL

[edit] Original House Bill Yes No

Labels:

• Field's Standard Long Label: Original House Bill Yes No
• Field's Standard Short Label: Original HBL Y N

[edit] Steamshipline

Labels:

• Field's Standard Long Label: Steamship Line
• Field's Standard Short Label: SSLine

[edit] Airline

Labels:

• Field's Standard Long Label: Airline
• Field's Standard Short Label: Airline

[edit] Co Loaders

Labels:

• Field's Standard Long Label: Co Loaders
• Field's Standard Short Label: Coloader

[edit] Booking Num

Labels:

• Field's Standard Long Label: Booking Num
• Field's Standard Short Label: Booking#

[edit] HAWB

Labels:

• Field's Standard Long Label: HAWB
• Field's Standard Short Label: HAWB

[edit] MBL

Labels:

• Field's Standard Long Label: MBL
• Field's Standard Short Label: MBL

[edit] MAWB

Labels:

• Field's Standard Long Label: MAWB
• Field's Standard Short Label: MAWB

[edit] HBL

Labels:

• Field's Standard Long Label: HBL
• Field's Standard Short Label: HBL

[edit] AMS Submission Date

Labels:

• Field's Standard Long Label: AMS Submission Date
• Field's Standard Short Label: AMS Sub Dt

[edit] Vessel Name

Labels:

• Field's Standard Long Label: Vessel Name
• Field's Standard Short Label: Vessel

[edit] Voyage Num

Labels:

• Field's Standard Long Label: Voyage Num
• Field's Standard Short Label: Voy#

[edit] Flight One

Labels:

• Field's Standard Long Label: Flight One
• Field's Standard Short Label: Flight1

[edit] Feeder Vessel Name

Labels:

• Field's Standard Long Label: Feeder Vessel Name
• Field's Standard Short Label: Feeder Vssl

[edit] Feeder Vessel Voyage Num

Labels:

• Field's Standard Long Label: Feeder Vessel Voyage Num
• Field's Standard Short Label: Feeder Voy#

[edit] Flight Two

Labels:

• Field's Standard Long Label: Flight Two
• Field's Standard Short Label: Flight2

[edit] Origin Terminal

• Meaning: Is the FIRST port of loading
• Format/type: ComboBox & Radio Button
• Examples: Shanghai, China
• MOT: Ocean FCL & LCL
• Default: The same as Port of Loading
• Master field?: N
• CRUD: Terminals#_Origin_Terminals

Labels:

• Field's Standard Long Label: Origin Terminal
• Field's Standard Short Label: Origin CY

[edit] Origin Terminal Estimated Date

Labels:

• Field's Standard Long Label: Original Terminal Estimated Date
• Field's Standard Short Label: ETD Origin CY

[edit] Origin Terminal Actual Date

Labels:

• Field's Standard Long Label: Origin Terminal Actual Date
• Field's Standard Short Label: ATD Origin CY

[edit] Port Of Loading

Labels:

• Field's Standard Long Label: Port Of Loading
• Field's Standard Short Label: Port Of Load

[edit] Airport Of Departure

• Meaning: Is the FIRST airport of loading
• Format/type: ComboBox & Radio Button
• Examples: Shanghai, China
• MOT: Air
• Default: The same as Airport of Departure
• Master field?: N

Labels:

• Field's Standard Long Label: Airport Of Departure
• Field's Standard Short Label: Origin Aiport

[edit] Port Of Loading Estimated Date

Labels:

• Field's Standard Long Label: Port Of Loading Estimated Date
• Field's Standard Short Label: ETD Port Of Laod

[edit] Airport Of Departure Estimated Date

Labels:

• Field's Standard Long Label: Airport Of Departure Estimated Date
• Field's Standard Short Label: ETD Origin Airport

[edit] Port Of Loading Actual Date

Labels:

• Field's Standard Long Label: Port Of Loading Actual Date
• Field's Standard Short Label: ATD Port of Load

[edit] Airport Of Departure Actual Date

Labels:

• Field's Standard Long Label: Airport Of Departure Actual Date
• Field's Standard Short Label: ATD Origin Airport

[edit] Trans Shipment

Labels:

• Field's Standard Long Label: Trans Shipment
• Field's Standard Short Label: TransShip Port

[edit] Trans Shipment Estimated Date

Labels:

• Field's Standard Long Label: Trans Shipment Estimated Date
• Field's Standard Short Label: ETD TransShip Port

[edit] Trans Shipment Actual Date

Labels:

• Field's Standard Long Label: Trans Shipment Actual Date
• Field's Standard Short Label: ATD TransShip Port

[edit] Port Of Discharge

Labels:

• Field's Standard Long Label: Port Of Discharge
• Field's Standard Short Label: Port Of Dischg

[edit] Airport Of Destination

• Meaning: Is the LAST airport of discharge at destination
• Format/type: ComboBox & Radio Button
• Examples: JFK, New York
• MOT: Air
• Default: The same as Airport of Destination
• Master field?: N

Labels:

• Field's Standard Long Label: Airport Of Destination
• Field's Standard Short Label: Dest. Airport

[edit] Port Of Discharge Estimated Date

Labels:

• Field's Standard Long Label: Port Of Discharge Estimated Date
• Field's Standard Short Label: ETA Port of Dischg

[edit] Airport Of Destination Estimated Date

Labels:

• Field's Standard Long Label: Airport Of Destination Estimated Date
• Field's Standard Short Label: ETA Dest. Airport

[edit] Port Of Discharge Actual Date

Labels:

• Field's Standard Long Label: Port Of Discharge Actual Date
• Field's Standard Short Label: ATA Port Of Dischg

[edit] Airport Of Destination Actual Date

Labels:

• Field's Standard Long Label: Airport Of Destination Actual Date
• Field's Standard Short Label: ATA Dest. Airport

[edit] Destination Terminal

• Meaning: Is the LAST port of discharge
• Format/type: ComboBox & Radio Button
• Examples: New York, United States
• MOT: Ocean FCL & LCL
• Default: The same as Port of Discharge
• Master field?: N
• CRUD: Terminals#_Destination_Terminals

Labels:

• Field's Standard Long Label: Destination Terminal
• Field's Standard Short Label: Dest. CY

[edit] Destination Terminal Estimated Date

Labels:

• Field's Standard Long Label: Destination Terminal Estimated Date
• Field's Standard Short Label: ETA Dest. CY

[edit] Destination Terminal Actual Date

Labels:

• Field's Standard Long Label: Destination Terminal Actual Date
• Field's Standard Short Label: ATA Dest. CY

[edit] Destination Receiving Agent combobox

Labels:

• Field's Standard Long Label: Destination Receiving Agent
• Field's Standard Short Label: Dest. Agent

[edit] Cubic Meter textbox

Labels:

• Field's Standard Long Label: Cubic Meter
• Field's Standard Short Label: CBM

[edit] Chargeable Weight textbox

[edit] Chargeable Weight

Labels:

• Field's Standard Long Label: Chargeable Weight
• Field's Standard Short Label: Chrgbl kg

[edit] HBL Comment

Labels:

• Field's Standard Long Label: HBL Comment
• Field's Standard Short Label: HBL Comment

[edit] HAWB Comment

Labels:

• Field's Standard Long Label: HAWB Comment
• Field's Standard Short Label: HAWB Comment

[edit] Export Customs Information

Labels:

• Field's Standard Long Label: Export Customs Information
• Field's Standard Short Label: Exp Customs

[edit] Import Fields

[edit] IT

Labels:

• Field's Standard Long Label: IT Number
• Field's Standard Short Label: IT #

[edit] IT Date

Labels:

• Field's Standard Long Label: IT Date
• Field's Standard Short Label: IT Dt

[edit] IT Location

Labels:

• Field's Standard Long Label: IT Location
• Field's Standard Short Label: IT Loc

[edit] Customs Broker

Labels:

• Field's Standard Long Label: Customs Broker
• Field's Standard Short Label: Cust Broker

[edit] Customs Broker Address

Labels:

• Field's Standard Long Label: Customs Broker Address
• Field's Standard Short Label: Cust Broker Addr

[edit] Import Delivery To

Labels:

• Field's Standard Long Label: Import Delivery To
• Field's Standard Short Label: Imp Del To

[edit] Import Delivery To Address

Labels:

• Field's Standard Long Label: Import Delivery To Address
• Field's Standard Short Label: Imp Del To Address

[edit] Delivery Address

same as #Import Delivery To

Labels:

• Field's Standard Long Label: Delivery Address
• Field's Standard Short Label: Del Address

[edit] 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)

Labels:

• Field's Standard Long Label: Delivery Instructions
• Field's Standard Short Label: Del Instr

[edit] 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: Labels:

• Field's Standard Long Label: Delivery Instructions
• Field's Standard Short Label: Del Instr

[edit] Last Free Day

Labels:

• Field's Standard Long Label: Last Free Day
• Field's Standard Short Label: Last Free Day

[edit] Import Pick Up

Labels:

• Field's Standard Long Label: Import Pick Up
• Field's Standard Short Label: Imp Pick Up

[edit] Cargo location

same as #Import Pick Up

Labels:

• Field's Standard Long Label: Cargo Location
• Field's Standard Short Label: Cargo Loc

[edit] Import Pick Up Address

Labels:

• Field's Standard Long Label: Import Pick Up Address
• Field's Standard Short Label: Imp P.U. Addr

[edit] Delivery Trucker

• Meaning: This is the trucker who will deliver the product to the CT#Delivery To party.
• Default value: Blank
• Required field? N
• Format/Datatype: CT_profile#ComboBox,
• User Read Access: all
• User Write Access: internal
• MOT: Air, Ocean

[edit] Delivery Date Type

Labels:

• Field's Standard Long Label: Delivery Date Type
• Field's Standard Short Label: Del Date Type

[edit] Delivery Comment

Labels:

• Field's Standard Long Label: Delivery Comment
• Field's Standard Short Label: Del Comment

[edit]

Labels:

• Field's Standard Long Label: Arrival Notice Comment
• Field's Standard Short Label: AN Comment

[edit] Estimated Delivery Date

• Meaning: This is an estimated date of when the delivery trucker is going to deliver the product to the CT#Delivery To location. This is an existing CT2 field, see #Estimated_Delivery_Date
• Default value: Blank
• Required field? N
• Format/Datatype: Datebox,
• User Read Access: all
• User Write Access: internal
• MOT: all

Location:

• Air, Client Consol, LCL: Imp Tab
• FCL and Truck-Ocean: Container#Estimated Delivery Date - Dates Tab
• Truck Dom, Truck Air: Gen Tab

[edit] Actual Delivery Date

• Meaning: This is actual date of when the delivery trucker delivered the product to the location. This is an existing CT2 field, see #Actual_Delivery_Date
• Default value: Blank
• Required field? N
• Format/Datatype: Datebox,
• User Read Access: all
• User Write Access: internal
• MOT: all

Location:

• Air, Client Consol, LCL: Imp Tab
• FCL and Truck-Ocean: Container#Actual Delivery Date - Dates Tab
• Truck Dom, Truck Air: Gen Tab

[edit] Jaguar Delivery Yes No

Labels:

• Field's Standard Long Label: Jaguar Delivery Yes No
• Field's Standard Short Label: Jaguar Del Y N

[edit] Original BL Required Yes No

Labels:

• Field's Standard Long Label: Original BL Required Yes No
• Field's Standard Short Label: Original BL Req Y N

[edit] Payment Of Charges Required Yes No

Labels:

• Field's Standard Long Label: Payment Of Charges Required Yes No
• Field's Standard Short Label: Pymnt Required Y N

[edit] Customs Status

Labels:

• Field's Standard Long Label: Customs Status
• Field's Standard Short Label: Customs Status

[edit] Customs Status Date

Labels:

• Field's Standard Long Label: Customs Status Date
• Field's Standard Short Label: Customs Status Date

[edit] FDA Status

Labels:

• Field's Standard Long Label: FDA Status
• Field's Standard Short Label: FDA Status

[edit] FDA Status Date

Labels:

• Field's Standard Long Label: FDA Status Date
• Field's Standard Short Label: FDA Status Date

[edit] Containers and Commodities

[edit] Plts

• see Commodity#Grand Total: Plts

[edit] Pkgs On Plts

• see Commodity#Grand Total: Pkgs On Plts

[edit] Loose

• see Commodity#Grand Total: Loose Pkgs

[edit] Gross Kg

• see Commodity#Grand Total: Gross Kg

[edit] Gross Lb

• see Commodity#Grand Total: Gross Lb

[edit] HU

• see Commodity#Grand Total: HU

[edit] CBM

• see Commodity#Grand Total: cbm

[edit] Com Table

See Commodity

[edit] Ctnr Table

See Container

[edit] Link to CRUD

See:

• Gen Tab
• Exp Tab
• Imp Tab

[edit] History

[edit] 002465: [EDI to TMS] (Misc) Add new TMSS field