Purchase Prepayment _ – Dynamics 365 BC Table Reference

Dynamics 365 BC Table Reference Tables Company Tables PPurchase 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 ID	Column Name	Data Type
1	timestamp	timestamp
2	Item No_	nvarchar(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_]
3	Vendor No_	nvarchar(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_]
4	Starting Date	datetime
5	Ending Date	datetime
6	Prepayment _	decimal(38,38)
7	$systemId	uniqueidentifier
8	$systemCreatedAt	datetime
9	$systemCreatedBy	uniqueidentifier
10	$systemModifiedAt	datetime
11	$systemModifiedBy	uniqueidentifier