Posted 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 IDColumn NameData Type
1timestamp Searchtimestamp
2No_ Primary Key Searchnvarchar(40)
3Line No_ Primary Key Searchint
4Source Type Searchint
5Source Subtype Searchint
6Source No_ Searchnvarchar(40)
7Source Line No_ Searchint
8Source Document Searchint
9Location Code Searchnvarchar(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]
10Shelf No_ Searchnvarchar(20)
11Bin Code Searchnvarchar(40)
12Zone Code Searchnvarchar(20)
13Item No_ Searchnvarchar(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_]
14Quantity Searchdecimal(38,38)
15Qty_ (Base) Searchdecimal(38,38)
16Unit of Measure Code Searchnvarchar(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]
17Qty_ per Unit of Measure Searchdecimal(38,38)
18Variant Code Searchnvarchar(20)
19Description Searchnvarchar(200)
20Description 2 Searchnvarchar(100)
21Due Date Searchdatetime
22Destination Type Searchint
23Destination No_ Searchnvarchar(40)
24Shipping Advice Searchint
25Shipment Date Searchdatetime
26Qty_ Rounding Precision Searchdecimal(38,38)
27Qty_ Rounding Precision (Base) Searchdecimal(38,38)
28Posted Source Document Searchint
29Posted Source No_ Searchnvarchar(40)
30Posting Date Searchdatetime
31Whse_ Shipment No_ Searchnvarchar(40)
32Whse Shipment Line No_ Searchint
33$systemId Searchuniqueidentifier
34$systemCreatedAt Searchdatetime
35$systemCreatedBy Searchuniqueidentifier
36$systemModifiedAt Searchdatetime
37$systemModifiedBy Searchuniqueidentifier

Show/hide tables related from Posted Whse_ Shipment Line table

Leave a Reply

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