Posted Invt_ Put-away Header

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

Table Type: Company

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

Table Number: 7340

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

Show/hide an example select of all columns

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

Show/hide an example select of all columns by name

SELECT
   [timestamp]
   ,[No_]
   ,[Location Code]
   ,[Assigned User ID]
   ,[Assignment Date]
   ,[Assignment Time]
   ,[Registering Date]
   ,[No_ Series]
   ,[Invt_ Put-away No_]
   ,[No_ Printed]
   ,[Posting Date]
   ,[Source No_]
   ,[Source Document]
   ,[Source Type]
   ,[Source Subtype]
   ,[Destination Type]
   ,[Destination No_]
   ,[External Document No_]
   ,[Expected Receipt Date]
   ,[External Document No_2]
   ,[$systemId]
   ,[$systemCreatedAt]
   ,[$systemCreatedBy]
   ,[$systemModifiedAt]
   ,[$systemModifiedBy]
FROM
   [CRONUS UK Ltd_$Posted Invt_ Put-away Header$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 Invt_ Put-away Header$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Posted Invt_ Put-away Header]
LEFT JOIN
   [CRONUS UK Ltd_$Location$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Location]
      ON
         [Posted Invt_ Put-away Header].[Location Code] = [Location].[Code]

Show/hide columns in Posted Invt_ Put-away Header table

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

Show/hide example query

SELECT
       [Posted Invt_ Put-away Header].[Location Code]
       ,[Location].[Code]
FROM
       [CRONUS UK Ltd_$Posted Invt_ Put-away Header$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Posted Invt_ Put-away Header]
LEFT JOIN
       [CRONUS UK Ltd_$Location$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Location]
              ON
                     [Posted Invt_ Put-away Header].[Location Code] = [Location].[Code]
4Assigned User ID Searchnvarchar(100)
5Assignment Date Searchdatetime
6Assignment Time Searchdatetime
7Registering Date Searchdatetime
8No_ Series Searchnvarchar(40)
9Invt_ Put-away No_ Searchnvarchar(40)
10No_ Printed Searchint
11Posting Date Searchdatetime
12Source No_ Searchnvarchar(40)
13Source Document Searchint
14Source Type Searchint
15Source Subtype Searchint
16Destination Type Searchint
17Destination No_ Searchnvarchar(40)
18External Document No_ Searchnvarchar(70)
19Expected Receipt Date Searchdatetime
20External Document No_2 Searchnvarchar(70)
21$systemId Searchuniqueidentifier
22$systemCreatedAt Searchdatetime
23$systemCreatedBy Searchuniqueidentifier
24$systemModifiedAt Searchdatetime
25$systemModifiedBy Searchuniqueidentifier

Show/hide tables related from Posted Invt_ Put-away Header table

Leave a Reply

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