IM Fdg Document Ett

In Scope

Technical: IM_FDG_DOC_ETT | ID: OR-IM-IM_FDG_DOC_ETT-IM_FDG_DOCUMENT_ETT

Stores info about the entities of a document. Location, Vendor/Partner, Third party payee.

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_ETT

Field Definitions(5)

Rules & Considerations(32)

Sample Load Data(4)

_scenario	DOC_IDR	ETT_IDRPK	PROCESS_IDR	CITY	NAME	EMAIL	STATE	STREET	COUNTRY	ETT_CODE	ETT_TYPE	CREATE_BY	TELEPHONE	COMPLEMENT	LEGAL_NAME	POSTAL_CODE	CONTACT_NAME	ETT_DOC_TYPE	ETT_PTNR_TYPE	LAST_UPDATE_BY	CREATE_DATETIME	CARRIER_DRIVER_LN	JURISDICTION_CODE	CARRIER_VEHICLE_RN	CARRIER_DRIVER_NAME	LAST_UPDATE_DATETIME	CARRIER_VEHICLE_STATE	ADDITIONAL_STREET_NAME
Example values from field definitions	1	1	1	SAMPLE	SAMPLE	SAMPLE	SAM	SAMPLE	SAM	SAMPLE	SAMPLE	SAMPLE	SAMPLE	SAMPLE	SAMPLE	SAMPLE	SAMPLE	SAMPLE	SAMPLE	SAMPLE	2026-01-01	SAMPLE	SAMPLE	SAMPLE	SAMPLE	2026-01-01	SAMPLE	SAMPLE
default	1000000003	1000000003	1000000003	IM Fdg Doc Ett-002-ALT	IM Fdg Doc Ett-002-ALT	IM Fdg Doc Ett-002-ALT	IM	IM Fdg Doc Ett-002-ALT	IM	ALT-IM_FDG-002	IM Fdg	CLIENT_INFO	IM Fdg Doc Ett-002-A	IM Fdg Doc Ett-002-ALT	IM Fdg Doc Ett Secondary	ALT-IM_FDG-002	IM Fdg Doc Ett Secondary	IM Fdg	IM Fdg	CLIENT_INFO	2026-01-03	IM Fdg Doc Ett-002-ALT	ALT-IM_FDG-002	IM Fdg Doc Ett-002-ALT	IM Fdg Doc Ett Secondary	2026-01-03	IM Fdg Doc Ett-002-ALT	IM Fdg Doc Ett Secondary
default	1000000005	1000000005	1000000005	IM Fdg Doc Ett-003-EDGE	IM Fdg Doc Ett-003-EDGE	IM Fdg Doc Ett-003-EDGE	IM	IM Fdg Doc Ett-003-EDGE	IM	EDGE-IM_FDG-003	IM Fdg	SE SSION_USER	IM Fdg Doc Ett-003-E	IM Fdg Doc Ett-003-EDGE	IM Fdg Doc Ett Core	EDGE-IM_FDG-003	IM Fdg Doc Ett Core	IM Fdg	IM Fdg	SE SSION_USER	2026-01-05	IM Fdg Doc Ett-003-EDGE	EDGE-IM_FDG-003	IM Fdg Doc Ett-003-EDGE	IM Fdg Doc Ett Core	2026-01-05	IM Fdg Doc Ett-003-EDGE	IM Fdg Doc Ett Core

Example values from field definitions

