Warranty Ledger Entry

Easily find this page again using the shortlink: https://bct.azrcrv.co.uk/5908

Table Type: Company

Table Name: Warranty Ledger Entry
Database Table Name: CRONUS UK Ltd_$Warranty Ledger Entry$437dbf0e-84ff-417a-965d-ed2bb9650972

Table Number: 5908

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 Warranty Ledger Entry can be queried.

Show/hide an example select of all columns

SELECT
   *
FROM
   [CRONUS UK Ltd_$Warranty Ledger Entry$437dbf0e-84ff-417a-965d-ed2bb9650972]

Show/hide an example select of all columns by name

SELECT
   [timestamp]
   ,[Entry No_]
   ,[Document No_]
   ,[Posting Date]
   ,[Customer No_]
   ,[Ship-to Code]
   ,[Bill-to Customer No_]
   ,[Variant Code (Serviced)]
   ,[Service Item No_ (Serviced)]
   ,[Item No_ (Serviced)]
   ,[Serial No_ (Serviced)]
   ,[Service Item Group (Serviced)]
   ,[Service Order No_]
   ,[Service Contract No_]
   ,[Fault Reason Code]
   ,[Fault Area Code]
   ,[Fault Code]
   ,[Symptom Code]
   ,[Resolution Code]
   ,[Type]
   ,[No_]
   ,[Quantity]
   ,[Work Type Code]
   ,[Unit of Measure Code]
   ,[Amount]
   ,[Description]
   ,[Gen_ Bus_ Posting Group]
   ,[Gen_ Prod_ Posting Group]
   ,[Global Dimension 1 Code]
   ,[Global Dimension 2 Code]
   ,[Open]
   ,[Vendor No_]
   ,[Vendor Item No_]
   ,[Variant Code]
   ,[Service Order Line No_]
   ,[Dimension Set ID]
   ,[$systemId]
   ,[$systemCreatedAt]
   ,[$systemCreatedBy]
   ,[$systemModifiedAt]
   ,[$systemModifiedBy]
FROM
   [CRONUS UK Ltd_$Warranty 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_$Warranty Ledger Entry$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Warranty Ledger Entry]
LEFT JOIN
   [CRONUS UK Ltd_$Customer$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Customer]
      ON
         [Warranty Ledger Entry].[Customer No_] = [Customer].[No_]
LEFT JOIN
   [CRONUS UK Ltd_$Customer$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Customer]
      ON
         [Warranty Ledger Entry].[Bill-to Customer No_] = [Customer].[No_]
LEFT JOIN
   [CRONUS UK Ltd_$Unit of Measure$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Unit of Measure]
      ON
         [Warranty Ledger Entry].[Unit of Measure Code] = [Unit of Measure].[Code]
LEFT JOIN
   [CRONUS UK Ltd_$Vendor$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Vendor]
      ON
         [Warranty Ledger Entry].[Vendor No_] = [Vendor].[No_]

Show/hide columns in Warranty Ledger Entry table

Column IDColumn NameData Type
1timestamp Searchtimestamp
2Entry No_ Primary Key Searchint
3Document No_ Searchnvarchar(40)
4Posting Date Searchdatetime
5Customer No_ Searchnvarchar(40)
Key to join to the Customer table.

Show/hide example query

SELECT
       [Warranty Ledger Entry].[Customer No_]
       ,[Customer].[No_]
FROM
       [CRONUS UK Ltd_$Warranty Ledger Entry$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Warranty Ledger Entry]
LEFT JOIN
       [CRONUS UK Ltd_$Customer$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Customer]
              ON
                     [Warranty Ledger Entry].[Customer No_] = [Customer].[No_]
6Ship-to Code Searchnvarchar(20)
7Bill-to Customer No_ Searchnvarchar(40)
Key to join to the Customer table.

Show/hide example query

SELECT
       [Warranty Ledger Entry].[Bill-to Customer No_]
       ,[Customer].[No_]
FROM
       [CRONUS UK Ltd_$Warranty Ledger Entry$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Warranty Ledger Entry]
LEFT JOIN
       [CRONUS UK Ltd_$Customer$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Customer]
              ON
                     [Warranty Ledger Entry].[Bill-to Customer No_] = [Customer].[No_]
8Variant Code (Serviced) Searchnvarchar(20)
9Service Item No_ (Serviced) Searchnvarchar(40)
10Item No_ (Serviced) Searchnvarchar(40)
11Serial No_ (Serviced) Searchnvarchar(100)
12Service Item Group (Serviced) Searchnvarchar(20)
13Service Order No_ Searchnvarchar(40)
14Service Contract No_ Searchnvarchar(40)
15Fault Reason Code Searchnvarchar(20)
16Fault Area Code Searchnvarchar(20)
17Fault Code Searchnvarchar(20)
18Symptom Code Searchnvarchar(20)
19Resolution Code Searchnvarchar(20)
20Type Searchint
21No_ Searchnvarchar(40)
22Quantity Searchdecimal(38,38)
23Work Type Code Searchnvarchar(20)
24Unit of Measure Code Searchnvarchar(20)
Key to join to the Unit of Measure table.

Show/hide example query

SELECT
       [Warranty Ledger Entry].[Unit of Measure Code]
       ,[Unit of Measure].[Code]
FROM
       [CRONUS UK Ltd_$Warranty Ledger Entry$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Warranty Ledger Entry]
LEFT JOIN
       [CRONUS UK Ltd_$Unit of Measure$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Unit of Measure]
              ON
                     [Warranty Ledger Entry].[Unit of Measure Code] = [Unit of Measure].[Code]
25Amount Searchdecimal(38,38)
26Description Searchnvarchar(200)
27Gen_ Bus_ Posting Group Searchnvarchar(40)
28Gen_ Prod_ Posting Group Searchnvarchar(40)
29Global Dimension 1 Code Searchnvarchar(40)
30Global Dimension 2 Code Searchnvarchar(40)
31Open Searchtinyint
32Vendor No_ Searchnvarchar(40)
Key to join to the Vendor table.

Show/hide example query

SELECT
       [Warranty Ledger Entry].[Vendor No_]
       ,[Vendor].[No_]
FROM
       [CRONUS UK Ltd_$Warranty Ledger Entry$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Warranty Ledger Entry]
LEFT JOIN
       [CRONUS UK Ltd_$Vendor$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Vendor]
              ON
                     [Warranty Ledger Entry].[Vendor No_] = [Vendor].[No_]
33Vendor Item No_ Searchnvarchar(100)
34Variant Code Searchnvarchar(20)
35Service Order Line No_ Searchint
36Dimension Set ID Searchint
37$systemId Searchuniqueidentifier
38$systemCreatedAt Searchdatetime
39$systemCreatedBy Searchuniqueidentifier
40$systemModifiedAt Searchdatetime
41$systemModifiedBy Searchuniqueidentifier

Show/hide tables related from Warranty Ledger Entry table

Leave a Reply

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