IM Reason Transaction Code Map
In ScopeTechnical: IM_REASON_TRAN_CODE_MAP | ID: OR-IM-IM_REASON_TRAN_CODE_MAP-IM_REASON_TRANSACTION_CODE_MAP
Stores the mapping between Reason codes and Tran codes.
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_REASON_TRAN_CODE_MAP
Field Definitions(5)
Rules & Considerations(24)
validation
constraint
Sample Load Data(4)
| _scenario | TRAN_CODER | TRAN_TYPERPK | REASON_CODE_IDRPK | SET_OF_BOOKS_IDR | REASON_TRAN_CODE_MAP_IDRPK | CREATED_BY | CREATION_DATE | LAST_UPDATED_BY | LAST_UPDATE_DATE | OBJECT_VERSION_ID |
|---|---|---|---|---|---|---|---|---|---|---|
| Example values from field definitions | SAMPLE | SAMPLE | SAMPLE | 1 | 1 | SAMPLE | 2026-01-01 | SAMPLE | 2026-01-01 | 1 |
| default | ALT-IM_REASON-002 | IM Rea | ALT-IM_REASON-002 | 1000000003 | 1000000003 | APP_USER_ID | 2026-01-03 | APP_USER_ID | 2026-01-03 | 1000000003 |
| default | EDGE-IM_REASON-003 | IM Rea | EDGE-IM_REASON-003 | 1000000005 | 1000000005 | USERENV | 2026-01-05 | USERENV | 2026-01-05 | 1000000005 |
Example values from field definitions
- TRAN_CODER
- SAMPLE
- TRAN_TYPERPK
- SAMPLE
- REASON_CODE_IDRPK
- SAMPLE
- SET_OF_BOOKS_IDR
- 1
- REASON_TRAN_CODE_MAP_IDRPK
- 1
- CREATED_BY
- SAMPLE
- CREATION_DATE
- 2026-01-01
- LAST_UPDATED_BY
- SAMPLE
- LAST_UPDATE_DATE
- 2026-01-01
- OBJECT_VERSION_ID
- 1
default
- TRAN_CODER
- ALT-IM_REASON-002
- TRAN_TYPERPK
- IM Rea
- REASON_CODE_IDRPK
- ALT-IM_REASON-002
- SET_OF_BOOKS_IDR
- 1000000003
- REASON_TRAN_CODE_MAP_IDRPK
- 1000000003
- CREATED_BY
- APP_USER_ID
- CREATION_DATE
- 2026-01-03
- LAST_UPDATED_BY
- APP_USER_ID
- LAST_UPDATE_DATE
- 2026-01-03
- OBJECT_VERSION_ID
- 1000000003
default
- TRAN_CODER
- EDGE-IM_REASON-003
- TRAN_TYPERPK
- IM Rea
- REASON_CODE_IDRPK
- EDGE-IM_REASON-003
- SET_OF_BOOKS_IDR
- 1000000005
- REASON_TRAN_CODE_MAP_IDRPK
- 1000000005
- CREATED_BY
- USERENV
- CREATION_DATE
- 2026-01-05
- LAST_UPDATED_BY
- USERENV
- LAST_UPDATE_DATE
- 2026-01-05
- OBJECT_VERSION_ID
- 1000000005
Rule Validation Summary
- Source Rule Count
- 58
- Governed Rule Count
- 24