Microsoft Dynamics AX 2012 R2

AxErd: Child-Parents: Fixed assets

Module: Fixed assets

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
201AssetPackingSlipTmp .AssetId (Fixed assets)     ‑‑‑>    AssetTable .AssetId (Fixed assets)
202AssetParameters .BookIdDefault (Fixed assets)     ‑‑‑>    AssetBookTable .BookId (Fixed assets)
203AssetParameters .PostingProfile (Fixed assets)     ‑‑‑>    AssetLedger .PostingProfile (Fixed assets)
204AssetParameters .AssetDefaultSaleLedgerDimension_PL (Fixed assets)     ‑‑‑>    DimensionAttributeValueCombination .RecId (General ledger)
205AssetParameters .LedgerDimension (Fixed assets)     ‑‑‑>    DimensionAttributeValueCombination .RecId (General ledger)
206AssetParameters .InventJournalNameId, .Fky? (Fixed assets)     ‑‑‑>    InventJournalName .JournalNameId, .Pky? (Inventory and warehouse management)
207AssetParameters .AssetUserGroupIdPostPO (Fixed assets)     ‑‑‑>    UserGroupInfo .id (Server and Tools)
208AssetReplacementTmp .Location (Fixed assets)     ‑‑‑>    AssetLocation .Location (Fixed assets)
209AssetReplacementTmp .AssetId (Fixed assets)     ‑‑‑>    AssetTable .AssetId (Fixed assets)
210AssetReserveTransactionsTmp .BookId (Fixed assets)     ‑‑‑>    AssetBookTable .BookId (Fixed assets)
211AssetReserveTransactionsTmp .AssetGroup (Fixed assets)     ‑‑‑>    AssetGroup .GroupId (Fixed assets)
212AssetReserveTransactionsTmp .ReserveTransferDone (Fixed assets)     ‑‑‑>    AssetReserveType .ReserveType (Fixed assets)
213AssetReserveTransactionsTmp .AssetId (Fixed assets)     ‑‑‑>    AssetTable .AssetId (Fixed assets)
214AssetReserveTransactionsTmp .CurrencyCode (Fixed assets)     ‑‑‑>    Currency .CurrencyCode (General ledger)
215AssetRevaluationGroupSpec .RevaluationGroupId (Fixed assets)     ‑‑‑>    AssetRevaluationGroup .RevaluationGroupId (Fixed assets)
216AssetsInAssetStatementTmp .AssetGroup (Fixed assets)     ‑‑‑>    AssetGroup .GroupId (Fixed assets)
217AssetsInAssetStatementTmp .AssetId (Fixed assets)     ‑‑‑>    AssetTable .AssetId (Fixed assets)
218AssetStatementFixedAssetsTmp .AssetGroup (Fixed assets)     ‑‑‑>    AssetGroup .GroupId (Fixed assets)
219AssetStatementFixedAssetsTmp .AssetId (Fixed assets)     ‑‑‑>    AssetTable .AssetId (Fixed assets)
220AssetStatementInterval .AssetStatementLineNum (Fixed assets)     ‑‑‑>    AssetStatementRow .LineNum (Fixed assets)
221AssetStatementInterval .FromAsset (Fixed assets)     ‑‑‑>    AssetTable .AssetId (Fixed assets)
222AssetStatementInterval .ToAsset (Fixed assets)     ‑‑‑>    AssetTable .AssetId (Fixed assets)
223AssetStatementRowSetupTmp .RowName (Fixed assets)     ‑‑‑>    AssetStatementRow .RowName (Fixed assets)
224AssetStatementRowSetupTmp .FromAsset (Fixed assets)     ‑‑‑>    AssetTable .AssetId (Fixed assets)
225AssetStatementRowSetupTmp .ToAsset (Fixed assets)     ‑‑‑>    AssetTable .AssetId (Fixed assets)
226AssetTable .AssetActivityCode (Fixed assets)     ‑‑‑>    AssetActivityCode .RecId (Fixed assets)
227AssetTable .Fky?, .CategoryId_LV (Fixed assets)     ‑‑‑>    AssetBookTable .Pky?, .BookId (Fixed assets)
228AssetTable .Condition (Fixed assets)     ‑‑‑>    AssetCondition .Condition (Fixed assets)
229AssetTable .AssetGroup (Fixed assets)     ‑‑‑>    AssetGroup .GroupId (Fixed assets)
230AssetTable .Location (Fixed assets)     ‑‑‑>    AssetLocation .Location (Fixed assets)
231AssetTable .MajorType (Fixed assets)     ‑‑‑>    AssetMajorType .MajorType (Fixed assets)
232AssetTable .AssetPropertyGroup (Fixed assets)     ‑‑‑>    AssetPropertyGroup .RecId (Fixed assets)
233AssetTable .SortingId, .Fky? (Fixed assets)     ‑‑‑>    AssetSorting .SortingId, .Pky? (Fixed assets)
234AssetTable .SortingId2, .Fky? (Fixed assets)     ‑‑‑>    AssetSorting .SortingId, .Pky? (Fixed assets)
235AssetTable .SortingId3, .Fky? (Fixed assets)     ‑‑‑>    AssetSorting .SortingId, .Pky? (Fixed assets)
236AssetTable .AssetSourceType_CN (Fixed assets)     ‑‑‑>    AssetSourceType_CN .RecId (Global financial management - Asia Pacific)
237AssetTable .MainAssetId (Fixed assets)     ‑‑‑>    AssetTable .AssetId (Fixed assets)
238AssetTable .DefaultDimension (Fixed assets)     ‑‑‑>    DimensionAttributeValueSet .RecId (General ledger)
239AssetTable .WorkerContactName (Fixed assets)     ‑‑‑>    HcmWorker .RecId (Human resources)
240AssetTable .WorkerResponsible (Fixed assets)     ‑‑‑>    HcmWorker .RecId (Human resources)
241AssetTable .Department (Fixed assets)     ‑‑‑>    OMOperatingUnit .RecId (Server and Tools)
242AssetTable .PurchLineRecId (Fixed assets)     ‑‑‑>    PurchLine .RecId (Procurement and sourcing)
243AssetTable .UnitOfMeasure (Fixed assets)     ‑‑‑>    UnitOfMeasure .Symbol (Inventory and warehouse management)
244AssetTable .InsuranceVendor (Fixed assets)     ‑‑‑>    VendTable .AccountNum (Procurement and sourcing)
245AssetTaxCategoryDepreciationTmp .CategoryId (Fixed assets)     ‑‑‑>    AssetBookTable .BookId (Fixed assets)
246AssetTaxCategoryDepreciationTmp .AssetId (Fixed assets)     ‑‑‑>    AssetTable .AssetId (Fixed assets)
247AssetTaxDepreciationCategoryDetail .AssetId (Fixed assets)     ‑‑‑>    AssetTable .AssetId (Fixed assets)
248AssetTaxDepreciationCategoryDetail .AssetTaxDeprCategoryRecId (Fixed assets)     ‑‑‑>    AssetTaxDeprCategory_LV .RecId (Global financial management - Eastern Europe)
249AssetTmpAssetTransferHistory .BookId (Fixed assets)     ‑‑‑>    AssetBookTable .BookId (Fixed assets)
250AssetTmpAssetTransferHistory .AssetId (Fixed assets)     ‑‑‑>    AssetTable .AssetId (Fixed assets)
251AssetTmpAssetTransferHistory .TransferSequenceNumber (Fixed assets)     ‑‑‑>    NumberSequenceTable .NumberSequence (Server and Tools)
252AssetTmpInventoryWorkSheet .BookId (Fixed assets)     ‑‑‑>    AssetBookTable .BookId (Fixed assets)
253AssetTmpInventoryWorkSheet .Location (Fixed assets)     ‑‑‑>    AssetLocation .Location (Fixed assets)
254AssetTmpInventoryWorkSheet .AssetId (Fixed assets)     ‑‑‑>    AssetTable .AssetId (Fixed assets)
255AssetTrans .BookId, .AssetId (Fixed assets)     ‑‑‑>    AssetBook .BookId, .AssetId (Fixed assets)
256AssetTrans .BookId (Fixed assets)     ‑‑‑>    AssetBookTable .BookId (Fixed assets)
257AssetTrans .AssetGroup (Fixed assets)     ‑‑‑>    AssetGroup .GroupId (Fixed assets)
258AssetTrans .PostingProfile (Fixed assets)     ‑‑‑>    AssetLedger .PostingProfile (Fixed assets)
259AssetTrans .AssetId (Fixed assets)     ‑‑‑>    AssetTable .AssetId (Fixed assets)
260AssetTrans .LVPTransferId_AU (Fixed assets)     ‑‑‑>    AssetTable .AssetId (Fixed assets)
261AssetTrans .ReserveTransId (Fixed assets)     ‑‑‑>    AssetTrans .RecId (Fixed assets)
262AssetTrans .RevaluedTransID (Fixed assets)     ‑‑‑>    AssetTrans .RecId (Fixed assets)
263AssetTrans .CurrencyCode (Fixed assets)     ‑‑‑>    Currency .CurrencyCode (General ledger)
264AssetTrans .DefaultDimension (Fixed assets)     ‑‑‑>    DimensionAttributeValueSet .RecId (General ledger)
265AssetTrans .Approver (Fixed assets)     ‑‑‑>    HcmWorker .RecId (Human resources)
266AssetTrans .ReasonRefRecId (Fixed assets)     ‑‑‑>    ReasonTableRef .RecId (General ledger)
267AssetTransactionListingTmp .BookID (Fixed assets)     ‑‑‑>    AssetBookMerge .BookId (Fixed assets)
268AssetTransactionListingTmp .AssetGroup (Fixed assets)     ‑‑‑>    AssetGroup .GroupId (Fixed assets)
269AssetTransactionListingTmp .Location (Fixed assets)     ‑‑‑>    AssetLocation .Location (Fixed assets)
270AssetTransactionListingTmp .AssetID (Fixed assets)     ‑‑‑>    AssetTable .AssetId (Fixed assets)
271AssetTransactionListingTmp .CurrencyCode (Fixed assets)     ‑‑‑>    Currency .CurrencyCode (General ledger)
272AssetTransferHistory .BookId, .AssetId (Fixed assets)     ‑‑‑>    AssetBook .BookId, .AssetId (Fixed assets)
273AssetTransferHistory .BookId (Fixed assets)     ‑‑‑>    AssetBookTable .BookId (Fixed assets)
274AssetTransferHistory .AssetId (Fixed assets)     ‑‑‑>    AssetTable .AssetId (Fixed assets)
275AssetTransferHistory .FromDimension (Fixed assets)     ‑‑‑>    DimensionAttributeValueSet .RecId (General ledger)
276AssetTransferHistory .ToDimension (Fixed assets)     ‑‑‑>    DimensionAttributeValueSet .RecId (General ledger)
277AssetTransferHistory .TransferSequenceNumber (Fixed assets)     ‑‑‑>    NumberSequenceTable .NumberSequence (Server and Tools)
278TmpAssetBookCompare .BookId (Fixed assets)     ‑‑‑>    AssetBookMergeLookup .BookId (Fixed assets)
279TmpAssetBookCompare .AssetId (Fixed assets)     ‑‑‑>    AssetTable .AssetId (Fixed assets)
280TmpAssetConsumptionProposal .AssetBookType, .BookId, .AssetId (Fixed assets)     ‑‑‑>    AssetBookMerge .BookType, .BookId, .AssetId (Fixed assets)
281TmpAssetConsumptionProposal .BookId (Fixed assets)     ‑‑‑>    AssetBookMergeLookup .BookId (Fixed assets)
282TmpAssetConsumptionProposal .AssetId (Fixed assets)     ‑‑‑>    AssetTable .AssetId (Fixed assets)
283TmpAssetDepBookTransBase .JournalNumber (Fixed assets)     ‑‑‑>    AssetDepBookJournalTable .JournalId (Fixed assets)
284TmpAssetDepBookTransBase .Fky?, .AssetId (Fixed assets)     ‑‑‑>    AssetTable .Pky?, .AssetId (Fixed assets)
285TmpAssetDepBookTransBase .RecordTableId, .RecordRecId (Fixed assets)     ‑‑‑>    Common .TableId, .RecId (Unknown module)
286TmpAssetDepBookTransBase .CurrencyCode (Fixed assets)     ‑‑‑>    Currency .CurrencyCode (General ledger)
287TmpAssetGroupCOT .AssetGroupId (Fixed assets)     ‑‑‑>    AssetGroup .GroupId (Fixed assets)
288tmpAssetTableCOT .AssetId (Fixed assets)     ‑‑‑>    AssetTable .AssetId (Fixed assets)
289TmpAssetTrans .BookId (Fixed assets)     ‑‑‑>    AssetBookTable .BookId (Fixed assets)
290TmpAssetTrans .AssetGroup (Fixed assets)     ‑‑‑>    AssetGroup .GroupId (Fixed assets)
291TmpAssetTrans .AssetId (Fixed assets)     ‑‑‑>    AssetTable .AssetId (Fixed assets)
292TmpAssetTrans .CurrencyCode (Fixed assets)     ‑‑‑>    Currency .CurrencyCode (General ledger)
293TmpDateSumCode .FiscalCalendarPeriod (Fixed assets)     ‑‑‑>    FiscalCalendarPeriod .RecId (General ledger)



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