Document Reference Attributes

In Scope

Technical: IM_FDG_DOC_REF | ID: OR-IM-IM_FDG_DOC_REF-IM_FDG_DOCUMENT_REFERENCE

Stores reference attributes associated with the documents.

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_FDG_DOC_REF

Field Definitions(5)

Rules & Considerations(15)

constraint

validation

Sample Load Data(4)

_scenario	DOC_IDR	REF_IDRPK	PROCESS_IDR	LEVEL_ID	REF_CODE	REF_TYPE	CREATE_BY	LEVEL_CODE	LAST_UPDATE_BY	CREATE_DATETIME	LAST_UPDATE_DATETIME
Example values from field definitions	1	1	1	1	SAMPLE	SAMPLE	SAMPLE	SAMPLE	SAMPLE	2026-01-01	2026-01-01
default	1000000003	1000000003	1000000003	1000000003	ALT-IM_FDG-002	IM Fdg	CLIENT_INFO	ALT-IM	CLIENT_INFO	2026-01-03	2026-01-03
default	1000000005	1000000005	1000000005	1000000005	EDGE-IM_FDG-003	IM Fdg	SE SSION_USER	EDGE-I	SE SSION_USER	2026-01-05	2026-01-05

Example values from field definitions

DOC_IDR: 1
REF_IDRPK: 1
PROCESS_IDR: 1
LEVEL_ID: 1
REF_CODE: SAMPLE
REF_TYPE: SAMPLE
CREATE_BY: SAMPLE
LEVEL_CODE: SAMPLE
LAST_UPDATE_BY: SAMPLE
CREATE_DATETIME: 2026-01-01
LAST_UPDATE_DATETIME: 2026-01-01

default

DOC_IDR: 1000000003
REF_IDRPK: 1000000003
PROCESS_IDR: 1000000003
LEVEL_ID: 1000000003
REF_CODE: ALT-IM_FDG-002
REF_TYPE: IM Fdg
CREATE_BY: CLIENT_INFO
LEVEL_CODE: ALT-IM
LAST_UPDATE_BY: CLIENT_INFO
CREATE_DATETIME: 2026-01-03
LAST_UPDATE_DATETIME: 2026-01-03

default

DOC_IDR: 1000000005
REF_IDRPK: 1000000005
PROCESS_IDR: 1000000005
LEVEL_ID: 1000000005
REF_CODE: EDGE-IM_FDG-003
REF_TYPE: IM Fdg
CREATE_BY: SE SSION_USER
LEVEL_CODE: EDGE-I
LAST_UPDATE_BY: SE SSION_USER
CREATE_DATETIME: 2026-01-05
LAST_UPDATE_DATETIME: 2026-01-05

Rule Validation Summary

Source Rule Count: 25
Governed Rule Count: 15