Whse_ Internal Pick Line

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

Table Type: Company

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

Table Number: 7334

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 Whse_ Internal Pick Line can be queried.

Show/hide an example select of all columns

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

Show/hide an example select of all columns by name

SELECT
   [timestamp]
   ,[No_]
   ,[Line No_]
   ,[Location Code]
   ,[Shelf No_]
   ,[To Bin Code]
   ,[To Zone Code]
   ,[Item No_]
   ,[Quantity]
   ,[Qty_ (Base)]
   ,[Qty_ Outstanding]
   ,[Qty_ Outstanding (Base)]
   ,[Qty_ Picked]
   ,[Qty_ Picked (Base)]
   ,[Unit of Measure Code]
   ,[Qty_ per Unit of Measure]
   ,[Variant Code]
   ,[Description]
   ,[Description 2]
   ,[Status]
   ,[Sorting Sequence No_]
   ,[Due Date]
   ,[Cubage]
   ,[Weight]
   ,[$systemId]
   ,[$systemCreatedAt]
   ,[$systemCreatedBy]
   ,[$systemModifiedAt]
   ,[$systemModifiedBy]
FROM
   [CRONUS UK Ltd_$Whse_ Internal Pick 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_$Whse_ Internal Pick Line$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Whse_ Internal Pick Line]
LEFT JOIN
   [CRONUS UK Ltd_$Location$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Location]
      ON
         [Whse_ Internal Pick Line].[Location Code] = [Location].[Code]
LEFT JOIN
   [CRONUS UK Ltd_$Item$c526b3e9-b8ca-4683-81ba-fcd5f6b1472a] AS [Item]
      ON
         [Whse_ Internal Pick Line].[Item No_] = [Item].[No_]
LEFT JOIN
   [CRONUS UK Ltd_$Unit of Measure$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Unit of Measure]
      ON
         [Whse_ Internal Pick Line].[Unit of Measure Code] = [Unit of Measure].[Code]

Show/hide columns in Whse_ Internal Pick Line table

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

Show/hide example query

SELECT
       [Whse_ Internal Pick Line].[Location Code]
       ,[Location].[Code]
FROM
       [CRONUS UK Ltd_$Whse_ Internal Pick Line$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Whse_ Internal Pick Line]
LEFT JOIN
       [CRONUS UK Ltd_$Location$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Location]
              ON
                     [Whse_ Internal Pick Line].[Location Code] = [Location].[Code]
5Shelf No_ Searchnvarchar(20)
6To Bin Code Searchnvarchar(40)
7To Zone Code Searchnvarchar(20)
8Item No_ Searchnvarchar(40)
Key to join to the Item table.

Show/hide example query

SELECT
       [Whse_ Internal Pick Line].[Item No_]
       ,[Item].[No_]
FROM
       [CRONUS UK Ltd_$Whse_ Internal Pick Line$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Whse_ Internal Pick Line]
LEFT JOIN
       [CRONUS UK Ltd_$Item$c526b3e9-b8ca-4683-81ba-fcd5f6b1472a] AS [Item]
              ON
                     [Whse_ Internal Pick Line].[Item No_] = [Item].[No_]
9Quantity Searchdecimal(38,38)
10Qty_ (Base) Searchdecimal(38,38)
11Qty_ Outstanding Searchdecimal(38,38)
12Qty_ Outstanding (Base) Searchdecimal(38,38)
13Qty_ Picked Searchdecimal(38,38)
14Qty_ Picked (Base) Searchdecimal(38,38)
15Unit of Measure Code Searchnvarchar(20)
Key to join to the Unit of Measure table.

Show/hide example query

SELECT
       [Whse_ Internal Pick Line].[Unit of Measure Code]
       ,[Unit of Measure].[Code]
FROM
       [CRONUS UK Ltd_$Whse_ Internal Pick Line$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Whse_ Internal Pick Line]
LEFT JOIN
       [CRONUS UK Ltd_$Unit of Measure$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Unit of Measure]
              ON
                     [Whse_ Internal Pick Line].[Unit of Measure Code] = [Unit of Measure].[Code]
16Qty_ per Unit of Measure Searchdecimal(38,38)
17Variant Code Searchnvarchar(20)
18Description Searchnvarchar(200)
19Description 2 Searchnvarchar(100)
20Status Searchint
21Sorting Sequence No_ Searchint
22Due Date Searchdatetime
23Cubage Searchdecimal(38,38)
24Weight Searchdecimal(38,38)
25$systemId Searchuniqueidentifier
26$systemCreatedAt Searchdatetime
27$systemCreatedBy Searchuniqueidentifier
28$systemModifiedAt Searchdatetime
29$systemModifiedBy Searchuniqueidentifier

Show/hide tables related from Whse_ Internal Pick Line table

Leave a Reply

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