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
   [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_$Bin$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Bin]
      ON
         [Posted Whse. Receipt Line].[Bin Code] = [Bin].[Code]
LEFT JOIN
   [CRONUS UK Ltd_$Item Variant$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Item Variant]
      ON
         [Posted Whse. Receipt Line].[Variant Code] = [Item Variant].[Code]
LEFT JOIN
   [User] AS [User]
      ON
         [Posted Whse. Receipt Line].[SystemCreatedBy] = [User].[User Security ID]
LEFT JOIN
   [User] AS [User]
      ON
         [Posted Whse. Receipt Line].[SystemModifiedBy] = [User].[User Security ID]

Show/hide columns in Posted Whse. Receipt Line table

Field No.Field NameField CaptionClassTypeLengthSQL Column NameSQL DataType
1No. Primary Key SearchNo.NormalCode20No_nvarchar(40)
2Line No. Primary Key SearchLine No.NormalInteger4Line No_int
3Source Type SearchSource TypeNormalInteger4Source Typeint
4Source Subtype SearchSource SubtypeNormalOption4Source Subtypeint
Available options are:
  • “0”
  • “1”
  • “2”
  • “3”
  • “4”
  • “5”
  • “6”
  • “7”
  • “8”
  • “9”
  • “10”
6Source No. SearchSource No.NormalCode20Source No_nvarchar(40)
7Source Line No. SearchSource Line No.NormalInteger4Source Line No_int
9Source Document SearchSource DocumentNormalOption4Source Documentint
Available options are:
  • ” “
  • “Sales Order”
  • “Sales Return Order”
  • “Purchase Order”
  • “Purchase Return Order”
  • “Inbound Transfer”
  • “Outbound Transfer”
  • “Prod. Consumption”
  • “Prod. Output”
  • “Service Order”
  • “Assembly Consumption”
  • “Assembly Order”
  • “Job Usage”
10Location Code SearchLocation CodeNormalCode10Location Codenvarchar(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]
11Shelf No. SearchShelf No.NormalCode10Shelf No_nvarchar(20)
12Bin Code SearchBin CodeNormalCode20Bin Codenvarchar(40)
Key to join to the Bin table.

Show/hide example query

SELECT
       [Posted Whse. Receipt Line].[Bin Code]
       ,[Bin].[Code]
FROM
       [CRONUS UK Ltd_$Posted Whse_ Receipt Line$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Posted Whse. Receipt Line]
LEFT JOIN
       [CRONUS UK Ltd_$Bin$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Bin]
              ON
                     [Posted Whse. Receipt Line].[Bin Code] = [Bin].[Code]
13Zone Code SearchZone CodeNormalCode10Zone Codenvarchar(20)
14Item No. SearchItem No.NormalCode20Item No_nvarchar(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$437dbf0e-84ff-417a-965d-ed2bb9650972$ext] AS [Item]
              ON
                     [Posted Whse. Receipt Line].[Item No_] = [Item].[No_]
15Quantity SearchQuantityNormalDecimal12Quantitydecimal(38,38)
16Qty. (Base) SearchQty. (Base)NormalDecimal12Qty_ (Base)decimal(38,38)
25Qty. Put Away SearchQty. Put AwayNormalDecimal12Qty_ Put Awaydecimal(38,38)
26Qty. Put Away (Base) SearchQty. Put Away (Base)NormalDecimal12Qty_ Put Away (Base)decimal(38,38)
27Put-away Qty. SearchPut-away Qty.FlowFieldDecimal12
28Put-away Qty. (Base) SearchPut-away Qty. (Base)FlowFieldDecimal12
29Unit of Measure Code SearchUnit of Measure CodeNormalCode10Unit of Measure Codenvarchar(20)
30Qty. per Unit of Measure SearchQty. per Unit of MeasureNormalDecimal12Qty_ per Unit of Measuredecimal(38,38)
31Variant Code SearchVariant CodeNormalCode10Variant Codenvarchar(20)
Key to join to the Item Variant table.

Show/hide example query

SELECT
       [Posted Whse. Receipt Line].[Variant Code]
       ,[Item Variant].[Code]
FROM
       [CRONUS UK Ltd_$Posted Whse_ Receipt Line$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Posted Whse. Receipt Line]
