CT bo

From UG

Contents 1 Definition 2 Scope 3 General Fields 3.1 Example 3.1.1 Acadaff Reference Field 3.2 References 3.2.1 CT Num 3.2.2 Export Ref 3.2.3 Import Ref 3.2.4 Customer Ref 3.2.5 Jaguar 3rd Ref 3.3 Dates 3.3.1 Cargo available 3.3.2 Cargo due 3.3.3 Created On Date 3.3.4 Created By 3.3.5 Time CT Created 3.3.6 Notification Date 3.3.7 Authorized On 3.3.8 Estimated Export Pick Up Date 3.3.9 Estimated Pick Up Date 3.3.10 Actual Export Pick Up Date 3.3.11 Actual Pick Up Date 3.3.12 Automated Estimated Delivery Date 3.4 Locations 3.4.1 Origin Country 3.4.2 Origin Country Note 3.4.3 Destination Country 3.4.4 Destination Country Note 3.4.5 Shipper 3.4.6 Shipper Address 3.4.7 Consignee 3.4.8 Consignee Address 3.4.9 Notify 3.4.10 Notify Address 3.4.11 Export Pick Up 3.4.11.1 Pick Up 3.4.11.2 Pick Up State 3.4.11.3 Pick Up Zip 3.4.11.4 Pick Up Company 3.4.12 Export Pick Up Address 3.4.13 Export Delivery To 3.4.14 Delivery To 3.4.14.1 Ship to State 3.4.14.2 Ship to Zip 3.4.15 Export Delivery To Address 3.4.16 Consol Warehouse 3.5 Client and Visibility 3.5.1 E0 Client 3.5.2 E1 3.5.3 E2 3.5.4 E3 3.6 Commodity related fields 3.6.1 Pick Up Comments 3.6.2 Commodity Description 3.6.3 Marks And Numbers 3.6.4 Hazardous Yes No 3.6.5 Hazardous Note 3.7 Authorization related fields 3.7.1 Authorized By 3.7.2 Authorized MOT 3.7.3 Authorization Method 3.8 Vendors 3.8.1 Export Pick Up Trucker 3.8.1.1 Pick Up Trucker 3.9 Misc 3.9.1 Mode Of Transport 3.9.1.1 MOT 3.9.2 Client Mode 3.9.3 Operator Of Last Change 3.9.4 Shipping Terms 3.9.5 Shipping Terms Location 3.9.6 On Customer Hold 3.9.7 Pending Approval 3.9.8 PT Number 3.9.9 DT Number 4 Export Fields 4.1 FedEx carrier ID 4.2 Freight Prepaid Collect 4.3 Arrival Into Warehouse 4.4 Move Type/HBL 4.5 Original House Bill Yes No 4.6 Steamshipline 4.7 Airline 4.8 Co Loaders 4.9 Booking Num 4.10 HAWB 4.11 MBL 4.12 MAWB 4.13 HBL 4.14 AMS Submission Date 4.15 Vessel Name 4.16 Voyage Num 4.17 Flight One 4.18 Feeder Vessel Name 4.19 Feeder Vessel Voyage Num 4.20 Flight Two 4.21 Origin Terminal 4.22 Origin Terminal Estimated Date 4.23 Origin Terminal Actual Date 4.24 Port Of Loading 4.25 Airport Of Departure 4.26 Port Of Loading Estimated Date 4.27 Airport Of Departure Estimated Date 4.28 Port Of Loading Actual Date 4.29 Airport Of Departure Actual Date 4.30 Trans Shipment 4.31 Trans Shipment Estimated Date 4.32 Trans Shipment Actual Date 4.33 Port Of Discharge 4.34 Airport Of Destination 4.35 Port Of Discharge Estimated Date 4.36 Airport Of Destination Estimated Date 4.37 Port Of Discharge Actual Date 4.38 Airport Of Destination Actual Date 4.39 Destination Terminal 4.40 Destination Terminal Estimated Date 4.41 Destination Terminal Actual Date 4.42 Destination Receiving Agent combobox 4.43 Cubic Meter textbox 4.44 Chargeable Weight textbox 4.45 HBL Comment 4.46 HAWB Comment 4.47 Export Customs Information 5 Import Fields 5.1 IT 5.2 IT Date 5.3 IT Location 5.4 Customs Broker 5.5 Customs Broker Address 5.6 Import Delivery To 5.7 Import Delivery To Address 5.7.1 Delivery Address 5.8 Delivery Comments 5.9 Delivery Instructions 5.10 Last Free Day 5.11 Import Pick Up 5.11.1 Cargo location 5.12 Import Pick Up Address 5.13 Delivery Trucker 5.14 Delivery Date Type 5.15 Delivery Comment 5.16 Arrival Notice Comment 5.17 Estimated Delivery Date 5.18 Actual Delivery Date 5.19 Jaguar Delivery Yes No 5.20 Original BL Required Yes No 5.21 Payment Of Charges Required Yes No 5.22 Customs Status 5.23 Customs Status Date 5.24 FDA Status 5.25 FDA Status Date 6 Containers and Commodities 6.1 Com Table 6.2 Ctnr Table 7 Link to CRUD

