Dc Supplier Address
In ScopeTechnical: DC_SUP_ADDR | ID: OR-SUP-DC_SUP_ADDR-DC_SUPPLIER_ADDRESS
This table is a staging table for data conversion and will hold the supplier address information.
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
- DC_SUP_ADDR
Field Definitions(5)
Rules & Considerations(17)
Sample Load Data(4)
| _scenario | CITY | POST | ADD_1 | ADD_2 | ADD_3 | STATE | COUNTY | ADDR_TYPE | COUNTRY_ID | CONTACT_FAX | KEY_VALUE_1 | CONTACT_NAME | CONTACT_EMAIL | CONTACT_PHONE | CONTACT_TELEX | PRIMARY_ADDR_IND | JURISDICTION_CODE |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| Example values from field definitions | SAMPLE | SAMPLE | SAMPLE | SAMPLE | SAMPLE | SAM | SAMPLE | SA | SAM | SAMPLE | 1 | SAMPLE | SAMPLE | SAMPLE | SAMPLE | S | SAMPLE |
| Closed historical record with successor reference | TPRINGFIELD | 10001 | 456 Broad St | NY | Gotham County | S | USA | +1-555-876-5432 | 2 | Jane Smith | jane.smith@example.com | +1-555-234-5678 | 54321 | Y | NY | ||
| New record with minimal optional data | — | — | — | — | — | — | — | — | USA | — | 3 | Mark Johnson | — | — | — | — | CA |
Example values from field definitions
- CITY
- SAMPLE
- POST
- SAMPLE
- ADD_1
- SAMPLE
- ADD_2
- SAMPLE
- ADD_3
- SAMPLE
- STATE
- SAM
- COUNTY
- SAMPLE
- ADDR_TYPE
- SA
- COUNTRY_ID
- SAM
- CONTACT_FAX
- SAMPLE
- KEY_VALUE_1
- 1
- CONTACT_NAME
- SAMPLE
- CONTACT_EMAIL
- SAMPLE
- CONTACT_PHONE
- SAMPLE
- CONTACT_TELEX
- SAMPLE
- PRIMARY_ADDR_IND
- S
- JURISDICTION_CODE
- SAMPLE
Closed historical record with successor reference
- CITY
- TPRINGFIELD
- POST
- 10001
- ADD_1
- 456 Broad St
- ADD_2
- ADD_3
- STATE
- NY
- COUNTY
- Gotham County
- ADDR_TYPE
- S
- COUNTRY_ID
- USA
- CONTACT_FAX
- +1-555-876-5432
- KEY_VALUE_1
- 2
- CONTACT_NAME
- Jane Smith
- CONTACT_EMAIL
- jane.smith@example.com
- CONTACT_PHONE
- +1-555-234-5678
- CONTACT_TELEX
- 54321
- PRIMARY_ADDR_IND
- Y
- JURISDICTION_CODE
- NY
New record with minimal optional data
- CITY
- —
- POST
- —
- ADD_1
- —
- ADD_2
- —
- ADD_3
- —
- STATE
- —
- COUNTY
- —
- ADDR_TYPE
- —
- COUNTRY_ID
- USA
- CONTACT_FAX
- —
- KEY_VALUE_1
- 3
- CONTACT_NAME
- Mark Johnson
- CONTACT_EMAIL
- —
- CONTACT_PHONE
- —
- CONTACT_TELEX
- —
- PRIMARY_ADDR_IND
- —
- JURISDICTION_CODE
- CA
Rule Validation Summary
- Source Rule Count
- 23
- Governed Rule Count
- 17