Payment Export Data – Dynamics 365 BC Table Reference

Dynamics 365 BC Table Reference Tables Company Tables PPayment 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 Name	Field Caption	Class	Type	Length	SQL Column Name	SQL DataType
1	Entry No.	Entry No.	Normal	Integer	4	Entry No_	int
2	Data Exch Entry No.	Data Exch Entry No.	Normal	Integer	4	Data 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_]
3	Line No.	Line No.	Normal	Integer	4	Line No_	int
4	Data Exch. Line Def Code	Data Exch. Line Def Code	Normal	Code	20	Data Exch_ Line Def Code	nvarchar(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]
5	General Journal Template	General Journal Template	Normal	Code	10	General Journal Template	nvarchar(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]
6	General Journal Batch Name	General Journal Batch Name	Normal	Code	10	General Journal Batch Name	nvarchar(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]
7	General Journal Line No.	General Journal Line No.	Normal	Integer	4	General Journal Line No_	int
28	Sender Bank Name – Data Conv.	Sender Bank Name – Data Conv.	Normal	Text	50	Sender Bank Name – Data Conv_	nvarchar(100)
29	Sender Bank Name	Sender Bank Name	Normal	Text	100	Sender Bank Name	nvarchar(200)
30	Sender Bank Account Code	Sender Bank Account Code	Normal	Code	20	Sender Bank Account Code	nvarchar(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_]
31	Sender Bank Account No.	Sender Bank Account No.	Normal	Text	50	Sender Bank Account No_	nvarchar(100)
32	Sender Bank Account Currency	Sender Bank Account Currency	Normal	Code	10	Sender Bank Account Currency	nvarchar(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]
33	Sender Bank Country/Region	Sender Bank Country/Region	Normal	Code	10	Sender Bank Country_Region	nvarchar(20)
34	Sender Bank BIC	Sender Bank BIC	Normal	Code	35	Sender Bank BIC	nvarchar(70)
35	Sender Bank Clearing Std.	Sender Bank Clearing Std.	Normal	Text	50	Sender 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]
36	Sender Bank Clearing Code	Sender Bank Clearing Code	Normal	Text	50	Sender Bank Clearing Code	nvarchar(100)
37	Sender Bank Address	Sender Bank Address	Normal	Text	100	Sender Bank Address	nvarchar(200)
38	Sender Bank City	Sender Bank City	Normal	Text	50	Sender Bank City	nvarchar(100)
39	Sender Bank Post Code	Sender Bank ZIP Code	Normal	Code	20	Sender Bank Post Code	nvarchar(40)
40	Recipient Name	Recipient Name	Normal	Text	100	Recipient Name	nvarchar(200)
41	Recipient Address	Recipient Address	Normal	Text	100	Recipient Address	nvarchar(200)
42	Recipient City	Recipient City	Normal	Text	50	Recipient City	nvarchar(100)
43	Recipient Post Code	Recipient ZIP Code	Normal	Code	20	Recipient Post Code	nvarchar(40)
44	Recipient Country/Region Code	Recipient Country/Region Code	Normal	Code	10	Recipient Country_Region Code	nvarchar(20)
45	Recipient Email Address	Recipient Email Address	Normal	Text	80	Recipient Email Address	nvarchar(160)
46	Recipient ID	Recipient ID	Normal	Code	20	Recipient ID	nvarchar(40)
48	Recipient Bank Clearing Std.	Recipient Bank Clearing Std.	Normal	Text	50	Recipient 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]
49	Recipient Bank Clearing Code	Recipient Bank Clearing Code	Normal	Text	50	Recipient Bank Clearing Code	nvarchar(100)
50	Recipient Reg. No.	Recipient Reg. No.	Normal	Code	20	Recipient Reg_ No_	nvarchar(40)
51	Recipient Acc. No.	Recipient Acc. No.	Normal	Code	30	Recipient Acc_ No_	nvarchar(60)
52	Recipient Bank Acc. No.	Recipient Bank Acc. No.	Normal	Text	50	Recipient Bank Acc_ No_	nvarchar(100)
53	Recipient Bank BIC	Recipient Bank BIC	Normal	Code	35	Recipient Bank BIC	nvarchar(70)
54	Recipient Bank Name	Recipient Bank Name	Normal	Text	100	Recipient Bank Name	nvarchar(200)
55	Recipient Bank Address	Recipient Bank Address	Normal	Text	100	Recipient Bank Address	nvarchar(200)
56	Recipient Bank City	Recipient Bank City	Normal	Text	50	Recipient Bank City	nvarchar(100)
57	Recipient Bank Country/Region	Recipient Bank Country/Region	Normal	Code	10	Recipient Bank Country_Region	nvarchar(20)
58	Recipient Creditor No.	Recipient Creditor No.	Normal	Code	20	Recipient Creditor No_	nvarchar(40)
59	Recipient Bank Post Code	Recipient Bank ZIP Code	Normal	Code	20	Recipient Bank Post Code	nvarchar(40)
60	Message Type	Message Type	Normal	Code	1	Message Type	nvarchar(2)
61	Letter to Sender	Letter to Sender	Normal	Code	1	Letter to Sender	nvarchar(2)
63	Recipient Acknowledgement	Recipient Acknowledgement	Normal	Code	1	Recipient Acknowledgement	nvarchar(2)
64	Short Advice	Short Advice	Normal	Text	35	Short Advice	nvarchar(70)
65	Message to Recipient 1	Message to Recipient 1	Normal	Text	140	Message to Recipient 1	nvarchar(280)
66	Message to Recipient 2	Message to Recipient 2	Normal	Text	140	Message to Recipient 2	nvarchar(280)
80	Amount	Amount	Normal	Decimal	12	Amount	decimal(38,38)
81	Currency Code	Currency Code	Normal	Code	10	Currency Code	nvarchar(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]
82	Transfer Date	Transfer Date	Normal	Date	4	Transfer Date	datetime
83	Transfer Type	Transfer Type	Normal	Code	1	Transfer Type	nvarchar(2)
84	Payment Type	Payment Type	Normal	Text	50	Payment Type	nvarchar(100)
85	Document No.	Document No.	Normal	Code	20	Document No_	nvarchar(40)
87	Recipient Reference	Recipient Reference	Normal	Code	35	Recipient Reference	nvarchar(70)
88	Payment Reference	Payment Reference	Normal	Code	50	Payment Reference	nvarchar(100)
89	Invoice Amount	Invoice Amount	Normal	Decimal	12	Invoice Amount	decimal(38,38)
90	Invoice Date	Invoice Date	Normal	Date	4	Invoice Date	datetime
91	Recipient County	Recipient State	Normal	Text	30	Recipient County	nvarchar(60)
92	Recipient Bank County	Recipient Bank State	Normal	Text	30	Recipient Bank County	nvarchar(60)
93	Sender Bank County	Sender Bank State	Normal	Text	30	Sender Bank County	nvarchar(60)
100	Payment Information ID	Payment Information ID	Normal	Text	50	Payment Information ID	nvarchar(100)
101	End-to-End ID	End-to-End ID	Normal	Text	50	End-to-End ID	nvarchar(100)
102	Message ID	Message ID	Normal	Text	35	Message ID	nvarchar(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]
103	SEPA Instruction Priority	SEPA Instruction Priority	Normal	Option	4	SEPA Instruction Priority	int
	Available options are: “NORMAL” “HIGH”
