VAT Rate Change Setup

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

Table Number: 550

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 IDColumn NameData Type
1timestamp Searchtimestamp
2Primary Key Primary Key Searchnvarchar(20)
3Update Gen_ Prod_ Post_ Groups Searchint
4Update G_L Accounts Searchint
5Update Items Searchint
6Update Item Templates Searchint
7Update Item Charges Searchint
8Update Resources Searchint
9Update Gen_ Journal Lines Searchint
10Update Gen_ Journal Allocation Searchint
11Update Std_ Gen_ Jnl_ Lines Searchint
12Update Res_ Journal Lines Searchint
13Update Job Journal Lines Searchint
14Update Requisition Lines Searchint
15Update Std_ Item Jnl_ Lines Searchint
16Update Service Docs_ Searchint
17Update Serv_ Price Adj_ Detail Searchint
18Update Sales Documents Searchint
19Update Purchase Documents Searchint
20Update Production Orders Searchint
21Update Work Centers Searchint
22Update Machine Centers Searchint
23Update Reminders Searchint
24Update Finance Charge Memos Searchint
25VAT Rate Change Tool Completed Searchtinyint
26Ignore Status on Sales Docs_ Searchtinyint
27Ignore Status on Purch_ Docs_ Searchtinyint
28Perform Conversion Searchtinyint
29Item Filter Searchnvarchar(500)
30Account Filter Searchnvarchar(500)
31Resource Filter Searchnvarchar(500)
32Ignore Status on Service Docs_ Searchtinyint
33Update Unit Price For G_L Acc_ Searchtinyint
34Upd_ Unit Price For Item Chrg_ Searchtinyint
35Upd_ Unit Price For FA Searchtinyint
36$systemId Searchuniqueidentifier
37$systemCreatedAt Searchdatetime
38$systemCreatedBy Searchuniqueidentifier
39$systemModifiedAt Searchdatetime
40$systemModifiedBy Searchuniqueidentifier

Leave a Reply

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