User 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
   [timestamp]
   ,[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]
   ,[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 columns in User Setup table

Column IDColumn NameData Type
1timestamp Searchtimestamp
2User ID Primary Key Searchnvarchar(100)
3Allow Posting From Searchdatetime
4Allow Posting To Searchdatetime
5Register Time Searchtinyint
6Allow Deferral Posting From Searchdatetime
7Allow Deferral Posting To Searchdatetime
8Salespers__Purch_ Code Searchnvarchar(40)
9Approver ID Searchnvarchar(100)
10Sales Amount Approval Limit Searchint
11Purchase Amount Approval Limit Searchint
12Unlimited Sales Approval Searchtinyint
13Unlimited Purchase Approval Searchtinyint
14Substitute Searchnvarchar(100)
15E-Mail Searchnvarchar(200)
16Phone No_ Searchnvarchar(60)
17Request Amount Approval Limit Searchint
18Unlimited Request Approval Searchtinyint
19Approval Administrator Searchtinyint
20Time Sheet Admin_ Searchtinyint
21Allow FA Posting From Searchdatetime
22Allow FA Posting To Searchdatetime
23Sales Resp_ Ctr_ Filter Searchnvarchar(20)
24Purchase Resp_ Ctr_ Filter Searchnvarchar(20)
25Service Resp_ Ctr_ Filter Searchnvarchar(20)
26$systemId Searchuniqueidentifier
27$systemCreatedAt Searchdatetime
28$systemCreatedBy Searchuniqueidentifier
29$systemModifiedAt Searchdatetime
30$systemModifiedBy Searchuniqueidentifier

Leave a Reply

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