IM Financials Stage
In ScopeTechnical: IM_FINANCIALS_STAGE | ID: OR-IM-IM_FINANCIALS_STAGE-IM_FINANCIALS_STAGE
Staging table used to load, validate, and track inbound invoice matching data for Oracle Retail Invoice Matching before it is processed into core operational tables. It typically supports interface status,...
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_FINANCIALS_STAGE
Field Definitions(5)
Rules & Considerations(65)
validation
constraint
Sample Load Data(4)
| _scenario | SEQ_NORPK | TRAN_CODER | DEBIT_CREDIT_INDR | AMOUNT | DOC_ID | VENDOR | DEAL_ID | DOC_DATE | ORDER_NO | VAT_CODE | VAT_RATE | CREATE_ID | PARENT_ID | SEGMENT_1 | SEGMENT_2 | SEGMENT_3 | SEGMENT_4 | SEGMENT_5 | SEGMENT_6 | SEGMENT_7 | SEGMENT_8 | SEGMENT_9 | TAX_ENTRY | BEST_TERMS | EXT_DOC_ID | POSTING_ID | RECEIPT_ID | SEGMENT_10 | SEGMENT_11 | SEGMENT_12 | SEGMENT_13 | SEGMENT_14 | SEGMENT_15 | SEGMENT_16 | SEGMENT_17 | SEGMENT_18 | SEGMENT_19 | SEGMENT_20 | VENDOR_TYPE | DATE_CREATED | PRE_PAID_IND | RECEIPT_DATE | REFERENCE_ID | TRANS_AMOUNT | CURRENCY_CODE | EXCHANGE_RATE | LOCAL_CURRENCY | BEST_TERMS_DATE | CREATE_DATETIME | ODI_SESSION_NUM | SET_OF_BOOKS_ID | MANUALLY_PAID_IND | PRIM_TRANS_AMOUNT | EXCHANGE_RATE_TYPE | PRIM_CURRENCY_CODE | TOTAL_COST_INC_VAT | INCOME_LOCAL_CURRENCY |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| Example values from field definitions | 1 | SAMPLE | SAMPLE | 1.0000 | 1 | SAMPLE | 1 | 2026-01-01 | 1 | SAMPLE | 1.0000000000 | SAMPLE | 1 | SAMPLE | SAMPLE | SAMPLE | SAMPLE | SAMPLE | SAMPLE | SAMPLE | SAMPLE | SAMPLE | S | SAMPLE | SAMPLE | 1 | 1 | SAMPLE | SAMPLE | SAMPLE | SAMPLE | SAMPLE | SAMPLE | SAMPLE | SAMPLE | SAMPLE | SAMPLE | SAMPLE | SAMPLE | 2026-01-01 | S | 2026-01-01 | SAMPLE | 1.0000 | SAM | 1.0000000000 | SAM | 2026-01-01 | 2026-01-01 | 1 | 1 | S | 1.0000 | SAMPLE | SAM | 1.0000 | 1.0000 |
| default | 4 | write | IM Fin | 12.5000 | 1000000003 | IM Financi | 1000000003 | 2026-01-03 | 4 | ALT-IM | 12.5000000000 | MDM_USER | 1000000003 | IM Financials Stage-002-A | IM Financials Stage-002-A | IM Financials Stage-002-A | IM Financials Stage-002-A | IM Financials Stage-002-A | IM Financials Stage-002-A | IM Financials Stage-002-A | IM Financials Stage-002-A | IM Financials Stage-002-A | I | IM Financials S | ALT-IM_FINANCI-002 | 1000000003 | 1000000003 | IM Financials Stage-002-A | IM Financials Stage-002-A | IM Financials Stage-002-A | IM Financials Stage-002-A | IM Financials Stage-002-A | IM Financials Stage-002-A | IM Financials Stage-002-A | IM Financials Stage-002-A | IM Financials Stage-002-A | IM Financials Stage-002-A | IM Financials Stage-002-A | IM Fin | 2026-01-03 | I | 2026-01-03 | ALT-IM_FINANCI-002 | 12.5000 | ALT | 12.5000000000 | IM | 2026-01-03 | 2026-01-03 | 4 | 1000000003 | I | 12.5000 | IM Financials Stage-002-ALT | ALT | 12.5000 | 12.5000 |
| default | 6 | non | IM Fin | 14.0000 | 1000000005 | IM Financi | 1000000005 | 2026-01-05 | 6 | EDGE-I | 14.0000000000 | BATCH_USER | 1000000005 | IM Financials Stage-003-E | IM Financials Stage-003-E | IM Financials Stage-003-E | IM Financials Stage-003-E | IM Financials Stage-003-E | IM Financials Stage-003-E | IM Financials Stage-003-E | IM Financials Stage-003-E | IM Financials Stage-003-E | I | IM Financials S | EDGE-IM_FINANCI-003 | 1000000005 | 1000000005 | IM Financials Stage-003-E | IM Financials Stage-003-E | IM Financials Stage-003-E | IM Financials Stage-003-E | IM Financials Stage-003-E | IM Financials Stage-003-E | IM Financials Stage-003-E | IM Financials Stage-003-E | IM Financials Stage-003-E | IM Financials Stage-003-E | IM Financials Stage-003-E | IM Fin | 2026-01-05 | I | 2026-01-05 | — | 14.0000 | EDG | 14.0000000000 | IM | 2026-01-05 | 2026-01-05 | 6 | 1000000005 | I | 14.0000 | IM Financials Stage-003-EDGE | EDG | 14.0000 | 14.0000 |
Example values from field definitions
- SEQ_NORPK
- 1
- TRAN_CODER
- SAMPLE
- DEBIT_CREDIT_INDR
- SAMPLE
- AMOUNT
- 1.0000
- DOC_ID
- 1
- VENDOR
- SAMPLE
- DEAL_ID
- 1
- DOC_DATE
- 2026-01-01
- ORDER_NO
- 1
- VAT_CODE
- SAMPLE
- VAT_RATE
- 1.0000000000
- CREATE_ID
- SAMPLE
- PARENT_ID
- 1
- SEGMENT_1
- SAMPLE
- SEGMENT_2
- SAMPLE
- SEGMENT_3
- SAMPLE
- SEGMENT_4
- SAMPLE
- SEGMENT_5
- SAMPLE
- SEGMENT_6
- SAMPLE
- SEGMENT_7
- SAMPLE
- SEGMENT_8
- SAMPLE
- SEGMENT_9
- SAMPLE
- TAX_ENTRY
- S
- BEST_TERMS
- SAMPLE
- EXT_DOC_ID
- SAMPLE
- POSTING_ID
- 1
- RECEIPT_ID
- 1
- SEGMENT_10
- SAMPLE
- SEGMENT_11
- SAMPLE
- SEGMENT_12
- SAMPLE
- SEGMENT_13
- SAMPLE
- SEGMENT_14
- SAMPLE
- SEGMENT_15
- SAMPLE
- SEGMENT_16
- SAMPLE
- SEGMENT_17
- SAMPLE
- SEGMENT_18
- SAMPLE
- SEGMENT_19
- SAMPLE
- SEGMENT_20
- SAMPLE
- VENDOR_TYPE
- SAMPLE
- DATE_CREATED
- 2026-01-01
- PRE_PAID_IND
- S
- RECEIPT_DATE
- 2026-01-01
- REFERENCE_ID
- SAMPLE
- TRANS_AMOUNT
- 1.0000
- CURRENCY_CODE
- SAM
- EXCHANGE_RATE
- 1.0000000000
- LOCAL_CURRENCY
- SAM
- BEST_TERMS_DATE
- 2026-01-01
- CREATE_DATETIME
- 2026-01-01
- ODI_SESSION_NUM
- 1
- SET_OF_BOOKS_ID
- 1
- MANUALLY_PAID_IND
- S
- PRIM_TRANS_AMOUNT
- 1.0000
- EXCHANGE_RATE_TYPE
- SAMPLE
- PRIM_CURRENCY_CODE
- SAM
- TOTAL_COST_INC_VAT
- 1.0000
- INCOME_LOCAL_CURRENCY
- 1.0000
default
- SEQ_NORPK
- 4
- TRAN_CODER
- write
- DEBIT_CREDIT_INDR
- IM Fin
- AMOUNT
- 12.5000
- DOC_ID
- 1000000003
- VENDOR
- IM Financi
- DEAL_ID
- 1000000003
- DOC_DATE
- 2026-01-03
- ORDER_NO
- 4
- VAT_CODE
- ALT-IM
- VAT_RATE
- 12.5000000000
- CREATE_ID
- MDM_USER
- PARENT_ID
- 1000000003
- SEGMENT_1
- IM Financials Stage-002-A
- SEGMENT_2
- IM Financials Stage-002-A
- SEGMENT_3
- IM Financials Stage-002-A
- SEGMENT_4
- IM Financials Stage-002-A
- SEGMENT_5
- IM Financials Stage-002-A
- SEGMENT_6
- IM Financials Stage-002-A
- SEGMENT_7
- IM Financials Stage-002-A
- SEGMENT_8
- IM Financials Stage-002-A
- SEGMENT_9
- IM Financials Stage-002-A
- TAX_ENTRY
- I
- BEST_TERMS
- IM Financials S
- EXT_DOC_ID
- ALT-IM_FINANCI-002
- POSTING_ID
- 1000000003
- RECEIPT_ID
- 1000000003
- SEGMENT_10
- IM Financials Stage-002-A
- SEGMENT_11
- IM Financials Stage-002-A
- SEGMENT_12
- IM Financials Stage-002-A
- SEGMENT_13
- IM Financials Stage-002-A
- SEGMENT_14
- IM Financials Stage-002-A
- SEGMENT_15
- IM Financials Stage-002-A
- SEGMENT_16
- IM Financials Stage-002-A
- SEGMENT_17
- IM Financials Stage-002-A
- SEGMENT_18
- IM Financials Stage-002-A
- SEGMENT_19
- IM Financials Stage-002-A
- SEGMENT_20
- IM Financials Stage-002-A
- VENDOR_TYPE
- IM Fin
- DATE_CREATED
- 2026-01-03
- PRE_PAID_IND
- I
- RECEIPT_DATE
- 2026-01-03
- REFERENCE_ID
- ALT-IM_FINANCI-002
- TRANS_AMOUNT
- 12.5000
- CURRENCY_CODE
- ALT
- EXCHANGE_RATE
- 12.5000000000
- LOCAL_CURRENCY
- IM
- BEST_TERMS_DATE
- 2026-01-03
- CREATE_DATETIME
- 2026-01-03
- ODI_SESSION_NUM
- 4
- SET_OF_BOOKS_ID
- 1000000003
- MANUALLY_PAID_IND
- I
- PRIM_TRANS_AMOUNT
- 12.5000
- EXCHANGE_RATE_TYPE
- IM Financials Stage-002-ALT
- PRIM_CURRENCY_CODE
- ALT
- TOTAL_COST_INC_VAT
- 12.5000
- INCOME_LOCAL_CURRENCY
- 12.5000
default
- SEQ_NORPK
- 6
- TRAN_CODER
- non
- DEBIT_CREDIT_INDR
- IM Fin
- AMOUNT
- 14.0000
- DOC_ID
- 1000000005
- VENDOR
- IM Financi
- DEAL_ID
- 1000000005
- DOC_DATE
- 2026-01-05
- ORDER_NO
- 6
- VAT_CODE
- EDGE-I
- VAT_RATE
- 14.0000000000
- CREATE_ID
- BATCH_USER
- PARENT_ID
- 1000000005
- SEGMENT_1
- IM Financials Stage-003-E
- SEGMENT_2
- IM Financials Stage-003-E
- SEGMENT_3
- IM Financials Stage-003-E
- SEGMENT_4
- IM Financials Stage-003-E
- SEGMENT_5
- IM Financials Stage-003-E
- SEGMENT_6
- IM Financials Stage-003-E
- SEGMENT_7
- IM Financials Stage-003-E
- SEGMENT_8
- IM Financials Stage-003-E
- SEGMENT_9
- IM Financials Stage-003-E
- TAX_ENTRY
- I
- BEST_TERMS
- IM Financials S
- EXT_DOC_ID
- EDGE-IM_FINANCI-003
- POSTING_ID
- 1000000005
- RECEIPT_ID
- 1000000005
- SEGMENT_10
- IM Financials Stage-003-E
- SEGMENT_11
- IM Financials Stage-003-E
- SEGMENT_12
- IM Financials Stage-003-E
- SEGMENT_13
- IM Financials Stage-003-E
- SEGMENT_14
- IM Financials Stage-003-E
- SEGMENT_15
- IM Financials Stage-003-E
- SEGMENT_16
- IM Financials Stage-003-E
- SEGMENT_17
- IM Financials Stage-003-E
- SEGMENT_18
- IM Financials Stage-003-E
- SEGMENT_19
- IM Financials Stage-003-E
- SEGMENT_20
- IM Financials Stage-003-E
- VENDOR_TYPE
- IM Fin
- DATE_CREATED
- 2026-01-05
- PRE_PAID_IND
- I
- RECEIPT_DATE
- 2026-01-05
- REFERENCE_ID
- —
- TRANS_AMOUNT
- 14.0000
- CURRENCY_CODE
- EDG
- EXCHANGE_RATE
- 14.0000000000
- LOCAL_CURRENCY
- IM
- BEST_TERMS_DATE
- 2026-01-05
- CREATE_DATETIME
- 2026-01-05
- ODI_SESSION_NUM
- 6
- SET_OF_BOOKS_ID
- 1000000005
- MANUALLY_PAID_IND
- I
- PRIM_TRANS_AMOUNT
- 14.0000
- EXCHANGE_RATE_TYPE
- IM Financials Stage-003-EDGE
- PRIM_CURRENCY_CODE
- EDG
- TOTAL_COST_INC_VAT
- 14.0000
- INCOME_LOCAL_CURRENCY
- 14.0000
Rule Validation Summary
- Source Rule Count
- 75
- Governed Rule Count
- 65