Sales Shipment Line – Dynamics 365 BC Table Reference

Dynamics 365 BC Table Reference Tables Company Tables SSales 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 ID	Column Name	Data Type
1	timestamp	timestamp
2	Document No_	nvarchar(40)
3	Line No_	int
4	Sell-to Customer No_	nvarchar(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_]
5	Type	int
6	No_	nvarchar(40)
7	Location Code	nvarchar(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]
8	Posting Group	nvarchar(40)
9	Shipment Date	datetime
10	Description	nvarchar(200)
11	Description 2	nvarchar(100)
12	Unit of Measure	nvarchar(100)
13	Quantity	decimal(38,38)
14	Unit Price	decimal(38,38)
15	Unit Cost (LCY)	decimal(38,38)
16	VAT _	decimal(38,38)
17	Line Discount _	decimal(38,38)
18	Allow Invoice Disc_	tinyint
19	Gross Weight	decimal(38,38)
20	Net Weight	decimal(38,38)
21	Units per Parcel	decimal(38,38)
22	Unit Volume	decimal(38,38)
23	Appl_-to Item Entry	int
24	Item Shpt_ Entry No_	int
25	Shortcut Dimension 1 Code	nvarchar(40)
26	Shortcut Dimension 2 Code	nvarchar(40)
27	Customer Price Group	nvarchar(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]
28	Job No_	nvarchar(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_]
29	Work Type Code	nvarchar(20)
30	Qty_ Shipped Not Invoiced	decimal(38,38)
31	Quantity Invoiced	decimal(38,38)
32	Order No_	nvarchar(40)
33	Order Line No_	int
34	Bill-to Customer No_	nvarchar(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_]
35	Purchase Order No_	nvarchar(40)
36	Purch_ Order Line No_	int
37	Drop Shipment	tinyint
38	Gen_ Bus_ Posting Group	nvarchar(40)
39	Gen_ Prod_ Posting Group	nvarchar(40)
40	VAT Calculation Type	int
41	Transaction Type	nvarchar(20)
42	Transport Method	nvarchar(20)
43	Attached to Line No_	int
44	Exit Point	nvarchar(20)
45	Area	nvarchar(20)
46	Transaction Specification	nvarchar(20)
47	Tax Area Code	nvarchar(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]
48	Tax Liable	tinyint
49	Tax Group Code	nvarchar(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]
50	VAT Bus_ Posting Group	nvarchar(40)
51	VAT Prod_ Posting Group	nvarchar(40)
52	Blanket Order No_	nvarchar(40)
53	Blanket Order Line No_	int
54	VAT Base Amount	decimal(38,38)
55	Unit Cost	decimal(38,38)
56	IC Partner Ref_ Type	int
57	IC Partner Reference	nvarchar(40)
58	Posting Date	datetime
59	IC Item Reference No_	nvarchar(100)
60	Dimension Set ID	int
61	Authorized for Credit Card	tinyint
62	Job Task No_	nvarchar(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_]
63	Job Contract Entry No_	int
64	Variant Code	nvarchar(20)
65	Bin Code	nvarchar(40)
66	Qty_ per Unit of Measure	decimal(38,38)
67	Unit of Measure Code	nvarchar(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]
68	Quantity (Base)	decimal(38,38)
69	Qty_ Invoiced (Base)	decimal(38,38)
70	FA Posting Date	datetime
71	Depreciation Book Code	nvarchar(20)
72	Depr_ until FA Posting Date	tinyint
73	Duplicate in Depreciation Book	nvarchar(20)
74	Use Duplication List	tinyint
75	Responsibility Center	nvarchar(20)
76	Cross-Reference No_	nvarchar(40)
77	Unit of Measure (Cross Ref_)	nvarchar(20)
78	Cross-Reference Type	int
79	Cross-Reference Type No_	nvarchar(60)
80	Item Category Code	nvarchar(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]
81	Nonstock	tinyint
82	Purchasing Code	nvarchar(20)
83	Product Group Code	nvarchar(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]
84	Item Reference No_	nvarchar(100)
85	Item Reference Unit of Measure	nvarchar(20)
86	Item Reference Type	int
87	Item Reference Type No_	nvarchar(60)
88	Requested Delivery Date	datetime
89	Promised Delivery Date	datetime
90	Shipping Time	varchar(32)
91	Outbound Whse_ Handling Time	varchar(32)
92	Planned Delivery Date	datetime
93	Planned Shipment Date	datetime
94	Appl_-from Item Entry	int
95	Item Charge Base Amount	decimal(38,38)
96	Correction	tinyint
97	Return Reason Code	nvarchar(20)
98	Price Calculation Method	int
99	Allow Line Disc_	tinyint
100	Customer Disc_ Group	nvarchar(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_]
101	Document Id	uniqueidentifier
102	$systemId	uniqueidentifier
103	$systemCreatedAt	datetime
104	$systemCreatedBy	uniqueidentifier
105	$systemModifiedAt	datetime
106	$systemModifiedBy	uniqueidentifier

Show/hide tables related from Sales Shipment Line table

Customer Customer Discount Group Customer Price Group Item Category Job Job Task Location Product Group Tax Area Tax Group Unit of Measure

Dynamics 365 BC Table Reference Tables Company Tables SSales Shipment Line

Leave a Reply Cancel reply