Country L10N Extension

In Scope

Technical: COUNTRY_L10N_EXT | ID: OR-FND-COUNTRY_L10N_EXT-COUNTRY_L10N_EXTENSION

This is the LFAS storage table for the entity COUNTRY.

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

Target Structure

Load Approach: Table
Target Objects: COUNTRY_L10N_EXT

Field Definitions(5)

Rules & Considerations(32)

constraint

validation

Sample Load Data(4)

_scenario	GROUP_IDRPK	COUNTRY_IDRPK	L10N_COUNTRY_IDRPK	DATE_21	DATE_22	NUMBER_11	NUMBER_12	NUMBER_13	NUMBER_14	NUMBER_15	NUMBER_16	NUMBER_17	NUMBER_18	NUMBER_19	NUMBER_20	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	1	SAM	SAM	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	1000000003	ALT	ALT	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	Country L10N Ext-002-ALT	Country L10N Ext-002-ALT	Country L10N Ext-002-ALT	Country L10N Ext-002-ALT	Country L10N Ext-002-ALT	Country L10N Ext-002-ALT	Country L10N Ext-002-ALT	Country L10N Ext-002-ALT	Country L10N Ext-002-ALT	Country L10N Ext-002-ALT
default	1000000005	EDG	EDG	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	Country L10N Ext-003-EDGE	Country L10N Ext-003-EDGE	Country L10N Ext-003-EDGE	Country L10N Ext-003-EDGE	Country L10N Ext-003-EDGE	Country L10N Ext-003-EDGE	Country L10N Ext-003-EDGE	Country L10N Ext-003-EDGE	Country L10N Ext-003-EDGE	Country L10N Ext-003-EDGE

Example values from field definitions

GROUP_IDRPK: 1
COUNTRY_IDRPK: SAM
L10N_COUNTRY_IDRPK: SAM
DATE_21: 2026-01-01
DATE_22: 2026-01-01
NUMBER_11: 1.0000
NUMBER_12: 1.0000
NUMBER_13: 1.0000
NUMBER_14: 1.0000
NUMBER_15: 1.0000
NUMBER_16: 1.0000
NUMBER_17: 1.0000
NUMBER_18: 1.0000
NUMBER_19: 1.0000
NUMBER_20: 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

GROUP_IDRPK: 1000000003
COUNTRY_IDRPK: ALT
L10N_COUNTRY_IDRPK: ALT
DATE_21: 2026-01-03
DATE_22: 2026-01-03
NUMBER_11: 12.5000
NUMBER_12: 12.5000
NUMBER_13: 12.5000
NUMBER_14: 12.5000
NUMBER_15: 12.5000
NUMBER_16: 12.5000
NUMBER_17: 12.5000
NUMBER_18: 12.5000
NUMBER_19: 12.5000
NUMBER_20: 12.5000
VARCHAR2_1: Country L10N Ext-002-ALT
VARCHAR2_2: Country L10N Ext-002-ALT
VARCHAR2_3: Country L10N Ext-002-ALT
VARCHAR2_4: Country L10N Ext-002-ALT
VARCHAR2_5: Country L10N Ext-002-ALT
VARCHAR2_6: Country L10N Ext-002-ALT
VARCHAR2_7: Country L10N Ext-002-ALT
VARCHAR2_8: Country L10N Ext-002-ALT
VARCHAR2_9: Country L10N Ext-002-ALT
VARCHAR2_10: Country L10N Ext-002-ALT

default

GROUP_IDRPK: 1000000005
COUNTRY_IDRPK: EDG
L10N_COUNTRY_IDRPK: EDG
DATE_21: 2026-01-05
DATE_22: 2026-01-05
NUMBER_11: 14.0000
NUMBER_12: 14.0000
NUMBER_13: 14.0000
NUMBER_14: 14.0000
NUMBER_15: 14.0000
NUMBER_16: 14.0000
NUMBER_17: 14.0000
NUMBER_18: 14.0000
NUMBER_19: 14.0000
NUMBER_20: 14.0000
VARCHAR2_1: Country L10N Ext-003-EDGE
VARCHAR2_2: Country L10N Ext-003-EDGE
VARCHAR2_3: Country L10N Ext-003-EDGE
VARCHAR2_4: Country L10N Ext-003-EDGE
VARCHAR2_5: Country L10N Ext-003-EDGE
VARCHAR2_6: Country L10N Ext-003-EDGE
VARCHAR2_7: Country L10N Ext-003-EDGE
VARCHAR2_8: Country L10N Ext-003-EDGE
VARCHAR2_9: Country L10N Ext-003-EDGE
VARCHAR2_10: Country L10N Ext-003-EDGE

Rule Validation Summary

Source Rule Count: 37
Governed Rule Count: 32