Posted Invt_ Pick Header

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

Table Type: Company

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

Table Number: 7342

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_ Pick Header can be queried.

Show/hide an example select of all columns

SELECT
   *
FROM
   [CRONUS UK Ltd_$Posted Invt_ Pick 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 Pick No_]
   ,[No_ Printed]
   ,[Posting Date]
   ,[Source No_]
   ,[Source Document]
   ,[Source Type]
   ,[Source Subtype]
   ,[Destination Type]
   ,[Destination No_]
   ,[External Document No_]
   ,[Shipment Date]
   ,[External Document No_2]
   ,[$systemId]
   ,[$systemCreatedAt]
   ,[$systemCreatedBy]
   ,[$systemModifiedAt]
   ,[$systemModifiedBy]
FROM
   [CRONUS UK Ltd_$Posted Invt_ Pick 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_ Pick Header$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Posted Invt_ Pick Header]
LEFT JOIN
   [CRONUS UK Ltd_$Location$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Location]
      ON
         [Posted Invt_ Pick Header].[Location Code] = [Location].[Code]

Show/hide columns in Posted Invt_ Pick 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_ Pick Header].[Location Code]
       ,[Location].[Code]
FROM
       [CRONUS UK Ltd_$Posted Invt_ Pick Header$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Posted Invt_ Pick Header]
LEFT JOIN
       [CRONUS UK Ltd_$Location$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Location]
              ON
                     [Posted Invt_ Pick Header].[Location Code] = [Location].[Code]
4Assigned User ID Searchnvarchar(100)
5Assignment Date Searchdatetime
6Assignment Time Searchdatetime
7Registering Date Searchdatetime
8No_ Series Searchnvarchar(40)
9Invt Pick 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)
19Shipment 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_ Pick Header table

Leave a Reply

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