Store

In Scope

Technical: STORE | ID: OR-STO-STORE-STORE

an location within the organization that hold items. this could include a store, warehouse, a physical location, catalog, web page or other channel.

See how this object fits into Store Operations

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

Field Definitions(5)

Sample Load Data(4)

_scenario	IDR	NAMER	LANG	EMAIL	STORE	TAX_ID	AUTO_RCV	DISTRICT	DUNS_LOC	TIMEZONE	CREATE_ID	MALL_NAME	OPEN_DATE	SIM_STORE	CHANNEL_ID	CLOSE_DATE	DEFAULT_WH	FAX_NUMBER	STORE_NAME	STORE_TYPE	VAT_REGION	DUNS_NUMBER	ORG_UNIT_ID	REMERCH_IND	STORE_CLASS	STORE_NAME3	UPDATE_DATE	UPDATE_USER	LEGAL_ENTITY	PHONE_NUMBER	REMODEL_DATE	SISTER_STORE	STORE_FORMAT	STORE_NAME10	ACQUIRED_DATE	CURRENCY_CODE	PRICING_STORE	TIMEZONE_NAME	TRANSFER_ZONE	TSF_ENTITY_ID	LAST_UPDATE_ID	LOCALE_COUNTRY	STORE_MGR_NAME	WF_CUSTOMER_ID	CREATE_DATETIME	LINEAR_DISTANCE	LOCALE_LANGUAGE	STOP_ORDER_DAYS	STORE_OPEN_DATE	TOTAL_SQUARE_FT	VAT_INCLUDE_IND	ONLINE_STORE_IND	START_ORDER_DAYS	STOCKHOLDING_IND	STORE_CLOSE_DATE	TRANSFER_ZONE_ID	GIFT_WRAPPING_IND	SELLING_SQUARE_FT	TOTAL_SQUARE_FEET	TRAN_NO_GENERATED	INTEGRATED_POS_IND	ORIG_CURRENCY_CODE	SELLING_SQUARE_FEET	LAST_UPDATE_DATETIME	ORGANIZATION_UNIT_ID	STORE_NAME_SECONDARY	CUSTOMER_ORDER_LOC_IND	CUSTOMER_ORDER_SHIP_IND
Example values from field definitions	1	SAMPLE	1	SAMPLE	1	SAMPLE	S	1	SAMP	SAMPLE	SAMPLE	SAMPLE	2026-01-01	Y	1	2026-01-01	1	SAMPLE	SAMPLE	SAMPLE	1	SAMPLE	1	S	S	SAM	2026-01-01	SAMPLE	SAMPLE	SAMPLE	2026-01-01	1	1	SAMPLE	2026-01-01	SAMPLE	1	SAMPLE	1	1	SAMPLE	SAM	SAMPLE	1	2026-01-01	1	SAM	1	2026-01-01	1	S	S	1	S	2026-01-01	SAMPLE	S	1	1.00	SAMPLE	S	USD	1.00	2026-01-01	SAMPLE	SAMPLE	Y	S
default	3	Store-002-ALT	—	—	—	—	—	—	—	Store-002-ALT	—	—	2026-01-03	N	—	2026-01-03	—	—	—	—	—	—	—	—	—	—	2026-01-03	2026-01-02-ALT	—	—	—	—	—	—	—	ALT-STORE-002	—	—	—	—	—	Sto	—	—	—	—	Sto	—	—	—	—	—	—	—	—	ALT-STORE-002	—	—	12.50	—	—	—	12.50	—	ALT-STORE-002	—	Y	—
default	5	Store-003-EDGE	—	—	—	—	—	—	—	Store-003-EDGE	—	—	2026-01-05	Y	—	2026-01-05	—	—	—	—	—	—	—	—	—	—	2026-01-05	2026-01-03-EDGE	—	—	—	—	—	—	—	EDGE-STORE-003	—	—	—	—	—	Sto	—	—	—	—	Sto	—	—	—	—	—	—	—	—	EDGE-STORE-003	—	—	14.00	—	—	—	14.00	—	EDGE-STORE-003	—	N	—

