Tran Codes Used By The System
In ScopeTechnical: IM_TRAN_CODE | ID: OR-IM-IM_TRAN_CODE-IM_TRANSACTION_CODE
Stores the tran codes used by the system.
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_TRAN_CODE
Field Definitions(5)
Rules & Considerations(19)
validation
constraint
Sample Load Data(4)
| _scenario | TRAN_IDRPK | TRAN_CODER | TRAN_TYPER | TRAN_CODE_DESCRIPTIONR | TRAN_TYPE_DESCRIPTIONR | CREATED_BY | CREATION_DATE | LAST_UPDATED_BY | LAST_UPDATE_DATE | OBJECT_VERSION_ID |
|---|---|---|---|---|---|---|---|---|---|---|
| Example values from field definitions | 1 | SAMPLE | SAMPLE | SAMPLE | SAMPLE | SAMPLE | 2026-01-01 | SAMPLE | 2026-01-01 | 1 |
| default | 1000000003 | ALT-IM_TRAN-002 | IM Tra | IM Tran Code: Alternate source profile | IM Tran Code: Alternate source profile | APP_USER_ID | 2026-01-03 | APP_USER_ID | 2026-01-03 | 1000000003 |
| default | 1000000005 | EDGE-IM_TRAN-003 | IM Tra | IM Tran Code: Edge-case optional attributes | IM Tran Code: Edge-case optional attributes | USERENV | 2026-01-05 | USERENV | 2026-01-05 | 1000000005 |
Example values from field definitions
- TRAN_IDRPK
- 1
- TRAN_CODER
- SAMPLE
- TRAN_TYPER
- SAMPLE
- TRAN_CODE_DESCRIPTIONR
- SAMPLE
- TRAN_TYPE_DESCRIPTIONR
- SAMPLE
- CREATED_BY
- SAMPLE
- CREATION_DATE
- 2026-01-01
- LAST_UPDATED_BY
- SAMPLE
- LAST_UPDATE_DATE
- 2026-01-01
- OBJECT_VERSION_ID
- 1
default
- TRAN_IDRPK
- 1000000003
- TRAN_CODER
- ALT-IM_TRAN-002
- TRAN_TYPER
- IM Tra
- TRAN_CODE_DESCRIPTIONR
- IM Tran Code: Alternate source profile
- TRAN_TYPE_DESCRIPTIONR
- IM Tran Code: Alternate source profile
- 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_IDRPK
- 1000000005
- TRAN_CODER
- EDGE-IM_TRAN-003
- TRAN_TYPER
- IM Tra
- TRAN_CODE_DESCRIPTIONR
- IM Tran Code: Edge-case optional attributes
- TRAN_TYPE_DESCRIPTIONR
- IM Tran Code: Edge-case optional attributes
- 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
- 49
- Governed Rule Count
- 19