RMS Oi Buyer Sales (GTT)
Out of ScopeTechnical: RMS_OI_BUYER_SALES_GTT | ID: OR-ITM-RMS_OI_BUYER_SALES_GTT-RMS_OI_BUYER_SALES_GTT
This is a global temporary table to support the dashboard Buyer Sales report process. It is used to temporarily hold the sales and margin data for an item that meets...
See how this object fits into Item Management
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
- RMS_OI_BUYER_SALES_GTT
Field Definitions(5)
Rules & Considerations(18)
Sample Load Data(4)
| _scenario | SESSION_IDR | ITEM | ITEM_DESC | AGG_DIFF_1 | AGG_DIFF_2 | AGG_DIFF_3 | AGG_DIFF_4 | SALES_UNITS | STANDARD_UOM | AGG_DIFF_1_DESC | AGG_DIFF_2_DESC | AGG_DIFF_3_DESC | AGG_DIFF_4_DESC | TOTAL_COST_PRIM | TOTAL_MARGIN_PRIM | TOTAL_RETAIL_PRIM | PRIM_CURRENCY_CODE |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| Example values from field definitions | 1 | SAMPLE | SAMPLE | SAMPLE | SAMPLE | SAMPLE | SAMPLE | 1.0000 | SAMP | SAMPLE | SAMPLE | SAMPLE | SAMPLE | 1.0000 | 1.0000 | 1.0000 | SAM |
| default | 1000000003 | RMS Oi Buyer Sales Gtt-00 | RMS Oi Buyer Sales Gtt-002-ALT | RMS Oi Buy | RMS Oi Buy | RMS Oi Buy | RMS Oi Buy | 12.5000 | RMS | RMS Oi Buyer Sales Gtt-002-ALT | RMS Oi Buyer Sales Gtt-002-ALT | RMS Oi Buyer Sales Gtt-002-ALT | RMS Oi Buyer Sales Gtt-002-ALT | 12.5000 | 12.5000 | 12.5000 | ALT |
| default | 1000000005 | RMS Oi Buyer Sales Gtt-00 | RMS Oi Buyer Sales Gtt-003-EDGE | RMS Oi Buy | RMS Oi Buy | RMS Oi Buy | RMS Oi Buy | 14.0000 | RMS | RMS Oi Buyer Sales Gtt-003-EDGE | RMS Oi Buyer Sales Gtt-003-EDGE | RMS Oi Buyer Sales Gtt-003-EDGE | RMS Oi Buyer Sales Gtt-003-EDGE | 14.0000 | 14.0000 | 14.0000 | EDG |
Example values from field definitions
- SESSION_IDR
- 1
- ITEM
- SAMPLE
- ITEM_DESC
- SAMPLE
- AGG_DIFF_1
- SAMPLE
- AGG_DIFF_2
- SAMPLE
- AGG_DIFF_3
- SAMPLE
- AGG_DIFF_4
- SAMPLE
- SALES_UNITS
- 1.0000
- STANDARD_UOM
- SAMP
- AGG_DIFF_1_DESC
- SAMPLE
- AGG_DIFF_2_DESC
- SAMPLE
- AGG_DIFF_3_DESC
- SAMPLE
- AGG_DIFF_4_DESC
- SAMPLE
- TOTAL_COST_PRIM
- 1.0000
- TOTAL_MARGIN_PRIM
- 1.0000
- TOTAL_RETAIL_PRIM
- 1.0000
- PRIM_CURRENCY_CODE
- SAM
default
- SESSION_IDR
- 1000000003
- ITEM
- RMS Oi Buyer Sales Gtt-00
- ITEM_DESC
- RMS Oi Buyer Sales Gtt-002-ALT
- AGG_DIFF_1
- RMS Oi Buy
- AGG_DIFF_2
- RMS Oi Buy
- AGG_DIFF_3
- RMS Oi Buy
- AGG_DIFF_4
- RMS Oi Buy
- SALES_UNITS
- 12.5000
- STANDARD_UOM
- RMS
- AGG_DIFF_1_DESC
- RMS Oi Buyer Sales Gtt-002-ALT
- AGG_DIFF_2_DESC
- RMS Oi Buyer Sales Gtt-002-ALT
- AGG_DIFF_3_DESC
- RMS Oi Buyer Sales Gtt-002-ALT
- AGG_DIFF_4_DESC
- RMS Oi Buyer Sales Gtt-002-ALT
- TOTAL_COST_PRIM
- 12.5000
- TOTAL_MARGIN_PRIM
- 12.5000
- TOTAL_RETAIL_PRIM
- 12.5000
- PRIM_CURRENCY_CODE
- ALT
default
- SESSION_IDR
- 1000000005
- ITEM
- RMS Oi Buyer Sales Gtt-00
- ITEM_DESC
- RMS Oi Buyer Sales Gtt-003-EDGE
- AGG_DIFF_1
- RMS Oi Buy
- AGG_DIFF_2
- RMS Oi Buy
- AGG_DIFF_3
- RMS Oi Buy
- AGG_DIFF_4
- RMS Oi Buy
- SALES_UNITS
- 14.0000
- STANDARD_UOM
- RMS
- AGG_DIFF_1_DESC
- RMS Oi Buyer Sales Gtt-003-EDGE
- AGG_DIFF_2_DESC
- RMS Oi Buyer Sales Gtt-003-EDGE
- AGG_DIFF_3_DESC
- RMS Oi Buyer Sales Gtt-003-EDGE
- AGG_DIFF_4_DESC
- RMS Oi Buyer Sales Gtt-003-EDGE
- TOTAL_COST_PRIM
- 14.0000
- TOTAL_MARGIN_PRIM
- 14.0000
- TOTAL_RETAIL_PRIM
- 14.0000
- PRIM_CURRENCY_CODE
- EDG
Rule Validation Summary
- Source Rule Count
- 24
- Governed Rule Count
- 18