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
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 ID | Column Name | Data Type | ||||
|---|---|---|---|---|---|---|
| 1 | timestamp  | timestamp | ||||
| 2 | Entry No_  | int | ||||
| 3 | Document No_ | nvarchar(40) | ||||
| 4 | Posting Date | datetime | ||||
| 5 | Customer No_ | nvarchar(40) | ||||
Key to join to the Customer table.Show/hide example querySELECT
[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_] | ||||||
| 6 | Ship-to Code | nvarchar(20) | ||||
| 7 | Bill-to Customer No_ | nvarchar(40) | ||||
Key to join to the Customer table.Show/hide example querySELECT
[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_] | ||||||
| 8 | Variant Code (Serviced) | nvarchar(20) | ||||
| 9 | Service Item No_ (Serviced) | nvarchar(40) | ||||
| 10 | Item No_ (Serviced) | nvarchar(40) | ||||
| 11 | Serial No_ (Serviced) | nvarchar(100) | ||||
| 12 | Service Item Group (Serviced) | nvarchar(20) | ||||
| 13 | Service Order No_ | nvarchar(40) | ||||
| 14 | Service Contract No_ | nvarchar(40) | ||||
| 15 | Fault Reason Code | nvarchar(20) | ||||
| 16 | Fault Area Code | nvarchar(20) | ||||
| 17 | Fault Code | nvarchar(20) | ||||
| 18 | Symptom Code | nvarchar(20) | ||||
| 19 | Resolution Code | nvarchar(20) | ||||
| 20 | Type | int | ||||
| 21 | No_ | nvarchar(40) | ||||
| 22 | Quantity | decimal(38,38) | ||||
| 23 | Work Type Code | nvarchar(20) | ||||
| 24 | Unit of Measure Code | nvarchar(20) | ||||
Key to join to the Unit of Measure table.Show/hide example querySELECT
[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] | ||||||
| 25 | Amount | decimal(38,38) | ||||
| 26 | Description | nvarchar(200) | ||||
| 27 | Gen_ Bus_ Posting Group | nvarchar(40) | ||||
| 28 | Gen_ Prod_ Posting Group | nvarchar(40) | ||||
| 29 | Global Dimension 1 Code | nvarchar(40) | ||||
| 30 | Global Dimension 2 Code | nvarchar(40) | ||||
| 31 | Open | tinyint | ||||
| 32 | Vendor No_ | nvarchar(40) | ||||
Key to join to the Vendor table.Show/hide example querySELECT
[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_] | ||||||
| 33 | Vendor Item No_ | nvarchar(100) | ||||
| 34 | Variant Code | nvarchar(20) | ||||
| 35 | Service Order Line No_ | int | ||||
| 36 | Dimension Set ID | int | ||||
| 37 | $systemId | uniqueidentifier | ||||
| 38 | $systemCreatedAt | datetime | ||||
| 39 | $systemCreatedBy | uniqueidentifier | ||||
| 40 | $systemModifiedAt | datetime | ||||
| 41 | $systemModifiedBy | uniqueidentifier | ||||