Definition

CT is often used as a short name for Shipment record in CT2 system.

Scope

This wiki describes CT (Shipment) Business Object

General Fields

For specific User Interface Implementation see also Gen Tab.

Table below gives cross reference current implementation with Business Object Fields defined in this wiki.

A	B	C	D
#Export Ref	#Import Ref	#Customer Ref	#Jaguar 3rd Ref
#E0 Client	#MOT	#Client Mode	#Operator Of Last Change
#E1 #E2 #E3	#Shipper #Shipper Address	#Consignee #Consignee Address	#Notify #Notify Address
#Export Pick Up #Export Pick Up Address	#Export Delivery To #Export Delivery To Address	#Pick Up Comments	#Export Pick Up Trucker
			#Estimated Export Pick Up Date #Actual Export Pick Up Date
#Origin Country Note #Origin Country #Destination Country Note #Destination Country	#Commodity Description #Marks And Numbers #Shipping Terms #Shipping Terms Location	#Notification Date #Authorized By #Authorized On #Authorized MOT #Automated Estimated Delivery Date #Authorization Method	#Hazardous Yes No radio #Hazardous Note textarea
			#MBL textbox #HBL textbox #Steamshipline textbox
			#Estimated Delivery Date #Actual Delivery Date
			#Last Free Day textbox #MAWB textbox #HAWB textbox #Airline textbox

all but FCL/Truck-Ocean

AIR/LCL/FCL

Truck Ocn

Truck Dom / Truck Air

Truck Air

All

Example

Acadaff Reference Field

Labels:

• Field's Standard Long Label: Acadaff Reference
• Field's Standard Short Label: Aca Ref

BO:

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

CRUD:

• Field's Widget:
• Widget properties:
  • default:
  • read only?

DB:

References

CT Num

Labels:

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

Export Ref

Labels:

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

Import Ref

Labels:

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

Customer Ref

Labels:

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

Jaguar 3rd Ref

Labels:

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

Dates

Cargo available

Labels:

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

Cargo due

Labels:

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

Created On Date

Labels:

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

Created By

Labels:

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

Time CT Created

Labels:

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

Notification Date

Labels:

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

Authorized On

Labels:

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

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:

Estimated Pick Up Date

same as #Estimated Export Pick Up Date

Labels:

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

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:

Actual Pick Up Date

same as #Actual Export Pick Up Date

Labels:

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

Automated Estimated Delivery Date

Labels:

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

Locations

Origin Country

Labels:

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

Origin Country Note

Labels:

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

Destination Country

Labels:

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

Destination Country Note

Labels:

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

Shipper

Labels:

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

Shipper Address

textarea below Shipper

Labels:

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

Consignee

Labels:

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

Consignee Address

Labels:

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

Notify

Labels:

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

Notify Address

Labels:

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

Export Pick Up

Labels:

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

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

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:

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

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:

Export Pick Up Address

Labels:

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

Export Delivery To

Labels:

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

Delivery To

same as #Export Delivery To

Labels:

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

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:

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:

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

Labels:

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

Client and Visibility

E0 Client

Labels:

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

E1

Labels:

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

E2

Labels:

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

E3

Labels:

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

Commodity related fields

Pick Up Comments

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

Labels:

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

Commodity Description

Labels:

• Standard Long Label: Commodity Description
• Standard Short Label: Goods Shipped:
• Other Labels in use:

Marks And Numbers

Labels:

• Standard Long Label: Marks and Numbers
• Standard Short Label: Marks & Numbers
• Other Labels in use:

Hazardous Yes No

Labels:

• Standard Long Label: Hazardous Yes No
• Standard Short Label: Haz Y N
• Other Labels in use:

Hazardous Note

Labels:

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

Authorization related fields

Authorized By

Labels:

• Field's Standard Long Label: Authorized By
• Field's Standard Short Label: Auth By

Authorized MOT

Labels:

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

Authorization Method

Labels:

• Field's Standard Long Label: Authorization Method
• Field's Standard Short Label: Autho Method

Vendors

Export Pick Up Trucker

Labels:

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

Pick Up Trucker

same as above

Misc

Mode Of Transport

Labels:

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

MOT

same as #Mode Of Transport

Labels:

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

Client Mode

Labels:

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

Operator Of Last Change

Labels:

• Field's Standard Long Label: Operator of Last Change
• Field's Standard Short Label: Op of Last Change

Shipping Terms

Labels:

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

Shipping Terms Location

Labels:

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

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

Pending Approval

• Meaning:
• 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

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.
• 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 #

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.
• * 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 #

Export Fields

See also Exp Tab.

LCL/AIR

AIR - bold

