Staged Data For Complex Deals
In ScopeTechnical: IM_INJECT_COMPLEX_DEAL_DETAIL | ID: OR-IM-IM_INJECT_COMPLEX_DEAL_DETAIL-IM_INJECT_COMPLEX_DEAL_DETAIL
Stores staged data for complex deals.
See how this object fits into Invoice Matching
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
- IM_INJECT_COMPLEX_DEAL_DETAIL
Field Definitions(5)
Rules & Considerations(28)
constraint
validation
Sample Load Data(4)
| _scenario | SEQ_NOR | INJECT_IDR | INJECT_DOC_IDR | ITEM | LOCATION | LOC_TYPE | ORDER_NO | CREATED_BY | CREATION_DATE | LOCAL_CURRENCY | LAST_UPDATED_BY | INCOME_DEAL_CURR | LAST_UPDATE_DATE | INCOME_LOCAL_CURR | OBJECT_VERSION_ID | ACTUAL_TURNOVER_UNITS | REF_OBJECT_VERSION_ID | ACTUAL_TURNOVER_REVENUE |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| Example values from field definitions | 1 | 1 | 1 | SAMPLE | 1 | SAMPLE | 1 | SAMPLE | 2026-01-01 | SAM | SAMPLE | 1.0000 | 2026-01-01 | 1.0000 | 1 | 1.0000 | 1 | 1.0000 |
| default | 4 | 1000000003 | 1000000003 | IM Inject Complex Deal De | 3 | IM Inj | 4 | IM Inject Complex Deal Detail-002-ALT | 2026-01-03 | IM | 2026-01-02-ALT | 12.5000 | 2026-01-03 | 12.5000 | 1000000003 | 12.5000 | 1000000003 | 12.5000 |
| default | 6 | 1000000005 | 1000000005 | IM Inject Complex Deal De | 5 | IM Inj | 6 | IM Inject Complex Deal Detail-003-EDGE | 2026-01-05 | IM | 2026-01-03-EDGE | 14.0000 | 2026-01-05 | 14.0000 | 1000000005 | 14.0000 | 1000000005 | 14.0000 |
Example values from field definitions
- SEQ_NOR
- 1
- INJECT_IDR
- 1
- INJECT_DOC_IDR
- 1
- ITEM
- SAMPLE
- LOCATION
- 1
- LOC_TYPE
- SAMPLE
- ORDER_NO
- 1
- CREATED_BY
- SAMPLE
- CREATION_DATE
- 2026-01-01
- LOCAL_CURRENCY
- SAM
- LAST_UPDATED_BY
- SAMPLE
- INCOME_DEAL_CURR
- 1.0000
- LAST_UPDATE_DATE
- 2026-01-01
- INCOME_LOCAL_CURR
- 1.0000
- OBJECT_VERSION_ID
- 1
- ACTUAL_TURNOVER_UNITS
- 1.0000
- REF_OBJECT_VERSION_ID
- 1
- ACTUAL_TURNOVER_REVENUE
- 1.0000
default
- SEQ_NOR
- 4
- INJECT_IDR
- 1000000003
- INJECT_DOC_IDR
- 1000000003
- ITEM
- IM Inject Complex Deal De
- LOCATION
- 3
- LOC_TYPE
- IM Inj
- ORDER_NO
- 4
- CREATED_BY
- IM Inject Complex Deal Detail-002-ALT
- CREATION_DATE
- 2026-01-03
- LOCAL_CURRENCY
- IM
- LAST_UPDATED_BY
- 2026-01-02-ALT
- INCOME_DEAL_CURR
- 12.5000
- LAST_UPDATE_DATE
- 2026-01-03
- INCOME_LOCAL_CURR
- 12.5000
- OBJECT_VERSION_ID
- 1000000003
- ACTUAL_TURNOVER_UNITS
- 12.5000
- REF_OBJECT_VERSION_ID
- 1000000003
- ACTUAL_TURNOVER_REVENUE
- 12.5000
default
- SEQ_NOR
- 6
- INJECT_IDR
- 1000000005
- INJECT_DOC_IDR
- 1000000005
- ITEM
- IM Inject Complex Deal De
- LOCATION
- 5
- LOC_TYPE
- IM Inj
- ORDER_NO
- 6
- CREATED_BY
- IM Inject Complex Deal Detail-003-EDGE
- CREATION_DATE
- 2026-01-05
- LOCAL_CURRENCY
- IM
- LAST_UPDATED_BY
- 2026-01-03-EDGE
- INCOME_DEAL_CURR
- 14.0000
- LAST_UPDATE_DATE
- 2026-01-05
- INCOME_LOCAL_CURR
- 14.0000
- OBJECT_VERSION_ID
- 1000000005
- ACTUAL_TURNOVER_UNITS
- 14.0000
- REF_OBJECT_VERSION_ID
- 1000000005
- ACTUAL_TURNOVER_REVENUE
- 14.0000
Rule Validation Summary
- Source Rule Count
- 34
- Governed Rule Count
- 28