User Setup

Dynamics 365 BC Table ReferenceTablesCompany TablesUUser Setup

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

Table Type: Company

Table Name: User Setup
Database Table Name: CRONUS UK Ltd_$User Setup$437dbf0e-84ff-417a-965d-ed2bb9650972

Table Number: 91

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 User Setup can be queried.

Show/hide an example select of all columns

SELECT

   *

FROM

   [CRONUS UK Ltd_$User Setup$437dbf0e-84ff-417a-965d-ed2bb9650972]

Show/hide an example select of all columns by name

SELECT

   [User ID]
   ,[Allow Posting From]
   ,[Allow Posting To]
   ,[Register Time]
   ,[Allow Deferral Posting From]
   ,[Allow Deferral Posting To]
   ,[Salespers__Purch_ Code]
   ,[Approver ID]
   ,[Sales Amount Approval Limit]
   ,[Purchase Amount Approval Limit]
   ,[Unlimited Sales Approval]
   ,[Unlimited Purchase Approval]
   ,[Substitute]
   ,[E-Mail]
   ,[Phone No_]
   ,[Request Amount Approval Limit]
   ,[Unlimited Request Approval]
   ,[Approval Administrator]
   ,[Sales Invoice Posting Policy]
   ,[Purch_ Invoice Posting Policy]
   ,[Time Sheet Admin_]
   ,[Allow FA Posting From]
   ,[Allow FA Posting To]
   ,[Sales Resp_ Ctr_ Filter]
   ,[Purchase Resp_ Ctr_ Filter]
   ,[Service Resp_ Ctr_ Filter]
   ,[$systemId]
   ,[$systemCreatedAt]
   ,[$systemCreatedBy]
   ,[$systemModifiedAt]
   ,[$systemModifiedBy]

FROM

   [CRONUS UK Ltd_$User Setup$437dbf0e-84ff-417a-965d-ed2bb9650972]

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

SELECT
   *
