Work Stkupld Item Location (GTT)

Out of Scope

Technical: WORK_STKUPLD_ITEM_LOC_GTT | ID: OR-ITM-WORK_STKUPLD_ITEM_LOC_GTT-WORK_STKUPLD_ITEM_LOC_GTT

This table is an helper table used in the stock upload process. Information required in the stock upload process from multiple RMS tables are retrieved and stored in this table.

See how this object fits into Item Management

Review the broader sequencing and dependencies for this domain

Migration Details

Complexity: Medium
Sequencing: Stage 2
Typical Sources: ERPLegacy

Classification

Object Type: gtt

Target Structure

Load Approach: Table
Target Objects: WORK_STKUPLD_ITEM_LOC_GTT

Field Definitions(5)

Rules & Considerations(39)

Sample Load Data(4)

_scenario	DEPT	ITEM	CLASS	STATUS	CHUNK_ID	LOCATION	PACK_IND	SUBCLASS	ERROR_MSG	ITEM_TYPE	PACK_ITEM	ITEM_LEVEL	PROCESS_ID	TRAN_LEVEL	CYCLE_COUNT	ITEM_STATUS	SELLABLE_IND	INVENTORY_IND	LOCATION_TYPE	ORDERABLE_IND	ITEM_XFORM_IND	STAKE_QUANTITY	STOCKTAKE_TYPE	NEW_ITEMLOC_IND	SIMPLE_PACK_IND	STOCKCOUNT_ITEM	XFORM_ITEM_TYPE	ILS_STOCK_ON_HAND	PHYSICAL_LOCATION	PRODUCT_LEVEL_IND	SSL_PROCESSED_IND	STOCKCOUNT_QUANTITY	LOCATION_DESCRIPTION	PWH_SUM_SNAPSHOT_QTY	SSL_PACK_COMP_QUANTITY	SSL_PHYSICAL_COUNT_QUANTIT	SSL_SNAPSHOT_ON_HAND_QUANTITY
Example values from field definitions	1	SAMPLE	1	S	1	1	S	1	SAMPLE	SAM	SAMPLE	1	1	1	1	S	S	S	S	S	S	1.0000	S	S	S	SAMPLE	S	1.0000	1	S	S	1.0000	SAMPLE	1.0000	1.0000	1.0000	1.0000
default	1003	Work Stkupld Item Loc Gtt	1103	P	1000000003	3	Y	1113	Work Stkupld Item Loc Gtt-002-ALT	ITM	Work Stkupld Item Loc Gtt	3	1000000003	3	3	S	N	Y	W	N	Y	12.5000	B	W	Y	Work Stkupld Item Loc Gtt	O	12.5000	3	W	W	12.5000	Work Stkupld Item Loc Gtt: Alternate source profile	12.5000	12.5000	12.5000	12.5000
default	1005	Work Stkupld Item Loc Gtt	1105	A	1000000005	5	Y	1115	Work Stkupld Item Loc Gtt-003-EDGE	ITM	Work Stkupld Item Loc Gtt	5	1000000005	5	5	A	Y	Y	E	Y	Y	14.0000	B	W	Y	Work Stkupld Item Loc Gtt	S	14.0000	5	W	W	14.0000	—	14.0000	14.0000	14.0000	14.0000

Example values from field definitions

DEPT: 1
ITEM: SAMPLE
CLASS: 1
STATUS: S
CHUNK_ID: 1
LOCATION: 1
PACK_IND: S
SUBCLASS: 1
ERROR_MSG: SAMPLE
ITEM_TYPE: SAM
PACK_ITEM: SAMPLE
ITEM_LEVEL: 1
PROCESS_ID: 1
TRAN_LEVEL: 1
CYCLE_COUNT: 1
ITEM_STATUS: S
SELLABLE_IND: S
INVENTORY_IND: S
LOCATION_TYPE: S
ORDERABLE_IND: S
ITEM_XFORM_IND: S
STAKE_QUANTITY: 1.0000
STOCKTAKE_TYPE: S
NEW_ITEMLOC_IND: S
SIMPLE_PACK_IND: S
STOCKCOUNT_ITEM: SAMPLE
XFORM_ITEM_TYPE: S
ILS_STOCK_ON_HAND: 1.0000
PHYSICAL_LOCATION: 1
PRODUCT_LEVEL_IND: S
SSL_PROCESSED_IND: S
STOCKCOUNT_QUANTITY: 1.0000
LOCATION_DESCRIPTION: SAMPLE
PWH_SUM_SNAPSHOT_QTY: 1.0000
SSL_PACK_COMP_QUANTITY: 1.0000
SSL_PHYSICAL_COUNT_QUANTIT: 1.0000
SSL_SNAPSHOT_ON_HAND_QUANTITY: 1.0000

