Posted Whse_ Shipment Line – Dynamics 365 BC Table Reference

Dynamics 365 BC Table Reference Tables Company Tables PPosted Whse_ Shipment Line

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

Table Type: Company

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

Table Number: 7323

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

Show/hide an example select of all columns

SELECT

   *

FROM

   [CRONUS UK Ltd_$Posted Whse_ Shipment Line$437dbf0e-84ff-417a-965d-ed2bb9650972]

Show/hide an example select of all columns by name

SELECT

   [timestamp]
   ,[No_]
   ,[Line No_]
   ,[Source Type]
   ,[Source Subtype]
   ,[Source No_]
   ,[Source Line No_]
   ,[Source Document]
   ,[Location Code]
   ,[Shelf No_]
   ,[Bin Code]
   ,[Zone Code]
   ,[Item No_]
   ,[Quantity]
   ,[Qty_ (Base)]
   ,[Unit of Measure Code]
   ,[Qty_ per Unit of Measure]
   ,[Variant Code]
   ,[Description]
   ,[Description 2]
   ,[Due Date]
   ,[Destination Type]
   ,[Destination No_]
   ,[Shipping Advice]
   ,[Shipment Date]
   ,[Qty_ Rounding Precision]
   ,[Qty_ Rounding Precision (Base)]
   ,[Posted Source Document]
   ,[Posted Source No_]
   ,[Posting Date]
   ,[Whse_ Shipment No_]
   ,[Whse Shipment Line No_]
   ,[$systemId]
   ,[$systemCreatedAt]
   ,[$systemCreatedBy]
   ,[$systemModifiedAt]
   ,[$systemModifiedBy]

FROM

   [CRONUS UK Ltd_$Posted Whse_ 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_$Posted Whse_ Shipment Line$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Posted Whse_ Shipment Line]
LEFT JOIN
   [CRONUS UK Ltd_$Location$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Location]
      ON
         [Posted Whse_ Shipment Line].[Location Code] = [Location].[Code]
LEFT JOIN
   [CRONUS UK Ltd_$Item$c526b3e9-b8ca-4683-81ba-fcd5f6b1472a] AS [Item]
      ON
         [Posted Whse_ Shipment Line].[Item No_] = [Item].[No_]
LEFT JOIN
   [CRONUS UK Ltd_$Unit of Measure$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Unit of Measure]
      ON
         [Posted Whse_ Shipment Line].[Unit of Measure Code] = [Unit of Measure].[Code]

Show/hide columns in Posted Whse_ Shipment Line table

Column ID	Column Name	Data Type
1	timestamp	timestamp
2	No_	nvarchar(40)
3	Line No_	int
4	Source Type	int
5	Source Subtype	int
6	Source No_	nvarchar(40)
7	Source Line No_	int
8	Source Document	int
9	Location Code	nvarchar(20)
	Key to join to the Location table. Show/hide example query SELECT [Posted Whse_ Shipment Line].[Location Code] ,[Location].[Code] FROM [CRONUS UK Ltd_$Posted Whse_ Shipment Line$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Posted Whse_ Shipment Line] LEFT JOIN [CRONUS UK Ltd_$Location$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Location] ON [Posted Whse_ Shipment Line].[Location Code] = [Location].[Code]
10	Shelf No_	nvarchar(20)
11	Bin Code	nvarchar(40)
12	Zone Code	nvarchar(20)
13	Item No_	nvarchar(40)
	Key to join to the Item table. Show/hide example query SELECT [Posted Whse_ Shipment Line].[Item No_] ,[Item].[No_] FROM [CRONUS UK Ltd_$Posted Whse_ Shipment Line$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Posted Whse_ Shipment Line] LEFT JOIN [CRONUS UK Ltd_$Item$c526b3e9-b8ca-4683-81ba-fcd5f6b1472a] AS [Item] ON [Posted Whse_ Shipment Line].[Item No_] = [Item].[No_]
14	Quantity	decimal(38,38)
15	Qty_ (Base)	decimal(38,38)
16	Unit of Measure Code	nvarchar(20)
	Key to join to the Unit of Measure table. Show/hide example query SELECT [Posted Whse_ Shipment Line].[Unit of Measure Code] ,[Unit of Measure].[Code] FROM [CRONUS UK Ltd_$Posted Whse_ Shipment Line$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Posted Whse_ Shipment Line] LEFT JOIN [CRONUS UK Ltd_$Unit of Measure$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Unit of Measure] ON [Posted Whse_ Shipment Line].[Unit of Measure Code] = [Unit of Measure].[Code]
17	Qty_ per Unit of Measure	decimal(38,38)
18	Variant Code	nvarchar(20)
19	Description	nvarchar(200)
20	Description 2	nvarchar(100)
21	Due Date	datetime
22	Destination Type	int
23	Destination No_	nvarchar(40)
24	Shipping Advice	int
25	Shipment Date	datetime
26	Qty_ Rounding Precision	decimal(38,38)
27	Qty_ Rounding Precision (Base)	decimal(38,38)
28	Posted Source Document	int
29	Posted Source No_	nvarchar(40)
30	Posting Date	datetime
31	Whse_ Shipment No_	nvarchar(40)
32	Whse Shipment Line No_	int
33	$systemId	uniqueidentifier
34	$systemCreatedAt	datetime
35	$systemCreatedBy	uniqueidentifier
36	$systemModifiedAt	datetime
37	$systemModifiedBy	uniqueidentifier

Show/hide tables related from Posted Whse_ Shipment Line table

Item Location Unit of Measure

Dynamics 365 BC Table Reference Tables Company Tables PPosted Whse_ Shipment Line

Leave a Reply Cancel reply