Dynamics NAV Table Relationship Diagrams
nav 2016 w1
Entity Relationship (E/R) diagrams for every granule in Microsoft Dynamics NAV.
Contacts
Fixed Assets
Financial Management
General Application
Human Resources
Inventory
IT Administration
Jobs
Manufacturing
Purchasing
Resource Planning
Sales
Service
Warehouse
-
Contacts
Activity Step Activity Attachment Attendee Business Relation Campaign Entry Campaign Status Campaign Target Group Campaign Close Opportunity Code Communication Method Cont. Duplicate Search String Contact Alt. Addr. Date Range Contact Alt. Address Contact Business Relation Contact Duplicate Contact Industry Group Contact Job Responsibility Contact Mailing Group Contact Profile Answer Contact Value Contact Web Source Contact Current Salesperson Customer Template Delivery Sorter Duplicate Search String Setup Exchange Folder Industry Group Inter. Log Entry Comment Line Interaction Group Interaction Log Entry Interaction Template Setup Interaction Template Interaction Tmpl. Language Job Responsibility Logged Segment Mailing Group Marketing Setup Opportunity Entry Opportunity Organizational Level Profile Questionnaire Header Profile Questionnaire Line Rating Rlshp. Mgt. Comment Line RM Matrix Management Sales Cycle Stage Sales Cycle Salutation Formula Salutation Saved Segment Criteria Line Saved Segment Criteria Segment Criteria Line Segment Header Segment History Segment Interaction Language Segment Line Segment Wizard Filter Team Salesperson Team To-do Interaction Language To-do Web Source
-
Fixed Assets
Depreciation Book Depreciation Table Buffer Depreciation Table Header Depreciation Table Line FA Allocation FA Buffer Projection FA Class FA Date Type FA Depreciation Book FA G/L Posting Buffer FA Journal Batch FA Journal Line FA Journal Setup FA Journal Template FA Ledger Entry FA Location FA Matrix Posting Type FA Posting Group Buffer FA Posting Group FA Posting Type Setup FA Posting Type FA Reclass. Journal Batch FA Reclass. Journal Line FA Reclass. Journal Template FA Register FA Setup FA Subclass Fixed Asset Ins. Coverage Ledger Entry Insurance Journal Batch Insurance Journal Line Insurance Journal Template Insurance Register Insurance Type Insurance Main Asset Component Maintenance Ledger Entry Maintenance Registration Maintenance Total Value Insured
-
Financial Management
Acc. Sched. Cell Value Acc. Sched. Chart Setup Line Acc. Sched. KPI Web Srv. Line Acc. Sched. KPI Web Srv. Setup Acc. Schedule Line Acc. Schedule Name Account Schedules Chart Setup Accounting Period Adjust Exchange Rate Buffer Analysis Report Chart Line Analysis Report Chart Setup Analysis View Budget Entry Analysis View Entry Analysis View Filter Analysis View Applied Payment Entry Area Bank Acc. Reconciliation Line Bank Acc. Reconciliation Bank Account Ledger Entry Bank Account Posting Group Bank Account Statement Line Bank Account Statement Bank Account Bank Pmt. Appl. Rule Cash Flow Account Comment Cash Flow Account Cash Flow Chart Setup Cash Flow Forecast Entry Cash Flow Forecast Cash Flow Manual Expense Cash Flow Manual Revenue Cash Flow Report Selection Cash Flow Setup Cash Flow Worksheet Line Check Ledger Entry Close Income Statement Buffer Column Layout Name Column Layout Cost Accounting Setup Cost Allocation Source Cost Allocation Target Cost Budget Buffer Cost Budget Entry Cost Budget Name Cost Budget Register Cost Center Cost Entry Cost Journal Batch Cost Journal Line Cost Journal Template Cost Object Cost Register Cost Type Curr. Exch. Rate Update Setup Currency Amount Currency Exchange Rate Currency Total Buffer Currency CV Ledger Entry Buffer Date Compr. Register Default Dimension Priority Default Dimension Deferral Header Archive Deferral Header Deferral Line Archive Deferral Line Deferral Post. Buffer Deferral Template Detailed CV Ledg. Entry Buffer Dimension Buffer Dimension Code Amount Buffer Dimension Code Buffer Dimension Combination Dimension Entry Buffer Dimension ID Buffer Dimension Selection Buffer Dimension Set Entry Dimension Set Tree Node Dimension Translation Dimension Value Combination Dimension Value Dimension Dimensions Field Map Entry No. Amount Buffer Entry/Exit Point Exch. Rate Adjmt. Reg. Gen. Business Posting Group Gen. Jnl. Allocation Gen. Journal Batch Gen. Journal Line Gen. Journal Template Gen. Product Posting Group General Ledger Setup General Posting Setup G/L Acc. Budget Buffer G/L Account (Analysis View) G/L Account Net Change G/L Account Where-Used G/L Account G/L Budget Entry G/L Budget Name G/L Entry - VAT Entry Link G/L Entry G/L Register Handled IC Inbox Jnl. Line Handled IC Inbox Purch. Header Handled IC Inbox Purch. Line Handled IC Inbox Sales Header Handled IC Inbox Sales Line Handled IC Inbox Trans. Handled IC Outbox Jnl. Line Handled IC Outbox Purch. Hdr Handled IC Outbox Purch. Line Handled IC Outbox Sales Header Handled IC Outbox Sales Line Handled IC Outbox Trans. IC Comment Line IC Dimension Value IC Dimension IC Document Dimension IC G/L Account IC Inbox Jnl. Line IC Inbox Purchase Header IC Inbox Purchase Line IC Inbox Sales Header IC Inbox Sales Line IC Inbox Transaction IC Inbox/Outbox Jnl. Line Dim. IC Outbox Jnl. Line IC Outbox Purchase Header IC Outbox Purchase Line IC Outbox Sales Header IC Outbox Sales Line IC Outbox Transaction IC Partner Intrastat Jnl. Batch Intrastat Jnl. Line Intrastat Jnl. Template Job Posting Buffer Payment Application Proposal Payment Buffer Payment Export Data Payment Export Remittance Text Payment Jnl. Export Error Text Payment Matching Details Payment Registration Buffer Payment Registration Setup Posted Deferral Header Posted Deferral Line Posted Payment Recon. Hdr Posted Payment Recon. Line Reclas. Dimension Set Buffer Reconcile CV Acc Buffer Reversal Entry Selected Dimension Standard General Journal Line Standard General Journal Tariff Number Tax Area Line Tax Area Tax Detail Tax Group Tax Jurisdiction Text-to-Account Mapping Transaction Specification Transaction Type Transport Method VAT Amount Line VAT Business Posting Group VAT Clause Translation VAT Clause VAT Entry VAT Posting Setup VAT Product Posting Group VAT Rate Change Conversion VAT Rate Change Log Entry VAT Rate Change Setup VAT Registration Log VAT Registration No. Format VAT Report Error Log VAT Report Header VAT Report Line Relation VAT Report Line VAT Report Setup VAT Statement Line VAT Statement Name VAT Statement Template XBRL Comment Line XBRL G/L Map Line XBRL Line Constant XBRL Linkbase XBRL Rollup Line XBRL Schema XBRL Taxonomy Label XBRL Taxonomy Line XBRL Taxonomy
-
General Application
Access Control Active Session Activity Log Add-in Approval Comment Line Approval Entry Bank Clearing Standard Bank Data Conv. Bank Bank Data Conv. Service Setup Bank Data Conversion Pmt. Type Bank Export/Import Setup Bank Statement Matching Buffer Bank Stmt Multiple Match Line Bar Chart Buffer Budget Buffer Business Chart Buffer Business Chart Map Business Chart User Setup Business Unit Certificate of Supply Change Log Entry Change Log Setup (Field) Change Log Setup (Table) Change Log Setup Chart Comment Line Company Information Company Config. Field Mapping Config. Line Config. Package Data Config. Package Error Config. Package Field Config. Package Filter Config. Package Record Config. Package Table Config. Package Config. Question Area Config. Question Config. Questionnaire Config. Related Field Config. Related Table Config. Selection Config. Setup Config. Template Header Config. Template Line Config. Text Transformation Country/Region Credit Trans Re-export History Credit Transfer Entry Credit Transfer Register Custom Report Layout Data Exch. Column Def Data Exch. Def Data Exch. Field Mapping Buf. Data Exch. Field Mapping Data Exch. Field Data Exch. Line Def Data Exch. Mapping Data Exch. Data Exchange Type DataExch-RapidStart Buffer Debugger Breakpoint Debugger Watch Device Direct Debit Collection Entry Direct Debit Collection DO Payment Card Type DO Payment Connection Details DO Payment Connection Setup DO Payment Credit Card Number DO Payment Credit Card DO Payment Setup DO Payment Trans. Log Entry Doc. Exch. Service Setup Document Entry Document Search Result Document Sending Profile Document Service Dynamic Request Page Entity Dynamic Request Page Field Electronic Document Format Error Message Excel Buffer Extended Text Header Extended Text Line Generic Chart Captions Buffer Generic Chart Filter Generic Chart Memo Buffer Generic Chart Query Column Generic Chart Setup Generic Chart Y-Axis Incoming Document Approver Incoming Document Attachment Incoming Document Incoming Documents Setup Integration Field Mapping Integration Page Integration Record Integration Synch. Job Errors Integration Synch. Job Integration Table Mapping Intermediate Data Import Job Queue Category Job Queue Entry Job Queue Log Entry Job Queue Language License Agreement Mini Chart Definition Mini Dimensions Template Mini Last Used Chart Mini Pages Mapping Mini Trial Balance Setup Mini User Removed Instructions Name/Value Buffer No. Series Line No. Series Relationship No. Series Notification Entry Notification Schedule Notification Setup Notification Template Object Metadata Object Tracking Object Translation OCR Service Document Template OCR Service Setup Online Map Parameter Setup Online Map Setup Outlook Synch. Dependency Outlook Synch. Entity Element Outlook Synch. Entity Outlook Synch. Field Outlook Synch. Filter Outlook Synch. Link Outlook Synch. Lookup Name Outlook Synch. Option Correl. Outlook Synch. Setup Detail Outlook Synch. User Setup Overdue Approval Entry Page Data Personalization Permission Set Permission Post Code Posted Approval Comment Line Posted Approval Entry Posted Docs. With No Inc. Buf. Printer Selection Reason Code Record Link Report Inbox Report Layout Update Log Report List Translation Report Selections Responsibility Center Restricted Record Send-To Program Sent Notification Entry SEPA Direct Debit Mandate Server Instance Service Connection Error Service Connection Status Service Connection Service Password Session Event SMTP Mail Setup Source Code Setup Source Code Standard Text Style Sheet Table Filter Temp Integration Field Mapping TempBlob Territory Trailing Sales Orders Setup Transformation Rule User Default Style Sheet User Metadata User Personalization User Property User Setup User Time Register User Web Service WF Event/Response Combination Workflow Buffer Workflow Category Workflow Event Queue Workflow Event Workflow Record Change Archive Workflow - Record Change Workflow Response Workflow Rule Workflow Step Argument Archive Workflow Step Argument Workflow Step Buffer Workflow Step Instance Archive Workflow Step Instance Workflow Step Workflow Table Relation Value Workflow - Table Relation Workflow User Group Member Workflow User Group Workflow XML Buffer XML Schema Element XML Schema Restriction XML Schema
-
Human Resources
Alternative Address Cause of Absence Cause of Inactivity Confidential Information Confidential Employee Absence Employee Qualification Employee Relative Employee Statistics Group Employee Employment Contract Grounds for Termination HR Confidential Comment Line Human Resource Comment Line Human Resource Unit of Measure Human Resources Setup Misc. Article Information Misc. Article Qualification Relative Union
-
Inventory
Analysis Column Template Analysis Column Analysis Dim. Selection Buffer Analysis Field Value Analysis Line Template Analysis Line Analysis Report Name Analysis Selected Dimension Analysis Type Availability at Date Average Cost Calc. Overview Avg. Cost Adjmt. Entry Point BOM Buffer BOM Component BOM Warning Log Cost Element Buffer Cost Share Buffer Customer Price Group Entry Summary Error Buffer G/L - Item Ledger Relation Inventory Adjmt. Entry (Order) Inventory Adjustment Buffer Inventory Buffer Inventory Comment Line Inventory Event Buffer Inventory Page Data Inventory Period Entry Inventory Period Inventory Posting Group Inventory Posting Setup Inventory Report Entry Inventory Report Header Inventory Setup Invt. Post to G/L Test Buffer Invt. Posting Buffer Item Amount Item Analysis View Budg. Entry Item Analysis View Entry Item Analysis View Filter Item Analysis View Item Application Entry History Item Application Entry Item Availability by Date Item Budget Buffer Item Budget Entry Item Budget Name Item Category Item Cross Reference Item Discount Group Item Entry Relation Item Journal Batch Item Journal Buffer Item Journal Line Item Journal Template Item Ledger Entry Item Register Item Statistics Buffer Item Substitution Item Tracing Buffer Item Tracing History Buffer Item Tracking Code Item Tracking Comment Item Translation Item Unit of Measure Item Variant Item Vendor Item Line Number Buffer Location Lot No. Information Manufacturer Memoized Result Mini Item Template Nonstock Item Setup Nonstock Item Phys. Inventory Ledger Entry Post Value Entry to G/L Prepayment Inv. Line Buffer Product Group Purchasing Record Buffer Reservation Entry Buffer Reservation Entry Return Reason Rounding Method Rounding Residual Buffer Sales Price Worksheet Sales Price Serial No. Information Standard Cost Worksheet Name Standard Cost Worksheet Standard Item Journal Line Standard Item Journal Stockkeeping Unit Comment Line Stockkeeping Unit Substitution Condition Timeline Event Change Timeline Event Tracking Specification Transfer Header Transfer Line Transfer Receipt Header Transfer Receipt Line Transfer Route Transfer Shipment Header Transfer Shipment Line Unit of Measure Translation Unit of Measure Value Entry Relation Value Entry Whse. Item Entry Relation Whse. Item Tracking Line
-
IT Administration
Accounting Services Cue Additional Fee Setup Administration Cue CAL Test Codeunit CAL Test Coverage Map CAL Test Enabled Codeunit CAL Test Line CAL Test Method CAL Test Result CAL Test Suite CRM Account Statistics CRM Account CRM Businessunit CRM Connection Setup CRM Contact CRM Contract CRM Customeraddress CRM Discount CRM Discounttype CRM Incident CRM Incidentresolution CRM Integration Record CRM Invoice CRM Invoicedetail CRM NAV Connection CRM Opportunity CRM Organization CRM Post CRM Pricelevel CRM Product CRM Productpricelevel CRM Quote CRM Quotedetail CRM Redirect CRM Salesorder CRM Salesorderdetail CRM Synch. Job Status Cue CRM Systemuser CRM Team CRM Transactioncurrency CRM Uom CRM Uomschedule CSV Buffer Cue Setup Custom Report Selection Email Item Finance Cue Geolocation Inc. Doc. Attachment Overview Job Cue Ledger Entry Matching Buffer Line Fee Note on Report Hist. Manufacturing Cue Mini Activities Cue My Customer My Item My Vendor NAV App Capabilities NAV App Data Archive NAV App Dependencies NAV App Installed App NAV App Object Metadata NAV App Object Prerequisites NAV App Tenant App NAV App Positive Pay Detail Positive Pay Entry Detail Positive Pay Entry Positive Pay Footer Positive Pay Header Profile Metadata Profile Resource Import/Export Profile Purchase Cue RapidStart Services Cue Record Export Buffer Referenced XML Schema Report Layout Selection Report Totals Buffer Sales Cue SB Owner Cue Service Cue Social Listening Search Topic Social Listening Setup Sorting Table Table Permission Buffer Tenant Permission Set Tenant Permission User Group Access Control User Group Member User Group Permission Set User Group Warehouse Basic Cue Warehouse WMS Cue Warehouse Worker WMS Cue
-
Jobs
Job Buffer Job Difference Buffer Job Entry No. Job G/L Account Price Job Item Price Job Journal Batch Job Journal Line Job Journal Quantity Job Journal Template Job Ledger Entry Job Planning Line Invoice Job Planning Line Job Posting Group Job Register Job Resource Price Job Task Dimension Job Task Job Usage Link Job WIP Buffer Job WIP Entry Job WIP G/L Entry Job WIP Method Job WIP Total Job WIP Warning Job Jobs Setup
-
Manufacturing
Action Message Entry Base Calendar Change Base Calendar Calendar Absence Entry Calendar Entry Capacity Constrained Resource Capacity Ledger Entry Capacity Unit of Measure Customized Calendar Change Customized Calendar Entry Family Line Family Inventory Profile Track Buffer Inventory Profile Item Availability Line Machine Center Manufacturing Comment Line Manufacturing Setup Manufacturing User Template Order Promising Line Order Promising Setup Order Tracking Entry Planning Assignment Planning Buffer Planning Component Planning Error Log Planning Routing Line Prod. Order Capacity Need Prod. Order Comment Line Prod. Order Comp. Cmt Line Prod. Order Component Prod. Order Line Prod. Order Routing Line Prod. Order Routing Personnel Prod. Order Routing Tool Prod. Order Rtng Comment Line Prod. Order Rtng Qlty Meas. Production BOM Comment Line Production BOM Header Production BOM Line Production BOM Version Production Forecast Entry Production Forecast Name Production Matrix BOM Entry Production Matrix BOM Line Production Order Quality Measure Registered Absence Req. Wksh. Template Requisition Line Requisition Wksh. Name Routing Comment Line Routing Header Routing Line Routing Link Routing Personnel Routing Quality Measure Routing Tool Routing Version Sales Planning Line Scrap Shop Calendar Holiday Shop Calendar Working Days Shop Calendar Standard Task Description Standard Task Personnel Standard Task Quality Measure Standard Task Tool Standard Task Stop Unplanned Demand Untracked Planning Element Where Used Base Calendar Where-Used Line Work Center Group Work Center Work Shift
-
Purchasing
Detailed Vendor Ledg. Entry Item Charge Assignment (Purch) Mini Vendor Template Order Address Payable Vendor Ledger Entry Payment Method Payment Term Translation Payment Terms Purch. Comment Line Archive Purch. Comment Line Purch. Cr. Memo Hdr. Purch. Cr. Memo Line Purch. Inv. Header Purch. Inv. Line Purch. Rcpt. Header Purch. Rcpt. Line Purchase Header Archive Purchase Header Purchase Line Archive Purchase Line Discount Purchase Line Purchase Prepayment % Purchase Price Purchases & Payables Setup Return Shipment Header Return Shipment Line Standard Purchase Code Standard Purchase Line Standard Vendor Purchase Code Vendor Amount Vendor Bank Account Vendor Invoice Disc. Vendor Ledger Entry Vendor Posting Group Vendor
-
Resource Planning
Res. Capacity Entry Res. Journal Batch Res. Journal Line Res. Journal Template Res. Ledger Entry Resource Cost Resource Group Resource Price Change Resource Price Resource Register Resource Unit of Measure Resource Resources Setup Time Sheet Chart Setup Time Sheet Cmt. Line Archive Time Sheet Comment Line Time Sheet Detail Archive Time Sheet Detail Time Sheet Header Archive Time Sheet Header Time Sheet Line Archive Time Sheet Line Time Sheet Posting Entry Work Type
-
Sales
Aging Band Buffer Currency for Fin. Charge Terms Currency for Reminder Level Cust. Invoice Disc. Cust. Ledger Entry Customer Amount Customer Bank Account Customer Discount Group Customer Posting Group Customer Detailed Cust. Ledg. Entry Drop Shpt. Post. Buffer Fin. Charge Comment Line Finance Charge Memo Header Finance Charge Memo Line Finance Charge Terms Finance Charge Text Invoice Post. Buffer Issued Fin. Charge Memo Header Issued Fin. Charge Memo Line Issued Reminder Header Issued Reminder Line Item Charge Assignment (Sales) Item Charge Mini Customer Template Reminder Comment Line Reminder Header Reminder Level Reminder Line Reminder Terms Translation Reminder Terms Reminder Text Reminder/Fin. Charge Entry Return Receipt Header Return Receipt Line Returns-Related Document Sales by Cust. Grp.Chart Setup Sales Comment Line Archive Sales Comment Line Sales Cr.Memo Header Sales Cr.Memo Line Sales Header Archive Sales Header Sales Invoice Header Sales Invoice Line Sales Line Archive Sales Line Discount Sales Line Sales Prepayment % Sales Price and Line Disc Buff Sales & Receivables Setup Sales Shipment Buffer Sales Shipment Header Sales Shipment Line Salesperson/Purchaser Ship-to Address Shipment Method Translation Shipment Method Shipping Agent Services Shipping Agent Standard Customer Sales Code Standard Sales Code Standard Sales Line
-
Service
Availability Calc. Overview Contract Change Log Contract Gain/Loss Entry Contract Group Contract/Service Discount Fault Area Fault Area/Symptom Code Fault Code Fault Reason Code Fault/Resol. Cod. Relationship Filed Contract Line Filed Service Contract Header Loaner Entry Loaner Repair Status Resolution Code Resource Location Resource Service Zone Resource Skill Serv. Price Adjustment Detail Serv. Price Group Setup Service Comment Line Service Contract Account Group Service Contract Header Service Contract Line Service Contract Template Service Cost Service Cr.Memo Header Service Cr.Memo Line Service Document Log Service Document Register Service E-Mail Queue Service Header Service Hour Service Invoice Header Service Invoice Line Service Item Component Service Item Group Service Item Line Service Item Log Service Item Service Ledger Entry Service Line Price Adjmt. Service Line Service Mgt. Setup Service Order Allocation Service Order Posting Buffer Service Order Type Service Price Adjustment Group Service Price Group Service Register Service Shelf Service Shipment Buffer Service Shipment Header Service Shipment Item Line Service Shipment Line Service Status Priority Setup Service Zone Skill Code Standard Service Code Standard Service Item Gr. Code Standard Service Line Symptom Code Troubleshooting Header Troubleshooting Line Troubleshooting Setup Warranty Ledger Entry Work-Hour Template
-
Warehouse
ADCS User Assemble-to-Order Link Assembly Comment Line Assembly Header Assembly Line Assembly Setup ATO Sales Buffer Bin Content Buffer Bin Content Bin Creation Wksh. Name Bin Creation Wksh. Template Bin Creation Worksheet Line Bin Template Bin Type Bin Internal Movement Header Internal Movement Line Item Identifier Lot Numbers by Bin Buffer Miniform Function Group Miniform Function Miniform Header Miniform Line Phys. Invt. Counting Period Phys. Invt. Item Selection Posted Assemble-to-Order Link Posted Assembly Header Posted Assembly Line Posted Invt. Pick Header Posted Invt. Pick Line Posted Invt. Put-away Header Posted Invt. Put-away Line Posted Whse. Receipt Header Posted Whse. Receipt Line Posted Whse. Shipment Header Posted Whse. Shipment Line Put-away Template Header Put-away Template Line Registered Invt. Movement Hdr. Registered Invt. Movement Line Registered Whse. Activity Hdr. Registered Whse. Activity Line Special Equipment Warehouse Activity Header Warehouse Activity Line Warehouse Class Warehouse Comment Line Warehouse Employee Warehouse Entry Warehouse Journal Batch Warehouse Journal Line Warehouse Journal Template Warehouse Receipt Header Warehouse Receipt Line Warehouse Register Warehouse Request Warehouse Setup Warehouse Shipment Header Warehouse Shipment Line Warehouse Source Filter Whse. Cross-Dock Opportunity Whse. Internal Pick Header Whse. Internal Pick Line Whse. Internal Put-away Header Whse. Internal Put-away Line Whse. Pick Request Whse. Put-away Request Whse. Worksheet Line Whse. Worksheet Name Whse. Worksheet Template Zone