Service Ledger Entry

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

Table Number: 5907

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 IDColumn NameData Type
1timestamp Searchtimestamp
2Entry No_ Primary Key Searchint
3Service Contract No_ Searchnvarchar(40)
4Document Type Searchint
5Document No_ Searchnvarchar(40)
6Serv_ Contract Acc_ Gr_ Code Searchnvarchar(20)
7Document Line No_ Searchint
8Moved from Prepaid Acc_ Searchtinyint
9Posting Date Searchdatetime
10Amount (LCY) Searchdecimal(38,38)
11Customer No_ Searchnvarchar(40)
Key to join to the Customer table.

Show/hide example query

SELECT
       [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_]
12Ship-to Code Searchnvarchar(20)
13Item No_ (Serviced) Searchnvarchar(40)
14Serial No_ (Serviced) Searchnvarchar(100)
15User ID Searchnvarchar(100)
16Contract Invoice Period Searchnvarchar(60)
17Global Dimension 1 Code Searchnvarchar(40)
18Global Dimension 2 Code Searchnvarchar(40)
19Service Item No_ (Serviced) Searchnvarchar(40)
20Variant Code (Serviced) Searchnvarchar(20)
21Contract Group Code Searchnvarchar(20)
22Type Searchint
23No_ Searchnvarchar(40)
24Cost Amount Searchdecimal(38,38)
25Discount Amount Searchdecimal(38,38)
26Unit Cost Searchdecimal(38,38)
27Quantity Searchdecimal(38,38)
28Charged Qty_ Searchdecimal(38,38)
29Unit Price Searchdecimal(38,38)
30Discount _ Searchdecimal(38,38)
31Contract Disc_ Amount Searchdecimal(38,38)
32Bill-to Customer No_ Searchnvarchar(40)
Key to join to the Customer table.

Show/hide example query

SELECT
       [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_]
33Fault Reason Code Searchnvarchar(20)
34Description Searchnvarchar(200)
35Service Order Type Searchnvarchar(20)
36Service Order No_ Searchnvarchar(40)
37Job No_ Searchnvarchar(40)
Key to join to the Job table.

Show/hide example query

SELECT
       [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_]
38Gen_ Bus_ Posting Group Searchnvarchar(40)
39Gen_ Prod_ Posting Group Searchnvarchar(40)
40Location Code Searchnvarchar(20)
Key to join to the Location table.

Show/hide example query

SELECT
       [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]
41Unit of Measure Code Searchnvarchar(20)
Key to join to the Unit of Measure table.

Show/hide example query

SELECT
       [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]
42Work Type Code Searchnvarchar(20)
43Bin Code Searchnvarchar(40)
44Responsibility Center Searchnvarchar(20)
45Variant Code Searchnvarchar(20)
46Entry Type Searchint
47Open Searchtinyint
48Serv_ Price Adjmt_ Gr_ Code Searchnvarchar(20)
49Service Price Group Code Searchnvarchar(20)
50Prepaid Searchtinyint
51Apply Until Entry No_ Searchint
52Applies-to Entry No_ Searchint
53Amount Searchdecimal(38,38)
54Job Task No_ Searchnvarchar(40)
Key to join to the Job Task table.

Show/hide example query

SELECT
       [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_]
55Job Line Type Searchint
56Job Posted Searchtinyint
57Dimension Set ID Searchint
58$systemId Searchuniqueidentifier
59$systemCreatedAt Searchdatetime
60$systemCreatedBy Searchuniqueidentifier
61$systemModifiedAt Searchdatetime
62$systemModifiedBy Searchuniqueidentifier

Show/hide tables related from Service Ledger Entry table

Leave a Reply

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