Microsoft Dynamics AX 2012 R2

AxErd: Child-Parents: General ledger

Module: General ledger

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
811SubledgerJournalEntry .AccountingEvent (General ledger)     ‑‑‑>    AccountingEvent .RecId (General ledger)
812SubledgerJournalEntry .VoucherDataAreaId, .Fky? (General ledger)     ‑‑‑>    DataArea .id, .Pky? (Unknown module)
813SubledgerJournalEntry .FiscalCalendarPeriod (General ledger)     ‑‑‑>    FiscalCalendarPeriod .RecId (General ledger)
814SubledgerJournalEntry .Ledger (General ledger)     ‑‑‑>    Ledger .RecId (General ledger)
815SubLedgerJournalTransferNumberSeqTmp .FiscalCalendarPeriod (General ledger)     ‑‑‑>    FiscalCalendarPeriod .RecId (General ledger)
816SubLedgerJournalTransferNumberSeqTmp .FiscalCalendarYear (General ledger)     ‑‑‑>    FiscalCalendarYear .RecId (General ledger)
817SubLedgerJournalTransferNumberSeqTmp .Ledger (General ledger)     ‑‑‑>    Ledger .RecId (General ledger)
818SubLedgerJournalTransferNumberSeqTmp .SubledgerJournalEntry (General ledger)     ‑‑‑>    SubledgerJournalEntry .RecId (General ledger)
819SubledgerJournalTransferRule .Ledger (General ledger)     ‑‑‑>    Ledger .RecId (General ledger)
820SubledgerJournalTransferRule .SourceDocumentType (General ledger)     ‑‑‑>    SourceDocumentTmpTypeInformation .ClassId (General ledger)
821SubledgerJournalTransferRule .NotificationUserGroupId (General ledger)     ‑‑‑>    UserGroupInfo .id (Server and Tools)
822SubledgerVoucherGeneralJournalEntry .VoucherDataAreaId, .Fky? (General ledger)     ‑‑‑>    DataArea .id, .Pky? (Unknown module)
823SubledgerVoucherGeneralJournalEntry .GeneralJournalEntry (General ledger)     ‑‑‑>    GeneralJournalEntry .RecId (General ledger)
824TmpAccountSum .CurrencyCode (General ledger)     ‑‑‑>    Currency .CurrencyCode (General ledger)
825TmpAccountSum .DefaultDimension (General ledger)     ‑‑‑>    DimensionAttributeValueSet .RecId (General ledger)
826TmpAccountSum .TaxCode (General ledger)     ‑‑‑>    TaxTable .TaxCode (Tax)
827TmpCurrencyLedgerGainLossAccount .CurrencyCode (General ledger)     ‑‑‑>    Currency .CurrencyCode (General ledger)
828TmpCurrencyLedgerGainLossAccount .LedgerDimension (General ledger)     ‑‑‑>    DimensionAttributeValueCombination .RecId (General ledger)
829TmpCurrencyLedgerGainLossAccount .TaxLedgerDimension_RU (General ledger)     ‑‑‑>    DimensionAttributeValueCombination .RecId (General ledger)
830TmpCurrencyLedgerGainLossAccount .Ledger (General ledger)     ‑‑‑>    Ledger .RecId (General ledger)
831TmpDimension .DefaultDimension (General ledger)     ‑‑‑>    DimensionAttributeValueSet .RecId (General ledger)
832TmpDimensionRelationshipConstraint .LeftDimensionHierarchyLevel (General ledger)     ‑‑‑>    DimensionHierarchyLevel .RecId (General ledger)
833TmpDimensionRelationshipConstraint .RightDimensionHierarchyLevel (General ledger)     ‑‑‑>    DimensionHierarchyLevel .RecId (General ledger)
834TmpDimensionRelationshipConstraint .DirRelationshipTypeTable (General ledger)     ‑‑‑>    DirRelationshipTypeTable .RelationshipTypeId (Sales and marketing)
835TmpDimensionRelationshipConstraint .OMHierarchyType (General ledger)     ‑‑‑>    OMHierarchyType .RecId (Server and Tools)
836TmpDimensionRuleAppliedHierarchy .DimensionHierarchy (General ledger)     ‑‑‑>    DimensionHierarchy .RecId (General ledger)
837TmpDimTransExtract .CurrencyCode (General ledger)     ‑‑‑>    Currency .CurrencyCode (General ledger)
838TmpDimTransExtract .LedgerDimension (General ledger)     ‑‑‑>    DimensionAttributeValueCombination .RecId (General ledger)
839TmpDimTransExtract .TaxTransGeneralJournalAccountEntry (General ledger)     ‑‑‑>    TaxTransGeneralJournalAccountEntry .RecId (Tax)
840TmpExchRates .CurrencyCode (General ledger)     ‑‑‑>    Currency .CurrencyCode (General ledger)
841TmpExchRateTxt .CurrencyCode (General ledger)     ‑‑‑>    Currency .CurrencyCode (General ledger)
842TmpJournalizingDefinitionTestResult .LedgerDimension (General ledger)     ‑‑‑>    DimensionAttributeValueCombination .RecId (General ledger)
843TmpLedgerAllocation .DefaultDimension (General ledger)     ‑‑‑>    DimensionAttributeValueSet .RecId (General ledger)
844TmpLedgerAllocation .AccountStructure (General ledger)     ‑‑‑>    DimensionHierarchy .RecId (General ledger)
845TmpLedgerAllocation .MainAccount (General ledger)     ‑‑‑>    MainAccount .RecId (General ledger)
846TmpLedgerBalanceControl .Fky?, .AccountNum (General ledger)     ‑‑‑>    BankAccountTable .Pky?, .AccountID (Cash and bank management)
847TmpLedgerBalanceControl .LedgerDimension (General ledger)     ‑‑‑>    DimensionAttributeValueCombination .RecId (General ledger)
848TmpLedgerBalanceControl .JournalName (General ledger)     ‑‑‑>    LedgerJournalName .JournalName (General ledger)
849TmpLedgerBalanceControl .Fky?, .AccountNum (General ledger)     ‑‑‑>    RCashTable .Pky?, .AccountNum (Global financial management - Russia)
850TmpLedgerBase .Fky?, .Fky?, .id (General ledger)     ‑‑‑>    BankAccountTable .Pky?, .Pky?, .AccountID (Cash and bank management)
851TmpLedgerBase .Fky?, .id (General ledger)     ‑‑‑>    BankAccountTable .Pky?, .AccountID (Cash and bank management)
852TmpLedgerBase .RecordTableId, .RecordRecId (General ledger)     ‑‑‑>    Common .TableId, .RecId (Unknown module)
853TmpLedgerBase .CurrencyCode (General ledger)     ‑‑‑>    Currency .CurrencyCode (General ledger)
854TmpLedgerBase .Fky?, .RecordTableId, .id (General ledger)     ‑‑‑>    CustTable .Pky?, .TableId, .AccountNum (Sales and marketing)
855TmpLedgerBase .LedgerDimension (General ledger)     ‑‑‑>    DimensionAttributeValueCombination .RecId (General ledger)
856TmpLedgerBase .DefaultDimension (General ledger)     ‑‑‑>    DimensionAttributeValueSet .RecId (General ledger)
857TmpLedgerBase .Fky?, .id (General ledger)     ‑‑‑>    EmployeeTable_RU .Pky?, .EmployeeId (Global financial management - Russia)
858TmpLedgerBase .Fky? (General ledger)     ‑‑‑>    EmployeeTable_RU .Pky? (Global financial management - Russia)
859TmpLedgerBase .Fky?, .id (General ledger)     ‑‑‑>    InventTable .Pky?, .ItemId (Inventory and warehouse management)
860TmpLedgerBase .Fky?, .id (General ledger)     ‑‑‑>    InventTable .Pky?, .ItemId (Inventory and warehouse management)
861TmpLedgerBase .Fky?, .id (General ledger)     ‑‑‑>    ProdTable .Pky?, .ProdId (Manufacturing)
862TmpLedgerBase .Fky?, .id (General ledger)     ‑‑‑>    RAssetTable .Pky?, .AccountNum (Global financial management - Russia)
863TmpLedgerBase .Fky?, .id (General ledger)     ‑‑‑>    RAssetTable .Pky?, .AccountNum (Global financial management - Russia)
864TmpLedgerBase .Fky?, .id (General ledger)     ‑‑‑>    RCashTable .Pky?, .AccountNum (Global financial management - Russia)
865TmpLedgerBase .Fky?, .id (General ledger)     ‑‑‑>    RCashTable .Pky?, .AccountNum (Global financial management - Russia)
866TmpLedgerBase .Fky?, .id (General ledger)     ‑‑‑>    TaxTable .Pky?, .TaxCode (Tax)
867TmpLedgerBase .Fky?, .id (General ledger)     ‑‑‑>    VendTable .Pky?, .AccountNum (Procurement and sourcing)
868TmpLedgerConsCompany .SourceCompany, .Fky? (General ledger)     ‑‑‑>    DataArea .id, .Pky? (Unknown module)
869TmpLedgerConsDimensionAttribute .LegalEntity, .Fky? (General ledger)     ‑‑‑>    DataArea .id, .Pky? (Unknown module)
870TmpLedgerConsDimensionValueItem .LegalEntity, .Fky? (General ledger)     ‑‑‑>    DataArea .id, .Pky? (Unknown module)
871TmpLedgerConsElimination .RuleId (General ledger)     ‑‑‑>    LedgerEliminationRule .RuleId (General ledger)
872TmpLedgerConsElimination .JournalName (General ledger)     ‑‑‑>    LedgerJournalName .JournalName (General ledger)
873TmpLedgerConsElimination .ReasonRefRecId (General ledger)     ‑‑‑>    ReasonTableRef .RecId (General ledger)
874TmpLedgerConsTrans .CurrencyCode (General ledger)     ‑‑‑>    Currency .CurrencyCode (General ledger)
875TmpLedgerConsTrans .TmpDataAreaId, .Fky? (General ledger)     ‑‑‑>    DataArea .id, .Pky? (Unknown module)
876TmpLedgerConsTrans .DimensionHierarchy (General ledger)     ‑‑‑>    DimensionHierarchy .RecId (General ledger)
877TmpLedgerJournalAccountMovement .CompanyId, .Fky? (General ledger)     ‑‑‑>    DataArea .id, .Pky? (Unknown module)
878TmpLedgerJournalAccountMovement .LedgerDimension (General ledger)     ‑‑‑>    DimensionAttributeValueCombination .RecId (General ledger)
879TmpLedgerJournalControlDetail .LedgerLegalEntity (General ledger)     ‑‑‑>    CompanyInfo .RecId (General ledger)
880TmpLedgerJournalControlDetail .DimensionAttribute (General ledger)     ‑‑‑>    DimensionAttribute .RecId (General ledger)
881TmpLedgerJournalControlDetail .DimensionConstraintTree (General ledger)     ‑‑‑>    DimensionConstraintTree .RecId (General ledger)
882TmpLedgerJournalControlDetail .DimensionHierarchy (General ledger)     ‑‑‑>    DimensionHierarchy .RecId (General ledger)
883TmpLedgerJournalControlDetail .LedgerJournalControlDetail (General ledger)     ‑‑‑>    LedgerJournalControlDetail .RecId (General ledger)
884TmpLedgerJournalSplitHeader .TaxGroup (General ledger)     ‑‑‑>    TaxGroupHeading .TaxGroup (Tax)
885TmpLedgerJournalSplitHeader .TaxItemGroup (General ledger)     ‑‑‑>    TaxItemGroupHeading .TaxItemGroup (Tax)
886TmpLedgerJournalSplitHeader .TaxCode (General ledger)     ‑‑‑>    TaxTable .TaxCode (Tax)
887TmpLedgerJournalSplitLines .LedgerDimension (General ledger)     ‑‑‑>    DimensionAttributeValueCombination .RecId (General ledger)
888TmpLedgerJournalSplitLines .OffsetRecId (General ledger)     ‑‑‑>    LedgerJournalTrans .RecId (General ledger)
889TmpLedgerJournalSplitLines .OriginalRecId (General ledger)     ‑‑‑>    LedgerJournalTrans .RecId (General ledger)
890TmpLedgerJournalSplitLines .LineNum (General ledger)     ‑‑‑>    TmpLedgerJournalSplitHeader .LineNum (General ledger)
891TmpLedgerPaymentControl .CurrencyCode (General ledger)     ‑‑‑>    Currency .CurrencyCode (General ledger)
892TmpLedgerPaymentControl .Company, .Fky? (General ledger)     ‑‑‑>    DataArea .id, .Pky? (Unknown module)
893TmpLedgerPaymentControl .JournalName (General ledger)     ‑‑‑>    LedgerJournalName .JournalName (General ledger)
894TmpLedgerPaymentControl .JournalNum (General ledger)     ‑‑‑>    LedgerJournalTable .JournalNum (General ledger)
895TmpLedgerPaymentControlCur .CurrencyCode (General ledger)     ‑‑‑>    Currency .CurrencyCode (General ledger)
896TmpLedgerPaymentControlCur .JournalName (General ledger)     ‑‑‑>    LedgerJournalName .JournalName (General ledger)
897TmpLedgerPaymentControlCur .JournalNum (General ledger)     ‑‑‑>    LedgerJournalTable .JournalNum (General ledger)
898TmpLedgerTable .CompanyId, .Fky? (General ledger)     ‑‑‑>    DataArea .id, .Pky? (Unknown module)
899TmpLedgerTable .LedgerDimension (General ledger)     ‑‑‑>    DimensionAttributeValueCombination .RecId (General ledger)
900TmpLedgerTrans .CurrencyCode (General ledger)     ‑‑‑>    Currency .CurrencyCode (General ledger)
901TmpLedgerTrans .Company, .Fky? (General ledger)     ‑‑‑>    DataArea .id, .Pky? (Unknown module)
902TmpLedgerTrans .LedgerDimensionId (General ledger)     ‑‑‑>    DimensionAttributeValueCombination .RecId (General ledger)
903TmpLedgerTrans .LedgerPostingJournalId (General ledger)     ‑‑‑>    LedgerPostingJournal .LedgerPostingJournalId (Global financial management - Western Europe)
904TmpMainAccount .MainAccount (General ledger)     ‑‑‑>    MainAccount .RecId (General ledger)
905TmpXBRLTaxonomyDetailsReferences .RowDefinition (General ledger)     ‑‑‑>    LedgerRowDef .RowDefinition (General ledger)
906TransactionReversalTrans .RefTableId, .RefRecId (General ledger)     ‑‑‑>    Common .TableId, .RecId (Unknown module)
907TransactionTextParameterSetup .TransactText (General ledger)     ‑‑‑>    TransactTxt .RecId (General ledger)
908TransactTxt .LanguageId (General ledger)     ‑‑‑>    LanguageTable .LanguageId (Developer and Partner Tools)
909XBRLTaxonomyArc .TaxonomyId (General ledger)     ‑‑‑>    XBRLTaxonomy .TaxonomyID (General ledger)
910XBRLTaxonomyArc .ExtendedLinkRecId (General ledger)     ‑‑‑>    XBRLTaxonomyExtendedLink .RecId (General ledger)
911XBRLTaxonomyArc .TaxonomyFileRecId (General ledger)     ‑‑‑>    XBRLTaxonomyFile .RecId (General ledger)
912XBRLTaxonomyArc .TaxonomyId, .FromElement, .ArcType, .ExtendedLinkRecId (General ledger)     ‑‑‑>    XBRLTaxonomyLocator .TaxonomyId, .Label, .LinkbaseType, .ExtendedLinkRecId (General ledger)
913XBRLTaxonomyComplexType .TaxonomyId (General ledger)     ‑‑‑>    XBRLTaxonomy .TaxonomyID (General ledger)
914XBRLTaxonomyComplexType .TaxonomyFileRecId (General ledger)     ‑‑‑>    XBRLTaxonomyFile .RecId (General ledger)
915XBRLTaxonomyComplexTypeValue .TaxonomyId (General ledger)     ‑‑‑>    XBRLTaxonomy .TaxonomyID (General ledger)
916XBRLTaxonomyComplexTypeValue .ComplexTypeName, .TaxonomyId (General ledger)     ‑‑‑>    XBRLTaxonomyComplexType .ComplexTypeName, .TaxonomyId (General ledger)
917XBRLTaxonomyElement .TaxonomyId (General ledger)     ‑‑‑>    XBRLTaxonomy .TaxonomyID (General ledger)
918XBRLTaxonomyElement .TaxonomyFileRecId (General ledger)     ‑‑‑>    XBRLTaxonomyFile .RecId (General ledger)
919XBRLTaxonomyElement .TaxonomyId, .ElementId (General ledger)     ‑‑‑>    XBRLTaxonomyLocator .TaxonomyId, .ElementId (General ledger)
920XBRLTaxonomyElement .TargetNamespaceRecId (General ledger)     ‑‑‑>    XBRLTaxonomyTargetNamespace .RecId (General ledger)
921XBRLTaxonomyElementValue .TaxonomyId (General ledger)     ‑‑‑>    XBRLTaxonomy .TaxonomyID (General ledger)
922XBRLTaxonomyElementValue .ElementId, .TaxonomyId (General ledger)     ‑‑‑>    XBRLTaxonomyElement .ElementId, .TaxonomyId (General ledger)
923XBRLTaxonomyExtendedLink .TaxonomyId (General ledger)     ‑‑‑>    XBRLTaxonomy .TaxonomyID (General ledger)
924XBRLTaxonomyExtendedLink .TaxonomyFileRecId (General ledger)     ‑‑‑>    XBRLTaxonomyFile .RecId (General ledger)
925XBRLTaxonomyFile .TaxonomyId (General ledger)     ‑‑‑>    XBRLTaxonomy .TaxonomyID (General ledger)
926XBRLTaxonomyLabelElement .TaxonomyId (General ledger)     ‑‑‑>    XBRLTaxonomy .TaxonomyID (General ledger)
927XBRLTaxonomyLabelElement .Fky?, .TaxonomyId, .Label (General ledger)     ‑‑‑>    XBRLTaxonomyArc .Pky?, .TaxonomyId, .ToElement (General ledger)
928XBRLTaxonomyLabelElement .ExtendedLinkRecId (General ledger)     ‑‑‑>    XBRLTaxonomyExtendedLink .RecId (General ledger)
929XBRLTaxonomyLabelElement .TaxonomyFileRecId (General ledger)     ‑‑‑>    XBRLTaxonomyFile .RecId (General ledger)
930XBRLTaxonomyLines .TaxonomyId (General ledger)     ‑‑‑>    XBRLTaxonomyTable .TaxonomyId (General ledger)
931XBRLTaxonomyLocator .TaxonomyId (General ledger)     ‑‑‑>    XBRLTaxonomy .TaxonomyID (General ledger)
932XBRLTaxonomyLocator .TaxonomyId, .Label, .LinkbaseType, .ExtendedLinkRecId (General ledger)     ‑‑‑>    XBRLTaxonomyArc .TaxonomyId, .ToElement, .ArcType, .ExtendedLinkRecId (General ledger)
933XBRLTaxonomyLocator .TaxonomyId, .ElementId (General ledger)     ‑‑‑>    XBRLTaxonomyElement .TaxonomyId, .ElementId (General ledger)
934XBRLTaxonomyLocator .ExtendedLinkRecId (General ledger)     ‑‑‑>    XBRLTaxonomyExtendedLink .RecId (General ledger)
935XBRLTaxonomyLocator .TaxonomyFileRecId (General ledger)     ‑‑‑>    XBRLTaxonomyFile .RecId (General ledger)
936XBRLTaxonomyReferenceElement .TaxonomyId (General ledger)     ‑‑‑>    XBRLTaxonomy .TaxonomyID (General ledger)
937XBRLTaxonomyReferenceElement .Fky?, .TaxonomyId, .Label (General ledger)     ‑‑‑>    XBRLTaxonomyArc .Pky?, .TaxonomyId, .ToElement (General ledger)
938XBRLTaxonomyReferenceElement .ExtendedLinkRecId (General ledger)     ‑‑‑>    XBRLTaxonomyExtendedLink .RecId (General ledger)
939XBRLTaxonomyReferenceElement .TaxonomyFileRecId (General ledger)     ‑‑‑>    XBRLTaxonomyFile .RecId (General ledger)
940XBRLTaxonomyTargetNamespace .TaxonomyId (General ledger)     ‑‑‑>    XBRLTaxonomy .TaxonomyID (General ledger)



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