RMS Oi Buyer Sales Gtt

Out of Scope

Technical: RMS_OI_BUYER_SALES_GTT | ID: OR-MFCS-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

Target Structure

Load Approach: Table
Target Objects: RMS_OI_BUYER_SALES_GTT

Field Definitions(17)

Rules & Considerations(8)

Validation

Sequencing

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
default	1000000001	RMS Oi Buyer Sales Gtt-001	RMS Oi Buyer Sales Gtt-001	RMS Oi Buyer Sales Gtt-001	RMS Oi Buyer Sales Gtt-001	RMS Oi Buyer Sales Gtt-001	RMS Oi Buyer Sales Gtt-001	11.0000	RMS Oi Buyer Sales Gtt-001	RMS Oi Buyer Sales Gtt-001	RMS Oi Buyer Sales Gtt-001	RMS Oi Buyer Sales Gtt-001	RMS Oi Buyer Sales Gtt-001	11.0000	11.0000	11.0000	STD-RMS_OI-001

default

SESSION_IDR: 1000000001
ITEM: RMS Oi Buyer Sales Gtt-001
ITEM_DESC: RMS Oi Buyer Sales Gtt-001
AGG_DIFF_1: RMS Oi Buyer Sales Gtt-001
AGG_DIFF_2: RMS Oi Buyer Sales Gtt-001
AGG_DIFF_3: RMS Oi Buyer Sales Gtt-001
AGG_DIFF_4: RMS Oi Buyer Sales Gtt-001
SALES_UNITS: 11.0000
STANDARD_UOM: RMS Oi Buyer Sales Gtt-001
AGG_DIFF_1_DESC: RMS Oi Buyer Sales Gtt-001
AGG_DIFF_2_DESC: RMS Oi Buyer Sales Gtt-001
AGG_DIFF_3_DESC: RMS Oi Buyer Sales Gtt-001
AGG_DIFF_4_DESC: RMS Oi Buyer Sales Gtt-001
TOTAL_COST_PRIM: 11.0000
TOTAL_MARGIN_PRIM: 11.0000
TOTAL_RETAIL_PRIM: 11.0000
PRIM_CURRENCY_CODE: STD-RMS_OI-001

All objects