LEFT JOIN
       [CRONUS UK Ltd_$Item Variant$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Item Variant]
              ON
                     [Posted Whse. Receipt Line].[Variant Code] = [Item Variant].[Code]
32Description SearchDescriptionNormalText100Descriptionnvarchar(200)
33Description 2 SearchDescription 2NormalText50Description 2nvarchar(100)
36Due Date SearchDue DateNormalDate4Due Datedatetime
37Starting Date SearchStarting DateNormalDate4Starting Datedatetime
50Qty. Cross-Docked SearchQty. Cross-DockedNormalDecimal12Qty_ Cross-Dockeddecimal(38,38)
51Qty. Cross-Docked (Base) SearchQty. Cross-Docked (Base)NormalDecimal12Qty_ Cross-Docked (Base)decimal(38,38)
52Cross-Dock Zone Code SearchCross-Dock Zone CodeNormalCode10Cross-Dock Zone Codenvarchar(20)
53Cross-Dock Bin Code SearchCross-Dock Bin CodeNormalCode20Cross-Dock Bin Codenvarchar(40)
55Qty. Rounding Precision SearchQty. Rounding PrecisionNormalDecimal12Qty_ Rounding Precisiondecimal(38,38)
56Qty. Rounding Precision (Base) SearchQty. Rounding Precision (Base)NormalDecimal12Qty_ Rounding Precision (Base)decimal(38,38)
60Posted Source Document SearchPosted Source DocumentNormalOption4Posted Source Documentint
Available options are:
  • ” “
  • “Posted Receipt”
  • “Posted Return Receipt”
  • “Posted Shipment”
  • “Posted Return Shipment”
  • “Posted Transfer Receipt”
  • “Posted Transfer Shipment”
61Posted Source No. SearchPosted Source No.NormalCode20Posted Source No_nvarchar(40)
62Posting Date SearchPosting DateNormalDate4Posting Datedatetime
63Vendor Shipment No. SearchVendor Shipment No.NormalCode35Vendor Shipment No_nvarchar(70)
64Whse. Receipt No. SearchWhse. Receipt No.NormalCode20Whse_ Receipt No_nvarchar(40)
65Whse Receipt Line No. SearchWhse Receipt Line No.NormalInteger4Whse Receipt Line No_int
66Status SearchStatusNormalOption4Statusint
Available options are:
  • ” “
  • “Partially Put Away”
  • “Completely Put Away”
6500Serial No. SearchSerial No.NormalCode50Serial No_nvarchar(100)
6501Lot No. SearchLot No.NormalCode50Lot No_nvarchar(100)
6502Warranty Date SearchWarranty DateNormalDate4Warranty Datedatetime
6503Expiration Date SearchExpiration DateNormalDate4Expiration Datedatetime
6515Package No. SearchPackage No.NormalCode50Package No_nvarchar(100)
2000000000$systemId SearchSystem IDNormalGUID16$systemIduniqueidentifier
2000000001SystemCreatedAt SearchCreated AtNormalDateTime8$systemCreatedAtdatetime
2000000002SystemCreatedBy SearchCreated ByNormalGUID16$systemCreatedByuniqueidentifier
Key to join to the User table.

Show/hide example query

SELECT
       [Posted Whse. Receipt Line].[$systemCreatedBy]
       ,[User].[User Security ID]
FROM
       [CRONUS UK Ltd_$Posted Whse_ Receipt Line$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Posted Whse. Receipt Line]
LEFT JOIN
       [User] AS [User]
              ON
                     [Posted Whse. Receipt Line].[$systemCreatedBy] = [User].[User Security ID]
2000000003SystemModifiedAt SearchModified AtNormalDateTime8$systemModifiedAtdatetime
2000000004SystemModifiedBy SearchModified ByNormalGUID16$systemModifiedByuniqueidentifier
Key to join to the User table.

Show/hide example query

SELECT
       [Posted Whse. Receipt Line].[$systemModifiedBy]
       ,[User].[User Security ID]
FROM
       [CRONUS UK Ltd_$Posted Whse_ Receipt Line$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Posted Whse. Receipt Line]
LEFT JOIN
       [User] AS [User]
              ON
                     [Posted Whse. Receipt Line].[$systemModifiedBy] = [User].[User Security ID]

Show/hide tables related from Posted Whse. Receipt Line table

Leave a Reply

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