Table and Field Structure

Below is a high-level overview of the main tables, fields and forms within DEACOM. Please refer to System > Data Dictionary within DEACOM for a complete list.

All DEACOM tables have an indicator to specify the type of table:

• dm: maintenance tables
• dt: transaction tables
• dx: system tables

Note on IDs:

• _id – This is a unique integer primary key identifier that increases by 1 for every row of data. This can be found in most tables (only 15 tables are exceptions at the time of writing). Example: pr_id is the unique identifier on the dmprod (Item Master) table.
• _*id – This is a reference and link to a primary key on another table. This is not unique. Example: cu_prid is the link from the dmcust (Customer Parts) table to the table dmprod (Item Master).
• _guid – This is a unique identifier field that is used on just a few tables. The SQL data type is uniqueidentifier and is a system generated key. Example: c2_guid is the unique ID on the dxcaption2 (Captions) table in addition to the c2_id being the integer primary key unique ID.
• _*guid – This is a link to a unique identifier field on another table. This is not unique. Example: d3_c2guid is the link from the dmd3 (UDF pick-list options) table to the table dxcaption2 (Captions).