CDQ Business Partner External ID (CDQ.POOL)

From CDQ
Business partner/external id
Jump to navigation Jump to search
Name Name of a concept, e.g. a data model concept. In contrast to terms, the name does not depend on a given context, e.g. a country-specific language. CDQ Business Partner External ID
Description Informal and comprehensive human-readable definition of a concept. Arbitrary identifier type to mark customer IDs which are "external" from CDQ's perspective. This is the identifier a customer provides to identify her records, e.g. the ID she manages in her SAP systems.
Example A simple example supporting the understanding of a concept, business rule, etc. no example available
Part of Hierarchical relation between two concepts of the CDQ Data Model. Data source CDQ.POOL
Technical key Defines a unique key by which e.g. data model concepts can be referenced in a technical integration context. These keys are unique in the CDL context. CDQ_BUSINESS_PARTNER_EXTERNAL_ID
Parent concept Hierarchical relation between two concepts of a data model, e.g., the CDQ Data Model. Business Partner (CDQ.POOL)
Cardinality Cardinality of data model concepts.<br/><code>ZERO_OR_ONE</code>: Optional, but max. 1 instance related to its parent.<br/><code>EXACTLY_ONE</code>: Exactly 1 instance related to its parent.<br/><code>ZERO_OR_MORE</code>: Optional, multiple instances related to its parent may exist.<br/><code>ONE_OR_MORE</code>: Mandatory, multiple instances related to its parent may exist. ZERO_OR_ONE
Data type Data type of a data model concept, i.e., <code>ARRAY</code>, <code>BOOLEAN</code>, <code>DATE</code>, <code>ENUM</code>, <code>INTEGER</code>, <code>OBJECT</code>, or <code>STRING</code>. n/a
Concept type Complex data type of a data model concept, defined by another data model concept. Allows re-use of data type concepts, e.g. for several address types in a data model. SELF
Path JSON Path to identify attributes in a data item. businessPartner.externalId
Concept role The role of a Category:Data model concept in the tree structure of a data model.<br/><code>ROOT</code>: Root concept in a data model, i.e., no parent concepts.<br/><code>NODE</code>: Structure concepts in a data model, i.e., parent and child concepts.<br/><code>LEAF</code>: Leaf concept in a data model, i.e., no child concepts, provides the effective data values.<br/> LEAF
Mapping

mapping source: cuit (AR.NRC), mapping: AR.NRC cuitCDQ_BUSINESS_PARTNER_EXTERNAL_ID
mapping source: regNo (AT.CR), mapping: AT.CR regNoCDQ_BUSINESS_PARTNER_EXTERNAL_ID
mapping source: uid (AT.FON), mapping: AT.FON uidCDQ_BUSINESS_PARTNER_EXTERNAL_ID
mapping source: identifierValue (AU.BR), mapping: AU.BR abn_identifierValueCDQ_BUSINESS_PARTNER_EXTERNAL_ID
mapping source: cnpj (BR.RF), mapping: BR.RF cnpjCDQ_BUSINESS_PARTNER_EXTERNAL_ID
mapping source: bvDId (BVD), BVDID (BVD), mapping: BVD bvDId, BVDIDCDQ_BUSINESS_PARTNER_EXTERNAL_ID
mapping source: corporationId (CA.CR), mapping: CA.CR corporationIdCDQ_BUSINESS_PARTNER_EXTERNAL_ID
mapping source: uidOrganisationIdCategorie (CH.UIDR), uidOrganisationId (CH.UIDR), mapping: CH.UIDR uidOrganisationIdCategorie, uidOrganisationIdCDQ_BUSINESS_PARTNER_EXTERNAL_ID
mapping source: ico (CZ.REE), mapping: CZ.REE odpoved_vypisVREO_zakladniUdaje_icoCDQ_BUSINESS_PARTNER_EXTERNAL_ID
mapping source: cvrNummer (DK.CR), mapping: DK.CR cvrNummerCDQ_BUSINESS_PARTNER_EXTERNAL_ID
mapping source: duns (DNB), mapping: DNB dunsCDQ_BUSINESS_PARTNER_EXTERNAL_ID
mapping source: ariregistri_kood (EE.CR), mapping: EE.CR ariregistri_koodCDQ_BUSINESS_PARTNER_EXTERNAL_ID
mapping source: siret (FR.RC), mapping: FR.RC etablissementValue_siretCDQ_BUSINESS_PARTNER_EXTERNAL_ID
mapping source: CompanyNumber (GB-EAW.CR), mapping: GB-EAW.CR CompanyNumberCDQ_BUSINESS_PARTNER_EXTERNAL_ID
mapping source: crNumber (HK.CR), mapping: HK.CR crNumberCDQ_BUSINESS_PARTNER_EXTERNAL_ID
mapping source: companyNum (IE.CR), mapping: IE.CR companyNumCDQ_BUSINESS_PARTNER_EXTERNAL_ID
mapping source: מספר חברה (IL.CR), mapping: IL.CR companyNumberCDQ_BUSINESS_PARTNER_EXTERNAL_ID
mapping source: EIN (IRS), mapping: IRS EINCDQ_BUSINESS_PARTNER_EXTERNAL_ID
mapping source: corporateNumber (JP.CR), mapping: JP.CR corporateNumberCDQ_BUSINESS_PARTNER_EXTERNAL_ID
mapping source: lei (LEI), mapping: LEI leiCDQ_BUSINESS_PARTNER_EXTERNAL_ID
mapping source: regcode (LV.CR), mapping: LV.CR regcodeCDQ_BUSINESS_PARTNER_EXTERNAL_ID
mapping source: kvkNumber (NL.BR), mapping: NL.BR kvkNumberCDQ_BUSINESS_PARTNER_EXTERNAL_ID
mapping source: nzbn (NZ.CR), mapping: NZ.CR entity_nzbnCDQ_BUSINESS_PARTNER_EXTERNAL_ID
mapping source: nip (PL.NOBR), mapping: PL.NOBR nipCDQ_BUSINESS_PARTNER_EXTERNAL_ID
mapping source: COD_INMATRICULARE (RO.TR), mapping: RO.TR COD_INMATRICULARECDQ_BUSINESS_PARTNER_EXTERNAL_ID
mapping source: BusinessPartnerDisplayId (SAP.ODM), mapping: SAP.ODM displayIdCDQ_BUSINESS_PARTNER_EXTERNAL_ID
mapping source: uen (SG.BR), mapping: SG.BR uenCDQ_BUSINESS_PARTNER_EXTERNAL_ID
mapping source: icdph (SK.FS), mapping: SK.FS icdphCDQ_BUSINESS_PARTNER_EXTERNAL_ID
mapping source: Organisation ID (SPOR.OMS), mapping: SPOR.OMS OrganisationIDCDQ_BUSINESS_PARTNER_EXTERNAL_ID
mapping source: ENTITYNUMBER (US-AK.BER), mapping: US-AK.BER entityNumberCDQ_BUSINESS_PARTNER_EXTERNAL_ID
mapping source: entityid (US-CO.BER), mapping: US-CO.BER entityidCDQ_BUSINESS_PARTNER_EXTERNAL_ID
mapping source: COR_NUMBER (US-FL.BER), mapping: US-FL.BER corporationNumberCDQ_BUSINESS_PARTNER_EXTERNAL_ID
mapping source: Corp Number (US-IO.BER), mapping: US-IO.BER corpNumberCDQ_BUSINESS_PARTNER_EXTERNAL_ID
mapping source: US-LA.BER ↣ CDQ_BUSINESS_PARTNER_EXTERNAL_ID, mapping: US-LA.BER CDQ_BUSINESS_PARTNER_EXTERNAL_ID
mapping source: dos_id (US-NY.BER), mapping: US-NY.BER dos_idCDQ_BUSINESS_PARTNER_EXTERNAL_ID
mapping source: registry_number (US-OR.BER), mapping: US-OR.BER registryNumberCDQ_BUSINESS_PARTNER_EXTERNAL_ID
mapping source: UniqueID (US-SF.BER), mapping: US-SF.BER UniqueIDCDQ_BUSINESS_PARTNER_EXTERNAL_ID
mapping source: FILING_NUM (US-WY.BER), mapping: US-WY.BER FILING_NUMCDQ_BUSINESS_PARTNER_EXTERNAL_ID
mapping source: IPEDSID (US.EDU), mapping: US.EDU IPEDSIDCDQ_BUSINESS_PARTNER_EXTERNAL_ID
mapping source: value (VIES), value (VIES), mapping: VIES countryCode_value, vatValue_valueCDQ_BUSINESS_PARTNER_EXTERNAL_ID

Data quality rules