Posted Whse_ Receipt Line

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

Table Type: Company

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

Table Number: 7319

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

Show/hide an example select of all columns

SELECT
   *
FROM
   [CRONUS UK Ltd_$Posted Whse_ Receipt 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 Document]
   ,[Location Code]
   ,[Shelf No_]
   ,[Bin Code]
   ,[Zone Code]
   ,[Item No_]
   ,[Quantity]
   ,[Qty_ (Base)]
   ,[Qty_ Put Away]
   ,[Qty_ Put Away (Base)]
   ,[Unit of Measure Code]
   ,[Qty_ per Unit of Measure]
   ,[Variant Code]
   ,[Description]
   ,[Description 2]
   ,[Due Date]
   ,[Starting Date]
   ,[Qty_ Cross-Docked]
   ,[Qty_ Cross-Docked (Base)]
   ,[Cross-Dock Zone Code]
   ,[Cross-Dock Bin Code]
   ,[Qty_ Rounding Precision]
   ,[Qty_ Rounding Precision (Base)]
   ,[Posted Source Document]
   ,[Posted Source No_]
   ,[Posting Date]
   ,[Vendor Shipment No_]
   ,[Whse_ Receipt No_]
   ,[Whse Receipt Line No_]
   ,[Status]
   ,[Serial No_]
   ,[Lot No_]
   ,[Warranty Date]
   ,[Expiration Date]
   ,[Package No_]
   ,[$systemId]
   ,[$systemCreatedAt]
   ,[$systemCreatedBy]
   ,[$systemModifiedAt]
   ,[$systemModifiedBy]
FROM
   [CRONUS UK Ltd_$Posted Whse_ Receipt 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 Whse_ Receipt Line$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Posted Whse_ Receipt Line]
LEFT JOIN
   [CRONUS UK Ltd_$Location$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Location]
      ON
         [Posted Whse_ Receipt Line].[Location Code] = [Location].[Code]
LEFT JOIN
   [CRONUS UK Ltd_$Item$c526b3e9-b8ca-4683-81ba-fcd5f6b1472a] AS [Item]
      ON
         [Posted Whse_ Receipt Line].[Item No_] = [Item].[No_]
LEFT JOIN
   [CRONUS UK Ltd_$Unit of Measure$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Unit of Measure]
      ON
         [Posted Whse_ Receipt Line].[Unit of Measure Code] = [Unit of Measure].[Code]

Show/hide columns in Posted Whse_ Receipt 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 Document Searchint
9Location Code Searchnvarchar(20)
Key to join to the Location table.

Show/hide example query

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

Show/hide example query

SELECT
       [Posted Whse_ Receipt Line].[Item No_]
       ,[Item].[No_]
FROM
       [CRONUS UK Ltd_$Posted Whse_ Receipt Line$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Posted Whse_ Receipt Line]
LEFT JOIN
       [CRONUS UK Ltd_$Item$c526b3e9-b8ca-4683-81ba-fcd5f6b1472a] AS [Item]
              ON
                     [Posted Whse_ Receipt Line].[Item No_] = [Item].[No_]
14Quantity Searchdecimal(38,38)
15Qty_ (Base) Searchdecimal(38,38)
16Qty_ Put Away Searchdecimal(38,38)
17Qty_ Put Away (Base) Searchdecimal(38,38)
18Unit of Measure Code Searchnvarchar(20)
Key to join to the Unit of Measure table.

Show/hide example query

SELECT
       [Posted Whse_ Receipt Line].[Unit of Measure Code]
       ,[Unit of Measure].[Code]
FROM
       [CRONUS UK Ltd_$Posted Whse_ Receipt Line$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Posted Whse_ Receipt Line]
LEFT JOIN
       [CRONUS UK Ltd_$Unit of Measure$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Unit of Measure]
              ON
                     [Posted Whse_ Receipt Line].[Unit of Measure Code] = [Unit of Measure].[Code]
19Qty_ per Unit of Measure Searchdecimal(38,38)
20Variant Code Searchnvarchar(20)
21Description Searchnvarchar(200)
22Description 2 Searchnvarchar(100)
23Due Date Searchdatetime
24Starting Date Searchdatetime
25Qty_ Cross-Docked Searchdecimal(38,38)
26Qty_ Cross-Docked (Base) Searchdecimal(38,38)
27Cross-Dock Zone Code Searchnvarchar(20)
28Cross-Dock Bin Code Searchnvarchar(40)
29Qty_ Rounding Precision Searchdecimal(38,38)
30Qty_ Rounding Precision (Base) Searchdecimal(38,38)
31Posted Source Document Searchint
32Posted Source No_ Searchnvarchar(40)
33Posting Date Searchdatetime
34Vendor Shipment No_ Searchnvarchar(70)
35Whse_ Receipt No_ Searchnvarchar(40)
36Whse Receipt Line No_ Searchint
37Status Searchint
38Serial No_ Searchnvarchar(100)
39Lot No_ Searchnvarchar(100)
40Warranty Date Searchdatetime
41Expiration Date Searchdatetime
42Package No_ Searchnvarchar(100)
43$systemId Searchuniqueidentifier
44$systemCreatedAt Searchdatetime
45$systemCreatedBy Searchuniqueidentifier
46$systemModifiedAt Searchdatetime
47$systemModifiedBy Searchuniqueidentifier

Show/hide tables related from Posted Whse_ Receipt Line table

Leave a Reply

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