Store
In ScopeTechnical: STORE | ID: OR-MFCS-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
Target Structure
- Load Approach
- Table
- Target Objects
- STORE
Field Definitions(54)
Rules & Considerations(49)
Sample Load Data(4)
| _scenario | LANGRPK | STORERPK | AUTO_RCVR | DISTRICTRPK | CREATE_IDR | CHANNEL_IDPK | DEFAULT_WHPK | STORE_NAMER | STORE_TYPER | VAT_REGIONPK | ORG_UNIT_IDPK | REMERCH_INDR | STORE_CLASSR | STORE_NAME3R | SISTER_STOREPK | STORE_FORMATPK | STORE_NAME10R | CURRENCY_CODERPK | TIMEZONE_NAMER | TRANSFER_ZONEPK | TSF_ENTITY_IDPK | LAST_UPDATE_IDR | STORE_MGR_NAMER | WF_CUSTOMER_IDPK | 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 | FAX_NUMBER | DUNS_NUMBER | LEGAL_ENTITY | PHONE_NUMBER | REMODEL_DATE | ACQUIRED_DATE | PRICING_STORE | LINEAR_DISTANCE | STOP_ORDER_DAYS | TOTAL_SQUARE_FT | VAT_INCLUDE_IND | ONLINE_STORE_IND | STORE_CLOSE_DATE | SELLING_SQUARE_FT | STORE_NAME_SECONDARY | CUSTOMER_ORDER_LOC_IND | |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| default | 000001 | 1001 | D | 301 | USERENV | 100001 | 9001 | Store Primary | C | 0201 | 1000000001 | N | Store-001 | Store-001 | 1001 | 0001 | Store-001 | STD-STORE-001 | Store Primary | 0001 | 1000000001 | RETAIL_CTX | Store Primary | 1000000001 | 2026-01-01 | 2026-01-01 | 001 | Store-001 | N | Store-001 | Store-001 | STD-STORE-001 | 2026-01-01 | N | Store-001 | STD-STORE-001 | Store-001 | Store Primary | Store-001 | Store-001 | Store-001 | Store-001 | 2026-01-01 | 2026-01-01 | 1001 | 1 | 001 | 1 | Y | Store-001 | 2026-01-01 | 1 | Store-001 | Store-001 |
default
- LANGRPK
- 000001
- STORERPK
- 1001
- AUTO_RCVR
- D
- DISTRICTRPK
- 301
- CREATE_IDR
- USERENV
- CHANNEL_IDPK
- 100001
- DEFAULT_WHPK
- 9001
- STORE_NAMER
- Store Primary
- STORE_TYPER
- C
- VAT_REGIONPK
- 0201
- ORG_UNIT_IDPK
- 1000000001
- REMERCH_INDR
- N
- STORE_CLASSR
- Store-001
- STORE_NAME3R
- Store-001
- SISTER_STOREPK
- 1001
- STORE_FORMATPK
- 0001
- STORE_NAME10R
- Store-001
- CURRENCY_CODERPK
- STD-STORE-001
- TIMEZONE_NAMER
- Store Primary
- TRANSFER_ZONEPK
- 0001
- TSF_ENTITY_IDPK
- 1000000001
- LAST_UPDATE_IDR
- RETAIL_CTX
- STORE_MGR_NAMER
- Store Primary
- WF_CUSTOMER_IDPK
- 1000000001
- CREATE_DATETIMER
- 2026-01-01
- STORE_OPEN_DATER
- 2026-01-01
- START_ORDER_DAYSR
- 001
- STOCKHOLDING_INDR
- Store-001
- GIFT_WRAPPING_INDR
- N
- TRAN_NO_GENERATEDR
- Store-001
- INTEGRATED_POS_INDR
- Store-001
- ORIG_CURRENCY_CODER
- STD-STORE-001
- LAST_UPDATE_DATETIMER
- 2026-01-01
- CUSTOMER_ORDER_SHIP_INDR
- N
- Store-001
- TAX_ID
- STD-STORE-001
- DUNS_LOC
- Store-001
- MALL_NAME
- Store Primary
- FAX_NUMBER
- Store-001
- DUNS_NUMBER
- Store-001
- LEGAL_ENTITY
- Store-001
- PHONE_NUMBER
- Store-001
- REMODEL_DATE
- 2026-01-01
- ACQUIRED_DATE
- 2026-01-01
- PRICING_STORE
- 1001
- LINEAR_DISTANCE
- 1
- STOP_ORDER_DAYS
- 001
- TOTAL_SQUARE_FT
- 1
- VAT_INCLUDE_IND
- Y
- ONLINE_STORE_IND
- Store-001
- STORE_CLOSE_DATE
- 2026-01-01
- SELLING_SQUARE_FT
- 1
- STORE_NAME_SECONDARY
- Store-001
- CUSTOMER_ORDER_LOC_IND
- Store-001