RMS Oi Inventory Ctl Neg Inventory

In Scope

Technical: RMS_OI_INV_CTL_NEG_INV | ID: OR-FND-RMS_OI_INV_CTL_NEG_INV-RMS_OI_INVENTORY_CTL_NEG_INVENTORY

Stores the information for the Negative Inventory Control Report.

See how this object fits into Foundation Data

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

Field Definitions(5)

Rules & Considerations(11)

Sample Load Data(4)

_scenario	LOC	ITEM	LOC_NAME	LOC_TYPE	ITEM_DESC	SESSION_ID	STANDARD_UOM	STOCK_ON_HAND	IN_PROGRESS_PO_COUNT	IN_PROGRESS_TSF_COUNT	IN_PROGRESS_ALLOC_COUNT
Example values from field definitions	1	SAMPLE	SAMPLE	SAMPLE	SAMPLE	1	SAMP	1.0000	1	1	1
default	3	RMS Oi Inv Ctl Neg Inv-00	RMS Oi Inv Ctl Neg Inv Secondary	RMS Oi Inv Ctl Neg Inv-002-ALT	RMS Oi Inv Ctl Neg Inv-002-ALT	1000000003	RMS	12.5000	3	3	3
default	5	RMS Oi Inv Ctl Neg Inv-00	RMS Oi Inv Ctl Neg Inv Core	RMS Oi Inv Ctl Neg Inv-003-EDGE	RMS Oi Inv Ctl Neg Inv-003-EDGE	1000000005	RMS	14.0000	5	5	5

Example values from field definitions

LOC: 1
ITEM: SAMPLE
LOC_NAME: SAMPLE
LOC_TYPE: SAMPLE
ITEM_DESC: SAMPLE
SESSION_ID: 1
STANDARD_UOM: SAMP
STOCK_ON_HAND: 1.0000
IN_PROGRESS_PO_COUNT: 1
IN_PROGRESS_TSF_COUNT: 1
IN_PROGRESS_ALLOC_COUNT: 1

default

LOC: 3
ITEM: RMS Oi Inv Ctl Neg Inv-00
LOC_NAME: RMS Oi Inv Ctl Neg Inv Secondary
LOC_TYPE: RMS Oi Inv Ctl Neg Inv-002-ALT
ITEM_DESC: RMS Oi Inv Ctl Neg Inv-002-ALT
SESSION_ID: 1000000003
STANDARD_UOM: RMS
STOCK_ON_HAND: 12.5000
IN_PROGRESS_PO_COUNT: 3
IN_PROGRESS_TSF_COUNT: 3
IN_PROGRESS_ALLOC_COUNT: 3

default

LOC: 5
ITEM: RMS Oi Inv Ctl Neg Inv-00
LOC_NAME: RMS Oi Inv Ctl Neg Inv Core
LOC_TYPE: RMS Oi Inv Ctl Neg Inv-003-EDGE
ITEM_DESC: RMS Oi Inv Ctl Neg Inv-003-EDGE
SESSION_ID: 1000000005
STANDARD_UOM: RMS
STOCK_ON_HAND: 14.0000
IN_PROGRESS_PO_COUNT: 5
IN_PROGRESS_TSF_COUNT: 5
IN_PROGRESS_ALLOC_COUNT: 5

Rule Validation Summary

Source Rule Count: 14
Governed Rule Count: 11