IM Prorate Workspace
In ScopeTechnical: IM_PRORATE_WORKSPACE | ID: OR-IM-IM_PRORATE_WORKSPACE
Stores invoice matching data for IM prorate workspace in Oracle Retail Invoice Matching. Used to support operational processing, integration, and reporting within the Oracle Retail application landscape.
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
Target Structure
- Load Approach
- Table
- Target Objects
- IM_PRORATE_WORKSPACE
Field Definitions(15)
Rules & Considerations(42)
Sample Load Data(4)
| _scenario | DECIMAL_SCALER | PRORATE_GROUP_KEYR | PRORATE_WORKSPACE_IDR | SHARE_DATA_1 | SHARE_DATA_2 | SHARE_DATA_3 | SHARE_IN_GROUP_1 | SHARE_IN_GROUP_2 | SHARE_IN_GROUP_3 | AMOUNT_TO_PRORATE_1 | AMOUNT_TO_PRORATE_2 | AMOUNT_TO_PRORATE_3 | RESULT_PRORATED_AMOUNT_2 | RESULT_PRORATED_AMOUNT_3 | REF_ROWID_1NROWID1011REF_ROWID_2NROWID1012REF_ROWID_3NROWID1013RESULT_PRORATED_AMOUNT_1 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| default | 000001 | STD-IM_PRORATE-001 | 1000000001 | IM Prorate Workspace-001 | IM Prorate Workspace-001 | IM Prorate Workspace-001 | 1 | 1 | 1 | 0 | 0 | 0 | 11.0000 | 11.0000 | 11.0000 |
default
- DECIMAL_SCALER
- 000001
- PRORATE_GROUP_KEYR
- STD-IM_PRORATE-001
- PRORATE_WORKSPACE_IDR
- 1000000001
- SHARE_DATA_1
- IM Prorate Workspace-001
- SHARE_DATA_2
- IM Prorate Workspace-001
- SHARE_DATA_3
- IM Prorate Workspace-001
- SHARE_IN_GROUP_1
- 1
- SHARE_IN_GROUP_2
- 1
- SHARE_IN_GROUP_3
- 1
- AMOUNT_TO_PRORATE_1
- 0
- AMOUNT_TO_PRORATE_2
- 0
- AMOUNT_TO_PRORATE_3
- 0
- RESULT_PRORATED_AMOUNT_2
- 11.0000
- RESULT_PRORATED_AMOUNT_3
- 11.0000
- REF_ROWID_1NROWID1011REF_ROWID_2NROWID1012REF_ROWID_3NROWID1013RESULT_PRORATED_AMOUNT_1
- 11.0000