AIR/FCL/LCL - italic

FCL/LCL - regular

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

#Freight Prepaid Collect
#Arrival Into Warehouse
#Move Type/HBL #Original House Bill Yes No	#Steamshipline / #Airline #Co Loaders #Booking Num / #HAWB	#MBL / #MAWB #HBL #AMS Submission Date	#Vessel Name #Voyage Num / #Flight One #Feeder Vessel Name #Feeder Vessel Voyage Num / #Flight Two
#Origin Terminal #Origin Terminal Estimated Date #Origin Terminal Actual Date	#Port Of Loading / #Airport Of Departure #Port Of Loading Estimated Date / #Airport Of Departure Estimated Date #Port Of Loading Actual Date / #Airport Of Departure Actual Date	#Trans Shipment #Trans Shipment Estimated Date #Trans Shipment Actual Date	#Port Of Discharge / #Airport Of Destination #Port Of Discharge Estimated Date / #Airport Of Destination Estimated Date #Port Of Discharge Actual Date / #Airport Of Destination Actual Date
#Destination Terminal #Destination Terminal Estimated Date #Destination Terminal Actual Date	#Destination Receiving Agent combobox #Cubic Meter textbox #Chargeable Weight textbox	#HBL Comment #HAWB Comment	#Export Customs Information

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 #

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

Labels:

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

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

Steamshipline

Labels:

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

Airline

Labels:

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

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

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

Labels:

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

Voyage Num

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

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

• 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

Origin Terminal Estimated 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:
• Field's Standard Short Label:

Port Of Loading

Labels:

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

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:
• Field's Standard Short Label:

Port Of Loading Estimated Date

Labels:

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

Airport Of Departure Estimated Date

Labels:

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

Port Of Loading Actual Date

Labels:

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

Airport Of Departure Actual Date

Labels:

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

Trans Shipment

Labels:

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

Trans Shipment Estimated Date

Labels:

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

Trans Shipment Actual Date

Labels:

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

Port Of Discharge

Labels:

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

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:
• Field's Standard Short Label:

Port Of Discharge Estimated Date

Labels:

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

Airport Of Destination Estimated Date

Port Of Discharge Actual Date

Labels:

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

Airport Of Destination Actual Date

Labels:

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

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:
• Field's Standard Short Label:

Destination Terminal Estimated Date

Labels:

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

Destination Terminal Actual Date

Labels:

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

Destination Receiving Agent combobox

Labels:

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

Cubic Meter textbox

Labels:

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

Chargeable Weight textbox

Labels:

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

HBL Comment

Labels:

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

HAWB Comment

Labels:

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

Export Customs Information

Labels:

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

Import Fields

Table below is to cross reference current implementation with Business Object Fields defined in this wiki.

Not colored fields are fields that are used for all 3 modes: Air, LCL, FCL

A	B	C	D
#IT #IT Date #IT Location	#Customs Broker #Customs Broker Address	#Import Delivery To #Import Delivery To Address (#Delivery Address)	#Delivery Comments - old name #Delivery Instructions - new name
#Last Free Day #Import Pick Up (#Cargo location) #Import Pick Up Address	#Delivery Trucker #Delivery Date Type #Delivery Comment		#Arrival Notice Comment
	#Estimated Delivery Date #Actual Delivery Date LCL/AIR only!
	#Jaguar Delivery Yes No ! FCL only !
#Original BL Required Yes No ! LCL/FCL only !
#Payment Of Charges Required Yes No	#Customs Status #Customs Status Date	#FDA Status #FDAStatus Date

IT

Labels:

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

IT Date

Labels:

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

IT Location

Labels:

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

Customs Broker

Labels:

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

Customs Broker Address

Labels:

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

Import Delivery To

Labels:

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

Import Delivery To Address

Labels:

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

Delivery Address

same as #Import Delivery To

Labels:

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

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:
• Field's Standard Short Label:

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:
• Field's Standard Short Label:

Last Free Day

Labels:

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

Import Pick Up

Labels:

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

Cargo location

same as #Import Pick Up

Labels:

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

Import Pick Up Address

Labels:

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

Delivery Trucker

Labels:

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

Delivery Date Type

Labels:

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

Delivery Comment

Labels:

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

Arrival Notice Comment

Labels:

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

Estimated Delivery Date

Labels:

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

Actual Delivery Date

!!! Note: for FCL and Truck-Ocean it is Container#Actual Delivery Date

Labels:

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

Jaguar Delivery Yes No

Labels:

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

Original BL Required Yes No

Labels:

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

Payment Of Charges Required Yes No

Labels:

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

Customs Status

Labels:

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

Customs Status Date

Labels:

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

FDA Status

Labels:

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

FDA Status Date

Labels:

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

Containers and Commodities

Com Table

See Commodity

Ctnr Table

See Container

Link to CRUD

See:

• Gen Tab
• Exp Tab
• Imp Tab