Native – API Tax Setup

Table Type: Company

Table Name: Native – API Tax Setup
Database Table Name: CRONUS UK Ltd_$Native – API Tax 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 Native – API Tax Setup can be queried.

Show/hide an example select of all columns

SELECT

   *

FROM

   [CRONUS UK Ltd_$Native - API Tax Setup$437dbf0e-84ff-417a-965d-ed2bb9650972]

Show/hide an example select of all columns by name

SELECT



FROM

   [CRONUS UK Ltd_$Native - API Tax Setup$437dbf0e-84ff-417a-965d-ed2bb9650972]

Show/hide columns in Native – API Tax Setup table

Column ID	Column Name	Data Type
1	timestamp	timestamp
2	Id	uniqueidentifier
3	Code	nvarchar(40)
4	Description	nvarchar(200)
5	Total Tax Percentage	decimal(38,38)
6	Last Modified Date Time	datetime
7	VAT Percentage	decimal(38,38)
8	VAT Regulation Reference ID	uniqueidentifier
9	VAT Regulation Description	nvarchar(500)
10	City	nvarchar(60)
11	City Rate	decimal(38,38)
12	State	nvarchar(4)
13	State Rate	decimal(38,38)
14	GST or HST Code	nvarchar(20)
15	GST or HST Description	nvarchar(100)
16	GST or HST Rate	decimal(38,38)
17	PST Code	nvarchar(20)
18	PST Description	nvarchar(100)
19	PST Rate	decimal(38,38)
20	Default	tinyint
21	Type	int
22	$systemId	uniqueidentifier
23	$systemCreatedAt	datetime
24	$systemCreatedBy	uniqueidentifier
25	$systemModifiedAt	datetime
26	$systemModifiedBy	uniqueidentifier