Microsoft Dynamics AX 2012 R2

AxErd: Parent-Children: Inventory and warehouse management

Module: Inventory and warehouse management

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
501InventDimCombination .InventDimId, .ItemId (Inventory and warehouse management)     <‑‑‑    CustVendExternalItem .InventDimId, .ItemId (Procurement and sourcing)
502InventDimCombination .TableId (Inventory and warehouse management)     <‑‑‑    ExtCodeTable .ExtCodeTableId (Procurement and sourcing)
503InventDimCombination .TableId, .RecId (Inventory and warehouse management)     <‑‑‑    ExtCodeValueTable .ExtCodeRelationTableId, .ExtCodeRelationRecId (Procurement and sourcing)
504InventDimCombination .RetailVariantId (Inventory and warehouse management)     <‑‑‑    InventItemBarcode .RetailVariantId (Inventory and warehouse management)
505InventDimCombination .InventDimId, .ItemId (Inventory and warehouse management)     <‑‑‑    InventProductGroupItem .InventDimId, .ItemId (Procurement and sourcing)
506InventDimCombination .RetailVariantId (Inventory and warehouse management)     <‑‑‑    PurchLine .VariantId (Procurement and sourcing)
507InventDimCombination .RetailVariantId (Inventory and warehouse management)     <‑‑‑    RetailInventItemLabel .VariantId (Retail)
508InventDimCombination .RetailVariantId (Inventory and warehouse management)     <‑‑‑    RetailPackageLines .VariantId (Retail)
509InventDimCombination .RetailVariantId (Inventory and warehouse management)     <‑‑‑    RetailTMPInventDimCombination .VariantId (Retail)
510InventDimCombination .RetailVariantId (Inventory and warehouse management)     <‑‑‑    RetailTMPTransactionSalesTrans .variantId (Retail)
511InventDimCombination .RetailVariantId (Inventory and warehouse management)     <‑‑‑    RetailTransactionSalesTrans .variantId (Retail)
512InventDimCombination .RetailVariantId (Inventory and warehouse management)     <‑‑‑    SalesLine .RetailVariantId (Procurement and sourcing)
513InventDimCombination .RetailVariantId (Inventory and warehouse management)     <‑‑‑    SalesQuotationLine .RetailVariantId (Procurement and sourcing)
514InventItemBarcode .itemBarCode (Inventory and warehouse management)     <‑‑‑    PurchLine .BarCode (Procurement and sourcing)
515InventItemBarcode .itemBarCode (Inventory and warehouse management)     <‑‑‑    PurchLineHistory .BarCode (Procurement and sourcing)
516InventItemBarcode .itemBarCode (Inventory and warehouse management)     <‑‑‑    RetailCompetitorPriceTable .barcode (Retail)
517InventItemBarcode .itemBarCode (Inventory and warehouse management)     <‑‑‑    RetailDiscountCode .BarCode (Retail)
518InventItemBarcode .itemBarCode (Inventory and warehouse management)     <‑‑‑    RetailImportJournalTrans .ItemBarCode (Retail)
519InventItemBarcode .itemBarCode (Inventory and warehouse management)     <‑‑‑    RetailImportTrans .ItemBarCode (Retail)
520InventItemBarcode .itemBarCode (Inventory and warehouse management)     <‑‑‑    RetailInventErrorNotifyTable .itemBarCode (Retail)
521InventItemBarcode .itemBarCode (Inventory and warehouse management)     <‑‑‑    RetailInventItemLabel .ItemBarCode (Retail)
522InventItemBarcode .itemId (Inventory and warehouse management)     <‑‑‑    RetailInventItemSectionLocation .itemId (Retail)
523InventItemBarcode .itemBarCode (Inventory and warehouse management)     <‑‑‑    RetailInvReceivingLine .Barcode (Retail)
524InventItemBarcode .itemBarCode (Inventory and warehouse management)     <‑‑‑    RetailInvTransferPickingLine .Barcode (Retail)
525InventItemBarcode .itemBarCode (Inventory and warehouse management)     <‑‑‑    RetailStockCountLine .Barcode (Retail)
526InventItemBarcode .itemBarCode (Inventory and warehouse management)     <‑‑‑    RetailTMPTransactionSalesTrans .barcode (Retail)
527InventItemBarcode .itemBarCode (Inventory and warehouse management)     <‑‑‑    RetailTransactionSalesTrans .barcode (Retail)
528InventItemBarcode .itemBarCode (Inventory and warehouse management)     <‑‑‑    SalesLine .BarCode (Procurement and sourcing)
529InventItemBarcode .itemBarCode (Inventory and warehouse management)     <‑‑‑    SalesQuotationLine .BarCode (Procurement and sourcing)
530InventItemGroup .ItemGroupId (Inventory and warehouse management)     <‑‑‑    BOMConsistOfTmp .InventTableItemGroup (Manufacturing)
531InventItemGroup .ItemGroupId (Inventory and warehouse management)     <‑‑‑    BOMPartOfTmp .InventTable_ItemGroup (Manufacturing)
532InventItemGroup .ItemGroupId (Inventory and warehouse management)     <‑‑‑    BOMTable .ItemGroupId (Manufacturing)
533InventItemGroup .ItemGroupId (Inventory and warehouse management)     <‑‑‑    BusinessStatisticsData .ItemGroupId (General ledger)
534InventItemGroup .Pky?, .ItemGroupId (Inventory and warehouse management)     <‑‑‑    CostSheetCalculationFactor .Fky?, .ItemRelation (Production control)
535InventItemGroup .ItemGroupId (Inventory and warehouse management)     <‑‑‑    CustSalesItemGroupStatisticsTmp_NA .ItemGroupId (Global financial management - North America)
536InventItemGroup .ItemGroupId (Inventory and warehouse management)     <‑‑‑    ForecastPurch .ItemGroupId (Manufacturing)
537InventItemGroup .ItemGroupId (Inventory and warehouse management)     <‑‑‑    ForecastSales .ItemGroupId (Manufacturing)
538InventItemGroup .ItemGroupId (Inventory and warehouse management)     <‑‑‑    ForecastSalesItemTmp .ItemGroupId (Manufacturing)
539InventItemGroup .ItemGroupId (Inventory and warehouse management)     <‑‑‑    InterCompanyGoodsInTransitTmp .InventItemGroup (Inventory and warehouse management)
540InventItemGroup .ItemGroupId (Inventory and warehouse management)     <‑‑‑    InventAgeGroupDimTmp .ItemGroupId (Inventory and warehouse management)
541InventItemGroup .Pky?, .ItemGroupId (Inventory and warehouse management)     <‑‑‑    InventBaileeCalcSetup_RU .Fky?, .ItemRelation (Global financial management - Russia)
542InventItemGroup .ItemGroupId (Inventory and warehouse management)     <‑‑‑    InventCostTmpTransBreakdown .ItemGroupId (Production control)
543InventItemGroup .ItemGroupId (Inventory and warehouse management)     <‑‑‑    InventItemGroupForm .ItemGroupId (Inventory and warehouse management)
544InventItemGroup .dataAreaId, .ItemGroupId (Inventory and warehouse management)     <‑‑‑    InventItemGroupItem .ItemGroupDataAreaId, .ItemGroupId (Inventory and warehouse management)
545InventItemGroup .ItemGroupId (Inventory and warehouse management)     <‑‑‑    InventPhysQtySumTmp_CN .ItemGroupId (Global financial management - Asia Pacific)
546InventItemGroup .Pky?, .ItemGroupId (Inventory and warehouse management)     <‑‑‑    InventPosting .Fky?, .ItemRelation (Inventory and warehouse management)
547InventItemGroup .ItemGroupId (Inventory and warehouse management)     <‑‑‑    InventSettlement .ItemGroupId (Production control)
548InventItemGroup .ItemGroupId (Inventory and warehouse management)     <‑‑‑    InventStockCardTmpLine .ItemGroupId (Global financial management - Asia Pacific)
549InventItemGroup .ItemGroupId (Inventory and warehouse management)     <‑‑‑    InventTentativePurchIvtSummaryTmp_CN .ItemGroupId (Global financial management - Asia Pacific)
550InventItemGroup .ItemGroupId (Inventory and warehouse management)     <‑‑‑    JournalizingDefinitionPayablesTrans .ItemGroupId (General ledger)
551InventItemGroup .ItemGroupId (Inventory and warehouse management)     <‑‑‑    JournalizingDefinitionPurchTrans .ItemGroupId (General ledger)
552InventItemGroup .ItemGroupId (Inventory and warehouse management)     <‑‑‑    PBAConfiguratedItemTmp .ItemGroupId (Manufacturing)
553InventItemGroup .ItemGroupId (Inventory and warehouse management)     <‑‑‑    PBAConsistOfTmp .ItemGroupId (Manufacturing)
554InventItemGroup .ItemGroupId (Inventory and warehouse management)     <‑‑‑    PBATable .ItemGroupId (Manufacturing)
555InventItemGroup .Pky?, .ItemGroupId (Inventory and warehouse management)     <‑‑‑    PdsComdPricingTemplateLine .Fky?, .MarginItemRelation (Procurement and sourcing)
556InventItemGroup .Pky?, .ItemGroupId (Inventory and warehouse management)     <‑‑‑    PdsCustSellableDays .Fky?, .ItemRelation (Inventory and warehouse management)
557InventItemGroup .Pky?, .ItemGroupId (Inventory and warehouse management)     <‑‑‑    PMFSequenceItemTable .Fky?, .ItemRelation (Manufacturing)
558InventItemGroup .ItemGroupId (Inventory and warehouse management)     <‑‑‑    PriceDiscSalesLineTmpPrintout .ItemGroupId (Procurement and sourcing)
559InventItemGroup .ItemGroupId (Inventory and warehouse management)     <‑‑‑    PriceDiscTmpPrintout .ItemGroupId (Procurement and sourcing)
560InventItemGroup .Pky?, .ItemGroupId (Inventory and warehouse management)     <‑‑‑    RAssetInventIssueGroupDefinition .Fky?, .ItemRelation (Global financial management - Russia)
561InventItemGroup .ItemGroupId (Inventory and warehouse management)     <‑‑‑    RAssetInventIssueQuotas .InventGroupId (Global financial management - Russia)
562InventItemGroup .ItemGroupId (Inventory and warehouse management)     <‑‑‑    ReqPO .ItemGroupId (Manufacturing)
563InventItemGroup .dataAreaId, .ItemGroupId (Inventory and warehouse management)     <‑‑‑    RetailAttributesLegalEntityLookup .ItemDataAreaId, .GroupItemGroup (Retail)
564InventItemGroup .ItemGroupId (Inventory and warehouse management)     <‑‑‑    RetailMassUpdateWorksheetLine .InventItemGroupItem_ItemGroupId (Retail)
565InventItemGroup .ItemGroupId (Inventory and warehouse management)     <‑‑‑    ReverseChargeItemGroup_UK .ItemGroupId (Global financial management - Western Europe)
566InventItemGroup .Pky?, .ItemGroupId (Inventory and warehouse management)     <‑‑‑    RouteOpr .Fky?, .ItemRelation (Manufacturing)
567InventItemGroup .ItemGroupId (Inventory and warehouse management)     <‑‑‑    RouteTable .ItemGroupId (Manufacturing)
568InventItemGroup .ItemGroupId (Inventory and warehouse management)     <‑‑‑    SalesOrderEntryStatistics .ItemGroupId (Global financial management - Western Europe)
569InventItemGroup .Pky?, .ItemGroupId (Inventory and warehouse management)     <‑‑‑    TaxesMatrix_BR .Fky?, .ItemRelation (Global financial management - Latin America)
570InventItemGroup .ItemGroupId (Inventory and warehouse management)     <‑‑‑    TmpABC .ItemGroupId (Enterprise Portal)
571InventItemGroup .ItemGroupId (Inventory and warehouse management)     <‑‑‑    TmpInventAge .itemGroupId (Inventory and warehouse management)
572InventItemGroup .ItemGroupId (Inventory and warehouse management)     <‑‑‑    TmpItemGroup_IN .ItemGroupId (Global financial management - Asia Pacific)
573InventItemGroup .ItemGroupId (Inventory and warehouse management)     <‑‑‑    TmpRAssetInventIssueOnHand .ItemGroupId (Global financial management - Russia)
574InventItemGroup .ItemGroupId (Inventory and warehouse management)     <‑‑‑    TmpRAssetInventIssueOnHandByItem .ItemGroupId (Global financial management - Russia)
575InventItemGroupItem .ItemDataAreaId, .ItemId (Inventory and warehouse management)     <‑‑‑    RetailMassUpdateWorksheetLine .dataAreaId, .ItemId (Retail)
576InventItemInventSetup .ItemId, .InventDimId (Inventory and warehouse management)     <‑‑‑    InventItemPurchSetup .ItemId, .InventDimId (Inventory and warehouse management)
577InventItemInventSetup .ItemId, .InventDimId (Inventory and warehouse management)     <‑‑‑    InventItemSalesSetup .ItemId, .InventDimId (Inventory and warehouse management)
578InventItemLocation .inventDimId, .ItemId (Inventory and warehouse management)     <‑‑‑    InventItemLocation .inventDimId, .ItemId (Inventory and warehouse management)
579InventItemLocation .ItemId, .inventDimId (Inventory and warehouse management)     <‑‑‑    InventItemLocationCountingStatus .ItemId, .InventDimId (Inventory and warehouse management)
580InventItemPurchSetup .ItemId, .InventDimId (Inventory and warehouse management)     <‑‑‑    InventItemInventSetup .ItemId, .InventDimId (Inventory and warehouse management)
581InventItemPurchSetup .ItemId, .InventDimId (Inventory and warehouse management)     <‑‑‑    InventItemSalesSetup .ItemId, .InventDimId (Inventory and warehouse management)
582InventItemSalesSetup .ItemId, .InventDimId (Inventory and warehouse management)     <‑‑‑    InventItemInventSetup .ItemId, .InventDimId (Inventory and warehouse management)
583InventItemSalesSetup .ItemId, .InventDimId (Inventory and warehouse management)     <‑‑‑    InventItemPurchSetup .ItemId, .InventDimId (Inventory and warehouse management)
584InventItemSampling .InventItemSamplingId (Inventory and warehouse management)     <‑‑‑    InventQualityOrderTable .ItemSamplingId (Inventory and warehouse management)
585InventItemSampling .InventItemSamplingId (Inventory and warehouse management)     <‑‑‑    InventTestAssociationTable .ItemSamplingId (Inventory and warehouse management)
586InventItemSampling .InventItemSamplingId (Inventory and warehouse management)     <‑‑‑    InventTestGroup .ItemSamplingId (Inventory and warehouse management)
587InventJournalName .JournalNameId, .Pky? (Inventory and warehouse management)     <‑‑‑    AssetParameters .InventJournalNameId, .Fky? (Fixed assets)
588InventJournalName .JournalNameId, .Pky? (Inventory and warehouse management)     <‑‑‑    AxdDocumentParameters .CountJournalNameId, .Fky? (Client)
589InventJournalName .JournalNameId, .Pky? (Inventory and warehouse management)     <‑‑‑    AxdDocumentParameters .ProfitLossJournalNameId, .Fky? (Client)
590InventJournalName .JournalNameId, .Pky? (Inventory and warehouse management)     <‑‑‑    AxdDocumentParameters .TransferJournalNameId, .Fky? (Client)
591InventJournalName .Pky?, .JournalNameId (Inventory and warehouse management)     <‑‑‑    BOMParmReportFinish .Fky?, .JournalNameId (Manufacturing)
592InventJournalName .JournalNameId (Inventory and warehouse management)     <‑‑‑    InventJournalReportParms_RU .InventJournalNameId (Global financial management - Russia)
593InventJournalName .JournalNameId (Inventory and warehouse management)     <‑‑‑    InventJournalTable .JournalNameId (Inventory and warehouse management)
594InventJournalName .JournalNameId, .Pky? (Inventory and warehouse management)     <‑‑‑    InventParameters .BOMJournalNameId, .Fky? (Inventory and warehouse management)
595InventJournalName .JournalNameId, .Pky? (Inventory and warehouse management)     <‑‑‑    InventParameters .CountJournalNameId, .Fky? (Inventory and warehouse management)
596InventJournalName .JournalNameId, .Pky? (Inventory and warehouse management)     <‑‑‑    InventParameters .InventBaileeJournalNameId_RU, .Fky? (Inventory and warehouse management)
597InventJournalName .JournalNameId, .Pky? (Inventory and warehouse management)     <‑‑‑    InventParameters .LossProfitJournalNameId, .Fky? (Inventory and warehouse management)
598InventJournalName .JournalNameId, .Pky? (Inventory and warehouse management)     <‑‑‑    InventParameters .MovementJournalNameId, .Fky? (Inventory and warehouse management)
599InventJournalName .JournalNameId (Inventory and warehouse management)     <‑‑‑    InventParameters .PdsCWInventJournalNameId (Inventory and warehouse management)
600InventJournalName .JournalNameId, .Pky? (Inventory and warehouse management)     <‑‑‑    InventParameters .TagCountingJournalNameId, .Fky? (Inventory and warehouse management)
601InventJournalName .JournalNameId, .Pky? (Inventory and warehouse management)     <‑‑‑    InventParameters .TransferJournalNameId, .Fky? (Inventory and warehouse management)
602InventJournalName .JournalNameId, .Pky? (Inventory and warehouse management)     <‑‑‑    JmgParameters .InventJournalNameLossProfit, .Fky? (Manufacturing)
603InventJournalName .JournalNameId, .Pky? (Inventory and warehouse management)     <‑‑‑    JmgParameters .ProjInventJournalNameId, .Fky? (Manufacturing)
604InventJournalName .Pky?, .JournalNameId (Inventory and warehouse management)     <‑‑‑    ProjParameters .Fky?, .inventJournalNameId (Project management and accounting)
605InventJournalName .JournalNameId, .Pky? (Inventory and warehouse management)     <‑‑‑    RetailParameters .defaultInventJournalName, .Fky? (Retail)
606InventJournalName .JournalNameId, .Pky? (Inventory and warehouse management)     <‑‑‑    RetailParametersEx2 .defaultTagCountJournal, .Fky? (Retail)
607InventJournalName .JournalNameId, .Pky? (Inventory and warehouse management)     <‑‑‑    RetailParametersEx2 .PRPostingTransferJournal, .Fky? (Retail)
608InventJournalName .JournalNameId, .Pky? (Inventory and warehouse management)     <‑‑‑    RetailParametersEx2 .PRPostingProfitLossJournal, .Fky? (Retail)
609InventJournalName .JournalNameId, .Pky? (Inventory and warehouse management)     <‑‑‑    SMAParameters .ProjJournalMaterial, .Fky? (Service management)
610InventJournalName .JournalNameId (Inventory and warehouse management)     <‑‑‑    TmpFrmVirtual .JournalNum (Procurement and sourcing)

Navigation:     Next_File




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