Gtt 10 Number 10 Str 10 Date

Out of Scope

Technical: GTT_10_NUM_10_STR_10_DATE | ID: OR-FND-GTT_10_NUM_10_STR_10_DATE-GTT_10_NUM_10_STR_10_DATE

A global temporary table with ten numeric values, string values, and date values.

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

Field Definitions(5)

Rules & Considerations(20)

Sample Load Data(4)

_scenario	DATE_1	DATE_2	DATE_3	DATE_4	DATE_5	DATE_6	DATE_7	DATE_8	DATE_9	DATE_10	NUMBER_1	NUMBER_2	NUMBER_3	NUMBER_4	NUMBER_5	NUMBER_6	NUMBER_7	NUMBER_8	NUMBER_9	NUMBER_10	VARCHAR2_1	VARCHAR2_2	VARCHAR2_3	VARCHAR2_4	VARCHAR2_5	VARCHAR2_6	VARCHAR2_7	VARCHAR2_8	VARCHAR2_9	VARCHAR2_10
Example values from field definitions	2026-01-01	2026-01-01	2026-01-01	2026-01-01	2026-01-01	2026-01-01	2026-01-01	2026-01-01	2026-01-01	2026-01-01	1.0000	1.0000	1.0000	1.0000	1.0000	1.0000	1.0000	1.0000	1.0000	1.0000	SAMPLE	SAMPLE	SAMPLE	SAMPLE	SAMPLE	SAMPLE	SAMPLE	SAMPLE	SAMPLE	SAMPLE
default	2026-01-03	2026-01-03	2026-01-03	2026-01-03	2026-01-03	2026-01-03	2026-01-03	2026-01-03	2026-01-03	2026-01-03	12.5000	12.5000	12.5000	12.5000	12.5000	12.5000	12.5000	12.5000	12.5000	12.5000	Gtt 10 Num 10 Str 10 Date-002-ALT	Gtt 10 Num 10 Str 10 Date-002-ALT	Gtt 10 Num 10 Str 10 Date-002-ALT	Gtt 10 Num 10 Str 10 Date-002-ALT	Gtt 10 Num 10 Str 10 Date-002-ALT	Gtt 10 Num 10 Str 10 Date-002-ALT	Gtt 10 Num 10 Str 10 Date-002-ALT	Gtt 10 Num 10 Str 10 Date-002-ALT	Gtt 10 Num 10 Str 10 Date-002-ALT	Gtt 10 Num 10 Str 10 Date-002-ALT
default	2026-01-05	2026-01-05	2026-01-05	2026-01-05	2026-01-05	2026-01-05	2026-01-05	2026-01-05	2026-01-05	2026-01-05	14.0000	14.0000	14.0000	14.0000	14.0000	14.0000	14.0000	14.0000	14.0000	14.0000	Gtt 10 Num 10 Str 10 Date-003-EDGE	Gtt 10 Num 10 Str 10 Date-003-EDGE	Gtt 10 Num 10 Str 10 Date-003-EDGE	Gtt 10 Num 10 Str 10 Date-003-EDGE	Gtt 10 Num 10 Str 10 Date-003-EDGE	Gtt 10 Num 10 Str 10 Date-003-EDGE	Gtt 10 Num 10 Str 10 Date-003-EDGE	Gtt 10 Num 10 Str 10 Date-003-EDGE	Gtt 10 Num 10 Str 10 Date-003-EDGE	Gtt 10 Num 10 Str 10 Date-003-EDGE

Example values from field definitions

