Deal Itemloc Parent Diff
In ScopeTechnical: DEAL_ITEMLOC_PARENT_DIFF | ID: OR-MFCS-DEAL_ITEMLOC_PARENT_DIFF
This table will hold information for the deal_itemloc view at the parent, parent/diff1, parent/diff2, parent/diff3 and parent/diff4.
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
Target Structure
- Load Approach
- Table
- Target Objects
- DEAL_ITEMLOC_PARENT_DIFF
Field Definitions(29)
Rules & Considerations(74)
Sample Load Data(4)
| _scenario | SEQ_NOR | DEAL_IDRPK | EXCL_INDR | ACTIVE_INDR | MERCH_LEVELR | DEAL_DETAIL_IDR | LAST_UPDATE_IDR | CREATE_DATETIMER | LAST_UPDATE_DATETIMER | AREA | DEPT | CHAIN | CLASS | DIFF_1 | DIFF_2 | DIFF_3 | DIFF_4 | REGION | DISTRICT | DIVISION | GROUP_NO | LOCATION | LOC_TYPE | SUBCLASS | CREATE_ID | ORG_LEVEL | ITEM_PARENT | ITEM_GRANDPARENT | ORIGIN_COUNTRY_ID |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| default | 2 | 1000000001 | Y | Deal Itemloc Parent Diff-001 | Deal Itemloc Parent Diff-001 | 1000000001 | MIG_USER | 2026-01-01 | 2026-01-01 | 101 | 1001 | 11 | 1101 | Deal Itemloc Parent Diff-001 | Deal Itemloc Parent Diff-001 | Deal Itemloc Parent Diff-001 | Deal Itemloc Parent Diff-001 | 201 | 301 | 0101 | 0002 | 1 | Deal Itemloc Parent Diff-001 | 1111 | USERENV | 1 | Deal Itemloc Parent Diff-001 | Deal Itemloc Parent Diff-001 | STD-DEAL_ITEML-001 |
default
- SEQ_NOR
- 2
- DEAL_IDRPK
- 1000000001
- EXCL_INDR
- Y
- ACTIVE_INDR
- Deal Itemloc Parent Diff-001
- MERCH_LEVELR
- Deal Itemloc Parent Diff-001
- DEAL_DETAIL_IDR
- 1000000001
- LAST_UPDATE_IDR
- MIG_USER
- CREATE_DATETIMER
- 2026-01-01
- LAST_UPDATE_DATETIMER
- 2026-01-01
- AREA
- 101
- DEPT
- 1001
- CHAIN
- 11
- CLASS
- 1101
- DIFF_1
- Deal Itemloc Parent Diff-001
- DIFF_2
- Deal Itemloc Parent Diff-001
- DIFF_3
- Deal Itemloc Parent Diff-001
- DIFF_4
- Deal Itemloc Parent Diff-001
- REGION
- 201
- DISTRICT
- 301
- DIVISION
- 0101
- GROUP_NO
- 0002
- LOCATION
- 1
- LOC_TYPE
- Deal Itemloc Parent Diff-001
- SUBCLASS
- 1111
- CREATE_ID
- USERENV
- ORG_LEVEL
- 1
- ITEM_PARENT
- Deal Itemloc Parent Diff-001
- ITEM_GRANDPARENT
- Deal Itemloc Parent Diff-001
- ORIGIN_COUNTRY_ID
- STD-DEAL_ITEML-001