Commodity

From UG

Revision as of 14:48, 22 June 2010 (edit) Andrei (Talk | contribs) (→Table A: Gross Kg, Gross Lb) ← Older edit		Revision as of 10:16, 24 June 2010 (edit) (undo) Andrei (Talk | contribs) (→Table A: Stackable) Newer edit →
Line 37:		Line 37:
	* ''Min/max:'' from 0 to 30 chars		* ''Min/max:'' from 0 to 30 chars
	* ''Possible Values:'' [[TBD]]		* ''Possible Values:'' [[TBD]]
-	* ''Widget:'' textbox	+	* ''Widget:'' [[Textbox]]
	* ''Default value:'' blank		* ''Default value:'' blank
	* ''Required field?'' N		* ''Required field?'' N
Line 54:		Line 54:
	* ''Min/max:'' from 0 to 30 chars		* ''Min/max:'' from 0 to 30 chars
	* ''Possible Values:'' [[TBD]]		* ''Possible Values:'' [[TBD]]
-	* ''Widget:'' textbox	+	* ''Widget:'' [[Textbox]]
	* ''Default value:'' blank		* ''Default value:'' blank
	* ''Required field?'' Y		* ''Required field?'' Y
Line 71:		Line 71:
	* ''Min/max:'' from 0 to 10 digits		* ''Min/max:'' from 0 to 10 digits
	* ''Possible Values:'' [[TBD]]		* ''Possible Values:'' [[TBD]]
-	* ''Widget:'' textbox	+	* ''Widget:'' [[Textbox]]
	* ''Default value:'' blank		* ''Default value:'' blank
	* ''Required field?'' Y		* ''Required field?'' Y
Line 89:		Line 89:
	* ''Min/max:'' from 0 to 60 chars		* ''Min/max:'' from 0 to 60 chars
	* ''Possible Values:'' [[TBD]]		* ''Possible Values:'' [[TBD]]
-	* ''Widget:'' textbox	+	* ''Widget:'' [[Textbox]]
	* ''Default value:'' blank		* ''Default value:'' blank
	* ''Required field?'' Y		* ''Required field?'' Y
Line 107:		Line 107:
	* ''Min/max:'' from 0 to 10 digits		* ''Min/max:'' from 0 to 10 digits
	* ''Possible Values:'' [[TBD]]		* ''Possible Values:'' [[TBD]]
-	* ''Widget:'' textbox	+	* ''Widget:'' [[Textbox]]
	* ''Default value:'' blank		* ''Default value:'' blank
	* ''Required field?'' Y		* ''Required field?'' Y
Line 125:		Line 125:
	* ''Min/max:'' from 0 to 10 digits		* ''Min/max:'' from 0 to 10 digits
	* ''Possible Values:'' [[TBD]]		* ''Possible Values:'' [[TBD]]
-	* ''Widget:'' textbox	+	* ''Widget:'' [[Textbox]]
	* ''Default value:'' blank		* ''Default value:'' blank
	* ''Required field?'' Y		* ''Required field?'' Y
Line 143:		Line 143:
	* ''Min/max:'' from 0 to 10 digits		* ''Min/max:'' from 0 to 10 digits
	* ''Possible Values:'' [[TBD]]		* ''Possible Values:'' [[TBD]]
-	* ''Widget:'' textbox	+	* ''Widget:'' [[Textbox]]
	* ''Default value:'' blank		* ''Default value:'' blank
	* ''Required field?'' Y		* ''Required field?'' Y
Line 161:		Line 161:
	* ''Min/max:'' [[TBD]]		* ''Min/max:'' [[TBD]]
	* ''Possible Values:'' [[TBD]]		* ''Possible Values:'' [[TBD]]
-	* ''Widget:'' textbox	+	* ''Widget:'' [[Textbox]]
	* ''Default value:'' blank		* ''Default value:'' blank
	* ''Required field?'' Y		* ''Required field?'' Y
Line 179:		Line 179:
	* ''Min/max:'' [[TBD]]		* ''Min/max:'' [[TBD]]
	* ''Possible Values:'' [[TBD]]		* ''Possible Values:'' [[TBD]]
-	* ''Widget:'' textbox	+	* ''Widget:'' [[Textbox]]
	* ''Default value:'' blank		* ''Default value:'' blank
	* ''Required field?'' Y		* ''Required field?'' Y
Line 188:		Line 188:
	=== HU ===		=== HU ===
-
	Ttl HU		Ttl HU
-		+	<section begin=HandlingUnits/>
-	'''Labels:'''	+	* ''Meaning:'' [[TBD]].
-	* ''Field's [[Standard Long Label]]:'' Handling Units	+	* ''[[Standard Long Label]]:'' Handling Units
-	* ''Field's [[Standard Short Label]]:'' Ttl HU	+	* ''[[Standard Short Label]]:'' Ttl HU
		+	* ''Other Labels in use:''
		+	* ''Format/type:'' [[Alphanumeric#positive_integer | Positive Integer]]
		+	* ''Min/max:'' [[TBD]]
		+	* ''Possible Values:'' [[TBD]]
		+	* ''Widget:'' [[Textbox]]
		+	* ''Default value:'' Blank
		+	* ''Required field?'' Y
		+	* ''User Read Access:'' [[TBD]]
		+	* ''User Write Access:'' [[TBD]]
		+	* ''Mode Of Transport:'' All
		+	<section end=HandlingUnits/>
	=== Container Num ===		=== Container Num ===
-
	Container		Container
		+	<section begin=ContainerNum/>
		+	* ''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
		+	<section end=ContainerNum/>
-	'''Labels:'''	+	=== Stackable ===
-	* ''Field's [[Standard Long Label]]:'' Container Number	+	<section begin=Stackable/>
-	* ''Field's [[Standard Short Label]]:'' Cont #	+	* ''Meaning:'' This is to advise if the pallets for the product shipping are stackable or not.
		+	* ''[[Standard Long Label]]:'' Stackable
		+	* ''[[Standard Short Label]]:'' Stackable
		+	* ''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:'' internal, client, planner
		+	* ''User Write Access:'' shipper
		+	* ''Mode Of Transport:'' All
		+	<section end=Stackable/>
	=== Grand Total: Plts ===		=== Grand Total: Plts ===

---

Revision as of 10:16, 24 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 Grand Total: Plts 3.14 Grand Total: Pkgs On Plts 3.15 Grand Total: Loose Pkgs 3.16 Grand Total: Gross Kg 3.17 Grand Total: Gross Lb 3.18 Grand Total: HU 3.19 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: internal, client, planner
• User Write Access: 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: internal, client, planner
• User Write Access: 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: internal, client, planner
• User Write Access: 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: internal, client, planner
• User Write Access: 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: internal, client, planner
• User Write Access: 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: internal, client, planner
• User Write Access: 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: internal, client, planner
• User Write Access: 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: internal, client, planner
• User Write Access: 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: internal, client, planner
• User Write Access: 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: TBD
• User Write Access: TBD
• 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: Stackable
• 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: internal, client, planner
• User Write Access: shipper
• 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