Payment Registration Buffer – Dynamics 365 BC Table Reference

Dynamics 365 BC Table Reference Tables Company Tables PPayment Registration Buffer

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

Table Type: Company

Table Name: Payment Registration Buffer
Database Table Name: CRONUS UK Ltd_$Payment Registration Buffer$437dbf0e-84ff-417a-965d-ed2bb9650972

Table Number: 981

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 Registration Buffer can be queried.

Show/hide an example select of all columns

SELECT

   *

FROM

   [CRONUS UK Ltd_$Payment Registration Buffer$437dbf0e-84ff-417a-965d-ed2bb9650972]

Show/hide an example select of all columns by name

SELECT

   [Ledger Entry No_]
   ,[Source No_]
   ,[Document Type]
   ,[Document No_]
   ,[Description]
   ,[Due Date]
   ,[Name]
   ,[Remaining Amount]
   ,[Payment Made]
   ,[Date Received]
   ,[Amount Received]
   ,[Original Remaining Amount]
   ,[Rem_ Amt_ after Discount]
   ,[Pmt_ Discount Date]
   ,[Limit Amount Received]
   ,[Payment Method Code]
   ,[Bal_ Account Type]
   ,[Bal_ Account No_]
   ,[External Document No_]
   ,[$systemId]
   ,[$systemCreatedAt]
   ,[$systemCreatedBy]
   ,[$systemModifiedAt]
   ,[$systemModifiedBy]

FROM

   [CRONUS UK Ltd_$Payment Registration Buffer$437dbf0e-84ff-417a-965d-ed2bb9650972]

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

SELECT
   *
FROM
   [CRONUS UK Ltd_$Payment Registration Buffer$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Payment Registration Buffer]
LEFT JOIN
   [CRONUS UK Ltd_$Sales Header Archive$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Sales Header Archive]
      ON
         [Payment Registration Buffer].[Document Type] = [Sales Header Archive].[Document Type]
      AND
         [Payment Registration Buffer].[Document No_] = [Sales Header Archive].[No_]
LEFT JOIN
   [CRONUS UK Ltd_$Sales Header$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Sales Header]
      ON
         [Payment Registration Buffer].[Document Type] = [Sales Header].[Document Type]
      AND
         [Payment Registration Buffer].[Document No_] = [Sales Header].[No_]
LEFT JOIN
   [CRONUS UK Ltd_$Payment Method$437dbf0e-84ff-417a-965d-ed2bb9650972$ext] AS [Payment Method]
      ON
         [Payment Registration Buffer].[Payment Method Code] = [Payment Method].[Code]
LEFT JOIN
   [User] AS [User]
      ON
         [Payment Registration Buffer].[SystemCreatedBy] = [User].[User Security ID]
LEFT JOIN
   [User] AS [User]
      ON
         [Payment Registration Buffer].[SystemModifiedBy] = [User].[User Security ID]

Show/hide columns in Payment Registration Buffer table

Field No.	Field Name	Field Caption	Class	Type	Length	SQL Column Name	SQL DataType
1	Ledger Entry No.	Ledger Entry No.	Normal	Integer	4	Ledger Entry No_	int
	Key to join to the G/L Entry table. Show/hide example query SELECT [Payment Registration Buffer].[Ledger Entry No_] ,[G/L Entry].[Entry No_] FROM [CRONUS UK Ltd_$Payment Registration Buffer$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Payment Registration Buffer] LEFT JOIN [CRONUS UK Ltd_$G_L Entry$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [G/L Entry] ON [Payment Registration Buffer].[Ledger Entry No_] = [G/L Entry].[Entry No_]
2	Source No.	Source No.	Normal	Code	20	Source No_	nvarchar(40)
3	Document Type	Document Type	Normal	Option	4	Document Type	int
	Available options are: ” “ “Payment” “Invoice” “Credit Memo” “Finance Charge Memo” “Reminder” “Refund”
4	Document No.	Document No.	Normal	Code	20	Document No_	nvarchar(40)
5	Description	Description	Normal	Text	100	Description	nvarchar(200)
6	Due Date	Due Date	Normal	Date	4	Due Date	datetime
7	Name	Name	Normal	Text	100	Name	nvarchar(200)
8	Remaining Amount	Remaining Amount	Normal	Decimal	12	Remaining Amount	decimal(38,38)
9	Payment Made	Payment Made	Normal	Boolean	4	Payment Made	tinyint
10	Date Received	Date Received	Normal	Date	4	Date Received	datetime
11	Amount Received	Amount Received	Normal	Decimal	12	Amount Received	decimal(38,38)
12	Original Remaining Amount	Original Remaining Amount	Normal	Decimal	12	Original Remaining Amount	decimal(38,38)
13	Rem. Amt. after Discount	Rem. Amt. after Discount	Normal	Decimal	12	Rem_ Amt_ after Discount	decimal(38,38)
14	Pmt. Discount Date	Pmt. Discount Date	Normal	Date	4	Pmt_ Discount Date	datetime
15	Limit Amount Received	Limit Amount Received	Normal	Boolean	4	Limit Amount Received	tinyint
16	Payment Method Code	Payment Method Code	Normal	Code	10	Payment Method Code	nvarchar(20)
	Key to join to the Payment Method table. Show/hide example query SELECT [Payment Registration Buffer].[Payment Method Code] ,[Payment Method].[Code] FROM [CRONUS UK Ltd_$Payment Registration Buffer$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Payment Registration Buffer] LEFT JOIN [CRONUS UK Ltd_$Payment Method$437dbf0e-84ff-417a-965d-ed2bb9650972$ext] AS [Payment Method] ON [Payment Registration Buffer].[Payment Method Code] = [Payment Method].[Code]
17	Bal. Account Type	Bal. Account Type	Normal	Option	4	Bal_ Account Type	int
	Available options are: “G/L Account” “Bank Account”
18	Bal. Account No.	Bal. Account No.	Normal	Code	20	Bal_ Account No_	nvarchar(40)
19	External Document No.	External Document No.	Normal	Code	35	External Document No_	nvarchar(70)
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 Registration Buffer].[$systemCreatedBy] ,[User].[User Security ID] FROM [CRONUS UK Ltd_$Payment Registration Buffer$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Payment Registration Buffer] LEFT JOIN [User] AS [User] ON [Payment Registration Buffer].[$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 Registration Buffer table

Payment Method Sales Header Sales Header Archive

Dynamics 365 BC Table Reference Tables Company Tables PPayment Registration Buffer

Leave a Reply Cancel reply