IM Document Header
In ScopeTechnical: IM_DOC_HEAD | ID: OR-IM-IM_DOC_HEAD-IM_DOCUMENT_HEADER
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
Classification
- Object Type
- dictionary
Target Structure
- Load Approach
- Table
- Target Objects
- IM_DOC_HEAD
Field Definitions(5)
Rules & Considerations(111)
constraint
validation
Sample Load Data(4)
| _scenario | TYPER | DOC_IDRPK | STATUSR | LOCATIONR | TERMS | VENDOR | DEAL_ID | DSD_IND | ERS_IND | REF_DOC | RTV_IND | DOC_DATE | DUE_DATE | GROUP_ID | LOC_TYPE | MATCH_ID | ORDER_NO | DEAL_TYPE | FISCAL_ID | PARENT_ID | POST_DATE | TOTAL_QTY | BEST_TERMS | CREATED_BY | DOC_SOURCE | EXT_DOC_ID | MATCH_DATE | MATCH_TYPE | TOTAL_COST | APPROVAL_ID | DOC_SEQ_NUM | HEADER_ONLY | HOLD_STATUS | PRE_PAID_ID | REF_AUTH_NO | VENDOR_TYPE | FREIGHT_TYPE | PRE_PAID_IND | RTV_ORDER_NO | SEQ_GROUP_ID | APPROVAL_DATE | CREATION_DATE | CURRENCY_CODE | DISCOUNT_DATE | EXCHANGE_RATE | PRE_PAID_DATE | COST_PRE_MATCH | DEAL_DETAIL_ID | DETAIL_MATCHED | DOC_SEQ_PREFIX | PAYMENT_METHOD | TOTAL_DISCOUNT | BEST_TERMS_DATE | CONSIGNMENT_IND | LAST_UPDATED_BY | REVERSE_VAT_IND | TERMS_DSCNT_PCT | CUSTOM_DOC_REF_1 | CUSTOM_DOC_REF_2 | CUSTOM_DOC_REF_3 | CUSTOM_DOC_REF_4 | EDI_DOWNLOAD_IND | LAST_UPDATE_DATE | SUPPLIER_SITE_ID | BEST_TERMS_SOURCE | MANUALLY_PAID_IND | OBJECT_VERSION_ID | THIRD_PARTY_PAYEE | REF_CNR_EXT_DOC_ID | REF_INV_EXT_DOC_ID | TOTAL_COST_INC_TAX | PENDING_FISCAL_APPR | TRANSMISSION_NUMBER | TAX_DISC_CREATE_DATE | INVOICE_RECEIVED_DATE | BEST_TERMS_DATE_SOURCE | VARIANCE_WITHIN_TOLERANCE | RESOLUTION_ADJUSTED_TOTAL_QTY | RESOLUTION_ADJUSTED_TOTAL_COST | EXTRACT_TIMESTAMPNTIMESTAMP(6)1176RECEIVING_AUTHORITY |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| Example values from field definitions | SAMPLE | 1 | SAMPLE | 1 | SAMPLE | SAMPLE | 1 | S | S | 1 | S | 2026-01-01 | 2026-01-01 | 1 | S | SAMPLE | 1 | S | SAMPLE | 1 | 2026-01-01 | 1.0000 | SAMPLE | SAMPLE | S | SAMPLE | 2026-01-01 | S | 1.0000 | SAMPLE | 1 | S | S | SAMPLE | 1 | SAMPLE | SAMPLE | S | 1 | 1 | 2026-01-01 | 2026-01-01 | SAM | 2026-01-01 | 1.0000000000 | 2026-01-01 | S | 1 | S | SAMPLE | SAMPLE | 1.0000 | 2026-01-01 | S | SAMPLE | S | 1.0000 | SAMPLE | SAMPLE | SAMPLE | SAMPLE | S | 2026-01-01 | SAMPLE | SAMPLE | S | 1 | 1 | SAMPLE | SAMPLE | 1.0000 | S | 1 | 2026-01-01 | 2026-01-01 | SAMPLE | 1.0000 | 1.0000 | 1.0000 | SAMPLE |
| default | IM Doc | 1000000003 | PENDING-AL | 3 | IM Doc Head-002 | IM Doc Hea | 1000000003 | N | N | 3 | I | 2026-01-03 | 2026-01-03 | 1000000003 | s | ALT-IM_DOC-002 | 4 | I | ALT-IM_DOC-002 | 1000000003 | 2026-01-03 | 12.5000 | IM Doc Head-002 | APP_USER_ID | I | ALT-IM_DOC-002 | 2026-01-03 | I | 12.5000 | ALT-IM_DOC-002 | 4 | I | n | ALT-IM_DOC-002 | 4 | bk | IM Doc | N | 4 | 1000000003 | 2026-01-03 | 2026-01-03 | ALT | 2026-01-03 | 12.5000000000 | 2026-01-03 | p | 1000000003 | I | IM Doc Head-002-ALT | IM Doc | 12.5000 | 2026-01-03 | Y | APP_USER_ID | Y | 12.5000 | IM Doc Head-002-ALT | IM Doc Head-002-ALT | IM Doc Head-002-ALT | IM Doc Head-002-ALT | I | 2026-01-03 | ALT-IM_DOC | IM Doc | N | 1000000003 | 3 | ALT-IM_DOC-002 | ALT-IM_DOC-002 | 12.5000 | N | 3 | 2026-01-03 | 2026-01-03 | 2026-0 | 12.5000 | 12.5000 | 12.5000 | IM Doc |
| default | IM Doc | 1000000005 | ACTIVE-EDG | 5 | IM Doc Head-003 | IM Doc Hea | 1000000005 | N | N | 5 | I | 2026-01-05 | 2026-01-05 | 1000000005 | s | EDGE-IM_DOC-003 | 6 | I | EDGE-IM_DOC-003 | 1000000005 | 2026-01-05 | 14.0000 | IM Doc Head-003 | USERENV | I | EDGE-IM_DOC-003 | 2026-01-05 | I | 14.0000 | EDGE-IM_DOC-003 | 6 | I | h | EDGE-IM_DOC-003 | 6 | bk | IM Doc | Y | 6 | 1000000005 | 2026-01-05 | 2026-01-05 | EDG | 2026-01-05 | 14.0000000000 | 2026-01-05 | p | 1000000005 | I | IM Doc Head-003-EDGE | IM Doc | 14.0000 | 2026-01-05 | S | USERENV | N | 14.0000 | IM Doc Head-003-EDGE | IM Doc Head-003-EDGE | IM Doc Head-003-EDGE | IM Doc Head-003-EDGE | I | 2026-01-05 | EDGE-IM_DO | IM Doc | Y | 1000000005 | 5 | EDGE-IM_DOC-003 | EDGE-IM_DOC-003 | 14.0000 | N | 5 | 2026-01-05 | 2026-01-05 | 2026-0 | 14.0000 | 14.0000 | 14.0000 | IM Doc |
Example values from field definitions
- TYPER
- SAMPLE
- DOC_IDRPK
- 1
- STATUSR
- SAMPLE
- LOCATIONR
- 1
- TERMS
- SAMPLE
- VENDOR
- SAMPLE
- DEAL_ID
- 1
- DSD_IND
- S
- ERS_IND
- S
- REF_DOC
- 1
- RTV_IND
- S
- DOC_DATE
- 2026-01-01
- DUE_DATE
- 2026-01-01
- GROUP_ID
- 1
- LOC_TYPE
- S
- MATCH_ID
- SAMPLE
- ORDER_NO
- 1
- DEAL_TYPE
- S
- FISCAL_ID
- SAMPLE
- PARENT_ID
- 1
- POST_DATE
- 2026-01-01
- TOTAL_QTY
- 1.0000
- BEST_TERMS
- SAMPLE
- CREATED_BY
- SAMPLE
- DOC_SOURCE
- S
- EXT_DOC_ID
- SAMPLE
- MATCH_DATE
- 2026-01-01
- MATCH_TYPE
- S
- TOTAL_COST
- 1.0000
- APPROVAL_ID
- SAMPLE
- DOC_SEQ_NUM
- 1
- HEADER_ONLY
- S
- HOLD_STATUS
- S
- PRE_PAID_ID
- SAMPLE
- REF_AUTH_NO
- 1
- VENDOR_TYPE
- SAMPLE
- FREIGHT_TYPE
- SAMPLE
- PRE_PAID_IND
- S
- RTV_ORDER_NO
- 1
- SEQ_GROUP_ID
- 1
- APPROVAL_DATE
- 2026-01-01
- CREATION_DATE
- 2026-01-01
- CURRENCY_CODE
- SAM
- DISCOUNT_DATE
- 2026-01-01
- EXCHANGE_RATE
- 1.0000000000
- PRE_PAID_DATE
- 2026-01-01
- COST_PRE_MATCH
- S
- DEAL_DETAIL_ID
- 1
- DETAIL_MATCHED
- S
- DOC_SEQ_PREFIX
- SAMPLE
- PAYMENT_METHOD
- SAMPLE
- TOTAL_DISCOUNT
- 1.0000
- BEST_TERMS_DATE
- 2026-01-01
- CONSIGNMENT_IND
- S
- LAST_UPDATED_BY
- SAMPLE
- REVERSE_VAT_IND
- S
- TERMS_DSCNT_PCT
- 1.0000
- CUSTOM_DOC_REF_1
- SAMPLE
- CUSTOM_DOC_REF_2
- SAMPLE
- CUSTOM_DOC_REF_3
- SAMPLE
- CUSTOM_DOC_REF_4
- SAMPLE
- EDI_DOWNLOAD_IND
- S
- LAST_UPDATE_DATE
- 2026-01-01
- SUPPLIER_SITE_ID
- SAMPLE
- BEST_TERMS_SOURCE
- SAMPLE
- MANUALLY_PAID_IND
- S
- OBJECT_VERSION_ID
- 1
- THIRD_PARTY_PAYEE
- 1
- REF_CNR_EXT_DOC_ID
- SAMPLE
- REF_INV_EXT_DOC_ID
- SAMPLE
- TOTAL_COST_INC_TAX
- 1.0000
- PENDING_FISCAL_APPR
- S
- TRANSMISSION_NUMBER
- 1
- TAX_DISC_CREATE_DATE
- 2026-01-01
- INVOICE_RECEIVED_DATE
- 2026-01-01
- BEST_TERMS_DATE_SOURCE
- SAMPLE
- VARIANCE_WITHIN_TOLERANCE
- 1.0000
- RESOLUTION_ADJUSTED_TOTAL_QTY
- 1.0000
- RESOLUTION_ADJUSTED_TOTAL_COST
- 1.0000
- EXTRACT_TIMESTAMPNTIMESTAMP(6)1176RECEIVING_AUTHORITY
- SAMPLE
default
- TYPER
- IM Doc
- DOC_IDRPK
- 1000000003
- STATUSR
- PENDING-AL
- LOCATIONR
- 3
- TERMS
- IM Doc Head-002
- VENDOR
- IM Doc Hea
- DEAL_ID
- 1000000003
- DSD_IND
- N
- ERS_IND
- N
- REF_DOC
- 3
- RTV_IND
- I
- DOC_DATE
- 2026-01-03
- DUE_DATE
- 2026-01-03
- GROUP_ID
- 1000000003
- LOC_TYPE
- s
- MATCH_ID
- ALT-IM_DOC-002
- ORDER_NO
- 4
- DEAL_TYPE
- I
- FISCAL_ID
- ALT-IM_DOC-002
- PARENT_ID
- 1000000003
- POST_DATE
- 2026-01-03
- TOTAL_QTY
- 12.5000
- BEST_TERMS
- IM Doc Head-002
- CREATED_BY
- APP_USER_ID
- DOC_SOURCE
- I
- EXT_DOC_ID
- ALT-IM_DOC-002
- MATCH_DATE
- 2026-01-03
- MATCH_TYPE
- I
- TOTAL_COST
- 12.5000
- APPROVAL_ID
- ALT-IM_DOC-002
- DOC_SEQ_NUM
- 4
- HEADER_ONLY
- I
- HOLD_STATUS
- n
- PRE_PAID_ID
- ALT-IM_DOC-002
- REF_AUTH_NO
- 4
- VENDOR_TYPE
- bk
- FREIGHT_TYPE
- IM Doc
- PRE_PAID_IND
- N
- RTV_ORDER_NO
- 4
- SEQ_GROUP_ID
- 1000000003
- APPROVAL_DATE
- 2026-01-03
- CREATION_DATE
- 2026-01-03
- CURRENCY_CODE
- ALT
- DISCOUNT_DATE
- 2026-01-03
- EXCHANGE_RATE
- 12.5000000000
- PRE_PAID_DATE
- 2026-01-03
- COST_PRE_MATCH
- p
- DEAL_DETAIL_ID
- 1000000003
- DETAIL_MATCHED
- I
- DOC_SEQ_PREFIX
- IM Doc Head-002-ALT
- PAYMENT_METHOD
- IM Doc
- TOTAL_DISCOUNT
- 12.5000
- BEST_TERMS_DATE
- 2026-01-03
- CONSIGNMENT_IND
- Y
- LAST_UPDATED_BY
- APP_USER_ID
- REVERSE_VAT_IND
- Y
- TERMS_DSCNT_PCT
- 12.5000
- CUSTOM_DOC_REF_1
- IM Doc Head-002-ALT
- CUSTOM_DOC_REF_2
- IM Doc Head-002-ALT
- CUSTOM_DOC_REF_3
- IM Doc Head-002-ALT
- CUSTOM_DOC_REF_4
- IM Doc Head-002-ALT
- EDI_DOWNLOAD_IND
- I
- LAST_UPDATE_DATE
- 2026-01-03
- SUPPLIER_SITE_ID
- ALT-IM_DOC
- BEST_TERMS_SOURCE
- IM Doc
- MANUALLY_PAID_IND
- N
- OBJECT_VERSION_ID
- 1000000003
- THIRD_PARTY_PAYEE
- 3
- REF_CNR_EXT_DOC_ID
- ALT-IM_DOC-002
- REF_INV_EXT_DOC_ID
- ALT-IM_DOC-002
- TOTAL_COST_INC_TAX
- 12.5000
- PENDING_FISCAL_APPR
- N
- TRANSMISSION_NUMBER
- 3
- TAX_DISC_CREATE_DATE
- 2026-01-03
- INVOICE_RECEIVED_DATE
- 2026-01-03
- BEST_TERMS_DATE_SOURCE
- 2026-0
- VARIANCE_WITHIN_TOLERANCE
- 12.5000
- RESOLUTION_ADJUSTED_TOTAL_QTY
- 12.5000
- RESOLUTION_ADJUSTED_TOTAL_COST
- 12.5000
- EXTRACT_TIMESTAMPNTIMESTAMP(6)1176RECEIVING_AUTHORITY
- IM Doc
default
- TYPER
- IM Doc
- DOC_IDRPK
- 1000000005
- STATUSR
- ACTIVE-EDG
- LOCATIONR
- 5
- TERMS
- IM Doc Head-003
- VENDOR
- IM Doc Hea
- DEAL_ID
- 1000000005
- DSD_IND
- N
- ERS_IND
- N
- REF_DOC
- 5
- RTV_IND
- I
- DOC_DATE
- 2026-01-05
- DUE_DATE
- 2026-01-05
- GROUP_ID
- 1000000005
- LOC_TYPE
- s
- MATCH_ID
- EDGE-IM_DOC-003
- ORDER_NO
- 6
- DEAL_TYPE
- I
- FISCAL_ID
- EDGE-IM_DOC-003
- PARENT_ID
- 1000000005
- POST_DATE
- 2026-01-05
- TOTAL_QTY
- 14.0000
- BEST_TERMS
- IM Doc Head-003
- CREATED_BY
- USERENV
- DOC_SOURCE
- I
- EXT_DOC_ID
- EDGE-IM_DOC-003
- MATCH_DATE
- 2026-01-05
- MATCH_TYPE
- I
- TOTAL_COST
- 14.0000
- APPROVAL_ID
- EDGE-IM_DOC-003
- DOC_SEQ_NUM
- 6
- HEADER_ONLY
- I
- HOLD_STATUS
- h
- PRE_PAID_ID
- EDGE-IM_DOC-003
- REF_AUTH_NO
- 6
- VENDOR_TYPE
- bk
- FREIGHT_TYPE
- IM Doc
- PRE_PAID_IND
- Y
- RTV_ORDER_NO
- 6
- SEQ_GROUP_ID
- 1000000005
- APPROVAL_DATE
- 2026-01-05
- CREATION_DATE
- 2026-01-05
- CURRENCY_CODE
- EDG
- DISCOUNT_DATE
- 2026-01-05
- EXCHANGE_RATE
- 14.0000000000
- PRE_PAID_DATE
- 2026-01-05
- COST_PRE_MATCH
- p
- DEAL_DETAIL_ID
- 1000000005
- DETAIL_MATCHED
- I
- DOC_SEQ_PREFIX
- IM Doc Head-003-EDGE
- PAYMENT_METHOD
- IM Doc
- TOTAL_DISCOUNT
- 14.0000
- BEST_TERMS_DATE
- 2026-01-05
- CONSIGNMENT_IND
- S
- LAST_UPDATED_BY
- USERENV
- REVERSE_VAT_IND
- N
- TERMS_DSCNT_PCT
- 14.0000
- CUSTOM_DOC_REF_1
- IM Doc Head-003-EDGE
- CUSTOM_DOC_REF_2
- IM Doc Head-003-EDGE
- CUSTOM_DOC_REF_3
- IM Doc Head-003-EDGE
- CUSTOM_DOC_REF_4
- IM Doc Head-003-EDGE
- EDI_DOWNLOAD_IND
- I
- LAST_UPDATE_DATE
- 2026-01-05
- SUPPLIER_SITE_ID
- EDGE-IM_DO
- BEST_TERMS_SOURCE
- IM Doc
- MANUALLY_PAID_IND
- Y
- OBJECT_VERSION_ID
- 1000000005
- THIRD_PARTY_PAYEE
- 5
- REF_CNR_EXT_DOC_ID
- EDGE-IM_DOC-003
- REF_INV_EXT_DOC_ID
- EDGE-IM_DOC-003
- TOTAL_COST_INC_TAX
- 14.0000
- PENDING_FISCAL_APPR
- N
- TRANSMISSION_NUMBER
- 5
- TAX_DISC_CREATE_DATE
- 2026-01-05
- INVOICE_RECEIVED_DATE
- 2026-01-05
- BEST_TERMS_DATE_SOURCE
- 2026-0
- VARIANCE_WITHIN_TOLERANCE
- 14.0000
- RESOLUTION_ADJUSTED_TOTAL_QTY
- 14.0000
- RESOLUTION_ADJUSTED_TOTAL_COST
- 14.0000
- EXTRACT_TIMESTAMPNTIMESTAMP(6)1176RECEIVING_AUTHORITY
- IM Doc
Rule Validation Summary
- Source Rule Count
- 157
- Governed Rule Count
- 111