IM Financials Stage History
In ScopeTechnical: IM_FINANCIALS_STAGE_HIST | ID: OR-IM-IM_FINANCIALS_STAGE_HIST-IM_FINANCIALS_STAGE_HISTORY
This is a history table for the IM_AP_STAGE_DETAIL table. Used for auditability, reconciliation, and historical reporting.
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_HIST
Field Definitions(5)
Rules & Considerations(52)
Sample Load Data(4)
| _scenario | AMOUNT | DOC_ID | SEQ_NO | 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 | TRAN_CODE | 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 | DEBIT_CREDIT_IND | 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.0000 | 1 | 1 | SAMPLE | 1 | 2026-01-01 | 1 | SAMPLE | 1.0000000000 | SAMPLE | 1 | SAMPLE | SAMPLE | SAMPLE | SAMPLE | SAMPLE | SAMPLE | SAMPLE | SAMPLE | SAMPLE | S | SAMPLE | 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 | SAMPLE | S | 1.0000 | SAMPLE | SAM | 1.0000 | 1.0000 |
| default | 12.5000 | 1000000003 | 4 | IM Financi | 1000000003 | 2026-01-03 | 4 | ALT-IM | 12.5000000000 | MDM_USER | 1000000003 | IM Financials Stage Hist- | IM Financials Stage Hist- | IM Financials Stage Hist- | IM Financials Stage Hist- | IM Financials Stage Hist- | IM Financials Stage Hist- | IM Financials Stage Hist- | IM Financials Stage Hist- | IM Financials Stage Hist- | I | write | IM Financials S | ALT-IM_FINANCI-002 | 1000000003 | 1000000003 | IM Financials Stage Hist- | IM Financials Stage Hist- | IM Financials Stage Hist- | IM Financials Stage Hist- | IM Financials Stage Hist- | IM Financials Stage Hist- | IM Financials Stage Hist- | IM Financials Stage Hist- | IM Financials Stage Hist- | IM Financials Stage Hist- | IM Financials Stage Hist- | 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 | IM Fin | I | 12.5000 | IM Financials Stage Hist-002-A | ALT | 12.5000 | 12.5000 |
| default | 14.0000 | 1000000005 | 6 | IM Financi | 1000000005 | 2026-01-05 | 6 | EDGE-I | 14.0000000000 | BATCH_USER | 1000000005 | IM Financials Stage Hist- | IM Financials Stage Hist- | IM Financials Stage Hist- | IM Financials Stage Hist- | IM Financials Stage Hist- | IM Financials Stage Hist- | IM Financials Stage Hist- | IM Financials Stage Hist- | IM Financials Stage Hist- | I | non | IM Financials S | EDGE-IM_FINANCI-003 | 1000000005 | 1000000005 | IM Financials Stage Hist- | IM Financials Stage Hist- | IM Financials Stage Hist- | IM Financials Stage Hist- | IM Financials Stage Hist- | IM Financials Stage Hist- | IM Financials Stage Hist- | IM Financials Stage Hist- | IM Financials Stage Hist- | IM Financials Stage Hist- | IM Financials Stage Hist- | IM Fin | 2026-01-05 | I | 2026-01-05 | — | 14.0000 | EDG | 14.0000000000 | IM | 2026-01-05 | 2026-01-05 | 6 | 1000000005 | IM Fin | I | 14.0000 | IM Financials Stage Hist-003-E | EDG | 14.0000 | 14.0000 |
Example values from field definitions
- AMOUNT
- 1.0000
- DOC_ID
- 1
- SEQ_NO
- 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
- TRAN_CODE
- SAMPLE
- 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
- DEBIT_CREDIT_IND
- SAMPLE
- 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
- AMOUNT
- 12.5000
- DOC_ID
- 1000000003
- SEQ_NO
- 4
- 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 Hist-
- SEGMENT_2
- IM Financials Stage Hist-
- SEGMENT_3
- IM Financials Stage Hist-
- SEGMENT_4
- IM Financials Stage Hist-
- SEGMENT_5
- IM Financials Stage Hist-
- SEGMENT_6
- IM Financials Stage Hist-
- SEGMENT_7
- IM Financials Stage Hist-
- SEGMENT_8
- IM Financials Stage Hist-
- SEGMENT_9
- IM Financials Stage Hist-
- TAX_ENTRY
- I
- TRAN_CODE
- write
- BEST_TERMS
- IM Financials S
- EXT_DOC_ID
- ALT-IM_FINANCI-002
- POSTING_ID
- 1000000003
- RECEIPT_ID
- 1000000003
- SEGMENT_10
- IM Financials Stage Hist-
- SEGMENT_11
- IM Financials Stage Hist-
- SEGMENT_12
- IM Financials Stage Hist-
- SEGMENT_13
- IM Financials Stage Hist-
- SEGMENT_14
- IM Financials Stage Hist-
- SEGMENT_15
- IM Financials Stage Hist-
- SEGMENT_16
- IM Financials Stage Hist-
- SEGMENT_17
- IM Financials Stage Hist-
- SEGMENT_18
- IM Financials Stage Hist-
- SEGMENT_19
- IM Financials Stage Hist-
- SEGMENT_20
- IM Financials Stage Hist-
- 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
- DEBIT_CREDIT_IND
- IM Fin
- MANUALLY_PAID_IND
- I
- PRIM_TRANS_AMOUNT
- 12.5000
- EXCHANGE_RATE_TYPE
- IM Financials Stage Hist-002-A
- PRIM_CURRENCY_CODE
- ALT
- TOTAL_COST_INC_VAT
- 12.5000
- INCOME_LOCAL_CURRENCY
- 12.5000
default
- AMOUNT
- 14.0000
- DOC_ID
- 1000000005
- SEQ_NO
- 6
- 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 Hist-
- SEGMENT_2
- IM Financials Stage Hist-
- SEGMENT_3
- IM Financials Stage Hist-
- SEGMENT_4
- IM Financials Stage Hist-
- SEGMENT_5
- IM Financials Stage Hist-
- SEGMENT_6
- IM Financials Stage Hist-
- SEGMENT_7
- IM Financials Stage Hist-
- SEGMENT_8
- IM Financials Stage Hist-
- SEGMENT_9
- IM Financials Stage Hist-
- TAX_ENTRY
- I
- TRAN_CODE
- non
- BEST_TERMS
- IM Financials S
- EXT_DOC_ID
- EDGE-IM_FINANCI-003
- POSTING_ID
- 1000000005
- RECEIPT_ID
- 1000000005
- SEGMENT_10
- IM Financials Stage Hist-
- SEGMENT_11
- IM Financials Stage Hist-
- SEGMENT_12
- IM Financials Stage Hist-
- SEGMENT_13
- IM Financials Stage Hist-
- SEGMENT_14
- IM Financials Stage Hist-
- SEGMENT_15
- IM Financials Stage Hist-
- SEGMENT_16
- IM Financials Stage Hist-
- SEGMENT_17
- IM Financials Stage Hist-
- SEGMENT_18
- IM Financials Stage Hist-
- SEGMENT_19
- IM Financials Stage Hist-
- SEGMENT_20
- IM Financials Stage Hist-
- 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
- DEBIT_CREDIT_IND
- IM Fin
- MANUALLY_PAID_IND
- I
- PRIM_TRANS_AMOUNT
- 14.0000
- EXCHANGE_RATE_TYPE
- IM Financials Stage Hist-003-E
- PRIM_CURRENCY_CODE
- EDG
- TOTAL_COST_INC_VAT
- 14.0000
- INCOME_LOCAL_CURRENCY
- 14.0000
Rule Validation Summary
- Source Rule Count
- 60
- Governed Rule Count
- 52