Purchase Prepayment _

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

Table Type: Company

Table Name: Purchase Prepayment _
Database Table Name: CRONUS UK Ltd_$Purchase Prepayment _$437dbf0e-84ff-417a-965d-ed2bb9650972

Table Number: 0

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 Purchase Prepayment _ can be queried.

Show/hide an example select of all columns

SELECT
   *
FROM
   [CRONUS UK Ltd_$Purchase Prepayment _$437dbf0e-84ff-417a-965d-ed2bb9650972]

Show/hide an example select of all columns by name

SELECT
   [timestamp]
   ,[Item No_]
   ,[Vendor No_]
   ,[Starting Date]
   ,[Ending Date]
   ,[Prepayment _]
   ,[$systemId]
   ,[$systemCreatedAt]
   ,[$systemCreatedBy]
   ,[$systemModifiedAt]
   ,[$systemModifiedBy]
FROM
   [CRONUS UK Ltd_$Purchase Prepayment _$437dbf0e-84ff-417a-965d-ed2bb9650972]

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

SELECT
   *
FROM
   [CRONUS UK Ltd_$Purchase Prepayment _$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Purchase Prepayment _]
LEFT JOIN
   [CRONUS UK Ltd_$Item$c526b3e9-b8ca-4683-81ba-fcd5f6b1472a] AS [Item]
      ON
         [Purchase Prepayment _].[Item No_] = [Item].[No_]
LEFT JOIN
   [CRONUS UK Ltd_$Vendor$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Vendor]
      ON
         [Purchase Prepayment _].[Vendor No_] = [Vendor].[No_]

Show/hide columns in Purchase Prepayment _ table

Column IDColumn NameData Type
1timestamp Searchtimestamp
2Item No_ Primary Key Searchnvarchar(40)
Key to join to the Item table.

Show/hide example query

SELECT
       [Purchase Prepayment _].[Item No_]
       ,[Item].[No_]
FROM
       [CRONUS UK Ltd_$Purchase Prepayment _$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Purchase Prepayment _]
LEFT JOIN
       [CRONUS UK Ltd_$Item$c526b3e9-b8ca-4683-81ba-fcd5f6b1472a] AS [Item]
              ON
                     [Purchase Prepayment _].[Item No_] = [Item].[No_]
3Vendor No_ Primary Key Searchnvarchar(40)
Key to join to the Vendor table.

Show/hide example query

SELECT
       [Purchase Prepayment _].[Vendor No_]
       ,[Vendor].[No_]
FROM
       [CRONUS UK Ltd_$Purchase Prepayment _$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Purchase Prepayment _]
LEFT JOIN
       [CRONUS UK Ltd_$Vendor$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Vendor]
              ON
                     [Purchase Prepayment _].[Vendor No_] = [Vendor].[No_]
4Starting Date Primary Key Searchdatetime
5Ending Date Searchdatetime
6Prepayment _ Searchdecimal(38,38)
7$systemId Searchuniqueidentifier
8$systemCreatedAt Searchdatetime
9$systemCreatedBy Searchuniqueidentifier
10$systemModifiedAt Searchdatetime
11$systemModifiedBy Searchuniqueidentifier

Show/hide tables related from Purchase Prepayment _ table

Leave a Reply

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