Commodity
From UG
(Difference between revisions)
(→Table A: Stackable) |
(→Upload content section from XLS) |
||
(72 intermediate revisions not shown) | |||
Line 25: | Line 25: | ||
** if Kg is selected - save as usual | ** if Kg is selected - save as usual | ||
** if Lb selected - recalc from pounds to Kg before save (because we store in DB in Kg) | ** 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 on one line in one CT at the same time. | ||
+ | |||
+ | == Upload content section from XLS == | ||
+ | |||
+ | * Basically an "upload" functionality, that allows users to fill/complete the "contents" section of an ASN or CT2 record using a spreadsheet, rather than typing the data manually. | ||
+ | * We need to clearly spell out the requirements: | ||
+ | :* Excel 2003 or Excell 2007 | ||
+ | :* No Headings | ||
+ | :* Columns: | ||
+ | ::* Column A - PO - Alphanumeric (max XX characters) | ||
+ | ::* Column B - SKU - Alphanumeric (max XX characters) | ||
+ | ::* Column C - SKU Qty - Numeric, no decimal point (max XX characters) | ||
+ | ::* ... | ||
+ | ::* etc... | ||
+ | * Currently used list of commodity fields: | ||
+ | :* P.O. | ||
+ | :* SKU | ||
+ | :* Qty | ||
+ | :* Item Description | ||
+ | :* Ttl # of plts | ||
+ | :* Ttl pkgs on plts | ||
+ | :* Ttl pkgs on plts Unit | ||
+ | :* Loose pkgs | ||
+ | :* Loose pkgs Unit | ||
+ | :* Ttl GW | ||
+ | :* Ttl GW Unit | ||
+ | :* Hazardous | ||
+ | :* Stackable | ||
+ | :* Cubic | ||
+ | :* Cubic Unit | ||
+ | :* HTS (AIR only) | ||
+ | :* Container (OCEAN only) | ||
== Table A == | == Table A == | ||
+ | |||
+ | === Ext1 === | ||
+ | <section begin=Ext1/> | ||
+ | * ''Meaning:'' This is 1st additional field of Commodity Line. | ||
+ | * ''[[Standard Long Label]]:'' Ext1 | ||
+ | * ''[[Standard Short Label]]:'' Extra Field 1 | ||
+ | * ''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 | ||
+ | <section end=Ext1/> | ||
+ | |||
+ | === Ext2 === | ||
+ | <section begin=Ext2/> | ||
+ | * ''Meaning:'' This is 2nd additional field of Commodity Line. | ||
+ | * ''[[Standard Long Label]]:'' Ext2 | ||
+ | * ''[[Standard Short Label]]:'' Extra Field 2 | ||
+ | * ''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 | ||
+ | <section end=Ext2/> | ||
+ | |||
+ | === Ext3 === | ||
+ | <section begin=Ext3/> | ||
+ | * ''Meaning:'' This is 3rd additional field of Commodity Line. | ||
+ | * ''[[Standard Long Label]]:'' Ext3 | ||
+ | * ''[[Standard Short Label]]:'' Extra Field 3 | ||
+ | * ''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 | ||
+ | <section end=Ext3/> | ||
=== PO === | === PO === | ||
Line 39: | Line 131: | ||
* ''Widget:'' [[Textbox]] | * ''Widget:'' [[Textbox]] | ||
* ''Default value:'' blank | * ''Default value:'' blank | ||
- | * ''Required field?'' N | + | * ''Required field?'' |
- | * ''User Read Access:'' | + | ** Internal: N |
- | * ''User Write Access:'' shipper | + | ** Shipper: Y |
+ | * ''User Read Access:'' client, shipper, planner, internal | ||
+ | * ''User Write Access:'' internal, shipper | ||
* ''Mode Of Transport:'' All | * ''Mode Of Transport:'' All | ||
<section end=PO/> | <section end=PO/> | ||
Line 56: | Line 150: | ||
* ''Widget:'' [[Textbox]] | * ''Widget:'' [[Textbox]] | ||
* ''Default value:'' blank | * ''Default value:'' blank | ||
- | * ''Required field?'' Y | + | * ''Required field?'' |
- | * ''User Read Access:'' | + | ** Internal: N |
- | * ''User Write Access:'' shipper | + | ** Shipper: Y |
+ | * ''User Read Access:'' client, planner, shipper, internal | ||
+ | * ''User Write Access:'' internal, shipper | ||
* ''Mode Of Transport:'' All | * ''Mode Of Transport:'' All | ||
<section end=SKU/> | <section end=SKU/> | ||
Line 69: | Line 165: | ||
* ''Other Labels in use:'' | * ''Other Labels in use:'' | ||
* ''Format/type:'' [[Alphanumeric#positive_integer | Positive Integer]] | * ''Format/type:'' [[Alphanumeric#positive_integer | Positive Integer]] | ||
- | * ''Min/max:'' from 0 to | + | * ''Min/max:'' from 0 to 9999999999 digits |
* ''Possible Values:'' [[TBD]] | * ''Possible Values:'' [[TBD]] | ||
* ''Widget:'' [[Textbox]] | * ''Widget:'' [[Textbox]] | ||
- | * ''Default value:'' | + | * ''Default value:'' 0 |
- | * ''Required field?'' | + | * ''Required field?'' |
- | * ''User Read Access:'' | + | ** Internal: N |
- | * ''User Write Access:'' shipper | + | ** Shipper: value must be > 0 |
+ | * ''User Read Access:'' client, planner, shipper, internal | ||
+ | * ''User Write Access:'' internal, shipper | ||
* ''Mode Of Transport:'' All | * ''Mode Of Transport:'' All | ||
<section end=Qty/> | <section end=Qty/> | ||
Line 91: | Line 189: | ||
* ''Widget:'' [[Textbox]] | * ''Widget:'' [[Textbox]] | ||
* ''Default value:'' blank | * ''Default value:'' blank | ||
- | * ''Required field?'' Y | + | * ''Required field?'' |
- | * ''User Read Access:'' | + | ** internal: N |
- | * ''User Write Access:'' shipper | + | ** shipper: Y |
+ | * ''User Read Access:'' client, planner, shipper, internal | ||
+ | * ''User Write Access:'' internal, shipper | ||
* ''Mode Of Transport:'' All | * ''Mode Of Transport:'' All | ||
<section end=Description/> | <section end=Description/> | ||
Line 109: | Line 209: | ||
* ''Widget:'' [[Textbox]] | * ''Widget:'' [[Textbox]] | ||
* ''Default value:'' blank | * ''Default value:'' blank | ||
- | * ''Required field?'' | + | * ''Required field?'' |
- | * ''User Read Access:'' | + | ** internal: N |
- | * ''User Write Access:'' shipper | + | ** shipper: see [[#Commodity#Loose_and_Plts_can_not_be_zero_at_the_same_time_RULE]] and [[Commodity#Weight_and_Number_of_Plts_validations_to_web_portal_on_commodity_line_item]] |
+ | * ''User Read Access:'' client, planner, shipper, internal | ||
+ | * ''User Write Access:'' internal, shipper | ||
* ''Mode Of Transport:'' All | * ''Mode Of Transport:'' All | ||
<section end=Plts/> | <section end=Plts/> | ||
Line 118: | Line 220: | ||
Ttl pkgs on plts | Ttl pkgs on plts | ||
<section begin=PkgsOnPlts/> | <section begin=PkgsOnPlts/> | ||
- | * ''Meaning:'' This is the number of packages that are packed on the pallets shipping. | + | * ''Meaning:'' This is the number of packages that are packed on the pallets shipping with a package type. |
* ''[[Standard Long Label]]:'' Pkgs On Plts | * ''[[Standard Long Label]]:'' Pkgs On Plts | ||
* ''[[Standard Short Label]]:'' Pkgs On Plts | * ''[[Standard Short Label]]:'' Pkgs On Plts | ||
Line 125: | Line 227: | ||
* ''Min/max:'' from 0 to 10 digits | * ''Min/max:'' from 0 to 10 digits | ||
* ''Possible Values:'' [[TBD]] | * ''Possible Values:'' [[TBD]] | ||
- | * ''Widget:'' [[Textbox]] | + | * ''Widget:'' [[Textbox]] and [[listbox]] |
- | * ''Default value:'' blank | + | * ''Default value:'' blank for # and cartons for package type. See [[#Pkgs On Plts Type]] |
- | * ''Required field?'' | + | * ''Required field?'' |
- | * ''User Read Access:'' | + | * Internal: N |
- | * ''User Write Access:'' shipper | + | * Shipper: see [[#Pkgs_On_Plts_can_not_be_zero_if_Plts_is_not_zero]] |
+ | * ''User Read Access:'' client, planner, shipper, internal | ||
+ | * ''User Write Access:'' internal, shipper | ||
* ''Mode Of Transport:'' All | * ''Mode Of Transport:'' All | ||
<section end=PkgsOnPlts/> | <section end=PkgsOnPlts/> | ||
+ | |||
+ | === Pkgs On Plts Type === | ||
+ | * ''Meaning'': This is the type of packages. | ||
+ | * ''[[Standard Long Label]]'': Pkgs On Plts | ||
+ | * ''[[Standard Short Label]]'': Pkgs On Plts | ||
+ | * ''Other Labels in use:'' | ||
+ | * ''Format/type'': TBD | ||
+ | * ''Possible Values'': Bags, Cartons, Bundles, Drums, Pails, Totes | ||
+ | * ''Widget'': listbox | ||
+ | * ''Default value'': Cartons for package type. | ||
+ | * ''Required field?'' | ||
+ | :* internal: N | ||
+ | :* shipper: Y | ||
+ | * ''User Read Access'': client, planner, shipper, internal | ||
+ | * ''User Write Access'': internal, shipper | ||
+ | * ''Mode Of Transport'': All | ||
=== Loose Pkgs === | === Loose Pkgs === | ||
Loose pkgs | Loose pkgs | ||
<section begin=LoosePkgs/> | <section begin=LoosePkgs/> | ||
- | * ''Meaning:'' This is the number of loose packages that are shipping. | + | * ''Meaning:'' This is the number of loose packages that are shipping with a package type. |
* ''[[Standard Long Label]]:'' Pkgs On Plts | * ''[[Standard Long Label]]:'' Pkgs On Plts | ||
* ''[[Standard Short Label]]:'' Pkgs On Plts | * ''[[Standard Short Label]]:'' Pkgs On Plts | ||
Line 143: | Line 263: | ||
* ''Min/max:'' from 0 to 10 digits | * ''Min/max:'' from 0 to 10 digits | ||
* ''Possible Values:'' [[TBD]] | * ''Possible Values:'' [[TBD]] | ||
- | * ''Widget:'' [[Textbox]] | + | * ''Widget:'' [[Textbox]] and [[listbox]] |
- | * ''Default value:'' blank | + | * ''Default value:'' blank for # and bags for package type. See [[#Loose Pkgs Type ]] |
- | * ''Required field?'' | + | * ''Required field?'' |
- | * ''User Read Access:'' | + | ** internal: N |
- | * ''User Write Access:'' shipper | + | ** shipper: see [[#Loose and Plts can not be zero at the same time RULE]] |
+ | * ''User Read Access:'' client, planner, shipper, internal | ||
+ | * ''User Write Access:'' internal, shipper | ||
* ''Mode Of Transport:'' All | * ''Mode Of Transport:'' All | ||
<section end=LoosePkgs/> | <section end=LoosePkgs/> | ||
+ | |||
+ | === Loose Pkgs Type === | ||
+ | * ''Meaning'': This is the type of packages. | ||
+ | * ''[[Standard Long Label]]'': Loose Pkgs | ||
+ | * ''[[Standard Short Label]]'': Loose Pkgs | ||
+ | * ''Other Labels in use:'' | ||
+ | * ''Format/type'': TBD | ||
+ | * ''Possible Values'': Bags, Cartons, Bundles, Drums, Pails, Totes | ||
+ | * ''Widget'': listbox | ||
+ | * ''Default value'': Cartons for package type. | ||
+ | * ''Required field?'' | ||
+ | :* internal: N | ||
+ | :* shipper: Y | ||
+ | * ''User Read Access'': client, planner, shipper, internal | ||
+ | * ''User Write Access'': internal, shipper | ||
+ | * ''Mode Of Transport'': All | ||
=== Gross Kg === | === Gross Kg === | ||
Line 164: | Line 302: | ||
* ''Default value:'' blank | * ''Default value:'' blank | ||
* ''Required field?'' Y | * ''Required field?'' Y | ||
- | * ''User Read Access:'' | + | * ''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 181: | Line 319: | ||
* ''Widget:'' [[Textbox]] | * ''Widget:'' [[Textbox]] | ||
* ''Default value:'' blank | * ''Default value:'' blank | ||
- | * ''Required field?'' Y | + | * ''Required field?'' |
- | * ''User Read Access:'' | + | ** Internal: N |
- | * ''User Write Access:'' shipper | + | ** Shipper: Y (See validation here: [[Commodity#Weight_and_Number_of_Plts_validations_to_web_portal_on_commodity_line_item]]) |
+ | * ''User Read Access:'' client, planner, shipper, internal | ||
+ | * ''User Write Access:'' internal, shipper | ||
* ''Mode Of Transport:'' All | * ''Mode Of Transport:'' All | ||
<section end=GrossLb/> | <section end=GrossLb/> | ||
+ | |||
+ | === Gross Unit === | ||
+ | Ttl G lb | ||
+ | <section begin=GrossUnit/> | ||
+ | * ''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?'' | ||
+ | ** Internal: N | ||
+ | ** Shipper: Y | ||
+ | * ''User Read Access:'' client, planner, shipper, internal | ||
+ | * ''User Write Access:'' internal, shipper | ||
+ | * ''Mode Of Transport:'' All | ||
+ | <section end=GrossUnit/> | ||
=== HU === | === HU === | ||
Line 200: | Line 360: | ||
* ''Default value:'' Blank | * ''Default value:'' Blank | ||
* ''Required field?'' Y | * ''Required field?'' Y | ||
- | * ''User Read Access:'' | + | * ''User Read Access:'' client, planner |
- | * ''User Write Access:'' | + | * ''User Write Access:'' internal, shipper |
* ''Mode Of Transport:'' All | * ''Mode Of Transport:'' All | ||
<section end=HandlingUnits/> | <section end=HandlingUnits/> | ||
Line 227: | Line 387: | ||
* ''Meaning:'' This is to advise if the pallets for the product shipping are stackable or not. | * ''Meaning:'' This is to advise if the pallets for the product shipping are stackable or not. | ||
* ''[[Standard Long Label]]:'' Stackable | * ''[[Standard Long Label]]:'' Stackable | ||
- | * ''[[Standard Short Label]]:'' | + | * ''[[Standard Short Label]]:'' Stack |
* ''Other Labels in use:'' | * ''Other Labels in use:'' | ||
* ''Format/type:'' [[Listbox]] option [Yes][No] | * ''Format/type:'' [[Listbox]] option [Yes][No] | ||
Line 234: | Line 394: | ||
* ''Widget:'' [[Listbox]] | * ''Widget:'' [[Listbox]] | ||
* ''Default value:'' Yes | * ''Default value:'' Yes | ||
- | * ''Required field?'' Y | + | * ''Required field?'' |
- | * ''User Read Access:'' | + | ** Internal: N |
- | * ''User Write Access:'' shipper | + | ** Shipper: Y (See validation here: [[Commodity#Weight_and_Number_of_Plts_validations_to_web_portal_on_commodity_line_item]]) |
- | * ''Mode Of Transport:'' | + | * ''User Read Access:'' client, planner, shipper, internal |
+ | * ''User Write Access:'' internal, shipper | ||
+ | * ''Mode Of Transport:'' Truck Dom for Client 2.1 phase 1. Later we might add for other MOTs | ||
<section end=Stackable/> | <section end=Stackable/> | ||
+ | |||
+ | ==== Hazardous Yes No ==== | ||
+ | <section begin=HazardousYesNo/> | ||
+ | * ''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?'' | ||
+ | ** Internal: Y | ||
+ | ** Shipper: Y | ||
+ | * ''User Read Access:'' client, planner, shipper, internal | ||
+ | * ''User Write Access:'' internal, shipper | ||
+ | * ''Mode Of Transport:'' Truck Dom for Client 2.1 phase 1. Later we might add for other MOTs | ||
+ | <section end=HazardousYesNo/> | ||
+ | |||
+ | === Piece price === | ||
+ | <section begin=PiecePrice/> | ||
+ | * ''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 [[Alphanumeric#decimal | 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 | ||
+ | <section end=PiecePrice/> | ||
+ | |||
+ | === Haz === | ||
+ | |||
+ | Hazardous or not. | ||
+ | |||
+ | ASN only | ||
+ | |||
+ | === Total Value === | ||
+ | <section begin=TotalValue/> | ||
+ | * ''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 [[Alphanumeric#decimal | 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 | ||
+ | <section end=TotalValue/> | ||
=== Grand Total: Plts === | === Grand Total: Plts === | ||
Line 295: | Line 520: | ||
* ''Field's [[Standard Long Label]]:'' Grand Ttl CBM | * ''Field's [[Standard Long Label]]:'' Grand Ttl CBM | ||
* ''Field's [[Standard Short Label]]:'' Ttl CBM | * ''Field's [[Standard Short Label]]:'' Ttl CBM | ||
+ | |||
+ | == Misc == | ||
+ | |||
+ | === Pkgs On Plts can not be zero if Plts is not zero === | ||
+ | |||
+ | [[#Pkgs On Plts]] can not be zero if [[#Plts]] is not zero. | ||
+ | |||
+ | |||
+ | === Weight and Number of Plts validations to web portal on commodity line item === | ||
+ | * One commodity line item per line cannot exceed a trailer load. If there is over the limit, user has to create a next line for the remaining | ||
+ | * Validation: | ||
+ | :* Max Gross weight per line = 44000 LB | ||
+ | :* Max Non-stackable number of pallets = 28 | ||
+ | :* Max Stackable number of pallets = 60 | ||
+ | * These number can be managed through Admin > Transportation > Trailer Per Load. See [[Trailer Per Load]] | ||
== Table B == | == Table B == | ||
Line 305: | Line 545: | ||
[[File:Commodity Table.JPG]] | [[File:Commodity Table.JPG]] | ||
- | == | + | == SOWs == |
- | === m2042 === | + | === SOW1 (m2042) === |
* http://mantis.jaguarfreight.com/mantis/view.php?id=2042 | * http://mantis.jaguarfreight.com/mantis/view.php?id=2042 | ||
Line 318: | Line 558: | ||
Solution: see [[#Kg Lb Units Feature]] | Solution: see [[#Kg Lb Units Feature]] | ||
+ | |||
+ | <hr> | ||
+ | === SOW2 (m3109) === | ||
+ | |||
+ | *http://ct.jaguarfreight.com/mantis/view.php?id=3109 | ||
+ | |||
+ | ==== BA ==== | ||
+ | |||
+ | * Option to include group shipments commodity contents onto the download spreadsheet in Cont Tab, Table A | ||
+ | |||
+ | ==== SA ==== | ||
+ | |||
+ | Solution: see [[Commodity_Table_A]] | ||
+ | |||
+ | <hr> | ||
+ | === SOW3 (m4575) === | ||
+ | |||
+ | *http://ct.jaguarfreight.com/mantis/view.php?id=4575 | ||
+ | |||
+ | ==== BA ==== | ||
+ | |||
+ | * ASN/CT content section uploads via .xls document | ||
+ | |||
+ | ==== SA ==== | ||
+ | |||
+ | Solution: see [[#Upload content section from XLS]] |
Current revision as of 17:08, 21 November 2014
[edit] 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
[edit] 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)
[edit] Loose and Plts can not be zero at the same time RULE
Both #Loose Pkgs and #Plts cant be zero on one line in one CT at the same time.
[edit] Upload content section from XLS
- Basically an "upload" functionality, that allows users to fill/complete the "contents" section of an ASN or CT2 record using a spreadsheet, rather than typing the data manually.
- We need to clearly spell out the requirements:
- Excel 2003 or Excell 2007
- No Headings
- Columns:
- Column A - PO - Alphanumeric (max XX characters)
- Column B - SKU - Alphanumeric (max XX characters)
- Column C - SKU Qty - Numeric, no decimal point (max XX characters)
- ...
- etc...
- Currently used list of commodity fields:
- P.O.
- SKU
- Qty
- Item Description
- Ttl # of plts
- Ttl pkgs on plts
- Ttl pkgs on plts Unit
- Loose pkgs
- Loose pkgs Unit
- Ttl GW
- Ttl GW Unit
- Hazardous
- Stackable
- Cubic
- Cubic Unit
- HTS (AIR only)
- Container (OCEAN only)
[edit] Table A
[edit] Ext1
- Meaning: This is 1st additional field of Commodity Line.
- Standard Long Label: Ext1
- Standard Short Label: Extra Field 1
- 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
[edit] Ext2
- Meaning: This is 2nd additional field of Commodity Line.
- Standard Long Label: Ext2
- Standard Short Label: Extra Field 2
- 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
[edit] Ext3
- Meaning: This is 3rd additional field of Commodity Line.
- Standard Long Label: Ext3
- Standard Short Label: Extra Field 3
- 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
[edit] 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
[edit] 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
[edit] 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
[edit] 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?
- internal: N
- shipper: Y
- User Read Access: client, planner, shipper, internal
- User Write Access: internal, shipper
- Mode Of Transport: All
[edit] 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?
- User Read Access: client, planner, shipper, internal
- User Write Access: internal, shipper
- Mode Of Transport: All
[edit] Pkgs On Plts
Ttl pkgs on plts
- Meaning: This is the number of packages that are packed on the pallets shipping with a package type.
- 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 and listbox
- Default value: blank for # and cartons for package type. See #Pkgs On Plts Type
- Required field?
- Internal: N
- Shipper: see #Pkgs_On_Plts_can_not_be_zero_if_Plts_is_not_zero
- User Read Access: client, planner, shipper, internal
- User Write Access: internal, shipper
- Mode Of Transport: All
[edit] Pkgs On Plts Type
- Meaning: This is the type of packages.
- Standard Long Label: Pkgs On Plts
- Standard Short Label: Pkgs On Plts
- Other Labels in use:
- Format/type: TBD
- Possible Values: Bags, Cartons, Bundles, Drums, Pails, Totes
- Widget: listbox
- Default value: Cartons for package type.
- Required field?
- internal: N
- shipper: Y
- User Read Access: client, planner, shipper, internal
- User Write Access: internal, shipper
- Mode Of Transport: All
[edit] Loose Pkgs
Loose pkgs
- Meaning: This is the number of loose packages that are shipping with a package type.
- 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 and listbox
- Default value: blank for # and bags for package type. See #Loose Pkgs Type
- Required field?
- internal: N
- shipper: see #Loose and Plts can not be zero at the same time RULE
- User Read Access: client, planner, shipper, internal
- User Write Access: internal, shipper
- Mode Of Transport: All
[edit] Loose Pkgs Type
- Meaning: This is the type of packages.
- Standard Long Label: Loose Pkgs
- Standard Short Label: Loose Pkgs
- Other Labels in use:
- Format/type: TBD
- Possible Values: Bags, Cartons, Bundles, Drums, Pails, Totes
- Widget: listbox
- Default value: Cartons for package type.
- Required field?
- internal: N
- shipper: Y
- User Read Access: client, planner, shipper, internal
- User Write Access: internal, shipper
- Mode Of Transport: All
[edit] 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
[edit] 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?
- Internal: N
- Shipper: Y (See validation here: Commodity#Weight_and_Number_of_Plts_validations_to_web_portal_on_commodity_line_item)
- User Read Access: client, planner, shipper, internal
- User Write Access: internal, shipper
- Mode Of Transport: All
[edit] 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?
- Internal: N
- Shipper: Y
- User Read Access: client, planner, shipper, internal
- User Write Access: internal, shipper
- Mode Of Transport: All
[edit] 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
[edit] 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
[edit] 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?
- Internal: N
- Shipper: Y (See validation here: Commodity#Weight_and_Number_of_Plts_validations_to_web_portal_on_commodity_line_item)
- User Read Access: client, planner, shipper, internal
- User Write Access: internal, shipper
- Mode Of Transport: Truck Dom for Client 2.1 phase 1. Later we might add for other MOTs
[edit] 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?
- Internal: Y
- Shipper: Y
- User Read Access: client, planner, shipper, internal
- User Write Access: internal, shipper
- Mode Of Transport: Truck Dom for Client 2.1 phase 1. Later we might add for other MOTs
[edit] 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: 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
[edit] Haz
Hazardous or not.
ASN only
[edit] 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: 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
[edit] Grand Total: Plts
Ttl # of plts
Labels:
- Field's Standard Long Label: Grand Total Plts
- Field's Standard Short Label: Ttl Plts
[edit] 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
[edit] Grand Total: Loose Pkgs
Loose pkgs
Labels:
- Field's Standard Long Label: Grand Ttl Loose Pkgs
- Field's Standard Short Label: Ttl Loose Pkgs
[edit] 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
[edit] 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
[edit] Grand Total: HU
Ttl HU
Labels:
- Field's Standard Long Label: Grand Ttl HU
- Field's Standard Short Label: Ttl HU
[edit] Grand Total: cbm
Table B. Total (in cbm)
Labels:
- Field's Standard Long Label: Grand Ttl CBM
- Field's Standard Short Label: Ttl CBM
[edit] Misc
[edit] Pkgs On Plts can not be zero if Plts is not zero
#Pkgs On Plts can not be zero if #Plts is not zero.
[edit] Weight and Number of Plts validations to web portal on commodity line item
- One commodity line item per line cannot exceed a trailer load. If there is over the limit, user has to create a next line for the remaining
- Validation:
- Max Gross weight per line = 44000 LB
- Max Non-stackable number of pallets = 28
- Max Stackable number of pallets = 60
- These number can be managed through Admin > Transportation > Trailer Per Load. See Trailer Per Load
[edit] Table B
[edit] Figures
[edit] Figure 1
[edit] SOWs
[edit] SOW1 (m2042)
[edit] BA
- Need ability to enter Weight in LB
[edit] SA
Solution: see #Kg Lb Units Feature
[edit] SOW2 (m3109)
[edit] BA
- Option to include group shipments commodity contents onto the download spreadsheet in Cont Tab, Table A
[edit] SA
Solution: see Commodity_Table_A
[edit] SOW3 (m4575)
[edit] BA
- ASN/CT content section uploads via .xls document
[edit] SA
Solution: see #Upload content section from XLS