Payment Export Data

Dynamics 365 BC Table ReferenceTablesCompany TablesPPayment Export Data

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

Table Type: Company

Table Name: Payment Export Data
Database Table Name: CRONUS UK Ltd_$Payment Export Data$437dbf0e-84ff-417a-965d-ed2bb9650972$ext

Table Number: 1226

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 Payment Export Data can be queried.

Show/hide an example select of all columns

SELECT

   *

FROM

   [CRONUS UK Ltd_$Payment Export Data$437dbf0e-84ff-417a-965d-ed2bb9650972$ext]

Show/hide an example select of all columns by name

SELECT

   [Entry No_]
   ,[Data Exch Entry No_]
   ,[Line No_]
   ,[Data Exch_ Line Def Code]
   ,[General Journal Template]
   ,[General Journal Batch Name]
   ,[General Journal Line No_]
   ,[Sender Bank Name - Data Conv_]
   ,[Sender Bank Name]
   ,[Sender Bank Account Code]
   ,[Sender Bank Account No_]
   ,[Sender Bank Account Currency]
   ,[Sender Bank Country_Region]
   ,[Sender Bank BIC]
   ,[Sender Bank Clearing Std_]
   ,[Sender Bank Clearing Code]
   ,[Sender Bank Address]
   ,[Sender Bank City]
   ,[Sender Bank Post Code]
   ,[Recipient Name]
   ,[Recipient Address]
   ,[Recipient City]
   ,[Recipient Post Code]
   ,[Recipient Country_Region Code]
   ,[Recipient Email Address]
   ,[Recipient ID]
   ,[Recipient Bank Clearing Std_]
   ,[Recipient Bank Clearing Code]
   ,[Recipient Reg_ No_]
   ,[Recipient Acc_ No_]
   ,[Recipient Bank Acc_ No_]
   ,[Recipient Bank BIC]
   ,[Recipient Bank Name]
   ,[Recipient Bank Address]
   ,[Recipient Bank City]
   ,[Recipient Bank Country_Region]
   ,[Recipient Creditor No_]
   ,[Recipient Bank Post Code]
   ,[Message Type]
   ,[Letter to Sender]
   ,[Recipient Acknowledgement]
   ,[Short Advice]
   ,[Message to Recipient 1]
   ,[Message to Recipient 2]
   ,[Amount]
   ,[Currency Code]
   ,[Transfer Date]
   ,[Transfer Type]
   ,[Payment Type]
   ,[Document No_]
   ,[Recipient Reference]
   ,[Payment Reference]
   ,[Invoice Amount]
   ,[Invoice Date]
   ,[Recipient County]
   ,[Recipient Bank County]
   ,[Sender Bank County]
   ,[Payment Information ID]
   ,[End-to-End ID]
   ,[Message ID]
   ,[SEPA Instruction Priority]
   ,[SEPA Instruction Priority Text]
   ,[SEPA Payment Method]
   ,[SEPA Payment Method Text]
   ,[SEPA Batch Booking]
   ,[SEPA Charge Bearer]
   ,[SEPA Charge Bearer Text]
   ,[SEPA Direct Debit Mandate ID]
   ,[SEPA Direct Debit Seq_ Type]
   ,[SEPA Direct Debit Seq_ Text]
   ,[SEPA DD Mandate Signed Date]
   ,[SEPA Partner Type]
   ,[SEPA Partner Type Text]
   ,[Importing Code]
   ,[Importing Date]
   ,[Importing Description]
   ,[Costs Distribution]
   ,[Message Structure]
   ,[Own Address Info_]
   ,[Creditor No_]
   ,[Transit No_]
   ,[Applies-to Ext_ Doc_ No_]
   ,[Format Command]
   ,[Format Remittance Info Type]
   ,[Format Payment Type]
   ,[Format Expense Code]
   ,[Format Text Code]
   ,[Format Form Type]
   ,[$systemId]
   ,[$systemCreatedAt]
   ,[$systemCreatedBy]
   ,[$systemModifiedAt]
   ,[$systemModifiedBy]

