Deal Itemloc Div Group
In ScopeTechnical: DEAL_ITEMLOC_DIV_GRP | ID: OR-CST-DEAL_ITEMLOC_DIV_GRP-DEAL_ITEMLOC_DIV_GROUP
This table will hold information for the deal_itemloc view at the company, division and group levels.
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_DIV_GRP
Field Definitions(21)
Rules & Considerations(30)
validation
constraint
Sample Load Data(4)
| _scenario | SEQ_NOR | DEAL_IDRPK | EXCL_INDR | ACTIVE_INDR | COMPANY_INDR | MERCH_LEVELR | DEAL_DETAIL_IDR | LAST_UPDATE_IDR | CREATE_DATETIMER | LAST_UPDATE_DATETIMER | AREA | CHAIN | REGION | DISTRICT | DIVISION | GROUP_NO | LOCATION | LOC_TYPE | CREATE_ID | ORG_LEVEL | ORIGIN_COUNTRY_ID |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| Example values from field definitions | 1 | 1 | S | S | S | SAMPLE | 1 | SAMPLE | 2026-01-01 | 2026-01-01 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | S | SAMPLE | SAMPLE | SAM |
Example values from field definitions
- SEQ_NOR
- 1
- DEAL_IDRPK
- 1
- EXCL_INDR
- S
- ACTIVE_INDR
- S
- COMPANY_INDR
- S
- MERCH_LEVELR
- SAMPLE
- DEAL_DETAIL_IDR
- 1
- LAST_UPDATE_IDR
- SAMPLE
- CREATE_DATETIMER
- 2026-01-01
- LAST_UPDATE_DATETIMER
- 2026-01-01
- AREA
- 1
- CHAIN
- 1
- REGION
- 1
- DISTRICT
- 1
- DIVISION
- 1
- GROUP_NO
- 1
- LOCATION
- 1
- LOC_TYPE
- S
- CREATE_ID
- SAMPLE
- ORG_LEVEL
- SAMPLE
- ORIGIN_COUNTRY_ID
- SAM
Rule Validation Summary
- Source Rule Count
- 46
- Governed Rule Count
- 30