Microsoft Dynamics AX 2012 R2

AxErd: Parent-Children: Retail

Module: Retail

Navigation:     AxErd_Home     Previous_File    


Row-numParent-table-nameForeign-key-columnsModule-of-parent-tableArrow-to-parentChild-table-namePrimary-key-columnsModule-of-child-table
1008RetailTillLayout .layoutId (Retail)     <‑‑‑    RetailStaffTable .layoutId (Retail)
1009RetailTillLayout .layoutId (Retail)     <‑‑‑    RetailStoreTable .layoutId (Retail)
1010RetailTillLayout .layoutId (Retail)     <‑‑‑    RetailTerminalTable .layoutId (Retail)
1011RetailTransactionBankedTenderTrans .TransactionId, .Store, .Terminal (Retail)     <‑‑‑    RetailTransactionTenderDeclarationTrans .transactionId, .store, .terminal (Retail)
1012RetailTransactionIncomeExpenseTrans .transactionId, .store, .terminal (Retail)     <‑‑‑    RetailTransactionInfocodeTrans .transactionId, .store, .terminal (Retail)
1013RetailTransactionPaymentTrans .transactionId, .store, .terminal (Retail)     <‑‑‑    RetailTransactionInfocodeTrans .transactionId, .store, .terminal (Retail)
1014RetailTransactionSalesTrans .dataAreaId, .inventTransId (Retail)     <‑‑‑    InventTransOriginRetailSalesTransTable .SalesTransTableDataAreaId, .SalesTransInventTransId (Inventory and warehouse management)
1015RetailTransactionSalesTrans .lineNum, .transactionId, .terminalId, .store (Retail)     <‑‑‑    RetailTransactionAddressTrans .SaleLineNum, .transactionId, .terminal, .store (Retail)
1016RetailTransactionSalesTrans .lineNum, .transactionId, .terminalId, .store (Retail)     <‑‑‑    RetailTransactionDiscountTrans .SaleLineNum, .TransactionId, .TerminalId, .StoreId (Retail)
1017RetailTransactionSalesTrans .transactionId, .store, .terminalId (Retail)     <‑‑‑    RetailTransactionInfocodeTrans .transactionId, .store, .terminal (Retail)
1018RetailTransactionSalesTrans .lineNum, .transactionId, .terminalId, .store (Retail)     <‑‑‑    RetailTransactionMarkupTrans .saleLineNum, .transactionId, .terminalId, .store (Retail)
1019RetailTransactionServiceProfile .profileId (Retail)     <‑‑‑    RetailChannelTable .TransactionServiceProfile (Retail)
1020RetailTransactionServiceProfile .RecId (Retail)     <‑‑‑    RetailConnStoreConnectProfile .TransactionServiceProfileRecId (Retail)
1021RetailTransactionServiceProfile .profileId (Retail)     <‑‑‑    RetailPubRetailChannelTable .TransactionServiceProfile (Retail)
1022RetailTransactionServiceProfile .profileId (Retail)     <‑‑‑    RetailTerminalTable .transactionServiceProfile (Retail)
1023RetailTransactionTable .transactionId (Retail)     <‑‑‑    CustTrans .RetailTransactionId (Accounts Receivable)
1024RetailTransactionTable .transactionId, .terminal, .store (Retail)     <‑‑‑    RetailCreditVoucherTable .appliedByTransactionId, .appliedByTerminalId, .appliedInStoreId (Retail)
1025RetailTransactionTable .transactionId, .terminal, .store (Retail)     <‑‑‑    RetailCreditVoucherTable .createdByTransactionId, .createdByTerminalId, .createdInStoreId (Retail)
1026RetailTransactionTable .transactionId (Retail)     <‑‑‑    RetailFiscalDocumentModel2_BR .TransactionId (Global financial management - Latin America)
1027RetailTransactionTable .transactionId (Retail)     <‑‑‑    RetailFiscalDocumentModel2Line_BR .TransactionId (Global financial management - Latin America)
1028RetailTransactionTable .transactionId (Retail)     <‑‑‑    RetailFiscalDocumentModel2TaxTrans_BR .TransactionId (Global financial management - Latin America)
1029RetailTransactionTable .transactionId (Retail)     <‑‑‑    RetailFiscalPrinterReport_BR .TransactionId (Global financial management - Latin America)
1030RetailTransactionTable .transactionId (Retail)     <‑‑‑    RetailFiscalReceipt_BR .TransactionId (Global financial management - Latin America)
1031RetailTransactionTable .transactionId (Retail)     <‑‑‑    RetailFiscalReceiptLine_BR .TransactionId (Global financial management - Latin America)
1032RetailTransactionTable .transactionId (Retail)     <‑‑‑    RetailFiscalReceiptTaxTrans_BR .TransactionId (Global financial management - Latin America)
1033RetailTransactionTable .transactionId (Retail)     <‑‑‑    RetailGiftCardTransactions .transactionId (Retail)
1034RetailTransactionTable .transactionId, .store, .terminal (Retail)     <‑‑‑    RetailLoyaltyMSRCardTrans .transactionId, .storeId, .terminalId (Retail)
1035RetailTransactionTable .statementId (Retail)     <‑‑‑    RetailStatementJour .statementId (Retail)
1036RetailTransactionTable .statementId (Retail)     <‑‑‑    RetailStatementTable .statementId (Retail)
1037RetailTransactionTable .RecId (Retail)     <‑‑‑    RetailSyncOrdersWorkTable .TransactionRefRecId (Retail)
1038RetailTransactionTable .transactionId (Retail)     <‑‑‑    RetailTMPTransactionSalesTrans .transactionId (Retail)
1039RetailTransactionTable .transactionId, .terminal, .store (Retail)     <‑‑‑    RetailTransactionAddressTrans .transactionId, .terminal, .store (Retail)
1040RetailTransactionTable .transactionId, .terminal, .store (Retail)     <‑‑‑    RetailTransactionAttributeTrans .transactionId, .terminal, .store (Retail)
1041RetailTransactionTable .transactionId, .store, .terminal (Retail)     <‑‑‑    RetailTransactionBankedTenderTrans .TransactionId, .Store, .Terminal (Retail)
1042RetailTransactionTable .transactionId, .terminal, .store (Retail)     <‑‑‑    RetailTransactionDiscountTrans .TransactionId, .TerminalId, .StoreId (Retail)
1043RetailTransactionTable .transactionId, .store, .terminal (Retail)     <‑‑‑    RetailTransactionIncomeExpenseTrans .transactionId, .store, .terminal (Retail)
1044RetailTransactionTable .transactionId, .store, .terminal (Retail)     <‑‑‑    RetailTransactionInfocodeTrans .transactionId, .store, .terminal (Retail)
1045RetailTransactionTable .transactionId, .store, .terminal (Retail)     <‑‑‑    RetailTransactionLoyaltyPointsTrans .transactionId, .storeId, .terminalId (Retail)
1046RetailTransactionTable .transactionId, .terminal, .store (Retail)     <‑‑‑    RetailTransactionMarkupTrans .transactionId, .terminalId, .store (Retail)
1047RetailTransactionTable .terminal, .store, .transactionId (Retail)     <‑‑‑    RetailTransactionOrderInvoiceTrans .terminalId, .storeId, .transactionId (Retail)
1048RetailTransactionTable .transactionId, .terminal, .store (Retail)     <‑‑‑    RetailTransactionOrderStatus .transactionId, .terminal, .store (Retail)
1049RetailTransactionTable .transactionId, .store, .terminal (Retail)     <‑‑‑    RetailTransactionPaymentTrans .transactionId, .store, .terminal (Retail)
1050RetailTransactionTable .transactionId (Retail)     <‑‑‑    RetailTransactionPaymentTrans_BR .TransactionId (Global financial management - Latin America)
1051RetailTransactionTable .transactionId, .store, .terminal (Retail)     <‑‑‑    RetailTransactionSafeTenderTrans .TransactionId, .Store, .Terminal (Retail)
1052RetailTransactionTable .transactionId, .store, .terminal (Retail)     <‑‑‑    RetailTransactionSalesTrans .transactionId, .store, .terminalId (Retail)
1053RetailTransactionTable .transactionId (Retail)     <‑‑‑    RetailTransactionSalesTrans .returnTransactionId (Retail)
1054RetailTransactionTable .transactionId, .store, .terminal (Retail)     <‑‑‑    RetailTransactionTableEx5 .transactionId, .storeId, .terminalId (Retail)
1055RetailTransactionTable .terminal, .store, .transactionId (Retail)     <‑‑‑    RetailTransactionTaxTrans .TerminalId, .StoreId, .TransactionId (Retail)
1056RetailTransactionTable .transactionId, .store, .terminal (Retail)     <‑‑‑    RetailTransactionTenderDeclarationTrans .transactionId, .store, .terminal (Retail)
1057RetailVendTable .AccountNum, .Pky? (Retail)     <‑‑‑    RetailInventTable .concessionVendAccount, .Fky? (Retail)
1058RetailVendTable .Pky?, .AccountNum (Retail)     <‑‑‑    RetailMassUpdateWorksheetLine .Fky?, .RetailInvent_concessionVendAccount (Retail)
1059RetailVisualProfile .TableId, .RecId (Retail)     <‑‑‑    RetailConnDistributionList .refTableId, .refRecId (Retail)
1060RetailVisualProfile .profileId (Retail)     <‑‑‑    RetailTerminalTable .visualProfile (Retail)
1061RetailWorkShiftSetup .TableId, .RecId (Retail)     <‑‑‑    RetailConnDistributionList .refTableId, .refRecId (Retail)
1062RetailWorkShiftSetup .workShiftId, .StoreRecId (Retail)     <‑‑‑    RetailStoreWorkShiftTable .shiftId, .StoreRecId (Retail)
1063RetailWorkShiftSetup .workShiftId, .StoreRecId (Retail)     <‑‑‑    RetailStoreWorkShiftTrans .shiftId, .StoreRecId (Retail)



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