Outloc

In Scope

Technical: OUTLOC | ID: OR-FND-OUTLOC-OUTLOC

This table is used to store skeleton information about locations that fall outside of RMS Organization Hierarchy such as entry ports.

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

Field Definitions(5)

Rules & Considerations(36)

Sample Load Data(4)

_scenario	OUTLOC_IDRPK	OUTLOC_DESCR	OUTLOC_TYPERPK	CREATE_ID	CONTACT_FAX	OUTLOC_ADD1	OUTLOC_ADD2	OUTLOC_CITY	OUTLOC_POST	PRIMARY_IND	CONTACT_NAME	OUTLOC_STATE	CONTACT_EMAIL	CONTACT_PHONE	CONTACT_TELEX	CREATE_DATETIME	OUTLOC_CURRENCY	OUTLOC_COUNTRY_ID	OUTLOC_VAT_REGION	OUTLOC_NAME_SECONDARY	OUTLOC_JURISDICTION_CODE
Example values from field definitions	SAMPL	SAMPLE	SAMPLE	SAMPLE	SAMPLE	SAMPLE	SAMPLE	SAMPLE	SAMPLE	S	SAMPLE	SAM	SAMPLE	SAMPLE	SAMPLE	2026-01-01	SAM	SAM	1	SAMPLE	SAMPLE
default	ALT-O	Outloc-002-ALT	Outloc	C LIENT_INFO	Outloc-002-ALT	Outloc-002-ALT	Outloc-002-ALT	Outloc-002-ALT	Outloc-002-ALT	N	Outloc Secondary	Out	Outloc-002-ALT	Outloc-002-ALT	Outloc-002-ALT	2026-01-03	Out	ALT	203	Outloc-002-ALT	ALT-OUTLOC
default	EDGE-	Outloc-003-EDGE	Outloc	USE RENV	Outloc-003-EDGE	Outloc-003-EDGE	Outloc-003-EDGE	Outloc-003-EDGE	Outloc-003-EDGE	N	Outloc Core	Out	Outloc-003-EDGE	Outloc-003-EDGE	Outloc-003-EDGE	2026-01-05	Out	EDG	205	Outloc-003-EDGE	EDGE-OUTLO

Example values from field definitions

OUTLOC_IDRPK: SAMPL
OUTLOC_DESCR: SAMPLE
OUTLOC_TYPERPK: SAMPLE
CREATE_ID: SAMPLE
CONTACT_FAX: SAMPLE
OUTLOC_ADD1: SAMPLE
OUTLOC_ADD2: SAMPLE
OUTLOC_CITY: SAMPLE
OUTLOC_POST: SAMPLE
PRIMARY_IND: S
CONTACT_NAME: SAMPLE
OUTLOC_STATE: SAM
CONTACT_EMAIL: SAMPLE
CONTACT_PHONE: SAMPLE
CONTACT_TELEX: SAMPLE
CREATE_DATETIME: 2026-01-01
OUTLOC_CURRENCY: SAM
OUTLOC_COUNTRY_ID: SAM
OUTLOC_VAT_REGION: 1
OUTLOC_NAME_SECONDARY: SAMPLE
OUTLOC_JURISDICTION_CODE: SAMPLE

default

OUTLOC_IDRPK: ALT-O
OUTLOC_DESCR: Outloc-002-ALT
OUTLOC_TYPERPK: Outloc
CREATE_ID: C LIENT_INFO
CONTACT_FAX: Outloc-002-ALT
OUTLOC_ADD1: Outloc-002-ALT
OUTLOC_ADD2: Outloc-002-ALT
OUTLOC_CITY: Outloc-002-ALT
OUTLOC_POST: Outloc-002-ALT
PRIMARY_IND: N
CONTACT_NAME: Outloc Secondary
OUTLOC_STATE: Out
CONTACT_EMAIL: Outloc-002-ALT
CONTACT_PHONE: Outloc-002-ALT
CONTACT_TELEX: Outloc-002-ALT
CREATE_DATETIME: 2026-01-03
OUTLOC_CURRENCY: Out
OUTLOC_COUNTRY_ID: ALT
OUTLOC_VAT_REGION: 203
OUTLOC_NAME_SECONDARY: Outloc-002-ALT
OUTLOC_JURISDICTION_CODE: ALT-OUTLOC

default

OUTLOC_IDRPK: EDGE-
OUTLOC_DESCR: Outloc-003-EDGE
OUTLOC_TYPERPK: Outloc
CREATE_ID: USE RENV
CONTACT_FAX: Outloc-003-EDGE
OUTLOC_ADD1: Outloc-003-EDGE
OUTLOC_ADD2: Outloc-003-EDGE
OUTLOC_CITY: Outloc-003-EDGE
OUTLOC_POST: Outloc-003-EDGE
PRIMARY_IND: N
CONTACT_NAME: Outloc Core
OUTLOC_STATE: Out
CONTACT_EMAIL: Outloc-003-EDGE
CONTACT_PHONE: Outloc-003-EDGE
CONTACT_TELEX: Outloc-003-EDGE
CREATE_DATETIME: 2026-01-05
OUTLOC_CURRENCY: Out
OUTLOC_COUNTRY_ID: EDG
OUTLOC_VAT_REGION: 205
OUTLOC_NAME_SECONDARY: Outloc-003-EDGE
OUTLOC_JURISDICTION_CODE: EDGE-OUTLO

Rule Validation Summary

Source Rule Count: 41
Governed Rule Count: 36