CT bo
From UG
(→General Fields) |
(→TMSS field) |
||
Line 974: | Line 974: | ||
==== TMSS field ==== | ==== TMSS field ==== | ||
- | * Shown on CT edit header with values and updates after events. | + | * Meaning - Shown on CT edit header with values and updates after events. |
'''Labels:''' | '''Labels:''' | ||
* yet = CT was never imported yet (default value) | * yet = CT was never imported yet (default value) |
Revision as of 13:35, 24 November 2010
Definition
CT is often used as a short name for Shipment record in CT2 system.
Scope
This wiki describes CT (Shipment) Business Object
Visual Map
Table below gives cross reference current implementation with Business Object Fields defined in this wiki.
General
all but FCL/Truck-Ocean | AIR/LCL/FCL | Truck Ocn | Truck Dom / Truck Air | Truck Air | All |
Export
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.
Import
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.
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
General Fields
For specific User Interface Implementation see also Gen Tab.
Example
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
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
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
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
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
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
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
- 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
!!! 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
'* 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
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
- 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.
- 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
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
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 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
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
- 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
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:
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
Labels:
- Standard Long Label: Export Delivery To
- Standard Short Label: Exp Delivery To
- Other Labels in use:
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
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)
- 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
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
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
Hazardous Yes No
- Meaning: This is to advise if the product shipping is hazardous or not.
- 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
- Mode Of Transport: All but Truck modes
Hazardous Note
Labels:
- Standard Long Label: Hazardous Note
- Standard Short Label: Haz Note
- Other Labels in use:
Authorization related fields
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
Authorized MOT
Labels:
- Field's Standard Long Label: Authorized MOT
- Field's Standard Short Label: Authzd MOT
Authorization Method
Labels:
- Field's Standard Long Label: Authorization Method
- Field's Standard Short Label: Auth via
Vendors
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
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
- 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
Misc
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
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
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
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.
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
- 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
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: 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
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 #
TMSS field
- Meaning - Shown on CT edit header with values and updates after events.
Labels:
- 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
Export Fields
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: Origin Terminal Actual Date
- Field's Standard Short Label: ATD Origin CY
Port Of Loading
Labels:
- Field's Standard Long Label: Port Of Loading
- Field's Standard Short Label: Port Of Load
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
Labels:
- Field's Standard Long Label: Trans Shipment
- Field's Standard Short Label: TransShip Port
Trans Shipment Estimated Date
Labels:
- Field's Standard Long Label: Trans Shipment Estimated Date
- Field's Standard Short Label: ETD TransShip Port
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
Labels:
- Field's Standard Long Label: Airport Of Destination Actual Date
- Field's Standard Short Label: ATA Dest. Airport
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
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
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
Labels:
- Field's Standard Long Label: Chargeable Weight
- Field's Standard Short Label: Chrgbl kg
HBL Comment
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
IT
Labels:
- Field's Standard Long Label: IT Number
- Field's Standard Short Label: IT #
IT Date
Labels:
- Field's Standard Long Label: IT Date
- Field's Standard Short Label: IT Dt
IT Location
Labels:
- Field's Standard Long Label: IT Location
- Field's Standard Short Label: IT Loc
Customs Broker
Labels:
- Field's Standard Long Label: Customs Broker
- Field's Standard Short Label: Cust Broker
Customs Broker Address
Labels:
- Field's Standard Long Label: Customs Broker Address
- Field's Standard Short Label: Cust Broker Addr
Import Delivery To
Labels:
- Field's Standard Long Label: Import Delivery To
- Field's Standard Short Label: Imp Del To
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
same as #Import Delivery To
Labels:
- Field's Standard Long Label: Delivery Address
- Field's Standard Short Label: Del Address
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
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
Last Free Day
Labels:
- Field's Standard Long Label: Last Free Day
- Field's Standard Short Label: Last Free Day
Import Pick Up
Labels:
- Field's Standard Long Label: Import Pick Up
- Field's Standard Short Label: Imp Pick Up
Cargo location
same as #Import Pick Up
Labels:
- Field's Standard Long Label: Cargo Location
- Field's Standard Short Label: Cargo Loc
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
- 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
Labels:
- Field's Standard Long Label: Delivery Date Type
- Field's Standard Short Label: Del Date Type
Delivery 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
- 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
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
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
Labels:
- Field's Standard Long Label: Payment Of Charges Required Yes No
- Field's Standard Short Label: Pymnt Required Y N
Customs Status
Labels:
- Field's Standard Long Label: Customs Status
- Field's Standard Short Label: Customs Status
Customs Status Date
Labels:
- Field's Standard Long Label: Customs Status Date
- Field's Standard Short Label: Customs Status Date
FDA Status
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
Com Table
See Commodity
Ctnr Table
See Container
Link to CRUD
See: