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 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)
Rules & Considerations(111)
validation
constraint
Sample Load Data(4)
| _scenario | STORERPK | STORE_NAMER | STORE_NAME3R | STORE_NAME10R | LANG | NAME | 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_TYPE | VAT_REGION | DUNS_NUMBER | ORG_UNIT_ID | REMERCH_IND | STORE_CLASS | UPDATE_DATE | UPDATE_USER | LEGAL_ENTITY | PHONE_NUMBER | REMODEL_DATE | SISTER_STORE | STORE_FORMAT | 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 | SAM | SAMPLE | 1 | SAMPLE | SAMPLE | SAMPLE | S | 1 | SAMP | SAMPLE | SAMPLE | SAMPLE | 2026-01-01 | Y | 1 | 2026-01-01 | 1 | SAMPLE | SAMPLE | 1 | SAMPLE | 1 | S | S | 2026-01-01 | SAMPLE | SAMPLE | SAMPLE | 2026-01-01 | 1 | 1 | 2026-01-01 | SAM | 1 | SAMPLE | 1 | 1 | SAMPLE | SAM | SAMPLE | 1 | 2026-01-01 | 1 | SA | 1 | 2026-01-01 | 1 | S | S | 1 | S | 2026-01-01 | SAMPLE | S | 1 | 1.00 | SAMPLE | S | SAM | 1.00 | 2026-01-01 | SAMPLE | SAMPLE | S | S |
| default | 1003 | Store Secondary | Sto | Store-002- | 3 | — | Store-002-ALT | ALT-STORE-002 | Y | 303 | Stor | — | C LIENT_INFO | Store Secondary | — | — | 100003 | — | 9003 | Store-002-ALT | C | 203 | Store-002 | 1000000003 | N | S | — | — | Store-002-ALT | Store-002-ALT | 2026-01-03 | 1003 | 3 | 2026-01-03 | ALT | 1003 | Store Secondary | 3 | 1000000003 | APP_USER_ID | — | Store Secondary | 1000000003 | 2026-01-03 | 3 | — | 3 | 2026-01-03 | 3 | N | S | 3 | S | 2026-01-03 | — | N | 3 | — | Store- | S | ALT | — | 2026-01-03 | — | Store-002-ALT | S | N |
| default | 1005 | Store Core | Sto | Store-003- | 5 | — | Store-003-EDGE | EDGE-STORE-003 | N | 305 | Stor | — | USE RENV | Store Core | — | — | 100005 | — | 9005 | Store-003-EDGE | C | 205 | Store-003 | 1000000005 | N | S | — | — | Store-003-EDGE | Store-003-EDGE | 2026-01-05 | 1005 | 5 | 2026-01-05 | EDG | 1005 | Store Core | 5 | 1000000005 | USERENV | — | Store Core | 1000000005 | 2026-01-05 | 5 | — | 5 | 2026-01-05 | 5 | Y | S | 5 | S | 2026-01-05 | — | N | 5 | — | Store- | S | EDG | — | 2026-01-05 | — | Store-003-EDGE | S | N |
Example values from field definitions
- STORERPK
- 1
- STORE_NAMER
- SAMPLE
- STORE_NAME3R
- SAM
- STORE_NAME10R
- SAMPLE
- LANG
- 1
- NAME
- SAMPLE
- SAMPLE
- 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_TYPE
- SAMPLE
- VAT_REGION
- 1
- DUNS_NUMBER
- SAMPLE
- ORG_UNIT_ID
- 1
- REMERCH_IND
- S
- STORE_CLASS
- S
- 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
- ACQUIRED_DATE
- 2026-01-01
- CURRENCY_CODE
- SAM
- 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
- SA
- 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
- SAM
- SELLING_SQUARE_FEET
- 1.00
- LAST_UPDATE_DATETIME
- 2026-01-01
- ORGANIZATION_UNIT_ID
- SAMPLE
- STORE_NAME_SECONDARY
- SAMPLE
- CUSTOMER_ORDER_LOC_IND
- S
- CUSTOMER_ORDER_SHIP_IND
- S
default
- STORERPK
- 1003
- STORE_NAMER
- Store Secondary
- STORE_NAME3R
- Sto
- STORE_NAME10R
- Store-002-
- LANG
- 3
- NAME
- —
- Store-002-ALT
- TAX_ID
- ALT-STORE-002
- AUTO_RCV
- Y
- DISTRICT
- 303
- DUNS_LOC
- Stor
- TIMEZONE
- —
- CREATE_ID
- C LIENT_INFO
- MALL_NAME
- Store Secondary
- OPEN_DATE
- —
- SIM_STORE
- —
- CHANNEL_ID
- 100003
- CLOSE_DATE
- —
- DEFAULT_WH
- 9003
- FAX_NUMBER
- Store-002-ALT
- STORE_TYPE
- C
- VAT_REGION
- 203
- DUNS_NUMBER
- Store-002
- ORG_UNIT_ID
- 1000000003
- REMERCH_IND
- N
- STORE_CLASS
- S
- UPDATE_DATE
- —
- UPDATE_USER
- —
- LEGAL_ENTITY
- Store-002-ALT
- PHONE_NUMBER
- Store-002-ALT
- REMODEL_DATE
- 2026-01-03
- SISTER_STORE
- 1003
- STORE_FORMAT
- 3
- ACQUIRED_DATE
- 2026-01-03
- CURRENCY_CODE
- ALT
- PRICING_STORE
- 1003
- TIMEZONE_NAME
- Store Secondary
- TRANSFER_ZONE
- 3
- TSF_ENTITY_ID
- 1000000003
- LAST_UPDATE_ID
- APP_USER_ID
- LOCALE_COUNTRY
- —
- STORE_MGR_NAME
- Store Secondary
- WF_CUSTOMER_ID
- 1000000003
- CREATE_DATETIME
- 2026-01-03
- LINEAR_DISTANCE
- 3
- LOCALE_LANGUAGE
- —
- STOP_ORDER_DAYS
- 3
- STORE_OPEN_DATE
- 2026-01-03
- TOTAL_SQUARE_FT
- 3
- VAT_INCLUDE_IND
- N
- ONLINE_STORE_IND
- S
- START_ORDER_DAYS
- 3
- STOCKHOLDING_IND
- S
- STORE_CLOSE_DATE
- 2026-01-03
- TRANSFER_ZONE_ID
- —
- GIFT_WRAPPING_IND
- N
- SELLING_SQUARE_FT
- 3
- TOTAL_SQUARE_FEET
- —
- TRAN_NO_GENERATED
- Store-
- INTEGRATED_POS_IND
- S
- ORIG_CURRENCY_CODE
- ALT
- SELLING_SQUARE_FEET
- —
- LAST_UPDATE_DATETIME
- 2026-01-03
- ORGANIZATION_UNIT_ID
- —
- STORE_NAME_SECONDARY
- Store-002-ALT
- CUSTOMER_ORDER_LOC_IND
- S
- CUSTOMER_ORDER_SHIP_IND
- N
default
- STORERPK
- 1005
- STORE_NAMER
- Store Core
- STORE_NAME3R
- Sto
- STORE_NAME10R
- Store-003-
- LANG
- 5
- NAME
- —
- Store-003-EDGE
- TAX_ID
- EDGE-STORE-003
- AUTO_RCV
- N
- DISTRICT
- 305
- DUNS_LOC
- Stor
- TIMEZONE
- —
- CREATE_ID
- USE RENV
- MALL_NAME
- Store Core
- OPEN_DATE
- —
- SIM_STORE
- —
- CHANNEL_ID
- 100005
- CLOSE_DATE
- —
- DEFAULT_WH
- 9005
- FAX_NUMBER
- Store-003-EDGE
- STORE_TYPE
- C
- VAT_REGION
- 205
- DUNS_NUMBER
- Store-003
- ORG_UNIT_ID
- 1000000005
- REMERCH_IND
- N
- STORE_CLASS
- S
- UPDATE_DATE
- —
- UPDATE_USER
- —
- LEGAL_ENTITY
- Store-003-EDGE
- PHONE_NUMBER
- Store-003-EDGE
- REMODEL_DATE
- 2026-01-05
- SISTER_STORE
- 1005
- STORE_FORMAT
- 5
- ACQUIRED_DATE
- 2026-01-05
- CURRENCY_CODE
- EDG
- PRICING_STORE
- 1005
- TIMEZONE_NAME
- Store Core
- TRANSFER_ZONE
- 5
- TSF_ENTITY_ID
- 1000000005
- LAST_UPDATE_ID
- USERENV
- LOCALE_COUNTRY
- —
- STORE_MGR_NAME
- Store Core
- WF_CUSTOMER_ID
- 1000000005
- CREATE_DATETIME
- 2026-01-05
- LINEAR_DISTANCE
- 5
- LOCALE_LANGUAGE
- —
- STOP_ORDER_DAYS
- 5
- STORE_OPEN_DATE
- 2026-01-05
- TOTAL_SQUARE_FT
- 5
- VAT_INCLUDE_IND
- Y
- ONLINE_STORE_IND
- S
- START_ORDER_DAYS
- 5
- STOCKHOLDING_IND
- S
- STORE_CLOSE_DATE
- 2026-01-05
- TRANSFER_ZONE_ID
- —
- GIFT_WRAPPING_IND
- N
- SELLING_SQUARE_FT
- 5
- TOTAL_SQUARE_FEET
- —
- TRAN_NO_GENERATED
- Store-
- INTEGRATED_POS_IND
- S
- ORIG_CURRENCY_CODE
- EDG
- SELLING_SQUARE_FEET
- —
- LAST_UPDATE_DATETIME
- 2026-01-05
- ORGANIZATION_UNIT_ID
- —
- STORE_NAME_SECONDARY
- Store-003-EDGE
- CUSTOMER_ORDER_LOC_IND
- S
- CUSTOMER_ORDER_SHIP_IND
- N
Rule Validation Summary
- Source Rule Count
- 158
- Governed Rule Count
- 111