Microsoft Dynamics AX 2012 R2

AxErd: Child-Parents: Sales and marketing

Module: Sales and marketing

Navigation:     AxErd_Home     Previous_File    


Row-num Child-table-name Foreign-key-columns Module-of-child-table Arrow-to-parent Parent-table-name Primary-key-columns Module-of-parent-table
615smmTMContactResponses .ContactPersonId (Sales and marketing)     ‑‑‑>    ContactPerson .ContactPersonId (Sales and marketing)
616smmTMContactResponses .Party (Sales and marketing)     ‑‑‑>    DirPartyTable .RecId (Sales and marketing)
617smmTMContactResponses .kmVirtualNetworkAnswerTableId (Sales and marketing)     ‑‑‑>    KMVirtualNetworkAnswerTable .kmVirtualNetworkAnswerTableId (Human resources)
618smmTMContactResponses .Party (Sales and marketing)     ‑‑‑>    smmBusRelTable .Party (Sales and marketing)
619smmTmpOutlookContacts .ContactPersonId (Sales and marketing)     ‑‑‑>    ContactPerson .ContactPersonId (Sales and marketing)
620smmTmpOutlookContacts .ContactForParty (Sales and marketing)     ‑‑‑>    DirPartyTable .RecId (Sales and marketing)
621smmTransLog .RefRecId (Sales and marketing)     ‑‑‑>    CaseDetailBase .RecId (Sales and marketing)
622smmTransLog .RefNum (Sales and marketing)     ‑‑‑>    CaseDetailBase .CaseId (Sales and marketing)
623smmTransLog .RefTableId (Sales and marketing)     ‑‑‑>    CaseDetailBase .TableId (Sales and marketing)
624smmTransLog .ContactPersonId (Sales and marketing)     ‑‑‑>    ContactPerson .ContactPersonId (Sales and marketing)
625smmTransLog .RefTableId, .RefRecId, .RefNum (Sales and marketing)     ‑‑‑>    CustTable .TableId, .RecId, .AccountNum (Sales and marketing)
626smmTransLog .RefTableId, .RefRecId, .RefNum (Sales and marketing)     ‑‑‑>    CustTrans .TableId, .RecId, .Voucher (Accounts Receivable)
627smmTransLog .Party (Sales and marketing)     ‑‑‑>    DirAddressBookPartyAllView .Party (Unknown module)
628smmTransLog .Party (Sales and marketing)     ‑‑‑>    DirPartyTable .RecId (Sales and marketing)
629smmTransLog .RefTableId, .RefRecId (Sales and marketing)     ‑‑‑>    DocuRef .TableId, .RecId (Client)
630smmTransLog .Worker (Sales and marketing)     ‑‑‑>    HcmWorker .RecId (Human resources)
631smmTransLog .RefTableId, .RefRecId, .RefNum (Sales and marketing)     ‑‑‑>    SalesTable .TableId, .RecId, .SalesId (Procurement and sourcing)
632smmTransLog .RefTableId, .RefRecId, .RefNum (Sales and marketing)     ‑‑‑>    smmActivities .TableId, .RecId, .ActivityNumber (Sales and marketing)
633smmTransLog .RefTableId, .RefRecId (Sales and marketing)     ‑‑‑>    smmBusRelTable .TableId, .RecId (Sales and marketing)
634smmTransLog .RefRecId, .RefNum, .RefTableId (Sales and marketing)     ‑‑‑>    smmCampaignTable .RecId, .CampaignId, .TableId (Sales and marketing)
635smmTransLog .RefTableId, .RefRecId (Sales and marketing)     ‑‑‑>    smmLeadTable .TableId, .RecId (Sales and marketing)
636smmTransLog .RefTableId, .RefRecId, .RefNum (Sales and marketing)     ‑‑‑>    smmMailings .TableId, .RecId, .KeyId (Sales and marketing)
637smmTransLog .RefTableId, .RefRecId (Sales and marketing)     ‑‑‑>    smmOpportunityTable .TableId, .RecId (Sales and marketing)
638smmTransLog .SalesUnitId (Sales and marketing)     ‑‑‑>    smmSalesUnit .SalesUnitId (Sales and marketing)
639smmTransLog .RefTableId, .RefRecId (Sales and marketing)     ‑‑‑>    smmTMCallListTable .TableId, .RecId (Sales and marketing)
640smmTransLog .RefTableId, .RefRecId, .RefNum (Sales and marketing)     ‑‑‑>    VendTable .TableId, .RecId, .AccountNum (Procurement and sourcing)
641smmTransLog .RefTableId, .RefRecId, .RefNum (Sales and marketing)     ‑‑‑>    VendTrans .TableId, .RecId, .Voucher (Accounts Payable)
642SysEmailMessageSystemTable .LanguageId, .Fky? (Sales and marketing)     ‑‑‑>    LanguageTable .LanguageId, .Pky? (Developer and Partner Tools)
643SysEmailMessageSystemTable .EmailId (Sales and marketing)     ‑‑‑>    SysEmailSystemTable .EmailId (Sales and marketing)
644SysEmailMessageTable .LanguageId, .Fky? (Sales and marketing)     ‑‑‑>    LanguageTable .LanguageId, .Pky? (Developer and Partner Tools)
645SysEmailMessageTable .EmailId (Sales and marketing)     ‑‑‑>    SysEmailTable .EmailId (Sales and marketing)
646SysEmailSystemTable .BatchGroupId (Sales and marketing)     ‑‑‑>    BatchGroup .Group (Server and Tools)
647SysEmailSystemTable .DefaultLanguage, .Fky? (Sales and marketing)     ‑‑‑>    LanguageTable .LanguageId, .Pky? (Developer and Partner Tools)
648SysEmailTable .BatchGroupId (Sales and marketing)     ‑‑‑>    BatchGroup .Group (Server and Tools)
649SysEmailTable .DefaultLanguage, .Fky? (Sales and marketing)     ‑‑‑>    LanguageTable .LanguageId, .Pky? (Developer and Partner Tools)
650SysImportFormat .RefDocTableId, .RefDocRecId (Sales and marketing)     ‑‑‑>    SysImportDocument .TableId, .RecId (Sales and marketing)
651SysImportFormatTransformation .RefFormatTableId, .RefFormatRecId (Sales and marketing)     ‑‑‑>    SysImportFormat .TableId, .RecId (Sales and marketing)
652SysImportFormatTransformation .RefTransTableId, .RefTransRecId (Sales and marketing)     ‑‑‑>    SysImportTransformation .TableId, .RecId (Sales and marketing)
653SysImportTransformation .RefDocRecId, .RefDocTableId (Sales and marketing)     ‑‑‑>    SysImportDocument .RecId, .TableId (Sales and marketing)
654SysImportTransformationParameter .RefTransTableId, .RefTransRecId (Sales and marketing)     ‑‑‑>    SysImportTransformation .TableId, .RecId (Sales and marketing)
655SysOutgoingEmailData .EmailItemId (Sales and marketing)     ‑‑‑>    SysOutgoingEmailTable .EmailItemId (Sales and marketing)
656SysOutgoingEmailTable .TemplateId (Sales and marketing)     ‑‑‑>    SysEmailTable .EmailId (Sales and marketing)
657SysOutgoingEmailTable .UserId (Sales and marketing)     ‑‑‑>    UserInfo .id (Unknown module)
658tmpSmmCustRevenuePeriod .CurrencyCode (Sales and marketing)     ‑‑‑>    Currency .CurrencyCode (General ledger)
659tmpSmmCustRevenuePeriod .AccountNum (Sales and marketing)     ‑‑‑>    CustTable .AccountNum (Sales and marketing)
660TmpSmmKACaseRelation .ItemId (Sales and marketing)     ‑‑‑>    smmEncyclopediaItems .ItemId (Sales and marketing)
661tmpSmmResponsibilityDistribute .Worker (Sales and marketing)     ‑‑‑>    HcmWorker .RecId (Human resources)
662tmpSmmSalesCustItemStatistics .AccountNum (Sales and marketing)     ‑‑‑>    CustTable .AccountNum (Sales and marketing)
663tmpSmmSalesCustItemStatistics .ItemId (Sales and marketing)     ‑‑‑>    InventTable .ItemId (Inventory and warehouse management)
664tmpSmmSalesCustItemStatistics .Unit1 (Sales and marketing)     ‑‑‑>    UnitOfMeasure .Symbol (Inventory and warehouse management)
665tmpSmmSalesCustItemStatistics .Unit2 (Sales and marketing)     ‑‑‑>    UnitOfMeasure .Symbol (Inventory and warehouse management)



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