Easily find this page again using the shortlink: https://bct.azrcrv.co.uk/5907
Table Type: Company
Table Name: Service Ledger Entry
Database Table Name: CRONUS UK Ltd_$Service Ledger 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 Service Ledger Entry can be queried.
Show/hide an example select of all columns
SELECT
*
FROM
[CRONUS UK Ltd_$Service Ledger Entry$437dbf0e-84ff-417a-965d-ed2bb9650972]Show/hide an example select of all columns by name
SELECT
[timestamp]
,[Entry No_]
,[Service Contract No_]
,[Document Type]
,[Document No_]
,[Serv_ Contract Acc_ Gr_ Code]
,[Document Line No_]
,[Moved from Prepaid Acc_]
,[Posting Date]
,[Amount (LCY)]
,[Customer No_]
,[Ship-to Code]
,[Item No_ (Serviced)]
,[Serial No_ (Serviced)]
,[User ID]
,[Contract Invoice Period]
,[Global Dimension 1 Code]
,[Global Dimension 2 Code]
,[Service Item No_ (Serviced)]
,[Variant Code (Serviced)]
,[Contract Group Code]
,[Type]
,[No_]
,[Cost Amount]
,[Discount Amount]
,[Unit Cost]
,[Quantity]
,[Charged Qty_]
,[Unit Price]
,[Discount _]
,[Contract Disc_ Amount]
,[Bill-to Customer No_]
,[Fault Reason Code]
,[Description]
,[Service Order Type]
,[Service Order No_]
,[Job No_]
,[Gen_ Bus_ Posting Group]
,[Gen_ Prod_ Posting Group]
,[Location Code]
,[Unit of Measure Code]
,[Work Type Code]
,[Bin Code]
,[Responsibility Center]
,[Variant Code]
,[Entry Type]
,[Open]
,[Serv_ Price Adjmt_ Gr_ Code]
,[Service Price Group Code]
,[Prepaid]
,[Apply Until Entry No_]
,[Applies-to Entry No_]
,[Amount]
,[Job Task No_]
,[Job Line Type]
,[Job Posted]
,[Dimension Set ID]
,[$systemId]
,[$systemCreatedAt]
,[$systemCreatedBy]
,[$systemModifiedAt]
,[$systemModifiedBy]
FROM
[CRONUS UK Ltd_$Service Ledger 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_$Service Ledger Entry$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Service Ledger Entry]
LEFT JOIN
[CRONUS UK Ltd_$Customer$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Customer]
ON
[Service Ledger Entry].[Customer No_] = [Customer].[No_]
LEFT JOIN
[CRONUS UK Ltd_$Customer$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Customer]
ON
[Service Ledger Entry].[Bill-to Customer No_] = [Customer].[No_]
LEFT JOIN
[CRONUS UK Ltd_$Job$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Job]
ON
[Service Ledger Entry].[Job No_] = [Job].[Job No_]
LEFT JOIN
[CRONUS UK Ltd_$Location$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Location]
ON
[Service Ledger Entry].[Location Code] = [Location].[Code]
LEFT JOIN
[CRONUS UK Ltd_$Unit of Measure$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Unit of Measure]
ON
[Service Ledger Entry].[Unit of Measure Code] = [Unit of Measure].[Code]
LEFT JOIN
[CRONUS UK Ltd_$Job Task$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Job Task]
ON
[Service Ledger Entry].[Job Task No_] = [Job Task].[Job Task No_]Show/hide columns in Service Ledger Entry table
| Column ID | Column Name | Data Type | ||||
|---|---|---|---|---|---|---|
| 1 | timestamp  | timestamp | ||||
| 2 | Entry No_  | int | ||||
| 3 | Service Contract No_ | nvarchar(40) | ||||
| 4 | Document Type | int | ||||
| 5 | Document No_ | nvarchar(40) | ||||
| 6 | Serv_ Contract Acc_ Gr_ Code | nvarchar(20) | ||||
| 7 | Document Line No_ | int | ||||
| 8 | Moved from Prepaid Acc_ | tinyint | ||||
| 9 | Posting Date | datetime | ||||
| 10 | Amount (LCY) | decimal(38,38) | ||||
| 11 | Customer No_ | nvarchar(40) | ||||
Key to join to the Customer table.Show/hide example querySELECT
[Service Ledger Entry].[Customer No_]
,[Customer].[No_]
FROM
[CRONUS UK Ltd_$Service Ledger Entry$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Service Ledger Entry]
LEFT JOIN
[CRONUS UK Ltd_$Customer$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Customer]
ON
[Service Ledger Entry].[Customer No_] = [Customer].[No_] | ||||||
| 12 | Ship-to Code | nvarchar(20) | ||||
| 13 | Item No_ (Serviced) | nvarchar(40) | ||||
| 14 | Serial No_ (Serviced) | nvarchar(100) | ||||
| 15 | User ID | nvarchar(100) | ||||
| 16 | Contract Invoice Period | nvarchar(60) | ||||
| 17 | Global Dimension 1 Code | nvarchar(40) | ||||
| 18 | Global Dimension 2 Code | nvarchar(40) | ||||
| 19 | Service Item No_ (Serviced) | nvarchar(40) | ||||
| 20 | Variant Code (Serviced) | nvarchar(20) | ||||
| 21 | Contract Group Code | nvarchar(20) | ||||
| 22 | Type | int | ||||
| 23 | No_ | nvarchar(40) | ||||
| 24 | Cost Amount | decimal(38,38) | ||||
| 25 | Discount Amount | decimal(38,38) | ||||
| 26 | Unit Cost | decimal(38,38) | ||||
| 27 | Quantity | decimal(38,38) | ||||
| 28 | Charged Qty_ | decimal(38,38) | ||||
| 29 | Unit Price | decimal(38,38) | ||||
| 30 | Discount _ | decimal(38,38) | ||||
| 31 | Contract Disc_ Amount | decimal(38,38) | ||||
| 32 | Bill-to Customer No_ | nvarchar(40) | ||||
Key to join to the Customer table.Show/hide example querySELECT
[Service Ledger Entry].[Bill-to Customer No_]
,[Customer].[No_]
FROM
[CRONUS UK Ltd_$Service Ledger Entry$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Service Ledger Entry]
LEFT JOIN
[CRONUS UK Ltd_$Customer$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Customer]
ON
[Service Ledger Entry].[Bill-to Customer No_] = [Customer].[No_] | ||||||
| 33 | Fault Reason Code | nvarchar(20) | ||||
| 34 | Description | nvarchar(200) | ||||
| 35 | Service Order Type | nvarchar(20) | ||||
| 36 | Service Order No_ | nvarchar(40) | ||||
| 37 | Job No_ | nvarchar(40) | ||||
Key to join to the Job table.Show/hide example querySELECT
[Service Ledger Entry].[Job No_]
,[Job].[Job No_]
FROM
[CRONUS UK Ltd_$Service Ledger Entry$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Service Ledger Entry]
LEFT JOIN
[CRONUS UK Ltd_$Job$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Job]
ON
[Service Ledger Entry].[Job No_] = [Job].[Job No_] | ||||||
| 38 | Gen_ Bus_ Posting Group | nvarchar(40) | ||||
| 39 | Gen_ Prod_ Posting Group | nvarchar(40) | ||||
| 40 | Location Code | nvarchar(20) | ||||
Key to join to the Location table.Show/hide example querySELECT
[Service Ledger Entry].[Location Code]
,[Location].[Code]
FROM
[CRONUS UK Ltd_$Service Ledger Entry$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Service Ledger Entry]
LEFT JOIN
[CRONUS UK Ltd_$Location$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Location]
ON
[Service Ledger Entry].[Location Code] = [Location].[Code] | ||||||
| 41 | Unit of Measure Code | nvarchar(20) | ||||
Key to join to the Unit of Measure table.Show/hide example querySELECT
[Service Ledger Entry].[Unit of Measure Code]
,[Unit of Measure].[Code]
FROM
[CRONUS UK Ltd_$Service Ledger Entry$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Service Ledger Entry]
LEFT JOIN
[CRONUS UK Ltd_$Unit of Measure$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Unit of Measure]
ON
[Service Ledger Entry].[Unit of Measure Code] = [Unit of Measure].[Code] | ||||||
| 42 | Work Type Code | nvarchar(20) | ||||
| 43 | Bin Code | nvarchar(40) | ||||
| 44 | Responsibility Center | nvarchar(20) | ||||
| 45 | Variant Code | nvarchar(20) | ||||
| 46 | Entry Type | int | ||||
| 47 | Open | tinyint | ||||
| 48 | Serv_ Price Adjmt_ Gr_ Code | nvarchar(20) | ||||
| 49 | Service Price Group Code | nvarchar(20) | ||||
| 50 | Prepaid | tinyint | ||||
| 51 | Apply Until Entry No_ | int | ||||
| 52 | Applies-to Entry No_ | int | ||||
| 53 | Amount | decimal(38,38) | ||||
| 54 | Job Task No_ | nvarchar(40) | ||||
Key to join to the Job Task table.Show/hide example querySELECT
[Service Ledger Entry].[Job Task No_]
,[Job Task].[Job Task No_]
FROM
[CRONUS UK Ltd_$Service Ledger Entry$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Service Ledger Entry]
LEFT JOIN
[CRONUS UK Ltd_$Job Task$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Job Task]
ON
[Service Ledger Entry].[Job Task No_] = [Job Task].[Job Task No_] | ||||||
| 55 | Job Line Type | int | ||||
| 56 | Job Posted | tinyint | ||||
| 57 | Dimension Set ID | int | ||||
| 58 | $systemId | uniqueidentifier | ||||
| 59 | $systemCreatedAt | datetime | ||||
| 60 | $systemCreatedBy | uniqueidentifier | ||||
| 61 | $systemModifiedAt | datetime | ||||
| 62 | $systemModifiedBy | uniqueidentifier | ||||