Location List Criteria
In ScopeTechnical: LOC_LIST_CRITERIA | ID: OR-FND-LOC_LIST_CRITERIA-LOCATION_LIST_CRITERIA
Stores one row for each step performed to obtain a store grouping criteria and a warehouse grouping criteria. For each step performed, a query where clause is formed to include/exclude...
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
- LOC_LIST_CRITERIA
Field Definitions(5)
Rules & Considerations(17)
constraint
validation
Sample Load Data(4)
| _scenario | SEQ_NORPK | LOC_LISTRPK | LOC_TYPERPK | VALUE | ELEMENT | COMPARISON | RELATED_VALUE | LOGIC_OPERATION | OPEN_PARENTHESIS | CLOSE_PARENTHESIS |
|---|---|---|---|---|---|---|---|---|---|---|
| Example values from field definitions | 1 | 1 | S | SAMPLE | SAMPLE | SAMPLE | 1 | SAMPLE | S | S |
| default | 4 | 3 | S | Loc List Criteria-002-ALT | Distri | Loc Li | 3 | Loc Li | L | L |
| default | 6 | 5 | S | Loc List Criteria-003-EDGE | Curren | Loc Li | 5 | Loc Li | L | L |
Example values from field definitions
- SEQ_NORPK
- 1
- LOC_LISTRPK
- 1
- LOC_TYPERPK
- S
- VALUE
- SAMPLE
- ELEMENT
- SAMPLE
- COMPARISON
- SAMPLE
- RELATED_VALUE
- 1
- LOGIC_OPERATION
- SAMPLE
- OPEN_PARENTHESIS
- S
- CLOSE_PARENTHESIS
- S
default
- SEQ_NORPK
- 4
- LOC_LISTRPK
- 3
- LOC_TYPERPK
- S
- VALUE
- Loc List Criteria-002-ALT
- ELEMENT
- Distri
- COMPARISON
- Loc Li
- RELATED_VALUE
- 3
- LOGIC_OPERATION
- Loc Li
- OPEN_PARENTHESIS
- L
- CLOSE_PARENTHESIS
- L
default
- SEQ_NORPK
- 6
- LOC_LISTRPK
- 5
- LOC_TYPERPK
- S
- VALUE
- Loc List Criteria-003-EDGE
- ELEMENT
- Curren
- COMPARISON
- Loc Li
- RELATED_VALUE
- 5
- LOGIC_OPERATION
- Loc Li
- OPEN_PARENTHESIS
- L
- CLOSE_PARENTHESIS
- L
Rule Validation Summary
- Source Rule Count
- 26
- Governed Rule Count
- 17