DATE_1: 2026-01-01
DATE_2: 2026-01-01
DATE_3: 2026-01-01
DATE_4: 2026-01-01
DATE_5: 2026-01-01
DATE_6: 2026-01-01
DATE_7: 2026-01-01
DATE_8: 2026-01-01
DATE_9: 2026-01-01
DATE_10: 2026-01-01
NUMBER_1: 1.0000
NUMBER_2: 1.0000
NUMBER_3: 1.0000
NUMBER_4: 1.0000
NUMBER_5: 1.0000
NUMBER_6: 1.0000
NUMBER_7: 1.0000
NUMBER_8: 1.0000
NUMBER_9: 1.0000
NUMBER_10: 1.0000
VARCHAR2_1: SAMPLE
VARCHAR2_2: SAMPLE
VARCHAR2_3: SAMPLE
VARCHAR2_4: SAMPLE
VARCHAR2_5: SAMPLE
VARCHAR2_6: SAMPLE
VARCHAR2_7: SAMPLE
VARCHAR2_8: SAMPLE
VARCHAR2_9: SAMPLE
VARCHAR2_10: SAMPLE

default

DATE_1: 2026-01-03
DATE_2: 2026-01-03
DATE_3: 2026-01-03
DATE_4: 2026-01-03
DATE_5: 2026-01-03
DATE_6: 2026-01-03
DATE_7: 2026-01-03
DATE_8: 2026-01-03
DATE_9: 2026-01-03
DATE_10: 2026-01-03
NUMBER_1: 12.5000
NUMBER_2: 12.5000
NUMBER_3: 12.5000
NUMBER_4: 12.5000
NUMBER_5: 12.5000
NUMBER_6: 12.5000
NUMBER_7: 12.5000
NUMBER_8: 12.5000
NUMBER_9: 12.5000
NUMBER_10: 12.5000
VARCHAR2_1: Gtt 10 Num 10 Str 10 Date-002-ALT
VARCHAR2_2: Gtt 10 Num 10 Str 10 Date-002-ALT
VARCHAR2_3: Gtt 10 Num 10 Str 10 Date-002-ALT
VARCHAR2_4: Gtt 10 Num 10 Str 10 Date-002-ALT
VARCHAR2_5: Gtt 10 Num 10 Str 10 Date-002-ALT
VARCHAR2_6: Gtt 10 Num 10 Str 10 Date-002-ALT
VARCHAR2_7: Gtt 10 Num 10 Str 10 Date-002-ALT
VARCHAR2_8: Gtt 10 Num 10 Str 10 Date-002-ALT
VARCHAR2_9: Gtt 10 Num 10 Str 10 Date-002-ALT
VARCHAR2_10: Gtt 10 Num 10 Str 10 Date-002-ALT

default

DATE_1: 2026-01-05
DATE_2: 2026-01-05
DATE_3: 2026-01-05
DATE_4: 2026-01-05
DATE_5: 2026-01-05
DATE_6: 2026-01-05
DATE_7: 2026-01-05
DATE_8: 2026-01-05
DATE_9: 2026-01-05
DATE_10: 2026-01-05
NUMBER_1: 14.0000
NUMBER_2: 14.0000
NUMBER_3: 14.0000
NUMBER_4: 14.0000
NUMBER_5: 14.0000
NUMBER_6: 14.0000
NUMBER_7: 14.0000
NUMBER_8: 14.0000
NUMBER_9: 14.0000
NUMBER_10: 14.0000
VARCHAR2_1: Gtt 10 Num 10 Str 10 Date-003-EDGE
VARCHAR2_2: Gtt 10 Num 10 Str 10 Date-003-EDGE
VARCHAR2_3: Gtt 10 Num 10 Str 10 Date-003-EDGE
VARCHAR2_4: Gtt 10 Num 10 Str 10 Date-003-EDGE
VARCHAR2_5: Gtt 10 Num 10 Str 10 Date-003-EDGE
VARCHAR2_6: Gtt 10 Num 10 Str 10 Date-003-EDGE
VARCHAR2_7: Gtt 10 Num 10 Str 10 Date-003-EDGE
VARCHAR2_8: Gtt 10 Num 10 Str 10 Date-003-EDGE
VARCHAR2_9: Gtt 10 Num 10 Str 10 Date-003-EDGE
VARCHAR2_10: Gtt 10 Num 10 Str 10 Date-003-EDGE

Rule Validation Summary

Source Rule Count: 23
Governed Rule Count: 20

All objects