Service Shipment Line

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

Table Type: Company

Table Name: Service Shipment Line
Database Table Name: CRONUS UK Ltd_$Service Shipment Line$437dbf0e-84ff-417a-965d-ed2bb9650972

Table Number: 5991

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 Shipment Line can be queried.

Show/hide an example select of all columns

SELECT
   *
FROM
   [CRONUS UK Ltd_$Service Shipment Line$437dbf0e-84ff-417a-965d-ed2bb9650972]

Show/hide an example select of all columns by name

SELECT
   [timestamp]
   ,[Document No_]
   ,[Line No_]
   ,[Customer No_]
   ,[Type]
   ,[No_]
   ,[Location Code]
   ,[Posting Group]
   ,[Description]
   ,[Description 2]
   ,[Unit of Measure]
   ,[Quantity]
   ,[Unit Price]
   ,[Unit Cost (LCY)]
   ,[VAT _]
   ,[Line Discount _]
   ,[Allow Invoice Disc_]
   ,[Gross Weight]
   ,[Net Weight]
   ,[Units per Parcel]
   ,[Unit Volume]
   ,[Appl_-to Item Entry]
   ,[Item Shpt_ Entry No_]
   ,[Shortcut Dimension 1 Code]
   ,[Shortcut Dimension 2 Code]
   ,[Customer Price Group]
   ,[Work Type Code]
   ,[Qty_ Shipped Not Invoiced]
   ,[Quantity Invoiced]
   ,[Order No_]
   ,[Order Line No_]
   ,[Bill-to Customer No_]
   ,[Gen_ Bus_ Posting Group]
   ,[Gen_ Prod_ Posting Group]
   ,[VAT Calculation Type]
   ,[Transaction Type]
   ,[Transport Method]
   ,[Attached to Line No_]
   ,[Exit Point]
   ,[Area]
   ,[Transaction Specification]
   ,[Tax Area Code]
   ,[Tax Liable]
   ,[Tax Group Code]
   ,[VAT Bus_ Posting Group]
   ,[VAT Prod_ Posting Group]
   ,[Currency Code]
   ,[VAT Base Amount]
   ,[Unit Cost]
   ,[Dimension Set ID]
   ,[Time Sheet No_]
   ,[Time Sheet Line No_]
   ,[Time Sheet Date]
   ,[Variant Code]
   ,[Bin Code]
   ,[Qty_ per Unit of Measure]
   ,[Unit of Measure Code]
   ,[Quantity (Base)]
   ,[Qty_ Shipped Not Invd_ (Base)]
   ,[Qty_ Invoiced (Base)]
   ,[Responsibility Center]
   ,[Item Category Code]
   ,[Nonstock]
   ,[Product Group Code]
   ,[Correction]
   ,[Appl_-to Warranty Entry]
   ,[Service Item No_]
   ,[Appl_-to Service Entry]
   ,[Service Item Line No_]
   ,[Service Item Serial No_]
   ,[Service Item Line Description]
   ,[Posting Date]
   ,[Order Date]
   ,[Needed by Date]
   ,[Ship-to Code]
   ,[Quantity Consumed]
   ,[Qty_ Consumed (Base)]
   ,[Service Price Group Code]
   ,[Fault Area Code]
   ,[Symptom Code]
   ,[Fault Code]
   ,[Resolution Code]
   ,[Exclude Warranty]
   ,[Warranty]
   ,[Contract No_]
   ,[Contract Disc_ _]
   ,[Warranty Disc_ _]
   ,[Component Line No_]
   ,[Spare Part Action]
   ,[Fault Reason Code]
   ,[Replaced Item No_]
   ,[Exclude Contract Discount]
   ,[Replaced Item Type]
   ,[Price Adjmt_ Status]
   ,[Line Discount Type]
   ,[Copy Components From]
   ,[Return Reason Code]
   ,[Price Calculation Method]
   ,[Allow Line Disc_]
   ,[Customer Disc_ Group]
   ,[$systemId]
   ,[$systemCreatedAt]
   ,[$systemCreatedBy]
   ,[$systemModifiedAt]
   ,[$systemModifiedBy]
