Fixed Asset

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

Table Type: Company

Table Name: Fixed Asset
Database Table Name: CRONUS UK Ltd_$Fixed Asset$437dbf0e-84ff-417a-965d-ed2bb9650972

Table Number: 5600

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 Fixed Asset can be queried.

Show/hide an example select of all columns

SELECT
   *
FROM
   [CRONUS UK Ltd_$Fixed Asset$437dbf0e-84ff-417a-965d-ed2bb9650972]

Show/hide an example select of all columns by name

SELECT
   [No_]
   ,[Description]
   ,[Search Description]
   ,[Description 2]
   ,[FA Class Code]
   ,[FA Subclass Code]
   ,[Global Dimension 1 Code]
   ,[Global Dimension 2 Code]
   ,[Location Code]
   ,[FA Location Code]
   ,[Vendor No_]
   ,[Main Asset_Component]
   ,[Component of Main Asset]
   ,[Budgeted Asset]
   ,[Warranty Date]
   ,[Responsible Employee]
   ,[Serial No_]
   ,[Last Date Modified]
   ,[Blocked]
   ,[Picture]
   ,[Maintenance Vendor No_]
   ,[Under Maintenance]
   ,[Next Service Date]
   ,[Inactive]
   ,[No_ Series]
   ,[FA Posting Group]
   ,[Image]
   ,[$systemId]
   ,[$systemCreatedAt]
   ,[$systemCreatedBy]
   ,[$systemModifiedAt]
   ,[$systemModifiedBy]
FROM
   [CRONUS UK Ltd_$Fixed Asset$437dbf0e-84ff-417a-965d-ed2bb9650972]

Show/hide an example select of all columns including those from all joined tables

SELECT
   *
FROM
   [CRONUS UK Ltd_$Fixed Asset$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Fixed Asset]
