Cash Flow Availability Buffer

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

Table Type: Company

Table Name: Cash Flow Availability Buffer
Database Table Name: CRONUS UK Ltd_$Cash Flow Availability Buffer$437dbf0e-84ff-417a-965d-ed2bb9650972

Table Number: 930

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 Cash Flow Availability Buffer can be queried.

Show/hide an example select of all columns

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

Show/hide an example select of all columns by name

SELECT
   [Period Type]
   ,[Period Name]
   ,[Period Start]
   ,[Period End]
   ,[Receivables]
   ,[Sales Orders]
   ,[Service Orders]
   ,[Fixed Assets Disposal]
   ,[Cash Flow Manual Revenues]
   ,[Payables]
   ,[Purchase Orders]
   ,[Fixed Assets Budget]
   ,[Cash Flow Manual Expenses]
   ,[G_L Budget]
   ,[Job]
   ,[Tax]
   ,[Total]
   ,[$systemId]
   ,[$systemCreatedAt]
   ,[$systemCreatedBy]
   ,[$systemModifiedAt]
   ,[$systemModifiedBy]
FROM
   [CRONUS UK Ltd_$Cash Flow Availability Buffer$437dbf0e-84ff-417a-965d-ed2bb9650972]

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

SELECT
   *
FROM
   [CRONUS UK Ltd_$Cash Flow Availability Buffer$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Cash Flow Availability Buffer]
LEFT JOIN
   [User] AS [User]
      ON
         [Cash Flow Availability Buffer].[SystemCreatedBy] = [User].[User Security ID]
LEFT JOIN
   [User] AS [User]
      ON
         [Cash Flow Availability Buffer].[SystemModifiedBy] = [User].[User Security ID]

Show/hide columns in Cash Flow Availability Buffer table

Field No.Field NameField CaptionClassTypeLengthSQL Column NameSQL DataType
5Period Type Primary Key SearchPeriod TypeNormalOption4Period Typeint
Available options are:
  • “Day”
  • “Week”
  • “Month”
  • “Quarter”
  • “Year”
  • “Period”
6Period Name SearchPeriod NameNormalText50Period Namenvarchar(100)
7Period Start Primary Key SearchPeriod StartNormalDate4Period Startdatetime
8Period End SearchPeriod EndNormalDate4Period Enddatetime
10Receivables SearchReceivablesNormalDecimal12Receivablesdecimal(38,38)
11Sales Orders SearchSales OrdersNormalDecimal12Sales Ordersdecimal(38,38)
12Service Orders SearchService OrdersNormalDecimal12Service Ordersdecimal(38,38)
13Fixed Assets Disposal SearchFixed Assets DisposalNormalDecimal12Fixed Assets Disposaldecimal(38,38)
14Cash Flow Manual Revenues SearchCash Flow Manual RevenuesNormalDecimal12Cash Flow Manual Revenuesdecimal(38,38)
15Payables SearchPayablesNormalDecimal12Payablesdecimal(38,38)
16Purchase Orders SearchPurchase OrdersNormalDecimal12Purchase Ordersdecimal(38,38)
17Fixed Assets Budget SearchFixed Assets BudgetNormalDecimal12Fixed Assets Budgetdecimal(38,38)
18Cash Flow Manual Expenses SearchCash Flow Manual ExpensesNormalDecimal12Cash Flow Manual Expensesdecimal(38,38)
19G/L Budget SearchG/L BudgetNormalDecimal12G_L Budgetdecimal(38,38)
20Job SearchJobNormalDecimal12Jobdecimal(38,38)
21Tax SearchTaxNormalDecimal12Taxdecimal(38,38)
22Total SearchTotalNormalDecimal12Totaldecimal(38,38)
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
       [Cash Flow Availability Buffer].[$systemCreatedBy]
       ,[User].[User Security ID]
FROM
       [CRONUS UK Ltd_$Cash Flow Availability Buffer$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Cash Flow Availability Buffer]
LEFT JOIN
       [User] AS [User]
              ON
                     [Cash Flow Availability Buffer].[$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
       [Cash Flow Availability Buffer].[$systemModifiedBy]
       ,[User].[User Security ID]
FROM
       [CRONUS UK Ltd_$Cash Flow Availability Buffer$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Cash Flow Availability Buffer]
LEFT JOIN
       [User] AS [User]
              ON
                     [Cash Flow Availability Buffer].[$systemModifiedBy] = [User].[User Security ID]

Leave a Reply

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