Warehouse Shipment Line

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

Table Type: Company

Table Name: Warehouse Shipment Line
Database Table Name: CRONUS UK Ltd_$Warehouse Shipment Line$437dbf0e-84ff-417a-965d-ed2bb9650972

Table Number: 7321

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

Show/hide an example select of all columns

SELECT
   *
FROM
   [CRONUS UK Ltd_$Warehouse Shipment 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_ Outstanding]
   ,[Qty_ Outstanding (Base)]
   ,[Qty_ to Ship]
   ,[Qty_ to Ship (Base)]
   ,[Qty_ Picked]
   ,[Qty_ Picked (Base)]
   ,[Qty_ Shipped]
   ,[Qty_ Shipped (Base)]
   ,[Unit of Measure Code]
   ,[Qty_ per Unit of Measure]
   ,[Variant Code]
   ,[Description]
   ,[Description 2]
   ,[Status]
   ,[Sorting Sequence No_]
   ,[Due Date]
   ,[Destination Type]
   ,[Destination No_]
   ,[Cubage]
   ,[Weight]
   ,[Shipping Advice]
   ,[Shipment Date]
   ,[Completely Picked]
   ,[Not upd_ by Src_ Doc_ Post_]
   ,[Posting from Whse_ Ref_]
   ,[Qty_ Rounding Precision]
   ,[Qty_ Rounding Precision (Base)]
   ,[Assemble to Order]
   ,[$systemId]
   ,[$systemCreatedAt]
   ,[$systemCreatedBy]
   ,[$systemModifiedAt]
   ,[$systemModifiedBy]
FROM
   [CRONUS UK Ltd_$Warehouse Shipment 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_$Warehouse Shipment Line$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Warehouse Shipment Line]
LEFT JOIN
   [CRONUS UK Ltd_$Location$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Location]
      ON
         [Warehouse Shipment Line].[Location Code] = [Location].[Code]
LEFT JOIN
   [CRONUS UK Ltd_$Bin$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Bin]
      ON
         [Warehouse Shipment Line].[Bin Code] = [Bin].[Code]
LEFT JOIN
   [CRONUS UK Ltd_$Item Variant$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Item Variant]
      ON
         [Warehouse Shipment Line].[Variant Code] = [Item Variant].[Code]
LEFT JOIN
   [User] AS [User]
      ON
         [Warehouse Shipment Line].[SystemCreatedBy] = [User].[User Security ID]
LEFT JOIN
   [User] AS [User]
      ON
         [Warehouse Shipment Line].[SystemModifiedBy] = [User].[User Security ID]

Show/hide columns in Warehouse Shipment Line table

