Organisation Unit Address Site
In ScopeTechnical: ORG_UNIT_ADDR_SITE | ID: OR-CST-ORG_UNIT_ADDR_SITE-ORGANISATION_UNIT_ADDRESS_SITE
This table will be used to associate Oracles vendor site id with RMS supplier addresses. This will be used for the new oracle financials interface and will allow RMS to...
See how this object fits into Cost
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
- ORG_UNIT_ADDR_SITE
Field Definitions(3)
Rules & Considerations(9)
validation
constraint
Sample Load Data(4)
| _scenario | ADDR_KEYRPK | ORG_UNIT_IDRPK | ORACLE_VENDOR_SITE_IDR |
|---|---|---|---|
| Example values from field definitions | 1 | 1 | 1 |
| default | 3 | 1000000003 | 1000000003 |
| default | 5 | 1000000005 | 1000000005 |
Example values from field definitions
- ADDR_KEYRPK
- 1
- ORG_UNIT_IDRPK
- 1
- ORACLE_VENDOR_SITE_IDR
- 1
default
- ADDR_KEYRPK
- 3
- ORG_UNIT_IDRPK
- 1000000003
- ORACLE_VENDOR_SITE_IDR
- 1000000003
default
- ADDR_KEYRPK
- 5
- ORG_UNIT_IDRPK
- 1000000005
- ORACLE_VENDOR_SITE_IDR
- 1000000005
Rule Validation Summary
- Source Rule Count
- 15
- Governed Rule Count
- 9