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
   [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_$Sales Header Archive$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Sales Header Archive]
      ON
         [Service Ledger Entry].[Document Type] = [Sales Header Archive].[Document Type]
      AND
         [Service Ledger Entry].[Document No_] = [Sales Header Archive].[No_]
LEFT JOIN
   [CRONUS UK Ltd_$Sales Header$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Sales Header]
      ON
         [Service Ledger Entry].[Document Type] = [Sales Header].[Document Type]
      AND
         [Service Ledger Entry].[Document No_] = [Sales Header].[No_]
LEFT JOIN
   [CRONUS UK Ltd_$Ship-to Address$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Ship-to Address]
      ON
         [Service Ledger Entry].[Ship-to Code] = [Ship-to Address].[Code]
LEFT JOIN
   [CRONUS UK Ltd_$Dimension$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Dimension]
      ON
         [Service Ledger Entry].[Global Dimension 1 Code] = [Dimension].[Code]
LEFT JOIN
   [CRONUS UK Ltd_$Dimension$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Dimension]
      ON
         [Service Ledger Entry].[Global Dimension 2 Code] = [Dimension].[Code]
LEFT JOIN
   [CRONUS UK Ltd_$Contract Group$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Contract Group]
      ON
         [Service Ledger Entry].[Contract Group Code] = [Contract Group].[Code]
LEFT JOIN
   [CRONUS UK Ltd_$Fault Reason Code$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Fault Reason Code]
      ON
         [Service Ledger Entry].[Fault Reason Code] = [Fault Reason Code].[Code]
LEFT JOIN
   [CRONUS UK Ltd_$Service Order Type$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Service Order Type]
      ON
         [Service Ledger Entry].[Service Order Type] = [Service Order Type].[Code]
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_$Work Type$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Work Type]
      ON
         [Service Ledger Entry].[Work Type Code] = [Work Type].[Code]
LEFT JOIN
   [CRONUS UK Ltd_$Bin$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Bin]
      ON
         [Service Ledger Entry].[Bin Code] = [Bin].[Code]
LEFT JOIN
   [CRONUS UK Ltd_$Responsibility Center$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Responsibility Center]
      ON
         [Service Ledger Entry].[Responsibility Center] = [Responsibility Center].[Code]
LEFT JOIN
   [CRONUS UK Ltd_$Item Variant$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Item Variant]
      ON
         [Service Ledger Entry].[Variant Code] = [Item Variant].[Code]
LEFT JOIN
   [CRONUS UK Ltd_$Service Price Group$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Service Price Group]
      ON
         [Service Ledger Entry].[Service Price Group Code] = [Service Price Group].[Code]
LEFT JOIN
   [CRONUS UK Ltd_$Dimension Set Entry$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Dimension Set Entry]
      ON
         [Service Ledger Entry].[Dimension Set ID] = [Dimension Set Entry].[Dimension Set ID]
LEFT JOIN
   [CRONUS UK Ltd_$Dimension$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Dimension]
      ON
         [Service Ledger Entry].[Shortcut Dimension 3 Code] = [Dimension].[Code]
LEFT JOIN
   [CRONUS UK Ltd_$Dimension$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Dimension]
      ON
         [Service Ledger Entry].[Shortcut Dimension 4 Code] = [Dimension].[Code]
LEFT JOIN
   [CRONUS UK Ltd_$Dimension$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Dimension]
      ON
         [Service Ledger Entry].[Shortcut Dimension 5 Code] = [Dimension].[Code]
LEFT JOIN
   [CRONUS UK Ltd_$Dimension$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Dimension]
      ON
         [Service Ledger Entry].[Shortcut Dimension 6 Code] = [Dimension].[Code]
LEFT JOIN
   [CRONUS UK Ltd_$Dimension$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Dimension]
      ON
         [Service Ledger Entry].[Shortcut Dimension 7 Code] = [Dimension].[Code]
LEFT JOIN
   [CRONUS UK Ltd_$Dimension$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Dimension]
      ON
         [Service Ledger Entry].[Shortcut Dimension 8 Code] = [Dimension].[Code]
LEFT JOIN
   [User] AS [User]
      ON
         [Service Ledger Entry].[SystemCreatedBy] = [User].[User Security ID]
LEFT JOIN
   [User] AS [User]
      ON
         [Service Ledger Entry].[SystemModifiedBy] = [User].[User Security ID]

