Store Sequence Item
In ScopeTechnical: STORE_SEQUENCE_ITEM | ID: OR-STO-STORE_SEQUENCE_ITEM-STORE_SEQUENCE_ITEM
this table defines a map of an item to a location and what order the item is in within the location.
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
- STORE_SEQUENCE_ITEM
Field Definitions(5)
Rules & Considerations(24)
validation
constraint
Sample Load Data(4)
| _scenario | IDRPK | ITEM_IDR | STORE_IDR | SEQUENCE_ORDERR | STORE_SEQUENCE_AREA_IDR | WIDTH | CAPACITY | UOM_MODE | TICKET_QUANTITY | PRIMARY_LOCATION | TICKET_FORMAT_ID |
|---|---|---|---|---|---|---|---|---|---|---|---|
| Example values from field definitions | 1 | SAMPLE | 1 | 1 | 1 | 1 | 1.00 | 1 | 1.00 | S | 1 |
| default | 3 | ALT-STORE_SEQU-002 | 1000000003 | 3 | 1000000003 | 3 | 12.50 | 3 | 12.50 | N | 1000000003 |
| default | 5 | EDGE-STORE_SEQU-003 | 1000000005 | 5 | 1000000005 | 5 | 14.00 | 5 | 14.00 | N | 1000000005 |
Example values from field definitions
- IDRPK
- 1
- ITEM_IDR
- SAMPLE
- STORE_IDR
- 1
- SEQUENCE_ORDERR
- 1
- STORE_SEQUENCE_AREA_IDR
- 1
- WIDTH
- 1
- CAPACITY
- 1.00
- UOM_MODE
- 1
- TICKET_QUANTITY
- 1.00
- PRIMARY_LOCATION
- S
- TICKET_FORMAT_ID
- 1
default
- IDRPK
- 3
- ITEM_IDR
- ALT-STORE_SEQU-002
- STORE_IDR
- 1000000003
- SEQUENCE_ORDERR
- 3
- STORE_SEQUENCE_AREA_IDR
- 1000000003
- WIDTH
- 3
- CAPACITY
- 12.50
- UOM_MODE
- 3
- TICKET_QUANTITY
- 12.50
- PRIMARY_LOCATION
- N
- TICKET_FORMAT_ID
- 1000000003
default
- IDRPK
- 5
- ITEM_IDR
- EDGE-STORE_SEQU-003
- STORE_IDR
- 1000000005
- SEQUENCE_ORDERR
- 5
- STORE_SEQUENCE_AREA_IDR
- 1000000005
- WIDTH
- 5
- CAPACITY
- 14.00
- UOM_MODE
- 5
- TICKET_QUANTITY
- 14.00
- PRIMARY_LOCATION
- N
- TICKET_FORMAT_ID
- 1000000005
Rule Validation Summary
- Source Rule Count
- 37
- Governed Rule Count
- 24