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

Show/hide an example select of all columns by name

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

Show/hide columns in Fixed Asset table

Field No.Field NameField CaptionClassTypeLengthSQL Column NameSQL DataType
1No. SearchNo.NormalCode20No_nvarchar(40)
2Description Primary Key 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

6FA Subclass Code SearchFA Subclass CodeNormalCode10FA Subclass Codenvarchar(20)
Key to join to the FA Subclass table.

Show/hide example query

7Global Dimension 1 Code SearchGlobal Dimension 1 CodeNormalCode20Global Dimension 1 Codenvarchar(40)
Key to join to the Dimension table.

Show/hide example query

8Global Dimension 2 Code SearchGlobal Dimension 2 CodeNormalCode20Global Dimension 2 Codenvarchar(40)
Key to join to the Dimension table.

Show/hide example query

9Location Code SearchLocation CodeNormalCode10Location Codenvarchar(20)
Key to join to the Location table.

Show/hide example query

10FA Location Code SearchFA Location CodeNormalCode10FA Location Codenvarchar(20)
Key to join to the FA Location table.

Show/hide example query

11Vendor No. SearchVendor No.NormalCode20Vendor No_nvarchar(40)
Key to join to the Vendor table.

Show/hide example query

12Main Asset/Component SearchMain Asset/ComponentNormalOption4Main Asset_Componentint
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

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

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

29FA Posting Group SearchFA Posting GroupNormalCode20FA Posting Groupnvarchar(40)
Key to join to the FA Posting Group table.

Show/hide example query

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

2000000003SystemModifiedAt SearchModified AtNormalDateTime8$systemModifiedAtdatetime
2000000004SystemModifiedBy SearchModified ByNormalGUID16$systemModifiedByuniqueidentifier

Show/hide tables related from Fixed Asset table

Leave a Reply

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