Maintenance Ledger Entry

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

Table Type: Company

Table Name: Maintenance Ledger Entry
Database Table Name: CRONUS UK Ltd_$Maintenance Ledger Entry$437dbf0e-84ff-417a-965d-ed2bb9650972

Table Number: 5625

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 Maintenance Ledger Entry 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 Maintenance Ledger Entry table

Field No.Field NameField CaptionClassTypeLengthSQL Column NameSQL DataType
1Entry No. SearchEntry No.NormalInteger4Entry No_int
2G/L Entry No. Primary Key SearchG/L Entry No.NormalInteger4G_L Entry No_int
3FA No. SearchFA No.NormalCode20FA No_nvarchar(40)
Key to join to the Fixed Asset table.

Show/hide example query

4FA Posting Date SearchFA Posting DateNormalDate4FA Posting Datedatetime
5Posting Date SearchPosting DateNormalDate4Posting Datedatetime
6Document Type SearchDocument TypeNormalOption4Document Typeint
Available options are:
  • ” “
  • “Payment”
  • “Invoice”
  • “Credit Memo”
  • “Finance Charge Memo”
  • “Reminder”
  • “Refund”
7Document Date SearchDocument DateNormalDate4Document Datedatetime
8Document No. SearchDocument No.NormalCode20Document No_nvarchar(40)
9External Document No. SearchExternal Document No.NormalCode35External Document No_nvarchar(70)
10Description SearchDescriptionNormalText100Descriptionnvarchar(200)
12Amount SearchAmountNormalDecimal12Amountdecimal(38,38)
13Debit Amount SearchDebit AmountNormalDecimal12Debit Amountdecimal(38,38)
14Credit Amount SearchCredit AmountNormalDecimal12Credit Amountdecimal(38,38)
15Quantity SearchQuantityNormalDecimal12Quantitydecimal(38,38)
16FA No./Budgeted FA No. SearchFA No./Budgeted FA No.NormalCode20FA No__Budgeted FA No_nvarchar(40)
17FA Subclass Code SearchFA Subclass CodeNormalCode10FA Subclass Codenvarchar(20)
Key to join to the FA Subclass table.

Show/hide example query

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

Show/hide example query

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

Show/hide example query

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

Show/hide example query

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

Show/hide example query

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

Show/hide example query

24User ID SearchUser IDNormalCode50User IDnvarchar(100)
25Journal Batch Name SearchJournal Batch NameNormalCode10Journal Batch Namenvarchar(20)
26Source Code SearchSource CodeNormalCode10Source Codenvarchar(20)
Key to join to the Source Code table.

Show/hide example query

27Reason Code SearchReason CodeNormalCode10Reason Codenvarchar(20)
Key to join to the Reason Code table.

Show/hide example query

28Transaction No. SearchTransaction No.NormalInteger4Transaction No_int
29Bal. Account Type SearchBal. Account TypeNormalOption4Bal_ Account Typeint
Available options are:
  • “G/L Account”
  • “Customer”
  • “Vendor”
  • “Bank Account”
  • “Fixed Asset”
  • “IC Partner”
  • “Employee”
  • “Allocation Account”
30Bal. Account No. SearchBal. Account No.NormalCode20Bal_ Account No_nvarchar(40)
31VAT Amount SearchTax AmountNormalDecimal12VAT Amountdecimal(38,38)
32Gen. Posting Type SearchGen. Posting TypeNormalOption4Gen_ Posting Typeint
Available options are:
  • ” “
  • “Purchase”
  • “Sale”
  • “Settlement”
33Gen. Bus. Posting Group SearchGen. Bus. Posting GroupNormalCode20Gen_ Bus_ Posting Groupnvarchar(40)
Key to join to the Gen. Business Posting Group table.

Show/hide example query

34Gen. Prod. Posting Group SearchGen. Prod. Posting GroupNormalCode20Gen_ Prod_ Posting Groupnvarchar(40)
Key to join to the Gen. Product Posting Group table.

Show/hide example query

35FA Class Code SearchFA Class CodeNormalCode10FA Class Codenvarchar(20)
Key to join to the FA Class table.

Show/hide example query

36Depreciation Book Code SearchDepreciation Book CodeNormalCode10Depreciation Book Codenvarchar(20)
Key to join to the Depreciation Book table.

Show/hide example query

37FA Exchange Rate SearchFA Exchange RateNormalDecimal12FA Exchange Ratedecimal(38,38)
38Amount (LCY) SearchAmount ($)NormalDecimal12Amount (LCY)decimal(38,38)
39Maintenance Code SearchMaintenance CodeNormalCode10Maintenance Codenvarchar(20)
Key to join to the Maintenance table.

Show/hide example query

40Correction SearchCorrectionNormalBoolean4Correctiontinyint
41Index Entry SearchIndex EntryNormalBoolean4Index Entrytinyint
42Automatic Entry SearchAutomatic EntryNormalBoolean4Automatic Entrytinyint
43No. Series SearchNo. SeriesNormalCode20No_ Seriesnvarchar(40)
Key to join to the No. Series table.

Show/hide example query

44Tax Area Code SearchTax Area CodeNormalCode20Tax Area Codenvarchar(40)
Key to join to the Tax Area table.

Show/hide example query

45Tax Liable SearchTax LiableNormalBoolean4Tax Liabletinyint
46Tax Group Code SearchTax Group CodeNormalCode20Tax Group Codenvarchar(40)
Key to join to the Tax Group table.

Show/hide example query

47Use Tax SearchUse TaxNormalBoolean4Use Taxtinyint
48VAT Bus. Posting Group SearchVAT Bus. Posting GroupNormalCode20VAT Bus_ Posting Groupnvarchar(40)
Key to join to the VAT Business Posting Group table.

Show/hide example query

49VAT Prod. Posting Group SearchVAT Prod. Posting GroupNormalCode20VAT Prod_ Posting Groupnvarchar(40)
Key to join to the VAT Product Posting Group table.

Show/hide example query

50Reversed SearchReversedNormalBoolean4Reversedtinyint
51Reversed by Entry No. SearchReversed by Entry No.NormalInteger4Reversed by Entry No_int
52Reversed Entry No. SearchReversed Entry No.NormalInteger4Reversed Entry No_int
480Dimension Set ID SearchDimension Set IDNormalInteger4Dimension Set IDint
Key to join to the Dimension Set Entry table.

Show/hide example query

481Shortcut Dimension 3 Code SearchShortcut Dimension 3 CodeFlowFieldCode20
Key to join to the Dimension table.

Show/hide example query

482Shortcut Dimension 4 Code SearchShortcut Dimension 4 CodeFlowFieldCode20
Key to join to the Dimension table.

Show/hide example query

483Shortcut Dimension 5 Code SearchShortcut Dimension 5 CodeFlowFieldCode20
Key to join to the Dimension table.

Show/hide example query

484Shortcut Dimension 6 Code SearchShortcut Dimension 6 CodeFlowFieldCode20
Key to join to the Dimension table.

Show/hide example query

485Shortcut Dimension 7 Code SearchShortcut Dimension 7 CodeFlowFieldCode20
Key to join to the Dimension table.

Show/hide example query

486Shortcut Dimension 8 Code SearchShortcut Dimension 8 CodeFlowFieldCode20
Key to join to the Dimension table.

Show/hide example query

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 Maintenance Ledger Entry table

Leave a Reply

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