Field No.Field NameField CaptionClassTypeLengthSQL Column NameSQL DataType
1No. SearchNo.NormalCode20No_nvarchar(40)
2Line No. Primary Key SearchLine No.NormalInteger4Line No_int
3Source Type Primary Key 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
	       [Warehouse Shipment Line].[Location Code]
	       ,[Location].[Code]
	FROM
	       [CRONUS UK Ltd_$Warehouse Shipment Line$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Warehouse Shipment Line]
	LEFT JOIN
	       [CRONUS UK Ltd_$Location$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Location]
	              ON
	                     [Warehouse Shipment 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
	       [Warehouse Shipment Line].[Bin Code]
	       ,[Bin].[Code]
	FROM
	       [CRONUS UK Ltd_$Warehouse Shipment Line$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Warehouse Shipment Line]
	LEFT JOIN
	       [CRONUS UK Ltd_$Bin$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Bin]
	              ON
	                     [Warehouse Shipment 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
	       [Warehouse Shipment Line].[Item No_]
	       ,[Item].[No_]
	FROM
	       [CRONUS UK Ltd_$Warehouse Shipment Line$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Warehouse Shipment Line]
	LEFT JOIN
	       [CRONUS UK Ltd_$Item$437dbf0e-84ff-417a-965d-ed2bb9650972$ext] AS [Item]
	              ON
	                     [Warehouse Shipment Line].[Item No_] = [Item].[No_]
15Quantity SearchQuantityNormalDecimal12Quantitydecimal(38,38)
16Qty. (Base) SearchQty. (Base)NormalDecimal12Qty_ (Base)decimal(38,38)
19Qty. Outstanding SearchQty. OutstandingNormalDecimal12Qty_ Outstandingdecimal(38,38)
20Qty. Outstanding (Base) SearchQty. Outstanding (Base)NormalDecimal12Qty_ Outstanding (Base)decimal(38,38)
21Qty. to Ship SearchQty. to ShipNormalDecimal12Qty_ to Shipdecimal(38,38)
22Qty. to Ship (Base) SearchQty. to Ship (Base)NormalDecimal12Qty_ to Ship (Base)decimal(38,38)
23Qty. Picked SearchQty. PickedNormalDecimal12Qty_ Pickeddecimal(38,38)
24Qty. Picked (Base) SearchQty. Picked (Base)NormalDecimal12Qty_ Picked (Base)decimal(38,38)
25Qty. Shipped SearchQty. ShippedNormalDecimal12Qty_ Shippeddecimal(38,38)
26Qty. Shipped (Base) SearchQty. Shipped (Base)NormalDecimal12Qty_ Shipped (Base)decimal(38,38)
27Pick Qty. SearchPick Qty.FlowFieldDecimal12
28Pick Qty. (Base) SearchPick 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
	       [Warehouse Shipment Line].[Variant Code]
	       ,[Item Variant].[Code]
	FROM
	       [CRONUS UK Ltd_$Warehouse Shipment Line$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Warehouse Shipment Line]
	LEFT JOIN
	       [CRONUS UK Ltd_$Item Variant$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Item Variant]
	              ON
	                     [Warehouse Shipment Line].[Variant Code] = [Item Variant].[Code]
32Description SearchDescriptionNormalText100Descriptionnvarchar(200)
33Description 2 SearchDescription 2NormalText50Description 2nvarchar(100)
34Status SearchStatusNormalOption4Statusint
Available options are:
  • ” “
  • “Partially Picked”
  • “Partially Shipped”
  • “Completely Picked”
  • “Completely Shipped”
35Sorting Sequence No. SearchSorting Sequence No.NormalInteger4Sorting Sequence No_int
36Due Date SearchDue DateNormalDate4Due Datedatetime
39Destination Type SearchDestination TypeNormalOption4Destination Typeint
Available options are:
  • ” “
  • “Customer”
  • “Vendor”
  • “Location”
  • “Item”
  • “Family”
  • “Sales Order”
40Destination No. SearchDestination No.NormalCode20Destination No_nvarchar(40)
41Cubage SearchCubageNormalDecimal12Cubagedecimal(38,38)
42Weight SearchWeightNormalDecimal12Weightdecimal(38,38)
44Shipping Advice SearchShipping AdviceNormalOption4Shipping Adviceint
Available options are:
  • “Partial”
  • “Complete”
45Shipment Date SearchShipment DateNormalDate4Shipment Datedatetime
46Completely Picked SearchCompletely PickedNormalBoolean4Completely Pickedtinyint
48Not upd. by Src. Doc. Post. SearchNot upd. by Src. Doc. Post.NormalBoolean4Not upd_ by Src_ Doc_ Post_tinyint
49Posting from Whse. Ref. SearchPosting from Whse. Ref.NormalInteger4Posting from Whse_ Ref_int
50Qty. Rounding Precision SearchQty. Rounding PrecisionNormalDecimal12Qty_ Rounding Precisiondecimal(38,38)
51Qty. Rounding Precision (Base) SearchQty. Rounding Precision (Base)NormalDecimal12Qty_ Rounding Precision (Base)decimal(38,38)
900Assemble to Order SearchAssemble to OrderNormalBoolean4Assemble to Ordertinyint
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
	       [Warehouse Shipment Line].[$systemCreatedBy]
	       ,[User].[User Security ID]
	FROM
	       [CRONUS UK Ltd_$Warehouse Shipment Line$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Warehouse Shipment Line]
	LEFT JOIN
	       [User] AS [User]
	              ON
	                     [Warehouse Shipment Line].[$systemCreatedBy] = [User].[User Security ID]
2000000003SystemModifiedAt SearchModified AtNormalDateTime8$systemModifiedAtdatetime
2000000004SystemModifiedBy SearchModified ByNormalGUID16$systemModifiedByuniqueidentifier

Show/hide tables related from Warehouse Shipment Line table

Leave a Reply

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