MS- 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
   [timestamp]
   ,[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_$Currency$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Currency]
      ON
         [MS- PayPal Transaction].[Currency Code] = [Currency].[Code]

Show/hide columns in MS- PayPal Transaction table

Column IDColumn NameData Type
1timestamp Searchtimestamp
2Account ID Primary Key Searchnvarchar(254)
3Transaction ID Primary Key Searchnvarchar(38)
4Transaction Status Searchnvarchar(20)
5Transaction Date Searchdatetime
6Transaction Type Searchnvarchar(56)
7Currency Code Searchnvarchar(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]
8Gross Amount Searchdecimal(38,38)
9Net Amount Searchdecimal(38,38)
10Fee Amount Searchdecimal(38,38)
11Payer E-mail Searchnvarchar(254)
12Payer Name Searchnvarchar(254)
13Payer Address Searchnvarchar(200)
14Note Searchnvarchar(500)
15Custom Searchnvarchar(500)
16Invoice No_ Searchnvarchar(40)
17Response Date Searchdatetime
18Details Searchimage
19$systemId Searchuniqueidentifier
20$systemCreatedAt Searchdatetime
21$systemCreatedBy Searchuniqueidentifier
22$systemModifiedAt Searchdatetime
23$systemModifiedBy Searchuniqueidentifier

Show/hide tables related from MS- PayPal Transaction table

Leave a Reply

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