GP Company Additional Settings

Dynamics 365 BC Table ReferenceTablesSystem TablesGGP Company Additional Settings

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

Table Type: System

Table Name: GP Company Additional Settings
Database Table Name:

Table Number: 40105

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

Show/hide columns in GP Company Additional Settings table

Field No.Field NameField CaptionClassTypeLengthSQL Column NameSQL DataType
1Name SearchNameNormalText30
7Migrate Inactive Customers Primary Key SearchMigrate Inactive CustomersNormalBoolean4
8Migrate Inactive Vendors SearchMigrate Inactive VendorsNormalBoolean4
10Migrate Inactive Checkbooks SearchMigrate Inactive CheckbooksNormalBoolean4
11Migrate Vendor Classes SearchMigrate Vendor ClassesNormalBoolean4
12Migrate Customer Classes SearchMigrate Customer ClassesNormalBoolean4
13Migrate Item Classes SearchMigrate Item ClassesNormalBoolean4
14Oldest GL Year to Migrate SearchOldest GL Year to MigrateNormalInteger4
15Migrate Bank Module SearchMigrate Bank ModuleNormalBoolean4
16Migrate Payables Module SearchMigrate Payables ModuleNormalBoolean4
17Migrate Receivables Module SearchMigrate Receivables ModuleNormalBoolean4
18Migrate Inventory Module SearchMigrate Inventory ModuleNormalBoolean4
19Global Dimension 1 SearchGlobal Dimension 1NormalText30
20Global Dimension 2 SearchGlobal Dimension 2NormalText30
21Migrate Open POs SearchMigrate Open POsNormalBoolean4
22Migrate Only GL Master SearchMigrate Only GL MasterNormalBoolean4
23Migrate Only Bank Master SearchMigrate Only Bank MasterNormalBoolean4
24Migrate Only Payables Master SearchMigrate Only Payables MasterNormalBoolean4
25Migrate Only Rec. Master SearchMigrate Only Rec. MasterNormalBoolean4
26Migrate Only Inventory Master SearchMigrate Only Inventory MasterNormalBoolean4
27Migrate Inactive Items SearchMigrate Inactive ItemsNormalBoolean4
28Migrate Discontinued Items SearchMigrate Discontinued ItemsNormalBoolean4
29Oldest Hist. Year to Migrate SearchOldest Hist. Year to MigrateNormalInteger4
30Migrate Hist. GL Trx. SearchMigrate Hist. GL Trx.NormalBoolean4
31Migrate Hist. AR Trx. SearchMigrate Hist. AR Trx.NormalBoolean4
32Migrate Hist. AP Trx. SearchMigrate Hist. AP Trx.NormalBoolean4
33Migrate Hist. Inv. Trx. SearchMigrate Hist. Inv. Trx.NormalBoolean4
34Migrate Hist. Purch. Trx. SearchMigrate Hist. Purch. Trx.NormalBoolean4
35Migration Completed SearchMigration CompletedFlowFieldBoolean4
36Skip Posting Account Batches SearchSkip Posting Account BatchesNormalBoolean4
37Skip Posting Customer Batches SearchSkip Posting Customer BatchesNormalBoolean4
38Skip Posting Vendor Batches SearchSkip Posting Vendor BatchesNormalBoolean4
39Skip Posting Bank Batches SearchSkip Posting Bank BatchesNormalBoolean4
100Migrate Vendor 1099 SearchMigrate Vendor 1099NormalBoolean4
1011099 Tax Year Search1099 Tax YearNormalInteger4
2000000000$systemId SearchSystem IDNormalGUID16
2000000001SystemCreatedAt SearchCreated AtNormalDateTime8
2000000002SystemCreatedBy SearchCreated ByNormalGUID16
Key to join to the User table.

Show/hide example query

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

Leave a Reply

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