FROM
   [CRONUS UK Ltd_$Service Shipment Line$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 Shipment Line$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Service Shipment Line]
LEFT JOIN
   [CRONUS UK Ltd_$Customer$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Customer]
      ON
         [Service Shipment Line].[Customer No_] = [Customer].[No_]
LEFT JOIN
   [CRONUS UK Ltd_$Location$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Location]
      ON
         [Service Shipment Line].[Location Code] = [Location].[Code]
LEFT JOIN
   [CRONUS UK Ltd_$Customer Price Group$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Customer Price Group]
      ON
         [Service Shipment Line].[Customer Price Group] = [Customer Price Group].[Code]
LEFT JOIN
   [CRONUS UK Ltd_$Customer$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Customer]
      ON
         [Service Shipment Line].[Bill-to Customer No_] = [Customer].[No_]
LEFT JOIN
   [CRONUS UK Ltd_$Tax Area$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Tax Area]
      ON
         [Service Shipment Line].[Tax Area Code] = [Tax Area].[Code]
LEFT JOIN
   [CRONUS UK Ltd_$Tax Group$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Tax Group]
      ON
         [Service Shipment Line].[Tax Group Code] = [Tax Group].[Code]
LEFT JOIN
   [CRONUS UK Ltd_$Currency$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Currency]
      ON
         [Service Shipment Line].[Currency Code] = [Currency].[Code]
LEFT JOIN
   [CRONUS UK Ltd_$Unit of Measure$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Unit of Measure]
      ON
         [Service Shipment Line].[Unit of Measure Code] = [Unit of Measure].[Code]
LEFT JOIN
   [CRONUS UK Ltd_$Item Category$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Item Category]
      ON
         [Service Shipment Line].[Item Category Code] = [Item Category].[Code]
LEFT JOIN
   [CRONUS UK Ltd_$Product Group$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Product Group]
      ON
         [Service Shipment Line].[Product Group Code] = [Product Group].[Code]
LEFT JOIN
   [CRONUS UK Ltd_$Customer Discount Group$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Customer Discount Group]
      ON
         [Service Shipment Line].[Customer Disc_ Group] = [Customer Discount Group].[No_]

Show/hide columns in Service Shipment Line table

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

Show/hide example query

SELECT
       [Service Shipment Line].[Customer No_]
       ,[Customer].[No_]
FROM
       [CRONUS UK Ltd_$Service Shipment Line$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Service Shipment Line]
LEFT JOIN
       [CRONUS UK Ltd_$Customer$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Customer]
              ON
                     [Service Shipment Line].[Customer No_] = [Customer].[No_]
5Type Searchint
6No_ Searchnvarchar(40)
7Location Code Searchnvarchar(20)
Key to join to the Location table.

Show/hide example query

SELECT
       [Service Shipment Line].[Location Code]
       ,[Location].[Code]
FROM
       [CRONUS UK Ltd_$Service Shipment Line$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Service Shipment Line]
LEFT JOIN
       [CRONUS UK Ltd_$Location$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Location]
              ON
                     [Service Shipment Line].[Location Code] = [Location].[Code]
8Posting Group Searchnvarchar(40)
9Description Searchnvarchar(200)
10Description 2 Searchnvarchar(100)
11Unit of Measure Searchnvarchar(100)
12Quantity Searchdecimal(38,38)
13Unit Price Searchdecimal(38,38)
14Unit Cost (LCY) Searchdecimal(38,38)
15VAT _ Searchdecimal(38,38)
16Line Discount _ Searchdecimal(38,38)
17Allow Invoice Disc_ Searchtinyint
18Gross Weight Searchdecimal(38,38)
19Net Weight Searchdecimal(38,38)
20Units per Parcel Searchdecimal(38,38)
21Unit Volume Searchdecimal(38,38)
22Appl_-to Item Entry Searchint
23Item Shpt_ Entry No_ Searchint
24Shortcut Dimension 1 Code Searchnvarchar(40)
25Shortcut Dimension 2 Code Searchnvarchar(40)
26Customer Price Group Searchnvarchar(20)
Key to join to the Customer Price Group table.

