Microsoft Dynamics AX 2012 R2

AxErd: Child-Parents: Travel and expense

Module: Travel and expense

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
201TrvWorkflowExpProviderCache .AccountingDistribution (Travel and expense)     ‑‑‑>    AccountingDistribution .RecId (General ledger)
202TrvWorkflowExpProviderCache .TrvExpTable (Travel and expense)     ‑‑‑>    TrvExpTable .RecId (Travel and expense)
203TrvWorkflowExpProviderCache .TrvExpTrans (Travel and expense)     ‑‑‑>    TrvExpTrans .RecId (Travel and expense)
204TrvWorkflowExpProviderCache .WorkflowUser (Travel and expense)     ‑‑‑>    UserInfo .id (Unknown module)
205TrvWorkflowLog .ApprovedByWorker (Travel and expense)     ‑‑‑>    HcmWorker .RecId (Human resources)
206TrvWorkflowLog .RejectedByWorker (Travel and expense)     ‑‑‑>    HcmWorker .RecId (Human resources)
207TrvWorkflowLog .ExpHeaderRecId (Travel and expense)     ‑‑‑>    TrvExpTable .RecId (Travel and expense)
208TrvWorkflowLog .ExpLineRecId (Travel and expense)     ‑‑‑>    TrvExpTrans .RecId (Travel and expense)
209TSAppEmplSub .AppWorker (Travel and expense)     ‑‑‑>    HcmWorker .RecId (Human resources)
210TSAppEmplSub .Worker (Travel and expense)     ‑‑‑>    HcmWorker .RecId (Human resources)
211TSAppEmplSub .Worker (Travel and expense)     ‑‑‑>    TSTimesheetTable .Worker (Travel and expense)
212TSIntercompanyCost .SourceDocumentHeader (Travel and expense)     ‑‑‑>    SourceDocumentHeader .RecId (General ledger)
213TSIntercompanyCost .TSTimesheetTable (Travel and expense)     ‑‑‑>    TSTimesheetTable .RecId (Travel and expense)
214TSIntercompanyCostDetails .Currency (Travel and expense)     ‑‑‑>    Currency .RecId (General ledger)
215TSIntercompanyCostDetails .SourceDocumentLine (Travel and expense)     ‑‑‑>    SourceDocumentLine .RecId (General ledger)
216TSIntercompanyCostDetails .TSIntercompanyCost (Travel and expense)     ‑‑‑>    TSIntercompanyCost .RecId (Travel and expense)
217TSIntercompanyCostDetails .TSTimesheetTrans (Travel and expense)     ‑‑‑>    TSTimesheetTrans .RecId (Travel and expense)
218TSTimesheetEmployeeFilter .Worker (Travel and expense)     ‑‑‑>    HcmWorker .RecId (Human resources)
219TSTimesheetEmployeeFilter .UserId (Travel and expense)     ‑‑‑>    UserInfo .id (Unknown module)
220TSTimesheetFavorites .Worker (Travel and expense)     ‑‑‑>    HcmWorker .RecId (Human resources)
221TSTimesheetFavorites .Fky?, .Worker (Travel and expense)     ‑‑‑>    HcmWorker .Pky?, .RecId (Human resources)
222TSTimesheetFavorites .CategoryId (Travel and expense)     ‑‑‑>    ProjCategory .CategoryId (Project management and accounting)
223TSTimesheetFavorites .ProjId (Travel and expense)     ‑‑‑>    ProjTable .ProjId (Project management and accounting)
224TSTimesheetFavorites .ProjValEmplGroup (Travel and expense)     ‑‑‑>    ProjValEmplProjTable .GroupId (Project management and accounting)
225TSTimesheetFavorites .ActivityNumber (Travel and expense)     ‑‑‑>    smmActivities .ActivityNumber (Sales and marketing)
226TSTimesheetLine .CurrencyCode (Travel and expense)     ‑‑‑>    Currency .CurrencyCode (General ledger)
227TSTimesheetLine .DefaultDimension (Travel and expense)     ‑‑‑>    DimensionAttributeValueSet .RecId (General ledger)
228TSTimesheetLine .Worker (Travel and expense)     ‑‑‑>    HcmWorker .RecId (Human resources)
229TSTimesheetLine .CategoryId, .Fky? (Travel and expense)     ‑‑‑>    ProjCategory .CategoryId, .Pky? (Project management and accounting)
230TSTimesheetLine .TransIdRef (Travel and expense)     ‑‑‑>    ProjEmplTrans .TransId (Project management and accounting)
231TSTimesheetLine .ProjectDataAreaId, .LinePropertyId (Travel and expense)     ‑‑‑>    ProjLineProperty .dataAreaId, .LinePropertyId (Project management and accounting)
232TSTimesheetLine .ProjPeriodTimesheetWeek (Travel and expense)     ‑‑‑>    ProjPeriodTimesheetWeek .RecId (Project management and accounting)
233TSTimesheetLine .ProjId (Travel and expense)     ‑‑‑>    ProjTable .ProjId (Project management and accounting)
234TSTimesheetLine .ActivityNumber (Travel and expense)     ‑‑‑>    smmActivities .ActivityNumber (Sales and marketing)
235TSTimesheetLine .TaxGroupId (Travel and expense)     ‑‑‑>    TaxGroupHeading .TaxGroup (Tax)
236TSTimesheetLine .TaxItemGroup (Travel and expense)     ‑‑‑>    TaxItemGroupHeading .TaxItemGroup (Tax)
237TSTimesheetLine .TimesheetNbr (Travel and expense)     ‑‑‑>    TSTimesheetTable .TimesheetNbr (Travel and expense)
238TSTimesheetLine .WrkCtrId, .Fky? (Travel and expense)     ‑‑‑>    WrkCtrTable .WrkCtrId, .Pky? (Manufacturing)
239TSTimesheetLineComments .TSTimesheetLineWeek (Travel and expense)     ‑‑‑>    TSTimesheetLineWeek .RecId (Travel and expense)
240TSTimesheetLineWeek .JournalId (Travel and expense)     ‑‑‑>    ProjJournalTable .JournalId (Project management and accounting)
241TSTimesheetLineWeek .ProjPeriodId (Travel and expense)     ‑‑‑>    ProjPeriodTable .PeriodId (Project management and accounting)
242TSTimesheetLineWeek .TSTimesheetLine (Travel and expense)     ‑‑‑>    TSTimesheetLine .RecId (Travel and expense)
243TSTimesheetLineWeek .TimesheetNbr (Travel and expense)     ‑‑‑>    TSTimesheetTable .TimesheetNbr (Travel and expense)
244TSTimesheetTable .Worker (Travel and expense)     ‑‑‑>    HcmWorker .RecId (Human resources)
245TSTimesheetTable .ProjPeriodId (Travel and expense)     ‑‑‑>    ProjPeriodTable .PeriodId (Project management and accounting)
246TSTimesheetTable .ProjPeriodTimesheetWeek (Travel and expense)     ‑‑‑>    ProjPeriodTimesheetWeek .RecId (Project management and accounting)
247TSTimesheetTable .SourceDocumentHeader (Travel and expense)     ‑‑‑>    SourceDocumentHeader .RecId (General ledger)
248TSTimesheetTable .TimesheetNbr (Travel and expense)     ‑‑‑>    TSTimesheetApprovalSummary .TimesheetNbr (Unknown module)
249TSTimesheetTable .Worker, .ProjPeriodTimesheetWeek (Travel and expense)     ‑‑‑>    TSTimesheetEntryTotalsPart .Worker, .ProjPeriodTimesheetWeek (Unknown module)
250TSTimesheetTable .RecId (Travel and expense)     ‑‑‑>    TSTimesheetTable .RecId (Travel and expense)
251TSTimesheetTrans .JournalId (Travel and expense)     ‑‑‑>    ProjJournalTable .JournalId (Project management and accounting)
252TSTimesheetTrans .PSAIndirectComponentGroup (Travel and expense)     ‑‑‑>    PSAIndirectComponentGroup .ComponentGroupId (Project management and accounting)
253TSTimesheetTrans .SourceDocumentLine (Travel and expense)     ‑‑‑>    SourceDocumentLine .RecId (General ledger)
254TSTimesheetTrans .TSTimesheetLineWeek (Travel and expense)     ‑‑‑>    TSTimesheetLineWeek .RecId (Travel and expense)
255TSWorkflowLog .ApprovedByWorker (Travel and expense)     ‑‑‑>    HcmWorker .RecId (Human resources)
256TSWorkflowLog .RejectedByWorker (Travel and expense)     ‑‑‑>    HcmWorker .RecId (Human resources)
257TSWorkflowLog .TimesheetLineRecId (Travel and expense)     ‑‑‑>    TSTimesheetLine .RecId (Travel and expense)
258TSWorkflowLog .TimesheetRecId (Travel and expense)     ‑‑‑>    TSTimesheetTable .RecId (Travel and expense)
259TSWorkflowTable .TimesheetLineRecId (Travel and expense)     ‑‑‑>    TSTimesheetLine .RecId (Travel and expense)
260TSWorkflowTable .TimesheetRecId (Travel and expense)     ‑‑‑>    TSTimesheetTable .RecId (Travel and expense)



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