IM Ap Stage Header History

In Scope

Technical: IM_AP_STAGE_HEAD_HIST | ID: OR-IM-IM_AP_STAGE_HEAD_HIST-IM_AP_STAGE_HEADER_HISTORY

This is a history table for the IM_AP_STAGE_HEAD table.

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_HEAD_HIST

Field Definitions(5)

Sample Load Data(4)

_scenario	AMOUNT	DOC_ID	SEQ_NO	VENDOR	DEAL_ID	DSD_IND	DOC_DATE	LOCATION	LOC_NAME	LOC_TYPE	ORDER_NO	ORG_UNIT	SEGMENT1	SEGMENT2	SEGMENT3	SEGMENT4	SEGMENT5	SEGMENT6	SEGMENT7	SEGMENT8	SEGMENT9	DEAL_TYPE	FISCAL_ID	SEGMENT10	SEGMENT11	SEGMENT12	SEGMENT13	SEGMENT14	SEGMENT15	SEGMENT16	SEGMENT17	SEGMENT18	SEGMENT19	SEGMENT20	BEST_TERMS	MATCH_DATE	POSTING_ID	DOC_SEQ_NUM	DATE_CREATED	LEGAL_ENTITY	REFERENCE_ID	RTV_ORDER_NO	APPROVAL_DATE	CURRENCY_CODE	EXCHANGE_RATE	DEAL_DETAIL_ID	DOC_SEQ_PREFIX	INVOICE_NUMBER	ORACLE_SITE_ID	BEST_TERMS_DATE	CONSIGNMENT_IND	ODI_SESSION_NUM	SET_OF_BOOKS_ID	CREATE_DATE_TIME	CUSTOM_DOC_REF_1	CUSTOM_DOC_REF_2	CUSTOM_DOC_REF_3	CUSTOM_DOC_REF_4	THIRD_PARTY_PAYEE	ATTACHMENT_EXT_URL	EXCHANGE_RATE_TYPE	ADDITIONAL_ORDER_NOS	INVC_TYPE_LOOKUP_CODE	INVOICE_RECEIVED_DATE
Example values from field definitions	1.0000	1	1	SAMPLE	1	S	2026-01-01	1	SAMPLE	S	1	1	SAMPLE	SAMPLE	SAMPLE	SAMPLE	SAMPLE	SAMPLE	SAMPLE	SAMPLE	SAMPLE	S	SAMPLE	SAMPLE	SAMPLE	SAMPLE	SAMPLE	SAMPLE	SAMPLE	SAMPLE	SAMPLE	SAMPLE	SAMPLE	SAMPLE	SAMPLE	2026-01-01	1	1	2026-01-01	SAMPLE	SAMPLE	1	2026-01-01	SAM	1.0000000000	1	SAMPLE	SAMPLE	1	2026-01-01	S	1	1	2026-01-01	SAMPLE	SAMPLE	SAMPLE	SAMPLE	1	SAMPLE	SAMPLE	SAMPLE	SAMPLE	2026-01-01
default	12.5000	1000000003	4	IM Ap Stag	1000000003	I	2026-01-03	3	IM Ap Stage Head Hist Secondary	I	4	3	IM Ap Stage Head Hist-002	IM Ap Stage Head Hist-002	IM Ap Stage Head Hist-002	IM Ap Stage Head Hist-002	IM Ap Stage Head Hist-002	IM Ap Stage Head Hist-002	IM Ap Stage Head Hist-002	IM Ap Stage Head Hist-002	IM Ap Stage Head Hist-002	I	ALT-IM_AP-002	IM Ap Stage Head Hist-002	IM Ap Stage Head Hist-002	IM Ap Stage Head Hist-002	IM Ap Stage Head Hist-002	IM Ap Stage Head Hist-002	IM Ap Stage Head Hist-002	IM Ap Stage Head Hist-002	IM Ap Stage Head Hist-002	IM Ap Stage Head Hist-002	IM Ap Stage Head Hist-002	IM Ap Stage Head Hist-002	IM Ap Stage Hea	2026-01-03	1000000003	4	2026-01-03	IM Ap Stage Head Hist-002-ALT	ALT-IM_AP-002	4	2026-01-03	ALT	12.5000000000	1000000003	IM Ap Stage Head Hist-002-ALT	IM Ap Stage Head Hist-002-ALT	1000000003	2026-01-03	I	4	1000000003	2026-01-03	IM Ap Stage Head Hist-002-ALT	IM Ap Stage Head Hist-002-ALT	IM Ap Stage Head Hist-002-ALT	IM Ap Stage Head Hist-002-ALT	3	IM Ap Stage Head Hist-002-ALT	IM Ap Stage Head Hist-002-ALT	IM Ap Stage Head Hist-002-ALT	ALT-IM_AP-002	2026-01-03
default	14.0000	1000000005	6	IM Ap Stag	1000000005	I	2026-01-05	5	IM Ap Stage Head Hist Core	I	6	5	IM Ap Stage Head Hist-003	IM Ap Stage Head Hist-003	IM Ap Stage Head Hist-003	IM Ap Stage Head Hist-003	IM Ap Stage Head Hist-003	IM Ap Stage Head Hist-003	IM Ap Stage Head Hist-003	IM Ap Stage Head Hist-003	IM Ap Stage Head Hist-003	I	EDGE-IM_AP-003	IM Ap Stage Head Hist-003	IM Ap Stage Head Hist-003	IM Ap Stage Head Hist-003	IM Ap Stage Head Hist-003	IM Ap Stage Head Hist-003	IM Ap Stage Head Hist-003	IM Ap Stage Head Hist-003	IM Ap Stage Head Hist-003	IM Ap Stage Head Hist-003	IM Ap Stage Head Hist-003	IM Ap Stage Head Hist-003	IM Ap Stage Hea	2026-01-05	1000000005	6	2026-01-05	IM Ap Stage Head Hist-003-EDGE	—	6	2026-01-05	EDG	14.0000000000	1000000005	IM Ap Stage Head Hist-003-EDGE	IM Ap Stage Head Hist-003-EDGE	1000000005	2026-01-05	I	6	1000000005	2026-01-05	IM Ap Stage Head Hist-003-EDGE	IM Ap Stage Head Hist-003-EDGE	IM Ap Stage Head Hist-003-EDGE	IM Ap Stage Head Hist-003-EDGE	5	IM Ap Stage Head Hist-003-EDGE	IM Ap Stage Head Hist-003-EDGE	IM Ap Stage Head Hist-003-EDGE	EDGE-IM_AP-003	2026-01-05

