IM Doc Head
In ScopeTechnical: IM_DOC_HEAD | ID: OR-IM-IM_DOC_HEAD
Oracle Retail history and operational measures captured at location grain, including returns to vendor and cost measures.
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
Target Structure
- Load Approach
- Table
- Target Objects
- IM_DOC_HEAD
Field Definitions(80)
Rules & Considerations(216)
Sample Load Data(4)
| _scenario | TYPER | TERMSR | DOC_IDRPK | STATUSR | VENDORR | DSD_INDR | ERS_INDR | REF_DOCPK | RTV_INDR | DOC_DATER | DUE_DATER | LOCATIONR | TOTAL_QTYR | CREATED_BYR | DOC_SOURCER | EXT_DOC_IDR | TOTAL_COSTR | HEADER_ONLYR | HOLD_STATUSR | VENDOR_TYPER | PRE_PAID_INDR | CREATION_DATER | CURRENCY_CODER | EXCHANGE_RATER | COST_PRE_MATCHR | DETAIL_MATCHEDR | CONSIGNMENT_INDR | LAST_UPDATED_BYR | REVERSE_VAT_INDR | TERMS_DSCNT_PCTR | EDI_DOWNLOAD_INDR | LAST_UPDATE_DATER | MANUALLY_PAID_INDR | OBJECT_VERSION_IDR | THIRD_PARTY_PAYEEPK | TOTAL_COST_INC_TAXR | PENDING_FISCAL_APPRR | RESOLUTION_ADJUSTED_TOTAL_QTYR | RESOLUTION_ADJUSTED_TOTAL_COSTR | DEAL_ID | GROUP_ID | LOC_TYPE | MATCH_ID | ORDER_NO | DEAL_TYPE | FISCAL_ID | PARENT_ID | POST_DATE | BEST_TERMS | MATCH_DATE | MATCH_TYPE | APPROVAL_ID | DOC_SEQ_NUM | PRE_PAID_ID | REF_AUTH_NO | FREIGHT_TYPE | RTV_ORDER_NO | SEQ_GROUP_ID | APPROVAL_DATE | DISCOUNT_DATE | PRE_PAID_DATE | DEAL_DETAIL_ID | DOC_SEQ_PREFIX | PAYMENT_METHOD | TOTAL_DISCOUNT | BEST_TERMS_DATE | CUSTOM_DOC_REF_1 | CUSTOM_DOC_REF_2 | CUSTOM_DOC_REF_3 | CUSTOM_DOC_REF_4 | SUPPLIER_SITE_ID | BEST_TERMS_SOURCE | REF_CNR_EXT_DOC_ID | REF_INV_EXT_DOC_ID | TRANSMISSION_NUMBER | TAX_DISC_CREATE_DATE | INVOICE_RECEIVED_DATE | BEST_TERMS_DATE_SOURCE | VARIANCE_WITHIN_TOLERANCE | EXTRACT_TIMESTAMPNTIMESTAMP(6)1176RECEIVING_AUTHORITY |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| default | IM Doc Head-001 | IM Doc Head-001 | 1000000001 | ACTIVE | IM Doc Head-001 | N | N | 1 | IM Doc Head-001 | 2026-01-01 | 2026-01-01 | 1 | 11.0000 | RETAIL_C TX | IM Doc Head-001 | STD-IM_DOC-001 | 11.0000 | IM Doc Head-001 | N | bk | Y | 2026-01-01 | STD-IM_DOC-001 | 11.0000 | pre | IM Doc Head-001 | N | RETAIL_C TX | N | 11.0000 | IM Doc Head-001 | 2026-01-01 | Y | 1000000001 | 1 | 11.0000 | N | 11.0000 | 11.0000 | 1000000001 | 1000000001 | s | STD-IM_DOC-001 | 2 | IM Doc Head-001 | STD-IM_DOC-001 | 1000000001 | 2026-01-01 | IM Doc Head-001 | 2026-01-01 | IM Doc Head-001 | STD-IM_DOC-001 | 2 | STD-IM_DOC-001 | 2 | IM Doc Head-001 | 2 | 1000000001 | 2026-01-01 | 2026-01-01 | 2026-01-01 | 1000000001 | IM Doc Head-001 | IM Doc Head-001 | 11.0000 | 2026-01-01 | IM Doc Head-001 | IM Doc Head-001 | IM Doc Head-001 | IM Doc Head-001 | STD-IM_DOC-001 | IM Doc Head-001 | STD-IM_DOC-001 | STD-IM_DOC-001 | 1 | 2026-01-01 | 2026-01-01 | 2026-01-01 | 11.0000 | IM Doc Head-001 |
default
- TYPER
- IM Doc Head-001
- TERMSR
- IM Doc Head-001
- DOC_IDRPK
- 1000000001
- STATUSR
- ACTIVE
- VENDORR
- IM Doc Head-001
- DSD_INDR
- N
- ERS_INDR
- N
- REF_DOCPK
- 1
- RTV_INDR
- IM Doc Head-001
- DOC_DATER
- 2026-01-01
- DUE_DATER
- 2026-01-01
- LOCATIONR
- 1
- TOTAL_QTYR
- 11.0000
- CREATED_BYR
- RETAIL_C TX
- DOC_SOURCER
- IM Doc Head-001
- EXT_DOC_IDR
- STD-IM_DOC-001
- TOTAL_COSTR
- 11.0000
- HEADER_ONLYR
- IM Doc Head-001
- HOLD_STATUSR
- N
- VENDOR_TYPER
- bk
- PRE_PAID_INDR
- Y
- CREATION_DATER
- 2026-01-01
- CURRENCY_CODER
- STD-IM_DOC-001
- EXCHANGE_RATER
- 11.0000
- COST_PRE_MATCHR
- pre
- DETAIL_MATCHEDR
- IM Doc Head-001
- CONSIGNMENT_INDR
- N
- LAST_UPDATED_BYR
- RETAIL_C TX
- REVERSE_VAT_INDR
- N
- TERMS_DSCNT_PCTR
- 11.0000
- EDI_DOWNLOAD_INDR
- IM Doc Head-001
- LAST_UPDATE_DATER
- 2026-01-01
- MANUALLY_PAID_INDR
- Y
- OBJECT_VERSION_IDR
- 1000000001
- THIRD_PARTY_PAYEEPK
- 1
- TOTAL_COST_INC_TAXR
- 11.0000
- PENDING_FISCAL_APPRR
- N
- RESOLUTION_ADJUSTED_TOTAL_QTYR
- 11.0000
- RESOLUTION_ADJUSTED_TOTAL_COSTR
- 11.0000
- DEAL_ID
- 1000000001
- GROUP_ID
- 1000000001
- LOC_TYPE
- s
- MATCH_ID
- STD-IM_DOC-001
- ORDER_NO
- 2
- DEAL_TYPE
- IM Doc Head-001
- FISCAL_ID
- STD-IM_DOC-001
- PARENT_ID
- 1000000001
- POST_DATE
- 2026-01-01
- BEST_TERMS
- IM Doc Head-001
- MATCH_DATE
- 2026-01-01
- MATCH_TYPE
- IM Doc Head-001
- APPROVAL_ID
- STD-IM_DOC-001
- DOC_SEQ_NUM
- 2
- PRE_PAID_ID
- STD-IM_DOC-001
- REF_AUTH_NO
- 2
- FREIGHT_TYPE
- IM Doc Head-001
- RTV_ORDER_NO
- 2
- SEQ_GROUP_ID
- 1000000001
- APPROVAL_DATE
- 2026-01-01
- DISCOUNT_DATE
- 2026-01-01
- PRE_PAID_DATE
- 2026-01-01
- DEAL_DETAIL_ID
- 1000000001
- DOC_SEQ_PREFIX
- IM Doc Head-001
- PAYMENT_METHOD
- IM Doc Head-001
- TOTAL_DISCOUNT
- 11.0000
- BEST_TERMS_DATE
- 2026-01-01
- CUSTOM_DOC_REF_1
- IM Doc Head-001
- CUSTOM_DOC_REF_2
- IM Doc Head-001
- CUSTOM_DOC_REF_3
- IM Doc Head-001
- CUSTOM_DOC_REF_4
- IM Doc Head-001
- SUPPLIER_SITE_ID
- STD-IM_DOC-001
- BEST_TERMS_SOURCE
- IM Doc Head-001
- REF_CNR_EXT_DOC_ID
- STD-IM_DOC-001
- REF_INV_EXT_DOC_ID
- STD-IM_DOC-001
- TRANSMISSION_NUMBER
- 1
- TAX_DISC_CREATE_DATE
- 2026-01-01
- INVOICE_RECEIVED_DATE
- 2026-01-01
- BEST_TERMS_DATE_SOURCE
- 2026-01-01
- VARIANCE_WITHIN_TOLERANCE
- 11.0000
- EXTRACT_TIMESTAMPNTIMESTAMP(6)1176RECEIVING_AUTHORITY
- IM Doc Head-001