eCRM RDF Views Deployment and Demo Scripts
use DB;
SPARQL
prefix ecrm: <http://demo.openlinksw.com/schemas/ecrm#>
prefix oplsioc: <http://www.openlinksw.com/schemas/oplsioc#>
prefix sioc: <http://rdfs.org/sioc/ns#>
prefix foaf: <http://xmlns.com/foaf/0.1/>
prefix cal: <http://www.w3.org/2002/12/cal/ical#>
prefix geo: <http://www.w3.org/2003/01/geo/wgs84_pos#>
prefix product: <http://www.swop-project.eu/ontologies/pmo/product.owl#>
prefix owl: <http://www.w3.org/2002/07/owl#>
drop quad map virtrdf:ecrmDemo1 .
;
SPARQL
prefix ecrm: <http://demo.openlinksw.com/schemas/ecrm#>
prefix oplsioc: <http://www.openlinksw.com/schemas/oplsioc#>
prefix sioc: <http://rdfs.org/sioc/ns#>
prefix foaf: <http://xmlns.com/foaf/0.1/>
prefix cal: <http://www.w3.org/2002/12/cal/ical#>
prefix geo: <http://www.w3.org/2003/01/geo/wgs84_pos#>
prefix product: <http://www.swop-project.eu/ontologies/pmo/product.owl#>
prefix owl: <http://www.w3.org/2002/07/owl#>
drop quad map virtrdf:ecrmDemo2 .
;
create procedure DB.DBA.exec_no_error (in expr varchar) {
declare state, message, meta, result any;
exec(expr, state, message, vector(), 0, meta, result);
}
;
DB.DBA.exec_no_error('create view eCRM.DBA.SFA_SALES_QUOTA_VIEW2 (ORG_ID,
QUOTA_ID,
USER_ID,
OWNER_ID,
FROM_DATE,
TO_DATE,
QUOTA_VALUE,
OBJECTIVES)
as select ORG_ID,
QUOTA_ID,
USER_ID,
OWNER_ID,
FROM_DATE,
TO_DATE,
QUOTA_VALUE,
cast(OBJECTIVES as varchar)
from eCRM.DBA.SFA_SALES_QUOTA
');
DB.DBA.exec_no_error('create view eCRM.DBA.SFA_CUSTOM_FIELD_DEFS_VIEW2(
ORG_ID,
FIELD_ID,
CLASS_ID,
FIELD_NAME,
FIELD_TYPE)
as select
ORG_ID,
FIELD_ID,
CLASS_ID,
cast(FIELD_NAME as varchar),
FIELD_TYPE
from eCRM.DBA.SFA_CUSTOM_FIELD_DEFS');
DB.DBA.exec_no_error('create view eCRM.DBA.SFA_CUSTOM_FIELDS_VIEW2(
ORG_ID,
OBJ_ID,
FIELD_ID,
FIELD_VALUE)
as select
ORG_ID,
OBJ_ID,
FIELD_ID,
cast(FIELD_VALUE as varchar)
from eCRM.DBA.SFA_CUSTOM_FIELDS');
DB.DBA.exec_no_error('create view eCRM.DBA.SFA_COMPANIES_VIEW2(
ORG_ID,
COMPANY_ID,
OWNER_ID,
FREETEXT_ID,
COMPANY_NAME,
INDUSTRY_NAME,
URL,
PHONE_NUMBER,
PHONE_EXTENSION,
FAX_NUMBER,
FAX_EXTENSION,
MOBILE_NUMBER,
EMAIL,
COUNTRY_NAME,
PROVINCE,
CITY,
POSTAL_CODE,
ADDRESS1,
ADDRESS2,
DESCRIPTION)
as select
ORG_ID,
COMPANY_ID,
OWNER_ID,
FREETEXT_ID,
cast(COMPANY_NAME as varchar),
cast(INDUSTRY_NAME as varchar),
URL,
PHONE_NUMBER,
PHONE_EXTENSION,
FAX_NUMBER,
FAX_EXTENSION,
MOBILE_NUMBER,
EMAIL,
cast(COUNTRY_NAME as varchar),
cast(PROVINCE as varchar),
cast(CITY as varchar),
cast(POSTAL_CODE as varchar),
cast(ADDRESS1 as varchar),
cast(ADDRESS2 as varchar),
cast(DESCRIPTION as varchar)
from eCRM.DBA.SFA_COMPANIES');
DB.DBA.exec_no_error('create view eCRM.DBA.SFA_CONTACTS_VIEW2(
ORG_ID,
CONTACT_ID,
OWNER_ID,
FREETEXT_ID,
NAME_TITLE,
NAME_FIRST,
NAME_MIDDLE,
NAME_LAST,
BIRTH_DATE,
CONTACT_TYPE_TITLE,
MANAGER_NAME,
BUSINESS,
INTEREST,
OPEN_ID,
SOURCE_TITLE,
PHONE_NUMBER,
PHONE_EXTENSION,
PHONE2_NUMBER,
PHONE2_EXTENSION,
FAX_NUMBER,
FAX_EXTENSION,
MOBILE_NUMBER,
EMAIL,
COUNTRY_NAME,
PROVINCE,
CITY,
POSTAL_CODE,
ADDRESS1,
ADDRESS2,
DESCRIPTION)
as select
ORG_ID,
CONTACT_ID,
OWNER_ID,
FREETEXT_ID,
cast(NAME_TITLE as varchar),
cast(NAME_FIRST as varchar),
cast(NAME_MIDDLE as varchar),
cast(NAME_LAST as varchar),
BIRTH_DATE,
cast(CONTACT_TYPE_TITLE as varchar),
MANAGER_NAME,
cast(BUSINESS as varchar),
cast(INTEREST as varchar),
cast("OPEN" as varchar),
cast(SOURCE_TITLE as varchar),
PHONE_NUMBER,
PHONE_EXTENSION,
PHONE2_NUMBER,
PHONE2_EXTENSION,
FAX_NUMBER,
FAX_EXTENSION,
MOBILE_NUMBER,
EMAIL,
cast(COUNTRY_NAME as varchar),
cast(PROVINCE as varchar),
cast(CITY as varchar),
cast(POSTAL_CODE as varchar),
cast(ADDRESS1 as varchar),
cast(ADDRESS2 as varchar),
cast(DESCRIPTION as varchar)
from eCRM.DBA.SFA_CONTACTS');
DB.DBA.exec_no_error('create view eCRM.DBA.SFA_EMPLOYMENTS_VIEW2(
ORG_ID,
COMPANY_ID,
CONTACT_ID,
OWNER_ID,
EMPLOYMENT_ID,
DEPARTMENT,
TITLE,
PHONE_NUMBER,
PHONE_EXTENSION,
FAX_NUMBER,
FAX_EXTENSION,
MOBILE_NUMBER,
EMAIL)
as select
ORG_ID,
COMPANY_ID,
CONTACT_ID,
OWNER_ID,
cast(EMPLOYMENT_ID as integer),
cast(DEPARTMENT as varchar),
cast(TITLE as varchar),
PHONE_NUMBER,
PHONE_EXTENSION,
FAX_NUMBER,
FAX_EXTENSION,
MOBILE_NUMBER,
EMAIL
from eCRM.DBA.SFA_EMPLOYMENTS');
DB.DBA.exec_no_error('create view eCRM.DBA.SFA_LEADS_VIEW2(
ORG_ID,
LEAD_ID,
OWNER_ID,
FREETEXT_ID,
SUBJECT,
NAME_TITLE,
NAME_FIRST,
NAME_MIDDLE,
NAME_LAST,
COMPANY_NAME,
COMPANY_ID,
REL_ID,
TITLE,
STATUS,
RATING,
PHONE_NUMBER,
PHONE_EXTENSION,
FAX_NUMBER,
FAX_EXTENSION,
MOBILE_NUMBER,
EMAIL,
COUNTRY_NAME,
PROVINCE,
CITY,
POSTAL_CODE,
ADDRESS1,
ADDRESS2)
as select
ORG_ID,
LEAD_ID,
OWNER_ID,
FREETEXT_ID,
cast(SUBJECT as varchar),
cast(NAME_TITLE as varchar),
cast(NAME_FIRST as varchar),
cast(NAME_MIDDLE as varchar),
cast(NAME_LAST as varchar),
cast(COMPANY_NAME as varchar),
COMPANY_ID,
REL_ID,
cast(TITLE as varchar),
cast(STATUS as varchar),
cast(RATING as varchar),
PHONE_NUMBER,
PHONE_EXTENSION,
FAX_NUMBER,
FAX_EXTENSION,
MOBILE_NUMBER,
EMAIL,
cast(COUNTRY_NAME as varchar),
cast(PROVINCE as varchar),
cast(CITY as varchar),
cast(POSTAL_CODE as varchar),
cast(ADDRESS1 as varchar),
cast(ADDRESS2 as varchar)
from eCRM.DBA.SFA_LEADS');
DB.DBA.exec_no_error('create view eCRM.DBA.SFA_OPPORTUNITIES_VIEW2(
ORG_ID,
OPPORTUNITY_ID,
OWNER_ID,
FREETEXT_ID,
OPPORTUNITY_NAME,
MANAGER_NAME,
COMPANY_ID,
COMPANY_NAME,
CONTACT_ID,
CONTACT_NAME,
COMPANY_REL_ID,
CONTACT_REL_ID,
FORECAST,
ESTIMATE_CLOSE,
START_DATE,
STATUS,
CODE,
STAGE_TITLE,
SOURCE_TITLE,
CLOSED_AMOUNT,
CLOSED_DATE,
PROBABILITY,
POTENTIAL)
as select
ORG_ID,
OPPORTUNITY_ID,
OWNER_ID,
FREETEXT_ID,
cast(OPPORTUNITY_NAME as varchar),
MANAGER_NAME,
COMPANY_ID,
cast(COMPANY_NAME as varchar),
CONTACT_ID,
cast(CONTACT_NAME as varchar),
COMPANY_REL_ID,
CONTACT_REL_ID,
FORECAST,
ESTIMATE_CLOSE,
START_DATE,
cast(STATUS as varchar),
cast(CODE as varchar),
cast(STAGE_TITLE as varchar),
cast(SOURCE_TITLE as varchar),
CLOSED_AMOUNT,
CLOSED_DATE,
PROBABILITY,
POTENTIAL
from eCRM.DBA.SFA_OPPORTUNITIES');
DB.DBA.exec_no_error('create view eCRM.DBA.SFA_CASES_VIEW2(
ORG_ID,
CASE_ID,
OWNER_ID,
FREETEXT_ID,
SUMMARY,
STATUS,
PRIORITY,
OPEN_DATE,
LAST_ACTION_DATE,
DAYS_OLD,
COMPANY_ID,
COMPANY_NAME,
CONTACT_ID,
CONTACT_NAME,
URI,
APPLICATION,
APPVER,
PHONE_NUMBER,
RELATIONSHIP,
EMAIL,
CLIENT,
CLIENT_VERSION,
OFFICE,
CONSULTANT,
DB_VENDOR,
DB_VER,
MIS_TS_ID,
OPL_CLIENT,
OPL_VER,
SERVER,
SERVER_VERSION,
CURRENT_ODBC,
DOWNLOAD_DATE,
JOB_TITLE,
SOURCE,
"YEAR",
"MONTH",
"QUARTER",
WHEN_ORDER,
INTERNAL_STATUS,
FINANCIAL_YEAR,
CONTACT_REL_ID,
COMPANY_REL_ID)
as select
ORG_ID,
CASE_ID,
OWNER_ID,
FREETEXT_ID,
cast(SUMMARY as varchar),
cast(STATUS as varchar),
PRIORITY,
OPEN_DATE,
LAST_ACTION_DATE,
DAYS_OLD,
COMPANY_ID,
cast(COMPANY_NAME as varchar),
CONTACT_ID,
cast(CONTACT_NAME as varchar),
URI,
cast(APPLICATION as varchar),
cast(APPVER as varchar),
PHONE_NUMBER,
cast(RELATIONSHIP as varchar),
EMAIL,
cast(CLIENT as varchar),
cast(CLIENT_VERSION as varchar),
cast(OFFICE as varchar),
cast(CONSULTANT as varchar),
cast(DB_VENDOR as varchar),
cast(DB_VER as varchar),
MIS_TS_ID,
cast(OPL_CLIENT as varchar),
cast(OPL_VER as varchar),
cast(SERVER as varchar),
cast(SERVER_VERSION as varchar),
CURRENT_ODBC,
DOWNLOAD_DATE,
cast(JOB_TITLE as varchar),
cast(SOURCE as varchar),
"YEAR",
cast("MONTH" as varchar),
"QUARTER",
cast(WHEN_ORDER as varchar),
cast(INTERNAL_STATUS as varchar),
FINANCIAL_YEAR,
CONTACT_REL_ID,
COMPANY_REL_ID
from eCRM.DBA.SFA_CASES');
DB.DBA.exec_no_error('create view eCRM.DBA.SFA_NOTES_VIEW2(
ORG_ID,
NOTE_ID,
OWNER_ID,
FREETEXT_ID,
OBJ_ID,
REL_ID,
DESCRIPTION)
as select
ORG_ID,
NOTE_ID,
OWNER_ID,
FREETEXT_ID,
OBJ_ID,
REL_ID,
cast(DESCRIPTION as varchar)
from eCRM.DBA.SFA_NOTES');
DB.DBA.exec_no_error('create view eCRM.DBA.SFA_DOCUMENTS_VIEW2 (
ORG_ID,
DOCUMENT_ID,
DOC_ID,
OWNER_ID,
OBJ_ID,
ITEM,
REFERENCE)
as select
ORG_ID,
DOCUMENT_ID,
DOC_ID,
OWNER_ID,
OBJ_ID,
cast(ITEM as varchar),
cast(REFERENCE as varchar)
from eCRM.DBA.SFA_DOCUMENTS');
DB.DBA.exec_no_error('create view eCRM.DBA.SFA_INFLUENCERS_VIEW2(
ORG_ID,
INFLUENCER_ID,
OWNER_ID,
OPPORTUNITY_ID,
COMPANY_ID,
CONTACT_NAME,
TITLE,
IROLE,
RESPONSE_MODE)
as select
ORG_ID,
INFLUENCER_ID,
OWNER_ID,
OPPORTUNITY_ID,
COMPANY_ID,
cast(CONTACT_NAME as varchar),
cast(TITLE as varchar),
cast(IROLE as varchar),
cast(RESPONSE_MODE as varchar)
from eCRM.DBA.SFA_INFLUENCERS');
DB.DBA.exec_no_error('create view eCRM.DBA.SFA_TEAMS_VIEW2(
ORG_ID,
TEAM_ID,
OPPORTUNITY_ID,
OWNER_ID,
CONTACT_ID,
TITLE,
DEPARTMENT,
TROLE)
as select
ORG_ID,
TEAM_ID,
OPPORTUNITY_ID,
OWNER_ID,
CONTACT_ID,
cast(TITLE as varchar),
cast(DEPARTMENT as varchar),
cast(TROLE as varchar)
from eCRM.DBA.SFA_TEAMS');
DB.DBA.exec_no_error('create view eCRM.DBA.SFA_COMPETITORS_VIEW2(
ORG_ID,
COMPETITOR_ID,
OWNER_ID,
OPPORTUNITY_ID,
COMPANY_ID,
PRODUCT_ID,
CONTACT_NAME,
PRODUCT_NAME,
STRENGTHS,
WEAKNESS,
RATING,
STATUS)
as select
ORG_ID,
COMPETITOR_ID,
OWNER_ID,
OPPORTUNITY_ID,
COMPANY_ID,
PRODUCT_ID,
cast(CONTACT_NAME as varchar),
cast(PRODUCT_NAME as varchar),
cast(STRENGTHS as varchar),
cast(WEAKNESS as varchar),
cast(RATING as varchar),
cast(STATUS as varchar)
from eCRM.DBA.SFA_COMPETITORS');
DB.DBA.exec_no_error('create view eCRM.DBA.SFA_ISSUES_VIEW2(
ORG_ID,
ISSUE_ID,
OWNER_ID,
OPPORTUNITY_ID,
REL_ID,
SUBJECT,
REFERENCE,
PRIORITY,
ISSUE_DATE,
STATUS,
USER_NAME,
DOC_TITLE)
as select
ORG_ID,
ISSUE_ID,
OWNER_ID,
OPPORTUNITY_ID,
REL_ID,
cast(SUBJECT as varchar),
cast(REFERENCE as varchar),
cast(PRIORITY as varchar),
ISSUE_DATE,
cast(STATUS as varchar),
cast(USER_NAME as varchar),
cast(DOC_TITLE as varchar)
from eCRM.DBA.SFA_ISSUES');
DB.DBA.exec_no_error('create view eCRM.DBA.SFA_ORDERS_VIEW2(
ORG_ID,
ORDER_ID,
OWNER_ID,
FREETEXT_ID,
COMPANY_ID,
COMPANY_NAME,
CONTACT_ID,
CONTACT_NAME,
ORDER_NO,
SHIP_FNAME,
SHIP_SNAME,
PHONE_NUMBER,
PHONE_EXTENSION,
EMAIL,
SHIP_COUNTRY_NAME,
SHIP_PROVINCE,
SHIP_CITY,
SHIP_POSTAL_CODE,
SHIP_ADDRESS1,
SHIP_ADDRESS2,
SALESREP,
ORDER_DATE,
ORDER_VALUE,
REFUND,
"YEAR",
"MONTH",
"QUARTER",
FINANCIAL_YEAR,
CONTACT_REL_ID,
COMPANY_REL_ID)
as select
ORG_ID,
ORDER_ID,
OWNER_ID,
FREETEXT_ID,
COMPANY_ID,
cast(COMPANY_NAME as varchar),
CONTACT_ID,
cast(CONTACT_NAME as varchar),
ORDER_NO,
cast(SHIP_FNAME as varchar),
cast(SHIP_SNAME as varchar),
PHONE_NUMBER,
PHONE_EXTENSION,
EMAIL,
cast(SHIP_COUNTRY_NAME as varchar),
cast(SHIP_PROVINCE as varchar),
cast(SHIP_CITY as varchar),
cast(SHIP_POSTAL_CODE as varchar),
cast(SHIP_ADDRESS1 as varchar),
cast(SHIP_ADDRESS2 as varchar),
cast(SALESREP as varchar),
ORDER_DATE,
ORDER_VALUE,
REFUND,
"YEAR",
cast("MONTH" as varchar),
"QUARTER",
FINANCIAL_YEAR,
CONTACT_REL_ID,
COMPANY_REL_ID
from eCRM.DBA.SFA_ORDERS');
DB.DBA.exec_no_error('create view eCRM.DBA.SFA_ORDER_ITEMS_VIEW2(
ORG_ID,
ORDER_ITEM_ID,
OWNER_ID,
ORDER_ID,
PRODUCT_ID,
PRODUCT_NAME,
CLIENT,
SERVER,
DBMS,
DISCOUNT,
UNIT_PRICE,
QTY)
as select
ORG_ID,
ORDER_ITEM_ID,
OWNER_ID,
ORDER_ID,
PRODUCT_ID,
cast(PRODUCT_NAME as varchar),
cast(CLIENT as varchar),
cast(SERVER as varchar),
cast(DBMS as varchar),
DISCOUNT,
UNIT_PRICE,
QTY
from eCRM.DBA.SFA_ORDER_ITEMS');
DB.DBA.exec_no_error('create view eCRM.DBA.PM_CATEGORIES_VIEW2(
ORG_ID,
CATEGORY_ID,
OWNER_ID,
FREETEXT_ID,
CATEGORY_NAME,
DESCRIPTION)
as select
ORG_ID,
CATEGORY_ID,
OWNER_ID,
FREETEXT_ID,
cast(CATEGORY_NAME as varchar),
cast(DESCRIPTION as varchar)
from eCRM.DBA.PM_CATEGORIES');
DB.DBA.exec_no_error('create view eCRM.DBA.PM_PRODUCT_ATTRIBUTE_DEFS_VIEW2(
ORG_ID,
ATTRIBUTE_ID,
CATEGORY_ID,
ATTRIBUTE_NAME,
ATTRIBUTE_TYPE)
as select
ORG_ID,
ATTRIBUTE_ID,
CATEGORY_ID,
cast(ATTRIBUTE_NAME as varchar),
ATTRIBUTE_TYPE
from eCRM.DBA.PM_PRODUCT_ATTRIBUTE_DEFS');
DB.DBA.exec_no_error('create view eCRM.DBA.PM_PRODUCTS_VIEW2(
ORG_ID,
PRODUCT_ID,
OWNER_ID,
FREETEXT_ID,
PRODUCT_NAME,
CATEGORY_ID,
UNIT_OF_MEASURE,
UNITS,
MANUFACTURER,
VALID_FROM,
VALID_UNTIL,
COUNTRY_NAME,
MINORDER,
MAXORDER,
PRODUCT_VENDOR,
DESCRIPTION)
as select
ORG_ID,
PRODUCT_ID,
OWNER_ID,
FREETEXT_ID,
cast(PRODUCT_NAME as varchar),
CATEGORY_ID,
UNIT_OF_MEASURE,
UNITS,
cast(MANUFACTURER as varchar),
VALID_FROM,
VALID_UNTIL,
cast(COUNTRY_NAME as varchar),
MINORDER,
MAXORDER,
cast(PRODUCT_VENDOR as varchar),
cast(DESCRIPTION as varchar)
from eCRM.DBA.PM_PRODUCTS');
DB.DBA.exec_no_error('create view eCRM.DBA.PM_PRODUCT_ATTRIBUTES_VIEW2(
ORG_ID,
PRODUCT_ID,
ATTRIBUTE_ID,
ATTRIBUTE_VALUE)
as select
ORG_ID,
PRODUCT_ID,
ATTRIBUTE_ID,
cast(ATTRIBUTE_VALUE as varchar)
from eCRM.DBA.PM_PRODUCT_ATTRIBUTES');
DB.DBA.exec_no_error('create view eCRM.DBA.PM_CATALOGS_VIEW2(
ORG_ID,
CATALOG_ID,
OWNER_ID,
FREETEXT_ID,
CATALOG_NAME,
CATALOG_PROVIDER,
CATALOG_AUDIENCE,
VALID_FROM,
VALID_UNTIL,
DESCRIPTION)
as select
ORG_ID,
CATALOG_ID,
OWNER_ID,
FREETEXT_ID,
cast(CATALOG_NAME as varchar),
cast(CATALOG_PROVIDER as varchar),
cast(CATALOG_AUDIENCE as varchar),
VALID_FROM,
VALID_UNTIL,
cast(DESCRIPTION as varchar)
from eCRM.DBA.PM_CATALOGS');
DB.DBA.exec_no_error('create view eCRM.DBA.PM_CATALOG_PRODUCTS_VIEW2(
ORG_ID,
OWNER_ID,
CATALOG_ID,
PRODUCT_ID,
REL_ID,
PRICE,
CURRENCY,
DESCRIPTION)
as select
ORG_ID,
OWNER_ID,
CATALOG_ID,
PRODUCT_ID,
REL_ID,
PRICE,
CURRENCY,
cast(DESCRIPTION as varchar)
from eCRM.DBA.PM_CATALOG_PRODUCTS');
DB.DBA.exec_no_error('create view eCRM.DBA.XSYS_COUNTRIES_VIEW2(
COUNTRY_ID,
COUNTRY_ID3,
ISO_CODE,
COUNTRY_NAME)
as select
COUNTRY_ID,
COUNTRY_ID3,
ISO_CODE,
cast(COUNTRY_NAME as varchar)
from eCRM.DBA.XSYS_COUNTRIES');
DB.DBA.exec_no_error('create view eCRM.DBA.XSYS_PROVINCES_VIEW2(
COUNTRY_ID,
PROVINCE_ID,
PROVINCE_NAME)
as select
COUNTRY_ID,
PROVINCE_ID,
cast(PROVINCE_NAME as varchar)
from eCRM.DBA.XSYS_PROVINCES');
GRANT SELECT ON eCRM.DBA.SFA_SALES_QUOTA_VIEW2 TO "SPARQL";
GRANT SELECT ON eCRM.DBA.SFA_COMPANIES_VIEW2 TO "SPARQL";
GRANT SELECT ON eCRM.DBA.SFA_CONTACTS_VIEW2 TO "SPARQL";
GRANT SELECT ON eCRM.DBA.SFA_EMPLOYMENTS_VIEW2 TO "SPARQL";
GRANT SELECT ON eCRM.DBA.SFA_LEADS_VIEW2 TO "SPARQL";
GRANT SELECT ON eCRM.DBA.SFA_OPPORTUNITIES_VIEW2 TO "SPARQL";
GRANT SELECT ON eCRM.DBA.SFA_DOCUMENTS_VIEW2 TO "SPARQL";
GRANT SELECT ON eCRM.DBA.SFA_INFLUENCERS_VIEW2 TO "SPARQL";
GRANT SELECT ON eCRM.DBA.SFA_TEAMS_VIEW2 TO "SPARQL";
GRANT SELECT ON eCRM.DBA.SFA_NOTES_VIEW2 TO "SPARQL";
GRANT SELECT ON eCRM.DBA.SFA_COMPETITORS_VIEW2 TO "SPARQL";
GRANT SELECT ON eCRM.DBA.SFA_ISSUES_VIEW2 TO "SPARQL";
GRANT SELECT ON eCRM.DBA.SFA_CUSTOM_FIELD_DEFS_VIEW2 TO "SPARQL";
GRANT SELECT ON eCRM.DBA.SFA_CUSTOM_FIELDS_VIEW2 TO "SPARQL";
GRANT SELECT ON eCRM.DBA.SFA_CASES_VIEW2 TO "SPARQL";
GRANT SELECT ON eCRM.DBA.SFA_ORDERS_VIEW2 TO "SPARQL";
GRANT SELECT ON eCRM.DBA.SFA_ORDER_ITEMS_VIEW2 TO "SPARQL";
GRANT SELECT ON eCRM.DBA.PM_CATEGORIES_VIEW2 TO "SPARQL";
GRANT SELECT ON eCRM.DBA.PM_PRODUCT_ATTRIBUTE_DEFS_VIEW2 TO "SPARQL";
GRANT SELECT ON eCRM.DBA.PM_PRODUCTS_VIEW2 TO "SPARQL";
GRANT SELECT ON eCRM.DBA.PM_PRODUCT_ATTRIBUTES_VIEW2 TO "SPARQL";
GRANT SELECT ON eCRM.DBA.PM_CATALOGS_VIEW2 TO "SPARQL";
GRANT SELECT ON eCRM.DBA.PM_CATALOG_PRODUCTS_VIEW2 TO "SPARQL";
GRANT SELECT ON eCRM.DBA.XSYS_MODULES TO "SPARQL";
GRANT SELECT ON eCRM.DBA.XSYS_REGISTRY TO "SPARQL";
GRANT SELECT ON eCRM.DBA.XSYS_ORGANIZATIONS_DATA TO "SPARQL";
GRANT SELECT ON eCRM.DBA.XSYS_MESSAGES TO "SPARQL";
GRANT SELECT ON eCRM.DBA.XSYS_COUNTRIES_VIEW2 TO "SPARQL";
GRANT SELECT ON eCRM.DBA.XSYS_PROVINCES_VIEW2 TO "SPARQL";
GRANT SELECT ON eCRM.DBA.XSYS_TIMEZONES TO "SPARQL";
GRANT SELECT ON eCRM.DBA.XSYS_MIME_TYPES TO "SPARQL";
GRANT SELECT ON eCRM.DBA.XSYS_MIME_EXTENSIONS TO "SPARQL";
GRANT SELECT ON eCRM.DBA.XSYS_CNAMES TO "SPARQL";
GRANT SELECT ON eCRM.DBA.XSYS_QUOTAS TO "SPARQL";
GRANT SELECT ON eCRM.DBA.XSYS_ROLES TO "SPARQL";
GRANT SELECT ON eCRM.DBA.XSYS_ACCOUNTS TO "SPARQL";
GRANT SELECT ON eCRM.DBA.XSYS_USERDATA TO "SPARQL";
GRANT SELECT ON eCRM.DBA.XSYS_GROUPDATA TO "SPARQL";
GRANT SELECT ON eCRM.DBA.XSYS_MEMBERS TO "SPARQL";
GRANT SELECT ON eCRM.DBA.XSYS_SESSIONS_DATA TO "SPARQL";
GRANT SELECT ON eCRM.DBA.XSYS_SESSION_DATA TO "SPARQL";
GRANT SELECT ON eCRM.DBA.XSYS_LIST_MEMBERS_DEFS TO "SPARQL";
GRANT SELECT ON eCRM.DBA.XSYS_CLASSES TO "SPARQL";
GRANT SELECT ON eCRM.DBA.XSYS_ORG_CLASSES TO "SPARQL";
GRANT SELECT ON eCRM.DBA.XSYS_CLASS_METHODS TO "SPARQL";
GRANT SELECT ON eCRM.DBA.XSYS_CLASS_VIEWS TO "SPARQL";
GRANT SELECT ON eCRM.DBA.XSYS_ROLE_PRIVILEGES TO "SPARQL";
GRANT SELECT ON eCRM.DBA.XSYS_USER_PRIVILEGES TO "SPARQL";
GRANT SELECT ON eCRM.DBA.XSYS_HISTORY TO "SPARQL";
GRANT SELECT ON eCRM.DBA.XSYS_USERS TO "SPARQL";
GRANT SELECT ON eCRM.DBA.SFA_SALES_QUOTA TO "SPARQL";
GRANT SELECT ON eCRM.DBA.SFA_COMPANIES TO "SPARQL";
GRANT SELECT ON eCRM.DBA.SFA_CONTACTS TO "SPARQL";
GRANT SELECT ON eCRM.DBA.SFA_EMPLOYMENTS TO "SPARQL";
GRANT SELECT ON eCRM.DBA.SFA_LEADS TO "SPARQL";
GRANT SELECT ON eCRM.DBA.SFA_OPPORTUNITIES TO "SPARQL";
GRANT SELECT ON eCRM.DBA.SFA_ACTIVITIES TO "SPARQL";
GRANT SELECT ON eCRM.DBA.SFA_MAIL_MESSAGES TO "SPARQL";
GRANT SELECT ON eCRM.DBA.SFA_DOCUMENTS TO "SPARQL";
GRANT SELECT ON eCRM.DBA.SFA_INFLUENCERS TO "SPARQL";
GRANT SELECT ON eCRM.DBA.SFA_TEAMS TO "SPARQL";
GRANT SELECT ON eCRM.DBA.SFA_NOTES TO "SPARQL";
GRANT SELECT ON eCRM.DBA.SFA_COMPETITORS TO "SPARQL";
GRANT SELECT ON eCRM.DBA.SFA_ISSUES TO "SPARQL";
GRANT SELECT ON eCRM.DBA.SFA_CUSTOM_FIELD_DEFS TO "SPARQL";
GRANT SELECT ON eCRM.DBA.SFA_CUSTOM_FIELDS TO "SPARQL";
GRANT SELECT ON eCRM.DBA.SFA_CASES TO "SPARQL";
GRANT SELECT ON eCRM.DBA.SFA_ORDERS TO "SPARQL";
GRANT SELECT ON eCRM.DBA.SFA_ORDER_ITEMS TO "SPARQL";
GRANT SELECT ON eCRM.DBA.PM_CATEGORIES TO "SPARQL";
GRANT SELECT ON eCRM.DBA.PM_PRODUCT_ATTRIBUTE_DEFS TO "SPARQL";
GRANT SELECT ON eCRM.DBA.PM_PRODUCTS TO "SPARQL";
GRANT SELECT ON eCRM.DBA.PM_PRODUCT_ATTRIBUTES TO "SPARQL";
GRANT SELECT ON eCRM.DBA.PM_CATALOGS TO "SPARQL";
GRANT SELECT ON eCRM.DBA.PM_CATALOG_PRODUCTS TO "SPARQL";
GRANT SELECT ON eCRM.DBA.XSYS_COUNTRIES TO "SPARQL";
GRANT SELECT ON eCRM.DBA.XSYS_PROVINCES TO "SPARQL";
SPARQL
prefix ecrm: <http://demo.openlinksw.com/schemas/ecrm#>
prefix oplsioc: <http://www.openlinksw.com/schemas/oplsioc#>
prefix sioc: <http://rdfs.org/sioc/ns#>
prefix foaf: <http://xmlns.com/foaf/0.1/>
prefix cal: <http://www.w3.org/2002/12/cal/ical#>
prefix geo: <http://www.w3.org/2003/01/geo/wgs84_pos#>
prefix product: <http://www.swop-project.eu/ontologies/pmo/product.owl#>
prefix owl: <http://www.w3.org/2002/07/owl#>
create iri class ecrm:SalesQuota "http://^{URIQADefaultHost}^/ecrm/SalesQuota/%d/%d#this" (in ORG_ID integer, in SALES_QUOTA_ID integer) option (BIJECTION) .
create iri class ecrm:Company "http://^{URIQADefaultHost}^/ecrm/Company/%U/%U/%d#this" (in COMPANY_NAME varchar, in COMPANY_ID number, in ORG_ID integer) option (BIJECTION) .
create iri class ecrm:Contact "http://^{URIQADefaultHost}^/ecrm/Contact/%U/%U/%U/%U/%d#this" (in FNAME varchar, in MNAME varchar, in LNAME varchar, in CONTACT_ID number, in ORG_ID integer) option (BIJECTION) .
create iri class ecrm:Employment "http://^{URIQADefaultHost}^/ecrm/Employment/%U/%U/%U/%d#this" (in DEPARTMENT varchar, in COMPANY_ID varchar, in CONTACT_ID number, in ORG_ID integer) option (BIJECTION) .
create iri class ecrm:Lead "http://^{URIQADefaultHost}^/ecrm/Lead/%U/%d/%U#this" (in SNAME varchar, in ORG_ID integer, in LEAD_ID varchar) option (BIJECTION) .
create iri class ecrm:CustomFieldDef "http://^{URIQADefaultHost}^/ecrm/CustomFieldDef/%d/%d#this" (in ORG_ID integer, in EMPLOYMENT_ID integer) option (BIJECTION) .
create iri class ecrm:CustomField "http://^{URIQADefaultHost}^/ecrm/CustomField/%d/%d/%d#this" (in ORG_ID integer, in EMPLOYMENT_ID number, in ID2 integer) option (BIJECTION) .
create iri class ecrm:Opportunity "http://^{URIQADefaultHost}^/ecrm/Opportunity/%d/%U#this" (in ORG_ID integer, in OPPORTUNITY_ID number) option (BIJECTION) .
create iri class ecrm:Case "http://^{URIQADefaultHost}^/ecrm/Case/%d/%U#this" (in ORG_ID integer, in CASE_ID varchar) option (BIJECTION) .
create iri class ecrm:Note "http://^{URIQADefaultHost}^/ecrm/Note/%d/%U#this" (in ORG_ID integer, in EMPLOYMENT_ID varchar) option (BIJECTION) .
create iri class ecrm:Activity "http://^{URIQADefaultHost}^/ecrm/Activity/%d/%U/%U#this" (in ORG_ID integer, in ACT_ID varchar, in OBJ_ID varchar) option (BIJECTION) .
create iri class ecrm:MailMessage "http://^{URIQADefaultHost}^/ecrm/MailMessage/%d/%U/%U#this" (in ORG_ID integer, in EMPLOYMENT_ID varchar, in EMPLOYMENT_ID2 varchar) option (BIJECTION) .
create iri class ecrm:Document "http://^{URIQADefaultHost}^/ecrm/Document/%d/%U/%U" (in ORG_ID integer, in EMPLOYMENT_ID varchar, in EMPLOYMENT_ID2 varchar) option (BIJECTION) .
create iri class ecrm:Influencer "http://^{URIQADefaultHost}^/ecrm/Influencer/%d/%U#this" (in ORG_ID integer, in EMPLOYMENT_ID varchar) option (BIJECTION) .
create iri class ecrm:Team "http://^{URIQADefaultHost}^/ecrm/Team/%d/%U/%U#this" (in ORG_ID integer, in OPPORTUNITY_ID number, in CONTACT_ID number) option (BIJECTION) .
create iri class ecrm:Competitor "http://^{URIQADefaultHost}^/ecrm/Competitor/%d/%U#this" (in ORG_ID integer, in EMPLOYMENT_ID varchar) option (BIJECTION) .
create iri class ecrm:Issue "http://^{URIQADefaultHost}^/ecrm/Issue/%d/%U#this" (in ORG_ID integer, in EMPLOYMENT_ID varchar) option (BIJECTION) .
create iri class ecrm:Order "http://^{URIQADefaultHost}^/ecrm/Order/%d/%U#this" (in ORG_ID integer, in ORDER_ID varchar) option (BIJECTION) .
create iri class ecrm:OrderItem "http://^{URIQADefaultHost}^/ecrm/OrderItem/%d/%U#this" (in ORG_ID integer, in ORDER_ITEM_ID varchar) option (BIJECTION) .
create iri class ecrm:Category "http://^{URIQADefaultHost}^/ecrm/Category/%d/%U#this" (in ORG_ID integer, in EMPLOYMENT_ID varchar) option (BIJECTION) .
create iri class ecrm:ProductAttributeDef "http://^{URIQADefaultHost}^/ecrm/ProductAttributeDef/%d/%U#this" (in ORG_ID integer, in EMPLOYMENT_ID varchar) option (BIJECTION) .
create iri class ecrm:Product "http://^{URIQADefaultHost}^/ecrm/Product/%d/%U#this" (in ORG_ID integer, in PRODUCT_ID varchar) option (BIJECTION) .
create iri class ecrm:ProductAttribute "http://^{URIQADefaultHost}^/ecrm/ProductAttribute/%d/%U/%U#this" (in ORG_ID integer, in EMPLOYMENT_ID varchar, in ORG_ID2 varchar) option (BIJECTION) .
create iri class ecrm:Catalog "http://^{URIQADefaultHost}^/ecrm/Catalog/%d/%U#this" (in ORG_ID integer, in EMPLOYMENT_ID varchar) option (BIJECTION) .
create iri class ecrm:CatalogProduct "http://^{URIQADefaultHost}^/ecrm/CatalogProduct/%d/%U/%U#this" (in ORG_ID integer, in EMPLOYMENT_ID varchar, in EMPLOYMENT_ID2 varchar) option (BIJECTION) .
create iri class ecrm:Module "http://^{URIQADefaultHost}^/ecrm/Module/%d#this" (in ORG_ID integer) option (BIJECTION) .
create iri class ecrm:Registry "http://^{URIQADefaultHost}^/ecrm/Registry/%U#this" (in ORG_ID varchar) option (BIJECTION) .
create iri class ecrm:OrganizationsData "http://^{URIQADefaultHost}^/ecrm/OrganizationsData/%d/%U#this" (in ORG_ID integer, in DNS_ZONE varchar) option (BIJECTION) .
create iri class ecrm:Message "http://^{URIQADefaultHost}^/ecrm/Message/%d/%U#this" (in ORG_ID integer, in MSG_ID varchar) option (BIJECTION) .
create iri class ecrm:Country "http://^{URIQADefaultHost}^/ecrm/Country/%U#this" (in COUNTRY_ID varchar) option (BIJECTION) .
create iri class ecrm:Province "http://^{URIQADefaultHost}^/ecrm/Province/%U/%U#this" (in COUNTRY_ID varchar, in PROV_ID varchar) option (BIJECTION) .
create iri class ecrm:Timezone "http://^{URIQADefaultHost}^/ecrm/Timezone/%U#this" (in COUNTRY_ID varchar) option (BIJECTION) .
create iri class ecrm:MimeType "http://^{URIQADefaultHost}^/ecrm/MimeType/%d#this" (in COUNTRY_ID integer) option (BIJECTION) .
create iri class ecrm:MimeExtension "http://^{URIQADefaultHost}^/ecrm/MimeExtension/%d/%U#this" (in COUNTRY_ID integer, in COUNTRY_ID2 varchar) option (BIJECTION) .
create iri class ecrm:Cname "http://^{URIQADefaultHost}^/ecrm/Cname/%U#this" (in COUNTRY_ID varchar) option (BIJECTION) .
create iri class ecrm:Quota "http://^{URIQADefaultHost}^/ecrm/Quota/%d/%d#this" (in COUNTRY_ID integer, in COUNTRY_ID2 integer) option (BIJECTION) .
create iri class ecrm:Role "http://^{URIQADefaultHost}^/ecrm/Role/%d/%d#this" (in COUNTRY_ID integer, in COUNTRY_ID2 integer) option (BIJECTION) .
create iri class ecrm:Account "http://^{URIQADefaultHost}^/ecrm/Account/%d/%d#this" (in COUNTRY_ID integer, in COUNTRY_ID2 integer) option (BIJECTION) .
create iri class ecrm:UserData "http://^{URIQADefaultHost}^/ecrm/UserData/%d/%d#this" (in COUNTRY_ID integer, in COUNTRY_ID2 integer) option (BIJECTION) .
create iri class ecrm:GroupData "http://^{URIQADefaultHost}^/ecrm/GroupData/%d/%d#this" (in COUNTRY_ID integer, in COUNTRY_ID2 integer) option (BIJECTION) .
create iri class ecrm:Member "http://^{URIQADefaultHost}^/ecrm/Member/%d/%d/%d#this" (in COUNTRY_ID integer, in COUNTRY_ID2 integer, in COUNTRY_ID3 integer) option (BIJECTION) .
create iri class ecrm:Account "http://^{URIQADefaultHost}^/ecrm/Account/%d/%d#this" (in COUNTRY_ID integer, in COUNTRY_ID2 integer) option (BIJECTION) .
create iri class ecrm:SessionsData "http://^{URIQADefaultHost}^/ecrm/SessionsData/%U#this" (in COUNTRY_ID varchar) option (BIJECTION) .
create iri class ecrm:SessionData "http://^{URIQADefaultHost}^/ecrm/SessionData/%U/%d#this" (in COUNTRY_ID varchar, in COUNTRY_ID2 integer) option (BIJECTION) .
create iri class ecrm:ListMembersDef "http://^{URIQADefaultHost}^/ecrm/ListMembersDef/%d/%d#this" (in COUNTRY_ID integer, in COUNTRY_ID2 integer) option (BIJECTION) .
create iri class ecrm:Class "http://^{URIQADefaultHost}^/ecrm/Class/%U#this" (in COUNTRY_ID varchar) option (BIJECTION) .
create iri class ecrm:OrgClass "http://^{URIQADefaultHost}^/ecrm/OrgClass/%d/%U#this" (in COUNTRY_ID integer, in COUNTRY_ID2 varchar) option (BIJECTION) .
create iri class ecrm:ClassMethod "http://^{URIQADefaultHost}^/ecrm/ClassMethod/%U/%U#this" (in COUNTRY_ID varchar, in COUNTRY_ID2 varchar) option (BIJECTION) .
create iri class ecrm:ClassView "http://^{URIQADefaultHost}^/ecrm/ClassView/%d/%d#this" (in COUNTRY_ID integer, in COUNTRY_ID2 integer) option (BIJECTION) .
create iri class ecrm:RolePrivelege "http://^{URIQADefaultHost}^/ecrm/RolePrivelege/%d/%d/%U/%U#this" (in COUNTRY_ID integer, in COUNTRY_ID2 integer, in COUNTRY_ID3 varchar, in COUNTRY_ID4 varchar) option (BIJECTION) .
create iri class ecrm:UserPrivelege "http://^{URIQADefaultHost}^/ecrm/UserPrivelege/%d/%d/%U/%U#this" (in COUNTRY_ID integer, in COUNTRY_ID2 integer, in COUNTRY_ID3 varchar, in COUNTRY_ID4 varchar) option (BIJECTION) .
create iri class ecrm:History "http://^{URIQADefaultHost}^/ecrm/History/%d/%d#this" (in COUNTRY_ID integer, in COUNTRY_ID2 integer) option (BIJECTION) .
create iri class ecrm:XSys_User "http://^{URIQADefaultHost}^/ecrm/XSys_User/%d/%U/%d#this" (in ORG_ID integer, in ACCOUNT_NAME varchar, in ACCOUNT_ID integer) option (BIJECTION) .
create iri class ecrm:sioc_user_iri "http://^{URIQADefaultHost}^/dataspace/%U" (in uname varchar not null) option (BIJECTION) .
create iri class ecrm:dbpedia_iri "http://dbpedia.org/resource/%U" (in uname varchar not null) option (BIJECTION) .
;
SPARQL
prefix ecrm: <http://demo.openlinksw.com/schemas/ecrm#>
prefix oplsioc: <http://www.openlinksw.com/schemas/oplsioc#>
prefix sioc: <http://rdfs.org/sioc/ns#>
prefix foaf: <http://xmlns.com/foaf/0.1/>
prefix cal: <http://www.w3.org/2002/12/cal/ical#>
prefix geo: <http://www.w3.org/2003/01/geo/wgs84_pos#>
prefix product: <http://www.swop-project.eu/ontologies/pmo/product.owl#>
prefix owl: <http://www.w3.org/2002/07/owl#>
alter quad storage virtrdf:DefaultQuadStorage
from eCRM.DBA.SFA_SALES_QUOTA_VIEW2 as sales_quotas
from eCRM.DBA.SFA_COMPANIES_VIEW2 as companies
from eCRM.DBA.SFA_COMPANIES as companies_table text literal companies_table.DESCRIPTION of (companies.DESCRIPTION)
from eCRM.DBA.SFA_CONTACTS_VIEW2 as contacts
from eCRM.DBA.SFA_CONTACTS as contacts_table text literal contacts_table.NAME_FIRST of (contacts.NAME_FIRST)
from eCRM.DBA.SFA_EMPLOYMENTS_VIEW2 as employments
from eCRM.DBA.SFA_LEADS_VIEW2 as leads
from eCRM.DBA.SFA_LEADS as leads_table text literal leads_table.SUBJECT of (leads.SUBJECT)
from eCRM.DBA.SFA_OPPORTUNITIES_VIEW2 as opportunities
from eCRM.DBA.SFA_OPPORTUNITIES as opportunities_table text literal opportunities_table.OPPORTUNITY_NAME of (opportunities.OPPORTUNITY_NAME)
from eCRM.DBA.SFA_ACTIVITIES as activities
from eCRM.DBA.SFA_MAIL_MESSAGES as messages
from eCRM.DBA.SFA_DOCUMENTS_VIEW2 as documents
from eCRM.DBA.SFA_INFLUENCERS_VIEW2 as influencers
from eCRM.DBA.SFA_TEAMS_VIEW2 as teams
from eCRM.DBA.SFA_NOTES_VIEW2 as notes
from eCRM.DBA.SFA_NOTES as notes_table text literal notes_table.DESCRIPTION of (notes.DESCRIPTION)
from eCRM.DBA.SFA_COMPETITORS_VIEW2 as competitors
from eCRM.DBA.SFA_ISSUES_VIEW2 as issues
from eCRM.DBA.SFA_CUSTOM_FIELD_DEFS_VIEW2 as custom_field_defs
from eCRM.DBA.SFA_CUSTOM_FIELDS_VIEW2 as custom_fields
from eCRM.DBA.SFA_CASES_VIEW2 as cases
from eCRM.DBA.SFA_CASES as cases_table text literal cases_table.SUMMARY of (cases.SUMMARY)
from eCRM.DBA.SFA_ORDERS_VIEW2 as orders
from eCRM.DBA.SFA_ORDERS as orders_table text literal orders_table.EMAIL of (orders.EMAIL)
from eCRM.DBA.SFA_ORDER_ITEMS_VIEW2 as order_items
from eCRM.DBA.PM_CATEGORIES_VIEW2 as categories
from eCRM.DBA.PM_PRODUCT_ATTRIBUTE_DEFS_VIEW2 as product_attribute_defs
from eCRM.DBA.PM_PRODUCTS_VIEW2 as products
from eCRM.DBA.PM_PRODUCTS as products_table text literal products_table.DESCRIPTION of (products.DESCRIPTION)
from eCRM.DBA.PM_PRODUCT_ATTRIBUTES_VIEW2 as product_attributes
from eCRM.DBA.PM_CATALOGS_VIEW2 as catalogs
from eCRM.DBA.PM_CATALOG_PRODUCTS_VIEW2 as catalog_products
from eCRM.DBA.XSYS_MODULES as modules
from eCRM.DBA.XSYS_REGISTRY as registries
from eCRM.DBA.XSYS_ORGANIZATIONS_DATA as organizations_data
from eCRM.DBA.XSYS_MESSAGES as xsysmessages
from eCRM.DBA.XSYS_COUNTRIES_VIEW2 as countries
from eCRM.DBA.XSYS_PROVINCES_VIEW2 as provinces
from eCRM.DBA.XSYS_TIMEZONES as timezones
from eCRM.DBA.XSYS_MIME_TYPES as mimetypes
from eCRM.DBA.XSYS_MIME_EXTENSIONS as mimeexts
from eCRM.DBA.XSYS_CNAMES as cnames
from eCRM.DBA.XSYS_QUOTAS as quotas
from eCRM.DBA.XSYS_ROLES as roles
from eCRM.DBA.XSYS_ACCOUNTS as accounts
from eCRM.DBA.XSYS_USERDATA as userdatas
from eCRM.DBA.XSYS_GROUPDATA as groupdatas
from eCRM.DBA.XSYS_MEMBERS as members
from eCRM.DBA.XSYS_SESSIONS_DATA as sessionsdatas
from eCRM.DBA.XSYS_SESSION_DATA as sessiondatas
from eCRM.DBA.XSYS_LIST_MEMBERS_DEFS as list_members_defs
from eCRM.DBA.XSYS_CLASSES as classes
from eCRM.DBA.XSYS_ORG_CLASSES as org_classes
from eCRM.DBA.XSYS_CLASS_METHODS as class_methods
from eCRM.DBA.XSYS_CLASS_VIEWS as class_views
from eCRM.DBA.XSYS_ROLE_PRIVILEGES as role_priveleges
from eCRM.DBA.XSYS_USER_PRIVILEGES as user_priveleges
from eCRM.DBA.XSYS_HISTORY as history
from eCRM.DBA.XSYS_USERS as xsys_users
where (^{companies.}^.COUNTRY_NAME = ^{countries.}^.COUNTRY_NAME)
where (^{contacts.}^.COUNTRY_NAME = ^{countries.}^.COUNTRY_NAME)
where (^{leads.}^.COUNTRY_NAME = ^{countries.}^.COUNTRY_NAME)
where (^{products.}^.COUNTRY_NAME = ^{countries.}^.COUNTRY_NAME)
where (^{orders.}^.SHIP_COUNTRY_NAME = ^{countries.}^.COUNTRY_NAME)
where (^{leads_table.}^.FREETEXT_ID = ^{leads.}^.FREETEXT_ID)
where (^{contacts_table.}^.FREETEXT_ID = ^{contacts.}^.FREETEXT_ID)
where (^{companies_table.}^.FREETEXT_ID = ^{companies.}^.FREETEXT_ID)
where (^{opportunities_table.}^.FREETEXT_ID = ^{opportunities.}^.FREETEXT_ID)
where (^{cases_table.}^.FREETEXT_ID = ^{cases.}^.FREETEXT_ID)
where (^{notes_table.}^.FREETEXT_ID = ^{notes.}^.FREETEXT_ID)
where (^{orders_table.}^.FREETEXT_ID = ^{orders.}^.FREETEXT_ID)
where (^{products_table.}^.FREETEXT_ID = ^{products.}^.FREETEXT_ID)
{
create virtrdf:ecrmDemo1 as graph iri ("http://^{URIQADefaultHost}^/ecrm") option (order 1501)
{
ecrm:Country (countries.COUNTRY_NAME)
a ecrm:Country
as virtrdf:Country-Countrys2 ;
a geo:SpatialThing
as virtrdf:Country-Countrys ;
owl:sameAs ecrm:dbpedia_iri (countries.COUNTRY_NAME) ;
ecrm:countryID countries.COUNTRY_ID
as virtrdf:Country-COUNTRY_ID ;
ecrm:countryID3 countries.COUNTRY_ID3
as virtrdf:Country-COUNTRY_ID3 ;
ecrm:isoCode countries.ISO_CODE
as virtrdf:Country-ISO_CODE ;
ecrm:countryName countries.COUNTRY_NAME
as virtrdf:Country-COUNTRY_NAME .
ecrm:Country (countries.COUNTRY_NAME)
ecrm:has_province
ecrm:Province (provinces.COUNTRY_ID, provinces.PROVINCE_NAME) where
(^{provinces.}^.COUNTRY_ID = ^{countries.}^.COUNTRY_ID) as virtrdf:ecrmCountry-has_province .
ecrm:Province (provinces.COUNTRY_ID, provinces.PROVINCE_NAME)
a ecrm:Province
as virtrdf:ecrmProvince-Provinces2 ;
a geo:SpatialThing
as virtrdf:ecrmProvince-Provinces ;
ecrm:provinceID provinces.PROVINCE_ID
as virtrdf:Province-PROVINCE_ID ;
ecrm:provinceName provinces.PROVINCE_NAME
as virtrdf:ecrmProvince-PROVINCE_NAME .
ecrm:Province (provinces.COUNTRY_ID, provinces.PROVINCE_NAME)
ecrm:is_province_of
ecrm:Country (countries.COUNTRY_NAME) where (^{countries.}^.COUNTRY_ID = ^{provinces.}^.COUNTRY_ID)
as virtrdf:ecrmProvince-is_province_of .
ecrm:SalesQuota (sales_quotas.ORG_ID, sales_quotas.QUOTA_ID)
a ecrm:SalesQuota
as virtrdf:SalesQuota-SalesQuotas ;
ecrm:has_ecrm_organization ecrm:OrganizationsData(sales_quotas.ORG_ID, organizations_data.DNS_ZONE)
where (^{sales_quotas.}^.ORG_ID = ^{organizations_data.}^.ORG_ID)
as virtrdf:SalesQuota-ORG_ID ;
ecrm:has_user ecrm:UserData(members.ORG_ID, sales_quotas.USER_ID)
as virtrdf:SalesQuota-USER_ID ;
ecrm:owner ecrm:XSys_User(sales_quotas.ORG_ID, xsys_users.ACCOUNT_NAME, sales_quotas.OWNER_ID)
where (^{sales_quotas.}^.OWNER_ID = ^{xsys_users.}^.ACCOUNT_ID and ^{sales_quotas.}^.ORG_ID = ^{xsys_users.}^.ORG_ID)
as virtrdf:SalesQuota-OWNER_ID ;
ecrm:fromDate sales_quotas.FROM_DATE
as virtrdf:SalesQuota-FROM_DATE ;
ecrm:toDate sales_quotas.TO_DATE
as virtrdf:SalesQuota-TO_DATE ;
ecrm:quotaValue sales_quotas.QUOTA_VALUE
as virtrdf:SalesQuota-QUOTA_VALUE ;
ecrm:objectives sales_quotas.OBJECTIVES
as virtrdf:SalesQuota-OBJECTIVES .
ecrm:OrganizationsData(sales_quotas.ORG_ID, organizations_data.DNS_ZONE)
ecrm:ecrm_organization_of
ecrm:SalesQuota (sales_quotas.ORG_ID, sales_quotas.QUOTA_ID) where (^{sales_quotas.}^.ORG_ID = ^{organizations_data.}^.ORG_ID) as virtrdf:SalesQuota-is_ecrm_org_of .
ecrm:Company (companies.COMPANY_NAME, companies.COMPANY_ID, companies.ORG_ID)
a ecrm:Company
as virtrdf:Company-Companys2 ;
a foaf:Organization
as virtrdf:Company-Companys ;
ecrm:has_ecrm_organization ecrm:OrganizationsData(companies.ORG_ID, organizations_data.DNS_ZONE) where (^{companies.}^.ORG_ID = ^{organizations_data.}^.ORG_ID)
as virtrdf:Company-ORG_ID ;
ecrm:owner ecrm:XSys_User(companies.ORG_ID, xsys_users.ACCOUNT_NAME, companies.OWNER_ID)
where (^{companies.}^.OWNER_ID = ^{xsys_users.}^.ACCOUNT_ID and ^{companies.}^.ORG_ID = ^{xsys_users.}^.ORG_ID)
as virtrdf:Company-OWNER_ID ;
ecrm:FREETEXT_ID companies.FREETEXT_ID
as virtrdf:Company-FREETEXT_ID ;
foaf:name companies.COMPANY_NAME
as virtrdf:foafCompany-COMPANY_NAME ;
ecrm:industry companies.INDUSTRY_NAME
as virtrdf:Company-INDUSTRY_NAME ;
foaf:homepage companies.URL
as virtrdf:foafCompany-URL ;
foaf:phone companies.PHONE_NUMBER
as virtrdf:foafCompany-PHONE_NUMBER ;
ecrm:phoneExtension companies.PHONE_EXTENSION
as virtrdf:Company-PHONE_EXTENSION ;
ecrm:faxNumber companies.FAX_NUMBER
as virtrdf:Company-FAX_NUMBER ;
ecrm:faxExtension companies.FAX_EXTENSION
as virtrdf:Company-FAX_EXTENSION ;
ecrm:mobileNumber companies.MOBILE_NUMBER
as virtrdf:Company-MOBILE_NUMBER ;
foaf:mbox companies.EMAIL
as virtrdf:foafCompany-EMAIL ;
ecrm:country ecrm:Country(companies.COUNTRY_NAME)
as virtrdf:Company-COUNTRY ;
#ecrm:countryCode countries.COUNTRY_ID where (^{countries.}^.COUNTRY_NAME = ^{companies.}^.COUNTRY_NAME)
# as virtrdf:Company-COUNTRY_CODE ;
ecrm:province companies.PROVINCE
as virtrdf:Company-PROVINCE ;
ecrm:city companies.CITY
as virtrdf:Company-CITY ;
ecrm:dbpedia_city ecrm:dbpedia_iri (companies.CITY)
as virtrdf:Company-dbpedia_CITY ;
ecrm:postalCode companies.POSTAL_CODE
as virtrdf:Company-POSTAL_CODE ;
ecrm:address1 companies.ADDRESS1
as virtrdf:Company-ADDRESS1 ;
ecrm:address2 companies.ADDRESS2
as virtrdf:Company-ADDRESS2 ;
ecrm:description companies.DESCRIPTION
as virtrdf:Company-DESCRIPTION .
ecrm:OrganizationsData(companies.ORG_ID, organizations_data.DNS_ZONE)
ecrm:ecrm_organization_of
ecrm:Company (companies.COMPANY_NAME, companies.COMPANY_ID, companies.ORG_ID)
where (^{companies.}^.ORG_ID = ^{organizations_data.}^.ORG_ID) as virtrdf:Company-is_ecrm_org_of .
ecrm:Country (companies.COUNTRY_NAME)
ecrm:is_country_of
ecrm:Company(companies.COMPANY_NAME, companies.COMPANY_ID, companies.ORG_ID) as virtrdf:Company-is_country_of .
ecrm:CustomFieldDef (custom_field_defs.ORG_ID, custom_field_defs.FIELD_ID)
a ecrm:CustomFieldDefs
as virtrdf:CustomFieldDef-CustomFieldDefs ;
ecrm:has_ecrm_organization ecrm:OrganizationsData(custom_field_defs.ORG_ID, organizations_data.DNS_ZONE) where (^{custom_field_defs.}^.ORG_ID = ^{organizations_data.}^.ORG_ID)
as virtrdf:CustomFieldDef-ORG_ID ;
ecrm:has_class ecrm:Class(custom_field_defs.CLASS_ID)
as virtrdf:CustomFieldDef-CLASS_ID ;
ecrm:fieldName custom_field_defs.FIELD_NAME
as virtrdf:CustomFieldDef-FIELD_NAME ;
ecrm:fieldType custom_field_defs.FIELD_TYPE
as virtrdf:CustomFieldDef-FIELD_TYPE .
ecrm:OrganizationsData(custom_field_defs.ORG_ID, organizations_data.DNS_ZONE)
ecrm:ecrm_organization_of
ecrm:CustomFieldDef (custom_field_defs.ORG_ID, custom_field_defs.FIELD_ID)
where (^{custom_field_defs.}^.ORG_ID = ^{organizations_data.}^.ORG_ID) as virtrdf:CustomFieldDef-is_ecrm_org_of .
ecrm:CustomField (custom_fields.ORG_ID, custom_fields.OBJ_ID, custom_fields.FIELD_ID)
a ecrm:CustomFields
as virtrdf:CustomField-CustomFields ;
ecrm:has_ecrm_organization ecrm:OrganizationsData(custom_fields.ORG_ID, organizations_data.DNS_ZONE) where (^{custom_fields.}^.ORG_ID = ^{organizations_data.}^.ORG_ID)
as virtrdf:CustomField-ORG_ID ;
#ecrm:OBJ_ID custom_fields.OBJ_ID
# as virtrdf:CustomField-OBJ_ID ;
ecrm:has_field ecrm:CustomFieldDef(custom_fields.ORG_ID, custom_fields.FIELD_ID)
as virtrdf:CustomField-FIELD_ID ;
ecrm:fieldValue custom_fields.FIELD_VALUE
as virtrdf:CustomField-FIELD_VALUE .
ecrm:OrganizationsData(custom_fields.ORG_ID, organizations_data.DNS_ZONE)
ecrm:ecrm_organization_of
ecrm:CustomField (custom_fields.ORG_ID, custom_fields.OBJ_ID, custom_fields.FIELD_ID)
where (^{custom_fields.}^.ORG_ID = ^{organizations_data.}^.ORG_ID) as virtrdf:CustomField-is_ecrm_org_of .
ecrm:Note (notes.ORG_ID, notes.NOTE_ID)
a ecrm:Note
as virtrdf:Note-Notes ;
ecrm:has_ecrm_organization ecrm:OrganizationsData(notes.ORG_ID, organizations_data.DNS_ZONE) where (^{notes.}^.ORG_ID = ^{organizations_data.}^.ORG_ID)
as virtrdf:Note-ORG_ID ;
ecrm:owner ecrm:XSys_User(notes.ORG_ID, xsys_users.ACCOUNT_NAME, notes.OWNER_ID)
where (^{notes.}^.OWNER_ID = ^{xsys_users.}^.ACCOUNT_ID and ^{notes.}^.ORG_ID = ^{xsys_users.}^.ORG_ID)
as virtrdf:Note-OWNER_ID ;
ecrm:FREETEXT_ID notes.FREETEXT_ID
as virtrdf:Note-FREETEXT_ID ;
#ecrm:OBJ_ID notes.ORG_ID
# as virtrdf:Note-OBJ_ID ;
#ecrm:REL_ID notes.REL_ID
# as virtrdf:Note-REL_ID ;
ecrm:DESCRIPTION notes.DESCRIPTION
as virtrdf:Note-DESCRIPTION .
ecrm:OrganizationsData(notes.ORG_ID, organizations_data.DNS_ZONE)
ecrm:ecrm_organization_of
ecrm:Note (notes.ORG_ID, notes.NOTE_ID)
where (^{notes.}^.ORG_ID = ^{organizations_data.}^.ORG_ID) as virtrdf:Note-is_ecrm_org_of .
ecrm:Employment (employments.DEPARTMENT, employments.COMPANY_ID, employments.CONTACT_ID, employments.ORG_ID)
a ecrm:Employment
as virtrdf:Employment-Employments ;
ecrm:has_ecrm_organization ecrm:OrganizationsData(employments.ORG_ID, organizations_data.DNS_ZONE) where (^{employments.}^.ORG_ID = ^{organizations_data.}^.ORG_ID)
as virtrdf:Employment-ORG_ID ;
ecrm:has_company ecrm:Company(companies.COMPANY_NAME, employments.COMPANY_ID, employments.ORG_ID)
where (^{employments.}^.COMPANY_ID = ^{companies.}^.COMPANY_ID and ^{employments.}^.ORG_ID = ^{companies.}^.ORG_ID)
as virtrdf:Employment-COMPANY_ID ;
ecrm:has_contact ecrm:Contact(contacts.NAME_FIRST, contacts.NAME_MIDDLE, contacts.NAME_LAST, employments.CONTACT_ID, employments.ORG_ID)
where (^{employments.}^.CONTACT_ID = ^{contacts.}^.CONTACT_ID and ^{employments.}^.ORG_ID = ^{contacts.}^.ORG_ID)
as virtrdf:Employment-CONTACT_ID ;
ecrm:owner ecrm:XSys_User(employments.ORG_ID, xsys_users.ACCOUNT_NAME, employments.OWNER_ID)
where (^{employments.}^.OWNER_ID = ^{xsys_users.}^.ACCOUNT_ID and ^{employments.}^.ORG_ID = ^{xsys_users.}^.ORG_ID)
as virtrdf:Employment-OWNER_ID ;
#ecrm:EMPLOYMENT_ID employments.EMPLOYMENT_ID
# as virtrdf:Employment-EMPLOYMENT_ID ;
ecrm:department employments.DEPARTMENT
as virtrdf:Employment-Department ;
ecrm:title employments.TITLE
as virtrdf:Employment-TITLE ;
ecrm:phoneNumber employments.PHONE_NUMBER
as virtrdf:Employment-PHONE_NUMBER ;
ecrm:phoneExtension employments.PHONE_EXTENSION
as virtrdf:Employment-PHONE_EXTENSION ;
ecrm:faxNumber employments.FAX_NUMBER
as virtrdf:Employment-FAX_NUMBER ;
ecrm:faxExtension employments.FAX_EXTENSION
as virtrdf:Employment-FAX_EXTENSION ;
ecrm:mobileNumber employments.MOBILE_NUMBER
as virtrdf:Employment-MOBILE_NUMBER ;
ecrm:email employments.EMAIL
as virtrdf:Employment-EMAIL .
ecrm:OrganizationsData(employments.ORG_ID, organizations_data.DNS_ZONE)
ecrm:ecrm_organization_of
ecrm:Employment (employments.DEPARTMENT, employments.COMPANY_ID, employments.CONTACT_ID, employments.ORG_ID)
where (^{employments.}^.ORG_ID = ^{organizations_data.}^.ORG_ID) as virtrdf:Employment-is_ecrm_org_of .
ecrm:Contact(contacts.NAME_FIRST, contacts.NAME_MIDDLE, contacts.NAME_LAST, employments.CONTACT_ID, employments.ORG_ID)
ecrm:is_contact_of
ecrm:Employment (employments.DEPARTMENT, employments.COMPANY_ID, employments.CONTACT_ID, employments.ORG_ID)
where (^{employments.}^.CONTACT_ID = ^{contacts.}^.CONTACT_ID and ^{employments.}^.ORG_ID = ^{contacts.}^.ORG_ID)
as virtrdf:Employment-is_coontact_of .
ecrm:Company (companies.COMPANY_NAME, employments.COMPANY_ID, employments.ORG_ID)
ecrm:is_company_of
ecrm:Employment (employments.DEPARTMENT, employments.COMPANY_ID, employments.CONTACT_ID, employments.ORG_ID)
where (^{employments.}^.COMPANY_ID = ^{companies.}^.COMPANY_ID and ^{employments.}^.ORG_ID = ^{companies.}^.ORG_ID)
as virtrdf:Employment-is_company_of .
ecrm:Contact (contacts.NAME_FIRST, contacts.NAME_MIDDLE, contacts.NAME_LAST, contacts.CONTACT_ID, contacts.ORG_ID)
a ecrm:Contact
as virtrdf:Contact-Contacts2 ;
a foaf:Person
as virtrdf:Contact-Contacts ;
ecrm:has_ecrm_organization ecrm:OrganizationsData(contacts.ORG_ID, organizations_data.DNS_ZONE) where (^{contacts.}^.ORG_ID = ^{organizations_data.}^.ORG_ID)
as virtrdf:Contact-ORG_ID ;
ecrm:owner ecrm:XSys_User(contacts.ORG_ID, xsys_users.ACCOUNT_NAME, contacts.OWNER_ID)
where (^{contacts.}^.OWNER_ID = ^{xsys_users.}^.ACCOUNT_ID and ^{contacts.}^.ORG_ID = ^{xsys_users.}^.ORG_ID)
as virtrdf:Contact-OWNER_ID ;
ecrm:FREETEXT_ID contacts.FREETEXT_ID
as virtrdf:Contact-FREETEXT_ID ;
foaf:title contacts.NAME_TITLE
as virtrdf:foafContact-NAME_TITLE ;
foaf:firstName contacts.NAME_FIRST
as virtrdf:foafContact-NAME_FIRST ;
foaf:givenname contacts.NAME_MIDDLE
as virtrdf:foafContact-NAME_MIDDLE ;
foaf:surname contacts.NAME_LAST
as virtrdf:foafContact-NAME_LAST ;
foaf:birthday contacts.BIRTH_DATE
as virtrdf:foafContact-BIRTH_DATE ;
ecrm:contactType contacts.CONTACT_TYPE_TITLE
as virtrdf:Contact-CONTACT_TYPE_TITLE ;
ecrm:manager contacts.MANAGER_NAME
as virtrdf:Contact-MANAGER_NAME ;
sioc:User ecrm:sioc_user_iri(contacts.MANAGER_NAME)
as virtrdf:siocContact-MANAGER_NAME ;
ecrm:business contacts.BUSINESS
as virtrdf:Contact-BUSINESS ;
foaf:interest contacts.INTEREST
as virtrdf:foafContact-INTEREST ;
ecrm:open contacts.OPEN_ID
as virtrdf:Contact-OPEN ;
ecrm:sourceTitle contacts.SOURCE_TITLE
as virtrdf:Contact-SOURCE_TITLE ;
foaf:phone contacts.PHONE_NUMBER
as virtrdf:foafContact-PHONE_NUMBER ;
ecrm:phoneExtension contacts.PHONE_EXTENSION
as virtrdf:Contact-PHONE_EXTENSION ;
ecrm:phone2Number contacts.PHONE2_NUMBER
as virtrdf:Contact-PHONE2_NUMBER ;
ecrm:phone2Extension contacts.PHONE2_EXTENSION
as virtrdf:Contact-PHONE2_EXTENSION ;
ecrm:faxNumber contacts.FAX_NUMBER
as virtrdf:Contact-FAX_NUMBER ;
ecrm:faxExtension contacts.FAX_EXTENSION
as virtrdf:Contact-FAX_EXTENSION ;
ecrm:mobileNumber contacts.MOBILE_NUMBER
as virtrdf:Contact-MOBILE_NUMBER ;
foaf:mbox contacts.EMAIL
as virtrdf:foafContact-EMAIL ;
ecrm:country ecrm:Country(contacts.COUNTRY_NAME)
as virtrdf:Contact-COUNTRY_NAME ;
#ecrm:countryCode ecrm:Country (countries.COUNTRY_ID) where (^{countries.}^.COUNTRY_NAME = ^{contacts.}^.COUNTRY_NAME)
# as virtrdf:Contact-COUNTRY_CODE ;
ecrm:province contacts.PROVINCE
as virtrdf:Contact-PROVINCE ;
ecrm:city contacts.CITY
as virtrdf:Contact-CITY ;
ecrm:dbpedia_city ecrm:dbpedia_iri (contacts.CITY)
as virtrdf:Contact-dbpedia_CITY ;
ecrm:postalCode contacts.POSTAL_CODE
as virtrdf:Contact-POSTAL_CODE ;
ecrm:address1 contacts.ADDRESS1
as virtrdf:Contact-ADDRESS1 ;
ecrm:address2 contacts.ADDRESS2
as virtrdf:Contact-ADDRESS2 ;
ecrm:description contacts.DESCRIPTION
as virtrdf:Contact-DESCRIPTION .
ecrm:OrganizationsData(contacts.ORG_ID, organizations_data.DNS_ZONE)
ecrm:ecrm_organization_of
ecrm:Contact (contacts.NAME_FIRST, contacts.NAME_MIDDLE, contacts.NAME_LAST, contacts.CONTACT_ID, contacts.ORG_ID)
where (^{contacts.}^.ORG_ID = ^{organizations_data.}^.ORG_ID) as virtrdf:Contact-is_ecrm_org_of .
ecrm:Country (contacts.COUNTRY_NAME)
ecrm:is_country_of
ecrm:Contact(contacts.NAME_FIRST, contacts.NAME_MIDDLE, contacts.NAME_LAST, contacts.CONTACT_ID, contacts.ORG_ID) as virtrdf:Contacts-is_country_of .
ecrm:Lead (leads.SUBJECT, leads.ORG_ID, leads.LEAD_ID)
a ecrm:Lead
as virtrdf:Lead-Leads2 ;
a foaf:Person
as virtrdf:Lead-Leads ;
ecrm:has_ecrm_organization ecrm:OrganizationsData(leads.ORG_ID, organizations_data.DNS_ZONE) where (^{leads.}^.ORG_ID = ^{organizations_data.}^.ORG_ID)
as virtrdf:Lead-ORG_ID ;
ecrm:owner ecrm:XSys_User(leads.ORG_ID, xsys_users.ACCOUNT_NAME, leads.OWNER_ID)
where (^{leads.}^.OWNER_ID = ^{xsys_users.}^.ACCOUNT_ID and ^{leads.}^.ORG_ID = ^{xsys_users.}^.ORG_ID)
as virtrdf:Lead-OWNER_ID ;
ecrm:FREETEXT_ID leads.FREETEXT_ID
as virtrdf:Lead-FREETEXT_ID ;
ecrm:subject leads.SUBJECT
as virtrdf:Lead-SUBJECT ;
foaf:title leads.NAME_TITLE
as virtrdf:foafLead-NAME_TITLE ;
foaf:firstName leads.NAME_FIRST
as virtrdf:foafLead-NAME_FIRST ;
foaf:givenname leads.NAME_MIDDLE
as virtrdf:Lead-NAME_MIDDLE ;
foaf:surname leads.NAME_LAST
as virtrdf:foafLead-NAME_LAST ;
ecrm:company leads.COMPANY_NAME
as virtrdf:Lead-COMPANY_NAME ;
ecrm:has_company ecrm:Company(leads.COMPANY_NAME, leads.COMPANY_ID, leads.ORG_ID)
as virtrdf:Lead-COMPANY_ID ;
#ecrm:REL_ID leads.REL_ID
# as virtrdf:Lead-REL_ID ;
ecrm:leadTitle leads.TITLE
as virtrdf:Lead-TITLE ;
ecrm:status leads.STATUS
as virtrdf:Lead-STATUS ;
ecrm:rating leads.RATING
as virtrdf:Lead-RATING ;
foaf:phone leads.PHONE_NUMBER
as virtrdf:foafLead-PHONE_NUMBER ;
ecrm:phoneExtension leads.PHONE_EXTENSION
as virtrdf:Lead-PHONE_EXTENSION ;
ecrm:mobileNumber leads.MOBILE_NUMBER
as virtrdf:Lead-MOBILE_NUMBER ;
ecrm:faxNumber leads.FAX_NUMBER
as virtrdf:Lead-FAX_NUMBER ;
ecrm:faxExtension leads.FAX_EXTENSION
as virtrdf:Lead-FAX_EXTENSION ;
foaf:mbox leads.EMAIL
as virtrdf:foafLead-EMAIL ;
ecrm:country ecrm:Country(leads.COUNTRY_NAME)
as virtrdf:Lead-COUNTRY_NAME ;
#ecrm:countryCode ecrm:Country (countries.COUNTRY_ID) where (^{countries.}^.COUNTRY_NAME = ^{leads.}^.COUNTRY_NAME)
# as virtrdf:Lead-COUNTRY_CODE ;
ecrm:province leads.PROVINCE
as virtrdf:Lead-PROVINCE ;
ecrm:city leads.CITY
as virtrdf:Lead-CITY ;
ecrm:dbpedia_city ecrm:dbpedia_iri (leads.CITY)
as virtrdf:Lead-dbpedia_CITY ;
ecrm:postalCode leads.POSTAL_CODE
as virtrdf:Lead-POSTAL_CODE ;
ecrm:address1 leads.ADDRESS1
as virtrdf:Lead-ADDRESS1 ;
ecrm:address2 leads.ADDRESS2
as virtrdf:Lead-ADDRESS2 .
ecrm:OrganizationsData(leads.ORG_ID, organizations_data.DNS_ZONE)
ecrm:ecrm_organization_of
ecrm:Lead (leads.SUBJECT, leads.ORG_ID, leads.LEAD_ID)
where (^{leads.}^.ORG_ID = ^{organizations_data.}^.ORG_ID) as virtrdf:Lead-is_ecrm_org_of .
ecrm:Company (leads.COMPANY_NAME, companies.COMPANY_ID, leads.ORG_ID)
ecrm:is_company_of
ecrm:Lead (leads.SUBJECT, leads.ORG_ID, leads.LEAD_ID)
where (^{leads.}^.COMPANY_NAME = ^{companies.}^.COMPANY_NAME and ^{leads.}^.ORG_ID = ^{companies.}^.ORG_ID)
as virtrdf:Lead-is_company_of .
ecrm:Country (leads.COUNTRY_NAME)
ecrm:is_country_of
ecrm:Lead(leads.SUBJECT, leads.ORG_ID, leads.LEAD_ID) as virtrdf:Lead-is_country_of .
ecrm:Opportunity (opportunities.ORG_ID, opportunities.OPPORTUNITY_ID)
a ecrm:Opportunity
as virtrdf:Opportunity-Opportunitys2 ;
a cal:Vevent
as virtrdf:Opportunity-Opportunitys ;
ecrm:has_ecrm_organization ecrm:OrganizationsData(opportunities.ORG_ID, organizations_data.DNS_ZONE) where (^{opportunities.}^.ORG_ID = ^{organizations_data.}^.ORG_ID)
as virtrdf:Opportunity-ORG_ID ;
ecrm:owner ecrm:XSys_User(opportunities.ORG_ID, xsys_users.ACCOUNT_NAME, opportunities.OWNER_ID)
where (^{opportunities.}^.OWNER_ID = ^{xsys_users.}^.ACCOUNT_ID and ^{opportunities.}^.ORG_ID = ^{xsys_users.}^.ORG_ID)
as virtrdf:Opportunity-OWNER_ID ;
ecrm:FREETEXT_ID opportunities.FREETEXT_ID
as virtrdf:Opportunity-FREETEXT_ID ;
ecrm:opportunityName opportunities.OPPORTUNITY_NAME
as virtrdf:Opportunity-OPPORTUNITY_NAME ;
sioc:User ecrm:sioc_user_iri(opportunities.MANAGER_NAME)
as virtrdf:siocOpportunity-MANAGER_NAME ;
ecrm:manager opportunities.MANAGER_NAME
as virtrdf:Opportunity-MANAGER_NAME ;
ecrm:has_company ecrm:Company(opportunities.COMPANY_NAME, opportunities.COMPANY_ID, opportunities.ORG_ID)
as virtrdf:Opportunity-COMPANY_ID ;
ecrm:company opportunities.COMPANY_NAME
as virtrdf:Opportunity-COMPANY_NAME ;
ecrm:has_contact ecrm:Contact(contacts.NAME_FIRST, contacts.NAME_MIDDLE, contacts.NAME_LAST, opportunities.CONTACT_ID, opportunities.ORG_ID)
where (^{opportunities.}^.CONTACT_ID = ^{contacts.}^.CONTACT_ID and ^{opportunities.}^.ORG_ID = ^{contacts.}^.ORG_ID)
as virtrdf:Opportunity-CONTACT_ID ;
ecrm:contactName opportunities.CONTACT_NAME
as virtrdf:Opportunity-CONTACT_NAME ;
#ecrm:companyRelID opportunities.COMPANY_REL_ID
# as virtrdf:Opportunity-COMPANY_REL_ID ;
#ecrm:contactRelID opportunities.CONTACT_REL_ID
# as virtrdf:Opportunity-CONTACT_REL_ID ;
ecrm:forecast opportunities.FORECAST
as virtrdf:Opportunity-FORECAST ;
ecrm:estimateClose opportunities.ESTIMATE_CLOSE
as virtrdf:Opportunity-ESTIMATE_CLOSE ;
cal:dtstart opportunities.START_DATE
as virtrdf:calOpportunity-START_DATE ;
ecrm:startDate opportunities.START_DATE
as virtrdf:Opportunity-START_DATE ;
ecrm:status opportunities.STATUS
as virtrdf:Opportunity-STATUS ;
ecrm:code opportunities.CODE
as virtrdf:Opportunity-CODE ;
ecrm:stageTitle opportunities.STAGE_TITLE
as virtrdf:Opportunity-STAGE_TITLE ;
ecrm:sourceTitle opportunities.SOURCE_TITLE
as virtrdf:Opportunity-SOURCE_TITLE ;
ecrm:closedAmount opportunities.CLOSED_AMOUNT
as virtrdf:Opportunity-CLOSED_AMOUNT ;
cal:dtend opportunities.CLOSED_DATE
as virtrdf:calOpportunity-CLOSED_DATE ;
ecrm:closedDate opportunities.CLOSED_DATE
as virtrdf:Opportunity-CLOSED_DATE ;
ecrm:propability opportunities.PROBABILITY
as virtrdf:Opportunity-PROBABILITY ;
ecrm:potential opportunities.POTENTIAL
as virtrdf:Opportunity-POTENTIAL .
ecrm:OrganizationsData(opportunities.ORG_ID, organizations_data.DNS_ZONE)
ecrm:ecrm_organization_of
ecrm:Opportunity (opportunities.ORG_ID, opportunities.OPPORTUNITY_ID)
where (^{opportunities.}^.ORG_ID = ^{organizations_data.}^.ORG_ID) as virtrdf:Opportunity-is_ecrm_org_of .
ecrm:Contact(contacts.NAME_FIRST, contacts.NAME_MIDDLE, contacts.NAME_LAST, opportunities.CONTACT_ID, opportunities.ORG_ID)
ecrm:is_contact_of
ecrm:Opportunity (opportunities.ORG_ID, opportunities.OPPORTUNITY_ID)
where (^{opportunities.}^.CONTACT_ID = ^{contacts.}^.CONTACT_ID and ^{opportunities.}^.ORG_ID = ^{contacts.}^.ORG_ID)
as virtrdf:Opportunity-is_contact_of .
ecrm:Company (opportunities.COMPANY_NAME, opportunities.COMPANY_ID, opportunities.ORG_ID)
ecrm:is_company_of
ecrm:Opportunity (opportunities.ORG_ID, opportunities.OPPORTUNITY_ID)
as virtrdf:Opportunity-is_company_of .
ecrm:Case (cases.ORG_ID, cases.CASE_ID)
a ecrm:Case
as virtrdf:Case-Cases2 ;
a cal:Vevent
as virtrdf:Case-Cases ;
ecrm:has_ecrm_organization ecrm:OrganizationsData(cases.ORG_ID, organizations_data.DNS_ZONE) where (^{cases.}^.ORG_ID = ^{organizations_data.}^.ORG_ID)
as virtrdf:Case-ORG_ID ;
ecrm:owner ecrm:XSys_User(cases.ORG_ID, xsys_users.ACCOUNT_NAME, cases.OWNER_ID)
where (^{cases.}^.OWNER_ID = ^{xsys_users.}^.ACCOUNT_ID and ^{cases.}^.ORG_ID = ^{xsys_users.}^.ORG_ID)
as virtrdf:Case-OWNER_ID ;
ecrm:FREETEXT_ID cases.FREETEXT_ID
as virtrdf:Case-FREETEXT_ID ;
ecrm:summary cases.SUMMARY
as virtrdf:Case-SUMMARY ;
ecrm:status cases.STATUS
as virtrdf:Case-STATUS ;
cal:priority cases.PRIORITY
as virtrdf:calCase-PRIORITY ;
ecrm:priority cases.PRIORITY
as virtrdf:Case-PRIORITY ;
cal:dtstart cases.OPEN_DATE
as virtrdf:calCase-OPEN_DATE ;
ecrm:openDate cases.OPEN_DATE
as virtrdf:Case-OPEN_DATE ;
cal:dtclose cases.LAST_ACTION_DATE
as virtrdf:calCase-LAST_ACTION_DATE ;
ecrm:lastActionDate cases.LAST_ACTION_DATE
as virtrdf:Case-LAST_ACTION_DATE ;
ecrm:daysOld cases.DAYS_OLD
as virtrdf:Case-DAYS_OLD ;
ecrm:has_company ecrm:Company(cases.COMPANY_NAME, cases.COMPANY_ID, cases.ORG_ID)
as virtrdf:Case-COMPANY_ID ;
ecrm:company cases.COMPANY_NAME
as virtrdf:Case-COMPANY_NAME ;
ecrm:has_contact ecrm:Contact(contacts.NAME_FIRST, contacts.NAME_MIDDLE, contacts.NAME_LAST, cases.CONTACT_ID, cases.ORG_ID)
where (^{cases.}^.CONTACT_ID = ^{contacts.}^.CONTACT_ID and ^{cases.}^.ORG_ID = ^{contacts.}^.ORG_ID)
as virtrdf:Case-CONTACT_ID ;
ecrm:contactName cases.CONTACT_NAME
as virtrdf:Case-CONTACT_NAME ;
cal:url cases.URI
as virtrdf:calCase-URI ;
ecrm:uri cases.URI
as virtrdf:Case-URI ;
ecrm:application cases.APPLICATION
as virtrdf:Case-APPLICATION ;
ecrm:appVer cases.APPVER
as virtrdf:Case-APPVER ;
ecrm:phoneNumber cases.PHONE_NUMBER
as virtrdf:Case-PHONE_NUMBER ;
ecrm:relationship cases.RELATIONSHIP
as virtrdf:Case-RELATIONSHIP ;
ecrm:email cases.EMAIL
as virtrdf:Case-EMAIL ;
ecrm:client cases.CLIENT
as virtrdf:Case-CLIENT ;
ecrm:clientVersion cases.CLIENT_VERSION
as virtrdf:Case-CLIENT_VERSION ;
ecrm:office cases.OFFICE
as virtrdf:Case-OFFICE ;
ecrm:consultant cases.CONSULTANT
as virtrdf:Case-CONSULTANT ;
ecrm:dbVendor cases.DB_VENDOR
as virtrdf:Case-DB_VENDOR ;
ecrm:dbVer cases.DB_VER
as virtrdf:Case-DB_VER ;
ecrm:misTsID cases.MIS_TS_ID
as virtrdf:Case-MIS_TS_ID ;
ecrm:oplClient cases.OPL_CLIENT
as virtrdf:Case-OPL_CLIENT ;
ecrm:oplVer cases.OPL_VER
as virtrdf:Case-OPL_VER ;
ecrm:server cases.SERVER
as virtrdf:Case-SERVER ;
ecrm:serverVersion cases.SERVER_VERSION
as virtrdf:Case-SERVER_VERSION ;
ecrm:downloadDate cases.DOWNLOAD_DATE
as virtrdf:Case-DOWNLOAD_DATE ;
ecrm:jobTitle cases.JOB_TITLE
as virtrdf:Case-JOB_TITLE ;
ecrm:source cases.SOURCE
as virtrdf:Case-SOURCE ;
ecrm:year cases.YEAR
as virtrdf:Case-YEAR ;
ecrm:month cases.MONTH
as virtrdf:Case-MONTH ;
ecrm:quarter cases.QUARTER
as virtrdf:Case-QUARTER ;
ecrm:whenOrder cases.WHEN_ORDER
as virtrdf:Case-WHEN_ORDER ;
ecrm:internalStatus cases.INTERNAL_STATUS
as virtrdf:Case-INTERNAL_STATUS ;
ecrm:financialYear cases.FINANCIAL_YEAR
as virtrdf:Case-FINANCIAL_YEAR .
#ecrm:contactRelID cases.CONTACT_REL_ID
# as virtrdf:Case-CONTACT_REL_ID ;
#ecrm:companyRelID cases.COMPANY_REL_ID
# as virtrdf:Case-COMPANY_REL_ID .
ecrm:OrganizationsData(cases.ORG_ID, organizations_data.DNS_ZONE)
ecrm:ecrm_organization_of
ecrm:Case (cases.ORG_ID, cases.CASE_ID)
where (^{cases.}^.ORG_ID = ^{organizations_data.}^.ORG_ID) as virtrdf:Case-is_ecrm_org_of .
ecrm:Contact(contacts.NAME_FIRST, contacts.NAME_MIDDLE, contacts.NAME_LAST, cases.CONTACT_ID, cases.ORG_ID)
ecrm:is_contact_of
ecrm:Case (cases.ORG_ID, cases.CASE_ID)
where (^{cases.}^.CONTACT_ID = ^{contacts.}^.CONTACT_ID and ^{cases.}^.ORG_ID = ^{contacts.}^.ORG_ID)
as virtrdf:Case-is_contact_of .
ecrm:Company (cases.COMPANY_NAME, cases.COMPANY_ID, cases.ORG_ID)
ecrm:is_company_of
ecrm:Case (cases.ORG_ID, cases.CASE_ID)
as virtrdf:Case-is_company_of .
ecrm:Activity (activities.ORG_ID, activities.ACT_ID, activities.OBJ_ID)
a ecrm:Activity
as virtrdf:Activity-Activitys2 ;
a cal:Vevent
as virtrdf:Activity-Activitys ;
ecrm:has_ecrm_organization ecrm:OrganizationsData(activities.ORG_ID, organizations_data.DNS_ZONE) where (^{activities.}^.ORG_ID = ^{organizations_data.}^.ORG_ID)
as virtrdf:Activity-ORG_ID ;
#ecrm:ACTIVITY_ID activities.ACTIVITY_ID
# as virtrdf:Activity-ACTIVITY_ID ;
#ecrm:ACT_ID activities.ACT_ID
# as virtrdf:Activity-ACT_ID ;
#ecrm:OBJ_ID activities.OBJ_ID
# as virtrdf:Activity-OBJ_ID ;
ecrm:owner ecrm:XSys_User(activities.ORG_ID, xsys_users.ACCOUNT_NAME, activities.OWNER_ID)
where (^{activities.}^.OWNER_ID = ^{xsys_users.}^.ACCOUNT_ID and ^{activities.}^.ORG_ID = ^{xsys_users.}^.ORG_ID)
as virtrdf:Activity-OWNER_ID .
ecrm:OrganizationsData(activities.ORG_ID, organizations_data.DNS_ZONE)
ecrm:ecrm_organization_of
ecrm:Activity (activities.ORG_ID, activities.ACT_ID, activities.OBJ_ID)
where (^{activities.}^.ORG_ID = ^{organizations_data.}^.ORG_ID) as virtrdf:Activity-is_ecrm_org_of .
ecrm:MailMessage (messages.ORG_ID, messages.MAIL_MSG_ID, messages.OBJ_ID)
a ecrm:MailMessage
as virtrdf:MailMessage-MailMessages ;
ecrm:has_ecrm_organization ecrm:OrganizationsData(messages.ORG_ID, organizations_data.DNS_ZONE) where (^{messages.}^.ORG_ID = ^{organizations_data.}^.ORG_ID)
as virtrdf:MailMessage-ORG_ID ;
#ecrm:MAIL_MESSAGE_ID messages.MAIL_MESSAGE_ID
# as virtrdf:MailMessage-MAIL_MESSAGE_ID ;
#ecrm:MAIL_MSG_ID messages.MAIL_MSG_ID
# as virtrdf:MailMessage-MAIL_MSG_ID ;
#ecrm:OBJ_ID messages.OBJ_ID
# as virtrdf:MailMessage-OBJ_ID ;
ecrm:owner ecrm:XSys_User(messages.ORG_ID, xsys_users.ACCOUNT_NAME, messages.OWNER_ID)
where (^{messages.}^.OWNER_ID = ^{xsys_users.}^.ACCOUNT_ID and ^{messages.}^.ORG_ID = ^{xsys_users.}^.ORG_ID)
as virtrdf:MailMessage-OWNER_ID .
ecrm:OrganizationsData(messages.ORG_ID, organizations_data.DNS_ZONE)
ecrm:ecrm_organization_of
ecrm:MailMessage (messages.ORG_ID, messages.MAIL_MSG_ID, messages.OBJ_ID)
where (^{messages.}^.ORG_ID = ^{organizations_data.}^.ORG_ID) as virtrdf:MailMessage-is_ecrm_org_of .
ecrm:Document (documents.ORG_ID, documents.DOC_ID, documents.OBJ_ID)
a ecrm:Document
as virtrdf:Document-Documents2 ;
a foaf:Document
as virtrdf:Document-Documents ;
ecrm:has_ecrm_organization ecrm:OrganizationsData(documents.ORG_ID, organizations_data.DNS_ZONE) where (^{documents.}^.ORG_ID = ^{organizations_data.}^.ORG_ID)
as virtrdf:Document-ORG_ID ;
#ecrm:documentId documents.DOCUMENT_ID
# as virtrdf:Document-DOCUMENT_ID ;
#ecrm:DOC_ID documents.DOC_ID
# as virtrdf:Document-DOC_ID ;
ecrm:owner ecrm:XSys_User(documents.ORG_ID, xsys_users.ACCOUNT_NAME, documents.OWNER_ID)
where (^{documents.}^.OWNER_ID = ^{xsys_users.}^.ACCOUNT_ID and ^{documents.}^.ORG_ID = ^{xsys_users.}^.ORG_ID)
as virtrdf:Document-OWNER_ID ;
#ecrm:OBJ_ID documents.OBJ_ID
# as virtrdf:Document-OBJ_ID .
ecrm:item documents.ITEM
as virtrdf:Document-ITEM ;
ecrm:reference documents.REFERENCE
as virtrdf:Document-REFERENCE .
ecrm:OrganizationsData(documents.ORG_ID, organizations_data.DNS_ZONE)
ecrm:ecrm_organization_of
ecrm:Document (documents.ORG_ID, documents.DOC_ID, documents.OBJ_ID)
where (^{documents.}^.ORG_ID = ^{organizations_data.}^.ORG_ID) as virtrdf:Document-is_ecrm_org_of .
ecrm:Influencer (influencers.ORG_ID, influencers.INFLUENCER_ID)
a ecrm:Influencer
as virtrdf:Influencer-Influencers2 ;
a foaf:Person
as virtrdf:Influencer-Influencers ;
ecrm:has_ecrm_organization ecrm:OrganizationsData(influencers.ORG_ID, organizations_data.DNS_ZONE) where (^{influencers.}^.ORG_ID = ^{organizations_data.}^.ORG_ID)
as virtrdf:Influencer-ORG_ID ;
ecrm:owner ecrm:XSys_User(influencers.ORG_ID, xsys_users.ACCOUNT_NAME, influencers.OWNER_ID)
where (^{influencers.}^.OWNER_ID = ^{xsys_users.}^.ACCOUNT_ID and ^{influencers.}^.ORG_ID = ^{xsys_users.}^.ORG_ID)
as virtrdf:Influencer-OWNER_ID ;
ecrm:has_opportunity ecrm:Opportunity(influencers.ORG_ID, influencers.OPPORTUNITY_ID)
as virtrdf:Influencer-OPPORTUNITY_ID ;
ecrm:has_company ecrm:Company(companies.COMPANY_NAME, influencers.COMPANY_ID, influencers.ORG_ID)
where (^{influencers.}^.COMPANY_ID = ^{companies.}^.COMPANY_ID and ^{influencers.}^.ORG_ID = ^{companies.}^.ORG_ID)
as virtrdf:Influencer-COMPANY_ID ;
ecrm:contactName influencers.CONTACT_NAME
as virtrdf:Influencer-CONTACT_NAME ;
foaf:title influencers.TITLE
as virtrdf:foafInfluencer-TITLE ;
ecrm:IROLE influencers.IROLE
as virtrdf:Influencer-IROLE ;
ecrm:responseMode influencers.RESPONSE_MODE
as virtrdf:Influencer-RESPONSE_MODE .
ecrm:Company (companies.COMPANY_NAME, influencers.COMPANY_ID, influencers.ORG_ID)
ecrm:is_company_of
ecrm:Influencer (influencers.ORG_ID, influencers.INFLUENCER_ID)
where (^{influencers.}^.COMPANY_ID = ^{companies.}^.COMPANY_ID and ^{influencers.}^.ORG_ID = ^{companies.}^.ORG_ID)
as virtrdf:Influencer-is_company_of .
ecrm:OrganizationsData(influencers.ORG_ID, organizations_data.DNS_ZONE)
ecrm:ecrm_organization_of
ecrm:Influencer (influencers.ORG_ID, influencers.INFLUENCER_ID)
where (^{influencers.}^.ORG_ID = ^{organizations_data.}^.ORG_ID) as virtrdf:Influencer-is_ecrm_org_of .
ecrm:Team (teams.ORG_ID, teams.OPPORTUNITY_ID, teams.CONTACT_ID)
a ecrm:Team
as virtrdf:Team-Teams ;
ecrm:has_ecrm_organization ecrm:OrganizationsData(teams.ORG_ID, organizations_data.DNS_ZONE) where (^{teams.}^.ORG_ID = ^{organizations_data.}^.ORG_ID)
as virtrdf:Team-ORG_ID ;
#ecrm:teamId teams.TEAM_ID
# as virtrdf:Team-TEAM_ID ;
ecrm:has_opportunity ecrm:Opportunity(teams.ORG_ID, teams.OPPORTUNITY_ID)
as virtrdf:Team-OPPORTUNITY_ID ;
ecrm:owner ecrm:XSys_User(teams.ORG_ID, xsys_users.ACCOUNT_NAME, teams.OWNER_ID)
where (^{teams.}^.OWNER_ID = ^{xsys_users.}^.ACCOUNT_ID and ^{teams.}^.ORG_ID = ^{xsys_users.}^.ORG_ID)
as virtrdf:Team-OWNER_ID ;
ecrm:has_contact ecrm:Contact(contacts.NAME_FIRST, contacts.NAME_MIDDLE, contacts.NAME_LAST, teams.CONTACT_ID, teams.ORG_ID)
where (^{teams.}^.CONTACT_ID = ^{contacts.}^.CONTACT_ID and ^{teams.}^.ORG_ID = ^{contacts.}^.ORG_ID)
as virtrdf:Team-CONTACT_ID ;
ecrm:title teams.TITLE
as virtrdf:Team-TITLE ;
ecrm:department teams.DEPARTMENT
as virtrdf:Team-DEPARTMENT ;
ecrm:TROLE teams.TROLE
as virtrdf:Team-TROLE .
ecrm:OrganizationsData(teams.ORG_ID, organizations_data.DNS_ZONE)
ecrm:ecrm_organization_of
ecrm:Team (teams.ORG_ID, teams.OPPORTUNITY_ID, teams.CONTACT_ID)
where (^{teams.}^.ORG_ID = ^{organizations_data.}^.ORG_ID) as virtrdf:Team-is_ecrm_org_of .
ecrm:Contact(contacts.NAME_FIRST, contacts.NAME_MIDDLE, contacts.NAME_LAST, teams.CONTACT_ID, teams.ORG_ID)
ecrm:is_contact_of
ecrm:Team (teams.ORG_ID, teams.OPPORTUNITY_ID, teams.CONTACT_ID)
where (^{teams.}^.CONTACT_ID = ^{contacts.}^.CONTACT_ID and ^{teams.}^.ORG_ID = ^{contacts.}^.ORG_ID)
as virtrdf:Team-is_contact_of .
ecrm:Competitor (competitors.ORG_ID, competitors.COMPETITOR_ID)
a ecrm:Competitor
as virtrdf:Competitor-Competitors2 ;
a foaf:Organization
as virtrdf:Competitor-Competitors ;
ecrm:has_ecrm_organization ecrm:OrganizationsData(competitors.ORG_ID, organizations_data.DNS_ZONE) where (^{competitors.}^.ORG_ID = ^{organizations_data.}^.ORG_ID)
as virtrdf:Competitor-ORG_ID ;
ecrm:owner ecrm:XSys_User(competitors.ORG_ID, xsys_users.ACCOUNT_NAME, competitors.OWNER_ID)
where (^{competitors.}^.OWNER_ID = ^{xsys_users.}^.ACCOUNT_ID and ^{competitors.}^.ORG_ID = ^{xsys_users.}^.ORG_ID)
as virtrdf:Competitor-OWNER_ID ;
ecrm:has_opportunity ecrm:Opportunity(competitors.ORG_ID, competitors.OPPORTUNITY_ID)
as virtrdf:Competitor-OPPORTUNITY_ID ;
ecrm:has_company ecrm:Company(companies.COMPANY_NAME, competitors.COMPANY_ID, competitors.ORG_ID)
where (^{competitors.}^.COMPANY_ID = ^{companies.}^.COMPANY_ID and ^{competitors.}^.ORG_ID = ^{companies.}^.ORG_ID)
as virtrdf:Competitor-COMPANY_ID ;
ecrm:has_product ecrm:Product(competitors.ORG_ID, competitors.PRODUCT_ID)
as virtrdf:Competitor-PRODUCT_ID ;
foaf:name competitors.CONTACT_NAME
as virtrdf:foafCompetitor-CONTACT_NAME ;
ecrm:productName competitors.PRODUCT_NAME
as virtrdf:Competitor-PRODUCT_NAME ;
ecrm:Strengths competitors.STRENGTHS
as virtrdf:Competitor-STRENGTHS ;
ecrm:Weakness competitors.WEAKNESS
as virtrdf:Competitor-WEAKNESS ;
ecrm:Rating competitors.RATING
as virtrdf:Competitor-RATING ;
ecrm:Status competitors.STATUS
as virtrdf:Competitor-STATUS .
ecrm:OrganizationsData(competitors.ORG_ID, organizations_data.DNS_ZONE)
ecrm:ecrm_organization_of
ecrm:Competitor (competitors.ORG_ID, competitors.COMPETITOR_ID)
where (^{competitors.}^.ORG_ID = ^{organizations_data.}^.ORG_ID) as virtrdf:Competitor-is_ecrm_org_of .
ecrm:Company (companies.COMPANY_NAME, competitors.COMPANY_ID, competitors.ORG_ID)
ecrm:is_company_of
ecrm:Competitor (competitors.ORG_ID, competitors.COMPETITOR_ID)
where (^{competitors.}^.COMPANY_ID = ^{companies.}^.COMPANY_ID and ^{competitors.}^.ORG_ID = ^{companies.}^.ORG_ID)
as virtrdf:Competitor-is_company_of .
ecrm:Issue (issues.ORG_ID, issues.ISSUE_ID)
a ecrm:Issue
as virtrdf:Issue-Issues ;
ecrm:has_ecrm_organization ecrm:OrganizationsData(issues.ORG_ID, organizations_data.DNS_ZONE) where (^{issues.}^.ORG_ID = ^{organizations_data.}^.ORG_ID)
as virtrdf:Issue-ORG_ID ;
ecrm:owner ecrm:XSys_User(issues.ORG_ID, xsys_users.ACCOUNT_NAME, issues.OWNER_ID)
where (^{issues.}^.OWNER_ID = ^{xsys_users.}^.ACCOUNT_ID and ^{issues.}^.ORG_ID = ^{xsys_users.}^.ORG_ID)
as virtrdf:Issue-OWNER_ID ;
ecrm:has_opportunity ecrm:Opportunity(issues.ORG_ID, issues.OPPORTUNITY_ID)
as virtrdf:Issue-OPPORTUNITY_ID ;
#ecrm:REL_ID issues.REL_ID
# as virtrdf:Issue-REL_ID ;
ecrm:subject issues.SUBJECT
as virtrdf:Issue-SUBJECT ;
ecrm:reference issues.REFERENCE
as virtrdf:Issue-REFERENCE ;
ecrm:priority issues.PRIORITY
as virtrdf:Issue-PRIORITY ;
ecrm:issueDate issues.ISSUE_DATE
as virtrdf:Issue-ISSUE_DATE ;
ecrm:status issues.STATUS
as virtrdf:Issue-STATUS ;
ecrm:userName issues.USER_NAME
as virtrdf:Issue-USER_NAME ;
ecrm:docTitle issues.DOC_TITLE
as virtrdf:Issue-DOC_TITLE .
ecrm:OrganizationsData(issues.ORG_ID, organizations_data.DNS_ZONE)
ecrm:ecrm_organization_of
ecrm:Issue (issues.ORG_ID, issues.ISSUE_ID)
where (^{issues.}^.ORG_ID = ^{organizations_data.}^.ORG_ID) as virtrdf:Issue-is_ecrm_org_of .
} .
} .
;
SPARQL
prefix ecrm: <http://demo.openlinksw.com/schemas/ecrm#>
prefix oplsioc: <http://www.openlinksw.com/schemas/oplsioc#>
prefix sioc: <http://rdfs.org/sioc/ns#>
prefix foaf: <http://xmlns.com/foaf/0.1/>
prefix geo: <http://www.w3.org/2003/01/geo/wgs84_pos#>
prefix cal: <http://www.w3.org/2002/12/cal/ical#>
prefix product: <http://www.swop-project.eu/ontologies/pmo/product.owl#>
prefix owl: <http://www.w3.org/2002/07/owl#>
alter quad storage virtrdf:DefaultQuadStorage
from eCRM.DBA.SFA_SALES_QUOTA_VIEW2 as sales_quotas
from eCRM.DBA.SFA_COMPANIES_VIEW2 as companies
from eCRM.DBA.SFA_COMPANIES as companies_table text literal companies_table.DESCRIPTION of (companies.DESCRIPTION)
from eCRM.DBA.SFA_CONTACTS_VIEW2 as contacts
from eCRM.DBA.SFA_CONTACTS as contacts_table text literal contacts_table.NAME_FIRST of (contacts.NAME_FIRST)
from eCRM.DBA.SFA_EMPLOYMENTS_VIEW2 as employments
from eCRM.DBA.SFA_LEADS_VIEW2 as leads
from eCRM.DBA.SFA_LEADS as leads_table text literal leads_table.SUBJECT of (leads.SUBJECT)
from eCRM.DBA.SFA_OPPORTUNITIES_VIEW2 as opportunities
from eCRM.DBA.SFA_OPPORTUNITIES as opportunities_table text literal opportunities_table.OPPORTUNITY_NAME of (opportunities.OPPORTUNITY_NAME)
from eCRM.DBA.SFA_ACTIVITIES as activities
from eCRM.DBA.SFA_MAIL_MESSAGES as messages
from eCRM.DBA.SFA_DOCUMENTS_VIEW2 as documents
from eCRM.DBA.SFA_INFLUENCERS_VIEW2 as influencers
from eCRM.DBA.SFA_TEAMS_VIEW2 as teams
from eCRM.DBA.SFA_NOTES_VIEW2 as notes
from eCRM.DBA.SFA_NOTES as notes_table text literal notes_table.DESCRIPTION of (notes.DESCRIPTION)
from eCRM.DBA.SFA_COMPETITORS_VIEW2 as competitors
from eCRM.DBA.SFA_ISSUES_VIEW2 as issues
from eCRM.DBA.SFA_CUSTOM_FIELD_DEFS_VIEW2 as custom_field_defs
from eCRM.DBA.SFA_CUSTOM_FIELDS_VIEW2 as custom_fields
from eCRM.DBA.SFA_CASES_VIEW2 as cases
from eCRM.DBA.SFA_CASES as cases_table text literal cases_table.SUMMARY of (cases.SUMMARY)
from eCRM.DBA.SFA_ORDERS_VIEW2 as orders
from eCRM.DBA.SFA_ORDERS as orders_table text literal orders_table.EMAIL of (orders.EMAIL)
from eCRM.DBA.SFA_ORDER_ITEMS_VIEW2 as order_items
from eCRM.DBA.PM_CATEGORIES_VIEW2 as categories
from eCRM.DBA.PM_PRODUCT_ATTRIBUTE_DEFS_VIEW2 as product_attribute_defs
from eCRM.DBA.PM_PRODUCTS_VIEW2 as products
from eCRM.DBA.PM_PRODUCTS as products_table text literal products_table.DESCRIPTION of (products.DESCRIPTION)
from eCRM.DBA.PM_PRODUCT_ATTRIBUTES_VIEW2 as product_attributes
from eCRM.DBA.PM_CATALOGS_VIEW2 as catalogs
from eCRM.DBA.PM_CATALOG_PRODUCTS_VIEW2 as catalog_products
from eCRM.DBA.XSYS_MODULES as modules
from eCRM.DBA.XSYS_REGISTRY as registries
from eCRM.DBA.XSYS_ORGANIZATIONS_DATA as organizations_data
from eCRM.DBA.XSYS_MESSAGES as xsysmessages
from eCRM.DBA.XSYS_COUNTRIES_VIEW2 as countries
from eCRM.DBA.XSYS_PROVINCES_VIEW2 as provinces
from eCRM.DBA.XSYS_TIMEZONES as timezones
from eCRM.DBA.XSYS_MIME_TYPES as mimetypes
from eCRM.DBA.XSYS_MIME_EXTENSIONS as mimeexts
from eCRM.DBA.XSYS_CNAMES as cnames
from eCRM.DBA.XSYS_QUOTAS as quotas
from eCRM.DBA.XSYS_ROLES as roles
from eCRM.DBA.XSYS_ACCOUNTS as accounts
from eCRM.DBA.XSYS_USERDATA as userdatas
from eCRM.DBA.XSYS_GROUPDATA as groupdatas
from eCRM.DBA.XSYS_MEMBERS as members
from eCRM.DBA.XSYS_SESSIONS_DATA as sessionsdatas
from eCRM.DBA.XSYS_SESSION_DATA as sessiondatas
from eCRM.DBA.XSYS_LIST_MEMBERS_DEFS as list_members_defs
from eCRM.DBA.XSYS_CLASSES as classes
from eCRM.DBA.XSYS_ORG_CLASSES as org_classes
from eCRM.DBA.XSYS_CLASS_METHODS as class_methods
from eCRM.DBA.XSYS_CLASS_VIEWS as class_views
from eCRM.DBA.XSYS_ROLE_PRIVILEGES as role_priveleges
from eCRM.DBA.XSYS_USER_PRIVILEGES as user_priveleges
from eCRM.DBA.XSYS_HISTORY as history
from eCRM.DBA.XSYS_USERS as xsys_users
where (^{companies.}^.COUNTRY_NAME = ^{countries.}^.COUNTRY_NAME)
where (^{contacts.}^.COUNTRY_NAME = ^{countries.}^.COUNTRY_NAME)
where (^{leads.}^.COUNTRY_NAME = ^{countries.}^.COUNTRY_NAME)
where (^{products.}^.COUNTRY_NAME = ^{countries.}^.COUNTRY_NAME)
where (^{orders.}^.SHIP_COUNTRY_NAME = ^{countries.}^.COUNTRY_NAME)
where (^{leads_table.}^.FREETEXT_ID = ^{leads.}^.FREETEXT_ID)
where (^{contacts_table.}^.FREETEXT_ID = ^{contacts.}^.FREETEXT_ID)
where (^{companies_table.}^.FREETEXT_ID = ^{companies.}^.FREETEXT_ID)
where (^{opportunities_table.}^.FREETEXT_ID = ^{opportunities.}^.FREETEXT_ID)
where (^{cases_table.}^.FREETEXT_ID = ^{cases.}^.FREETEXT_ID)
where (^{notes_table.}^.FREETEXT_ID = ^{notes.}^.FREETEXT_ID)
where (^{orders_table.}^.FREETEXT_ID = ^{orders.}^.FREETEXT_ID)
where (^{products_table.}^.FREETEXT_ID = ^{products.}^.FREETEXT_ID)
{
create virtrdf:ecrmDemo2 as graph iri ("http://^{URIQADefaultHost}^/ecrm") option (exclusive, order 1502)
{
ecrm:Order (orders.ORG_ID, orders.ORDER_ID)
a ecrm:Order
as virtrdf:Order-Orders ;
ecrm:has_ecrm_organization ecrm:OrganizationsData(orders.ORG_ID, organizations_data.DNS_ZONE) where (^{orders.}^.ORG_ID = ^{organizations_data.}^.ORG_ID)
as virtrdf:Order-ORG_ID ;
ecrm:owner ecrm:XSys_User(orders.ORG_ID, xsys_users.ACCOUNT_NAME, orders.OWNER_ID)
where (^{orders.}^.OWNER_ID = ^{xsys_users.}^.ACCOUNT_ID and ^{orders.}^.ORG_ID = ^{xsys_users.}^.ORG_ID)
as virtrdf:Order-OWNER_ID ;
ecrm:FREETEXT_ID orders.FREETEXT_ID
as virtrdf:Order-FREETEXT_ID ;
ecrm:has_company ecrm:Company(orders.COMPANY_NAME, orders.COMPANY_ID, orders.ORG_ID)
as virtrdf:Order-COMPANY_ID ;
ecrm:companyName orders.COMPANY_NAME
as virtrdf:Order-COMPANY_NAME ;
ecrm:has_contact ecrm:Contact(contacts.NAME_FIRST, contacts.NAME_MIDDLE, contacts.NAME_LAST, orders.CONTACT_ID, orders.ORG_ID)
where (^{orders.}^.CONTACT_ID = ^{contacts.}^.CONTACT_ID and ^{orders.}^.ORG_ID = ^{contacts.}^.ORG_ID)
as virtrdf:Order-CONTACT_ID ;
ecrm:contactName orders.CONTACT_NAME
as virtrdf:Order-CONTACT_NAME ;
ecrm:orderNo orders.ORDER_NO
as virtrdf:Order-ORDER_NO ;
ecrm:shipFirstName orders.SHIP_FNAME
as virtrdf:Order-SHIP_FNAME ;
ecrm:shipSecondName orders.SHIP_SNAME
as virtrdf:Order-SHIP_SNAME ;
ecrm:phoneNumber orders.PHONE_NUMBER
as virtrdf:Order-PHONE_NUMBER ;
ecrm:phoneExtension orders.PHONE_EXTENSION
as virtrdf:Order-PHONE_EXTENSION ;
ecrm:email orders.EMAIL
as virtrdf:Order-EMAIL ;
ecrm:shipCountry ecrm:Country(orders.SHIP_COUNTRY_NAME)
as virtrdf:Order-SHIP_COUNTRY_NAME ;
#ecrm:shipCountryCode ecrm:Country (countries.COUNTRY_NAME) where (^{countries.}^.COUNTRY_NAME = ^{orders.}^.SHIP_COUNTRY_NAME)
# as virtrdf:Order-SHIP_COUNTRY_CODE ;
ecrm:shipProvince orders.SHIP_PROVINCE
as virtrdf:Order-SHIP_PROVINCE ;
ecrm:shipCity orders.SHIP_CITY
as virtrdf:Order-SHIP_CITY ;
ecrm:dbpedia_shipCity ecrm:dbpedia_iri (orders.SHIP_CITY)
as virtrdf:Order-SHIP_dbpedia_CITY ;
ecrm:shipPostalCode orders.SHIP_POSTAL_CODE
as virtrdf:Order-SHIP_POSTAL_CODE ;
ecrm:shipAddress1 orders.SHIP_ADDRESS1
as virtrdf:Order-SHIP_ADDRESS1 ;
ecrm:shipAddress2 orders.SHIP_ADDRESS2
as virtrdf:Order-SHIP_ADDRESS2 ;
ecrm:salesRep orders.SALESREP
as virtrdf:Order-SALESREP ;
ecrm:orderDate orders.ORDER_DATE
as virtrdf:Order-ORDER_DATE ;
ecrm:orderValue orders.ORDER_VALUE
as virtrdf:Order-ORDER_VALUE ;
ecrm:refund orders.REFUND
as virtrdf:Order-REFUND ;
ecrm:year orders.YEAR
as virtrdf:Order-YEAR ;
ecrm:month orders.MONTH
as virtrdf:Order-MONTH ;
ecrm:quarter orders.QUARTER
as virtrdf:Order-QUARTER ;
ecrm:financialYear orders.FINANCIAL_YEAR
as virtrdf:Order-FINANCIAL_YEAR .
#ecrm:CONTACT_REL_ID orders.CONTACT_REL_ID
# as virtrdf:Order-CONTACT_REL_ID ;
#ecrm:COMPANY_REL_ID orders.COMPANY_REL_ID
# as virtrdf:Order-COMPANY_REL_ID .
ecrm:OrganizationsData(orders.ORG_ID, organizations_data.DNS_ZONE)
ecrm:ecrm_organization_of
ecrm:Order (orders.ORG_ID, orders.ORDER_ID)
where (^{orders.}^.ORG_ID = ^{organizations_data.}^.ORG_ID) as virtrdf:Order-is_ecrm_org_of .
ecrm:Contact(contacts.NAME_FIRST, contacts.NAME_MIDDLE, contacts.NAME_LAST, orders.CONTACT_ID, orders.ORG_ID)
ecrm:is_contact_of
ecrm:Order (orders.ORG_ID, orders.ORDER_ID)
where (^{orders.}^.CONTACT_ID = ^{contacts.}^.CONTACT_ID and ^{orders.}^.ORG_ID = ^{contacts.}^.ORG_ID)
as virtrdf:Order-is_contact_of .
ecrm:Company(orders.COMPANY_NAME, orders.COMPANY_ID, orders.ORG_ID)
ecrm:is_company_of
ecrm:Order (orders.ORG_ID, orders.ORDER_ID)
as virtrdf:Order-is_company_of .
ecrm:Country (orders.SHIP_COUNTRY_NAME)
ecrm:is_country_of
ecrm:Order(orders.ORG_ID, orders.ORDER_ID) as virtrdf:Order-is_country_of .
ecrm:OrderItem (order_items.ORG_ID, order_items.ORDER_ITEM_ID)
a ecrm:OrderItem
as virtrdf:OrderItem-OrderItems ;
ecrm:has_ecrm_organization ecrm:OrganizationsData(order_items.ORG_ID, organizations_data.DNS_ZONE) where (^{order_items.}^.ORG_ID = ^{organizations_data.}^.ORG_ID)
as virtrdf:OrderItem-ORG_ID ;
ecrm:owner ecrm:XSys_User(order_items.ORG_ID, xsys_users.ACCOUNT_NAME, order_items.OWNER_ID)
where (^{order_items.}^.OWNER_ID = ^{xsys_users.}^.ACCOUNT_ID and ^{order_items.}^.ORG_ID = ^{xsys_users.}^.ORG_ID)
as virtrdf:OrderItem-OWNER_ID ;
ecrm:has_order ecrm:Order(order_items.ORG_ID, order_items.ORDER_ID)
as virtrdf:OrderItem-ORDER_ID ;
ecrm:has_product ecrm:Product(order_items.ORG_ID, order_items.PRODUCT_ID)
as virtrdf:OrderItem-PRODUCT_ID ;
ecrm:productName order_items.PRODUCT_NAME
as virtrdf:OrderItem-PRODUCT_NAME ;
ecrm:client order_items.CLIENT
as virtrdf:OrderItem-CLIENT ;
ecrm:server order_items.SERVER
as virtrdf:OrderItem-SERVER ;
ecrm:dbms order_items.DBMS
as virtrdf:OrderItem-DBMS ;
ecrm:discount order_items.DISCOUNT
as virtrdf:OrderItem-DISCOUNT ;
ecrm:unitPrice order_items.UNIT_PRICE
as virtrdf:OrderItem-UNIT_PRICE ;
ecrm:qty order_items.QTY
as virtrdf:OrderItem-QTY .
ecrm:OrganizationsData(order_items.ORG_ID, organizations_data.DNS_ZONE)
ecrm:ecrm_organization_of
ecrm:OrderItem (order_items.ORG_ID, order_items.ORDER_ITEM_ID)
where (^{order_items.}^.ORG_ID = ^{organizations_data.}^.ORG_ID) as virtrdf:OrderItem-is_ecrm_org_of .
ecrm:Category (categories.ORG_ID, categories.CATEGORY_ID)
a ecrm:Category
as virtrdf:Category-Categorys ;
ecrm:has_ecrm_organization ecrm:OrganizationsData(categories.ORG_ID, organizations_data.DNS_ZONE) where (^{categories.}^.ORG_ID = ^{organizations_data.}^.ORG_ID)
as virtrdf:Category-ORG_ID ;
ecrm:owner ecrm:XSys_User(categories.ORG_ID, xsys_users.ACCOUNT_NAME, categories.OWNER_ID)
where (^{categories.}^.OWNER_ID = ^{xsys_users.}^.ACCOUNT_ID and ^{categories.}^.ORG_ID = ^{xsys_users.}^.ORG_ID)
as virtrdf:Category-OWNER_ID ;
ecrm:FREETEXT_ID categories.FREETEXT_ID
as virtrdf:Category-FREETEXT_ID ;
ecrm:categoryName categories.CATEGORY_NAME
as virtrdf:Category-CATEGORY_NAME ;
ecrm:description categories.DESCRIPTION
as virtrdf:Category-DESCRIPTION .
ecrm:OrganizationsData(categories.ORG_ID, organizations_data.DNS_ZONE)
ecrm:ecrm_organization_of
ecrm:Category (categories.ORG_ID, categories.CATEGORY_ID)
where (^{categories.}^.ORG_ID = ^{organizations_data.}^.ORG_ID) as virtrdf:Category-is_ecrm_org_of .
ecrm:OrganizationsData (organizations_data.ORG_ID, organizations_data.DNS_ZONE)
a ecrm:OrganizationsData
as virtrdf:OrganizationsData-OrganizationsDatas2 ;
a foaf:Organization
as virtrdf:OrganizationsData-OrganizationsDatas ;
ecrm:dnsZone organizations_data.DNS_ZONE
as virtrdf:OrganizationsData-DNS_ZONE ;
ecrm:status organizations_data.STATUS
as virtrdf:OrganizationsData-STATUS ;
ecrm:data organizations_data.DATA
as virtrdf:OrganizationsData-DATA ;
ecrm:spaceTotal organizations_data.SPACE_TOTAL
as virtrdf:OrganizationsData-SPACE_TOTAL ;
ecrm:spaceUsed organizations_data.SPACE_USED
as virtrdf:OrganizationsData-SPACE_USED ;
ecrm:userLicenses organizations_data.USER_LICENSES
as virtrdf:OrganizationsData-USER_LICENSES .
ecrm:ProductAttributeDef (product_attribute_defs.ORG_ID, product_attribute_defs.ATTRIBUTE_ID)
a ecrm:ProductAttributeDef
as virtrdf:ProductAttributeDef-ProductAttributeDefs ;
ecrm:has_ecrm_organization ecrm:OrganizationsData(product_attribute_defs.ORG_ID, organizations_data.DNS_ZONE) where (^{product_attribute_defs.}^.ORG_ID = ^{organizations_data.}^.ORG_ID)
as virtrdf:ProductAttributeDef-ORG_ID ;
ecrm:has_category ecrm:Category(product_attribute_defs.ORG_ID, product_attribute_defs.CATEGORY_ID)
as virtrdf:ProductAttributeDef-CATEGORY_ID ;
ecrm:attributeName product_attribute_defs.ATTRIBUTE_NAME
as virtrdf:ProductAttributeDef-ATTRIBUTE_NAME ;
ecrm:attributeType product_attribute_defs.ATTRIBUTE_TYPE
as virtrdf:ProductAttributeDef-ATTRIBUTE_TYPE .
ecrm:OrganizationsData(product_attribute_defs.ORG_ID, organizations_data.DNS_ZONE)
ecrm:ecrm_organization_of
ecrm:ProductAttributeDef (product_attribute_defs.ORG_ID, product_attribute_defs.ATTRIBUTE_ID)
where (^{product_attribute_defs.}^.ORG_ID = ^{organizations_data.}^.ORG_ID) as virtrdf:ProductAttributeDef-is_ecrm_org_of .
ecrm:Product (products.ORG_ID, products.PRODUCT_ID)
a product:Product
as virtrdf:Product-Products ;
ecrm:has_ecrm_organization ecrm:OrganizationsData(products.ORG_ID, organizations_data.DNS_ZONE) where (^{products.}^.ORG_ID = ^{organizations_data.}^.ORG_ID)
as virtrdf:Product-ORG_ID ;
ecrm:owner ecrm:XSys_User(products.ORG_ID, xsys_users.ACCOUNT_NAME, products.OWNER_ID)
where (^{products.}^.OWNER_ID = ^{xsys_users.}^.ACCOUNT_ID and ^{products.}^.ORG_ID = ^{xsys_users.}^.ORG_ID)
as virtrdf:Product-OWNER_ID ;
ecrm:FREETEXT_ID products.FREETEXT_ID
as virtrdf:Product-FREETEXT_ID ;
ecrm:productName products.PRODUCT_NAME
as virtrdf:Product-PRODUCT_NAME ;
ecrm:has_category ecrm:Category(products.ORG_ID, products.CATEGORY_ID)
as virtrdf:Product-CATEGORY_ID ;
ecrm:unitOfMeasure products.UNIT_OF_MEASURE
as virtrdf:Product-UNIT_OF_MEASURE ;
#ecrm:units products.UNITS
# as virtrdf:Product-UNITS ;
product:unit products.UNITS
as virtrdf:Product-productUNITS ;
ecrm:manufacturer products.MANUFACTURER
as virtrdf:Product-MANUFACTURER ;
ecrm:validFrom products.VALID_FROM
as virtrdf:Product-VALID_FROM ;
ecrm:validUntil products.VALID_UNTIL
as virtrdf:Product-VALID_UNTIL ;
ecrm:country ecrm:Country(products.COUNTRY_NAME)
as virtrdf:Product-COUNTRY_NAME ;
#ecrm:countryCode ecrm:Country (countries.COUNTRY_ID) where (^{countries.}^.COUNTRY_NAME = ^{products.}^.COUNTRY_NAME)
# as virtrdf:Product-COUNTRY_CODE ;
ecrm:minorder products.MINORDER
as virtrdf:Product-MINORDER ;
ecrm:maxorder products.MAXORDER
as virtrdf:Product-MAXORDER ;
ecrm:productVendor products.PRODUCT_VENDOR
as virtrdf:Product-PRODUCT_VENDOR ;
ecrm:description products.DESCRIPTION
as virtrdf:Product-DESCRIPTION .
ecrm:OrganizationsData(products.ORG_ID, organizations_data.DNS_ZONE)
ecrm:ecrm_organization_of
ecrm:Product (products.ORG_ID, products.PRODUCT_ID)
where (^{products.}^.ORG_ID = ^{organizations_data.}^.ORG_ID) as virtrdf:Product-is_ecrm_org_of .
ecrm:Country (products.COUNTRY_NAME)
ecrm:is_country_of
ecrm:Product(products.ORG_ID, products.PRODUCT_ID) as virtrdf:Product-is_country_of .
ecrm:ProductAttribute (product_attributes.ORG_ID, product_attributes.PRODUCT_ID, product_attributes.ATTRIBUTE_ID)
a ecrm:ProductAttribute
as virtrdf:ProductAttribute-ProductAttributes ;
ecrm:has_ecrm_organization ecrm:OrganizationsData(product_attributes.ORG_ID, organizations_data.DNS_ZONE) where (^{product_attributes.}^.ORG_ID = ^{organizations_data.}^.ORG_ID)
as virtrdf:ProductAttribute-ORG_ID ;
ecrm:has_product ecrm:Product(product_attributes.ORG_ID, product_attributes.PRODUCT_ID)
as virtrdf:ProductAttribute-PRODUCT_ID ;
ecrm:has_attribute ecrm:ProductAttributeDef(product_attributes.ORG_ID, product_attributes.ATTRIBUTE_ID)
as virtrdf:ProductAttribute-ATTRIBUTE_ID ;
ecrm:attributeValue product_attributes.ATTRIBUTE_VALUE
as virtrdf:ProductAttribute-ATTRIBUTE_VALUE .
ecrm:OrganizationsData(product_attributes.ORG_ID, organizations_data.DNS_ZONE)
ecrm:ecrm_organization_of
ecrm:ProductAttribute (product_attributes.ORG_ID, product_attributes.PRODUCT_ID, product_attributes.ATTRIBUTE_ID)
where (^{product_attributes.}^.ORG_ID = ^{organizations_data.}^.ORG_ID) as virtrdf:ProductAttribute-is_ecrm_org_of .
ecrm:Catalog (catalogs.ORG_ID, catalogs.CATALOG_ID)
a ecrm:Catalog
as virtrdf:Catalog-Catalogs ;
ecrm:has_ecrm_organization ecrm:OrganizationsData(catalogs.ORG_ID, organizations_data.DNS_ZONE) where (^{catalogs.}^.ORG_ID = ^{organizations_data.}^.ORG_ID)
as virtrdf:Catalog-ORG_ID ;
ecrm:owner ecrm:XSys_User(catalogs.ORG_ID, xsys_users.ACCOUNT_NAME, catalogs.OWNER_ID)
where (^{catalogs.}^.OWNER_ID = ^{xsys_users.}^.ACCOUNT_ID and ^{catalogs.}^.ORG_ID = ^{xsys_users.}^.ORG_ID)
as virtrdf:Catalog-OWNER_ID ;
ecrm:FREETEXT_ID catalogs.FREETEXT_ID
as virtrdf:Catalog-FREETEXT_ID ;
ecrm:catalogName catalogs.CATALOG_NAME
as virtrdf:Catalog-CATALOG_NAME ;
ecrm:catalogProvider catalogs.CATALOG_PROVIDER
as virtrdf:Catalog-CATALOG_PROVIDER ;
ecrm:catalogAudience catalogs.CATALOG_AUDIENCE
as virtrdf:Catalog-CATALOG_AUDIENCE ;
ecrm:validFrom catalogs.VALID_FROM
as virtrdf:Catalog-VALID_FROM ;
ecrm:validUntil catalogs.VALID_UNTIL
as virtrdf:Catalog-VALID_UNTIL ;
ecrm:description catalogs.DESCRIPTION
as virtrdf:Catalog-DESCRIPTION .
ecrm:OrganizationsData(catalogs.ORG_ID, organizations_data.DNS_ZONE)
ecrm:ecrm_organization_of
ecrm:Catalog (catalogs.ORG_ID, catalogs.CATALOG_ID)
where (^{catalogs.}^.ORG_ID = ^{organizations_data.}^.ORG_ID) as virtrdf:Catalog-is_ecrm_org_of .
ecrm:CatalogProduct (catalog_products.ORG_ID, catalog_products.CATALOG_ID, catalog_products.PRODUCT_ID)
a ecrm:CatalogProduct
as virtrdf:CatalogProduct-CatalogProducts ;
ecrm:has_ecrm_organization ecrm:OrganizationsData(catalog_products.ORG_ID, organizations_data.DNS_ZONE) where (^{catalog_products.}^.ORG_ID = ^{organizations_data.}^.ORG_ID)
as virtrdf:CatalogProduct-ORG_ID ;
ecrm:owner ecrm:XSys_User(catalog_products.ORG_ID, xsys_users.ACCOUNT_NAME, catalog_products.OWNER_ID)
where (^{catalog_products.}^.OWNER_ID = ^{xsys_users.}^.ACCOUNT_ID and ^{catalog_products.}^.ORG_ID = ^{xsys_users.}^.ORG_ID)
as virtrdf:CatalogProduct-OWNER_ID ;
ecrm:has_catalog ecrm:Catalog(catalog_products.ORG_ID, catalog_products.CATALOG_ID)
as virtrdf:CatalogProduct-CATALOG_ID ;
ecrm:has_product ecrm:Product(catalog_products.ORG_ID, catalog_products.PRODUCT_ID)
as virtrdf:CatalogProduct-PRODUCT_ID ;
#ecrm:REL_ID catalog_products.REL_ID
# as virtrdf:CatalogProduct-REL_ID ;
ecrm:price catalog_products.PRICE
as virtrdf:CatalogProduct-PRICE ;
ecrm:currency catalog_products.CURRENCY
as virtrdf:CatalogProduct-CURRENCY ;
ecrm:description catalog_products.DESCRIPTION
as virtrdf:CatalogProduct-DESCRIPTION .
ecrm:OrganizationsData(catalog_products.ORG_ID, organizations_data.DNS_ZONE)
ecrm:ecrm_organization_of
ecrm:CatalogProduct (catalog_products.ORG_ID, catalog_products.CATALOG_ID, catalog_products.PRODUCT_ID)
where (^{catalog_products.}^.ORG_ID = ^{organizations_data.}^.ORG_ID) as virtrdf:CatalogProduct-is_ecrm_org_of .
ecrm:Module (modules.MODULE_ID)
a ecrm:Module
as virtrdf:Module-Modules ;
ecrm:prefix modules.PREFIX
as virtrdf:Module-PREFIX ;
ecrm:moduleName modules.MODULE_NAME
as virtrdf:Module-MODULE_NAME ;
ecrm:description modules.DESCRIPTION
as virtrdf:Module-DESCRIPTION ;
ecrm:version modules.VERSION
as virtrdf:Module-VERSION ;
ecrm:buildDate modules.BUILD_DATE
as virtrdf:Module-BUILD_DATE ;
ecrm:installDate modules.INSTALL_DATE
as virtrdf:Module-INSTALL_DATE .
ecrm:Registry (registries.KEY_NAME)
a ecrm:Registry
as virtrdf:Registry-Registrys ;
ecrm:keyName registries.KEY_NAME
as virtrdf:Registry-KEY_NAME ;
ecrm:hasModule ecrm:Module(registries.MODULE_ID)
as virtrdf:Registry-MODULE_ID ;
ecrm:keyData registries.KEY_DATA
as virtrdf:Registry-KEY_DATA .
ecrm:Message (xsysmessages.MODULE_ID, xsysmessages.MSG_ID)
a ecrm:Message
as virtrdf:Message-Messages ;
ecrm:hasModule ecrm:Module(xsysmessages.MODULE_ID)
as virtrdf:Message-MODULE_ID ;
ecrm:messageText xsysmessages.MSG_TEXT
as virtrdf:Message-MSG_TEXT .
ecrm:Timezone (timezones.TZ_ID)
a ecrm:Timezone
as virtrdf:Timezone-Timezones ;
ecrm:timezoneName timezones.TZ_NAME
as virtrdf:Timezone-TZ_NAME ;
ecrm:timezoneOffset timezones.TZ_OFFSET
as virtrdf:Timezone-TZ_OFFSET .
ecrm:MimeType (mimetypes.ID)
a ecrm:MimeType
as virtrdf:MimeType-MimeTypes ;
ecrm:mimeType mimetypes.MIME_TYPE
as virtrdf:MimeType-MIME_TYPE ;
ecrm:description mimetypes.DESCRIPTION
as virtrdf:MimeType-DESCRIPTION .
ecrm:MimeExtension (mimeexts.MIME_TYPE_ID, mimeexts.EXTENSION)
a ecrm:MimeExtension
as virtrdf:MimeExtension-MimeExtensions ;
ecrm:hasMimeType ecrm:MimeType (mimeexts.MIME_TYPE_ID)
as virtrdf:MimeExtension-MIME_TYPE_ID ;
ecrm:extension mimeexts.EXTENSION
as virtrdf:MimeExtension-EXTENSION .
ecrm:Cname (cnames.DNS_CNAME)
a ecrm:Cname
as virtrdf:Cname-Cnames ;
ecrm:dnsCname cnames.DNS_CNAME
as virtrdf:Cname-DNS_CNAME ;
ecrm:has_ecrm_organization ecrm:OrganizationsData(cnames.ORG_ID, organizations_data.DNS_ZONE) where (^{cnames.}^.ORG_ID = ^{organizations_data.}^.ORG_ID)
as virtrdf:Cname-ORG_ID ;
ecrm:interface cnames.INTERFACE
as virtrdf:Cname-INTERFACE .
ecrm:OrganizationsData(cnames.ORG_ID, organizations_data.DNS_ZONE)
ecrm:ecrm_organization_of
ecrm:Cname (cnames.DNS_CNAME)
where (^{cnames.}^.ORG_ID = ^{organizations_data.}^.ORG_ID) as virtrdf:Cname-is_ecrm_org_of .
ecrm:Quota (quotas.ORG_ID, quotas.QUOTA_ID)
a ecrm:Quota
as virtrdf:Quota-Quotas ;
ecrm:quotaName quotas.QUOTA_NAME
as virtrdf:Quota-QUOTA_NAME ;
ecrm:has_ecrm_organization ecrm:OrganizationsData(quotas.ORG_ID, organizations_data.DNS_ZONE) where (^{quotas.}^.ORG_ID = ^{organizations_data.}^.ORG_ID)
as virtrdf:Quota-ORG_ID ;
ecrm:spaceTotal quotas.SPACE_TOTAL
as virtrdf:Quota-SPACE_TOTAL .
ecrm:OrganizationsData(quotas.ORG_ID, organizations_data.DNS_ZONE)
ecrm:ecrm_organization_of
ecrm:Quota (quotas.ORG_ID, quotas.QUOTA_ID)
where (^{quotas.}^.ORG_ID = ^{organizations_data.}^.ORG_ID) as virtrdf:Quota-is_ecrm_org_of .
ecrm:Role (roles.ORG_ID, roles.ROLE_ID)
a ecrm:Role
as virtrdf:Role-Roles ;
ecrm:roleName roles.ROLE_NAME
as virtrdf:Role-ROLE_NAME ;
ecrm:has_ecrm_organization ecrm:OrganizationsData(roles.ORG_ID, organizations_data.DNS_ZONE) where (^{roles.}^.ORG_ID = ^{organizations_data.}^.ORG_ID)
as virtrdf:Role-ORG_ID ;
ecrm:parentID roles.PARENT_ID
as virtrdf:Role-PARENT_ID .
ecrm:OrganizationsData(roles.ORG_ID, organizations_data.DNS_ZONE)
ecrm:ecrm_organization_of
ecrm:Role (roles.ORG_ID, roles.ROLE_ID)
where (^{roles.}^.ORG_ID = ^{organizations_data.}^.ORG_ID) as virtrdf:Role-is_ecrm_org_of .
ecrm:Account (accounts.ORG_ID, accounts.ACCOUNT_ID)
a ecrm:Account
as virtrdf:Account-Accounts ;
ecrm:has_ecrm_organization ecrm:OrganizationsData(accounts.ORG_ID, organizations_data.DNS_ZONE) where (^{accounts.}^.ORG_ID = ^{organizations_data.}^.ORG_ID)
as virtrdf:Account-ORG_ID ;
ecrm:accountType accounts.ACCOUNT_TYPE
as virtrdf:Account-ACCOUNT_TYPE ;
ecrm:accountName accounts.ACCOUNT_NAME
as virtrdf:Account-ACCOUNT_NAME ;
ecrm:data accounts.DATA
as virtrdf:Account-DATA .
ecrm:OrganizationsData(accounts.ORG_ID, organizations_data.DNS_ZONE)
ecrm:ecrm_organization_of
ecrm:Account (accounts.ORG_ID, accounts.ACCOUNT_ID)
where (^{accounts.}^.ORG_ID = ^{organizations_data.}^.ORG_ID) as virtrdf:Account-is_ecrm_org_of .
ecrm:UserData (userdatas.ORG_ID, userdatas.ACCOUNT_ID)
a ecrm:UserData
as virtrdf:UserData-UserDatas ;
ecrm:has_ecrm_organization ecrm:OrganizationsData(userdatas.ORG_ID, organizations_data.DNS_ZONE) where (^{userdatas.}^.ORG_ID = ^{organizations_data.}^.ORG_ID)
as virtrdf:UserData-ORG_ID ;
ecrm:has_account ecrm:Account(userdatas.ORG_ID, userdatas.ACCOUNT_ID)
as virtrdf:UserData-ACCOUNT_ID ;
ecrm:status userdatas.STATUS
as virtrdf:UserData-STATUS ;
ecrm:loginPassword userdatas.LOGIN_PWD
as virtrdf:UserData-LOGIN_PWD ;
ecrm:has_role ecrm:Role(userdatas.ORG_ID, userdatas.ROLE_ID)
as virtrdf:UserData-ROLE_ID ;
ecrm:has_quota ecrm:Quota(userdatas.ORG_ID, userdatas.QUOTA_ID)
as virtrdf:UserData-QUOTA_ID ;
ecrm:spaceUsed userdatas.SPACE_USED
as virtrdf:UserData-SPACE_USED ;
ecrm:lastLogin userdatas.LAST_LOGIN
as virtrdf:UserData-LAST_LOGIN ;
ecrm:loginPolicy userdatas.LOGIN_POLICY
as virtrdf:UserData-LOGIN_POLICY ;
ecrm:preferences userdatas.PREFERENCES
as virtrdf:UserData-PREFERENCES .
ecrm:OrganizationsData(userdatas.ORG_ID, organizations_data.DNS_ZONE)
ecrm:ecrm_organization_of
