IM Transform Shipsku (GTT)
Out of ScopeTechnical: IM_TRANSFORM_SHIPSKU_GTT | ID: OR-IM-IM_TRANSFORM_SHIPSKU_GTT-IM_TRANSFORM_SHIPSKU_GTT
Global temporary table used when applying catchweight and UOM logic to shipsku 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_SHIPSKU_GTT
Field Definitions(5)
Rules & Considerations(19)
Sample Load Data(4)
| _scenario | VPN | ITEM | CARTON | SEQ_NO | ORDER_NO | SHIPMENT | SUPPLIER | INVC_ITEM | SS_UNIT_COST | SUP_QTY_LEVEL | SS_QTY_MATCHED | SS_QTY_RECEIVED | WEIGHT_RECEIVED | CATCH_WEIGHT_TYPE | INVC_MATCH_STATUS | TRANSFORM_UNIT_COST | WEIGHT_RECEIVED_UOM | TRANSFORM_QTY_MATCHED | TRANSFORM_QTY_RECEIVED |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| Example values from field definitions | SAMPLE | SAMPLE | SAMPLE | 1 | 1 | 1 | 1 | SAMPLE | 1.0000 | SAMPLE | 1.0000 | 1.0000 | 1.0000 | SA | S | 1.0000 | SAMP | 1.0000 | 1.0000 |
| default | IM Transform Shipsku Gtt-002-A | IM Transform Shipsku Gtt- | IM Transform Shipsku Gtt-002-A | 4 | 4 | 3 | 3 | IM Transform Shipsku Gtt- | 12.5000 | IM Tra | 12.5000 | 12.5000 | 12.5000 | IM | P | 12.5000 | IM T | 12.5000 | 12.5000 |
| default | IM Transform Shipsku Gtt-003-E | IM Transform Shipsku Gtt- | IM Transform Shipsku Gtt-003-E | 6 | 6 | 5 | 5 | IM Transform Shipsku Gtt- | 14.0000 | IM Tra | 14.0000 | 14.0000 | 14.0000 | IM | A | 14.0000 | IM T | 14.0000 | 14.0000 |
Example values from field definitions
- VPN
- SAMPLE
- ITEM
- SAMPLE
- CARTON
- SAMPLE
- SEQ_NO
- 1
- ORDER_NO
- 1
- SHIPMENT
- 1
- SUPPLIER
- 1
- INVC_ITEM
- SAMPLE
- SS_UNIT_COST
- 1.0000
- SUP_QTY_LEVEL
- SAMPLE
- SS_QTY_MATCHED
- 1.0000
- SS_QTY_RECEIVED
- 1.0000
- WEIGHT_RECEIVED
- 1.0000
- CATCH_WEIGHT_TYPE
- SA
- INVC_MATCH_STATUS
- S
- TRANSFORM_UNIT_COST
- 1.0000
- WEIGHT_RECEIVED_UOM
- SAMP
- TRANSFORM_QTY_MATCHED
- 1.0000
- TRANSFORM_QTY_RECEIVED
- 1.0000
default
- VPN
- IM Transform Shipsku Gtt-002-A
- ITEM
- IM Transform Shipsku Gtt-
- CARTON
- IM Transform Shipsku Gtt-002-A
- SEQ_NO
- 4
- ORDER_NO
- 4
- SHIPMENT
- 3
- SUPPLIER
- 3
- INVC_ITEM
- IM Transform Shipsku Gtt-
- SS_UNIT_COST
- 12.5000
- SUP_QTY_LEVEL
- IM Tra
- SS_QTY_MATCHED
- 12.5000
- SS_QTY_RECEIVED
- 12.5000
- WEIGHT_RECEIVED
- 12.5000
- CATCH_WEIGHT_TYPE
- IM
- INVC_MATCH_STATUS
- P
- TRANSFORM_UNIT_COST
- 12.5000
- WEIGHT_RECEIVED_UOM
- IM T
- TRANSFORM_QTY_MATCHED
- 12.5000
- TRANSFORM_QTY_RECEIVED
- 12.5000
default
- VPN
- IM Transform Shipsku Gtt-003-E
- ITEM
- IM Transform Shipsku Gtt-
- CARTON
- IM Transform Shipsku Gtt-003-E
- SEQ_NO
- 6
- ORDER_NO
- 6
- SHIPMENT
- 5
- SUPPLIER
- 5
- INVC_ITEM
- IM Transform Shipsku Gtt-
- SS_UNIT_COST
- 14.0000
- SUP_QTY_LEVEL
- IM Tra
- SS_QTY_MATCHED
- 14.0000
- SS_QTY_RECEIVED
- 14.0000
- WEIGHT_RECEIVED
- 14.0000
- CATCH_WEIGHT_TYPE
- IM
- INVC_MATCH_STATUS
- A
- TRANSFORM_UNIT_COST
- 14.0000
- WEIGHT_RECEIVED_UOM
- IM T
- TRANSFORM_QTY_MATCHED
- 14.0000
- TRANSFORM_QTY_RECEIVED
- 14.0000
Rule Validation Summary
- Source Rule Count
- 25
- Governed Rule Count
- 19