Allocation Session Quantity Limits
In ScopeTechnical: ALC_SESSION_QUANTITY_LIMITS | ID: OR-ALLOC-ALC_SESSION_QUANTITY_LIMITS-ACTUAL_LANDED_COST_SESSION_QUANTITY_LIMITS
Table for storing Quantity limits session detail. On load it would be loaded from alc_quantity_limits table.
See how this object fits into Allocations
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
- ALC_SESSION_QUANTITY_LIMITS
Field Definitions(5)
Rules & Considerations(22)
constraint
validation
Sample Load Data(4)
| _scenario | QUANTITY_LIMITS_SESSION_IDRPK | MAX | MIN | WOS | DEPT | CLASS | TREND | ITEM_ID | ALLOC_ID | LOC_TYPE | MAX_PACK | MIN_NEED | MIN_PACK | SUBCLASS | THRESHOLD | LOCATION_ID | FACET_SESSION_ID | QUANTITY_LIMITS_ID |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| Example values from field definitions | 1 | 1.0000 | 1.0000 | 1.0000 | 1 | 1 | 1.0000 | SAMPLE | 1 | S | 1.0000 | 1.0000 | 1.0000 | 1 | 1.0000 | 1 | SAMPLE | 1 |
| default | 1000000003 | 12.5000 | 12.5000 | 12.5000 | 1003 | 1103 | 12.5000 | ALT-ALC_SESSIO-002 | 1000000003 | A | 12.5000 | 12.5000 | 12.5000 | 1113 | 12.5000 | 1000000003 | ALT-ALC_SESSIO-002 | 1000000003 |
| default | 1000000005 | 14.0000 | 14.0000 | 14.0000 | 1005 | 1105 | 14.0000 | EDGE-ALC_SESSIO-003 | 1000000005 | A | 14.0000 | 14.0000 | 14.0000 | 1115 | 14.0000 | 1000000005 | EDGE-ALC_SESSIO-003 | 1000000005 |
Example values from field definitions
- QUANTITY_LIMITS_SESSION_IDRPK
- 1
- MAX
- 1.0000
- MIN
- 1.0000
- WOS
- 1.0000
- DEPT
- 1
- CLASS
- 1
- TREND
- 1.0000
- ITEM_ID
- SAMPLE
- ALLOC_ID
- 1
- LOC_TYPE
- S
- MAX_PACK
- 1.0000
- MIN_NEED
- 1.0000
- MIN_PACK
- 1.0000
- SUBCLASS
- 1
- THRESHOLD
- 1.0000
- LOCATION_ID
- 1
- FACET_SESSION_ID
- SAMPLE
- QUANTITY_LIMITS_ID
- 1
default
- QUANTITY_LIMITS_SESSION_IDRPK
- 1000000003
- MAX
- 12.5000
- MIN
- 12.5000
- WOS
- 12.5000
- DEPT
- 1003
- CLASS
- 1103
- TREND
- 12.5000
- ITEM_ID
- ALT-ALC_SESSIO-002
- ALLOC_ID
- 1000000003
- LOC_TYPE
- A
- MAX_PACK
- 12.5000
- MIN_NEED
- 12.5000
- MIN_PACK
- 12.5000
- SUBCLASS
- 1113
- THRESHOLD
- 12.5000
- LOCATION_ID
- 1000000003
- FACET_SESSION_ID
- ALT-ALC_SESSIO-002
- QUANTITY_LIMITS_ID
- 1000000003
default
- QUANTITY_LIMITS_SESSION_IDRPK
- 1000000005
- MAX
- 14.0000
- MIN
- 14.0000
- WOS
- 14.0000
- DEPT
- 1005
- CLASS
- 1105
- TREND
- 14.0000
- ITEM_ID
- EDGE-ALC_SESSIO-003
- ALLOC_ID
- 1000000005
- LOC_TYPE
- A
- MAX_PACK
- 14.0000
- MIN_NEED
- 14.0000
- MIN_PACK
- 14.0000
- SUBCLASS
- 1115
- THRESHOLD
- 14.0000
- LOCATION_ID
- 1000000005
- FACET_SESSION_ID
- EDGE-ALC_SESSIO-003
- QUANTITY_LIMITS_ID
- 1000000005
Rule Validation Summary
- Source Rule Count
- 28
- Governed Rule Count
- 22