It is basically storing Company
data like Transactions, Journals, Inventory and General Ledger etc… as per the
Axapta application
System table
Identified by SYS prefix that
starts the name of the table
Fields
Using MorphX to
access the fields node to create of modify the physical columns in the database
table, any changes made in table node will be reflected in the database
Field Groups
It is logical
groupings of physical database fields, field group can be used in forms and
reports using field group to cluster fields into logical group, once
modification made to the fields group the entire application element related to
that group will be automatically updated. Apply when many fields logically
belong together and are shown together on forms, all fields on a table should
belong to a group
Indexes
Any
index define in AX table are physical indexes that exist on the tables in the
database
Full text indexes
X++ select statement cannot use a
full text index; these are queries that search for words embedded in the middle
of the string fields.
Relations
Relationship can
be created between tables, Microsoft Dynamics Axapta uses a relational database
Delete Actions
How
data will be handled when deletion event occurs in a parent table
Type of deletion action
1. None: Particular row in this table
deleted but nothing occurs in the specified table.
2. Cascade: Row in this table deleted
and all relevant data in the specific table is also deleted
3. Restricted: row from this table only
deleted if no relevant data found in the specific table, useful when parent
data should not be deleted
4. Cascade + Restricted: Same as
Restricted.
Methods
If you would like
to perform functions to the table, Like Data Lookup or any manipulation in data
based on events
