Cost Com (GTT)

Out of Scope

Technical: COST_COM_GTT | ID: OR-FND-COST_COM_GTT-COST_COM_GTT

This table will act as a helper table for future cost engine while applying the cost buildup templates to franchise stores.

See how this object fits into Foundation Data

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

Field Definitions(5)

Rules & Considerations(11)

Sample Load Data(4)

_scenario	ITEM	VALUE	COMP_ID	LOCATION	SUPPLIER	TEMPL_ID	COMP_RATE	PER_COUNT	ACTIVE_DATE	EXCHANGE_RATE	PER_COUNT_UOM	ORIGIN_COUNTRY_ID
Example values from field definitions	SAMPLE	1.0000	SAMPLE	1	1	1	1.0000	1.0000	2026-01-01	1.0000000000	SAMP	SAM
default	Cost Com Gtt-002-ALT	12.5000	ALT-COST_C	3	3	1000000003	12.5000	12.5000	2026-01-03	12.5000000000	Cost	ALT
default	Cost Com Gtt-003-EDGE	14.0000	EDGE-COST_	5	5	1000000005	14.0000	14.0000	2026-01-05	14.0000000000	Cost	EDG

Example values from field definitions

ITEM: SAMPLE
VALUE: 1.0000
COMP_ID: SAMPLE
LOCATION: 1
SUPPLIER: 1
TEMPL_ID: 1
COMP_RATE: 1.0000
PER_COUNT: 1.0000
ACTIVE_DATE: 2026-01-01
EXCHANGE_RATE: 1.0000000000
PER_COUNT_UOM: SAMP
ORIGIN_COUNTRY_ID: SAM

default

ITEM: Cost Com Gtt-002-ALT
VALUE: 12.5000
COMP_ID: ALT-COST_C
LOCATION: 3
SUPPLIER: 3
TEMPL_ID: 1000000003
COMP_RATE: 12.5000
PER_COUNT: 12.5000
ACTIVE_DATE: 2026-01-03
EXCHANGE_RATE: 12.5000000000
PER_COUNT_UOM: Cost
ORIGIN_COUNTRY_ID: ALT

default

ITEM: Cost Com Gtt-003-EDGE
VALUE: 14.0000
COMP_ID: EDGE-COST_
LOCATION: 5
SUPPLIER: 5
TEMPL_ID: 1000000005
COMP_RATE: 14.0000
PER_COUNT: 14.0000
ACTIVE_DATE: 2026-01-05
EXCHANGE_RATE: 14.0000000000
PER_COUNT_UOM: Cost
ORIGIN_COUNTRY_ID: EDG

Rule Validation Summary

Source Rule Count: 14
Governed Rule Count: 11