One Row For Each Store
In ScopeTechnical: STORE | ID: OR-FND-STORE-STORE
Stores one row for each store within the company.
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
- STORE
Field Definitions(68)
Rules & Considerations(111)
validation
constraint
Sample Load Data(4)
| _scenario | LANGRPK | NAMER | STORERPK | AUTO_RCVR | DISTRICTRPK | TIMEZONER | CREATE_IDR | SIM_STORER | CHANNEL_IDRPK | DEFAULT_WHRPK | STORE_NAMER | STORE_TYPER | VAT_REGIONRPK | ORG_UNIT_IDRPK | REMERCH_INDR | STORE_CLASSR | STORE_NAME3R | SISTER_STORERPK | STORE_FORMATRPK | STORE_NAME10R | CURRENCY_CODERPK | TIMEZONE_NAMER | TRANSFER_ZONERPK | TSF_ENTITY_IDRPK | LAST_UPDATE_IDR | STORE_MGR_NAMER | WF_CUSTOMER_IDRPK | CREATE_DATETIMER | STORE_OPEN_DATER | START_ORDER_DAYSR | STOCKHOLDING_INDR | GIFT_WRAPPING_INDR | TRAN_NO_GENERATEDR | INTEGRATED_POS_INDR | ORIG_CURRENCY_CODER | LAST_UPDATE_DATETIMER | CUSTOMER_ORDER_SHIP_INDR | TAX_ID | DUNS_LOC | MALL_NAME | OPEN_DATE | CLOSE_DATE | FAX_NUMBER | DUNS_NUMBER | UPDATE_DATE | UPDATE_USER | LEGAL_ENTITY | PHONE_NUMBER | REMODEL_DATE | ACQUIRED_DATE | PRICING_STORE | LOCALE_COUNTRY | LINEAR_DISTANCE | LOCALE_LANGUAGE | STOP_ORDER_DAYS | TOTAL_SQUARE_FT | VAT_INCLUDE_IND | ONLINE_STORE_IND | STORE_CLOSE_DATE | TRANSFER_ZONE_ID | SELLING_SQUARE_FT | TOTAL_SQUARE_FEET | SELLING_SQUARE_FEET | ORGANIZATION_UNIT_ID | STORE_NAME_SECONDARY | CUSTOMER_ORDER_LOC_IND | |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| Example values from field definitions | 1 | SAMPLE | 1 | S | 1 | SAMPLE | SAMPLE | Y | 1 | 1 | SAMPLE | SAMPLE | 1 | 1 | S | S | SAM | 1 | 1 | SAMPLE | SAM | SAMPLE | 1 | 1 | SAMPLE | SAMPLE | 1 | 2026-01-01 | 2026-01-01 | 1 | S | S | SAMPLE | S | SAM | 2026-01-01 | S | SAMPLE | SAMPLE | SAMP | SAMPLE | 2026-01-01 | 2026-01-01 | SAMPLE | SAMPLE | 2026-01-01 | SAMPLE | SAMPLE | SAMPLE | 2026-01-01 | 2026-01-01 | 1 | SAM | 1 | SA | 1 | 1 | S | S | 2026-01-01 | SAMPLE | 1 | 1.00 | 1.00 | SAMPLE | SAMPLE | S |
Example values from field definitions
- LANGRPK
- 1
- NAMER
- SAMPLE
- STORERPK
- 1
- AUTO_RCVR
- S
- DISTRICTRPK
- 1
- TIMEZONER
- SAMPLE
- CREATE_IDR
- SAMPLE
- SIM_STORER
- Y
- CHANNEL_IDRPK
- 1
- DEFAULT_WHRPK
- 1
- STORE_NAMER
- SAMPLE
- STORE_TYPER
- SAMPLE
- VAT_REGIONRPK
- 1
- ORG_UNIT_IDRPK
- 1
- REMERCH_INDR
- S
- STORE_CLASSR
- S
- STORE_NAME3R
- SAM
- SISTER_STORERPK
- 1
- STORE_FORMATRPK
- 1
- STORE_NAME10R
- SAMPLE
- CURRENCY_CODERPK
- SAM
- TIMEZONE_NAMER
- SAMPLE
- TRANSFER_ZONERPK
- 1
- TSF_ENTITY_IDRPK
- 1
- LAST_UPDATE_IDR
- SAMPLE
- STORE_MGR_NAMER
- SAMPLE
- WF_CUSTOMER_IDRPK
- 1
- CREATE_DATETIMER
- 2026-01-01
- STORE_OPEN_DATER
- 2026-01-01
- START_ORDER_DAYSR
- 1
- STOCKHOLDING_INDR
- S
- GIFT_WRAPPING_INDR
- S
- TRAN_NO_GENERATEDR
- SAMPLE
- INTEGRATED_POS_INDR
- S
- ORIG_CURRENCY_CODER
- SAM
- LAST_UPDATE_DATETIMER
- 2026-01-01
- CUSTOMER_ORDER_SHIP_INDR
- S
- SAMPLE
- TAX_ID
- SAMPLE
- DUNS_LOC
- SAMP
- MALL_NAME
- SAMPLE
- OPEN_DATE
- 2026-01-01
- CLOSE_DATE
- 2026-01-01
- FAX_NUMBER
- SAMPLE
- DUNS_NUMBER
- SAMPLE
- UPDATE_DATE
- 2026-01-01
- UPDATE_USER
- SAMPLE
- LEGAL_ENTITY
- SAMPLE
- PHONE_NUMBER
- SAMPLE
- REMODEL_DATE
- 2026-01-01
- ACQUIRED_DATE
- 2026-01-01
- PRICING_STORE
- 1
- LOCALE_COUNTRY
- SAM
- LINEAR_DISTANCE
- 1
- LOCALE_LANGUAGE
- SA
- STOP_ORDER_DAYS
- 1
- TOTAL_SQUARE_FT
- 1
- VAT_INCLUDE_IND
- S
- ONLINE_STORE_IND
- S
- STORE_CLOSE_DATE
- 2026-01-01
- TRANSFER_ZONE_ID
- SAMPLE
- SELLING_SQUARE_FT
- 1
- TOTAL_SQUARE_FEET
- 1.00
- SELLING_SQUARE_FEET
- 1.00
- ORGANIZATION_UNIT_ID
- SAMPLE
- STORE_NAME_SECONDARY
- SAMPLE
- CUSTOMER_ORDER_LOC_IND
- S
Rule Validation Summary
- Source Rule Count
- 158
- Governed Rule Count
- 111