Easily find this page again using the shortlink: https://bct.azrcrv.co.uk/550
Table Type: Company
Table Name: VAT Rate Change Setup
Database Table Name: CRONUS UK Ltd_$VAT Rate Change 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 VAT Rate Change Setup can be queried.
Show/hide an example select of all columns
SELECT
*
FROM
[CRONUS UK Ltd_$VAT Rate Change Setup$437dbf0e-84ff-417a-965d-ed2bb9650972]Show/hide an example select of all columns by name
SELECT
[timestamp]
,[Primary Key]
,[Update Gen_ Prod_ Post_ Groups]
,[Update G_L Accounts]
,[Update Items]
,[Update Item Templates]
,[Update Item Charges]
,[Update Resources]
,[Update Gen_ Journal Lines]
,[Update Gen_ Journal Allocation]
,[Update Std_ Gen_ Jnl_ Lines]
,[Update Res_ Journal Lines]
,[Update Job Journal Lines]
,[Update Requisition Lines]
,[Update Std_ Item Jnl_ Lines]
,[Update Service Docs_]
,[Update Serv_ Price Adj_ Detail]
,[Update Sales Documents]
,[Update Purchase Documents]
,[Update Production Orders]
,[Update Work Centers]
,[Update Machine Centers]
,[Update Reminders]
,[Update Finance Charge Memos]
,[VAT Rate Change Tool Completed]
,[Ignore Status on Sales Docs_]
,[Ignore Status on Purch_ Docs_]
,[Perform Conversion]
,[Item Filter]
,[Account Filter]
,[Resource Filter]
,[Ignore Status on Service Docs_]
,[Update Unit Price For G_L Acc_]
,[Upd_ Unit Price For Item Chrg_]
,[Upd_ Unit Price For FA]
,[$systemId]
,[$systemCreatedAt]
,[$systemCreatedBy]
,[$systemModifiedAt]
,[$systemModifiedBy]
FROM
[CRONUS UK Ltd_$VAT Rate Change Setup$437dbf0e-84ff-417a-965d-ed2bb9650972]Show/hide columns in VAT Rate Change Setup table
| Column ID | Column Name | Data Type |
|---|---|---|
| 1 | timestamp  | timestamp |
| 2 | Primary Key  | nvarchar(20) |
| 3 | Update Gen_ Prod_ Post_ Groups | int |
| 4 | Update G_L Accounts | int |
| 5 | Update Items | int |
| 6 | Update Item Templates | int |
| 7 | Update Item Charges | int |
| 8 | Update Resources | int |
| 9 | Update Gen_ Journal Lines | int |
| 10 | Update Gen_ Journal Allocation | int |
| 11 | Update Std_ Gen_ Jnl_ Lines | int |
| 12 | Update Res_ Journal Lines | int |
| 13 | Update Job Journal Lines | int |
| 14 | Update Requisition Lines | int |
| 15 | Update Std_ Item Jnl_ Lines | int |
| 16 | Update Service Docs_ | int |
| 17 | Update Serv_ Price Adj_ Detail | int |
| 18 | Update Sales Documents | int |
| 19 | Update Purchase Documents | int |
| 20 | Update Production Orders | int |
| 21 | Update Work Centers | int |
| 22 | Update Machine Centers | int |
| 23 | Update Reminders | int |
| 24 | Update Finance Charge Memos | int |
| 25 | VAT Rate Change Tool Completed | tinyint |
| 26 | Ignore Status on Sales Docs_ | tinyint |
| 27 | Ignore Status on Purch_ Docs_ | tinyint |
| 28 | Perform Conversion | tinyint |
| 29 | Item Filter | nvarchar(500) |
| 30 | Account Filter | nvarchar(500) |
| 31 | Resource Filter | nvarchar(500) |
| 32 | Ignore Status on Service Docs_ | tinyint |
| 33 | Update Unit Price For G_L Acc_ | tinyint |
| 34 | Upd_ Unit Price For Item Chrg_ | tinyint |
| 35 | Upd_ Unit Price For FA | tinyint |
| 36 | $systemId | uniqueidentifier |
| 37 | $systemCreatedAt | datetime |
| 38 | $systemCreatedBy | uniqueidentifier |
| 39 | $systemModifiedAt | datetime |
| 40 | $systemModifiedBy | uniqueidentifier |