Gtt Price History Mgn
Out of ScopeTechnical: GTT_PRICE_HIST_MGN | ID: OR-PRC-GTT_PRICE_HIST_MGN-GTT_PRICE_HIST_MGN
This table will hold the information for the new price history and margin form. It will contain all of the fields currently maintained on the existing price history table in...
See how this object fits into Pricing & Promotions
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
- GTT_PRICE_HIST_MGN
Field Definitions(5)
Rules & Considerations(30)
Sample Load Data(4)
| _scenario | LOC | VPN | ITEM | REASON | LOC_TYPE | REF_ITEM | ITEM_DESC | TRAN_TYPE | LOCAL_CURR | MARGIN_PCT | STORE_TYPE | ACTION_DATE | MULTI_UNITS | REASON_DESC | SELLING_UOM | UNIT_RETAIL | PRICING_COST | PRIMARY_CURR | WH_MARGIN_PCT | TRAN_TYPE_DESC | UNIT_RETAIL_EURO | UNIT_RETAIL_PRIM | MULTI_SELLING_UOM | MULTI_UNIT_RETAIL | PRICING_COST_EURO | PRICING_COST_PRIM | SELLING_UNIT_RETAIL | MULTI_UNIT_RETAIL_EURO | MULTI_UNIT_RETAIL_PRIM | SELLING_UNIT_RETAIL_EURO | SELLING_UNIT_RETAIL_PRIM |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| Example values from field definitions | 1 | SAMPLE | SAMPLE | 1 | S | SAMPLE | SAMPLE | 1 | SAM | 1.0000 | S | 2026-01-01 | 1.0000 | SAMPLE | SAMP | 1.0000 | 1.0000 | SAM | 1.0000 | SAMPLE | 1.0000 | 1.0000 | SAMP | 1.0000 | 1.0000 | 1.0000 | 1.0000 | 1.0000 | 1.0000 | 1.0000 | 1.0000 |
| default | 3 | Gtt Price Hist Mgn-002-ALT | Gtt Price Hist Mgn-002-AL | 3 | G | Gtt Price Hist Mgn-002-AL | Gtt Price Hist Mgn-002-ALT | 3 | Gtt | 12.5000 | G | 2026-01-03 | 12.5000 | Gtt Price Hist Mgn-002-ALT | Gtt | 12.5000 | 12.5000 | Gtt | 12.5000 | Gtt Price Hist Mgn-002-ALT | 12.5000 | 12.5000 | Gtt | 12.5000 | 12.5000 | 12.5000 | 12.5000 | 12.5000 | 12.5000 | 12.5000 | 12.5000 |
| default | 5 | Gtt Price Hist Mgn-003-EDGE | Gtt Price Hist Mgn-003-ED | 5 | G | Gtt Price Hist Mgn-003-ED | Gtt Price Hist Mgn-003-EDGE | 5 | Gtt | 14.0000 | G | 2026-01-05 | 14.0000 | Gtt Price Hist Mgn-003-EDGE | Gtt | 14.0000 | 14.0000 | Gtt | 14.0000 | Gtt Price Hist Mgn-003-EDGE | 14.0000 | 14.0000 | Gtt | 14.0000 | 14.0000 | 14.0000 | 14.0000 | 14.0000 | 14.0000 | 14.0000 | 14.0000 |
Example values from field definitions
- LOC
- 1
- VPN
- SAMPLE
- ITEM
- SAMPLE
- REASON
- 1
- LOC_TYPE
- S
- REF_ITEM
- SAMPLE
- ITEM_DESC
- SAMPLE
- TRAN_TYPE
- 1
- LOCAL_CURR
- SAM
- MARGIN_PCT
- 1.0000
- STORE_TYPE
- S
- ACTION_DATE
- 2026-01-01
- MULTI_UNITS
- 1.0000
- REASON_DESC
- SAMPLE
- SELLING_UOM
- SAMP
- UNIT_RETAIL
- 1.0000
- PRICING_COST
- 1.0000
- PRIMARY_CURR
- SAM
- WH_MARGIN_PCT
- 1.0000
- TRAN_TYPE_DESC
- SAMPLE
- UNIT_RETAIL_EURO
- 1.0000
- UNIT_RETAIL_PRIM
- 1.0000
- MULTI_SELLING_UOM
- SAMP
- MULTI_UNIT_RETAIL
- 1.0000
- PRICING_COST_EURO
- 1.0000
- PRICING_COST_PRIM
- 1.0000
- SELLING_UNIT_RETAIL
- 1.0000
- MULTI_UNIT_RETAIL_EURO
- 1.0000
- MULTI_UNIT_RETAIL_PRIM
- 1.0000
- SELLING_UNIT_RETAIL_EURO
- 1.0000
- SELLING_UNIT_RETAIL_PRIM
- 1.0000
default
- LOC
- 3
- VPN
- Gtt Price Hist Mgn-002-ALT
- ITEM
- Gtt Price Hist Mgn-002-AL
- REASON
- 3
- LOC_TYPE
- G
- REF_ITEM
- Gtt Price Hist Mgn-002-AL
- ITEM_DESC
- Gtt Price Hist Mgn-002-ALT
- TRAN_TYPE
- 3
- LOCAL_CURR
- Gtt
- MARGIN_PCT
- 12.5000
- STORE_TYPE
- G
- ACTION_DATE
- 2026-01-03
- MULTI_UNITS
- 12.5000
- REASON_DESC
- Gtt Price Hist Mgn-002-ALT
- SELLING_UOM
- Gtt
- UNIT_RETAIL
- 12.5000
- PRICING_COST
- 12.5000
- PRIMARY_CURR
- Gtt
- WH_MARGIN_PCT
- 12.5000
- TRAN_TYPE_DESC
- Gtt Price Hist Mgn-002-ALT
- UNIT_RETAIL_EURO
- 12.5000
- UNIT_RETAIL_PRIM
- 12.5000
- MULTI_SELLING_UOM
- Gtt
- MULTI_UNIT_RETAIL
- 12.5000
- PRICING_COST_EURO
- 12.5000
- PRICING_COST_PRIM
- 12.5000
- SELLING_UNIT_RETAIL
- 12.5000
- MULTI_UNIT_RETAIL_EURO
- 12.5000
- MULTI_UNIT_RETAIL_PRIM
- 12.5000
- SELLING_UNIT_RETAIL_EURO
- 12.5000
- SELLING_UNIT_RETAIL_PRIM
- 12.5000
default
- LOC
- 5
- VPN
- Gtt Price Hist Mgn-003-EDGE
- ITEM
- Gtt Price Hist Mgn-003-ED
- REASON
- 5
- LOC_TYPE
- G
- REF_ITEM
- Gtt Price Hist Mgn-003-ED
- ITEM_DESC
- Gtt Price Hist Mgn-003-EDGE
- TRAN_TYPE
- 5
- LOCAL_CURR
- Gtt
- MARGIN_PCT
- 14.0000
- STORE_TYPE
- G
- ACTION_DATE
- 2026-01-05
- MULTI_UNITS
- 14.0000
- REASON_DESC
- Gtt Price Hist Mgn-003-EDGE
- SELLING_UOM
- Gtt
- UNIT_RETAIL
- 14.0000
- PRICING_COST
- 14.0000
- PRIMARY_CURR
- Gtt
- WH_MARGIN_PCT
- 14.0000
- TRAN_TYPE_DESC
- Gtt Price Hist Mgn-003-EDGE
- UNIT_RETAIL_EURO
- 14.0000
- UNIT_RETAIL_PRIM
- 14.0000
- MULTI_SELLING_UOM
- Gtt
- MULTI_UNIT_RETAIL
- 14.0000
- PRICING_COST_EURO
- 14.0000
- PRICING_COST_PRIM
- 14.0000
- SELLING_UNIT_RETAIL
- 14.0000
- MULTI_UNIT_RETAIL_EURO
- 14.0000
- MULTI_UNIT_RETAIL_PRIM
- 14.0000
- SELLING_UNIT_RETAIL_EURO
- 14.0000
- SELLING_UNIT_RETAIL_PRIM
- 14.0000
Rule Validation Summary
- Source Rule Count
- 33
- Governed Rule Count
- 30