IM System Options

In Scope

Technical: IM_SYSTEM_OPTIONS | ID: OR-IM-IM_SYSTEM_OPTIONS

Stores configuration settings and processing options for IM system options in Oracle Retail Invoice Matching. These values control system behavior, integration settings, validation rules, or runtime defaults used by invoice…

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

Information Type: Configuration

Target Structure

Load Approach: Table
Target Objects: IM_SYSTEM_OPTIONS

Field Definitions(86)

Rules & Considerations(285)

Sample Load Data(4)

_scenario	DFLT_SOBPK	DFLT_DEPTPK	CREATED_BYR	CREATION_DATER	DOC_HIST_DAYSR	NUM_TAX_ALLOWR	OBIEE_ENABLEDR	CALC_TOLERANCER	CNT_TOMOR_CRITR	CNT_TOMOR_WARNR	CNT_TOTAL_CRITR	CNT_TOTAL_WARNR	LUW_AUTO_MATCHR	S9T_PURGE_DAYSR	ALLOWANCE_MATCHR	DFLT_HEADER_TAXR	GL_MAX_SEGMENTSR	LAST_UPDATED_BYR	LUW_FDG_EXTRACTR	DOC_QTY_DECIMALSR	LAST_UPDATE_DATER	LUW_EDI_INJECTORR	BATCH_DATE_FORMATR	CNT_PAST_DUE_CRITR	CNT_PAST_DUE_WARNR	MAX_TOLERANCE_PCTR	OBJECT_VERSION_IDR	CALC_TOLERANCE_INDR	CNT_2DAYS_OUT_CRITR	CNT_2DAYS_OUT_WARNR	CNT_3DAYS_OUT_CRITR	CNT_3DAYS_OUT_WARNR	POST_ON_DOC_HEADERR	TOTAL_QTY_REQUIREDR	USE_SUFFIX_ON_DOCSR	DOCUMENT_SEARCH_MAXR	EDI_DATA_PURGE_DAYSR	POST_DATED_DOC_DAYSR	RESOLUTION_DUE_DAYSR	TAX_VALIDATION_TYPER	DAYS_BEFORE_DUE_DATER	DEAL_DOCS_PURGE_DAYSR	DEBIT_MEMO_SEND_DAYSR	DFLT_QTY_OVERBILL_RCPK	DEBIT_MEMO_PREFIX_QTYR	DEBIT_MEMO_PREFIX_TAXR	DFLT_COST_OVERBILL_RCPK	DFLT_QTY_UNDERBILL_RCPK	CALC_EXCHANGE_RATE_VARR	CREDIT_MEMO_PREFIX_QTYR	DEBIT_MEMO_PREFIX_COSTR	DFLT_COST_UNDERBILL_RCPK	DFLT_PAY_NOW_TERMS_RTVPK	DOCUMENTATION_SUMM_INDR	RECEIPT_WRITE_OFF_DAYSR	STATUS_DATA_PURGE_DAYSR	BATCH_THREAD_TIMEOUT_MSR	CLOSE_OPEN_RECEIPT_DAYSR	CREDIT_MEMO_PREFIX_COSTR	DEBIT_MEMO_PREFIX_ALLOWR	TAX_RESOLUTION_DUE_DAYSR	THIRD_PARTY_PAYEE_ALLOWR	CREDIT_MEMO_PREFIX_ALLOWR	DFLT_PAY_NOW_TERMS_DEALSPK	MATCH_INQUIRY_SEARCH_MAXR	PRORATE_ACROSS_TAX_CODESR	POST_INTRA_REGION_TAX_INDR	TAX_DOCUMENT_CREATION_LVLR	CREDIT_NOTE_REQ_PREFIX_QTYR	CREDIT_NOTE_REQ_PREFIX_TAXR	ALWAYS_USE_PO_EXCHANGE_RATER	CREDIT_NOTE_REQ_PREFIX_COSTR	EXCL_PRFX_ON_EXTL_SRCD_DOCSR	EXTERNAL_ACCOUNT_VALIDATIONR	CREDIT_NOTE_REQ_PREFIX_ALLOWR	INCL_DOC_DATE_FOR_DUPL_CHECKR	INCL_DOC_YEAR_FOR_DUPL_CHECKR	USE_INV_RCV_DT_TO_CALC_DUE_DTR	DFLT_CLASS	BALANCING_TOLERANCE	WS_FIN_ACC_VALID_URL	WS_FIN_DRILL_FWD_URL	WS_FIN_ACC_VALID_CRED	WS_FIN_DRILL_FWD_CRED	DFLT_NON_MERCH_LOCATION	DELAY_LN_MTCH_UNTL_ROUTE_
default	1	1001	RETAIL_C TX	2026-01-01	non	S	N	11.0000	000001	000001	000001	000001	1	01	N	IM System Options-001	01	RETAIL_C TX	000001	1	2026-01-01	1	yyyyMMddHHmmss	000001	000001	11.0000	1000000001	A	000001	000001	000001	000001	N	N	N	1	001	001	001	RECON	001	001	non	IM System Options-001	IM System Options-001	IM System Options-001	IM System Options-001	IM System Options-001	N	IM System Options-001	IM System Options-001	IM System Options-001	IM System Options-001	N	001	001	1	non	IM System Options-001	DMA	non	N	CMA	IM System Options-001	1	N	N	ITEM	IM System Options-001	IM System Options-001	Y	IM System Options-001	N	N	CNA	N	N	N	1101	1	IM System Options-001	IM System Options-001	IM System Options-001	IM System Options-001	1	Y

