IM Document Search (GTT)

Out of Scope

Technical: IM_DOC_SEARCH_GTT | ID: OR-IM-IM_DOC_SEARCH_GTT-IM_DOC_SEARCH_GTT

Global temporary table used in search logic.

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: gtt

Target Structure

Load Approach: Table
Target Objects: IM_DOC_SEARCH_GTT

Field Definitions(5)

Rules & Considerations(43)

Sample Load Data(4)

_scenario	TYPE	DOC_ID	STATUS	VENDOR	RTV_IND	DOC_DATE	DUE_DATE	GROUP_ID	LOCATION	LOC_NAME	LOC_TYPE	MATCH_ID	ORDER_NO	MATCH_KEY	TOTAL_QTY	DOC_SOURCE	EXT_DOC_ID	MATCH_DATE	TOTAL_COST	AP_REVIEWER	HOLD_STATUS	PO_SUPPLIER	VENDOR_NAME	VENDOR_TYPE	FREIGHT_TYPE	MATCH_KEY_ID	PRE_PAID_IND	RTV_ORDER_NO	VENDOR_PHONE	CURRENCY_CODE	COST_PRE_MATCH	LOC_VAT_REGION	CONSIGNMENT_IND	MATCH_KEY_VALUE	CUSTOM_DOC_REF_1	CUSTOM_DOC_REF_2	CUSTOM_DOC_REF_3	CUSTOM_DOC_REF_4	PO_SUPPLIER_SITE	SUPPLIER_SITE_ID	MANUALLY_PAID_IND	SUPPLIER_GROUP_ID	SUPPLIER_SITE_NAME	DOC_HEAD_VERSION_ID	LOC_SET_OF_BOOKS_ID	SUPPLIER_SITE_VAT_REGION
Example values from field definitions	SAMPLE	1	SAMPLE	SAMPLE	S	2026-01-01	2026-01-01	1	1	SAMPLE	S	SAMPLE	1	SAM	1.0000	SAMPLE	SAMPLE	2026-01-01	1.0000	SAMPLE	S	1	SAMPLE	SAMPLE	SAMPLE	1	S	1	SAMPLE	SAM	S	1	S	SAMPLE	SAMPLE	SAMPLE	SAMPLE	SAMPLE	1	SAMPLE	S	1	SAMPLE	1	1	1
default	IM Doc	1000000003	PENDING-AL	IM Doc Sea	I	2026-01-03	2026-01-03	1000000003	3	IM Doc Search Gtt Secondary	I	ALT-IM_DOC-002	4	ALT	12.5000	IM Doc	ALT-IM_DOC-002	2026-01-03	12.5000	IM Doc Search Gtt-002-ALT	h	3	IM Doc Search Gtt Secondary	IM Doc	IM Doc	1000000003	N	4	IM Doc Search Gtt-00	ALT	I	203	I	IM Doc Search Gtt-002-ALT	IM Doc Search Gtt-002-ALT	IM Doc Search Gtt-002-ALT	IM Doc Search Gtt-002-ALT	IM Doc Search Gtt-002-ALT	3	ALT-IM_DOC	Y	1000000003	IM Doc Search Gtt Secondary	1000000003	1000000003	203
default	IM Doc	1000000005	ACTIVE-EDG	IM Doc Sea	I	2026-01-05	2026-01-05	1000000005	5	IM Doc Search Gtt Core	I	EDGE-IM_DOC-003	6	EDG	14.0000	IM Doc	EDGE-IM_DOC-003	2026-01-05	14.0000	IM Doc Search Gtt-003-EDGE	r	5	IM Doc Search Gtt Core	IM Doc	IM Doc	1000000005	Y	6	IM Doc Search Gtt-00	EDG	I	205	I	IM Doc Search Gtt-003-EDGE	IM Doc Search Gtt-003-EDGE	IM Doc Search Gtt-003-EDGE	IM Doc Search Gtt-003-EDGE	IM Doc Search Gtt-003-EDGE	5	EDGE-IM_DO	N	1000000005	IM Doc Search Gtt Core	1000000005	1000000005	205

Example values from field definitions

TYPE: SAMPLE
DOC_ID: 1
STATUS: SAMPLE
VENDOR: SAMPLE
RTV_IND: S
DOC_DATE: 2026-01-01
DUE_DATE: 2026-01-01
GROUP_ID: 1
LOCATION: 1
LOC_NAME: SAMPLE
LOC_TYPE: S
MATCH_ID: SAMPLE
ORDER_NO: 1
MATCH_KEY: SAM
TOTAL_QTY: 1.0000
DOC_SOURCE: SAMPLE
EXT_DOC_ID: SAMPLE
MATCH_DATE: 2026-01-01
TOTAL_COST: 1.0000
AP_REVIEWER: SAMPLE
HOLD_STATUS: S
PO_SUPPLIER: 1
VENDOR_NAME: SAMPLE
VENDOR_TYPE: SAMPLE
FREIGHT_TYPE: SAMPLE
MATCH_KEY_ID: 1
PRE_PAID_IND: S
RTV_ORDER_NO: 1
VENDOR_PHONE: SAMPLE
CURRENCY_CODE: SAM
COST_PRE_MATCH: S
LOC_VAT_REGION: 1
CONSIGNMENT_IND: S
MATCH_KEY_VALUE: SAMPLE
CUSTOM_DOC_REF_1: SAMPLE
CUSTOM_DOC_REF_2: SAMPLE
CUSTOM_DOC_REF_3: SAMPLE
CUSTOM_DOC_REF_4: SAMPLE
PO_SUPPLIER_SITE: 1
SUPPLIER_SITE_ID: SAMPLE
MANUALLY_PAID_IND: S
SUPPLIER_GROUP_ID: 1
SUPPLIER_SITE_NAME: SAMPLE
DOC_HEAD_VERSION_ID: 1
LOC_SET_OF_BOOKS_ID: 1
SUPPLIER_SITE_VAT_REGION: 1

