Item Country L10N Extension

In Scope

Technical: ITEM_COUNTRY_L10N_EXT | ID: OR-ITM-ITEM_COUNTRY_L10N_EXT-ITEM_COUNTRY_L10N_EXTENSION

In a GTAX (where SYSTEM_OPTIONS.DEFAULT_TAX_TYPE = GTAX ) environment, this table holds the fiscal attributes of a country associated with each item. Currently, Brazil is the only country supported for...

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

Classification

Object Type: dictionary

Target Structure

Load Approach: Table
Target Objects: ITEM_COUNTRY_L10N_EXT

Field Definitions(5)

Rules & Considerations(35)

constraint

validation

Sample Load Data(4)

_scenario	ITEMRPK	GROUP_IDRPK	COUNTRY_IDR	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	SAMPLE	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	Item Country L10N Ext-002	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	Item Country L10N Ext-002-ALT	Item Country L10N Ext-002-ALT	Item Country L10N Ext-002-ALT	Item Country L10N Ext-002-ALT	Item Country L10N Ext-002-ALT	Item Country L10N Ext-002-ALT	Item Country L10N Ext-002-ALT	Item Country L10N Ext-002-ALT	Item Country L10N Ext-002-ALT	Item Country L10N Ext-002-ALT
default	Item Country L10N Ext-003	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	Item Country L10N Ext-003-EDGE	Item Country L10N Ext-003-EDGE	Item Country L10N Ext-003-EDGE	Item Country L10N Ext-003-EDGE	Item Country L10N Ext-003-EDGE	Item Country L10N Ext-003-EDGE	Item Country L10N Ext-003-EDGE	Item Country L10N Ext-003-EDGE	Item Country L10N Ext-003-EDGE	Item Country L10N Ext-003-EDGE

Example values from field definitions

ITEMRPK: SAMPLE
GROUP_IDRPK: 1
COUNTRY_IDR: 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

ITEMRPK: Item Country L10N Ext-002
GROUP_IDRPK: 1000000003
COUNTRY_IDR: 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: Item Country L10N Ext-002-ALT
VARCHAR2_2: Item Country L10N Ext-002-ALT
VARCHAR2_3: Item Country L10N Ext-002-ALT
VARCHAR2_4: Item Country L10N Ext-002-ALT
VARCHAR2_5: Item Country L10N Ext-002-ALT
VARCHAR2_6: Item Country L10N Ext-002-ALT
VARCHAR2_7: Item Country L10N Ext-002-ALT
VARCHAR2_8: Item Country L10N Ext-002-ALT
VARCHAR2_9: Item Country L10N Ext-002-ALT
VARCHAR2_10: Item Country L10N Ext-002-ALT