Availability Calc. Overview

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

Table Type: Company

Table Name: Availability Calc. Overview
Database Table Name: CRONUS UK Ltd_$Availability Calc_ Overview$437dbf0e-84ff-417a-965d-ed2bb9650972

Table Number: 5830

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 Availability Calc. Overview can be queried.

Show/hide an example select of all columns

SELECT
   *
FROM
   [CRONUS UK Ltd_$Availability Calc_ Overview$437dbf0e-84ff-417a-965d-ed2bb9650972]

Show/hide an example select of all columns by name

SELECT
   [Entry No_]
   ,[Type]
   ,[Date]
   ,[Item No_]
   ,[Location Code]
   ,[Variant Code]
   ,[Unit of Measure Code]
   ,[Attached to Entry No_]
   ,[Level]
   ,[Source Type]
   ,[Source Order Status]
   ,[Source ID]
   ,[Source Batch Name]
   ,[Source Ref_ No_]
   ,[Source Prod_ Order Line]
   ,[Description]
   ,[Quantity]
   ,[Reserved Quantity]
   ,[Inventory Running Total]
   ,[Supply Running Total]
   ,[Demand Running Total]
   ,[Running Total]
   ,[Matches Criteria]
   ,[$systemId]
   ,[$systemCreatedAt]
   ,[$systemCreatedBy]
   ,[$systemModifiedAt]
   ,[$systemModifiedBy]
FROM
   [CRONUS UK Ltd_$Availability Calc_ Overview$437dbf0e-84ff-417a-965d-ed2bb9650972]

Show/hide an example select of all columns including those from all joined tables

SELECT
   *
FROM
   [CRONUS UK Ltd_$Availability Calc_ Overview$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Availability Calc. Overview]
LEFT JOIN
   [CRONUS UK Ltd_$Location$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Location]
      ON
         [Availability Calc. Overview].[Location Code] = [Location].[Code]
LEFT JOIN
   [CRONUS UK Ltd_$Item Variant$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Item Variant]
      ON
         [Availability Calc. Overview].[Variant Code] = [Item Variant].[Code]
LEFT JOIN
   [User] AS [User]
      ON
         [Availability Calc. Overview].[SystemCreatedBy] = [User].[User Security ID]
LEFT JOIN
   [User] AS [User]
      ON
         [Availability Calc. Overview].[SystemModifiedBy] = [User].[User Security ID]

Show/hide columns in Availability Calc. Overview table

Field No.Field NameField CaptionClassTypeLengthSQL Column NameSQL DataType
1Entry No. Primary Key SearchEntry No.NormalInteger4Entry No_int
2Type SearchTypeNormalOption4Typeint
Available options are:
  • “Item”
  • “As of Date”
  • “Inventory”
  • “Supply”
  • “Supply Forecast”
  • “Demand”
3Date SearchDateNormalDate4Datedatetime
4Item No. SearchItem No.NormalCode20Item No_nvarchar(40)
Key to join to the Item table.

Show/hide example query

SELECT
       [Availability Calc. Overview].[Item No_]
       ,[Item].[No_]
FROM
       [CRONUS UK Ltd_$Availability Calc_ Overview$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Availability Calc. Overview]
LEFT JOIN
       [CRONUS UK Ltd_$Item$437dbf0e-84ff-417a-965d-ed2bb9650972$ext] AS [Item]
              ON
                     [Availability Calc. Overview].[Item No_] = [Item].[No_]
5Location Code SearchLocation CodeNormalCode10Location Codenvarchar(20)
Key to join to the Location table.

Show/hide example query

SELECT
       [Availability Calc. Overview].[Location Code]
       ,[Location].[Code]
FROM
       [CRONUS UK Ltd_$Availability Calc_ Overview$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Availability Calc. Overview]
LEFT JOIN
       [CRONUS UK Ltd_$Location$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Location]
              ON
                     [Availability Calc. Overview].[Location Code] = [Location].[Code]
6Variant Code SearchVariant CodeNormalCode10Variant Codenvarchar(20)
Key to join to the Item Variant table.

Show/hide example query

SELECT
       [Availability Calc. Overview].[Variant Code]
       ,[Item Variant].[Code]
FROM
       [CRONUS UK Ltd_$Availability Calc_ Overview$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Availability Calc. Overview]
LEFT JOIN
       [CRONUS UK Ltd_$Item Variant$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Item Variant]
              ON
                     [Availability Calc. Overview].[Variant Code] = [Item Variant].[Code]
7Unit of Measure Code SearchUnit of Measure CodeNormalCode10Unit of Measure Codenvarchar(20)
11Attached to Entry No. SearchAttached to Entry No.NormalInteger4Attached to Entry No_int
Key to join to the Item Ledger Entry table.

Show/hide example query

SELECT
       [Availability Calc. Overview].[Attached to Entry No_]
       ,[Item Ledger Entry].[Entry No_]
FROM
       [CRONUS UK Ltd_$Availability Calc_ Overview$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Availability Calc. Overview]
LEFT JOIN
       [CRONUS UK Ltd_$Item Ledger Entry$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Item Ledger Entry]
              ON
                     [Availability Calc. Overview].[Attached to Entry No_] = [Item Ledger Entry].[Entry No_]
13Level SearchLevelNormalInteger4Levelint
21Source Type SearchSource TypeNormalInteger4Source Typeint
22Source Order Status SearchSource Order StatusNormalInteger4Source Order Statusint
23Source ID SearchSource IDNormalCode20Source IDnvarchar(40)
24Source Batch Name SearchSource Batch NameNormalCode10Source Batch Namenvarchar(20)
25Source Ref. No. SearchSource Ref. No.NormalInteger4Source Ref_ No_int
26Source Prod. Order Line SearchSource Prod. Order LineNormalInteger4Source Prod_ Order Lineint
27Description SearchDescriptionNormalText100Descriptionnvarchar(200)
41Quantity SearchQuantityNormalDecimal12Quantitydecimal(38,38)
42Reserved Quantity SearchReserved QuantityNormalDecimal12Reserved Quantitydecimal(38,38)
45Inventory Running Total SearchInventory Running TotalNormalDecimal12Inventory Running Totaldecimal(38,38)
46Supply Running Total SearchSupply Running TotalNormalDecimal12Supply Running Totaldecimal(38,38)
47Demand Running Total SearchDemand Running TotalNormalDecimal12Demand Running Totaldecimal(38,38)
48Running Total SearchRunning TotalNormalDecimal12Running Totaldecimal(38,38)
50Matches Criteria SearchMatches CriteriaNormalBoolean4Matches Criteriatinyint
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
       [Availability Calc. Overview].[$systemCreatedBy]
       ,[User].[User Security ID]
FROM
       [CRONUS UK Ltd_$Availability Calc_ Overview$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Availability Calc. Overview]
LEFT JOIN
       [User] AS [User]
              ON
                     [Availability Calc. Overview].[$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
       [Availability Calc. Overview].[$systemModifiedBy]
       ,[User].[User Security ID]
FROM
       [CRONUS UK Ltd_$Availability Calc_ Overview$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Availability Calc. Overview]
LEFT JOIN
       [User] AS [User]
              ON
                     [Availability Calc. Overview].[$systemModifiedBy] = [User].[User Security ID]

Show/hide tables related from Availability Calc. Overview table

Leave a Reply

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