Warehouse Source Filter

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

Table Type: Company

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

Table Number: 5771

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

Show/hide an example select of all columns

SELECT
   *
FROM
   [CRONUS UK Ltd_$Warehouse Source Filter$437dbf0e-84ff-417a-965d-ed2bb9650972]

Show/hide an example select of all columns by name

SELECT
   [Code]
   ,[Description]
   ,[Item No_ Filter]
   ,[Variant Code Filter]
   ,[Unit of Measure Filter]
   ,[Sell-to Customer No_ Filter]
   ,[Buy-from Vendor No_ Filter]
   ,[Customer No_ Filter]
   ,[Shipment Method Code Filter]
   ,[Shipping Agent Code Filter]
   ,[Shipping Advice Filter]
   ,[Do Not Fill Qty_ to Handle]
   ,[Show Filter Request]
   ,[Shipping Agent Service Filter]
   ,[In-Transit Code Filter]
   ,[Transfer-from Code Filter]
   ,[Transfer-to Code Filter]
   ,[Job No_]
   ,[Reserved From Stock]
   ,[Source No_ Filter]
   ,[Source Document]
   ,[Type]
   ,[Sales Orders]
   ,[Sales Return Orders]
   ,[Purchase Orders]
   ,[Purchase Return Orders]
   ,[Inbound Transfers]
   ,[Outbound Transfers]
   ,[Partial]
   ,[Complete]
   ,[Service Orders]
   ,[Job Task No_ Filter]
   ,[Prod_ Order No_]
   ,[Planned Delivery Date]
   ,[Planned Shipment Date]
   ,[Planned Receipt Date]
   ,[Expected Receipt Date]
   ,[Shipment Date]
   ,[Receipt Date]
   ,[Sales Shipment Date]
   ,[Prod_ Order Line No_ Filter]
   ,[$systemId]
   ,[$systemCreatedAt]
   ,[$systemCreatedBy]
   ,[$systemModifiedAt]
   ,[$systemModifiedBy]
FROM
   [CRONUS UK Ltd_$Warehouse Source Filter$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 Source Filter$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Warehouse Source Filter]
LEFT JOIN
   [CRONUS UK Ltd_$Item Variant$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Item Variant]
      ON
         [Warehouse Source Filter].[Variant Code Filter] = [Item Variant].[Code]
LEFT JOIN
   [CRONUS UK Ltd_$Unit of Measure$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Unit of Measure]
      ON
         [Warehouse Source Filter].[Unit of Measure Filter] = [Unit of Measure].[Code]
LEFT JOIN
   [CRONUS UK Ltd_$Shipment Method$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Shipment Method]
      ON
         [Warehouse Source Filter].[Shipment Method Code Filter] = [Shipment Method].[Code]
LEFT JOIN
   [CRONUS UK Ltd_$Shipping Agent$437dbf0e-84ff-417a-965d-ed2bb9650972$ext] AS [Shipping Agent]
      ON
         [Warehouse Source Filter].[Shipping Agent Code Filter] = [Shipping Agent].[Code]
LEFT JOIN
   [CRONUS UK Ltd_$Shipping Agent Services$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Shipping Agent Services]
      ON
         [Warehouse Source Filter].[Shipping Agent Service Filter] = [Shipping Agent Services].[Code]
LEFT JOIN
   [User] AS [User]
      ON
         [Warehouse Source Filter].[SystemCreatedBy] = [User].[User Security ID]
LEFT JOIN
   [User] AS [User]
      ON
         [Warehouse Source Filter].[SystemModifiedBy] = [User].[User Security ID]

Show/hide columns in Warehouse Source Filter table

Field No.Field NameField CaptionClassTypeLengthSQL Column NameSQL DataType
1Code Primary Key SearchCodeNormalCode10Codenvarchar(20)
2Description SearchDescriptionNormalText100Descriptionnvarchar(200)
3Item No. Filter SearchItem No. FilterNormalCode100Item No_ Filternvarchar(200)
Key to join to the Item table.

Show/hide example query

SELECT
       [Warehouse Source Filter].[Item No_ Filter]
       ,[Item].[No_]
FROM
       [CRONUS UK Ltd_$Warehouse Source Filter$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Warehouse Source Filter]
LEFT JOIN
       [CRONUS UK Ltd_$Item$437dbf0e-84ff-417a-965d-ed2bb9650972$ext] AS [Item]
              ON
                     [Warehouse Source Filter].[Item No_ Filter] = [Item].[No_]
4Variant Code Filter SearchVariant Code FilterNormalCode100Variant Code Filternvarchar(200)
Key to join to the Item Variant table.

Show/hide example query

SELECT
       [Warehouse Source Filter].[Variant Code Filter]
       ,[Item Variant].[Code]
FROM
       [CRONUS UK Ltd_$Warehouse Source Filter$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Warehouse Source Filter]