Example values from field definitions

IDR: 1
NAMER: SAMPLE
LANG: 1
EMAIL: SAMPLE
STORE: 1
TAX_ID: SAMPLE
AUTO_RCV: S
DISTRICT: 1
DUNS_LOC: SAMP
TIMEZONE: SAMPLE
CREATE_ID: SAMPLE
MALL_NAME: SAMPLE
OPEN_DATE: 2026-01-01
SIM_STORE: Y
CHANNEL_ID: 1
CLOSE_DATE: 2026-01-01
DEFAULT_WH: 1
FAX_NUMBER: SAMPLE
STORE_NAME: SAMPLE
STORE_TYPE: SAMPLE
VAT_REGION: 1
DUNS_NUMBER: SAMPLE
ORG_UNIT_ID: 1
REMERCH_IND: S
STORE_CLASS: S
STORE_NAME3: SAM
UPDATE_DATE: 2026-01-01
UPDATE_USER: SAMPLE
LEGAL_ENTITY: SAMPLE
PHONE_NUMBER: SAMPLE
REMODEL_DATE: 2026-01-01
SISTER_STORE: 1
STORE_FORMAT: 1
STORE_NAME10: SAMPLE
ACQUIRED_DATE: 2026-01-01
CURRENCY_CODE: SAMPLE
PRICING_STORE: 1
TIMEZONE_NAME: SAMPLE
TRANSFER_ZONE: 1
TSF_ENTITY_ID: 1
LAST_UPDATE_ID: SAMPLE
LOCALE_COUNTRY: SAM
STORE_MGR_NAME: SAMPLE
WF_CUSTOMER_ID: 1
CREATE_DATETIME: 2026-01-01
LINEAR_DISTANCE: 1
LOCALE_LANGUAGE: SAM
STOP_ORDER_DAYS: 1
STORE_OPEN_DATE: 2026-01-01
TOTAL_SQUARE_FT: 1
VAT_INCLUDE_IND: S
ONLINE_STORE_IND: S
START_ORDER_DAYS: 1
STOCKHOLDING_IND: S
STORE_CLOSE_DATE: 2026-01-01
TRANSFER_ZONE_ID: SAMPLE
GIFT_WRAPPING_IND: S
SELLING_SQUARE_FT: 1
TOTAL_SQUARE_FEET: 1.00
TRAN_NO_GENERATED: SAMPLE
INTEGRATED_POS_IND: S
ORIG_CURRENCY_CODE: USD
SELLING_SQUARE_FEET: 1.00
LAST_UPDATE_DATETIME: 2026-01-01
ORGANIZATION_UNIT_ID: SAMPLE
STORE_NAME_SECONDARY: SAMPLE
CUSTOMER_ORDER_LOC_IND: Y
CUSTOMER_ORDER_SHIP_IND: S

default

