Cybertrax 2.1 Client (data dictionary)

From UG

Revision as of 17:58, 22 June 2010 (edit) Alex (Talk | contribs) (→Commodity table) ← Older edit		Revision as of 17:59, 22 June 2010 (edit) (undo) Alex (Talk | contribs) (→Jaguar role fields) Newer edit →
Line 83:		Line 83:
	* ''Required field?'' Y		* ''Required field?'' Y
	* ''Format/Datatype:'' Currency - USD		* ''Format/Datatype:'' Currency - USD
-
-	== Jaguar role fields ==
-
-	'''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.
-	* ''Default value:''  The operator’s company name & address as this based upon the users login name.  Pre-filled.  This is an existing CT2 field, see [[CT#Shipper]]
-	* ''Required field?'' Y
-	* ''Format/Datatype:'' [[CT_profile#ComboBox]], see [[CT#Shipper]]
-
-	'''Pick Up Trucker'''
-	* ''Meaning:'' This is the name of the trucker who will pick up the product once it is approved to ship.  This is an existing CT2 field, see [[CT#Pick Up Trucker]]
-	* ''Default value:'' Blank
-	* ''Required field?'' N
-	* ''Format/Datatype:'' [[CT_profile#ComboBox]], see [[CT#Pick Up Trucker]]
-
-	'''Delivery Trucker'''
-	* ''Meaning:'' This is the trucker who will deliver the product to the [[CT#Delivery To]] party.
-	* ''Default value:'' Blank
-	* ''Required field?'' N
-	* ''Format/Datatype:'' [[CT_profile#ComboBox]], see [[CT#Delivery Trucker]]
-
-	'''Estimated 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]], see [[CT#Estimated Pick Up]]
-
-	'''Actual 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]], see [[CT#Actual Pick Up]]
-
-	'''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]], see [[#Estimated_Delivery_Date]]
-
-	'''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]], see [[#Actual_Delivery_Date]]
	== Planner role fields ==		== Planner role fields ==

---

Revision as of 17:59, 22 June 2010

Contents 1 CT fields 1.1 PO Issued by 1.2 Pick up Location 1.3 Ship to Location 1.4 Pick up Instructions 1.5 Commodity Description 1.6 Cargo Available 2 Commodity fields 2.1 P.O. 2.2 SKU 2.3 Quantity 2.4 Item Description 2.5 Number of Plts 2.6 Pkgs on Plts 2.7 Loose Pkgs 2.8 GW 2.9 Total Value 2.10 Haz/Non-Haz 2.11 Stackable 2.12 Piece price 3 Planner role fields 3.1 Read only properties of Planner role fields

CT fields

PO Issued by

NEW FIELD!

• 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

Commodity fields

P.O.

a.k.a. Commodity#PO

• Meaning: This is the purchase order number for the product shipping.
• Standard Long Label: PO #
• Standard Short Label: PO #
• Other Labels in use:
• Format/type: Alphanumeric
• Min/max: from 0 to 30 chars
• Possible Values: TBD
• Widget: Textbox
• Default value: blank
• Required field?
  • Internal: N
  • Shipper: Y
• User Read Access: client, shipper, planner, internal
• User Write Access: internal, shipper
• Mode Of Transport: All

SKU

a.k.a. Commodity#SKU

• Meaning: This is the sku number of the product shipping.
• Standard Long Label: Sku #
• Standard Short Label: Sku #
• Other Labels in use:
• Format/type: Alphanumeric
• Min/max: from 0 to 30 chars
• Possible Values: TBD
• Widget: Textbox
• Default value: blank
• Required field?
  • Internal: N
  • Shipper: Y
• User Read Access: client, planner, shipper, internal
• User Write Access: internal, shipper
• Mode Of Transport: All

Quantity

a.k.a. Commodity#Qty

• Meaning: These are the actual number of pieces for the product shipping.
• Standard Long Label: Quantity
• Standard Short Label: Qty #
• Other Labels in use:
• Format/type: Positive Integer
• Min/max: from 0 to 9999999999 digits
• Possible Values: TBD
• Widget: Textbox
• Default value: 0
• Required field?
  • Internal: N
  • Shipper: value must be > 0
• User Read Access: client, planner, shipper, internal
• User Write Access: internal, shipper
• Mode Of Transport: All

Item Description

a.k.a. Commodity#Description

• Meaning: This is the description of the PO and SKU that is shipping.
• Standard Long Label: Commodity Line 1
• Standard Short Label: Com Ln1
• Other Labels in use:
• Format/type: Alphanumeric
• Min/max: from 0 to 60 chars
• Possible Values: TBD
• Widget: Textbox
• Default value: blank
• Required field?
  • internal: N
  • shipper: Y
• User Read Access: client, planner, shipper, internal
• User Write Access: internal, shipper
• Mode Of Transport: All

Number of Plts

a.k.a. Commodity#Plts

• Meaning: This is the number of pallets that are shipping.
• Standard Long Label: # Of Plts
• Standard Short Label: # Of Plts
• Other Labels in use:
• Format/type: Positive Integer
• Min/max: from 0 to 10 digits
• Possible Values: TBD
• Widget: Textbox
• Default value: blank
• Required field?
  • internal: N
  • shipper: see #Commodity#Loose_and_Plts_can_not_be_zero_at_the_same_time_RULE and Commodity#Weight_and_Number_of_Plts_validations_to_web_portal_on_commodity_line_item
• User Read Access: client, planner, shipper, internal
• User Write Access: internal, shipper
• Mode Of Transport: All

Pkgs on Plts

a.k.a. Commodity#Pkgs On Plts

• Meaning: This is the number of packages that are packed on the pallets shipping with a package type.
• Standard Long Label: Pkgs On Plts
• Standard Short Label: Pkgs On Plts
• Other Labels in use:
• Format/type: Positive Integer
• Min/max: from 0 to 10 digits
• Possible Values: TBD
• Widget: Textbox and listbox
• Default value: blank for # and cartons for package type. See #Pkgs On Plts Type
• Required field?
• Internal: N
• Shipper: see #Pkgs_On_Plts_can_not_be_zero_if_Plts_is_not_zero
• User Read Access: client, planner, shipper, internal
• User Write Access: internal, shipper
• Mode Of Transport: All

Loose Pkgs

a.k.a. Commodity#Loose Pkgs

• Meaning: This is the number of loose packages that are shipping with a package type.
• Standard Long Label: Pkgs On Plts
• Standard Short Label: Pkgs On Plts
• Other Labels in use:
• Format/type: Positive Integer
• Min/max: from 0 to 10 digits
• Possible Values: TBD
• Widget: Textbox and listbox
• Default value: blank for # and bags for package type. See #Loose Pkgs Type
• Required field?
  • internal: N
  • shipper: see #Loose and Plts can not be zero at the same time RULE
• User Read Access: client, planner, shipper, internal
• User Write Access: internal, shipper
• Mode Of Transport: All

GW

a.k.a. Commodity#Gross Lb

• Meaning: This is the gross weight of the product that is shipping.
• Standard Long Label: Gross Weight Lb
• Standard Short Label: Ttl GW Lb
• Other Labels in use:
• Format/type: Decimal
• Min/max: TBD
• Possible Values: TBD
• Widget: Textbox
• Default value: blank
• Required field?
  • Internal: N
  • Shipper: Y (See validation here: Commodity#Weight_and_Number_of_Plts_validations_to_web_portal_on_commodity_line_item)
• User Read Access: client, planner, shipper, internal
• User Write Access: internal, shipper
• Mode Of Transport: All

Total Value

• Meaning: This is the total value of the unit piece price multiplied by the quantity of each PO/SKU that is shipping.
• Default value: Blank
• Required field? Y
• Format/Datatype: Datatypes#ascii

Haz/Non-Haz

a.k.a. CT#Hazardous Yes No

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

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

Stackable

• Meaning: This is to advise if the pallets for the product shipping are stackable or not. This is a new CT2 field.
• Default value: Yes
• Required field? Y
• Format/Datatype: Listbox option [Yes][No]

Piece price

• Meaning: This is the unit price of each piece piece shipping for a PO/SKU. This is a new CT2 field.
• Default value: Blank
• Required field? Y
• Format/Datatype: Currency - USD

Planner role fields

CT Authorization status

• Meaning: It allows a planner to set a status (approve, reject, or hold) to any shipments created by a supplier.
• Default value: Blank
• Required field? Y
• Format/Datatype: Listbox with option to choose one of three choices

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
• Default value: Blank
• Required field? N
• Format/Datatype: Datebox with a clear button

Approved By

Approved On

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

• Meaning: Shipment was approved for transportation by whom and when
• 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
• Format/Datatype:Read only Textarea

Hold Info

• Name of person who placed on hold, including the date & time)

• Meaning: Shipment was placed on hold for transportation by whom and when. It also allows a planner to come back to update the status to approve, reject, or hold with a date. This field will record any updates made by a planner in the history log and will display the last update recorded on the shipment record.
• 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 placed on hold
• Format/Datatype: Read only Textarea with history log button
• Additional Info: Comment pop-up window will appear once a planner clicks Apply

Rejected Info

• Name of person who rejected it, including the date & time)

• Meaning: Shipment was rejected for transportation by whom and when
• 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 rejected
• Format/Datatype: Read only Textarea
• Additional Info: Comment pop-up window will appear once a planner clicks Apply

Comment Info

• 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.
• Default value: Blank
• Required field? N
• Format/Datatape: textarea
• 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.

History Log Info

• Keeps a record of all status events

• Meaning: It is a field of recorded status events shown on a shipment record.
• Default value: blank
• Required field? Y - when there is an updated info
• Format/Datatype: a button to a history log screen
• Additional Info: Event status, name of the planner, and date and timestamps.

• Example: 9-Jun-2010 Put on hold Alex Doe

Read only properties of Planner role fields

• [a] ...