Whse_ Internal Put-away Line

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

Table Type: Company

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

Table Number: 7332

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 Put-away Line can be queried.

Show/hide an example select of all columns

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

Show/hide columns in Whse_ Internal Put-away 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 Put-away Line].[Location Code]
       ,[Location].[Code]
FROM
       [CRONUS UK Ltd_$Whse_ Internal Put-away Line$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Whse_ Internal Put-away Line]
LEFT JOIN
       [CRONUS UK Ltd_$Location$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Location]
              ON
                     [Whse_ Internal Put-away Line].[Location Code] = [Location].[Code]
5Shelf No_ Searchnvarchar(20)
6From Bin Code Searchnvarchar(40)
7From Zone Code Searchnvarchar(20)
8Item No_ Searchnvarchar(40)
Key to join to the Item table.

Show/hide example query

SELECT
       [Whse_ Internal Put-away Line].[Item No_]
       ,[Item].[No_]
FROM
       [CRONUS UK Ltd_$Whse_ Internal Put-away Line$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Whse_ Internal Put-away Line]
LEFT JOIN
       [CRONUS UK Ltd_$Item$c526b3e9-b8ca-4683-81ba-fcd5f6b1472a] AS [Item]
              ON
                     [Whse_ Internal Put-away 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_ Put Away Searchdecimal(38,38)
14Qty_ Put Away (Base) Searchdecimal(38,38)
15Status Searchint
16Unit of Measure Code Searchnvarchar(20)
Key to join to the Unit of Measure table.

Show/hide example query

SELECT
       [Whse_ Internal Put-away Line].[Unit of Measure Code]
       ,[Unit of Measure].[Code]
FROM
       [CRONUS UK Ltd_$Whse_ Internal Put-away Line$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Whse_ Internal Put-away Line]
LEFT JOIN
       [CRONUS UK Ltd_$Unit of Measure$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Unit of Measure]
              ON
                     [Whse_ Internal Put-away 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)
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 Put-away Line table

Leave a Reply

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