Address
In ScopeTechnical: ADDRESS | ID: OR-STO-ADDRESS-ADDRESS
this table will store different supplier addresses for a suppliers.
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
- ADDRESS
Field Definitions(26)
Rules & Considerations(30)
Sample Load Data(4)
| _scenario | IDRPK | TYPER | ENTITY_IDR | IS_PRIMARYR | ENTITY_TYPER | CITY | STATE | COUNTY | END_DATE | LAST_NAME | COUNTRY_ID | FIRST_NAME | START_DATE | CONTACT_FAX | EXTERNAL_ID | LOCATION_ID | POSTAL_CODE | COMPANY_NAME | CONTACT_NAME | CONTACT_EMAIL | CONTACT_PHONE | ADDRESS_LINE_1 | ADDRESS_LINE_2 | ADDRESS_LINE_3 | PHONETIC_LAST_NAME | PHONETIC_FIRST_NAME |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| Example values from field definitions | 1 | SA | 1 | S | SAMP | SAMPLE | SAM | SAMPLE | 2026-01-01 | SAMPLE | SAM | SAMPLE | 2026-01-01 | SAMPLE | SAMPLE | SAMPLE | SAMPLE | SAMPLE | SAMPLE | SAMPLE | SAMPLE | SAMPLE | SAMPLE | SAMPLE | SAMPLE | SAMPLE |
Example values from field definitions
- IDRPK
- 1
- TYPER
- SA
- ENTITY_IDR
- 1
- IS_PRIMARYR
- S
- ENTITY_TYPER
- SAMP
- CITY
- SAMPLE
- STATE
- SAM
- COUNTY
- SAMPLE
- END_DATE
- 2026-01-01
- LAST_NAME
- SAMPLE
- COUNTRY_ID
- SAM
- FIRST_NAME
- SAMPLE
- START_DATE
- 2026-01-01
- CONTACT_FAX
- SAMPLE
- EXTERNAL_ID
- SAMPLE
- LOCATION_ID
- SAMPLE
- POSTAL_CODE
- SAMPLE
- COMPANY_NAME
- SAMPLE
- CONTACT_NAME
- SAMPLE
- CONTACT_EMAIL
- SAMPLE
- CONTACT_PHONE
- SAMPLE
- ADDRESS_LINE_1
- SAMPLE
- ADDRESS_LINE_2
- SAMPLE
- ADDRESS_LINE_3
- SAMPLE
- PHONETIC_LAST_NAME
- SAMPLE
- PHONETIC_FIRST_NAME
- SAMPLE
Rule Validation Summary
- Source Rule Count
- 37
- Governed Rule Count
- 30