Microsoft Dynamics AX 2012 R2

AxErd: Parent-Children: General ledger

Module: General ledger

Navigation:     AxErd_Home     Previous_File     Next_File


Row-numParent-table-nameForeign-key-columnsModule-of-parent-tableArrow-to-parentChild-table-namePrimary-key-columnsModule-of-child-table
2441LedgerJournalTransAccrual .RefTableid, .RefRecid (General ledger)     <‑‑‑    LedgerJournalTransAccrualTrans .RefTableid, .RefRecid (General ledger)
2442LedgerJournalTransAccrualTrans .RecId (General ledger)     <‑‑‑    LedgerPostingTransactionTmp .AccrualRecId (General ledger)
2443LedgerJournalTransVoucherTemplate .JournalNum, .Voucher (General ledger)     <‑‑‑    LedgerJournalTrans .JournalNum, .Voucher (General ledger)
2444LedgerJournalTxt .Txt (General ledger)     <‑‑‑    AssetDepBookJournalTrans .Txt (Fixed assets)
2445LedgerJournalTxt .dataAreaId, .Txt (General ledger)     <‑‑‑    LedgerJournalTrans .Company, .Txt (General ledger)
2446LedgerJournalTxt .dataAreaId, .Txt (General ledger)     <‑‑‑    LedgerJournalTrans .OffsetCompany, .OffsetTxt (General ledger)
2447LedgerPeriodCode .Code (General ledger)     <‑‑‑    BusinessStatisticsDef .PeriodCode (General ledger)
2448LedgerPeriodCode .Code (General ledger)     <‑‑‑    COSReportColumn .DateInterval (Production control)
2449LedgerPeriodCode .Code (General ledger)     <‑‑‑    COSTmpReport .DateCode (Production control)
2450LedgerPeriodCode .Code (General ledger)     <‑‑‑    InventClosing .PeriodCode (Production control)
2451LedgerPeriodCode .Code (General ledger)     <‑‑‑    InventValueReport .DefaultDateInterval (Production control)
2452LedgerPeriodCode .Code (General ledger)     <‑‑‑    LedgerAllocationBasisRule .DateInterval (General ledger)
2453LedgerPeriodCode .Code (General ledger)     <‑‑‑    LedgerAllocationRule .DateInterval (General ledger)
2454LedgerPeriodCode .Code (General ledger)     <‑‑‑    LedgerAllocationRulesTmp .DateInterval (General ledger)
2455LedgerPeriodCode .Code (General ledger)     <‑‑‑    LedgerBalColumnsDim .DateCode (General ledger)
2456LedgerPeriodCode .Code (General ledger)     <‑‑‑    LedgerRRGCellTable_RU .LedgerPeriodCode (Global financial management - Russia)
2457LedgerPeriodCode .Code (General ledger)     <‑‑‑    LedgerRRGEQueries_W .Period (Global financial management - _W)
2458LedgerPeriodCode .Code (General ledger)     <‑‑‑    LedgerRRGOperationTable_RU .LedgerPeriodCode (Global financial management - Russia)
2459LedgerPeriodCode .Code (General ledger)     <‑‑‑    LedgerRRGReportTable_RU .LedgerPeriodCode (Global financial management - Russia)
2460LedgerPeriodCode .Code (General ledger)     <‑‑‑    TmpLedgerBalanceSheetDimCol .DateCode (Global financial management - Eastern Europe)
2461LedgerPostingTransactionTmp .RecId (General ledger)     <‑‑‑    LedgerPostingTransactionTaxTmp .LedgerPostingTransactionTmp (General ledger)
2462LedgerPostingTransactionTmp .RecId (General ledger)     <‑‑‑    LedgerPostingTransactionTaxWHTTmp_IN .LedgerPostingTransactionTmp (Global financial management - Asia Pacific)
2463LedgerRowDef .RowDefinition (General ledger)     <‑‑‑    LedgerBalHeaderDim .RowDefinition (General ledger)
2464LedgerRowDef .RowDefinition (General ledger)     <‑‑‑    LedgerBalHeaderDim .RowDefinitionSec (General ledger)
2465LedgerRowDef .RowDefinition (General ledger)     <‑‑‑    LedgerRowDefErrorLog .RowDefinition (General ledger)
2466LedgerRowDef .RowDefinition (General ledger)     <‑‑‑    LedgerRowDefinitionPrintTmp .RowDefinition (General ledger)
2467LedgerRowDef .RowDefinition (General ledger)     <‑‑‑    LedgerRowDefLine .RowDefinition (General ledger)
2468LedgerRowDef .RowDefinition (General ledger)     <‑‑‑    LedgerRowDefLine .RefRowDef (General ledger)
2469LedgerRowDef .RowDefinition (General ledger)     <‑‑‑    LedgerRowDefLineCalc .RowDefinition (General ledger)
2470LedgerRowDef .RowDefinition (General ledger)     <‑‑‑    TmpXBRLTaxonomyDetailsReferences .RowDefinition (General ledger)
2471LedgerRowDefLine .RecId, .RowDefinition (General ledger)     <‑‑‑    LedgerRowDefErrorLog .SourceRecId, .RowDefinition (General ledger)
2472LedgerRowDefLine .RecId (General ledger)     <‑‑‑    LedgerRowDefErrorLog .ReferenceRecId (General ledger)
2473LedgerRowDefLine .RecId, .RowDefinition (General ledger)     <‑‑‑    LedgerRowDefLine .ParentRecId, .RowDefinition (General ledger)
2474LedgerRowDefLine .RecId (General ledger)     <‑‑‑    LedgerRowDefLine .originalRecId (General ledger)
2475LedgerRowDefLine .RecId (General ledger)     <‑‑‑    LedgerRowDefLine .RefRowDefBranch (General ledger)
2476LedgerRowDefLine .RecId (General ledger)     <‑‑‑    LedgerRowDefLine .SourceRecId (General ledger)
2477LedgerRowDefLine .RecId (General ledger)     <‑‑‑    LedgerRowDefLineCalc .ArgRecId (General ledger)
2478LedgerRowDefLine .RecId (General ledger)     <‑‑‑    LedgerRowDefLineCalc .OriginalRecId (General ledger)
2479LineOfBusiness .LineOfBusinessId (General ledger)     <‑‑‑    AgreementHeaderExt_RU .LineOfBusinessId (Global financial management - Russia)
2480LineOfBusiness .LineOfBusinessId (General ledger)     <‑‑‑    AgreementHeaderHistoryExt_RU .LineOfBusinessId (Global financial management - Russia)
2481LineOfBusiness .LineOfBusinessId (General ledger)     <‑‑‑    CustTable .LineOfBusinessId (Sales and marketing)
2482LineOfBusiness .LineOfBusinessId (General ledger)     <‑‑‑    SalesOrderEntryStatistics .LineOfBusinessId (Global financial management - Western Europe)
2483LineOfBusiness .LineOfBusinessId (General ledger)     <‑‑‑    smmBusRelTable .LineOfBusinessId (Sales and marketing)
2484LineOfBusiness .LineOfBusinessId (General ledger)     <‑‑‑    smmImportRelationJournal .LineOfBusinessId (Sales and marketing)
2485LineOfBusiness .LineOfBusinessId (General ledger)     <‑‑‑    VendRequestProspectiveProfile .LineOfBusinessId (Procurement and sourcing)
2486LineOfBusiness .LineOfBusinessId (General ledger)     <‑‑‑    VendTable .LineOfBusinessId (Procurement and sourcing)
2487MainAccount .MainAccountId (General ledger)     <‑‑‑    AssetAcquisitionStmtTmp .MainAccountId (Global financial management - Eastern Europe)
2488MainAccount .RecId (General ledger)     <‑‑‑    AssetBook .DueFrom_PSN (Fixed assets)
2489MainAccount .RecId (General ledger)     <‑‑‑    AssetBook .DueTo_PSN (Fixed assets)
2490MainAccount .RecId (General ledger)     <‑‑‑    BudgetAnalysisDimProcessingTmp_PSN .MainAccount (Public Sector SL1)
2491MainAccount .RecId (General ledger)     <‑‑‑    BudgetControlMainAccount .MainAccount (Budgeting)
2492MainAccount .MainAccountId (General ledger)     <‑‑‑    COSCostTrans .LedgerAccountNum (Production control)
2493MainAccount .RecId (General ledger)     <‑‑‑    COSLedgerReference .MainAccount (Production control)
2494MainAccount .MainAccountId (General ledger)     <‑‑‑    CustAuditorTmp .MainAccountId (Accounts Receivable)
2495MainAccount .MainAccountId (General ledger)     <‑‑‑    CustBalanceByProfileTmp_CN .MainAccountId (Global financial management - Asia Pacific)
2496MainAccount .MainAccountId (General ledger)     <‑‑‑    CustLedgerTransactionsTmp_CN .MainAccountNum (Global financial management - Asia Pacific)
2497MainAccount .MainAccountId (General ledger)     <‑‑‑    CustVendBalanceTmp_CN .MainAccountNum (Global financial management - Asia Pacific)
2498MainAccount .MainAccountId (General ledger)     <‑‑‑    CustVendPaymJournalTmp .BankMainAccount (Accounts Receivable)
2499MainAccount .MainAccountId (General ledger)     <‑‑‑    CustVendTurnoverAndBalanceTmp .SummaryAccountNumber (Accounts Receivable)
2500MainAccount .RecId (General ledger)     <‑‑‑    DimensionAttributeValueCombination .MainAccount (General ledger)
2501MainAccount .MainAccountId (General ledger)     <‑‑‑    InventLedgerConciliationTmp .Account (Production control)
2502MainAccount .MainAccountId (General ledger)     <‑‑‑    InventSumDateFinancialDim_RU .Account (Global financial management - Russia)
2503MainAccount .MainAccountId (General ledger)     <‑‑‑    InventValueReportTmpLedgerLine .MainAccountId (Production control)
2504MainAccount .RecId (General ledger)     <‑‑‑    ISRConceptMainAccount_MX .MainAccount (Global financial management - Latin America)
2505MainAccount .MainAccountId (General ledger)     <‑‑‑    LedgerAccountBalSheetByDimTmp .FromAccount (Global financial management - Asia Pacific)
2506MainAccount .MainAccountId (General ledger)     <‑‑‑    LedgerAccountBalSheetByDimTmp .LedgerAccount (Global financial management - Asia Pacific)
2507MainAccount .MainAccountId (General ledger)     <‑‑‑    LedgerAccountBalSheetByDimTmp .ToAccount (Global financial management - Asia Pacific)
2508MainAccount .RecId (General ledger)     <‑‑‑    LedgerAccountCov .FromMainAccount (General ledger)
2509MainAccount .RecId (General ledger)     <‑‑‑    LedgerAccountCov .ToMainAccount (General ledger)
2510MainAccount .RecId (General ledger)     <‑‑‑    LedgerAllocation .FromMainAccount (General ledger)
2511MainAccount .RecId (General ledger)     <‑‑‑    LedgerBalanceControl .MainAccount (General ledger)
2512MainAccount .RecId (General ledger)     <‑‑‑    LedgerBalanceSheetCorrection .MainAccount (Global financial management - Eastern Europe)
2513MainAccount .RecId (General ledger)     <‑‑‑    LedgerBalanceSheetGross .MainAccount (Global financial management - Eastern Europe)
2514MainAccount .MainAccountId (General ledger)     <‑‑‑    LedgerBalanceTurnoverTmp_RU .MainAccount (Global financial management - Russia)
2515MainAccount .MainAccountId (General ledger)     <‑‑‑    LedgerBalanceTurnoverTmp_RU .OffsetAccount (Global financial management - Russia)
2516MainAccount .MainAccountId (General ledger)     <‑‑‑    LedgerCashDailyStatusTmp .AccountNum (Global financial management - Asia Pacific)
2517MainAccount .MainAccountId (General ledger)     <‑‑‑    LedgerChartofAccountsbyDimensionsTmp_CN .AccountNum (Global financial management - Asia Pacific)
2518MainAccount .RecId (General ledger)     <‑‑‑    LedgerClosingTable .MainAccount (General ledger)
2519MainAccount .MainAccountId (General ledger)     <‑‑‑    LedgerClosingTmp .MainAccountId (General ledger)
2520MainAccount .RecId (General ledger)     <‑‑‑    LedgerCov .MainAccount (General ledger)
2521MainAccount .MainAccountId (General ledger)     <‑‑‑    LedgerDailySummaryReportTmp_CN .AccountNum (Global financial management - Asia Pacific)
2522MainAccount .MainAccountId (General ledger)     <‑‑‑    LedgerDetailedTransByDimensionsTmp_CN .AccountNum (Global financial management - Asia Pacific)
2523MainAccount .MainAccountId, .MainAccountId (General ledger)     <‑‑‑    LedgerDetailedTransByDimTmpParameter_CN .FromAccount, .ToAccount (Global financial management - Asia Pacific)
2524MainAccount .RecId (General ledger)     <‑‑‑    LedgerLiquidity .MainAccount (General ledger)
2525MainAccount .RecId (General ledger)     <‑‑‑    LedgerMatrixLine_CN .MainAccountNum (Global financial management - Asia Pacific)
2526MainAccount .MainAccountId (General ledger)     <‑‑‑    LedgerMatrixReportTmp_CN .MainAccountId (Global financial management - Asia Pacific)
2527MainAccount .MainAccountId (General ledger)     <‑‑‑    LedgerMatrixReportTmpParameter_CN .MainAccountId (Global financial management - Asia Pacific)
2528MainAccount .RecId (General ledger)     <‑‑‑    LedgerMatrixTable_CN .MainAccount (Global financial management - Asia Pacific)
2529MainAccount .RecId (General ledger)     <‑‑‑    LedgerOpeningTable_ES .MainAccount (Global financial management - Western Europe)
2530MainAccount .RecId (General ledger)     <‑‑‑    LedgerRelatedAccounts_ES .FromAccountRecId (Global financial management - Western Europe)
2531MainAccount .RecId (General ledger)     <‑‑‑    LedgerRelatedAccounts_ES .ToAccountRecId (Global financial management - Western Europe)
2532MainAccount .MainAccountId (General ledger)     <‑‑‑    LedgerRRGOperationTable_RU .OffsetAccountNumMask (Global financial management - Russia)
2533MainAccount .RecId (General ledger)     <‑‑‑    LedgerStatementDefinition .MainAccount (Global financial management - Eastern Europe)
2534MainAccount .MainAccountId (General ledger)     <‑‑‑    LedgerTmpAccountCategoryLink .MainAccountId (General ledger)
2535MainAccount .MainAccountId (General ledger)     <‑‑‑    LedgerTransactionListTmp .AccountNum (General ledger)
2536MainAccount .MainAccountId (General ledger)     <‑‑‑    LedgerTransactionsbyDimensionTmp_CN .AccountNum (Global financial management - Asia Pacific)
2537MainAccount .MainAccountId, .MainAccountId (General ledger)     <‑‑‑    LedgerTransbyDimensionTmpParameter_CN .FromAccount, .ToAccount (Global financial management - Asia Pacific)
2538MainAccount .MainAccountId (General ledger)     <‑‑‑    LedgerTransferOpeningTmp .MainAccount (General ledger)
2539MainAccount .RecId (General ledger)     <‑‑‑    LedgerTransStatementTmp .MainAccount (General ledger)
2540MainAccount .MainAccountId (General ledger)     <‑‑‑    LedgerTurnoverAndBalanceTmp .AccountNum (Global financial management - Eastern Europe)
2541MainAccount .RecId (General ledger)     <‑‑‑    MainAccount .OpeningAccount (General ledger)
2542MainAccount .RecId (General ledger)     <‑‑‑    MainAccount .ParentMainAccount_BR (General ledger)
2543MainAccount .RecId (General ledger)     <‑‑‑    MainAccount .TransferYearEndAccount_ES (General ledger)
2544MainAccount .RecId (General ledger)     <‑‑‑    MainAccountConsolidateAccount .MainAccount (General ledger)
2545MainAccount .RecId (General ledger)     <‑‑‑    MainAccountControlCurrencyCode .MainAccount (General ledger)
2546MainAccount .RecId (General ledger)     <‑‑‑    MainAccountControlPosting .MainAccount (General ledger)
2547MainAccount .RecId (General ledger)     <‑‑‑    MainAccountControlTaxCode .MainAccount (General ledger)
2548MainAccount .RecId (General ledger)     <‑‑‑    MainAccountControlUser .MainAccount (General ledger)
2549MainAccount .RecId (General ledger)     <‑‑‑    MainAccountLegalEntity .MainAccount (General ledger)
2550MainAccount .RecId (General ledger)     <‑‑‑    MainAccountSeparateBalance .MainAccount (General ledger)
2551MainAccount .RecId (General ledger)     <‑‑‑    MainAccountTranslation .MainAccount (General ledger)
2552MainAccount .MainAccountId (General ledger)     <‑‑‑    ProjTmpAccountDetailHistory .MainAccountId (Public Sector SL1)
2553MainAccount .MainAccountId (General ledger)     <‑‑‑    RCashAccountStatementTmp .MainAccount (Global financial management - Russia)
2554MainAccount .RecId (General ledger)     <‑‑‑    RCashBalances .MainAccountId (Global financial management - Russia)
2555MainAccount .MainAccountId (General ledger)     <‑‑‑    RCashLedgerReconciliationTmp .MainAccountId (Global financial management - Russia)
2556MainAccount .RecId (General ledger)     <‑‑‑    RTax25LedgerInterval .FromMainAccountId (Global financial management - Russia)
2557MainAccount .RecId (General ledger)     <‑‑‑    RTax25LedgerInterval .ToMainAccountId (Global financial management - Russia)
2558MainAccount .Pky?, .MainAccountId (General ledger)     <‑‑‑    RTax25ProfitLedgerSetup .Fky?, .AccountNumGroup (Global financial management - Russia)
2559MainAccount .Pky?, .MainAccountId (General ledger)     <‑‑‑    RTax25ProfitLedgerSetup .Fky?, .OffsetAccountNumGroup (Global financial management - Russia)
2560MainAccount .MainAccountId (General ledger)     <‑‑‑    RTSLLedgerTransRule .MainAccountNum (Global financial management - Russia)
2561MainAccount .MainAccountId (General ledger)     <‑‑‑    RTSLLedgerTransRule .MainAccountNumOffset (Global financial management - Russia)
2562MainAccount .MainAccountId (General ledger)     <‑‑‑    RTSLLedgerTransRule .ToMainAccountNum (Global financial management - Russia)
2563MainAccount .RecId (General ledger)     <‑‑‑    TaxReport347Account .MainAccount (Global financial management - Western Europe)
2564MainAccount .MainAccountId (General ledger)     <‑‑‑    TaxTransDetailTmp .MainAccount (Tax)
2565MainAccount .RecId (General ledger)     <‑‑‑    TaxYearlyComSetupExclude_IT .FromMainAccount (Global financial management - Western Europe)
2566MainAccount .RecId (General ledger)     <‑‑‑    TaxYearlyComSetupExclude_IT .ToMainAccount (Global financial management - Western Europe)
2567MainAccount .MainAccountId (General ledger)     <‑‑‑    TmpBalanceTurnoverReport_RU .AccountNum (Global financial management - Russia)
2568MainAccount .MainAccountId (General ledger)     <‑‑‑    TmpBalanceTurnoverReport_RU .CorrAccountNum (Global financial management - Russia)
2569MainAccount .MainAccountId (General ledger)     <‑‑‑    TmpCustLedger .MainAccountId_RU (Public Sector SL1)
2570MainAccount .MainAccountId (General ledger)     <‑‑‑    TmpDailyLedger_CN .AccountNum (Global financial management - Asia Pacific)
2571MainAccount .MainAccountId (General ledger)     <‑‑‑    TmpGeneralLedger_CN .AccountNum (Global financial management - Asia Pacific)
2572MainAccount .RecId (General ledger)     <‑‑‑    TmpLedgerAllocation .MainAccount (General ledger)
2573MainAccount .RecId (General ledger)     <‑‑‑    TmpLedgerTransPreview_RU .MainAccount (Global financial management - Russia)
2574MainAccount .RecId (General ledger)     <‑‑‑    TmpMainAccount .MainAccount (General ledger)
2575MainAccount .MainAccountId (General ledger)     <‑‑‑    TmpRAssetMB2Report .MainAccountNum (Global financial management - Russia)
2576MainAccount .MainAccountId (General ledger)     <‑‑‑    TmpRTax25TaxRemainGoods .MainAccountNum (Global financial management - Russia)
2577MainAccount .MainAccountId (General ledger)     <‑‑‑    TmpRTax25TaxRemainGoods .SumMainAccountNum (Global financial management - Russia)
2578MainAccount .MainAccountId (General ledger)     <‑‑‑    TmpSalesPurchReportLine_RU .InventPostingAccount (Global financial management - Russia)
2579MainAccount .MainAccountId (General ledger)     <‑‑‑    VendBalanceByProfileTmp_CN .MainAccountId (Global financial management - Asia Pacific)
2580MainAccount .MainAccountId (General ledger)     <‑‑‑    VendExchRateAdjustmentTmp .MainAccount (Accounts Payable)
2581MainAccount .MainAccountId (General ledger)     <‑‑‑    VendLedgerTransactionsTmp_CN .MainAccountNum (Global financial management - Asia Pacific)
2582MainAccount .MainAccountId (General ledger)     <‑‑‑    VendProvisionalBalanceTmp .MainAccountId (Accounts Payable)
2583MainAccountCategory .AccountCategory (General ledger)     <‑‑‑    LedgerTmpAccountCategoryLink .AccountCategory (General ledger)
2584MainAccountCategory .AccountCategoryRef (General ledger)     <‑‑‑    MainAccount .AccountCategoryRef (General ledger)
2585MainAccountCategory .RecId (General ledger)     <‑‑‑    MainAccountTemplate .MainAccountCategory (General ledger)
2586MainAccountLegalEntity .MainAccount (General ledger)     <‑‑‑    LedgerAllocation .FromMainAccount (General ledger)
2587MainAccountLegalEntity .MainAccount (General ledger)     <‑‑‑    MainAccountControlTaxCode .MainAccount (General ledger)
2588MainAccountTemplate .RecId (General ledger)     <‑‑‑    MainAccount .MainAccountTemplate (General ledger)
2589MainAccountTemplate .RecId (General ledger)     <‑‑‑    MainAccountTemplateTranslation .MainAccountTemplate (General ledger)
2590ReasonTable .Reason (General ledger)     <‑‑‑    BankLGAction .CancellationReason (Cash and bank management)
2591ReasonTable .Reason (General ledger)     <‑‑‑    BankLGGuarantee .CancellationReason (Cash and bank management)
2592ReasonTable .Reason (General ledger)     <‑‑‑    BankLGGuarantee .RequestReason (Cash and bank management)
2593ReasonTable .Reason (General ledger)     <‑‑‑    BudgetTransactionCode .Reason (Budgeting)
2594ReasonTable .Reason, .Pky? (General ledger)     <‑‑‑    CustParameters .CollectionsWriteOffReasonTable, .Fky? (Accounts Receivable)
2595ReasonTable .Pky?, .Reason (General ledger)     <‑‑‑    PurchRFQParmUpdate .Fky?, .ReasonId (Procurement and sourcing)
2596ReasonTable .Reason (General ledger)     <‑‑‑    ReasonTableRef .Reason (General ledger)
2597ReasonTable .Reason (General ledger)     <‑‑‑    VendOnHoldHistory .ReasonCode (Procurement and sourcing)
2598ReasonTable .Reason (General ledger)     <‑‑‑    VendRequestAuditTmp .ReasonCode (Procurement and sourcing)
2599ReasonTable .Reason (General ledger)     <‑‑‑    VendRequestStatusChange .StatusChangeReasonCode (Procurement and sourcing)
2600ReasonTable .Reason (General ledger)     <‑‑‑    VendTmpRequest .RejectionReason (Accounts Payable)

Navigation:     Next_File




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