Sales Shipment Line

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

Table Type: Company

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

Table Number: 0

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

Show/hide an example select of all columns

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

Show/hide an example select of all columns by name

SELECT
   [timestamp]
   ,[Document No_]
   ,[Line No_]
   ,[Sell-to Customer No_]
   ,[Type]
   ,[No_]
   ,[Location Code]
   ,[Posting Group]
   ,[Shipment Date]
   ,[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]
   ,[Job No_]
   ,[Work Type Code]
   ,[Qty_ Shipped Not Invoiced]
   ,[Quantity Invoiced]
   ,[Order No_]
   ,[Order Line No_]
   ,[Bill-to Customer No_]
   ,[Purchase Order No_]
   ,[Purch_ Order Line No_]
   ,[Drop Shipment]
   ,[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]
   ,[Blanket Order No_]
   ,[Blanket Order Line No_]
   ,[VAT Base Amount]
   ,[Unit Cost]
   ,[IC Partner Ref_ Type]
   ,[IC Partner Reference]
   ,[Posting Date]
   ,[IC Item Reference No_]
   ,[Dimension Set ID]
   ,[Authorized for Credit Card]
   ,[Job Task No_]
   ,[Job Contract Entry No_]
   ,[Variant Code]
   ,[Bin Code]
   ,[Qty_ per Unit of Measure]
   ,[Unit of Measure Code]
   ,[Quantity (Base)]
   ,[Qty_ Invoiced (Base)]
   ,[FA Posting Date]
   ,[Depreciation Book Code]
   ,[Depr_ until FA Posting Date]
   ,[Duplicate in Depreciation Book]
   ,[Use Duplication List]
   ,[Responsibility Center]
   ,[Cross-Reference No_]
   ,[Unit of Measure (Cross Ref_)]
   ,[Cross-Reference Type]
   ,[Cross-Reference Type No_]
   ,[Item Category Code]
   ,[Nonstock]
   ,[Purchasing Code]
   ,[Product Group Code]
   ,[Item Reference No_]
   ,[Item Reference Unit of Measure]
   ,[Item Reference Type]
   ,[Item Reference Type No_]
   ,[Requested Delivery Date]
   ,[Promised Delivery Date]
   ,[Shipping Time]
   ,[Outbound Whse_ Handling Time]
   ,[Planned Delivery Date]
   ,[Planned Shipment Date]
   ,[Appl_-from Item Entry]
   ,[Item Charge Base Amount]
   ,[Correction]
   ,[Return Reason Code]
   ,[Price Calculation Method]
   ,[Allow Line Disc_]
   ,[Customer Disc_ Group]
   ,[Document Id]
   ,[$systemId]
   ,[$systemCreatedAt]
   ,[$systemCreatedBy]
   ,[$systemModifiedAt]
   ,[$systemModifiedBy]
FROM
   [CRONUS UK Ltd_$Sales 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_$Sales Shipment Line$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Sales Shipment Line]
LEFT JOIN
   [CRONUS UK Ltd_$Customer$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Customer]
      ON
         [Sales Shipment Line].[Sell-to Customer No_] = [Customer].[No_]
LEFT JOIN
   [CRONUS UK Ltd_$Location$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Location]
      ON
         [Sales Shipment Line].[Location Code] = [Location].[Code]
LEFT JOIN
   [CRONUS UK Ltd_$Customer Price Group$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Customer Price Group]
      ON
         [Sales Shipment Line].[Customer Price Group] = [Customer Price Group].[Code]
LEFT JOIN
   [CRONUS UK Ltd_$Job$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Job]
      ON
         [Sales Shipment Line].[Job No_] = [Job].[Job No_]
LEFT JOIN
   [CRONUS UK Ltd_$Customer$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Customer]
      ON
         [Sales Shipment Line].[Bill-to Customer No_] = [Customer].[No_]
LEFT JOIN
   [CRONUS UK Ltd_$Tax Area$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Tax Area]
      ON
         [Sales Shipment Line].[Tax Area Code] = [Tax Area].[Code]
LEFT JOIN
   [CRONUS UK Ltd_$Tax Group$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Tax Group]
      ON
         [Sales Shipment Line].[Tax Group Code] = [Tax Group].[Code]
LEFT JOIN
   [CRONUS UK Ltd_$Job Task$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Job Task]
      ON
         [Sales Shipment Line].[Job Task No_] = [Job Task].[Job Task No_]