Show/hide columns in Service Ledger Entry table

Field No.Field NameField CaptionClassTypeLengthSQL Column NameSQL DataType
1Entry No. Primary Key SearchEntry No.NormalInteger4Entry No_int
2Service Contract No. SearchService Contract No.NormalCode20Service Contract No_nvarchar(40)
3Document Type SearchDocument TypeNormalOption4Document Typeint
Available options are:
  • ” “
  • “Payment”
  • “Invoice”
  • “Credit Memo”
  • “Finance Charge Memo”
  • “Reminder”
  • “Refund”
  • “Shipment”
4Document No. SearchDocument No.NormalCode20Document No_nvarchar(40)
5Serv. Contract Acc. Gr. Code SearchServ. Contract Acc. Gr. CodeNormalCode10Serv_ Contract Acc_ Gr_ Codenvarchar(20)
Key to join to the Service Contract Account Group table.

Show/hide example query

SELECT
       [Service Ledger Entry].[Serv_ Contract Acc_ Gr_ Code]
       ,[Service Contract Account Group].[Code]
FROM
       [CRONUS UK Ltd_$Service Ledger Entry$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Service Ledger Entry]
LEFT JOIN
       [CRONUS UK Ltd_$Service Contract Account Group$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Service Contract Account Group]
              ON
                     [Service Ledger Entry].[Serv_ Contract Acc_ Gr_ Code] = [Service Contract Account Group].[Code]
6Document Line No. SearchDocument Line No.NormalInteger4Document Line No_int
8Moved from Prepaid Acc. SearchMoved from Prepaid Acc.NormalBoolean4Moved from Prepaid Acc_tinyint
9Posting Date SearchPosting DateNormalDate4Posting Datedatetime
11Amount (LCY) SearchAmount ($)NormalDecimal12Amount (LCY)decimal(38,38)
12Customer No. SearchCustomer No.NormalCode20Customer No_nvarchar(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_]
13Ship-to Code SearchShip-to CodeNormalCode10Ship-to Codenvarchar(20)
Key to join to the Ship-to Address table.

Show/hide example query

SELECT
       [Service Ledger Entry].[Ship-to Code]
       ,[Ship-to Address].[Code]
FROM
       [CRONUS UK Ltd_$Service Ledger Entry$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Service Ledger Entry]
LEFT JOIN
       [CRONUS UK Ltd_$Ship-to Address$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Ship-to Address]
              ON
                     [Service Ledger Entry].[Ship-to Code] = [Ship-to Address].[Code]
14Item No. (Serviced) SearchItem No. (Serviced)NormalCode20Item No_ (Serviced)nvarchar(40)
Key to join to the Item table.

Show/hide example query

SELECT
       [Service Ledger Entry].[Item No_ (Serviced)]
       ,[Item].[No_]
FROM
       [CRONUS UK Ltd_$Service Ledger Entry$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Service Ledger Entry]
LEFT JOIN
       [CRONUS UK Ltd_$Item$437dbf0e-84ff-417a-965d-ed2bb9650972$ext] AS [Item]
              ON
                     [Service Ledger Entry].[Item No_ (Serviced)] = [Item].[No_]
15Serial No. (Serviced) SearchSerial No. (Serviced)NormalCode50Serial No_ (Serviced)nvarchar(100)
16User ID SearchUser IDNormalCode50User IDnvarchar(100)
17Contract Invoice Period SearchContract Invoice PeriodNormalText30Contract Invoice Periodnvarchar(60)
18Global Dimension 1 Code SearchGlobal Dimension 1 CodeNormalCode20Global Dimension 1 Codenvarchar(40)
Key to join to the Dimension table.

Show/hide example query

SELECT
       [Service Ledger Entry].[Global Dimension 1 Code]
       ,[Dimension].[Code]
FROM
       [CRONUS UK Ltd_$Service Ledger Entry$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Service Ledger Entry]
LEFT JOIN
       [CRONUS UK Ltd_$Dimension$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Dimension]
              ON
                     [Service Ledger Entry].[Global Dimension 1 Code] = [Dimension].[Code]
19Global Dimension 2 Code SearchGlobal Dimension 2 CodeNormalCode20Global Dimension 2 Codenvarchar(40)
Key to join to the Dimension table.

