Microsoft Dynamics AX 2012 R2

AxErd: Child-Parents: Accounts Payable

Module: Accounts Payable

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
401VendPaymSchedLineHistory .ParentRecID (Accounts Payable)     ‑‑‑>    VendPaymSched .RecId (Accounts Payable)
402VendPaymSchedLineHistory .VendPaymSchedLine (Accounts Payable)     ‑‑‑>    VendPaymSchedLine .RecId (Accounts Payable)
403VendPrenote .BankAccountId (Accounts Payable)     ‑‑‑>    BankAccountTable .AccountID (Cash and bank management)
404VendPrenote .VendAccount, .VendAccountId (Accounts Payable)     ‑‑‑>    VendBankAccount .VendAccount, .AccountID (Procurement and sourcing)
405VendPrenote .VendAccount (Accounts Payable)     ‑‑‑>    VendTable .AccountNum (Procurement and sourcing)
406VendProcurementCategoryStatus .OperatingUnit (Accounts Payable)     ‑‑‑>    OMOperatingUnit .RecId (Server and Tools)
407VendProcurementCategoryStatus .VendorCategory (Accounts Payable)     ‑‑‑>    VendCategory .RecId (Procurement and sourcing)
408VendPromissoryNoteInvoice .CurrencyCode (Accounts Payable)     ‑‑‑>    Currency .CurrencyCode (General ledger)
409VendPromissoryNoteInvoice .PromissoryNoteId (Accounts Payable)     ‑‑‑>    VendPromissoryNoteJour .PromissoryNoteId (Accounts Payable)
410VendPromissoryNoteInvoice .InvoiceAccountNum (Accounts Payable)     ‑‑‑>    VendTable .AccountNum (Procurement and sourcing)
411VendPromissoryNoteInvoice .RecipientAccountNum (Accounts Payable)     ‑‑‑>    VendTable .AccountNum (Procurement and sourcing)
412VendPromissoryNoteInvoice .PromissoryNoteId (Accounts Payable)     ‑‑‑>    VendTrans .PromissoryNoteID (Accounts Payable)
413VendPromissoryNoteInvoice .InvoiceCompany, .InvoiceId (Accounts Payable)     ‑‑‑>    VendTrans .dataAreaId, .Invoice (Accounts Payable)
414VendPromissoryNoteJour .DocumentNum (Accounts Payable)     ‑‑‑>    BankPromissoryNoteTable .PromissoryNoteNum (Cash and bank management)
415VendPromissoryNoteJour .Fky? (Accounts Payable)     ‑‑‑>    LedgerJournalTrans .Pky? (General ledger)
416VendPromissoryNoteJour .LedgerJournalTransRecId (Accounts Payable)     ‑‑‑>    LedgerJournalTrans .RecId (General ledger)
417VendPromissoryNoteJour .VendAccount (Accounts Payable)     ‑‑‑>    VendTable .AccountNum (Procurement and sourcing)
418VendPromissoryNoteReportTmp .Currency (Accounts Payable)     ‑‑‑>    Currency .CurrencyCode (General ledger)
419VendPromissoryNoteReportTmp .CurrencyCode (Accounts Payable)     ‑‑‑>    Currency .CurrencyCode (General ledger)
420VendPromissoryNoteReportTmp .PaymMode (Accounts Payable)     ‑‑‑>    CustPaymModeTable .PaymMode (Accounts Receivable)
421VendPromissoryNoteReportTmp .InvoiceCompany, .Fky? (Accounts Payable)     ‑‑‑>    DataArea .id, .Pky? (Unknown module)
422VendPromissoryNoteReportTmp .PostingProfile (Accounts Payable)     ‑‑‑>    VendLedger .PostingProfile (Accounts Payable)
423VendPromissoryNoteReportTmp .PromissoryNoteId (Accounts Payable)     ‑‑‑>    VendPromissoryNoteJour .PromissoryNoteId (Accounts Payable)
424VendPromissoryNoteReportTmp .InvoiceAccountNum (Accounts Payable)     ‑‑‑>    VendTable .AccountNum (Procurement and sourcing)
425VendPromissoryNoteReportTmp .VendAccount (Accounts Payable)     ‑‑‑>    VendTable .AccountNum (Procurement and sourcing)
426VendPromissoryNoteTrans .RemittedtoBankAccountId (Accounts Payable)     ‑‑‑>    BankAccountTable .AccountID (Cash and bank management)
427VendPromissoryNoteTrans .BankPromissoryNoteNum (Accounts Payable)     ‑‑‑>    BankPromissoryNoteTable .PromissoryNoteNum (Cash and bank management)
428VendPromissoryNoteTrans .CurrencyCode (Accounts Payable)     ‑‑‑>    Currency .CurrencyCode (General ledger)
429VendPromissoryNoteTrans .PromissoryNoteId (Accounts Payable)     ‑‑‑>    VendPromissoryNoteJour .PromissoryNoteId (Accounts Payable)
430VendPromissoryNoteTrans .VendAccount (Accounts Payable)     ‑‑‑>    VendTable .AccountNum (Procurement and sourcing)
431VendProvisionalBalanceTmp .MainAccountId (Accounts Payable)     ‑‑‑>    MainAccount .MainAccountId (General ledger)
432VendProvisionalBalanceTmp .AccountNum (Accounts Payable)     ‑‑‑>    VendTable .AccountNum (Procurement and sourcing)
433VendQuestionnaire .VendorParty (Accounts Payable)     ‑‑‑>    DirPartyTable .RecId (Sales and marketing)
434VendQuestionnaire .QuestionnaireDataArea, .QuestionnaireDefinition (Accounts Payable)     ‑‑‑>    KMCollection .dataAreaId, .kmCollectionId (Human resources)
435VendQuestionnaire .QuestionnaireDataArea, .QuestionnaireResponse (Accounts Payable)     ‑‑‑>    KMVirtualNetworkAnswerTable .dataAreaId, .kmVirtualNetworkAnswerTableId (Human resources)
436VendQuestionnaire .VendorRequest (Accounts Payable)     ‑‑‑>    VendRequest .RecId (Procurement and sourcing)
437VendSettlement .OffsetCompany, .Fky? (Accounts Payable)     ‑‑‑>    DataArea .id, .Pky? (Unknown module)
438VendSettlement .CashDiscountLedgerDimension (Accounts Payable)     ‑‑‑>    DimensionAttributeValueCombination .RecId (General ledger)
439VendSettlement .DefaultDimension (Accounts Payable)     ‑‑‑>    DimensionAttributeValueSet .RecId (General ledger)
440VendSettlement .RemittanceAddress (Accounts Payable)     ‑‑‑>    LogisticsPostalAddress .RecId (Sales and marketing)
441VendSettlement .ReversedRecId_RU (Accounts Payable)     ‑‑‑>    VendSettlement .RecId (Accounts Payable)
442VendSettlement .AccountNum (Accounts Payable)     ‑‑‑>    VendTable .AccountNum (Procurement and sourcing)
443VendSettlement .OffsetAccountNum (Accounts Payable)     ‑‑‑>    VendTable .AccountNum (Procurement and sourcing)
444VendSettlement .TransCompany, .TransRecId, .AccountNum (Accounts Payable)     ‑‑‑>    VendTrans .dataAreaId, .RecId, .AccountNum (Accounts Payable)
445VendSettlement .OffsetRecid (Accounts Payable)     ‑‑‑>    VendTrans .RecId (Accounts Payable)
446VendSettlementExtensionTH .VendSettlement (Accounts Payable)     ‑‑‑>    VendSettlement .RecId (Accounts Payable)
447VendSettlementExtensionTH .VendUnrealizedRev (Accounts Payable)     ‑‑‑>    VendUnrealizedRev .RecId (Accounts Payable)
448VendTmpAccountSum .CurrencyCode (Accounts Payable)     ‑‑‑>    Currency .CurrencyCode (General ledger)
449VendTmpAccountSum .DefaultDimension (Accounts Payable)     ‑‑‑>    DimensionAttributeValueSet .RecId (General ledger)
450VendTmpAccountSum .TaxCode (Accounts Payable)     ‑‑‑>    TaxTable .TaxCode (Tax)
451VendTmpAccountSum .AccountNum (Accounts Payable)     ‑‑‑>    VendTable .AccountNum (Procurement and sourcing)
452VendTmpCompanyInfo .DataArea (Accounts Payable)     ‑‑‑>    DataArea .id (Unknown module)
453VendTmpCurrentVendorResult .VendorDataAreaId, .VendorAccountNum (Accounts Payable)     ‑‑‑>    VendTable .dataAreaId, .AccountNum (Procurement and sourcing)
454VendTmpInvoiceInfoLine .ProcurementCategory (Accounts Payable)     ‑‑‑>    EcoResCategory .RecId (Retail)
455VendTmpInvoiceInfoLine .InventDimId (Accounts Payable)     ‑‑‑>    InventDim .inventDimId (Inventory and warehouse management)
456VendTmpInvoiceInfoLine .ItemId (Accounts Payable)     ‑‑‑>    InventTable .ItemId (Inventory and warehouse management)
457VendTmpInvoiceInfoLine .OrigPurchId (Accounts Payable)     ‑‑‑>    PurchTable .PurchId (Procurement and sourcing)
458VendTmpInvoiceInfoLine .TableRefId (Accounts Payable)     ‑‑‑>    VendTmpInvoiceInfoTable .TableRefId (Accounts Payable)
459VendTmpInvoiceInfoTable .CurrencyCode (Accounts Payable)     ‑‑‑>    Currency .CurrencyCode (General ledger)
460VendTmpInvoiceInfoTable .DefaultDimension (Accounts Payable)     ‑‑‑>    DimensionAttributeValueSet .RecId (General ledger)
461VendTmpInvoiceInfoTable .PurchId (Accounts Payable)     ‑‑‑>    PurchTable .PurchId (Procurement and sourcing)
462VendTmpInvoiceInfoTable .InvoiceAccount (Accounts Payable)     ‑‑‑>    VendTable .AccountNum (Procurement and sourcing)
463VendTmpProcurementCategory .VendorAccountNumber (Accounts Payable)     ‑‑‑>    VendTable .AccountNum (Procurement and sourcing)
464VendTmpProspectiveVendorResult .VendorRequestDataAreaId (Accounts Payable)     ‑‑‑>    DataArea .id (Unknown module)
465VendTmpProspectiveVendorResult .CountryRegionId (Accounts Payable)     ‑‑‑>    LogisticsAddressCountryRegion .CountryRegionId (Sales and marketing)
466VendTmpProspectiveVendorResult .VendRequestRecId (Accounts Payable)     ‑‑‑>    VendRequest .RecId (Procurement and sourcing)
467VendTmpProspectiveVendorResult .VendTable1, .AccountNum (Accounts Payable)     ‑‑‑>    VendTable .dataAreaId, .AccountNum (Procurement and sourcing)
468VendTmpRequest .DataArea (Accounts Payable)     ‑‑‑>    DataArea .id (Unknown module)
469VendTmpRequest .RejectionReason (Accounts Payable)     ‑‑‑>    ReasonTable .Reason (General ledger)
470VendTmpSearchCreateVendor .Currency (Accounts Payable)     ‑‑‑>    Currency .CurrencyCode (General ledger)
471VendTmpSearchCreateVendor .LegalEntity, .VendGroup (Accounts Payable)     ‑‑‑>    VendGroup .dataAreaId, .VendGroup (Procurement and sourcing)
472VendTmpSearchCreateVendor .VendAccountNum (Accounts Payable)     ‑‑‑>    VendTable .AccountNum (Procurement and sourcing)
473VendTmpSearchCreateVendorCategory .VendCategory (Accounts Payable)     ‑‑‑>    EcoResCategory .RecId (Retail)
474VendTmpSearchCreateVendorCategory .OperatingUnit (Accounts Payable)     ‑‑‑>    OMOperatingUnit .RecId (Server and Tools)
475VendTmpSearchCreateVendorCategory .VendTmpSearchCreateVendor (Accounts Payable)     ‑‑‑>    VendTmpSearchCreateVendor .RecId (Accounts Payable)
476VendTmpSearchCriteriaProcCategories .EcoResCategory (Accounts Payable)     ‑‑‑>    EcoResCategory .RecId (Retail)
477VendTmpUnsolicitedVendorResult .RequestSignUp (Accounts Payable)     ‑‑‑>    VendRequestSignup .RecId (Procurement and sourcing)
478VendTotalPriceTolerance .VendAccount (Accounts Payable)     ‑‑‑>    VendTable .AccountNum (Procurement and sourcing)
479VendTrans .AccountingEvent (Accounts Payable)     ‑‑‑>    AccountingEvent .RecId (General ledger)
480VendTrans .CompanyBankAccountId (Accounts Payable)     ‑‑‑>    BankAccountTable .AccountID (Cash and bank management)
481VendTrans .BankCentralBankPurposeCode (Accounts Payable)     ‑‑‑>    BankCentralBankPurpose .Code (Cash and bank management)
482VendTrans .TransDate, .Voucher (Accounts Payable)     ‑‑‑>    BankChequePaymTrans .InvoiceTransDate, .InvoiceVoucher (Cash and bank management)
483VendTrans .BankLCImportLine (Accounts Payable)     ‑‑‑>    BankLCImportLine .RecId (Cash and bank management)
484VendTrans .BankRemittanceFileId (Accounts Payable)     ‑‑‑>    BankRemittanceFilesVend .FileId (Cash and bank management)
485VendTrans .CashDiscCode (Accounts Payable)     ‑‑‑>    CashDisc .CashDiscCode (Financial management)
486VendTrans .CurrencyCode (Accounts Payable)     ‑‑‑>    Currency .CurrencyCode (General ledger)
487VendTrans .LastSettleCompany, .Fky? (Accounts Payable)     ‑‑‑>    DataArea .id, .Pky? (Unknown module)
488VendTrans .DefaultDimension (Accounts Payable)     ‑‑‑>    DimensionAttributeValueSet .RecId (General ledger)
489VendTrans .Fky?, .Fky?, .AccountNum, .Voucher, .TransDate, .CurrencyCode, .RecId (Accounts Payable)     ‑‑‑>    FactureJour_RU .Pky?, .Pky?, .CustVendInvoiceAccount, .Voucher, .FactureDate, .CurrencyCode, .CustVendTransRecId (Global financial management - Russia)
490VendTrans .Approver (Accounts Payable)     ‑‑‑>    HcmWorker .RecId (Human resources)
491VendTrans .JournalNum (Accounts Payable)     ‑‑‑>    LedgerJournalTable .JournalNum (General ledger)
492VendTrans .Tax1099State (Accounts Payable)     ‑‑‑>    LogisticsAddressState .StateId (Sales and marketing)
493VendTrans .RemittanceLocation (Accounts Payable)     ‑‑‑>    LogisticsLocation .RecId (Sales and marketing)
494VendTrans .RemittanceAddress (Accounts Payable)     ‑‑‑>    LogisticsPostalAddress .RecId (Sales and marketing)
495VendTrans .ReasonRefRecId (Accounts Payable)     ‑‑‑>    ReasonTableRef .RecId (General ledger)
496VendTrans .ConsessionSettlementId (Accounts Payable)     ‑‑‑>    RetailConsessionSettlementTable .SettlementId (Retail)
497VendTrans .Tax1099RecId (Accounts Payable)     ‑‑‑>    Tax1099BoxDetail .RecId (Public Sector SL1)
498VendTrans .Tax1099Fields (Accounts Payable)     ‑‑‑>    Tax1099Fields .RecId (Global financial management - North America)
499VendTrans .TransDate, .Voucher (Accounts Payable)     ‑‑‑>    TmpBankPaym2Invoice .InvoiceTransDate, .InvoiceVoucher (Cash and bank management)
500VendTrans .AccountNum, .ThirdPartyBankAccountId (Accounts Payable)     ‑‑‑>    VendBankAccount .VendAccount, .AccountID (Procurement and sourcing)
501VendTrans .createdTransactionId (Accounts Payable)     ‑‑‑>    VendExchRateAdjustment .createdTransactionId (Accounts Payable)
502VendTrans .Voucher, .AccountNum, .TransDate (Accounts Payable)     ‑‑‑>    VendInvoiceJour .LedgerVoucher, .InvoiceAccount, .InvoiceDate (Accounts Payable)
503VendTrans .PostingChangeVoucher (Accounts Payable)     ‑‑‑>    VendLedger .PostingProfile (Accounts Payable)
504VendTrans .PostingProfile (Accounts Payable)     ‑‑‑>    VendLedger .PostingProfile (Accounts Payable)
505VendTrans .PostingProfileApprove (Accounts Payable)     ‑‑‑>    VendLedger .PostingProfile (Accounts Payable)
506VendTrans .PostingProfileCancel (Accounts Payable)     ‑‑‑>    VendLedger .PostingProfile (Accounts Payable)
507VendTrans .PostingProfileClose (Accounts Payable)     ‑‑‑>    VendLedger .PostingProfile (Accounts Payable)
508VendTrans .PostingProfileReOpen (Accounts Payable)     ‑‑‑>    VendLedger .PostingProfile (Accounts Payable)
509VendTrans .PaymMode, .PaymSpec (Accounts Payable)     ‑‑‑>    VendPaymModeSpec .PaymMode, .Specification (Accounts Payable)
510VendTrans .PaymMode (Accounts Payable)     ‑‑‑>    VendPaymModeTable .PaymMode (Accounts Payable)
511VendTrans .PromissoryNoteID (Accounts Payable)     ‑‑‑>    VendPromissoryNoteJour .PromissoryNoteId (Accounts Payable)
512VendTrans .PromissoryNoteID, .AccountNum, .Voucher, .TransDate (Accounts Payable)     ‑‑‑>    VendPromissoryNoteTrans .PromissoryNoteId, .VendAccount, .Voucher, .TransDate (Accounts Payable)
513VendTrans .AccountNum, .Tax1099State (Accounts Payable)     ‑‑‑>    VendStateTaxID .VendAccount, .StateId (Global financial management - North America)
514VendTrans .AccountNum (Accounts Payable)     ‑‑‑>    VendTable .AccountNum (Procurement and sourcing)
515VendTrans .LastSettleAccountNum (Accounts Payable)     ‑‑‑>    VendTable .AccountNum (Procurement and sourcing)
516VendTrans .AccountNum, .TransDate, .Voucher (Accounts Payable)     ‑‑‑>    VendTrans .AccountNum, .TransDate, .Voucher (Accounts Payable)
517VendTrans .OffsetRecid (Accounts Payable)     ‑‑‑>    VendTrans .RecId (Accounts Payable)
518VendTrans .Voucher (Accounts Payable)     ‑‑‑>    VendTrans .Voucher (Accounts Payable)
519VendTransCashDisc .CashDiscCode (Accounts Payable)     ‑‑‑>    CashDisc .CashDiscCode (Financial management)
520VendTransCashDisc .RefTableId, .RefRecId (Accounts Payable)     ‑‑‑>    LedgerJournalTrans .TableId, .RecId (General ledger)
521VendTransCashDisc .RefTableId, .RefRecId (Accounts Payable)     ‑‑‑>    VendInvoiceJour .TableId, .RecId (Accounts Payable)
522VendTransCashDisc .RefTableId, .RefRecId (Accounts Payable)     ‑‑‑>    VendSettlement .TableId, .RecId (Accounts Payable)
523VendTransCashDisc .RefRecId, .RefTableId (Accounts Payable)     ‑‑‑>    VendTransOpen .RecId, .TableId (Accounts Payable)
524VendTransListTmp .CurrencyCode (Accounts Payable)     ‑‑‑>    Currency .CurrencyCode (General ledger)
525VendTransListTmp .AccountNum (Accounts Payable)     ‑‑‑>    VendTable .AccountNum (Procurement and sourcing)
526VendTransOpen .BankLCImportLine (Accounts Payable)     ‑‑‑>    BankLCImportLine .RecId (Cash and bank management)
527VendTransOpen .CashDiscountLedgerDimension (Accounts Payable)     ‑‑‑>    DimensionAttributeValueCombination .RecId (General ledger)
528VendTransOpen .Fky? (Accounts Payable)     ‑‑‑>    LedgerJournalTrans .Pky? (General ledger)
529VendTransOpen .AccountNum (Accounts Payable)     ‑‑‑>    PurchTable .InvoiceAccount (Procurement and sourcing)
530VendTransOpen .TaxComponentTable_IN (Accounts Payable)     ‑‑‑>    TaxComponentTable_IN .RecId (Global financial management - Asia Pacific)
531VendTransOpen .TaxWithholdRegNumber_IN (Accounts Payable)     ‑‑‑>    TaxWithholdRegNumbers_IN .RecId (Global financial management - Asia Pacific)
532VendTransOpen .ThirdPartyBankAccountId, .AccountNum (Accounts Payable)     ‑‑‑>    VendBankAccount .AccountID, .VendAccount (Procurement and sourcing)
533VendTransOpen .FineCode_BR (Accounts Payable)     ‑‑‑>    VendFineSetup_BR .FineCode (Global financial management - Latin America)
534VendTransOpen .InterestCode_BR (Accounts Payable)     ‑‑‑>    VendInterestSetup_BR .InterestCode (Global financial management - Latin America)
535VendTransOpen .AccountNum (Accounts Payable)     ‑‑‑>    VendInvoiceJour .InvoiceAccount (Accounts Payable)
536VendTransOpen .AccountNum (Accounts Payable)     ‑‑‑>    VendPromissoryNoteJour .VendAccount (Accounts Payable)
537VendTransOpen .AccountNum (Accounts Payable)     ‑‑‑>    VendTable .AccountNum (Procurement and sourcing)
538VendTransOpen .AccountNum, .RefRecId (Accounts Payable)     ‑‑‑>    VendTrans .AccountNum, .RecId (Accounts Payable)
539VendTransOpen .RecId (Accounts Payable)     ‑‑‑>    VendTransEPRemit_BR .VendTransOpenRefRecId (Global financial management - Latin America)
540VendTransOpen .RecId (Accounts Payable)     ‑‑‑>    VendTransOpen .RecId (Accounts Payable)
541VendTransOpen_PaymMode_TmpES .CompanyBankAccountId (Accounts Payable)     ‑‑‑>    BankAccountTable .AccountID (Cash and bank management)
542VendTransOpen_PaymMode_TmpES .PostingProfile (Accounts Payable)     ‑‑‑>    VendLedger .PostingProfile (Accounts Payable)
543VendTransOpen_PaymMode_TmpES .PaymMode (Accounts Payable)     ‑‑‑>    VendPaymModeTable .PaymMode (Accounts Payable)
544VendTransOpen_PaymMode_TmpES .PromissoryNoteID (Accounts Payable)     ‑‑‑>    VendPromissoryNoteJour .PromissoryNoteId (Accounts Payable)
545VendTransOpen_PaymMode_TmpES .AccountNum (Accounts Payable)     ‑‑‑>    VendTable .AccountNum (Procurement and sourcing)
546VendUnrealizedRev .CurrencyCode (Accounts Payable)     ‑‑‑>    Currency .CurrencyCode (General ledger)
547VendUnrealizedRev .VendTable (Accounts Payable)     ‑‑‑>    VendTable .AccountNum (Procurement and sourcing)



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