Commodity

From UG

(Difference between revisions)
Jump to: navigation, search
m (Total Value)
m (Table A)
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

General Info

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


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:

Grand Total: Pkgs On Plts

Ttl pkgs on plts

Labels:

Grand Total: Loose Pkgs

Loose pkgs

Labels:

Grand Total: Gross Kg

Ttl G kg

Labels:

Grand Total: Gross Lb

Ttl G lb

Labels:

Grand Total: HU

Ttl HU

Labels:

Grand Total: cbm

Table B. Total (in cbm)

Labels:

Table B

Figures

Figure 1

File:Commodity Table.JPG

History

m2042

BA

  • Need ability to enter Weight in LB

SA

Solution: see #Kg Lb Units Feature

Personal tools