Microsoft Dynamics AX 2012 R2

AxErd: Child-Parents: Client

Module: Client

Navigation:     AxErd_Home    


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
1AxdDocumentParameters .FreeTextInvoiceLedgerDimension (Client)     ‑‑‑>    DimensionAttributeValueCombination .RecId (General ledger)
2AxdDocumentParameters .DocuTypeId, .Fky? (Client)     ‑‑‑>    DocuType .TypeId, .Pky? (Client)
3AxdDocumentParameters .CountJournalNameId, .Fky? (Client)     ‑‑‑>    InventJournalName .JournalNameId, .Pky? (Inventory and warehouse management)
4AxdDocumentParameters .ProfitLossJournalNameId, .Fky? (Client)     ‑‑‑>    InventJournalName .JournalNameId, .Pky? (Inventory and warehouse management)
5AxdDocumentParameters .TransferJournalNameId, .Fky? (Client)     ‑‑‑>    InventJournalName .JournalNameId, .Pky? (Inventory and warehouse management)
6AxdDocumentParameters .CustPaymJournalNameId, .Fky? (Client)     ‑‑‑>    LedgerJournalName .JournalName, .Pky? (General ledger)
7AxdDocumentParameters .InvoiceRegisterJournalName, .Fky? (Client)     ‑‑‑>    LedgerJournalName .JournalName, .Pky? (General ledger)
8AxdDocumentParameters .PriceDiscJournalName (Client)     ‑‑‑>    PriceDiscAdmName .JournalName (Procurement and sourcing)
9AxdDocumentParameters .ProdPickingListJournalNameId, .Fky? (Client)     ‑‑‑>    ProdJournalName .JournalNameId, .Pky? (Manufacturing)
10AxdDocumentParameters .RouteCardJournalNameId, .Fky? (Client)     ‑‑‑>    ProdJournalName .JournalNameId, .Pky? (Manufacturing)
11AxdDocumentParameters .ProjJournalNameId (Client)     ‑‑‑>    ProjJournalName .JournalNameId (Project management and accounting)
12DocuField .TypeId, .DocuTableId (Client)     ‑‑‑>    DocuTable .TypeId, .DocuTableId (Client)
13DocuOpenFile .RefRecId (Client)     ‑‑‑>    DocuRef .RecId (Client)
14DocuRef .RefCompanyId, .RefTableId, .RefRecId (Client)     ‑‑‑>    AssetTable .dataAreaId, .TableId, .RecId (Fixed assets)
15DocuRef .RefCompanyId, .RefTableId, .RefRecId (Client)     ‑‑‑>    CaseDetail .dataAreaId, .TableId, .RecId (Sales and marketing)
16DocuRef .RefRecId, .RefTableId, .RefCompanyId (Client)     ‑‑‑>    ContactPerson .RecId, .TableId, .dataAreaId (Sales and marketing)
17DocuRef .RefCompanyId, .ContactPersonId (Client)     ‑‑‑>    ContactPerson .dataAreaId, .ContactPersonId (Sales and marketing)
18DocuRef .RefCompanyId, .RefTableId, .RefRecId (Client)     ‑‑‑>    CustInvoiceLine .dataAreaId, .TableId, .RecId (Accounts Receivable)
19DocuRef .RefCompanyId, .RefTableId, .RefRecId (Client)     ‑‑‑>    CustTable .dataAreaId, .TableId, .RecId (Sales and marketing)
20DocuRef .ActualCompanyId, .Fky? (Client)     ‑‑‑>    DataArea .id, .Pky? (Unknown module)
21DocuRef .RefCompanyId, .Fky? (Client)     ‑‑‑>    DataArea .id, .Pky? (Unknown module)
22DocuRef .Party (Client)     ‑‑‑>    DirAddressBookPartyAllView .Party (Unknown module)
23DocuRef .Party (Client)     ‑‑‑>    DirPartyTable .RecId (Sales and marketing)
24DocuRef .Author (Client)     ‑‑‑>    DirPerson .RecId (Sales and marketing)
25DocuRef .RefCompanyId, .TypeId (Client)     ‑‑‑>    DocuType .dataAreaId, .TypeId (Client)
26DocuRef .ValueRecId (Client)     ‑‑‑>    DocuValue .RecId (Client)
27DocuRef .RefTableId, .RefRecId (Client)     ‑‑‑>    HcmWorker .TableId, .RecId (Human resources)
28DocuRef .RefRecId, .RefTableId, .RefCompanyId (Client)     ‑‑‑>    InventQualityOrderLine .RecId, .TableId, .dataAreaId (Inventory and warehouse management)
29DocuRef .RefCompanyId, .RefTableId, .RefRecId (Client)     ‑‑‑>    InventTable .dataAreaId, .TableId, .RecId (Inventory and warehouse management)
30DocuRef .RefRecId, .RefTableId, .RefCompanyId (Client)     ‑‑‑>    InventTestGroupMember .RecId, .TableId, .dataAreaId (Inventory and warehouse management)
31DocuRef .RefRecId, .RefTableId, .RefCompanyId (Client)     ‑‑‑>    InventTestTable .RecId, .TableId, .dataAreaId (Inventory and warehouse management)
32DocuRef .RefRecId, .RefTableId, .RefCompanyId (Client)     ‑‑‑>    LedgerJournalTable .RecId, .TableId, .dataAreaId (General ledger)
33DocuRef .RefRecId, .RefTableId, .RefCompanyId (Client)     ‑‑‑>    LedgerJournalTrans .RecId, .TableId, .dataAreaId (General ledger)
34DocuRef .RefRecId, .RefTableId, .RefCompanyId (Client)     ‑‑‑>    ProdRoute .RecId, .TableId, .dataAreaId (Manufacturing)
35DocuRef .RefCompanyId, .RefRecId, .RefTableId (Client)     ‑‑‑>    ProjBudget .dataAreaId, .RecId, .TableId (Project management and accounting)
36DocuRef .RefCompanyId, .RefTableId, .RefRecId (Client)     ‑‑‑>    ProjEmplTrans .dataAreaId, .TableId, .RecId (Project management and accounting)
37DocuRef .RefCompanyId, .RefTableId, .RefRecId (Client)     ‑‑‑>    ProjInvoiceCost .dataAreaId, .TableId, .RecId (Project management and accounting)
38DocuRef .RefCompanyId, .RefTableId, .RefRecId (Client)     ‑‑‑>    ProjInvoiceEmpl .dataAreaId, .TableId, .RecId (Project management and accounting)
39DocuRef .RefCompanyId, .RefTableId, .RefRecId (Client)     ‑‑‑>    ProjInvoiceItem .dataAreaId, .TableId, .RecId (Project management and accounting)
40DocuRef .RefCompanyId, .RefTableId, .RefRecId (Client)     ‑‑‑>    ProjInvoiceJour .dataAreaId, .TableId, .RecId (Project management and accounting)
41DocuRef .RefCompanyId, .RefTableId, .RefRecId (Client)     ‑‑‑>    ProjInvoiceOnAcc .dataAreaId, .TableId, .RecId (Project management and accounting)
42DocuRef .RefCompanyId, .RefTableId, .RefRecId (Client)     ‑‑‑>    ProjInvoiceRevenue .dataAreaId, .TableId, .RecId (Project management and accounting)
43DocuRef .RefRecId, .RefCompanyId, .RefTableId (Client)     ‑‑‑>    ProjJournalTrans .RecId, .dataAreaId, .TableId (Project management and accounting)
44DocuRef .RefCompanyId, .RefTableId, .RefRecId (Client)     ‑‑‑>    ProjOnAccTrans .dataAreaId, .TableId, .RecId (Project management and accounting)
45DocuRef .RefCompanyId, .RefTableId, .RefRecId (Client)     ‑‑‑>    ProjProposalCost .dataAreaId, .TableId, .RecId (Project management and accounting)
46DocuRef .RefCompanyId, .RefTableId, .RefRecId (Client)     ‑‑‑>    ProjProposalEmpl .dataAreaId, .TableId, .RecId (Project management and accounting)
47DocuRef .RefCompanyId, .RefTableId, .RefRecId (Client)     ‑‑‑>    ProjProposalItem .dataAreaId, .TableId, .RecId (Project management and accounting)
48DocuRef .RefCompanyId, .RefTableId, .RefRecId (Client)     ‑‑‑>    ProjProposalJour .dataAreaId, .TableId, .RecId (Project management and accounting)
49DocuRef .RefCompanyId, .RefTableId, .RefRecId (Client)     ‑‑‑>    ProjProposalRevenue .dataAreaId, .TableId, .RecId (Project management and accounting)
50DocuRef .RefCompanyId, .RefTableId, .RefRecId (Client)     ‑‑‑>    ProjTable .dataAreaId, .TableId, .RecId (Project management and accounting)
51DocuRef .RefCompanyId, .RefTableId, .RefRecId (Client)     ‑‑‑>    PurchComplementaryInvoiceHeader .dataAreaId, .TableId, .RecId (Global financial management - Latin America)
52DocuRef .RefCompanyId, .RefTableId, .RefRecId (Client)     ‑‑‑>    PurchComplementaryInvoiceLine .dataAreaId, .TableId, .RecId (Global financial management - Latin America)
53DocuRef .RefCompanyId, .RefTableId, .RefRecId (Client)     ‑‑‑>    PurchLine .dataAreaId, .TableId, .RecId (Procurement and sourcing)
54DocuRef .RefCompanyId, .RefTableId, .RefRecId (Client)     ‑‑‑>    PurchLineHistory .dataAreaId, .TableId, .RecId (Procurement and sourcing)
55DocuRef .RefTableId, .RefRecId (Client)     ‑‑‑>    PurchReqLine .TableId, .RecId (Procurement and sourcing)
56DocuRef .RefTableId, .RefRecId (Client)     ‑‑‑>    PurchReqTable .TableId, .RecId (Procurement and sourcing)
57DocuRef .RefCompanyId, .RefTableId, .RefRecId (Client)     ‑‑‑>    PurchRFQCaseLine .dataAreaId, .TableId, .RecId (Procurement and sourcing)
58DocuRef .RefCompanyId, .RefTableId, .RefRecId (Client)     ‑‑‑>    PurchRFQLine .dataAreaId, .TableId, .RecId (Procurement and sourcing)
59DocuRef .RefCompanyId, .RefTableId, .RefRecId (Client)     ‑‑‑>    PurchRFQReplyTable .dataAreaId, .TableId, .RecId (Procurement and sourcing)
60DocuRef .RefCompanyId, .RefTableId, .RefRecId (Client)     ‑‑‑>    PurchRFQTable .dataAreaId, .TableId, .RecId (Procurement and sourcing)
61DocuRef .RefCompanyId, .RefTableId, .RefRecId (Client)     ‑‑‑>    PurchTable .dataAreaId, .TableId, .RecId (Procurement and sourcing)
62DocuRef .RefCompanyId, .RefTableId, .RefRecId (Client)     ‑‑‑>    PurchTableHistory .dataAreaId, .TableId, .RecId (Procurement and sourcing)
63DocuRef .RefRecId, .RefTableId, .RefCompanyId (Client)     ‑‑‑>    RetailDiscountCode .RecId, .TableId, .dataAreaId (Retail)
64DocuRef .RefCompanyId, .RefRecId, .RefTableId (Client)     ‑‑‑>    RouteOpr .dataAreaId, .RecId, .TableId (Manufacturing)
65DocuRef .RefCompanyId, .RefTableId, .RefRecId (Client)     ‑‑‑>    SalesComplementaryInvoiceHeader .dataAreaId, .TableId, .RecId (Global financial management - Latin America)
66DocuRef .RefCompanyId, .RefTableId, .RefRecId (Client)     ‑‑‑>    SalesComplementaryInvoiceLine .dataAreaId, .TableId, .RecId (Global financial management - Latin America)
67DocuRef .RefCompanyId, .RefTableId, .RefRecId (Client)     ‑‑‑>    SalesLine .dataAreaId, .TableId, .RecId (Procurement and sourcing)
68DocuRef .RefCompanyId, .RefTableId, .RefRecId (Client)     ‑‑‑>    SalesQuotationLine .dataAreaId, .TableId, .RecId (Procurement and sourcing)
69DocuRef .RefCompanyId, .RefTableId, .RefRecId (Client)     ‑‑‑>    SalesQuotationTable .dataAreaId, .TableId, .RecId (Procurement and sourcing)
70DocuRef .RefCompanyId, .RefTableId, .RefRecId (Client)     ‑‑‑>    SalesTable .dataAreaId, .TableId, .RecId (Procurement and sourcing)
71DocuRef .RefTableId, .RefRecId, .RefCompanyId (Client)     ‑‑‑>    smmBusRelTable .TableId, .RecId, .dataAreaId (Sales and marketing)
72DocuRef .RefRecId, .RefTableId, .RefCompanyId (Client)     ‑‑‑>    smmCampaignTable .RecId, .TableId, .dataAreaId (Sales and marketing)
73DocuRef .RefCompanyId, .EncyclopediaItemId (Client)     ‑‑‑>    smmEncyclopediaItems .dataAreaId, .ItemId (Sales and marketing)
74DocuRef .RefRecId, .RefCompanyId, .RefTableId (Client)     ‑‑‑>    smmLeadTable .RecId, .dataAreaId, .TableId (Sales and marketing)
75DocuRef .RefCompanyId, .RefTableId, .RefRecId (Client)     ‑‑‑>    smmOpportunityTable .dataAreaId, .TableId, .RecId (Sales and marketing)
76DocuRef .RefCompanyId, .RefTableId, .RefRecId (Client)     ‑‑‑>    smmQuotationCompetitorGroup .dataAreaId, .TableId, .RecId (Sales and marketing)
77DocuRef .RefCompanyId, .RefTableId, .RefRecId (Client)     ‑‑‑>    smmTMCallListTable .dataAreaId, .TableId, .RecId (Sales and marketing)
78DocuRef .RefRecId, .RefTableId, .RefCompanyId (Client)     ‑‑‑>    TrvDisputes .RecId, .TableId, .dataAreaId (Travel and expense)
79DocuRef .RefTableId, .RefRecId (Client)     ‑‑‑>    TrvExpTable .TableId, .RecId (Travel and expense)
80DocuRef .RefTableId, .RefRecId (Client)     ‑‑‑>    UtilElements .TableId, .RecId (Unknown module)
81DocuRef .RefCompanyId, .RefTableId, .RefRecId (Client)     ‑‑‑>    VendBankAccount .dataAreaId, .TableId, .RecId (Procurement and sourcing)
82DocuRef .RefCompanyId, .RefTableId, .RefRecId (Client)     ‑‑‑>    VendCertification .dataAreaId, .TableId, .RecId (Procurement and sourcing)
83DocuRef .RefCompanyId, .RefTableId, .RefRecId (Client)     ‑‑‑>    VendInvoiceInfoLine .dataAreaId, .TableId, .RecId (Accounts Payable)
84DocuRef .RefCompanyId, .RefTableId, .RefRecId (Client)     ‑‑‑>    VendInvoiceInfoTable .dataAreaId, .TableId, .RecId (Accounts Payable)
85DocuRef .RefCompanyId, .RefTableId, .RefRecId (Client)     ‑‑‑>    VendInvoiceJour .dataAreaId, .TableId, .RecId (Accounts Payable)
86DocuRef .RefCompanyId, .RefTableId, .RefRecId (Client)     ‑‑‑>    VendInvoiceTrans .dataAreaId, .TableId, .RecId (Accounts Payable)
87DocuRef .RefCompanyId, .RefTableId, .RefRecId (Client)     ‑‑‑>    VendNotificationTemplate .dataAreaId, .TableId, .RecId (Procurement and sourcing)
88DocuRef .RefRecId, .RefCompanyId, .RefTableId (Client)     ‑‑‑>    VendPurchOrderJour .RecId, .dataAreaId, .TableId (Procurement and sourcing)
89DocuRef .RefCompanyId, .RefTableId, .RefRecId (Client)     ‑‑‑>    VendRequest .dataAreaId, .TableId, .RecId (Procurement and sourcing)
90DocuRef .RefCompanyId, .RefTableId, .RefRecId (Client)     ‑‑‑>    VendStateTaxID .dataAreaId, .TableId, .RecId (Global financial management - North America)
91DocuRef .RefCompanyId, .RefTableId, .RefRecId (Client)     ‑‑‑>    VendTable .dataAreaId, .TableId, .RecId (Procurement and sourcing)
92DocuTable .TypeId (Client)     ‑‑‑>    DocuType .TypeId (Client)
93DocuTemplate .FileType (Client)     ‑‑‑>    DocuFileTypes .FileType (Client)
94DocuTemplate .TypeID (Client)     ‑‑‑>    DocuType .TypeId (Client)
95DocuTemplate .LanguageID, .Fky? (Client)     ‑‑‑>    LanguageTable .LanguageId, .Pky? (Developer and Partner Tools)
96DocuValueMetaData .ContentType (Client)     ‑‑‑>    ContentType .RecId (Client)
97DocuValueMetaData .DocuValue (Client)     ‑‑‑>    DocuValue .RecId (Client)
98SysCue .CreatedByUser (Client)     ‑‑‑>    SysUserInfo .Id (Server and Tools)
99SysCueGroup .CreatedByUser (Client)     ‑‑‑>    SysUserInfo .Id (Server and Tools)
100SysCueGroupMembership .Cue (Client)     ‑‑‑>    SysCue .RecId (Client)
101SysCueGroupMembership .CueGroup (Client)     ‑‑‑>    SysCueGroup .RecId (Client)
102SysCuePersonalization .Cue (Client)     ‑‑‑>    SysCue .RecId (Client)
103SysCuePersonalization .CueGroup (Client)     ‑‑‑>    SysCueGroup .RecId (Client)
104SysCuePersonalization .CreatedByUser (Client)     ‑‑‑>    SysUserInfo .Id (Server and Tools)
105SysCueVisibility .Cue (Client)     ‑‑‑>    SysCue .RecId (Client)
106SysCueVisibility .Profile (Client)     ‑‑‑>    SysProfiles .ProfileId (Client)
107SysImageTable .Language, .Fky? (Client)     ‑‑‑>    LanguageTable .LanguageId, .Pky? (Developer and Partner Tools)
108SysImageTable .Theme (Client)     ‑‑‑>    SysInetThemeTable .Name (Client)
109SysINetTable .Id (Client)     ‑‑‑>    UserInfo .id (Unknown module)
110SysInetThemeTable .StyleSheet (Client)     ‑‑‑>    SysInetCSS .Name (Client)
111SysInetThemeTable .ToolbarStylesheet (Client)     ‑‑‑>    SysInetCSS .Name (Client)
112SysPersonalization .UserId (Client)     ‑‑‑>    UserInfo .id (Unknown module)
113SysQuickLinks .LinkSubstituteId (Client)     ‑‑‑>    SysQuickLinks .RecId (Client)
114SysQuickLinks .UserId (Client)     ‑‑‑>    UserInfo .id (Unknown module)
115SysQuickLinksOrder .LinkId (Client)     ‑‑‑>    SysQuickLinks .RecId (Client)
116SysQuickLinksOrder .UserId (Client)     ‑‑‑>    UserInfo .id (Unknown module)
117SysSearchName .LanguageId, .Fky? (Client)     ‑‑‑>    LanguageTable .LanguageId, .Pky? (Developer and Partner Tools)
118SysSearchPath .SrcRecId (Client)     ‑‑‑>    Common .RecId (Unknown module)
119SysSearchPath .LanguageId, .Fky? (Client)     ‑‑‑>    LanguageTable .LanguageId, .Pky? (Developer and Partner Tools)
120SysSearchPath .RecId (Client)     ‑‑‑>    SysSearchRef .PathRecId (Client)
121SysSearchRef .NameRecId (Client)     ‑‑‑>    SysSearchName .RecId (Client)
122SysSearchRef .PathRecId (Client)     ‑‑‑>    SysSearchPath .RecId (Client)
123TmpFormLookUp .InventDimId (Client)     ‑‑‑>    InventDim .inventDimId (Inventory and warehouse management)
124TmpFormLookUp .itemId (Client)     ‑‑‑>    InventTable .ItemId (Inventory and warehouse management)
125TmpFormLookUp .MarkupCode_RU, .Fky? (Client)     ‑‑‑>    MarkupTable .MarkupCode, .Pky? (Procurement and sourcing)
126TmpSysQuery .Field_Id, .FieldLabel (Client)     ‑‑‑>    TmpSysQuery .Field_Id, .FieldLabel (Client)
127TmpSysQueryCompanyRange .CompanyId (Client)     ‑‑‑>    DataArea .id (Unknown module)



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