Example values from field definitions

AMOUNT: 1.0000
DOC_ID: 1
SEQ_NO: 1
VENDOR: SAMPLE
DEAL_ID: 1
DSD_IND: S
DOC_DATE: 2026-01-01
LOCATION: 1
LOC_NAME: SAMPLE
LOC_TYPE: S
ORDER_NO: 1
ORG_UNIT: 1
SEGMENT1: SAMPLE
SEGMENT2: SAMPLE
SEGMENT3: SAMPLE
SEGMENT4: SAMPLE
SEGMENT5: SAMPLE
SEGMENT6: SAMPLE
SEGMENT7: SAMPLE
SEGMENT8: SAMPLE
SEGMENT9: SAMPLE
DEAL_TYPE: S
FISCAL_ID: SAMPLE
SEGMENT10: SAMPLE
SEGMENT11: SAMPLE
SEGMENT12: SAMPLE
SEGMENT13: SAMPLE
SEGMENT14: SAMPLE
SEGMENT15: SAMPLE
SEGMENT16: SAMPLE
SEGMENT17: SAMPLE
SEGMENT18: SAMPLE
SEGMENT19: SAMPLE
SEGMENT20: SAMPLE
BEST_TERMS: SAMPLE
MATCH_DATE: 2026-01-01
POSTING_ID: 1
DOC_SEQ_NUM: 1
DATE_CREATED: 2026-01-01
LEGAL_ENTITY: SAMPLE
REFERENCE_ID: SAMPLE
RTV_ORDER_NO: 1
APPROVAL_DATE: 2026-01-01
CURRENCY_CODE: SAM
EXCHANGE_RATE: 1.0000000000
DEAL_DETAIL_ID: 1
DOC_SEQ_PREFIX: SAMPLE
INVOICE_NUMBER: SAMPLE
ORACLE_SITE_ID: 1
BEST_TERMS_DATE: 2026-01-01
CONSIGNMENT_IND: S
ODI_SESSION_NUM: 1
SET_OF_BOOKS_ID: 1
CREATE_DATE_TIME: 2026-01-01
CUSTOM_DOC_REF_1: SAMPLE
CUSTOM_DOC_REF_2: SAMPLE
CUSTOM_DOC_REF_3: SAMPLE
CUSTOM_DOC_REF_4: SAMPLE
THIRD_PARTY_PAYEE: 1
ATTACHMENT_EXT_URL: SAMPLE
EXCHANGE_RATE_TYPE: SAMPLE
ADDITIONAL_ORDER_NOS: SAMPLE
INVC_TYPE_LOOKUP_CODE: SAMPLE
INVOICE_RECEIVED_DATE: 2026-01-01