FROM
   [CRONUS UK Ltd_$User Setup$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [User Setup]
LEFT JOIN
   [CRONUS UK Ltd_$User Setup$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [User Setup]
      ON
         [User Setup].[Approver ID] = [User Setup].[User ID]
LEFT JOIN
   [CRONUS UK Ltd_$User Setup$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [User Setup]
      ON
         [User Setup].[Substitute] = [User Setup].[User ID]
LEFT JOIN
   [User] AS [User]
      ON
         [User Setup].[SystemCreatedBy] = [User].[User Security ID]
LEFT JOIN
   [User] AS [User]
      ON
         [User Setup].[SystemModifiedBy] = [User].[User Security ID]

Show/hide columns in User Setup table

Field No.Field NameField CaptionClassTypeLengthSQL Column NameSQL DataType
1User ID SearchUser IDNormalCode50User IDnvarchar(100)
2Allow Posting From Primary Key SearchAllow Posting FromNormalDate4Allow Posting Fromdatetime
3Allow Posting To SearchAllow Posting ToNormalDate4Allow Posting Todatetime
4Register Time SearchRegister TimeNormalBoolean4Register Timetinyint
5Allow Deferral Posting From SearchAllow Deferral Posting FromNormalDate4Allow Deferral Posting Fromdatetime
6Allow Deferral Posting To SearchAllow Deferral Posting ToNormalDate4Allow Deferral Posting Todatetime
10Salespers./Purch. Code SearchSalespers./Purch. CodeNormalCode20Salespers__Purch_ Codenvarchar(40)
11Approver ID SearchApprover IDNormalCode50Approver IDnvarchar(100)
12Sales Amount Approval Limit SearchSales Amount Approval LimitNormalInteger4Sales Amount Approval Limitint
13Purchase Amount Approval Limit SearchPurchase Amount Approval LimitNormalInteger4Purchase Amount Approval Limitint
14Unlimited Sales Approval SearchUnlimited Sales ApprovalNormalBoolean4Unlimited Sales Approvaltinyint
15Unlimited Purchase Approval SearchUnlimited Purchase ApprovalNormalBoolean4Unlimited Purchase Approvaltinyint
16Substitute SearchSubstituteNormalCode50Substitutenvarchar(100)
17E-Mail SearchE-MailNormalText100E-Mailnvarchar(200)
18Phone No. SearchPhone No.NormalText30Phone No_nvarchar(60)
19Request Amount Approval Limit SearchRequest Amount Approval LimitNormalInteger4Request Amount Approval Limitint
20Unlimited Request Approval SearchUnlimited Request ApprovalNormalBoolean4Unlimited Request Approvaltinyint
21Approval Administrator SearchApproval AdministratorNormalBoolean4Approval Administratortinyint
31License Type SearchLicense TypeFlowFieldOption4
80Sales Invoice Posting Policy SearchSales Invoice Posting PolicyNormalOption4Sales Invoice Posting Policyint
Available options are:
  • “Allowed”
  • “Prohibited”
  • “Mandatory”
90Purch. Invoice Posting Policy SearchPurch. Invoice Posting PolicyNormalOption4Purch_ Invoice Posting Policyint
Available options are:
  • “Allowed”
  • “Prohibited”
  • “Mandatory”
950Time Sheet Admin. SearchTime Sheet Admin.NormalBoolean4Time Sheet Admin_tinyint
5600Allow FA Posting From SearchAllow FA Posting FromNormalDate4Allow FA Posting Fromdatetime
5601Allow FA Posting To SearchAllow FA Posting ToNormalDate4Allow FA Posting Todatetime
5700Sales Resp. Ctr. Filter SearchSales Resp. Ctr. FilterNormalCode10Sales Resp_ Ctr_ Filternvarchar(20)
Key to join to the Responsibility Center table.

Show/hide example query

SELECT
	       [User Setup].[Sales Resp_ Ctr_ Filter]
	       ,[Responsibility Center].[Code]
	FROM
	       [CRONUS UK Ltd_$User Setup$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [User Setup]
	LEFT JOIN
	       [CRONUS UK Ltd_$Responsibility Center$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Responsibility Center]
	              ON
	                     [User Setup].[Sales Resp_ Ctr_ Filter] = [Responsibility Center].[Code]
5701Purchase Resp. Ctr. Filter SearchPurchase Resp. Ctr. FilterNormalCode10Purchase Resp_ Ctr_ Filternvarchar(20)
Key to join to the Responsibility Center table.

Show/hide example query

SELECT
	       [User Setup].[Purchase Resp_ Ctr_ Filter]
	       ,[Responsibility Center].[Code]
	FROM
	       [CRONUS UK Ltd_$User Setup$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [User Setup]
	LEFT JOIN
	       [CRONUS UK Ltd_$Responsibility Center$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Responsibility Center]
	              ON
	                     [User Setup].[Purchase Resp_ Ctr_ Filter] = [Responsibility Center].[Code]
5900Service Resp. Ctr. Filter SearchService Resp. Ctr. FilterNormalCode10Service Resp_ Ctr_ Filternvarchar(20)
Key to join to the Responsibility Center table.

Show/hide example query

SELECT
	       [User Setup].[Service Resp_ Ctr_ Filter]
	       ,[Responsibility Center].[Code]
	FROM
	       [CRONUS UK Ltd_$User Setup$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [User Setup]
	LEFT JOIN
	       [CRONUS UK Ltd_$Responsibility Center$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Responsibility Center]
	              ON
	                     [User Setup].[Service Resp_ Ctr_ Filter] = [Responsibility Center].[Code]
2000000000$systemId SearchSystem IDNormalGUID16$systemIduniqueidentifier
2000000001SystemCreatedAt SearchCreated AtNormalDateTime8$systemCreatedAtdatetime
2000000002SystemCreatedBy SearchCreated ByNormalGUID16$systemCreatedByuniqueidentifier
Key to join to the User table.

Show/hide example query

SELECT
	       [User Setup].[$systemCreatedBy]
	       ,[User].[User Security ID]
	FROM
	       [CRONUS UK Ltd_$User Setup$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [User Setup]
	LEFT JOIN
	       [User] AS [User]
	              ON
	                     [User Setup].[$systemCreatedBy] = [User].[User Security ID]
2000000003SystemModifiedAt SearchModified AtNormalDateTime8$systemModifiedAtdatetime
2000000004SystemModifiedBy SearchModified ByNormalGUID16$systemModifiedByuniqueidentifier
Dynamics 365 BC Table ReferenceTablesCompany TablesUUser Setup

Leave a Reply

Your email address will not be published. Required fields are marked *