Difference between revisions of "GX:Studio:Catchweight"
| Line 23: | Line 23: | ||
==Columns== | ==Columns== | ||
| − | ===Item=== | + | ===Item - in_item_key=== |
The item to be catchweighted. | The item to be catchweighted. | ||
| − | ===UCC128=== | + | ===Pack - im_pack_key=== |
| + | Pack entry of item to be catchweighted. | ||
| + | |||
| + | ===UCC128 - ucc128_item=== | ||
Unique item number. | Unique item number. | ||
| − | ===Min | + | ===Min Weight - wms_ctwght_minwgt=== |
Minimum allowable weight of the item. | Minimum allowable weight of the item. | ||
| − | ===Max | + | ===Max Weight - wms_ctwght_maxwgt=== |
Maximum allowable weight of the item. | Maximum allowable weight of the item. | ||
| − | ===Net | + | ===Net Weight - wms_ctwght_netwt=== |
Net weight of the item. | Net weight of the item. | ||
| − | ===Tare=== | + | ===Tare - wms_ctwght_tare=== |
| − | Weight of packaging | + | Weight of packaging to be taken out of the weight. |
| − | ===UPC=== | + | ===UPC - upc_key=== |
| + | Typically unused. Value now comes from ERP. | ||
| − | ===SCC=== | + | ===SCC - wms_ctwght_scc=== |
| + | Typically unused. Value now comes from ERP. | ||
| − | ===Freeze By=== | + | ===Freeze By - wms_ctwght_freeze=== |
| + | Number of days to offset the production date for freeze. | ||
| − | ===Peel By=== | + | ===Peel By - wms_ctwght_peel=== |
| + | Number of days to offset the production date for peel. | ||
| − | ===Back Dt=== | + | ===Back Dt - 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). | ||
| − | ===Sell By=== | + | ===Sell By - wms_ctwght_sell=== |
| + | Number of days to offset the production date for sellby. | ||
| − | ===Default Item=== | + | ===Default Item - defaultitem=== |
| + | Customer specific entry. | ||
===Tare Group=== | ===Tare Group=== | ||
| + | An entry that permits like containers to track the tares by tare-group instead of by the item. (Customer specific entry). | ||
| − | ===Min Pcs=== | + | ===Min Pcs - minPieces=== |
| + | Minimum number of pieces permitted per case. | ||
| − | ===Max Pcs=== | + | ===Max Pcs - maxPieces=== |
| + | Maximum number of pieces permitted per case. | ||
| − | ===Min PWgt=== | + | ===Min PWgt - minPieceWeight === |
| + | Minimum average pieceweight for case (average pieceweight is case netweight / # pieces). | ||
| − | ===Max PWgt=== | + | ===Max PWgt - maxPieceWeight=== |
| + | Maximum average pieceweight for case. | ||
| − | ===Target Pcs=== | + | ===Target Pcs - target_pieces=== |
| + | Target number of pieces (how many you're trying to pack) for a case. | ||
===ECOLotsOnly=== | ===ECOLotsOnly=== | ||
| + | This marks an item for being in an ECO certification. ECO lots are only permitted to use ECO item. (Customer specific entry) | ||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
[[GX:Category:Studio Screen|Category:Studio Screen]] | [[GX:Category:Studio Screen|Category:Studio Screen]] | ||
[[GX:Category:Data Setup|Category:Data Setup]] | [[GX:Category:Data Setup|Category:Data Setup]] | ||
[[GX:Category:WIP|Category:WIP]] | [[GX:Category:WIP|Category:WIP]] | ||
Revision as of 18:46, 11 February 2013
Contents
- 1 Intended Use
- 2 Example Usage
- 3 Columns
- 3.1 Item - in_item_key
- 3.2 Pack - im_pack_key
- 3.3 UCC128 - ucc128_item
- 3.4 Min Weight - wms_ctwght_minwgt
- 3.5 Max Weight - wms_ctwght_maxwgt
- 3.6 Net Weight - wms_ctwght_netwt
- 3.7 Tare - wms_ctwght_tare
- 3.8 UPC - upc_key
- 3.9 SCC - wms_ctwght_scc
- 3.10 Freeze By - wms_ctwght_freeze
- 3.11 Peel By - wms_ctwght_peel
- 3.12 Back Dt - wms_ctwght_backdt
- 3.13 Sell By - wms_ctwght_sell
- 3.14 Default Item - defaultitem
- 3.15 Tare Group
- 3.16 Min Pcs - minPieces
- 3.17 Max Pcs - maxPieces
- 3.18 Min PWgt - minPieceWeight
- 3.19 Max PWgt - maxPieceWeight
- 3.20 Target Pcs - target_pieces
- 3.21 ECOLotsOnly
Intended Use
This screen is used to set up catchweighted items. A catchweight (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.
When using the Infor ERP system, an item is considered to be catchweight or random weight, with potentially a different weight for each piece if:
1) the fill attribute column in the table in_itmpk_tbl contains a value of 2, and
2) the net weight column (wms_ctwght_netwt) in the table wms_ctwght_tbl is equal to 0.
An item is considered catchweight or random weight, but uses the same weight for each piece if:
1) the fill attribute column in the table in_itmpk_tbl contains a value of 2, and
2) the net weight column (wms_ctwght_netwt) in the table wms_ctwght_tbl is greater than 0.
Example Usage
New Item #23 is catchweighted, and Whistle needs to know the various weighs associated with the item.
Columns
Item - in_item_key
The item to be catchweighted.
Pack - im_pack_key
Pack entry of item to be catchweighted.
UCC128 - ucc128_item
Unique item number.
Min Weight - wms_ctwght_minwgt
Minimum allowable weight of the item.
Max Weight - wms_ctwght_maxwgt
Maximum allowable weight of the item.
Net Weight - wms_ctwght_netwt
Net weight of the item.
Tare - wms_ctwght_tare
Weight of packaging to be taken out of the weight.
UPC - upc_key
Typically unused. Value now comes from ERP.
SCC - wms_ctwght_scc
Typically unused. Value now comes from ERP.
Freeze By - wms_ctwght_freeze
Number of days to offset the production date for freeze.
Peel By - wms_ctwght_peel
Number of days to offset the production date for peel.
Back Dt - 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).
Sell By - wms_ctwght_sell
Number of days to offset the production date for sellby.
Default Item - defaultitem
Customer specific entry.
Tare Group
An entry that permits like containers to track the tares by tare-group instead of by the item. (Customer specific entry).
Min Pcs - minPieces
Minimum number of pieces permitted per case.
Max Pcs - maxPieces
Maximum number of pieces permitted per case.
Min PWgt - minPieceWeight
Minimum average pieceweight for case (average pieceweight is case netweight / # pieces).
Max PWgt - maxPieceWeight
Maximum average pieceweight for case.
Target Pcs - 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)
