Appendix A. - The ERP/CRM Integrator Meta Model

Below are descriptions of the Tables that make up the ERP/CRM Integrator Meta Model.  Each table is briefly described, the attributes listed and comments provided where applicable.

Table Name: DD_DATAELEMENT

Definition: A data element is a definition of an attribute, independent of an entity

Table Column Name	Table Column Comment
DD_DATAELEMENTNAME	Data Element Name
DD_DOMAINNAME	Parent Domain Name
DD_ORIGIN	Possible Values – E –from ERP, GE – Generic Element (generated by ERP/CRM Integrator)
TEMP_EXTRACT_INFO1
TECH_DESC

Table Name: DD_DATAELEMENT_DESC

Definition: The descriptive text for a Data Element

Table Column Name	Table Column Comment
DD_DATAELEMENTNAME	Data Element  Name
DD_LANGUAGE_ID	Language Code
SHORT_DESC
LOGICAL_UNIQUENAME
LONG_DESC

Table Name: DD_DOMAIN

Definition: A Domain is a generic definition of an Attribute type

Table Column Name	Table Column Comment
DD_DOMAINNAME	Domain Name
DD_DATATYPE	Logical Datatype
DD_DATATYPE_ERP	ERP-specific Datatype
DATA_LENGTH	Datatype length
DATA_DECIMALS	Datatype Decimals
DD_LOOKUP_ENTITYNAME	Name of the associated Entity Lookup table
DD_ORIGIN	Possible Values – E –from ERP, GD – Generic Domain (generated by ERP/CRM Integrator)
TEMP_EXTRACT_INFO1
TECH_DESC

Table Name: DD_DOMAIN_DESC

Definition: The descriptive text for a Domain

Table Column Name	Table Column Comment
DD_DOMAINNAME	Domain Name
DD_LANGUAGE_ID	Language Code
SHORT_DESC
LOGICAL_UNIQUENAME
LONG_DESC

Table Name: DD_DOMAINVALUE

Definition: A set of fixed values associated with a Domain

Table Column Name	Table Column Comment
DD_DOMAINNAME	Domain Name
DD_DOMAINVALUE_KEY	Domain Value Key
POSIT
TECH_DESC

Table Name: DD_DOMAINVALUE_DESC

Definition: The descriptive text for a Domain value

Table Column Name	Table Column Comment
DD_DOMAINNAME	Domain Name
DD_DOMAINVALUE_KEY	Domain Value Key
DD_LANGUAGE_ID	Language Code
SHORT_DESC
LONG_DESC

Table Name: DD_FIELD

Definition: A Field is an attribute belonging to a Table

Table Column Name	Table Column Comment
DD_TABLENAME	Table Name
DD_FIELDNAME	Field Name
POSIT
KEY_FLAG	Indicates a Primary Key field – Possible values are ‘Y’ or ‘N’
MANDATORY	Indicates if Field is Mandatory – Possible values are ‘Y’ or ‘N’
DD_DATAELEMENTNAME	Parent Data Element Name
DD_DOMAINNAME	Parent Domain Name
DD_PARENT_TABLENAME	Where the Fields is a Foreign Key, the Parent Table Name
DD_PARENT_FIELDNAME	Where the Fields is a Foreign Key, the Parent Field Name
DD_FLDGRPNAME	Only relevant to BW systems - Field Group that the Field belongs to
TEMP_EXTRACT_INFO1
TEMP_EXTRACT_INFO2
TECH_DESC

Table Name: DD_FIELD_DESC

Definition: The descriptive text for a Field

Table Column Name	Table Column Comment
DD_TABLENAME	Table Name
DD_FIELDNAME	Field Name
DD_LANGUAGE_ID	Language Code
SHORT_DESC
LOGICAL_UNIQUENAME
LONG_DESC

Table Name: DD_FIELDGRP

Definition: A Field Group is normally only used for SAP BW systems.

Table Column Name	Table Column Comment
DD_TABLENAME	Table Name
DD_FIELDGRPNAME	Field Group Name
POSIT

Table Name: DD_FIELDGRP_DESC

Definition: The descriptive text for a Field Group

Table Column Name	Table Column Comment
DD_TABLENAME	Table Name
DD_FIELDGRPNAME	Field Group Name
DD_LANGUAGE_ID	Language Code
SHORT_DESC

Table Name: DD_INDEX

Definition: An Index is a definition of a database index for a Table

Table Column Name	Table Column Comment
DD_TABLENAME	Table Name
DD_INDEXNAME	Index Name
DD_INDEXTYPE	The Index Type – A for Alternate, I for Inversion Entry, P for Primary Key Index
TECH_DESC

Table Name: DD_INDEX_DESC

Definition: The descriptive text for an Index

Table Column Name	Table Column Comment
DD_TABLENAME	Table Name
DD_INDEXNAME	Index Name
DD_LANGUAGE_ID	Language Code
SHORT_DESC
LONG_DESC

Table Name: DD_INDEXITEM

Definition: An Index Item is a definition of a field that belongs to an Index

