Stock Count Line Item UIN

In Scope

Technical: STOCK_COUNT_LINE_ITEM_UIN | ID: OR-STO-STOCK_COUNT_LINE_ITEM_UIN-STOCK_COUNT_LINE_ITEM_UIN

Stores all the uins that are assigned to a particular line item on a stock count. it also contains whether the uin is counted, recounted, or authorized.

See how this object fits into Store Operations

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

Field Definitions(5)

Rules & Considerations(27)

validation

constraint

Sample Load Data(4)

_scenario	IDRPK	STORE_IDR	STOCK_COUNT_IDR	STOCK_COUNT_CHILD_IDR	STOCK_COUNT_LINE_ITEM_IDRPK	UIN	COUNT	STATUS	ITEM_ID	RECOUNT	AUTHORIZE	ITEM_UIN_ID
Example values from field definitions	1	1	1	1	1	SAMPLE	S	1	SAMPLE	S	S	1
default	3	1000000003	1000000003	1000000003	1000000003	Stock Count Line Item UIN-002-ALT	N	1	ALT-STOCK_COUN-002	N	N	1000000003
default	5	1000000005	1000000005	1000000005	1000000005	Stock Count Line Item UIN-003-EDGE	N	2	EDGE-STOCK_COUN-003	N	N	1000000005

Example values from field definitions

IDRPK: 1
STORE_IDR: 1
STOCK_COUNT_IDR: 1
STOCK_COUNT_CHILD_IDR: 1
STOCK_COUNT_LINE_ITEM_IDRPK: 1
UIN: SAMPLE
COUNT: S
STATUS: 1
ITEM_ID: SAMPLE
RECOUNT: S
AUTHORIZE: S
ITEM_UIN_ID: 1

default

IDRPK: 3
STORE_IDR: 1000000003
STOCK_COUNT_IDR: 1000000003
STOCK_COUNT_CHILD_IDR: 1000000003
STOCK_COUNT_LINE_ITEM_IDRPK: 1000000003
UIN: Stock Count Line Item UIN-002-ALT
COUNT: N
STATUS: 1
ITEM_ID: ALT-STOCK_COUN-002
RECOUNT: N
AUTHORIZE: N
ITEM_UIN_ID: 1000000003