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$16319982-4995-4fb1-8fb2-2b1e13773e3b

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$16319982-4995-4fb1-8fb2-2b1e13773e3b]

Show/hide an example select of all columns by name

SELECT

   [timestamp]
   ,[Entry No_]
   ,[AMC Recip_ Bank Acc_ Currency]
   ,[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$16319982-4995-4fb1-8fb2-2b1e13773e3b]

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_$Currency$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Currency]
      ON
         [Payment Export Data].[Currency Code] = [Currency].[Code]

Show/hide columns in Payment Export Data table

Column ID	Column Name	Data Type
1	timestamp	timestamp
2	Entry No_	int
3	AMC Recip_ Bank Acc_ Currency	nvarchar(20)
3	Data Exch Entry No_	int
4	Line No_	int
5	Data Exch_ Line Def Code	nvarchar(40)
6	General Journal Template	nvarchar(20)
7	General Journal Batch Name	nvarchar(20)
8	General Journal Line No_	int
9	Sender Bank Name – Data Conv_	nvarchar(100)
10	Sender Bank Name	nvarchar(200)
11	Sender Bank Account Code	nvarchar(40)
12	Sender Bank Account No_	nvarchar(100)
13	Sender Bank Account Currency	nvarchar(20)
14	Sender Bank Country_Region	nvarchar(20)
15	Sender Bank BIC	nvarchar(70)
16	Sender Bank Clearing Std_	nvarchar(100)
17	Sender Bank Clearing Code	nvarchar(100)
18	Sender Bank Address	nvarchar(200)
19	Sender Bank City	nvarchar(100)
20	Sender Bank Post Code	nvarchar(40)
21	Recipient Name	nvarchar(200)
22	Recipient Address	nvarchar(200)
23	Recipient City	nvarchar(100)
24	Recipient Post Code	nvarchar(40)
25	Recipient Country_Region Code	nvarchar(20)
26	Recipient Email Address	nvarchar(160)
27	Recipient ID	nvarchar(40)
28	Recipient Bank Clearing Std_	nvarchar(100)
29	Recipient Bank Clearing Code	nvarchar(100)
30	Recipient Reg_ No_	nvarchar(40)
31	Recipient Acc_ No_	nvarchar(60)
32	Recipient Bank Acc_ No_	nvarchar(100)
33	Recipient Bank BIC	nvarchar(70)
34	Recipient Bank Name	nvarchar(200)
35	Recipient Bank Address	nvarchar(200)
36	Recipient Bank City	nvarchar(100)
37	Recipient Bank Country_Region	nvarchar(20)
38	Recipient Creditor No_	nvarchar(40)
39	Recipient Bank Post Code	nvarchar(40)
40	Message Type	nvarchar(2)
41	Letter to Sender	nvarchar(2)
42	Recipient Acknowledgement	nvarchar(2)
43	Short Advice	nvarchar(70)
44	Message to Recipient 1	nvarchar(280)
45	Message to Recipient 2	nvarchar(280)
46	Amount	decimal(38,38)
47	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$16319982-4995-4fb1-8fb2-2b1e13773e3b] 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]
48	Transfer Date	datetime
49	Transfer Type	nvarchar(2)
50	Payment Type	nvarchar(100)
51	Document No_	nvarchar(40)
52	Recipient Reference	nvarchar(70)
53	Payment Reference	nvarchar(100)
54	Invoice Amount	decimal(38,38)
55	Invoice Date	datetime
56	Recipient County	nvarchar(60)
57	Recipient Bank County	nvarchar(60)
58	Sender Bank County	nvarchar(60)
59	Payment Information ID	nvarchar(100)
60	End-to-End ID	nvarchar(100)
61	Message ID	nvarchar(70)
62	SEPA Instruction Priority	int
63	SEPA Instruction Priority Text	nvarchar(8)
64	SEPA Payment Method	int
65	SEPA Payment Method Text	nvarchar(6)
66	SEPA Batch Booking	tinyint
67	SEPA Charge Bearer	int
68	SEPA Charge Bearer Text	nvarchar(8)
69	SEPA Direct Debit Mandate ID	nvarchar(70)
70	SEPA Direct Debit Seq_ Type	int
71	SEPA Direct Debit Seq_ Text	nvarchar(8)
72	SEPA DD Mandate Signed Date	datetime
73	SEPA Partner Type	int
74	SEPA Partner Type Text	nvarchar(8)
75	Importing Code	nvarchar(20)
76	Importing Date	datetime
77	Importing Description	nvarchar(500)
78	Costs Distribution	nvarchar(60)
79	Message Structure	nvarchar(60)
80	Own Address Info_	nvarchar(60)
81	Creditor No_	nvarchar(70)
82	Transit No_	nvarchar(70)
83	Applies-to Ext_ Doc_ No_	nvarchar(70)
84	Format Command	nvarchar(8)
85	Format Remittance Info Type	nvarchar(2)
86	Format Payment Type	nvarchar(4)
87	Format Expense Code	nvarchar(2)
88	Format Text Code	nvarchar(6)
89	Format Form Type	nvarchar(4)
90	$systemId	uniqueidentifier
91	$systemCreatedAt	datetime
92	$systemCreatedBy	uniqueidentifier
93	$systemModifiedAt	datetime
94	$systemModifiedBy	uniqueidentifier