FROM

   [CRONUS UK Ltd_$Payment Export Data$437dbf0e-84ff-417a-965d-ed2bb9650972$ext]

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

SELECT
   *
FROM
   [CRONUS UK Ltd_$Payment Export Data$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Payment Export Data]
LEFT JOIN
   [CRONUS UK Ltd_$Gen_ Journal Template$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Gen. Journal Template]
      ON
         [Payment Export Data].[General Journal Template] = [Gen. Journal Template].[Name]
LEFT JOIN
   [CRONUS UK Ltd_$Gen_ Journal Batch$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Gen. Journal Batch]
      ON
         [Payment Export Data].[General Journal Batch Name] = [Gen. Journal Batch].[Journal Template Name]
LEFT JOIN
   [CRONUS UK Ltd_$Bank Account$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Bank Account]
      ON
         [Payment Export Data].[Sender Bank Account Code] = [Bank Account].[No_]
LEFT JOIN
   [CRONUS UK Ltd_$Currency$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Currency]
      ON
         [Payment Export Data].[Sender Bank Account Currency] = [Currency].[Code]
LEFT JOIN
   [CRONUS UK Ltd_$Currency$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Currency]
      ON
         [Payment Export Data].[Currency Code] = [Currency].[Code]
LEFT JOIN
   [CRONUS UK Ltd_$Email Message$63ca2fa4-4f03-4f2b-a480-172fef340d3f] AS [Email Message]
      ON
         [Payment Export Data].[Message Id] = [Email Message].[Id]
LEFT JOIN
   [User] AS [User]
      ON
         [Payment Export Data].[SystemCreatedBy] = [User].[User Security ID]
LEFT JOIN
   [User] AS [User]
      ON
         [Payment Export Data].[SystemModifiedBy] = [User].[User Security ID]

Show/hide columns in Payment Export Data table

Field No.Field NameField CaptionClassTypeLengthSQL Column NameSQL DataType
1Entry No. SearchEntry No.NormalInteger4Entry No_int
2Data Exch Entry No. Primary Key SearchData Exch Entry No.NormalInteger4Data Exch Entry No_int
Key to join to the Data Exch. table.

Show/hide example query

SELECT
	       [Payment Export Data].[Data Exch Entry No_]
	       ,[Data Exch.].[Entry No_]
	FROM
	       [CRONUS UK Ltd_$Payment Export Data$437dbf0e-84ff-417a-965d-ed2bb9650972$ext] AS [Payment Export Data]
	LEFT JOIN
	       [CRONUS UK Ltd_$Data Exch_$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Data Exch.]
	              ON
	                     [Payment Export Data].[Data Exch Entry No_] = [Data Exch.].[Entry No_]
3Line No. SearchLine No.NormalInteger4Line No_int
4Data Exch. Line Def Code SearchData Exch. Line Def CodeNormalCode20Data Exch_ Line Def Codenvarchar(40)
Key to join to the Data Exch. Line Def table.

Show/hide example query

SELECT
	       [Payment Export Data].[Data Exch_ Line Def Code]
	       ,[Data Exch. Line Def].[Code]
	FROM
	       [CRONUS UK Ltd_$Payment Export Data$437dbf0e-84ff-417a-965d-ed2bb9650972$ext] AS [Payment Export Data]
	LEFT JOIN
	       [CRONUS UK Ltd_$Data Exch_ Line Def$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Data Exch. Line Def]
	              ON
	                     [Payment Export Data].[Data Exch_ Line Def Code] = [Data Exch. Line Def].[Code]
5General Journal Template SearchGeneral Journal TemplateNormalCode10General Journal Templatenvarchar(20)
Key to join to the Gen. Journal Template table.

Show/hide example query

