General Posting Setup

Dynamics 365 BC Table ReferenceTablesCompany TablesGGeneral Posting Setup

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

Table Type: Company

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

Table Number: 252

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

Show/hide an example select of all columns

SELECT

   *

FROM

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

Show/hide an example select of all columns by name

SELECT

   [Gen_ Bus_ Posting Group]
   ,[Gen_ Prod_ Posting Group]
   ,[Sales Account]
   ,[Sales Line Disc_ Account]
   ,[Sales Inv_ Disc_ Account]
   ,[Sales Pmt_ Disc_ Debit Acc_]
   ,[Purch_ Account]
   ,[Purch_ Line Disc_ Account]
   ,[Purch_ Inv_ Disc_ Account]
   ,[Purch_ Pmt_ Disc_ Credit Acc_]
   ,[COGS Account]
   ,[Inventory Adjmt_ Account]
   ,[Sales Credit Memo Account]
   ,[Purch_ Credit Memo Account]
   ,[Sales Pmt_ Disc_ Credit Acc_]
   ,[Purch_ Pmt_ Disc_ Debit Acc_]
   ,[Sales Pmt_ Tol_ Debit Acc_]
   ,[Sales Pmt_ Tol_ Credit Acc_]
   ,[Purch_ Pmt_ Tol_ Debit Acc_]
   ,[Purch_ Pmt_ Tol_ Credit Acc_]
   ,[Sales Prepayments Account]
   ,[Purch_ Prepayments Account]
   ,[Description]
   ,[View All Accounts on Lookup]
   ,[Blocked]
   ,[Purch_ FA Disc_ Account]
   ,[Invt_ Accrual Acc_ (Interim)]
   ,[COGS Account (Interim)]
   ,[Direct Cost Applied Account]
   ,[Overhead Applied Account]
   ,[Purchase Variance Account]
   ,[$systemId]
   ,[$systemCreatedAt]
   ,[$systemCreatedBy]
   ,[$systemModifiedAt]
   ,[$systemModifiedBy]

