Application Area Setup – Dynamics 365 BC Table Reference

Dynamics 365 BC Table Reference Tables System Tables AApplication Area Setup

Easily find this page again using the shortlink: https://bct.azrcrv.co.uk/9178

Table Type: System

Table Name: Application Area Setup
Database Table Name:

Table Number: 9178

Due to how Dynamics BC tables and columns are named, square brackets need to be wrapped around the table name and column names. Below are example queries showing how Application Area Setup can be queried.

Show/hide an example select of all columns

SELECT

   *

FROM

   []

Show/hide an example select of all columns by name

SELECT



FROM

   []

Show/hide an example select of all columns including those from all joined tables

SELECT
   *
FROM
   [] AS [Application Area Setup]
LEFT JOIN
   [Company] AS [Company]
      ON
         [Application Area Setup].[Company Name] = [Company].[Name]
LEFT JOIN
   [CRONUS UK Ltd_$Source Code$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Source Code]
      ON
         [Application Area Setup].[Assembly] = [Source Code].[Code]
LEFT JOIN
   [User] AS [User]
      ON
         [Application Area Setup].[SystemCreatedBy] = [User].[User Security ID]
LEFT JOIN
   [User] AS [User]
      ON
         [Application Area Setup].[SystemModifiedBy] = [User].[User Security ID]

Show/hide columns in Application Area Setup table

Field No.	Field Name	Field Caption	Class	Type	Length
1	Company Name	Company Name	Normal	Text	30
	Key to join to the Company table. Show/hide example query SELECT [Application Area Setup].[] ,[Company].[Name] FROM [] AS [Application Area Setup] LEFT JOIN [Company] AS [Company] ON [Application Area Setup].[] = [Company].[Name]
2	Profile ID	Profile ID	Normal	Code	30
3	User ID	User ID	Normal	Code	50
40	Invoicing	Invoicing	Normal	Boolean	4
100	Basic	Basic	Normal	Boolean	4
200	Suite	Suite	Normal	Boolean	4
300	Relationship Mgmt	Relationship Mgmt	Normal	Boolean	4
400	Jobs	Jobs	Normal	Boolean	4
500	Fixed Assets	Fixed Assets	Normal	Boolean	4
600	Location	Location	Normal	Boolean	4
700	BasicHR	BasicHR	Normal	Boolean	4
800	Assembly	Assembly	Normal	Boolean	4
	Key to join to the Source Code table. Show/hide example query SELECT [Application Area Setup].[] ,[Source Code].[Code] FROM [] AS [Application Area Setup] LEFT JOIN [CRONUS UK Ltd_$Source Code$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Source Code] ON [Application Area Setup].[] = [Source Code].[Code]
900	Item Charges	Item Charges	Normal	Boolean	4
1000	Advanced	Advanced	Normal	Boolean	4
1100	Warehouse	Warehouse	Normal	Boolean	4
1200	Service	Service	Normal	Boolean	4
1300	Manufacturing	Manufacturing	Normal	Boolean	4
1400	Planning	Planning	Normal	Boolean	4
1500	Dimensions	Dimensions	Normal	Boolean	4
1600	Item Tracking	Item Tracking	Normal	Boolean	4
1700	Intercompany	Intercompany	Normal	Boolean	4
1800	Sales Return Order	Sales Return Order	Normal	Boolean	4
1900	Purch Return Order	Purch Return Order	Normal	Boolean	4
2000	Prepayments	Prepayments	Normal	Boolean	4
2100	Cost Accounting	Cost Accounting	Normal	Boolean	4
2200	Sales Budget	Sales Budget	Normal	Boolean	4
2300	Purchase Budget	Purchase Budget	Normal	Boolean	4
2400	Item Budget	Item Budget	Normal	Boolean	4
2500	Sales Analysis	Sales Analysis	Normal	Boolean	4
2600	Purchase Analysis	Purchase Analysis	Normal	Boolean	4
2650	Inventory Analysis	Inventory Analysis	Normal	Boolean	4
2700	XBRL	XBRL	Normal	Boolean	4
2800	Reservation	Reservation	Normal	Boolean	4
2900	Order Promising	Order Promising	Normal	Boolean	4
3000	ADCS	ADCS	Normal	Boolean	4
3100	Comments	Comments	Normal	Boolean	4
3200	Record Links	Record Links	Normal	Boolean	4
3300	Notes	Notes	Normal	Boolean	4
3400	VAT	Tax	Normal	Boolean	4
3500	Sales Tax	Sales Tax	Normal	Boolean	4
3600	Item References	Item References	Normal	Boolean	4
5000	Basic EU	Basic EU	Normal	Boolean	4
5001	Basic CA	Basic CA	Normal	Boolean	4
5002	Basic US	Basic US	Normal	Boolean	4
5003	Basic MX	Basic MX	Normal	Boolean	4
5004	Basic AU	Basic AU	Normal	Boolean	4
5005	Basic NZ	Basic NZ	Normal	Boolean	4
5006	Basic AT	Basic AT	Normal	Boolean	4
5007	Basic CH	Basic CH	Normal	Boolean	4
5008	Basic DE	Basic DE	Normal	Boolean	4
5009	Basic BE	Basic BE	Normal	Boolean	4
5010	Basic CZ	Basic CZ	Normal	Boolean	4
5011	Basic DK	Basic DK	Normal	Boolean	4
5012	Basic ES	Basic ES	Normal	Boolean	4
5013	Basic FI	Basic FI	Normal	Boolean	4
5014	Basic FR	Basic FR	Normal	Boolean	4
5015	Basic GB	Basic GB	Normal	Boolean	4
5016	Basic IS	Basic IS	Normal	Boolean	4
5017	Basic IT	Basic IT	Normal	Boolean	4
5018	Basic NL	Basic NL	Normal	Boolean	4
5019	Basic NO	Basic NO	Normal	Boolean	4
5020	Basic RU	Basic RU	Normal	Boolean	4
5021	Basic SE	Basic SE	Normal	Boolean	4
2000000000	$systemId	System ID	Normal	GUID	16
2000000001	SystemCreatedAt	Created At	Normal	DateTime	8
2000000002	SystemCreatedBy	Created By	Normal	GUID	16
	Key to join to the User table. Show/hide example query SELECT [Application Area Setup].[] ,[User].[User Security ID] FROM [] AS [Application Area Setup] LEFT JOIN [User] AS [User] ON [Application Area Setup].[] = [User].[User Security ID]
2000000003	SystemModifiedAt	Modified At	Normal	DateTime	8
2000000004	SystemModifiedBy	Modified By	Normal	GUID	16