MS – WorldPay Transaction

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

Table Type: Company

Table Name: MS – WorldPay Transaction
Database Table Name: CRONUS UK Ltd_$MS – WorldPay Transaction$bae453ed-0fd8-4416-afdc-4b09db6c12c3

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

Show/hide an example select of all columns

SELECT
   *
FROM
   [CRONUS UK Ltd_$MS - WorldPay Transaction$bae453ed-0fd8-4416-afdc-4b09db6c12c3]

Show/hide an example select of all columns by name

SELECT

FROM
   [CRONUS UK Ltd_$MS - WorldPay Transaction$bae453ed-0fd8-4416-afdc-4b09db6c12c3]

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

SELECT
   *
FROM
   [CRONUS UK Ltd_$MS - WorldPay Transaction$bae453ed-0fd8-4416-afdc-4b09db6c12c3] AS [MS - WorldPay Transaction]
LEFT JOIN
   [CRONUS UK Ltd_$Currency$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Currency]
      ON
         [MS - WorldPay Transaction].[Currency Code] = [Currency].[Code]

Show/hide columns in MS – WorldPay 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 - WorldPay Transaction].[Currency Code]
       ,[Currency].[Code]
FROM
       [CRONUS UK Ltd_$MS - WorldPay Transaction$bae453ed-0fd8-4416-afdc-4b09db6c12c3] AS [MS - WorldPay Transaction]
LEFT JOIN
       [CRONUS UK Ltd_$Currency$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Currency]
              ON
                     [MS - WorldPay 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 – WorldPay Transaction table

Leave a Reply

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