FROM

   [CRONUS UK Ltd_$General Posting 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_$General Posting Setup$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [General Posting Setup]
LEFT JOIN
   [CRONUS UK Ltd_$G_L Account$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [G/L Account]
      ON
         [General Posting Setup].[Sales Account] = [G/L Account].[No_]
LEFT JOIN
   [CRONUS UK Ltd_$G_L Account$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [G/L Account]
      ON
         [General Posting Setup].[COGS Account] = [G/L Account].[No_]
LEFT JOIN
   [CRONUS UK Ltd_$G_L Account$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [G/L Account]
      ON
         [General Posting Setup].[Sales Credit Memo Account] = [G/L Account].[No_]
LEFT JOIN
   [CRONUS UK Ltd_$G_L Account$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [G/L Account]
      ON
         [General Posting Setup].[Sales Prepayments Account] = [G/L Account].[No_]
LEFT JOIN
   [CRONUS UK Ltd_$G_L Account$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [G/L Account]
      ON
         [General Posting Setup].[COGS Account (Interim)] = [G/L Account].[No_]
LEFT JOIN
   [CRONUS UK Ltd_$G_L Account$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [G/L Account]
      ON
         [General Posting Setup].[Direct Cost Applied Account] = [G/L Account].[No_]
LEFT JOIN
   [CRONUS UK Ltd_$G_L Account$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [G/L Account]
      ON
         [General Posting Setup].[Overhead Applied Account] = [G/L Account].[No_]
LEFT JOIN
   [CRONUS UK Ltd_$G_L Account$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [G/L Account]
      ON
         [General Posting Setup].[Purchase Variance Account] = [G/L Account].[No_]
LEFT JOIN
   [User] AS [User]
      ON
         [General Posting Setup].[SystemCreatedBy] = [User].[User Security ID]
LEFT JOIN
   [User] AS [User]
      ON
         [General Posting Setup].[SystemModifiedBy] = [User].[User Security ID]

Show/hide columns in General Posting Setup table

Field No.Field NameField CaptionClassTypeLengthSQL Column NameSQL DataType
1Gen. Bus. Posting Group Primary Key SearchGen. Bus. Posting GroupNormalCode20Gen_ Bus_ Posting Groupnvarchar(40)
Key to join to the Gen. Business Posting Group table.

Show/hide example query

SELECT
       [General Posting Setup].[Gen_ Bus_ Posting Group]
       ,[Gen. Business Posting Group].[Code]
FROM
       [CRONUS UK Ltd_$General Posting Setup$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [General Posting Setup]
LEFT JOIN
       [CRONUS UK Ltd_$Gen_ Business Posting Group$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Gen. Business Posting Group]
              ON
                     [General Posting Setup].[Gen_ Bus_ Posting Group] = [Gen. Business Posting Group].[Code]
2Gen. Prod. Posting Group Primary Key SearchGen. Prod. Posting GroupNormalCode20Gen_ Prod_ Posting Groupnvarchar(40)
Key to join to the Gen. Product Posting Group table.

Show/hide example query

SELECT
       [General Posting Setup].[Gen_ Prod_ Posting Group]
       ,[Gen. Product Posting Group].[Code]
FROM
       [CRONUS UK Ltd_$General Posting Setup$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [General Posting Setup]
LEFT JOIN
       [CRONUS UK Ltd_$Gen_ Product Posting Group$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Gen. Product Posting Group]
              ON
                     [General Posting Setup].[Gen_ Prod_ Posting Group] = [Gen. Product Posting Group].[Code]
10Sales Account SearchSales AccountNormalCode20Sales Accountnvarchar(40)
Key to join to the G/L Account table.

Show/hide example query

SELECT
       [General Posting Setup].[Sales Account]
       ,[G/L Account].[No_]
FROM
       [CRONUS UK Ltd_$General Posting Setup$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [General Posting Setup]
LEFT JOIN
       [CRONUS UK Ltd_$G_L Account$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [G/L Account]
              ON
                     [General Posting Setup].[Sales Account] = [G/L Account].[No_]
11Sales Line Disc. Account SearchSales Line Disc. AccountNormalCode20Sales Line Disc_ Accountnvarchar(40)
Key to join to the G/L Account table.

Show/hide example query

SELECT
       [General Posting Setup].[Sales Line Disc_ Account]
       ,[G/L Account].[No_]
FROM
       [CRONUS UK Ltd_$General Posting Setup$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [General Posting Setup]
LEFT JOIN
       [CRONUS UK Ltd_$G_L Account$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [G/L Account]
              ON
                     [General Posting Setup].[Sales Line Disc_ Account] = [G/L Account].[No_]
12Sales Inv. Disc. Account SearchSales Inv. Disc. AccountNormalCode20Sales Inv_ Disc_ Accountnvarchar(40)
Key to join to the G/L Account table.

Show/hide example query

SELECT
       [General Posting Setup].[Sales Inv_ Disc_ Account]
       ,[G/L Account].[No_]
FROM
       [CRONUS UK Ltd_$General Posting Setup$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [General Posting Setup]
LEFT JOIN
       [CRONUS UK Ltd_$G_L Account$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [G/L Account]
              ON
                     [General Posting Setup].[Sales Inv_ Disc_ Account] = [G/L Account].[No_]
13Sales Pmt. Disc. Debit Acc. SearchSales Pmt. Disc. Debit Acc.NormalCode20Sales Pmt_ Disc_ Debit Acc_nvarchar(40)
Key to join to the G/L Account table.

Show/hide example query

SELECT
       [General Posting Setup].[Sales Pmt_ Disc_ Debit Acc_]
       ,[G/L Account].[No_]
FROM
       [CRONUS UK Ltd_$General Posting Setup$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [General Posting Setup]
LEFT JOIN
       [CRONUS UK Ltd_$G_L Account$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [G/L Account]
              ON
                     [General Posting Setup].[Sales Pmt_ Disc_ Debit Acc_] = [G/L Account].[No_]
14Purch. Account SearchPurch. AccountNormalCode20Purch_ Accountnvarchar(40)
Key to join to the G/L Account table.

Show/hide example query

SELECT
       [General Posting Setup].[Purch_ Account]
       ,[G/L Account].[No_]
FROM
       [CRONUS UK Ltd_$General Posting Setup$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [General Posting Setup]
LEFT JOIN
       [CRONUS UK Ltd_$G_L Account$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [G/L Account]
              ON
                     [General Posting Setup].[Purch_ Account] = [G/L Account].[No_]
15Purch. Line Disc. Account SearchPurch. Line Disc. AccountNormalCode20Purch_ Line Disc_ Accountnvarchar(40)
Key to join to the G/L Account table.

Show/hide example query

SELECT
       [General Posting Setup].[Purch_ Line Disc_ Account]
       ,[G/L Account].[No_]
FROM
       [CRONUS UK Ltd_$General Posting Setup$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [General Posting Setup]
LEFT JOIN
       [CRONUS UK Ltd_$G_L Account$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [G/L Account]
              ON
                     [General Posting Setup].[Purch_ Line Disc_ Account] = [G/L Account].[No_]
16Purch. Inv. Disc. Account SearchPurch. Inv. Disc. AccountNormalCode20Purch_ Inv_ Disc_ Accountnvarchar(40)
Key to join to the G/L Account table.

Show/hide example query

SELECT
       [General Posting Setup].[Purch_ Inv_ Disc_ Account]
       ,[G/L Account].[No_]
FROM
       [CRONUS UK Ltd_$General Posting Setup$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [General Posting Setup]
LEFT JOIN
       [CRONUS UK Ltd_$G_L Account$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [G/L Account]
              ON
                     [General Posting Setup].[Purch_ Inv_ Disc_ Account] = [G/L Account].[No_]
17Purch. Pmt. Disc. Credit Acc. SearchPurch. Pmt. Disc. Credit Acc.NormalCode20Purch_ Pmt_ Disc_ Credit Acc_nvarchar(40)
Key to join to the G/L Account table.

Show/hide example query

SELECT
       [General Posting Setup].[Purch_ Pmt_ Disc_ Credit Acc_]
       ,[G/L Account].[No_]
FROM
       [CRONUS UK Ltd_$General Posting Setup$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [General Posting Setup]
LEFT JOIN
       [CRONUS UK Ltd_$G_L Account$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [G/L Account]
              ON
                     [General Posting Setup].[Purch_ Pmt_ Disc_ Credit Acc_] = [G/L Account].[No_]
18COGS Account SearchCOGS AccountNormalCode20COGS Accountnvarchar(40)
Key to join to the G/L Account table.

Show/hide example query

SELECT
       [General Posting Setup].[COGS Account]
       ,[G/L Account].[No_]
FROM
       [CRONUS UK Ltd_$General Posting Setup$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [General Posting Setup]
LEFT JOIN
       [CRONUS UK Ltd_$G_L Account$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [G/L Account]
              ON
                     [General Posting Setup].[COGS Account] = [G/L Account].[No_]
19Inventory Adjmt. Account SearchInventory Adjmt. AccountNormalCode20Inventory Adjmt_ Accountnvarchar(40)
Key to join to the G/L Account table.

Show/hide example query

SELECT
       [General Posting Setup].[Inventory Adjmt_ Account]
       ,[G/L Account].[No_]
FROM
       [CRONUS UK Ltd_$General Posting Setup$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [General Posting Setup]
LEFT JOIN
       [CRONUS UK Ltd_$G_L Account$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [G/L Account]
              ON
                     [General Posting Setup].[Inventory Adjmt_ Account] = [G/L Account].[No_]
27Sales Credit Memo Account SearchSales Credit Memo AccountNormalCode20Sales Credit Memo Accountnvarchar(40)
Key to join to the G/L Account table.

Show/hide example query

SELECT
       [General Posting Setup].[Sales Credit Memo Account]
       ,[G/L Account].[No_]
FROM
       [CRONUS UK Ltd_$General Posting Setup$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [General Posting Setup]
LEFT JOIN
       [CRONUS UK Ltd_$G_L Account$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [G/L Account]
              ON
                     [General Posting Setup].[Sales Credit Memo Account] = [G/L Account].[No_]
28Purch. Credit Memo Account SearchPurch. Credit Memo AccountNormalCode20Purch_ Credit Memo Accountnvarchar(40)
Key to join to the G/L Account table.

Show/hide example query

SELECT
       [General Posting Setup].[Purch_ Credit Memo Account]
       ,[G/L Account].[No_]
FROM
       [CRONUS UK Ltd_$General Posting Setup$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [General Posting Setup]
LEFT JOIN
       [CRONUS UK Ltd_$G_L Account$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [G/L Account]
              ON
                     [General Posting Setup].[Purch_ Credit Memo Account] = [G/L Account].[No_]
30Sales Pmt. Disc. Credit Acc. SearchSales Pmt. Disc. Credit Acc.NormalCode20Sales Pmt_ Disc_ Credit Acc_nvarchar(40)
Key to join to the G/L Account table.

Show/hide example query

SELECT
       [General Posting Setup].[Sales Pmt_ Disc_ Credit Acc_]
       ,[G/L Account].[No_]
FROM
       [CRONUS UK Ltd_$General Posting Setup$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [General Posting Setup]
LEFT JOIN
       [CRONUS UK Ltd_$G_L Account$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [G/L Account]
              ON
                     [General Posting Setup].[Sales Pmt_ Disc_ Credit Acc_] = [G/L Account].[No_]
31Purch. Pmt. Disc. Debit Acc. SearchPurch. Pmt. Disc. Debit Acc.NormalCode20Purch_ Pmt_ Disc_ Debit Acc_nvarchar(40)
Key to join to the G/L Account table.

Show/hide example query

SELECT
       [General Posting Setup].[Purch_ Pmt_ Disc_ Debit Acc_]
       ,[G/L Account].[No_]
FROM
       [CRONUS UK Ltd_$General Posting Setup$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [General Posting Setup]
LEFT JOIN
       [CRONUS UK Ltd_$G_L Account$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [G/L Account]
              ON
                     [General Posting Setup].[Purch_ Pmt_ Disc_ Debit Acc_] = [G/L Account].[No_]
32Sales Pmt. Tol. Debit Acc. SearchSales Pmt. Tol. Debit Acc.NormalCode20Sales Pmt_ Tol_ Debit Acc_nvarchar(40)
Key to join to the G/L Account table.

Show/hide example query

SELECT
       [General Posting Setup].[Sales Pmt_ Tol_ Debit Acc_]
       ,[G/L Account].[No_]
FROM
       [CRONUS UK Ltd_$General Posting Setup$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [General Posting Setup]
LEFT JOIN
       [CRONUS UK Ltd_$G_L Account$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [G/L Account]
              ON
                     [General Posting Setup].[Sales Pmt_ Tol_ Debit Acc_] = [G/L Account].[No_]
33Sales Pmt. Tol. Credit Acc. SearchSales Pmt. Tol. Credit Acc.NormalCode20Sales Pmt_ Tol_ Credit Acc_nvarchar(40)
Key to join to the G/L Account table.

Show/hide example query

SELECT
       [General Posting Setup].[Sales Pmt_ Tol_ Credit Acc_]
       ,[G/L Account].[No_]
FROM
       [CRONUS UK Ltd_$General Posting Setup$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [General Posting Setup]
LEFT JOIN
       [CRONUS UK Ltd_$G_L Account$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [G/L Account]
              ON
                     [General Posting Setup].[Sales Pmt_ Tol_ Credit Acc_] = [G/L Account].[No_]
34Purch. Pmt. Tol. Debit Acc. SearchPurch. Pmt. Tol. Debit Acc.NormalCode20Purch_ Pmt_ Tol_ Debit Acc_nvarchar(40)
Key to join to the G/L Account table.

Show/hide example query

SELECT
       [General Posting Setup].[Purch_ Pmt_ Tol_ Debit Acc_]
       ,[G/L Account].[No_]
FROM
       [CRONUS UK Ltd_$General Posting Setup$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [General Posting Setup]
LEFT JOIN
       [CRONUS UK Ltd_$G_L Account$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [G/L Account]
              ON
                     [General Posting Setup].[Purch_ Pmt_ Tol_ Debit Acc_] = [G/L Account].[No_]
35Purch. Pmt. Tol. Credit Acc. SearchPurch. Pmt. Tol. Credit Acc.NormalCode20Purch_ Pmt_ Tol_ Credit Acc_nvarchar(40)
Key to join to the G/L Account table.

Show/hide example query

SELECT
       [General Posting Setup].[Purch_ Pmt_ Tol_ Credit Acc_]
       ,[G/L Account].[No_]
FROM
       [CRONUS UK Ltd_$General Posting Setup$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [General Posting Setup]
LEFT JOIN
       [CRONUS UK Ltd_$G_L Account$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [G/L Account]
              ON
                     [General Posting Setup].[Purch_ Pmt_ Tol_ Credit Acc_] = [G/L Account].[No_]
36Sales Prepayments Account SearchSales Prepayments AccountNormalCode20Sales Prepayments Accountnvarchar(40)
Key to join to the G/L Account table.

Show/hide example query

SELECT
       [General Posting Setup].[Sales Prepayments Account]
       ,[G/L Account].[No_]
FROM
       [CRONUS UK Ltd_$General Posting Setup$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [General Posting Setup]
LEFT JOIN
       [CRONUS UK Ltd_$G_L Account$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [G/L Account]
              ON
                     [General Posting Setup].[Sales Prepayments Account] = [G/L Account].[No_]
37Purch. Prepayments Account SearchPurch. Prepayments AccountNormalCode20Purch_ Prepayments Accountnvarchar(40)
Key to join to the G/L Account table.

Show/hide example query

SELECT
       [General Posting Setup].[Purch_ Prepayments Account]
       ,[G/L Account].[No_]
FROM
       [CRONUS UK Ltd_$General Posting Setup$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [General Posting Setup]
LEFT JOIN
       [CRONUS UK Ltd_$G_L Account$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [G/L Account]
              ON
                     [General Posting Setup].[Purch_ Prepayments Account] = [G/L Account].[No_]
50Description SearchDescriptionNormalText100Descriptionnvarchar(200)
51View All Accounts on Lookup SearchView All Accounts on LookupNormalBoolean4View All Accounts on Lookuptinyint
52Blocked SearchBlockedNormalBoolean4Blockedtinyint
5600Purch. FA Disc. Account SearchPurch. FA Disc. AccountNormalCode20Purch_ FA Disc_ Accountnvarchar(40)
Key to join to the G/L Account table.

Show/hide example query

SELECT
       [General Posting Setup].[Purch_ FA Disc_ Account]
       ,[G/L Account].[No_]
FROM
       [CRONUS UK Ltd_$General Posting Setup$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [General Posting Setup]
LEFT JOIN
       [CRONUS UK Ltd_$G_L Account$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [G/L Account]
              ON
                     [General Posting Setup].[Purch_ FA Disc_ Account] = [G/L Account].[No_]
5801Invt. Accrual Acc. (Interim) SearchInvt. Accrual Acc. (Interim)NormalCode20Invt_ Accrual Acc_ (Interim)nvarchar(40)
Key to join to the G/L Account table.

Show/hide example query

SELECT
       [General Posting Setup].[Invt_ Accrual Acc_ (Interim)]
       ,[G/L Account].[No_]
FROM
       [CRONUS UK Ltd_$General Posting Setup$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [General Posting Setup]
LEFT JOIN
       [CRONUS UK Ltd_$G_L Account$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [G/L Account]
              ON
                     [General Posting Setup].[Invt_ Accrual Acc_ (Interim)] = [G/L Account].[No_]
5803COGS Account (Interim) SearchCOGS Account (Interim)NormalCode20COGS Account (Interim)nvarchar(40)
Key to join to the G/L Account table.

Show/hide example query

SELECT
       [General Posting Setup].[COGS Account (Interim)]
       ,[G/L Account].[No_]
FROM
       [CRONUS UK Ltd_$General Posting Setup$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [General Posting Setup]
LEFT JOIN
       [CRONUS UK Ltd_$G_L Account$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [G/L Account]
              ON
                     [General Posting Setup].[COGS Account (Interim)] = [G/L Account].[No_]
99000752Direct Cost Applied Account SearchDirect Cost Applied AccountNormalCode20Direct Cost Applied Accountnvarchar(40)
Key to join to the G/L Account table.

Show/hide example query

SELECT
       [General Posting Setup].[Direct Cost Applied Account]
       ,[G/L Account].[No_]
FROM
       [CRONUS UK Ltd_$General Posting Setup$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [General Posting Setup]
LEFT JOIN
       [CRONUS UK Ltd_$G_L Account$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [G/L Account]
              ON
                     [General Posting Setup].[Direct Cost Applied Account] = [G/L Account].[No_]
99000753Overhead Applied Account SearchOverhead Applied AccountNormalCode20Overhead Applied Accountnvarchar(40)
Key to join to the G/L Account table.

Show/hide example query

SELECT
       [General Posting Setup].[Overhead Applied Account]
       ,[G/L Account].[No_]
FROM
       [CRONUS UK Ltd_$General Posting Setup$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [General Posting Setup]
LEFT JOIN
       [CRONUS UK Ltd_$G_L Account$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [G/L Account]
              ON
                     [General Posting Setup].[Overhead Applied Account] = [G/L Account].[No_]
99000754Purchase Variance Account SearchPurchase Variance AccountNormalCode20Purchase Variance Accountnvarchar(40)
Key to join to the G/L Account table.

Show/hide example query

SELECT
       [General Posting Setup].[Purchase Variance Account]
       ,[G/L Account].[No_]
FROM
       [CRONUS UK Ltd_$General Posting Setup$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [General Posting Setup]
LEFT JOIN
       [CRONUS UK Ltd_$G_L Account$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [G/L Account]
              ON
                     [General Posting Setup].[Purchase Variance Account] = [G/L Account].[No_]
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
       [General Posting Setup].[$systemCreatedBy]
       ,[User].[User Security ID]
FROM
       [CRONUS UK Ltd_$General Posting Setup$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [General Posting Setup]
LEFT JOIN
       [User] AS [User]
              ON
                     [General Posting Setup].[$systemCreatedBy] = [User].[User Security ID]
2000000003SystemModifiedAt SearchModified AtNormalDateTime8$systemModifiedAtdatetime
2000000004SystemModifiedBy SearchModified ByNormalGUID16$systemModifiedByuniqueidentifier
Key to join to the User table.

Show/hide example query

SELECT
       [General Posting Setup].[$systemModifiedBy]
       ,[User].[User Security ID]
FROM
       [CRONUS UK Ltd_$General Posting Setup$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [General Posting Setup]
LEFT JOIN
       [User] AS [User]
              ON
                     [General Posting Setup].[$systemModifiedBy] = [User].[User Security ID]
Dynamics 365 BC Table ReferenceTablesCompany TablesGGeneral Posting Setup

Leave a Reply

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