default

DFLT_SOBPK: 1
DFLT_DEPTPK: 1001
CREATED_BYR: RETAIL_C TX
CREATION_DATER: 2026-01-01
DOC_HIST_DAYSR: non
NUM_TAX_ALLOWR: S
OBIEE_ENABLEDR: N
CALC_TOLERANCER: 11.0000
CNT_TOMOR_CRITR: 000001
CNT_TOMOR_WARNR: 000001
CNT_TOTAL_CRITR: 000001
CNT_TOTAL_WARNR: 000001
LUW_AUTO_MATCHR: 1
S9T_PURGE_DAYSR: 01
ALLOWANCE_MATCHR: N
DFLT_HEADER_TAXR: IM System Options-001
GL_MAX_SEGMENTSR: 01
LAST_UPDATED_BYR: RETAIL_C TX
LUW_FDG_EXTRACTR: 000001
DOC_QTY_DECIMALSR: 1
LAST_UPDATE_DATER: 2026-01-01
LUW_EDI_INJECTORR: 1
BATCH_DATE_FORMATR: yyyyMMddHHmmss
CNT_PAST_DUE_CRITR: 000001
CNT_PAST_DUE_WARNR: 000001
MAX_TOLERANCE_PCTR: 11.0000
OBJECT_VERSION_IDR: 1000000001
CALC_TOLERANCE_INDR: A
CNT_2DAYS_OUT_CRITR: 000001
CNT_2DAYS_OUT_WARNR: 000001
CNT_3DAYS_OUT_CRITR: 000001
CNT_3DAYS_OUT_WARNR: 000001
POST_ON_DOC_HEADERR: N
TOTAL_QTY_REQUIREDR: N
USE_SUFFIX_ON_DOCSR: N
DOCUMENT_SEARCH_MAXR: 1
EDI_DATA_PURGE_DAYSR: 001
POST_DATED_DOC_DAYSR: 001
RESOLUTION_DUE_DAYSR: 001
TAX_VALIDATION_TYPER: RECON
DAYS_BEFORE_DUE_DATER: 001
DEAL_DOCS_PURGE_DAYSR: 001
DEBIT_MEMO_SEND_DAYSR: non
DFLT_QTY_OVERBILL_RCPK: IM System Options-001
DEBIT_MEMO_PREFIX_QTYR: IM System Options-001
DEBIT_MEMO_PREFIX_TAXR: IM System Options-001
DFLT_COST_OVERBILL_RCPK: IM System Options-001
DFLT_QTY_UNDERBILL_RCPK: IM System Options-001
CALC_EXCHANGE_RATE_VARR: N
CREDIT_MEMO_PREFIX_QTYR: IM System Options-001
DEBIT_MEMO_PREFIX_COSTR: IM System Options-001
DFLT_COST_UNDERBILL_RCPK: IM System Options-001
DFLT_PAY_NOW_TERMS_RTVPK: IM System Options-001
DOCUMENTATION_SUMM_INDR: N
RECEIPT_WRITE_OFF_DAYSR: 001
STATUS_DATA_PURGE_DAYSR: 001
BATCH_THREAD_TIMEOUT_MSR: 1
CLOSE_OPEN_RECEIPT_DAYSR: non
CREDIT_MEMO_PREFIX_COSTR: IM System Options-001
DEBIT_MEMO_PREFIX_ALLOWR: DMA
TAX_RESOLUTION_DUE_DAYSR: non
THIRD_PARTY_PAYEE_ALLOWR: N
CREDIT_MEMO_PREFIX_ALLOWR: CMA
DFLT_PAY_NOW_TERMS_DEALSPK: IM System Options-001
MATCH_INQUIRY_SEARCH_MAXR: 1
PRORATE_ACROSS_TAX_CODESR: N
POST_INTRA_REGION_TAX_INDR: N
TAX_DOCUMENT_CREATION_LVLR: ITEM
CREDIT_NOTE_REQ_PREFIX_QTYR: IM System Options-001
CREDIT_NOTE_REQ_PREFIX_TAXR: IM System Options-001
ALWAYS_USE_PO_EXCHANGE_RATER: Y
CREDIT_NOTE_REQ_PREFIX_COSTR: IM System Options-001
EXCL_PRFX_ON_EXTL_SRCD_DOCSR: N
EXTERNAL_ACCOUNT_VALIDATIONR: N
CREDIT_NOTE_REQ_PREFIX_ALLOWR: CNA
INCL_DOC_DATE_FOR_DUPL_CHECKR: N
INCL_DOC_YEAR_FOR_DUPL_CHECKR: N
USE_INV_RCV_DT_TO_CALC_DUE_DTR: N
DFLT_CLASS: 1101
BALANCING_TOLERANCE: 1
WS_FIN_ACC_VALID_URL: IM System Options-001
WS_FIN_DRILL_FWD_URL: IM System Options-001
WS_FIN_ACC_VALID_CRED: IM System Options-001
WS_FIN_DRILL_FWD_CRED: IM System Options-001
DFLT_NON_MERCH_LOCATION: 1
DELAY_LN_MTCH_UNTL_ROUTE_: Y

All objects