Stock File Stg

In Scope

Technical: STK_FILE_STG | ID: OR-ITM-STK_FILE_STG-STOCK_FILE_STG

This table will hold ITEM_MASTER information based on the items from the stkupld file.

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: dictionary

Target Structure

Load Approach: Table
Target Objects: STK_FILE_STG

Field Definitions(5)

Rules & Considerations(17)

constraint

validation

Sample Load Data(4)

_scenario	ITEMRPK	DEPT	CLASS	STATUS	LOC_DESC	PACK_IND	SUBCLASS	ITEM_TYPE	ITEM_LEVEL	TRAN_LEVEL	SELLABLE_IND	INVENTORY_IND	ORDERABLE_IND	ITEM_XFORM_IND	SIMPLE_PACK_IND
Example values from field definitions	SAMPLE	1	1	S	SAMPLE	S	1	SAM	1	1	S	S	S	S	S
default	Stk File Stg-002-ALT	1003	1103	P	Stk File Stg-002-ALT	S	1113	Stk	3	3	S	S	S	S	S
default	Stk File Stg-003-EDGE	1005	1105	A	Stk File Stg-003-EDGE	S	1115	Stk	5	5	S	S	S	S	S

Example values from field definitions

ITEMRPK: SAMPLE
DEPT: 1
CLASS: 1
STATUS: S
LOC_DESC: SAMPLE
PACK_IND: S
SUBCLASS: 1
ITEM_TYPE: SAM
ITEM_LEVEL: 1
TRAN_LEVEL: 1
SELLABLE_IND: S
INVENTORY_IND: S
ORDERABLE_IND: S
ITEM_XFORM_IND: S
SIMPLE_PACK_IND: S

default

ITEMRPK: Stk File Stg-002-ALT
DEPT: 1003
CLASS: 1103
STATUS: P
LOC_DESC: Stk File Stg-002-ALT
PACK_IND: S
SUBCLASS: 1113
ITEM_TYPE: Stk
ITEM_LEVEL: 3
TRAN_LEVEL: 3
SELLABLE_IND: S
INVENTORY_IND: S
ORDERABLE_IND: S
ITEM_XFORM_IND: S
SIMPLE_PACK_IND: S

default

ITEMRPK: Stk File Stg-003-EDGE
DEPT: 1005
CLASS: 1105
STATUS: A
LOC_DESC: Stk File Stg-003-EDGE
PACK_IND: S
SUBCLASS: 1115
ITEM_TYPE: Stk
ITEM_LEVEL: 5
TRAN_LEVEL: 5
SELLABLE_IND: S
INVENTORY_IND: S
ORDERABLE_IND: S
ITEM_XFORM_IND: S
SIMPLE_PACK_IND: S

Rule Validation Summary

Source Rule Count: 23
Governed Rule Count: 17