General 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: 0

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

Column IDColumn NameData Type
1timestamp Searchtimestamp
2Gen_ Bus_ Posting Group Primary Key Searchnvarchar(40)
3Gen_ Prod_ Posting Group Primary Key Searchnvarchar(40)
4Sales Account Searchnvarchar(40)
5Sales Line Disc_ Account Searchnvarchar(40)
6Sales Inv_ Disc_ Account Searchnvarchar(40)
7Sales Pmt_ Disc_ Debit Acc_ Searchnvarchar(40)
8Purch_ Account Searchnvarchar(40)
9Purch_ Line Disc_ Account Searchnvarchar(40)
10Purch_ Inv_ Disc_ Account Searchnvarchar(40)
11Purch_ Pmt_ Disc_ Credit Acc_ Searchnvarchar(40)
12COGS Account Searchnvarchar(40)
13Inventory Adjmt_ Account Searchnvarchar(40)
14Sales Credit Memo Account Searchnvarchar(40)
15Purch_ Credit Memo Account Searchnvarchar(40)
16Sales Pmt_ Disc_ Credit Acc_ Searchnvarchar(40)
17Purch_ Pmt_ Disc_ Debit Acc_ Searchnvarchar(40)
18Sales Pmt_ Tol_ Debit Acc_ Searchnvarchar(40)
19Sales Pmt_ Tol_ Credit Acc_ Searchnvarchar(40)
20Purch_ Pmt_ Tol_ Debit Acc_ Searchnvarchar(40)
21Purch_ Pmt_ Tol_ Credit Acc_ Searchnvarchar(40)
22Sales Prepayments Account Searchnvarchar(40)
23Purch_ Prepayments Account Searchnvarchar(40)
24Description Searchnvarchar(200)
25View All Accounts on Lookup Searchtinyint
26Blocked Searchtinyint
27Purch_ FA Disc_ Account Searchnvarchar(40)
28Invt_ Accrual Acc_ (Interim) Searchnvarchar(40)
29COGS Account (Interim) Searchnvarchar(40)
30Direct Cost Applied Account Searchnvarchar(40)
31Overhead Applied Account Searchnvarchar(40)
32Purchase Variance Account Searchnvarchar(40)
33$systemId Searchuniqueidentifier
34$systemCreatedAt Searchdatetime
35$systemCreatedBy Searchuniqueidentifier
36$systemModifiedAt Searchdatetime
37$systemModifiedBy Searchuniqueidentifier

Leave a Reply

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