Deal Itemloc Item
In ScopeTechnical: DEAL_ITEMLOC_ITEM | ID: OR-CST-DEAL_ITEMLOC_ITEM-DEAL_ITEMLOC_ITEM
This table will hold information for the deal_itemloc view at the item level.
See how this object fits into Cost
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
- DEAL_ITEMLOC_ITEM
Field Definitions(5)
Rules & Considerations(40)
validation
constraint
Sample Load Data(4)
| _scenario | SEQ_NORPK | DEAL_IDRPK | MERCH_LEVELR | DEAL_DETAIL_IDRPK | AREA | DEPT | ITEM | CHAIN | CLASS | DIFF_1 | DIFF_2 | DIFF_3 | DIFF_4 | REGION | DISTRICT | DIVISION | EXCL_IND | GROUP_NO | LOCATION | LOC_TYPE | SUBCLASS | CREATE_ID | ORG_LEVEL | ACTIVE_IND | ITEM_PARENT | LAST_UPDATE_ID | CREATE_DATETIME | ITEM_GRANDPARENT | ORIGIN_COUNTRY_ID | LAST_UPDATE_DATETIME |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| Example values from field definitions | 1 | 1 | SAMPLE | 1 | 1 | 1 | SAMPLE | 1 | 1 | SAMPLE | SAMPLE | SAMPLE | SAMPLE | 1 | 1 | 1 | S | 1 | 1 | S | 1 | SAMPLE | SAMPLE | S | SAMPLE | SAMPLE | 2026-01-01 | SAMPLE | SAM | 2026-01-01 |
| default | 4 | 1000000003 | Deal I | 1000000003 | 103 | 1003 | Deal Itemloc Item-002-ALT | 13 | 1103 | Deal Iteml | Deal Iteml | Deal Iteml | Deal Iteml | 203 | 303 | 103 | Y | 4 | 3 | D | 1113 | C LIENT_INFO | 2 | D | Deal Itemloc Item-002-ALT | MDM_USER | 2026-01-03 | Deal Itemloc Item-002-ALT | ALT | 2026-01-03 |
| default | 6 | 1000000005 | Deal I | 1000000005 | 105 | 1005 | Deal Itemloc Item-003-EDG | 15 | 1105 | Deal Iteml | Deal Iteml | Deal Iteml | Deal Iteml | 205 | 305 | 105 | Y | 6 | 5 | D | 1115 | USE RENV | 3 | D | Deal Itemloc Item-003-EDG | BATCH_USER | 2026-01-05 | Deal Itemloc Item-003-EDG | EDG | 2026-01-05 |
Example values from field definitions
- SEQ_NORPK
- 1
- DEAL_IDRPK
- 1
- MERCH_LEVELR
- SAMPLE
- DEAL_DETAIL_IDRPK
- 1
- AREA
- 1
- DEPT
- 1
- ITEM
- SAMPLE
- CHAIN
- 1
- CLASS
- 1
- DIFF_1
- SAMPLE
- DIFF_2
- SAMPLE
- DIFF_3
- SAMPLE
- DIFF_4
- SAMPLE
- REGION
- 1
- DISTRICT
- 1
- DIVISION
- 1
- EXCL_IND
- S
- GROUP_NO
- 1
- LOCATION
- 1
- LOC_TYPE
- S
- SUBCLASS
- 1
- CREATE_ID
- SAMPLE
- ORG_LEVEL
- SAMPLE
- ACTIVE_IND
- S
- ITEM_PARENT
- SAMPLE
- LAST_UPDATE_ID
- SAMPLE
- CREATE_DATETIME
- 2026-01-01
- ITEM_GRANDPARENT
- SAMPLE
- ORIGIN_COUNTRY_ID
- SAM
- LAST_UPDATE_DATETIME
- 2026-01-01
default
- SEQ_NORPK
- 4
- DEAL_IDRPK
- 1000000003
- MERCH_LEVELR
- Deal I
- DEAL_DETAIL_IDRPK
- 1000000003
- AREA
- 103
- DEPT
- 1003
- ITEM
- Deal Itemloc Item-002-ALT
- CHAIN
- 13
- CLASS
- 1103
- DIFF_1
- Deal Iteml
- DIFF_2
- Deal Iteml
- DIFF_3
- Deal Iteml
- DIFF_4
- Deal Iteml
- REGION
- 203
- DISTRICT
- 303
- DIVISION
- 103
- EXCL_IND
- Y
- GROUP_NO
- 4
- LOCATION
- 3
- LOC_TYPE
- D
- SUBCLASS
- 1113
- CREATE_ID
- C LIENT_INFO
- ORG_LEVEL
- 2
- ACTIVE_IND
- D
- ITEM_PARENT
- Deal Itemloc Item-002-ALT
- LAST_UPDATE_ID
- MDM_USER
- CREATE_DATETIME
- 2026-01-03
- ITEM_GRANDPARENT
- Deal Itemloc Item-002-ALT
- ORIGIN_COUNTRY_ID
- ALT
- LAST_UPDATE_DATETIME
- 2026-01-03
default
- SEQ_NORPK
- 6
- DEAL_IDRPK
- 1000000005
- MERCH_LEVELR
- Deal I
- DEAL_DETAIL_IDRPK
- 1000000005
- AREA
- 105
- DEPT
- 1005
- ITEM
- Deal Itemloc Item-003-EDG
- CHAIN
- 15
- CLASS
- 1105
- DIFF_1
- Deal Iteml
- DIFF_2
- Deal Iteml
- DIFF_3
- Deal Iteml
- DIFF_4
- Deal Iteml
- REGION
- 205
- DISTRICT
- 305
- DIVISION
- 105
- EXCL_IND
- Y
- GROUP_NO
- 6
- LOCATION
- 5
- LOC_TYPE
- D
- SUBCLASS
- 1115
- CREATE_ID
- USE RENV
- ORG_LEVEL
- 3
- ACTIVE_IND
- D
- ITEM_PARENT
- Deal Itemloc Item-003-EDG
- LAST_UPDATE_ID
- BATCH_USER
- CREATE_DATETIME
- 2026-01-05
- ITEM_GRANDPARENT
- Deal Itemloc Item-003-EDG
- ORIGIN_COUNTRY_ID
- EDG
- LAST_UPDATE_DATETIME
- 2026-01-05
Rule Validation Summary
- Source Rule Count
- 72
- Governed Rule Count
- 40