Competitors

In Scope

Technical: COMPETITOR | ID: OR-FND-COMPETITOR-COMPETITOR

This table is used to store all competitors.

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

Field Definitions(5)

Rules & Considerations(19)

constraint

validation

Sample Load Data(4)

_scenario	COMP_NAMER	COMPETITORRPK	FAX	CITY	PHONE	STATE	WEBSITE	ADDRESS_1	ADDRESS_2	ADDRESS_3	POST_CODE	COUNTRY_ID	JURISDICTION_CODE
Example values from field definitions	SAMPLE	1	SAMPLE	SAMPLE	SAMPLE	SAM	SAMPLE	SAMPLE	SAMPLE	SAMPLE	SAMPLE	SAM	SAMPLE
default	Competitor Secondary	3	Competitor-002-ALT	Competitor-002-ALT	Competitor-002-ALT	Com	Competitor-002-ALT	Competitor-002-ALT	Competitor-002-ALT	Competitor-002-ALT	ALT-COMPETITOR-002	ALT	ALT-COMPET
default	Competitor Core	5	Competitor-003-EDGE	Competitor-003-EDGE	Competitor-003-EDGE	Com	Competitor-003-EDGE	Competitor-003-EDGE	Competitor-003-EDGE	Competitor-003-EDGE	EDGE-COMPETITOR-003	EDG	EDGE-COMPE

Example values from field definitions

COMP_NAMER: SAMPLE
COMPETITORRPK: 1
FAX: SAMPLE
CITY: SAMPLE
PHONE: SAMPLE
STATE: SAM
WEBSITE: SAMPLE
ADDRESS_1: SAMPLE
ADDRESS_2: SAMPLE
ADDRESS_3: SAMPLE
POST_CODE: SAMPLE
COUNTRY_ID: SAM
JURISDICTION_CODE: SAMPLE

default

COMP_NAMER: Competitor Secondary
COMPETITORRPK: 3
FAX: Competitor-002-ALT
CITY: Competitor-002-ALT
PHONE: Competitor-002-ALT
STATE: Com
WEBSITE: Competitor-002-ALT
ADDRESS_1: Competitor-002-ALT
ADDRESS_2: Competitor-002-ALT
ADDRESS_3: Competitor-002-ALT
POST_CODE: ALT-COMPETITOR-002
COUNTRY_ID: ALT
JURISDICTION_CODE: ALT-COMPET

default

COMP_NAMER: Competitor Core
COMPETITORRPK: 5
FAX: Competitor-003-EDGE
CITY: Competitor-003-EDGE
PHONE: Competitor-003-EDGE
STATE: Com
WEBSITE: Competitor-003-EDGE
ADDRESS_1: Competitor-003-EDGE
ADDRESS_2: Competitor-003-EDGE
ADDRESS_3: Competitor-003-EDGE
POST_CODE: EDGE-COMPETITOR-003
COUNTRY_ID: EDG
JURISDICTION_CODE: EDGE-COMPE

Rule Validation Summary

Source Rule Count: 24
Governed Rule Count: 19