G/L Entry

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

Table Type: Company

Table Name: G/L Entry
Database Table Name: CRONUS UK Ltd_$G_L Entry$437dbf0e-84ff-417a-965d-ed2bb9650972

Table Number: 17

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 G/L 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 G/L Entry table

Field No.Field NameField CaptionClassTypeLengthSQL Column NameSQL DataType
1Entry No. SearchEntry No.NormalInteger4Entry No_int
3G/L Account No. Primary Key SearchG/L Account No.NormalCode20G_L Account No_nvarchar(40)
4Posting Date SearchPosting DateNormalDate4Posting Datedatetime
5Document Type SearchDocument TypeNormalOption4Document Typeint
Available options are:
  • ” “
  • “Payment”
  • “Invoice”
  • “Credit Memo”
  • “Finance Charge Memo”
  • “Reminder”
  • “Refund”
6Document No. SearchDocument No.NormalCode20Document No_nvarchar(40)
7Description SearchDescriptionNormalText100Descriptionnvarchar(200)
10Bal. Account No. SearchBal. Account No.NormalCode20Bal_ Account No_nvarchar(40)
17Amount SearchAmountNormalDecimal12Amountdecimal(38,38)
23Global Dimension 1 Code SearchGlobal Dimension 1 CodeNormalCode20Global Dimension 1 Codenvarchar(40)
Key to join to the Dimension table.

Show/hide example query

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

Show/hide example query

27User ID SearchUser IDNormalCode50User IDnvarchar(100)
28Source Code SearchSource CodeNormalCode10Source Codenvarchar(20)
Key to join to the Source Code table.

Show/hide example query

29System-Created Entry SearchSystem-Created EntryNormalBoolean4
30Prior-Year Entry SearchPrior-Year EntryNormalBoolean4Prior-Year Entrytinyint
41Job No. SearchJob No.NormalCode20Job No_nvarchar(40)
Key to join to the Job table.

Show/hide example query

42Quantity SearchQuantityNormalDecimal12Quantitydecimal(38,38)
43VAT Amount SearchTax AmountNormalDecimal12VAT Amountdecimal(38,38)
45Business Unit Code SearchBusiness Unit CodeNormalCode20Business Unit Codenvarchar(40)
Key to join to the Business Unit table.

Show/hide example query

46Journal Batch Name SearchJournal Batch NameNormalCode10Journal Batch Namenvarchar(20)
47Reason Code SearchReason CodeNormalCode10Reason Codenvarchar(20)
Key to join to the Reason Code table.

Show/hide example query

48Gen. Posting Type SearchGen. Posting TypeNormalOption4Gen_ Posting Typeint
Available options are:
  • ” “
  • “Purchase”
  • “Sale”
  • “Settlement”
49Gen. 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

50Gen. 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

51Bal. Account Type SearchBal. Account TypeNormalOption4Bal_ Account Typeint
Available options are:
  • “G/L Account”
  • “Customer”
  • “Vendor”
  • “Bank Account”
  • “Fixed Asset”
  • “IC Partner”
  • “Employee”
  • “Allocation Account”
52Transaction No. SearchTransaction No.NormalInteger4Transaction No_int
53Debit Amount SearchDebit AmountNormalDecimal12Debit Amountdecimal(38,38)
54Credit Amount SearchCredit AmountNormalDecimal12Credit Amountdecimal(38,38)
55Document Date SearchDocument DateNormalDate4Document Datedatetime
56External Document No. SearchExternal Document No.NormalCode35External Document No_nvarchar(70)
57Source Type SearchSource TypeNormalOption4Source Typeint
Available options are:
  • ” “
  • “Customer”
  • “Vendor”
  • “Bank Account”
  • “Fixed Asset”
  • “IC Partner”
  • “Employee”
58Source No. SearchSource No.NormalCode20Source No_nvarchar(40)
59No. Series SearchNo. SeriesNormalCode20No_ Seriesnvarchar(40)
Key to join to the No. Series table.

Show/hide example query

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

Show/hide example query

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

Show/hide example query

63Use Tax SearchUse TaxNormalBoolean4Use Taxtinyint
64VAT 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

65VAT 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

68Additional-Currency Amount SearchAdditional-Currency AmountNormalDecimal12Additional-Currency Amountdecimal(38,38)
69Add.-Currency Debit Amount SearchAdd.-Currency Debit AmountNormalDecimal12Add_-Currency Debit Amountdecimal(38,38)
70Add.-Currency Credit Amount SearchAdd.-Currency Credit AmountNormalDecimal12Add_-Currency Credit Amountdecimal(38,38)
71Close Income Statement Dim. ID SearchClose Income Statement Dim. IDNormalInteger4Close Income Statement Dim_ IDint
72IC Partner Code SearchIC Partner CodeNormalCode20IC Partner Codenvarchar(40)
Key to join to the IC Partner table.

Show/hide example query

73Reversed SearchReversedNormalBoolean4Reversedtinyint
74Reversed by Entry No. SearchReversed by Entry No.NormalInteger4Reversed by Entry No_int
75Reversed Entry No. SearchReversed Entry No.NormalInteger4Reversed Entry No_int
76G/L Account Name SearchG/L Account NameFlowFieldText100
78Journal Templ. Name SearchJournal Template NameNormalCode10Journal Templ_ Namenvarchar(20)
79VAT Reporting Date SearchTax DateNormalDate4VAT Reporting Datedatetime
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

495Last Dim. Correction Entry No. SearchLast Dim. Correction Entry No.NormalInteger4Last Dim_ Correction Entry No_int
496Last Dim. Correction Node SearchLast Dim. Correction NodeNormalInteger4Last Dim_ Correction Nodeint
497Dimension Changes Count SearchCount of Dimension ChangesNormalInteger4Dimension Changes Countint
2678Allocation Account No. SearchAllocation Account No.NormalCode20Allocation Account No_nvarchar(40)
Key to join to the Allocation Account table.

Show/hide example query

5400Prod. Order No. SearchProd. Order No.NormalCode20Prod_ Order No_nvarchar(40)
5600FA Entry Type SearchFA Entry TypeNormalOption4FA Entry Typeint
Available options are:
  • ” “
  • “Fixed Asset”
  • “Maintenance”
5601FA Entry No. SearchFA Entry No.NormalInteger4FA Entry No_int
5618Comment SearchCommentNormalText250Commentnvarchar(500)
6200Non-Deductible VAT Amount SearchNon-Deductible Tax AmountNormalDecimal12Non-Deductible VAT Amountdecimal(38,38)
6201Non-Deductible VAT Amount ACY SearchNon-Deductible Tax Amount ACYNormalDecimal12Non-Deductible VAT Amount ACYdecimal(38,38)
8001Account Id SearchAccount IdFlowFieldGUID16
Key to join to the G/L Account table.

Show/hide example query

8005Last Modified DateTime SearchLast Modified DateTimeNormalDateTime8Last Modified DateTimedatetime
10018STE Transaction ID SearchSTE Transaction IDNormalText20
10019GST/HST SearchGST/HSTNormalOption4
22212Reviewed SearchReviewedFlowFieldBoolean4
22213Reviewed By SearchReviewed ByFlowFieldCode50
22214Reviewed Date SearchReviewed DateFlowFieldDateTime8
22215Reviewed Identifier SearchReviewed IdentifierFlowFieldInteger4
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 G/L Entry table

Leave a Reply

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