Microsoft Dynamics AX 2012 R2

AxErd: Parent-Children: Service management

Module: Service management

Navigation:     AxErd_Home    


Row-numParent-table-nameForeign-key-columnsModule-of-parent-tableArrow-to-parentChild-table-namePrimary-key-columnsModule-of-child-table
1SMAAgreementGroup .AgreementGroup (Service management)     <‑‑‑    SMAAgreementTable .AgreementGroupId (Service management)
2SMAAgreementGroup .AgreementGroup (Service management)     <‑‑‑    SMAParameters .AgreementGroupId (Service management)
3SMAAgreementInterval .IntervalId (Service management)     <‑‑‑    InventSiteDimensionLinkValidationTmp .SMAALIntervalId (Inventory and warehouse management)
4SMAAgreementInterval .IntervalId (Service management)     <‑‑‑    SMAAgreementLine .IntervalId (Service management)
5SMAAgreementLine .TableId, .AgreementId, .ServiceObjectRelationId (Service management)     <‑‑‑    SMAServiceObjectRelation .RelTableId, .RelKeyId, .ServiceObjectRelationId (Service management)
6SMAAgreementLine .TableId, .AgreementId, .ServiceTaskId (Service management)     <‑‑‑    SMAServiceTaskRelation .RelTableId, .RelKeyId, .ServiceTaskId (Service management)
7SMAAgreementTable .AgreementId (Service management)     <‑‑‑    GanttTmpSMA .AgreementId (Manufacturing)
8SMAAgreementTable .AgreementId (Service management)     <‑‑‑    InventSiteDimensionLinkValidationTmp .SMAALAgreementId (Inventory and warehouse management)
9SMAAgreementTable .AgreementId (Service management)     <‑‑‑    SalesQuotationTable .ServiceId (Procurement and sourcing)
10SMAAgreementTable .AgreementId (Service management)     <‑‑‑    SMAAgreementLine .AgreementId (Service management)
11SMAAgreementTable .AgreementId (Service management)     <‑‑‑    SMAPreServiceOrderLine .AgreementId (Service management)
12SMAAgreementTable .AgreementId, .TableId (Service management)     <‑‑‑    SMAServiceObjectRelation .RelKeyId, .RelTableId (Service management)
13SMAAgreementTable .AgreementId (Service management)     <‑‑‑    SMAServiceOrderLine .AgreementId (Service management)
14SMAAgreementTable .AgreementId (Service management)     <‑‑‑    SMAServiceOrderTable .AgreementId (Service management)
15SMAAgreementTable .TableId, .AgreementId (Service management)     <‑‑‑    SMAServiceTaskRelation .RelTableId, .RelKeyId (Service management)
16SMAAgreementTable .AgreementId (Service management)     <‑‑‑    SMAWorkNoteTmp .OTAgreementId (Service management)
17SMAConditionTable .ConditionId (Service management)     <‑‑‑    SMARepairLine .ConditionId (Service management)
18SMADiagnosisArea .DiagnosisAreaId (Service management)     <‑‑‑    SMADiagnosisCode .DiagnosisAreaId (Service management)
19SMADiagnosisArea .DiagnosisAreaId (Service management)     <‑‑‑    SMARepairLine .DiagnosisAreaId (Service management)
20SMADiagnosisCode .DiagnosisAreaId, .DiagnosisCodeId (Service management)     <‑‑‑    SMARepairLine .DiagnosisAreaId, .DiagnosisCodeId (Service management)
21SMADispatchTeamTable .DispatchTeamId (Service management)     <‑‑‑    GanttTmpSMA .DispatchTeamId (Manufacturing)
22SMADispatchTeamTable .dataAreaId, .DispatchTeamId (Service management)     <‑‑‑    SMADispatchWorkerSetup .DispatchTeamDataAreaId, .DispatchTeamId (Service management)
23SMAReasonTable .ReasonId (Service management)     <‑‑‑    SMAServiceLevelAgreementReason .ReasonId (Service management)
24SMAReasonTable .ReasonId (Service management)     <‑‑‑    SMAServiceOrderReason .ReasonId (Service management)
25SMARepairStage .RepairStageId (Service management)     <‑‑‑    SMARepairLine .RepairStageId (Service management)
26SMAResolutionTable .ResolutionId (Service management)     <‑‑‑    SMARepairLine .ResolutionId (Service management)
27SMAServiceBOMTable .Pky?, .ServiceBOMLineId (Service management)     <‑‑‑    SMAServiceBOMChange .Fky?, .ActiveServiceBOMLineId (Service management)
28SMAServiceLevelAgreementTable .ServiceLevelAgreementId (Service management)     <‑‑‑    CaseCategoryHierarchyDetail .ServiceLevelAgreementId (Sales and marketing)
29SMAServiceLevelAgreementTable .ServiceLevelAgreementId (Service management)     <‑‑‑    CaseDetail .ServiceLevelAgreementId (Sales and marketing)
30SMAServiceLevelAgreementTable .ServiceLevelAgreementId (Service management)     <‑‑‑    GanttTmpSMA .ServiceLevelAgreement (Manufacturing)
31SMAServiceLevelAgreementTable .ServiceLevelAgreementId (Service management)     <‑‑‑    SMAAgreementGroup .ServiceLevelAgreementId (Service management)
32SMAServiceLevelAgreementTable .ServiceLevelAgreementId (Service management)     <‑‑‑    SMAAgreementTable .ServiceLevelAgreementId (Service management)
33SMAServiceLevelAgreementTable .ServiceLevelAgreementId (Service management)     <‑‑‑    SMAServiceOrderTable .ServiceLevelAgreement (Service management)
34SMAServiceLevelAgreementTable .ServiceLevelAgreementId (Service management)     <‑‑‑    SMAWorkNoteTmp .OTServiceLevelAgreement (Service management)
35SMAServiceObjectGroup .ServiceObjectGroup (Service management)     <‑‑‑    SMAServiceObjectTable .ServiceObjectGroup (Service management)
36SMAServiceObjectRelation .ServiceObjectRelationId (Service management)     <‑‑‑    SMAAgreementLine .ServiceObjectRelationId (Service management)
37SMAServiceObjectRelation .RelKeyId, .RelTableId (Service management)     <‑‑‑    SMAAgreementTable .AgreementId, .TableId (Service management)
38SMAServiceObjectRelation .ServiceObjectRelationId (Service management)     <‑‑‑    SMAPreServiceOrderLine .ServiceObjectRelationId (Service management)
39SMAServiceObjectRelation .ServiceObjectRelationId (Service management)     <‑‑‑    SMARepairLine .ServiceObjectRelationId (Service management)
40SMAServiceObjectRelation .ServiceObjectRelationId (Service management)     <‑‑‑    SMARepairLine .ServiceObjectRelationId (Service management)
41SMAServiceObjectRelation .ServiceObjectRelationId (Service management)     <‑‑‑    SMAServiceBOMChange .ServiceObjectRelationId (Service management)
42SMAServiceObjectRelation .ServiceObjectRelationId (Service management)     <‑‑‑    SMAServiceBOMTable .ServiceObjectRelationId (Service management)
43SMAServiceObjectRelation .ServiceObjectRelationId (Service management)     <‑‑‑    SMAServiceOrderLine .ServiceObjectRelationId (Service management)
44SMAServiceObjectRelation .RelKeyId, .RelTableId (Service management)     <‑‑‑    SMAServiceOrderTable .ServiceOrderId, .TableId (Service management)
45SMAServiceObjectTable .ServiceObjectId (Service management)     <‑‑‑    InventSiteDimensionLinkValidationTmp .SMAALServiceObjectId (Inventory and warehouse management)
46SMAServiceObjectTable .ServiceObjectId (Service management)     <‑‑‑    SMAAgreementLine .ServiceObjectId (Service management)
47SMAServiceObjectTable .ServiceObjectId (Service management)     <‑‑‑    SMAPreServiceOrderLine .ServiceObjectId (Service management)
48SMAServiceObjectTable .ServiceObjectId (Service management)     <‑‑‑    SMARepairLine .ServiceObjectId (Service management)
49SMAServiceObjectTable .ServiceObjectId (Service management)     <‑‑‑    SMAServiceBOMChange .ObjectId (Service management)
50SMAServiceObjectTable .ServiceObjectId (Service management)     <‑‑‑    SMAServiceBOMTable .ObjectId (Service management)
51SMAServiceObjectTable .ServiceObjectId (Service management)     <‑‑‑    SMAServiceObjectRelation .ServiceObjectId (Service management)
52SMAServiceObjectTable .ServiceObjectId (Service management)     <‑‑‑    SMAServiceOrderLine .ServiceObjectId (Service management)
53SMAServiceObjectTable .ServiceObjectId (Service management)     <‑‑‑    SMAWorkNoteTmp .OLServiceObjectId (Service management)
54SMAServiceObjectTable .ServiceObjectId (Service management)     <‑‑‑    tmpSMAAgreementObjects .ServiceObjectId (Service management)
55SMAServiceOrderLine .ItemId (Service management)     <‑‑‑    BOMCalcTable .ItemId (Manufacturing)
56SMAServiceOrderLine .AgreementId, .AgreementLineNum (Service management)     <‑‑‑    SMAAgreementLine .AgreementId, .AgreementLineNum (Service management)
57SMAServiceOrderLine .DateCalculated, .AgreementLineNum, .AgreementId (Service management)     <‑‑‑    SMAPreServiceOrderLine .DateCalculated, .AgreementLineNum, .AgreementId (Service management)
58SMAServiceOrderLine .TableId, .ServiceOrderId, .ServiceObjectRelationId (Service management)     <‑‑‑    SMAServiceObjectRelation .RelTableId, .RelKeyId, .ServiceObjectRelationId (Service management)
59SMAServiceOrderLine .RecId (Service management)     <‑‑‑    SMAServiceOrderLineTaxExtension_IN .ServiceOrder (Global financial management - Asia Pacific)
60SMAServiceOrderLine .TableId, .ServiceOrderId, .ServiceTaskId (Service management)     <‑‑‑    SMAServiceTaskRelation .RelTableId, .RelKeyId, .ServiceTaskId (Service management)
61SMAServiceOrderLine .Pky?, .RecId (Service management)     <‑‑‑    smmActivityParentLinkTable .Fky?, .RefRecId (Sales and marketing)
62SMAServiceOrderTable .RecId, .Pky? (Service management)     <‑‑‑    CaseAssociation .RefRecId, .Fky? (Sales and marketing)
63SMAServiceOrderTable .ServiceOrderId (Service management)     <‑‑‑    GanttTmpSMA .ServiceOrderId (Manufacturing)
64SMAServiceOrderTable .ServiceOrderId (Service management)     <‑‑‑    InventSiteDimensionLinkValidationTmp .SMASOLServiceOrderId (Inventory and warehouse management)
65SMAServiceOrderTable .ServiceOrderId (Service management)     <‑‑‑    SalesLine .ServiceOrderId (Procurement and sourcing)
66SMAServiceOrderTable .ServiceOrderId (Service management)     <‑‑‑    SMAPreServiceOrderLine .ServiceOrderId (Service management)
67SMAServiceOrderTable .ServiceOrderId (Service management)     <‑‑‑    SMARepairLine .ServiceOrderId (Service management)
68SMAServiceOrderTable .ServiceOrderId (Service management)     <‑‑‑    SMAServiceBOMChange .ServiceOrderId (Service management)
69SMAServiceOrderTable .ServiceOrderId (Service management)     <‑‑‑    SMAServiceLevelAgreementLog .ServiceOrderId (Service management)
70SMAServiceOrderTable .ServiceOrderId, .TableId (Service management)     <‑‑‑    SMAServiceObjectRelation .RelKeyId, .RelTableId (Service management)
71SMAServiceOrderTable .ServiceOrderId (Service management)     <‑‑‑    SMAServiceOrderLine .ServiceOrderId (Service management)
72SMAServiceOrderTable .ServiceOrderId (Service management)     <‑‑‑    SMAServiceOrderReason .ServiceOrderId (Service management)
73SMAServiceOrderTable .TableId, .ServiceOrderId (Service management)     <‑‑‑    SMAServiceTaskRelation .RelTableId, .RelKeyId (Service management)
74SMAServiceOrderTable .StageId (Service management)     <‑‑‑    SMAStageTable .StageId (Service management)
75SMAServiceOrderTable .ServiceOrderId (Service management)     <‑‑‑    SMAWorkNoteTmp .SEFTVisibility (Service management)
76SMAServiceOrderTable .ServiceOrderId (Service management)     <‑‑‑    SMAWorkNoteTmp .SOlVisibility (Service management)
77SMAServiceOrderTable .ServiceOrderId (Service management)     <‑‑‑    SMAWorkNoteTmp .SITVisibility (Service management)
78SMAServiceOrderTable .ServiceOrderId (Service management)     <‑‑‑    SMAWorkNoteTmp .SLServiceOrderId (Service management)
79SMAServiceOrderTable .ServiceOrderId (Service management)     <‑‑‑    SMAWorkNoteTmp .OTServiceOrderId (Service management)
80SMAServiceOrderTable .ServiceOrderId (Service management)     <‑‑‑    SMAWorkNoteTmp .STAServiceOrderId (Service management)
81SMAServiceOrderTable .ServiceOrderId (Service management)     <‑‑‑    SMAWorkNoteTmp .STServiceOrderId (Service management)
82SMAServiceOrderTable .Pky?, .RecId (Service management)     <‑‑‑    smmActivityParentLinkTable .Fky?, .RefRecId (Sales and marketing)
83SMAServiceTask .ServiceTaskId (Service management)     <‑‑‑    InventSiteDimensionLinkValidationTmp .SMAALServiceTaskId (Inventory and warehouse management)
84SMAServiceTask .ServiceTaskId (Service management)     <‑‑‑    SMAAgreementLine .ServiceTaskId (Service management)
85SMAServiceTask .ServiceTaskId (Service management)     <‑‑‑    SMAPreServiceOrderLine .ServiceTaskId (Service management)
86SMAServiceTask .ServiceTaskId (Service management)     <‑‑‑    SMAServiceOrderLine .ServiceTaskId (Service management)
87SMAServiceTask .ServiceTaskId (Service management)     <‑‑‑    SMAServiceTaskRelation .ServiceTaskId (Service management)
88SMAServiceTask .ServiceTaskId (Service management)     <‑‑‑    SMAWorkNoteTmp .OLServiceLineTaskId (Service management)
89SMAServiceTask .ServiceTaskId (Service management)     <‑‑‑    SMAWorkNoteTmp .TRServiceTaskId (Service management)
90SMAServiceTask .ServiceTaskId (Service management)     <‑‑‑    SMAWorkNoteTmp .TRSTAServiceTaskId (Service management)
91SMAServiceTaskRelation .RelKeyId, .RelTableId (Service management)     <‑‑‑    SMAAgreementTable .AgreementId, .TableId (Service management)
92SMAServiceTaskRelation .RelKeyId, .RelTableId (Service management)     <‑‑‑    SMAServiceOrderTable .ServiceOrderId, .TableId (Service management)
93SMAStageTable .StageId (Service management)     <‑‑‑    CaseDetail .StageId (Sales and marketing)
94SMAStageTable .StageId (Service management)     <‑‑‑    SMAParameters .ServiceLineActivityStage (Service management)
95SMAStageTable .StageId (Service management)     <‑‑‑    SMAServiceLevelAgreementReason .StageId (Service management)
96SMAStageTable .StageId (Service management)     <‑‑‑    SMAServiceOrderReason .StageId (Service management)
97SMAStageTable .StageId (Service management)     <‑‑‑    SMAServiceOrderTable .StageId (Service management)
98SMAStageTable .StageId (Service management)     <‑‑‑    SMAStageTable .ParentStageId (Service management)
99SMASubscriptionGroup .GroupId (Service management)     <‑‑‑    SMASubscriptionTable .GroupId (Service management)
100SMASubscriptionTable .SubscriptionId (Service management)     <‑‑‑    ProjInvoiceLocalizationTmp .SMASubscriptionId (Project management and accounting)
101SMASubscriptionTable .SubscriptionId (Service management)     <‑‑‑    ProjInvoiceRevenue .SMASubscriptionId (Project management and accounting)
102SMASubscriptionTable .SubscriptionId (Service management)     <‑‑‑    ProjInvoiceTmp .SMASubscriptionId (Project management and accounting)
103SMASubscriptionTable .SubscriptionId (Service management)     <‑‑‑    ProjRevenueTrans .SMASubscriptionId (Project management and accounting)
104SMASubscriptionTable .SubscriptionId (Service management)     <‑‑‑    ProjTransBudget .SubscriptionId (Project management and accounting)
105SMASubscriptionTable .SubscriptionId, .Pky?, .Pky? (Service management)     <‑‑‑    ProjTransPosting .SubscriptionId, .Fky?, .Fky? (Project management and accounting)
106SMASubscriptionTable .SubscriptionId (Service management)     <‑‑‑    SMASalesPriceSubscription .SMASubscriptionId (Service management)
107SMASubscriptionTable .SubscriptionId (Service management)     <‑‑‑    TmpProjCashFlowExcelPivot .SubscriptionId (Project management and accounting)
108SMASubscriptionTable .SubscriptionId (Service management)     <‑‑‑    TmpProjCostControlExcelPivot .SubscriptionId (Project management and accounting)
109SMASubscriptionTable .SubscriptionId (Service management)     <‑‑‑    TmpProjHourUtilExcelPivot .SubscriptionId (Project management and accounting)
110SMASubscriptionTable .SubscriptionId (Service management)     <‑‑‑    TmpProjInvoiceControlExcelPivot .SubscriptionId (Project management and accounting)
111SMASubscriptionTable .SubscriptionId (Service management)     <‑‑‑    TmpProjStatisticExcelPivot .SubscriptionId (Project management and accounting)
112SMASymptomArea .SymptomAreaId (Service management)     <‑‑‑    SMARepairLine .SymptomAreaId (Service management)
113SMASymptomArea .SymptomAreaId (Service management)     <‑‑‑    SMASymptomCode .SMASymptomAreaId (Service management)
114SMASymptomCode .SMASymptomAreaId, .SMASymptomCodeId (Service management)     <‑‑‑    SMARepairLine .SymptomAreaId, .SymptomCodeId (Service management)
115SMASymptomCode .SMASymptomCodeId (Service management)     <‑‑‑    SMASymptomCode .SMASymptomCodeId (Service management)
116SMATemplateBOMTable .TemplateBOMId (Service management)     <‑‑‑    SMAServiceBOMChange .ServiceBOMId (Service management)
117SMATemplateBOMTable .TemplateBOMId (Service management)     <‑‑‑    SMAServiceBOMTable .ServiceBOMId (Service management)
118SMATemplateBOMTable .TemplateBOMId (Service management)     <‑‑‑    SMAServiceObjectRelation .TemplateBOMId (Service management)
119SMATemplateBOMTable .TemplateBOMId (Service management)     <‑‑‑    SMAServiceObjectTable .TemplateBOMId (Service management)
120SMATemplateBOMTable .Pky?, .TemplateBOMId (Service management)     <‑‑‑    SMATemplateBOMTable .Fky?, .BOMCopyRefId (Service management)
121SMATemplateBOMTable .TemplateBOMId (Service management)     <‑‑‑    tmpSMAAgreementObjects .TemplateBOMId (Service management)
122SMATemplateGroup .TemplateGroupId (Service management)     <‑‑‑    SMAAgreementTable .TemplateGroupId (Service management)
123SMATemplateGroup .TemplateGroupId (Service management)     <‑‑‑    SMATemplateGroup .ParentTemplateGroupId (Service management)
124SMATimeAgreement .TimeAgreementId (Service management)     <‑‑‑    InventSiteDimensionLinkValidationTmp .SMAALTimeAgreementId (Inventory and warehouse management)
125SMATimeAgreement .TimeAgreementId (Service management)     <‑‑‑    SMAAgreementLine .TimeAgreementId (Service management)
126SMATimeAgreement .TimeAgreementId (Service management)     <‑‑‑    SMAPreServiceOrderLine .TimeAgreementId (Service management)



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