CT bo

From UG

(Difference between revisions)
Jump to: navigation, search
(→Original House Bill Yes No)
(→Delivery To)
Line 555: Line 555:
* ''Required field?''  
* ''Required field?''  
** Internal: N
** Internal: N
-
** Shipper: Y
+
** 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 Read Access:'' all
* ''User Write Access:'' internal, shipper unless [[Cybertrax_2.1_Client_(requirements)#What_CTs_Shipper_may_edit_RULE]] is true  
* ''User Write Access:'' internal, shipper unless [[Cybertrax_2.1_Client_(requirements)#What_CTs_Shipper_may_edit_RULE]] is true  

Revision as of 19:58, 6 October 2010


Contents

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

A B C D
#Export Ref
File:Textbox.jpg 		#Import Ref
File:Textbox.jpg 		#Customer Ref
File:Textbox.jpg 		#Jaguar 3rd Ref
File:Textbox.jpg
#E0 Client
File:Combobox.JPG 		#MOT
File:Combobox.JPG 		#Client Mode
File:Dropdown.JPG 		#Operator Of Last Change
File:Textbox.jpg
#E1 File:Combobox.JPG
#E2 File:Combobox.JPG
#E3 File:Combobox.JPG
#Shipper
File:Combobox.JPG
#Shipper Address
File:Textarea.JPG 		#Consignee
File:Combobox.JPG
#Consignee Address
File:Textarea.JPG 		#Notify
File:Combobox.JPG
#Notify Address
File:Textarea.JPG
#Export Pick Up
File:Combobox.JPG
#Export Pick Up Address
File:Textarea.JPG 		#Export Delivery To
File:Combobox.JPG
#Export Delivery To Address
File:Textarea.JPG 		#Pick Up Comments
File:Textarea.JPG 		#Export Pick Up Trucker
File:Combobox.JPG
#Estimated Export Pick Up Date
File:Datebox.JPG
#Actual Export Pick Up Date
File:Datebox.JPG
#Origin Country Note
File:Textbox.jpg
#Origin Country
File:Combobox.JPG
#Destination Country Note
File:Textbox.jpg
#Destination Country
File:Combobox.JPG 		#Commodity Description
File:Textarea.JPG
#Marks And Numbers
File:Textarea.JPG
#Shipping Terms
File:Dropdown.JPG
#Shipping Terms Location
File:Textbox.jpg 		#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
File:Datebox.JPG
#Actual Delivery Date
File:Datebox.JPG
#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

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.


#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

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

A B C D
#IT
File:Textbox.jpg
#IT Date
File:Datebox.JPG
#IT Location
File:Textbox.jpg 		#Customs Broker
File:Textbox.jpg
#Customs Broker Address
File:Textarea.JPG 		#Import Delivery To
File:Textbox.jpg
#Import Delivery To Address
(#Delivery Address)
File:Textarea.JPG 		#Delivery Comments - old name
#Delivery Instructions - new name
File:Textarea.JPG
#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

General Fields

For specific User Interface Implementation see also Gen Tab.


Example

Abc Reference Field


Labels:

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:

Export Ref

Labels:

Import Ref

Labels:

Customer Ref

Labels:

Jaguar 3rd Ref

Labels:

Dates

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


Cargo due

Labels:

Created On Date

Labels:

Created By

Labels:

Time CT Created

Labels:

Notification Date

Labels:

Authorized On

Labels:

Estimated Export Pick Up Date

Labels:

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:

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:

Locations

Origin Country

Labels:

Origin Country Note

Labels:

Destination Country

Labels:

Destination Country Note

Labels:

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

Labels:

Shipper ZIP

This is a Derived field

Labels:

Shipper Address

textarea below Shipper

Labels:

Consignee

Labels:

Consignee State

This is a Derived field

Labels:

Consignee ZIP

This is a Derived field

Labels:

Consignee Address

Labels:

Notify

Labels:

Notify Address

Labels:

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:

Pick Up State

This is a Derived field

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:

Pick Up Address

Labels:

Export Pick Up Address

same as #Pick Up Address

Export Delivery To

Labels:

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
  • label on xls: Ship to State

Labels:

Ship to Zip
  • label on xls: Ship to Zip

Labels:

Export Delivery To Address

Labels:

Consol Warehouse

Labels:

Client and Visibility

E0 Client

Labels:

E1

Labels:

E2

Labels:

E3

Labels:

Commodity related fields

Pick Up Comments

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


Commodity Description


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:

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:

Authorization Method

Labels:

Vendors

Export Pick Up Trucker

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

Labels:

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


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:

MOT

same as #Mode Of Transport

Labels:

Client Mode

Labels:

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:

Shipping Terms Location

Labels:

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:

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:

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:

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:

Export Fields

FedEx carrier ID

Labels:

Freight Prepaid Collect

Labels:

Arrival Into Warehouse

Labels:

Move Type/HBL

Labels:

Original House Bill Yes No

Labels:

Steamshipline

Labels:

Airline

Labels:

Co Loaders

Labels:

Booking Num

Labels:

HAWB

Labels:

MBL

Labels:

MAWB

Labels:

HBL

Labels:

AMS Submission Date

Labels:

Vessel Name

Labels:

Voyage Num

Labels:

Flight One

Labels:

Feeder Vessel Name

Labels:

Feeder Vessel Voyage Num

Labels:

Flight Two

Labels:

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:


Origin Terminal Estimated Date

Labels:

Origin Terminal Actual Date

Labels:

Port Of Loading

Labels:

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:

Port Of Loading Estimated Date

Labels:

Airport Of Departure Estimated Date

Labels:

Port Of Loading Actual Date

Labels:


Airport Of Departure Actual Date

Labels:

Trans Shipment

Labels:

Trans Shipment Estimated Date

Labels:

Trans Shipment Actual Date

Labels:

Port Of Discharge

Labels:

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:

Port Of Discharge Estimated Date

Labels:

Airport Of Destination Estimated Date

Labels:

Port Of Discharge Actual Date

Labels:

Airport Of Destination Actual Date

Labels:

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:

Destination Terminal Estimated Date

Labels:

Destination Terminal Actual Date

Labels:

Destination Receiving Agent combobox

Labels:

Cubic Meter textbox

Labels:

Chargeable Weight textbox

Labels:

HBL Comment

Labels:

HAWB Comment

Labels:

Export Customs Information

Labels:

Import Fields

IT

Labels:

IT Date

Labels:

IT Location

Labels:

Customs Broker

Labels:

Customs Broker Address

Labels:

Import Delivery To

Labels:

Import Delivery To Address

Labels:

Delivery Address

same as #Import Delivery To

Labels:

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:

Delivery Instructions

Notes: Labels:

Last Free Day

Labels:

Import Pick Up

Labels:

Cargo location

same as #Import Pick Up

Labels:

Import Pick Up Address

Labels:

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: all

Delivery Date Type

Labels:

Delivery Comment

Labels:

Labels:

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:

Original BL Required Yes No

Labels:

Payment Of Charges Required Yes No

Labels:

Customs Status

Labels:

Customs Status Date

Labels:

FDA Status

Labels:

FDA Status Date

Labels:

Containers and Commodities

Com Table

See Commodity

Ctnr Table

See Container

Link to CRUD

See:

Retrieved from "https://wiki.jaguarfreight.com/CT_bo"
Personal tools