Show/hide example query

SELECT
       [Service Shipment Line].[Customer Price Group]
       ,[Customer Price Group].[Code]
FROM
       [CRONUS UK Ltd_$Service Shipment Line$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Service Shipment Line]
LEFT JOIN
       [CRONUS UK Ltd_$Customer Price Group$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Customer Price Group]
              ON
                     [Service Shipment Line].[Customer Price Group] = [Customer Price Group].[Code]
27Work Type Code Searchnvarchar(20)
28Qty_ Shipped Not Invoiced Searchdecimal(38,38)
29Quantity Invoiced Searchdecimal(38,38)
30Order No_ Searchnvarchar(40)
31Order Line No_ Searchint
32Bill-to Customer No_ Searchnvarchar(40)
Key to join to the Customer table.

Show/hide example query

SELECT
       [Service Shipment Line].[Bill-to Customer No_]
       ,[Customer].[No_]
FROM
       [CRONUS UK Ltd_$Service Shipment Line$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Service Shipment Line]
LEFT JOIN
       [CRONUS UK Ltd_$Customer$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Customer]
              ON
                     [Service Shipment Line].[Bill-to Customer No_] = [Customer].[No_]
33Gen_ Bus_ Posting Group Searchnvarchar(40)
34Gen_ Prod_ Posting Group Searchnvarchar(40)
35VAT Calculation Type Searchint
36Transaction Type Searchnvarchar(20)
37Transport Method Searchnvarchar(20)
38Attached to Line No_ Searchint
39Exit Point Searchnvarchar(20)
40Area Searchnvarchar(20)
41Transaction Specification Searchnvarchar(20)
42Tax Area Code Searchnvarchar(40)
Key to join to the Tax Area table.

Show/hide example query

SELECT
       [Service Shipment Line].[Tax Area Code]
       ,[Tax Area].[Code]
FROM
       [CRONUS UK Ltd_$Service Shipment Line$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Service Shipment Line]
LEFT JOIN
       [CRONUS UK Ltd_$Tax Area$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Tax Area]
              ON
                     [Service Shipment Line].[Tax Area Code] = [Tax Area].[Code]
43Tax Liable Searchtinyint
44Tax Group Code Searchnvarchar(40)
Key to join to the Tax Group table.

Show/hide example query

SELECT
       [Service Shipment Line].[Tax Group Code]
       ,[Tax Group].[Code]
FROM
       [CRONUS UK Ltd_$Service Shipment Line$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Service Shipment Line]
LEFT JOIN
       [CRONUS UK Ltd_$Tax Group$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Tax Group]
              ON
                     [Service Shipment Line].[Tax Group Code] = [Tax Group].[Code]
45VAT Bus_ Posting Group Searchnvarchar(40)
46VAT Prod_ Posting Group Searchnvarchar(40)
47Currency Code Searchnvarchar(20)
Key to join to the Currency table.

Show/hide example query

SELECT
       [Service Shipment Line].[Currency Code]
       ,[Currency].[Code]
FROM
       [CRONUS UK Ltd_$Service Shipment Line$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Service Shipment Line]
LEFT JOIN
       [CRONUS UK Ltd_$Currency$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Currency]
              ON
                     [Service Shipment Line].[Currency Code] = [Currency].[Code]
48VAT Base Amount Searchdecimal(38,38)
49Unit Cost Searchdecimal(38,38)
50Dimension Set ID Searchint
51Time Sheet No_ Searchnvarchar(40)
52Time Sheet Line No_ Searchint
53Time Sheet Date Searchdatetime
54Variant Code Searchnvarchar(20)
55Bin Code Searchnvarchar(40)
56Qty_ per Unit of Measure Searchdecimal(38,38)
57Unit of Measure Code Searchnvarchar(20)
Key to join to the Unit of Measure table.

Show/hide example query

SELECT
       [Service Shipment Line].[Unit of Measure Code]
       ,[Unit of Measure].[Code]
