Ordcust L10N Extension

In Scope

Technical: ORDCUST_L10N_EXT | ID: OR-PUR-ORDCUST_L10N_EXT-ORDCUST_L10N_EXTENSION

This extension table will hold the customer order localization extension attributes.

See how this object fits into Purchasing

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

Field Definitions(5)

Rules & Considerations(32)

constraint

validation

Sample Load Data(4)

_scenario	GROUP_IDRPK	ORDCUST_NORPK	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	1	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	4	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	Ordcust L10N Ext-002-ALT	Ordcust L10N Ext-002-ALT	Ordcust L10N Ext-002-ALT	Ordcust L10N Ext-002-ALT	Ordcust L10N Ext-002-ALT	Ordcust L10N Ext-002-ALT	Ordcust L10N Ext-002-ALT	Ordcust L10N Ext-002-ALT	Ordcust L10N Ext-002-ALT	Ordcust L10N Ext-002-ALT
default	1000000005	6	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	Ordcust L10N Ext-003-EDGE	Ordcust L10N Ext-003-EDGE	Ordcust L10N Ext-003-EDGE	Ordcust L10N Ext-003-EDGE	Ordcust L10N Ext-003-EDGE	Ordcust L10N Ext-003-EDGE	Ordcust L10N Ext-003-EDGE	Ordcust L10N Ext-003-EDGE	Ordcust L10N Ext-003-EDGE	Ordcust L10N Ext-003-EDGE

Example values from field definitions

GROUP_IDRPK: 1
ORDCUST_NORPK: 1
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
ORDCUST_NORPK: 4
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: Ordcust L10N Ext-002-ALT
VARCHAR2_2: Ordcust L10N Ext-002-ALT
VARCHAR2_3: Ordcust L10N Ext-002-ALT
VARCHAR2_4: Ordcust L10N Ext-002-ALT
VARCHAR2_5: Ordcust L10N Ext-002-ALT
VARCHAR2_6: Ordcust L10N Ext-002-ALT
VARCHAR2_7: Ordcust L10N Ext-002-ALT
VARCHAR2_8: Ordcust L10N Ext-002-ALT
VARCHAR2_9: Ordcust L10N Ext-002-ALT
VARCHAR2_10: Ordcust L10N Ext-002-ALT

default

GROUP_IDRPK: 1000000005
ORDCUST_NORPK: 6
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: Ordcust L10N Ext-003-EDGE
VARCHAR2_2: Ordcust L10N Ext-003-EDGE
VARCHAR2_3: Ordcust L10N Ext-003-EDGE
VARCHAR2_4: Ordcust L10N Ext-003-EDGE
VARCHAR2_5: Ordcust L10N Ext-003-EDGE
VARCHAR2_6: Ordcust L10N Ext-003-EDGE
VARCHAR2_7: Ordcust L10N Ext-003-EDGE
VARCHAR2_8: Ordcust L10N Ext-003-EDGE
VARCHAR2_9: Ordcust L10N Ext-003-EDGE
VARCHAR2_10: Ordcust L10N Ext-003-EDGE

Rule Validation Summary

Source Rule Count: 38
Governed Rule Count: 32