IM Valid Accounts
In ScopeTechnical: IM_VALID_ACCOUNTS | ID: OR-IM-IM_VALID_ACCOUNTS-IM_VALID_ACCOUNTS
Stores account setup or posting information for IM valid accounts in Oracle Retail Invoice Matching. Used to map business events to accounting structures and support downstream financial integration and reconciliation.
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_VALID_ACCOUNTS
Field Definitions(5)
Rules & Considerations(38)
validation
constraint
Sample Load Data(4)
| _scenario | SET_OF_BOOKS_IDR | ID | SEGMENT1 | SEGMENT2 | SEGMENT3 | SEGMENT4 | SEGMENT5 | SEGMENT6 | SEGMENT7 | SEGMENT8 | SEGMENT9 | TAX_CODE | SEGMENT10 | SEGMENT11 | SEGMENT12 | SEGMENT13 | SEGMENT14 | SEGMENT15 | SEGMENT16 | SEGMENT17 | SEGMENT18 | SEGMENT19 | SEGMENT20 | CREATED_BY | ACCOUNT_CODE | ACCOUNT_TYPE | CREATION_DATE | LAST_UPDATED_BY | CREATE_DATE_TIME | LAST_UPDATE_DATE | OBJECT_VERSION_ID |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| Example values from field definitions | 1 | 1 | SAMPLE | SAMPLE | SAMPLE | SAMPLE | SAMPLE | SAMPLE | SAMPLE | SAMPLE | SAMPLE | SAMPLE | SAMPLE | SAMPLE | SAMPLE | SAMPLE | SAMPLE | SAMPLE | SAMPLE | SAMPLE | SAMPLE | SAMPLE | SAMPLE | SAMPLE | SAMPLE | SAMPLE | 2026-01-01 | SAMPLE | 2026-01-01 | 2026-01-01 | 1 |
| default | 1000000003 | 3 | IM Valid Accounts-002-ALT | IM Valid Accounts-002-ALT | IM Valid Accounts-002-ALT | IM Valid Accounts-002-ALT | IM Valid Accounts-002-ALT | IM Valid Accounts-002-ALT | IM Valid Accounts-002-ALT | IM Valid Accounts-002-ALT | IM Valid Accounts-002-ALT | NOCODE | IM Valid Accounts-002-ALT | IM Valid Accounts-002-ALT | IM Valid Accounts-002-ALT | IM Valid Accounts-002-ALT | IM Valid Accounts-002-ALT | IM Valid Accounts-002-ALT | IM Valid Accounts-002-ALT | IM Valid Accounts-002-ALT | IM Valid Accounts-002-ALT | IM Valid Accounts-002-ALT | IM Valid Accounts-002-ALT | APP_USER_ID | ALT-IM_VALID-002 | IM Val | 2026-01-03 | APP_USER_ID | 2026-01-03 | 2026-01-03 | 1000000003 |
| default | 1000000005 | 5 | IM Valid Accounts-003-EDG | IM Valid Accounts-003-EDG | IM Valid Accounts-003-EDG | IM Valid Accounts-003-EDG | IM Valid Accounts-003-EDG | IM Valid Accounts-003-EDG | IM Valid Accounts-003-EDG | IM Valid Accounts-003-EDG | IM Valid Accounts-003-EDG | NOCODE | IM Valid Accounts-003-EDG | IM Valid Accounts-003-EDG | IM Valid Accounts-003-EDG | IM Valid Accounts-003-EDG | IM Valid Accounts-003-EDG | IM Valid Accounts-003-EDG | IM Valid Accounts-003-EDG | IM Valid Accounts-003-EDG | IM Valid Accounts-003-EDG | IM Valid Accounts-003-EDG | IM Valid Accounts-003-EDG | USERENV | EDGE-IM_VALID-003 | IM Val | 2026-01-05 | USERENV | 2026-01-05 | 2026-01-05 | 1000000005 |
Example values from field definitions
- SET_OF_BOOKS_IDR
- 1
- ID
- 1
- SEGMENT1
- SAMPLE
- SEGMENT2
- SAMPLE
- SEGMENT3
- SAMPLE
- SEGMENT4
- SAMPLE
- SEGMENT5
- SAMPLE
- SEGMENT6
- SAMPLE
- SEGMENT7
- SAMPLE
- SEGMENT8
- SAMPLE
- SEGMENT9
- SAMPLE
- TAX_CODE
- SAMPLE
- SEGMENT10
- SAMPLE
- SEGMENT11
- SAMPLE
- SEGMENT12
- SAMPLE
- SEGMENT13
- SAMPLE
- SEGMENT14
- SAMPLE
- SEGMENT15
- SAMPLE
- SEGMENT16
- SAMPLE
- SEGMENT17
- SAMPLE
- SEGMENT18
- SAMPLE
- SEGMENT19
- SAMPLE
- SEGMENT20
- SAMPLE
- CREATED_BY
- SAMPLE
- ACCOUNT_CODE
- SAMPLE
- ACCOUNT_TYPE
- SAMPLE
- CREATION_DATE
- 2026-01-01
- LAST_UPDATED_BY
- SAMPLE
- CREATE_DATE_TIME
- 2026-01-01
- LAST_UPDATE_DATE
- 2026-01-01
- OBJECT_VERSION_ID
- 1
default
- SET_OF_BOOKS_IDR
- 1000000003
- ID
- 3
- SEGMENT1
- IM Valid Accounts-002-ALT
- SEGMENT2
- IM Valid Accounts-002-ALT
- SEGMENT3
- IM Valid Accounts-002-ALT
- SEGMENT4
- IM Valid Accounts-002-ALT
- SEGMENT5
- IM Valid Accounts-002-ALT
- SEGMENT6
- IM Valid Accounts-002-ALT
- SEGMENT7
- IM Valid Accounts-002-ALT
- SEGMENT8
- IM Valid Accounts-002-ALT
- SEGMENT9
- IM Valid Accounts-002-ALT
- TAX_CODE
- NOCODE
- SEGMENT10
- IM Valid Accounts-002-ALT
- SEGMENT11
- IM Valid Accounts-002-ALT
- SEGMENT12
- IM Valid Accounts-002-ALT
- SEGMENT13
- IM Valid Accounts-002-ALT
- SEGMENT14
- IM Valid Accounts-002-ALT
- SEGMENT15
- IM Valid Accounts-002-ALT
- SEGMENT16
- IM Valid Accounts-002-ALT
- SEGMENT17
- IM Valid Accounts-002-ALT
- SEGMENT18
- IM Valid Accounts-002-ALT
- SEGMENT19
- IM Valid Accounts-002-ALT
- SEGMENT20
- IM Valid Accounts-002-ALT
- CREATED_BY
- APP_USER_ID
- ACCOUNT_CODE
- ALT-IM_VALID-002
- ACCOUNT_TYPE
- IM Val
- CREATION_DATE
- 2026-01-03
- LAST_UPDATED_BY
- APP_USER_ID
- CREATE_DATE_TIME
- 2026-01-03
- LAST_UPDATE_DATE
- 2026-01-03
- OBJECT_VERSION_ID
- 1000000003
default
- SET_OF_BOOKS_IDR
- 1000000005
- ID
- 5
- SEGMENT1
- IM Valid Accounts-003-EDG
- SEGMENT2
- IM Valid Accounts-003-EDG
- SEGMENT3
- IM Valid Accounts-003-EDG
- SEGMENT4
- IM Valid Accounts-003-EDG
- SEGMENT5
- IM Valid Accounts-003-EDG
- SEGMENT6
- IM Valid Accounts-003-EDG
- SEGMENT7
- IM Valid Accounts-003-EDG
- SEGMENT8
- IM Valid Accounts-003-EDG
- SEGMENT9
- IM Valid Accounts-003-EDG
- TAX_CODE
- NOCODE
- SEGMENT10
- IM Valid Accounts-003-EDG
- SEGMENT11
- IM Valid Accounts-003-EDG
- SEGMENT12
- IM Valid Accounts-003-EDG
- SEGMENT13
- IM Valid Accounts-003-EDG
- SEGMENT14
- IM Valid Accounts-003-EDG
- SEGMENT15
- IM Valid Accounts-003-EDG
- SEGMENT16
- IM Valid Accounts-003-EDG
- SEGMENT17
- IM Valid Accounts-003-EDG
- SEGMENT18
- IM Valid Accounts-003-EDG
- SEGMENT19
- IM Valid Accounts-003-EDG
- SEGMENT20
- IM Valid Accounts-003-EDG
- CREATED_BY
- USERENV
- ACCOUNT_CODE
- EDGE-IM_VALID-003
- ACCOUNT_TYPE
- IM Val
- CREATION_DATE
- 2026-01-05
- LAST_UPDATED_BY
- USERENV
- CREATE_DATE_TIME
- 2026-01-05
- LAST_UPDATE_DATE
- 2026-01-05
- OBJECT_VERSION_ID
- 1000000005
Rule Validation Summary
- Source Rule Count
- 66
- Governed Rule Count
- 38