GP Configuration

Dynamics 365 BC Table ReferenceTablesCompany TablesGGP Configuration

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

Table Type: Company

Table Name: GP Configuration
Database Table Name:

Table Number: 4024

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 GP Configuration 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 [GP Configuration]
LEFT JOIN
   [User] AS [User]
      ON
         [GP Configuration].[SystemCreatedBy] = [User].[User Security ID]
LEFT JOIN
   [User] AS [User]
      ON
         [GP Configuration].[SystemModifiedBy] = [User].[User Security ID]

Show/hide columns in GP Configuration table

Field No.Field NameField CaptionClassTypeLengthSQL Column NameSQL DataType
1Dummy SearchDummyNormalCode10
2Updated GL Setup Primary Key SearchUpdated GL SetupNormalBoolean4
3GL Transactions Processed SearchGL Transactions ProcessedNormalBoolean4
4Account Validation Error SearchAccount Validation ErrorNormalBoolean4
5Finish Event Processed SearchFinish Event ProcessedNormalBoolean4
6Last Error Message SearchLast Error MessageNormalText250
7PreMigration Cleanup Completed SearchPreMigration Cleanup CompletedNormalBoolean4
8Dimensions Created SearchDimensions CreatedNormalBoolean4
9Payment Terms Created SearchPayment Terms CreatedNormalBoolean4
10Item Tracking Codes Created SearchItem Tracking Codes CreatedNormalBoolean4
11Locations Created SearchLocations CreatedNormalBoolean4
12CheckBooks Created SearchCheckBooks CreatedNormalBoolean4
13Open Purchase Orders Created SearchOpen Purchase Orders CreatedNormalBoolean4
14Fiscal Periods Created SearchFiscal Periods CreatedNormalBoolean4
15Vendor EFT Bank Acc. Created SearchVendor EFT Bank Acc. CreatedNormalBoolean4
16Vendor Classes Created SearchVendor Classes CreatedNormalBoolean4
17Customer Classes Created SearchCustomer Classes CreatedNormalBoolean4
18Historical Job Ran SearchHistorical Job RanNormalBoolean4
2000000000$systemId SearchSystem IDNormalGUID16
2000000001SystemCreatedAt SearchCreated AtNormalDateTime8
2000000002SystemCreatedBy SearchCreated ByNormalGUID16
Key to join to the User table.

Show/hide example query

SELECT
	       [GP Configuration].[]
	       ,[User].[User Security ID]
	FROM
	       [] AS [GP Configuration]
	LEFT JOIN
	       [User] AS [User]
	              ON
	                     [GP Configuration].[] = [User].[User Security ID]
2000000003SystemModifiedAt SearchModified AtNormalDateTime8
2000000004SystemModifiedBy SearchModified ByNormalGUID16
Dynamics 365 BC Table ReferenceTablesCompany TablesGGP Configuration

Leave a Reply

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