Microsoft Dynamics AX 2012 R2

AxErd: Parent-Children: Client

Module: Client

Navigation:     AxErd_Home    


Row-numParent-table-nameForeign-key-columnsModule-of-parent-tableArrow-to-parentChild-table-namePrimary-key-columnsModule-of-child-table
1ContentType .RecId (Client)     <‑‑‑    DocuValueMetaData .ContentType (Client)
2DocuFileTypes .FileType (Client)     <‑‑‑    DocuTemplate .FileType (Client)
3DocuRef .RecId (Client)     <‑‑‑    DocuOpenFile .RefRecId (Client)
4DocuRef .RecId (Client)     <‑‑‑    DocuRefExt_BR .DocuRef (Global financial management - Latin America)
5DocuRef .RecId, .RefRecId (Client)     <‑‑‑    EcoResProductImage .RefRecId, .RefRecord (Retail)
6DocuRef .RefTableId, .RefRecId (Client)     <‑‑‑    smmActivities .TableId, .RecId (Sales and marketing)
7DocuRef .RefRecId (Client)     <‑‑‑    smmMailings .RecId (Sales and marketing)
8DocuRef .TableId, .RecId (Client)     <‑‑‑    smmTransLog .RefTableId, .RefRecId (Sales and marketing)
9DocuRef .RecId (Client)     <‑‑‑    TrvExpTransLinkReceipts .RefDocuRefRecId (Travel and expense)
10DocuTable .TypeId, .DocuTableId (Client)     <‑‑‑    DocuField .TypeId, .DocuTableId (Client)
11DocuType .TypeId, .Pky? (Client)     <‑‑‑    AxdDocumentParameters .DocuTypeId, .Fky? (Client)
12DocuType .Pky?, .TypeId (Client)     <‑‑‑    BrazilParameters .Fky?, .FiscalDocumentTextDocuTypeId (Global financial management - Latin America)
13DocuType .TypeId, .Pky? (Client)     <‑‑‑    CustFormletterDocument .DocuTypeAgreement, .Fky? (Procurement and sourcing)
14DocuType .TypeId, .Pky? (Client)     <‑‑‑    CustFormletterDocument .DocuTypeConfirm, .Fky? (Procurement and sourcing)
15DocuType .TypeId, .Pky? (Client)     <‑‑‑    CustFormletterDocument .DocuTypeInvoice4Paym_RU, .Fky? (Procurement and sourcing)
16DocuType .TypeId, .Pky? (Client)     <‑‑‑    CustFormletterDocument .DocuTypeFreeTextInvoice, .Fky? (Procurement and sourcing)
17DocuType .TypeId, .Pky? (Client)     <‑‑‑    CustFormletterDocument .DocuTypeInvoice, .Fky? (Procurement and sourcing)
18DocuType .TypeId, .Pky? (Client)     <‑‑‑    CustFormletterDocument .DocuTypePackingSlip, .Fky? (Procurement and sourcing)
19DocuType .TypeId, .Pky? (Client)     <‑‑‑    CustFormletterDocument .DocuTypePickingList, .Fky? (Procurement and sourcing)
20DocuType .TypeId, .Pky? (Client)     <‑‑‑    CustFormletterDocument .DocuTypeQuotation, .Fky? (Procurement and sourcing)
21DocuType .dataAreaId, .TypeId (Client)     <‑‑‑    DocuRef .RefCompanyId, .TypeId (Client)
22DocuType .TypeId (Client)     <‑‑‑    DocuTable .TypeId (Client)
23DocuType .TypeId (Client)     <‑‑‑    DocuTemplate .TypeID (Client)
24DocuType .dataAreaId, .TypeId (Client)     <‑‑‑    EcoResProductParameters .PCDocuTypeDataAreaID, .PCDocuTypeId (Inventory and warehouse management)
25DocuType .TypeId (Client)     <‑‑‑    HRMParameters .applicationEmailDocuTypeId (Human resources)
26DocuType .TypeId (Client)     <‑‑‑    HRMParameters .applicationWordDocuTypeId (Human resources)
27DocuType .TypeId (Client)     <‑‑‑    InventTestCertOfAnalysisTmp .TypeId (Inventory and warehouse management)
28DocuType .TypeId, .Pky? (Client)     <‑‑‑    InventTestReportSetup .DocuTypeIdNote, .Fky? (Inventory and warehouse management)
29DocuType .TypeId (Client)     <‑‑‑    JmgDocumentGroupType .DocuType (Manufacturing)
30DocuType .TypeId, .Pky? (Client)     <‑‑‑    PBAParameters .DocuTypeConfigDetails, .Fky? (Manufacturing)
31DocuType .TypeId, .Pky? (Client)     <‑‑‑    PBAParameters .GraphicOnFormularTypeId, .Fky? (Manufacturing)
32DocuType .TypeId (Client)     <‑‑‑    PBATreeDocRef .TypeId (Manufacturing)
33DocuType .TypeId (Client)     <‑‑‑    ProdJobCardTmp .DocuRef_TypeId (Manufacturing)
34DocuType .TypeId (Client)     <‑‑‑    ProdParameters .ProductionInstructionDocumentType (Manufacturing)
35DocuType .TypeId (Client)     <‑‑‑    ProdRouteCardTmp .DocTypeId (Manufacturing)
36DocuType .TypeId, .Pky? (Client)     <‑‑‑    ProjFormletterDocument .DocuTypeOnInvoice, .Fky? (Project management and accounting)
37DocuType .TypeId, .Pky? (Client)     <‑‑‑    RetailParametersEx1 .ConcessionDocuTypeSales, .Fky? (Retail)
38DocuType .TypeId (Client)     <‑‑‑    smmParametersTable .DocuTypeIdForFiles (Sales and marketing)
39DocuType .TypeId (Client)     <‑‑‑    smmParametersTable .DocuTypeIdForInEMail (Sales and marketing)
40DocuType .TypeId (Client)     <‑‑‑    smmParametersTable .DocuTypeIdForOutEMail (Sales and marketing)
41DocuType .TypeId, .Pky? (Client)     <‑‑‑    VendFormletterDocument .DocuTypeAgreement, .Fky? (Accounts Payable)
42DocuType .TypeId, .Pky? (Client)     <‑‑‑    VendFormletterDocument .DocuTypePurchOrder, .Fky? (Accounts Payable)
43DocuType .TypeId, .Pky? (Client)     <‑‑‑    VendFormletterDocument .DocuTypePurchReq, .Fky? (Accounts Payable)
44DocuType .TypeId, .Pky? (Client)     <‑‑‑    VendFormletterDocument .DocuTypePurchRFQ, .Fky? (Accounts Payable)
45DocuValue .RecId (Client)     <‑‑‑    DocuRef .ValueRecId (Client)
46DocuValue .RecId (Client)     <‑‑‑    DocuValueMetaData .DocuValue (Client)
47SysCue .RecId (Client)     <‑‑‑    SysCueGroupMembership .Cue (Client)
48SysCue .RecId (Client)     <‑‑‑    SysCuePersonalization .Cue (Client)
49SysCue .RecId (Client)     <‑‑‑    SysCueVisibility .Cue (Client)
50SysCueGroup .RecId (Client)     <‑‑‑    SysCueGroupMembership .CueGroup (Client)
51SysCueGroup .RecId (Client)     <‑‑‑    SysCuePersonalization .CueGroup (Client)
52SysInetCSS .Name (Client)     <‑‑‑    SysInetThemeTable .StyleSheet (Client)
53SysInetCSS .Name (Client)     <‑‑‑    SysInetThemeTable .ToolbarStylesheet (Client)
54SysInetThemeTable .Name (Client)     <‑‑‑    SysImageTable .Theme (Client)
55SysInetThemeTable .Name (Client)     <‑‑‑    SysUserInfo .HelpTheme (Server and Tools)
56SysProfiles .ProfileId (Client)     <‑‑‑    SysCueVisibility .Profile (Client)
57SysProfiles .ProfileId (Client)     <‑‑‑    SysUserProfiles .ProfileId (Server and Tools)
58SysQuickLinks .RecId (Client)     <‑‑‑    SysQuickLinks .LinkSubstituteId (Client)
59SysQuickLinks .RecId (Client)     <‑‑‑    SysQuickLinksOrder .LinkId (Client)
60SysSearchName .RecId (Client)     <‑‑‑    SysSearchRef .NameRecId (Client)
61SysSearchPath .RecId (Client)     <‑‑‑    SysSearchRef .PathRecId (Client)
62SysSearchRef .PathRecId (Client)     <‑‑‑    SysSearchPath .RecId (Client)
63TmpSysQuery .Field_Id, .FieldLabel (Client)     <‑‑‑    TmpSysQuery .Field_Id, .FieldLabel (Client)



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