Download
1 / 19
190 likes | 261 Views
AX 2012 Development Training. Presented by Vishy Grandhi. 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. Data Dictionary : Objectives.
E N D
AX 2012 Development Training Presented by Vishy Grandhi
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
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
Data Dictionary: What is it? • Data Dictionary • The root node where all the core database objects are stored
Data Dictionary: Elements/Objects • Elements/Objects • Tables • Maps • Views • EDTs, Base Enums • Configuration Keys • License keys • Security Keys • Table Collections
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
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
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
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
Tables: Overview • Similar in nature to SQL tables with some differences • Tables can have methods • We can define relations, indexes
Tables: Elements • Following are the important elements of tables • Fields • Field Groups • Indexes • Full-text indexes • Relations • Methods • Delete Actions
Tables: Some important tables • CustTable • VendTable • HcmWorker • LedgerTable • InventTable • PurchTable • SalesTable
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
Demo • Create 2 new tables and link them up • Create a form to edit the data in these tables
Assignment • Create any one of the following tables • Create a form to edit the data in the table that you created.
Recipes: List of recipes • The following recipes are included in this presentation 2a. Create a new table 2b. Create and set a primary key on your table
Recipe 2a: Create a new table • Start • We are going to create a table called SpeciesTablewith 3 fields SpeciesId, Name, Description • Open Microsoft Dynamics AX client • Open Microsoft Dynamics AX development workspace (Ctrl + Shift + W) • The fields of a table are usually based on EDTs, so we need to create the 3 EDTs (or at least locate the EDTs that we can use) • Columns that are based on EDTs will inherit the EDTs label and the table could inherit EDTs relation • Right-click on AOT->Data Dictionary->Extended Data Types and select New->Sring • Rename the EDT to SpeciesIdand set the Caption property to Species Id • We will reuse existing EDTs for Name and Description • Right-Click on AOT->Data Dictionary->Tables and select New Table menu • Rename your table SpeciesTable • Set the Label property to Species • Right-click the SpeciesTablenode and select Open New Window • Drag the 3 EDTs one by one to the Fields node under the table SpeciesTable • Drag all the 3 fields to the node SpeciesTable->Field Groups->AutoReport • The idea is that every field should belong to at least one field group • Finish
Recipe 2b: Create and set a primary key on your table • Start • We are going to set the field SpeciesId as a primary key on our table SpeciesTable • Open Microsoft Dynamics AX client • Open Microsoft Dynamics AX development workspace (Ctrl + Shift + W) • Right-click on the node SpeciesTable->Indexes and select New Index • Rename the Index to SpeciesIdx • Drag the field SpeciesId on top of the Index SpeciesIdx • Select the node SpeciesIdxand set the propertyAllowDuplicatesto No and AlternateKeyto Yes and save your changes • We now need to set this Index as the primary key on the table, so select the table SpeciesTable • Set the property PrimaryIndexto SpeciesIdx • Finish
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
