Easily find this page again using the shortlink: https://bct.azrcrv.co.uk/379
Table Type: Company
Table Name: Detailed Cust. Ledg. Entry
Database Table Name: CRONUS UK Ltd_$Detailed Cust_ Ledg_ 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 Detailed Cust. Ledg. Entry can be queried.
Show/hide an example select of all columns
SELECT
*
FROM
[CRONUS UK Ltd_$Detailed Cust_ Ledg_ Entry$437dbf0e-84ff-417a-965d-ed2bb9650972]
Show/hide an example select of all columns by name
SELECT
[Entry No_]
,[Cust_ Ledger Entry No_]
,[Entry Type]
,[Posting Date]
,[Document Type]
,[Document No_]
,[Amount]
,[Amount (LCY)]
,[Customer No_]
,[Currency Code]
,[User ID]
,[Source Code]
,[Transaction No_]
,[Journal Batch Name]
,[Reason Code]
,[Debit Amount]
,[Credit Amount]
,[Debit Amount (LCY)]
,[Credit Amount (LCY)]
,[Initial Entry Due Date]
,[Initial Entry Global Dim_ 1]
,[Initial Entry Global Dim_ 2]
,[Gen_ Bus_ Posting Group]
,[Gen_ Prod_ Posting Group]
,[Use Tax]
,[VAT Bus_ Posting Group]
,[VAT Prod_ Posting Group]
,[Initial Document Type]
,[Applied Cust_ Ledger Entry No_]
,[Unapplied]
,[Unapplied by Entry No_]
,[Remaining Pmt_ Disc_ Possible]
,[Max_ Payment Tolerance]
,[Tax Jurisdiction Code]
,[Application No_]
,[Ledger Entry Amount]
,[Posting Group]
,[Exch_ Rate Adjmt_ Reg_ No_]
,[$systemId]
,[$systemCreatedAt]
,[$systemCreatedBy]
,[$systemModifiedAt]
,[$systemModifiedBy]
FROM
[CRONUS UK Ltd_$Detailed Cust_ Ledg_ Entry$437dbf0e-84ff-417a-965d-ed2bb9650972]
Show/hide an example select of all columns including those from all joined tables
SELECT
*
FROM
[CRONUS UK Ltd_$Detailed Cust_ Ledg_ Entry$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Detailed Cust. Ledg. Entry]
LEFT JOIN
[CRONUS UK Ltd_$Sales Header Archive$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Sales Header Archive]
ON
[Detailed Cust. Ledg. Entry].[Document Type] = [Sales Header Archive].[Document Type]
AND
[Detailed Cust. Ledg. Entry].[Document No_] = [Sales Header Archive].[No_]
LEFT JOIN
[CRONUS UK Ltd_$Sales Header$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Sales Header]
ON
[Detailed Cust. Ledg. Entry].[Document Type] = [Sales Header].[Document Type]
AND
[Detailed Cust. Ledg. Entry].[Document No_] = [Sales Header].[No_]
LEFT JOIN
[CRONUS UK Ltd_$Currency$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Currency]
ON
[Detailed Cust. Ledg. Entry].[Currency Code] = [Currency].[Code]
LEFT JOIN
[CRONUS UK Ltd_$Source Code$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Source Code]
ON
[Detailed Cust. Ledg. Entry].[Source Code] = [Source Code].[Code]
LEFT JOIN
[CRONUS UK Ltd_$Reason Code$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Reason Code]
ON
[Detailed Cust. Ledg. Entry].[Reason Code] = [Reason Code].[Code]
LEFT JOIN
[CRONUS UK Ltd_$Tax Jurisdiction$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Tax Jurisdiction]
ON
[Detailed Cust. Ledg. Entry].[Tax Jurisdiction Code] = [Tax Jurisdiction].[Code]
LEFT JOIN
[CRONUS UK Ltd_$Customer Posting Group$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Customer Posting Group]
ON
[Detailed Cust. Ledg. Entry].[Posting Group] = [Customer Posting Group].[Code]
LEFT JOIN
[User] AS [User]
ON
[Detailed Cust. Ledg. Entry].[SystemCreatedBy] = [User].[User Security ID]
LEFT JOIN
[User] AS [User]
ON
[Detailed Cust. Ledg. Entry].[SystemModifiedBy] = [User].[User Security ID]
Show/hide columns in Detailed Cust. Ledg. 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 |
2 | Cust. Ledger Entry No. | Cust. Ledger Entry No. | Normal | Integer | 4 | Cust_ Ledger Entry No_ | int |
Key to join to the Cust. Ledger Entry table.Show/hide example querySELECT [Detailed Cust. Ledg. Entry].[Cust_ Ledger Entry No_] ,[Cust. Ledger Entry].[Entry No_] FROM [CRONUS UK Ltd_$Detailed Cust_ Ledg_ Entry$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Detailed Cust. Ledg. Entry] LEFT JOIN [CRONUS UK Ltd_$Cust_ Ledger Entry$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Cust. Ledger Entry] ON [Detailed Cust. Ledg. Entry].[Cust_ Ledger Entry No_] = [Cust. Ledger Entry].[Entry No_] | |||||||
3 | Entry Type | Entry Type | Normal | Option | 4 | Entry Type | int |
Available options are:
| |||||||
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 | Amount | Amount | Normal | Decimal | 12 | Amount | decimal(38,38) |
8 | Amount (LCY) | Amount ($) | Normal | Decimal | 12 | Amount (LCY) | decimal(38,38) |
9 | Customer No. | Customer No. | Normal | Code | 20 | Customer No_ | nvarchar(40) |
Key to join to the Customer table.Show/hide example querySELECT [Detailed Cust. Ledg. Entry].[Customer No_] ,[Customer].[No_] FROM [CRONUS UK Ltd_$Detailed Cust_ Ledg_ Entry$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Detailed Cust. Ledg. Entry] LEFT JOIN [CRONUS UK Ltd_$Customer$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Customer] ON [Detailed Cust. Ledg. Entry].[Customer No_] = [Customer].[No_] | |||||||
10 | Currency Code | Currency Code | Normal | Code | 10 | Currency Code | nvarchar(20) |
Key to join to the Currency table.Show/hide example querySELECT [Detailed Cust. Ledg. Entry].[Currency Code] ,[Currency].[Code] FROM [CRONUS UK Ltd_$Detailed Cust_ Ledg_ Entry$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Detailed Cust. Ledg. Entry] LEFT JOIN [CRONUS UK Ltd_$Currency$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Currency] ON [Detailed Cust. Ledg. Entry].[Currency Code] = [Currency].[Code] | |||||||
11 | User ID | User ID | Normal | Code | 50 | User ID | nvarchar(100) |
12 | Source Code | Source Code | Normal | Code | 10 | Source Code | nvarchar(20) |
Key to join to the Source Code table.Show/hide example querySELECT [Detailed Cust. Ledg. Entry].[Source Code] ,[Source Code].[Code] FROM [CRONUS UK Ltd_$Detailed Cust_ Ledg_ Entry$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Detailed Cust. Ledg. Entry] LEFT JOIN [CRONUS UK Ltd_$Source Code$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Source Code] ON [Detailed Cust. Ledg. Entry].[Source Code] = [Source Code].[Code] | |||||||
13 | Transaction No. | Transaction No. | Normal | Integer | 4 | Transaction No_ | int |
14 | Journal Batch Name | Journal Batch Name | Normal | Code | 10 | Journal Batch Name | nvarchar(20) |
15 | Reason Code | Reason Code | Normal | Code | 10 | Reason Code | nvarchar(20) |
Key to join to the Reason Code table.Show/hide example querySELECT [Detailed Cust. Ledg. Entry].[Reason Code] ,[Reason Code].[Code] FROM [CRONUS UK Ltd_$Detailed Cust_ Ledg_ Entry$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Detailed Cust. Ledg. Entry] LEFT JOIN [CRONUS UK Ltd_$Reason Code$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Reason Code] ON [Detailed Cust. Ledg. Entry].[Reason Code] = [Reason Code].[Code] | |||||||
16 | Debit Amount | Debit Amount | Normal | Decimal | 12 | Debit Amount | decimal(38,38) |
17 | Credit Amount | Credit Amount | Normal | Decimal | 12 | Credit Amount | decimal(38,38) |
18 | Debit Amount (LCY) | Debit Amount ($) | Normal | Decimal | 12 | Debit Amount (LCY) | decimal(38,38) |
19 | Credit Amount (LCY) | Credit Amount ($) | Normal | Decimal | 12 | Credit Amount (LCY) | decimal(38,38) |
20 | Initial Entry Due Date | Initial Entry Due Date | Normal | Date | 4 | Initial Entry Due Date | datetime |
21 | Initial Entry Global Dim. 1 | Initial Entry Global Dim. 1 | Normal | Code | 20 | Initial Entry Global Dim_ 1 | nvarchar(40) |
22 | Initial Entry Global Dim. 2 | Initial Entry Global Dim. 2 | Normal | Code | 20 | Initial Entry Global Dim_ 2 | nvarchar(40) |
24 | 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 querySELECT [Detailed Cust. Ledg. Entry].[Gen_ Bus_ Posting Group] ,[Gen. Business Posting Group].[Code] FROM [CRONUS UK Ltd_$Detailed Cust_ Ledg_ Entry$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Detailed Cust. Ledg. Entry] LEFT JOIN [CRONUS UK Ltd_$Gen_ Business Posting Group$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Gen. Business Posting Group] ON [Detailed Cust. Ledg. Entry].[Gen_ Bus_ Posting Group] = [Gen. Business Posting Group].[Code] | |||||||
25 | 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 querySELECT [Detailed Cust. Ledg. Entry].[Gen_ Prod_ Posting Group] ,[Gen. Product Posting Group].[Code] FROM [CRONUS UK Ltd_$Detailed Cust_ Ledg_ Entry$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Detailed Cust. Ledg. Entry] LEFT JOIN [CRONUS UK Ltd_$Gen_ Product Posting Group$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Gen. Product Posting Group] ON [Detailed Cust. Ledg. Entry].[Gen_ Prod_ Posting Group] = [Gen. Product Posting Group].[Code] | |||||||
29 | Use Tax | Use Tax | Normal | Boolean | 4 | Use Tax | tinyint |
30 | 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 querySELECT [Detailed Cust. Ledg. Entry].[VAT Bus_ Posting Group] ,[VAT Business Posting Group].[Code] FROM [CRONUS UK Ltd_$Detailed Cust_ Ledg_ Entry$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Detailed Cust. Ledg. Entry] LEFT JOIN [CRONUS UK Ltd_$VAT Business Posting Group$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [VAT Business Posting Group] ON [Detailed Cust. Ledg. Entry].[VAT Bus_ Posting Group] = [VAT Business Posting Group].[Code] | |||||||
31 | 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 querySELECT [Detailed Cust. Ledg. Entry].[VAT Prod_ Posting Group] ,[VAT Product Posting Group].[Code] FROM [CRONUS UK Ltd_$Detailed Cust_ Ledg_ Entry$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Detailed Cust. Ledg. Entry] LEFT JOIN [CRONUS UK Ltd_$VAT Product Posting Group$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [VAT Product Posting Group] ON [Detailed Cust. Ledg. Entry].[VAT Prod_ Posting Group] = [VAT Product Posting Group].[Code] | |||||||
35 | Initial Document Type | Initial Document Type | Normal | Option | 4 | Initial Document Type | int |
Available options are:
| |||||||
36 | Applied Cust. Ledger Entry No. | Applied Cust. Ledger Entry No. | Normal | Integer | 4 | Applied Cust_ Ledger Entry No_ | int |
37 | Unapplied | Unapplied | Normal | Boolean | 4 | Unapplied | tinyint |
38 | Unapplied by Entry No. | Unapplied by Entry No. | Normal | Integer | 4 | Unapplied by Entry No_ | int |
39 | Remaining Pmt. Disc. Possible | Remaining Pmt. Disc. Possible | Normal | Decimal | 12 | Remaining Pmt_ Disc_ Possible | decimal(38,38) |
40 | Max. Payment Tolerance | Max. Payment Tolerance | Normal | Decimal | 12 | Max_ Payment Tolerance | decimal(38,38) |
41 | Tax Jurisdiction Code | Tax Jurisdiction Code | Normal | Code | 10 | Tax Jurisdiction Code | nvarchar(20) |
Key to join to the Tax Jurisdiction table.Show/hide example querySELECT [Detailed Cust. Ledg. Entry].[Tax Jurisdiction Code] ,[Tax Jurisdiction].[Code] FROM [CRONUS UK Ltd_$Detailed Cust_ Ledg_ Entry$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Detailed Cust. Ledg. Entry] LEFT JOIN [CRONUS UK Ltd_$Tax Jurisdiction$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Tax Jurisdiction] ON [Detailed Cust. Ledg. Entry].[Tax Jurisdiction Code] = [Tax Jurisdiction].[Code] | |||||||
42 | Application No. | Application No. | Normal | Integer | 4 | Application No_ | int |
43 | Ledger Entry Amount | Ledger Entry Amount | Normal | Boolean | 4 | Ledger Entry Amount | tinyint |
44 | Posting Group | Customer Posting Group | Normal | Code | 20 | Posting Group | nvarchar(40) |
Key to join to the Customer Posting Group table.Show/hide example querySELECT [Detailed Cust. Ledg. Entry].[Posting Group] ,[Customer Posting Group].[Code] FROM [CRONUS UK Ltd_$Detailed Cust_ Ledg_ Entry$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Detailed Cust. Ledg. Entry] LEFT JOIN [CRONUS UK Ltd_$Customer Posting Group$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Customer Posting Group] ON [Detailed Cust. Ledg. Entry].[Posting Group] = [Customer Posting Group].[Code] | |||||||
45 | Exch. Rate Adjmt. Reg. No. | Exch. Rate Adjmt. Reg. No. | Normal | Integer | 4 | Exch_ Rate Adjmt_ Reg_ No_ | int |
Key to join to the Exch. Rate Adjmt. Reg. table.Show/hide example querySELECT [Detailed Cust. Ledg. Entry].[Exch_ Rate Adjmt_ Reg_ No_] ,[Exch. Rate Adjmt. Reg.].[No_] FROM [CRONUS UK Ltd_$Detailed Cust_ Ledg_ Entry$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Detailed Cust. Ledg. Entry] LEFT JOIN [CRONUS UK Ltd_$Exch_ Rate Adjmt_ Reg_$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Exch. Rate Adjmt. Reg.] ON [Detailed Cust. Ledg. Entry].[Exch_ Rate Adjmt_ Reg_ No_] = [Exch. Rate Adjmt. Reg.].[No_] | |||||||
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 querySELECT [Detailed Cust. Ledg. Entry].[$systemCreatedBy] ,[User].[User Security ID] FROM [CRONUS UK Ltd_$Detailed Cust_ Ledg_ Entry$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Detailed Cust. Ledg. Entry] LEFT JOIN [User] AS [User] ON [Detailed Cust. Ledg. Entry].[$systemCreatedBy] = [User].[User Security ID] | |||||||
2000000003 | SystemModifiedAt | Modified At | Normal | DateTime | 8 | $systemModifiedAt | datetime |
2000000004 | SystemModifiedBy | Modified By | Normal | GUID | 16 | $systemModifiedBy | uniqueidentifier |