IM Transform Ordloc (GTT)
Out of ScopeTechnical: IM_TRANSFORM_ORDLOC_GTT | ID: OR-IM-IM_TRANSFORM_ORDLOC_GTT-IM_TRANSFORM_ORDLOC_GTT
Global temporary table used when applying catchweight and UOM logic to ordloc records.
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_TRANSFORM_ORDLOC_GTT
Field Definitions(5)
Rules & Considerations(16)
Sample Load Data(4)
| _scenario | LOC | ITEM | LOC_TYPE | ORDER_NO | ITEM_DESC | UNIT_COST | IMPORT_LOC | COST_SOURCE | QTY_ORDERED | SUP_QTY_LEVEL | UNIT_COST_INIT | IMPORT_LOC_TYPE | CATCH_WEIGHT_TYPE | TRANSFORM_UNIT_COST | TRANSFORM_QTY_ORDERED | TRANSFORM_UNIT_COST_INIT |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| Example values from field definitions | 1 | SAMPLE | S | 1 | SAMPLE | 1.0000 | 1 | SAMP | 1.0000 | SAMPLE | 1.0000 | S | SA | 1.0000 | 1.0000 | 1.0000 |
| default | 3 | IM Transform Ordloc Gtt-0 | I | 4 | IM Transform Ordloc Gtt-002-ALT | 12.5000 | 3 | IM T | 12.5000 | IM Tra | 12.5000 | I | IM | 12.5000 | 12.5000 | 12.5000 |
| default | 5 | IM Transform Ordloc Gtt-0 | I | 6 | IM Transform Ordloc Gtt-003-EDGE | 14.0000 | 5 | IM T | 14.0000 | IM Tra | 14.0000 | I | IM | 14.0000 | 14.0000 | 14.0000 |
Example values from field definitions
- LOC
- 1
- ITEM
- SAMPLE
- LOC_TYPE
- S
- ORDER_NO
- 1
- ITEM_DESC
- SAMPLE
- UNIT_COST
- 1.0000
- IMPORT_LOC
- 1
- COST_SOURCE
- SAMP
- QTY_ORDERED
- 1.0000
- SUP_QTY_LEVEL
- SAMPLE
- UNIT_COST_INIT
- 1.0000
- IMPORT_LOC_TYPE
- S
- CATCH_WEIGHT_TYPE
- SA
- TRANSFORM_UNIT_COST
- 1.0000
- TRANSFORM_QTY_ORDERED
- 1.0000
- TRANSFORM_UNIT_COST_INIT
- 1.0000
default
- LOC
- 3
- ITEM
- IM Transform Ordloc Gtt-0
- LOC_TYPE
- I
- ORDER_NO
- 4
- ITEM_DESC
- IM Transform Ordloc Gtt-002-ALT
- UNIT_COST
- 12.5000
- IMPORT_LOC
- 3
- COST_SOURCE
- IM T
- QTY_ORDERED
- 12.5000
- SUP_QTY_LEVEL
- IM Tra
- UNIT_COST_INIT
- 12.5000
- IMPORT_LOC_TYPE
- I
- CATCH_WEIGHT_TYPE
- IM
- TRANSFORM_UNIT_COST
- 12.5000
- TRANSFORM_QTY_ORDERED
- 12.5000
- TRANSFORM_UNIT_COST_INIT
- 12.5000
default
- LOC
- 5
- ITEM
- IM Transform Ordloc Gtt-0
- LOC_TYPE
- I
- ORDER_NO
- 6
- ITEM_DESC
- IM Transform Ordloc Gtt-003-EDGE
- UNIT_COST
- 14.0000
- IMPORT_LOC
- 5
- COST_SOURCE
- IM T
- QTY_ORDERED
- 14.0000
- SUP_QTY_LEVEL
- IM Tra
- UNIT_COST_INIT
- 14.0000
- IMPORT_LOC_TYPE
- I
- CATCH_WEIGHT_TYPE
- IM
- TRANSFORM_UNIT_COST
- 14.0000
- TRANSFORM_QTY_ORDERED
- 14.0000
- TRANSFORM_UNIT_COST_INIT
- 14.0000
Rule Validation Summary
- Source Rule Count
- 22
- Governed Rule Count
- 16