Table Column Name	Table Column Comment
DD_TABLENAME	Table Name
DD_INDEXNAME	Index Name
POSIT
DD_FIELDNAME
DESCENDING	Indicates if Index Item is a Descending Index Item – possible values are ‘Y’ or ‘N’

Table Name: DD_LANGUAGE

Definition: A definition of a Language for descriptive text fields

Table Column Name	Table Column Comment
DD_LANGUAGE_ID	Language Code
SHORT_DESC

Table Name: DD_RELATIONSHIP

Definition: A Relationship defines a link between two tables

Table Column Name	Table Column Comment
DD_RELATIONSHIP_ID	Relationship Id
DD_PARENT_TABLENAME	Parent Table Name
DD_CHILD_TABLENAME	Child Table Name
DD_RELATTYPE	The Relationship Type.  I – for Identifying, N for Non-Identifying
DD_CARDINALITY	The Relationship Cardinality.  Possible values are:   ZM - Zero, one or more 1M - One or more Z1 - Zero or 1 E1 - Exact 1
DD_ORIGIN	The origin of the Relationship.  Possible values are ‘E’ – from the ERP, ‘XR’ – Extended relationship, ‘RR’ – Rules Based relationship
TEMP_EXTRACT_INFO1
TECH_DESC

Table Name: DD_RELATIONSHIP_DESC

Definition: The descriptive text for a Relationship

Table Column Name	Table Column Comment
DD_RELATIONSHIP_ID	Relationship Id
DD_LANGUAGE_ID	Language Code
SHORT_DESC
LONG_DESC

Table Name: DD_RELATIONSHIPITEM

Definition: A relationship Item is a definition of a Field that belongs to a Relationship

Table Column Name	Table Column Comment
DD_RELATIONSHIP_ID	Relationship Id
POSIT
DD_PARENT_TABLENAME	The Parent Table for the Relationship
DD_PARENT_FIELDNAME	The Parent Field for the Relationship Item
DD_CHILD_TABLENAME	The Child Table for the Relationship
DD_CHILD_FIELDNAME	The Child Field for the Relationship Item
DD_CHILD_FIELDVALUE_FIXED	Where the Relationship Item is to a ‘fixed’ value, the fixed value
TECH_DESC

Table Name: DD_SUBJECTAREA

Definition: A Subject Area is a grouping of Tables and/or Views

Table Column Name	Table Column Comment
DD_SUBJECTAREA_ID	Subject Area Id
DD_SUBJECTAREANAME
UPDATE_USER	The Windows User that last updated the Subject Area
UPDATE_DATETIME	The Date a& Time the Subject Area was last updated
CREATION_USER	The Windows User that created the Subject Area
CREATION_DATETIME	The Date a& Time the Subject Area was created
REMARK	Free format text to describe the Subject Area

Table Name: DD_SUBJECTAREA_MK_FIELD

Definition: A Marked Field indicates that a Table Field belongs to the designated Subject Area.

Table Column Name	Table Column Comment
DD_SUBJECTAREA_ID	Subject Area Id
DD_TABLENAME	Table Name
DD_FIELDNAME	Field Name

Table Name: DD_SUBJECTAREA_MK_VFIELD

Definition: A Marked Field indicates that a View Field belongs to the designated Subject Area.

Table Column Name	Table Column Comment
DD_SUBJECTAREA_ID	Subject Area Id
DD_VIEWTYPE	Determined by the ERP type
DD_VIEWNAME	View Name
DD_VIEWFIELDNAME	View Field Name

Table Name: DD_SUBJECTAREA_TABLE

Definition: An intersect table between a Subject Area and a Table

Table Column Name	Table Column Comment
DD_SUBJECTAREA_ID	Subject Area Id
DD_TABLENAME	Table Name

Table Name: DD_SUBJECTAREA_VIEW

Definition: An intersect table between a Subject Area and a View

Table Column Name	Table Column Comment
DD_SUBJECTAREA_ID	Subject Area Id
DD_VIEWTYPE	Determined by the ERP type
DD_VIEWNAME	View Name

Table Name: DD_TABLE

Definition: A table is a definition of a database Base Table

Table Column Name	Table Column Comment
DD_TABLENAME	Table Name
DD_TABLETYPE	The Table Type – T – Transparent, P – Pool, C – Cluster (P & C values are only relevant to SAP).
PHYSICAL_TABLENAME	Physical Table Name
NUMBER_OF_PARENT_TABLES
NUMBER_OF_CHILD_TABLES
HAS_DATA	Row Count, if available
TEMP_EXTRACT_INFO1
TEMP_EXTRACT_INFO2
TECH_DESC

Table Name: DD_TABLE_DESC

Definition: The descriptive text for a Table

Table Column Name	Table Column Comment
DD_TABLENAME	Table Name
DD_LANGUAGE_ID	Language Code
SHORT_DESC
LOGICAL_UNIQUENAME
LONG_DESC

Table Name: DD_TREE

Definition: A definition of a Tree Type for the Application Hierarchy