default

AMOUNT: 12.5000
DOC_ID: 1000000003
SEQ_NO: 4
VENDOR: IM Ap Stag
DEAL_ID: 1000000003
DSD_IND: I
DOC_DATE: 2026-01-03
LOCATION: 3
LOC_NAME: IM Ap Stage Head Hist Secondary
LOC_TYPE: I
ORDER_NO: 4
ORG_UNIT: 3
SEGMENT1: IM Ap Stage Head Hist-002
SEGMENT2: IM Ap Stage Head Hist-002
SEGMENT3: IM Ap Stage Head Hist-002
SEGMENT4: IM Ap Stage Head Hist-002
SEGMENT5: IM Ap Stage Head Hist-002
SEGMENT6: IM Ap Stage Head Hist-002
SEGMENT7: IM Ap Stage Head Hist-002
SEGMENT8: IM Ap Stage Head Hist-002
SEGMENT9: IM Ap Stage Head Hist-002
DEAL_TYPE: I
FISCAL_ID: ALT-IM_AP-002
SEGMENT10: IM Ap Stage Head Hist-002
SEGMENT11: IM Ap Stage Head Hist-002
SEGMENT12: IM Ap Stage Head Hist-002
SEGMENT13: IM Ap Stage Head Hist-002
SEGMENT14: IM Ap Stage Head Hist-002
SEGMENT15: IM Ap Stage Head Hist-002
SEGMENT16: IM Ap Stage Head Hist-002
SEGMENT17: IM Ap Stage Head Hist-002
SEGMENT18: IM Ap Stage Head Hist-002
SEGMENT19: IM Ap Stage Head Hist-002
SEGMENT20: IM Ap Stage Head Hist-002
BEST_TERMS: IM Ap Stage Hea
MATCH_DATE: 2026-01-03
POSTING_ID: 1000000003
DOC_SEQ_NUM: 4
DATE_CREATED: 2026-01-03
LEGAL_ENTITY: IM Ap Stage Head Hist-002-ALT
REFERENCE_ID: ALT-IM_AP-002
RTV_ORDER_NO: 4
APPROVAL_DATE: 2026-01-03
CURRENCY_CODE: ALT
EXCHANGE_RATE: 12.5000000000
DEAL_DETAIL_ID: 1000000003
DOC_SEQ_PREFIX: IM Ap Stage Head Hist-002-ALT
INVOICE_NUMBER: IM Ap Stage Head Hist-002-ALT
ORACLE_SITE_ID: 1000000003
BEST_TERMS_DATE: 2026-01-03
CONSIGNMENT_IND: I
ODI_SESSION_NUM: 4
SET_OF_BOOKS_ID: 1000000003
CREATE_DATE_TIME: 2026-01-03
CUSTOM_DOC_REF_1: IM Ap Stage Head Hist-002-ALT
CUSTOM_DOC_REF_2: IM Ap Stage Head Hist-002-ALT
CUSTOM_DOC_REF_3: IM Ap Stage Head Hist-002-ALT
CUSTOM_DOC_REF_4: IM Ap Stage Head Hist-002-ALT
THIRD_PARTY_PAYEE: 3
ATTACHMENT_EXT_URL: IM Ap Stage Head Hist-002-ALT
EXCHANGE_RATE_TYPE: IM Ap Stage Head Hist-002-ALT
ADDITIONAL_ORDER_NOS: IM Ap Stage Head Hist-002-ALT
INVC_TYPE_LOOKUP_CODE: ALT-IM_AP-002
INVOICE_RECEIVED_DATE: 2026-01-03