SELECT
	       [Payment Export Data].[General Journal Template]
	       ,[Gen. Journal Template].[Name]
	FROM
	       [CRONUS UK Ltd_$Payment Export Data$437dbf0e-84ff-417a-965d-ed2bb9650972$ext] AS [Payment Export Data]
	LEFT JOIN
	       [CRONUS UK Ltd_$Gen_ Journal Template$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Gen. Journal Template]
	              ON
	                     [Payment Export Data].[General Journal Template] = [Gen. Journal Template].[Name]
6General Journal Batch Name SearchGeneral Journal Batch NameNormalCode10General Journal Batch Namenvarchar(20)
Key to join to the Gen. Journal Batch table.

Show/hide example query

SELECT
	       [Payment Export Data].[General Journal Batch Name]
	       ,[Gen. Journal Batch].[Journal Template Name]
	FROM
	       [CRONUS UK Ltd_$Payment Export Data$437dbf0e-84ff-417a-965d-ed2bb9650972$ext] AS [Payment Export Data]
	LEFT JOIN
	       [CRONUS UK Ltd_$Gen_ Journal Batch$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Gen. Journal Batch]
	              ON
	                     [Payment Export Data].[General Journal Batch Name] = [Gen. Journal Batch].[Journal Template Name]
7General Journal Line No. SearchGeneral Journal Line No.NormalInteger4General Journal Line No_int
28Sender Bank Name – Data Conv. SearchSender Bank Name – Data Conv.NormalText50Sender Bank Name – Data Conv_nvarchar(100)
29Sender Bank Name SearchSender Bank NameNormalText100Sender Bank Namenvarchar(200)
30Sender Bank Account Code SearchSender Bank Account CodeNormalCode20Sender Bank Account Codenvarchar(40)
Key to join to the Bank Account table.

Show/hide example query

SELECT
	       [Payment Export Data].[Sender Bank Account Code]
	       ,[Bank Account].[No_]
	FROM
	       [CRONUS UK Ltd_$Payment Export Data$437dbf0e-84ff-417a-965d-ed2bb9650972$ext] AS [Payment Export Data]
	LEFT JOIN
	       [CRONUS UK Ltd_$Bank Account$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Bank Account]
	              ON
	                     [Payment Export Data].[Sender Bank Account Code] = [Bank Account].[No_]
31Sender Bank Account No. SearchSender Bank Account No.NormalText50Sender Bank Account No_nvarchar(100)
32Sender Bank Account Currency SearchSender Bank Account CurrencyNormalCode10Sender Bank Account Currencynvarchar(20)
Key to join to the Currency table.

Show/hide example query

SELECT
	       [Payment Export Data].[Sender Bank Account Currency]
	       ,[Currency].[Code]
	FROM
	       [CRONUS UK Ltd_$Payment Export Data$437dbf0e-84ff-417a-965d-ed2bb9650972$ext] AS [Payment Export Data]
	LEFT JOIN
	       [CRONUS UK Ltd_$Currency$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Currency]
	              ON
	                     [Payment Export Data].[Sender Bank Account Currency] = [Currency].[Code]
33Sender Bank Country/Region SearchSender Bank Country/RegionNormalCode10Sender Bank Country_Regionnvarchar(20)
34Sender Bank BIC SearchSender Bank BICNormalCode35Sender Bank BICnvarchar(70)
35Sender Bank Clearing Std. SearchSender Bank Clearing Std.NormalText50Sender Bank Clearing Std_nvarchar(100)
Key to join to the Bank Clearing Standard table.

Show/hide example query

SELECT
	       [Payment Export Data].[Sender Bank Clearing Std_]
	       ,[Bank Clearing Standard].[Code]
	FROM
	       [CRONUS UK Ltd_$Payment Export Data$437dbf0e-84ff-417a-965d-ed2bb9650972$ext] AS [Payment Export Data]
	LEFT JOIN
	       [CRONUS UK Ltd_$Bank Clearing Standard$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Bank Clearing Standard]
	              ON
	                     [Payment Export Data].[Sender Bank Clearing Std_] = [Bank Clearing Standard].[Code]
