Microsoft Dynamics AX 2012 R2

AxErd: Parent-Children: Travel and expense

Module: Travel and expense

Navigation:     AxErd_Home    


Row-numParent-table-nameForeign-key-columnsModule-of-parent-tableArrow-to-parentChild-table-namePrimary-key-columnsModule-of-child-table
1CategoryTable .CategoryId (Travel and expense)     <‑‑‑    ProjBudgetLine .CategoryId (Project management and accounting)
2CategoryTable .CategoryId (Travel and expense)     <‑‑‑    ProjCategory .CategoryId (Project management and accounting)
3CategoryTable .CategoryId (Travel and expense)     <‑‑‑    ProjListProjPostingTmp .CategoryId (Project management and accounting)
4CategoryTable .CategoryId (Travel and expense)     <‑‑‑    RouteCostCategory .CostCategoryId (Manufacturing)
5CategoryTable .CategoryId (Travel and expense)     <‑‑‑    TrvCostType .CostType (Travel and expense)
6SysPolicy .RecId (Travel and expense)     <‑‑‑    AuditPolicyAdditionalOption .Policy (Compliance and internal controls)
7SysPolicy .RecId (Travel and expense)     <‑‑‑    SysPolicyOrganization .Policy (Travel and expense)
8SysPolicy .RecId (Travel and expense)     <‑‑‑    SysPolicyRule .Policy (Travel and expense)
9SysPolicyRule .RecId (Travel and expense)     <‑‑‑    CatCatalogPolicyRule .RecId (Retail)
10SysPolicyRule .RecId (Travel and expense)     <‑‑‑    HcmBenefitEligibilityRule .RecId (Human resources)
11SysPolicyRule .RecId (Travel and expense)     <‑‑‑    HRPDefaultLimitRule .RecId (Human resources)
12SysPolicyRule .RecId (Travel and expense)     <‑‑‑    HRPLimitAgreementRule .RecId (Human resources)
13SysPolicyRule .RecId (Travel and expense)     <‑‑‑    HRPLimitRequestCurrencyRule .RecId (Human resources)
14SysPolicyRule .RecId (Travel and expense)     <‑‑‑    ProcCategoryAccessPolicyParameter .ProcurementCategoryAccessPolicyRule (Procurement and sourcing)
15SysPolicyRule .RecId (Travel and expense)     <‑‑‑    ProcCategoryPolicyParameter .ProcurementCategoryPolicyRule (Procurement and sourcing)
16SysPolicyRule .RecId (Travel and expense)     <‑‑‑    ProcCategoryTmpPolicyRule .PolicyRule (Procurement and sourcing)
17SysPolicyRule .RecId (Travel and expense)     <‑‑‑    PurchPolicyRuleCatThreshold_PSN .SysPolicyRule (Public Sector SL1)
18SysPolicyRule .RecId (Travel and expense)     <‑‑‑    PurchReApprovalPolicyRuleTable .RecId (Procurement and sourcing)
19SysPolicyRule .RecId (Travel and expense)     <‑‑‑    PurchReqConsolidationRule .PolicyRule (Procurement and sourcing)
20SysPolicyRule .RecId (Travel and expense)     <‑‑‑    PurchReqControlRFQRule .RecId (Procurement and sourcing)
21SysPolicyRule .RecId (Travel and expense)     <‑‑‑    PurchReqControlRule .RecId (Procurement and sourcing)
22SysPolicyRule .RecId (Travel and expense)     <‑‑‑    PurchReqSourcingHoldRule .PolicyRule (Procurement and sourcing)
23SysPolicyRule .RecId (Travel and expense)     <‑‑‑    PurchReqSourcingPolicyRule .RecId (Procurement and sourcing)
24SysPolicyRule .RecId (Travel and expense)     <‑‑‑    PurchReqSourcingPriceToleranceRule .PolicyRule (Procurement and sourcing)
25SysPolicyRule .RecId (Travel and expense)     <‑‑‑    PurchReqSourcingSplitRule .PolicyRule (Procurement and sourcing)
26SysPolicyRule .RecId (Travel and expense)     <‑‑‑    RequisitionPurposeRule .RecId (Procurement and sourcing)
27SysPolicyRule .RecId (Travel and expense)     <‑‑‑    RequisitionRepCatAccessPolicyRuleData .RequisitionReplenishCatAccessPolicyRule (Procurement and sourcing)
28SysPolicyRule .RecId (Travel and expense)     <‑‑‑    RequisitionReplenishCatAccessPolicyRule .RecId (Procurement and sourcing)
29SysPolicyRule .RecId (Travel and expense)     <‑‑‑    RequisitionReplenishControlRule .RecId (Procurement and sourcing)
30SysPolicyRule .RecId (Travel and expense)     <‑‑‑    SysPolicySourceDocumentRule .RecId (Travel and expense)
31SysPolicyRule .RecId (Travel and expense)     <‑‑‑    TrvPolicyRule .RecId (Travel and expense)
32SysPolicyRuleType .RecId (Travel and expense)     <‑‑‑    HcmBenefitDetail .PolicyRuleType (Human resources)
33SysPolicyRuleType .RecId (Travel and expense)     <‑‑‑    SysPolicyRule .PolicyRuleType (Travel and expense)
34SysPolicyRuleType .RecId (Travel and expense)     <‑‑‑    SysPolicyRuleTypeSequence .PolicyRuleType (Travel and expense)
35SysPolicyRuleType .RecId (Travel and expense)     <‑‑‑    SysPolicySourceDocumentRuleType .RecId (Travel and expense)
36SysPolicySequenceGroup .RecId (Travel and expense)     <‑‑‑    SysPolicyOrganizationTypeSequence .SequenceGroup (Travel and expense)
37SysPolicySequenceGroup .RecId (Travel and expense)     <‑‑‑    SysPolicyRuleTypeSequence .SequenceGroup (Travel and expense)
38SysPolicySequenceGroup .RecId (Travel and expense)     <‑‑‑    SysPolicyTypeSequence .SequenceGroup (Travel and expense)
39SysPolicySourceDocumentRule .RecId (Travel and expense)     <‑‑‑    AuditPolicyRuleDetail .PolicySourceDocumentRule (Compliance and internal controls)
40SysPolicySourceDocumentRule .RecId (Travel and expense)     <‑‑‑    SysPolicySourceDocumentRuleTranslation .PolicySourceDocumentRule (Travel and expense)
41SysPolicySourceDocumentRule .RecId (Travel and expense)     <‑‑‑    SysPolicySourceDocumentRuleViolation .PolicySourceDocumentRule (Travel and expense)
42SysPolicySourceDocumentRuleViolation .RecId (Travel and expense)     <‑‑‑    AuditPolicyRuleViolation .PolicySourceDocumentRuleViolation (Compliance and internal controls)
43SysPolicyType .RecId (Travel and expense)     <‑‑‑    SysPolicy .PolicyType (Travel and expense)
44SysPolicyType .RecId (Travel and expense)     <‑‑‑    SysPolicyRuleType .PolicyType (Travel and expense)
45SysPolicyType .RecId (Travel and expense)     <‑‑‑    SysPolicyTypeSequence .PolicyType (Travel and expense)
46SysPolicyType .RecId (Travel and expense)     <‑‑‑    SysPolicyTypeSourceDocumentQuery .PolicyType (Travel and expense)
47SysPolicyTypeSourceDocumentQuery .RecId (Travel and expense)     <‑‑‑    SysPolicySourceDocumentRuleType .PolicyTypeSourceDocumentQuery (Travel and expense)
48TrvCardTypes .TrvCreditCardType (Travel and expense)     <‑‑‑    TrvDisputeReasonCodeMaster .CardType (Travel and expense)
49TrvCardTypes .TrvCreditCardType (Travel and expense)     <‑‑‑    TrvEmpPaymethod .TrvCreditCardType (Travel and expense)
50TrvCashAdvance .RecId (Travel and expense)     <‑‑‑    TrvExpTrans .CashAdvanceRecId (Travel and expense)
51TrvCostType .CostType (Travel and expense)     <‑‑‑    ProjExpPolicies .CostType (Project management and accounting)
52TrvCostType .CostType (Travel and expense)     <‑‑‑    TrvCostTypeRates .CostType (Travel and expense)
53TrvCostType .CostType (Travel and expense)     <‑‑‑    TrvExpSubCategory .CostType (Travel and expense)
54TrvCostType .dataAreaId, .CostType (Travel and expense)     <‑‑‑    TrvExpTrans .ReferenceDataAreaId, .CostType (Travel and expense)
55TrvCostType .ExpType (Travel and expense)     <‑‑‑    TrvExpTrans .ExpType (Travel and expense)
56TrvCostType .CostType (Travel and expense)     <‑‑‑    TrvPBSCatCodes .CostType (Travel and expense)
57TrvCostType .CostType (Travel and expense)     <‑‑‑    TrvPBSMaindata .CostType (Travel and expense)
58TrvCostType .dataAreaId, .CostType (Travel and expense)     <‑‑‑    TrvRequisitionLine .ReferenceDataAreaId, .Category (Travel and expense)
59TrvCostType .CostType (Travel and expense)     <‑‑‑    TrvValidatePayment .CostType (Travel and expense)
60TrvCostTypeRates .VehicleType (Travel and expense)     <‑‑‑    TrvExpTrans .VehicleType (Travel and expense)
61TrvCostTypeRates .VehicleType (Travel and expense)     <‑‑‑    TrvKmSum .VehicleType (Travel and expense)
62TrvCostTypeStatistics .TrvCostTypeStatisticsId (Travel and expense)     <‑‑‑    TrvCostType .TrvCostTypeStatisticsId (Travel and expense)
63TrvCreditCards .RecId (Travel and expense)     <‑‑‑    TrvEmpPaymethod .CardNumberRecId (Travel and expense)
64TrvDestinations .Destination (Travel and expense)     <‑‑‑    TrvCashAdvance .Destination (Travel and expense)
65TrvDestinations .dataAreaId, .Destination (Travel and expense)     <‑‑‑    TrvExpTable .ReferenceDataAreaId, .Destination (Travel and expense)
66TrvDestinations .dataAreaId, .Destination (Travel and expense)     <‑‑‑    TrvRequisitionTable .ReferenceDataAreaId, .Destination (Travel and expense)
67TrvDisputeReasonCodeMaster .DisputeCode (Travel and expense)     <‑‑‑    TrvDisputes .DisputeReasonCode (Travel and expense)
68TrvDisputes .RecId, .TableId, .dataAreaId (Travel and expense)     <‑‑‑    DocuRef .RefRecId, .RefTableId, .RefCompanyId (Client)
69TrvEmpPaymethod .RecId (Travel and expense)     <‑‑‑    TrvPBSMaindata .EmpPayMethodRecId (Travel and expense)
70TrvEnhancedCarRentalData .RecId (Travel and expense)     <‑‑‑    TrvCarRentalCharge .CarRentalRecId (Travel and expense)
71TrvEnhancedData .RecId (Travel and expense)     <‑‑‑    TrvEnhancedCarRentalData .RecId (Travel and expense)
72TrvEnhancedData .RecId (Travel and expense)     <‑‑‑    TrvEnhancedHotelData .RecId (Travel and expense)
73TrvEnhancedData .RecId (Travel and expense)     <‑‑‑    TrvEnhancedItineraryData .RecId (Travel and expense)
74TrvEnhancedHotelData .RecId (Travel and expense)     <‑‑‑    TrvHotelCharge .HotelRecId (Travel and expense)
75TrvEnhancedItineraryData .RecId (Travel and expense)     <‑‑‑    TrvEnhancedTripLegDetail .ItineraryRecId (Travel and expense)
76TrvEnhancedItineraryData .RecId (Travel and expense)     <‑‑‑    TrvItineraryCharge .ItineraryRecID (Travel and expense)
77TrvEnhancedTaxInfo .RecId (Travel and expense)     <‑‑‑    TrvTaxCharge .TaxInfoRecId (Travel and expense)
78TrvExpGuest .RecId (Travel and expense)     <‑‑‑    TrvExpTransGuest .TrvExpGuest (Travel and expense)
79TrvExpMerchant .dataAreaId, .MerchantId (Travel and expense)     <‑‑‑    TrvExpTrans .ReferenceDataAreaId, .MerchantId (Travel and expense)
80TrvExpMerchant .dataAreaId, .MerchantId (Travel and expense)     <‑‑‑    TrvRequisitionLine .ReferenceDataAreaId, .Merchant (Travel and expense)
81TrvExpSubCategory .RecId (Travel and expense)     <‑‑‑    TrvExpTrans .SubCategoryRecId (Travel and expense)
82TrvExpTable .RecId, .Pky? (Travel and expense)     <‑‑‑    CaseAssociation .RefRecId, .Fky? (Sales and marketing)
83TrvExpTable .TableId, .RecId (Travel and expense)     <‑‑‑    DocuRef .RefTableId, .RefRecId (Client)
84TrvExpTable .CreatingWorker (Travel and expense)     <‑‑‑    TrvAppEmplSub .DelegatingWorker (Travel and expense)
85TrvExpTable .RecId (Travel and expense)     <‑‑‑    TrvExpTableTrvRequisitionTable .TrvExpTable (Travel and expense)
86TrvExpTable .RecId (Travel and expense)     <‑‑‑    TrvExpTrans .TrvExpTable (Travel and expense)
87TrvExpTable .ExpNumber (Travel and expense)     <‑‑‑    TrvPBSMaindata .TravelNo (Travel and expense)
88TrvExpTable .RecId (Travel and expense)     <‑‑‑    TrvPolicyViolationJustification .ViolatingRecord (Travel and expense)
89TrvExpTable .Pky?, .RecId (Travel and expense)     <‑‑‑    TrvPolicyViolationsCache .Fky?, .Header (Travel and expense)
90TrvExpTable .RecId, .Pky? (Travel and expense)     <‑‑‑    TrvPolicyViolationsLog .Header, .Fky? (Travel and expense)
91TrvExpTable .RecId (Travel and expense)     <‑‑‑    TrvWorkflowExpProviderCache .TrvExpTable (Travel and expense)
92TrvExpTable .RecId (Travel and expense)     <‑‑‑    TrvWorkflowLog .ExpHeaderRecId (Travel and expense)
93TrvExpTrans .Pky?, .RecId (Travel and expense)     <‑‑‑    CaseAssociation .Fky?, .RefRecId (Sales and marketing)
94TrvExpTrans .TableId, .RecId (Travel and expense)     <‑‑‑    TaxUncommitted .SourceTableId, .SourceRecId (Tax)
95TrvExpTrans .RecId (Travel and expense)     <‑‑‑    TrvEnhancedData .TransactionRecord (Travel and expense)
96TrvExpTrans .RecId (Travel and expense)     <‑‑‑    TrvExpenseTaxRecovery .ExpTransRecId (Travel and expense)
97TrvExpTrans .RecId (Travel and expense)     <‑‑‑    TrvExpTrans .ParentRecId (Travel and expense)
98TrvExpTrans .RecId (Travel and expense)     <‑‑‑    TrvExpTransGuest .TrvExpTrans (Travel and expense)
99TrvExpTrans .RecId (Travel and expense)     <‑‑‑    TrvExpTransLinkReceipts .RefExpTransRecId (Travel and expense)
100TrvExpTrans .RecId (Travel and expense)     <‑‑‑    TrvPolicyViolationJustification .ViolatingRecord (Travel and expense)
101TrvExpTrans .RecId, .Pky?, .RecId (Travel and expense)     <‑‑‑    TrvPolicyViolationsCache .ParentRecId, .Fky?, .Line (Travel and expense)
102TrvExpTrans .RecId, .Pky? (Travel and expense)     <‑‑‑    TrvPolicyViolationsLog .Line, .Fky? (Travel and expense)
103TrvExpTrans .RecId (Travel and expense)     <‑‑‑    TrvUnreconciledExpenseTransaction .ExpenseLine (Travel and expense)
104TrvExpTrans .RecId (Travel and expense)     <‑‑‑    TrvWorkflowExpProviderCache .TrvExpTrans (Travel and expense)
105TrvExpTrans .RecId (Travel and expense)     <‑‑‑    TrvWorkflowLog .ExpLineRecId (Travel and expense)
106TrvLinePurpose .BusinessPurpose (Travel and expense)     <‑‑‑    TrvExpTrans .BusinessPurpose (Travel and expense)
107TrvLocations .dataAreaId, .Location (Travel and expense)     <‑‑‑    TrvExpTrans .ReferenceDataAreaId, .Location (Travel and expense)
108TrvLocations .Location (Travel and expense)     <‑‑‑    TrvPerDiems .Location (Travel and expense)
109TrvLocations .dataAreaId, .Location (Travel and expense)     <‑‑‑    TrvRequisitionLine .ReferenceDataAreaId, .PerdiemLocation (Travel and expense)
110TrvParameters .RecId, .TableId (Travel and expense)     <‑‑‑    LanguageTxt .TxtRecId, .TxtTableId (General ledger)
111TrvParameters .KeyId (Travel and expense)     <‑‑‑    TrvBarcodeInstructionsLanguageTxt .TrvParameter (Travel and expense)
112TrvPayMethod .PayMethod (Travel and expense)     <‑‑‑    TrvCostType .StdPaiMethod (Travel and expense)
113TrvPayMethod .PayMethod (Travel and expense)     <‑‑‑    TrvEmpPaymethod .Paymethod (Travel and expense)
114TrvPayMethod .dataAreaId, .PayMethod (Travel and expense)     <‑‑‑    TrvExpTrans .ReferenceDataAreaId, .PayMethod (Travel and expense)
115TrvPayMethod .PayMethod (Travel and expense)     <‑‑‑    TrvPBSMaindata .Paymethod (Travel and expense)
116TrvPayMethod .PayMethod (Travel and expense)     <‑‑‑    TrvValidatePayment .PayMethod (Travel and expense)
117TrvPBSMaindata .RecId (Travel and expense)     <‑‑‑    TrvDisputes .DisputedTransactionId (Travel and expense)
118TrvPBSMaindata .RecId (Travel and expense)     <‑‑‑    TrvDisputes .TemporaryCreditId (Travel and expense)
119TrvPBSMaindata .RecId (Travel and expense)     <‑‑‑    TrvEnhancedData .PBSRecid (Travel and expense)
120TrvPBSMaindata .RecId (Travel and expense)     <‑‑‑    TrvEnhancedTaxInfo .PBSRecId (Travel and expense)
121TrvPBSMaindata .RecId (Travel and expense)     <‑‑‑    TrvExpTrans .PBSRecId (Travel and expense)
122TrvPerDiems .RecId (Travel and expense)     <‑‑‑    TrvAllowanceRate .PerDiemRecId (Travel and expense)
123TrvPolicyRule .RecId (Travel and expense)     <‑‑‑    TrvPolicyLanguageTxt .TrvPolicyRule (Travel and expense)
124TrvPolicyRule .RecId (Travel and expense)     <‑‑‑    TrvPolicyViolationsCache .Rule (Travel and expense)
125TrvPolicyRule .RecId (Travel and expense)     <‑‑‑    TrvPolicyViolationsLog .Rule (Travel and expense)
126TrvRequisitionLine .RecId (Travel and expense)     <‑‑‑    TrvExpTrans .MappedToRequisitionLine (Travel and expense)
127TrvRequisitionLine .RecId (Travel and expense)     <‑‑‑    TrvPolicyViolationJustification .ViolatingRecord (Travel and expense)
128TrvRequisitionLine .Pky?, .RecId (Travel and expense)     <‑‑‑    TrvPolicyViolationsCache .Fky?, .Line (Travel and expense)
129TrvRequisitionLine .RecId, .Pky? (Travel and expense)     <‑‑‑    TrvPolicyViolationsLog .Line, .Fky? (Travel and expense)
130TrvRequisitionTable .CreatingWorker (Travel and expense)     <‑‑‑    TrvAppEmplSub .DelegatingWorker (Travel and expense)
131TrvRequisitionTable .RecId (Travel and expense)     <‑‑‑    TrvExpTableTrvRequisitionTable .TrvRequisitionTable (Travel and expense)
132TrvRequisitionTable .RecId (Travel and expense)     <‑‑‑    TrvPolicyViolationJustification .ViolatingRecord (Travel and expense)
133TrvRequisitionTable .Pky?, .RecId (Travel and expense)     <‑‑‑    TrvPolicyViolationsCache .Fky?, .Header (Travel and expense)
134TrvRequisitionTable .RecId, .Pky? (Travel and expense)     <‑‑‑    TrvPolicyViolationsLog .Header, .Fky? (Travel and expense)
135TrvRequisitionTable .RecId (Travel and expense)     <‑‑‑    TrvRequisitionLine .TrvRequisitionTable (Travel and expense)
136TrvSharedSubCategory .RecId (Travel and expense)     <‑‑‑    TrvExpSubCategory .TrvSharedSubCategory (Travel and expense)
137TrvTravelTxt .Txt, .dataAreaId (Travel and expense)     <‑‑‑    TrvExpTable .Txt2, .ReferenceDataAreaId (Travel and expense)
138TrvTravelTxt .dataAreaId, .Txt (Travel and expense)     <‑‑‑    TrvRequisitionTable .ReferenceDataAreaId, .TravelPurpose (Travel and expense)
139TrvValidatePayment .dataAreaId, .PayMethod, .CostType (Travel and expense)     <‑‑‑    TrvExpTrans .ReferenceDataAreaId, .PayMethod, .CostType (Travel and expense)
140TSIntercompanyCost .RecId (Travel and expense)     <‑‑‑    TSIntercompanyCostDetails .TSIntercompanyCost (Travel and expense)
141TSTimesheetLine .RecId (Travel and expense)     <‑‑‑    TSTimesheetLineTaxExtensionIN .TSTimesheetLine (Global financial management - Asia Pacific)
142TSTimesheetLine .RecId (Travel and expense)     <‑‑‑    TSTimesheetLineWeek .TSTimesheetLine (Travel and expense)
143TSTimesheetLine .RecId (Travel and expense)     <‑‑‑    TSWorkflowLog .TimesheetLineRecId (Travel and expense)
144TSTimesheetLine .RecId (Travel and expense)     <‑‑‑    TSWorkflowTable .TimesheetLineRecId (Travel and expense)
145TSTimesheetLineWeek .RecId (Travel and expense)     <‑‑‑    TSTimesheetLineComments .TSTimesheetLineWeek (Travel and expense)
146TSTimesheetLineWeek .RecId (Travel and expense)     <‑‑‑    TSTimesheetTrans .TSTimesheetLineWeek (Travel and expense)
147TSTimesheetTable .Worker (Travel and expense)     <‑‑‑    TSAppEmplSub .Worker (Travel and expense)
148TSTimesheetTable .RecId (Travel and expense)     <‑‑‑    TSIntercompanyCost .TSTimesheetTable (Travel and expense)
149TSTimesheetTable .TimesheetNbr (Travel and expense)     <‑‑‑    TSTimesheetLine .TimesheetNbr (Travel and expense)
150TSTimesheetTable .TimesheetNbr (Travel and expense)     <‑‑‑    TSTimesheetLineWeek .TimesheetNbr (Travel and expense)
151TSTimesheetTable .RecId (Travel and expense)     <‑‑‑    TSTimesheetTable .RecId (Travel and expense)
152TSTimesheetTable .RecId (Travel and expense)     <‑‑‑    TSWorkflowLog .TimesheetRecId (Travel and expense)
153TSTimesheetTable .RecId (Travel and expense)     <‑‑‑    TSWorkflowTable .TimesheetRecId (Travel and expense)
154TSTimesheetTrans .RecId (Travel and expense)     <‑‑‑    TSIntercompanyCostDetails .TSTimesheetTrans (Travel and expense)



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