IM Posting Document

In Scope

Technical: IM_POSTING_DOC | ID: OR-IM-IM_POSTING_DOC-IM_POSTING_DOCUMENT

Stores document-related data for IM posting doc in Oracle Retail Invoice Matching, supporting creation, validation, matching, or downstream processing of business documents used in invoice matching.

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_POSTING_DOC

Field Definitions(5)

Rules & Considerations(33)

Sample Load Data(4)

_scenario	DOC_IDRPK	POSTING_IDRPK	VENDOR	DEAL_ID	DOC_DATE	DOC_TYPE	LOCATION	LOC_TYPE	ORDER_NO	PARENT_ID	BEST_TERMS	CALC_BASIS	EXT_DOC_ID	HAS_ERRORS	MATCH_TYPE	SYS_TAX_IND	VENDOR_TYPE	DEFAULT_DEPT	PRE_PAID_IND	CURRENCY_CODE	CURRENCY_RATE	DEFAULT_CLASS	DOC_TAX_COUNT	DECIMAL_DIGITS	BEST_TERMS_DATE	SET_OF_BOOKS_ID	RESOLUTION_COUNT	MANUALLY_PAID_IND	SYS_CURRENCY_CODE	CURRENCY_RATE_TYPE
Example values from field definitions	1	1	SAMPLE	1	2026-01-01	SAMPLE	1	S	1	1	SAMPLE	SAMPLE	SAMPLE	S	SAMPLE	S	SAMPLE	1	S	SAM	1.0000	1	1	1	2026-01-01	1	1	S	SAM	SAMPLE
default	1000000003	1000000003	IM Posting	1000000003	2026-01-03	IM Pos	3	I	4	1000000003	IM Posting Doc-	IM Posting Doc-002-ALT	ALT-IM_POSTING-002	N	IM Posting Doc-002-A	N	IM Pos	1003	I	ALT	12.5000	1103	3	3	2026-01-03	1000000003	3	I	ALT	IM Posting Doc-002-ALT
default	1000000005	1000000005	IM Posting	1000000005	2026-01-05	IM Pos	5	I	6	1000000005	IM Posting Doc-	IM Posting Doc-003-EDGE	EDGE-IM_POSTING-003	N	IM Posting Doc-003-E	N	IM Pos	1005	I	EDG	14.0000	1105	5	5	2026-01-05	1000000005	5	I	EDG	IM Posting Doc-003-EDGE

Example values from field definitions

DOC_IDRPK: 1
POSTING_IDRPK: 1
VENDOR: SAMPLE
DEAL_ID: 1
DOC_DATE: 2026-01-01
DOC_TYPE: SAMPLE
LOCATION: 1
LOC_TYPE: S
ORDER_NO: 1
PARENT_ID: 1
BEST_TERMS: SAMPLE
CALC_BASIS: SAMPLE
EXT_DOC_ID: SAMPLE
HAS_ERRORS: S
MATCH_TYPE: SAMPLE
SYS_TAX_IND: S
VENDOR_TYPE: SAMPLE
DEFAULT_DEPT: 1
PRE_PAID_IND: S
CURRENCY_CODE: SAM
CURRENCY_RATE: 1.0000
DEFAULT_CLASS: 1
DOC_TAX_COUNT: 1
DECIMAL_DIGITS: 1
BEST_TERMS_DATE: 2026-01-01
SET_OF_BOOKS_ID: 1
RESOLUTION_COUNT: 1
MANUALLY_PAID_IND: S
SYS_CURRENCY_CODE: SAM
CURRENCY_RATE_TYPE: SAMPLE

default

DOC_IDRPK: 1000000003
POSTING_IDRPK: 1000000003
VENDOR: IM Posting
DEAL_ID: 1000000003
DOC_DATE: 2026-01-03
DOC_TYPE: IM Pos
LOCATION: 3
LOC_TYPE: I
ORDER_NO: 4
PARENT_ID: 1000000003
BEST_TERMS: IM Posting Doc-
CALC_BASIS: IM Posting Doc-002-ALT
EXT_DOC_ID: ALT-IM_POSTING-002
HAS_ERRORS: N
MATCH_TYPE: IM Posting Doc-002-A
SYS_TAX_IND: N
VENDOR_TYPE: IM Pos
DEFAULT_DEPT: 1003
PRE_PAID_IND: I
CURRENCY_CODE: ALT
CURRENCY_RATE: 12.5000
DEFAULT_CLASS: 1103
DOC_TAX_COUNT: 3
DECIMAL_DIGITS: 3
BEST_TERMS_DATE: 2026-01-03
SET_OF_BOOKS_ID: 1000000003
RESOLUTION_COUNT: 3
MANUALLY_PAID_IND: I
SYS_CURRENCY_CODE: ALT
CURRENCY_RATE_TYPE: IM Posting Doc-002-ALT

default

DOC_IDRPK: 1000000005
POSTING_IDRPK: 1000000005
VENDOR: IM Posting
DEAL_ID: 1000000005
DOC_DATE: 2026-01-05
DOC_TYPE: IM Pos
LOCATION: 5
LOC_TYPE: I
ORDER_NO: 6
PARENT_ID: 1000000005
BEST_TERMS: IM Posting Doc-
CALC_BASIS: IM Posting Doc-003-EDGE
EXT_DOC_ID: EDGE-IM_POSTING-003
HAS_ERRORS: N
MATCH_TYPE: IM Posting Doc-003-E
SYS_TAX_IND: N
VENDOR_TYPE: IM Pos
DEFAULT_DEPT: 1005
PRE_PAID_IND: I
CURRENCY_CODE: EDG
CURRENCY_RATE: 14.0000
DEFAULT_CLASS: 1105
DOC_TAX_COUNT: 5
DECIMAL_DIGITS: 5
BEST_TERMS_DATE: 2026-01-05
SET_OF_BOOKS_ID: 1000000005
RESOLUTION_COUNT: 5
MANUALLY_PAID_IND: I
SYS_CURRENCY_CODE: EDG
CURRENCY_RATE_TYPE: IM Posting Doc-003-EDGE

Rule Validation Summary

Source Rule Count: 43
Governed Rule Count: 33

All objects