Show/hide example query

SELECT
       [Service Ledger Entry].[Global Dimension 2 Code]
       ,[Dimension].[Code]
FROM
       [CRONUS UK Ltd_$Service Ledger Entry$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Service Ledger Entry]
LEFT JOIN
       [CRONUS UK Ltd_$Dimension$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Dimension]
              ON
                     [Service Ledger Entry].[Global Dimension 2 Code] = [Dimension].[Code]
20Service Item No. (Serviced) SearchService Item No. (Serviced)NormalCode20Service Item No_ (Serviced)nvarchar(40)
Key to join to the Service Item table.

Show/hide example query

SELECT
       [Service Ledger Entry].[Service Item No_ (Serviced)]
       ,[Service Item].[No_]
FROM
       [CRONUS UK Ltd_$Service Ledger Entry$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Service Ledger Entry]
LEFT JOIN
       [CRONUS UK Ltd_$Service Item$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Service Item]
              ON
                     [Service Ledger Entry].[Service Item No_ (Serviced)] = [Service Item].[No_]
21Variant Code (Serviced) SearchVariant Code (Serviced)NormalCode10Variant Code (Serviced)nvarchar(20)
22Contract Group Code SearchContract Group CodeNormalCode10Contract Group Codenvarchar(20)
Key to join to the Contract Group table.

Show/hide example query

SELECT
       [Service Ledger Entry].[Contract Group Code]
       ,[Contract Group].[Code]
FROM
       [CRONUS UK Ltd_$Service Ledger Entry$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Service Ledger Entry]
LEFT JOIN
       [CRONUS UK Ltd_$Contract Group$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Contract Group]
              ON
                     [Service Ledger Entry].[Contract Group Code] = [Contract Group].[Code]
23Type SearchTypeNormalOption4Typeint
Available options are:
  • ” “
  • “Resource”
  • “Item”
  • “Service Cost”
  • “Service Contract”
  • “G/L Account”
24No. SearchNo.NormalCode20No_nvarchar(40)
25Cost Amount SearchCost AmountNormalDecimal12Cost Amountdecimal(38,38)
26Discount Amount SearchDiscount AmountNormalDecimal12Discount Amountdecimal(38,38)
27Unit Cost SearchUnit CostNormalDecimal12Unit Costdecimal(38,38)
28Quantity SearchQuantityNormalDecimal12Quantitydecimal(38,38)
29Charged Qty. SearchCharged Qty.NormalDecimal12Charged Qty_decimal(38,38)
30Unit Price SearchUnit PriceNormalDecimal12Unit Pricedecimal(38,38)
31Discount % SearchDiscount %NormalDecimal12Discount _decimal(38,38)
32Contract Disc. Amount SearchContract Disc. AmountNormalDecimal12Contract Disc_ Amountdecimal(38,38)
33Bill-to Customer No. SearchBill-to Customer No.NormalCode20Bill-to Customer No_nvarchar(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_]
34Fault Reason Code SearchFault Reason CodeNormalCode10Fault Reason Codenvarchar(20)
Key to join to the Fault Reason Code table.

Show/hide example query

SELECT
       [Service Ledger Entry].[Fault Reason Code]
       ,[Fault Reason Code].[Code]
FROM
       [CRONUS UK Ltd_$Service Ledger Entry$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Service Ledger Entry]
LEFT JOIN
       [CRONUS UK Ltd_$Fault Reason Code$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Fault Reason Code]
              ON
                     [Service Ledger Entry].[Fault Reason Code] = [Fault Reason Code].[Code]
35Description SearchDescriptionNormalText100Descriptionnvarchar(200)
37Service Order Type SearchService Order TypeNormalCode10Service Order Typenvarchar(20)
Key to join to the Service Order Type table.

Show/hide example query

SELECT
       [Service Ledger Entry].[Service Order Type]
       ,[Service Order Type].[Code]
FROM
       [CRONUS UK Ltd_$Service Ledger Entry$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Service Ledger Entry]
LEFT JOIN
       [CRONUS UK Ltd_$Service Order Type$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Service Order Type]
              ON
                     [Service Ledger Entry].[Service Order Type] = [Service Order Type].[Code]
39Service Order No. SearchService Order No.NormalCode20Service Order No_nvarchar(40)
40Job No. SearchJob No.NormalCode20Job No_nvarchar(40)
Key to join to the Job table.

