Microsoft Dynamics AX 2012 R2

AxErd: Parent-Children: Sales and marketing

Module: Sales and marketing

Navigation:     AxErd_Home     Previous_File    


Row-numParent-table-nameForeign-key-columnsModule-of-parent-tableArrow-to-parentChild-table-namePrimary-key-columnsModule-of-child-table
1407smmLeadTypeTable .TypeId (Sales and marketing)     <‑‑‑    smmLeadTable .TypeId (Sales and marketing)
1408smmLoyaltyGroup .LoyaltyId (Sales and marketing)     <‑‑‑    ContactPerson .Loyalty (Sales and marketing)
1409smmMailingCategoryGroup .CategoryId (Sales and marketing)     <‑‑‑    smmMailingGroup .CategoryId (Sales and marketing)
1410smmMailingCategoryGroup .CategoryId (Sales and marketing)     <‑‑‑    smmMailings .CategoryId (Sales and marketing)
1411smmMailingGroup .CategoryId, .CategoryItemId (Sales and marketing)     <‑‑‑    smmMailings .CategoryId, .CategoryItemId (Sales and marketing)
1412smmMailingMergeFile .RecId (Sales and marketing)     <‑‑‑    smmMailingHistory .MailmergeRecId (Sales and marketing)
1413smmMailings .KeyId (Sales and marketing)     <‑‑‑    smmMailingHistory .KeyId (Sales and marketing)
1414smmMailings .KeyId (Sales and marketing)     <‑‑‑    smmMailings .KeyId (Sales and marketing)
1415smmMailings .TableId, .RecId, .KeyId (Sales and marketing)     <‑‑‑    smmTransLog .RefTableId, .RefRecId, .RefNum (Sales and marketing)
1416smmOpportunityRelTable .RefTableId, .RefRecId (Sales and marketing)     <‑‑‑    smmOpportunityTable .TableId, .RecId (Sales and marketing)
1417smmOpportunityTable .RecId, .Pky? (Sales and marketing)     <‑‑‑    CaseAssociation .RefRecId, .Fky? (Sales and marketing)
1418smmOpportunityTable .OpportunityId (Sales and marketing)     <‑‑‑    CollabSiteLink .OpportunityId (Project management and accounting)
1419smmOpportunityTable .TableId, .RecId (Sales and marketing)     <‑‑‑    DirOrgPersonRelations .EntityRefTableId, .EntityRefRecId (Sales and marketing)
1420smmOpportunityTable .dataAreaId, .TableId, .RecId (Sales and marketing)     <‑‑‑    DocuRef .RefCompanyId, .RefTableId, .RefRecId (Client)
1421smmOpportunityTable .TableId, .RecId (Sales and marketing)     <‑‑‑    HierarchyLinkTable .RefTableId, .RefRecId (Project management and accounting)
1422smmOpportunityTable .OpportunityId (Sales and marketing)     <‑‑‑    SalesQuotationTable .OpportunityId (Procurement and sourcing)
1423smmOpportunityTable .Pky?, .RecId (Sales and marketing)     <‑‑‑    smmActivityParentLinkTable .Fky?, .RefRecId (Sales and marketing)
1424smmOpportunityTable .Party (Sales and marketing)     <‑‑‑    smmCampaignSelection .Party (Sales and marketing)
1425smmOpportunityTable .TableId, .RecId (Sales and marketing)     <‑‑‑    smmLeadRelTable .RefTableId, .RefRecId (Sales and marketing)
1426smmOpportunityTable .OpportunityId (Sales and marketing)     <‑‑‑    smmOpportunityRelTable .OpportunityId (Sales and marketing)
1427smmOpportunityTable .TableId, .RecId (Sales and marketing)     <‑‑‑    smmQuotationCompetitors .RefTableId, .RefRecId (Sales and marketing)
1428smmOpportunityTable .TableId, .RecId (Sales and marketing)     <‑‑‑    smmResponsibilitiesEmplTable .RefTableId, .RefRecId (Sales and marketing)
1429smmOpportunityTable .TableId, .RecId (Sales and marketing)     <‑‑‑    smmSwotTable .RefTableId, .RefRecId (Sales and marketing)
1430smmOpportunityTable .Party (Sales and marketing)     <‑‑‑    smmTMCallListTable .Party (Sales and marketing)
1431smmOpportunityTable .TableId, .RecId (Sales and marketing)     <‑‑‑    smmTransLog .RefTableId, .RefRecId (Sales and marketing)
1432smmOpportunityTable .OpportunityId (Sales and marketing)     <‑‑‑    TmpSalesQuotationMassUpdate .OpportunityId (Procurement and sourcing)
1433smmProcessStage .HierarchyId, .ElementNumber (Sales and marketing)     <‑‑‑    HierarchyTreeTable .HierarchyId, .ElementNumber (Project management and accounting)
1434smmQuotationCompetitorGroup .Party (Sales and marketing)     <‑‑‑    ContactPerson .ContactForParty (Sales and marketing)
1435smmQuotationCompetitorGroup .TableId, .RecId (Sales and marketing)     <‑‑‑    DirOrgPersonRelations .EntityRefTableId, .EntityRefRecId (Sales and marketing)
1436smmQuotationCompetitorGroup .dataAreaId, .TableId, .RecId (Sales and marketing)     <‑‑‑    DocuRef .RefCompanyId, .RefTableId, .RefRecId (Client)
1437smmQuotationCompetitorGroup .RecId (Sales and marketing)     <‑‑‑    RetailCompetitorPriceTable .CompetitorGroupId (Retail)
1438smmQuotationCompetitorGroup .Party (Sales and marketing)     <‑‑‑    smmCampaignSelection .Party (Sales and marketing)
1439smmQuotationCompetitorGroup .Party (Sales and marketing)     <‑‑‑    smmQuotationCompetitors .Party (Sales and marketing)
1440smmQuotationCompetitorGroup .TableId, .RecId (Sales and marketing)     <‑‑‑    smmSwotTable .RefTableId, .RefRecId (Sales and marketing)
1441smmQuotationCompetitorGroup .Party (Sales and marketing)     <‑‑‑    smmTMCallListTable .Party (Sales and marketing)
1442smmQuotationCompetitors .TableId, .RecId (Sales and marketing)     <‑‑‑    smmSwotTable .RefTableId, .RefRecId (Sales and marketing)
1443smmQuotationProbabilityGroup .ProbabilityId (Sales and marketing)     <‑‑‑    ReqPlanSched .smmQuotationProbabilityId (Manufacturing)
1444smmQuotationProbabilityGroup .ProbabilityId (Sales and marketing)     <‑‑‑    smmOpportunityTable .ProbabilityId (Sales and marketing)
1445smmQuotationPrognosisGroup .PrognosisId (Sales and marketing)     <‑‑‑    smmOpportunityTable .PrognosisId (Sales and marketing)
1446smmQuotationReasonGroup .ReasonId (Sales and marketing)     <‑‑‑    SalesQuotationTable .ReasonId (Procurement and sourcing)
1447smmQuotationReasonGroup .ReasonId (Sales and marketing)     <‑‑‑    smmLeadTable .ReasonId (Sales and marketing)
1448smmQuotationReasonGroup .ReasonId (Sales and marketing)     <‑‑‑    smmOpportunityTable .Reason (Sales and marketing)
1449smmQuotationReasonGroup .ReasonId (Sales and marketing)     <‑‑‑    TmpSalesQuotationMassUpdate .ReasonId (Procurement and sourcing)
1450smmResponsibilityGroup .ResponsibilityId (Sales and marketing)     <‑‑‑    smmActivities .ResponsibilityId (Sales and marketing)
1451smmResponsibilityGroup .ResponsibilityId (Sales and marketing)     <‑‑‑    smmResponsibilitiesEmplTable .ResponsibilityId (Sales and marketing)
1452smmResponsibilityGroup .Pky?, .Pky?, .ResponsibilityId (Sales and marketing)     <‑‑‑    smmResponsibilitiesTable .Fky?, .Fky?, .ResponsibilityId (Sales and marketing)
1453smmResponsibilityGroup .ResponsibilityId, .Pky?, .Pky? (Sales and marketing)     <‑‑‑    smmResponsibilitiesTable .ResponsibilityId, .Fky?, .Fky? (Sales and marketing)
1454smmResponsibilityGroup .Pky?, .Pky?, .ResponsibilityId (Sales and marketing)     <‑‑‑    smmResponsibilitiesTable .Fky?, .Fky?, .ResponsibilityId (Sales and marketing)
1455smmResponsibilityGroup .Pky?, .Pky?, .ResponsibilityId (Sales and marketing)     <‑‑‑    smmResponsibilitiesTable .Fky?, .Fky?, .ResponsibilityId (Sales and marketing)
1456smmResponsibilityGroup .Pky?, .Pky?, .ResponsibilityId (Sales and marketing)     <‑‑‑    smmResponsibilitiesTable .Fky?, .Fky?, .ResponsibilityId (Sales and marketing)
1457smmSalesManagementAllowedTables .AllowedTableId (Sales and marketing)     <‑‑‑    smmSalesManagementAllowedFields .AllowedTableId (Sales and marketing)
1458smmSalesManagementGraphOptions .RecId (Sales and marketing)     <‑‑‑    smmSalesManagementGraphTable .RefRecId (Sales and marketing)
1459smmSalesManagementGraphOptions .RecId (Sales and marketing)     <‑‑‑    smmSalesManagementQueriesTable .RefRecId (Sales and marketing)
1460smmSalesManagementGraphTable .RecId (Sales and marketing)     <‑‑‑    smmSalesManagementGraphLines .RefRecId (Sales and marketing)
1461smmSalesManagementQueriesTable .RefRecId (Sales and marketing)     <‑‑‑    smmSalesManagementGraphTable .RefRecId (Sales and marketing)
1462smmSalesTarget .RecId (Sales and marketing)     <‑‑‑    smmSalesTargetTrans .RefRecId (Sales and marketing)
1463smmSalesUnit .SalesUnitId (Sales and marketing)     <‑‑‑    InventSalesShipmentDetailsTmp_CN .SalesUnitId (Global financial management - Asia Pacific)
1464smmSalesUnit .dataAreaId, .SalesUnitId (Sales and marketing)     <‑‑‑    SalesAgreementHeaderDefault .SalesUnitDataAreaId, .SalesUnit (Procurement and sourcing)
1465smmSalesUnit .dataAreaId, .SalesUnitId (Sales and marketing)     <‑‑‑    SalesAgreementHeaderDefaultHistory .SalesUnitDataAreaId, .SalesUnit (Procurement and sourcing)
1466smmSalesUnit .SalesUnitId (Sales and marketing)     <‑‑‑    SalesQuotationTable .SalesUnitId (Procurement and sourcing)
1467smmSalesUnit .SalesUnitId (Sales and marketing)     <‑‑‑    SalesTable .SalesUnitId (Procurement and sourcing)
1468smmSalesUnit .SalesUnitId (Sales and marketing)     <‑‑‑    smmLeadTable .SalesUnitId (Sales and marketing)
1469smmSalesUnit .SalesUnitId (Sales and marketing)     <‑‑‑    smmOpportunityTable .SalesUnitId (Sales and marketing)
1470smmSalesUnit .SalesUnitId (Sales and marketing)     <‑‑‑    smmPhoneLog .SalesUnitId (Sales and marketing)
1471smmSalesUnit .TableId, .RecId (Sales and marketing)     <‑‑‑    smmResponsibilitiesEmplTable .RefTableId, .RefRecId (Sales and marketing)
1472smmSalesUnit .Pky?, .SalesUnitId (Sales and marketing)     <‑‑‑    smmResponsibilitiesTable .Fky?, .SalesUnitId (Sales and marketing)
1473smmSalesUnit .SalesUnitId (Sales and marketing)     <‑‑‑    smmSalesManagementGraphOptions .SalesUnitId (Sales and marketing)
1474smmSalesUnit .SalesUnitId (Sales and marketing)     <‑‑‑    smmSalesTarget .SalesUnitId (Sales and marketing)
1475smmSalesUnit .SalesUnitId (Sales and marketing)     <‑‑‑    smmSalesUnit .ParentId (Sales and marketing)
1476smmSalesUnit .SalesUnitId (Sales and marketing)     <‑‑‑    smmSalesUnitMembers .SalesUnitId (Sales and marketing)
1477smmSalesUnit .SalesUnitId (Sales and marketing)     <‑‑‑    smmTransLog .SalesUnitId (Sales and marketing)
1478smmSalesUnitMembers .MemberId (Sales and marketing)     <‑‑‑    smmSalesTarget .MemberId (Sales and marketing)
1479smmSourceTypeTable .TypeId (Sales and marketing)     <‑‑‑    CaseLog .SourceTypeId (Sales and marketing)
1480smmSourceTypeTable .TypeId (Sales and marketing)     <‑‑‑    smmLeadTable .SourceTypeId (Sales and marketing)
1481smmSourceTypeTable .TypeId (Sales and marketing)     <‑‑‑    smmOpportunityTable .SourceTypeId (Sales and marketing)
1482smmSourceTypeTable .TypeId (Sales and marketing)     <‑‑‑    smmSourceTypeOptions .TypeId (Sales and marketing)
1483smmTMCallListGroup .CallListID (Sales and marketing)     <‑‑‑    SalesQuotationTable .CallListID (Procurement and sourcing)
1484smmTMCallListGroup .Pky?, .RecId (Sales and marketing)     <‑‑‑    smmActivityParentLinkTable .Fky?, .RefRecId (Sales and marketing)
1485smmTMCallListGroup .CallListID (Sales and marketing)     <‑‑‑    smmCampaignTable .TMCallListID (Sales and marketing)
1486smmTMCallListGroup .TableId, .RecId (Sales and marketing)     <‑‑‑    smmResponsibilitiesEmplTable .RefTableId, .RefRecId (Sales and marketing)
1487smmTMCallListGroup .CallListID (Sales and marketing)     <‑‑‑    smmTMCallListTable .CallListId (Sales and marketing)
1488smmTMCallListTable .dataAreaId, .TableId, .RecId (Sales and marketing)     <‑‑‑    DocuRef .RefCompanyId, .RefTableId, .RefRecId (Client)
1489smmTMCallListTable .Party (Sales and marketing)     <‑‑‑    smmMailings .Party (Sales and marketing)
1490smmTMCallListTable .Party (Sales and marketing)     <‑‑‑    smmPhoneLog .Party (Sales and marketing)
1491smmTMCallListTable .TableId, .RecId (Sales and marketing)     <‑‑‑    smmTransLog .RefTableId, .RefRecId (Sales and marketing)
1492smmTMReasonGroup .ReasonId (Sales and marketing)     <‑‑‑    smmTMCallListTable .ReasonId (Sales and marketing)
1493SysEmailSystemTable .EmailId (Sales and marketing)     <‑‑‑    EventSystemParameters .AlertTemplateId (Workflow)
1494SysEmailSystemTable .EmailId (Sales and marketing)     <‑‑‑    SysEmailMessageSystemTable .EmailId (Sales and marketing)
1495SysEmailSystemTable .EmailId (Sales and marketing)     <‑‑‑    SysWorkflowParameters .WorkItemEmailId (Workflow)
1496SysEmailSystemTable .EmailId (Sales and marketing)     <‑‑‑    UserRequestParameters .CustomerNewUserEmailTemplate (Procurement and sourcing)
1497SysEmailSystemTable .EmailId (Sales and marketing)     <‑‑‑    UserRequestParameters .TemporaryPasswordEmailTemplate (Procurement and sourcing)
1498SysEmailSystemTable .EmailId (Sales and marketing)     <‑‑‑    UserRequestParameters .UserAliasEmailTemplate (Procurement and sourcing)
1499SysEmailSystemTable .EmailId (Sales and marketing)     <‑‑‑    UserRequestParameters .VendorNewUserEmailTemplate (Procurement and sourcing)
1500SysEmailTable .EmailId (Sales and marketing)     <‑‑‑    CaseCategoryHierarchyDetail .EmailId (Sales and marketing)
1501SysEmailTable .EmailId (Sales and marketing)     <‑‑‑    CaseDetailBase .EmailId (Sales and marketing)
1502SysEmailTable .EmailId (Sales and marketing)     <‑‑‑    CustParameters .CollectionsGeneralSysEmailId (Accounts Receivable)
1503SysEmailTable .EmailId (Sales and marketing)     <‑‑‑    CustParameters .CollectionsSalespersonSysEmailId (Accounts Receivable)
1504SysEmailTable .EmailId (Sales and marketing)     <‑‑‑    CustParameters .CollectionsStatementSysEmailId (Accounts Receivable)
1505SysEmailTable .EmailId (Sales and marketing)     <‑‑‑    EInvoiceCFDIParameters_MX .EmailId (Global financial management - Latin America)
1506SysEmailTable .EmailId (Sales and marketing)     <‑‑‑    EInvoiceParameters_MX .EmailId (Global financial management - Latin America)
1507SysEmailTable .dataAreaId, .EmailId (Sales and marketing)     <‑‑‑    EventInbox .CompanyId, .EmailTemplateId (Workflow)
1508SysEmailTable .EmailId (Sales and marketing)     <‑‑‑    EventParameters .AlertTemplateId (Workflow)
1509SysEmailTable .EmailId (Sales and marketing)     <‑‑‑    FiscalEstablishment_BR .EFDocEmailApproved (Global financial management - Latin America)
1510SysEmailTable .EmailId (Sales and marketing)     <‑‑‑    FiscalEstablishment_BR .EFDocEmailCanceled (Global financial management - Latin America)
1511SysEmailTable .EmailId (Sales and marketing)     <‑‑‑    FiscalEstablishment_BR .EFDocEmailEvent (Global financial management - Latin America)
1512SysEmailTable .EmailId (Sales and marketing)     <‑‑‑    PurchRFQCaseTable .SitesEmailId (Procurement and sourcing)
1513SysEmailTable .EmailId (Sales and marketing)     <‑‑‑    RetailEventNotificationSetting .EmailId (Retail)
1514SysEmailTable .EmailId (Sales and marketing)     <‑‑‑    SysEmailMessageTable .EmailId (Sales and marketing)
1515SysEmailTable .EmailId (Sales and marketing)     <‑‑‑    SysOutgoingEmailTable .TemplateId (Sales and marketing)
1516SysEmailTable .EmailId (Sales and marketing)     <‑‑‑    WorkflowParameters .WorkItemEmailId (Workflow)
1517SysImportDocument .TableId, .RecId (Sales and marketing)     <‑‑‑    SysImportFormat .RefDocTableId, .RefDocRecId (Sales and marketing)
1518SysImportDocument .RecId, .TableId (Sales and marketing)     <‑‑‑    SysImportTransformation .RefDocRecId, .RefDocTableId (Sales and marketing)
1519SysImportFormat .TableId, .RecId (Sales and marketing)     <‑‑‑    SysImportFormatTransformation .RefFormatTableId, .RefFormatRecId (Sales and marketing)
1520SysImportTransformation .TableId, .RecId (Sales and marketing)     <‑‑‑    SysImportFormatTransformation .RefTransTableId, .RefTransRecId (Sales and marketing)
1521SysImportTransformation .TableId, .RecId (Sales and marketing)     <‑‑‑    SysImportTransformationParameter .RefTransTableId, .RefTransRecId (Sales and marketing)
1522SysOutgoingEmailTable .EmailItemId (Sales and marketing)     <‑‑‑    EventInbox .EmailId (Workflow)
1523SysOutgoingEmailTable .EmailItemId (Sales and marketing)     <‑‑‑    SysOutgoingEmailData .EmailItemId (Sales and marketing)



  Microsoft
Disclaimer   |   Terms of Use   |   Trademarks   |   Privacy Statement       ©  2013 Microsoft