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 an example select of all columns including those from all joined tables

SELECT
   *
FROM
   [CRONUS UK Ltd_$Native - API Tax Setup$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Native - API Tax Setup]
LEFT JOIN
   [CRONUS UK Ltd_$Post Code$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Post Code]
      ON
         [Native - API Tax Setup].[City] = [Post Code].[City]
LEFT JOIN
   [User] AS [User]
      ON
         [Native - API Tax Setup].[SystemCreatedBy] = [User].[User Security ID]
LEFT JOIN
   [User] AS [User]
      ON
         [Native - API Tax Setup].[SystemModifiedBy] = [User].[User Security ID]

Show/hide columns in Native – API Tax Setup table

Field No.Field NameField CaptionClassTypeLengthSQL Column NameSQL DataType
1Code SearchCodeNormalCode20Codenvarchar(40)
2Description SearchDescriptionNormalText100Descriptionnvarchar(200)
3Total Tax Percentage SearchTotal Tax PercentageNormalDecimal12Total Tax Percentagedecimal(38,38)
10Last Modified Date Time SearchLast Modified Date TimeNormalDateTime8Last Modified Date Timedatetime
20VAT Percentage SearchVAT PercentageNormalDecimal12VAT Percentagedecimal(38,38)
21VAT Regulation Reference ID SearchVAT Regulation Reference IDNormalGUID16VAT Regulation Reference IDuniqueidentifier
22VAT Regulation Description SearchVAT Regulation DescriptionNormalText250VAT Regulation Descriptionnvarchar(500)
30City SearchCityNormalText30Citynvarchar(60)
Key to join to the Post Code table.

Show/hide example query

SELECT
       [Native - API Tax Setup].[City]
       ,[Post Code].[City]
FROM
       [CRONUS UK Ltd_$Native - API Tax Setup$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Native - API Tax Setup]
LEFT JOIN
       [CRONUS UK Ltd_$Post Code$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Post Code]
              ON
                     [Native - API Tax Setup].[City] = [Post Code].[City]
31City Rate SearchCity RateNormalDecimal12City Ratedecimal(38,38)
32State SearchStateNormalCode2Statenvarchar(4)
33State Rate SearchState RateNormalDecimal12State Ratedecimal(38,38)
40GST or HST Code SearchGST or HST CodeNormalCode10GST or HST Codenvarchar(20)
41GST or HST Description SearchGST or HST DescriptionNormalText50GST or HST Descriptionnvarchar(100)
42GST or HST Rate SearchGST or HST RateNormalDecimal12GST or HST Ratedecimal(38,38)
45PST Code SearchPST CodeNormalCode10PST Codenvarchar(20)
46PST Description SearchPST DescriptionNormalText50PST Descriptionnvarchar(100)
47PST Rate SearchPST RateNormalDecimal12PST Ratedecimal(38,38)
100Default SearchDefaultNormalBoolean4Defaulttinyint
8000Id Primary Key SearchIdNormalGUID16Iduniqueidentifier
9600Type SearchTypeNormalOption4Typeint
Available options are:
  • “Sales Tax”
  • “VAT”
10010Country/Region SearchCountry/RegionNormalOption4
2000000000$systemId SearchSystem IDNormalGUID16$systemIduniqueidentifier
2000000001SystemCreatedAt SearchCreated AtNormalDateTime8$systemCreatedAtdatetime
2000000002SystemCreatedBy SearchCreated ByNormalGUID16$systemCreatedByuniqueidentifier
Key to join to the User table.

Show/hide example query

SELECT
       [Native - API Tax Setup].[$systemCreatedBy]
       ,[User].[User Security ID]
FROM
       [CRONUS UK Ltd_$Native - API Tax Setup$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Native - API Tax Setup]
LEFT JOIN
       [User] AS [User]
              ON
                     [Native - API Tax Setup].[$systemCreatedBy] = [User].[User Security ID]
2000000003SystemModifiedAt SearchModified AtNormalDateTime8$systemModifiedAtdatetime
2000000004SystemModifiedBy SearchModified ByNormalGUID16$systemModifiedByuniqueidentifier
Key to join to the User table.

Show/hide example query

SELECT
       [Native - API Tax Setup].[$systemModifiedBy]
       ,[User].[User Security ID]
FROM
       [CRONUS UK Ltd_$Native - API Tax Setup$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Native - API Tax Setup]
LEFT JOIN
       [User] AS [User]
              ON
                     [Native - API Tax Setup].[$systemModifiedBy] = [User].[User Security ID]

Leave a Reply

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