Show/hide example query

SELECT
       [Service Ledger Entry].[Job No_]
       ,[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].[No_]
41Gen. 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

SELECT
       [Service Ledger Entry].[Gen_ Bus_ Posting Group]
       ,[Gen. Business Posting Group].[Code]
FROM
       [CRONUS UK Ltd_$Service Ledger Entry$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Service Ledger Entry]
LEFT JOIN
       [CRONUS UK Ltd_$Gen_ Business Posting Group$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Gen. Business Posting Group]
              ON
                     [Service Ledger Entry].[Gen_ Bus_ Posting Group] = [Gen. Business Posting Group].[Code]
42Gen. 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

SELECT
       [Service Ledger Entry].[Gen_ Prod_ Posting Group]
       ,[Gen. Product Posting Group].[Code]
FROM
       [CRONUS UK Ltd_$Service Ledger Entry$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Service Ledger Entry]
LEFT JOIN
       [CRONUS UK Ltd_$Gen_ Product Posting Group$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Gen. Product Posting Group]
              ON
                     [Service Ledger Entry].[Gen_ Prod_ Posting Group] = [Gen. Product Posting Group].[Code]
43Location Code SearchLocation CodeNormalCode10Location Codenvarchar(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]
44Unit of Measure Code SearchUnit of Measure CodeNormalCode10Unit of Measure Codenvarchar(20)
45Work Type Code SearchWork Type CodeNormalCode10Work Type Codenvarchar(20)
Key to join to the Work Type table.

Show/hide example query

SELECT
       [Service Ledger Entry].[Work Type Code]
       ,[Work Type].[Code]
FROM
       [CRONUS UK Ltd_$Service Ledger Entry$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Service Ledger Entry]
LEFT JOIN
       [CRONUS UK Ltd_$Work Type$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Work Type]
              ON
                     [Service Ledger Entry].[Work Type Code] = [Work Type].[Code]
46Bin Code SearchBin CodeNormalCode20Bin Codenvarchar(40)
Key to join to the Bin table.

Show/hide example query

SELECT
       [Service Ledger Entry].[Bin Code]
       ,[Bin].[Code]
FROM
       [CRONUS UK Ltd_$Service Ledger Entry$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Service Ledger Entry]
LEFT JOIN
       [CRONUS UK Ltd_$Bin$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Bin]
              ON
                     [Service Ledger Entry].[Bin Code] = [Bin].[Code]
47Responsibility Center SearchResponsibility CenterNormalCode10Responsibility Centernvarchar(20)
Key to join to the Responsibility Center table.

Show/hide example query

SELECT
       [Service Ledger Entry].[Responsibility Center]
       ,[Responsibility Center].[Code]
FROM
       [CRONUS UK Ltd_$Service Ledger Entry$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Service Ledger Entry]
LEFT JOIN
       [CRONUS UK Ltd_$Responsibility Center$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Responsibility Center]
              ON
                     [Service Ledger Entry].[Responsibility Center] = [Responsibility Center].[Code]
48Variant Code SearchVariant CodeNormalCode10Variant Codenvarchar(20)
Key to join to the Item Variant table.

Show/hide example query

SELECT
       [Service Ledger Entry].[Variant Code]
       ,[Item Variant].[Code]
FROM
       [CRONUS UK Ltd_$Service Ledger Entry$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Service Ledger Entry]
LEFT JOIN
       [CRONUS UK Ltd_$Item Variant$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Item Variant]
              ON
                     [Service Ledger Entry].[Variant Code] = [Item Variant].[Code]
50Entry Type SearchEntry TypeNormalOption4Entry Typeint
Available options are:
  • “Usage”
  • “Sale”
  • “Consume”
  • “Contract”
51Open SearchOpenNormalBoolean4Opentinyint
52Serv. Price Adjmt. Gr. Code SearchServ. Price Adjmt. Gr. CodeNormalCode10Serv_ Price Adjmt_ Gr_ Codenvarchar(20)
Key to join to the Service Price Adjustment Group table.

Show/hide example query

SELECT
       [Service Ledger Entry].[Serv_ Price Adjmt_ Gr_ Code]
       ,[Service Price Adjustment Group].[Code]
FROM
       [CRONUS UK Ltd_$Service Ledger Entry$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Service Ledger Entry]