default

AMOUNT: 14.0000
DOC_ID: 1000000005
SEQ_NO: 6
VENDOR: IM Ap Stag
DEAL_ID: 1000000005
DSD_IND: I
DOC_DATE: 2026-01-05
LOCATION: 5
LOC_NAME: IM Ap Stage Head Hist Core
LOC_TYPE: I
ORDER_NO: 6
ORG_UNIT: 5
SEGMENT1: IM Ap Stage Head Hist-003
SEGMENT2: IM Ap Stage Head Hist-003
SEGMENT3: IM Ap Stage Head Hist-003
SEGMENT4: IM Ap Stage Head Hist-003
SEGMENT5: IM Ap Stage Head Hist-003
SEGMENT6: IM Ap Stage Head Hist-003
SEGMENT7: IM Ap Stage Head Hist-003
SEGMENT8: IM Ap Stage Head Hist-003
SEGMENT9: IM Ap Stage Head Hist-003
DEAL_TYPE: I
FISCAL_ID: EDGE-IM_AP-003
SEGMENT10: IM Ap Stage Head Hist-003
SEGMENT11: IM Ap Stage Head Hist-003
SEGMENT12: IM Ap Stage Head Hist-003
SEGMENT13: IM Ap Stage Head Hist-003
SEGMENT14: IM Ap Stage Head Hist-003
SEGMENT15: IM Ap Stage Head Hist-003
SEGMENT16: IM Ap Stage Head Hist-003
SEGMENT17: IM Ap Stage Head Hist-003
SEGMENT18: IM Ap Stage Head Hist-003
SEGMENT19: IM Ap Stage Head Hist-003
SEGMENT20: IM Ap Stage Head Hist-003
BEST_TERMS: IM Ap Stage Hea
MATCH_DATE: 2026-01-05
POSTING_ID: 1000000005
DOC_SEQ_NUM: 6
DATE_CREATED: 2026-01-05
LEGAL_ENTITY: IM Ap Stage Head Hist-003-EDGE
REFERENCE_ID: —
RTV_ORDER_NO: 6
APPROVAL_DATE: 2026-01-05
CURRENCY_CODE: EDG
EXCHANGE_RATE: 14.0000000000
DEAL_DETAIL_ID: 1000000005
DOC_SEQ_PREFIX: IM Ap Stage Head Hist-003-EDGE
INVOICE_NUMBER: IM Ap Stage Head Hist-003-EDGE
ORACLE_SITE_ID: 1000000005
BEST_TERMS_DATE: 2026-01-05
CONSIGNMENT_IND: I
ODI_SESSION_NUM: 6
SET_OF_BOOKS_ID: 1000000005
CREATE_DATE_TIME: 2026-01-05
CUSTOM_DOC_REF_1: IM Ap Stage Head Hist-003-EDGE
CUSTOM_DOC_REF_2: IM Ap Stage Head Hist-003-EDGE
CUSTOM_DOC_REF_3: IM Ap Stage Head Hist-003-EDGE
CUSTOM_DOC_REF_4: IM Ap Stage Head Hist-003-EDGE
THIRD_PARTY_PAYEE: 5
ATTACHMENT_EXT_URL: IM Ap Stage Head Hist-003-EDGE
EXCHANGE_RATE_TYPE: IM Ap Stage Head Hist-003-EDGE
ADDITIONAL_ORDER_NOS: IM Ap Stage Head Hist-003-EDGE
INVC_TYPE_LOOKUP_CODE: EDGE-IM_AP-003
INVOICE_RECEIVED_DATE: 2026-01-05

Rule Validation Summary

Source Rule Count: 63
Governed Rule Count: 57

All objects