36Sender Bank Clearing Code SearchSender Bank Clearing CodeNormalText50Sender Bank Clearing Codenvarchar(100)
37Sender Bank Address SearchSender Bank AddressNormalText100Sender Bank Addressnvarchar(200)
38Sender Bank City SearchSender Bank CityNormalText50Sender Bank Citynvarchar(100)
39Sender Bank Post Code SearchSender Bank ZIP CodeNormalCode20Sender Bank Post Codenvarchar(40)
40Recipient Name SearchRecipient NameNormalText100Recipient Namenvarchar(200)
41Recipient Address SearchRecipient AddressNormalText100Recipient Addressnvarchar(200)
42Recipient City SearchRecipient CityNormalText50Recipient Citynvarchar(100)
43Recipient Post Code SearchRecipient ZIP CodeNormalCode20Recipient Post Codenvarchar(40)
44Recipient Country/Region Code SearchRecipient Country/Region CodeNormalCode10Recipient Country_Region Codenvarchar(20)
45Recipient Email Address SearchRecipient Email AddressNormalText80Recipient Email Addressnvarchar(160)
46Recipient ID SearchRecipient IDNormalCode20Recipient IDnvarchar(40)
48Recipient Bank Clearing Std. SearchRecipient Bank Clearing Std.NormalText50Recipient Bank Clearing Std_nvarchar(100)
Key to join to the Bank Clearing Standard table.

Show/hide example query

SELECT
	       [Payment Export Data].[Recipient Bank Clearing Std_]
	       ,[Bank Clearing Standard].[Code]
	FROM
	       [CRONUS UK Ltd_$Payment Export Data$437dbf0e-84ff-417a-965d-ed2bb9650972$ext] AS [Payment Export Data]
	LEFT JOIN
	       [CRONUS UK Ltd_$Bank Clearing Standard$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Bank Clearing Standard]
	              ON
	                     [Payment Export Data].[Recipient Bank Clearing Std_] = [Bank Clearing Standard].[Code]
49Recipient Bank Clearing Code SearchRecipient Bank Clearing CodeNormalText50Recipient Bank Clearing Codenvarchar(100)
50Recipient Reg. No. SearchRecipient Reg. No.NormalCode20Recipient Reg_ No_nvarchar(40)
51Recipient Acc. No. SearchRecipient Acc. No.NormalCode30Recipient Acc_ No_nvarchar(60)
52Recipient Bank Acc. No. SearchRecipient Bank Acc. No.NormalText50Recipient Bank Acc_ No_nvarchar(100)
53Recipient Bank BIC SearchRecipient Bank BICNormalCode35Recipient Bank BICnvarchar(70)
54Recipient Bank Name SearchRecipient Bank NameNormalText100Recipient Bank Namenvarchar(200)
55Recipient Bank Address SearchRecipient Bank AddressNormalText100Recipient Bank Addressnvarchar(200)
56Recipient Bank City SearchRecipient Bank CityNormalText50Recipient Bank Citynvarchar(100)
57Recipient Bank Country/Region SearchRecipient Bank Country/RegionNormalCode10Recipient Bank Country_Regionnvarchar(20)
58Recipient Creditor No. SearchRecipient Creditor No.NormalCode20Recipient Creditor No_nvarchar(40)
59Recipient Bank Post Code SearchRecipient Bank ZIP CodeNormalCode20Recipient Bank Post Codenvarchar(40)
60Message Type SearchMessage TypeNormalCode1Message Typenvarchar(2)
61Letter to Sender SearchLetter to SenderNormalCode1Letter to Sendernvarchar(2)
63Recipient Acknowledgement SearchRecipient AcknowledgementNormalCode1Recipient Acknowledgementnvarchar(2)
64Short Advice SearchShort AdviceNormalText35Short Advicenvarchar(70)
65Message to Recipient 1 SearchMessage to Recipient 1NormalText140Message to Recipient 1nvarchar(280)
66Message to Recipient 2 SearchMessage to Recipient 2NormalText140Message to Recipient 2nvarchar(280)
80Amount SearchAmountNormalDecimal12Amountdecimal(38,38)
81Currency Code SearchCurrency CodeNormalCode10Currency Codenvarchar(20)
Key to join to the Currency table.