LEFT JOIN
       [CRONUS UK Ltd_$Item Variant$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Item Variant]
              ON
                     [Warehouse Source Filter].[Variant Code Filter] = [Item Variant].[Code]
5Unit of Measure Filter SearchUnit of Measure FilterNormalCode100Unit of Measure Filternvarchar(200)
Key to join to the Unit of Measure table.

Show/hide example query

SELECT
       [Warehouse Source Filter].[Unit of Measure Filter]
       ,[Unit of Measure].[Code]
FROM
       [CRONUS UK Ltd_$Warehouse Source Filter$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Warehouse Source Filter]
LEFT JOIN
       [CRONUS UK Ltd_$Unit of Measure$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Unit of Measure]
              ON
                     [Warehouse Source Filter].[Unit of Measure Filter] = [Unit of Measure].[Code]
6Sell-to Customer No. Filter SearchSell-to Customer No. FilterNormalCode100Sell-to Customer No_ Filternvarchar(200)
Key to join to the Customer table.

Show/hide example query

SELECT
       [Warehouse Source Filter].[Sell-to Customer No_ Filter]
       ,[Customer].[No_]
FROM
       [CRONUS UK Ltd_$Warehouse Source Filter$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Warehouse Source Filter]
LEFT JOIN
       [CRONUS UK Ltd_$Customer$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Customer]
              ON
                     [Warehouse Source Filter].[Sell-to Customer No_ Filter] = [Customer].[No_]
7Buy-from Vendor No. Filter SearchBuy-from Vendor No. FilterNormalCode100Buy-from Vendor No_ Filternvarchar(200)
Key to join to the Vendor table.

Show/hide example query

SELECT
       [Warehouse Source Filter].[Buy-from Vendor No_ Filter]
       ,[Vendor].[No_]
FROM
       [CRONUS UK Ltd_$Warehouse Source Filter$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Warehouse Source Filter]
LEFT JOIN
       [CRONUS UK Ltd_$Vendor$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Vendor]
              ON
                     [Warehouse Source Filter].[Buy-from Vendor No_ Filter] = [Vendor].[No_]
8Customer No. Filter SearchCustomer No. FilterNormalCode100Customer No_ Filternvarchar(200)
Key to join to the Customer table.

Show/hide example query

SELECT
       [Warehouse Source Filter].[Customer No_ Filter]
       ,[Customer].[No_]
FROM
       [CRONUS UK Ltd_$Warehouse Source Filter$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Warehouse Source Filter]
LEFT JOIN
       [CRONUS UK Ltd_$Customer$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Customer]
              ON
                     [Warehouse Source Filter].[Customer No_ Filter] = [Customer].[No_]
10Planned Delivery Date Filter SearchPlanned Delivery Date FilterFlowFilterDate4
11Shipment Method Code Filter SearchShipment Method Code FilterNormalCode100Shipment Method Code Filternvarchar(200)
Key to join to the Shipment Method table.

Show/hide example query

SELECT
       [Warehouse Source Filter].[Shipment Method Code Filter]
       ,[Shipment Method].[Code]
FROM
       [CRONUS UK Ltd_$Warehouse Source Filter$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Warehouse Source Filter]
LEFT JOIN
       [CRONUS UK Ltd_$Shipment Method$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Shipment Method]
              ON
                     [Warehouse Source Filter].[Shipment Method Code Filter] = [Shipment Method].[Code]
12Shipping Agent Code Filter SearchShipping Agent Code FilterNormalCode100Shipping Agent Code Filternvarchar(200)
Key to join to the Shipping Agent table.

Show/hide example query

SELECT
       [Warehouse Source Filter].[Shipping Agent Code Filter]
       ,[Shipping Agent].[Code]
FROM
       [CRONUS UK Ltd_$Warehouse Source Filter$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Warehouse Source Filter]
LEFT JOIN
       [CRONUS UK Ltd_$Shipping Agent$437dbf0e-84ff-417a-965d-ed2bb9650972$ext] AS [Shipping Agent]
              ON
                     [Warehouse Source Filter].[Shipping Agent Code Filter] = [Shipping Agent].[Code]
13Shipping Advice Filter SearchShipping Advice FilterNormalCode100Shipping Advice Filternvarchar(200)
15Do Not Fill Qty. to Handle SearchDo Not Fill Qty. to HandleNormalBoolean4Do Not Fill Qty_ to Handletinyint
16Show Filter Request SearchShow Filter RequestNormalBoolean4Show Filter Requesttinyint
17Shipping Agent Service Filter SearchShipping Agent Service FilterNormalCode100Shipping Agent Service Filternvarchar(200)
Key to join to the Shipping Agent Services table.

Show/hide example query

SELECT
       [Warehouse Source Filter].[Shipping Agent Service Filter]
       ,[Shipping Agent Services].[Code]
