Posted Invt_ Pick Line

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

Table Type: Company

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

Table Number: 7343

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

Show/hide an example select of all columns

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

Show/hide an example select of all columns by name

SELECT
   [timestamp]
   ,[No_]
   ,[Line No_]
   ,[Source Type]
   ,[Source Subtype]
   ,[Source No_]
   ,[Source Line No_]
   ,[Source Subline No_]
   ,[Source Document]
   ,[Location Code]
   ,[Shelf No_]
   ,[Sorting Sequence No_]
   ,[Item No_]
   ,[Variant Code]
   ,[Unit of Measure Code]
   ,[Qty_ per Unit of Measure]
   ,[Description]
   ,[Description 2]
   ,[Quantity]
   ,[Qty_ (Base)]
   ,[Shipping Advice]
   ,[Due Date]
   ,[Destination Type]
   ,[Destination No_]
   ,[Whse_ Activity No_]
   ,[Shipping Agent Code]
   ,[Shipping Agent Service Code]
   ,[Shipment Method Code]
   ,[Serial No_]
   ,[Lot No_]
   ,[Warranty Date]
   ,[Expiration Date]
   ,[Package No_]
   ,[Bin Code]
   ,[Zone Code]
   ,[Action Type]
   ,[Special Equipment Code]
   ,[$systemId]
   ,[$systemCreatedAt]
   ,[$systemCreatedBy]
   ,[$systemModifiedAt]
   ,[$systemModifiedBy]
FROM
   [CRONUS UK Ltd_$Posted Invt_ 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_$Posted Invt_ Pick Line$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Posted Invt_ Pick Line]
LEFT JOIN
   [CRONUS UK Ltd_$Location$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Location]
      ON
         [Posted Invt_ Pick Line].[Location Code] = [Location].[Code]
LEFT JOIN
   [CRONUS UK Ltd_$Item$c526b3e9-b8ca-4683-81ba-fcd5f6b1472a] AS [Item]
      ON
         [Posted Invt_ Pick Line].[Item No_] = [Item].[No_]
LEFT JOIN
   [CRONUS UK Ltd_$Unit of Measure$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Unit of Measure]
      ON
         [Posted Invt_ Pick Line].[Unit of Measure Code] = [Unit of Measure].[Code]
LEFT JOIN
   [CRONUS UK Ltd_$Shipping Agent$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Shipping Agent]
      ON
         [Posted Invt_ Pick Line].[Shipping Agent Code] = [Shipping Agent].[Code]
LEFT JOIN
   [CRONUS UK Ltd_$Shipping Agent Services$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Shipping Agent Services]
      ON
         [Posted Invt_ Pick Line].[Shipping Agent Service Code] = [Shipping Agent Services].[Code]
LEFT JOIN
   [CRONUS UK Ltd_$Shipment Method$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Shipment Method]
      ON
         [Posted Invt_ Pick Line].[Shipment Method Code] = [Shipment Method].[Code]
LEFT JOIN
   [CRONUS UK Ltd_$Special Equipment$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Special Equipment]
      ON
         [Posted Invt_ Pick Line].[Special Equipment Code] = [Special Equipment].[Code]

Show/hide columns in Posted Invt_ Pick Line table

Column IDColumn NameData Type
1timestamp Searchtimestamp
2No_ Primary Key Searchnvarchar(40)
3Line No_ Primary Key Searchint
4Source Type Searchint
5Source Subtype Searchint
6Source No_ Searchnvarchar(40)
7Source Line No_ Searchint
8Source Subline No_ Searchint
9Source Document Searchint
10Location Code Searchnvarchar(20)
Key to join to the Location table.

Show/hide example query

SELECT
       [Posted Invt_ Pick Line].[Location Code]
       ,[Location].[Code]
FROM
       [CRONUS UK Ltd_$Posted Invt_ Pick Line$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Posted Invt_ Pick Line]
LEFT JOIN
       [CRONUS UK Ltd_$Location$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Location]
              ON
                     [Posted Invt_ Pick Line].[Location Code] = [Location].[Code]
11Shelf No_ Searchnvarchar(20)
12Sorting Sequence No_ Searchint
13Item No_ Searchnvarchar(40)
Key to join to the Item table.

Show/hide example query

SELECT
       [Posted Invt_ Pick Line].[Item No_]
       ,[Item].[No_]
FROM
       [CRONUS UK Ltd_$Posted Invt_ Pick Line$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Posted Invt_ Pick Line]
