Difference between revisions of "GX:Studio:Catchweight"

Revision as of 09:52, 12 February 2013

thumb

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

in_item_key

The item to be catchweighted.

im_pack_key

Pack entry of item to be catchweighted.

ucc128_item

Unique item number.

wms_ctwght_minwgt

Minimum allowable weight of the item.

wms_ctwght_maxwgt

Maximum allowable weight of the item.

wms_ctwght_netwt

Net weight of the item.

wms_ctwght_tare

Weight of packaging to be taken out of the weight.

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)

Category:Studio Screen Category:Data Setup Category:WIP

@@ Line 2: / Line 2: @@
 ==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.
+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.
-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:
-) the fill attribute column in the table in_itmpk_tbl contains a value of 2, and
-) 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:
-) the fill attribute column in the table in_itmpk_tbl contains a value of 2, and
-) 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.
+New Item #23 is catchweighted, and Whistle needs to know the various weights associated with the item.
 ==Columns==
-===Item - in_item_key===
+===in_item_key===
 The item to be catchweighted.
-===Pack - im_pack_key===
+===im_pack_key===
 Pack entry of item to be catchweighted.
-===UCC128 - ucc128_item===
+===ucc128_item===
 Unique item number.
-===Min Weight - wms_ctwght_minwgt===
+===wms_ctwght_minwgt===
 Minimum allowable weight of the item.
-===Max Weight - wms_ctwght_maxwgt===
+===wms_ctwght_maxwgt===
 Maximum allowable weight of the item.
-===Net Weight - wms_ctwght_netwt===
+===wms_ctwght_netwt===
 Net weight of the item.
-===Tare - wms_ctwght_tare===
+===wms_ctwght_tare===
 Weight of packaging to be taken out of the weight.
-===UPC - upc_key===
+===upc_key===
 Typically unused.  Value now comes from ERP.
-===SCC - wms_ctwght_scc===
+===wms_ctwght_scc===
 Typically unused.  Value now comes from ERP.
-===Freeze By - wms_ctwght_freeze===
+===wms_ctwght_freeze===
 Number of days to offset the production date for freeze.
-===Peel By - wms_ctwght_peel===
+===wms_ctwght_peel===
 Number of days to offset the production date for peel.
-===Back Dt - wms_ctwght_backdt===
+===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===
+===wms_ctwght_sell===
 Number of days to offset the production date for sellby.
-===Default Item - defaultitem===
+===defaultitem===
 Customer specific entry.
-===Tare Group===
+===boxcode===
 An entry that permits like containers to track the tares by tare-group instead of by the item. (Customer specific entry).
-===Min Pcs - minPieces===
+===minPieces===
 Minimum number of pieces permitted per case.
-===Max Pcs - maxPieces===
+===maxPieces===
 Maximum number of pieces permitted per case.
-===Min PWgt - minPieceWeight ===
+===minPieceWeight===
 Minimum average pieceweight for case (average pieceweight is case netweight / # pieces).
-===Max PWgt - maxPieceWeight===
+===maxPieceWeight===
 Maximum average pieceweight for case.
-===Target Pcs - target_pieces===
+===target_pieces===
 Target number of pieces (how many you're trying to pack) for a case.