LEFT JOIN
       [CRONUS UK Ltd_$Service Price Adjustment Group$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Service Price Adjustment Group]
              ON
                     [Service Ledger Entry].[Serv_ Price Adjmt_ Gr_ Code] = [Service Price Adjustment Group].[Code]
53Service Price Group Code SearchService Price Group CodeNormalCode10Service Price Group Codenvarchar(20)
Key to join to the Service Price Group table.

Show/hide example query

SELECT
       [Service Ledger Entry].[Service Price Group Code]
       ,[Service Price Group].[Code]
FROM
       [CRONUS UK Ltd_$Service Ledger Entry$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Service Ledger Entry]
LEFT JOIN
       [CRONUS UK Ltd_$Service Price Group$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Service Price Group]
              ON
                     [Service Ledger Entry].[Service Price Group Code] = [Service Price Group].[Code]
54Prepaid SearchPrepaidNormalBoolean4Prepaidtinyint
55Apply Until Entry No. SearchApply Until Entry No.NormalInteger4Apply Until Entry No_int
56Applies-to Entry No. SearchApplies-to Entry No.NormalInteger4Applies-to Entry No_int
57Amount SearchAmountNormalDecimal12Amountdecimal(38,38)
58Job Task No. SearchJob Task No.NormalCode20Job Task No_nvarchar(40)
59Job Line Type SearchJob Line TypeNormalOption4Job Line Typeint
Available options are:
  • ” “
  • “Budget”
  • “Billable”
  • “Both Budget and Billable”
60Job Posted SearchJob PostedNormalBoolean4Job Postedtinyint
480Dimension Set ID SearchDimension Set IDNormalInteger4Dimension Set IDint
Key to join to the Dimension Set Entry table.

Show/hide example query

SELECT
       [Service Ledger Entry].[Dimension Set ID]
       ,[Dimension Set Entry].[Dimension Set ID]
FROM
       [CRONUS UK Ltd_$Service Ledger Entry$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Service Ledger Entry]
LEFT JOIN
       [CRONUS UK Ltd_$Dimension Set Entry$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Dimension Set Entry]
              ON
                     [Service Ledger Entry].[Dimension Set ID] = [Dimension Set Entry].[Dimension Set ID]
481Shortcut Dimension 3 Code SearchShortcut Dimension 3 CodeFlowFieldCode20
482Shortcut Dimension 4 Code SearchShortcut Dimension 4 CodeFlowFieldCode20
483Shortcut Dimension 5 Code SearchShortcut Dimension 5 CodeFlowFieldCode20
484Shortcut Dimension 6 Code SearchShortcut Dimension 6 CodeFlowFieldCode20
485Shortcut Dimension 7 Code SearchShortcut Dimension 7 CodeFlowFieldCode20
486Shortcut Dimension 8 Code SearchShortcut Dimension 8 CodeFlowFieldCode20
2000000000$systemId SearchSystem IDNormalGUID16$systemIduniqueidentifier
2000000001SystemCreatedAt SearchCreated AtNormalDateTime8$systemCreatedAtdatetime
2000000002SystemCreatedBy SearchCreated ByNormalGUID16$systemCreatedByuniqueidentifier
Key to join to the User table.

Show/hide example query

SELECT
       [Service Ledger Entry].[$systemCreatedBy]
       ,[User].[User Security ID]
FROM
       [CRONUS UK Ltd_$Service Ledger Entry$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Service Ledger Entry]
LEFT JOIN
       [User] AS [User]
              ON
                     [Service Ledger Entry].[$systemCreatedBy] = [User].[User Security ID]
2000000003SystemModifiedAt SearchModified AtNormalDateTime8$systemModifiedAtdatetime
2000000004SystemModifiedBy SearchModified ByNormalGUID16$systemModifiedByuniqueidentifier
Key to join to the User table.

Show/hide example query

SELECT
       [Service Ledger Entry].[$systemModifiedBy]
       ,[User].[User Security ID]
FROM
       [CRONUS UK Ltd_$Service Ledger Entry$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Service Ledger Entry]
LEFT JOIN
       [User] AS [User]
              ON
                     [Service Ledger Entry].[$systemModifiedBy] = [User].[User Security ID]

Show/hide tables related from Service Ledger Entry table

Leave a Reply

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