Cybertrax 2.1 Client (data dictionary)

Currently editing. Alex.

CT fields

PO Issued by

NEW FIELD! a.k.a. CT#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

Pick up Location

a.k.a. CT#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

Ship to Location

a.k.a. CT#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

Pick up Instructions

a.k.a. CT#Pick Up 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

a.k.a. CT#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

Cargo Available

a.k.a. CT#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

Fields that Shipper can not edit

Shipper

a.k.a. CT#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

Pick Up Trucker

see CT#Pick Up Trucker

Delivery Trucker

see CT#Delivery Trucker

Estimated Pick up date

see CT#Estimated Pick Up

Actual Pick up date

see CT#Actual Pick Up

• 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: internal, client, planner
• User Write Access: internal
• MOT: all

Estimated Delivery date

see #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: internal, client, planner
• User Write Access: internal
• MOT: all

Actual Delivery date

see #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: internal, client, planner
• User Write Access: internal
• MOT: all

Last Update

a.k.a. Ct#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

Last Update date time

NEW FIELD a.k.a. CT#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

Field related to Planners

CT Authorization status

NEW FIELD! a.k.a. CT#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 Date

NEW FIELD! a.k.a CT#Approved_For_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

Approved By

a.k.a. CT#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

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
• User Write Access: internal, planner
• Mode Of Transport: All

Authorization Comment

NEW FIELD! a.k.a. CT#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.