Cybertrax 2.1 Client (data dictionary)

From UG

(Difference between revisions)
Jump to: navigation, search
(→Jaguar role fields)
m
 
(80 intermediate revisions not shown)
Line 1: Line 1:
[[Category:Cybertrax 2.1 Client]]
[[Category:Cybertrax 2.1 Client]]
-
== CT fields ==
+
<!--div style="background-color:coral">
 +
<font size="10">Currently editing. Alex. </font-->
 +
 +
== CT fields ==
==== PO Issued by ====
==== PO Issued by ====
<font color="red">'''NEW FIELD!'''</font>
<font color="red">'''NEW FIELD!'''</font>
 +
a.k.a. [[CT#PO_Issued_by]]
{{#lst:CT_bo|POIssuedby}}
{{#lst:CT_bo|POIssuedby}}
Line 15: Line 19:
a.k.a. [[CT#Delivery To]]
a.k.a. [[CT#Delivery To]]
{{#lst:CT_bo|DeliveryTo}}
{{#lst:CT_bo|DeliveryTo}}
 +
* ''NOTE:'' This field from web portal is needed to map to both '''Delivery To''' and '''Consignee''' fields on the Internal app
==== Pick up Instructions ====
==== Pick up Instructions ====
Line 25: Line 30:
==== Cargo Available ====
==== Cargo Available ====
-
a.k.a. [[CT#Cargo Available]]   
+
a.k.a. [[CT#Cargo_available]]   
{{#lst:CT_bo|CargoAvailable}}
{{#lst:CT_bo|CargoAvailable}}
 +
 +
=== Fields that Shipper can not edit ===
 +
 +
==== Shipper ====
 +
 +
a.k.a. [[CT#Shipper]] 
 +
{{#lst:CT_bo|Shipper}}
 +
 +
==== Pick Up Trucker ====
 +
see [[CT#Pick Up Trucker]]
 +
 +
==== Delivery Trucker====
 +
see [[CT#Delivery Trucker]]
 +
 +
==== Estimated Pick up date====
 +
see [[CT#Estimated_Pick_Up_Date]]
 +
 +
==== Actual Pick up date====
 +
see [[CT#Actual Pick Up Date ]]
 +
 +
==== Estimated Delivery date====
 +
see [[CT#Estimated Delivery Date]]
 +
 +
==== Actual Delivery date====
 +
see [[CT#Actual_Delivery_Date]]
 +
 +
==== Last Update ====
 +
a.k.a. [[Ct#Operator_Of_Last_Change]]
 +
{{#lst:CT_bo|LastUpdateBy}}
 +
 +
==== Last Update date time ====
 +
<font color="red">'''NEW FIELD'''</font>
 +
a.k.a. [[CT#Last Modified DateTime]]
 +
{{#lst:CT_bo|LastModifiedDateTime}}
 +
 +
==== Routed Date ====
 +
<font color="red">'''NEW FIELD'''</font>
 +
a.k.a [[CT#Routed_Date]]
 +
{{#lst:CT_bo|RoutedDate}}
 +
 +
=== Field related to Planners ===
 +
 +
 +
==== CT Authorization status====
 +
<font color="red">'''NEW FIELD!'''</font>
 +
a.k.a. [[CT#CT_Authorization_status]]
 +
{{#lst:CT_bo|CTAuthorizationStatus}}
 +
 +
==== Approved For Date ====
 +
<font color="red">'''NEW FIELD!'''</font>
 +
a.k.a [[CT#Approved_For_Date]]
 +
{{#lst:CT_bo|ApprovedForDate}}
 +
 +
==== Approved By====
 +
a.k.a. [[CT#Authorized By]]
 +
{{#lst:CT_bo|AuthorizedBy}}
 +
 +
==== 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
 +
 +
==== Authorization Comment ====
 +
<font color="red">'''NEW FIELD!'''</font>
 +
a.k.a. [[CT#Authorization_Comment]]
 +
{{#lst:CT_bo|AuthorizationComment}}
 +
 +
<!--
 +
==== Authorization History ====
 +
 +
<font color="red">'''NEW FIELD/OBJECT'''</font>
 +
 +
* 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 [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>
== Commodity fields ==
== Commodity fields ==
Line 53: Line 155:
a.k.a. [[Commodity#Pkgs On Plts]]
a.k.a. [[Commodity#Pkgs On Plts]]
{{#lst:Commodity|PkgsOnPlts}}
{{#lst:Commodity|PkgsOnPlts}}
 +
 +
===== Pkgs on Plts Type =====
 +
a.k.a. [[Commodity#Pkgs_On_Plts_Type]]
 +
{{#lst:Commodity|LoosePkgsType}}
===== Loose Pkgs =====
===== Loose Pkgs =====
Line 62: Line 168:
{{#lst:Commodity|GrossLb}}
{{#lst:Commodity|GrossLb}}
-
===== Total Value =====
+
===== GW Unit =====
-
* ''Meaning:'' This is the total value of the unit piece price multiplied by the quantity of each PO/SKU that is shipping.
+
a.k.a. [[Commodity#Gross_Unit]]
-
* ''Default value:'' Blank
+
{{#lst:Commodity|GrossUnit}}
-
* ''Required field?'' Y
+
-
* ''Format/Datatype:'' [[Datatypes#ascii]]
+
===== Haz/Non-Haz =====
===== Haz/Non-Haz =====
-
a.k.a. [[CT#Hazardous Yes No]]
+
a.k.a. [[Commodity#Hazardous Yes No]]
-
{{#lst:CT_bo|HazardousYesNo}}
+
{{#lst:Commodity|HazardousYesNo}}
==== Stackable ====  
==== Stackable ====  
-
* ''Meaning:'' This is to advise if the pallets for the product shipping are stackable or not. This is a new CT2 field.
+
<font color="red">'''NEW FIELD!'''</font>
-
* ''Default value:'' Yes 
+
a.k.a. [[Commodity#Stackable]]
-
* ''Required field?'' Y
+
{{#lst:Commodity|Stackable}}
-
* ''Format/Datatype:'' [[Listbox]] option [Yes][No]
+
==== Piece price ====
==== Piece price ====
-
* ''Meaning:'' This is the unit price of each piece piece shipping for a PO/SKU.  This is a new CT2 field.
+
<font color="red">'''NEW FIELD!'''</font>
-
* ''Default value:'' Blank 
+
a.k.a. [[Commodity#Piece_price]]
-
* ''Required field?'' Y
+
{{#lst:Commodity|PiecePrice}}
-
* ''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
+
-
 
+
 +
==== 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