default

DEPT: 1003
ITEM: Work Stkupld Item Loc Gtt
CLASS: 1103
STATUS: P
CHUNK_ID: 1000000003
LOCATION: 3
PACK_IND: Y
SUBCLASS: 1113
ERROR_MSG: Work Stkupld Item Loc Gtt-002-ALT
ITEM_TYPE: ITM
PACK_ITEM: Work Stkupld Item Loc Gtt
ITEM_LEVEL: 3
PROCESS_ID: 1000000003
TRAN_LEVEL: 3
CYCLE_COUNT: 3
ITEM_STATUS: S
SELLABLE_IND: N
INVENTORY_IND: Y
LOCATION_TYPE: W
ORDERABLE_IND: N
ITEM_XFORM_IND: Y
STAKE_QUANTITY: 12.5000
STOCKTAKE_TYPE: B
NEW_ITEMLOC_IND: W
SIMPLE_PACK_IND: Y
STOCKCOUNT_ITEM: Work Stkupld Item Loc Gtt
XFORM_ITEM_TYPE: O
ILS_STOCK_ON_HAND: 12.5000
PHYSICAL_LOCATION: 3
PRODUCT_LEVEL_IND: W
SSL_PROCESSED_IND: W
STOCKCOUNT_QUANTITY: 12.5000
LOCATION_DESCRIPTION: Work Stkupld Item Loc Gtt: Alternate source profile
PWH_SUM_SNAPSHOT_QTY: 12.5000
SSL_PACK_COMP_QUANTITY: 12.5000
SSL_PHYSICAL_COUNT_QUANTIT: 12.5000
SSL_SNAPSHOT_ON_HAND_QUANTITY: 12.5000

default

DEPT: 1005
ITEM: Work Stkupld Item Loc Gtt
CLASS: 1105
STATUS: A
CHUNK_ID: 1000000005
LOCATION: 5
PACK_IND: Y
SUBCLASS: 1115
ERROR_MSG: Work Stkupld Item Loc Gtt-003-EDGE
ITEM_TYPE: ITM
PACK_ITEM: Work Stkupld Item Loc Gtt
ITEM_LEVEL: 5
PROCESS_ID: 1000000005
TRAN_LEVEL: 5
CYCLE_COUNT: 5
ITEM_STATUS: A
SELLABLE_IND: Y
INVENTORY_IND: Y
LOCATION_TYPE: E
ORDERABLE_IND: Y
ITEM_XFORM_IND: Y
STAKE_QUANTITY: 14.0000
STOCKTAKE_TYPE: B
NEW_ITEMLOC_IND: W
SIMPLE_PACK_IND: Y
STOCKCOUNT_ITEM: Work Stkupld Item Loc Gtt
XFORM_ITEM_TYPE: S
ILS_STOCK_ON_HAND: 14.0000
PHYSICAL_LOCATION: 5
PRODUCT_LEVEL_IND: W
SSL_PROCESSED_IND: W
STOCKCOUNT_QUANTITY: 14.0000
LOCATION_DESCRIPTION: —
PWH_SUM_SNAPSHOT_QTY: 14.0000
SSL_PACK_COMP_QUANTITY: 14.0000
SSL_PHYSICAL_COUNT_QUANTIT: 14.0000
SSL_SNAPSHOT_ON_HAND_QUANTITY: 14.0000

Rule Validation Summary

Source Rule Count: 69
Governed Rule Count: 39

All objects