Cybertrax 2.1 Client (data dictionary)

From UG

(Difference between revisions)
Jump to: navigation, search
(→Intro)
m
 
(95 intermediate revisions not shown)
Line 1: Line 1:
[[Category:Cybertrax 2.1 Client]]
[[Category:Cybertrax 2.1 Client]]
-
== Fields related to Shipper role ==
+
<!--div style="background-color:coral">
-
=== New Fields ===
+
<font size="10">Currently editing. Alex. </font-->
-
'''PO Issued by:'''
+
-
{{#lst:CT_bo|POIssuedby}}
+
-
=== Existing fields ===
+
== CT fields ==
-
'''Pick up Location:'''  
+
==== PO Issued by ====
-
* ''Description:'' This is the location of where the goods are actually shipping from.  
+
<font color="red">'''NEW FIELD!'''</font>
-
** This is an existing CT2 field, see [[CT#Export_Pick_Up]]
+
a.k.a. [[CT#PO_Issued_by]]
-
* ''Default value:'' Shippers Address 
+
{{#lst:CT_bo|POIssuedby}}
-
* ''Required field?'' Y
+
-
* ''Format/Datatype:'' see [[CT#Export_Pick_Up]]
+
 +
==== Pick up Location ====
 +
a.k.a. [[CT#Export_Pick_Up]]
 +
{{#lst:CT_bo|ExportPickUp}}
-
'''Ship to Location:'''
+
==== Ship to Location ====
-
* ''Description:'' This is where the goods are shipping to.  
+
a.k.a. [[CT#Delivery To]]
-
** This is an existing CT2 field, see [[CT#Delivery To]]
+
{{#lst:CT_bo|DeliveryTo}}
-
* ''Default value:'' Blank
+
* ''NOTE:'' This field from web portal is needed to map to both '''Delivery To''' and '''Consignee''' fields on the Internal app
-
* ''Required field?'' Y
+
-
* ''Format/Datatype:'' see [[CT#Delivery To]]
+
-
'''Pick up Instructions:'''
+
==== Pick up Instructions ====
-
* ''Meaning:'' This field is for the user to list any specific pick up instructions for the trucking company. This is an existing CT2 field, see [[CT#Pick Up Comments]]  
+
a.k.a. [[CT#Pick Up Comments]]  
-
* ''Default:'' Blank
+
{{#lst:CT_bo|PickUpInstructions}}
-
* ''Required?'' N
+
-
* ''Format/Datatype:'' see [[CT#Pick Up Comments]]
+
 +
==== Commodity Description ====
 +
a.k.a. [[CT#Commodity Description]] 
 +
{{#lst:CT_bo|CommodityDescription}}
-
'''Commodity Description:'''
+
==== Cargo Available ====
 +
a.k.a. [[CT#Cargo_available]] 
 +
{{#lst:CT_bo|CargoAvailable}}
-
* ''Meaning:'' This field is for the user to list a general description of the contents being shipped. This is an existing CT2 field, see [[CT#Commodity Description]] 
+
=== Fields that Shipper can not edit ===
-
* ''Default value:'' Blank 
+
-
* ''Required field?'' Y
+
-
* ''Format/Datatype:'' see [[CT#Commodity Description]]
+
 +
==== Shipper ====
-
'''Cargo Available:'''
+
a.k.a. [[CT#Shipper]] 
 +
{{#lst:CT_bo|Shipper}}
-
* ''Meaning:'' This is the date that the goods are available for pick up.  This is an existing CT2 field, see [[CT#Cargo Available]]
+
==== Pick Up Trucker ====
-
* ''Default value:'' The date that the record is created
+
see [[CT#Pick Up Trucker]]
-
* ''Required field?'' Y
+
-
* ''Format/Datatype:'' see [[CT#Cargo Available]]
+
-
==== Commodity table ====
+
==== Delivery Trucker====  
 +
see [[CT#Delivery Trucker]]
-
'''P.O.:'''
+
==== Estimated Pick up date====
 +
see [[CT#Estimated_Pick_Up_Date]]
-
* ''Meaning:'' This is the purchase order number for the product shipping.  This is an existing CT2 field, see [[Commodity#PO]]
+
==== Actual Pick up date====
-
* ''Default value:'' Blank 
+
see [[CT#Actual Pick Up Date ]]
-
* ''Required field?'' Y
+
-
* ''Format/Datatype:''Alphanumeric, see [[Commodity#PO]]
+
 +
==== Estimated Delivery date====
 +
see [[CT#Estimated Delivery Date]]
-
'''SKU:'''
+
==== Actual Delivery date====
 +
see [[CT#Actual_Delivery_Date]]
-
* ''Meaning:'' This is the sku number of the product shipping. This is an existing CT2 field, see [[Commodity#SKU]]
+
==== Last Update ====
-
* ''Default value:''  Blank
+
a.k.a. [[Ct#Operator_Of_Last_Change]]
-
* ''Required field?'' Y
+
{{#lst:CT_bo|LastUpdateBy}}
-
* ''Format/Datatype:'' Alphanumeric, see [[Commodity#SKU]]
+
 +
==== Last Update date time ====
 +
<font color="red">'''NEW FIELD'''</font>
 +
a.k.a. [[CT#Last Modified DateTime]]
 +
{{#lst:CT_bo|LastModifiedDateTime}}
-
'''Quantity:'''  
+
==== Routed Date ====
 +
<font color="red">'''NEW FIELD'''</font>
 +
a.k.a [[CT#Routed_Date]]
 +
{{#lst:CT_bo|RoutedDate}}
-
* ''Meaning:'' These are the actual number of pieces for the product shipping.  This is an existing CT2 field, see [[Commodity#Qty]]
+
=== Field related to Planners ===
-
* ''Default value:'' Blank
+
-
* ''Required field?'' Y
+
-
* ''Format/Datatype:'' Numeric, see [[Commodity#Qty]]
+
-
'''Item Description:'''
+
==== CT Authorization status====
 +
<font color="red">'''NEW FIELD!'''</font>
 +
a.k.a. [[CT#CT_Authorization_status]]
 +
{{#lst:CT_bo|CTAuthorizationStatus}}
-
* ''Meaning:'' This is the description of the PO and SKU that is shipping. This is an existing CT2 field, see [[Commodity#Description]]
+
==== Approved For Date ====
-
* ''Default value:'' Blank 
+
<font color="red">'''NEW FIELD!'''</font>
-
* ''Required field?'' Y
+
a.k.a [[CT#Approved_For_Date]]
-
* ''Format/Datatype:'' Alpha, see [[Commodity#Description]]
+
{{#lst:CT_bo|ApprovedForDate}}
 +
==== Approved By====
 +
a.k.a. [[CT#Authorized By]]
 +
{{#lst:CT_bo|AuthorizedBy}}
-
'''Number of Plts:'''
+
==== Approved On====
 +
a.k.a. [[CT#Authorized On]]
-
* ''Meaning:'' This is the number of pallets that are shipping.  This is an existing CT2 field, see [[Commodity#Plts]]
+
(with name of person who approved, including the date & time)
-
* ''Default value:'' Blank 
+
-
* ''Required field?'' Y
+
-
* ''Format/Datatype:'' Numeric, see [[Commodity#Plts]]
+
 +
* ''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
-
'''Pks on Plts:'''
+
==== Authorization Comment ====
 +
<font color="red">'''NEW FIELD!'''</font>
 +
a.k.a. [[CT#Authorization_Comment]]
 +
{{#lst:CT_bo|AuthorizationComment}}
-
* ''Meaning:'' This is the number of packages that are packed on the pallets shipping.  This is an existing CT2 field, see [[Commodity#Pkgs On Plts]] 
+
<!--
-
* ''Default value:'' Blank 
+
==== Authorization History ====
-
* ''Required field?'' Y
+
-
* ''Format/Datatype:'' Numeric, see [[Commodity#Pkgs On Plts]]
+
 +
<font color="red">'''NEW FIELD/OBJECT'''</font>
-
'''Loose Pkgs:'''
+
* Keeps a record of all status events
-
* ''Meaning:'' This is the number of loose packages that are shipping.  This is an existing CT2 field, see [[Commodity#Loose Pkgs]]
+
* ''Meaning:'' It is a field of recorded status events shown on a shipment record.   
-
* ''Default value:'' Blank 
+
* ''Default value:'' blank
-
* ''Required field?'' Y
+
* ''Required field?'' Y - when there is an updated info
-
* ''Format/Datatype:'' Numeric, see [[Commodity#Loose Pkgs]]
+
* ''Format/Datatype: a button to a [http://mantis.jaguarfreight.com/wiki/Cybertrax_2.1_Client_(requirements)#Authorization_History history log screen]
 +
* ''Additional Info:'' Event status, name of the planner, and date and timestamps.
 +
:* Example: 9-Jun-2010  Put on hold  Alex Doe
 +
-->
 +
</div>
-
'''GW:'''
+
== Commodity fields ==
-
* ''Meaning:''  This is the gross weight of the product that is shipping. This is an existing CT2 field, see [[Commodity#Gross Lb]]
+
===== P.O. =====
-
* ''Default value:'' Blank
+
a.k.a. [[Commodity#PO]]
-
* ''Required field?'' Y
+
{{#lst:Commodity|PO}}
-
* ''Format/Datatype:'' Numeric, see [[Commodity#Gross Lb]]
+
 +
===== SKU =====
 +
a.k.a. [[Commodity#SKU]] 
 +
{{#lst:Commodity|SKU}}
-
'''Piece price:'''
+
===== Quantity =====
 +
a.k.a. [[Commodity#Qty]]
 +
{{#lst:Commodity|Qty}}
-
* ''Meaning:'' This is the unit price of each piece piece shipping for a PO/SKU. This is a new CT2 field.
+
===== Item Description =====
-
* ''Default value:'' Blank 
+
a.k.a. [[Commodity#Description]]
-
* ''Required field?'' Y
+
{{#lst:Commodity|Description}}
-
* ''Format/Datatype:'' Currency - USD
+
 +
===== Number of Plts =====
 +
a.k.a. [[Commodity#Plts]]
 +
{{#lst:Commodity|Plts}}
-
'''Total Value:'''
+
===== Pkgs on Plts =====
 +
a.k.a. [[Commodity#Pkgs On Plts]]
 +
{{#lst:Commodity|PkgsOnPlts}}
-
* ''Meaning:'' This is the total value of the unit piece price multiplied by the quantity of each PO/SKU that is shipping.
+
===== Pkgs on Plts Type =====
-
* ''Default value:'' Blank
+
a.k.a. [[Commodity#Pkgs_On_Plts_Type]]
-
* ''Required field?'' Y
+
{{#lst:Commodity|LoosePkgsType}}
-
* ''Format/Datatype:'' [[Datatypes#ascii]]
+
 +
===== Loose Pkgs =====
 +
a.k.a. [[Commodity#Loose Pkgs]]
 +
{{#lst:Commodity|LoosePkgs}}
-
'''Haz/Non-Haz:'''
+
===== GW =====
 +
a.k.a. [[Commodity#Gross Lb]]
 +
{{#lst:Commodity|GrossLb}}
-
* ''Meaning:'' This is to advise if the product shipping is hazardous or not. This is an existing CT2 field, see [[CT#Hazardous Yes No]]
+
===== GW Unit =====
-
* ''Default value:''  No
+
a.k.a. [[Commodity#Gross_Unit]]
-
* ''Required field?'' Y
+
{{#lst:Commodity|GrossUnit}}
-
* ''Format/Datatype:'' [[Listbox]] option [Yes][No]
+
 +
===== Haz/Non-Haz =====
 +
a.k.a. [[Commodity#Hazardous Yes No]]
 +
{{#lst:Commodity|HazardousYesNo}}
-
'''Stackable:'''
+
==== Stackable ====  
-
 
+
<font color="red">'''NEW FIELD!'''</font>
-
* ''Meaning:''  This is to advise if the pallets for the product shipping are stackable or not.  This is a new CT2 field.
+
a.k.a. [[Commodity#Stackable]]
-
* ''Default value:'' Yes 
+
{{#lst:Commodity|Stackable}}
-
* ''Required field?'' Y
+
-
* ''Format/Datatype:'' [[Listbox]] option [Yes][No]
+
-
 
+
-
=== 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]]
+
-
 
+
-
==== Read only properties ====
+
-
 
+
-
* [a] Fields above are editable only by ''jaguar operator''s.
+
-
** [a1] They are editable any time.
+
-
 
+
-
=== 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
+
-
 
+
-
'''Approval Info'''
+
-
* (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
+
 +
==== Piece price ====
 +
<font color="red">'''NEW FIELD!'''</font>
 +
a.k.a. [[Commodity#Piece_price]]
 +
{{#lst:Commodity|PiecePrice}}
 +
==== Total Value ====
 +
<font color="red">'''NEW FIELD!'''</font>
 +
a.k.a. [[Commodity#Total_Value]]
 +
{{#lst:Commodity|TotalValue}}
-
==== Read only properties of Planner role fields ====
+
== Misc fields or derived info ==
-
* [a] ...
+
=== Planner ===

Current revision as of 21:09, 23 November 2010


Contents

[edit] CT fields

[edit] PO Issued by

NEW FIELD! a.k.a. CT#PO_Issued_by


[edit] 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


[edit] 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
  • NOTE: This field from web portal is needed to map to both Delivery To and Consignee fields on the Internal app

[edit] Pick up Instructions

a.k.a. CT#Pick Up Comments


[edit] Commodity Description

a.k.a. CT#Commodity Description


[edit] Cargo Available

a.k.a. CT#Cargo_available


[edit] Fields that Shipper can not edit

[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


[edit] Pick Up Trucker

see CT#Pick Up Trucker

[edit] Delivery Trucker

see CT#Delivery Trucker

[edit] Estimated Pick up date

see CT#Estimated_Pick_Up_Date

[edit] Actual Pick up date

see CT#Actual Pick Up Date

[edit] Estimated Delivery date

see CT#Estimated Delivery Date

[edit] Actual Delivery date

see CT#Actual_Delivery_Date

[edit] 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


[edit] 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


[edit] Routed Date

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


[edit] Field related to Planners

[edit] 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


[edit] 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


[edit] 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


[edit] 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

[edit] 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.


</div>

[edit] Commodity fields

[edit] 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


[edit] 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


[edit] 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


[edit] 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


[edit] Number of Plts

a.k.a. Commodity#Plts


[edit] Pkgs on Plts

a.k.a. Commodity#Pkgs On Plts


[edit] Pkgs on Plts Type

a.k.a. Commodity#Pkgs_On_Plts_Type


[edit] Loose Pkgs

a.k.a. Commodity#Loose Pkgs


[edit] GW

a.k.a. Commodity#Gross Lb


[edit] GW Unit

a.k.a. Commodity#Gross_Unit

  • Meaning: This is the gross weight unit of measurement
  • Standard Long Label: none
  • Standard Short Label:none
  • Other Labels in use:
  • Format/type: dropdown Lb/Kg
  • Min/max: TBD
  • Possible Values: TBD
  • Widget: List
  • Default value: If MOT is Dom Truck then default to Lb else Kg
  • Required field?
    • Internal: N
    • Shipper: Y
  • User Read Access: client, planner, shipper, internal
  • User Write Access: internal, shipper
  • Mode Of Transport: All


[edit] Haz/Non-Haz

a.k.a. Commodity#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: Listbox option [Yes][No]
  • Min/max: n/a
  • Possible Values: Yes, No
  • Widget: radiogroup or listbox
  • Default value: No
  • Required field?
    • Internal: Y
    • Shipper: Y
  • User Read Access: client, planner, shipper, internal
  • User Write Access: internal, shipper
  • Mode Of Transport: Truck Dom for Client 2.1 phase 1. Later we might add for other MOTs


[edit] Stackable

NEW FIELD! a.k.a. Commodity#Stackable


[edit] Piece price

NEW FIELD! a.k.a. Commodity#Piece_price

  • Meaning: This is the unit price of each piece piece shipping for a PO/SKU.
  • Standard Long Label: Piece price
  • Standard Short Label: Price
  • Other Labels in use:
  • Format/type: 4 decimal point Decimal, Currency - USD
  • Min/max: TBD
  • Possible Values: TBD
  • Widget: Textbox
  • Default value: 0.00
  • Required field?
    • Internal: N
    • Shipper: Y
  • User Read Access: internal, client, planner, shipper
  • User Write Access: shipper
  • Mode Of Transport: Truck Domestic


[edit] Total Value

NEW FIELD! a.k.a. Commodity#Total_Value

  • Meaning: This is the total value of the unit piece price multiplied by the quantity of each PO/SKU that is shipping.
  • Standard Long Label: Total Value
  • Standard Short Label: Ttl Val
  • Other Labels in use:
  • Format/type: No Decimal point ; round number up for greater or equal 5 and down for less than 5 , Currency - USD
  • Min/max: TBD
  • Possible Values: TBD
  • Widget: Textbox
  • Default value: Blank
  • Required field?
    • Internal: N
    • Shipper: Y
  • User Read Access: internal, client, shipper, planner
  • User Write Access: no access, because this field is calculated.
  • Mode Of Transport: Truck Domestic


[edit] Misc fields or derived info

[edit] Planner

Retrieved from "https://wiki.jaguarfreight.com/Cybertrax_2.1_Client_(data_dictionary)"
Personal tools