Show/hide example query

SELECT
	       [Payment Export Data].[Currency Code]
	       ,[Currency].[Code]
	FROM
	       [CRONUS UK Ltd_$Payment Export Data$437dbf0e-84ff-417a-965d-ed2bb9650972$ext] AS [Payment Export Data]
	LEFT JOIN
	       [CRONUS UK Ltd_$Currency$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Currency]
	              ON
	                     [Payment Export Data].[Currency Code] = [Currency].[Code]
82Transfer Date SearchTransfer DateNormalDate4Transfer Datedatetime
83Transfer Type SearchTransfer TypeNormalCode1Transfer Typenvarchar(2)
84Payment Type SearchPayment TypeNormalText50Payment Typenvarchar(100)
85Document No. SearchDocument No.NormalCode20Document No_nvarchar(40)
87Recipient Reference SearchRecipient ReferenceNormalCode35Recipient Referencenvarchar(70)
88Payment Reference SearchPayment ReferenceNormalCode50Payment Referencenvarchar(100)
89Invoice Amount SearchInvoice AmountNormalDecimal12Invoice Amountdecimal(38,38)
90Invoice Date SearchInvoice DateNormalDate4Invoice Datedatetime
91Recipient County SearchRecipient StateNormalText30Recipient Countynvarchar(60)
92Recipient Bank County SearchRecipient Bank StateNormalText30Recipient Bank Countynvarchar(60)
93Sender Bank County SearchSender Bank StateNormalText30Sender Bank Countynvarchar(60)
100Payment Information ID SearchPayment Information IDNormalText50Payment Information IDnvarchar(100)
101End-to-End ID SearchEnd-to-End IDNormalText50End-to-End IDnvarchar(100)
102Message ID SearchMessage IDNormalText35Message IDnvarchar(70)
Key to join to the Email Message table.

Show/hide example query

SELECT
	       [Payment Export Data].[Message ID]
	       ,[Email Message].[Id]
	FROM
	       [CRONUS UK Ltd_$Payment Export Data$437dbf0e-84ff-417a-965d-ed2bb9650972$ext] AS [Payment Export Data]
	LEFT JOIN
	       [CRONUS UK Ltd_$Email Message$63ca2fa4-4f03-4f2b-a480-172fef340d3f] AS [Email Message]
	              ON
	                     [Payment Export Data].[Message ID] = [Email Message].[Id]
103SEPA Instruction Priority SearchSEPA Instruction PriorityNormalOption4SEPA Instruction Priorityint
Available options are:
  • “NORMAL”
  • “HIGH”
104SEPA Instruction Priority Text SearchSEPA Instruction Priority TextNormalCode4SEPA Instruction Priority Textnvarchar(8)
105SEPA Payment Method SearchSEPA Payment MethodNormalOption4SEPA Payment Methodint
Available options are:
  • “CHK”
  • “TRF”
  • “TRA”
106SEPA Payment Method Text SearchSEPA Payment Method TextNormalCode3SEPA Payment Method Textnvarchar(6)
107SEPA Batch Booking SearchSEPA Batch BookingNormalBoolean4SEPA Batch Bookingtinyint
108SEPA Charge Bearer SearchSEPA Charge BearerNormalOption4SEPA Charge Bearerint
Available options are:
  • “DEBT”
  • “CRED”
  • “SHAR”
  • “SLEV”
109SEPA Charge Bearer Text SearchSEPA Charge Bearer TextNormalCode4SEPA Charge Bearer Textnvarchar(8)
120SEPA Direct Debit Mandate ID SearchSEPA Direct Debit Mandate IDNormalCode35SEPA Direct Debit Mandate IDnvarchar(70)
121SEPA Direct Debit Seq. Type SearchSEPA Direct Debit Seq. TypeNormalOption4SEPA Direct Debit Seq_ Typeint
Available options are:
  • “One Off”
  • “First”
  • “Recurring”
  • “Last”
