Commodity

From UG

Contents 1 General Info 2 Kg Lb Units Feature 3 Loose and Plts can not be zero at the same time RULE 4 Table A 4.1 PO 4.2 SKU 4.3 Qty 4.4 Description 4.5 Plts 4.6 Pkgs On Plts 4.7 Loose Pkgs 4.8 Gross Kg 4.9 Gross Lb 4.10 Gross Unit 4.11 HU 4.12 Container Num 4.13 Stackable 4.13.1 Hazardous Yes No 4.14 Piece price 4.15 Total Value 4.16 Grand Total: Plts 4.17 Grand Total: Pkgs On Plts 4.18 Grand Total: Loose Pkgs 4.19 Grand Total: Gross Kg 4.20 Grand Total: Gross Lb 4.21 Grand Total: HU 4.22 Grand Total: cbm 5 Table B 6 Figures 6.1 Figure 1 7 History 7.1 m2042 7.1.1 BA 7.1.2 SA

General Info

• parent http://mantis.jaguarfreight.com/mantis/view.php?id=966

This wiki describes Commodity Table Business Object. Each field made a section so that other wikis (example pdfs wikis) can use this doc for mapping.

For example they can refer to Commodity#Pkgs On Plts

Kg Lb Units Feature

• Add drop down {Kg, Lb}
• For New CTs show:
  • if MOT=Truck-Domestic then "Lb"
  • else "Kg"
• For Existing CTs:
  • System will remember to what value this was set and next time CT is opened it will preserve the same setting

• Rename "Ttl G kg" into "Ttl GW" (there are 2 places: table header and TOTAL section)
• Put dropdown into Table header next to "Ttl GW"
• On dropdown change from Kg to Lb (or Lb to Kg) system will re-calculate values

• On save system would look up what unit is used and:
  • if Kg is selected - save as usual
  • if Lb selected - recalc from pounds to Kg before save (because we store in DB in Kg)

Loose and Plts can not be zero at the same time RULE

Both #Loose Pkgs and #Plts cant be zero in one CT at the same time.

Table A

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

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

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 10 digits
• Possible Values: TBD
• Widget: Textbox
• Default value: blank
• Required field? Y
• User Read Access: client, planner
• User Write Access: internal, shipper
• Mode Of Transport: All

Description

Item 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? Y
• User Read Access: client, planner
• User Write Access: internal, shipper
• Mode Of Transport: All

Plts

Ttl # of 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? Y
• User Read Access: client, planner
• User Write Access: internal, shipper
• Mode Of Transport: All

Pkgs On Plts

Ttl pkgs on plts

• Meaning: This is the number of packages that are packed on the pallets shipping.
• 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
• Default value: blank
• Required field? Y
• User Read Access: client, planner
• User Write Access: internal, shipper
• Mode Of Transport: All

Loose Pkgs

Loose pkgs

• Meaning: This is the number of loose packages that are shipping.
• 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
• Default value: blank
• Required field? Y
• User Read Access: client, planner
• User Write Access: internal, shipper
• Mode Of Transport: All

Gross Kg

Ttl G kg

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

Gross Lb

Ttl G 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? Y
• User Read Access: client, planner
• User Write Access: internal, shipper
• Mode Of Transport: All

Gross Unit

Ttl G lb

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

HU

Ttl HU

• Meaning: TBD.
• Standard Long Label: Handling Units
• Standard Short Label: Ttl HU
• Other Labels in use:
• Format/type: Positive Integer
• Min/max: TBD
• Possible Values: TBD
• Widget: Textbox
• Default value: Blank
• Required field? Y
• User Read Access: client, planner
• User Write Access: internal, shipper
• Mode Of Transport: All

Container Num

Container

• Meaning: TBD.
• Standard Long Label: Container Number
• Standard Short Label: Cont #
• Other Labels in use:
• Format/type: TBD
• Min/max: n/a
• Possible Values: TBD
• Widget: TBD
• Default value: Blank
• Required field? N
• User Read Access: TBD
• User Write Access: TBD
• Mode Of Transport: Ocean FCL/LCL, Trucking-Ocean

Stackable

• Meaning: This is to advise if the pallets for the product shipping are stackable or not.
• Standard Long Label: Stackable
• Standard Short Label: Stack
• Other Labels in use:
• Format/type: Listbox option [Yes][No]
• Min/max: n/a
• Possible Values: Yes, No
• Widget: Listbox
• Default value: Yes
• Required field? Y
• User Read Access: client, planner
• User Write Access: internal, shipper
• Mode Of Transport: Truck Dom for Client 2.1 phase 1. Later we might add for other MOTs

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? Y
• User Read Access: client, planner
• User Write Access: internal, shipper
• Mode Of Transport: Truck Dom for Client 2.1 phase 1. Later we might add for other MOTs

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: Decimal, Currency - USD
• Min/max: TBD
• Possible Values: TBD
• Widget: Textbox
• Default value: Blank
• Required field? Y
• User Read Access: internal, client, planner
• User Write Access: shipper
• Mode Of Transport: Truck Domestic

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: Decimal, Currency - USD
• Min/max: TBD
• Possible Values: TBD
• Widget: Textbox
• Default value: Blank
• Required field? Y
• User Read Access: internal, client, shipper, planner
• User Write Access: no access, because this field is calculated.
• Mode Of Transport: Truck Domestic

Grand Total: Plts

Ttl # of plts

Labels:

• Field's Standard Long Label: Grand Total Plts
• Field's Standard Short Label: Ttl Plts

Grand Total: Pkgs On Plts

Ttl pkgs on plts

Labels:

• Field's Standard Long Label: Grand Ttl Pkgs On Plts
• Field's Standard Short Label: Ttl Pkgs On Plts

Grand Total: Loose Pkgs

Loose pkgs

Labels:

• Field's Standard Long Label: Grand Ttl Loose Pkgs
• Field's Standard Short Label: Ttl Loose Pkgs

Grand Total: Gross Kg

Ttl G kg

Labels:

• Field's Standard Long Label: Grand Ttl Gross Kg
• Field's Standard Short Label: Ttl Gross KG

Grand Total: Gross Lb

Ttl G lb

Labels:

• Field's Standard Long Label: Grand Ttl Gross Lb
• Field's Standard Short Label: Ttl Gross Lb

Grand Total: HU

Ttl HU

Labels:

• Field's Standard Long Label: Grand Ttl HU
• Field's Standard Short Label: Ttl HU

Grand Total: cbm

Table B. Total (in cbm)

Labels:

• Field's Standard Long Label: Grand Ttl CBM
• Field's Standard Short Label: Ttl CBM

Table B

Figures

Figure 1

History

m2042

• http://mantis.jaguarfreight.com/mantis/view.php?id=2042

BA

• Need ability to enter Weight in LB

SA

Solution: see #Kg Lb Units Feature