Difference between revisions of "GX:Studio:Catchweight"
Line 38: | Line 38: | ||
===upc_key=== | ===upc_key=== | ||
− | Typically unused. | + | Typically unused. This value now comes from the ERP system. |
===wms_ctwght_scc=== | ===wms_ctwght_scc=== | ||
− | Typically unused. | + | Typically unused. This value now comes from the ERP system. |
===wms_ctwght_freeze=== | ===wms_ctwght_freeze=== | ||
− | + | This is the number of days to offset the production date for freeze. | |
===wms_ctwght_peel=== | ===wms_ctwght_peel=== | ||
− | + | This is the number of days to offset the production date for peel. | |
===wms_ctwght_backdt=== | ===wms_ctwght_backdt=== | ||
− | + | This is the number of days to offset the production date backwards for backdating. | |
===wms_ctwght_sell=== | ===wms_ctwght_sell=== | ||
− | + | This is the number of days to offset the production date for sellby. | |
===defaultitem=== | ===defaultitem=== | ||
− | Customer specific entry. | + | Customer specific entry, not generally used. |
===boxcode=== | ===boxcode=== | ||
− | An entry that permits | + | An entry that permits containers with the same inventory contents to track the tares by tare-group instead of by the item. Customer specific entry, not generally used. |
===minPieces=== | ===minPieces=== | ||
− | + | This is the minimum number of pieces permitted per case. | |
===maxPieces=== | ===maxPieces=== | ||
− | + | This is the maximum number of pieces permitted per case. | |
===minPieceWeight=== | ===minPieceWeight=== | ||
− | + | This is the mMinimum average pieceweight for case (average pieceweight is case netweight / # pieces). | |
===maxPieceWeight=== | ===maxPieceWeight=== | ||
− | + | This is the maximum average pieceweight for case. | |
===target_pieces=== | ===target_pieces=== | ||
− | + | This is the target number of pieces (how many you're trying to pack) for a case. | |
===ECOLotsOnly=== | ===ECOLotsOnly=== |
Revision as of 13:29, 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. This value now comes from the ERP system.
wms_ctwght_scc
Typically unused. This value now comes from the ERP system.
wms_ctwght_freeze
This is the number of days to offset the production date for freeze.
wms_ctwght_peel
This is the number of days to offset the production date for peel.
wms_ctwght_backdt
This is the number of days to offset the production date backwards for backdating.
wms_ctwght_sell
This is the number of days to offset the production date for sellby.
defaultitem
Customer specific entry, not generally used.
boxcode
An entry that permits containers with the same inventory contents to track the tares by tare-group instead of by the item. Customer specific entry, not generally used.
minPieces
This is the minimum number of pieces permitted per case.
maxPieces
This is the maximum number of pieces permitted per case.
minPieceWeight
This is the mMinimum average pieceweight for case (average pieceweight is case netweight / # pieces).
maxPieceWeight
This is the maximum average pieceweight for case.
target_pieces
This is the 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)