IM Ap Stage Detail
In ScopeTechnical: IM_AP_STAGE_DETAIL | ID: OR-IM-IM_AP_STAGE_DETAIL-IM_AP_STAGE_DETAIL
Invoice Matching 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
Field Definitions(5)
Sample Load Data(4)
| _scenario | AMOUNTR | DOC_IDRPK | SEQ_NORPK | TRAN_CODER | LINE_TYPE_LOOKUP_CODER | 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 | 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 | 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 | SAMPLE | SAMPLE | 1 | SAMPLE | SAMPLE | SAMPLE | SAMPLE | SAMPLE | SAMPLE | SAMPLE | SAMPLE | SAMPLE | SAMPLE | 1.0000000000 | 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 |
| default | 12.5000 | 1000000003 | 4 | ALT-IM | ALT-IM_AP-002 | 3 | IM Ap Stage Detail-002-AL | IM Ap Stage Detail-002-AL | IM Ap Stage Detail-002-AL | IM Ap Stage Detail-002-AL | IM Ap Stage Detail-002-AL | IM Ap Stage Detail-002-AL | IM Ap Stage Detail-002-AL | IM Ap Stage Detail-002-AL | IM Ap Stage Detail-002-AL | ALT-IM | 12.5000000000 | IM Ap Stage Detail-002-AL | IM Ap Stage Detail-002-AL | IM Ap Stage Detail-002-AL | IM Ap Stage Detail-002-AL | IM Ap Stage Detail-002-AL | IM Ap Stage Detail-002-AL | IM Ap Stage Detail-002-AL | IM Ap Stage Detail-002-AL | IM Ap Stage Detail-002-AL | IM Ap Stage Detail-002-AL | IM Ap Stage Detail-002-AL | 1000000003 | ALT-IM_AP-002 | ALT-IM_AP-002 | 4 | ALT-IM | 4 | 1000000003 | 2026-01-03 | N | IM Ap Stage Detail-002-ALT | ALT-IM | IM Ap Stage Detail: Alternate source profile | IM Ap Stage Detail: Alternate source profile | IM Ap Stage Detail-002-ALT |
| default | 14.0000 | 1000000005 | 6 | EDGE-I | EDGE-IM_AP-003 | 5 | IM Ap Stage Detail-003-ED | IM Ap Stage Detail-003-ED | IM Ap Stage Detail-003-ED | IM Ap Stage Detail-003-ED | IM Ap Stage Detail-003-ED | IM Ap Stage Detail-003-ED | IM Ap Stage Detail-003-ED | IM Ap Stage Detail-003-ED | IM Ap Stage Detail-003-ED | EDGE-I | 14.0000000000 | IM Ap Stage Detail-003-ED | IM Ap Stage Detail-003-ED | IM Ap Stage Detail-003-ED | IM Ap Stage Detail-003-ED | IM Ap Stage Detail-003-ED | IM Ap Stage Detail-003-ED | IM Ap Stage Detail-003-ED | IM Ap Stage Detail-003-ED | IM Ap Stage Detail-003-ED | IM Ap Stage Detail-003-ED | IM Ap Stage Detail-003-ED | 1000000005 | EDGE-IM_AP-003 | — | 6 | EDGE-I | 6 | 1000000005 | 2026-01-05 | N | IM Ap Stage Detail-003-EDGE | EDGE-I | — | — | IM Ap Stage Detail-003-EDGE |
Example values from field definitions
- AMOUNTR
- 1.0000
- DOC_IDRPK
- 1
- SEQ_NORPK
- 1
- TRAN_CODER
- SAMPLE
- LINE_TYPE_LOOKUP_CODER
- SAMPLE
- 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
- 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
- SELF_ASSESSED_TAX_IND
- SAMPLE
- BASIC_TRANSACTION_CODE
- SAMPLE
- REASON_CODE_DESCRIPTION
- SAMPLE
- NON_MRCH_CODE_DESCRIPTION
- SAMPLE
- BASIC_TRANSACTION_CODE_DESC
- SAMPLE
default
- AMOUNTR
- 12.5000
- DOC_IDRPK
- 1000000003
- SEQ_NORPK
- 4
- TRAN_CODER
- ALT-IM
- LINE_TYPE_LOOKUP_CODER
- ALT-IM_AP-002
- ORG_UNIT
- 3
- SEGMENT1
- IM Ap Stage Detail-002-AL
- SEGMENT2
- IM Ap Stage Detail-002-AL
- SEGMENT3
- IM Ap Stage Detail-002-AL
- SEGMENT4
- IM Ap Stage Detail-002-AL
- SEGMENT5
- IM Ap Stage Detail-002-AL
- SEGMENT6
- IM Ap Stage Detail-002-AL
- SEGMENT7
- IM Ap Stage Detail-002-AL
- SEGMENT8
- IM Ap Stage Detail-002-AL
- SEGMENT9
- IM Ap Stage Detail-002-AL
- VAT_CODE
- ALT-IM
- VAT_RATE
- 12.5000000000
- SEGMENT10
- IM Ap Stage Detail-002-AL
- SEGMENT11
- IM Ap Stage Detail-002-AL
- SEGMENT12
- IM Ap Stage Detail-002-AL
- SEGMENT13
- IM Ap Stage Detail-002-AL
- SEGMENT14
- IM Ap Stage Detail-002-AL
- SEGMENT15
- IM Ap Stage Detail-002-AL
- SEGMENT16
- IM Ap Stage Detail-002-AL
- SEGMENT17
- IM Ap Stage Detail-002-AL
- SEGMENT18
- IM Ap Stage Detail-002-AL
- SEGMENT19
- IM Ap Stage Detail-002-AL
- SEGMENT20
- IM Ap Stage Detail-002-AL
- 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
- N
- SELF_ASSESSED_TAX_IND
- IM Ap Stage Detail-002-ALT
- BASIC_TRANSACTION_CODE
- ALT-IM
- REASON_CODE_DESCRIPTION
- IM Ap Stage Detail: Alternate source profile
- NON_MRCH_CODE_DESCRIPTION
- IM Ap Stage Detail: Alternate source profile
- BASIC_TRANSACTION_CODE_DESC
- IM Ap Stage Detail-002-ALT
default
- AMOUNTR
- 14.0000
- DOC_IDRPK
- 1000000005
- SEQ_NORPK
- 6
- TRAN_CODER
- EDGE-I
- LINE_TYPE_LOOKUP_CODER
- EDGE-IM_AP-003
- ORG_UNIT
- 5
- SEGMENT1
- IM Ap Stage Detail-003-ED
- SEGMENT2
- IM Ap Stage Detail-003-ED
- SEGMENT3
- IM Ap Stage Detail-003-ED
- SEGMENT4
- IM Ap Stage Detail-003-ED
- SEGMENT5
- IM Ap Stage Detail-003-ED
- SEGMENT6
- IM Ap Stage Detail-003-ED
- SEGMENT7
- IM Ap Stage Detail-003-ED
- SEGMENT8
- IM Ap Stage Detail-003-ED
- SEGMENT9
- IM Ap Stage Detail-003-ED
- VAT_CODE
- EDGE-I
- VAT_RATE
- 14.0000000000
- SEGMENT10
- IM Ap Stage Detail-003-ED
- SEGMENT11
- IM Ap Stage Detail-003-ED
- SEGMENT12
- IM Ap Stage Detail-003-ED
- SEGMENT13
- IM Ap Stage Detail-003-ED
- SEGMENT14
- IM Ap Stage Detail-003-ED
- SEGMENT15
- IM Ap Stage Detail-003-ED
- SEGMENT16
- IM Ap Stage Detail-003-ED
- SEGMENT17
- IM Ap Stage Detail-003-ED
- SEGMENT18
- IM Ap Stage Detail-003-ED
- SEGMENT19
- IM Ap Stage Detail-003-ED
- SEGMENT20
- IM Ap Stage Detail-003-ED
- 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
- N
- SELF_ASSESSED_TAX_IND
- IM Ap Stage Detail-003-EDGE
- BASIC_TRANSACTION_CODE
- EDGE-I
- REASON_CODE_DESCRIPTION
- —
- NON_MRCH_CODE_DESCRIPTION
- —
- BASIC_TRANSACTION_CODE_DESC
- IM Ap Stage Detail-003-EDGE
Rule Validation Summary
- Source Rule Count
- 59
- Governed Rule Count
- 51