Actual Landed Cost Oi Top Bottom Sales (GTT)

Out of Scope

Technical: ALC_OI_TOP_BOTTOM_SALES_GTT | ID: OR-ALLOC-ALC_OI_TOP_BOTTOM_SALES_GTT-ALC_OI_TOP_BOTTOM_SALES_GTT

This will hold Item sales information to be used by the Allocation OI Reports.

See how this object fits into Allocations

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: ALC_OI_TOP_BOTTOM_SALES_GTT

Field Definitions(5)

Rules & Considerations(21)

Sample Load Data(4)

_scenario	UOM	COST	DEPT	ITEM	CLASS	SALES	UNITS	DIFF_1	DIFF_2	DIFF_3	DIFF_4	MARGIN	RETAIL	SUBCLASS	ITEM_DESC	IMAGE_ADDR	IMAGE_NAME	ITEM_PARENT	ALC_ITEM_TYPE	TOP_BOTTOM_FLAG	MARKUP_CALC_TYPE
Example values from field definitions	SAMP	1.0000	1	SAMPLE	1	1.0000	1.0000	SAMPLE	SAMPLE	SAMPLE	SAMPLE	1.0000	1.0000	1	SAMPLE	SAMPLE	SAMPLE	SAMPLE	SAMPLE	SAMPLE	SA
default	Alc	12.5000	1003	Alc Oi Top Bottom Sales G	1103	12.5000	12.5000	Alc Oi Top	Alc Oi Top	Alc Oi Top	Alc Oi Top	12.5000	12.5000	1113	Alc Oi Top Bottom Sales Gtt-002-ALT	Alc Oi Top Bottom Sales Gtt-002-ALT	Alc Oi Top Bottom Sales Gtt Secondary	Alc Oi Top Bottom Sales G	Alc Oi Top Bott	Alc Oi	R
default	Alc	14.0000	1005	Alc Oi Top Bottom Sales G	1105	14.0000	14.0000	Alc Oi Top	Alc Oi Top	Alc Oi Top	Alc Oi Top	14.0000	14.0000	1115	Alc Oi Top Bottom Sales Gtt-003-EDGE	Alc Oi Top Bottom Sales Gtt-003-EDGE	Alc Oi Top Bottom Sales Gtt Core	Alc Oi Top Bottom Sales G	Alc Oi Top Bott	Alc Oi	C

Example values from field definitions

UOM: SAMP
COST: 1.0000
DEPT: 1
ITEM: SAMPLE
CLASS: 1
SALES: 1.0000
UNITS: 1.0000
DIFF_1: SAMPLE
DIFF_2: SAMPLE
DIFF_3: SAMPLE
DIFF_4: SAMPLE
MARGIN: 1.0000
RETAIL: 1.0000
SUBCLASS: 1
ITEM_DESC: SAMPLE
IMAGE_ADDR: SAMPLE
IMAGE_NAME: SAMPLE
ITEM_PARENT: SAMPLE
ALC_ITEM_TYPE: SAMPLE
TOP_BOTTOM_FLAG: SAMPLE
MARKUP_CALC_TYPE: SA

default

UOM: Alc
COST: 12.5000
DEPT: 1003
ITEM: Alc Oi Top Bottom Sales G
CLASS: 1103
SALES: 12.5000
UNITS: 12.5000
DIFF_1: Alc Oi Top
DIFF_2: Alc Oi Top
DIFF_3: Alc Oi Top
DIFF_4: Alc Oi Top
MARGIN: 12.5000
RETAIL: 12.5000
SUBCLASS: 1113
ITEM_DESC: Alc Oi Top Bottom Sales Gtt-002-ALT
IMAGE_ADDR: Alc Oi Top Bottom Sales Gtt-002-ALT
IMAGE_NAME: Alc Oi Top Bottom Sales Gtt Secondary
ITEM_PARENT: Alc Oi Top Bottom Sales G
ALC_ITEM_TYPE: Alc Oi Top Bott
TOP_BOTTOM_FLAG: Alc Oi
MARKUP_CALC_TYPE: R

default

UOM: Alc
COST: 14.0000
DEPT: 1005
ITEM: Alc Oi Top Bottom Sales G
CLASS: 1105
SALES: 14.0000
UNITS: 14.0000
DIFF_1: Alc Oi Top
DIFF_2: Alc Oi Top
DIFF_3: Alc Oi Top
DIFF_4: Alc Oi Top
MARGIN: 14.0000
RETAIL: 14.0000
SUBCLASS: 1115
ITEM_DESC: Alc Oi Top Bottom Sales Gtt-003-EDGE
IMAGE_ADDR: Alc Oi Top Bottom Sales Gtt-003-EDGE
IMAGE_NAME: Alc Oi Top Bottom Sales Gtt Core
ITEM_PARENT: Alc Oi Top Bottom Sales G
ALC_ITEM_TYPE: Alc Oi Top Bott
TOP_BOTTOM_FLAG: Alc Oi
MARKUP_CALC_TYPE: C

Rule Validation Summary

Source Rule Count: 29
Governed Rule Count: 21