Commodity

From UG

Revision as of 10:53, 24 June 2010 (edit) Andrei (Talk | contribs) m (→Total Value) ← Older edit		Revision as of 00:28, 28 June 2010 (edit) (undo) Andrei (Talk | contribs) m (→Table A) Newer edit →
Line 40:		Line 40:
	* ''Default value:'' blank		* ''Default value:'' blank
	* ''Required field?'' N		* ''Required field?'' N
-	* ''User Read Access:'' internal, client, planner	+	* ''User Read Access:'' client, planner
-	* ''User Write Access:'' shipper	+	* ''User Write Access:'' internal, shipper
	* ''Mode Of Transport:'' All		* ''Mode Of Transport:'' All
	<section end=PO/>		<section end=PO/>
Line 57:		Line 57:
	* ''Default value:'' blank		* ''Default value:'' blank
	* ''Required field?'' Y		* ''Required field?'' Y
-	* ''User Read Access:'' internal, client, planner	+	* ''User Read Access:'' client, planner
-	* ''User Write Access:'' shipper	+	* ''User Write Access:'' internal, shipper
	* ''Mode Of Transport:'' All		* ''Mode Of Transport:'' All
	<section end=SKU/>		<section end=SKU/>
Line 74:		Line 74:
	* ''Default value:'' blank		* ''Default value:'' blank
	* ''Required field?'' Y		* ''Required field?'' Y
-	* ''User Read Access:'' internal, client, planner	+	* ''User Read Access:'' client, planner
-	* ''User Write Access:'' shipper	+	* ''User Write Access:'' internal, shipper
	* ''Mode Of Transport:'' All		* ''Mode Of Transport:'' All
	<section end=Qty/>		<section end=Qty/>
Line 92:		Line 92:
	* ''Default value:'' blank		* ''Default value:'' blank
	* ''Required field?'' Y		* ''Required field?'' Y
-	* ''User Read Access:'' internal, client, planner	+	* ''User Read Access:'' client, planner
-	* ''User Write Access:'' shipper	+	* ''User Write Access:'' internal, shipper
	* ''Mode Of Transport:'' All		* ''Mode Of Transport:'' All
	<section end=Description/>		<section end=Description/>
Line 110:		Line 110:
	* ''Default value:'' blank		* ''Default value:'' blank
	* ''Required field?'' Y		* ''Required field?'' Y
-	* ''User Read Access:'' internal, client, planner	+	* ''User Read Access:'' client, planner
-	* ''User Write Access:'' shipper	+	* ''User Write Access:'' internal, shipper
	* ''Mode Of Transport:'' All		* ''Mode Of Transport:'' All
	<section end=Plts/>		<section end=Plts/>
Line 128:		Line 128:
	* ''Default value:'' blank		* ''Default value:'' blank
	* ''Required field?'' Y		* ''Required field?'' Y
-	* ''User Read Access:'' internal, client, planner	+	* ''User Read Access:'' client, planner
-	* ''User Write Access:'' shipper	+	* ''User Write Access:'' internal, shipper
	* ''Mode Of Transport:'' All		* ''Mode Of Transport:'' All
	<section end=PkgsOnPlts/>		<section end=PkgsOnPlts/>
Line 146:		Line 146:
	* ''Default value:'' blank		* ''Default value:'' blank
	* ''Required field?'' Y		* ''Required field?'' Y
-	* ''User Read Access:'' internal, client, planner	+	* ''User Read Access:'' client, planner
-	* ''User Write Access:'' shipper	+	* ''User Write Access:'' internal, shipper
	* ''Mode Of Transport:'' All		* ''Mode Of Transport:'' All
	<section end=LoosePkgs/>		<section end=LoosePkgs/>
Line 164:		Line 164:
	* ''Default value:'' blank		* ''Default value:'' blank
	* ''Required field?'' Y		* ''Required field?'' Y
-	* ''User Read Access:'' internal, client, planner	+	* ''User Read Access:'' client, planner
-	* ''User Write Access:'' shipper	+	* ''User Write Access:'' internal, shipper
	* ''Mode Of Transport:'' All		* ''Mode Of Transport:'' All
	<section end=GrossKg/>		<section end=GrossKg/>
Line 182:		Line 182:
	* ''Default value:'' blank		* ''Default value:'' blank
	* ''Required field?'' Y		* ''Required field?'' Y
-	* ''User Read Access:'' internal, client, planner	+	* ''User Read Access:'' client, planner
-	* ''User Write Access:'' shipper	+	* ''User Write Access:'' internal, shipper
	* ''Mode Of Transport:'' All		* ''Mode Of Transport:'' All
	<section end=GrossLb/>		<section end=GrossLb/>
Line 200:		Line 200:
	* ''Default value:'' Blank		* ''Default value:'' Blank
	* ''Required field?'' Y		* ''Required field?'' Y
-	* ''User Read Access:'' [[TBD]]	+	* ''User Read Access:'' client, planner
-	* ''User Write Access:'' [[TBD]]	+	* ''User Write Access:'' internal, shipper
	* ''Mode Of Transport:'' All		* ''Mode Of Transport:'' All
	<section end=HandlingUnits/>		<section end=HandlingUnits/>
Line 235:		Line 235:
	* ''Default value:'' Yes		* ''Default value:'' Yes
	* ''Required field?'' Y		* ''Required field?'' Y
-	* ''User Read Access:'' internal, client, planner	+	* ''User Read Access:'' client, planner
-	* ''User Write Access:'' shipper	+	* ''User Write Access:'' internal, shipper
	* ''Mode Of Transport:'' All		* ''Mode Of Transport:'' All
	<section end=Stackable/>		<section end=Stackable/>
Line 269:		Line 269:
	* ''Default value:'' Blank		* ''Default value:'' Blank
	* ''Required field?'' Y		* ''Required field?'' Y
-	* ''User Read Access:'' internal, client, planner	+	* ''User Read Access:'' internal, client, shipper, planner
-	* ''User Write Access:'' shipper	+	* ''User Write Access:'' no access, because this field is calculated.
	* ''Mode Of Transport:'' All		* ''Mode Of Transport:'' All
	<section end=TotalValue/>		<section end=TotalValue/>

---

Revision as of 00:28, 28 June 2010

Contents 1 General Info 2 Kg Lb Units Feature 3 Table A 3.1 PO 3.2 SKU 3.3 Qty 3.4 Description 3.5 Plts 3.6 Pkgs On Plts 3.7 Loose Pkgs 3.8 Gross Kg 3.9 Gross Lb 3.10 HU 3.11 Container Num 3.12 Stackable 3.13 Piece price 3.14 Total Value 3.15 Grand Total: Plts 3.16 Grand Total: Pkgs On Plts 3.17 Grand Total: Loose Pkgs 3.18 Grand Total: Gross Kg 3.19 Grand Total: Gross Lb 3.20 Grand Total: HU 3.21 Grand Total: cbm 4 Table B 5 Figures 5.1 Figure 1 6 History 6.1 m2042 6.1.1 BA 6.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)

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

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: All

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: 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.
• 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: All

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