1 / 16

AX 2012 Development Training: Data Dictionary and Tables

Understand Data Dictionary elements, tables, EDTs, and common shortcuts in AX 2012 development. Learn to create and manage data efficiently. Includes demos and practical assignments.

kelda
Télécharger la présentation

AX 2012 Development Training: Data Dictionary and Tables

An Image/Link below is provided (as is) to download presentation Download Policy: Content on the Website is provided to you AS IS for your information and personal use and may not be sold / licensed / shared on other websites without getting consent from its author. Content is provided to you AS IS for your information and personal use only. Download presentation by click this link. While downloading, if for some reason you are not able to download a presentation, the publisher may have deleted the file from their server. During download, if you can't get a presentation, the file might be deleted by the publisher.

E N D

Presentation Transcript

  1. AX 2012 Development Training Presented by VishyGrandhi

  2. Training Outline • Lesson 1: Data dictionary elements • Lesson 2: Tables • Lesson 3: Demo • Create a new table with all the elements • Manage the data in the form

  3. Data Dictionary: Objectives • At the end of this lesson you will have an understanding about • What is Data dictionary • Elements/Objects • Common shortcuts • EDTs in detail

  4. Data Dictionary: What is it? • Data Dictionary • The root node where all the core database objects are stored

  5. Data Dictionary: Elements/Objects • Elements/Objects • Tables • Maps • Views • EDTs, Base Enums • Configuration Keys • License keys • Security Keys • Table Collections

  6. Data Dictionary: Common Shortcuts • Ctrl + 0 – Opens a form, table etc. • Ctrl + D – New AOT window • Alt + Enter – Properties • Ctrl + Shift + S – Save all modified objects • Ctrl + Shift + I – Launch the import project window • F7 – Compile

  7. Data Dictionary: EDTs • Extended data types are basically new fields created based on existing primitive types • Following is a list of primitive types • String, Integer, Real, Int64, Boolean • Date, Time, UTCDateTime • Enum • Container • GUID

  8. Data Dictionary: Wrap-up • We have understood what is Data dictionary • We discussed the elements under this node • We also looked at some of the commonly used short cuts

  9. Tables: Objectives • At the end of this lesson you will have an understanding about • What are tables • What are the different elements of tables • Some core tables

  10. Tables: Overview • Similar in nature to SQL tables with some differences • Tables can have methods • We can define relations, indexes

  11. Tables: Elements • Following are the important elements of tables • Fields • Field Groups • Indexes • Full-text indexes • Relations • Methods • Delete Actions

  12. Tables: Some important tables • CustTable • VendTable • HcmWorker • LedgerTable • InventTable • PurchTable • SalesTable

  13. Tables: Wrap-up • We looked at the different elements of tables and what are some of their nuances • What are some of the important properties of a table • Also we looked at some of the core tables

  14. Demo • Create 2 new tables and link them up • Create a form to edit the data in these tables

  15. Assignment • Create any one of the following tables • Create a form to edit the data in the table that you created.

  16. Summary of Training • We have looked at the Data dictionary • We explored the elements of a table • Finally a demo on creating tables and managing the data

More Related