LEFT JOIN
   [CRONUS UK Ltd_$FA Class$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [FA Class]
      ON
         [Fixed Asset].[FA Class Code] = [FA Class].[Code]
LEFT JOIN
   [CRONUS UK Ltd_$FA Subclass$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [FA Subclass]
      ON
         [Fixed Asset].[FA Subclass Code] = [FA Subclass].[Code]
LEFT JOIN
   [CRONUS UK Ltd_$Dimension$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Dimension]
      ON
         [Fixed Asset].[Global Dimension 1 Code] = [Dimension].[Code]
LEFT JOIN
   [CRONUS UK Ltd_$Dimension$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Dimension]
      ON
         [Fixed Asset].[Global Dimension 2 Code] = [Dimension].[Code]
LEFT JOIN
   [CRONUS UK Ltd_$Location$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Location]
      ON
         [Fixed Asset].[Location Code] = [Location].[Code]
LEFT JOIN
   [CRONUS UK Ltd_$FA Location$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [FA Location]
      ON
         [Fixed Asset].[FA Location Code] = [FA Location].[Code]
LEFT JOIN
   [CRONUS UK Ltd_$Fixed Asset$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Fixed Asset]
      ON
         [Fixed Asset].[Component of Main Asset] = [Fixed Asset].[No_]
LEFT JOIN
   [CRONUS UK Ltd_$Employee$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Employee]
      ON
         [Fixed Asset].[Responsible Employee] = [Employee].[No_]
LEFT JOIN
   [CRONUS UK Ltd_$FA Posting Group$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [FA Posting Group]
      ON
         [Fixed Asset].[FA Posting Group] = [FA Posting Group].[Code]
LEFT JOIN
   [User] AS [User]
      ON
         [Fixed Asset].[SystemCreatedBy] = [User].[User Security ID]
LEFT JOIN
   [User] AS [User]
      ON
         [Fixed Asset].[SystemModifiedBy] = [User].[User Security ID]

Show/hide columns in Fixed Asset table

Field No.Field NameField CaptionClassTypeLengthSQL Column NameSQL DataType
1No. Primary Key SearchNo.NormalCode20No_nvarchar(40)
2Description SearchDescriptionNormalText100Descriptionnvarchar(200)
3Search Description SearchSearch DescriptionNormalCode100Search Descriptionnvarchar(200)
4Description 2 SearchDescription 2NormalText50Description 2nvarchar(100)
5FA Class Code SearchFA Class CodeNormalCode10FA Class Codenvarchar(20)
Key to join to the FA Class table.

Show/hide example query

SELECT
       [Fixed Asset].[FA Class Code]
       ,[FA Class].[Code]
FROM
       [CRONUS UK Ltd_$Fixed Asset$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Fixed Asset]
LEFT JOIN
       [CRONUS UK Ltd_$FA Class$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [FA Class]
              ON
                     [Fixed Asset].[FA Class Code] = [FA Class].[Code]
6FA Subclass Code SearchFA Subclass CodeNormalCode10FA Subclass Codenvarchar(20)
Key to join to the FA Subclass table.

Show/hide example query

SELECT
       [Fixed Asset].[FA Subclass Code]
       ,[FA Subclass].[Code]
FROM
       [CRONUS UK Ltd_$Fixed Asset$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Fixed Asset]
LEFT JOIN
       [CRONUS UK Ltd_$FA Subclass$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [FA Subclass]
              ON
                     [Fixed Asset].[FA Subclass Code] = [FA Subclass].[Code]
7Global Dimension 1 Code SearchGlobal Dimension 1 CodeNormalCode20Global Dimension 1 Codenvarchar(40)
Key to join to the Dimension table.

Show/hide example query

SELECT
       [Fixed Asset].[Global Dimension 1 Code]
       ,[Dimension].[Code]
FROM
       [CRONUS UK Ltd_$Fixed Asset$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Fixed Asset]
LEFT JOIN
       [CRONUS UK Ltd_$Dimension$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Dimension]
              ON
                     [Fixed Asset].[Global Dimension 1 Code] = [Dimension].[Code]
8Global Dimension 2 Code SearchGlobal Dimension 2 CodeNormalCode20Global Dimension 2 Codenvarchar(40)
Key to join to the Dimension table.

Show/hide example query

SELECT
       [Fixed Asset].[Global Dimension 2 Code]
       ,[Dimension].[Code]
FROM
       [CRONUS UK Ltd_$Fixed Asset$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Fixed Asset]
LEFT JOIN
       [CRONUS UK Ltd_$Dimension$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Dimension]
              ON
                     [Fixed Asset].[Global Dimension 2 Code] = [Dimension].[Code]
9Location Code SearchLocation CodeNormalCode10Location Codenvarchar(20)
Key to join to the Location table.

Show/hide example query

SELECT
       [Fixed Asset].[Location Code]
       ,[Location].[Code]
FROM
       [CRONUS UK Ltd_$Fixed Asset$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Fixed Asset]
LEFT JOIN
       [CRONUS UK Ltd_$Location$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Location]
              ON
                     [Fixed Asset].[Location Code] = [Location].[Code]
10FA Location Code SearchFA Location CodeNormalCode10FA Location Codenvarchar(20)
Key to join to the FA Location table.

Show/hide example query

SELECT
       [Fixed Asset].[FA Location Code]
       ,[FA Location].[Code]
FROM
       [CRONUS UK Ltd_$Fixed Asset$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Fixed Asset]
LEFT JOIN
       [CRONUS UK Ltd_$FA Location$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [FA Location]
              ON
                     [Fixed Asset].[FA Location Code] = [FA Location].[Code]
11Vendor No. SearchVendor No.NormalCode20Vendor No_nvarchar(40)
Key to join to the Vendor table.

Show/hide example query

SELECT
       [Fixed Asset].[Vendor No_]
       ,[Vendor].[No_]
FROM
       [CRONUS UK Ltd_$Fixed Asset$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Fixed Asset]
LEFT JOIN
       [CRONUS UK Ltd_$Vendor$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Vendor]
              ON
                     [Fixed Asset].[Vendor No_] = [Vendor].[No_]
12Main Asset/Component SearchMain Asset/ComponentNormalOption4Main Asset_Componentint
Available options are:
  • ” “
  • “Main Asset”
  • “Component”
13Component of Main Asset SearchComponent of Main AssetNormalCode20Component of Main Assetnvarchar(40)
14Budgeted Asset SearchBudgeted AssetNormalBoolean4Budgeted Assettinyint
15Warranty Date SearchWarranty DateNormalDate4Warranty Datedatetime
16Responsible Employee SearchResponsible EmployeeNormalCode20Responsible Employeenvarchar(40)
Key to join to the Employee table.

Show/hide example query

SELECT
       [Fixed Asset].[Responsible Employee]
       ,[Employee].[No_]
FROM
       [CRONUS UK Ltd_$Fixed Asset$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Fixed Asset]
LEFT JOIN
       [CRONUS UK Ltd_$Employee$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Employee]
              ON
                     [Fixed Asset].[Responsible Employee] = [Employee].[No_]
17Serial No. SearchSerial No.NormalText50Serial No_nvarchar(100)
18Last Date Modified SearchLast Date ModifiedNormalDate4Last Date Modifieddatetime
19Insured SearchInsuredFlowFieldBoolean4
20Comment SearchCommentFlowFieldBoolean4
21Blocked SearchBlockedNormalBoolean4Blockedtinyint
22Picture SearchPictureNormalBLOB8Pictureimage
23Maintenance Vendor No. SearchMaintenance Vendor No.NormalCode20Maintenance Vendor No_nvarchar(40)
Key to join to the Vendor table.

Show/hide example query

SELECT
       [Fixed Asset].[Maintenance Vendor No_]
       ,[Vendor].[No_]
FROM
       [CRONUS UK Ltd_$Fixed Asset$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Fixed Asset]
LEFT JOIN
       [CRONUS UK Ltd_$Vendor$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Vendor]
              ON
                     [Fixed Asset].[Maintenance Vendor No_] = [Vendor].[No_]
24Under Maintenance SearchUnder MaintenanceNormalBoolean4Under Maintenancetinyint
25Next Service Date SearchNext Service DateNormalDate4Next Service Datedatetime
26Inactive SearchInactiveNormalBoolean4Inactivetinyint
27FA Posting Date Filter SearchFA Posting Date FilterFlowFilterDate4
28No. Series SearchNo. SeriesNormalCode20No_ Seriesnvarchar(40)
Key to join to the No. Series table.

Show/hide example query

SELECT
       [Fixed Asset].[No_ Series]
       ,[No. Series].[Code]
FROM
       [CRONUS UK Ltd_$Fixed Asset$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Fixed Asset]
LEFT JOIN
       [CRONUS UK Ltd_$No_ Series$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [No. Series]
              ON
                     [Fixed Asset].[No_ Series] = [No. Series].[Code]
29FA Posting Group SearchFA Posting GroupNormalCode20FA Posting Groupnvarchar(40)
Key to join to the FA Posting Group table.

Show/hide example query

SELECT
       [Fixed Asset].[FA Posting Group]
       ,[FA Posting Group].[Code]
FROM
       [CRONUS UK Ltd_$Fixed Asset$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Fixed Asset]
LEFT JOIN
       [CRONUS UK Ltd_$FA Posting Group$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [FA Posting Group]
              ON
                     [Fixed Asset].[FA Posting Group] = [FA Posting Group].[Code]
30Acquired SearchAcquiredFlowFieldBoolean4
140Image SearchImageNormalMedia16Imageuniqueidentifier
10001Vehicle Licence Plate SearchVehicle License PlateNormalCode10
10002Vehicle Year SearchVehicle YearNormalInteger4
10004SAT Federal Autotransport SearchSAT Federal AutotransportNormalCode10
10005SAT Trailer Type SearchSAT Trailer TypeNormalCode10
10006SCT Permission Type SearchSCT Permission TypeNormalCode10
10007SCT Permission Number SearchSCT Permission NumberNormalCode20
10008SCT Permission No. SearchSCT Permission No.NormalText50
27000SAT Classification Code SearchSAT Classification CodeNormalCode10
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
       [Fixed Asset].[$systemCreatedBy]
       ,[User].[User Security ID]
FROM
       [CRONUS UK Ltd_$Fixed Asset$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Fixed Asset]
LEFT JOIN
       [User] AS [User]
              ON
                     [Fixed Asset].[$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
       [Fixed Asset].[$systemModifiedBy]
       ,[User].[User Security ID]
FROM
       [CRONUS UK Ltd_$Fixed Asset$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Fixed Asset]
LEFT JOIN
       [User] AS [User]
              ON
                     [Fixed Asset].[$systemModifiedBy] = [User].[User Security ID]

Show/hide tables related from Fixed Asset table

Leave a Reply

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