Ap_Stage_Head Data
In ScopeTechnical: IM_BDI_AP_STAGE_HEAD_OUT | ID: OR-IM-IM_BDI_AP_STAGE_HEAD_OUT-IM_BDI_AP_STAGE_HEADER_OUT
This BDI integration table holds the AP_STAGE_HEAD data.
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_BDI_AP_STAGE_HEAD_OUT
Field Definitions(5)
Sample Load Data(4)
| _scenario | SEQ_NOR | BDI_SEQ_IDRPK | BDI_APP_NAMERPK | AMOUNT | DOC_ID | VENDOR | DOC_DATE | ORG_UNIT | SEGMENT1 | SEGMENT2 | SEGMENT3 | SEGMENT4 | SEGMENT5 | SEGMENT6 | SEGMENT7 | SEGMENT8 | SEGMENT9 | SEGMENT10 | SEGMENT11 | SEGMENT12 | SEGMENT13 | SEGMENT14 | SEGMENT15 | SEGMENT16 | SEGMENT17 | SEGMENT18 | SEGMENT19 | SEGMENT20 | BEST_TERMS | POSTING_ID | REFERENCE_ID | CURRENCY_CODE | EXCHANGE_RATE | INVOICE_NUMBER | ORACLE_SITE_ID | BEST_TERMS_DATE | ODI_SESSION_NUM | SET_OF_BOOKS_ID | BDI_DATASET_TYPE | CREATE_DATE_TIME | BDI_DATASET_ACTION | EXCHANGE_RATE_TYPE | INVC_TYPE_LOOKUP_CODE |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| Example values from field definitions | 1 | 1 | SAMPLE | 1.0000 | 1 | SAMPLE | 2026-01-01 | 1 | SAMPLE | SAMPLE | SAMPLE | SAMPLE | SAMPLE | SAMPLE | SAMPLE | SAMPLE | SAMPLE | SAMPLE | SAMPLE | SAMPLE | SAMPLE | SAMPLE | SAMPLE | SAMPLE | SAMPLE | SAMPLE | SAMPLE | SAMPLE | SAMPLE | 1 | SAMPLE | SAM | 1.0000000000 | SAMPLE | 1 | 2026-01-01 | 1 | 1 | SAMPLE | 2026-01-01 | SAMPLE | SAMPLE | SAMPLE |
| default | 4 | 1000000003 | current_schema | 12.5000 | 1000000003 | IM Bdi Ap | 2026-01-03 | 3 | IM Bdi Ap Stage Head Out- | IM Bdi Ap Stage Head Out- | IM Bdi Ap Stage Head Out- | IM Bdi Ap Stage Head Out- | IM Bdi Ap Stage Head Out- | IM Bdi Ap Stage Head Out- | IM Bdi Ap Stage Head Out- | IM Bdi Ap Stage Head Out- | IM Bdi Ap Stage Head Out- | IM Bdi Ap Stage Head Out- | IM Bdi Ap Stage Head Out- | IM Bdi Ap Stage Head Out- | IM Bdi Ap Stage Head Out- | IM Bdi Ap Stage Head Out- | IM Bdi Ap Stage Head Out- | IM Bdi Ap Stage Head Out- | IM Bdi Ap Stage Head Out- | IM Bdi Ap Stage Head Out- | IM Bdi Ap Stage Head Out- | IM Bdi Ap Stage Head Out- | IM Bdi Ap Stage | 1000000003 | ALT-IM_BDI-002 | ALT | 12.5000000000 | IM Bdi Ap Stage Head Out-002-ALT | 1000000003 | 2026-01-03 | 4 | 1000000003 | FULL | 2026-01-03 | REPLACE | IM Bdi Ap Stage Head Out-002-A | ALT-IM_BDI-002 |
| default | 6 | 1000000005 | userenv | 14.0000 | 1000000005 | IM Bdi Ap | 2026-01-05 | 5 | IM Bdi Ap Stage Head Out- | IM Bdi Ap Stage Head Out- | IM Bdi Ap Stage Head Out- | IM Bdi Ap Stage Head Out- | IM Bdi Ap Stage Head Out- | IM Bdi Ap Stage Head Out- | IM Bdi Ap Stage Head Out- | IM Bdi Ap Stage Head Out- | IM Bdi Ap Stage Head Out- | IM Bdi Ap Stage Head Out- | IM Bdi Ap Stage Head Out- | IM Bdi Ap Stage Head Out- | IM Bdi Ap Stage Head Out- | IM Bdi Ap Stage Head Out- | IM Bdi Ap Stage Head Out- | IM Bdi Ap Stage Head Out- | IM Bdi Ap Stage Head Out- | IM Bdi Ap Stage Head Out- | IM Bdi Ap Stage Head Out- | IM Bdi Ap Stage Head Out- | IM Bdi Ap Stage | 1000000005 | — | EDG | 14.0000000000 | IM Bdi Ap Stage Head Out-003-EDGE | 1000000005 | 2026-01-05 | 6 | 1000000005 | FULL | 2026-01-05 | REPLACE | IM Bdi Ap Stage Head Out-003-E | EDGE-IM_BDI-003 |
Example values from field definitions
- SEQ_NOR
- 1
- BDI_SEQ_IDRPK
- 1
- BDI_APP_NAMERPK
- SAMPLE
- AMOUNT
- 1.0000
- DOC_ID
- 1
- VENDOR
- SAMPLE
- DOC_DATE
- 2026-01-01
- ORG_UNIT
- 1
- SEGMENT1
- SAMPLE
- SEGMENT2
- SAMPLE
- SEGMENT3
- SAMPLE
- SEGMENT4
- SAMPLE
- SEGMENT5
- SAMPLE
- SEGMENT6
- SAMPLE
- SEGMENT7
- SAMPLE
- SEGMENT8
- SAMPLE
- SEGMENT9
- 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
- POSTING_ID
- 1
- REFERENCE_ID
- SAMPLE
- CURRENCY_CODE
- SAM
- EXCHANGE_RATE
- 1.0000000000
- INVOICE_NUMBER
- SAMPLE
- ORACLE_SITE_ID
- 1
- BEST_TERMS_DATE
- 2026-01-01
- ODI_SESSION_NUM
- 1
- SET_OF_BOOKS_ID
- 1
- BDI_DATASET_TYPE
- SAMPLE
- CREATE_DATE_TIME
- 2026-01-01
- BDI_DATASET_ACTION
- SAMPLE
- EXCHANGE_RATE_TYPE
- SAMPLE
- INVC_TYPE_LOOKUP_CODE
- SAMPLE
default
- SEQ_NOR
- 4
- BDI_SEQ_IDRPK
- 1000000003
- BDI_APP_NAMERPK
- current_schema
- AMOUNT
- 12.5000
- DOC_ID
- 1000000003
- VENDOR
- IM Bdi Ap
- DOC_DATE
- 2026-01-03
- ORG_UNIT
- 3
- SEGMENT1
- IM Bdi Ap Stage Head Out-
- SEGMENT2
- IM Bdi Ap Stage Head Out-
- SEGMENT3
- IM Bdi Ap Stage Head Out-
- SEGMENT4
- IM Bdi Ap Stage Head Out-
- SEGMENT5
- IM Bdi Ap Stage Head Out-
- SEGMENT6
- IM Bdi Ap Stage Head Out-
- SEGMENT7
- IM Bdi Ap Stage Head Out-
- SEGMENT8
- IM Bdi Ap Stage Head Out-
- SEGMENT9
- IM Bdi Ap Stage Head Out-
- SEGMENT10
- IM Bdi Ap Stage Head Out-
- SEGMENT11
- IM Bdi Ap Stage Head Out-
- SEGMENT12
- IM Bdi Ap Stage Head Out-
- SEGMENT13
- IM Bdi Ap Stage Head Out-
- SEGMENT14
- IM Bdi Ap Stage Head Out-
- SEGMENT15
- IM Bdi Ap Stage Head Out-
- SEGMENT16
- IM Bdi Ap Stage Head Out-
- SEGMENT17
- IM Bdi Ap Stage Head Out-
- SEGMENT18
- IM Bdi Ap Stage Head Out-
- SEGMENT19
- IM Bdi Ap Stage Head Out-
- SEGMENT20
- IM Bdi Ap Stage Head Out-
- BEST_TERMS
- IM Bdi Ap Stage
- POSTING_ID
- 1000000003
- REFERENCE_ID
- ALT-IM_BDI-002
- CURRENCY_CODE
- ALT
- EXCHANGE_RATE
- 12.5000000000
- INVOICE_NUMBER
- IM Bdi Ap Stage Head Out-002-ALT
- ORACLE_SITE_ID
- 1000000003
- BEST_TERMS_DATE
- 2026-01-03
- ODI_SESSION_NUM
- 4
- SET_OF_BOOKS_ID
- 1000000003
- BDI_DATASET_TYPE
- FULL
- CREATE_DATE_TIME
- 2026-01-03
- BDI_DATASET_ACTION
- REPLACE
- EXCHANGE_RATE_TYPE
- IM Bdi Ap Stage Head Out-002-A
- INVC_TYPE_LOOKUP_CODE
- ALT-IM_BDI-002
default
- SEQ_NOR
- 6
- BDI_SEQ_IDRPK
- 1000000005
- BDI_APP_NAMERPK
- userenv
- AMOUNT
- 14.0000
- DOC_ID
- 1000000005
- VENDOR
- IM Bdi Ap
- DOC_DATE
- 2026-01-05
- ORG_UNIT
- 5
- SEGMENT1
- IM Bdi Ap Stage Head Out-
- SEGMENT2
- IM Bdi Ap Stage Head Out-
- SEGMENT3
- IM Bdi Ap Stage Head Out-
- SEGMENT4
- IM Bdi Ap Stage Head Out-
- SEGMENT5
- IM Bdi Ap Stage Head Out-
- SEGMENT6
- IM Bdi Ap Stage Head Out-
- SEGMENT7
- IM Bdi Ap Stage Head Out-
- SEGMENT8
- IM Bdi Ap Stage Head Out-
- SEGMENT9
- IM Bdi Ap Stage Head Out-
- SEGMENT10
- IM Bdi Ap Stage Head Out-
- SEGMENT11
- IM Bdi Ap Stage Head Out-
- SEGMENT12
- IM Bdi Ap Stage Head Out-
- SEGMENT13
- IM Bdi Ap Stage Head Out-
- SEGMENT14
- IM Bdi Ap Stage Head Out-
- SEGMENT15
- IM Bdi Ap Stage Head Out-
- SEGMENT16
- IM Bdi Ap Stage Head Out-
- SEGMENT17
- IM Bdi Ap Stage Head Out-
- SEGMENT18
- IM Bdi Ap Stage Head Out-
- SEGMENT19
- IM Bdi Ap Stage Head Out-
- SEGMENT20
- IM Bdi Ap Stage Head Out-
- BEST_TERMS
- IM Bdi Ap Stage
- POSTING_ID
- 1000000005
- REFERENCE_ID
- —
- CURRENCY_CODE
- EDG
- EXCHANGE_RATE
- 14.0000000000
- INVOICE_NUMBER
- IM Bdi Ap Stage Head Out-003-EDGE
- ORACLE_SITE_ID
- 1000000005
- BEST_TERMS_DATE
- 2026-01-05
- ODI_SESSION_NUM
- 6
- SET_OF_BOOKS_ID
- 1000000005
- BDI_DATASET_TYPE
- FULL
- CREATE_DATE_TIME
- 2026-01-05
- BDI_DATASET_ACTION
- REPLACE
- EXCHANGE_RATE_TYPE
- IM Bdi Ap Stage Head Out-003-E
- INVC_TYPE_LOOKUP_CODE
- EDGE-IM_BDI-003
Rule Validation Summary
- Source Rule Count
- 64
- Governed Rule Count
- 52