Difference between revisions of "GX:Studio:Catchweight"
| Line 13: | Line 13: | ||
==Columns== | ==Columns== | ||
| + | There are certain rules associated with entries made in some columns. This will provide an overview of what is required to be in the various columns of this table. | ||
| + | |||
===in_item_key=== | ===in_item_key=== | ||
| Line 18: | Line 20: | ||
===im_pack_key=== | ===im_pack_key=== | ||
| − | + | This is the pack entry of item to be catchweighted. Catchweighted items must have an entry in this column. Items without pack entries are, generally, considered to be bulk inventory. | |
===ucc128_item=== | ===ucc128_item=== | ||
| − | + | This is a unique item number, used to map the item from the vendor to the item in the ERP system. | |
===wms_ctwght_minwgt=== | ===wms_ctwght_minwgt=== | ||
| − | Minimum allowable weight of the item. | + | Minimum allowable weight of the item. This entry must be less than or equal to the maximum weight of the field. When there is a value in this field, the netweight field must be 0 or empty, and the maximum weight field must be filled out. |
===wms_ctwght_maxwgt=== | ===wms_ctwght_maxwgt=== | ||
| − | Maximum allowable weight of the item. | + | Maximum allowable weight of the item. This entry must be greater than or equal to the minimum weight of the field. When there is a value in this field, the netweight field must be 0 or empty, and the minimum weight field must be filled out. |
===wms_ctwght_netwt=== | ===wms_ctwght_netwt=== | ||
| − | Net weight of the item. | + | Net weight of the item. When there is an entry in this field, the minimum and maximum weight fields must be 0 or empty. |
===wms_ctwght_tare=== | ===wms_ctwght_tare=== | ||
| − | Weight of packaging to be | + | Weight of the packaging material used for packaging this item/pack. This is the amount to be removed from the total weight of the packages item in order to find the actual weight of just the inventory. |
===upc_key=== | ===upc_key=== | ||
Revision as of 12:15, 12 February 2013
Contents
- 1 Security
- 2 Intended Use
- 3 Example Usage
- 4 Columns
- 4.1 in_item_key
- 4.2 im_pack_key
- 4.3 ucc128_item
- 4.4 wms_ctwght_minwgt
- 4.5 wms_ctwght_maxwgt
- 4.6 wms_ctwght_netwt
- 4.7 wms_ctwght_tare
- 4.8 upc_key
- 4.9 wms_ctwght_scc
- 4.10 wms_ctwght_freeze
- 4.11 wms_ctwght_peel
- 4.12 wms_ctwght_backdt
- 4.13 wms_ctwght_sell
- 4.14 defaultitem
- 4.15 boxcode
- 4.16 minPieces
- 4.17 maxPieces
- 4.18 minPieceWeight
- 4.19 maxPieceWeight
- 4.20 target_pieces
- 4.21 ECOLotsOnly
Security
In order to use this screen, the user must have been assigned the screen privilege "SD CATCHWEIGHT SETUP".
Intended Use
This screen is used to set up catchweighted items in Whistle. A catchweighted (also known as random weight) item is inventory where each piece can have a different weight, and the product is priced by the actual weight of the individual piece. In contrast, a standard weight (also known as net weight) item is one that uses the same (standardized) weight for each piece.
Example Usage
New Item #23 is catchweighted, and Whistle needs to know the various weights associated with the item.
Columns
There are certain rules associated with entries made in some columns. This will provide an overview of what is required to be in the various columns of this table.
in_item_key
The item to be catchweighted.
im_pack_key
This is the pack entry of item to be catchweighted. Catchweighted items must have an entry in this column. Items without pack entries are, generally, considered to be bulk inventory.
ucc128_item
This is a unique item number, used to map the item from the vendor to the item in the ERP system.
wms_ctwght_minwgt
Minimum allowable weight of the item. This entry must be less than or equal to the maximum weight of the field. When there is a value in this field, the netweight field must be 0 or empty, and the maximum weight field must be filled out.
wms_ctwght_maxwgt
Maximum allowable weight of the item. This entry must be greater than or equal to the minimum weight of the field. When there is a value in this field, the netweight field must be 0 or empty, and the minimum weight field must be filled out.
wms_ctwght_netwt
Net weight of the item. When there is an entry in this field, the minimum and maximum weight fields must be 0 or empty.
wms_ctwght_tare
Weight of the packaging material used for packaging this item/pack. This is the amount to be removed from the total weight of the packages item in order to find the actual weight of just the inventory.
upc_key
Typically unused. Value now comes from ERP.
wms_ctwght_scc
Typically unused. Value now comes from ERP.
wms_ctwght_freeze
Number of days to offset the production date for freeze.
wms_ctwght_peel
Number of days to offset the production date for peel.
wms_ctwght_backdt
Number of days to offset the production date backwards for backdating (future dating not permitted even if this value is set to a negative value).
wms_ctwght_sell
Number of days to offset the production date for sellby.
defaultitem
Customer specific entry.
boxcode
An entry that permits like containers to track the tares by tare-group instead of by the item. (Customer specific entry).
minPieces
Minimum number of pieces permitted per case.
maxPieces
Maximum number of pieces permitted per case.
minPieceWeight
Minimum average pieceweight for case (average pieceweight is case netweight / # pieces).
maxPieceWeight
Maximum average pieceweight for case.
target_pieces
Target number of pieces (how many you're trying to pack) for a case.
ECOLotsOnly
This marks an item for being in an ECO certification. ECO lots are only permitted to use ECO item. (Customer specific entry)
