Put-away Template Line

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

Table Type: Company

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

Table Number: 7308

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

Show/hide an example select of all columns

SELECT
   *
FROM
   [CRONUS UK Ltd_$Put-away Template Line$437dbf0e-84ff-417a-965d-ed2bb9650972]

Show/hide an example select of all columns by name

SELECT
   [timestamp]
   ,[Put-away Template Code]
   ,[Line No_]
   ,[Description]
   ,[Find Fixed Bin]
   ,[Find Floating Bin]
   ,[Find Same Item]
   ,[Find Unit of Measure Match]
   ,[Find Bin w_ Less than Min_ Qty]
   ,[Find Empty Bin]
   ,[$systemId]
   ,[$systemCreatedAt]
   ,[$systemCreatedBy]
   ,[$systemModifiedAt]
   ,[$systemModifiedBy]
FROM
   [CRONUS UK Ltd_$Put-away Template 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_$Put-away Template Line$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Put-away Template Line]
LEFT JOIN
   [CRONUS UK Ltd_$Put-away Template Header$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Put-away Template Header]
      ON
         [Put-away Template Line].[Put-away Template Code] = [Put-away Template Header].[Code]

Show/hide columns in Put-away Template Line table

Column IDColumn NameData Type
1timestamp Searchtimestamp
2Put-away Template Code Primary Key Searchnvarchar(20)
Key to join to the Put-away Template Header table.

Show/hide example query

SELECT
       [Put-away Template Line].[Put-away Template Code]
       ,[Put-away Template Header].[Code]
FROM
       [CRONUS UK Ltd_$Put-away Template Line$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Put-away Template Line]
LEFT JOIN
       [CRONUS UK Ltd_$Put-away Template Header$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Put-away Template Header]
              ON
                     [Put-away Template Line].[Put-away Template Code] = [Put-away Template Header].[Code]
3Line No_ Primary Key Searchint
4Description Searchnvarchar(200)
5Find Fixed Bin Searchtinyint
6Find Floating Bin Searchtinyint
7Find Same Item Searchtinyint
8Find Unit of Measure Match Searchtinyint
9Find Bin w_ Less than Min_ Qty Searchtinyint
10Find Empty Bin Searchtinyint
11$systemId Searchuniqueidentifier
12$systemCreatedAt Searchdatetime
13$systemCreatedBy Searchuniqueidentifier
14$systemModifiedAt Searchdatetime
15$systemModifiedBy Searchuniqueidentifier

Show/hide tables related from Put-away Template Line table

Leave a Reply

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