IM Ap Stage Header

In Scope

Technical: IM_AP_STAGE_HEAD | ID: OR-IM-IM_AP_STAGE_HEAD-IM_AP_STAGE_HEADER

Invoice Matching AP staging headers for supplier invoice documents posted to Oracle Financials, including supplier, vendor site, currency, and exchange-rate details.

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

Field Definitions(5)

Sample Load Data(4)

Example values from field definitions

DOC_IDR
1
SEQ_NORPK
1
VENDORR
SAMPLE
INVC_TYPE_LOOKUP_CODER
SAMPLE
AMOUNT
1.0000
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
INVOICE_RECEIVED_DATE
2026-01-01

default

DOC_IDR
1000000003
SEQ_NORPK
4
VENDORR
IM Ap Stag
INVC_TYPE_LOOKUP_CODER
ALT-IM_AP-002
AMOUNT
12.5000
DEAL_ID
1000000003
DSD_IND
I
DOC_DATE
2026-01-03
LOCATION
3
LOC_NAME
IM Ap Stage Head Secondary
LOC_TYPE
I
ORDER_NO
4
ORG_UNIT
3
SEGMENT1
IM Ap Stage Head-002-ALT
SEGMENT2
IM Ap Stage Head-002-ALT
SEGMENT3
IM Ap Stage Head-002-ALT
SEGMENT4
IM Ap Stage Head-002-ALT
SEGMENT5
IM Ap Stage Head-002-ALT
SEGMENT6
IM Ap Stage Head-002-ALT
SEGMENT7
IM Ap Stage Head-002-ALT
SEGMENT8
IM Ap Stage Head-002-ALT
SEGMENT9
IM Ap Stage Head-002-ALT
DEAL_TYPE
I
FISCAL_ID
ALT-IM_AP-002
SEGMENT10
IM Ap Stage Head-002-ALT
SEGMENT11
IM Ap Stage Head-002-ALT
SEGMENT12
IM Ap Stage Head-002-ALT
SEGMENT13
IM Ap Stage Head-002-ALT
SEGMENT14
IM Ap Stage Head-002-ALT
SEGMENT15
IM Ap Stage Head-002-ALT
SEGMENT16
IM Ap Stage Head-002-ALT
SEGMENT17
IM Ap Stage Head-002-ALT
SEGMENT18
IM Ap Stage Head-002-ALT
SEGMENT19
IM Ap Stage Head-002-ALT
SEGMENT20
IM Ap Stage Head-002-ALT
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-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-002-ALT
INVOICE_NUMBER
IM Ap Stage Head-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-002-ALT
CUSTOM_DOC_REF_2
IM Ap Stage Head-002-ALT
CUSTOM_DOC_REF_3
IM Ap Stage Head-002-ALT
CUSTOM_DOC_REF_4
IM Ap Stage Head-002-ALT
THIRD_PARTY_PAYEE
3
ATTACHMENT_EXT_URL
IM Ap Stage Head-002-ALT
EXCHANGE_RATE_TYPE
IM Ap Stage Head-002-ALT
ADDITIONAL_ORDER_NOS
IM Ap Stage Head-002-ALT
INVOICE_RECEIVED_DATE
2026-01-03

default

DOC_IDR
1000000005
SEQ_NORPK
6
VENDORR
IM Ap Stag
INVC_TYPE_LOOKUP_CODER
EDGE-IM_AP-003
AMOUNT
14.0000
DEAL_ID
1000000005
DSD_IND
I
DOC_DATE
2026-01-05
LOCATION
5
LOC_NAME
IM Ap Stage Head Core
LOC_TYPE
I
ORDER_NO
6
ORG_UNIT
5
SEGMENT1
IM Ap Stage Head-003-EDGE
SEGMENT2
IM Ap Stage Head-003-EDGE
SEGMENT3
IM Ap Stage Head-003-EDGE
SEGMENT4
IM Ap Stage Head-003-EDGE
SEGMENT5
IM Ap Stage Head-003-EDGE
SEGMENT6
IM Ap Stage Head-003-EDGE
SEGMENT7
IM Ap Stage Head-003-EDGE
SEGMENT8
IM Ap Stage Head-003-EDGE
SEGMENT9
IM Ap Stage Head-003-EDGE
DEAL_TYPE
I
FISCAL_ID
EDGE-IM_AP-003
SEGMENT10
IM Ap Stage Head-003-EDGE
SEGMENT11
IM Ap Stage Head-003-EDGE
SEGMENT12
IM Ap Stage Head-003-EDGE
SEGMENT13
IM Ap Stage Head-003-EDGE
SEGMENT14
IM Ap Stage Head-003-EDGE
SEGMENT15
IM Ap Stage Head-003-EDGE
SEGMENT16
IM Ap Stage Head-003-EDGE
SEGMENT17
IM Ap Stage Head-003-EDGE
SEGMENT18
IM Ap Stage Head-003-EDGE
SEGMENT19
IM Ap Stage Head-003-EDGE
SEGMENT20
IM Ap Stage Head-003-EDGE
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-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-003-EDGE
INVOICE_NUMBER
IM Ap Stage Head-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-003-EDGE
CUSTOM_DOC_REF_2
IM Ap Stage Head-003-EDGE
CUSTOM_DOC_REF_3
IM Ap Stage Head-003-EDGE
CUSTOM_DOC_REF_4
IM Ap Stage Head-003-EDGE
THIRD_PARTY_PAYEE
5
ATTACHMENT_EXT_URL
IM Ap Stage Head-003-EDGE
EXCHANGE_RATE_TYPE
IM Ap Stage Head-003-EDGE
ADDITIONAL_ORDER_NOS
IM Ap Stage Head-003-EDGE
INVOICE_RECEIVED_DATE
2026-01-05

Rule Validation Summary

Source Rule Count
72
Governed Rule Count
66