IM Receipt Search (GTT)
Out of ScopeTechnical: IM_RCPT_SEARCH_GTT | ID: OR-IM-IM_RCPT_SEARCH_GTT-IM_RCPT_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_RCPT_SEARCH_GTT
Field Definitions(5)
Rules & Considerations(24)
Sample Load Data(4)
| _scenario | ASN | LOCATION | ORDER_NO | SHIPMENT | SUPPLIER | SHIP_DATE | TOTAL_QTY | TOTAL_COST | BILL_TO_LOC | CHOICE_FLAG | STATUS_CODE | MATCH_KEY_ID | RECEIVE_DATE | CURRENCY_CODE | LOCATION_NAME | LOCATION_TYPE | SUPPLIER_NAME | LOC_VAT_REGION | CONSIGNMENT_IND | BILL_TO_LOC_NAME | BILL_TO_LOC_TYPE | SUPPLIER_SITE_ID | INVC_MATCH_STATUS | SUPPLIER_SITE_NAME | LOC_SET_OF_BOOKS_ID | SUPPLIER_SITE_VAT_REGION |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| Example values from field definitions | SAMPLE | 1 | 1 | 1 | 1 | 2026-01-01 | 1.0000 | 1.0000 | 1 | S | S | 1 | 2026-01-01 | SAM | SAMPLE | S | SAMPLE | 1 | S | SAMPLE | S | 1 | S | SAMPLE | 1 | 1 |
| default | IM Rcpt Search Gtt-002-ALT | 3 | 4 | 3 | 3 | 2026-01-03 | 12.5000 | 12.5000 | 3 | I | A | 1000000003 | 2026-01-03 | ALT | IM Rcpt Search Gtt Secondary | I | IM Rcpt Search Gtt Secondary | 203 | I | IM Rcpt Search Gtt Secondary | I | 1000000003 | P | IM Rcpt Search Gtt Secondary | 1000000003 | 203 |
| default | IM Rcpt Search Gtt-003-EDGE | 5 | 6 | 5 | 5 | 2026-01-05 | 14.0000 | 14.0000 | 5 | I | E | 1000000005 | 2026-01-05 | EDG | IM Rcpt Search Gtt Core | I | IM Rcpt Search Gtt Core | 205 | I | IM Rcpt Search Gtt Core | I | 1000000005 | A | IM Rcpt Search Gtt Core | 1000000005 | 205 |
Example values from field definitions
- ASN
- SAMPLE
- LOCATION
- 1
- ORDER_NO
- 1
- SHIPMENT
- 1
- SUPPLIER
- 1
- SHIP_DATE
- 2026-01-01
- TOTAL_QTY
- 1.0000
- TOTAL_COST
- 1.0000
- BILL_TO_LOC
- 1
- CHOICE_FLAG
- S
- STATUS_CODE
- S
- MATCH_KEY_ID
- 1
- RECEIVE_DATE
- 2026-01-01
- CURRENCY_CODE
- SAM
- LOCATION_NAME
- SAMPLE
- LOCATION_TYPE
- S
- SUPPLIER_NAME
- SAMPLE
- LOC_VAT_REGION
- 1
- CONSIGNMENT_IND
- S
- BILL_TO_LOC_NAME
- SAMPLE
- BILL_TO_LOC_TYPE
- S
- SUPPLIER_SITE_ID
- 1
- INVC_MATCH_STATUS
- S
- SUPPLIER_SITE_NAME
- SAMPLE
- LOC_SET_OF_BOOKS_ID
- 1
- SUPPLIER_SITE_VAT_REGION
- 1
default
- ASN
- IM Rcpt Search Gtt-002-ALT
- LOCATION
- 3
- ORDER_NO
- 4
- SHIPMENT
- 3
- SUPPLIER
- 3
- SHIP_DATE
- 2026-01-03
- TOTAL_QTY
- 12.5000
- TOTAL_COST
- 12.5000
- BILL_TO_LOC
- 3
- CHOICE_FLAG
- I
- STATUS_CODE
- A
- MATCH_KEY_ID
- 1000000003
- RECEIVE_DATE
- 2026-01-03
- CURRENCY_CODE
- ALT
- LOCATION_NAME
- IM Rcpt Search Gtt Secondary
- LOCATION_TYPE
- I
- SUPPLIER_NAME
- IM Rcpt Search Gtt Secondary
- LOC_VAT_REGION
- 203
- CONSIGNMENT_IND
- I
- BILL_TO_LOC_NAME
- IM Rcpt Search Gtt Secondary
- BILL_TO_LOC_TYPE
- I
- SUPPLIER_SITE_ID
- 1000000003
- INVC_MATCH_STATUS
- P
- SUPPLIER_SITE_NAME
- IM Rcpt Search Gtt Secondary
- LOC_SET_OF_BOOKS_ID
- 1000000003
- SUPPLIER_SITE_VAT_REGION
- 203
default
- ASN
- IM Rcpt Search Gtt-003-EDGE
- LOCATION
- 5
- ORDER_NO
- 6
- SHIPMENT
- 5
- SUPPLIER
- 5
- SHIP_DATE
- 2026-01-05
- TOTAL_QTY
- 14.0000
- TOTAL_COST
- 14.0000
- BILL_TO_LOC
- 5
- CHOICE_FLAG
- I
- STATUS_CODE
- E
- MATCH_KEY_ID
- 1000000005
- RECEIVE_DATE
- 2026-01-05
- CURRENCY_CODE
- EDG
- LOCATION_NAME
- IM Rcpt Search Gtt Core
- LOCATION_TYPE
- I
- SUPPLIER_NAME
- IM Rcpt Search Gtt Core
- LOC_VAT_REGION
- 205
- CONSIGNMENT_IND
- I
- BILL_TO_LOC_NAME
- IM Rcpt Search Gtt Core
- BILL_TO_LOC_TYPE
- I
- SUPPLIER_SITE_ID
- 1000000005
- INVC_MATCH_STATUS
- A
- SUPPLIER_SITE_NAME
- IM Rcpt Search Gtt Core
- LOC_SET_OF_BOOKS_ID
- 1000000005
- SUPPLIER_SITE_VAT_REGION
- 205
Rule Validation Summary
- Source Rule Count
- 30
- Governed Rule Count
- 24