DOC_IDR: 1
ETT_IDRPK: 1
PROCESS_IDR: 1
CITY: SAMPLE
NAME: SAMPLE
EMAIL: SAMPLE
STATE: SAM
STREET: SAMPLE
COUNTRY: SAM
ETT_CODE: SAMPLE
ETT_TYPE: SAMPLE
CREATE_BY: SAMPLE
TELEPHONE: SAMPLE
COMPLEMENT: SAMPLE
LEGAL_NAME: SAMPLE
POSTAL_CODE: SAMPLE
CONTACT_NAME: SAMPLE
ETT_DOC_TYPE: SAMPLE
ETT_PTNR_TYPE: SAMPLE
LAST_UPDATE_BY: SAMPLE
CREATE_DATETIME: 2026-01-01
CARRIER_DRIVER_LN: SAMPLE
JURISDICTION_CODE: SAMPLE
CARRIER_VEHICLE_RN: SAMPLE
CARRIER_DRIVER_NAME: SAMPLE
LAST_UPDATE_DATETIME: 2026-01-01
CARRIER_VEHICLE_STATE: SAMPLE
ADDITIONAL_STREET_NAME: SAMPLE

default

DOC_IDR: 1000000003
ETT_IDRPK: 1000000003
PROCESS_IDR: 1000000003
CITY: IM Fdg Doc Ett-002-ALT
NAME: IM Fdg Doc Ett-002-ALT
EMAIL: IM Fdg Doc Ett-002-ALT
STATE: IM
STREET: IM Fdg Doc Ett-002-ALT
COUNTRY: IM
ETT_CODE: ALT-IM_FDG-002
ETT_TYPE: IM Fdg
CREATE_BY: CLIENT_INFO
TELEPHONE: IM Fdg Doc Ett-002-A
COMPLEMENT: IM Fdg Doc Ett-002-ALT
LEGAL_NAME: IM Fdg Doc Ett Secondary
POSTAL_CODE: ALT-IM_FDG-002
CONTACT_NAME: IM Fdg Doc Ett Secondary
ETT_DOC_TYPE: IM Fdg
ETT_PTNR_TYPE: IM Fdg
LAST_UPDATE_BY: CLIENT_INFO
CREATE_DATETIME: 2026-01-03
CARRIER_DRIVER_LN: IM Fdg Doc Ett-002-ALT
JURISDICTION_CODE: ALT-IM_FDG-002
CARRIER_VEHICLE_RN: IM Fdg Doc Ett-002-ALT
CARRIER_DRIVER_NAME: IM Fdg Doc Ett Secondary
LAST_UPDATE_DATETIME: 2026-01-03
CARRIER_VEHICLE_STATE: IM Fdg Doc Ett-002-ALT
ADDITIONAL_STREET_NAME: IM Fdg Doc Ett Secondary

default

DOC_IDR: 1000000005
ETT_IDRPK: 1000000005
PROCESS_IDR: 1000000005
CITY: IM Fdg Doc Ett-003-EDGE
NAME: IM Fdg Doc Ett-003-EDGE
EMAIL: IM Fdg Doc Ett-003-EDGE
STATE: IM
STREET: IM Fdg Doc Ett-003-EDGE
COUNTRY: IM
ETT_CODE: EDGE-IM_FDG-003
ETT_TYPE: IM Fdg
CREATE_BY: SE SSION_USER
TELEPHONE: IM Fdg Doc Ett-003-E
COMPLEMENT: IM Fdg Doc Ett-003-EDGE
LEGAL_NAME: IM Fdg Doc Ett Core
POSTAL_CODE: EDGE-IM_FDG-003
CONTACT_NAME: IM Fdg Doc Ett Core
ETT_DOC_TYPE: IM Fdg
ETT_PTNR_TYPE: IM Fdg
LAST_UPDATE_BY: SE SSION_USER
CREATE_DATETIME: 2026-01-05
CARRIER_DRIVER_LN: IM Fdg Doc Ett-003-EDGE
JURISDICTION_CODE: EDGE-IM_FDG-003
CARRIER_VEHICLE_RN: IM Fdg Doc Ett-003-EDGE
CARRIER_DRIVER_NAME: IM Fdg Doc Ett Core
LAST_UPDATE_DATETIME: 2026-01-05
CARRIER_VEHICLE_STATE: IM Fdg Doc Ett-003-EDGE
ADDITIONAL_STREET_NAME: IM Fdg Doc Ett Core

Rule Validation Summary

Source Rule Count: 42
Governed Rule Count: 32