LEFT JOIN
   [CRONUS UK Ltd_$Unit of Measure$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Unit of Measure]
      ON
         [Sales 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
         [Sales Shipment Line].[Item Category Code] = [Item Category].[Code]
LEFT JOIN
   [CRONUS UK Ltd_$Product Group$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Product Group]
      ON
         [Sales 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
         [Sales Shipment Line].[Customer Disc_ Group] = [Customer Discount Group].[No_]

Show/hide columns in Sales Shipment Line table

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

Show/hide example query

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

Show/hide example query

SELECT
       [Sales Shipment Line].[Customer Price Group]
       ,[Customer Price Group].[Code]
FROM
       [CRONUS UK Ltd_$Sales Shipment Line$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Sales Shipment Line]
LEFT JOIN
       [CRONUS UK Ltd_$Customer Price Group$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Customer Price Group]
              ON
                     [Sales Shipment Line].[Customer Price Group] = [Customer Price Group].[Code]
28Job No_ Searchnvarchar(40)
Key to join to the Job table.

Show/hide example query

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

Show/hide example query

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

Show/hide example query

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

Show/hide example query

SELECT
       [Sales Shipment Line].[Tax Group Code]
       ,[Tax Group].[Code]
FROM
       [CRONUS UK Ltd_$Sales Shipment Line$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Sales Shipment Line]
LEFT JOIN
       [CRONUS UK Ltd_$Tax Group$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Tax Group]
              ON
                     [Sales Shipment Line].[Tax Group Code] = [Tax Group].[Code]
50VAT Bus_ Posting Group Searchnvarchar(40)
51VAT Prod_ Posting Group Searchnvarchar(40)
52Blanket Order No_ Searchnvarchar(40)
53Blanket Order Line No_ Searchint
54VAT Base Amount Searchdecimal(38,38)
55Unit Cost Searchdecimal(38,38)
56IC Partner Ref_ Type Searchint
57IC Partner Reference Searchnvarchar(40)
58Posting Date Searchdatetime
59IC Item Reference No_ Searchnvarchar(100)
60Dimension Set ID Searchint
61Authorized for Credit Card Searchtinyint
62Job Task No_ Searchnvarchar(40)
Key to join to the Job Task table.

Show/hide example query

SELECT
       [Sales Shipment Line].[Job Task No_]
       ,[Job Task].[Job Task No_]
FROM
       [CRONUS UK Ltd_$Sales Shipment Line$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Sales Shipment Line]
LEFT JOIN
       [CRONUS UK Ltd_$Job Task$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Job Task]
              ON
                     [Sales Shipment Line].[Job Task No_] = [Job Task].[Job Task No_]
63Job Contract Entry No_ Searchint
64Variant Code Searchnvarchar(20)
65Bin Code Searchnvarchar(40)
66Qty_ per Unit of Measure Searchdecimal(38,38)
67Unit of Measure Code Searchnvarchar(20)
Key to join to the Unit of Measure table.

Show/hide example query

SELECT
       [Sales Shipment Line].[Unit of Measure Code]
       ,[Unit of Measure].[Code]
FROM
       [CRONUS UK Ltd_$Sales Shipment Line$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Sales Shipment Line]
LEFT JOIN
       [CRONUS UK Ltd_$Unit of Measure$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Unit of Measure]
              ON
                     [Sales Shipment Line].[Unit of Measure Code] = [Unit of Measure].[Code]
68Quantity (Base) Searchdecimal(38,38)
69Qty_ Invoiced (Base) Searchdecimal(38,38)
70FA Posting Date Searchdatetime
71Depreciation Book Code Searchnvarchar(20)
72Depr_ until FA Posting Date Searchtinyint
73Duplicate in Depreciation Book Searchnvarchar(20)
74Use Duplication List Searchtinyint
75Responsibility Center Searchnvarchar(20)
76Cross-Reference No_ Searchnvarchar(40)
77Unit of Measure (Cross Ref_) Searchnvarchar(20)
78Cross-Reference Type Searchint
79Cross-Reference Type No_ Searchnvarchar(60)
80Item Category Code Searchnvarchar(40)
Key to join to the Item Category table.

Show/hide example query

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

Show/hide example query

SELECT
       [Sales Shipment Line].[Product Group Code]
       ,[Product Group].[Code]
FROM
       [CRONUS UK Ltd_$Sales Shipment Line$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Sales Shipment Line]
LEFT JOIN
       [CRONUS UK Ltd_$Product Group$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Product Group]
              ON
                     [Sales Shipment Line].[Product Group Code] = [Product Group].[Code]
84Item Reference No_ Searchnvarchar(100)
85Item Reference Unit of Measure Searchnvarchar(20)
86Item Reference Type Searchint
87Item Reference Type No_ Searchnvarchar(60)
88Requested Delivery Date Searchdatetime
89Promised Delivery Date Searchdatetime
90Shipping Time Searchvarchar(32)
91Outbound Whse_ Handling Time Searchvarchar(32)
92Planned Delivery Date Searchdatetime
93Planned Shipment Date Searchdatetime
94Appl_-from Item Entry Searchint
95Item Charge Base Amount Searchdecimal(38,38)
96Correction Searchtinyint
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
       [Sales Shipment Line].[Customer Disc_ Group]
       ,[Customer Discount Group].[No_]
FROM
       [CRONUS UK Ltd_$Sales Shipment Line$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Sales Shipment Line]
LEFT JOIN
       [CRONUS UK Ltd_$Customer Discount Group$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Customer Discount Group]
              ON
                     [Sales Shipment Line].[Customer Disc_ Group] = [Customer Discount Group].[No_]
101Document Id Searchuniqueidentifier
102$systemId Searchuniqueidentifier
103$systemCreatedAt Searchdatetime
104$systemCreatedBy Searchuniqueidentifier
105$systemModifiedAt Searchdatetime
106$systemModifiedBy Searchuniqueidentifier

Show/hide tables related from Sales Shipment Line table

Leave a Reply

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