Native – API Tax Setup

Easily find this page again using the shortlink: https://bct.azrcrv.co.uk/2850

Table Type: Company

Table Name: Native – API Tax Setup
Database Table Name: CRONUS UK Ltd_$Native – API Tax Setup$437dbf0e-84ff-417a-965d-ed2bb9650972

Table Number: 2850

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 IDColumn NameData Type
1timestamp Searchtimestamp
2Id Primary Key Searchuniqueidentifier
3Code Searchnvarchar(40)
4Description Searchnvarchar(200)
5Total Tax Percentage Searchdecimal(38,38)
6Last Modified Date Time Searchdatetime
7VAT Percentage Searchdecimal(38,38)
8VAT Regulation Reference ID Searchuniqueidentifier
9VAT Regulation Description Searchnvarchar(500)
10City Searchnvarchar(60)
11City Rate Searchdecimal(38,38)
12State Searchnvarchar(4)
13State Rate Searchdecimal(38,38)
14GST or HST Code Searchnvarchar(20)
15GST or HST Description Searchnvarchar(100)
16GST or HST Rate Searchdecimal(38,38)
17PST Code Searchnvarchar(20)
18PST Description Searchnvarchar(100)
19PST Rate Searchdecimal(38,38)
20Default Searchtinyint
21Type Searchint
22$systemId Searchuniqueidentifier
23$systemCreatedAt Searchdatetime
24$systemCreatedBy Searchuniqueidentifier
25$systemModifiedAt Searchdatetime
26$systemModifiedBy Searchuniqueidentifier

Leave a Reply

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