FROM
       [CRONUS UK Ltd_$Service Shipment Line$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Service Shipment Line]
LEFT JOIN
       [CRONUS UK Ltd_$Unit of Measure$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Unit of Measure]
              ON
                     [Service Shipment Line].[Unit of Measure Code] = [Unit of Measure].[Code]
58Quantity (Base) Searchdecimal(38,38)
59Qty_ Shipped Not Invd_ (Base) Searchdecimal(38,38)
60Qty_ Invoiced (Base) Searchdecimal(38,38)
61Responsibility Center Searchnvarchar(20)
62Item Category Code Searchnvarchar(40)
Key to join to the Item Category table.

Show/hide example query

SELECT
       [Service Shipment Line].[Item Category Code]
       ,[Item Category].[Code]
FROM
       [CRONUS UK Ltd_$Service Shipment Line$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Service Shipment Line]
LEFT JOIN
       [CRONUS UK Ltd_$Item Category$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Item Category]
              ON
                     [Service Shipment Line].[Item Category Code] = [Item Category].[Code]
63Nonstock Searchtinyint
64Product Group Code Searchnvarchar(20)
Key to join to the Product Group table.

Show/hide example query

SELECT
       [Service Shipment Line].[Product Group Code]
       ,[Product Group].[Code]
FROM
       [CRONUS UK Ltd_$Service Shipment Line$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Service Shipment Line]
LEFT JOIN
       [CRONUS UK Ltd_$Product Group$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Product Group]
              ON
                     [Service Shipment Line].[Product Group Code] = [Product Group].[Code]
65Correction Searchtinyint
66Appl_-to Warranty Entry Searchint
67Service Item No_ Searchnvarchar(40)
68Appl_-to Service Entry Searchint
69Service Item Line No_ Searchint
70Service Item Serial No_ Searchnvarchar(100)
71Service Item Line Description Searchnvarchar(200)
72Posting Date Searchdatetime
73Order Date Searchdatetime
74Needed by Date Searchdatetime
75Ship-to Code Searchnvarchar(20)
76Quantity Consumed Searchdecimal(38,38)
77Qty_ Consumed (Base) Searchdecimal(38,38)
78Service Price Group Code Searchnvarchar(20)
79Fault Area Code Searchnvarchar(20)
80Symptom Code Searchnvarchar(20)
81Fault Code Searchnvarchar(20)
82Resolution Code Searchnvarchar(20)
83Exclude Warranty Searchtinyint
84Warranty Searchtinyint
85Contract No_ Searchnvarchar(40)
86Contract Disc_ _ Searchdecimal(38,38)
87Warranty Disc_ _ Searchdecimal(38,38)
88Component Line No_ Searchint
89Spare Part Action Searchint
90Fault Reason Code Searchnvarchar(20)
91Replaced Item No_ Searchnvarchar(40)
92Exclude Contract Discount Searchtinyint
93Replaced Item Type Searchint
94Price Adjmt_ Status Searchint
95Line Discount Type Searchint
96Copy Components From Searchint
97Return Reason Code Searchnvarchar(20)
98Price Calculation Method Searchint
99Allow Line Disc_ Searchtinyint
100Customer Disc_ Group Searchnvarchar(40)
Key to join to the Customer Discount Group table.

Show/hide example query

SELECT
       [Service Shipment Line].[Customer Disc_ Group]
       ,[Customer Discount Group].[No_]
FROM
       [CRONUS UK Ltd_$Service Shipment Line$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Service Shipment Line]
LEFT JOIN
       [CRONUS UK Ltd_$Customer Discount Group$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Customer Discount Group]
              ON
                     [Service Shipment Line].[Customer Disc_ Group] = [Customer Discount Group].[No_]
101$systemId Searchuniqueidentifier
102$systemCreatedAt Searchdatetime
103$systemCreatedBy Searchuniqueidentifier
104$systemModifiedAt Searchdatetime
105$systemModifiedBy Searchuniqueidentifier

Show/hide tables related from Service Shipment Line table

Leave a Reply

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