Table Column Name	Table Column Comment
DD_TREE_ID	Tree Id
DD_ROOTNODE_ID

Table Name: DD_TREE_DESC

Definition: The descriptive text for a Tree type

Table Column Name	Table Column Comment
DD_TREE_ID	Tree Id
DD_LANGUAGE_ID	Language Code
SHORT_DESC

Table Name: DD_TREENODE

Definition: A definition of a Tree Node within the Application Hierarchy

Table Column Name	Table Column Comment
DD_TREE_ID	Tree Id
DD_TREENODE_ID
DD_TREENODECLASS_ID
HAS_CHILDNODES	Indicates if there are Nodes below current level – possible values are ‘Y’ or ‘N’
HAS_TREENODE_TABLES	Indicates if there are Nodes containing Tables associated with this Node – possible values are ‘Y’ or ‘N’
HAS_TREENODE_VIEWS	Indicates if there are Nodes containing Views associated with this Node – possible values are ‘Y’ or ‘N’
TEMP_EXTRACT_INFO1
TEMP_EXTRACT_INFO2

Table Name: DD_TREENODE_DESC

Definition: The descriptive text for a Tree Node

Table Column Name	Table Column Comment
DD_TREE_ID	Tree Id
DD_TREENODE_ID	Tree Node Id
DD_LANGUAGE_ID	Language Code
SHORT_DESC

Table Name: DD_TREENODE_TABLE

Definition: An intersect between a Tree Node and a Table

Table Column Name	Table Column Comment
DD_TREE_ID	Tree Id
DD_TREENODE_ID	Tree Node Id
DD_TABLENAME	Table Name

Table Name: DD_TREENODE_VIEW

Definition: An intersect between a Tree Node and a View

Table Column Name	Table Column Comment
DD_TREE_ID	Tree Id
DD_TREENODE_ID	Tree Node Id
DD_VIEWTYPE	Determined by the ERP Type
DD_VIEWNAME	View Name

Table Name: DD_TREENODECLASS

Definition: A classification of a Tree Node

Table Column Name	Table Column Comment
DD_TREE_ID	Tree Id
DD_TREENODECLASS_ID	Tree Node Class Id
ICON_ID	Indicates the type of icon to be used for this Tree Node Class
DELETEIFHASNOCHILDS	Should this Tree Node type be deleted if there are no levels below it.  Possible values are ‘Y’ or ‘N’

Table Name: DD_TREENODECLASS_DESC

Definition: The descriptive text for a Tree Node Class

Table Column Name	Table Column Comment
DD_TREE_ID	Tree Id
DD_TREENODECLASS_ID	Tree Node Class Id
DD_LANGUAGE_ID	Language Code
SHORT_DESC
DESC_SUFFIX

Table Name: DD_TREESTRUCT

Definition: The link between a Parent and Child Node in a Tree

Table Column Name	Table Column Comment
DD_TREE_ID	Tree Id
DD_PARENTNODE_ID	Id of Parent Node
DD_CHILDNODE_ID	Id of Child Node
TEMP_EXTRACT_INFO1

Table Name: DD_VIEW

Definition: Details of each View (a View can be a Database View, or an ‘abstracted view’)

Table Column Name	Table Column Comment
DD_VIEWTYPE	Determined by the ERP Type
DD_VIEWNAME	View Name
TEMP_EXTRACT_INFO1
TECH_DESC

Table Name: DD_VIEW_DESC

Definition: The descriptive text for a View

Table Column Name	Table Column Comment
DD_VIEWTYPE	Determined by the ERP Type
DD_VIEWNAME	View Name
DD_LANGUAGE_ID	Language Code
SHORT_DESC
LOGICAL_UNIQUENAME
LONG_DESC

Table Name: DD_VIEWFIELD

Definition: A View Field is an attribute of a View

Table Column Name	Table Column Comment
DD_VIEWTYPE	Determined by the ERP Type
DD_VIEWNAME	View Name
DD_VIEWFIELDNAME	View Field Name
POSIT
DD_VIEWFIELDTYPE	The View Field type.  Possible values are: UK  -Undefined TB – maps to a Table VW – maps to another View CL – Calculated Field
DD_TABLENAME	Table Name
DD_FIELDNAME	Field Name
DD_PARENT_VIEWTYPE	(For a future release of ERP/CRM Integrator)
DD_PARENT_VIEWNAME	Where a View Field is based upon another View, the View Name of that Parent
DD_PARENT_VIEWFIELDNAME	Where a View Field is based upon another View, the View Field Name of that Parent
DD_DATAELEMENTNAME	Parent Data Element Name
TEMP_EXTRACT_INFO1
TECH_DESC

Table Name: DD_VIEWFIELD_DESC

Definition: The descriptive text for a View Field

Table Column Name	Table Column Comment
DD_VIEWTYPE	Determined by the ERP Type
DD_VIEWNAME	View Name
DD_VIEWFIELDNAME	View Field Name
DD_LANGUAGE_ID	Language Code
SHORT_DESC
LOGICAL_UNIQUENAME
LONG_DESC