IM Receipt Item Posting
In ScopeTechnical: IM_RECEIPT_ITEM_POSTING | ID: OR-IM-IM_RECEIPT_ITEM_POSTING-IM_RECEIPT_ITEM_POSTING
Stores item-related invoice matching data for IM receipt item posting in Oracle Retail Invoice Matching. It supports merchandising, cost, allocation, or downstream integration processes that depend on item-level attributes and...
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_RECEIPT_ITEM_POSTING
Field Definitions(5)
Rules & Considerations(17)
validation
constraint
Sample Load Data(4)
| _scenario | ITEMR | SEQ_NORPK | SHIPMENTR | CREATED_BY | QTY_POSTED | QTY_MATCHED | CREATION_DATE | LAST_UPDATED_BY | LAST_UPDATE_DATE | OBJECT_VERSION_ID |
|---|---|---|---|---|---|---|---|---|---|---|
| Example values from field definitions | SAMPLE | 1 | 1 | SAMPLE | 1.0000 | 1.0000 | 2026-01-01 | SAMPLE | 2026-01-01 | 1 |
| default | IM Receipt Item Posting-0 | 4 | 3 | APP_USER_ID | 12.5000 | 12.5000 | 2026-01-03 | APP_USER_ID | 2026-01-03 | 1000000003 |
| default | IM Receipt Item Posting-0 | 6 | 5 | USERENV | 14.0000 | 14.0000 | 2026-01-05 | USERENV | 2026-01-05 | 1000000005 |
Example values from field definitions
- ITEMR
- SAMPLE
- SEQ_NORPK
- 1
- SHIPMENTR
- 1
- CREATED_BY
- SAMPLE
- QTY_POSTED
- 1.0000
- QTY_MATCHED
- 1.0000
- CREATION_DATE
- 2026-01-01
- LAST_UPDATED_BY
- SAMPLE
- LAST_UPDATE_DATE
- 2026-01-01
- OBJECT_VERSION_ID
- 1
default
- ITEMR
- IM Receipt Item Posting-0
- SEQ_NORPK
- 4
- SHIPMENTR
- 3
- CREATED_BY
- APP_USER_ID
- QTY_POSTED
- 12.5000
- QTY_MATCHED
- 12.5000
- CREATION_DATE
- 2026-01-03
- LAST_UPDATED_BY
- APP_USER_ID
- LAST_UPDATE_DATE
- 2026-01-03
- OBJECT_VERSION_ID
- 1000000003
default
- ITEMR
- IM Receipt Item Posting-0
- SEQ_NORPK
- 6
- SHIPMENTR
- 5
- CREATED_BY
- USERENV
- QTY_POSTED
- 14.0000
- QTY_MATCHED
- 14.0000
- 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
- 43
- Governed Rule Count
- 17
