IM Ap Stage Detail History

In Scope

Technical: IM_AP_STAGE_DETAIL_HIST | ID: OR-IM-IM_AP_STAGE_DETAIL_HIST-IM_AP_STAGE_DETAIL_HISTORY

Invoice Matching history table for AP staging detail lines for documents posted to Oracle Financials, including transaction codes, amounts, VAT, and GL account segments.

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_AP_STAGE_DETAIL_HIST

Field Definitions(5)

Rules & Considerations(41)

Sample Load Data(4)

_scenario	AMOUNT	DOC_ID	SEQ_NO	ORG_UNIT	SEGMENT1	SEGMENT2	SEGMENT3	SEGMENT4	SEGMENT5	SEGMENT6	SEGMENT7	SEGMENT8	SEGMENT9	VAT_CODE	VAT_RATE	SEGMENT10	SEGMENT11	SEGMENT12	SEGMENT13	SEGMENT14	SEGMENT15	SEGMENT16	SEGMENT17	SEGMENT18	SEGMENT19	SEGMENT20	TRAN_CODE	POSTING_ID	REASON_CODE	REFERENCE_ID	LINE_GROUP_NO	NON_MERCH_CODE	ODI_SESSION_NUM	SET_OF_BOOKS_ID	CREATE_DATE_TIME	PRORATE_ACROSS_FLAG	LINE_TYPE_LOOKUP_CODE	SELF_ASSESSED_TAX_IND	BASIC_TRANSACTION_CODE	REASON_CODE_DESCRIPTION	NON_MRCH_CODE_DESCRIPTION	BASIC_TRANSACTION_CODE_DESC
Example values from field definitions	1.0000	1	1	1	SAMPLE	SAMPLE	SAMPLE	SAMPLE	SAMPLE	SAMPLE	SAMPLE	SAMPLE	SAMPLE	SAMPLE	1.0000000000	SAMPLE	SAMPLE	SAMPLE	SAMPLE	SAMPLE	SAMPLE	SAMPLE	SAMPLE	SAMPLE	SAMPLE	SAMPLE	SAMPLE	1	SAMPLE	SAMPLE	1	SAMPLE	1	1	2026-01-01	S	SAMPLE	SAMPLE	SAMPLE	SAMPLE	SAMPLE	SAMPLE
default	12.5000	1000000003	4	3	IM Ap Stage Detail Hist-0	IM Ap Stage Detail Hist-0	IM Ap Stage Detail Hist-0	IM Ap Stage Detail Hist-0	IM Ap Stage Detail Hist-0	IM Ap Stage Detail Hist-0	IM Ap Stage Detail Hist-0	IM Ap Stage Detail Hist-0	IM Ap Stage Detail Hist-0	ALT-IM	12.5000000000	IM Ap Stage Detail Hist-0	IM Ap Stage Detail Hist-0	IM Ap Stage Detail Hist-0	IM Ap Stage Detail Hist-0	IM Ap Stage Detail Hist-0	IM Ap Stage Detail Hist-0	IM Ap Stage Detail Hist-0	IM Ap Stage Detail Hist-0	IM Ap Stage Detail Hist-0	IM Ap Stage Detail Hist-0	IM Ap Stage Detail Hist-0	ALT-IM	1000000003	ALT-IM_AP-002	ALT-IM_AP-002	4	ALT-IM	4	1000000003	2026-01-03	I	ALT-IM_AP-002	IM Ap Stage Detail Hist-002-ALT	ALT-IM	IM Ap Stage Detail Hist: Alternate source profile	IM Ap Stage Detail Hist: Alternate source profile	IM Ap Stage Detail Hist-002-ALT
default	14.0000	1000000005	6	5	IM Ap Stage Detail Hist-0	IM Ap Stage Detail Hist-0	IM Ap Stage Detail Hist-0	IM Ap Stage Detail Hist-0	IM Ap Stage Detail Hist-0	IM Ap Stage Detail Hist-0	IM Ap Stage Detail Hist-0	IM Ap Stage Detail Hist-0	IM Ap Stage Detail Hist-0	EDGE-I	14.0000000000	IM Ap Stage Detail Hist-0	IM Ap Stage Detail Hist-0	IM Ap Stage Detail Hist-0	IM Ap Stage Detail Hist-0	IM Ap Stage Detail Hist-0	IM Ap Stage Detail Hist-0	IM Ap Stage Detail Hist-0	IM Ap Stage Detail Hist-0	IM Ap Stage Detail Hist-0	IM Ap Stage Detail Hist-0	IM Ap Stage Detail Hist-0	EDGE-I	1000000005	EDGE-IM_AP-003	—	6	EDGE-I	6	1000000005	2026-01-05	I	EDGE-IM_AP-003	IM Ap Stage Detail Hist-003-EDGE	EDGE-I	—	—	IM Ap Stage Detail Hist-003-EDGE

Example values from field definitions

AMOUNT: 1.0000
DOC_ID: 1
SEQ_NO: 1
ORG_UNIT: 1
SEGMENT1: SAMPLE
SEGMENT2: SAMPLE
SEGMENT3: SAMPLE
SEGMENT4: SAMPLE
SEGMENT5: SAMPLE
SEGMENT6: SAMPLE
SEGMENT7: SAMPLE
SEGMENT8: SAMPLE
SEGMENT9: SAMPLE
VAT_CODE: SAMPLE
VAT_RATE: 1.0000000000
SEGMENT10: SAMPLE
SEGMENT11: SAMPLE
SEGMENT12: SAMPLE
SEGMENT13: SAMPLE
SEGMENT14: SAMPLE
SEGMENT15: SAMPLE
SEGMENT16: SAMPLE
SEGMENT17: SAMPLE
SEGMENT18: SAMPLE
SEGMENT19: SAMPLE
SEGMENT20: SAMPLE
TRAN_CODE: SAMPLE
POSTING_ID: 1
REASON_CODE: SAMPLE
REFERENCE_ID: SAMPLE
LINE_GROUP_NO: 1
NON_MERCH_CODE: SAMPLE
ODI_SESSION_NUM: 1
SET_OF_BOOKS_ID: 1
CREATE_DATE_TIME: 2026-01-01
PRORATE_ACROSS_FLAG: S
LINE_TYPE_LOOKUP_CODE: SAMPLE
SELF_ASSESSED_TAX_IND: SAMPLE
BASIC_TRANSACTION_CODE: SAMPLE
REASON_CODE_DESCRIPTION: SAMPLE
NON_MRCH_CODE_DESCRIPTION: SAMPLE
BASIC_TRANSACTION_CODE_DESC: SAMPLE