104	SEPA Instruction Priority Text	SEPA Instruction Priority Text	Normal	Code	4	SEPA Instruction Priority Text	nvarchar(8)
105	SEPA Payment Method	SEPA Payment Method	Normal	Option	4	SEPA Payment Method	int
	Available options are: “CHK” “TRF” “TRA”
106	SEPA Payment Method Text	SEPA Payment Method Text	Normal	Code	3	SEPA Payment Method Text	nvarchar(6)
107	SEPA Batch Booking	SEPA Batch Booking	Normal	Boolean	4	SEPA Batch Booking	tinyint
108	SEPA Charge Bearer	SEPA Charge Bearer	Normal	Option	4	SEPA Charge Bearer	int
	Available options are: “DEBT” “CRED” “SHAR” “SLEV”
109	SEPA Charge Bearer Text	SEPA Charge Bearer Text	Normal	Code	4	SEPA Charge Bearer Text	nvarchar(8)
120	SEPA Direct Debit Mandate ID	SEPA Direct Debit Mandate ID	Normal	Code	35	SEPA Direct Debit Mandate ID	nvarchar(70)
121	SEPA Direct Debit Seq. Type	SEPA Direct Debit Seq. Type	Normal	Option	4	SEPA Direct Debit Seq_ Type	int
	Available options are: “One Off” “First” “Recurring” “Last”
122	SEPA Direct Debit Seq. Text	SEPA Direct Debit Seq. Text	Normal	Code	4	SEPA Direct Debit Seq_ Text	nvarchar(8)
123	SEPA DD Mandate Signed Date	SEPA DD Mandate Signed Date	Normal	Date	4	SEPA DD Mandate Signed Date	datetime
124	SEPA Partner Type	SEPA Partner Type	Normal	Option	4	SEPA Partner Type	int
	Available options are: ” “ “Company” “Person”
125	SEPA Partner Type Text	SEPA Partner Type Text	Normal	Code	4	SEPA Partner Type Text	nvarchar(8)
130	Importing Code	Importing Code	Normal	Code	10	Importing Code	nvarchar(20)
131	Importing Date	Importing Date	Normal	Date	4	Importing Date	datetime
132	Importing Description	Importing Description	Normal	Text	250	Importing Description	nvarchar(500)
133	Costs Distribution	Costs Distribution	Normal	Text	30	Costs Distribution	nvarchar(60)
134	Message Structure	Message Structure	Normal	Text	30	Message Structure	nvarchar(60)
135	Own Address Info.	Own Address Info.	Normal	Text	30	Own Address Info_	nvarchar(60)
170	Creditor No.	Creditor No.	Normal	Code	35	Creditor No_	nvarchar(70)
171	Transit No.	Transit No.	Normal	Code	35	Transit No_	nvarchar(70)
173	Applies-to Ext. Doc. No.	Applies-to Ext. Doc. No.	Normal	Code	35	Applies-to Ext_ Doc_ No_	nvarchar(70)
200	Format Command	Format Command	Normal	Code	4	Format Command	nvarchar(8)
201	Format Remittance Info Type	Format Remittance Info Type	Normal	Code	1	Format Remittance Info Type	nvarchar(2)
220	Format Payment Type	Format Payment Type	Normal	Code	2	Format Payment Type	nvarchar(4)
221	Format Expense Code	Format Expense Code	Normal	Code	1	Format Expense Code	nvarchar(2)
222	Format Text Code	Format Text Code	Normal	Code	3	Format Text Code	nvarchar(6)
283	Format Form Type	Format Form Type	Normal	Code	2	Format Form Type	nvarchar(4)
20100	AMC Recip. Bank Acc. Currency	Recipient Bank Account Currency	Normal	Code	10
	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	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 [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]
2000000003	SystemModifiedAt	Modified At	Normal	DateTime	8	$systemModifiedAt	datetime
2000000004	SystemModifiedBy	Modified By	Normal	GUID	16	$systemModifiedBy	uniqueidentifier

Show/hide tables related from Payment Export Data table

Dynamics 365 BC Table Reference Tables Company Tables PPayment Export Data

Leave a Reply Cancel reply