122SEPA Direct Debit Seq. Text SearchSEPA Direct Debit Seq. TextNormalCode4SEPA Direct Debit Seq_ Textnvarchar(8)
123SEPA DD Mandate Signed Date SearchSEPA DD Mandate Signed DateNormalDate4SEPA DD Mandate Signed Datedatetime
124SEPA Partner Type SearchSEPA Partner TypeNormalOption4SEPA Partner Typeint
Available options are:
  • ” “
  • “Company”
  • “Person”
125SEPA Partner Type Text SearchSEPA Partner Type TextNormalCode4SEPA Partner Type Textnvarchar(8)
130Importing Code SearchImporting CodeNormalCode10Importing Codenvarchar(20)
131Importing Date SearchImporting DateNormalDate4Importing Datedatetime
132Importing Description SearchImporting DescriptionNormalText250Importing Descriptionnvarchar(500)
133Costs Distribution SearchCosts DistributionNormalText30Costs Distributionnvarchar(60)
134Message Structure SearchMessage StructureNormalText30Message Structurenvarchar(60)
135Own Address Info. SearchOwn Address Info.NormalText30Own Address Info_nvarchar(60)
170Creditor No. SearchCreditor No.NormalCode35Creditor No_nvarchar(70)
171Transit No. SearchTransit No.NormalCode35Transit No_nvarchar(70)
173Applies-to Ext. Doc. No. SearchApplies-to Ext. Doc. No.NormalCode35Applies-to Ext_ Doc_ No_nvarchar(70)
200Format Command SearchFormat CommandNormalCode4Format Commandnvarchar(8)
201Format Remittance Info Type SearchFormat Remittance Info TypeNormalCode1Format Remittance Info Typenvarchar(2)
220Format Payment Type SearchFormat Payment TypeNormalCode2Format Payment Typenvarchar(4)
221Format Expense Code SearchFormat Expense CodeNormalCode1Format Expense Codenvarchar(2)
222Format Text Code SearchFormat Text CodeNormalCode3Format Text Codenvarchar(6)
283Format Form Type SearchFormat Form TypeNormalCode2Format Form Typenvarchar(4)
20100AMC Recip. Bank Acc. Currency SearchRecipient Bank Account CurrencyNormalCode10
Key to join to the Currency table.

Show/hide example query

SELECT
	       [Payment Export Data].[]
	       ,[Currency].[Code]
	FROM
	       [CRONUS UK Ltd_$Payment Export Data$437dbf0e-84ff-417a-965d-ed2bb9650972$ext] AS [Payment Export Data]
	LEFT JOIN
	       [CRONUS UK Ltd_$Currency$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Currency]
	              ON
	                     [Payment Export Data].[] = [Currency].[Code]
2000000000$systemId SearchSystem IDNormalGUID16$systemIduniqueidentifier
2000000001SystemCreatedAt SearchCreated AtNormalDateTime8$systemCreatedAtdatetime
2000000002SystemCreatedBy SearchCreated ByNormalGUID16$systemCreatedByuniqueidentifier
Key to join to the User table.

Show/hide example query

SELECT
	       [Payment Export Data].[$systemCreatedBy]
	       ,[User].[User Security ID]
	FROM
	       [CRONUS UK Ltd_$Payment Export Data$437dbf0e-84ff-417a-965d-ed2bb9650972$ext] AS [Payment Export Data]
	LEFT JOIN
	       [User] AS [User]
	              ON
	                     [Payment Export Data].[$systemCreatedBy] = [User].[User Security ID]
2000000003SystemModifiedAt SearchModified AtNormalDateTime8$systemModifiedAtdatetime
2000000004SystemModifiedBy SearchModified ByNormalGUID16$systemModifiedByuniqueidentifier

Show/hide tables related from Payment Export Data table

Currency
Dynamics 365 BC Table ReferenceTablesCompany TablesPPayment Export Data

Leave a Reply

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