Dc Partner
In ScopeTechnical: DC_PARTNER | ID: OR-FND-DC_PARTNER-DC_PARTNER
This table is a staging table for data conversion and will hold the partner information.
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
- DC_PARTNER
Field Definitions(5)
Rules & Considerations(31)
Sample Load Data(4)
| _scenario | LANG | TERMS | MFG_ID | STATUS | TAX_ID | PARTNER_ID | VAT_REGION | YTD_CREDIT | CONTACT_FAX | OPEN_CREDIT | ORG_UNIT_ID | COMMENT_DESC | CONTACT_NAME | INVC_PAY_LOC | PARTNER_DESC | PARTNER_TYPE | CONTACT_EMAIL | CONTACT_PHONE | CONTACT_TELEX | CURRENCY_CODE | TSF_ENTITY_ID | YTD_DRAWDOWNS | LINE_OF_CREDIT | PRIMARY_IA_IND | OUTSTAND_CREDIT | AUTO_RECEIVE_IND | INVC_RECEIVE_LOC | IMPORT_COUNTRY_ID | PRINCIPLE_COUNTRY_ID | SERVICE_PERF_REQ_IND | PARTNER_NAME_SECONDARY |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| Example values from field definitions | 1 | SAMPLE | SAMPLE | S | SAMPLE | SAMPLE | 1 | 1.0000 | SAMPLE | 1.0000 | 1 | SAMPLE | SAMPLE | SAMPLE | SAMPLE | SAMPLE | SAMPLE | SAMPLE | SAMPLE | SAM | 1 | 1.0000 | 1.0000 | S | 1.0000 | S | SAMPLE | SAM | SAM | S | SAMPLE |
| default | 3 | Dc Partner-002- | ALT-DC_PARTNER-002 | P | ALT-DC_PARTNER-002 | ALT-DC_PAR | 203 | 12.5000 | Dc Partner-002-ALT | 12.5000 | 1000000003 | Dc Partner-002-ALT | Dc Partner Secondary | Dc Par | Dc Partner-002-ALT | Dc Par | Dc Partner-002-ALT | Dc Partner-002-ALT | Dc Partner-002-ALT | ALT | 1000000003 | 12.5000 | 12.5000 | D | 12.5000 | D | Dc Par | ALT | ALT | D | Dc Partner-002-ALT |
| default | 5 | Dc Partner-003- | EDGE-DC_PARTNER-00 | A | EDGE-DC_PARTNER-00 | EDGE-DC_PA | 205 | 14.0000 | Dc Partner-003-EDGE | 14.0000 | 1000000005 | Dc Partner-003-EDGE | Dc Partner Core | Dc Par | Dc Partner-003-EDGE | Dc Par | Dc Partner-003-EDGE | Dc Partner-003-EDGE | Dc Partner-003-EDGE | EDG | 1000000005 | 14.0000 | 14.0000 | D | 14.0000 | D | Dc Par | EDG | EDG | D | Dc Partner-003-EDGE |
Example values from field definitions
- LANG
- 1
- TERMS
- SAMPLE
- MFG_ID
- SAMPLE
- STATUS
- S
- TAX_ID
- SAMPLE
- PARTNER_ID
- SAMPLE
- VAT_REGION
- 1
- YTD_CREDIT
- 1.0000
- CONTACT_FAX
- SAMPLE
- OPEN_CREDIT
- 1.0000
- ORG_UNIT_ID
- 1
- COMMENT_DESC
- SAMPLE
- CONTACT_NAME
- SAMPLE
- INVC_PAY_LOC
- SAMPLE
- PARTNER_DESC
- SAMPLE
- PARTNER_TYPE
- SAMPLE
- CONTACT_EMAIL
- SAMPLE
- CONTACT_PHONE
- SAMPLE
- CONTACT_TELEX
- SAMPLE
- CURRENCY_CODE
- SAM
- TSF_ENTITY_ID
- 1
- YTD_DRAWDOWNS
- 1.0000
- LINE_OF_CREDIT
- 1.0000
- PRIMARY_IA_IND
- S
- OUTSTAND_CREDIT
- 1.0000
- AUTO_RECEIVE_IND
- S
- INVC_RECEIVE_LOC
- SAMPLE
- IMPORT_COUNTRY_ID
- SAM
- PRINCIPLE_COUNTRY_ID
- SAM
- SERVICE_PERF_REQ_IND
- S
- PARTNER_NAME_SECONDARY
- SAMPLE
default
- LANG
- 3
- TERMS
- Dc Partner-002-
- MFG_ID
- ALT-DC_PARTNER-002
- STATUS
- P
- TAX_ID
- ALT-DC_PARTNER-002
- PARTNER_ID
- ALT-DC_PAR
- VAT_REGION
- 203
- YTD_CREDIT
- 12.5000
- CONTACT_FAX
- Dc Partner-002-ALT
- OPEN_CREDIT
- 12.5000
- ORG_UNIT_ID
- 1000000003
- COMMENT_DESC
- Dc Partner-002-ALT
- CONTACT_NAME
- Dc Partner Secondary
- INVC_PAY_LOC
- Dc Par
- PARTNER_DESC
- Dc Partner-002-ALT
- PARTNER_TYPE
- Dc Par
- CONTACT_EMAIL
- Dc Partner-002-ALT
- CONTACT_PHONE
- Dc Partner-002-ALT
- CONTACT_TELEX
- Dc Partner-002-ALT
- CURRENCY_CODE
- ALT
- TSF_ENTITY_ID
- 1000000003
- YTD_DRAWDOWNS
- 12.5000
- LINE_OF_CREDIT
- 12.5000
- PRIMARY_IA_IND
- D
- OUTSTAND_CREDIT
- 12.5000
- AUTO_RECEIVE_IND
- D
- INVC_RECEIVE_LOC
- Dc Par
- IMPORT_COUNTRY_ID
- ALT
- PRINCIPLE_COUNTRY_ID
- ALT
- SERVICE_PERF_REQ_IND
- D
- PARTNER_NAME_SECONDARY
- Dc Partner-002-ALT
default
- LANG
- 5
- TERMS
- Dc Partner-003-
- MFG_ID
- EDGE-DC_PARTNER-00
- STATUS
- A
- TAX_ID
- EDGE-DC_PARTNER-00
- PARTNER_ID
- EDGE-DC_PA
- VAT_REGION
- 205
- YTD_CREDIT
- 14.0000
- CONTACT_FAX
- Dc Partner-003-EDGE
- OPEN_CREDIT
- 14.0000
- ORG_UNIT_ID
- 1000000005
- COMMENT_DESC
- Dc Partner-003-EDGE
- CONTACT_NAME
- Dc Partner Core
- INVC_PAY_LOC
- Dc Par
- PARTNER_DESC
- Dc Partner-003-EDGE
- PARTNER_TYPE
- Dc Par
- CONTACT_EMAIL
- Dc Partner-003-EDGE
- CONTACT_PHONE
- Dc Partner-003-EDGE
- CONTACT_TELEX
- Dc Partner-003-EDGE
- CURRENCY_CODE
- EDG
- TSF_ENTITY_ID
- 1000000005
- YTD_DRAWDOWNS
- 14.0000
- LINE_OF_CREDIT
- 14.0000
- PRIMARY_IA_IND
- D
- OUTSTAND_CREDIT
- 14.0000
- AUTO_RECEIVE_IND
- D
- INVC_RECEIVE_LOC
- Dc Par
- IMPORT_COUNTRY_ID
- EDG
- PRINCIPLE_COUNTRY_ID
- EDG
- SERVICE_PERF_REQ_IND
- D
- PARTNER_NAME_SECONDARY
- Dc Partner-003-EDGE
Rule Validation Summary
- Source Rule Count
- 34
- Governed Rule Count
- 31