Cybertrax 2.1 Client (data dictionary)

From UG

(Difference between revisions)
Jump to: navigation, search
(Fields that Shipper can not edit)
(PO Issued by)
Line 6: Line 6:
==== 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}}

Revision as of 23:20, 27 June 2010


Contents

CT fields

PO Issued by

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


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


Commodity Description

a.k.a. CT#Commodity Description


Cargo Available

a.k.a. CT#Cargo Available


Fields that Shipper can not edit

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

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

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


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

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

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

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

Last Update

aka Ct#Operator_Of_Last_Change

Last Update date time

??? Do we have this field already ??? NEW FIELD???

Field related to Planners

CT Authorization status

NEW FIELD!

  • 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!

"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

aka CT#Authorized By

Approved On

aka CT#Authorized 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

Authorization Comment

NEW FIELD!

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.


Authorization History

NEW FIELD/OBJECT

  • 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

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


Pkgs on Plts

a.k.a. Commodity#Pkgs On Plts


Loose Pkgs

a.k.a. Commodity#Loose Pkgs


GW

a.k.a. Commodity#Gross Lb


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

NEW FIELD!


Piece price

NEW FIELD!

  • 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


Total Value

NEW FIELD!

  • 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
Personal tools