Availability Calc_ Overview – Dynamics 365 BC Table Reference

Dynamics 365 BC Table Reference Tables Company Tables AAvailability 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

   [timestamp]
   ,[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_$Item$c526b3e9-b8ca-4683-81ba-fcd5f6b1472a] AS [Item]
      ON
         [Availability Calc_ Overview].[Item No_] = [Item].[No_]
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_$Unit of Measure$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Unit of Measure]
      ON
         [Availability Calc_ Overview].[Unit of Measure Code] = [Unit of Measure].[Code]

Show/hide columns in Availability Calc_ Overview table

Column ID	Column Name	Data Type
1	timestamp	timestamp
2	Entry No_	int
3	Type	int
4	Date	datetime
5	Item 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$c526b3e9-b8ca-4683-81ba-fcd5f6b1472a] AS [Item] ON [Availability Calc_ Overview].[Item No_] = [Item].[No_]
6	Location Code	nvarchar(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]
7	Variant Code	nvarchar(20)
8	Unit of Measure Code	nvarchar(20)
	Key to join to the Unit of Measure table. Show/hide example query SELECT [Availability Calc_ Overview].[Unit of Measure Code] ,[Unit of Measure].[Code] FROM [CRONUS UK Ltd_$Availability Calc_ Overview$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Availability Calc_ Overview] LEFT JOIN [CRONUS UK Ltd_$Unit of Measure$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Unit of Measure] ON [Availability Calc_ Overview].[Unit of Measure Code] = [Unit of Measure].[Code]
9	Attached to Entry No_	int
10	Level	int
11	Source Type	int
12	Source Order Status	int
13	Source ID	nvarchar(40)
14	Source Batch Name	nvarchar(20)
15	Source Ref_ No_	int
16	Source Prod_ Order Line	int
17	Description	nvarchar(200)
18	Quantity	decimal(38,38)
19	Reserved Quantity	decimal(38,38)
20	Inventory Running Total	decimal(38,38)
21	Supply Running Total	decimal(38,38)
22	Demand Running Total	decimal(38,38)
23	Running Total	decimal(38,38)
24	Matches Criteria	tinyint
25	$systemId	uniqueidentifier
26	$systemCreatedAt	datetime
27	$systemCreatedBy	uniqueidentifier
28	$systemModifiedAt	datetime
29	$systemModifiedBy	uniqueidentifier

Show/hide tables related from Availability Calc_ Overview table

Item Location Unit of Measure

Dynamics 365 BC Table Reference Tables Company Tables AAvailability Calc_ Overview

Leave a Reply Cancel reply