Microsoft Dynamics AX 2012 R2

AxErd: Parent-Children: Project management and accounting

Module: Project management and accounting

Navigation:     AxErd_Home     Previous_File    


Row-numParent-table-nameForeign-key-columnsModule-of-parent-tableArrow-to-parentChild-table-namePrimary-key-columnsModule-of-child-table
1002PSAProjProposalProj .ContractLineNum, .ProjProposalId, .ProjId (Project management and accounting)     <‑‑‑    PSAProjProposalRetain .ContractLineNum, .ProposalId, .ProjId (Project management and accounting)
1003PSAProjProposalProj .ProjId (Project management and accounting)     <‑‑‑    PSATmpProjTotals .ProjId (Project management and accounting)
1004PSASchedEmplReservation .dataAreaId, .RecId (Project management and accounting)     <‑‑‑    PSATmpSchedEmplReservation .ReservationDataAreaId, .ReservationRecId (Project management and accounting)
1005PSASchedRole .RoleId (Project management and accounting)     <‑‑‑    PSAActivityProjProject .Role (Project management and accounting)
1006PSASchedRole .RoleId (Project management and accounting)     <‑‑‑    PSATmpActivityProjProject .Role (Project management and accounting)
1007PSASchedRole .RoleId (Project management and accounting)     <‑‑‑    PSATmpResourceProject .Role (Project management and accounting)
1008PSATmpProjProposalSummary .RecId, .RecId (Project management and accounting)     <‑‑‑    PSATmpProjProposalTrans .RefRecIdCat, .RefRecId (Project management and accounting)
1009PSATmpRetentionInquiryHeader .RecId (Project management and accounting)     <‑‑‑    PSATmpRetentionReleaseTable .RefRecId (Project management and accounting)
1010PSATmpRetentionReleaseTable .RecId (Project management and accounting)     <‑‑‑    PSATmpRetentionReleaseLine .RefRecId (Project management and accounting)
1011PSATmpSchedEmplCalendar .Worker, .TransDate (Project management and accounting)     <‑‑‑    PSATmpSchedEmplCalendarDetail .Worker, .TransDate (Project management and accounting)
1012PSATmpSchedEmplReservation .RecId (Project management and accounting)     <‑‑‑    PSATmpSchedEmplReservation .RefRecId (Project management and accounting)
1013PSATmpSchedEmplResource .QuotationId, .ActivityNumber, .ProjId, .WorkerLegalEntity, .Worker (Project management and accounting)     <‑‑‑    PSATmpSchedEmplCalendar .QuotationId, .ActivityNumber, .ProjId, .WorkerLegalEntity, .Worker (Project management and accounting)
1014PSATmpSchedEmplResource .Worker (Project management and accounting)     <‑‑‑    PSATmpSchedEmplCapacity .Worker (Project management and accounting)
1015PSATmpSchedMgrEmplResource .Worker (Project management and accounting)     <‑‑‑    PSATmpResourceAttribute .Worker (Project management and accounting)
1016PSATmpSchedMgrEmplResource .Worker (Project management and accounting)     <‑‑‑    PSATmpResourceCertificate .Worker (Project management and accounting)
1017PSATmpSchedMgrEmplResource .Worker (Project management and accounting)     <‑‑‑    PSATmpResourceEducation .Worker (Project management and accounting)
1018PSATmpSchedMgrEmplResource .Worker (Project management and accounting)     <‑‑‑    PSATmpResourceSkill .Worker (Project management and accounting)
1019PSATmpSchedMgrEmplResource .Worker (Project management and accounting)     <‑‑‑    PSATmpSchedEmplCalendar .Worker (Project management and accounting)
1020PSATmpSchedMgrProjActivity .RefRecId, .RefTableId (Project management and accounting)     <‑‑‑    PSATmpActivityProjAttribute .RefRecId, .RefTableId (Project management and accounting)
1021PSATmpSchedMgrProjActivity .RefTableId, .RefRecId (Project management and accounting)     <‑‑‑    PSATmpActivityProjCertificate .RefTableId, .RefRecId (Project management and accounting)
1022PSATmpSchedMgrProjActivity .RefTableId, .RefRecId (Project management and accounting)     <‑‑‑    PSATmpActivityProjEducation .RefTableId, .RefRecId (Project management and accounting)
1023PSATmpSchedMgrProjActivity .RefRecId, .RefTableId (Project management and accounting)     <‑‑‑    PSATmpActivityProjProject .RefRecId, .RefTableId (Project management and accounting)
1024PSATmpSchedMgrProjActivity .RefTableId, .RefRecId (Project management and accounting)     <‑‑‑    PSATmpActivityProjReqImportance .RefTableId, .RefRecId (Project management and accounting)
1025PSATmpSchedMgrProjActivity .RefRecId, .RefTableId (Project management and accounting)     <‑‑‑    PSATmpActivityProjSkill .RefRecId, .RefTableId (Project management and accounting)
1026PSATmpSchedMgrProjActivity .RecId, .TableId (Project management and accounting)     <‑‑‑    PSATmpSchedMgrProjActivity .RefRecId, .RefTableId (Project management and accounting)
1027PSATmpSchedProjActivity .RecId, .TableId (Project management and accounting)     <‑‑‑    PSAActivityProjReqImportance .RefRecId, .RefTableId (Project management and accounting)
1028PSATmpSchedProjActivity .RefTableId, .RefRecId (Project management and accounting)     <‑‑‑    PSATmpActivityProjAttribute .RefTableId, .RefRecId (Project management and accounting)
1029PSATmpSchedProjActivity .RefTableId, .RefRecId (Project management and accounting)     <‑‑‑    PSATmpActivityProjCertificate .RefTableId, .RefRecId (Project management and accounting)
1030PSATmpSchedProjActivity .RefTableId, .RefRecId (Project management and accounting)     <‑‑‑    PSATmpActivityProjEducation .RefTableId, .RefRecId (Project management and accounting)
1031PSATmpSchedProjActivity .RefTableId, .RefRecId (Project management and accounting)     <‑‑‑    PSATmpActivityProjProject .RefTableId, .RefRecId (Project management and accounting)
1032PSATmpSchedProjActivity .RefTableId, .RefRecId (Project management and accounting)     <‑‑‑    PSATmpActivityProjReqImportance .RefTableId, .RefRecId (Project management and accounting)
1033PSATmpSchedProjActivity .RefTableId, .RefRecId (Project management and accounting)     <‑‑‑    PSATmpActivityProjSkill .RefTableId, .RefRecId (Project management and accounting)
1034PSATmpSchedProjActivity .QuotationId, .ProjId, .ActivityNumber (Project management and accounting)     <‑‑‑    PSATmpSchedEmplResource .QuotationId, .ProjId, .ActivityNumber (Project management and accounting)
1035PSATmpVendInvoiceTable .RecId (Project management and accounting)     <‑‑‑    PSATmpVendInvoiceLines .PSATmpVendInvoiceTableRecId (Project management and accounting)
1036PSAVendorRetentionTermsTable .VendorRetentionTermId (Project management and accounting)     <‑‑‑    ProjPWPVendorRetentionSetting .RuleId (Project management and accounting)
1037PSAVendorRetentionTermsTable .VendorRetentionTermId (Project management and accounting)     <‑‑‑    PSAVendorRetentionTermsLine .VendorRetentionTermId (Project management and accounting)
1038PSAVendorRetentionTermsTable .VendorRetentionTermId (Project management and accounting)     <‑‑‑    PurchLine .PSARetainScheduleId (Procurement and sourcing)
1039SyncApp .AppId (Project management and accounting)     <‑‑‑    SyncActivityCategoryLookup .AppId (Project management and accounting)
1040SyncApp .AppId (Project management and accounting)     <‑‑‑    SyncAppCompany .AppId (Project management and accounting)
1041SyncApp .AppId (Project management and accounting)     <‑‑‑    SyncCompanyLookup .AppId (Project management and accounting)
1042SyncApp .AppId (Project management and accounting)     <‑‑‑    SyncCompoundDataTrans .SourceAppId (Project management and accounting)
1043SyncApp .AppId (Project management and accounting)     <‑‑‑    SyncCompoundDataTrans .TargetAppId (Project management and accounting)
1044SyncApp .AppId (Project management and accounting)     <‑‑‑    SyncCompoundTrans .OriginAppId (Project management and accounting)
1045SyncApp .AppId (Project management and accounting)     <‑‑‑    SyncCompoundType .MasterAppId (Project management and accounting)
1046SyncApp .AppId (Project management and accounting)     <‑‑‑    SyncCustTableLookup .AppId (Project management and accounting)
1047SyncApp .AppId (Project management and accounting)     <‑‑‑    SyncHierarchyTreeTable .AppId (Project management and accounting)
1048SyncApp .AppId (Project management and accounting)     <‑‑‑    SyncIntegratedFields .AppId (Project management and accounting)
1049SyncApp .AppId (Project management and accounting)     <‑‑‑    SyncProjActivityAssignment .AppId (Project management and accounting)
1050SyncApp .AppId (Project management and accounting)     <‑‑‑    SyncProjGroupLookup .AppId (Project management and accounting)
1051SyncApp .AppId (Project management and accounting)     <‑‑‑    SyncProjInvoiceTableLookup .AppId (Project management and accounting)
1052SyncApp .AppId (Project management and accounting)     <‑‑‑    SyncProjResource .AppId (Project management and accounting)
1053SyncApp .AppId (Project management and accounting)     <‑‑‑    SyncProjStatusLookup .AppId (Project management and accounting)
1054SyncApp .AppId (Project management and accounting)     <‑‑‑    SyncProjTable .AppId (Project management and accounting)
1055SyncApp .AppId (Project management and accounting)     <‑‑‑    SyncProjTransaction .AppId (Project management and accounting)
1056SyncApp .AppId (Project management and accounting)     <‑‑‑    SyncProjTypeLookup .AppId (Project management and accounting)
1057SyncApp .AppId (Project management and accounting)     <‑‑‑    SyncSimpleTrans .AppId (Project management and accounting)
1058SyncApp .AppId (Project management and accounting)     <‑‑‑    SyncWrkCtrTable .AppId (Project management and accounting)
1059SyncCompoundDataTrans .SyncTransId (Project management and accounting)     <‑‑‑    SyncCompoundDependTrans .SyncTransId (Project management and accounting)
1060SyncCompoundDataTrans .SyncTransId (Project management and accounting)     <‑‑‑    SyncErrorDataTrans .SyncTransId (Project management and accounting)
1061SyncCompoundTrans .SyncEntityId (Project management and accounting)     <‑‑‑    SyncCompoundDataTrans .SyncEntityId (Project management and accounting)
1062SyncCompoundTrans .SyncEntityId (Project management and accounting)     <‑‑‑    SyncSimpleTrans .SyncEntityId (Project management and accounting)
1063TmpProjAdjustment .TransId (Project management and accounting)     <‑‑‑    TmpProjAdjustmentCreate .TransID (Project management and accounting)
1064TmpProjAdjustmentCreate .RecId (Project management and accounting)     <‑‑‑    TmpProjAdjustmentCreateCost .RefRecId (Project management and accounting)
1065TmpProjAdjustmentCreate .RecId (Project management and accounting)     <‑‑‑    TmpProjAdjustmentCreateSale .RefRecId (Project management and accounting)
1066TmpProjControlActual .TransId (Project management and accounting)     <‑‑‑    ProjTransPosting .TransId (Project management and accounting)
1067TmpProjInvoiceLine .RecId (Project management and accounting)     <‑‑‑    TmpProjInvoiceLineSettleBy .RefRecId (Project management and accounting)
1068TmpProjPeriodic .transId (Project management and accounting)     <‑‑‑    TmpProjPeriodicCost .transId (Project management and accounting)
1069TmpProjPeriodic .transId, .transType (Project management and accounting)     <‑‑‑    TmpProjPeriodicLedger .TransId, .TransType (Project management and accounting)
1070TmpProjPeriodic .transId (Project management and accounting)     <‑‑‑    TmpProjPeriodicSale .transId (Project management and accounting)
1071TmpProjStatistic .Pky?, .transId (Project management and accounting)     <‑‑‑    TmpProjStatistic .Fky?, .transId (Project management and accounting)
1072TmpProjStatisticLink .TransId (Project management and accounting)     <‑‑‑    PSATmpProjFinancialStatistic .TransId (Project management and accounting)
1073TmpProjStatisticLink .Pky?, .TransId (Project management and accounting)     <‑‑‑    TmpProjStatistic .Fky?, .transId (Project management and accounting)



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