Address Translations
In ScopeTechnical: ADDR_TL | ID: OR-FND-ADDR_TL-ADDRESS_TRANSLATIONS
This is the translation table for ADDR table. The data in the base table is held in data integration langauge configured in SYSTEM_CONFIG_OPTIONS.
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
- ADDR_TL
Field Definitions(13)
Rules & Considerations(21)
validation
constraint
Sample Load Data(4)
| _scenario | CITYR | LANGRPK | ADD_1R | ADDR_KEYRPK | CREATE_IDR | LAST_UPDATE_IDR | CREATE_DATETIMER | LAST_UPDATE_DATETIMER | ADD_2 | ADD_3 | ADD_4 | COUNTY | CONTACT_NAME |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| Example values from field definitions | SAMPLE | 1 | SAMPLE | 1 | SAMPLE | SAMPLE | 2026-01-01 | 2026-01-01 | SAMPLE | SAMPLE | SAMPLE | SAMPLE | SAMPLE |
Example values from field definitions
- CITYR
- SAMPLE
- LANGRPK
- 1
- ADD_1R
- SAMPLE
- ADDR_KEYRPK
- 1
- CREATE_IDR
- SAMPLE
- LAST_UPDATE_IDR
- SAMPLE
- CREATE_DATETIMER
- 2026-01-01
- LAST_UPDATE_DATETIMER
- 2026-01-01
- ADD_2
- SAMPLE
- ADD_3
- SAMPLE
- ADD_4
- SAMPLE
- COUNTY
- SAMPLE
- CONTACT_NAME
- SAMPLE
Rule Validation Summary
- Source Rule Count
- 24
- Governed Rule Count
- 21