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
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 Name | Field Caption | Class | Type | Length | SQL Column Name | SQL DataType |
---|---|---|---|---|---|---|---|
1 | Entry No. | Entry No. | Normal | Integer | 4 | Entry No_ | int |
3 | G/L Account No. | G/L Account No. | Normal | Code | 20 | G_L Account No_ | nvarchar(40) |
4 | Posting Date | Posting Date | Normal | Date | 4 | Posting Date | datetime |
5 | Document Type | Document Type | Normal | Option | 4 | Document Type | int |
Available options are:
| |||||||
6 | Document No. | Document No. | Normal | Code | 20 | Document No_ | nvarchar(40) |
7 | Description | Description | Normal | Text | 100 | Description | nvarchar(200) |
10 | Bal. Account No. | Bal. Account No. | Normal | Code | 20 | Bal_ Account No_ | nvarchar(40) |
17 | Amount | Amount | Normal | Decimal | 12 | Amount | decimal(38,38) |
23 | Global Dimension 1 Code | Global Dimension 1 Code | Normal | Code | 20 | Global Dimension 1 Code | nvarchar(40) |
Key to join to the Dimension table.Show/hide example query | |||||||
24 | Global Dimension 2 Code | Global Dimension 2 Code | Normal | Code | 20 | Global Dimension 2 Code | nvarchar(40) |
Key to join to the Dimension table.Show/hide example query | |||||||
27 | User ID | User ID | Normal | Code | 50 | User ID | nvarchar(100) |
28 | Source Code | Source Code | Normal | Code | 10 | Source Code | nvarchar(20) |
Key to join to the Source Code table.Show/hide example query | |||||||
29 | System-Created Entry | System-Created Entry | Normal | Boolean | 4 | ||
30 | Prior-Year Entry | Prior-Year Entry | Normal | Boolean | 4 | Prior-Year Entry | tinyint |
41 | Job No. | Job No. | Normal | Code | 20 | Job No_ | nvarchar(40) |
Key to join to the Job table.Show/hide example query | |||||||
42 | Quantity | Quantity | Normal | Decimal | 12 | Quantity | decimal(38,38) |
43 | VAT Amount | Tax Amount | Normal | Decimal | 12 | VAT Amount | decimal(38,38) |
45 | Business Unit Code | Business Unit Code | Normal | Code | 20 | Business Unit Code | nvarchar(40) |
Key to join to the Business Unit table.Show/hide example query | |||||||
46 | Journal Batch Name | Journal Batch Name | Normal | Code | 10 | Journal Batch Name | nvarchar(20) |
47 | Reason Code | Reason Code | Normal | Code | 10 | Reason Code | nvarchar(20) |
Key to join to the Reason Code table.Show/hide example query | |||||||
48 | Gen. Posting Type | Gen. Posting Type | Normal | Option | 4 | Gen_ Posting Type | int |
Available options are:
| |||||||
49 | Gen. Bus. Posting Group | Gen. Bus. Posting Group | Normal | Code | 20 | Gen_ Bus_ Posting Group | nvarchar(40) |
Key to join to the Gen. Business Posting Group table.Show/hide example query | |||||||
50 | Gen. Prod. Posting Group | Gen. Prod. Posting Group | Normal | Code | 20 | Gen_ Prod_ Posting Group | nvarchar(40) |
Key to join to the Gen. Product Posting Group table.Show/hide example query | |||||||
51 | Bal. Account Type | Bal. Account Type | Normal | Option | 4 | Bal_ Account Type | int |
Available options are:
| |||||||
52 | Transaction No. | Transaction No. | Normal | Integer | 4 | Transaction No_ | int |
53 | Debit Amount | Debit Amount | Normal | Decimal | 12 | Debit Amount | decimal(38,38) |
54 | Credit Amount | Credit Amount | Normal | Decimal | 12 | Credit Amount | decimal(38,38) |
55 | Document Date | Document Date | Normal | Date | 4 | Document Date | datetime |
56 | External Document No. | External Document No. | Normal | Code | 35 | External Document No_ | nvarchar(70) |
57 | Source Type | Source Type | Normal | Option | 4 | Source Type | int |
Available options are:
| |||||||
58 | Source No. | Source No. | Normal | Code | 20 | Source No_ | nvarchar(40) |
59 | No. Series | No. Series | Normal | Code | 20 | No_ Series | nvarchar(40) |
Key to join to the No. Series table.Show/hide example query | |||||||
60 | Tax Area Code | Tax Area Code | Normal | Code | 20 | Tax Area Code | nvarchar(40) |
Key to join to the Tax Area table.Show/hide example query | |||||||
61 | Tax Liable | Tax Liable | Normal | Boolean | 4 | Tax Liable | tinyint |
62 | Tax Group Code | Tax Group Code | Normal | Code | 20 | Tax Group Code | nvarchar(40) |
Key to join to the Tax Group table.Show/hide example query | |||||||
63 | Use Tax | Use Tax | Normal | Boolean | 4 | Use Tax | tinyint |
64 | VAT Bus. Posting Group | VAT Bus. Posting Group | Normal | Code | 20 | VAT Bus_ Posting Group | nvarchar(40) |
Key to join to the VAT Business Posting Group table.Show/hide example query | |||||||
65 | VAT Prod. Posting Group | VAT Prod. Posting Group | Normal | Code | 20 | VAT Prod_ Posting Group | nvarchar(40) |
Key to join to the VAT Product Posting Group table.Show/hide example query | |||||||
68 | Additional-Currency Amount | Additional-Currency Amount | Normal | Decimal | 12 | Additional-Currency Amount | decimal(38,38) |
69 | Add.-Currency Debit Amount | Add.-Currency Debit Amount | Normal | Decimal | 12 | Add_-Currency Debit Amount | decimal(38,38) |
70 | Add.-Currency Credit Amount | Add.-Currency Credit Amount | Normal | Decimal | 12 | Add_-Currency Credit Amount | decimal(38,38) |
71 | Close Income Statement Dim. ID | Close Income Statement Dim. ID | Normal | Integer | 4 | Close Income Statement Dim_ ID | int |
72 | IC Partner Code | IC Partner Code | Normal | Code | 20 | IC Partner Code | nvarchar(40) |
Key to join to the IC Partner table.Show/hide example query | |||||||
73 | Reversed | Reversed | Normal | Boolean | 4 | Reversed | tinyint |
74 | Reversed by Entry No. | Reversed by Entry No. | Normal | Integer | 4 | Reversed by Entry No_ | int |
75 | Reversed Entry No. | Reversed Entry No. | Normal | Integer | 4 | Reversed Entry No_ | int |
76 | G/L Account Name | G/L Account Name | FlowField | Text | 100 | ||
78 | Journal Templ. Name | Journal Template Name | Normal | Code | 10 | Journal Templ_ Name | nvarchar(20) |
79 | VAT Reporting Date | Tax Date | Normal | Date | 4 | VAT Reporting Date | datetime |
480 | Dimension Set ID | Dimension Set ID | Normal | Integer | 4 | Dimension Set ID | int |
Key to join to the Dimension Set Entry table.Show/hide example query | |||||||
481 | Shortcut Dimension 3 Code | Shortcut Dimension 3 Code | FlowField | Code | 20 | ||
Key to join to the Dimension table.Show/hide example query | |||||||
482 | Shortcut Dimension 4 Code | Shortcut Dimension 4 Code | FlowField | Code | 20 | ||
Key to join to the Dimension table.Show/hide example query | |||||||
483 | Shortcut Dimension 5 Code | Shortcut Dimension 5 Code | FlowField | Code | 20 | ||
Key to join to the Dimension table.Show/hide example query | |||||||
484 | Shortcut Dimension 6 Code | Shortcut Dimension 6 Code | FlowField | Code | 20 | ||
Key to join to the Dimension table.Show/hide example query | |||||||
485 | Shortcut Dimension 7 Code | Shortcut Dimension 7 Code | FlowField | Code | 20 | ||
Key to join to the Dimension table.Show/hide example query | |||||||
486 | Shortcut Dimension 8 Code | Shortcut Dimension 8 Code | FlowField | Code | 20 | ||
Key to join to the Dimension table.Show/hide example query | |||||||
495 | Last Dim. Correction Entry No. | Last Dim. Correction Entry No. | Normal | Integer | 4 | Last Dim_ Correction Entry No_ | int |
496 | Last Dim. Correction Node | Last Dim. Correction Node | Normal | Integer | 4 | Last Dim_ Correction Node | int |
497 | Dimension Changes Count | Count of Dimension Changes | Normal | Integer | 4 | Dimension Changes Count | int |
2678 | Allocation Account No. | Allocation Account No. | Normal | Code | 20 | Allocation Account No_ | nvarchar(40) |
Key to join to the Allocation Account table.Show/hide example query | |||||||
5400 | Prod. Order No. | Prod. Order No. | Normal | Code | 20 | Prod_ Order No_ | nvarchar(40) |
5600 | FA Entry Type | FA Entry Type | Normal | Option | 4 | FA Entry Type | int |
Available options are:
| |||||||
5601 | FA Entry No. | FA Entry No. | Normal | Integer | 4 | FA Entry No_ | int |
5618 | Comment | Comment | Normal | Text | 250 | Comment | nvarchar(500) |
6200 | Non-Deductible VAT Amount | Non-Deductible Tax Amount | Normal | Decimal | 12 | Non-Deductible VAT Amount | decimal(38,38) |
6201 | Non-Deductible VAT Amount ACY | Non-Deductible Tax Amount ACY | Normal | Decimal | 12 | Non-Deductible VAT Amount ACY | decimal(38,38) |
8001 | Account Id | Account Id | FlowField | GUID | 16 | ||
Key to join to the G/L Account table.Show/hide example query | |||||||
8005 | Last Modified DateTime | Last Modified DateTime | Normal | DateTime | 8 | Last Modified DateTime | datetime |
10018 | STE Transaction ID | STE Transaction ID | Normal | Text | 20 | ||
10019 | GST/HST | GST/HST | Normal | Option | 4 | ||
22212 | Reviewed | Reviewed | FlowField | Boolean | 4 | ||
22213 | Reviewed By | Reviewed By | FlowField | Code | 50 | ||
22214 | Reviewed Date | Reviewed Date | FlowField | DateTime | 8 | ||
22215 | Reviewed Identifier | Reviewed Identifier | FlowField | Integer | 4 | ||
2000000000 | $systemId | System ID | Normal | GUID | 16 | $systemId | uniqueidentifier |
2000000001 | SystemCreatedAt | Created At | Normal | DateTime | 8 | $systemCreatedAt | datetime |
2000000002 | SystemCreatedBy | Created By | Normal | GUID | 16 | $systemCreatedBy | uniqueidentifier |
Key to join to the User table.Show/hide example query | |||||||
2000000003 | SystemModifiedAt | Modified At | Normal | DateTime | 8 | $systemModifiedAt | datetime |
2000000004 | SystemModifiedBy | Modified By | Normal | GUID | 16 | $systemModifiedBy | uniqueidentifier |