Address
In ScopeTechnical: ADDR | ID: OR-SUP-ADDR-ADDRESS
The ADDR table stores the address of the store, ware house, supplier, and partner. Seq_no is required as multiple addresses can exist for each address type.
See how this object fits into Supplier Management
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
- ADDR
Field Definitions(37)
Rules & Considerations(51)
validation
constraint
Sample Load Data(4)
| _scenario | CITYR | ADD_1R | MODULER | SEQ_NOR | ADDR_KEYRPK | ADDR_TYPERPK | CREATE_IDR | COUNTRY_IDRPK | KEY_VALUE_1R | PUBLISH_INDR | LAST_UPDATE_IDR | CREATE_DATETIMER | PRIMARY_ADDR_INDR | LAST_UPDATE_DATETIMER | POST | ADD_2 | ADD_3 | ADD_4 | STATE | COUNTY | PHONE2 | PHONE3 | LATITUDE | LONGITUDE | CONTACT_FAX | KEY_VALUE_2 | PHONE2_TYPE | PHONE3_TYPE | CONTACT_NAME | EDI_ADDR_CHG | CONTACT_EMAIL | CONTACT_PHONE | CONTACT_TELEX | EXTERNAL_REF_ID | JURISDICTION_CODE | ORACLE_VENDOR_SITE_ID |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| Example values from field definitions | SAMPLE | SAMPLE | SAMP | 1 | 1 | SA | SAMPLE | SAM | SAMPLE | S | SAMPLE | 2026-01-01 | S | 2026-01-01 | SAMPLE | SAMPLE | SAMPLE | SAMPLE | SAM | SAMPLE | SAMPLE | SAMPLE | 1.000000 | 1.000000 | SAMPLE | SAMPLE | SAMPLE | SAMPLE | SAMPLE | S | SAMPLE | SAMPLE | SAMPLE | SAMPLE | SAMPLE | 1 |
Example values from field definitions
- CITYR
- SAMPLE
- ADD_1R
- SAMPLE
- MODULER
- SAMP
- SEQ_NOR
- 1
- ADDR_KEYRPK
- 1
- ADDR_TYPERPK
- SA
- CREATE_IDR
- SAMPLE
- COUNTRY_IDRPK
- SAM
- KEY_VALUE_1R
- SAMPLE
- PUBLISH_INDR
- S
- LAST_UPDATE_IDR
- SAMPLE
- CREATE_DATETIMER
- 2026-01-01
- PRIMARY_ADDR_INDR
- S
- LAST_UPDATE_DATETIMER
- 2026-01-01
- POST
- SAMPLE
- ADD_2
- SAMPLE
- ADD_3
- SAMPLE
- ADD_4
- SAMPLE
- STATE
- SAM
- COUNTY
- SAMPLE
- PHONE2
- SAMPLE
- PHONE3
- SAMPLE
- LATITUDE
- 1.000000
- LONGITUDE
- 1.000000
- CONTACT_FAX
- SAMPLE
- KEY_VALUE_2
- SAMPLE
- PHONE2_TYPE
- SAMPLE
- PHONE3_TYPE
- SAMPLE
- CONTACT_NAME
- SAMPLE
- EDI_ADDR_CHG
- S
- CONTACT_EMAIL
- SAMPLE
- CONTACT_PHONE
- SAMPLE
- CONTACT_TELEX
- SAMPLE
- EXTERNAL_REF_ID
- SAMPLE
- JURISDICTION_CODE
- SAMPLE
- ORACLE_VENDOR_SITE_ID
- 1
Rule Validation Summary
- Source Rule Count
- 67
- Governed Rule Count
- 51