IDR: 3
NAMER: Store-002-ALT
LANG: —
EMAIL: —
STORE: —
TAX_ID: —
AUTO_RCV: —
DISTRICT: —
DUNS_LOC: —
TIMEZONE: Store-002-ALT
CREATE_ID: —
MALL_NAME: —
OPEN_DATE: 2026-01-03
SIM_STORE: N
CHANNEL_ID: —
CLOSE_DATE: 2026-01-03
DEFAULT_WH: —
FAX_NUMBER: —
STORE_NAME: —
STORE_TYPE: —
VAT_REGION: —
DUNS_NUMBER: —
ORG_UNIT_ID: —
REMERCH_IND: —
STORE_CLASS: —
STORE_NAME3: —
UPDATE_DATE: 2026-01-03
UPDATE_USER: 2026-01-02-ALT
LEGAL_ENTITY: —
PHONE_NUMBER: —
REMODEL_DATE: —
SISTER_STORE: —
STORE_FORMAT: —
STORE_NAME10: —
ACQUIRED_DATE: —
CURRENCY_CODE: ALT-STORE-002
PRICING_STORE: —
TIMEZONE_NAME: —
TRANSFER_ZONE: —
TSF_ENTITY_ID: —
LAST_UPDATE_ID: —
LOCALE_COUNTRY: Sto
STORE_MGR_NAME: —
WF_CUSTOMER_ID: —
CREATE_DATETIME: —
LINEAR_DISTANCE: —
LOCALE_LANGUAGE: Sto
STOP_ORDER_DAYS: —
STORE_OPEN_DATE: —
TOTAL_SQUARE_FT: —
VAT_INCLUDE_IND: —
ONLINE_STORE_IND: —
START_ORDER_DAYS: —
STOCKHOLDING_IND: —
STORE_CLOSE_DATE: —
TRANSFER_ZONE_ID: ALT-STORE-002
GIFT_WRAPPING_IND: —
SELLING_SQUARE_FT: —
TOTAL_SQUARE_FEET: 12.50
TRAN_NO_GENERATED: —
INTEGRATED_POS_IND: —
ORIG_CURRENCY_CODE: —
SELLING_SQUARE_FEET: 12.50
LAST_UPDATE_DATETIME: —
ORGANIZATION_UNIT_ID: ALT-STORE-002
STORE_NAME_SECONDARY: —
CUSTOMER_ORDER_LOC_IND: Y
CUSTOMER_ORDER_SHIP_IND: —

default

IDR: 5
NAMER: Store-003-EDGE
LANG: —
EMAIL: —
STORE: —
TAX_ID: —
AUTO_RCV: —
DISTRICT: —
DUNS_LOC: —
TIMEZONE: Store-003-EDGE
CREATE_ID: —
MALL_NAME: —
OPEN_DATE: 2026-01-05
SIM_STORE: Y
CHANNEL_ID: —
CLOSE_DATE: 2026-01-05
DEFAULT_WH: —
FAX_NUMBER: —
STORE_NAME: —
STORE_TYPE: —
VAT_REGION: —
DUNS_NUMBER: —
ORG_UNIT_ID: —
REMERCH_IND: —
STORE_CLASS: —
STORE_NAME3: —
UPDATE_DATE: 2026-01-05
UPDATE_USER: 2026-01-03-EDGE
LEGAL_ENTITY: —
PHONE_NUMBER: —
REMODEL_DATE: —
SISTER_STORE: —
STORE_FORMAT: —
STORE_NAME10: —
ACQUIRED_DATE: —
CURRENCY_CODE: EDGE-STORE-003
PRICING_STORE: —
TIMEZONE_NAME: —
TRANSFER_ZONE: —
TSF_ENTITY_ID: —
LAST_UPDATE_ID: —
LOCALE_COUNTRY: Sto
STORE_MGR_NAME: —
WF_CUSTOMER_ID: —
CREATE_DATETIME: —
LINEAR_DISTANCE: —
LOCALE_LANGUAGE: Sto
STOP_ORDER_DAYS: —
STORE_OPEN_DATE: —
TOTAL_SQUARE_FT: —
VAT_INCLUDE_IND: —
ONLINE_STORE_IND: —
START_ORDER_DAYS: —
STOCKHOLDING_IND: —
STORE_CLOSE_DATE: —
TRANSFER_ZONE_ID: EDGE-STORE-003
GIFT_WRAPPING_IND: —
SELLING_SQUARE_FT: —
TOTAL_SQUARE_FEET: 14.00
TRAN_NO_GENERATED: —
INTEGRATED_POS_IND: —
ORIG_CURRENCY_CODE: —
SELLING_SQUARE_FEET: 14.00
LAST_UPDATE_DATETIME: —
ORGANIZATION_UNIT_ID: EDGE-STORE-003
STORE_NAME_SECONDARY: —
CUSTOMER_ORDER_LOC_IND: N
CUSTOMER_ORDER_SHIP_IND: —

Rule Validation Summary

Source Rule Count: 108
Governed Rule Count: 100

All objects