FROM
       [CRONUS UK Ltd_$Warehouse Source Filter$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Warehouse Source Filter]
LEFT JOIN
       [CRONUS UK Ltd_$Shipping Agent Services$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Shipping Agent Services]
              ON
                     [Warehouse Source Filter].[Shipping Agent Service Filter] = [Shipping Agent Services].[Code]
18In-Transit Code Filter SearchIn-Transit Code FilterNormalCode100In-Transit Code Filternvarchar(200)
19Transfer-from Code Filter SearchTransfer-from Code FilterNormalCode100Transfer-from Code Filternvarchar(200)
20Transfer-to Code Filter SearchTransfer-to Code FilterNormalCode100Transfer-to Code Filternvarchar(200)
21Planned Shipment Date Filter SearchPlanned Shipment Date FilterFlowFilterDate4
22Planned Receipt Date Filter SearchPlanned Receipt Date FilterFlowFilterDate4
23Expected Receipt Date Filter SearchExpected Receipt Date FilterFlowFilterDate4
24Shipment Date Filter SearchOutbound Date FilterFlowFilterDate4
25Receipt Date Filter SearchInbound Date FilterFlowFilterDate4
28Sales Shipment Date Filter SearchSales Shipment Date FilterFlowFilterDate4
45Job No. SearchJob No.NormalCode20Job No_nvarchar(40)
Key to join to the Job table.

Show/hide example query

SELECT
       [Warehouse Source Filter].[Job No_]
       ,[Job].[No_]
FROM
       [CRONUS UK Ltd_$Warehouse Source Filter$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Warehouse Source Filter]
LEFT JOIN
       [CRONUS UK Ltd_$Job$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Job]
              ON
                     [Warehouse Source Filter].[Job No_] = [Job].[No_]
96Reserved From Stock SearchReserved from StockNormalOption4Reserved From Stockint
98Source No. Filter SearchSource No. FilterNormalCode100Source No_ Filternvarchar(200)
99Source Document SearchSource DocumentNormalCode250Source Documentnvarchar(500)
100Type Primary Key SearchTypeNormalOption4Typeint
Available options are:
  • “Inbound”
  • “Outbound”
101Sales Orders SearchSales OrdersNormalBoolean4Sales Orderstinyint
102Sales Return Orders SearchSales Return OrdersNormalBoolean4Sales Return Orderstinyint
103Purchase Orders SearchPurchase OrdersNormalBoolean4Purchase Orderstinyint
104Purchase Return Orders SearchPurchase Return OrdersNormalBoolean4Purchase Return Orderstinyint
105Inbound Transfers SearchInbound TransfersNormalBoolean4Inbound Transferstinyint
106Outbound Transfers SearchOutbound TransfersNormalBoolean4Outbound Transferstinyint
108Partial SearchPartialNormalBoolean4Partialtinyint
109Complete SearchCompleteNormalBoolean4Completetinyint
110Service Orders SearchService OrdersNormalBoolean4Service Orderstinyint
1001Job Task No. Filter SearchJob Task No. FilterNormalCode100Job Task No_ Filternvarchar(200)
5401Prod. Order No. SearchProd. Order No.NormalCode20Prod_ Order No_nvarchar(40)
7300Planned Delivery Date SearchPlanned Delivery DateNormalText250Planned Delivery Datenvarchar(500)
7301Planned Shipment Date SearchPlanned Shipment DateNormalText250Planned Shipment Datenvarchar(500)
7302Planned Receipt Date SearchPlanned Receipt DateNormalText250Planned Receipt Datenvarchar(500)
7303Expected Receipt Date SearchExpected Receipt DateNormalText250Expected Receipt Datenvarchar(500)
7304Shipment Date SearchShipment DateNormalText250Shipment Datenvarchar(500)
7305Receipt Date SearchReceipt DateNormalText250Receipt Datenvarchar(500)
7306Sales Shipment Date SearchSales Shipment DateNormalText250Sales Shipment Datenvarchar(500)
99000754Prod. Order Line No. Filter SearchProd. Order Line No. FilterNormalText100Prod_ Order Line No_ Filternvarchar(200)
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 Source Filter].[$systemCreatedBy]
       ,[User].[User Security ID]
FROM
       [CRONUS UK Ltd_$Warehouse Source Filter$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Warehouse Source Filter]
LEFT JOIN
       [User] AS [User]
              ON
                     [Warehouse Source Filter].[$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
       [Warehouse Source Filter].[$systemModifiedBy]
       ,[User].[User Security ID]
FROM
       [CRONUS UK Ltd_$Warehouse Source Filter$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Warehouse Source Filter]
LEFT JOIN
       [User] AS [User]
              ON
                     [Warehouse Source Filter].[$systemModifiedBy] = [User].[User Security ID]

Leave a Reply

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