LEFT JOIN
       [CRONUS UK Ltd_$Item$c526b3e9-b8ca-4683-81ba-fcd5f6b1472a] AS [Item]
              ON
                     [Posted Invt_ Pick Line].[Item No_] = [Item].[No_]
14Variant Code Searchnvarchar(20)
15Unit of Measure Code Searchnvarchar(20)
Key to join to the Unit of Measure table.

Show/hide example query

SELECT
       [Posted Invt_ Pick Line].[Unit of Measure Code]
       ,[Unit of Measure].[Code]
FROM
       [CRONUS UK Ltd_$Posted Invt_ Pick Line$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Posted Invt_ Pick Line]
LEFT JOIN
       [CRONUS UK Ltd_$Unit of Measure$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Unit of Measure]
              ON
                     [Posted Invt_ Pick Line].[Unit of Measure Code] = [Unit of Measure].[Code]
16Qty_ per Unit of Measure Searchdecimal(38,38)
17Description Searchnvarchar(200)
18Description 2 Searchnvarchar(100)
19Quantity Searchdecimal(38,38)
20Qty_ (Base) Searchdecimal(38,38)
21Shipping Advice Searchint
22Due Date Searchdatetime
23Destination Type Searchint
24Destination No_ Searchnvarchar(40)
25Whse_ Activity No_ Searchnvarchar(40)
26Shipping Agent Code Searchnvarchar(20)
Key to join to the Shipping Agent table.

Show/hide example query

SELECT
       [Posted Invt_ Pick Line].[Shipping Agent Code]
       ,[Shipping Agent].[Code]
FROM
       [CRONUS UK Ltd_$Posted Invt_ Pick Line$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Posted Invt_ Pick Line]
LEFT JOIN
       [CRONUS UK Ltd_$Shipping Agent$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Shipping Agent]
              ON
                     [Posted Invt_ Pick Line].[Shipping Agent Code] = [Shipping Agent].[Code]
27Shipping Agent Service Code Searchnvarchar(20)
Key to join to the Shipping Agent Services table.

Show/hide example query

SELECT
       [Posted Invt_ Pick Line].[Shipping Agent Service Code]
       ,[Shipping Agent Services].[Code]
FROM
       [CRONUS UK Ltd_$Posted Invt_ Pick Line$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Posted Invt_ Pick Line]
LEFT JOIN
       [CRONUS UK Ltd_$Shipping Agent Services$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Shipping Agent Services]
              ON
                     [Posted Invt_ Pick Line].[Shipping Agent Service Code] = [Shipping Agent Services].[Code]
28Shipment Method Code Searchnvarchar(20)
Key to join to the Shipment Method table.

Show/hide example query

SELECT
       [Posted Invt_ Pick Line].[Shipment Method Code]
       ,[Shipment Method].[Code]
FROM
       [CRONUS UK Ltd_$Posted Invt_ Pick Line$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Posted Invt_ Pick Line]
LEFT JOIN
       [CRONUS UK Ltd_$Shipment Method$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Shipment Method]
              ON
                     [Posted Invt_ Pick Line].[Shipment Method Code] = [Shipment Method].[Code]
29Serial No_ Searchnvarchar(100)
30Lot No_ Searchnvarchar(100)
31Warranty Date Searchdatetime
32Expiration Date Searchdatetime
33Package No_ Searchnvarchar(100)
34Bin Code Searchnvarchar(40)
35Zone Code Searchnvarchar(20)
36Action Type Searchint
37Special Equipment Code Searchnvarchar(20)
Key to join to the Special Equipment table.

Show/hide example query

SELECT
       [Posted Invt_ Pick Line].[Special Equipment Code]
       ,[Special Equipment].[Code]
FROM
       [CRONUS UK Ltd_$Posted Invt_ Pick Line$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Posted Invt_ Pick Line]
LEFT JOIN
       [CRONUS UK Ltd_$Special Equipment$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Special Equipment]
              ON
                     [Posted Invt_ Pick Line].[Special Equipment Code] = [Special Equipment].[Code]
38$systemId Searchuniqueidentifier
39$systemCreatedAt Searchdatetime
40$systemCreatedBy Searchuniqueidentifier
41$systemModifiedAt Searchdatetime
42$systemModifiedBy Searchuniqueidentifier

Show/hide tables related from Posted Invt_ Pick Line table

Leave a Reply

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