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
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 ID | Column Name | Data Type |
|---|---|---|
| 1 | timestamp  | timestamp |
| 2 | Gen_ Bus_ Posting Group  | nvarchar(40) |
| 3 | Gen_ Prod_ Posting Group | nvarchar(40) |
| 4 | Sales Account | nvarchar(40) |
| 5 | Sales Line Disc_ Account | nvarchar(40) |
| 6 | Sales Inv_ Disc_ Account | nvarchar(40) |
| 7 | Sales Pmt_ Disc_ Debit Acc_ | nvarchar(40) |
| 8 | Purch_ Account | nvarchar(40) |
| 9 | Purch_ Line Disc_ Account | nvarchar(40) |
| 10 | Purch_ Inv_ Disc_ Account | nvarchar(40) |
| 11 | Purch_ Pmt_ Disc_ Credit Acc_ | nvarchar(40) |
| 12 | COGS Account | nvarchar(40) |
| 13 | Inventory Adjmt_ Account | nvarchar(40) |
| 14 | Sales Credit Memo Account | nvarchar(40) |
| 15 | Purch_ Credit Memo Account | nvarchar(40) |
| 16 | Sales Pmt_ Disc_ Credit Acc_ | nvarchar(40) |
| 17 | Purch_ Pmt_ Disc_ Debit Acc_ | nvarchar(40) |
| 18 | Sales Pmt_ Tol_ Debit Acc_ | nvarchar(40) |
| 19 | Sales Pmt_ Tol_ Credit Acc_ | nvarchar(40) |
| 20 | Purch_ Pmt_ Tol_ Debit Acc_ | nvarchar(40) |
| 21 | Purch_ Pmt_ Tol_ Credit Acc_ | nvarchar(40) |
| 22 | Sales Prepayments Account | nvarchar(40) |
| 23 | Purch_ Prepayments Account | nvarchar(40) |
| 24 | Description | nvarchar(200) |
| 25 | View All Accounts on Lookup | tinyint |
| 26 | Blocked | tinyint |
| 27 | Purch_ FA Disc_ Account | nvarchar(40) |
| 28 | Invt_ Accrual Acc_ (Interim) | nvarchar(40) |
| 29 | COGS Account (Interim) | nvarchar(40) |
| 30 | Direct Cost Applied Account | nvarchar(40) |
| 31 | Overhead Applied Account | nvarchar(40) |
| 32 | Purchase Variance Account | nvarchar(40) |
| 33 | $systemId | uniqueidentifier |
| 34 | $systemCreatedAt | datetime |
| 35 | $systemCreatedBy | uniqueidentifier |
| 36 | $systemModifiedAt | datetime |
| 37 | $systemModifiedBy | uniqueidentifier |