default

AMOUNT: 12.5000
DOC_ID: 1000000003
SEQ_NO: 4
ORG_UNIT: 3
SEGMENT1: IM Ap Stage Detail Hist-0
SEGMENT2: IM Ap Stage Detail Hist-0
SEGMENT3: IM Ap Stage Detail Hist-0
SEGMENT4: IM Ap Stage Detail Hist-0
SEGMENT5: IM Ap Stage Detail Hist-0
SEGMENT6: IM Ap Stage Detail Hist-0
SEGMENT7: IM Ap Stage Detail Hist-0
SEGMENT8: IM Ap Stage Detail Hist-0
SEGMENT9: IM Ap Stage Detail Hist-0
VAT_CODE: ALT-IM
VAT_RATE: 12.5000000000
SEGMENT10: IM Ap Stage Detail Hist-0
SEGMENT11: IM Ap Stage Detail Hist-0
SEGMENT12: IM Ap Stage Detail Hist-0
SEGMENT13: IM Ap Stage Detail Hist-0
SEGMENT14: IM Ap Stage Detail Hist-0
SEGMENT15: IM Ap Stage Detail Hist-0
SEGMENT16: IM Ap Stage Detail Hist-0
SEGMENT17: IM Ap Stage Detail Hist-0
SEGMENT18: IM Ap Stage Detail Hist-0
SEGMENT19: IM Ap Stage Detail Hist-0
SEGMENT20: IM Ap Stage Detail Hist-0
TRAN_CODE: ALT-IM
POSTING_ID: 1000000003
REASON_CODE: ALT-IM_AP-002
REFERENCE_ID: ALT-IM_AP-002
LINE_GROUP_NO: 4
NON_MERCH_CODE: ALT-IM
ODI_SESSION_NUM: 4
SET_OF_BOOKS_ID: 1000000003
CREATE_DATE_TIME: 2026-01-03
PRORATE_ACROSS_FLAG: I
LINE_TYPE_LOOKUP_CODE: ALT-IM_AP-002
SELF_ASSESSED_TAX_IND: IM Ap Stage Detail Hist-002-ALT
BASIC_TRANSACTION_CODE: ALT-IM
REASON_CODE_DESCRIPTION: IM Ap Stage Detail Hist: Alternate source profile
NON_MRCH_CODE_DESCRIPTION: IM Ap Stage Detail Hist: Alternate source profile
BASIC_TRANSACTION_CODE_DESC: IM Ap Stage Detail Hist-002-ALT

default

AMOUNT: 14.0000
DOC_ID: 1000000005
SEQ_NO: 6
ORG_UNIT: 5
SEGMENT1: IM Ap Stage Detail Hist-0
SEGMENT2: IM Ap Stage Detail Hist-0
SEGMENT3: IM Ap Stage Detail Hist-0
SEGMENT4: IM Ap Stage Detail Hist-0
SEGMENT5: IM Ap Stage Detail Hist-0
SEGMENT6: IM Ap Stage Detail Hist-0
SEGMENT7: IM Ap Stage Detail Hist-0
SEGMENT8: IM Ap Stage Detail Hist-0
SEGMENT9: IM Ap Stage Detail Hist-0
VAT_CODE: EDGE-I
VAT_RATE: 14.0000000000
SEGMENT10: IM Ap Stage Detail Hist-0
SEGMENT11: IM Ap Stage Detail Hist-0
SEGMENT12: IM Ap Stage Detail Hist-0
SEGMENT13: IM Ap Stage Detail Hist-0
SEGMENT14: IM Ap Stage Detail Hist-0
SEGMENT15: IM Ap Stage Detail Hist-0
SEGMENT16: IM Ap Stage Detail Hist-0
SEGMENT17: IM Ap Stage Detail Hist-0
SEGMENT18: IM Ap Stage Detail Hist-0
SEGMENT19: IM Ap Stage Detail Hist-0
SEGMENT20: IM Ap Stage Detail Hist-0
TRAN_CODE: EDGE-I
POSTING_ID: 1000000005
REASON_CODE: EDGE-IM_AP-003
REFERENCE_ID: —
LINE_GROUP_NO: 6
NON_MERCH_CODE: EDGE-I
ODI_SESSION_NUM: 6
SET_OF_BOOKS_ID: 1000000005
CREATE_DATE_TIME: 2026-01-05
PRORATE_ACROSS_FLAG: I
LINE_TYPE_LOOKUP_CODE: EDGE-IM_AP-003
SELF_ASSESSED_TAX_IND: IM Ap Stage Detail Hist-003-EDGE
BASIC_TRANSACTION_CODE: EDGE-I
REASON_CODE_DESCRIPTION: —
NON_MRCH_CODE_DESCRIPTION: —
BASIC_TRANSACTION_CODE_DESC: IM Ap Stage Detail Hist-003-EDGE

Rule Validation Summary

Source Rule Count: 47
Governed Rule Count: 41

All objects