MS- PayPal Transaction – Dynamics 365 BC Table Reference

Dynamics 365 BC Table Reference Tables Company Tables MMS- PayPal Transaction

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

Table Type: Company

Table Name: MS- PayPal Transaction
Database Table Name: CRONUS UK Ltd_$MS- PayPal Transaction$437dbf0e-84ff-417a-965d-ed2bb9650972

Table Number: 7862

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 MS- PayPal Transaction can be queried.

Show/hide an example select of all columns

SELECT

   *

FROM

   [CRONUS UK Ltd_$MS- PayPal Transaction$437dbf0e-84ff-417a-965d-ed2bb9650972]

Show/hide an example select of all columns by name

SELECT

   [Account ID]
   ,[Transaction ID]
   ,[Transaction Status]
   ,[Transaction Date]
   ,[Transaction Type]
   ,[Currency Code]
   ,[Gross Amount]
   ,[Net Amount]
   ,[Fee Amount]
   ,[Payer E-mail]
   ,[Payer Name]
   ,[Payer Address]
   ,[Note]
   ,[Custom]
   ,[Invoice No_]
   ,[Response Date]
   ,[Details]
   ,[$systemId]
   ,[$systemCreatedAt]
   ,[$systemCreatedBy]
   ,[$systemModifiedAt]
   ,[$systemModifiedBy]

FROM

   [CRONUS UK Ltd_$MS- PayPal Transaction$437dbf0e-84ff-417a-965d-ed2bb9650972]

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

SELECT
   *
FROM
   [CRONUS UK Ltd_$MS- PayPal Transaction$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [MS- PayPal Transaction]
LEFT JOIN
   [CRONUS UK Ltd_$G_L Account$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [G/L Account]
      ON
         [MS- PayPal Transaction].[Account Id] = [G/L Account].[$systemId]
LEFT JOIN
   [CRONUS UK Ltd_$Transaction Type$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Transaction Type]
      ON
         [MS- PayPal Transaction].[Transaction Type] = [Transaction Type].[Code]
LEFT JOIN
   [CRONUS UK Ltd_$Currency$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Currency]
      ON
         [MS- PayPal Transaction].[Currency Code] = [Currency].[Code]
LEFT JOIN
   [User] AS [User]
      ON
         [MS- PayPal Transaction].[SystemCreatedBy] = [User].[User Security ID]
LEFT JOIN
   [User] AS [User]
      ON
         [MS- PayPal Transaction].[SystemModifiedBy] = [User].[User Security ID]

Show/hide columns in MS- PayPal Transaction table

Field No.	Field Name	Field Caption	Class	Type	Length	SQL Column Name	SQL DataType
1	Account ID	Account ID	Normal	Code	127	Account ID	nvarchar(254)
	Key to join to the G/L Account table. Show/hide example query SELECT [MS- PayPal Transaction].[Account ID] ,[G/L Account].[$systemId] FROM [CRONUS UK Ltd_$MS- PayPal Transaction$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [MS- PayPal Transaction] LEFT JOIN [CRONUS UK Ltd_$G_L Account$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [G/L Account] ON [MS- PayPal Transaction].[Account ID] = [G/L Account].[$systemId]
2	Transaction ID	Transaction ID	Normal	Text	19	Transaction ID	nvarchar(38)
3	Transaction Status	Transaction Status	Normal	Code	10	Transaction Status	nvarchar(20)
4	Transaction Date	Transaction Date	Normal	DateTime	8	Transaction Date	datetime
6	Transaction Type	Transaction Type	Normal	Code	28	Transaction Type	nvarchar(56)
	Key to join to the Transaction Type table. Show/hide example query SELECT [MS- PayPal Transaction].[Transaction Type] ,[Transaction Type].[Code] FROM [CRONUS UK Ltd_$MS- PayPal Transaction$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [MS- PayPal Transaction] LEFT JOIN [CRONUS UK Ltd_$Transaction Type$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Transaction Type] ON [MS- PayPal Transaction].[Transaction Type] = [Transaction Type].[Code]
7	Currency Code	Currency Code	Normal	Code	3	Currency Code	nvarchar(6)
	Key to join to the Currency table. Show/hide example query SELECT [MS- PayPal Transaction].[Currency Code] ,[Currency].[Code] FROM [CRONUS UK Ltd_$MS- PayPal Transaction$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [MS- PayPal Transaction] LEFT JOIN [CRONUS UK Ltd_$Currency$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Currency] ON [MS- PayPal Transaction].[Currency Code] = [Currency].[Code]
8	Gross Amount	Gross Amount	Normal	Decimal	12	Gross Amount	decimal(38,38)
9	Net Amount	Net Amount	Normal	Decimal	12	Net Amount	decimal(38,38)
10	Fee Amount	Fee Amount	Normal	Decimal	12	Fee Amount	decimal(38,38)
11	Payer E-mail	Payer E-mail	Normal	Text	127	Payer E-mail	nvarchar(254)
12	Payer Name	Payer Name	Normal	Text	127	Payer Name	nvarchar(254)
13	Payer Address	Payer Address	Normal	Text	100	Payer Address	nvarchar(200)
14	Note	Note	Normal	Text	250	Note	nvarchar(500)
15	Custom	Custom	Normal	Text	250	Custom	nvarchar(500)
16	Invoice No.	Invoice No.	Normal	Code	20	Invoice No_	nvarchar(40)
101	Response Date	Response Date	Normal	DateTime	8	Response Date	datetime
200	Details	Details	Normal	BLOB	8	Details	image
2000000000	$systemId	System ID	Normal	GUID	16	$systemId	uniqueidentifier
2000000001	SystemCreatedAt	Created At	Normal	DateTime	8	$systemCreatedAt	datetime
2000000002	SystemCreatedBy	Created By	Normal	GUID	16	$systemCreatedBy	uniqueidentifier
	Key to join to the User table. Show/hide example query SELECT [MS- PayPal Transaction].[$systemCreatedBy] ,[User].[User Security ID] FROM [CRONUS UK Ltd_$MS- PayPal Transaction$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [MS- PayPal Transaction] LEFT JOIN [User] AS [User] ON [MS- PayPal Transaction].[$systemCreatedBy] = [User].[User Security ID]
2000000003	SystemModifiedAt	Modified At	Normal	DateTime	8	$systemModifiedAt	datetime
2000000004	SystemModifiedBy	Modified By	Normal	GUID	16	$systemModifiedBy	uniqueidentifier

Show/hide tables related from MS- PayPal Transaction table

Currency

Dynamics 365 BC Table Reference Tables Company Tables MMS- PayPal Transaction

Leave a Reply Cancel reply