default

TYPE: IM Doc
DOC_ID: 1000000003
STATUS: PENDING-AL
VENDOR: IM Doc Sea
RTV_IND: I
DOC_DATE: 2026-01-03
DUE_DATE: 2026-01-03
GROUP_ID: 1000000003
LOCATION: 3
LOC_NAME: IM Doc Search Gtt Secondary
LOC_TYPE: I
MATCH_ID: ALT-IM_DOC-002
ORDER_NO: 4
MATCH_KEY: ALT
TOTAL_QTY: 12.5000
DOC_SOURCE: IM Doc
EXT_DOC_ID: ALT-IM_DOC-002
MATCH_DATE: 2026-01-03
TOTAL_COST: 12.5000
AP_REVIEWER: IM Doc Search Gtt-002-ALT
HOLD_STATUS: h
PO_SUPPLIER: 3
VENDOR_NAME: IM Doc Search Gtt Secondary
VENDOR_TYPE: IM Doc
FREIGHT_TYPE: IM Doc
MATCH_KEY_ID: 1000000003
PRE_PAID_IND: N
RTV_ORDER_NO: 4
VENDOR_PHONE: IM Doc Search Gtt-00
CURRENCY_CODE: ALT
COST_PRE_MATCH: I
LOC_VAT_REGION: 203
CONSIGNMENT_IND: I
MATCH_KEY_VALUE: IM Doc Search Gtt-002-ALT
CUSTOM_DOC_REF_1: IM Doc Search Gtt-002-ALT
CUSTOM_DOC_REF_2: IM Doc Search Gtt-002-ALT
CUSTOM_DOC_REF_3: IM Doc Search Gtt-002-ALT
CUSTOM_DOC_REF_4: IM Doc Search Gtt-002-ALT
PO_SUPPLIER_SITE: 3
SUPPLIER_SITE_ID: ALT-IM_DOC
MANUALLY_PAID_IND: Y
SUPPLIER_GROUP_ID: 1000000003
SUPPLIER_SITE_NAME: IM Doc Search Gtt Secondary
DOC_HEAD_VERSION_ID: 1000000003
LOC_SET_OF_BOOKS_ID: 1000000003
SUPPLIER_SITE_VAT_REGION: 203

default

TYPE: IM Doc
DOC_ID: 1000000005
STATUS: ACTIVE-EDG
VENDOR: IM Doc Sea
RTV_IND: I
DOC_DATE: 2026-01-05
DUE_DATE: 2026-01-05
GROUP_ID: 1000000005
LOCATION: 5
LOC_NAME: IM Doc Search Gtt Core
LOC_TYPE: I
MATCH_ID: EDGE-IM_DOC-003
ORDER_NO: 6
MATCH_KEY: EDG
TOTAL_QTY: 14.0000
DOC_SOURCE: IM Doc
EXT_DOC_ID: EDGE-IM_DOC-003
MATCH_DATE: 2026-01-05
TOTAL_COST: 14.0000
AP_REVIEWER: IM Doc Search Gtt-003-EDGE
HOLD_STATUS: r
PO_SUPPLIER: 5
VENDOR_NAME: IM Doc Search Gtt Core
VENDOR_TYPE: IM Doc
FREIGHT_TYPE: IM Doc
MATCH_KEY_ID: 1000000005
PRE_PAID_IND: Y
RTV_ORDER_NO: 6
VENDOR_PHONE: IM Doc Search Gtt-00
CURRENCY_CODE: EDG
COST_PRE_MATCH: I
LOC_VAT_REGION: 205
CONSIGNMENT_IND: I
MATCH_KEY_VALUE: IM Doc Search Gtt-003-EDGE
CUSTOM_DOC_REF_1: IM Doc Search Gtt-003-EDGE
CUSTOM_DOC_REF_2: IM Doc Search Gtt-003-EDGE
CUSTOM_DOC_REF_3: IM Doc Search Gtt-003-EDGE
CUSTOM_DOC_REF_4: IM Doc Search Gtt-003-EDGE
PO_SUPPLIER_SITE: 5
SUPPLIER_SITE_ID: EDGE-IM_DO
MANUALLY_PAID_IND: N
SUPPLIER_GROUP_ID: 1000000005
SUPPLIER_SITE_NAME: IM Doc Search Gtt Core
DOC_HEAD_VERSION_ID: 1000000005
LOC_SET_OF_BOOKS_ID: 1000000005
SUPPLIER_SITE_VAT_REGION: 205

Rule Validation Summary

Source Rule Count: 55
Governed Rule Count: 43

All objects